pgBadger-
Global information
- Generated on Tue Jun 23 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 53,461 log entries in 9s
- Log start from 2026-06-23 00:00:58 to 2026-06-23 23:49:18
-
Overview
Global Stats
- 394 Number of unique normalized queries
- 7,390 Number of queries
- 10h32m28s Total query duration
- 2026-06-23 00:02:28 First query
- 2026-06-23 23:47:51 Last query
- 5 queries/s at 2026-06-23 09:27:06 Query peak
- 10h32m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10h32m28s Execute total duration
- 5,915 Number of events
- 16 Number of unique normalized events
- 5,686 Max number of times the same event was reported
- 0 Number of cancellation
- 528 Total number of automatic vacuums
- 1,106 Total number of automatic analyzes
- 29 Number temporary file
- 231.55 MiB Max size of temporary file
- 105.07 MiB Average size of temporary file
- 350 Total number of sessions
- 8 sessions at 2026-06-23 06:55:06 Session peak
- 13d3h15m49s Total duration of sessions
- 54m2s Average duration of sessions
- 21 Average queries per session
- 1m48s Average queries duration per session
- 52m14s Average idle time per session
- 355 Total number of connections
- 4 connections/s at 2026-06-23 00:02:28 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-23 09:27:06 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-23 09:27:06 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-23 23:47:17 Date
Queries duration
Key values
- 10h32m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 23 00 28 0ms 26s699ms 5s918ms 6s907ms 17s892ms 1m28s 01 20 0ms 4s359ms 1s803ms 4s818ms 6s206ms 7s233ms 02 16 0ms 4s451ms 1s823ms 2s612ms 5s526ms 6s951ms 03 18 0ms 6s113ms 2s62ms 3s944ms 6s 9s166ms 04 63 0ms 4s802ms 726ms 4s201ms 5s569ms 8s180ms 05 48 0ms 9m10s 24s218ms 14s12ms 2m21s 9m11s 06 32 0ms 24s314ms 3s20ms 2s838ms 10s296ms 34s565ms 07 181 0ms 11m5s 14s281ms 3m40s 4m13s 11m7s 08 653 150ms 6m26s 4s567ms 4m2s 4m48s 7m5s 09 764 150ms 15m28s 5s676ms 2m31s 7m13s 15m38s 10 810 150ms 11m23s 3s889ms 1m46s 4m46s 11m39s 11 684 150ms 8m59s 3s317ms 1m18s 4m14s 9m5s 12 232 0ms 10m44s 8s773ms 59s354ms 4m 11m9s 13 427 0ms 6m56s 4s92ms 59s725ms 3m31s 6m56s 14 666 150ms 10m42s 3s924ms 1m18s 4m24s 11m1s 15 967 150ms 10m14s 3s950ms 4m28s 5m10s 10m50s 16 717 150ms 7m49s 3s607ms 1m16s 4m33s 8m1s 17 511 0ms 7m32s 4s187ms 1m31s 3m38s 7m53s 18 26 0ms 7m41s 30s548ms 3s210ms 1m1s 7m41s 19 21 0ms 5m44s 28s59ms 2s547ms 42s757ms 5m44s 20 112 0ms 6m56s 10s933ms 1m3s 2m2s 6m56s 21 31 0ms 5m56s 19s631ms 3s670ms 41s689ms 5m56s 22 28 0ms 6m8s 22s579ms 3s732ms 4s992ms 6m54s 23 335 0ms 1m24s 6s743ms 1m11s 1m19s 2m13s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 23 00 6 0 4s943ms 0ms 0ms 1s572ms 01 2 0 286ms 0ms 0ms 241ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 383ms 0ms 0ms 0ms 04 44 0 279ms 435ms 679ms 1s56ms 05 26 0 312ms 229ms 624ms 992ms 06 13 0 2s928ms 0ms 341ms 6s598ms 07 111 0 19s552ms 5s164ms 3m40s 5m31s 08 475 0 4s894ms 16s458ms 3m41s 5m14s 09 586 0 5s741ms 1m2s 2m15s 7m3s 10 617 0 4s183ms 21s278ms 1m46s 4m45s 11 541 0 3s437ms 22s411ms 58s116ms 4m31s 12 156 0 10s998ms 12s883ms 55s140ms 5m57s 13 350 0 4s449ms 21s198ms 47s471ms 5m33s 14 536 0 4s67ms 28s104ms 54s460ms 7m15s 15 727 0 4s319ms 42s471ms 4m22s 5m57s 16 506 0 4s323ms 33s784ms 1m6s 5m13s 17 390 0 5s72ms 31s666ms 1m29s 5m18s 18 9 0 1m25s 0ms 1s441ms 3m43s 19 6 0 1m35s 0ms 0ms 3m3s 20 13 86 12s122ms 695ms 1m3s 3m21s 21 12 0 48s515ms 0ms 166ms 3m1s 22 8 0 1m15s 0ms 0ms 3m10s 23 8 327 6s743ms 1m3s 1m11s 2m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 23 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 4 4.00 0.00% 07 0 8 8.00 0.00% 08 0 14 14.00 0.00% 09 0 14 14.00 0.00% 10 0 14 14.00 0.00% 11 0 8 8.00 0.00% 12 0 7 7.00 0.00% 13 0 12 12.00 0.00% 14 0 12 12.00 0.00% 15 0 12 12.00 0.00% 16 0 10 10.00 0.00% 17 0 12 12.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 1 1.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 23 00 15 0.00/s 01 7 0.00/s 02 6 0.00/s 03 16 0.00/s 04 12 0.00/s 05 11 0.00/s 06 14 0.00/s 07 12 0.00/s 08 25 0.01/s 09 22 0.01/s 10 23 0.01/s 11 17 0.00/s 12 15 0.00/s 13 24 0.01/s 14 22 0.01/s 15 24 0.01/s 16 21 0.01/s 17 17 0.00/s 18 9 0.00/s 19 8 0.00/s 20 10 0.00/s 21 10 0.00/s 22 10 0.00/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jun 23 00 5 1h36s 1h3s 01 14 1h48s 1h46s 02 7 1h 59m56s 03 14 11m55s 11m53s 04 8 1h2m37s 1h2m31s 05 10 1h1m11s 59m15s 06 10 58m6s 57m56s 07 14 57m13s 54m8s 08 16 47m47s 44m41s 09 22 57m13s 53m56s 10 23 56m54s 54m37s 11 21 58m48s 57m 12 19 54m50s 53m3s 13 15 51m56s 49m59s 14 23 54m26s 52m33s 15 23 53m51s 51m5s 16 23 55m34s 53m41s 17 22 53m7s 51m30s 18 14 59m46s 58m49s 19 9 1h43s 59m38s 20 11 43m 41m9s 21 7 1h1m16s 59m49s 22 9 1h41s 59m31s 23 11 47m21s 43m55s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-23 00:02:28 Date
Connections per database
Key values
- rio Main Database
- 355 connections Total
Connections per user
Key values
- intelifix Main User
- 355 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-06-23 06:55:06 Date
Histogram of session times
Key values
- 291 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 350 sessions Total
Sessions per user
Key values
- intelifix Main User
- 350 sessions Total
Sessions per host
Key values
- [local] Main Host
- 350 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 38,712 buffers Checkpoint Peak
- 2026-06-23 00:19:38 Date
- 270.038 seconds Highest write time
- 0.574 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-06-23 15:39:34 Date
Checkpoints distance
Key values
- 405.12 Mo Distance Peak
- 2026-06-23 15:39:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 23 00 42,323 630.991s 0.26s 631.324s 01 1,796 180.185s 0.161s 180.395s 02 1,526 152.954s 0.095s 153.082s 03 1,827 183.119s 0.084s 183.272s 04 3,324 333.512s 0.167s 333.733s 05 13,494 1,200.93s 0.261s 1,201.287s 06 5,001 409.501s 0.178s 409.715s 07 40,772 2,436.967s 0.209s 2,437.343s 08 71,924 3,232.406s 0.352s 3,233.107s 09 94,300 3,238.186s 1.061s 3,239.739s 10 107,146 3,239.065s 0.372s 3,239.684s 11 57,580 3,239.279s 0.281s 3,239.725s 12 46,264 2,603.978s 0.137s 2,604.212s 13 33,311 2,242.284s 0.147s 2,242.551s 14 72,167 3,239.311s 0.212s 3,239.662s 15 86,187 3,239.18s 0.308s 3,239.667s 16 69,088 3,239.332s 0.239s 3,239.743s 17 46,305 2,462.222s 0.169s 2,462.496s 18 1,465 147.107s 0.014s 147.146s 19 33 3.361s 0.005s 3.379s 20 862 89.582s 0.007s 89.601s 21 2,392 239.801s 0.038s 239.892s 22 1,780 178.693s 0.024s 178.748s 23 226 288.379s 0.009s 288.406s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 23 00 0 9 0 471 0.096s 0.007s 01 0 0 0 410 0.065s 0.007s 02 0 1 0 344 0.068s 0.005s 03 0 0 0 353 0.016s 0.006s 04 0 1 0 786 0.062s 0.01s 05 0 7 0 953 0.064s 0.01s 06 0 1 0 116 0.064s 0.017s 07 0 28 0 2,412 0.039s 0.011s 08 0 56 0 6,118 0.061s 0.012s 09 0 60 0 7,182 0.518s 0.012s 10 0 21 43 7,545 0.006s 0.012s 11 0 0 33 6,709 0.005s 0.012s 12 0 0 38 3,472 0.033s 0.011s 13 0 0 16 4,590 0.004s 0.012s 14 0 0 38 6,666 0.005s 0.012s 15 0 0 64 7,910 0.006s 0.012s 16 0 0 56 7,025 0.006s 0.012s 17 0 0 27 5,440 0.004s 0.012s 18 0 0 0 190 0.002s 0.007s 19 0 0 0 11 0.002s 0.003s 20 0 0 2 92 0.002s 0.003s 21 0 0 0 447 0.004s 0.01s 22 0 0 1 403 0.003s 0.007s 23 0 0 2 37 0.003s 0.004s Day Hour Count Avg time (sec) Jun 23 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 23 00 24,270.67 kB 151,063.17 kB 01 1,388.43 kB 78,540.29 kB 02 1,508.20 kB 41,914.80 kB 03 1,477.43 kB 6,436.43 kB 04 1,731.40 kB 2,574.70 kB 05 10,471.30 kB 23,982.90 kB 06 2,581.40 kB 22,699.60 kB 07 42,205.36 kB 82,504.36 kB 08 76,396.42 kB 137,112.00 kB 09 82,671.50 kB 115,028.58 kB 10 86,545.50 kB 149,333.75 kB 11 45,306.50 kB 94,349.83 kB 12 55,945.18 kB 109,333.73 kB 13 23,005.58 kB 77,781.83 kB 14 51,892.75 kB 107,237.50 kB 15 86,284.17 kB 145,810.33 kB 16 77,053.58 kB 126,201.83 kB 17 36,262.25 kB 94,595.25 kB 18 1,021.00 kB 52,576.17 kB 19 66.67 kB 32,405.67 kB 20 9,309.00 kB 25,996.00 kB 21 1,139.90 kB 14,204.60 kB 22 1,445.29 kB 6,506.00 kB 23 8,776.75 kB 18,369.75 kB -
Temporary Files
Size of temporary files
Key values
- 463.09 MiB Temp Files size Peak
- 2026-06-23 05:31:53 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-23 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.05 GiB 107.11 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 3 312.00 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 4 416.00 MiB 104.00 MiB 13 1 104.00 MiB 104.00 MiB 14 1 104.00 MiB 104.00 MiB 15 1 104.00 MiB 104.00 MiB 16 3 312.00 MiB 104.00 MiB 17 3 312.00 MiB 104.00 MiB 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 19 1.93 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025995, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 09:44:56 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026020, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 14:42:58 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026014, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 12:03:39 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 8 893.92 MiB 69.06 MiB 231.55 MiB 111.74 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-23 05:32:02 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-23 05:31:53 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 177.20 MiB 88.60 MiB 88.60 MiB 88.60 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-23 05:30:40 Duration: 38s377ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-23 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 231.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-23 05:31:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 231.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-23 05:31:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-23 17:19:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 17:23:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 09:54:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 16:18:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 16:30:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 16:24:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 12:18:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 13:53:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 14:39:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 15:20:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 12:04:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 08:19:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 11:22:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 10:09:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 09:35:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 17:07:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 12:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-23 09:08:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 29.14 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-23 12:30:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 29.14 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-23 12:30:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 1,106 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.pg_catalog.pg_class 64 rio.pg_catalog.pg_type 56 rio.public.usuarios 49 brasilia.pg_catalog.pg_attribute 45 rio.pg_catalog.pg_index 35 rio.public.temp0000283282 33 contagem.pg_catalog.pg_attribute 31 rio.pg_catalog.pg_depend 29 rio.public.temp0000283380 28 brasilia.pg_catalog.pg_class 26 rio.public.temp0000283300 26 rio.public.temp0000283286 24 brasilia.pg_catalog.pg_type 22 contagem.pg_catalog.pg_class 21 brasilia.auditor.auditor_2026_06 21 contagem.public.usuarios 20 rio.public.temp0000283382 18 rio.public.temp0000283316 18 rio.public.temp0000283392 18 contagem.pg_catalog.pg_type 17 rio.public.temp0000283368 16 brasilia.pg_catalog.pg_index 16 rio.public.temp0000283318 16 contagem.public.temp0000226464 15 rio.public.temp0000283374 15 rio.public.temp0000283338 15 rio.public.temp0000283302 13 brasilia.pg_catalog.pg_depend 13 rio.public.temp0000283344 12 rio.public.temp0000283288 10 contagem.pg_catalog.pg_index 10 contagem.public.temp0000226480 10 brasilia.public.usuarios 9 rio.public.temp0000283334 9 rio.public.temp0000283102 9 rio.public.temp0000283178 9 rio.public.temp0000283296 9 rio.public.tmp_drill_0302 8 contagem.pg_catalog.pg_depend 8 brasilia.public.temp0000234420 8 rio.public.temp0000283204 8 brasilia.public.temp0000234438 8 rio.public.temp0000283312 7 rio.public.temp0000283310 7 rio.public.temp0000283290 7 template1.pg_catalog.pg_shdepend 6 contagem.public.nf_entrada 6 rio.public.temp0000282858 5 brasilia.public.temp0000234442 5 brasilia.public.temp0000234400 5 rio.public.temp0000283376 5 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000283272 4 brasilia.public.temp0000234366 4 rio.public.tmp_drill_0175 4 brasilia.public.nf_entrada 4 rio.public.temp0000283356 4 rio.public.temp0000281789 3 rio.public.temp0000283366 3 rio.public.temp0000283284 3 rio.public.temp0000283198 3 rio.public.temp0000283180 3 brasilia.public.temp0000234362 3 brasilia.public.temp0000234370 2 brasilia.public.temp0000234382 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000283304 2 brasilia.public.temp0000234424 2 postgres.pg_catalog.pg_shdepend 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000234368 2 rio.public.temp0000283276 2 brasilia.public.temp0000234398 2 brasilia.public.temp0000234386 2 contagem.public.temp0000226466 1 rio.public.temp0000283372 1 brasilia.public.temp0000234452 1 rio.public.temp0000283308 1 rio.public.temp0000283278 1 brasilia.public.temp0000234396 1 contagem.public.temp0000226470 1 brasilia.public.temp0000234418 1 rio.public.temp0000283358 1 rio.public.temp0000283330 1 rio.public.temp0000283294 1 rio.public.temp0000283352 1 brasilia.public.temp0000234358 1 rio.public.temp0000283390 1 rio.public.temp0000283298 1 rio.public.temp0000283306 1 brasilia.public.temp0000234414 1 rio.public.temp0000283386 1 brasilia.public.temp0000234410 1 rio.public.temp0000283408 1 brasilia.public.temp0000234448 1 Total 1,106 Vacuums per table
Key values
- pg_catalog.pg_attribute (44) Main table vacuumed on database rio
- 528 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 44 42 0 0 0 0 0 22,733 6,593 9,558,224 420 11,063 rio.public.temp0000283282 33 0 0 0 0 0 0 32,639 1,818 4,128,712 0 0 rio.pg_catalog.pg_class 27 27 0 0 0 0 0 5,353 1,927 2,674,994 103 411 rio.pg_catalog.pg_type 22 22 0 0 0 0 0 2,105 601 777,028 75 313 brasilia.pg_catalog.pg_attribute 20 18 0 0 0 0 0 8,795 1,932 3,503,604 67 1,949 contagem.public.usuarios 19 0 0 0 0 0 0 89 72 36,140 2 2 rio.public.usuarios 18 5 0 0 0 0 0 170 61 123,393 13 30 rio.public.temp0000283382 18 0 0 0 0 0 0 21,228 166 1,432,682 0 0 rio.public.temp0000283318 15 0 0 0 0 0 0 12,792 53 763,318 0 0 rio.public.temp0000283374 15 0 0 0 0 0 0 14,403 1,649 2,893,908 0 0 brasilia.pg_catalog.pg_class 15 13 0 0 0 0 0 2,377 520 1,015,421 31 575 rio.public.temp0000283300 15 0 0 0 0 0 0 1,987 67 127,753 0 0 rio.pg_catalog.pg_index 15 15 0 0 0 0 0 1,067 254 223,195 53 138 rio.public.temp0000283380 14 0 0 0 0 0 0 2,529 71 160,792 0 0 brasilia.pg_catalog.pg_type 12 10 0 0 0 0 0 654 126 242,626 14 128 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,694 1,725 3,105,054 33 862 rio.public.tmp_drill_0175 11 3 0 0 0 0 0 114 30 47,733 1 52 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 4,122 1,560 2,119,873 94 829 brasilia.auditor.auditor_2026_06 11 0 0 0 0 0 0 12,817 7,086 8,913,969 2,120 40,555 brasilia.pg_catalog.pg_index 10 8 0 0 0 0 0 369 91 108,598 13 99 contagem.public.temp0000226480 10 0 0 0 0 0 0 883 59 61,376 0 0 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,552 2,306 10,311,953 1,005 4,281 rio.public.temp0000283102 9 0 0 0 0 0 0 848 47 57,728 0 0 rio.public.temp0000283334 8 0 0 0 0 0 0 9,658 1,626 2,606,106 0 0 rio.public.temp0000283204 8 0 0 0 0 0 0 543 43 38,750 0 0 rio.public.tmp_drill_0302 8 8 0 0 0 0 0 10,673 24 1,766,940 0 0 rio.public.temp0000283178 8 0 0 0 0 0 0 828 164 258,142 0 0 rio.public.temp0000283310 7 0 0 0 0 0 0 28 21 5,418 0 0 rio.public.temp0000283316 7 0 0 0 0 0 0 4,808 1,618 2,321,374 0 0 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 723 156 256,447 5 12 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,341 278 447,601 6 21 brasilia.public.temp0000234438 6 0 0 0 0 0 0 1,412 266 448,853 0 0 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,189 370 543,589 17 372 contagem.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 584 207 371,758 27 79 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 262 93 67,180 6 11 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,325 355 736,284 8 42 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,216 488 2,830,436 140 508 rio.public.temp0000283356 4 0 0 0 0 0 0 4,795 15 285,252 0 0 rio.public.temp0000282858 3 0 0 0 0 0 0 324 167 285,392 0 0 rio.public.temp0000283180 3 0 0 0 0 0 0 240 18 16,801 0 0 rio.public.temp0000283312 3 0 0 0 0 0 0 3,202 13 190,937 0 0 template1.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 357 154 281,128 74 4,373 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 246 49 239,369 13 52 rio.public.temp0000283392 2 0 0 0 0 0 0 152 9 10,497 0 0 rio.public.temp0000283302 2 0 0 0 0 0 0 80 9 6,152 0 0 rio.public.temp0000283198 2 0 0 0 0 0 0 185 12 12,749 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,797 456 2,008,057 285 2,742 rio.public.temp0000283338 1 0 0 0 0 0 0 8 5 1,289 0 0 rio.public.temp0000283306 1 0 0 0 0 0 0 76 74 138,312 0 0 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 145,553 81,213 108,431,185 32,048 696,246 rio.public.temp0000283376 1 0 0 0 0 0 0 8 5 1,304 0 0 rio.public.temp0000283304 1 0 0 0 0 0 0 76 6 5,376 0 0 brasilia.public.fluxos 1 0 0 0 0 0 0 20 13 23,421 5 170 brasilia.public.temp0000234410 1 0 0 0 0 0 0 8 5 1,522 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 23 12 38,110 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 106 45 74,102 3 5 rio.public.temp0000283408 1 0 0 0 0 0 0 158 6 10,342 0 0 brasilia.public.giga_testes 1 0 0 0 0 0 0 119 104 259,474 4 64 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 145 18 69,111 9 20 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 112 39 73,962 4 6 rio.pg_toast.pg_toast_362317 1 0 0 0 0 0 0 628 213 1,479,455 208 996 rio.public.temp0000283330 1 0 0 0 0 0 0 1,595 4 94,708 0 0 rio.public.temp0000283352 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.rs_mv_codigos_barra 1 1 0 0 0 0 0 4,698 888 4,132,246 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,358 46 285,055 33 294 contagem.public.parametros 1 1 0 0 0 0 0 107 56 38,154 1 1 rio.public.temp0000281789 1 0 0 0 0 0 0 101 6 6,886 0 0 rio.pg_catalog.pg_constraint 1 1 0 0 0 0 0 21 11 27,165 0 0 rio.public.temp0000283366 1 0 0 0 0 0 0 8 5 1,341 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 21,174 20,280 25,538,466 12 104 rio.public.rs_mv_equipamentos 1 1 0 0 0 0 0 3,656 795 3,588,330 0 0 rio.public.temp0000283308 1 0 0 0 0 0 0 8 5 1,283 0 0 rio.public.logs 1 0 0 0 0 0 0 1,479 1,173 1,430,927 153 3,811 Total 528 257 0 0 0 0 0 396,537 140,455 214,175,586 37,105 771,216 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (29.14) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.46 rio.public.temp0000283282 0 0 1.18 rio.pg_catalog.pg_class 0 0 0.92 rio.pg_catalog.pg_type 0 0 0.34 brasilia.pg_catalog.pg_attribute 0 0 1.28 contagem.public.usuarios 0 0 0 rio.public.usuarios 0 0 0 rio.public.temp0000283382 0 0 0.67 rio.public.temp0000283318 0 0 0.73 rio.public.temp0000283374 0 0 0.74 brasilia.pg_catalog.pg_class 0 0 0.37 rio.public.temp0000283300 0 0 0.25 rio.pg_catalog.pg_index 0 0 0.18 rio.public.temp0000283380 0 0 0.26 brasilia.pg_catalog.pg_type 0 0 0.09 contagem.pg_catalog.pg_attribute 0 0 1.24 rio.public.tmp_drill_0175 0 0 0.03 rio.pg_catalog.pg_depend 0 0 0.9 brasilia.auditor.auditor_2026_06 0 0 2.03 brasilia.pg_catalog.pg_index 0 0 0 contagem.public.temp0000226480 0 0 0.16 rio.pg_catalog.pg_statistic 0 0 1.91 rio.public.temp0000283102 0 0 0.12 rio.public.temp0000283334 0 0 0.37 rio.public.temp0000283204 0 0 0.09 rio.public.tmp_drill_0302 0 0 0.4 rio.public.temp0000283178 0 0 0.14 rio.public.temp0000283310 0 0 0.29 rio.public.temp0000283316 0 0 0.35 contagem.pg_catalog.pg_type 0 0 0.16 contagem.pg_catalog.pg_class 0 0 0.43 brasilia.public.temp0000234438 0 0 0.11 brasilia.pg_catalog.pg_depend 0 0 0.3 contagem.pg_catalog.pg_shdepend 0 0 0.29 contagem.pg_catalog.pg_index 0 0 0.06 contagem.pg_catalog.pg_depend 0 0 0.25 rio.pg_toast.pg_toast_2619 0 0 0.35 rio.public.temp0000283356 0 0 0.19 rio.public.temp0000282858 0 0 0.05 rio.public.temp0000283180 0 0 0.04 rio.public.temp0000283312 0 0 0.49 template1.pg_catalog.pg_shdepend 0 0 0.38 brasilia.pg_toast.pg_toast_2619 0 0 0.06 rio.public.temp0000283392 0 0 0.02 rio.public.temp0000283302 0 0 0.06 rio.public.temp0000283198 0 0 0.03 brasilia.pg_catalog.pg_statistic 0 0 0.28 rio.public.temp0000283338 0 0 0.01 rio.public.temp0000283306 0 0 0.02 rio.auditor.auditor_2026_06 0 0 29.14 rio.public.temp0000283376 0 0 0.01 rio.public.temp0000283304 0 0 0.01 brasilia.public.fluxos 0 0 0.07 brasilia.public.temp0000234410 0 0 0.02 brasilia.public.nf_entrada_arquivo_erros 0 0 0 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000283408 0 0 0.02 brasilia.public.giga_testes 0 0 0.12 contagem.pg_toast.pg_toast_2619 0 0 0 postgres.pg_catalog.pg_shdepend 0 0 0.05 rio.pg_toast.pg_toast_362317 0 0 0.09 rio.public.temp0000283330 0 0 0.05 rio.public.temp0000283352 0 0 0.04 rio.public.rs_mv_codigos_barra 0 0 1.43 contagem.pg_catalog.pg_statistic 0 0 0.08 contagem.public.parametros 0 0 0.01 rio.public.temp0000281789 0 0 0.01 rio.pg_catalog.pg_constraint 0 0 0.03 rio.public.temp0000283366 0 0 0.02 contagem.auditor.auditor_2026_06 0 0 5.71 rio.public.rs_mv_equipamentos 0 0 0.95 rio.public.temp0000283308 0 0 0 rio.public.logs 0 0 0.53 Total 0 0 60.5 Tuples removed per table
Key values
- pg_catalog.pg_attribute (165906) Main table with removed tuples on database rio
- 562037 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 44 42 165,906 1,089,007 43,023 100 26,062 rio.public.tmp_drill_0302 8 8 160,810 163,517 0 0 4,108 brasilia.pg_catalog.pg_attribute 20 18 87,864 453,844 36,686 35 12,060 contagem.pg_catalog.pg_attribute 11 11 50,913 262,974 256 189 6,031 rio.pg_catalog.pg_statistic 9 9 15,795 76,859 330 0 11,574 rio.pg_catalog.pg_depend 11 11 9,971 212,136 2,554 0 2,062 rio.pg_catalog.pg_type 22 22 8,045 51,624 1,306 25 1,549 rio.public.rs_mv_codigos_barra 1 1 6,454 3,948,645 0 0 26,202 brasilia.pg_catalog.pg_statistic 2 2 5,024 16,895 0 0 2,102 rio.public.rs_mv_equipamentos 1 1 4,954 2,015,547 0 0 8,941 brasilia.pg_catalog.pg_depend 6 6 4,751 104,799 5,509 15 1,074 brasilia.pg_catalog.pg_type 12 10 4,512 23,583 3,588 4 875 contagem.pg_catalog.pg_statistic 1 1 4,106 7,274 0 0 1,011 rio.pg_catalog.pg_index 15 15 4,099 29,419 513 0 930 rio.pg_catalog.pg_class 27 27 3,971 99,020 4,718 40 3,323 brasilia.pg_catalog.pg_class 15 13 3,295 53,714 8,962 0 1,950 contagem.pg_catalog.pg_shdepend 6 6 2,837 77,293 922 0 661 rio.auditor.auditor_2026_06 1 0 2,693 17,582,343 0 0 826,800 brasilia.pg_catalog.pg_index 10 8 2,514 18,892 1,797 0 544 contagem.pg_catalog.pg_type 7 7 2,440 15,787 20 13 456 contagem.pg_catalog.pg_depend 5 5 1,638 95,839 64 0 851 contagem.pg_catalog.pg_class 7 7 1,349 23,460 48 12 799 contagem.pg_catalog.pg_index 5 5 1,310 9,491 0 0 268 rio.pg_toast.pg_toast_2619 4 4 1,223 3,267 0 0 1,064 rio.public.tmp_drill_0175 11 3 1,201 52,897 25,848 0 688 contagem.public.usuarios 19 0 1,157 437 0 0 38 brasilia.auditor.auditor_2026_06 11 0 634 873,142 0 0 41,145 contagem.auditor.auditor_2026_06 1 0 552 2,820,307 0 0 123,863 postgres.pg_catalog.pg_shdepend 1 1 544 12,922 2 0 111 rio.public.usuarios 18 5 416 12,043 2,917 0 306 contagem.public.nf_entrada 1 1 341 1,293 0 0 69 template1.pg_catalog.pg_shdepend 3 3 291 40,277 181 0 316 brasilia.pg_toast.pg_toast_2619 2 2 142 273 0 34 74 contagem.pg_toast.pg_toast_2619 1 1 108 117 0 0 54 brasilia.public.giga_testes 1 0 91 673,492 0 0 17,508 brasilia.public.fluxos 1 0 69 1,139,563 0 0 13,631 contagem.public.parametros 1 1 13 382 0 0 50 rio.pg_catalog.pg_constraint 1 1 4 1,372 0 0 37 rio.public.temp0000282858 3 0 0 16,191 0 89 359 rio.public.temp0000283338 1 0 0 1,502 0 58 70 rio.public.temp0000283306 1 0 0 1,474 0 60 68 rio.public.temp0000283310 7 0 0 157,144 0 0 11,200 rio.public.temp0000283380 14 0 0 109,093 0 482 5,982 rio.public.temp0000283316 7 0 0 157,190 0 0 11,200 rio.public.temp0000283334 8 0 0 158,665 0 58 11,270 rio.public.temp0000283204 8 0 0 32,589 0 175 721 rio.public.temp0000283180 3 0 0 9,780 0 40 216 rio.public.temp0000283376 1 0 0 1,694 0 49 79 rio.public.temp0000283304 1 0 0 1,474 0 60 68 brasilia.public.temp0000234410 1 0 0 3,023 0 29 227 rio.public.temp0000283312 3 0 0 46,398 0 60 3,268 brasilia.public.nf_entrada_arquivo_erros 1 0 0 1,628,530 0 0 29,083 brasilia.public.temp0000234438 6 0 0 18,154 0 174 1,362 rio.public.temp0000283408 1 0 0 6,759 0 42 150 rio.public.temp0000283356 4 0 0 89,840 0 0 6,400 rio.public.temp0000283318 15 0 0 336,673 0 0 24,000 rio.public.temp0000283282 33 0 0 510,659 0 620 35,988 rio.public.temp0000283392 2 0 0 11,996 0 52 268 rio.pg_toast.pg_toast_362317 1 0 0 1,002 0 0 209 rio.public.temp0000283302 2 0 0 23,934 0 60 1,668 rio.public.temp0000283330 1 0 0 22,442 0 0 1,600 rio.public.temp0000283352 1 0 0 22,458 0 0 1,600 rio.public.temp0000283102 9 0 0 48,215 0 332 1,076 rio.public.temp0000283198 2 0 0 5,872 0 87 169 rio.public.temp0000283382 18 0 0 301,021 0 218 21,222 rio.public.temp0000283374 15 0 0 337,065 0 0 24,000 rio.public.temp0000283178 8 0 0 37,681 0 253 835 rio.public.temp0000281789 1 0 0 4,231 0 35 93 rio.public.temp0000283300 15 0 0 111,407 0 362 7,062 contagem.public.temp0000226480 10 0 0 11,608 0 390 890 rio.public.temp0000283366 1 0 0 5,138 0 14 114 rio.public.temp0000283308 1 0 0 1,476 0 60 68 rio.public.logs 1 0 0 15,949,522 0 0 637,216 Total 528 257 562,037 52,245,646 139,244 4,326 1,978,988 Pages removed per table
Key values
- public.temp0000283282 (620) Main table with removed pages on database rio
- 4326 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283282 33 0 0 620 rio.public.temp0000283380 14 0 0 482 contagem.public.temp0000226480 10 0 0 390 rio.public.temp0000283300 15 0 0 362 rio.public.temp0000283102 9 0 0 332 rio.public.temp0000283178 8 0 0 253 rio.public.temp0000283382 18 0 0 218 contagem.pg_catalog.pg_attribute 11 11 50913 189 rio.public.temp0000283204 8 0 0 175 brasilia.public.temp0000234438 6 0 0 174 rio.pg_catalog.pg_attribute 44 42 165906 100 rio.public.temp0000282858 3 0 0 89 rio.public.temp0000283198 2 0 0 87 rio.public.temp0000283306 1 0 0 60 rio.public.temp0000283304 1 0 0 60 rio.public.temp0000283312 3 0 0 60 rio.public.temp0000283302 2 0 0 60 rio.public.temp0000283308 1 0 0 60 rio.public.temp0000283338 1 0 0 58 rio.public.temp0000283334 8 0 0 58 rio.public.temp0000283392 2 0 0 52 rio.public.temp0000283376 1 0 0 49 rio.public.temp0000283408 1 0 0 42 rio.public.temp0000283180 3 0 0 40 rio.pg_catalog.pg_class 27 27 3971 40 rio.public.temp0000281789 1 0 0 35 brasilia.pg_catalog.pg_attribute 20 18 87864 35 brasilia.pg_toast.pg_toast_2619 2 2 142 34 brasilia.public.temp0000234410 1 0 0 29 rio.pg_catalog.pg_type 22 22 8045 25 brasilia.pg_catalog.pg_depend 6 6 4751 15 rio.public.temp0000283366 1 0 0 14 contagem.pg_catalog.pg_type 7 7 2440 13 contagem.pg_catalog.pg_class 7 7 1349 12 brasilia.pg_catalog.pg_type 12 10 4512 4 rio.public.temp0000283310 7 0 0 0 rio.public.tmp_drill_0175 11 3 1201 0 rio.public.temp0000283316 7 0 0 0 rio.pg_catalog.pg_statistic 9 9 15795 0 rio.public.tmp_drill_0302 8 8 160810 0 contagem.public.usuarios 19 0 1157 0 rio.auditor.auditor_2026_06 1 0 2693 0 brasilia.public.fluxos 1 0 69 0 rio.pg_toast.pg_toast_2619 4 4 1223 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 contagem.public.nf_entrada 1 1 341 0 brasilia.public.giga_testes 1 0 91 0 rio.public.temp0000283356 4 0 0 0 brasilia.pg_catalog.pg_index 10 8 2514 0 contagem.pg_toast.pg_toast_2619 1 1 108 0 rio.public.temp0000283318 15 0 0 0 postgres.pg_catalog.pg_shdepend 1 1 544 0 template1.pg_catalog.pg_shdepend 3 3 291 0 rio.pg_catalog.pg_depend 11 11 9971 0 rio.pg_toast.pg_toast_362317 1 0 0 0 contagem.pg_catalog.pg_index 5 5 1310 0 rio.public.temp0000283330 1 0 0 0 rio.public.temp0000283352 1 0 0 0 brasilia.auditor.auditor_2026_06 11 0 634 0 rio.public.usuarios 18 5 416 0 rio.public.rs_mv_codigos_barra 1 1 6454 0 contagem.pg_catalog.pg_statistic 1 1 4106 0 contagem.pg_catalog.pg_shdepend 6 6 2837 0 rio.public.temp0000283374 15 0 0 0 contagem.public.parametros 1 1 13 0 brasilia.pg_catalog.pg_class 15 13 3295 0 contagem.pg_catalog.pg_depend 5 5 1638 0 rio.pg_catalog.pg_constraint 1 1 4 0 contagem.auditor.auditor_2026_06 1 0 552 0 rio.public.rs_mv_equipamentos 1 1 4954 0 brasilia.pg_catalog.pg_statistic 2 2 5024 0 rio.public.logs 1 0 0 0 rio.pg_catalog.pg_index 15 15 4099 0 Total 528 257 562,037 4,326 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 23 00 2 1 01 0 0 02 0 0 03 0 0 04 0 2 05 8 5 06 0 1 07 13 27 08 55 113 09 64 117 10 53 133 11 37 91 12 24 45 13 23 54 14 49 102 15 72 165 16 90 148 17 37 95 18 0 0 19 0 0 20 0 0 21 1 7 22 0 0 23 0 0 - 29.14 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 4m26s 4m26s 4m26s 4m26s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 09:09:49 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 00:05:43 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 13:15:11 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 4m26s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-23 09:09:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 5,143 Total read queries
- 1,734 Total write queries
Queries by database
Key values
- rio Main database
- 5,147 Requests
- 8h27m14s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,249 Requests
User Request type Count Duration etiquetas Total 26 5s696ms select 26 5s696ms intelifix Total 7,249 10h30m37s copy to 413 45m48s ddl 1,321 1h3m15s others 512 50m11s select 5,002 7h51m22s lenon Total 115 1m44s select 115 1m44s Duration by user
Key values
- 10h30m37s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 26 5s696ms select 26 5s696ms intelifix Total 7,249 10h30m37s copy to 413 45m48s ddl 1,321 1h3m15s others 512 50m11s select 5,002 7h51m22s lenon Total 115 1m44s select 115 1m44s Queries by host
Key values
- [local] Main host
- 7,390 Requests
- 10h32m28s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,196 Requests
- 5h2m1s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-23 10:37:17 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,745 100-500ms duration
Slowest individual queries
Rank Duration Query 1 15m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 09:20:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 10:16:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 11m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 07:16:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 12:15:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 10m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 14:15:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 10m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 15:15:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 9m10s analyze verbose;[ Date: 2026-06-23 05:09:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 11:14:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 16:12:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 18:12:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 17:12:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 20:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 13:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025995, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-23 09:44:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 08:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 22:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m2s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026020, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-23 14:42:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-23 21:10:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026014, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-23 12:03:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026025, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-23 15:24:37 - 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 2h35m56s 304 151ms 6m53s 30s779ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 23 06 1 6s598ms 6s598ms 07 14 16m57s 1m12s 08 42 19m49s 28s324ms 09 36 21m18s 35s526ms 10 23 14m38s 38s188ms 11 27 6m51s 15s237ms 12 16 10m24s 39s50ms 13 21 8m25s 24s83ms 14 27 9m25s 20s952ms 15 44 22m14s 30s334ms 16 24 13m30s 33s771ms 17 28 12m11s 26s114ms 18 1 1s518ms 1s518ms [ User: intelifix - Total duration: 2h35m56s - Times executed: 304 ]
[ Application: [unknown] - Total duration: 2h35m56s - Times executed: 304 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025995, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 09:44:56 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026020, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 14:42:58 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026014, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 12:03:39 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h27m8s 48 1s292ms 15m28s 3m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 23 07 3 11m58s 3m59s 08 3 6m43s 2m14s 09 3 16m12s 5m24s 10 3 12m3s 4m1s 11 3 9m31s 3m10s 12 3 11m11s 3m43s 13 3 7m16s 2m25s 14 3 11m14s 3m44s 15 3 10m45s 3m35s 16 3 8m15s 2m45s 17 3 7m56s 2m38s 18 3 8m6s 2m42s 19 3 6m 2m 20 3 7m15s 2m25s 21 3 6m11s 2m3s 22 3 6m26s 2m8s [ User: intelifix - Total duration: 2h27m8s - Times executed: 48 ]
[ Application: psql - Total duration: 2h27m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-23 09:20:30 Duration: 15m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-23 10:16:25 Duration: 11m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-23 07:16:07 Duration: 11m5s Database: rio User: intelifix Remote: [local] Application: psql
3 1h14m27s 48 214ms 4m31s 1m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 23 07 3 5m34s 1m51s 08 3 3m54s 1m18s 09 3 5m54s 1m58s 10 3 5m9s 1m43s 11 3 5m13s 1m44s 12 3 4m41s 1m33s 13 3 3m54s 1m18s 14 3 5m31s 1m50s 15 3 5m37s 1m52s 16 3 4m32s 1m30s 17 3 4m30s 1m30s 18 3 4m43s 1m34s 19 3 3m30s 1m10s 20 3 4m31s 1m30s 21 3 3m27s 1m9s 22 3 3m39s 1m13s [ User: intelifix - Total duration: 1h14m27s - Times executed: 48 ]
[ Application: psql - Total duration: 1h14m27s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-23 09:27:00 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-23 15:21:17 Duration: 4m22s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-23 14:21:43 Duration: 4m17s Database: brasilia User: intelifix Remote: [local] Application: psql
4 31m42s 1,474 151ms 7s272ms 1s290ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 23 07 1 2s182ms 2s182ms 08 136 2m28s 1s90ms 09 202 3m57s 1s177ms 10 263 5m1s 1s145ms 11 194 4m4s 1s258ms 12 32 41s847ms 1s307ms 13 104 2m16s 1s316ms 14 124 3m41s 1s790ms 15 200 4m45s 1s428ms 16 135 3m15s 1s451ms 17 83 1m25s 1s35ms [ User: intelifix - Total duration: 31m42s - Times executed: 1474 ]
[ Application: [unknown] - Total duration: 31m42s - Times executed: 1474 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257302, 504, '518218069706,2C9569F5847B,BC644BD28668,A89FECC584D6,2C584F33F231,5819F843FEED,A8F5DDE63802,F8F532598FD9,A8F5DDE8783D,2C584F368302,4C12653E4D07,2C9569F2C155,5819F8460D32,4C1265E77F76,5819F8415DB9,B0DAF9514D89,5819F8463046,BC644BDEBE9C,2C584F34096F,A8F5DDED20F4,4C1265E448CE,BC644BCB28EB,BC644BDF084D,2C584F33BF9B,F8F5325682C6,F8F53256ABED,B0DAF94EF14C,2C9569EF4C55,BC644BD9C6CB,B0DAF963C056,B0935BEC38C3,2C584F2E8DA0,2C584F38416A,BC644BE4F1CC,CC75E2BCB34E,F8F5325A5635,BC644BCDADAA', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 14:58:07 Duration: 7s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257307, 450, 'F200012189B4E7F,1834AF24E293$F200011084B89EB,9877E74C274B$F200012312B2038,1834AF619B36$F200011334B8D91,8401128498C3$F200012073B5D4E,840112DCE59E$F200011330B2DE2,84011284146B$F200012256B009C,1834AF287BD0$F200011175B7F31,9877E7BF790D$F200011168B1AA1,9877E7BD9C1F$F200012192B1683,1834AF24FEF5$F200012188B0D1E,1834AF248F96$F200012311B8FF0,1834AF618BE6$F200010254B68D4,743AEF9A4B3F$F200013234B654C,1834AF9A3B00$F200011016B4DE6,9877E7098069$F200010150104FD,743AEF33CD3A$F200010273B05D0,743AEF9C711A$F200012187B7294,1834AF2480C4$F200012069B135F,840112DBDD96$F200011064B1DC5,9877E747ED23$F200011314B7BD6,84011280CE7F$F200011307B1CD8,840112804EFE$F2000102051665B,743AEF771EB4$F200011133B8C65,9877E7BA4DD5$F200012018B8B11,840112BD39F0$F200010356B9D87,9877E706C7AA$F200011307B1A97,840112804E02$F200011131B50E2,9877E7B9B461$F200010336E1E84,9877E700648A$F200011018B55EE,9877E709B38B$F200012074B30C8,840112DD1F65$F200010233B09DD,743AEF73127C$F200012062B0BAA,840112C2D647$F200010284B58EA,743AEFAD79C6$F200011057EC0E3,9877E74E2CB8$F200012311B5896,1834AF6173AC$F200011239B264C,8401122A795C$F200012073B4724,840112DCDBF0$F200011302B027F,8401128005C4', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 15:01:04 Duration: 7s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257307, 450, 'F200011055BC2F2,9877E74D72F2$F200011056B768D,9877E74DAE02$F200012028B18F9,840112BF8502$F200012152B3DB5,840112EB1410$F200012054B61A6,840112C122E9$F200012308B325D,1834AF612842$F200011013EA0EF,9877E708DA37$F200011131B09AF,9877E7B99535$F200010295E747C,743AEFAFBA7B$F200012192B13EC,1834AF24FDCF$F200011105B3373,9877E77C53B3$F200012308B66FB,1834AF613F48$F200012312B37B4,1834AF61A57E$F200010284B94B8,743AEFAD93F1$F200012308B660F,1834AF613EDF$F200011246B5B3C,840112374885$F20001017516312,743AEF5F532F$F200011308B5541,840112809138$F200012312B12B7,1834AF61954E$F20001020617E6E,743AEF70CECC$F200012189B2C50,1834AF24D3A5$F200011151B144E,9877E7BC8059$F200010290B829E,743AEFAEF16C$F200011203B9F44,8401120661D7$F200012192B4BCF,1834AF251641$F200011308B34B6,8401128082F9$F200011120B3AFA,9877E7B894F1$F200012189B2BFA,1834AF24D37B$F200013244B10C0,1834AF9B702D$F200011278B3E42,8401125EBCB1$F200013244B2E9E,1834AF9B7D38$F200011230B561A,84011229757C$F200011177B63C4,9877E7BFFCBD$F200011350B440F,84011294423A$F200012122B2250,840112E9071E$F200012258B1CA8,1834AF28BCA5$F200012188B0CA7,1834AF248F65$F200012349B082B,1834AF638066$F200011211B6B9E,84011207F53E$F200010336B9C5C,9877E7009B95', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 15:44:52 Duration: 7s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 25m35s 126 1s415ms 1m49s 12s183ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 23 07 3 20s699ms 6s899ms 08 9 2m36s 17s413ms 09 4 2m43s 40s754ms 10 4 1m22s 20s644ms 11 8 2m22s 17s821ms 12 10 43s574ms 4s357ms 13 4 1m39s 24s873ms 14 10 2m37s 15s770ms 15 24 4m19s 10s801ms 16 17 2m24s 8s518ms 17 33 4m24s 8s20ms [ User: intelifix - Total duration: 25m35s - Times executed: 126 ]
[ Application: [unknown] - Total duration: 25m35s - Times executed: 126 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 09:29:02 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0320, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 08:19:05 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 13:14:26 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 16m33s 3 2m20s 9m10s 5m31s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 23 05 3 16m33s 5m31s [ User: intelifix - Total duration: 16m33s - Times executed: 3 ]
[ Application: psql - Total duration: 16m33s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-23 05:09:11 Duration: 9m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-23 05:14:13 Duration: 5m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-23 05:16:34 Duration: 2m20s Database: contagem User: intelifix Remote: [local] Application: psql
7 14m42s 79 8s364ms 55s278ms 11s172ms create table temp0000283282 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 23 07 20 3m51s 11s573ms 08 22 3m46s 10s308ms 09 15 3m 12s38ms 10 14 2m33s 10s941ms 11 8 1m30s 11s320ms [ User: intelifix - Total duration: 14m42s - Times executed: 79 ]
[ Application: [unknown] - Total duration: 14m42s - Times executed: 79 ]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 07:01:33 Duration: 55s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:02:37 Duration: 14s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 08:46:18 Duration: 13s608ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 14m4s 156 310ms 26s699ms 5s416ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 23 00 6 42s70ms 7s11ms 01 6 17s36ms 2s839ms 02 5 13s229ms 2s645ms 03 5 19s60ms 3s812ms 04 6 14s936ms 2s489ms 05 6 21s912ms 3s652ms 06 1 2s997ms 2s997ms 07 12 1m15s 6s262ms 08 12 1m21s 6s771ms 09 12 1m40s 8s405ms 10 12 1m18s 6s504ms 11 12 1m18s 6s521ms 12 8 58s261ms 7s282ms 13 9 19s377ms 2s153ms 14 12 1m19s 6s626ms 15 12 1m23s 6s926ms 16 10 44s436ms 4s443ms 21 5 7s505ms 1s501ms 22 5 7s894ms 1s578ms [ User: intelifix - Total duration: 14m4s - Times executed: 156 ]
[ Application: psql - Total duration: 14m4s - Times executed: 156 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 00:05:28 Duration: 26s699ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 14:35:21 Duration: 19s668ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 15:25:18 Duration: 17s298ms Database: rio User: intelifix Remote: [local] Application: psql
9 13m28s 1,253 150ms 4s115ms 645ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 23 07 3 8s44ms 2s681ms 08 108 1m36s 890ms 09 136 1m47s 792ms 10 166 1m32s 559ms 11 148 1m29s 606ms 12 18 13s262ms 736ms 13 117 1m9s 590ms 14 191 1m52s 587ms 15 189 1m53s 598ms 16 116 1m5s 566ms 17 61 40s782ms 668ms [ User: intelifix - Total duration: 13m28s - Times executed: 1253 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 1253 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257084", "modelo" : "320", "itens" : "241631419806,241658782230,241711198186,241649594251,241616725364,241660478096,241660796466,241630216871,241635780816,241646180720,241604272331,241649867891,241606126978,241637624856,241709607582,241614909407,241604209697,241635974246,241606022951,241666181830,241651167782,241653180000,241669522021,241674050118,241634538304,241630084053,241678325158,241664123346,241661164359,241654972240,241656361534,241603343037,241618348496,241689462643,241593863133,241603270000,241679151940,241615666787,241677280725,241651186370,241655471840,230048071919,241604209394,241646190317,241620344752,241638238080,241615894565,241646614858", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 07:56:48 Duration: 4s115ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257152", "modelo" : "320", "itens" : "241689430721,241603558085,241710884060,241666204155,241634792526,241701419511,241621273440,241691191016,241715461432,241630979101,241619465564,241677466679,241628261429,241716442728,241669585562,241690088191,241600847787,241607439294,241666070506,241619215764,241608089920,241645780524,241632286669,241709309797,241607985970,241617566770,241604961119,241652402842,241620615059,241698621124,241619773148,241654408794,241666047798,241595461415,241671573355,241622685059,241631633542,241614911630,241655584151,241712137380,241706743252,241651773353,241638029496,241652050002,230040121323,241706429607,241663327981,241647073040", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 09:12:44 Duration: 3s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257152", "modelo" : "320", "itens" : "241694389598,241712190619,241621152542,241672014565,241621185777,241694883542,241655632641,241677522847,241656924046,241714635559,241675846476,241700316687,241659988598,241628174753,241608092345,241679304154,241595539098,241732780709,241629422945,241708997792,241608091436,241608093052,241629855770,241606288890,241713060614,241677687082,241658995258,241660545151,241707087987,241707367487,241664669516,241728311631,241596627880,241628823840,241697128384,241672380415,241666738102,241654401825,241629881632,241630694853,241726781616,241607984354,241691228291,230049484346,241604680912,241618212042,241703475772,241635580415", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 09:08:06 Duration: 3s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 12m17s 266 153ms 4m31s 2s773ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 23 00 11 32s911ms 2s991ms 01 12 18s468ms 1s539ms 02 11 15s951ms 1s450ms 03 11 17s230ms 1s566ms 04 12 18s262ms 1s521ms 05 10 18s857ms 1s885ms 06 11 16s196ms 1s472ms 07 12 18s477ms 1s539ms 08 12 21s95ms 1s757ms 09 12 4m54s 24s574ms 10 12 22s263ms 1s855ms 11 12 22s219ms 1s851ms 12 12 17s450ms 1s454ms 13 12 26s312ms 2s192ms 14 12 21s98ms 1s758ms 15 12 29s387ms 2s448ms 16 12 22s623ms 1s885ms 17 12 19s831ms 1s652ms 18 12 17s190ms 1s432ms 19 12 15s708ms 1s309ms 20 10 20s725ms 2s72ms 21 10 16s7ms 1s600ms 22 12 14s518ms 1s209ms [ User: intelifix - Total duration: 12m17s - Times executed: 266 ]
[ Application: psql - Total duration: 12m17s - Times executed: 266 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 09:09:49 Duration: 4m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 00:05:43 Duration: 15s162ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 13:15:11 Duration: 10s336ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m47s 37 8s674ms 43s177ms 12s628ms create table temp0000283382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 23 14 12 2m55s 14s615ms 15 14 2m52s 12s325ms 16 11 1m59s 10s845ms [ User: intelifix - Total duration: 7m47s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 7m47s - Times executed: 37 ]
-
CREATE TABLE temp0000283382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 14:35:03 Duration: 43s177ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:16:51 Duration: 26s766ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 16:25:04 Duration: 14s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 6m9s 78 201ms 1m21s 4s740ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 23 07 7 4s86ms 583ms 08 15 7s902ms 526ms 09 12 2m13s 11s146ms 10 9 1m56s 12s974ms 11 5 5s440ms 1s88ms 12 3 4s479ms 1s493ms 13 1 3s4ms 3s4ms 14 4 3s16ms 754ms 15 13 6s199ms 476ms 16 7 1m3s 9s67ms 17 2 21s645ms 10s822ms [ User: intelifix - Total duration: 6m9s - Times executed: 78 ]
[ Application: psql - Total duration: 6m9s - Times executed: 78 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026007);
Date: 2026-06-23 10:38:15 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026000);
Date: 2026-06-23 09:56:24 Duration: 47s80ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025997);
Date: 2026-06-23 09:48:51 Duration: 45s262ms Database: rio User: intelifix Remote: [local] Application: psql
13 5m38s 30 9s82ms 14s188ms 11s286ms create table temp0000283318 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 23 08 5 56s825ms 11s365ms 09 17 3m8s 11s89ms 10 3 32s660ms 10s886ms 11 5 1m 12s116ms [ User: intelifix - Total duration: 5m38s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 5m38s - Times executed: 30 ]
-
CREATE TABLE temp0000283318 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:10:11 Duration: 14s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283318 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 11:55:42 Duration: 13s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283318 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:48:19 Duration: 13s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 5m25s 26 8s856ms 48s639ms 12s520ms create table temp0000283374 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 23 13 3 1m15s 25s138ms 14 5 59s61ms 11s812ms 15 3 34s504ms 11s501ms 16 9 1m30s 10s85ms 17 6 1m5s 10s961ms [ User: intelifix - Total duration: 5m25s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 5m25s - Times executed: 26 ]
-
CREATE TABLE temp0000283374 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 13:56:40 Duration: 48s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283374 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 13:57:12 Duration: 14s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283374 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 14:43:15 Duration: 13s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 4m8s 59 180ms 32s349ms 4s219ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 23 07 4 36s847ms 9s211ms 08 8 24s738ms 3s92ms 09 9 56s605ms 6s289ms 10 7 29s425ms 4s203ms 11 5 21s316ms 4s263ms 12 1 493ms 493ms 14 4 22s943ms 5s735ms 15 9 28s623ms 3s180ms 16 9 26s872ms 2s985ms 17 3 1s102ms 367ms [ User: intelifix - Total duration: 4m8s - Times executed: 59 ]
[ Application: psql - Total duration: 4m8s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025967);
Date: 2026-06-23 07:03:13 Duration: 32s349ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025995);
Date: 2026-06-23 09:37:54 Duration: 18s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026020);
Date: 2026-06-23 14:36:39 Duration: 15s920ms Database: rio User: intelifix Remote: [local] Application: psql
16 3m6s 18 8s798ms 13s233ms 10s350ms create table temp0000283300 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 23 08 13 2m7s 9s804ms 09 5 58s859ms 11s771ms [ User: intelifix - Total duration: 3m6s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 18 ]
-
CREATE TABLE temp0000283300 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:28:48 Duration: 13s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283300 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:27:49 Duration: 12s242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283300 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:32:50 Duration: 11s543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m54s 4 4s682ms 1m24s 43s666ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 23 20 2 1m25s 42s704ms 23 2 1m29s 44s627ms [ User: intelifix - Total duration: 2m54s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m54s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-23 23:36:04 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-23 20:08:08 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-23 23:45:41 Duration: 4s877ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m45s 15 9s130ms 13s355ms 11s50ms create table temp0000283380 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 23 15 15 2m45s 11s50ms [ User: intelifix - Total duration: 2m45s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m45s - Times executed: 15 ]
-
CREATE TABLE temp0000283380 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:25:32 Duration: 13s355ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283380 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:28:41 Duration: 12s345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283380 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:32:06 Duration: 12s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m8s 95 157ms 14s289ms 1s352ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 23 07 8 9s360ms 1s170ms 08 21 15s862ms 755ms 09 2 2s672ms 1s336ms 11 11 10s653ms 968ms 13 8 7s881ms 985ms 14 3 3s162ms 1s54ms 15 25 57s285ms 2s291ms 16 7 6s775ms 967ms 17 10 14s875ms 1s487ms [ User: intelifix - Total duration: 2m8s - Times executed: 95 ]
[ Application: [unknown] - Total duration: 2m8s - Times executed: 95 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-23 15:37:29 Duration: 14s289ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-23 15:38:13 Duration: 10s975ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-06-23 17:23:04 Duration: 8s554ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 2m 10 10s23ms 13s225ms 12s31ms create table temp0000283334 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 23 10 10 2m 12s31ms [ User: intelifix - Total duration: 2m - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m - Times executed: 10 ]
-
CREATE TABLE temp0000283334 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 10:43:01 Duration: 13s225ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283334 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 10:31:15 Duration: 13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283334 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 10:30:44 Duration: 12s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,474 31m42s 151ms 7s272ms 1s290ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 23 07 1 2s182ms 2s182ms 08 136 2m28s 1s90ms 09 202 3m57s 1s177ms 10 263 5m1s 1s145ms 11 194 4m4s 1s258ms 12 32 41s847ms 1s307ms 13 104 2m16s 1s316ms 14 124 3m41s 1s790ms 15 200 4m45s 1s428ms 16 135 3m15s 1s451ms 17 83 1m25s 1s35ms [ User: intelifix - Total duration: 31m42s - Times executed: 1474 ]
[ Application: [unknown] - Total duration: 31m42s - Times executed: 1474 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257302, 504, '518218069706,2C9569F5847B,BC644BD28668,A89FECC584D6,2C584F33F231,5819F843FEED,A8F5DDE63802,F8F532598FD9,A8F5DDE8783D,2C584F368302,4C12653E4D07,2C9569F2C155,5819F8460D32,4C1265E77F76,5819F8415DB9,B0DAF9514D89,5819F8463046,BC644BDEBE9C,2C584F34096F,A8F5DDED20F4,4C1265E448CE,BC644BCB28EB,BC644BDF084D,2C584F33BF9B,F8F5325682C6,F8F53256ABED,B0DAF94EF14C,2C9569EF4C55,BC644BD9C6CB,B0DAF963C056,B0935BEC38C3,2C584F2E8DA0,2C584F38416A,BC644BE4F1CC,CC75E2BCB34E,F8F5325A5635,BC644BCDADAA', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 14:58:07 Duration: 7s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257307, 450, 'F200012189B4E7F,1834AF24E293$F200011084B89EB,9877E74C274B$F200012312B2038,1834AF619B36$F200011334B8D91,8401128498C3$F200012073B5D4E,840112DCE59E$F200011330B2DE2,84011284146B$F200012256B009C,1834AF287BD0$F200011175B7F31,9877E7BF790D$F200011168B1AA1,9877E7BD9C1F$F200012192B1683,1834AF24FEF5$F200012188B0D1E,1834AF248F96$F200012311B8FF0,1834AF618BE6$F200010254B68D4,743AEF9A4B3F$F200013234B654C,1834AF9A3B00$F200011016B4DE6,9877E7098069$F200010150104FD,743AEF33CD3A$F200010273B05D0,743AEF9C711A$F200012187B7294,1834AF2480C4$F200012069B135F,840112DBDD96$F200011064B1DC5,9877E747ED23$F200011314B7BD6,84011280CE7F$F200011307B1CD8,840112804EFE$F2000102051665B,743AEF771EB4$F200011133B8C65,9877E7BA4DD5$F200012018B8B11,840112BD39F0$F200010356B9D87,9877E706C7AA$F200011307B1A97,840112804E02$F200011131B50E2,9877E7B9B461$F200010336E1E84,9877E700648A$F200011018B55EE,9877E709B38B$F200012074B30C8,840112DD1F65$F200010233B09DD,743AEF73127C$F200012062B0BAA,840112C2D647$F200010284B58EA,743AEFAD79C6$F200011057EC0E3,9877E74E2CB8$F200012311B5896,1834AF6173AC$F200011239B264C,8401122A795C$F200012073B4724,840112DCDBF0$F200011302B027F,8401128005C4', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 15:01:04 Duration: 7s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257307, 450, 'F200011055BC2F2,9877E74D72F2$F200011056B768D,9877E74DAE02$F200012028B18F9,840112BF8502$F200012152B3DB5,840112EB1410$F200012054B61A6,840112C122E9$F200012308B325D,1834AF612842$F200011013EA0EF,9877E708DA37$F200011131B09AF,9877E7B99535$F200010295E747C,743AEFAFBA7B$F200012192B13EC,1834AF24FDCF$F200011105B3373,9877E77C53B3$F200012308B66FB,1834AF613F48$F200012312B37B4,1834AF61A57E$F200010284B94B8,743AEFAD93F1$F200012308B660F,1834AF613EDF$F200011246B5B3C,840112374885$F20001017516312,743AEF5F532F$F200011308B5541,840112809138$F200012312B12B7,1834AF61954E$F20001020617E6E,743AEF70CECC$F200012189B2C50,1834AF24D3A5$F200011151B144E,9877E7BC8059$F200010290B829E,743AEFAEF16C$F200011203B9F44,8401120661D7$F200012192B4BCF,1834AF251641$F200011308B34B6,8401128082F9$F200011120B3AFA,9877E7B894F1$F200012189B2BFA,1834AF24D37B$F200013244B10C0,1834AF9B702D$F200011278B3E42,8401125EBCB1$F200013244B2E9E,1834AF9B7D38$F200011230B561A,84011229757C$F200011177B63C4,9877E7BFFCBD$F200011350B440F,84011294423A$F200012122B2250,840112E9071E$F200012258B1CA8,1834AF28BCA5$F200012188B0CA7,1834AF248F65$F200012349B082B,1834AF638066$F200011211B6B9E,84011207F53E$F200010336B9C5C,9877E7009B95', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 15:44:52 Duration: 7s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,253 13m28s 150ms 4s115ms 645ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 23 07 3 8s44ms 2s681ms 08 108 1m36s 890ms 09 136 1m47s 792ms 10 166 1m32s 559ms 11 148 1m29s 606ms 12 18 13s262ms 736ms 13 117 1m9s 590ms 14 191 1m52s 587ms 15 189 1m53s 598ms 16 116 1m5s 566ms 17 61 40s782ms 668ms [ User: intelifix - Total duration: 13m28s - Times executed: 1253 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 1253 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257084", "modelo" : "320", "itens" : "241631419806,241658782230,241711198186,241649594251,241616725364,241660478096,241660796466,241630216871,241635780816,241646180720,241604272331,241649867891,241606126978,241637624856,241709607582,241614909407,241604209697,241635974246,241606022951,241666181830,241651167782,241653180000,241669522021,241674050118,241634538304,241630084053,241678325158,241664123346,241661164359,241654972240,241656361534,241603343037,241618348496,241689462643,241593863133,241603270000,241679151940,241615666787,241677280725,241651186370,241655471840,230048071919,241604209394,241646190317,241620344752,241638238080,241615894565,241646614858", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 07:56:48 Duration: 4s115ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257152", "modelo" : "320", "itens" : "241689430721,241603558085,241710884060,241666204155,241634792526,241701419511,241621273440,241691191016,241715461432,241630979101,241619465564,241677466679,241628261429,241716442728,241669585562,241690088191,241600847787,241607439294,241666070506,241619215764,241608089920,241645780524,241632286669,241709309797,241607985970,241617566770,241604961119,241652402842,241620615059,241698621124,241619773148,241654408794,241666047798,241595461415,241671573355,241622685059,241631633542,241614911630,241655584151,241712137380,241706743252,241651773353,241638029496,241652050002,230040121323,241706429607,241663327981,241647073040", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 09:12:44 Duration: 3s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257152", "modelo" : "320", "itens" : "241694389598,241712190619,241621152542,241672014565,241621185777,241694883542,241655632641,241677522847,241656924046,241714635559,241675846476,241700316687,241659988598,241628174753,241608092345,241679304154,241595539098,241732780709,241629422945,241708997792,241608091436,241608093052,241629855770,241606288890,241713060614,241677687082,241658995258,241660545151,241707087987,241707367487,241664669516,241728311631,241596627880,241628823840,241697128384,241672380415,241666738102,241654401825,241629881632,241630694853,241726781616,241607984354,241691228291,230049484346,241604680912,241618212042,241703475772,241635580415", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 09:08:06 Duration: 3s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 304 2h35m56s 151ms 6m53s 30s779ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 23 06 1 6s598ms 6s598ms 07 14 16m57s 1m12s 08 42 19m49s 28s324ms 09 36 21m18s 35s526ms 10 23 14m38s 38s188ms 11 27 6m51s 15s237ms 12 16 10m24s 39s50ms 13 21 8m25s 24s83ms 14 27 9m25s 20s952ms 15 44 22m14s 30s334ms 16 24 13m30s 33s771ms 17 28 12m11s 26s114ms 18 1 1s518ms 1s518ms [ User: intelifix - Total duration: 2h35m56s - Times executed: 304 ]
[ Application: [unknown] - Total duration: 2h35m56s - Times executed: 304 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025995, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 09:44:56 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026020, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 14:42:58 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026014, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 12:03:39 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 266 12m17s 153ms 4m31s 2s773ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 23 00 11 32s911ms 2s991ms 01 12 18s468ms 1s539ms 02 11 15s951ms 1s450ms 03 11 17s230ms 1s566ms 04 12 18s262ms 1s521ms 05 10 18s857ms 1s885ms 06 11 16s196ms 1s472ms 07 12 18s477ms 1s539ms 08 12 21s95ms 1s757ms 09 12 4m54s 24s574ms 10 12 22s263ms 1s855ms 11 12 22s219ms 1s851ms 12 12 17s450ms 1s454ms 13 12 26s312ms 2s192ms 14 12 21s98ms 1s758ms 15 12 29s387ms 2s448ms 16 12 22s623ms 1s885ms 17 12 19s831ms 1s652ms 18 12 17s190ms 1s432ms 19 12 15s708ms 1s309ms 20 10 20s725ms 2s72ms 21 10 16s7ms 1s600ms 22 12 14s518ms 1s209ms [ User: intelifix - Total duration: 12m17s - Times executed: 266 ]
[ Application: psql - Total duration: 12m17s - Times executed: 266 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 09:09:49 Duration: 4m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 00:05:43 Duration: 15s162ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 13:15:11 Duration: 10s336ms Database: rio User: intelifix Remote: [local] Application: psql
5 253 1m5s 150ms 755ms 259ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 23 04 23 6s265ms 272ms 05 17 5s859ms 344ms 07 18 5s260ms 292ms 08 25 5s855ms 234ms 09 26 6s771ms 260ms 10 20 5s368ms 268ms 11 22 5s110ms 232ms 12 20 5s91ms 254ms 13 4 1s17ms 254ms 14 28 6s879ms 245ms 15 28 7s6ms 250ms 16 20 4s724ms 236ms 17 2 372ms 186ms [ User: intelifix - Total duration: 1m5s - Times executed: 253 ]
[ Application: [unknown] - Total duration: 1m5s - Times executed: 253 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241734211724,241698480729,241603267193,241629893653,241650255157,241655667896,241649640822,241621207800,241621186686,241659635152,241725877374,241620281335,241652856982,241593423135,241637585761', NULL, NULL, 0320, 00);
Date: 2026-06-23 05:02:57 Duration: 755ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '229959050426,229952944857,229995231420,229962300204,230013530120,229938309613,229959130512,229999838793,229994621428,229947684052,229964357171,229993137073,229997628499', NULL, NULL, 0287, 00);
Date: 2026-06-23 07:57:12 Duration: 652ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230026237273,229963276673,230001045163,230024835779,230030464959,229982275172,230023109202,229981939909,229990470720,229979019108,230011381526,230032936973,229967172834,230038098498,230038011218,230031776467,229981889601,230024645659,230034520507,230050152728,230051955676,230051959010,230038151333,230011247393,230041234046,230053515267,230011294345,229971369001', NULL, NULL, 0295, 00);
Date: 2026-06-23 04:26:23 Duration: 627ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 156 14m4s 310ms 26s699ms 5s416ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 23 00 6 42s70ms 7s11ms 01 6 17s36ms 2s839ms 02 5 13s229ms 2s645ms 03 5 19s60ms 3s812ms 04 6 14s936ms 2s489ms 05 6 21s912ms 3s652ms 06 1 2s997ms 2s997ms 07 12 1m15s 6s262ms 08 12 1m21s 6s771ms 09 12 1m40s 8s405ms 10 12 1m18s 6s504ms 11 12 1m18s 6s521ms 12 8 58s261ms 7s282ms 13 9 19s377ms 2s153ms 14 12 1m19s 6s626ms 15 12 1m23s 6s926ms 16 10 44s436ms 4s443ms 21 5 7s505ms 1s501ms 22 5 7s894ms 1s578ms [ User: intelifix - Total duration: 14m4s - Times executed: 156 ]
[ Application: psql - Total duration: 14m4s - Times executed: 156 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 00:05:28 Duration: 26s699ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 14:35:21 Duration: 19s668ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 15:25:18 Duration: 17s298ms Database: rio User: intelifix Remote: [local] Application: psql
7 132 21s607ms 150ms 206ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 23 04 1 168ms 168ms 07 7 1s141ms 163ms 08 9 1s478ms 164ms 09 20 3s307ms 165ms 10 10 1s633ms 163ms 11 13 2s55ms 158ms 12 5 893ms 178ms 13 9 1s490ms 165ms 14 18 2s861ms 158ms 15 27 4s479ms 165ms 16 9 1s435ms 159ms 17 4 660ms 165ms [ User: intelifix - Total duration: 21s607ms - Times executed: 132 ]
[ Application: [unknown] - Total duration: 21s607ms - Times executed: 132 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-06-23 12:42:33 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-06-23 15:15:14 Duration: 204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-23 15:49:12 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 127 40s141ms 150ms 626ms 316ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 23 09 2 602ms 301ms 16 50 17s9ms 340ms 17 75 22s529ms 300ms [ User: intelifix - Total duration: 40s141ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 40s141ms - Times executed: 127 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42959","seriais":"08A7C04FB4EC,B85E71E5BEB0,400FC1867884,ECA81F21A8D4,F8D2AC4AEBD8,B85E71BEBA7C,08A7C06D94B4,E4BFFAFBEA6C,00CB7ADD0F9C,D4E2CB93BE64,F8D2AC4B09EC,3C82C0CE4FF4,B85E71E2566C,E4BFFAF95774","usuario":"416","observacao":""}');
Date: 2026-06-23 16:59:50 Duration: 626ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42959","seriais":"5CFA2515B511,582FF796DC03,4829524CB4D6,8CFDDE87EB20,CC58300343ED,CC5830E32EDC,6CFFCE6948BB,841EA38C1DEF,94988F30ED38,20B82BFA2515","usuario":"416","observacao":""}');
Date: 2026-06-23 16:58:27 Duration: 523ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42959","seriais":"CCF3C8815BB3,CCF3C857F1CB,48BDCE7080FB,F8D2ACEDDB4B,CCF3C882CABB,F8D2AC5585E3,CCF3C8509AF3,10A7933E3273,F8D2ACF1B7B3,CCF3C87C3893","usuario":"416","observacao":""}');
Date: 2026-06-23 17:13:13 Duration: 518ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 126 25m35s 1s415ms 1m49s 12s183ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 23 07 3 20s699ms 6s899ms 08 9 2m36s 17s413ms 09 4 2m43s 40s754ms 10 4 1m22s 20s644ms 11 8 2m22s 17s821ms 12 10 43s574ms 4s357ms 13 4 1m39s 24s873ms 14 10 2m37s 15s770ms 15 24 4m19s 10s801ms 16 17 2m24s 8s518ms 17 33 4m24s 8s20ms [ User: intelifix - Total duration: 25m35s - Times executed: 126 ]
[ Application: [unknown] - Total duration: 25m35s - Times executed: 126 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 09:29:02 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0320, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 08:19:05 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 13:14:26 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
10 124 47s412ms 155ms 1s297ms 382ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 23 07 1 214ms 214ms 08 18 6s243ms 346ms 09 17 9s628ms 566ms 10 16 7s311ms 456ms 11 8 4s844ms 605ms 13 6 3s82ms 513ms 14 20 6s703ms 335ms 15 33 8s159ms 247ms 16 1 209ms 209ms 17 4 1s14ms 253ms [ User: intelifix - Total duration: 47s412ms - Times executed: 124 ]
[ Application: [unknown] - Total duration: 47s412ms - Times executed: 124 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F4E84F863A62,843C992C6B07,14CA56D6C445,689E29FC2B17,3CF9F0AC01F8,5872C98D4B71,C4EBFF8BE360,D89A0DAD1AC9,48D68233D3C6,843C99208EB9,843C992F5AFF,843C993332F3,14CA56CE24A5,C4EBFF897FD8,3CF9F0A5D0AE,14CA56D560CB,48D68231F56A,D89A0DA470EB,3CF9F0AC5F6A,14CA56CDB8F9', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-06-23 09:12:38 Duration: 1s297ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '942CB3E96A85,8C444F60FA59,E820E2F39316,942CB3E62303,E820E29C405E,942CB3E32D20,90F3055764D3,8C444F803C7F,E820E2554E74,E820E26FAA13', '138;1', 'DEFAULT', 09, 039, '','', '', 00);
Date: 2026-06-23 08:51:28 Duration: 1s242ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229799874969,229642516682,229765142848,229704486568,229707793042,229707751321,229833184258,229822248285,229700484461,229825025661,229733307686,229642134041,229764036162,229798454763,229711914555,229695419612,229833194158,229646301822,229703275878,229763699003,229824584855,229764579504,229709695472,229768313348,229646086873,229705723042,229714336183,229702761530,229704922728,216950018809,229834160022,229834082943,229798851424,229767941718,229767970913,229823660916,229834301831,229693274756,229767971519', '','DEFAULT',056,0137,'', '','', 00);
Date: 2026-06-23 09:58:38 Duration: 1s164ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 122 24s612ms 150ms 679ms 201ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 23 00 1 418ms 418ms 01 2 572ms 286ms 03 1 383ms 383ms 04 13 2s729ms 209ms 05 7 1s365ms 195ms 06 1 239ms 239ms 07 15 2s589ms 172ms 08 9 1s795ms 199ms 09 21 4s636ms 220ms 10 12 2s114ms 176ms 11 16 3s244ms 202ms 12 6 1s34ms 172ms 13 3 806ms 268ms 14 7 1s295ms 185ms 15 2 319ms 159ms 16 5 898ms 179ms 21 1 166ms 166ms [ User: intelifix - Total duration: 24s612ms - Times executed: 122 ]
[ Application: [unknown] - Total duration: 24s612ms - Times executed: 122 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('AC606F31AD60');
Date: 2026-06-23 09:17:51 Duration: 679ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('2165776;7997');
Date: 2026-06-23 13:26:33 Duration: 481ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('24E4CED9FF84');
Date: 2026-06-23 11:19:29 Duration: 419ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 114 23s932ms 150ms 938ms 209ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 23 04 3 979ms 326ms 07 1 184ms 184ms 08 2 1s110ms 555ms 09 4 837ms 209ms 10 1 165ms 165ms 11 14 3s748ms 267ms 12 4 724ms 181ms 13 6 1s713ms 285ms 14 13 2s246ms 172ms 15 29 5s711ms 196ms 16 25 4s394ms 175ms 17 12 2s116ms 176ms [ User: intelifix - Total duration: 23s932ms - Times executed: 114 ]
[ Application: [unknown] - Total duration: 23s932ms - Times executed: 114 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-23", "data-ate" : "2026-06-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-06-23 08:10:52 Duration: 938ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-06-23", "data-ate" : "2026-06-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-06-23 13:41:26 Duration: 637ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-22", "data-ate" : "2026-06-22", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-23 11:56:07 Duration: 494ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 110 48s626ms 261ms 717ms 442ms 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 #13
Day Hour Count Duration Avg duration Jun 23 00 1 441ms 441ms 04 2 949ms 474ms 05 1 375ms 375ms 06 3 1s145ms 381ms 07 6 2s321ms 386ms 08 12 5s799ms 483ms 09 9 3s686ms 409ms 10 11 5s565ms 505ms 11 7 2s937ms 419ms 12 6 2s247ms 374ms 13 12 5s417ms 451ms 14 9 3s820ms 424ms 15 10 4s636ms 463ms 16 9 3s685ms 409ms 17 10 4s441ms 444ms 21 1 595ms 595ms 22 1 559ms 559ms [ User: lenon - Total duration: 48s626ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 48s626ms - Times executed: 110 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-23 10:24:22 Duration: 717ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-23 17:25:44 Duration: 692ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-23 13:57:53 Duration: 682ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
14 110 42s417ms 205ms 767ms 385ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 23 06 1 341ms 341ms 07 4 1s358ms 339ms 08 12 4s140ms 345ms 09 23 9s178ms 399ms 10 11 4s156ms 377ms 11 8 2s812ms 351ms 12 9 3s458ms 384ms 13 4 1s752ms 438ms 14 7 2s742ms 391ms 15 12 5s836ms 486ms 16 10 3s294ms 329ms 17 8 3s20ms 377ms 18 1 324ms 324ms [ User: intelifix - Total duration: 42s417ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 42s417ms - Times executed: 110 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-23 15:15:14 Duration: 767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-23 09:07:10 Duration: 759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-23 15:19:15 Duration: 622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 102 56s603ms 318ms 879ms 554ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 23 00 1 712ms 712ms 04 2 1s211ms 605ms 05 1 534ms 534ms 06 1 441ms 441ms 07 4 1s769ms 442ms 08 12 7s136ms 594ms 09 8 4s262ms 532ms 10 11 6s835ms 621ms 11 7 3s727ms 532ms 12 6 2s871ms 478ms 13 11 6s202ms 563ms 14 9 4s905ms 545ms 15 10 5s919ms 591ms 16 9 4s698ms 522ms 17 10 5s376ms 537ms [ User: intelifix - Total duration: 56s603ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 56s603ms - Times executed: 102 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-23 10:24:22 Duration: 879ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-06-23 15:26:30 Duration: 782ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (99, 20, 1);
Date: 2026-06-23 15:15:16 Duration: 780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 95 2m8s 157ms 14s289ms 1s352ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 23 07 8 9s360ms 1s170ms 08 21 15s862ms 755ms 09 2 2s672ms 1s336ms 11 11 10s653ms 968ms 13 8 7s881ms 985ms 14 3 3s162ms 1s54ms 15 25 57s285ms 2s291ms 16 7 6s775ms 967ms 17 10 14s875ms 1s487ms [ User: intelifix - Total duration: 2m8s - Times executed: 95 ]
[ Application: [unknown] - Total duration: 2m8s - Times executed: 95 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-23 15:37:29 Duration: 14s289ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-23 15:38:13 Duration: 10s975ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-06-23 17:23:04 Duration: 8s554ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 92 20s986ms 153ms 523ms 228ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 23 07 1 412ms 412ms 08 7 1s987ms 283ms 09 5 1s448ms 289ms 10 8 1s886ms 235ms 11 2 588ms 294ms 14 12 2s574ms 214ms 15 29 6s136ms 211ms 16 15 3s315ms 221ms 17 13 2s637ms 202ms [ User: intelifix - Total duration: 20s986ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 20s986ms - Times executed: 92 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"303", "usuario" :"427", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-23 08:55:25 Duration: 523ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"0011", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-23 07:09:43 Duration: 412ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"466", "usuario" :"507", "tipo" :"N", "itens" :"005", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-23 16:18:46 Duration: 371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 79 14m42s 8s364ms 55s278ms 11s172ms create table temp0000283282 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 23 07 20 3m51s 11s573ms 08 22 3m46s 10s308ms 09 15 3m 12s38ms 10 14 2m33s 10s941ms 11 8 1m30s 11s320ms [ User: intelifix - Total duration: 14m42s - Times executed: 79 ]
[ Application: [unknown] - Total duration: 14m42s - Times executed: 79 ]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 07:01:33 Duration: 55s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:02:37 Duration: 14s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 08:46:18 Duration: 13s608ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 78 6m9s 201ms 1m21s 4s740ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 23 07 7 4s86ms 583ms 08 15 7s902ms 526ms 09 12 2m13s 11s146ms 10 9 1m56s 12s974ms 11 5 5s440ms 1s88ms 12 3 4s479ms 1s493ms 13 1 3s4ms 3s4ms 14 4 3s16ms 754ms 15 13 6s199ms 476ms 16 7 1m3s 9s67ms 17 2 21s645ms 10s822ms [ User: intelifix - Total duration: 6m9s - Times executed: 78 ]
[ Application: psql - Total duration: 6m9s - Times executed: 78 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026007);
Date: 2026-06-23 10:38:15 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026000);
Date: 2026-06-23 09:56:24 Duration: 47s80ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025997);
Date: 2026-06-23 09:48:51 Duration: 45s262ms Database: rio User: intelifix Remote: [local] Application: psql
20 70 31s457ms 180ms 13s224ms 449ms create table temp0000283368 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 23 13 7 14s685ms 2s97ms 14 3 643ms 214ms 15 20 5s501ms 275ms 16 26 6s798ms 261ms 17 14 3s828ms 273ms [ User: intelifix - Total duration: 31s457ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 31s457ms - Times executed: 70 ]
-
CREATE TABLE temp0000283368 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-06-2026", "ate" :"23-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-23 13:32:42 Duration: 13s224ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283368 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-06-2026", "ate" :"23-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-23 17:30:54 Duration: 387ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283368 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-06-2026", "ate" :"23-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-23 15:50:18 Duration: 360ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m20s 9m10s 5m31s 3 16m33s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 23 05 3 16m33s 5m31s [ User: intelifix - Total duration: 16m33s - Times executed: 3 ]
[ Application: psql - Total duration: 16m33s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-23 05:09:11 Duration: 9m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-23 05:14:13 Duration: 5m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-23 05:16:34 Duration: 2m20s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s292ms 15m28s 3m3s 48 2h27m8s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 23 07 3 11m58s 3m59s 08 3 6m43s 2m14s 09 3 16m12s 5m24s 10 3 12m3s 4m1s 11 3 9m31s 3m10s 12 3 11m11s 3m43s 13 3 7m16s 2m25s 14 3 11m14s 3m44s 15 3 10m45s 3m35s 16 3 8m15s 2m45s 17 3 7m56s 2m38s 18 3 8m6s 2m42s 19 3 6m 2m 20 3 7m15s 2m25s 21 3 6m11s 2m3s 22 3 6m26s 2m8s [ User: intelifix - Total duration: 2h27m8s - Times executed: 48 ]
[ Application: psql - Total duration: 2h27m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-23 09:20:30 Duration: 15m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-23 10:16:25 Duration: 11m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-23 07:16:07 Duration: 11m5s Database: rio User: intelifix Remote: [local] Application: psql
3 214ms 4m31s 1m33s 48 1h14m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 23 07 3 5m34s 1m51s 08 3 3m54s 1m18s 09 3 5m54s 1m58s 10 3 5m9s 1m43s 11 3 5m13s 1m44s 12 3 4m41s 1m33s 13 3 3m54s 1m18s 14 3 5m31s 1m50s 15 3 5m37s 1m52s 16 3 4m32s 1m30s 17 3 4m30s 1m30s 18 3 4m43s 1m34s 19 3 3m30s 1m10s 20 3 4m31s 1m30s 21 3 3m27s 1m9s 22 3 3m39s 1m13s [ User: intelifix - Total duration: 1h14m27s - Times executed: 48 ]
[ Application: psql - Total duration: 1h14m27s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-23 09:27:00 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-23 15:21:17 Duration: 4m22s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-23 14:21:43 Duration: 4m17s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s682ms 1m24s 43s666ms 4 2m54s 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 Jun 23 20 2 1m25s 42s704ms 23 2 1m29s 44s627ms [ User: intelifix - Total duration: 2m54s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m54s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-23 23:36:04 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-23 20:08:08 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-23 23:45:41 Duration: 4s877ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 151ms 6m53s 30s779ms 304 2h35m56s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 23 06 1 6s598ms 6s598ms 07 14 16m57s 1m12s 08 42 19m49s 28s324ms 09 36 21m18s 35s526ms 10 23 14m38s 38s188ms 11 27 6m51s 15s237ms 12 16 10m24s 39s50ms 13 21 8m25s 24s83ms 14 27 9m25s 20s952ms 15 44 22m14s 30s334ms 16 24 13m30s 33s771ms 17 28 12m11s 26s114ms 18 1 1s518ms 1s518ms [ User: intelifix - Total duration: 2h35m56s - Times executed: 304 ]
[ Application: [unknown] - Total duration: 2h35m56s - Times executed: 304 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025995, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 09:44:56 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026020, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 14:42:58 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026014, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-23 12:03:39 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 8s674ms 43s177ms 12s628ms 37 7m47s create table temp0000283382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 23 14 12 2m55s 14s615ms 15 14 2m52s 12s325ms 16 11 1m59s 10s845ms [ User: intelifix - Total duration: 7m47s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 7m47s - Times executed: 37 ]
-
CREATE TABLE temp0000283382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 14:35:03 Duration: 43s177ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:16:51 Duration: 26s766ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 16:25:04 Duration: 14s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 8s856ms 48s639ms 12s520ms 26 5m25s create table temp0000283374 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 23 13 3 1m15s 25s138ms 14 5 59s61ms 11s812ms 15 3 34s504ms 11s501ms 16 9 1m30s 10s85ms 17 6 1m5s 10s961ms [ User: intelifix - Total duration: 5m25s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 5m25s - Times executed: 26 ]
-
CREATE TABLE temp0000283374 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 13:56:40 Duration: 48s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283374 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 13:57:12 Duration: 14s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283374 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 14:43:15 Duration: 13s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 1s415ms 1m49s 12s183ms 126 25m35s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 23 07 3 20s699ms 6s899ms 08 9 2m36s 17s413ms 09 4 2m43s 40s754ms 10 4 1m22s 20s644ms 11 8 2m22s 17s821ms 12 10 43s574ms 4s357ms 13 4 1m39s 24s873ms 14 10 2m37s 15s770ms 15 24 4m19s 10s801ms 16 17 2m24s 8s518ms 17 33 4m24s 8s20ms [ User: intelifix - Total duration: 25m35s - Times executed: 126 ]
[ Application: [unknown] - Total duration: 25m35s - Times executed: 126 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 09:29:02 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0320, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 08:19:05 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-23', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-23 13:14:26 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s23ms 13s225ms 12s31ms 10 2m create table temp0000283334 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 23 10 10 2m 12s31ms [ User: intelifix - Total duration: 2m - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m - Times executed: 10 ]
-
CREATE TABLE temp0000283334 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 10:43:01 Duration: 13s225ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283334 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 10:31:15 Duration: 13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283334 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 10:30:44 Duration: 12s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s82ms 14s188ms 11s286ms 30 5m38s create table temp0000283318 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 23 08 5 56s825ms 11s365ms 09 17 3m8s 11s89ms 10 3 32s660ms 10s886ms 11 5 1m 12s116ms [ User: intelifix - Total duration: 5m38s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 5m38s - Times executed: 30 ]
-
CREATE TABLE temp0000283318 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:10:11 Duration: 14s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283318 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 11:55:42 Duration: 13s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283318 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:48:19 Duration: 13s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s364ms 55s278ms 11s172ms 79 14m42s create table temp0000283282 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 23 07 20 3m51s 11s573ms 08 22 3m46s 10s308ms 09 15 3m 12s38ms 10 14 2m33s 10s941ms 11 8 1m30s 11s320ms [ User: intelifix - Total duration: 14m42s - Times executed: 79 ]
[ Application: [unknown] - Total duration: 14m42s - Times executed: 79 ]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 07:01:33 Duration: 55s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:02:37 Duration: 14s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283282 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 08:46:18 Duration: 13s608ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s130ms 13s355ms 11s50ms 15 2m45s create table temp0000283380 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 23 15 15 2m45s 11s50ms [ User: intelifix - Total duration: 2m45s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m45s - Times executed: 15 ]
-
CREATE TABLE temp0000283380 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:25:32 Duration: 13s355ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283380 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:28:41 Duration: 12s345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283380 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 15:32:06 Duration: 12s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s798ms 13s233ms 10s350ms 18 3m6s create table temp0000283300 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 23 08 13 2m7s 9s804ms 09 5 58s859ms 11s771ms [ User: intelifix - Total duration: 3m6s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 18 ]
-
CREATE TABLE temp0000283300 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:28:48 Duration: 13s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283300 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:27:49 Duration: 12s242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283300 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-23 09:32:50 Duration: 11s543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 310ms 26s699ms 5s416ms 156 14m4s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 23 00 6 42s70ms 7s11ms 01 6 17s36ms 2s839ms 02 5 13s229ms 2s645ms 03 5 19s60ms 3s812ms 04 6 14s936ms 2s489ms 05 6 21s912ms 3s652ms 06 1 2s997ms 2s997ms 07 12 1m15s 6s262ms 08 12 1m21s 6s771ms 09 12 1m40s 8s405ms 10 12 1m18s 6s504ms 11 12 1m18s 6s521ms 12 8 58s261ms 7s282ms 13 9 19s377ms 2s153ms 14 12 1m19s 6s626ms 15 12 1m23s 6s926ms 16 10 44s436ms 4s443ms 21 5 7s505ms 1s501ms 22 5 7s894ms 1s578ms [ User: intelifix - Total duration: 14m4s - Times executed: 156 ]
[ Application: psql - Total duration: 14m4s - Times executed: 156 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 00:05:28 Duration: 26s699ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 14:35:21 Duration: 19s668ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-23 15:25:18 Duration: 17s298ms Database: rio User: intelifix Remote: [local] Application: psql
15 201ms 1m21s 4s740ms 78 6m9s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 23 07 7 4s86ms 583ms 08 15 7s902ms 526ms 09 12 2m13s 11s146ms 10 9 1m56s 12s974ms 11 5 5s440ms 1s88ms 12 3 4s479ms 1s493ms 13 1 3s4ms 3s4ms 14 4 3s16ms 754ms 15 13 6s199ms 476ms 16 7 1m3s 9s67ms 17 2 21s645ms 10s822ms [ User: intelifix - Total duration: 6m9s - Times executed: 78 ]
[ Application: psql - Total duration: 6m9s - Times executed: 78 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026007);
Date: 2026-06-23 10:38:15 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026000);
Date: 2026-06-23 09:56:24 Duration: 47s80ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025997);
Date: 2026-06-23 09:48:51 Duration: 45s262ms Database: rio User: intelifix Remote: [local] Application: psql
16 180ms 32s349ms 4s219ms 59 4m8s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 23 07 4 36s847ms 9s211ms 08 8 24s738ms 3s92ms 09 9 56s605ms 6s289ms 10 7 29s425ms 4s203ms 11 5 21s316ms 4s263ms 12 1 493ms 493ms 14 4 22s943ms 5s735ms 15 9 28s623ms 3s180ms 16 9 26s872ms 2s985ms 17 3 1s102ms 367ms [ User: intelifix - Total duration: 4m8s - Times executed: 59 ]
[ Application: psql - Total duration: 4m8s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025967);
Date: 2026-06-23 07:03:13 Duration: 32s349ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025995);
Date: 2026-06-23 09:37:54 Duration: 18s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026020);
Date: 2026-06-23 14:36:39 Duration: 15s920ms Database: rio User: intelifix Remote: [local] Application: psql
17 153ms 4m31s 2s773ms 266 12m17s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 23 00 11 32s911ms 2s991ms 01 12 18s468ms 1s539ms 02 11 15s951ms 1s450ms 03 11 17s230ms 1s566ms 04 12 18s262ms 1s521ms 05 10 18s857ms 1s885ms 06 11 16s196ms 1s472ms 07 12 18s477ms 1s539ms 08 12 21s95ms 1s757ms 09 12 4m54s 24s574ms 10 12 22s263ms 1s855ms 11 12 22s219ms 1s851ms 12 12 17s450ms 1s454ms 13 12 26s312ms 2s192ms 14 12 21s98ms 1s758ms 15 12 29s387ms 2s448ms 16 12 22s623ms 1s885ms 17 12 19s831ms 1s652ms 18 12 17s190ms 1s432ms 19 12 15s708ms 1s309ms 20 10 20s725ms 2s72ms 21 10 16s7ms 1s600ms 22 12 14s518ms 1s209ms [ User: intelifix - Total duration: 12m17s - Times executed: 266 ]
[ Application: psql - Total duration: 12m17s - Times executed: 266 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 09:09:49 Duration: 4m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 00:05:43 Duration: 15s162ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-23 13:15:11 Duration: 10s336ms Database: rio User: intelifix Remote: [local] Application: psql
18 157ms 14s289ms 1s352ms 95 2m8s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 23 07 8 9s360ms 1s170ms 08 21 15s862ms 755ms 09 2 2s672ms 1s336ms 11 11 10s653ms 968ms 13 8 7s881ms 985ms 14 3 3s162ms 1s54ms 15 25 57s285ms 2s291ms 16 7 6s775ms 967ms 17 10 14s875ms 1s487ms [ User: intelifix - Total duration: 2m8s - Times executed: 95 ]
[ Application: [unknown] - Total duration: 2m8s - Times executed: 95 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-23 15:37:29 Duration: 14s289ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-23 15:38:13 Duration: 10s975ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-06-23 17:23:04 Duration: 8s554ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 151ms 7s272ms 1s290ms 1,474 31m42s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 23 07 1 2s182ms 2s182ms 08 136 2m28s 1s90ms 09 202 3m57s 1s177ms 10 263 5m1s 1s145ms 11 194 4m4s 1s258ms 12 32 41s847ms 1s307ms 13 104 2m16s 1s316ms 14 124 3m41s 1s790ms 15 200 4m45s 1s428ms 16 135 3m15s 1s451ms 17 83 1m25s 1s35ms [ User: intelifix - Total duration: 31m42s - Times executed: 1474 ]
[ Application: [unknown] - Total duration: 31m42s - Times executed: 1474 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257302, 504, '518218069706,2C9569F5847B,BC644BD28668,A89FECC584D6,2C584F33F231,5819F843FEED,A8F5DDE63802,F8F532598FD9,A8F5DDE8783D,2C584F368302,4C12653E4D07,2C9569F2C155,5819F8460D32,4C1265E77F76,5819F8415DB9,B0DAF9514D89,5819F8463046,BC644BDEBE9C,2C584F34096F,A8F5DDED20F4,4C1265E448CE,BC644BCB28EB,BC644BDF084D,2C584F33BF9B,F8F5325682C6,F8F53256ABED,B0DAF94EF14C,2C9569EF4C55,BC644BD9C6CB,B0DAF963C056,B0935BEC38C3,2C584F2E8DA0,2C584F38416A,BC644BE4F1CC,CC75E2BCB34E,F8F5325A5635,BC644BCDADAA', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 14:58:07 Duration: 7s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257307, 450, 'F200012189B4E7F,1834AF24E293$F200011084B89EB,9877E74C274B$F200012312B2038,1834AF619B36$F200011334B8D91,8401128498C3$F200012073B5D4E,840112DCE59E$F200011330B2DE2,84011284146B$F200012256B009C,1834AF287BD0$F200011175B7F31,9877E7BF790D$F200011168B1AA1,9877E7BD9C1F$F200012192B1683,1834AF24FEF5$F200012188B0D1E,1834AF248F96$F200012311B8FF0,1834AF618BE6$F200010254B68D4,743AEF9A4B3F$F200013234B654C,1834AF9A3B00$F200011016B4DE6,9877E7098069$F200010150104FD,743AEF33CD3A$F200010273B05D0,743AEF9C711A$F200012187B7294,1834AF2480C4$F200012069B135F,840112DBDD96$F200011064B1DC5,9877E747ED23$F200011314B7BD6,84011280CE7F$F200011307B1CD8,840112804EFE$F2000102051665B,743AEF771EB4$F200011133B8C65,9877E7BA4DD5$F200012018B8B11,840112BD39F0$F200010356B9D87,9877E706C7AA$F200011307B1A97,840112804E02$F200011131B50E2,9877E7B9B461$F200010336E1E84,9877E700648A$F200011018B55EE,9877E709B38B$F200012074B30C8,840112DD1F65$F200010233B09DD,743AEF73127C$F200012062B0BAA,840112C2D647$F200010284B58EA,743AEFAD79C6$F200011057EC0E3,9877E74E2CB8$F200012311B5896,1834AF6173AC$F200011239B264C,8401122A795C$F200012073B4724,840112DCDBF0$F200011302B027F,8401128005C4', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 15:01:04 Duration: 7s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (257307, 450, 'F200011055BC2F2,9877E74D72F2$F200011056B768D,9877E74DAE02$F200012028B18F9,840112BF8502$F200012152B3DB5,840112EB1410$F200012054B61A6,840112C122E9$F200012308B325D,1834AF612842$F200011013EA0EF,9877E708DA37$F200011131B09AF,9877E7B99535$F200010295E747C,743AEFAFBA7B$F200012192B13EC,1834AF24FDCF$F200011105B3373,9877E77C53B3$F200012308B66FB,1834AF613F48$F200012312B37B4,1834AF61A57E$F200010284B94B8,743AEFAD93F1$F200012308B660F,1834AF613EDF$F200011246B5B3C,840112374885$F20001017516312,743AEF5F532F$F200011308B5541,840112809138$F200012312B12B7,1834AF61954E$F20001020617E6E,743AEF70CECC$F200012189B2C50,1834AF24D3A5$F200011151B144E,9877E7BC8059$F200010290B829E,743AEFAEF16C$F200011203B9F44,8401120661D7$F200012192B4BCF,1834AF251641$F200011308B34B6,8401128082F9$F200011120B3AFA,9877E7B894F1$F200012189B2BFA,1834AF24D37B$F200013244B10C0,1834AF9B702D$F200011278B3E42,8401125EBCB1$F200013244B2E9E,1834AF9B7D38$F200011230B561A,84011229757C$F200011177B63C4,9877E7BFFCBD$F200011350B440F,84011294423A$F200012122B2250,840112E9071E$F200012258B1CA8,1834AF28BCA5$F200012188B0CA7,1834AF248F65$F200012349B082B,1834AF638066$F200011211B6B9E,84011207F53E$F200010336B9C5C,9877E7009B95', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-23 15:44:52 Duration: 7s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 4s115ms 645ms 1,253 13m28s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 23 07 3 8s44ms 2s681ms 08 108 1m36s 890ms 09 136 1m47s 792ms 10 166 1m32s 559ms 11 148 1m29s 606ms 12 18 13s262ms 736ms 13 117 1m9s 590ms 14 191 1m52s 587ms 15 189 1m53s 598ms 16 116 1m5s 566ms 17 61 40s782ms 668ms [ User: intelifix - Total duration: 13m28s - Times executed: 1253 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 1253 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257084", "modelo" : "320", "itens" : "241631419806,241658782230,241711198186,241649594251,241616725364,241660478096,241660796466,241630216871,241635780816,241646180720,241604272331,241649867891,241606126978,241637624856,241709607582,241614909407,241604209697,241635974246,241606022951,241666181830,241651167782,241653180000,241669522021,241674050118,241634538304,241630084053,241678325158,241664123346,241661164359,241654972240,241656361534,241603343037,241618348496,241689462643,241593863133,241603270000,241679151940,241615666787,241677280725,241651186370,241655471840,230048071919,241604209394,241646190317,241620344752,241638238080,241615894565,241646614858", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 07:56:48 Duration: 4s115ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257152", "modelo" : "320", "itens" : "241689430721,241603558085,241710884060,241666204155,241634792526,241701419511,241621273440,241691191016,241715461432,241630979101,241619465564,241677466679,241628261429,241716442728,241669585562,241690088191,241600847787,241607439294,241666070506,241619215764,241608089920,241645780524,241632286669,241709309797,241607985970,241617566770,241604961119,241652402842,241620615059,241698621124,241619773148,241654408794,241666047798,241595461415,241671573355,241622685059,241631633542,241614911630,241655584151,241712137380,241706743252,241651773353,241638029496,241652050002,230040121323,241706429607,241663327981,241647073040", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 09:12:44 Duration: 3s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "257152", "modelo" : "320", "itens" : "241694389598,241712190619,241621152542,241672014565,241621185777,241694883542,241655632641,241677522847,241656924046,241714635559,241675846476,241700316687,241659988598,241628174753,241608092345,241679304154,241595539098,241732780709,241629422945,241708997792,241608091436,241608093052,241629855770,241606288890,241713060614,241677687082,241658995258,241660545151,241707087987,241707367487,241664669516,241728311631,241596627880,241628823840,241697128384,241672380415,241666738102,241654401825,241629881632,241630694853,241726781616,241607984354,241691228291,230049484346,241604680912,241618212042,241703475772,241635580415", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-23 09:08:06 Duration: 3s117ms 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 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 23 12 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 6s489ms - Times executed: 3 ]
[ Application: psql - Total duration: 6s489ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 22,982 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 5897 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,686 Max number of times the same event was reported
- 5,915 Total events found
Rank Times reported Error 1 5,686 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 23 00 57 01 58 02 57 03 56 04 55 05 60 06 80 07 298 08 520 09 528 10 586 11 518 12 321 13 176 14 629 15 673 16 487 17 182 18 60 19 59 20 59 21 59 22 59 23 49 - ERROR: prepared statement "_PLAN0000000029D30F20" does not exist
- ERROR: prepared statement "_PLAN0000000029D31840" does not exist
- ERROR: prepared statement "_PLAN000000002A0EC7D0" does not exist
Statement: DEALLOCATE "_PLAN0000000029D30F20"
Date: 2026-06-23 00:00:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D31840"
Date: 2026-06-23 00:01:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A0EC7D0"
Date: 2026-06-23 00:03:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 92 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 23 07 3 08 9 09 10 10 23 11 25 12 9 14 8 16 5 - ERROR: trailing junk after numeric literal at or near "0E-" at character 39
- ERROR: trailing junk after numeric literal at or near "0E-" at character 39
- ERROR: trailing junk after numeric literal at or near "0E-" at character 39
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-84-0E-BE)
Date: 2026-06-23 07:34:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-84-0E-BE)
Date: 2026-06-23 07:34:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-84-0E-BE)
Date: 2026-06-23 07:34:07 Database: rio Application: [unknown] User: etiquetas 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 Jun 23 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-06-23 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-23 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-23 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 31 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 23 08 3 09 6 10 4 11 6 14 9 16 3 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-84-D7-C4)
Date: 2026-06-23 08:27:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-84-D7-C4)
Date: 2026-06-23 08:27:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-84-D7-C4)
Date: 2026-06-23 08:27:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 15 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 23 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-06-23 18:00:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-23 18: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-06-23 18:40:04 Database: brasilia Application: psql User: intelifix Remote: [local]
6 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 23 08 3 10 3 11 2 14 4 - ERROR: syntax error at or near "07898936084361" at character 31
- ERROR: syntax error at or near "07898936084361" at character 31
- ERROR: syntax error at or near "07898936084361" at character 31
Statement: SELECT * FROM RS_ETIQUETA((01)07898936084361)
Date: 2026-06-23 08:35:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA((01)07898936084361)
Date: 2026-06-23 08:35:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA((01)07898936084361)
Date: 2026-06-23 08:35:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 23 00 1 04 2 05 1 06 1 21 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-23 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-23 04:00:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-23 04:28:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
8 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 23 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-23 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-23 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-23 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 5 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 23 10 1 11 4 - ERROR: unterminated quoted string at or near "'229680301818'');" at character 39
- ERROR: unterminated quoted string at or near "'830310945001824'');" at character 39
- ERROR: unterminated quoted string at or near "'229847878902'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229680301818'');
Date: 2026-06-23 10:16:56 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('830310945001824'');
Date: 2026-06-23 11:39:21 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229847878902'');
Date: 2026-06-23 11:41:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 23 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-06-23 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-23 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-23 05:32:02 Database: contagem Application: psql User: intelifix Remote: [local]
11 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 23 09 3 - LOG: process 1837445 still waiting for ShareLock on transaction 1462971 after 1000.142 ms
- LOG: process 1837445 still waiting for ShareLock on transaction 1462971 after 9408.911 ms
- LOG: process 1837445 still waiting for ShareLock on transaction 1462971 after 106274.386 ms
Detail: Process holding the lock: 1839022. Wait queue: 1837445.
Context: while updating tuple (71178,33) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-23 09:05:19 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1839022. Wait queue: 1837445.
Context: while updating tuple (71178,33) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-23 09:05:28 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1839022. Wait queue: 1837445.
Context: while updating tuple (71178,33) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-23 09:07:04 Database: rio Application: psql User: intelifix Remote: [local]
12 2 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 23 08 2 - 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,'N-Na--N-Na');
Date: 2026-06-23 08:39:57 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( '2026-06-08', 0404 ,'', '',0,7,'N-Na--N-Na');
Date: 2026-06-23 08:40:29 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
13 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 23 10 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73917685850068803560)Date: 2026-06-23 10:03:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73917685850068803560)Date: 2026-06-23 10:03:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
14 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 23 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-23 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-23 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 23 07 2 - ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 0 ));Date: 2026-06-23 07:50:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 0 ));Date: 2026-06-23 07:50:27 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 23 03 1 - LOG: database system was shut down at 2026-06-23 03:05:01 -03
Date: 2026-06-23 03:05:02