pgBadger-
Global information
- Generated on Wed Jun 24 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 47,751 log entries in 8s
- Log start from 2026-06-24 00:00:23 to 2026-06-24 23:50:02
-
Overview
Global Stats
- 385 Number of unique normalized queries
- 6,845 Number of queries
- 9h24m6s Total query duration
- 2026-06-24 00:02:19 First query
- 2026-06-24 23:49:46 Last query
- 5 queries/s at 2026-06-24 09:00:41 Query peak
- 9h24m6s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h24m6s Execute total duration
- 4,517 Number of events
- 19 Number of unique normalized events
- 4,337 Max number of times the same event was reported
- 0 Number of cancellation
- 569 Total number of automatic vacuums
- 1,166 Total number of automatic analyzes
- 37 Number temporary file
- 231.71 MiB Max size of temporary file
- 105.01 MiB Average size of temporary file
- 362 Total number of sessions
- 8 sessions at 2026-06-24 22:05:01 Session peak
- 13d12h6m2s Total duration of sessions
- 53m43s Average duration of sessions
- 18 Average queries per session
- 1m33s Average queries duration per session
- 52m9s Average idle time per session
- 368 Total number of connections
- 5 connections/s at 2026-06-24 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-24 09:00:41 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-24 10:16:46 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-24 23:49:33 Date
Queries duration
Key values
- 9h24m6s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 24 00 22 0ms 18s272ms 4s924ms 2s632ms 4s730ms 1m11s 01 27 0ms 2s584ms 838ms 2s442ms 3s13ms 4s311ms 02 12 0ms 2s343ms 1s681ms 2s82ms 4s87ms 4s327ms 03 27 0ms 2s612ms 874ms 2s396ms 3s752ms 4s455ms 04 21 0ms 2s709ms 1s154ms 2s620ms 3s516ms 5s108ms 05 33 0ms 8m3s 29s345ms 3s935ms 2m13s 8m3s 06 30 0ms 17s592ms 3s283ms 3s359ms 19s317ms 29s3ms 07 507 150ms 8m10s 5s85ms 1m29s 4m45s 8m12s 08 784 150ms 9m11s 3s535ms 1m30s 5m15s 9m42s 09 799 150ms 8m41s 4s127ms 1m51s 5m37s 9m3s 10 774 150ms 9m5s 4s169ms 1m37s 6m32s 10m4s 11 680 150ms 9m9s 4s272ms 1m24s 5m43s 9m10s 12 230 0ms 8m46s 10s514ms 1m44s 5m36s 10m23s 13 443 0ms 6m56s 2s863ms 41s333ms 58s61ms 6m56s 14 719 150ms 8m37s 3s377ms 1m16s 4m10s 8m53s 15 898 150ms 9m29s 3s884ms 1m33s 5m17s 9m52s 16 275 0ms 8m17s 5s384ms 1m1s 1m20s 8m19s 17 48 0ms 7m13s 15s327ms 3s927ms 17s100ms 7m46s 18 18 0ms 6m23s 37s145ms 3s516ms 15s736ms 6m57s 19 15 0ms 5m13s 37s753ms 3s36ms 3s670ms 5m57s 20 103 0ms 6m7s 11s199ms 58s970ms 2m3s 6m55s 21 27 0ms 5m31s 22s 3s987ms 15s456ms 5m56s 22 21 0ms 5m58s 29s729ms 5s112ms 6s468ms 6m39s 23 332 0ms 1m32s 7s147ms 1m10s 1m23s 1m56s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 24 00 4 0 4s849ms 0ms 0ms 216ms 01 15 0 273ms 163ms 204ms 436ms 02 0 0 0ms 0ms 0ms 0ms 03 13 0 252ms 151ms 232ms 312ms 04 8 0 320ms 0ms 0ms 838ms 05 14 0 302ms 0ms 277ms 776ms 06 14 0 1s763ms 0ms 239ms 1s97ms 07 369 0 5s615ms 15s330ms 1m29s 4m52s 08 554 0 4s13ms 35s732ms 1m 5m14s 09 631 0 4s562ms 46s528ms 1m49s 5m40s 10 617 0 4s560ms 44s139ms 1m25s 9m19s 11 535 0 4s575ms 43s613ms 1m21s 5m43s 12 158 0 13s97ms 7s155ms 1m2s 8m44s 13 349 0 3s203ms 9s597ms 40s722ms 3m52s 14 549 0 3s578ms 35s118ms 1m13s 5m46s 15 675 0 4s301ms 44s271ms 1m28s 6m19s 16 206 0 6s270ms 27s204ms 50s961ms 4m10s 17 37 0 19s207ms 1s375ms 1s920ms 3m23s 18 8 0 1m20s 0ms 0ms 3m29s 19 6 0 1m30s 0ms 0ms 3m5s 20 9 84 12s72ms 457ms 58s970ms 3m13s 21 15 0 37s451ms 0ms 918ms 3m5s 22 6 0 1m38s 0ms 0ms 3m9s 23 7 325 7s147ms 1m4s 1m10s 1m32s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 24 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 5 5.00 0.00% 07 0 11 11.00 0.00% 08 0 15 15.00 0.00% 09 0 15 15.00 0.00% 10 0 21 21.00 0.00% 11 0 19 19.00 0.00% 12 0 9 9.00 0.00% 13 0 14 14.00 0.00% 14 0 19 19.00 0.00% 15 0 16 16.00 0.00% 16 0 5 5.00 0.00% 17 0 2 2.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 24 00 15 0.00/s 01 9 0.00/s 02 7 0.00/s 03 16 0.00/s 04 10 0.00/s 05 10 0.00/s 06 15 0.00/s 07 18 0.01/s 08 21 0.01/s 09 21 0.01/s 10 27 0.01/s 11 23 0.01/s 12 19 0.01/s 13 19 0.01/s 14 26 0.01/s 15 25 0.01/s 16 16 0.00/s 17 12 0.00/s 18 9 0.00/s 19 9 0.00/s 20 13 0.00/s 21 12 0.00/s 22 9 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jun 24 00 3 1h1m8s 1h32s 01 14 1h1m15s 1h1m13s 02 9 1h40s 1h38s 03 14 24m 23m59s 04 9 1h2m40s 1h2m37s 05 11 56m 54m32s 06 9 58m40s 58m29s 07 16 55m9s 52m28s 08 18 55m48s 53m14s 09 24 50m36s 48m19s 10 20 52m3s 49m22s 11 25 55m53s 53m57s 12 22 53m12s 51m23s 13 17 54m29s 53m14s 14 22 48m55s 47m5s 15 26 51m27s 49m13s 16 20 58m20s 57m6s 17 16 1h22s 59m36s 18 12 1h47s 59m51s 19 10 55m 54m3s 20 11 44m57s 43m12s 21 10 1h 59m 22 13 56m23s 55m35s 23 11 47m31s 43m55s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-24 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 368 connections Total
Connections per user
Key values
- intelifix Main User
- 368 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-06-24 22:05:01 Date
Histogram of session times
Key values
- 293 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 362 sessions Total
Sessions per user
Key values
- intelifix Main User
- 362 sessions Total
Sessions per host
Key values
- [local] Main Host
- 362 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,396 buffers Checkpoint Peak
- 2026-06-24 00:19:41 Date
- 270.049 seconds Highest write time
- 0.226 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-06-24 15:29:33 Date
Checkpoints distance
Key values
- 303.71 Mo Distance Peak
- 2026-06-24 15:29:33 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 24 00 24,660 640.982s 0.019s 641.033s 01 2,588 259.719s 0.024s 259.784s 02 1,649 165.304s 0.012s 165.338s 03 2,893 290.427s 0.044s 290.523s 04 2,863 287.21s 0.04s 287.298s 05 9,784 955.025s 0.053s 955.321s 06 5,572 466.721s 0.024s 466.788s 07 51,981 2,867.868s 0.481s 2,868.522s 08 82,258 3,238.78s 0.637s 3,239.64s 09 76,843 3,238.636s 0.808s 3,239.712s 10 71,388 3,238.655s 0.781s 3,239.684s 11 56,638 3,221.562s 0.768s 3,222.563s 12 60,471 2,597.911s 0.404s 2,598.488s 13 26,254 2,378.578s 0.496s 2,379.228s 14 56,727 3,150.727s 0.665s 3,151.588s 15 82,394 3,238.728s 0.79s 3,239.78s 16 26,744 2,012.92s 0.387s 2,013.451s 17 5,033 506.22s 0.111s 506.411s 18 860 86.22s 0.016s 86.259s 19 23 2.33s 0.004s 2.339s 20 1,016 103.177s 0.018s 103.21s 21 1,306 134.688s 0.042s 134.796s 22 2,365 237.878s 0.119s 238.132s 23 621 108.748s 0.239s 109.024s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 24 00 0 0 7 523 0.002s 0.006s 01 0 0 1 603 0.003s 0.009s 02 0 0 1 375 0.003s 0.005s 03 0 0 1 705 0.003s 0.009s 04 0 0 1 709 0.003s 0.011s 05 0 0 4 757 0.010s 0.009s 06 0 0 0 79 0.003s 0.004s 07 0 0 32 4,525 0.007s 0.012s 08 0 0 51 6,939 0.011s 0.012s 09 0 0 48 8,477 0.011s 0.012s 10 0 0 42 7,623 0.011s 0.012s 11 0 0 42 7,781 0.007s 0.012s 12 0 0 36 3,648 0.017s 0.012s 13 0 0 11 5,545 0.006s 0.012s 14 0 0 31 6,879 0.006s 0.012s 15 0 0 59 8,078 0.005s 0.012s 16 0 0 22 4,227 0.007s 0.012s 17 0 0 1 1,338 0.008s 0.009s 18 0 0 1 141 0.006s 0.003s 19 0 0 0 5 0.003s 0.001s 20 0 0 1 87 0.002s 0.003s 21 0 0 0 225 0.008s 0.008s 22 0 0 1 425 0.031s 0.007s 23 0 0 3 23 0.226s 0.229s Day Hour Count Avg time (sec) Jun 24 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 24 00 20,759.50 kB 68,400.17 kB 01 1,424.22 kB 38,250.22 kB 02 1,807.60 kB 18,636.20 kB 03 1,456.30 kB 3,358.80 kB 04 1,425.09 kB 2,501.55 kB 05 7,509.22 kB 17,257.56 kB 06 3,261.50 kB 12,816.75 kB 07 42,627.92 kB 70,641.50 kB 08 70,411.42 kB 101,497.75 kB 09 64,668.92 kB 108,319.92 kB 10 57,535.50 kB 92,643.58 kB 11 57,103.67 kB 93,061.83 kB 12 49,557.25 kB 110,311.50 kB 13 14,641.17 kB 46,954.67 kB 14 43,011.00 kB 71,415.25 kB 15 80,664.25 kB 131,210.42 kB 16 29,679.25 kB 78,785.50 kB 17 2,744.56 kB 29,151.78 kB 18 1,023.33 kB 15,865.33 kB 19 169.00 kB 12,860.00 kB 20 6,716.67 kB 14,455.00 kB 21 796.43 kB 9,057.00 kB 22 1,880.71 kB 5,063.29 kB 23 14,089.25 kB 27,613.50 kB -
Temporary Files
Size of temporary files
Key values
- 463.42 MiB Temp Files size Peak
- 2026-06-24 05:31:58 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-24 05:31:58 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.05 GiB 107.75 MiB 06 0 0 0 07 2 208.00 MiB 104.00 MiB 08 4 416.00 MiB 104.00 MiB 09 3 312.00 MiB 104.00 MiB 10 4 416.00 MiB 104.00 MiB 11 3 312.00 MiB 104.00 MiB 12 2 208.00 MiB 104.00 MiB 13 0 0 0 14 2 208.00 MiB 104.00 MiB 15 5 520.00 MiB 104.00 MiB 16 2 208.00 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 27 2.74 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-24 10:47:21 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026099, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 15:30:13 Duration: 5m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026092, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 14:46:02 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 8 900.18 MiB 69.11 MiB 231.71 MiB 112.52 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-24 05:32:06 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-24 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 177.31 MiB 88.66 MiB 88.66 MiB 88.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-24 05:30:41 Duration: 38s710ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-24 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 231.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-24 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 231.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-24 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 15:58:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 08:05:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 14:44:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 08:19:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 09:04:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 11:18:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 12:13:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 15:38:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-24 15:52:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 15:29:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 12:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 11:29:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 10:53:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 11:37:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 09:52:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 09:39:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 16:08:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,304,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-24 14:03:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.73 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database brasilia - 2026-06-24 09:52:07 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 0.73 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database brasilia - 2026-06-24 09:52:07 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (120) Main table analyzed (database rio)
- 1,166 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 120 rio.pg_catalog.pg_class 63 contagem.pg_catalog.pg_attribute 56 rio.pg_catalog.pg_type 54 rio.public.usuarios 48 rio.public.temp0000283438 44 brasilia.pg_catalog.pg_attribute 40 contagem.pg_catalog.pg_class 40 rio.pg_catalog.pg_index 37 rio.public.temp0000283460 34 contagem.pg_catalog.pg_type 32 rio.pg_catalog.pg_depend 29 brasilia.public.temp0000234536 27 rio.public.temp0000283420 27 contagem.public.temp0000226464 25 brasilia.public.temp0000234490 24 contagem.public.temp0000226484 22 contagem.pg_catalog.pg_index 20 rio.public.temp0000283500 20 contagem.public.usuarios 19 brasilia.pg_catalog.pg_class 19 rio.public.temp0000283440 18 brasilia.pg_catalog.pg_type 17 rio.public.temp0000283428 16 contagem.pg_catalog.pg_depend 16 rio.public.temp0000283414 13 brasilia.public.temp0000234538 13 rio.public.temp0000283178 13 rio.public.temp0000283290 12 rio.public.temp0000283448 12 rio.public.temp0000283102 11 brasilia.pg_catalog.pg_index 10 rio.public.temp0000283434 10 brasilia.public.usuarios 8 rio.public.temp0000283492 8 contagem.public.temp0000226462 8 brasilia.pg_catalog.pg_depend 8 rio.public.temp0000283424 8 contagem.public.temp0000226482 7 rio.public.temp0000283204 7 rio.public.temp0000283518 6 rio.public.temp0000283450 6 rio.public.temp0000283480 6 brasilia.auditor.auditor_2026_06 6 rio.public.temp0000283524 6 rio.public.temp0000283412 5 contagem.pg_catalog.pg_shdepend 5 rio.public.temp0000283454 5 brasilia.pg_catalog.pg_shdepend 4 brasilia.public.temp0000234470 4 rio.public.tmp_drill_0302 4 rio.public.temp0000283490 4 contagem.public.nf_entrada 4 brasilia.public.temp0000234478 4 rio.public.temp0000283456 3 rio.public.temp0000283426 3 contagem.public.temp0000226470 3 brasilia.public.temp0000234484 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000283436 3 rio.public.temp0000283502 3 brasilia.public.temp0000234534 3 rio.public.temp0000283498 3 rio.public.temp0000283390 3 rio.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000234554 2 rio.public.temp0000283446 2 brasilia.public.temp0000234522 2 brasilia.public.temp0000234464 2 rio.public.temp0000283522 2 rio.public.temp0000283494 2 brasilia.public.temp0000234492 2 brasilia.public.temp0000234564 2 brasilia.public.nf_entrada 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000283504 2 brasilia.public.temp0000234560 2 brasilia.public.temp0000234546 1 brasilia.public.temp0000234486 1 rio.public.temp0000283306 1 brasilia.public.temp0000234570 1 rio.public.temp0000283422 1 brasilia.public.temp0000234458 1 brasilia.public.temp0000234512 1 brasilia.public.temp0000234524 1 brasilia.public.temp0000234528 1 rio.public.temp0000283444 1 brasilia.public.temp0000234580 1 brasilia.public.temp0000234542 1 rio.public.temp0000283462 1 brasilia.public.temp0000234578 1 contagem.public.parametros 1 brasilia.public.temp0000234462 1 brasilia.public.temp0000234576 1 brasilia.public.temp0000234466 1 rio.public.temp0000283476 1 rio.public.temp0000283430 1 brasilia.public.temp0000234568 1 rio.public.temp0000283510 1 Total 1,166 Vacuums per table
Key values
- pg_catalog.pg_attribute (64) Main table vacuumed on database rio
- 569 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 64 46 0 0 0 0 0 24,944 7,086 10,121,823 390 9,661 rio.pg_catalog.pg_class 49 29 0 0 0 0 0 5,685 1,812 2,581,737 76 291 rio.public.temp0000283438 47 0 0 0 0 0 0 33,662 1,896 4,209,630 0 0 rio.pg_catalog.pg_type 43 25 0 0 0 0 0 2,444 733 931,170 71 236 rio.public.temp0000283460 33 0 0 0 0 0 0 27,261 1,712 3,663,375 0 0 rio.pg_catalog.pg_index 24 16 0 0 0 0 0 1,152 307 267,453 48 121 contagem.pg_catalog.pg_attribute 22 22 0 0 0 0 0 11,500 2,767 4,993,421 25 582 rio.public.temp0000283500 20 0 0 0 0 0 0 19,244 1,669 3,187,025 0 0 contagem.public.temp0000226484 20 0 0 0 0 0 0 1,862 119 128,774 0 0 contagem.public.usuarios 18 0 0 0 0 0 0 98 78 40,203 1 1 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 7,461 1,735 2,761,971 75 1,976 contagem.pg_catalog.pg_class 14 14 0 0 0 0 0 2,316 597 879,896 20 56 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,151 1,464 2,259,154 73 526 contagem.pg_catalog.pg_type 12 12 0 0 0 0 0 1,184 339 500,700 13 28 rio.public.temp0000283178 11 0 0 0 0 0 0 881 183 268,413 0 0 rio.public.temp0000283102 11 0 0 0 0 0 0 1,199 94 129,372 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,524 2,148 9,385,034 1,114 4,314 rio.public.tmp_drill_0302 8 3 0 0 0 0 0 210 77 107,124 1 9 rio.public.tmp_drill_0175 8 3 0 0 0 0 0 1,224 42 245,659 1 17 rio.public.temp0000283204 7 0 0 0 0 0 0 363 36 27,103 0 0 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,420 314 547,262 26 128 contagem.pg_catalog.pg_index 7 7 0 0 0 0 0 324 97 88,592 3 3 rio.public.temp0000283518 6 0 0 0 0 0 0 9,606 24 570,372 0 0 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 496 101 132,855 10 38 contagem.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,685 567 1,115,096 8 42 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 268 50 62,551 10 22 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,007 427 2,206,022 124 453 rio.public.temp0000283524 5 0 0 0 0 0 0 20 15 3,870 0 0 rio.public.usuarios 4 4 0 0 0 0 0 123 42 88,295 8 21 rio.public.temp0000283490 4 0 0 0 0 0 0 3,210 14 191,672 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,643 960 3,727,371 646 4,301 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 806 199 232,081 11 144 brasilia.auditor.auditor_2026_06 3 0 0 0 0 0 0 8,797 5,252 6,850,978 1,165 24,962 rio.public.temp0000283390 3 0 0 0 0 0 0 262 17 18,317 0 0 rio.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 315 116 208,925 15 33 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,665 404 1,596,659 264 1,943 rio.public.temp0000283446 2 0 0 0 0 0 0 16 10 2,416 0 0 rio.public.temp0000283420 2 0 0 0 0 0 0 1,687 10 101,049 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 321 42 177,110 21 41 brasilia.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 275 106 146,300 26 56 rio.public.temp0000283502 2 0 0 0 0 0 0 105 9 7,676 0 0 brasilia.public.temp0000234534 2 0 0 0 0 0 0 470 12 29,994 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 274 76 248,804 17 25 brasilia.public.temp0000234560 2 0 0 0 0 0 0 472 12 30,282 0 0 rio.public.temp0000283494 2 0 0 0 0 0 0 254 12 16,906 0 0 rio.public.temp0000283492 2 0 0 0 0 0 0 258 10 16,779 0 0 rio.public.temp0000283504 2 0 0 0 0 0 0 1,703 10 102,026 0 0 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 256 65 116,862 9 21 brasilia.public.temp0000234564 1 0 0 0 0 0 0 235 6 15,000 0 0 rio.public.temp0000283440 1 0 0 0 0 0 0 1,600 4 95,003 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 149 123 416,399 13 2,405 brasilia.public.temp0000234484 1 0 0 0 0 0 0 235 6 14,997 0 0 rio.public.temp0000283306 1 0 0 0 0 0 0 4 3 774 0 0 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 139 50 65,596 2 6 brasilia.public.temp0000234512 1 0 0 0 0 0 0 235 6 14,997 0 0 brasilia.public.temp0000234524 1 0 0 0 0 0 0 235 6 14,997 0 0 brasilia.public.temp0000234528 1 0 0 0 0 0 0 235 6 14,997 0 0 rio.public.temp0000283476 1 0 0 0 0 0 0 109 6 7,374 0 0 brasilia.public.temp0000234576 1 0 0 0 0 0 0 235 6 14,991 0 0 rio.public.temp0000283422 1 0 0 0 0 0 0 86 6 5,987 0 0 rio.public.temp0000283436 1 0 0 0 0 0 0 86 6 5,987 0 0 rio.public.temp0000283522 1 0 0 0 0 0 0 8 5 1,343 0 0 brasilia.public.temp0000234464 1 0 0 0 0 0 0 235 6 14,997 0 0 rio.public.temp0000283498 1 0 0 0 0 0 0 101 6 6,902 0 0 rio.public.temp0000283450 1 0 0 0 0 0 0 8 5 1,305 0 0 brasilia.public.temp0000234580 1 0 0 0 0 0 0 235 6 14,993 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 61 41 116,977 5 11 brasilia.public.temp0000234578 1 0 0 0 0 0 0 235 6 14,991 0 0 brasilia.public.temp0000234568 1 0 0 0 0 0 0 235 6 14,993 0 0 rio.public.temp0000283424 1 0 0 0 0 0 0 86 6 5,987 0 0 rio.public.temp0000283462 1 0 0 0 0 0 0 90 6 6,228 0 0 brasilia.public.nf_entrada_itens 1 0 0 0 0 0 0 25 25 31,632 9 242 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 208 89 270,543 27 1,484 Total 569 268 0 0 0 0 0 205,213 34,308 66,514,149 4,327 54,199 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (4.18) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.18 rio.pg_catalog.pg_class 0 0 0.86 rio.public.temp0000283438 0 0 1.64 rio.pg_catalog.pg_type 0 0 0.45 rio.public.temp0000283460 0 0 1.59 rio.pg_catalog.pg_index 0 0 0.27 contagem.pg_catalog.pg_attribute 0 0 1.55 rio.public.temp0000283500 0 0 1.34 contagem.public.temp0000226484 0 0 0.35 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 1.19 contagem.pg_catalog.pg_class 0 0 0.5 rio.pg_catalog.pg_depend 0 0 1.03 contagem.pg_catalog.pg_type 0 0 0.32 rio.public.temp0000283178 0 0 0.21 rio.public.temp0000283102 0 0 0.19 rio.pg_catalog.pg_statistic 0 0 1.29 rio.public.tmp_drill_0302 0 0 0.03 rio.public.tmp_drill_0175 0 0 0.06 rio.public.temp0000283204 0 0 0.08 brasilia.pg_catalog.pg_class 0 0 0.47 contagem.pg_catalog.pg_index 0 0 0.24 rio.public.temp0000283518 0 0 0.3 brasilia.pg_catalog.pg_type 0 0 0.22 contagem.pg_catalog.pg_depend 0 0 0.34 brasilia.pg_catalog.pg_index 0 0 0.06 rio.pg_toast.pg_toast_2619 0 0 0.23 rio.public.temp0000283524 0 0 0.24 rio.public.usuarios 0 0 0.01 rio.public.temp0000283490 0 0 0.19 brasilia.pg_catalog.pg_statistic 0 0 0.41 brasilia.pg_catalog.pg_depend 0 0 0.21 brasilia.auditor.auditor_2026_06 0 0 1.83 rio.public.temp0000283390 0 0 0.07 rio.pg_catalog.pg_shdepend 0 0 0.14 contagem.pg_catalog.pg_statistic 0 0 0.26 rio.public.temp0000283446 0 0 0.02 rio.public.temp0000283420 0 0 0.07 contagem.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_catalog.pg_shdepend 0 0 0.13 rio.public.temp0000283502 0 0 0.06 brasilia.public.temp0000234534 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.01 brasilia.public.temp0000234560 0 0 0.06 rio.public.temp0000283494 0 0 0.04 rio.public.temp0000283492 0 0 0.02 rio.public.temp0000283504 0 0 0.06 contagem.pg_catalog.pg_shdepend 0 0 0.13 brasilia.public.temp0000234564 0 0 0.02 rio.public.temp0000283440 0 0 0.04 rio.public.equipamentos_referencia 0 0 0.05 brasilia.public.temp0000234484 0 0 0.03 rio.public.temp0000283306 0 0 0.05 postgres.pg_catalog.pg_shdepend 0 0 0.04 brasilia.public.temp0000234512 0 0 0.02 brasilia.public.temp0000234524 0 0 0.02 brasilia.public.temp0000234528 0 0 0.02 rio.public.temp0000283476 0 0 0.03 brasilia.public.temp0000234576 0 0 0.02 rio.public.temp0000283422 0 0 0.01 rio.public.temp0000283436 0 0 0.01 rio.public.temp0000283522 0 0 0.01 brasilia.public.temp0000234464 0 0 0.03 rio.public.temp0000283498 0 0 0.01 rio.public.temp0000283450 0 0 0.01 brasilia.public.temp0000234580 0 0 0.03 contagem.public.nf_entrada 0 0 0.03 brasilia.public.temp0000234578 0 0 0.02 brasilia.public.temp0000234568 0 0 0.02 rio.public.temp0000283424 0 0 0.02 rio.public.temp0000283462 0 0 0.02 brasilia.public.nf_entrada_itens 0 0 0.03 brasilia.public.nf_entrada_arquivo_erros 0 0 0.03 Total 0 0 23.64 Tuples removed per table
Key values
- pg_catalog.pg_attribute (191271) Main table with removed tuples on database rio
- 442290 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 64 46 191,271 1,685,531 230,451 589 40,645 contagem.pg_catalog.pg_attribute 22 22 75,893 511,631 69 77 11,847 brasilia.pg_catalog.pg_attribute 14 14 65,476 311,823 0 311 8,467 rio.public.tmp_drill_0175 8 3 17,779 24,707 3,300 0 547 rio.pg_catalog.pg_statistic 8 8 14,371 65,816 259 0 10,288 rio.pg_catalog.pg_depend 13 13 13,320 254,707 6,194 12 2,340 rio.pg_catalog.pg_type 43 25 9,475 115,911 18,328 31 3,202 brasilia.pg_catalog.pg_statistic 4 4 8,148 30,904 0 0 4,280 contagem.pg_catalog.pg_statistic 3 3 6,760 22,805 0 0 3,033 rio.pg_catalog.pg_index 24 16 4,839 51,178 5,173 0 1,488 rio.pg_catalog.pg_class 49 29 4,155 220,448 47,839 33 6,601 contagem.pg_catalog.pg_depend 6 6 3,822 114,586 13 11 1,016 brasilia.pg_catalog.pg_class 7 7 3,521 26,657 0 7 994 brasilia.pg_catalog.pg_type 6 6 3,014 10,039 28 12 440 contagem.pg_catalog.pg_type 12 12 2,818 26,990 0 5 802 contagem.pg_catalog.pg_class 14 14 2,676 46,523 55 16 1,640 contagem.pg_catalog.pg_shdepend 2 2 2,138 25,129 17 0 240 brasilia.pg_catalog.pg_shdepend 2 2 1,808 24,762 0 0 240 brasilia.pg_catalog.pg_index 5 5 1,755 9,385 0 3 268 rio.public.tmp_drill_0302 8 3 1,643 34,626 15,993 0 482 rio.pg_toast.pg_toast_2619 5 5 1,306 2,643 8 0 1,415 contagem.pg_catalog.pg_index 7 7 1,232 13,286 3 10 347 contagem.public.usuarios 18 0 1,112 414 0 0 36 rio.pg_catalog.pg_shdepend 3 3 1,080 38,902 955 0 342 brasilia.pg_catalog.pg_depend 3 3 660 51,339 0 19 506 brasilia.auditor.auditor_2026_06 3 0 646 796,384 0 0 35,191 postgres.pg_catalog.pg_shdepend 1 1 350 13,257 458 0 111 rio.public.usuarios 4 4 290 2,322 294 0 68 contagem.public.nf_entrada 1 1 219 1,481 0 0 69 contagem.pg_toast.pg_toast_2619 2 2 216 220 0 0 124 brasilia.pg_toast.pg_toast_2619 2 2 212 280 0 0 140 brasilia.public.nf_entrada_itens 1 0 211 1,611,888 0 0 16,792 brasilia.public.nf_entrada_arquivo_erros 1 0 74 1,630,441 0 0 29,123 brasilia.public.temp0000234564 1 0 0 3,031 0 29 227 rio.public.temp0000283440 1 0 0 22,506 0 0 1,600 rio.public.temp0000283446 2 0 0 3,050 0 60 68 rio.public.temp0000283500 20 0 0 450,357 0 0 32,000 rio.public.equipamentos_referencia 1 0 0 5,104,172 0 0 27,591 rio.public.temp0000283518 6 0 0 135,085 0 0 9,600 brasilia.public.temp0000234484 1 0 0 3,029 0 29 227 rio.public.temp0000283420 2 0 0 24,114 0 50 1,678 rio.public.temp0000283306 1 0 0 22,510 0 0 1,600 rio.public.temp0000283460 33 0 0 742,459 0 0 52,800 rio.public.temp0000283502 2 0 0 24,444 0 35 1,693 rio.public.temp0000283178 11 0 0 48,694 0 317 1,091 brasilia.public.temp0000234512 1 0 0 3,029 0 29 227 brasilia.public.temp0000234524 1 0 0 3,029 0 29 227 brasilia.public.temp0000234534 2 0 0 6,058 0 58 454 brasilia.public.temp0000234528 1 0 0 3,029 0 29 227 rio.public.temp0000283490 4 0 0 90,062 0 0 6,400 rio.public.temp0000283476 1 0 0 4,511 0 27 101 rio.public.temp0000283204 7 0 0 25,302 0 139 565 brasilia.public.temp0000234576 1 0 0 3,032 0 29 227 rio.public.temp0000283422 1 0 0 1,602 0 50 78 rio.public.temp0000283436 1 0 0 1,602 0 50 78 rio.public.temp0000283522 1 0 0 1,984 0 31 97 brasilia.public.temp0000234560 2 0 0 6,060 0 58 454 rio.public.temp0000283494 2 0 0 10,665 0 18 238 rio.public.temp0000283492 2 0 0 11,009 0 9 247 brasilia.public.temp0000234464 1 0 0 3,029 0 29 227 rio.public.temp0000283102 11 0 0 54,301 0 415 1,217 rio.public.temp0000283498 1 0 0 1,927 0 35 93 contagem.public.temp0000226484 20 0 0 23,336 0 777 1,783 rio.public.temp0000283450 1 0 0 1,602 0 50 78 rio.public.temp0000283438 47 0 0 620,520 0 964 43,324 rio.public.temp0000283504 2 0 0 24,439 0 34 1,694 rio.public.temp0000283390 3 0 0 17,098 0 66 382 brasilia.public.temp0000234580 1 0 0 3,032 0 29 227 brasilia.public.temp0000234578 1 0 0 3,032 0 29 227 rio.public.temp0000283524 5 0 0 112,577 0 0 8,000 brasilia.public.temp0000234568 1 0 0 3,032 0 29 227 rio.public.temp0000283424 1 0 0 1,602 0 50 78 rio.public.temp0000283462 1 0 0 1,683 0 46 82 Total 569 268 442,290 15,402,650 329,437 4,765 380,558 Pages removed per table
Key values
- public.temp0000283438 (964) Main table with removed pages on database rio
- 4765 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283438 47 0 0 964 contagem.public.temp0000226484 20 0 0 777 rio.pg_catalog.pg_attribute 64 46 191271 589 rio.public.temp0000283102 11 0 0 415 rio.public.temp0000283178 11 0 0 317 brasilia.pg_catalog.pg_attribute 14 14 65476 311 rio.public.temp0000283204 7 0 0 139 contagem.pg_catalog.pg_attribute 22 22 75893 77 rio.public.temp0000283390 3 0 0 66 rio.public.temp0000283446 2 0 0 60 brasilia.public.temp0000234534 2 0 0 58 brasilia.public.temp0000234560 2 0 0 58 rio.public.temp0000283420 2 0 0 50 rio.public.temp0000283422 1 0 0 50 rio.public.temp0000283436 1 0 0 50 rio.public.temp0000283450 1 0 0 50 rio.public.temp0000283424 1 0 0 50 rio.public.temp0000283462 1 0 0 46 rio.public.temp0000283502 2 0 0 35 rio.public.temp0000283498 1 0 0 35 rio.public.temp0000283504 2 0 0 34 rio.pg_catalog.pg_class 49 29 4155 33 rio.public.temp0000283522 1 0 0 31 rio.pg_catalog.pg_type 43 25 9475 31 brasilia.public.temp0000234564 1 0 0 29 brasilia.public.temp0000234484 1 0 0 29 brasilia.public.temp0000234512 1 0 0 29 brasilia.public.temp0000234524 1 0 0 29 brasilia.public.temp0000234528 1 0 0 29 brasilia.public.temp0000234576 1 0 0 29 brasilia.public.temp0000234464 1 0 0 29 brasilia.public.temp0000234580 1 0 0 29 brasilia.public.temp0000234578 1 0 0 29 brasilia.public.temp0000234568 1 0 0 29 rio.public.temp0000283476 1 0 0 27 brasilia.pg_catalog.pg_depend 3 3 660 19 rio.public.temp0000283494 2 0 0 18 contagem.pg_catalog.pg_class 14 14 2676 16 brasilia.pg_catalog.pg_type 6 6 3014 12 rio.pg_catalog.pg_depend 13 13 13320 12 contagem.pg_catalog.pg_depend 6 6 3822 11 contagem.pg_catalog.pg_index 7 7 1232 10 rio.public.temp0000283492 2 0 0 9 brasilia.pg_catalog.pg_class 7 7 3521 7 contagem.pg_catalog.pg_type 12 12 2818 5 brasilia.pg_catalog.pg_index 5 5 1755 3 rio.public.temp0000283440 1 0 0 0 rio.pg_catalog.pg_statistic 8 8 14371 0 rio.public.usuarios 4 4 290 0 rio.public.temp0000283500 20 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 rio.public.temp0000283518 6 0 0 0 rio.public.tmp_drill_0302 8 3 1643 0 contagem.public.usuarios 18 0 1112 0 contagem.pg_toast.pg_toast_2619 2 2 216 0 brasilia.pg_catalog.pg_shdepend 2 2 1808 0 rio.public.temp0000283306 1 0 0 0 postgres.pg_catalog.pg_shdepend 1 1 350 0 rio.public.temp0000283460 33 0 0 0 rio.public.temp0000283490 4 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 212 0 brasilia.pg_catalog.pg_statistic 4 4 8148 0 rio.pg_toast.pg_toast_2619 5 5 1306 0 rio.public.tmp_drill_0175 8 3 17779 0 brasilia.auditor.auditor_2026_06 3 0 646 0 rio.pg_catalog.pg_shdepend 3 3 1080 0 contagem.public.nf_entrada 1 1 219 0 rio.public.temp0000283524 5 0 0 0 contagem.pg_catalog.pg_shdepend 2 2 2138 0 rio.pg_catalog.pg_index 24 16 4839 0 brasilia.public.nf_entrada_itens 1 0 211 0 brasilia.public.nf_entrada_arquivo_erros 1 0 74 0 contagem.pg_catalog.pg_statistic 3 3 6760 0 Total 569 268 442,290 4,765 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 24 00 1 1 01 1 3 02 0 0 03 0 6 04 0 5 05 6 4 06 3 5 07 33 88 08 105 156 09 111 167 10 47 126 11 55 121 12 21 43 13 43 104 14 41 116 15 75 161 16 21 49 17 4 8 18 0 0 19 0 0 20 0 0 21 2 3 22 0 0 23 0 0 - 0.73 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 2m47s 49s937ms 1m57s 1m23s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 07:17:08 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 14:46:02 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 00:05:20 Database: rio User: intelifix Remote: [local] Application: psql
2 2 2s1ms 1s 1s1ms 1s drop table if exists temp0000283438;-
DROP TABLE IF EXISTS temp0000283438;
Date: 2026-06-24 10:14:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000283438;
Date: 2026-06-24 08:37:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000283438;
Date: 2026-06-24 09:16:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s 1s 1s 1s drop table if exists temp0000283500;-
DROP TABLE IF EXISTS temp0000283500;
Date: 2026-06-24 15:54:59 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000283500;
Date: 2026-06-24 15:54:59 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m57s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-24 07:17:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 49s937ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-24 14:46:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000283438;[ Date: 2026-06-24 08:37:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000283438;[ Date: 2026-06-24 10:14:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s DROP TABLE IF EXISTS temp0000283500;[ Date: 2026-06-24 15:54:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,799 Total read queries
- 1,675 Total write queries
Queries by database
Key values
- rio Main database
- 4,694 Requests
- 7h17m50s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,679 Requests
User Request type Count Duration etiquetas Total 48 9s367ms select 48 9s367ms intelifix Total 6,679 9h22m24s copy to 409 47m43s ddl 1,266 53m32s others 370 37m27s select 4,633 7h3m39s lenon Total 118 1m33s select 118 1m33s Duration by user
Key values
- 9h22m24s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 48 9s367ms select 48 9s367ms intelifix Total 6,679 9h22m24s copy to 409 47m43s ddl 1,266 53m32s others 370 37m27s select 4,633 7h3m39s lenon Total 118 1m33s select 118 1m33s Queries by host
Key values
- [local] Main host
- 6,845 Requests
- 9h24m6s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,847 Requests
- 4h29m2s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-24 00:10:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,619 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 15:14:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 08:14:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 11:14:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 10:14:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 12:13:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 09:13:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 14:13:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 16:13:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 07:13:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m3s analyze verbose;[ Date: 2026-06-24 05:08:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 17:12:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 13:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 18:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 20:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-24 22:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-24 10:47:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m45s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026099, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-24 15:30:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026092, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-24 14:46:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026082, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-24 11:48:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026066, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-24 09:38:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h28m18s 350 153ms 5m53s 25s423ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 24 07 28 15m36s 33s461ms 08 26 15m19s 35s374ms 09 55 24m11s 26s386ms 10 50 22m40s 27s211ms 11 33 16m26s 29s903ms 12 12 18m45s 1m33s 13 21 56s334ms 2s682ms 14 32 9m57s 18s660ms 15 75 21m28s 17s179ms 16 18 2m55s 9s751ms [ User: intelifix - Total duration: 2h28m18s - Times executed: 350 ]
[ Application: [unknown] - Total duration: 2h28m18s - Times executed: 350 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-24 10:47:21 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026099, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 15:30:13 Duration: 5m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026092, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 14:46:02 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h10m24s 48 1s373ms 9m29s 2m43s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 24 07 3 8m46s 2m55s 08 3 9m48s 3m16s 09 3 9m16s 3m5s 10 3 9m38s 3m12s 11 3 9m46s 3m15s 12 3 9m27s 3m9s 13 3 7m14s 2m24s 14 3 9m6s 3m2s 15 3 10m10s 3m23s 16 3 8m49s 2m56s 17 3 7m34s 2m31s 18 3 6m41s 2m13s 19 3 5m31s 1m50s 20 3 6m29s 2m9s 21 3 5m48s 1m56s 22 3 6m14s 2m4s [ User: intelifix - Total duration: 2h10m24s - Times executed: 48 ]
[ Application: psql - Total duration: 2h10m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-24 15:14:31 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-24 08:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-24 11:14:11 Duration: 9m9s Database: rio User: intelifix Remote: [local] Application: psql
3 1h13m25s 48 228ms 4m53s 1m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 24 07 3 4m36s 1m32s 08 3 5m2s 1m40s 09 3 5m36s 1m52s 10 3 5m37s 1m52s 11 3 5m55s 1m58s 12 3 4m55s 1m38s 13 3 4m27s 1m29s 14 3 5m3s 1m41s 15 3 4m49s 1m36s 16 3 4m54s 1m38s 17 3 3m51s 1m17s 18 3 4m1s 1m20s 19 3 3m31s 1m10s 20 3 3m59s 1m19s 21 3 3m29s 1m9s 22 3 3m34s 1m11s [ User: intelifix - Total duration: 1h13m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-24 11:20:40 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-24 10:20:13 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-24 09:19:49 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql
4 26m10s 122 1s346ms 51s547ms 12s874ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 24 07 8 1m53s 14s197ms 08 7 58s527ms 8s361ms 09 8 2m20s 17s530ms 10 13 2m56s 13s544ms 11 20 3m31s 10s556ms 12 1 5s961ms 5s961ms 13 11 2m34s 14s65ms 14 22 4m8s 11s283ms 15 22 5m18s 14s489ms 16 10 2m23s 14s340ms [ User: intelifix - Total duration: 26m10s - Times executed: 122 ]
[ Application: [unknown] - Total duration: 26m10s - Times executed: 122 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 07:44:12 Duration: 51s547ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-24', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 15:32:08 Duration: 43s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-24', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 14:18:45 Duration: 40s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 18m53s 1,532 150ms 5s61ms 739ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 24 07 94 1m18s 831ms 08 196 2m26s 748ms 09 196 2m26s 749ms 10 197 2m44s 832ms 11 170 2m16s 804ms 12 66 34s805ms 527ms 13 80 54s869ms 685ms 14 206 2m13s 646ms 15 221 2m40s 727ms 16 79 54s61ms 684ms 17 27 23s105ms 855ms [ User: intelifix - Total duration: 18m53s - Times executed: 1532 ]
[ Application: [unknown] - Total duration: 18m53s - Times executed: 1532 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257772, 450, 'F200012098B1AF0,840112E09DA5$F200012102B8F76,840112E140D5$F200011051B3CCB,9877E70CB01A$F200012050B865A,840112C058DE$F200010330B89F0,743AEFDC7B1A$F200011112B4131,9877E77DE8DA$F200011236B13E8,8401122A0C9D$F200011208B6A75,8401120714AB$F200011015B3D48,9877E7094DBE$F200010338B188A,9877E7011A6E$F200012060B30C0,840112C24BEB$F200011236B2A2F,8401122A1659$F200011053B245A,9877E74C9E91$F200011289B3746,8401125FCE2F$F200010347B2624,9877E702EECD$F200012003B0F03,8401129581E0$F200011341B1101,84011293614C$F200012172B1648,840112ECEDFC$F200011336B4F12,8401129882DD$F20001016816EE6,743AEF5DEB81$F200012195B494E,1834AF256C8D$F200011149B3495,9877E7BC5303$F200010330E33BF,743AEFDC555E$F200012192B49F2,1834AF251576$F200011280B2F20,8401125F4C69$F200011236B5680,8401122A29C3$F200011153B1C64,9877E7BD0E5F$F200010279B5296,743AEFABD931$F200011299B9DF3,84011284EE91$F200010347B11FB,9877E702E5F8$F200011280B7066,8401125F68F5$F200011148B7456,9877E7BC30AB$F200011105B1CF4,9877E77C49DB$F200012005B34FB,840112960BFD', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 10:16:37 Duration: 5s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256570, 450, '834270939000938,241629320511,241728536074,241608698902,241673337185,241729498301,241677396268,241713368499,241715043557,241700946378,241605375053,241704260204,241704667796,241689137784,241598819812,241729516888,241646287575,241654580406,241689024160,241622537188,241729497492,241622436673,241664691213,241704666584,241659742638,241695484061,241622435663,241664813447,241637607278,241618234445,230048419809,241732173747,241646307072,241622593939,241714991532,241618233031,241679919702,241616298599,241731231321,241729500019,230043580516', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 08:00:23 Duration: 4s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257788, 304, '834110916000282,241595747682,241676475258,230040462445,241696975564,241695056768,241616816484,241616006270,241694365354,241677680921,241619750722,241667983543,241667160523,241664684646,241659526679,241696848403,241701437896,241639103250,241661489800,241594006278,241649311721,241699146988,230039679607,241664258083,241664266569,241698477495,241607734756,241730529298,241660702137,241674386165,241635414057,241638251820,241629121423,241732810914,241698374051,241726842632,241616077590', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 08:51:20 Duration: 4s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 13m43s 70 8s396ms 17s371ms 11s766ms create table temp0000283438 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 24 07 17 2m59s 10s565ms 08 9 1m48s 12s95ms 09 14 2m56s 12s575ms 10 7 1m23s 11s879ms 11 10 2m9s 12s923ms 12 13 2m26s 11s287ms [ User: intelifix - Total duration: 13m43s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 70 ]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 11:59:40 Duration: 17s371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 09:01:53 Duration: 15s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:38:47 Duration: 15s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 13m42s 3 2m13s 8m3s 4m34s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 24 05 3 13m42s 4m34s [ User: intelifix - Total duration: 13m42s - Times executed: 3 ]
[ Application: psql - Total duration: 13m42s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-24 05:08:05 Duration: 8m3s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-24 05:11:30 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-24 05:13:44 Duration: 2m13s Database: contagem User: intelifix Remote: [local] Application: psql
8 11m13s 56 9s166ms 33s740ms 12s31ms create table temp0000283460 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 24 07 2 19s924ms 9s962ms 08 15 2m59s 11s993ms 09 6 1m3s 10s649ms 10 13 2m34s 11s862ms 11 13 2m57s 13s650ms 12 7 1m18s 11s195ms [ User: intelifix - Total duration: 11m13s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m13s - Times executed: 56 ]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 11:20:16 Duration: 33s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:31:11 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:32:23 Duration: 14s569ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m37s 1,172 150ms 2s263ms 492ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 24 07 133 1m21s 612ms 08 157 1m14s 471ms 09 179 1m13s 412ms 10 152 1m8s 450ms 11 132 1m7s 512ms 12 6 4s154ms 692ms 13 110 52s666ms 478ms 14 134 1m4s 482ms 15 133 1m10s 528ms 16 36 19s964ms 554ms [ User: intelifix - Total duration: 9m37s - Times executed: 1172 ]
[ Application: [unknown] - Total duration: 9m37s - Times executed: 1172 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258103", "modelo" : "454", "itens" : "241624891313,241613415052,241644858604,241641403351,241642653136,241626967171,241613991226,241613691017,241644887900,241640188900,241614285777,241633608202,241624633858,241632694061,241643595562,241640114650,241613392929,241644714347,241624382038,241634267693,241612194462,241600742828,241640212034,241633530316,241640115155,241634168895,241613702230,241644786677,241640462339,241633548296,241599972136,241634175462,241644146884,241600515959,241626625668,241612249898,241633208992,241600301921,241640359500,241624208585,241611564748,241624931014,241612191230,241625257689,241625388083,241613715867,241625363738,241633530013", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-24 15:26:37 Duration: 2s263ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257667", "modelo" : "263", "itens" : "229897872143,229916310912,229871382038,229901360205,229874158403,229871729501,229874082335,229892210816,229896297173,229916431227,229913592936,229902920021,229908373145,229898060321,229897856181,229919816169,229902274244,229892430512,229899816372,229915844547,229910710018,229899353140,229901997797,229916162738,229898898594,229892799818,229896765760,229899821323,229915096180,229902592637,229916160314,229897268693,229912780725,229871472024,229885563040,229910467389,229912513246,229896904966,229910562427,229920828097,229901491127,229896479919,229911271621,229916300305,229908991522,229911047075,229871329507,229910796770", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-24 07:34:13 Duration: 1s894ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258095", "modelo" : "454", "itens" : "241625294057,241632982529,241600541619,241643706179,241644772737,241625365960,241643716887,241600440218,241613678893,241612791726,241613682430,241633598403,241612794453,241626542024,241632968082,241633859820,241625041631,241627224346,241624968996,241627588096,241625078503,241623634759,241626387990,241632535863,241611514463,241633613152,241642034860,241600713757,241613826282,241624185475,241643844352,241641578092,241642705666,241600384555,241633733747,241611494966,241644993140,241640092426,241633632020,241640126974,241642755974,241625138485,241614299819,241613525063,241633564359,241643794044,241643836775,241624926568", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-24 14:56:35 Duration: 1s812ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9m17s 159 150ms 2m 3s508ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 24 00 7 18s731ms 2s675ms 01 6 12s578ms 2s96ms 02 7 12s676ms 1s810ms 03 7 12s588ms 1s798ms 04 6 11s821ms 1s970ms 05 8 11s813ms 1s476ms 06 6 12s932ms 2s155ms 07 6 2m10s 21s788ms 08 7 17s305ms 2s472ms 09 7 14s973ms 2s139ms 10 8 18s296ms 2s287ms 11 8 22s243ms 2s780ms 12 8 14s687ms 1s835ms 13 6 13s430ms 2s238ms 14 7 1m5s 9s400ms 15 8 20s546ms 2s568ms 16 8 23s780ms 2s972ms 17 6 21s358ms 3s559ms 18 7 21s147ms 3s21ms 19 6 19s205ms 3s200ms 20 7 24s378ms 3s482ms 21 7 18s872ms 2s696ms 22 6 17s914ms 2s985ms [ User: intelifix - Total duration: 9m17s - Times executed: 159 ]
[ Application: psql - Total duration: 9m17s - Times executed: 159 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 07:17:08 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 14:46:02 Duration: 52s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 00:05:20 Duration: 7s787ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m46s 150 166ms 11s740ms 3s111ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 24 00 6 18s648ms 3s108ms 01 6 5s953ms 992ms 02 5 7s496ms 1s499ms 03 6 7s487ms 1s247ms 04 6 9s176ms 1s529ms 05 6 6s619ms 1s103ms 06 1 977ms 977ms 07 12 50s267ms 4s188ms 08 12 46s77ms 3s839ms 09 12 54s889ms 4s574ms 10 12 49s468ms 4s122ms 11 12 49s242ms 4s103ms 12 8 40s440ms 5s55ms 13 8 7s500ms 937ms 14 12 39s409ms 3s284ms 15 12 39s992ms 3s332ms 16 6 16s486ms 2s747ms 21 2 2s147ms 1s73ms 22 6 14s420ms 2s403ms [ User: intelifix - Total duration: 7m46s - Times executed: 150 ]
[ Application: psql - Total duration: 7m46s - Times executed: 150 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 00:05:12 Duration: 11s740ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 09:45:10 Duration: 8s948ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 09:15:10 Duration: 8s479ms Database: rio User: intelifix Remote: [local] Application: psql
12 6m16s 30 9s266ms 32s735ms 12s539ms create table temp0000283500 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 24 13 1 32s735ms 32s735ms 14 4 49s614ms 12s403ms 15 17 3m28s 12s281ms 16 8 1m25s 10s633ms [ User: intelifix - Total duration: 6m16s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m16s - Times executed: 30 ]
-
CREATE TABLE temp0000283500 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 13:38:11 Duration: 32s735ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283500 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 15:02:00 Duration: 15s208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283500 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 15:31:25 Duration: 14s688ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m54s 124 150ms 13s907ms 2s374ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 24 07 17 8s773ms 516ms 08 1 4s602ms 4s602ms 09 17 1m15s 4s416ms 10 20 1m 3s37ms 11 9 6s481ms 720ms 13 12 33s574ms 2s797ms 14 7 7s27ms 1s3ms 15 33 1m10s 2s137ms 16 8 27s651ms 3s456ms [ User: intelifix - Total duration: 4m54s - Times executed: 124 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 124 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 09:14:53 Duration: 13s907ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 13:36:11 Duration: 12s239ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 16:28:26 Duration: 12s208ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 3m31s 17 10s310ms 14s979ms 12s459ms create table temp0000283518 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 24 14 11 2m19s 12s666ms 15 6 1m12s 12s80ms [ User: intelifix - Total duration: 3m31s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m31s - Times executed: 17 ]
-
CREATE TABLE temp0000283518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 14:38:14 Duration: 14s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 14:58:09 Duration: 14s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 14:40:11 Duration: 14s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m8s 41 3s343ms 13s97ms 4s603ms create table temp0000283438 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 24 07 10 38s907ms 3s890ms 08 24 1m46s 4s442ms 09 6 37s764ms 6s294ms 10 1 5s450ms 5s450ms [ User: intelifix - Total duration: 3m8s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 41 ]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 09:41:25 Duration: 13s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 08:26:35 Duration: 5s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 09:44:18 Duration: 5s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m52s 4 4s626ms 1m23s 43s53ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 24 20 2 1m23s 41s997ms 23 2 1m28s 44s109ms [ User: intelifix - Total duration: 2m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m52s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-24 23:37:46 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-24 20:08:08 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-24 23:47:31 Duration: 4s812ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m33s 59 184ms 31s313ms 2s597ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 24 07 7 7s949ms 1s135ms 08 8 1m5s 8s156ms 09 7 12s624ms 1s803ms 10 8 6s152ms 769ms 11 8 14s249ms 1s781ms 12 6 8s499ms 1s416ms 14 5 5s841ms 1s168ms 15 8 29s300ms 3s662ms 16 2 3s357ms 1s678ms [ User: intelifix - Total duration: 2m33s - Times executed: 59 ]
[ Application: psql - Total duration: 2m33s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026056);
Date: 2026-06-24 08:20:54 Duration: 31s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026053);
Date: 2026-06-24 08:06:30 Duration: 21s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026095);
Date: 2026-06-24 15:01:52 Duration: 21s585ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m13s 28 849ms 17s814ms 4s779ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 24 08 1 17s814ms 17s814ms 09 2 13s230ms 6s615ms 10 2 11s117ms 5s558ms 11 3 22s681ms 7s560ms 12 3 10s534ms 3s511ms 13 1 5s249ms 5s249ms 14 3 18s741ms 6s247ms 15 1 12s901ms 12s901ms 16 2 8s764ms 4s382ms 17 2 2s125ms 1s62ms 18 2 2s470ms 1s235ms 19 1 1s748ms 1s748ms 20 1 1s707ms 1s707ms 21 2 2s638ms 1s319ms 22 2 2s105ms 1s52ms [ User: intelifix - Total duration: 2m13s - Times executed: 28 ]
[ Application: psql - Total duration: 2m13s - Times executed: 28 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-24 08:00:19 Duration: 17s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-24 15:40:14 Duration: 12s901ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-24 11:20:11 Duration: 10s139ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m55s 30 163ms 11s425ms 3s846ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 24 07 3 19s352ms 6s450ms 08 7 17s734ms 2s533ms 09 6 12s824ms 2s137ms 10 3 10s626ms 3s542ms 11 2 19s414ms 9s707ms 12 3 10s798ms 3s599ms 13 1 926ms 926ms 14 2 14s495ms 7s247ms 15 3 9s226ms 3s75ms [ User: intelifix - Total duration: 1m55s - Times executed: 30 ]
[ Application: psql - Total duration: 1m55s - Times executed: 30 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026076);
Date: 2026-06-24 11:03:37 Duration: 11s425ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026092);
Date: 2026-06-24 14:39:52 Duration: 10s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026047);
Date: 2026-06-24 07:11:56 Duration: 9s582ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m53s 2 20s638ms 1m32s 56s541ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 24 23 2 1m53s 56s541ms [ User: intelifix - Total duration: 1m53s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-24 23:13:57 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-24 23:48:35 Duration: 20s638ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,532 18m53s 150ms 5s61ms 739ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 24 07 94 1m18s 831ms 08 196 2m26s 748ms 09 196 2m26s 749ms 10 197 2m44s 832ms 11 170 2m16s 804ms 12 66 34s805ms 527ms 13 80 54s869ms 685ms 14 206 2m13s 646ms 15 221 2m40s 727ms 16 79 54s61ms 684ms 17 27 23s105ms 855ms [ User: intelifix - Total duration: 18m53s - Times executed: 1532 ]
[ Application: [unknown] - Total duration: 18m53s - Times executed: 1532 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257772, 450, 'F200012098B1AF0,840112E09DA5$F200012102B8F76,840112E140D5$F200011051B3CCB,9877E70CB01A$F200012050B865A,840112C058DE$F200010330B89F0,743AEFDC7B1A$F200011112B4131,9877E77DE8DA$F200011236B13E8,8401122A0C9D$F200011208B6A75,8401120714AB$F200011015B3D48,9877E7094DBE$F200010338B188A,9877E7011A6E$F200012060B30C0,840112C24BEB$F200011236B2A2F,8401122A1659$F200011053B245A,9877E74C9E91$F200011289B3746,8401125FCE2F$F200010347B2624,9877E702EECD$F200012003B0F03,8401129581E0$F200011341B1101,84011293614C$F200012172B1648,840112ECEDFC$F200011336B4F12,8401129882DD$F20001016816EE6,743AEF5DEB81$F200012195B494E,1834AF256C8D$F200011149B3495,9877E7BC5303$F200010330E33BF,743AEFDC555E$F200012192B49F2,1834AF251576$F200011280B2F20,8401125F4C69$F200011236B5680,8401122A29C3$F200011153B1C64,9877E7BD0E5F$F200010279B5296,743AEFABD931$F200011299B9DF3,84011284EE91$F200010347B11FB,9877E702E5F8$F200011280B7066,8401125F68F5$F200011148B7456,9877E7BC30AB$F200011105B1CF4,9877E77C49DB$F200012005B34FB,840112960BFD', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 10:16:37 Duration: 5s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256570, 450, '834270939000938,241629320511,241728536074,241608698902,241673337185,241729498301,241677396268,241713368499,241715043557,241700946378,241605375053,241704260204,241704667796,241689137784,241598819812,241729516888,241646287575,241654580406,241689024160,241622537188,241729497492,241622436673,241664691213,241704666584,241659742638,241695484061,241622435663,241664813447,241637607278,241618234445,230048419809,241732173747,241646307072,241622593939,241714991532,241618233031,241679919702,241616298599,241731231321,241729500019,230043580516', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 08:00:23 Duration: 4s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257788, 304, '834110916000282,241595747682,241676475258,230040462445,241696975564,241695056768,241616816484,241616006270,241694365354,241677680921,241619750722,241667983543,241667160523,241664684646,241659526679,241696848403,241701437896,241639103250,241661489800,241594006278,241649311721,241699146988,230039679607,241664258083,241664266569,241698477495,241607734756,241730529298,241660702137,241674386165,241635414057,241638251820,241629121423,241732810914,241698374051,241726842632,241616077590', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 08:51:20 Duration: 4s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,172 9m37s 150ms 2s263ms 492ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 24 07 133 1m21s 612ms 08 157 1m14s 471ms 09 179 1m13s 412ms 10 152 1m8s 450ms 11 132 1m7s 512ms 12 6 4s154ms 692ms 13 110 52s666ms 478ms 14 134 1m4s 482ms 15 133 1m10s 528ms 16 36 19s964ms 554ms [ User: intelifix - Total duration: 9m37s - Times executed: 1172 ]
[ Application: [unknown] - Total duration: 9m37s - Times executed: 1172 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258103", "modelo" : "454", "itens" : "241624891313,241613415052,241644858604,241641403351,241642653136,241626967171,241613991226,241613691017,241644887900,241640188900,241614285777,241633608202,241624633858,241632694061,241643595562,241640114650,241613392929,241644714347,241624382038,241634267693,241612194462,241600742828,241640212034,241633530316,241640115155,241634168895,241613702230,241644786677,241640462339,241633548296,241599972136,241634175462,241644146884,241600515959,241626625668,241612249898,241633208992,241600301921,241640359500,241624208585,241611564748,241624931014,241612191230,241625257689,241625388083,241613715867,241625363738,241633530013", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-24 15:26:37 Duration: 2s263ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257667", "modelo" : "263", "itens" : "229897872143,229916310912,229871382038,229901360205,229874158403,229871729501,229874082335,229892210816,229896297173,229916431227,229913592936,229902920021,229908373145,229898060321,229897856181,229919816169,229902274244,229892430512,229899816372,229915844547,229910710018,229899353140,229901997797,229916162738,229898898594,229892799818,229896765760,229899821323,229915096180,229902592637,229916160314,229897268693,229912780725,229871472024,229885563040,229910467389,229912513246,229896904966,229910562427,229920828097,229901491127,229896479919,229911271621,229916300305,229908991522,229911047075,229871329507,229910796770", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-24 07:34:13 Duration: 1s894ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258095", "modelo" : "454", "itens" : "241625294057,241632982529,241600541619,241643706179,241644772737,241625365960,241643716887,241600440218,241613678893,241612791726,241613682430,241633598403,241612794453,241626542024,241632968082,241633859820,241625041631,241627224346,241624968996,241627588096,241625078503,241623634759,241626387990,241632535863,241611514463,241633613152,241642034860,241600713757,241613826282,241624185475,241643844352,241641578092,241642705666,241600384555,241633733747,241611494966,241644993140,241640092426,241633632020,241640126974,241642755974,241625138485,241614299819,241613525063,241633564359,241643794044,241643836775,241624926568", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-24 14:56:35 Duration: 1s812ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 350 2h28m18s 153ms 5m53s 25s423ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 24 07 28 15m36s 33s461ms 08 26 15m19s 35s374ms 09 55 24m11s 26s386ms 10 50 22m40s 27s211ms 11 33 16m26s 29s903ms 12 12 18m45s 1m33s 13 21 56s334ms 2s682ms 14 32 9m57s 18s660ms 15 75 21m28s 17s179ms 16 18 2m55s 9s751ms [ User: intelifix - Total duration: 2h28m18s - Times executed: 350 ]
[ Application: [unknown] - Total duration: 2h28m18s - Times executed: 350 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-24 10:47:21 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026099, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 15:30:13 Duration: 5m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026092, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 14:46:02 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 159 9m17s 150ms 2m 3s508ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 24 00 7 18s731ms 2s675ms 01 6 12s578ms 2s96ms 02 7 12s676ms 1s810ms 03 7 12s588ms 1s798ms 04 6 11s821ms 1s970ms 05 8 11s813ms 1s476ms 06 6 12s932ms 2s155ms 07 6 2m10s 21s788ms 08 7 17s305ms 2s472ms 09 7 14s973ms 2s139ms 10 8 18s296ms 2s287ms 11 8 22s243ms 2s780ms 12 8 14s687ms 1s835ms 13 6 13s430ms 2s238ms 14 7 1m5s 9s400ms 15 8 20s546ms 2s568ms 16 8 23s780ms 2s972ms 17 6 21s358ms 3s559ms 18 7 21s147ms 3s21ms 19 6 19s205ms 3s200ms 20 7 24s378ms 3s482ms 21 7 18s872ms 2s696ms 22 6 17s914ms 2s985ms [ User: intelifix - Total duration: 9m17s - Times executed: 159 ]
[ Application: psql - Total duration: 9m17s - Times executed: 159 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 07:17:08 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 14:46:02 Duration: 52s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 00:05:20 Duration: 7s787ms Database: rio User: intelifix Remote: [local] Application: psql
5 150 7m46s 166ms 11s740ms 3s111ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 24 00 6 18s648ms 3s108ms 01 6 5s953ms 992ms 02 5 7s496ms 1s499ms 03 6 7s487ms 1s247ms 04 6 9s176ms 1s529ms 05 6 6s619ms 1s103ms 06 1 977ms 977ms 07 12 50s267ms 4s188ms 08 12 46s77ms 3s839ms 09 12 54s889ms 4s574ms 10 12 49s468ms 4s122ms 11 12 49s242ms 4s103ms 12 8 40s440ms 5s55ms 13 8 7s500ms 937ms 14 12 39s409ms 3s284ms 15 12 39s992ms 3s332ms 16 6 16s486ms 2s747ms 21 2 2s147ms 1s73ms 22 6 14s420ms 2s403ms [ User: intelifix - Total duration: 7m46s - Times executed: 150 ]
[ Application: psql - Total duration: 7m46s - Times executed: 150 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 00:05:12 Duration: 11s740ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 09:45:10 Duration: 8s948ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 09:15:10 Duration: 8s479ms Database: rio User: intelifix Remote: [local] Application: psql
6 150 24s665ms 150ms 258ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 24 01 1 150ms 150ms 05 1 163ms 163ms 07 13 2s172ms 167ms 08 26 4s232ms 162ms 09 19 3s73ms 161ms 10 30 5s5ms 166ms 11 16 2s645ms 165ms 12 9 1s491ms 165ms 13 4 671ms 167ms 14 17 2s795ms 164ms 15 12 1s929ms 160ms 16 2 333ms 166ms [ User: intelifix - Total duration: 24s665ms - Times executed: 150 ]
[ Application: [unknown] - Total duration: 24s665ms - Times executed: 150 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0287;
Date: 2026-06-24 10:12:07 Duration: 258ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-24 07:21:04 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-24 11:54:39 Duration: 204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 133 29s418ms 154ms 422ms 221ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 24 07 5 1s488ms 297ms 08 23 5s705ms 248ms 09 20 4s605ms 230ms 10 25 5s500ms 220ms 11 19 3s932ms 206ms 13 18 3s424ms 190ms 14 10 2s225ms 222ms 15 13 2s536ms 195ms [ User: intelifix - Total duration: 29s418ms - Times executed: 133 ]
[ Application: [unknown] - Total duration: 29s418ms - Times executed: 133 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-24 07:38:52 Duration: 422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"323", "usuario" :"427", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-24 08:38:29 Duration: 361ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"46", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-24 09:57:41 Duration: 345ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
8 127 24s28ms 150ms 346ms 189ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 24 01 1 220ms 220ms 05 2 498ms 249ms 06 1 239ms 239ms 07 2 319ms 159ms 08 2 429ms 214ms 09 3 500ms 166ms 10 7 1s247ms 178ms 11 13 2s526ms 194ms 12 6 1s22ms 170ms 13 4 860ms 215ms 14 21 3s820ms 181ms 15 49 9s164ms 187ms 16 16 3s177ms 198ms [ User: intelifix - Total duration: 24s28ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 24s28ms - Times executed: 127 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "409", "data-de" : "2026-06-23", "data-ate" : "2026-06-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 476 }');
Date: 2026-06-24 05:40:26 Duration: 346ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-24", "data-ate" : "2026-06-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-24 16:31:40 Duration: 330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-24", "data-ate" : "2026-06-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-24 15:38:32 Duration: 330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 124 4m54s 150ms 13s907ms 2s374ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 24 07 17 8s773ms 516ms 08 1 4s602ms 4s602ms 09 17 1m15s 4s416ms 10 20 1m 3s37ms 11 9 6s481ms 720ms 13 12 33s574ms 2s797ms 14 7 7s27ms 1s3ms 15 33 1m10s 2s137ms 16 8 27s651ms 3s456ms [ User: intelifix - Total duration: 4m54s - Times executed: 124 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 124 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 09:14:53 Duration: 13s907ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 13:36:11 Duration: 12s239ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 16:28:26 Duration: 12s208ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 122 26m10s 1s346ms 51s547ms 12s874ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 24 07 8 1m53s 14s197ms 08 7 58s527ms 8s361ms 09 8 2m20s 17s530ms 10 13 2m56s 13s544ms 11 20 3m31s 10s556ms 12 1 5s961ms 5s961ms 13 11 2m34s 14s65ms 14 22 4m8s 11s283ms 15 22 5m18s 14s489ms 16 10 2m23s 14s340ms [ User: intelifix - Total duration: 26m10s - Times executed: 122 ]
[ Application: [unknown] - Total duration: 26m10s - Times executed: 122 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 07:44:12 Duration: 51s547ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-24', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 15:32:08 Duration: 43s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-24', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 14:18:45 Duration: 40s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 117 23s972ms 150ms 390ms 204ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 24 01 11 2s365ms 215ms 03 11 2s459ms 223ms 04 4 900ms 225ms 05 7 1s890ms 270ms 07 9 1s879ms 208ms 08 10 1s845ms 184ms 09 12 2s230ms 185ms 10 15 2s995ms 199ms 11 8 1s418ms 177ms 12 10 1s894ms 189ms 14 13 2s704ms 208ms 15 7 1s387ms 198ms [ User: intelifix - Total duration: 23s972ms - Times executed: 117 ]
[ Application: [unknown] - Total duration: 23s972ms - Times executed: 117 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229756344256,229654264563,229682200006,229652743741,229650064153,229654753253,229681827892,229681126780,229680676276,229651634553,229679736981,229654457084,229653570725,229651609500,229683223450,229653389315,229681891839', NULL, NULL, 0159, 00);
Date: 2026-06-24 05:28:49 Duration: 390ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229682248999,229649937395,229651977089,229650551227,229654005267,229758065254,229652254647,229683171728,229683233653,216917183438,229652024344,229683891933,229762774659,229760545070,229653692431,229760667887,229651480016', NULL, NULL, 0159, 00);
Date: 2026-06-24 05:29:52 Duration: 380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229653740012,216917176063,229762157797,229654621321,229653898791,229759029400,229681116375,229654457993,229680016481,216917362244,229683584450,229757751027,229651285271,229761817281,216917124970,229654137681', NULL, NULL, 0159, 00);
Date: 2026-06-24 01:19:26 Duration: 363ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 113 53s602ms 284ms 824ms 474ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 24 01 1 548ms 548ms 03 1 343ms 343ms 04 2 696ms 348ms 05 2 737ms 368ms 06 4 1s489ms 372ms 07 8 3s940ms 492ms 08 8 4s5ms 500ms 09 10 5s252ms 525ms 10 13 6s222ms 478ms 11 12 6s158ms 513ms 12 6 2s158ms 359ms 13 12 5s339ms 444ms 14 13 6s545ms 503ms 15 12 5s969ms 497ms 16 4 1s980ms 495ms 17 2 896ms 448ms 21 3 1s317ms 439ms [ User: lenon - Total duration: 53s602ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 53s602ms - Times executed: 113 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-24 08:31:50 Duration: 824ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-24 15:27:41 Duration: 786ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-24 14:25:08 Duration: 780ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
13 113 47s403ms 165ms 759ms 419ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 24 07 7 2s517ms 359ms 08 10 3s839ms 383ms 09 15 5s966ms 397ms 10 18 8s96ms 449ms 11 11 4s660ms 423ms 12 7 2s940ms 420ms 13 6 2s418ms 403ms 14 12 5s713ms 476ms 15 23 9s631ms 418ms 16 4 1s619ms 404ms [ User: intelifix - Total duration: 47s403ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 47s403ms - Times executed: 113 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-24 11:17:13 Duration: 759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-24 10:22:57 Duration: 668ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-06-24 14:07:50 Duration: 644ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 104 1m1s 357ms 912ms 587ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 24 01 1 816ms 816ms 03 1 485ms 485ms 04 2 962ms 481ms 05 2 940ms 470ms 06 2 971ms 485ms 07 8 4s897ms 612ms 08 7 4s259ms 608ms 09 10 6s199ms 619ms 10 13 7s747ms 595ms 11 10 5s943ms 594ms 12 6 2s804ms 467ms 13 12 6s633ms 552ms 14 12 7s301ms 608ms 15 12 7s486ms 623ms 16 3 1s845ms 615ms 17 2 1s215ms 607ms 21 1 580ms 580ms [ User: intelifix - Total duration: 1m1s - Times executed: 104 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 104 ]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-06-24 08:31:50 Duration: 912ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 81, 1);
Date: 2026-06-24 14:25:08 Duration: 894ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-06-24 15:27:41 Duration: 875ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 97 28s296ms 155ms 3s560ms 291ms create table temp0000283440 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 24 07 32 12s273ms 383ms 08 28 8s149ms 291ms 09 13 2s619ms 201ms 10 11 2s547ms 231ms 11 9 1s916ms 212ms 12 4 788ms 197ms [ User: intelifix - Total duration: 28s296ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 28s296ms - Times executed: 97 ]
-
CREATE TABLE temp0000283440 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 07:06:42 Duration: 3s560ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283440 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 07:53:59 Duration: 427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283440 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 08:22:16 Duration: 413ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 70 13m43s 8s396ms 17s371ms 11s766ms create table temp0000283438 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 24 07 17 2m59s 10s565ms 08 9 1m48s 12s95ms 09 14 2m56s 12s575ms 10 7 1m23s 11s879ms 11 10 2m9s 12s923ms 12 13 2m26s 11s287ms [ User: intelifix - Total duration: 13m43s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 70 ]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 11:59:40 Duration: 17s371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 09:01:53 Duration: 15s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:38:47 Duration: 15s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 59 2m33s 184ms 31s313ms 2s597ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 24 07 7 7s949ms 1s135ms 08 8 1m5s 8s156ms 09 7 12s624ms 1s803ms 10 8 6s152ms 769ms 11 8 14s249ms 1s781ms 12 6 8s499ms 1s416ms 14 5 5s841ms 1s168ms 15 8 29s300ms 3s662ms 16 2 3s357ms 1s678ms [ User: intelifix - Total duration: 2m33s - Times executed: 59 ]
[ Application: psql - Total duration: 2m33s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026056);
Date: 2026-06-24 08:20:54 Duration: 31s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026053);
Date: 2026-06-24 08:06:30 Duration: 21s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026095);
Date: 2026-06-24 15:01:52 Duration: 21s585ms Database: rio User: intelifix Remote: [local] Application: psql
18 57 15s975ms 152ms 3s710ms 280ms create table temp0000283462 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 24 08 4 4s234ms 1s58ms 09 5 927ms 185ms 10 12 2s346ms 195ms 11 7 1s588ms 226ms 12 2 513ms 256ms 13 2 652ms 326ms 14 11 2s655ms 241ms 15 14 3s57ms 218ms [ User: intelifix - Total duration: 15s975ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 15s975ms - Times executed: 57 ]
-
CREATE TABLE temp0000283462 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 08:16:36 Duration: 3s710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283462 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"64739", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 13:41:45 Duration: 333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283462 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"64739", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 13:41:26 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 56 11m13s 9s166ms 33s740ms 12s31ms create table temp0000283460 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 24 07 2 19s924ms 9s962ms 08 15 2m59s 11s993ms 09 6 1m3s 10s649ms 10 13 2m34s 11s862ms 11 13 2m57s 13s650ms 12 7 1m18s 11s195ms [ User: intelifix - Total duration: 11m13s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m13s - Times executed: 56 ]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 11:20:16 Duration: 33s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:31:11 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:32:23 Duration: 14s569ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 55 19s366ms 150ms 3s701ms 352ms create table temp0000226462 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 24 08 7 3s35ms 433ms 10 3 514ms 171ms 11 19 6s962ms 366ms 13 16 2s964ms 185ms 14 6 5s227ms 871ms 16 2 313ms 156ms 17 2 349ms 174ms [ User: intelifix - Total duration: 19s366ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 19s366ms - Times executed: 55 ]
-
CREATE TABLE temp0000226462 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 11:50:06 Duration: 3s701ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226462 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 08:26:44 Duration: 2s34ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226462 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 14:19:20 Duration: 1s115ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m13s 8m3s 4m34s 3 13m42s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 24 05 3 13m42s 4m34s [ User: intelifix - Total duration: 13m42s - Times executed: 3 ]
[ Application: psql - Total duration: 13m42s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-24 05:08:05 Duration: 8m3s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-24 05:11:30 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-24 05:13:44 Duration: 2m13s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s373ms 9m29s 2m43s 48 2h10m24s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 24 07 3 8m46s 2m55s 08 3 9m48s 3m16s 09 3 9m16s 3m5s 10 3 9m38s 3m12s 11 3 9m46s 3m15s 12 3 9m27s 3m9s 13 3 7m14s 2m24s 14 3 9m6s 3m2s 15 3 10m10s 3m23s 16 3 8m49s 2m56s 17 3 7m34s 2m31s 18 3 6m41s 2m13s 19 3 5m31s 1m50s 20 3 6m29s 2m9s 21 3 5m48s 1m56s 22 3 6m14s 2m4s [ User: intelifix - Total duration: 2h10m24s - Times executed: 48 ]
[ Application: psql - Total duration: 2h10m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-24 15:14:31 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-24 08:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-24 11:14:11 Duration: 9m9s Database: rio User: intelifix Remote: [local] Application: psql
3 228ms 4m53s 1m31s 48 1h13m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 24 07 3 4m36s 1m32s 08 3 5m2s 1m40s 09 3 5m36s 1m52s 10 3 5m37s 1m52s 11 3 5m55s 1m58s 12 3 4m55s 1m38s 13 3 4m27s 1m29s 14 3 5m3s 1m41s 15 3 4m49s 1m36s 16 3 4m54s 1m38s 17 3 3m51s 1m17s 18 3 4m1s 1m20s 19 3 3m31s 1m10s 20 3 3m59s 1m19s 21 3 3m29s 1m9s 22 3 3m34s 1m11s [ User: intelifix - Total duration: 1h13m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-24 11:20:40 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-24 10:20:13 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-24 09:19:49 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql
4 20s638ms 1m32s 56s541ms 2 1m53s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 24 23 2 1m53s 56s541ms [ User: intelifix - Total duration: 1m53s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-24 23:13:57 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-24 23:48:35 Duration: 20s638ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 4s626ms 1m23s 43s53ms 4 2m52s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 24 20 2 1m23s 41s997ms 23 2 1m28s 44s109ms [ User: intelifix - Total duration: 2m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m52s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-24 23:37:46 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-24 20:08:08 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-24 23:47:31 Duration: 4s812ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 153ms 5m53s 25s423ms 350 2h28m18s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 24 07 28 15m36s 33s461ms 08 26 15m19s 35s374ms 09 55 24m11s 26s386ms 10 50 22m40s 27s211ms 11 33 16m26s 29s903ms 12 12 18m45s 1m33s 13 21 56s334ms 2s682ms 14 32 9m57s 18s660ms 15 75 21m28s 17s179ms 16 18 2m55s 9s751ms [ User: intelifix - Total duration: 2h28m18s - Times executed: 350 ]
[ Application: [unknown] - Total duration: 2h28m18s - Times executed: 350 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-24 10:47:21 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026099, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 15:30:13 Duration: 5m45s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026092, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-24 14:46:02 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 1s346ms 51s547ms 12s874ms 122 26m10s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 24 07 8 1m53s 14s197ms 08 7 58s527ms 8s361ms 09 8 2m20s 17s530ms 10 13 2m56s 13s544ms 11 20 3m31s 10s556ms 12 1 5s961ms 5s961ms 13 11 2m34s 14s65ms 14 22 4m8s 11s283ms 15 22 5m18s 14s489ms 16 10 2m23s 14s340ms [ User: intelifix - Total duration: 26m10s - Times executed: 122 ]
[ Application: [unknown] - Total duration: 26m10s - Times executed: 122 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 07:44:12 Duration: 51s547ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-24', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 15:32:08 Duration: 43s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-24', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-24 14:18:45 Duration: 40s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s266ms 32s735ms 12s539ms 30 6m16s create table temp0000283500 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 24 13 1 32s735ms 32s735ms 14 4 49s614ms 12s403ms 15 17 3m28s 12s281ms 16 8 1m25s 10s633ms [ User: intelifix - Total duration: 6m16s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m16s - Times executed: 30 ]
-
CREATE TABLE temp0000283500 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 13:38:11 Duration: 32s735ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283500 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 15:02:00 Duration: 15s208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283500 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 15:31:25 Duration: 14s688ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s310ms 14s979ms 12s459ms 17 3m31s create table temp0000283518 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 24 14 11 2m19s 12s666ms 15 6 1m12s 12s80ms [ User: intelifix - Total duration: 3m31s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m31s - Times executed: 17 ]
-
CREATE TABLE temp0000283518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 14:38:14 Duration: 14s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 14:58:09 Duration: 14s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 14:40:11 Duration: 14s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s166ms 33s740ms 12s31ms 56 11m13s create table temp0000283460 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 24 07 2 19s924ms 9s962ms 08 15 2m59s 11s993ms 09 6 1m3s 10s649ms 10 13 2m34s 11s862ms 11 13 2m57s 13s650ms 12 7 1m18s 11s195ms [ User: intelifix - Total duration: 11m13s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m13s - Times executed: 56 ]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 11:20:16 Duration: 33s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:31:11 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283460 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:32:23 Duration: 14s569ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s396ms 17s371ms 11s766ms 70 13m43s create table temp0000283438 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 24 07 17 2m59s 10s565ms 08 9 1m48s 12s95ms 09 14 2m56s 12s575ms 10 7 1m23s 11s879ms 11 10 2m9s 12s923ms 12 13 2m26s 11s287ms [ User: intelifix - Total duration: 13m43s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 70 ]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 11:59:40 Duration: 17s371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 09:01:53 Duration: 15s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-24 08:38:47 Duration: 15s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 849ms 17s814ms 4s779ms 28 2m13s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 24 08 1 17s814ms 17s814ms 09 2 13s230ms 6s615ms 10 2 11s117ms 5s558ms 11 3 22s681ms 7s560ms 12 3 10s534ms 3s511ms 13 1 5s249ms 5s249ms 14 3 18s741ms 6s247ms 15 1 12s901ms 12s901ms 16 2 8s764ms 4s382ms 17 2 2s125ms 1s62ms 18 2 2s470ms 1s235ms 19 1 1s748ms 1s748ms 20 1 1s707ms 1s707ms 21 2 2s638ms 1s319ms 22 2 2s105ms 1s52ms [ User: intelifix - Total duration: 2m13s - Times executed: 28 ]
[ Application: psql - Total duration: 2m13s - Times executed: 28 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-24 08:00:19 Duration: 17s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-24 15:40:14 Duration: 12s901ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-24 11:20:11 Duration: 10s139ms Database: rio User: intelifix Remote: [local] Application: psql
13 3s343ms 13s97ms 4s603ms 41 3m8s create table temp0000283438 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 24 07 10 38s907ms 3s890ms 08 24 1m46s 4s442ms 09 6 37s764ms 6s294ms 10 1 5s450ms 5s450ms [ User: intelifix - Total duration: 3m8s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 41 ]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 09:41:25 Duration: 13s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 08:26:35 Duration: 5s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283438 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-06-2026", "ate" :"24-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-24 09:44:18 Duration: 5s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 163ms 11s425ms 3s846ms 30 1m55s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 24 07 3 19s352ms 6s450ms 08 7 17s734ms 2s533ms 09 6 12s824ms 2s137ms 10 3 10s626ms 3s542ms 11 2 19s414ms 9s707ms 12 3 10s798ms 3s599ms 13 1 926ms 926ms 14 2 14s495ms 7s247ms 15 3 9s226ms 3s75ms [ User: intelifix - Total duration: 1m55s - Times executed: 30 ]
[ Application: psql - Total duration: 1m55s - Times executed: 30 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026076);
Date: 2026-06-24 11:03:37 Duration: 11s425ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026092);
Date: 2026-06-24 14:39:52 Duration: 10s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026047);
Date: 2026-06-24 07:11:56 Duration: 9s582ms Database: rio User: intelifix Remote: [local] Application: psql
15 150ms 2m 3s508ms 159 9m17s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 24 00 7 18s731ms 2s675ms 01 6 12s578ms 2s96ms 02 7 12s676ms 1s810ms 03 7 12s588ms 1s798ms 04 6 11s821ms 1s970ms 05 8 11s813ms 1s476ms 06 6 12s932ms 2s155ms 07 6 2m10s 21s788ms 08 7 17s305ms 2s472ms 09 7 14s973ms 2s139ms 10 8 18s296ms 2s287ms 11 8 22s243ms 2s780ms 12 8 14s687ms 1s835ms 13 6 13s430ms 2s238ms 14 7 1m5s 9s400ms 15 8 20s546ms 2s568ms 16 8 23s780ms 2s972ms 17 6 21s358ms 3s559ms 18 7 21s147ms 3s21ms 19 6 19s205ms 3s200ms 20 7 24s378ms 3s482ms 21 7 18s872ms 2s696ms 22 6 17s914ms 2s985ms [ User: intelifix - Total duration: 9m17s - Times executed: 159 ]
[ Application: psql - Total duration: 9m17s - Times executed: 159 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 07:17:08 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 14:46:02 Duration: 52s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-24 00:05:20 Duration: 7s787ms Database: rio User: intelifix Remote: [local] Application: psql
16 166ms 11s740ms 3s111ms 150 7m46s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 24 00 6 18s648ms 3s108ms 01 6 5s953ms 992ms 02 5 7s496ms 1s499ms 03 6 7s487ms 1s247ms 04 6 9s176ms 1s529ms 05 6 6s619ms 1s103ms 06 1 977ms 977ms 07 12 50s267ms 4s188ms 08 12 46s77ms 3s839ms 09 12 54s889ms 4s574ms 10 12 49s468ms 4s122ms 11 12 49s242ms 4s103ms 12 8 40s440ms 5s55ms 13 8 7s500ms 937ms 14 12 39s409ms 3s284ms 15 12 39s992ms 3s332ms 16 6 16s486ms 2s747ms 21 2 2s147ms 1s73ms 22 6 14s420ms 2s403ms [ User: intelifix - Total duration: 7m46s - Times executed: 150 ]
[ Application: psql - Total duration: 7m46s - Times executed: 150 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 00:05:12 Duration: 11s740ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 09:45:10 Duration: 8s948ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-24 09:15:10 Duration: 8s479ms Database: rio User: intelifix Remote: [local] Application: psql
17 184ms 31s313ms 2s597ms 59 2m33s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 24 07 7 7s949ms 1s135ms 08 8 1m5s 8s156ms 09 7 12s624ms 1s803ms 10 8 6s152ms 769ms 11 8 14s249ms 1s781ms 12 6 8s499ms 1s416ms 14 5 5s841ms 1s168ms 15 8 29s300ms 3s662ms 16 2 3s357ms 1s678ms [ User: intelifix - Total duration: 2m33s - Times executed: 59 ]
[ Application: psql - Total duration: 2m33s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026056);
Date: 2026-06-24 08:20:54 Duration: 31s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026053);
Date: 2026-06-24 08:06:30 Duration: 21s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026095);
Date: 2026-06-24 15:01:52 Duration: 21s585ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 13s907ms 2s374ms 124 4m54s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 24 07 17 8s773ms 516ms 08 1 4s602ms 4s602ms 09 17 1m15s 4s416ms 10 20 1m 3s37ms 11 9 6s481ms 720ms 13 12 33s574ms 2s797ms 14 7 7s27ms 1s3ms 15 33 1m10s 2s137ms 16 8 27s651ms 3s456ms [ User: intelifix - Total duration: 4m54s - Times executed: 124 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 124 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 09:14:53 Duration: 13s907ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 13:36:11 Duration: 12s239ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-24 16:28:26 Duration: 12s208ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s61ms 739ms 1,532 18m53s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 24 07 94 1m18s 831ms 08 196 2m26s 748ms 09 196 2m26s 749ms 10 197 2m44s 832ms 11 170 2m16s 804ms 12 66 34s805ms 527ms 13 80 54s869ms 685ms 14 206 2m13s 646ms 15 221 2m40s 727ms 16 79 54s61ms 684ms 17 27 23s105ms 855ms [ User: intelifix - Total duration: 18m53s - Times executed: 1532 ]
[ Application: [unknown] - Total duration: 18m53s - Times executed: 1532 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257772, 450, 'F200012098B1AF0,840112E09DA5$F200012102B8F76,840112E140D5$F200011051B3CCB,9877E70CB01A$F200012050B865A,840112C058DE$F200010330B89F0,743AEFDC7B1A$F200011112B4131,9877E77DE8DA$F200011236B13E8,8401122A0C9D$F200011208B6A75,8401120714AB$F200011015B3D48,9877E7094DBE$F200010338B188A,9877E7011A6E$F200012060B30C0,840112C24BEB$F200011236B2A2F,8401122A1659$F200011053B245A,9877E74C9E91$F200011289B3746,8401125FCE2F$F200010347B2624,9877E702EECD$F200012003B0F03,8401129581E0$F200011341B1101,84011293614C$F200012172B1648,840112ECEDFC$F200011336B4F12,8401129882DD$F20001016816EE6,743AEF5DEB81$F200012195B494E,1834AF256C8D$F200011149B3495,9877E7BC5303$F200010330E33BF,743AEFDC555E$F200012192B49F2,1834AF251576$F200011280B2F20,8401125F4C69$F200011236B5680,8401122A29C3$F200011153B1C64,9877E7BD0E5F$F200010279B5296,743AEFABD931$F200011299B9DF3,84011284EE91$F200010347B11FB,9877E702E5F8$F200011280B7066,8401125F68F5$F200011148B7456,9877E7BC30AB$F200011105B1CF4,9877E77C49DB$F200012005B34FB,840112960BFD', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 10:16:37 Duration: 5s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256570, 450, '834270939000938,241629320511,241728536074,241608698902,241673337185,241729498301,241677396268,241713368499,241715043557,241700946378,241605375053,241704260204,241704667796,241689137784,241598819812,241729516888,241646287575,241654580406,241689024160,241622537188,241729497492,241622436673,241664691213,241704666584,241659742638,241695484061,241622435663,241664813447,241637607278,241618234445,230048419809,241732173747,241646307072,241622593939,241714991532,241618233031,241679919702,241616298599,241731231321,241729500019,230043580516', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 08:00:23 Duration: 4s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257788, 304, '834110916000282,241595747682,241676475258,230040462445,241696975564,241695056768,241616816484,241616006270,241694365354,241677680921,241619750722,241667983543,241667160523,241664684646,241659526679,241696848403,241701437896,241639103250,241661489800,241594006278,241649311721,241699146988,230039679607,241664258083,241664266569,241698477495,241607734756,241730529298,241660702137,241674386165,241635414057,241638251820,241629121423,241732810914,241698374051,241726842632,241616077590', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-24 08:51:20 Duration: 4s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 357ms 912ms 587ms 104 1m1s select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 24 01 1 816ms 816ms 03 1 485ms 485ms 04 2 962ms 481ms 05 2 940ms 470ms 06 2 971ms 485ms 07 8 4s897ms 612ms 08 7 4s259ms 608ms 09 10 6s199ms 619ms 10 13 7s747ms 595ms 11 10 5s943ms 594ms 12 6 2s804ms 467ms 13 12 6s633ms 552ms 14 12 7s301ms 608ms 15 12 7s486ms 623ms 16 3 1s845ms 615ms 17 2 1s215ms 607ms 21 1 580ms 580ms [ User: intelifix - Total duration: 1m1s - Times executed: 104 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 104 ]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-06-24 08:31:50 Duration: 912ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 81, 1);
Date: 2026-06-24 14:25:08 Duration: 894ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-06-24 15:27:41 Duration: 875ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 24 15 1 0ms 0ms 18 2 0ms 0ms 20 3 0ms 0ms [ User: intelifix - Total duration: 25s228ms - Times executed: 6 ]
[ Application: psql - Total duration: 24s377ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 851ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 19,881 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 4493 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,337 Max number of times the same event was reported
- 4,517 Total events found
Rank Times reported Error 1 4,337 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 24 00 59 01 58 02 58 03 59 04 59 05 58 06 60 07 236 08 394 09 464 10 471 11 494 12 219 13 186 14 445 15 390 16 182 17 98 18 60 19 59 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN000000002A0F5A40" does not exist
- ERROR: prepared statement "_PLAN0000000029E77AD0" does not exist
- ERROR: prepared statement "_PLAN0000000029E76890" does not exist
Statement: DEALLOCATE "_PLAN000000002A0F5A40"
Date: 2026-06-24 00:00:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E77AD0"
Date: 2026-06-24 00:01:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E76890"
Date: 2026-06-24 00:02:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 24 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 1 20 1 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-24 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-24 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-24 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 24 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 2 20 2 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-24 08:00:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-24 08:20:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-24 08:40:08 Database: brasilia Application: psql User: intelifix Remote: [local]
4 34 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 24 09 2 11 3 12 8 14 12 15 9 - ERROR: trailing junk after numeric literal at or near "6C55E8E82A9A" at character 27
- ERROR: trailing junk after numeric literal at or near "6C55E8E82A9A" at character 27
- ERROR: trailing junk after numeric literal at or near "80F503377FA1" at character 27
Statement: SELECT * FROM RS_ETIQUETA(6C55E8E82A9A)
Date: 2026-06-24 09:11:44 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(6C55E8E82A9A)
Date: 2026-06-24 09:11:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(80F503377FA1)
Date: 2026-06-24 11:51:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 9 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 24 12 3 15 6 - ERROR: column "fc6fb7d77c80" does not exist at character 27
- ERROR: column "fc6fb7d77c80" does not exist at character 27
- ERROR: column "fc6fb7d77c80" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(FC6FB7D77C80)
Date: 2026-06-24 12:46:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(FC6FB7D77C80)
Date: 2026-06-24 12:46:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(FC6FB7D77C80)
Date: 2026-06-24 12:46:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 24 08 2 11 2 13 2 17 2 - ERROR: syntax error at or near "[" at character 35
- ERROR: syntax error at or near "[" at character 35
- ERROR: syntax error at or near "]" at character 33
Statement: select * from rs_caixa_qr(3142753 [)
Date: 2026-06-24 08:56:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3142753 [)
Date: 2026-06-24 08:56:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(112895])
Date: 2026-06-24 11:12:15 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
7 7 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 24 05 4 08 3 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-24 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-24 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-24 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local]
8 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 24 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-24 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
9 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 24 07 3 14 2 - LOG: process 2959919 still waiting for ShareLock on transaction 1526832 after 1000.125 ms
- LOG: process 2959919 still waiting for ShareLock on transaction 1526832 after 7934.182 ms
- LOG: process 2959919 still waiting for ShareLock on transaction 1526832 after 92342.017 ms
Detail: Process holding the lock: 2956368. Wait queue: 2959919.
Context: while updating tuple (71406,59) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-24 07:15:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2956368. Wait queue: 2959919.
Context: while updating tuple (71406,59) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-24 07:15:17 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2956368. Wait queue: 2959919.
Context: while updating tuple (71406,59) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-24 07:16:42 Database: rio Application: psql User: intelifix Remote: [local]
10 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 24 00 1 06 1 11 2 13 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-24 00:02:21 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-24 06:02:25 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-24 11:15:20 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
11 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 24 08 1 10 1 15 1 - LOG: process 3014928 still waiting for AccessExclusiveLock on relation 1524712 of database 358220 after 1000.144 ms
- LOG: process 3135396 still waiting for AccessExclusiveLock on relation 1542654 of database 358220 after 1000.118 ms
- LOG: process 3434435 still waiting for AccessExclusiveLock on relation 1575852 of database 358220 after 1000.230 ms
Detail: Process holding the lock: 3040318. Wait queue: 3014928.
Statement: DROP TABLE IF EXISTS temp0000283438;Date: 2026-06-24 08:37:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3145480. Wait queue: 3135396.
Statement: DROP TABLE IF EXISTS temp0000283438;Date: 2026-06-24 10:14:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3441632. Wait queue: 3434435.
Statement: DROP TABLE IF EXISTS temp0000283500;Date: 2026-06-24 15:54:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 24 08 1 10 1 15 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000283438"
Date: 2026-06-24 08:37:43
Context: automatic vacuum of table "rio.public.temp0000283438"
Date: 2026-06-24 10:14:44
Context: automatic vacuum of table "rio.public.temp0000283500"
Date: 2026-06-24 15:54:59
13 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 24 14 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73010785850079005081)Date: 2026-06-24 14:49:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73010785850079005081)Date: 2026-06-24 14:49:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
14 2 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 24 19 1 20 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-24 19:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-24 20:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
15 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 24 07 1 16 1 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "'226273673851'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-06-24 07:32:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('226273673851'');
Date: 2026-06-24 16:48:50 Database: contagem Application: [unknown] User: intelifix Remote: [local]
16 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 24 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-24 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
17 2 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 24 19 1 20 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-24 19:40:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-24 20:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 24 03 1 - LOG: database system was shut down at 2026-06-24 03:05:01 -03
Date: 2026-06-24 03:05:02
19 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 24 10 1 - LOG: skipping analyze of "temp0000283438" --- lock not available
Date: 2026-06-24 10:27:55