pgBadger-
Global information
- Generated on Tue Jul 14 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 52,017 log entries in 7s
- Log start from 2026-07-14 00:00:48 to 2026-07-14 23:49:48
-
Overview
Global Stats
- 439 Number of unique normalized queries
- 7,972 Number of queries
- 8h36m21s Total query duration
- 2026-07-14 00:02:09 First query
- 2026-07-14 23:47:49 Last query
- 6 queries/s at 2026-07-14 15:10:51 Query peak
- 8h36m21s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h36m21s Execute total duration
- 4,545 Number of events
- 17 Number of unique normalized events
- 4,310 Max number of times the same event was reported
- 0 Number of cancellation
- 608 Total number of automatic vacuums
- 1,314 Total number of automatic analyzes
- 16 Number temporary file
- 235.01 MiB Max size of temporary file
- 131.67 MiB Average size of temporary file
- 380 Total number of sessions
- 8 sessions at 2026-07-14 10:37:59 Session peak
- 13d23h22m39s Total duration of sessions
- 52m57s Average duration of sessions
- 20 Average queries per session
- 1m21s Average queries duration per session
- 51m35s Average idle time per session
- 387 Total number of connections
- 7 connections/s at 2026-07-14 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-14 15:10:51 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-14 10:20:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-14 23:47:38 Date
Queries duration
Key values
- 8h36m21s 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) Jul 14 00 22 0ms 18s183ms 4s499ms 3s907ms 4s681ms 1m6s 01 23 0ms 4s266ms 1s303ms 4s96ms 4s418ms 4s661ms 02 14 0ms 4s666ms 1s940ms 3s927ms 4s290ms 5s120ms 03 14 0ms 4s267ms 1s870ms 3s801ms 4s427ms 5s44ms 04 27 0ms 5s100ms 1s177ms 4s129ms 4s725ms 6s149ms 05 20 0ms 8m5s 50s907ms 5s520ms 2m15s 8m5s 06 21 0ms 9s36ms 3s39ms 3s842ms 4s591ms 31s164ms 07 225 0ms 7m26s 8s174ms 43s312ms 4m32s 7m55s 08 865 150ms 7m30s 2s760ms 59s405ms 5m6s 7m37s 09 893 150ms 8m41s 3s486ms 3m15s 5m26s 8m49s 10 880 150ms 8m39s 2s371ms 38s375ms 4m19s 10m22s 11 959 150ms 8m34s 2s431ms 53s918ms 5m36s 8m38s 12 160 0ms 7m58s 5s874ms 13s889ms 1m2s 7m58s 13 543 0ms 6m20s 2s219ms 24s409ms 1m5s 7m18s 14 767 151ms 7m32s 2s996ms 1m7s 4m13s 7m46s 15 803 150ms 9m47s 3s502ms 1m2s 5m5s 9m55s 16 855 150ms 8m34s 3s32ms 1m17s 5m16s 8m54s 17 324 0ms 8m49s 5s759ms 1m33s 4m8s 8m57s 18 22 0ms 6m15s 30s548ms 4s651ms 15s320ms 6m46s 19 21 0ms 5m27s 28s562ms 4s576ms 14s214ms 5m56s 20 115 0ms 8m5s 12s357ms 1m11s 2m7s 8m5s 21 31 0ms 5m42s 20s150ms 6s52ms 43s712ms 5m42s 22 28 0ms 5m41s 22s692ms 6s154ms 42s687ms 5m41s 23 340 0ms 1m36s 6s643ms 1m18s 1m33s 2m3s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 00 5 0 2s317ms 0ms 0ms 380ms 01 11 0 337ms 0ms 172ms 1s93ms 02 2 0 197ms 0ms 0ms 188ms 03 1 0 151ms 0ms 0ms 0ms 04 15 0 295ms 0ms 275ms 829ms 05 2 0 550ms 0ms 0ms 0ms 06 5 0 2s362ms 0ms 0ms 920ms 07 157 0 9s486ms 6s319ms 39s526ms 7m27s 08 651 0 2s837ms 11s433ms 48s657ms 5m1s 09 660 0 3s973ms 33s382ms 3m13s 5m51s 10 697 0 2s541ms 14s367ms 35s883ms 4m26s 11 823 0 2s413ms 19s81ms 29s658ms 5m35s 12 113 0 7s584ms 2s754ms 3s516ms 3m49s 13 446 0 2s405ms 9s251ms 19s10ms 3m50s 14 596 0 3s51ms 15s888ms 1m7s 5m23s 15 596 0 3s644ms 26s147ms 48s255ms 9m2s 16 598 0 3s572ms 21s866ms 1m7s 5m16s 17 207 0 7s522ms 10s529ms 58s964ms 4m47s 18 8 0 1m20s 0ms 0ms 3m35s 19 6 0 1m34s 0ms 0ms 3m17s 20 10 88 14s25ms 39s274ms 1m8s 3m33s 21 12 0 48s893ms 0ms 0ms 3m17s 22 8 0 1m14s 0ms 0ms 3m30s 23 13 326 6s661ms 1m4s 1m18s 2m3s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 14 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 Jul 14 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 16 16.00 0.00% 08 0 16 16.00 0.00% 09 0 15 15.00 0.00% 10 0 18 18.00 0.00% 11 0 20 20.00 0.00% 12 0 4 4.00 0.00% 13 0 15 15.00 0.00% 14 0 16 16.00 0.00% 15 0 13 13.00 0.00% 16 0 13 13.00 0.00% 17 0 4 4.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 1 1.00 0.00% 22 0 1 1.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Jul 14 00 17 0.00/s 01 11 0.00/s 02 10 0.00/s 03 18 0.01/s 04 10 0.00/s 05 10 0.00/s 06 15 0.00/s 07 21 0.01/s 08 23 0.01/s 09 19 0.01/s 10 26 0.01/s 11 22 0.01/s 12 14 0.00/s 13 25 0.01/s 14 25 0.01/s 15 20 0.01/s 16 22 0.01/s 17 14 0.00/s 18 10 0.00/s 19 11 0.00/s 20 12 0.00/s 21 11 0.00/s 22 11 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Jul 14 00 6 1h 59m43s 01 16 1h1m6s 1h1m4s 02 11 1h16s 1h14s 03 20 20m5s 20m3s 04 8 1h3m 1h2m56s 05 10 56m36s 54m54s 06 10 58m49s 58m42s 07 17 52m2s 50m14s 08 20 53m35s 51m36s 09 22 54m56s 52m35s 10 24 47m5s 45m38s 11 24 51m34s 49m57s 12 19 53m1s 52m11s 13 16 51m12s 49m57s 14 24 52m35s 50m59s 15 22 56m14s 54m6s 16 22 57m6s 55m8s 17 20 57m15s 55m42s 18 13 1h43s 59m51s 19 10 55m 54m 20 13 47m 45m10s 21 9 1h40s 59m30s 22 11 1h16s 59m18s 23 13 49m17s 46m23s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-14 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 387 connections Total
Connections per user
Key values
- intelifix Main User
- 387 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-14 10:37:59 Date
Histogram of session times
Key values
- 300 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 380 sessions Total
Sessions per user
Key values
- intelifix Main User
- 380 sessions Total
Sessions per host
Key values
- [local] Main Host
- 380 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 30,277 buffers Checkpoint Peak
- 2026-07-14 14:49:38 Date
- 270.005 seconds Highest write time
- 0.201 seconds Sync time
Checkpoints Wal files
Key values
- 19 files Wal files usage Peak
- 2026-07-14 14:49:38 Date
Checkpoints distance
Key values
- 598.39 Mo Distance Peak
- 2026-07-14 14:49:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 14 00 17,466 561.156s 0.035s 561.247s 01 2,176 218.783s 0.056s 218.905s 02 330 33.458s 0.025s 33.528s 03 286 28.985s 0.033s 29.081s 04 1,471 148.627s 0.048s 148.742s 05 7,388 740.021s 0.071s 740.158s 06 5,314 409.959s 0.026s 410.027s 07 40,972 2,597.235s 0.246s 2,597.623s 08 79,367 3,238.598s 0.829s 3,239.682s 09 77,850 3,232.633s 0.86s 3,233.764s 10 79,747 3,238.553s 0.779s 3,239.621s 11 65,315 3,238.837s 0.592s 3,239.637s 12 26,271 2,336.285s 0.182s 2,336.585s 13 33,732 2,790.52s 0.575s 2,791.278s 14 101,443 3,238.402s 1.066s 3,239.774s 15 95,998 3,238.572s 0.794s 3,239.672s 16 75,646 3,238.758s 0.703s 3,239.735s 17 87,747 2,312.045s 0.441s 2,312.703s 18 2,426 248.46s 0.02s 248.51s 19 25 2.553s 0.005s 2.572s 20 1,172 377.742s 0.054s 377.844s 21 2,648 267.073s 0.029s 267.167s 22 2,283 229.496s 0.027s 229.57s 23 2,238 283.582s 0.036s 283.649s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 14 00 0 0 6 338 0.003s 0.008s 01 0 0 1 683 0.004s 0.01s 02 0 0 0 265 0.003s 0.007s 03 0 0 0 231 0.004s 0.011s 04 0 0 1 481 0.004s 0.013s 05 0 0 3 572 0.007s 0.009s 06 0 0 1 311 0.004s 0.006s 07 0 0 28 3,601 0.008s 0.012s 08 0 0 47 7,390 0.011s 0.012s 09 0 0 48 7,725 0.007s 0.012s 10 0 0 43 8,128 0.004s 0.012s 11 0 0 38 7,042 0.017s 0.012s 12 0 0 8 3,365 0.005s 0.012s 13 0 0 14 6,091 0.009s 0.012s 14 0 0 55 8,333 0.075s 0.012s 15 0 0 58 7,971 0.008s 0.012s 16 0 0 48 6,853 0.011s 0.012s 17 0 0 56 4,375 0.010s 0.012s 18 0 0 0 247 0.003s 0.005s 19 0 0 0 6 0.003s 0.003s 20 0 0 4 88 0.022s 0.003s 21 0 0 0 414 0.003s 0.007s 22 0 0 1 494 0.003s 0.007s 23 0 0 3 78 0.003s 0.004s Day Hour Count Avg time (sec) Jul 14 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 Jul 14 00 13,733.43 kB 49,780.86 kB 01 1,047.90 kB 24,192.80 kB 02 171.29 kB 10,026.14 kB 03 103.70 kB 801.60 kB 04 596.36 kB 948.09 kB 05 5,890.44 kB 13,785.33 kB 06 2,559.33 kB 9,473.00 kB 07 39,194.58 kB 74,933.08 kB 08 63,743.67 kB 104,127.17 kB 09 65,642.00 kB 103,803.17 kB 10 58,552.00 kB 102,476.50 kB 11 51,301.92 kB 99,334.33 kB 12 12,029.08 kB 53,578.25 kB 13 19,211.58 kB 36,093.00 kB 14 74,878.92 kB 113,292.67 kB 15 79,192.67 kB 184,520.83 kB 16 64,454.58 kB 118,033.58 kB 17 76,818.00 kB 156,938.25 kB 18 1,821.40 kB 87,772.00 kB 19 88.00 kB 60,346.50 kB 20 17,224.67 kB 50,814.00 kB 21 1,870.71 kB 31,434.57 kB 22 1,736.29 kB 15,944.00 kB 23 13,362.50 kB 24,735.00 kB -
Temporary Files
Size of temporary files
Key values
- 470.02 MiB Temp Files size Peak
- 2026-07-14 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-14 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.25 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 1 182.02 MiB 182.02 MiB 10 2 364.03 MiB 182.01 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 1 182.01 MiB 182.01 MiB 15 1 104.00 MiB 104.00 MiB 16 1 182.09 MiB 182.09 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 8 912.71 MiB 70.10 MiB 235.01 MiB 114.09 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-14 05:32:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-14 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 5 910.14 MiB 182.00 MiB 182.09 MiB 182.03 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01545);
Date: 2026-07-14 16:58:23 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01534);
Date: 2026-07-14 09:56:48 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01544);
Date: 2026-07-14 14:41:39 Duration: 1m48s Database: contagem User: intelifix Remote: [local] Application: psql
3 2 179.81 MiB 89.91 MiB 89.91 MiB 89.91 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-14 05:30:42 Duration: 40s144ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-14 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0265882,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-07-14 15:03:40 Duration: 9m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026998, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 09:40:19 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 11:08:54 Duration: 5m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 235.01 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 235.01 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.09 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01545);[ Date: 2026-07-14 16:58:05 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01535);[ Date: 2026-07-14 10:13:42 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01534);[ Date: 2026-07-14 09:56:43 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01544);[ Date: 2026-07-14 14:41:38 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01536);[ Date: 2026-07-14 10:20:45 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
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-07-14 15:56:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 89.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-14 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 89.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-14 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 77.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 77.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 77.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 70.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 70.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 70.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-14 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 15.90 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-14 11:10:00 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 15.90 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-14 11:10:00 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (132) Main table analyzed (database rio)
- 1,314 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 132 rio.public.temp0000285272 72 rio.pg_catalog.pg_class 71 rio.pg_catalog.pg_type 58 contagem.pg_catalog.pg_attribute 56 rio.public.usuarios 53 brasilia.pg_catalog.pg_attribute 47 rio.public.temp0000285244 46 rio.pg_catalog.pg_index 41 rio.public.temp0000285248 35 contagem.public.temp0000226610 33 contagem.pg_catalog.pg_class 32 rio.pg_catalog.pg_depend 30 contagem.pg_catalog.pg_type 29 rio.public.temp0000285336 29 contagem.public.usuarios 27 rio.public.temp0000284750 24 contagem.public.temp0000226636 22 rio.public.temp0000285220 22 brasilia.pg_catalog.pg_class 21 rio.public.temp0000285338 20 contagem.pg_catalog.pg_index 20 brasilia.pg_catalog.pg_type 18 rio.public.temp0000285240 17 contagem.pg_catalog.pg_depend 16 rio.public.temp0000285238 15 contagem.public.temp0000226628 15 rio.public.temp0000285234 14 brasilia.pg_catalog.pg_index 13 rio.public.temp0000285242 12 rio.public.temp0000285340 10 brasilia.pg_catalog.pg_depend 10 brasilia.public.usuarios 10 rio.public.temp0000285224 10 brasilia.public.temp0000236104 10 rio.public.temp0000285314 9 rio.public.temp0000284762 9 rio.public.temp0000285354 9 rio.public.temp0000285304 8 contagem.public.nf_entrada 8 rio.public.temp0000285358 8 rio.public.temp0000285316 8 rio.public.temp0000285286 8 rio.public.temp0000285246 7 contagem.public.temp0000226618 7 contagem.pg_catalog.pg_shdepend 7 brasilia.public.temp0000236014 7 brasilia.public.temp0000236108 6 rio.public.temp0000284984 6 contagem.public.temp0000226612 5 brasilia.public.temp0000236020 5 rio.public.temp0000284664 5 contagem.public.temp0000226624 4 rio.public.temp0000285362 4 postgres.pg_catalog.pg_shdepend 4 brasilia.public.nf_entrada 4 rio.public.temp0000285020 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000285352 3 rio.public.temp0000285250 3 brasilia.public.temp0000236062 3 rio.public.tmp_drill_0302 3 brasilia.public.temp0000236078 3 rio.public.temp0000285226 3 contagem.public.temp0000226622 3 rio.public.temp0000285282 3 brasilia.public.temp0000236116 2 contagem.public.temp0000226614 2 brasilia.public.temp0000236082 2 rio.public.temp0000285262 2 contagem.public.temp0000226634 2 rio.public.temp0000285256 2 rio.pg_catalog.pg_shdepend 2 contagem.public.temp0000226632 2 rio.public.tmp_drill_0175 2 brasilia.public.temp0000236022 2 brasilia.public.temp0000236076 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000285298 2 brasilia.auditor.auditor_2026_07 1 brasilia.public.temp0000236032 1 brasilia.public.temp0000236096 1 brasilia.public.temp0000236074 1 contagem.public.temp0000226626 1 rio.public.temp0000285366 1 brasilia.public.temp0000236080 1 rio.auditor.auditor_2026_07 1 rio.public.temp0000285306 1 rio.public.temp0000285360 1 rio.public.temp0000285320 1 rio.public.temp0000285344 1 brasilia.public.temp0000236098 1 rio.public.temp0000285318 1 rio.public.temp0000285264 1 contagem.auditor.auditor_2026_07 1 brasilia.public.temp0000236038 1 brasilia.public.temp0000236046 1 brasilia.public.temp0000236110 1 rio.public.nf_entrada_arquivos_notas 1 rio.public.temp0000285346 1 brasilia.public.temp0000236026 1 brasilia.public.temp0000236056 1 rio.public.temp0000285322 1 brasilia.public.temp0000236068 1 rio.public.temp0000285334 1 rio.public.temp0000285296 1 contagem.public.temp0000226638 1 rio.public.temp0000285312 1 brasilia.public.temp0000236070 1 Total 1,314 Vacuums per table
Key values
- public.temp0000285272 (56) Main table vacuumed on database rio
- 608 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000285272 56 0 0 0 0 0 0 2,855 634 761,479 0 0 rio.pg_catalog.pg_attribute 55 46 0 0 0 0 0 26,396 6,957 10,594,129 380 9,509 rio.public.temp0000285244 43 0 0 0 0 0 0 34,102 3,499 6,266,311 0 0 rio.pg_catalog.pg_class 36 30 0 0 0 0 0 5,378 1,647 2,413,287 103 391 rio.pg_catalog.pg_type 29 23 0 0 0 0 0 2,444 772 1,106,850 102 289 contagem.public.usuarios 26 0 0 0 0 0 0 123 89 48,970 0 0 contagem.pg_catalog.pg_attribute 24 24 0 0 0 0 0 14,369 2,452 4,993,352 51 1,425 rio.pg_catalog.pg_index 21 17 0 0 0 0 0 1,071 290 284,181 53 114 rio.public.temp0000285338 20 0 0 0 0 0 0 7,126 96 437,046 0 0 rio.public.temp0000285220 20 0 0 0 0 0 0 24,809 78 1,475,782 0 0 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 8,676 2,221 3,548,994 90 2,495 rio.public.temp0000284750 15 0 0 0 0 0 0 848 85 61,936 0 0 rio.public.temp0000285336 14 0 0 0 0 0 0 4,188 72 258,407 0 0 contagem.pg_catalog.pg_class 13 13 0 0 0 0 0 2,667 348 612,991 13 40 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 3,703 1,392 1,842,111 71 650 contagem.pg_catalog.pg_type 12 12 0 0 0 0 0 1,281 260 445,322 8 18 rio.public.usuarios 11 6 0 0 0 0 0 189 62 120,410 9 20 rio.pg_catalog.pg_statistic 11 11 0 0 0 0 0 13,931 3,374 15,305,850 1,317 4,818 rio.public.temp0000285340 10 0 0 0 0 0 0 9,920 36 591,050 0 0 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 1,034 292 424,666 23 218 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 440 113 125,303 7 15 rio.public.temp0000284762 8 0 0 0 0 0 0 793 47 54,068 0 0 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,995 499 815,511 43 256 contagem.public.temp0000226618 7 0 0 0 0 0 0 667 139 209,330 0 0 contagem.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,013 522 1,053,708 12 84 rio.public.temp0000285358 7 0 0 0 0 0 0 11,557 28 686,084 0 0 rio.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 1,073 337 683,494 36 80 rio.public.tmp_drill_0175 5 2 0 0 0 0 0 99 6 21,872 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 344 80 73,909 12 20 rio.public.temp0000284984 5 0 0 0 0 0 0 553 28 37,592 0 0 contagem.public.temp0000226636 5 0 0 0 0 0 0 426 29 29,799 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,098 437 2,444,860 115 370 rio.public.temp0000284664 4 0 0 0 0 0 0 682 24 44,360 0 0 contagem.public.temp0000226624 4 0 0 0 0 0 0 224 22 16,830 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,413 378 585,660 5 59 rio.public.tmp_drill_0302 4 3 0 0 0 0 0 1,871 9 338,535 0 0 template1.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 537 199 447,197 35 129 rio.public.temp0000285286 3 0 0 0 0 0 0 1,775 16 107,057 0 0 rio.public.temp0000285020 3 0 0 0 0 0 0 209 17 15,067 0 0 rio.public.temp0000285362 3 0 0 0 0 0 0 4,953 12 294,036 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,969 710 2,872,386 419 2,970 contagem.public.temp0000226622 3 0 0 0 0 0 0 220 113 176,816 0 0 contagem.public.nf_entrada 3 3 0 0 0 0 0 191 43 97,294 4 6 rio.public.temp0000285316 3 0 0 0 0 0 0 70 12 6,069 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,687 462 1,859,430 317 2,263 contagem.public.temp0000226612 2 0 0 0 0 0 0 149 12 10,567 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 262 36 149,551 14 20 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 309 73 242,936 22 45 rio.public.temp0000285352 2 0 0 0 0 0 0 8 6 1,548 0 0 brasilia.public.nf_entrada 2 2 0 0 0 0 0 372 159 346,610 18 32 rio.public.temp0000285314 2 0 0 0 0 0 0 278 12 18,361 0 0 rio.public.temp0000285312 1 0 0 0 0 0 0 62 6 4,521 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 22,000 10,439 14,229,791 5,476 124,227 rio.public.temp0000285298 1 0 0 0 0 0 0 1,649 4 97,894 0 0 rio.public.temp0000285320 1 0 0 0 0 0 0 8 5 1,254 0 0 rio.public.temp0000285360 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000285296 1 0 0 0 0 0 0 92 6 6,341 0 0 rio.public.temp0000285250 1 0 0 0 0 0 0 1,649 4 97,894 0 0 brasilia.public.temp0000236076 1 0 0 0 0 0 0 241 240 380,622 0 0 brasilia.public.lote_itens 1 1 0 0 0 0 0 19,770 16,987 70,188,805 301 12,927 rio.public.temp0000285318 1 0 0 0 0 0 0 62 6 4,521 0 0 brasilia.public.temp0000236098 1 0 0 0 0 0 0 241 6 15,359 0 0 contagem.public.temp0000226638 1 0 0 0 0 0 0 46 6 3,561 0 0 rio.public.temp0000285344 1 0 0 0 0 0 0 1,651 4 98,012 0 0 rio.public.caixa_itens_exclusao 1 1 0 0 0 0 0 1,822 1,349 6,069,380 41 4,613 rio.public.temp0000285322 1 0 0 0 0 0 0 62 6 4,521 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 238 90 285,856 43 2,320 brasilia.public.temp0000236080 1 0 0 0 0 0 0 241 6 15,359 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 87,235 47,676 61,673,466 20,038 380,861 contagem.public.temp0000226634 1 0 0 0 0 0 0 104 6 7,085 0 0 rio.public.temp0000285262 1 0 0 0 0 0 0 8 5 1,247 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 34,640 17,020 22,572,946 8,428 167,293 rio.public.temp0000285304 1 0 0 0 0 0 0 8 5 1,291 0 0 rio.public.temp0000285346 1 0 0 0 0 0 0 1,651 4 98,012 0 0 rio.public.lotes_saidas 1 1 0 0 0 0 0 1,227 992 4,106,335 27 258 contagem.public.nf_entrada_arquivos_notas 1 1 0 0 0 0 0 19 11 34,273 0 0 rio.public.nf_entrada_arquivos_notas 1 1 0 0 0 0 0 39 15 52,966 0 0 Total 608 288 0 0 0 0 0 383,116 124,137 245,511,050 37,633 718,835 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (15.9) 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.public.temp0000285272 0 0 0.75 rio.pg_catalog.pg_attribute 0 0 3.75 rio.public.temp0000285244 0 0 1.39 rio.pg_catalog.pg_class 0 0 0.93 rio.pg_catalog.pg_type 0 0 0.33 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.57 rio.pg_catalog.pg_index 0 0 0.27 rio.public.temp0000285338 0 0 0.45 rio.public.temp0000285220 0 0 0.91 brasilia.pg_catalog.pg_attribute 0 0 1.15 rio.public.temp0000284750 0 0 0.18 rio.public.temp0000285336 0 0 0.31 contagem.pg_catalog.pg_class 0 0 0.39 rio.pg_catalog.pg_depend 0 0 0.85 contagem.pg_catalog.pg_type 0 0 0.19 rio.public.usuarios 0 0 0.02 rio.pg_catalog.pg_statistic 0 0 1.92 rio.public.temp0000285340 0 0 0.84 brasilia.pg_catalog.pg_type 0 0 0.19 contagem.pg_catalog.pg_index 0 0 0.2 rio.public.temp0000284762 0 0 0.15 brasilia.pg_catalog.pg_class 0 0 0.3 contagem.public.temp0000226618 0 0 0.12 contagem.pg_catalog.pg_depend 0 0 0.29 rio.public.temp0000285358 0 0 0.4 rio.pg_catalog.pg_shdepend 0 0 0.35 rio.public.tmp_drill_0175 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0.05 rio.public.temp0000284984 0 0 0.09 contagem.public.temp0000226636 0 0 0.07 rio.pg_toast.pg_toast_2619 0 0 0.3 rio.public.temp0000284664 0 0 0.08 contagem.public.temp0000226624 0 0 0.06 brasilia.pg_catalog.pg_depend 0 0 0.28 rio.public.tmp_drill_0302 0 0 0.06 template1.pg_catalog.pg_shdepend 0 0 0.23 rio.public.temp0000285286 0 0 0.07 rio.public.temp0000285020 0 0 0.04 rio.public.temp0000285362 0 0 0.14 brasilia.pg_catalog.pg_statistic 0 0 0.45 contagem.public.temp0000226622 0 0 0.07 contagem.public.nf_entrada 0 0 0.06 rio.public.temp0000285316 0 0 0.07 contagem.pg_catalog.pg_statistic 0 0 0.29 contagem.public.temp0000226612 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000285352 0 0 0.08 brasilia.public.nf_entrada 0 0 0.07 rio.public.temp0000285314 0 0 0.04 rio.public.temp0000285312 0 0 0.02 contagem.auditor.auditor_2026_07 0 0 3.5 rio.public.temp0000285298 0 0 0.05 rio.public.temp0000285320 0 0 0.01 rio.public.temp0000285360 0 0 0.04 rio.public.temp0000285296 0 0 0.02 rio.public.temp0000285250 0 0 0.05 brasilia.public.temp0000236076 0 0 0.03 brasilia.public.lote_itens 0 0 7.34 rio.public.temp0000285318 0 0 0.02 brasilia.public.temp0000236098 0 0 0.02 contagem.public.temp0000226638 0 0 0.02 rio.public.temp0000285344 0 0 0.06 rio.public.caixa_itens_exclusao 0 0 1.47 rio.public.temp0000285322 0 0 0.02 brasilia.public.nf_entrada_arquivo_erros 0 0 0.06 brasilia.public.temp0000236080 0 0 0.01 rio.auditor.auditor_2026_07 0 0 15.9 contagem.public.temp0000226634 0 0 0.01 rio.public.temp0000285262 0 0 0.01 brasilia.auditor.auditor_2026_07 0 0 5.66 rio.public.temp0000285304 0 0 0.01 rio.public.temp0000285346 0 0 0.06 rio.public.lotes_saidas 0 0 0.55 contagem.public.nf_entrada_arquivos_notas 0 0 0.01 rio.public.nf_entrada_arquivos_notas 0 0 0 Total 0 0 55.82 Tuples removed per table
Key values
- pg_catalog.pg_attribute (200515) Main table with removed tuples on database rio
- 529528 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 55 46 200,515 1,433,442 119,828 165 34,993 contagem.pg_catalog.pg_attribute 24 24 105,923 573,736 98 315 13,370 brasilia.pg_catalog.pg_attribute 15 15 74,518 345,013 224 177 9,019 rio.public.tmp_drill_0302 4 3 28,268 29,012 372 0 720 rio.pg_catalog.pg_statistic 11 11 18,398 93,617 702 0 14,146 rio.pg_catalog.pg_depend 12 12 11,401 232,448 3,838 0 2,244 rio.pg_catalog.pg_type 29 23 8,073 74,085 7,134 8 2,141 brasilia.pg_catalog.pg_class 8 8 7,291 27,049 16 0 1,076 contagem.pg_catalog.pg_statistic 3 3 6,528 22,988 0 0 3,033 brasilia.pg_catalog.pg_statistic 3 3 6,484 24,313 0 0 3,216 rio.pg_catalog.pg_class 36 30 5,953 146,337 18,315 28 4,510 contagem.pg_catalog.pg_type 12 12 5,888 27,136 2 13 830 brasilia.pg_catalog.pg_depend 4 4 5,850 67,860 0 12 714 rio.auditor.auditor_2026_07 1 0 4,759 9,088,970 0 0 424,482 brasilia.pg_catalog.pg_type 9 9 4,466 19,927 16 36 598 rio.pg_catalog.pg_shdepend 6 6 4,387 82,000 466 0 690 rio.pg_catalog.pg_index 21 17 3,805 43,681 2,996 0 1,209 contagem.pg_catalog.pg_class 13 13 3,371 44,748 4 42 1,527 brasilia.public.nf_entrada 2 2 3,136 8,955 0 0 304 brasilia.auditor.auditor_2026_07 1 0 2,864 2,444,055 0 0 107,581 contagem.pg_catalog.pg_index 8 8 2,612 15,224 1 0 430 template1.pg_catalog.pg_shdepend 3 3 2,611 40,923 20 0 345 contagem.pg_catalog.pg_depend 7 7 2,272 124,483 6 0 1,261 brasilia.pg_catalog.pg_index 5 5 1,847 9,409 0 9 272 brasilia.public.nf_entrada_arquivo_erros 1 0 1,746 1,661,536 0 0 29,856 brasilia.public.lote_itens 1 1 1,713 1,721,926 0 0 22,833 contagem.public.usuarios 26 0 1,583 607 9 0 52 rio.pg_toast.pg_toast_2619 4 4 1,199 2,831 8 0 1,072 contagem.public.nf_entrada 3 3 657 4,579 0 0 207 rio.public.tmp_drill_0175 5 2 372 3,590 1,116 0 67 rio.public.usuarios 11 6 306 6,986 1,387 0 187 rio.public.lotes_saidas 1 1 266 87,267 2 0 1,128 brasilia.pg_toast.pg_toast_2619 2 2 206 279 0 0 132 contagem.pg_toast.pg_toast_2619 2 2 191 243 0 0 114 rio.public.caixa_itens_exclusao 1 1 58 1,300,710 0 0 10,872 contagem.public.nf_entrada_arquivos_notas 1 1 11 1,233 0 0 7 rio.public.temp0000285338 20 0 0 155,388 0 76 10,804 rio.public.temp0000285312 1 0 0 1,032 0 10 54 contagem.auditor.auditor_2026_07 1 0 0 1,532,139 0 0 63,863 contagem.public.temp0000226618 7 0 0 8,609 0 221 611 contagem.public.temp0000226612 2 0 0 2,338 0 59 133 rio.public.temp0000285358 7 0 0 162,587 0 0 11,648 rio.public.temp0000285298 1 0 0 23,200 0 0 1,664 rio.public.temp0000285286 3 0 0 25,355 0 20 1,772 rio.public.temp0000284664 4 0 0 28,670 0 118 650 rio.public.temp0000285320 1 0 0 1,032 0 10 54 rio.public.temp0000285360 1 0 0 23,227 0 0 1,664 rio.public.temp0000285244 43 0 0 553,974 0 233 39,319 rio.public.temp0000285296 1 0 0 3,760 0 44 84 rio.public.temp0000285020 3 0 0 14,506 0 120 328 rio.public.temp0000285362 3 0 0 69,683 0 0 4,992 rio.public.temp0000285250 1 0 0 23,203 0 0 1,664 rio.public.temp0000285352 2 0 0 46,446 0 0 3,328 rio.public.temp0000284984 5 0 0 36,107 0 142 818 brasilia.public.temp0000236076 1 0 0 3,107 0 23 233 rio.public.temp0000285220 20 0 0 441,763 0 14 31,666 rio.public.temp0000285318 1 0 0 1,032 0 10 54 brasilia.public.temp0000236098 1 0 0 3,108 0 23 233 contagem.public.temp0000226638 1 0 0 1,052 0 28 36 rio.public.temp0000285344 1 0 0 23,221 0 0 1,664 rio.public.temp0000285322 1 0 0 1,032 0 10 54 rio.public.temp0000284750 15 0 0 46,660 0 602 998 contagem.public.temp0000226624 4 0 0 5,019 0 128 384 contagem.public.temp0000226622 3 0 0 3,764 0 96 288 rio.public.temp0000285336 14 0 0 124,895 0 240 7,568 rio.public.temp0000285272 56 0 0 150,038 0 1,311 3,361 brasilia.public.temp0000236080 1 0 0 3,107 0 23 233 contagem.public.temp0000226634 1 0 0 1,261 0 32 96 rio.public.temp0000285262 1 0 0 1,008 0 14 50 rio.public.temp0000285340 10 0 0 232,159 0 0 16,640 contagem.public.temp0000226636 5 0 0 6,308 0 158 482 rio.public.temp0000285304 1 0 0 4,122 0 36 92 rio.public.temp0000285346 1 0 0 23,227 0 0 1,664 rio.public.temp0000284762 8 0 0 34,082 0 385 767 rio.public.temp0000285314 2 0 0 11,607 0 122 262 rio.public.temp0000285316 3 0 0 25,498 0 10 1,782 rio.public.nf_entrada_arquivos_notas 1 1 0 20,659 0 0 117 Total 608 288 529,528 23,690,183 156,560 5,123 907,412 Pages removed per table
Key values
- public.temp0000285272 (1311) Main table with removed pages on database rio
- 5123 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285272 56 0 0 1311 rio.public.temp0000284750 15 0 0 602 rio.public.temp0000284762 8 0 0 385 contagem.pg_catalog.pg_attribute 24 24 105923 315 rio.public.temp0000285336 14 0 0 240 rio.public.temp0000285244 43 0 0 233 contagem.public.temp0000226618 7 0 0 221 brasilia.pg_catalog.pg_attribute 15 15 74518 177 rio.pg_catalog.pg_attribute 55 46 200515 165 contagem.public.temp0000226636 5 0 0 158 rio.public.temp0000284984 5 0 0 142 contagem.public.temp0000226624 4 0 0 128 rio.public.temp0000285314 2 0 0 122 rio.public.temp0000285020 3 0 0 120 rio.public.temp0000284664 4 0 0 118 contagem.public.temp0000226622 3 0 0 96 rio.public.temp0000285338 20 0 0 76 contagem.public.temp0000226612 2 0 0 59 rio.public.temp0000285296 1 0 0 44 contagem.pg_catalog.pg_class 13 13 3371 42 brasilia.pg_catalog.pg_type 9 9 4466 36 rio.public.temp0000285304 1 0 0 36 contagem.public.temp0000226634 1 0 0 32 contagem.public.temp0000226638 1 0 0 28 rio.pg_catalog.pg_class 36 30 5953 28 brasilia.public.temp0000236076 1 0 0 23 brasilia.public.temp0000236098 1 0 0 23 brasilia.public.temp0000236080 1 0 0 23 rio.public.temp0000285286 3 0 0 20 rio.public.temp0000285220 20 0 0 14 rio.public.temp0000285262 1 0 0 14 contagem.pg_catalog.pg_type 12 12 5888 13 brasilia.pg_catalog.pg_depend 4 4 5850 12 rio.public.temp0000285312 1 0 0 10 rio.public.temp0000285320 1 0 0 10 rio.public.temp0000285318 1 0 0 10 rio.public.temp0000285322 1 0 0 10 rio.public.temp0000285316 3 0 0 10 brasilia.pg_catalog.pg_index 5 5 1847 9 rio.pg_catalog.pg_type 29 23 8073 8 template1.pg_catalog.pg_shdepend 3 3 2611 0 rio.pg_toast.pg_toast_2619 4 4 1199 0 rio.pg_catalog.pg_shdepend 6 6 4387 0 contagem.auditor.auditor_2026_07 1 0 0 0 contagem.pg_catalog.pg_depend 7 7 2272 0 rio.public.temp0000285358 7 0 0 0 contagem.pg_catalog.pg_index 8 8 2612 0 rio.public.tmp_drill_0175 5 2 372 0 rio.public.temp0000285298 1 0 0 0 rio.public.temp0000285360 1 0 0 0 rio.pg_catalog.pg_index 21 17 3805 0 contagem.pg_toast.pg_toast_2619 2 2 191 0 rio.public.temp0000285362 3 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 206 0 rio.public.temp0000285250 1 0 0 0 rio.public.temp0000285352 2 0 0 0 brasilia.public.lote_itens 1 1 1713 0 rio.public.temp0000285344 1 0 0 0 rio.public.caixa_itens_exclusao 1 1 58 0 brasilia.public.nf_entrada 2 2 3136 0 rio.public.usuarios 11 6 306 0 brasilia.pg_catalog.pg_statistic 3 3 6484 0 brasilia.public.nf_entrada_arquivo_erros 1 0 1746 0 rio.pg_catalog.pg_depend 12 12 11401 0 contagem.public.nf_entrada 3 3 657 0 contagem.public.usuarios 26 0 1583 0 rio.auditor.auditor_2026_07 1 0 4759 0 rio.public.temp0000285340 10 0 0 0 brasilia.auditor.auditor_2026_07 1 0 2864 0 rio.public.tmp_drill_0302 4 3 28268 0 rio.pg_catalog.pg_statistic 11 11 18398 0 rio.public.temp0000285346 1 0 0 0 brasilia.pg_catalog.pg_class 8 8 7291 0 rio.public.lotes_saidas 1 1 266 0 contagem.public.nf_entrada_arquivos_notas 1 1 11 0 rio.public.nf_entrada_arquivos_notas 1 1 0 0 contagem.pg_catalog.pg_statistic 3 3 6528 0 Total 608 288 529,528 5,123 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 14 00 0 0 01 1 5 02 0 0 03 0 0 04 0 7 05 6 1 06 0 1 07 30 47 08 71 139 09 98 200 10 65 171 11 47 122 12 2 13 13 32 100 14 101 157 15 56 149 16 67 131 17 27 67 18 0 0 19 0 0 20 0 0 21 5 3 22 0 0 23 0 1 - 15.90 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 2s627ms 1s290ms 1s337ms 1s313ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45318, 418, '246043733947', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 09:02:17 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45306, 418, '246227160525', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 10:42:56 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45314, 418, '215911922132', '',077,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 08:33:30 Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000285220;-
DROP TABLE IF EXISTS temp0000285220;
Date: 2026-07-14 10:42:45 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285220;
Date: 2026-07-14 08:46:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285220;
Date: 2026-07-14 07:51:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s337ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46448, 406, '833199929000412,230014808593$834025904001272,230044831435$833290942002097,230030302340$832347950000022,229976211225$832307944000008,229968256486$834053908000396,230050217683$833145921000828,230006711822$834047907002467,230049525764', '',0295,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":""}]','$$$$$$$','', 00);[ Date: 2026-07-14 10:22:23 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s290ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45761, 417, '929240091954,CC5830FD4C67$929240019972,5447CCE40AF5$929240842763,441524E586B6$929240655285,20354320EEB5$929240191860,9C247230519A$929240048639,CC583000E372$929240488315,D8CF6165C73C', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""}]','$$$$$$','', 00);[ Date: 2026-07-14 17:31:22 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s1ms DROP TABLE IF EXISTS temp0000285220;[ Date: 2026-07-14 10:42:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,642 Total read queries
- 1,876 Total write queries
Queries by database
Key values
- rio Main database
- 4,714 Requests
- 6h18m24s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,801 Requests
User Request type Count Duration etiquetas Total 46 9s145ms select 46 9s145ms intelifix Total 7,801 8h34m54s copy to 414 47m24s ddl 1,462 52m57s others 453 40m14s select 5,471 6h14m17s lenon Total 125 1m18s select 125 1m18s Duration by user
Key values
- 8h34m54s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 46 9s145ms select 46 9s145ms intelifix Total 7,801 8h34m54s copy to 414 47m24s ddl 1,462 52m57s others 453 40m14s select 5,471 6h14m17s lenon Total 125 1m18s select 125 1m18s Queries by host
Key values
- [local] Main host
- 7,972 Requests
- 8h36m21s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,875 Requests
- 4h18m6s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-14 11:05:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,490 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0265882,0) ;', '/var/www/html/tmp/temp_94.xlsx');[ Date: 2026-07-14 15:03:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 8m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 15:13:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 17:13:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 09:13:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 10:13:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 11:13:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 16:13:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m5s analyze verbose;[ Date: 2026-07-14 05:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 20:13:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 12:12:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 14:12:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 08:12:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 07:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 13:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 18:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026998, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-14 09:40:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 21:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 22:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-14 19:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-14 11:08:54 - 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 2h6m50s 47 1s192ms 8m54s 2m41s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 07 3 7m59s 2m39s 08 3 8m 2m40s 09 3 9m17s 3m5s 10 3 9m9s 3m3s 11 3 9m8s 3m2s 12 3 8m23s 2m47s 13 3 6m37s 2m12s 14 3 7m55s 2m38s 15 3 9m27s 3m9s 16 3 9m11s 3m3s 17 2 8m55s 4m27s 18 3 6m32s 2m10s 19 3 5m43s 1m54s 20 3 8m31s 2m50s 21 3 5m57s 1m59s 22 3 5m58s 1m59s [ User: intelifix - Total duration: 2h6m50s - Times executed: 47 ]
[ Application: psql - Total duration: 2h6m50s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-14 15:13:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-14 17:13:51 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-14 09:13:42 Duration: 8m41s Database: rio User: intelifix Remote: [local] Application: psql
2 1h41m4s 454 155ms 9m47s 13s358ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 07 21 10m19s 29s517ms 08 36 10m57s 18s251ms 09 62 21m8s 20s452ms 10 29 5m7s 10s609ms 11 26 11m25s 26s355ms 12 7 5s940ms 848ms 13 35 1m18s 2s252ms 14 67 7m36s 6s807ms 15 43 12m44s 17s782ms 16 86 11m58s 8s357ms 17 42 8m22s 11s966ms [ User: intelifix - Total duration: 1h41m4s - Times executed: 454 ]
[ Application: [unknown] - Total duration: 1h41m4s - Times executed: 454 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0265882,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-07-14 15:03:40 Duration: 9m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026998, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 09:40:19 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 11:08:54 Duration: 5m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h14m25s 47 234ms 4m33s 1m35s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 07 3 4m27s 1m29s 08 3 5m31s 1m50s 09 3 5m6s 1m42s 10 3 4m51s 1m37s 11 3 5m21s 1m47s 12 3 4m23s 1m27s 13 3 4m9s 1m23s 14 3 4m43s 1m34s 15 2 5m6s 2m33s 16 3 5m19s 1m46s 17 3 5m20s 1m46s 18 3 4m4s 1m21s 19 3 3m44s 1m14s 20 3 4m31s 1m30s 21 3 3m45s 1m15s 22 3 3m57s 1m19s [ User: intelifix - Total duration: 1h14m25s - Times executed: 47 ]
[ Application: psql - Total duration: 1h14m25s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-14 08:18:28 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-14 17:19:41 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-14 11:19:24 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m47s 1,481 150ms 6s989ms 883ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 07 30 52s732ms 1s757ms 08 192 2m35s 810ms 09 152 2m22s 937ms 10 141 2m24s 1s26ms 11 148 2m15s 918ms 12 57 47s315ms 830ms 13 110 1m33s 848ms 14 209 3m8s 900ms 15 190 2m24s 761ms 16 192 2m26s 764ms 17 60 56s25ms 933ms [ User: intelifix - Total duration: 21m47s - Times executed: 1481 ]
[ Application: [unknown] - Total duration: 21m47s - Times executed: 1481 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45318, 418, '246043733947', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 09:02:17 Duration: 6s989ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45306, 418, '246227160525', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 10:42:56 Duration: 5s850ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45314, 418, '215911922132', '',077,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 08:33:30 Duration: 5s60ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 14m23s 3 2m15s 8m5s 4m47s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 05 3 14m23s 4m47s [ User: intelifix - Total duration: 14m23s - Times executed: 3 ]
[ Application: psql - Total duration: 14m23s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-14 05:08:07 Duration: 8m5s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-14 05:12:08 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-14 05:14:24 Duration: 2m15s Database: contagem User: intelifix Remote: [local] Application: psql
6 11m11s 274 152ms 12s42ms 2s449ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 00 12 34s151ms 2s845ms 01 12 26s278ms 2s189ms 02 12 26s772ms 2s231ms 03 12 25s748ms 2s145ms 04 12 27s343ms 2s278ms 05 12 26s449ms 2s204ms 06 12 25s431ms 2s119ms 07 12 26s105ms 2s175ms 08 12 30s284ms 2s523ms 09 12 30s586ms 2s548ms 10 12 29s902ms 2s491ms 11 12 32s177ms 2s681ms 12 12 25s498ms 2s124ms 13 12 27s836ms 2s319ms 14 12 30s416ms 2s534ms 15 12 32s979ms 2s748ms 16 12 35s268ms 2s939ms 17 12 29s448ms 2s454ms 18 11 25s377ms 2s307ms 19 12 27s599ms 2s299ms 20 12 42s822ms 3s568ms 21 12 27s249ms 2s270ms 22 11 25s493ms 2s317ms [ User: intelifix - Total duration: 11m11s - Times executed: 274 ]
[ Application: psql - Total duration: 11m11s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 00:05:23 Duration: 12s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 20:05:13 Duration: 11s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 20:15:12 Duration: 10s356ms Database: rio User: intelifix Remote: [local] Application: psql
7 10m58s 55 9s4ms 22s699ms 11s964ms create table temp0000285244 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 14 07 10 1m43s 10s307ms 08 11 2m8s 11s717ms 09 17 3m29s 12s342ms 10 5 55s945ms 11s189ms 11 12 2m40s 13s357ms [ User: intelifix - Total duration: 10m58s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 55 ]
-
CREATE TABLE temp0000285244 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 11:38:04 Duration: 22s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285244 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 11:02:16 Duration: 14s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285244 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 09:32:12 Duration: 14s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m52s 19 750ms 2m8s 34s364ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 14 07 1 750ms 750ms 09 1 1m55s 1m55s 10 6 3m56s 39s428ms 11 4 8s276ms 2s69ms 13 1 4s426ms 4s426ms 14 4 2m26s 36s634ms 15 1 12s129ms 12s129ms 16 1 2m8s 2m8s [ User: intelifix - Total duration: 10m52s - Times executed: 19 ]
[ Application: psql - Total duration: 10m52s - Times executed: 19 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01545);
Date: 2026-07-14 16:58:23 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01534);
Date: 2026-07-14 09:56:48 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01544);
Date: 2026-07-14 14:41:39 Duration: 1m48s Database: contagem User: intelifix Remote: [local] Application: psql
9 9m24s 66 1s215ms 26s420ms 8s548ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 14 07 7 18s227ms 2s603ms 08 3 13s682ms 4s560ms 09 5 29s481ms 5s896ms 10 5 57s807ms 11s561ms 11 7 57s597ms 8s228ms 12 1 21s845ms 21s845ms 13 9 40s582ms 4s509ms 14 4 46s77ms 11s519ms 15 9 2m4s 13s888ms 16 9 1m46s 11s818ms 17 6 43s925ms 7s320ms 18 1 3s590ms 3s590ms [ User: intelifix - Total duration: 9m24s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 9m24s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 14:55:13 Duration: 26s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 10:30:28 Duration: 23s710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 16:32:14 Duration: 22s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9m21s 1,037 150ms 2s803ms 541ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 14 08 131 1m23s 636ms 09 193 1m31s 472ms 10 119 59s690ms 501ms 11 105 59s272ms 564ms 12 12 7s500ms 625ms 13 140 1m27s 625ms 14 119 1m2s 528ms 15 104 58s732ms 564ms 16 101 43s598ms 431ms 17 13 7s896ms 607ms [ User: intelifix - Total duration: 9m21s - Times executed: 1037 ]
[ Application: [unknown] - Total duration: 9m21s - Times executed: 1037 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "160", "itens" : "229763030016,229862086775,229861906780,229852666473,229845979502,229842928788,229855863744,229853754346,229852617680,229851926872,229842413857,229848065261,229845320920,229846938900,229851720411,229855798282,229853435471,229847557882,229855088809,229854615979,229861202133,229854620728,229847661025,229847064344,229763164349,229854516878,229852745269,229853282830,229852267893,229853649409,229852757694,229854573147,229854155575,229851676264,229842819104,229842253942", "usuario" : "414", "caixa" : "1219422", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 08:39:46 Duration: 2s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265707", "modelo" : "320", "itens" : "241666299292,241699966069,241708448692,241730395571,241690139712,241656902125,241706819802,241655514548,241674331638,241675617385,241606256385,241645485466,241637565860,241649206379,241694707486,241608854753,241711584566,241651795375,241618403957,241680277997,241645674149,241708589616,241680497390,241708442329,241617850110,241595513642,241716684345,241709423446,241709540607,241592528086,241680266784,241660474056,241655151528,241608698295,241619454553,241619983853,241715652640,241673044048,241700874856,241649568793,241689902035,241674191018,241667682829,241676153454,241652115563,241654402835,241608712944,241716596177", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 13:44:15 Duration: 2s754ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265795", "modelo" : "320", "itens" : "241615159005,241645751531,241630892325,241675505859,241646493859,241653698287,241631581820,241645747186,241677183240,241690551728,241708750721,241712222036,241704357485,241690185777,241606194460,241709815459,241708484959,241714048296,241673058392,241661033033,241715506082,241655152841,241699105671,241671933850,241700812224,241709757597,230048383139,241672013858,241592638603,241629859609,241670244145,241706572528,241674601114,241593256878,241691865256,241674397883,241665695160,241700827679,241653150424,241706766890,241679378303,241701775359,241601477074,241689796771,241727546168,241703362832,241661031013,241713855674", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 13:47:47 Duration: 2s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m36s 118 178ms 1m46s 3s872ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 14 07 3 2s71ms 690ms 08 12 2m26s 12s176ms 09 11 33s182ms 3s16ms 10 12 40s97ms 3s341ms 11 12 46s573ms 3s881ms 12 12 41s696ms 3s474ms 13 7 9s867ms 1s409ms 14 12 42s312ms 3s526ms 15 12 50s787ms 4s232ms 16 9 23s283ms 2s587ms 17 5 2s366ms 473ms 20 1 259ms 259ms 21 4 7s437ms 1s859ms 22 6 10s917ms 1s819ms [ User: intelifix - Total duration: 7m36s - Times executed: 118 ]
[ Application: psql - Total duration: 7m36s - Times executed: 118 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 08:06:47 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 15:05:11 Duration: 9s582ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 08:35:10 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: psql
12 5m42s 28 8s692ms 30s969ms 12s216ms create table temp0000285220 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 14 07 10 2m3s 12s316ms 08 6 1m12s 12s131ms 09 2 25s249ms 12s624ms 10 8 1m32s 11s510ms 16 2 28s776ms 14s388ms [ User: intelifix - Total duration: 5m42s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 5m42s - Times executed: 28 ]
-
CREATE TABLE temp0000285220 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 07:09:03 Duration: 30s969ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285220 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 16:40:17 Duration: 14s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285220 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 16:40:56 Duration: 14s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m14s 19 10s618ms 34s341ms 13s410ms create table temp0000285336 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 14 14 4 1m13s 18s468ms 15 15 3m 12s61ms [ User: intelifix - Total duration: 4m14s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m14s - Times executed: 19 ]
-
CREATE TABLE temp0000285336 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:27:22 Duration: 34s341ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285336 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:33:28 Duration: 14s627ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285336 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 15:07:02 Duration: 13s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m9s 20 9s77ms 15s222ms 12s483ms create table temp0000285338 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 14 14 6 1m13s 12s284ms 15 9 1m51s 12s374ms 16 5 1m4s 12s917ms [ User: intelifix - Total duration: 4m9s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m9s - Times executed: 20 ]
-
CREATE TABLE temp0000285338 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 16:19:52 Duration: 15s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285338 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:40:29 Duration: 15s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285338 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:39:14 Duration: 14s31ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 4m 166 151ms 15s580ms 1s447ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 14 07 6 3s954ms 659ms 08 8 6s217ms 777ms 09 14 6s235ms 445ms 10 3 3s313ms 1s104ms 11 5 9s847ms 1s969ms 13 24 1m10s 2s930ms 14 31 20s36ms 646ms 15 15 1m8s 4s543ms 16 49 46s204ms 942ms 17 11 6s10ms 546ms [ User: intelifix - Total duration: 4m - Times executed: 166 ]
[ Application: [unknown] - Total duration: 4m - Times executed: 166 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-14 15:38:33 Duration: 15s580ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-14 15:42:17 Duration: 12s934ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-14 16:26:19 Duration: 12s871ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 3m12s 4 4s612ms 1m39s 48s70ms 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 Jul 14 20 2 1m45s 52s559ms 23 2 1m27s 43s580ms [ User: intelifix - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-14 20:09:30 Duration: 1m39s 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-07-14 23:36:15 Duration: 1m22s 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-07-14 20:11:25 Duration: 5s328ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 3m7s 16 9s748ms 15s216ms 11s742ms create table temp0000285340 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 14 14 7 1m26s 12s427ms 16 9 1m40s 11s210ms [ User: intelifix - Total duration: 3m7s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 16 ]
-
CREATE TABLE temp0000285340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:54:28 Duration: 15s216ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:30:37 Duration: 13s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:30:03 Duration: 13s190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 3m7s 676 150ms 1s528ms 276ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 14 08 6 1s581ms 263ms 09 27 15s813ms 585ms 10 233 1m3s 274ms 11 378 1m38s 260ms 15 32 7s317ms 228ms [ User: intelifix - Total duration: 3m7s - Times executed: 676 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 676 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"246043733947,226402354344,246109399918,246287387793,246042576168,226106508805,246306965473,246297546888,226097846264,246119551919,226005928292,226244979513,246300622026,246062381828,246260499917,246304580415,226064879916,246024690114,246317556484,246183193147,226402695769,246219793655,246257048402,246281617387,226085985062,246268153032,226028933748,246323302545,246099622432,226380681534,226137224249,246322091024,226077749915,226377533235,246218216082,226233483352,246170904652,226137521226,246334781533,226335023946,246137909816,246219758499,246335319698,246226420419,246301711414,226069003652,226116139004,226377082125,246129454344,226086398693","usuario":"416","observacao":""}');
Date: 2026-07-14 09:46:19 Duration: 1s528ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45285","seriais":"229745212732,229664457678,229934244143,229754261225,229737037388,229816765057,229665685565,229741733739,229669941234,229746274665,216932150410,229816682547,229665380003,229750578395,229879812636,229836958486,229864991313,229740634653,229741745053,229747855975,229726211731,216942764554,229812536889,229850444865,229737136971,229727086776,229685587901,229739571531,229670133048,229735358088,229669982023,229689541317,229736419719,216944518686,229934316574,229691592931,229879810818,229745745971,229865042530,229670535466","usuario":"419","observacao":""}');
Date: 2026-07-14 11:35:50 Duration: 1s503ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"215911922132","usuario":"416","observacao":""}');
Date: 2026-07-14 09:45:55 Duration: 1s478ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 2m49s 15 9s837ms 14s681ms 11s298ms create table temp0000285358 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 14 17 15 2m49s 11s298ms [ User: intelifix - Total duration: 2m49s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m49s - Times executed: 15 ]
-
CREATE TABLE temp0000285358 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 17:15:10 Duration: 14s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285358 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 17:15:38 Duration: 12s998ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285358 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 17:16:35 Duration: 12s404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m41s 57 201ms 38s517ms 2s824ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 14 07 8 8s655ms 1s81ms 08 5 2s229ms 445ms 09 6 2s639ms 439ms 10 4 2s708ms 677ms 11 4 1s493ms 373ms 14 7 1m9s 9s895ms 15 14 29s766ms 2s126ms 16 5 17s211ms 3s442ms 17 4 27s46ms 6s761ms [ User: intelifix - Total duration: 2m41s - Times executed: 57 ]
[ Application: psql - Total duration: 2m41s - Times executed: 57 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027014);
Date: 2026-07-14 14:44:02 Duration: 38s517ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027029);
Date: 2026-07-14 15:57:58 Duration: 25s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027010);
Date: 2026-07-14 14:30:12 Duration: 22s612ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,481 21m47s 150ms 6s989ms 883ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 07 30 52s732ms 1s757ms 08 192 2m35s 810ms 09 152 2m22s 937ms 10 141 2m24s 1s26ms 11 148 2m15s 918ms 12 57 47s315ms 830ms 13 110 1m33s 848ms 14 209 3m8s 900ms 15 190 2m24s 761ms 16 192 2m26s 764ms 17 60 56s25ms 933ms [ User: intelifix - Total duration: 21m47s - Times executed: 1481 ]
[ Application: [unknown] - Total duration: 21m47s - Times executed: 1481 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45318, 418, '246043733947', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 09:02:17 Duration: 6s989ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45306, 418, '246227160525', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 10:42:56 Duration: 5s850ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45314, 418, '215911922132', '',077,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 08:33:30 Duration: 5s60ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,037 9m21s 150ms 2s803ms 541ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 08 131 1m23s 636ms 09 193 1m31s 472ms 10 119 59s690ms 501ms 11 105 59s272ms 564ms 12 12 7s500ms 625ms 13 140 1m27s 625ms 14 119 1m2s 528ms 15 104 58s732ms 564ms 16 101 43s598ms 431ms 17 13 7s896ms 607ms [ User: intelifix - Total duration: 9m21s - Times executed: 1037 ]
[ Application: [unknown] - Total duration: 9m21s - Times executed: 1037 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "160", "itens" : "229763030016,229862086775,229861906780,229852666473,229845979502,229842928788,229855863744,229853754346,229852617680,229851926872,229842413857,229848065261,229845320920,229846938900,229851720411,229855798282,229853435471,229847557882,229855088809,229854615979,229861202133,229854620728,229847661025,229847064344,229763164349,229854516878,229852745269,229853282830,229852267893,229853649409,229852757694,229854573147,229854155575,229851676264,229842819104,229842253942", "usuario" : "414", "caixa" : "1219422", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 08:39:46 Duration: 2s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265707", "modelo" : "320", "itens" : "241666299292,241699966069,241708448692,241730395571,241690139712,241656902125,241706819802,241655514548,241674331638,241675617385,241606256385,241645485466,241637565860,241649206379,241694707486,241608854753,241711584566,241651795375,241618403957,241680277997,241645674149,241708589616,241680497390,241708442329,241617850110,241595513642,241716684345,241709423446,241709540607,241592528086,241680266784,241660474056,241655151528,241608698295,241619454553,241619983853,241715652640,241673044048,241700874856,241649568793,241689902035,241674191018,241667682829,241676153454,241652115563,241654402835,241608712944,241716596177", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 13:44:15 Duration: 2s754ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265795", "modelo" : "320", "itens" : "241615159005,241645751531,241630892325,241675505859,241646493859,241653698287,241631581820,241645747186,241677183240,241690551728,241708750721,241712222036,241704357485,241690185777,241606194460,241709815459,241708484959,241714048296,241673058392,241661033033,241715506082,241655152841,241699105671,241671933850,241700812224,241709757597,230048383139,241672013858,241592638603,241629859609,241670244145,241706572528,241674601114,241593256878,241691865256,241674397883,241665695160,241700827679,241653150424,241706766890,241679378303,241701775359,241601477074,241689796771,241727546168,241703362832,241661031013,241713855674", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 13:47:47 Duration: 2s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 676 3m7s 150ms 1s528ms 276ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 08 6 1s581ms 263ms 09 27 15s813ms 585ms 10 233 1m3s 274ms 11 378 1m38s 260ms 15 32 7s317ms 228ms [ User: intelifix - Total duration: 3m7s - Times executed: 676 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 676 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"246043733947,226402354344,246109399918,246287387793,246042576168,226106508805,246306965473,246297546888,226097846264,246119551919,226005928292,226244979513,246300622026,246062381828,246260499917,246304580415,226064879916,246024690114,246317556484,246183193147,226402695769,246219793655,246257048402,246281617387,226085985062,246268153032,226028933748,246323302545,246099622432,226380681534,226137224249,246322091024,226077749915,226377533235,246218216082,226233483352,246170904652,226137521226,246334781533,226335023946,246137909816,246219758499,246335319698,246226420419,246301711414,226069003652,226116139004,226377082125,246129454344,226086398693","usuario":"416","observacao":""}');
Date: 2026-07-14 09:46:19 Duration: 1s528ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45285","seriais":"229745212732,229664457678,229934244143,229754261225,229737037388,229816765057,229665685565,229741733739,229669941234,229746274665,216932150410,229816682547,229665380003,229750578395,229879812636,229836958486,229864991313,229740634653,229741745053,229747855975,229726211731,216942764554,229812536889,229850444865,229737136971,229727086776,229685587901,229739571531,229670133048,229735358088,229669982023,229689541317,229736419719,216944518686,229934316574,229691592931,229879810818,229745745971,229865042530,229670535466","usuario":"419","observacao":""}');
Date: 2026-07-14 11:35:50 Duration: 1s503ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"215911922132","usuario":"416","observacao":""}');
Date: 2026-07-14 09:45:55 Duration: 1s478ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 454 1h41m4s 155ms 9m47s 13s358ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 07 21 10m19s 29s517ms 08 36 10m57s 18s251ms 09 62 21m8s 20s452ms 10 29 5m7s 10s609ms 11 26 11m25s 26s355ms 12 7 5s940ms 848ms 13 35 1m18s 2s252ms 14 67 7m36s 6s807ms 15 43 12m44s 17s782ms 16 86 11m58s 8s357ms 17 42 8m22s 11s966ms [ User: intelifix - Total duration: 1h41m4s - Times executed: 454 ]
[ Application: [unknown] - Total duration: 1h41m4s - Times executed: 454 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0265882,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-07-14 15:03:40 Duration: 9m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026998, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 09:40:19 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 11:08:54 Duration: 5m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 274 11m11s 152ms 12s42ms 2s449ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 00 12 34s151ms 2s845ms 01 12 26s278ms 2s189ms 02 12 26s772ms 2s231ms 03 12 25s748ms 2s145ms 04 12 27s343ms 2s278ms 05 12 26s449ms 2s204ms 06 12 25s431ms 2s119ms 07 12 26s105ms 2s175ms 08 12 30s284ms 2s523ms 09 12 30s586ms 2s548ms 10 12 29s902ms 2s491ms 11 12 32s177ms 2s681ms 12 12 25s498ms 2s124ms 13 12 27s836ms 2s319ms 14 12 30s416ms 2s534ms 15 12 32s979ms 2s748ms 16 12 35s268ms 2s939ms 17 12 29s448ms 2s454ms 18 11 25s377ms 2s307ms 19 12 27s599ms 2s299ms 20 12 42s822ms 3s568ms 21 12 27s249ms 2s270ms 22 11 25s493ms 2s317ms [ User: intelifix - Total duration: 11m11s - Times executed: 274 ]
[ Application: psql - Total duration: 11m11s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 00:05:23 Duration: 12s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 20:05:13 Duration: 11s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 20:15:12 Duration: 10s356ms Database: rio User: intelifix Remote: [local] Application: psql
6 202 33s63ms 150ms 213ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 01 1 175ms 175ms 07 1 158ms 158ms 08 28 4s532ms 161ms 09 44 7s335ms 166ms 10 28 4s576ms 163ms 11 19 2s993ms 157ms 12 2 320ms 160ms 13 13 2s81ms 160ms 14 21 3s415ms 162ms 15 22 3s624ms 164ms 16 19 3s153ms 165ms 17 4 694ms 173ms [ User: intelifix - Total duration: 33s63ms - Times executed: 202 ]
[ Application: [unknown] - Total duration: 33s63ms - Times executed: 202 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-14 09:10:26 Duration: 213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0151;
Date: 2026-07-14 17:02:12 Duration: 204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-14 08:22:02 Duration: 200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 166 4m 151ms 15s580ms 1s447ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 14 07 6 3s954ms 659ms 08 8 6s217ms 777ms 09 14 6s235ms 445ms 10 3 3s313ms 1s104ms 11 5 9s847ms 1s969ms 13 24 1m10s 2s930ms 14 31 20s36ms 646ms 15 15 1m8s 4s543ms 16 49 46s204ms 942ms 17 11 6s10ms 546ms [ User: intelifix - Total duration: 4m - Times executed: 166 ]
[ Application: [unknown] - Total duration: 4m - Times executed: 166 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-14 15:38:33 Duration: 15s580ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-14 15:42:17 Duration: 12s934ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-14 16:26:19 Duration: 12s871ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 165 1m14s 170ms 892ms 449ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 14 08 115 56s690ms 492ms 10 1 172ms 172ms 11 1 170ms 170ms 13 46 16s713ms 363ms 15 2 414ms 207ms [ User: intelifix - Total duration: 1m14s - Times executed: 165 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 165 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-07-14 08:46:33 Duration: 892ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-07-14 08:38:07 Duration: 878ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-07-14 08:46:17 Duration: 832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 134 27s119ms 150ms 375ms 202ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 14 01 5 929ms 185ms 04 8 1s716ms 214ms 07 14 3s92ms 220ms 08 13 2s483ms 191ms 09 9 1s890ms 210ms 10 12 2s775ms 231ms 11 18 3s576ms 198ms 12 14 2s587ms 184ms 14 11 2s237ms 203ms 15 23 4s365ms 189ms 16 7 1s464ms 209ms [ User: intelifix - Total duration: 27s119ms - Times executed: 134 ]
[ Application: [unknown] - Total duration: 27s119ms - Times executed: 134 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, 'ECA81FF661A4,3C82C06AC46C,8C6A8DC266DC,D4E2CB1E98DC,C4509CBCF484,ECA81F248354,80DAC2CF1C68,1C9D726B82F4,3C82C0C852D4,1C9D726BBDA4,ECA81FF939CC,B85E71E2A7D4,1C9D726A8964,08A7C0764204,ECA81F228374', NULL, NULL, 0185, 00);
Date: 2026-07-14 10:42:09 Duration: 375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '230026077987,230031672137,229974991824,229982429205,229990384448,230053031225,230041652628,229985279921,229985954566,230035263643', NULL, NULL, 0295, 00);
Date: 2026-07-14 07:58:22 Duration: 319ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229840036677,229854520819,229853080813,229861215366,229840664247,229856907392,229845153552,229853474263,229852979714,229856933456,229842370621,229853661027,229843231625,229840875962,229862018182,229842469900,229847748282', NULL, NULL, 0160, 00);
Date: 2026-07-14 04:33:40 Duration: 316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 126 50s459ms 162ms 971ms 400ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 14 07 10 3s329ms 332ms 08 13 5s964ms 458ms 09 20 6s816ms 340ms 10 12 4s575ms 381ms 11 6 3s118ms 519ms 12 2 1s6ms 503ms 13 2 723ms 361ms 14 17 6s374ms 374ms 15 15 6s121ms 408ms 16 16 6s999ms 437ms 17 13 5s429ms 417ms [ User: intelifix - Total duration: 50s459ms - Times executed: 126 ]
[ Application: [unknown] - Total duration: 50s459ms - Times executed: 126 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-07-14 11:32:20 Duration: 971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-14 08:34:42 Duration: 691ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-14 08:58:56 Duration: 671ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 119 56s715ms 296ms 878ms 476ms 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 #11
Day Hour Count Duration Avg duration Jul 14 01 2 1s56ms 528ms 04 3 1s105ms 368ms 05 1 476ms 476ms 06 1 387ms 387ms 07 10 4s803ms 480ms 08 14 7s176ms 512ms 09 11 5s716ms 519ms 10 12 5s449ms 454ms 11 12 4s927ms 410ms 12 3 1s182ms 394ms 13 13 5s857ms 450ms 14 11 5s682ms 516ms 15 10 4s786ms 478ms 16 9 4s315ms 479ms 17 4 2s187ms 546ms 21 1 629ms 629ms 22 1 495ms 495ms 23 1 480ms 480ms [ User: lenon - Total duration: 56s715ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 56s715ms - Times executed: 119 ]
-
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-07-14 09:00:05 Duration: 878ms 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-07-14 08:36:37 Duration: 807ms 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-07-14 08:50:10 Duration: 807ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
12 118 7m36s 178ms 1m46s 3s872ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 14 07 3 2s71ms 690ms 08 12 2m26s 12s176ms 09 11 33s182ms 3s16ms 10 12 40s97ms 3s341ms 11 12 46s573ms 3s881ms 12 12 41s696ms 3s474ms 13 7 9s867ms 1s409ms 14 12 42s312ms 3s526ms 15 12 50s787ms 4s232ms 16 9 23s283ms 2s587ms 17 5 2s366ms 473ms 20 1 259ms 259ms 21 4 7s437ms 1s859ms 22 6 10s917ms 1s819ms [ User: intelifix - Total duration: 7m36s - Times executed: 118 ]
[ Application: psql - Total duration: 7m36s - Times executed: 118 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 08:06:47 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 15:05:11 Duration: 9s582ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 08:35:10 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: psql
13 115 20s46ms 150ms 271ms 174ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 14 01 1 160ms 160ms 10 1 153ms 153ms 11 7 1s182ms 168ms 12 2 348ms 174ms 13 6 1s8ms 168ms 14 13 2s278ms 175ms 15 37 6s342ms 171ms 16 27 4s647ms 172ms 17 21 3s923ms 186ms [ User: intelifix - Total duration: 20s46ms - Times executed: 115 ]
[ Application: [unknown] - Total duration: 20s46ms - Times executed: 115 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-07-14", "data-ate" : "2026-07-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-07-14 16:24:29 Duration: 271ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-07-14", "data-ate" : "2026-07-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 366 }');
Date: 2026-07-14 17:12:11 Duration: 252ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-07-14", "data-ate" : "2026-07-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-07-14 14:36:57 Duration: 239ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 107 1m2s 361ms 992ms 585ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 14 01 2 1s390ms 695ms 04 2 960ms 480ms 05 1 624ms 624ms 07 8 4s937ms 617ms 08 14 8s460ms 604ms 09 9 5s388ms 598ms 10 11 6s305ms 573ms 11 12 6s127ms 510ms 12 3 1s622ms 540ms 13 13 7s120ms 547ms 14 10 6s197ms 619ms 15 9 4s981ms 553ms 16 8 5s118ms 639ms 17 4 2s670ms 667ms 23 1 740ms 740ms [ User: intelifix - Total duration: 1m2s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 107 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-14 09:30:01 Duration: 992ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-07-14 16:10:00 Duration: 935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-14 08:50:10 Duration: 924ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 96 37s236ms 150ms 1s82ms 387ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 14 07 5 1s79ms 215ms 08 7 5s11ms 715ms 09 15 7s652ms 510ms 10 30 12s626ms 420ms 11 6 1s363ms 227ms 12 1 153ms 153ms 13 1 191ms 191ms 14 9 3s826ms 425ms 15 10 2s760ms 276ms 16 11 2s367ms 215ms 17 1 204ms 204ms [ User: intelifix - Total duration: 37s236ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 37s236ms - Times executed: 96 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '689E29BD78E7,3CF9F0A662B2,F4E84F898022,48D682313330,689E29BD8127,3CF9F07027AD,D83139245E20,4896D9566BE2,689E29BD8787,14CA56D50C65,14CA56D513D9,843C9921397D,3CF9F0AE1594,5872C9901139,3CF9F0A6A8A2,3CF9F0AE75FA,D8313993E696,689E29BD71BB,689E29BD81F3', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-14 08:14:10 Duration: 1s82ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '689E29BC274F,5872C9950B19,843C99337D5D,48D68239ED76,843C992260EB,4896D9566942,D89A0DAA2141,D89A0DA44D51,3CF9F0A90C42,C4EBFF8EACE2,843C992E0643,D89A0D84AB9F,3CF9F0A5AB1C,14CA56D4ED7B,14CA56CE6813,3CF9F0A3A530,D89A0DACD77F,3CF9F0ABEA7C,D89A0D85032F,D89A0DA924C9', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-14 08:28:41 Duration: 1s3ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'C4EBFF904D22,4896D957BF90,843C99337B83,48D68231455A,6C11BA6BDAA7,F4E84F895CF4,3CF9F0A4DFBE,689E29BD8A5D,14CA56D2C1C1,689E29BD8C31,3891484AD13F,F4E84F846A64,3CF9F0A72696,5872C98D5AF5,D89A0DACB097,5872C98B5FEF,5872C994C877,843C9933CEAB,689E29BD8277', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-14 10:36:45 Duration: 891ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 89 47s481ms 331ms 2s440ms 533ms create table temp0000226636 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 14 14 6 3s246ms 541ms 16 83 44s235ms 532ms [ User: intelifix - Total duration: 47s481ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 47s481ms - Times executed: 89 ]
-
CREATE TABLE temp0000226636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-14 16:46:10 Duration: 2s440ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-14 16:58:27 Duration: 784ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-14 16:58:23 Duration: 772ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 81 32s754ms 249ms 712ms 404ms create table temp0000285272 as select * from rs_fluxos_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 14 08 30 10s340ms 344ms 09 51 22s414ms 439ms [ User: intelifix - Total duration: 32s754ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 32s754ms - Times executed: 81 ]
-
CREATE TABLE temp0000285272 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '14-07-2026', '14-07-2026', 0, '', 00);
Date: 2026-07-14 09:57:41 Duration: 712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285272 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '14-07-2026', '14-07-2026', 0, '', 00);
Date: 2026-07-14 09:42:05 Duration: 694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285272 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '14-07-2026', '14-07-2026', 0, '', 00);
Date: 2026-07-14 09:56:26 Duration: 671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 66 9m24s 1s215ms 26s420ms 8s548ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 14 07 7 18s227ms 2s603ms 08 3 13s682ms 4s560ms 09 5 29s481ms 5s896ms 10 5 57s807ms 11s561ms 11 7 57s597ms 8s228ms 12 1 21s845ms 21s845ms 13 9 40s582ms 4s509ms 14 4 46s77ms 11s519ms 15 9 2m4s 13s888ms 16 9 1m46s 11s818ms 17 6 43s925ms 7s320ms 18 1 3s590ms 3s590ms [ User: intelifix - Total duration: 9m24s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 9m24s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 14:55:13 Duration: 26s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 10:30:28 Duration: 23s710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 16:32:14 Duration: 22s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 60 24s66ms 150ms 1s191ms 401ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 14 08 13 6s637ms 510ms 09 9 1s989ms 221ms 10 6 2s5ms 334ms 11 9 2s542ms 282ms 13 11 6s611ms 601ms 14 2 371ms 185ms 15 5 2s584ms 516ms 16 4 1s83ms 270ms 17 1 241ms 241ms [ User: intelifix - Total duration: 24s66ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 24s66ms - Times executed: 60 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3017522 ORDER BY A.CAI_ORDEM;
Date: 2026-07-14 08:43:08 Duration: 1s191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2494637 ORDER BY A.CAI_ORDEM;
Date: 2026-07-14 13:36:34 Duration: 1s153ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2922873 ORDER BY A.CAI_ORDEM;
Date: 2026-07-14 13:38:49 Duration: 1s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 57 2m41s 201ms 38s517ms 2s824ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 14 07 8 8s655ms 1s81ms 08 5 2s229ms 445ms 09 6 2s639ms 439ms 10 4 2s708ms 677ms 11 4 1s493ms 373ms 14 7 1m9s 9s895ms 15 14 29s766ms 2s126ms 16 5 17s211ms 3s442ms 17 4 27s46ms 6s761ms [ User: intelifix - Total duration: 2m41s - Times executed: 57 ]
[ Application: psql - Total duration: 2m41s - Times executed: 57 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027014);
Date: 2026-07-14 14:44:02 Duration: 38s517ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027029);
Date: 2026-07-14 15:57:58 Duration: 25s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027010);
Date: 2026-07-14 14:30:12 Duration: 22s612ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m15s 8m5s 4m47s 3 14m23s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 14 05 3 14m23s 4m47s [ User: intelifix - Total duration: 14m23s - Times executed: 3 ]
[ Application: psql - Total duration: 14m23s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-14 05:08:07 Duration: 8m5s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-14 05:12:08 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-14 05:14:24 Duration: 2m15s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s192ms 8m54s 2m41s 47 2h6m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 14 07 3 7m59s 2m39s 08 3 8m 2m40s 09 3 9m17s 3m5s 10 3 9m9s 3m3s 11 3 9m8s 3m2s 12 3 8m23s 2m47s 13 3 6m37s 2m12s 14 3 7m55s 2m38s 15 3 9m27s 3m9s 16 3 9m11s 3m3s 17 2 8m55s 4m27s 18 3 6m32s 2m10s 19 3 5m43s 1m54s 20 3 8m31s 2m50s 21 3 5m57s 1m59s 22 3 5m58s 1m59s [ User: intelifix - Total duration: 2h6m50s - Times executed: 47 ]
[ Application: psql - Total duration: 2h6m50s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-14 15:13:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-14 17:13:51 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-14 09:13:42 Duration: 8m41s Database: rio User: intelifix Remote: [local] Application: psql
3 234ms 4m33s 1m35s 47 1h14m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 14 07 3 4m27s 1m29s 08 3 5m31s 1m50s 09 3 5m6s 1m42s 10 3 4m51s 1m37s 11 3 5m21s 1m47s 12 3 4m23s 1m27s 13 3 4m9s 1m23s 14 3 4m43s 1m34s 15 2 5m6s 2m33s 16 3 5m19s 1m46s 17 3 5m20s 1m46s 18 3 4m4s 1m21s 19 3 3m44s 1m14s 20 3 4m31s 1m30s 21 3 3m45s 1m15s 22 3 3m57s 1m19s [ User: intelifix - Total duration: 1h14m25s - Times executed: 47 ]
[ Application: psql - Total duration: 1h14m25s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-14 08:18:28 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-14 17:19:41 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-14 11:19:24 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s612ms 1m39s 48s70ms 4 3m12s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 14 20 2 1m45s 52s559ms 23 2 1m27s 43s580ms [ User: intelifix - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-14 20:09:30 Duration: 1m39s 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-07-14 23:36:15 Duration: 1m22s 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-07-14 20:11:25 Duration: 5s328ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 750ms 2m8s 34s364ms 19 10m52s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 14 07 1 750ms 750ms 09 1 1m55s 1m55s 10 6 3m56s 39s428ms 11 4 8s276ms 2s69ms 13 1 4s426ms 4s426ms 14 4 2m26s 36s634ms 15 1 12s129ms 12s129ms 16 1 2m8s 2m8s [ User: intelifix - Total duration: 10m52s - Times executed: 19 ]
[ Application: psql - Total duration: 10m52s - Times executed: 19 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01545);
Date: 2026-07-14 16:58:23 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01534);
Date: 2026-07-14 09:56:48 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01544);
Date: 2026-07-14 14:41:39 Duration: 1m48s Database: contagem User: intelifix Remote: [local] Application: psql
6 10s618ms 34s341ms 13s410ms 19 4m14s create table temp0000285336 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 14 14 4 1m13s 18s468ms 15 15 3m 12s61ms [ User: intelifix - Total duration: 4m14s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m14s - Times executed: 19 ]
-
CREATE TABLE temp0000285336 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:27:22 Duration: 34s341ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285336 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:33:28 Duration: 14s627ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285336 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 15:07:02 Duration: 13s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 155ms 9m47s 13s358ms 454 1h41m4s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 14 07 21 10m19s 29s517ms 08 36 10m57s 18s251ms 09 62 21m8s 20s452ms 10 29 5m7s 10s609ms 11 26 11m25s 26s355ms 12 7 5s940ms 848ms 13 35 1m18s 2s252ms 14 67 7m36s 6s807ms 15 43 12m44s 17s782ms 16 86 11m58s 8s357ms 17 42 8m22s 11s966ms [ User: intelifix - Total duration: 1h41m4s - Times executed: 454 ]
[ Application: [unknown] - Total duration: 1h41m4s - Times executed: 454 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0265882,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-07-14 15:03:40 Duration: 9m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026998, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 09:40:19 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-14 11:08:54 Duration: 5m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s77ms 15s222ms 12s483ms 20 4m9s create table temp0000285338 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 14 14 6 1m13s 12s284ms 15 9 1m51s 12s374ms 16 5 1m4s 12s917ms [ User: intelifix - Total duration: 4m9s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m9s - Times executed: 20 ]
-
CREATE TABLE temp0000285338 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 16:19:52 Duration: 15s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285338 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:40:29 Duration: 15s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285338 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:39:14 Duration: 14s31ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8s692ms 30s969ms 12s216ms 28 5m42s create table temp0000285220 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 14 07 10 2m3s 12s316ms 08 6 1m12s 12s131ms 09 2 25s249ms 12s624ms 10 8 1m32s 11s510ms 16 2 28s776ms 14s388ms [ User: intelifix - Total duration: 5m42s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 5m42s - Times executed: 28 ]
-
CREATE TABLE temp0000285220 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 07:09:03 Duration: 30s969ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285220 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 16:40:17 Duration: 14s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285220 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 16:40:56 Duration: 14s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s4ms 22s699ms 11s964ms 55 10m58s create table temp0000285244 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 14 07 10 1m43s 10s307ms 08 11 2m8s 11s717ms 09 17 3m29s 12s342ms 10 5 55s945ms 11s189ms 11 12 2m40s 13s357ms [ User: intelifix - Total duration: 10m58s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 55 ]
-
CREATE TABLE temp0000285244 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 11:38:04 Duration: 22s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285244 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 11:02:16 Duration: 14s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285244 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 09:32:12 Duration: 14s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s748ms 15s216ms 11s742ms 16 3m7s create table temp0000285340 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 14 14 7 1m26s 12s427ms 16 9 1m40s 11s210ms [ User: intelifix - Total duration: 3m7s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 16 ]
-
CREATE TABLE temp0000285340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:54:28 Duration: 15s216ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:30:37 Duration: 13s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 14:30:03 Duration: 13s190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s837ms 14s681ms 11s298ms 15 2m49s create table temp0000285358 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 14 17 15 2m49s 11s298ms [ User: intelifix - Total duration: 2m49s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m49s - Times executed: 15 ]
-
CREATE TABLE temp0000285358 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 17:15:10 Duration: 14s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285358 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 17:15:38 Duration: 12s998ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285358 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-14 17:16:35 Duration: 12s404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s215ms 26s420ms 8s548ms 66 9m24s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 14 07 7 18s227ms 2s603ms 08 3 13s682ms 4s560ms 09 5 29s481ms 5s896ms 10 5 57s807ms 11s561ms 11 7 57s597ms 8s228ms 12 1 21s845ms 21s845ms 13 9 40s582ms 4s509ms 14 4 46s77ms 11s519ms 15 9 2m4s 13s888ms 16 9 1m46s 11s818ms 17 6 43s925ms 7s320ms 18 1 3s590ms 3s590ms [ User: intelifix - Total duration: 9m24s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 9m24s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 14:55:13 Duration: 26s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 10:30:28 Duration: 23s710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-14', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-14 16:32:14 Duration: 22s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 178ms 1m46s 3s872ms 118 7m36s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 14 07 3 2s71ms 690ms 08 12 2m26s 12s176ms 09 11 33s182ms 3s16ms 10 12 40s97ms 3s341ms 11 12 46s573ms 3s881ms 12 12 41s696ms 3s474ms 13 7 9s867ms 1s409ms 14 12 42s312ms 3s526ms 15 12 50s787ms 4s232ms 16 9 23s283ms 2s587ms 17 5 2s366ms 473ms 20 1 259ms 259ms 21 4 7s437ms 1s859ms 22 6 10s917ms 1s819ms [ User: intelifix - Total duration: 7m36s - Times executed: 118 ]
[ Application: psql - Total duration: 7m36s - Times executed: 118 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 08:06:47 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 15:05:11 Duration: 9s582ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-14 08:35:10 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: psql
15 201ms 38s517ms 2s824ms 57 2m41s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 14 07 8 8s655ms 1s81ms 08 5 2s229ms 445ms 09 6 2s639ms 439ms 10 4 2s708ms 677ms 11 4 1s493ms 373ms 14 7 1m9s 9s895ms 15 14 29s766ms 2s126ms 16 5 17s211ms 3s442ms 17 4 27s46ms 6s761ms [ User: intelifix - Total duration: 2m41s - Times executed: 57 ]
[ Application: psql - Total duration: 2m41s - Times executed: 57 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027014);
Date: 2026-07-14 14:44:02 Duration: 38s517ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027029);
Date: 2026-07-14 15:57:58 Duration: 25s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027010);
Date: 2026-07-14 14:30:12 Duration: 22s612ms Database: rio User: intelifix Remote: [local] Application: psql
16 152ms 12s42ms 2s449ms 274 11m11s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 14 00 12 34s151ms 2s845ms 01 12 26s278ms 2s189ms 02 12 26s772ms 2s231ms 03 12 25s748ms 2s145ms 04 12 27s343ms 2s278ms 05 12 26s449ms 2s204ms 06 12 25s431ms 2s119ms 07 12 26s105ms 2s175ms 08 12 30s284ms 2s523ms 09 12 30s586ms 2s548ms 10 12 29s902ms 2s491ms 11 12 32s177ms 2s681ms 12 12 25s498ms 2s124ms 13 12 27s836ms 2s319ms 14 12 30s416ms 2s534ms 15 12 32s979ms 2s748ms 16 12 35s268ms 2s939ms 17 12 29s448ms 2s454ms 18 11 25s377ms 2s307ms 19 12 27s599ms 2s299ms 20 12 42s822ms 3s568ms 21 12 27s249ms 2s270ms 22 11 25s493ms 2s317ms [ User: intelifix - Total duration: 11m11s - Times executed: 274 ]
[ Application: psql - Total duration: 11m11s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 00:05:23 Duration: 12s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 20:05:13 Duration: 11s905ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-14 20:15:12 Duration: 10s356ms Database: rio User: intelifix Remote: [local] Application: psql
17 151ms 15s580ms 1s447ms 166 4m select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 14 07 6 3s954ms 659ms 08 8 6s217ms 777ms 09 14 6s235ms 445ms 10 3 3s313ms 1s104ms 11 5 9s847ms 1s969ms 13 24 1m10s 2s930ms 14 31 20s36ms 646ms 15 15 1m8s 4s543ms 16 49 46s204ms 942ms 17 11 6s10ms 546ms [ User: intelifix - Total duration: 4m - Times executed: 166 ]
[ Application: [unknown] - Total duration: 4m - Times executed: 166 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-14 15:38:33 Duration: 15s580ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-14 15:42:17 Duration: 12s934ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-14 16:26:19 Duration: 12s871ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 150ms 6s989ms 883ms 1,481 21m47s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 14 07 30 52s732ms 1s757ms 08 192 2m35s 810ms 09 152 2m22s 937ms 10 141 2m24s 1s26ms 11 148 2m15s 918ms 12 57 47s315ms 830ms 13 110 1m33s 848ms 14 209 3m8s 900ms 15 190 2m24s 761ms 16 192 2m26s 764ms 17 60 56s25ms 933ms [ User: intelifix - Total duration: 21m47s - Times executed: 1481 ]
[ Application: [unknown] - Total duration: 21m47s - Times executed: 1481 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45318, 418, '246043733947', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 09:02:17 Duration: 6s989ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45306, 418, '246227160525', '',0172,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 10:42:56 Duration: 5s850ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45314, 418, '215911922132', '',077,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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-14 08:33:30 Duration: 5s60ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 361ms 992ms 585ms 107 1m2s select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 14 01 2 1s390ms 695ms 04 2 960ms 480ms 05 1 624ms 624ms 07 8 4s937ms 617ms 08 14 8s460ms 604ms 09 9 5s388ms 598ms 10 11 6s305ms 573ms 11 12 6s127ms 510ms 12 3 1s622ms 540ms 13 13 7s120ms 547ms 14 10 6s197ms 619ms 15 9 4s981ms 553ms 16 8 5s118ms 639ms 17 4 2s670ms 667ms 23 1 740ms 740ms [ User: intelifix - Total duration: 1m2s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 107 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-14 09:30:01 Duration: 992ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-07-14 16:10:00 Duration: 935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-14 08:50:10 Duration: 924ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 150ms 2s803ms 541ms 1,037 9m21s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 14 08 131 1m23s 636ms 09 193 1m31s 472ms 10 119 59s690ms 501ms 11 105 59s272ms 564ms 12 12 7s500ms 625ms 13 140 1m27s 625ms 14 119 1m2s 528ms 15 104 58s732ms 564ms 16 101 43s598ms 431ms 17 13 7s896ms 607ms [ User: intelifix - Total duration: 9m21s - Times executed: 1037 ]
[ Application: [unknown] - Total duration: 9m21s - Times executed: 1037 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "160", "itens" : "229763030016,229862086775,229861906780,229852666473,229845979502,229842928788,229855863744,229853754346,229852617680,229851926872,229842413857,229848065261,229845320920,229846938900,229851720411,229855798282,229853435471,229847557882,229855088809,229854615979,229861202133,229854620728,229847661025,229847064344,229763164349,229854516878,229852745269,229853282830,229852267893,229853649409,229852757694,229854573147,229854155575,229851676264,229842819104,229842253942", "usuario" : "414", "caixa" : "1219422", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 08:39:46 Duration: 2s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265707", "modelo" : "320", "itens" : "241666299292,241699966069,241708448692,241730395571,241690139712,241656902125,241706819802,241655514548,241674331638,241675617385,241606256385,241645485466,241637565860,241649206379,241694707486,241608854753,241711584566,241651795375,241618403957,241680277997,241645674149,241708589616,241680497390,241708442329,241617850110,241595513642,241716684345,241709423446,241709540607,241592528086,241680266784,241660474056,241655151528,241608698295,241619454553,241619983853,241715652640,241673044048,241700874856,241649568793,241689902035,241674191018,241667682829,241676153454,241652115563,241654402835,241608712944,241716596177", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 13:44:15 Duration: 2s754ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265795", "modelo" : "320", "itens" : "241615159005,241645751531,241630892325,241675505859,241646493859,241653698287,241631581820,241645747186,241677183240,241690551728,241708750721,241712222036,241704357485,241690185777,241606194460,241709815459,241708484959,241714048296,241673058392,241661033033,241715506082,241655152841,241699105671,241671933850,241700812224,241709757597,230048383139,241672013858,241592638603,241629859609,241670244145,241706572528,241674601114,241593256878,241691865256,241674397883,241665695160,241700827679,241653150424,241706766890,241679378303,241701775359,241601477074,241689796771,241727546168,241703362832,241661031013,241713855674", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-14 13:47:47 Duration: 2s589ms 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 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 14 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 18 2 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 4s866ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 3s473ms - Times executed: 5 ]
[ Application: psql - Total duration: 1s392ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: [unknown]
-
Events
Log levels
Key values
- 21,374 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 4522 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,310 Max number of times the same event was reported
- 4,545 Total events found
Rank Times reported Error 1 4,310 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 14 00 59 01 60 02 59 03 55 04 59 05 60 06 59 07 182 08 351 09 340 10 439 11 352 12 196 13 188 14 348 15 400 16 262 17 167 18 115 19 116 20 116 21 114 22 118 23 95 - ERROR: prepared statement "_PLAN0000000029F208E0" does not exist
- ERROR: prepared statement "_PLAN0000000029C448F0" does not exist
- ERROR: prepared statement "_PLAN0000000029C3F6D0" does not exist
Statement: DEALLOCATE "_PLAN0000000029F208E0"
Date: 2026-07-14 00:00:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C448F0"
Date: 2026-07-14 00:01:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C3F6D0"
Date: 2026-07-14 00:02:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 47 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 14 00 6 01 6 02 6 03 5 04 6 05 6 06 6 07 6 - ERROR: update or delete on table "fluxos" violates foreign key constraint "ref_caixa_itens_to_fluxos" on table "caixa_itens"
- ERROR: update or delete on table "fluxos" violates foreign key constraint "ref_caixa_itens_to_fluxos" on table "caixa_itens"
- ERROR: update or delete on table "fluxos" violates foreign key constraint "ref_caixa_itens_to_fluxos" on table "caixa_itens"
Detail: Key (flu_id)=(2957262) is still referenced from table "caixa_itens".
Context: SQL statement "DELETE FROM FLUXOS WHERE FLU_ID = nFluxo" PL/pgSQL function rs_triagem_exclui(integer,integer) line 121 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-14 00:05:11 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Key (flu_id)=(2957262) is still referenced from table "caixa_itens".
Context: SQL statement "DELETE FROM FLUXOS WHERE FLU_ID = nFluxo" PL/pgSQL function rs_triagem_exclui(integer,integer) line 121 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-14 00:15:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Key (flu_id)=(2957262) is still referenced from table "caixa_itens".
Context: SQL statement "DELETE FROM FLUXOS WHERE FLU_ID = nFluxo" PL/pgSQL function rs_triagem_exclui(integer,integer) line 121 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-14 00:25:01 Database: rio Application: psql User: intelifix Remote: [local]
3 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 14 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 2 20 2 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-07-14 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-07-14 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-07-14 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 14 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 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-07-14 08:00:05 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-07-14 08:20:03 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-07-14 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
5 35 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 14 08 3 09 3 10 3 11 21 12 3 16 1 17 1 - ERROR: trailing junk after numeric literal at or near "83350053391676E" at character 27
- ERROR: trailing junk after numeric literal at or near "83350053391676E" at character 27
- ERROR: trailing junk after numeric literal at or near "83350053391676E" at character 27
Statement: SELECT * FROM RS_ETIQUETA(83350053391676E)
Date: 2026-07-14 08:46:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350053391676E)
Date: 2026-07-14 08:46:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350053391676E)
Date: 2026-07-14 08:46:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 27 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 14 08 2 09 2 11 2 12 4 13 13 14 3 16 1 - ERROR: syntax error at or near "3266933" at character 35
- ERROR: syntax error at or near "3266933" at character 35
- ERROR: syntax error at or near ")" at character 34
Statement: select * from rs_caixa_qr(3266933 3266933 )
Date: 2026-07-14 08:10:38 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3266933 3266933 )
Date: 2026-07-14 08:10:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(379924,)
Date: 2026-07-14 09:53:26 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 14 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-14 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-14 03:05:02 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-14 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 14 00 1 06 1 08 1 16 1 18 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-14 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-14 06:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-14 08:53:17 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
9 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 14 05 4 - 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-07-14 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-14 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-14 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local]
10 4 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 14 07 4 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
- ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
- ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 85
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-07-01');
Date: 2026-07-14 07:21:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'N-Na--N-Na');
Date: 2026-07-14 07:22:08 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( '2026-07-13', 0404 ,'', '',0,7,'N-Na--N-Na');
Date: 2026-07-14 07:25:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
11 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 14 03 4 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-14 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-14 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-14 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 14 10 1 17 1 - LOG: process 667100 still waiting for ShareLock on transaction 2628773 after 1000.169 ms
- LOG: process 1135649 still waiting for ShareLock on transaction 2674848 after 1000.120 ms
Detail: Process holding the lock: 735038. Wait queue: 667100.
Context: while updating tuple (1,49) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(46448,406,'833199929000412,230014808593$834025904001272,230044831435$833290942002097,230030302340$832347950000022,229976211225$832307944000008,229968256486$834053908000396,230050217683$833145921000828,230006711822$834047907002467,230049525764','',0295,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":""}]','$$$$$$$','',00);Date: 2026-07-14 10:22:22 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1095435. Wait queue: 1135649.
Context: while updating tuple (1,24) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(45761,417,'929240091954,CC5830FD4C67$929240019972,5447CCE40AF5$929240842763,441524E586B6$929240655285,20354320EEB5$929240191860,9C247230519A$929240048639,CC583000E372$929240488315,D8CF6165C73C','',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""}]','$$$$$$','',00);Date: 2026-07-14 17:31:22 Database: contagem Application: [unknown] User: intelifix Remote: [local]
13 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 14 12 1 17 1 - ERROR: unterminated quoted string at or near "''' )" at character 44
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0131, ''' )
Date: 2026-07-14 12:05:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-14 17:17:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 14 10 1 - LOG: process 755142 still waiting for AccessExclusiveLock on relation 2385230 of database 358220 after 1000.149 ms
Detail: Process holding the lock: 763707. Wait queue: 755142.
Statement: DROP TABLE IF EXISTS temp0000285220;Date: 2026-07-14 10:42:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 14 03 1 - LOG: database system was shut down at 2026-07-14 03:05:02 -03
Date: 2026-07-14 03:05:03
16 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 14 10 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000285220"
Date: 2026-07-14 10:42:45
17 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 14 13 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, 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_LOTE_MANUTENCAO_ITENS(128198,401,'14003785850075808433,8C444FDFBE32$14119685850097600076,C85D38DE19E7$14120085850097602379,C85D38E0EC06$14032285850086702153,C85D389A68BF$14013485850080208423,C85D381312BE$14106885850091803326,8C444FD4E98A$14014185850081104359,C85D381A0192$14012785850080003869,C85D3860FE49$14317085850104102217,D86C5A6749B0$14012785850080010041,C85D3862F895','',0151,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',08444E32);Date: 2026-07-14 13:56:50 Database: brasilia Application: [unknown] User: intelifix Remote: [local]