pgBadger-
Global information
- Generated on Thu Aug 13 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 54,255 log entries in 14s
- Log start from 2026-08-12 00:00:02 to 2026-08-12 23:59:37
-
Overview
Global Stats
- 373 Number of unique normalized queries
- 6,175 Number of queries
- 9h30m20s Total query duration
- 2026-08-12 00:02:11 First query
- 2026-08-12 23:54:05 Last query
- 6 queries/s at 2026-08-12 11:05:14 Query peak
- 9h30m20s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h30m20s Execute total duration
- 6,851 Number of events
- 14 Number of unique normalized events
- 6,746 Max number of times the same event was reported
- 0 Number of cancellation
- 428 Total number of automatic vacuums
- 944 Total number of automatic analyzes
- 17 Number temporary file
- 240.10 MiB Max size of temporary file
- 108.47 MiB Average size of temporary file
- 497 Total number of sessions
- 8 sessions at 2026-08-12 19:05:02 Session peak
- 14d11h16m12s Total duration of sessions
- 41m55s Average duration of sessions
- 12 Average queries per session
- 1m8s Average queries duration per session
- 40m46s Average idle time per session
- 507 Total number of connections
- 5 connections/s at 2026-08-12 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-12 11:05:14 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-12 11:05:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-12 20:08:51 Date
Queries duration
Key values
- 9h30m20s 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) Aug 12 00 26 0ms 19s367ms 4s984ms 5s176ms 7s332ms 1m25s 01 42 0ms 5s132ms 1s133ms 4s417ms 6s668ms 9s602ms 02 17 0ms 4s229ms 1s995ms 4s44ms 6s35ms 6s990ms 03 19 0ms 10s788ms 2s272ms 4s960ms 6s616ms 13s56ms 04 27 0ms 4s70ms 1s509ms 4s672ms 6s445ms 8s201ms 05 35 0ms 9m16s 34s147ms 9s449ms 2m38s 9m16s 06 23 0ms 8s585ms 2s913ms 4s98ms 5s259ms 28s947ms 07 377 0ms 8m48s 5s668ms 1m6s 4m59s 8m48s 08 652 150ms 7m28s 2s792ms 43s923ms 1m31s 8m31s 09 584 151ms 9m23s 2s673ms 39s96ms 1m19s 9m35s 10 593 150ms 7m2s 2s417ms 54s915ms 1m43s 7m8s 11 545 0ms 8m 4s591ms 1m14s 6m36s 9m53s 12 288 0ms 40m15s 24s994ms 1m47s 24m13s 40m15s 13 424 0ms 6m3s 3s98ms 34s790ms 1m7s 6m57s 14 613 150ms 8m30s 4s586ms 1m36s 4m43s 9m9s 15 590 150ms 8m54s 3s614ms 52s244ms 5m 8m58s 16 480 150ms 9m12s 3s568ms 48s114ms 3m2s 9m13s 17 311 0ms 8m43s 4s591ms 48s282ms 1m30s 8m48s 18 27 0ms 6m19s 25s287ms 6s701ms 20s699ms 6m57s 19 24 0ms 5m55s 27s213ms 6s434ms 50s335ms 5m55s 20 126 0ms 7m59s 11s237ms 1m11s 1m34s 7m59s 21 39 0ms 5m53s 17s1ms 8s149ms 47s607ms 5m53s 22 30 0ms 6m43s 25s562ms 9s41ms 1m2s 6m43s 23 283 0ms 1m42s 8s583ms 1m7s 1m14s 1m42s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 12 00 3 0 4s568ms 0ms 0ms 0ms 01 24 0 278ms 224ms 278ms 1s31ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 189ms 0ms 0ms 0ms 04 9 0 317ms 0ms 234ms 797ms 05 16 0 290ms 0ms 435ms 781ms 06 7 0 2s235ms 0ms 0ms 1s270ms 07 265 0 6s576ms 5s788ms 19s883ms 6m15s 08 478 0 2s949ms 8s855ms 15s671ms 7m38s 09 468 0 2s761ms 9s756ms 16s912ms 4m40s 10 495 0 2s407ms 10s503ms 24s130ms 4m1s 11 445 0 4s887ms 11s162ms 1m4s 6m53s 12 185 0 34s630ms 6s319ms 1m27s 28m24s 13 327 0 3s283ms 12s813ms 31s212ms 3m36s 14 464 0 4s724ms 34s400ms 1m14s 6m34s 15 441 0 4s87ms 16s801ms 34s199ms 7m2s 16 345 0 4s364ms 13s748ms 23s512ms 4m39s 17 202 0 5s963ms 11s823ms 36s342ms 4m2s 18 9 0 1m10s 0ms 0ms 3m16s 19 6 0 1m40s 0ms 0ms 3m19s 20 16 92 12s463ms 25s976ms 1m7s 3m44s 21 16 0 37s540ms 0ms 645ms 3m16s 22 6 0 1m55s 0ms 0ms 3m48s 23 22 261 8s583ms 1m2s 1m6s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 12 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 Aug 12 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 12 12.00 0.00% 08 0 13 13.00 0.00% 09 0 12 12.00 0.00% 10 0 16 16.00 0.00% 11 0 15 15.00 0.00% 12 0 13 13.00 0.00% 13 0 13 13.00 0.00% 14 0 21 21.00 0.00% 15 0 14 14.00 0.00% 16 0 13 13.00 0.00% 17 0 8 8.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 10 10.00 0.00% Day Hour Count Average / Second Aug 12 00 16 0.00/s 01 11 0.00/s 02 9 0.00/s 03 17 0.00/s 04 9 0.00/s 05 10 0.00/s 06 17 0.00/s 07 22 0.01/s 08 24 0.01/s 09 24 0.01/s 10 32 0.01/s 11 27 0.01/s 12 22 0.01/s 13 31 0.01/s 14 33 0.01/s 15 29 0.01/s 16 29 0.01/s 17 18 0.01/s 18 20 0.01/s 19 21 0.01/s 20 23 0.01/s 21 24 0.01/s 22 17 0.00/s 23 22 0.01/s Day Hour Count Average Duration Average idle time Aug 12 00 8 1h22s 1h6s 01 15 1h48s 1h45s 02 11 1h21s 1h18s 03 19 21m51s 21m49s 04 7 1h3m 1h2m54s 05 10 55m36s 53m36s 06 9 57m13s 57m6s 07 17 54m24s 52m18s 08 23 51m37s 50m18s 09 23 49m20s 48m12s 10 31 42m34s 41m48s 11 28 42m19s 40m50s 12 31 41m31s 37m38s 13 22 33m53s 32m53s 14 31 40m17s 38m46s 15 33 39m22s 38m18s 16 27 39m49s 38m46s 17 26 43m7s 42m12s 18 19 34m2s 33m26s 19 23 31m 30m32s 20 20 33m28s 32m17s 21 21 35m33s 35m2s 22 20 42m19s 41m40s 23 23 30m18s 28m32s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-08-12 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 507 connections Total
Connections per user
Key values
- etiquetas Main User
- 507 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-12 19:05:02 Date
Histogram of session times
Key values
- 290 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 497 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 497 sessions Total
Sessions per host
Key values
- [local] Main Host
- 497 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 37,957 buffers Checkpoint Peak
- 2026-08-12 00:09:43 Date
- 269.993 seconds Highest write time
- 0.142 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-08-12 12:14:35 Date
Checkpoints distance
Key values
- 446.84 Mo Distance Peak
- 2026-08-12 12:14:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 12 00 52,052 657.249s 0.053s 657.363s 01 4,032 404.838s 0.074s 405.05s 02 1,418 142.441s 0.044s 142.532s 03 1,469 147.649s 0.059s 147.76s 04 2,692 270.385s 0.089s 270.636s 05 9,269 924.446s 0.156s 924.679s 06 6,167 384.224s 0.008s 384.249s 07 36,400 2,383.697s 0.487s 2,384.345s 08 59,733 3,238.34s 0.895s 3,239.496s 09 54,400 3,238.853s 0.555s 3,239.644s 10 50,454 3,238.809s 0.713s 3,239.707s 11 81,321 3,238.782s 0.676s 3,239.682s 12 54,663 2,546.049s 0.519s 2,546.746s 13 37,053 2,394.126s 0.655s 2,394.964s 14 65,840 3,220.719s 0.849s 3,221.788s 15 67,405 3,238.572s 0.688s 3,239.478s 16 43,487 2,740.829s 0.641s 2,741.638s 17 32,701 2,166.279s 0.449s 2,166.877s 18 2,350 235.569s 0.104s 235.715s 19 34 3.457s 0.008s 3.48s 20 1,107 219.351s 0.024s 219.397s 21 3,019 305.22s 0.116s 305.452s 22 2,031 204.01s 0.139s 204.332s 23 233 23.442s 0.011s 23.494s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 12 00 0 0 8 485 0.013s 0.006s 01 0 0 1 790 0.004s 0.01s 02 0 0 1 394 0.007s 0.006s 03 0 0 0 371 0.008s 0.006s 04 0 0 1 488 0.062s 0.006s 05 0 0 4 737 0.030s 0.008s 06 0 0 1 33 0.002s 0.002s 07 0 0 25 3,890 0.059s 0.012s 08 0 0 36 6,335 0.062s 0.012s 09 0 0 29 6,715 0.015s 0.012s 10 0 0 21 6,757 0.063s 0.012s 11 0 0 43 7,212 0.011s 0.012s 12 0 0 48 3,982 0.062s 0.012s 13 0 0 23 5,355 0.062s 0.012s 14 0 0 41 7,145 0.055s 0.012s 15 0 0 36 6,914 0.033s 0.012s 16 0 0 20 5,532 0.063s 0.012s 17 0 0 19 4,390 0.013s 0.01s 18 0 0 1 359 0.061s 0.007s 19 0 0 0 11 0.003s 0.002s 20 0 0 1 91 0.002s 0.003s 21 0 0 1 506 0.033s 0.008s 22 0 0 0 557 0.062s 0.037s 23 0 0 0 26 0.004s 0.005s Day Hour Count Avg time (sec) Aug 12 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 Aug 12 00 23,636.00 kB 60,219.17 kB 01 2,040.10 kB 28,897.50 kB 02 1,181.83 kB 13,048.50 kB 03 1,145.86 kB 2,894.29 kB 04 2,272.67 kB 2,847.50 kB 05 7,850.00 kB 16,341.25 kB 06 8,082.50 kB 14,375.50 kB 07 33,833.17 kB 72,975.25 kB 08 49,467.25 kB 100,045.00 kB 09 40,197.75 kB 74,075.00 kB 10 27,761.08 kB 49,606.33 kB 11 59,250.33 kB 92,769.42 kB 12 65,293.17 kB 161,100.83 kB 13 31,712.67 kB 75,122.50 kB 14 55,966.08 kB 88,576.42 kB 15 49,432.25 kB 102,100.92 kB 16 26,416.58 kB 62,862.75 kB 17 31,464.60 kB 65,552.70 kB 18 1,685.50 kB 47,173.00 kB 19 109.50 kB 30,637.00 kB 20 4,990.67 kB 24,766.67 kB 21 3,023.67 kB 16,703.17 kB 22 1,219.00 kB 8,883.75 kB 23 126.20 kB 4,838.40 kB -
Temporary Files
Size of temporary files
Key values
- 480.20 MiB Temp Files size Peak
- 2026-08-12 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-12 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.59 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 2 208.00 MiB 104.00 MiB 12 1 104.00 MiB 104.00 MiB 13 0 0 0 14 3 312.00 MiB 104.00 MiB 15 0 0 0 16 1 104.00 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 932.65 MiB 71.61 MiB 240.10 MiB 116.58 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-12 05:32:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-12 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 7 728.01 MiB 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( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:58:01 Duration: 40m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:43:38 Duration: 28m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:28:36 Duration: 20m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 183.30 MiB 91.65 MiB 91.65 MiB 91.65 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-12 05:30:41 Duration: 39s604ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-12 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 240.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 240.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 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-08-12 12:04:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-12 16:33:35 - 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-08-12 11:11:25 - 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-08-12 14:53:07 - 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-08-12 14:14:34 - 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-08-12 11:17:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 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-08-12 14:28:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 91.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-12 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 91.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-12 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 79.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 79.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 79.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 71.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 71.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 71.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-12 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 12.42 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-12 09:05:54 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 12.42 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-12 09:05:54 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (99) Main table analyzed (database rio)
- 944 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 99 brasilia.pg_catalog.pg_attribute 63 rio.public.usuarios 52 rio.pg_catalog.pg_class 47 rio.pg_catalog.pg_type 39 rio.public.temp0000288116 38 brasilia.pg_catalog.pg_class 37 rio.public.temp0000288192 35 brasilia.pg_catalog.pg_type 32 contagem.pg_catalog.pg_attribute 31 contagem.public.usuarios 31 rio.pg_catalog.pg_index 26 brasilia.pg_catalog.pg_index 24 rio.pg_catalog.pg_depend 20 brasilia.public.temp0000237972 19 brasilia.pg_catalog.pg_depend 19 rio.public.temp0000288148 17 rio.public.temp0000288126 16 brasilia.public.temp0000237976 16 rio.public.temp0000288216 15 contagem.pg_catalog.pg_class 15 rio.public.temp0000288118 14 contagem.pg_catalog.pg_type 12 rio.public.temp0000288184 10 brasilia.public.usuarios 10 rio.public.temp0000288106 10 rio.public.temp0000288136 9 rio.public.temp0000288130 8 brasilia.public.temp0000238064 7 rio.public.temp0000288172 7 contagem.pg_catalog.pg_index 7 rio.public.temp0000288128 7 brasilia.public.nf_entrada 7 rio.public.temp0000288124 7 rio.public.temp0000288204 6 rio.public.temp0000288122 6 rio.public.temp0000288174 6 contagem.pg_catalog.pg_depend 5 contagem.public.temp0000226812 4 brasilia.public.temp0000238034 4 rio.pg_catalog.pg_shdepend 4 brasilia.public.temp0000238008 4 brasilia.public.temp0000238038 4 rio.public.temp0000288108 4 brasilia.public.temp0000238012 3 brasilia.public.temp0000237986 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000238000 3 rio.public.temp0000288120 3 rio.public.temp0000288238 3 rio.public.tmp_drill_0320 3 rio.public.temp0000288244 3 brasilia.public.temp0000238002 3 rio.public.tmp_drill_0302 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000288234 2 rio.public.temp0000288162 2 rio.public.temp0000288240 2 brasilia.public.temp0000238058 2 postgres.pg_catalog.pg_shdepend 2 brasilia.public.temp0000237982 2 rio.public.temp0000288200 2 rio.public.temp0000288146 2 brasilia.public.temp0000237994 2 brasilia.public.temp0000238072 2 rio.public.temp0000288242 2 rio.public.temp0000288142 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000288206 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000288236 1 brasilia.public.temp0000238042 1 brasilia.public.temp0000238026 1 brasilia.public.temp0000237996 1 rio.public.temp0000288214 1 brasilia.public.temp0000237974 1 rio.public.temp0000288110 1 brasilia.public.temp0000238004 1 rio.public.temp0000288138 1 rio.public.temp0000288150 1 rio.public.temp0000288188 1 brasilia.public.temp0000238028 1 brasilia.public.temp0000238052 1 rio.public.temp0000288198 1 rio.auditor.auditor_2026_08 1 brasilia.auditor.auditor_2026_08 1 contagem.auditor.auditor_2026_08 1 brasilia.public.temp0000238024 1 brasilia.public.temp0000238032 1 rio.public.temp0000288144 1 rio.public.temp0000288154 1 rio.public.temp0000288186 1 contagem.public.temp0000226764 1 brasilia.public.temp0000238066 1 brasilia.public.temp0000237980 1 brasilia.public.temp0000237990 1 contagem.public.nf_entrada 1 brasilia.public.temp0000238062 1 rio.public.temp0000288218 1 contagem.public.temp0000226824 1 Total 944 Vacuums per table
Key values
- public.temp0000288116 (38) Main table vacuumed on database rio
- 428 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000288116 38 0 0 0 0 0 0 21,714 244 1,460,309 0 0 rio.pg_catalog.pg_attribute 33 32 0 0 0 0 0 17,553 4,269 6,490,562 254 6,037 contagem.public.usuarios 30 0 0 0 0 0 0 147 115 63,542 0 0 brasilia.pg_catalog.pg_attribute 25 23 0 0 0 0 0 11,501 2,572 4,299,562 98 2,655 rio.pg_catalog.pg_class 20 19 0 0 0 0 0 4,178 1,235 1,881,932 61 213 rio.public.temp0000288192 18 0 0 0 0 0 0 5,299 102 329,108 0 0 brasilia.pg_catalog.pg_class 18 15 0 0 0 0 0 3,043 624 1,070,169 43 122 rio.pg_catalog.pg_type 15 14 0 0 0 0 0 1,533 379 536,413 38 115 brasilia.pg_catalog.pg_type 15 13 0 0 0 0 0 1,312 328 470,807 23 72 rio.public.temp0000288216 14 0 0 0 0 0 0 20,681 55 1,230,729 0 0 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 628 193 191,089 31 67 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 6,060 1,591 2,944,659 7 156 rio.public.temp0000288184 9 0 0 0 0 0 0 1,754 28 108,393 0 0 brasilia.pg_catalog.pg_index 9 9 0 0 0 0 0 452 110 102,941 23 34 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,933 987 1,435,174 52 422 rio.public.temp0000288130 7 0 0 0 0 0 0 526 40 37,092 0 0 rio.public.temp0000288172 7 0 0 0 0 0 0 5,182 24 309,699 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,237 2,192 9,984,462 851 3,705 rio.public.usuarios 6 4 0 0 0 0 0 114 46 98,058 5 9 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,639 462 703,206 17 126 rio.public.temp0000288136 6 0 0 0 0 0 0 872 36 57,370 0 0 rio.public.temp0000288204 6 0 0 0 0 0 0 6,900 22 410,588 0 0 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 939 188 304,019 5 8 rio.public.temp0000288148 5 0 0 0 0 0 0 333 24 23,183 0 0 brasilia.public.temp0000238008 4 0 0 0 0 0 0 992 265 438,364 0 0 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 486 138 211,309 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,920 373 1,919,556 128 358 rio.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 560 133 269,916 23 42 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,752 660 2,635,770 352 2,473 rio.public.temp0000288128 4 0 0 0 0 0 0 290 167 259,827 0 0 brasilia.public.temp0000238038 4 0 0 0 0 0 0 983 260 436,879 0 0 rio.public.temp0000288244 3 0 0 0 0 0 0 5,169 12 306,780 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 423 114 209,271 15 34 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 180 9 38,870 0 0 rio.public.tmp_drill_0320 3 3 0 0 0 0 0 1,896 25 347,372 0 0 rio.public.temp0000288238 3 0 0 0 0 0 0 180 17 13,278 0 0 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 641 131 563,340 32 73 contagem.public.temp0000226812 3 0 0 0 0 0 0 331 18 22,415 0 0 brasilia.public.temp0000238012 3 0 0 0 0 0 0 505 17 33,188 0 0 brasilia.public.temp0000237994 2 0 0 0 0 0 0 496 12 31,548 0 0 rio.public.temp0000288146 2 0 0 0 0 0 0 280 148 250,968 0 0 brasilia.public.temp0000237982 2 0 0 0 0 0 0 256 11 17,307 0 0 brasilia.public.temp0000238000 2 0 0 0 0 0 0 496 13 33,677 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 138 35 39,897 0 0 rio.public.temp0000288206 2 0 0 0 0 0 0 3,446 8 204,520 0 0 rio.public.temp0000288162 2 0 0 0 0 0 0 102 11 7,722 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 795 183 416,639 1 6 rio.public.temp0000288142 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000288234 2 0 0 0 0 0 0 1,731 9 103,566 0 0 brasilia.public.nf_entrada 2 2 0 0 0 0 0 264 141 288,933 16 24 rio.public.temp0000288242 2 0 0 0 0 0 0 3,446 8 204,520 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 1,891 6 327,307 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 241 206 651,369 18 1,016 brasilia.public.notas_fiscais 1 1 0 0 0 0 0 67 47 146,494 4 379 rio.public.temp0000288200 1 0 0 0 0 0 0 8 5 1,368 0 0 brasilia.public.temp0000238052 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.logs 1 0 0 0 0 0 0 4,348 4,286 5,178,375 21 524 rio.public.temp0000288188 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000288124 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000288150 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000288186 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000288154 1 0 0 0 0 0 0 1,723 4 102,260 0 0 rio.public.temp0000288144 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000238024 1 0 0 0 0 0 0 249 6 15,823 0 0 rio.public.temp0000288214 1 0 0 0 0 0 0 8 5 1,289 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 20,814 12,360 14,714,324 3,794 64,122 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 22,055 10,784 14,456,669 5,582 127,133 brasilia.public.temp0000238042 1 0 0 0 0 0 0 248 6 15,779 0 0 brasilia.public.temp0000238026 1 0 0 0 0 0 0 248 6 15,773 0 0 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 54,220 36,967 45,299,028 8,651 160,406 rio.public.temp0000288236 1 0 0 0 0 0 0 85 6 5,927 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 164 8 45,955 2 7 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,198 11 168,549 2 22 brasilia.public.usuarios 1 1 0 0 0 0 0 31 13 33,459 3 107 Total 428 216 0 0 0 0 0 264,283 83,537 125,056,168 20,152 370,467 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (12.42) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000288116 0 0 0.97 rio.pg_catalog.pg_attribute 0 0 2.63 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 1.6 rio.pg_catalog.pg_class 0 0 0.8 rio.public.temp0000288192 0 0 0.36 brasilia.pg_catalog.pg_class 0 0 0.39 rio.pg_catalog.pg_type 0 0 0.23 brasilia.pg_catalog.pg_type 0 0 0.19 rio.public.temp0000288216 0 0 0.72 rio.pg_catalog.pg_index 0 0 0.22 contagem.pg_catalog.pg_attribute 0 0 1.18 rio.public.temp0000288184 0 0 0.42 brasilia.pg_catalog.pg_index 0 0 0.06 rio.pg_catalog.pg_depend 0 0 0.91 rio.public.temp0000288130 0 0 0.1 rio.public.temp0000288172 0 0 0.35 rio.pg_catalog.pg_statistic 0 0 1.22 rio.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_depend 0 0 0.27 rio.public.temp0000288136 0 0 0.1 rio.public.temp0000288204 0 0 0.32 contagem.pg_catalog.pg_class 0 0 0.55 rio.public.temp0000288148 0 0 0.02 brasilia.public.temp0000238008 0 0 0.07 contagem.pg_catalog.pg_type 0 0 0.11 rio.pg_toast.pg_toast_2619 0 0 0.15 rio.pg_catalog.pg_shdepend 0 0 0.14 brasilia.pg_catalog.pg_statistic 0 0 0.42 rio.public.temp0000288128 0 0 0.05 brasilia.public.temp0000238038 0 0 0.03 rio.public.temp0000288244 0 0 0.15 postgres.pg_catalog.pg_shdepend 0 0 0.26 rio.public.tmp_drill_0175 0 0 0.01 rio.public.tmp_drill_0320 0 0 0.07 rio.public.temp0000288238 0 0 0.06 brasilia.pg_toast.pg_toast_2619 0 0 0.05 contagem.public.temp0000226812 0 0 0.05 brasilia.public.temp0000238012 0 0 0.06 brasilia.public.temp0000237994 0 0 0.04 rio.public.temp0000288146 0 0 0.04 brasilia.public.temp0000237982 0 0 0.02 brasilia.public.temp0000238000 0 0 0.05 contagem.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000288206 0 0 0.1 rio.public.temp0000288162 0 0 0.02 contagem.pg_catalog.pg_depend 0 0 0.19 rio.public.temp0000288142 0 0 0 rio.public.temp0000288234 0 0 0.08 brasilia.public.nf_entrada 0 0 0.11 rio.public.temp0000288242 0 0 0.1 rio.public.tmp_drill_0302 0 0 0.05 brasilia.public.nf_entrada_arquivo_erros 0 0 0.23 brasilia.public.notas_fiscais 0 0 0.16 rio.public.temp0000288200 0 0 0.02 brasilia.public.temp0000238052 0 0 0.01 rio.public.logs 0 0 1.7 rio.public.temp0000288188 0 0 0.04 rio.public.temp0000288124 0 0 0 rio.public.temp0000288150 0 0 0 rio.public.temp0000288186 0 0 0.05 rio.public.temp0000288154 0 0 0.04 rio.public.temp0000288144 0 0 0 brasilia.public.temp0000238024 0 0 0.02 rio.public.temp0000288214 0 0 0.02 contagem.auditor.auditor_2026_08 0 0 4.39 brasilia.auditor.auditor_2026_08 0 0 3.87 brasilia.public.temp0000238042 0 0 0.02 brasilia.public.temp0000238026 0 0 0.02 rio.auditor.auditor_2026_08 0 0 12.42 rio.public.temp0000288236 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.07 brasilia.public.usuarios 0 0 0 Total 0 0 39.32 Tuples removed per table
Key values
- pg_catalog.pg_attribute (136538) Main table with removed tuples on database rio
- 416920 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 33 32 136,538 806,899 29,826 500 19,311 brasilia.pg_catalog.pg_attribute 25 23 107,289 569,546 16,007 128 15,236 rio.public.tmp_drill_0320 3 3 28,340 28,609 0 0 721 rio.public.tmp_drill_0302 2 2 28,199 28,689 0 0 724 contagem.pg_catalog.pg_attribute 10 10 26,043 234,432 0 313 5,256 rio.pg_catalog.pg_statistic 7 7 12,388 58,430 536 0 9,002 rio.pg_catalog.pg_depend 9 9 11,045 173,730 2,667 0 1,683 brasilia.pg_catalog.pg_statistic 4 4 7,855 32,096 0 0 4,288 rio.pg_catalog.pg_type 15 14 6,514 35,629 1,602 9 1,114 brasilia.pg_catalog.pg_class 18 15 5,861 68,266 4,415 0 2,386 brasilia.pg_catalog.pg_depend 6 6 5,800 107,985 0 0 1,063 brasilia.pg_catalog.pg_type 15 13 5,583 34,631 1,422 0 1,100 rio.pg_catalog.pg_shdepend 4 4 4,417 54,364 0 0 476 contagem.pg_catalog.pg_statistic 1 1 4,346 7,274 0 0 1,011 rio.pg_catalog.pg_class 20 19 3,159 74,867 3,948 67 2,499 postgres.pg_catalog.pg_shdepend 3 3 2,805 40,825 157 0 357 brasilia.pg_catalog.pg_index 9 9 2,702 17,101 186 6 485 rio.pg_catalog.pg_index 10 10 2,654 19,560 389 7 546 rio.auditor.auditor_2026_08 1 0 2,550 6,519,051 0 0 311,190 contagem.pg_catalog.pg_type 4 4 2,439 8,978 0 44 240 rio.public.tmp_drill_0175 3 3 1,927 2,129 0 0 58 contagem.public.usuarios 30 0 1,916 720 0 0 60 brasilia.public.nf_entrada 2 2 1,459 8,155 1,052 0 304 rio.pg_toast.pg_toast_2619 4 4 1,231 2,277 0 0 1,140 brasilia.auditor.auditor_2026_08 1 0 1,119 1,705,980 0 0 77,215 contagem.pg_catalog.pg_depend 2 2 966 37,675 0 33 345 contagem.pg_catalog.pg_class 5 5 548 17,768 0 0 752 brasilia.pg_toast.pg_toast_2619 3 3 339 414 0 0 222 rio.public.usuarios 6 4 320 3,512 458 0 96 brasilia.public.notas_fiscais 1 1 160 99,371 0 0 544 contagem.pg_toast.pg_toast_2619 1 1 151 119 0 0 62 brasilia.public.usuarios 1 1 137 429 0 0 11 contagem.pg_catalog.pg_index 2 2 117 3,789 0 23 96 brasilia.public.nf_entrada_arquivo_erros 1 0 3 1,690,732 0 0 30,571 brasilia.public.temp0000237994 2 0 0 6,397 0 32 480 brasilia.public.temp0000238008 4 0 0 12,802 0 64 960 rio.public.temp0000288146 2 0 0 11,810 0 120 264 rio.public.temp0000288184 9 0 0 218,540 0 0 15,552 rio.public.temp0000288192 18 0 0 133,099 0 870 5,466 rio.public.temp0000288200 1 0 0 6,454 0 48 144 brasilia.public.temp0000238052 1 0 0 3,206 0 0 256 rio.public.temp0000288130 7 0 0 27,520 0 225 607 rio.public.temp0000288244 3 0 0 72,884 0 0 5,184 brasilia.public.temp0000237982 2 0 0 6,395 0 32 480 rio.public.logs 1 0 0 16,344,474 0 0 653,057 rio.public.temp0000288188 1 0 0 24,283 0 0 1,728 brasilia.public.temp0000238000 2 0 0 6,400 0 32 480 rio.public.temp0000288124 1 0 0 1,227 0 0 64 rio.public.temp0000288216 14 0 0 340,049 0 0 24,192 rio.public.temp0000288150 1 0 0 1,220 0 0 64 rio.public.temp0000288186 1 0 0 24,283 0 0 1,728 rio.public.temp0000288206 2 0 0 48,587 0 0 3,456 rio.public.temp0000288162 2 0 0 7,387 0 93 163 rio.public.temp0000288172 7 0 0 169,955 0 0 12,096 rio.public.temp0000288238 3 0 0 4,577 0 151 233 rio.public.temp0000288136 6 0 0 36,865 0 265 823 rio.public.temp0000288154 1 0 0 24,290 0 0 1,728 rio.public.temp0000288142 2 0 0 2,440 0 0 128 rio.public.temp0000288144 1 0 0 1,220 0 0 64 rio.public.temp0000288234 2 0 0 25,832 0 49 1,807 rio.public.temp0000288204 6 0 0 145,734 0 0 10,368 rio.public.temp0000288128 4 0 0 11,855 0 89 263 brasilia.public.temp0000238024 1 0 0 3,202 0 16 240 rio.public.temp0000288214 1 0 0 1,372 0 57 71 contagem.auditor.auditor_2026_08 1 0 0 1,454,725 0 0 67,677 rio.public.temp0000288242 2 0 0 48,589 0 0 3,456 brasilia.public.temp0000238042 1 0 0 3,204 0 16 240 contagem.public.temp0000226812 3 0 0 3,970 0 78 306 brasilia.public.temp0000238026 1 0 0 3,202 0 16 240 rio.public.temp0000288236 1 0 0 1,499 0 51 77 rio.public.temp0000288148 5 0 0 9,095 0 73 311 brasilia.public.temp0000238038 4 0 0 12,820 0 16 1,008 rio.public.temp0000288116 38 0 0 427,889 0 476 29,124 brasilia.public.temp0000238012 3 0 0 9,602 0 48 720 Total 428 216 416,920 32,192,986 62,665 4,047 1,335,469 Pages removed per table
Key values
- public.temp0000288192 (870) Main table with removed pages on database rio
- 4047 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288192 18 0 0 870 rio.pg_catalog.pg_attribute 33 32 136538 500 rio.public.temp0000288116 38 0 0 476 contagem.pg_catalog.pg_attribute 10 10 26043 313 rio.public.temp0000288136 6 0 0 265 rio.public.temp0000288130 7 0 0 225 rio.public.temp0000288238 3 0 0 151 brasilia.pg_catalog.pg_attribute 25 23 107289 128 rio.public.temp0000288146 2 0 0 120 rio.public.temp0000288162 2 0 0 93 rio.public.temp0000288128 4 0 0 89 contagem.public.temp0000226812 3 0 0 78 rio.public.temp0000288148 5 0 0 73 rio.pg_catalog.pg_class 20 19 3159 67 brasilia.public.temp0000238008 4 0 0 64 rio.public.temp0000288214 1 0 0 57 rio.public.temp0000288236 1 0 0 51 rio.public.temp0000288234 2 0 0 49 rio.public.temp0000288200 1 0 0 48 brasilia.public.temp0000238012 3 0 0 48 contagem.pg_catalog.pg_type 4 4 2439 44 contagem.pg_catalog.pg_depend 2 2 966 33 brasilia.public.temp0000237994 2 0 0 32 brasilia.public.temp0000237982 2 0 0 32 brasilia.public.temp0000238000 2 0 0 32 contagem.pg_catalog.pg_index 2 2 117 23 brasilia.public.temp0000238024 1 0 0 16 brasilia.public.temp0000238042 1 0 0 16 brasilia.public.temp0000238026 1 0 0 16 brasilia.public.temp0000238038 4 0 0 16 rio.pg_catalog.pg_type 15 14 6514 9 rio.pg_catalog.pg_index 10 10 2654 7 brasilia.pg_catalog.pg_index 9 9 2702 6 brasilia.public.nf_entrada_arquivo_erros 1 0 3 0 rio.public.temp0000288184 9 0 0 0 brasilia.public.notas_fiscais 1 1 160 0 rio.public.usuarios 6 4 320 0 brasilia.pg_catalog.pg_class 18 15 5861 0 brasilia.public.temp0000238052 1 0 0 0 rio.public.temp0000288244 3 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 2805 0 rio.public.logs 1 0 0 0 rio.public.temp0000288188 1 0 0 0 contagem.pg_catalog.pg_class 5 5 548 0 rio.pg_toast.pg_toast_2619 4 4 1231 0 brasilia.pg_catalog.pg_depend 6 6 5800 0 rio.pg_catalog.pg_shdepend 4 4 4417 0 rio.public.temp0000288124 1 0 0 0 rio.public.temp0000288216 14 0 0 0 rio.public.tmp_drill_0175 3 3 1927 0 rio.public.temp0000288150 1 0 0 0 rio.public.tmp_drill_0320 3 3 28340 0 rio.public.temp0000288186 1 0 0 0 rio.public.temp0000288206 2 0 0 0 rio.public.temp0000288172 7 0 0 0 rio.pg_catalog.pg_statistic 7 7 12388 0 contagem.public.usuarios 30 0 1916 0 brasilia.pg_toast.pg_toast_2619 3 3 339 0 rio.public.temp0000288154 1 0 0 0 rio.public.temp0000288142 2 0 0 0 rio.public.temp0000288144 1 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7855 0 brasilia.public.nf_entrada 2 2 1459 0 rio.public.temp0000288204 6 0 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 brasilia.auditor.auditor_2026_08 1 0 1119 0 rio.public.temp0000288242 2 0 0 0 rio.pg_catalog.pg_depend 9 9 11045 0 rio.auditor.auditor_2026_08 1 0 2550 0 rio.public.tmp_drill_0302 2 2 28199 0 brasilia.pg_catalog.pg_type 15 13 5583 0 contagem.pg_toast.pg_toast_2619 1 1 151 0 contagem.pg_catalog.pg_statistic 1 1 4346 0 brasilia.public.usuarios 1 1 137 0 Total 428 216 416,920 4,047 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 12 00 0 0 01 1 6 02 0 0 03 0 0 04 0 4 05 8 6 06 0 0 07 19 53 08 53 125 09 37 90 10 26 78 11 52 100 12 29 47 13 39 74 14 60 116 15 53 112 16 26 70 17 19 58 18 0 0 19 0 0 20 0 0 21 6 5 22 0 0 23 0 0 - 12.42 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 6 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 38m59s 10m42s 15m2s 12m59s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:58:01 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:43:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:28:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 3m33s 3m33s 3m33s 3m33s call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 12:28:43 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 00:05:18 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 07:35:11 Database: rio User: intelifix Remote: [local] Application: psql
3 1 2m24s 2m24s 2m24s 2m24s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 14:47:37 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 00:05:31 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 20:05:13 Database: rio User: intelifix Remote: [local] Application: psql
4 1 2s105ms 2s105ms 2s105ms 2s105ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52175, 413, '73931685850072304194,229767451031,216925447375,216950342331,229830949214,229703003652,229800946678,229827640317,229711171924,229729972345,229836213454,229646798289,229765785469,229699802038,229695277274,229700888192,229702520519,229714739208,229833727374,216926108608,229775039818,229733337386,229777994259,216928470107,229793732024,229643172942,229830032020,229834482735,229708450514,229730228384,229836090210,229638413454,229776659314,216930087480,229730425879', '246554165569,246450380817,246447119397,246634019412,246505099804,246615474448,246633861417,246543601935,246564954557,246241034044,246460954351,246555061527,246512809816,246500453537,246512698592,246519793539,246553024863,226004949701,246444385562,246580091422,246567352244,246602805658,246452274660,246606453153,246476844050,246634155665,246251058198,246512093753,246553151015,246323283755,246446989812,246573945872,246452618688,246587382122,,,,,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-12 10:50:27 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR8C11237,3891484F8E65,3891484F8E66,ZTEGDB08AC55$ZTE3ANNRB729187,5872C990E543,5872C990E544,ZTEGDC619CD6$ZTE3ANNQ8M27884,843C99215573,843C99215574,ZTEGD7BAB459$ZTE3ANNR3Y33942,4896D952DC3C,4896D952DC3D,ZTEGD97EB54B$ZTE3ANNR1Y25649,14CA56CF03A1,14CA56CF03A2,ZTEGD970DA8C$ZTE3ANNR9W49885,D89A0DACED51,D89A0DACED52,ZTEGDB16D488$ZTE3ANNQ8M44172,843C9922D333,843C9922D334,ZTEGD7BAF3F9$ZTE3ANNQ8117200,689E29BD71EB,689E29BD71EC,ZTEGD7B77DC0$ZTE3ANNQ5N03691,3CF9F0AD1BF8,3CF9F0AD1BF9,ZTEGD641C4B2$ZTE3ANNQ9J14752,843C992D2AF5,843C992D2AF6,ZTEGD7BB424B$ZTE3ANNRCP20125,6C11BA6B027D,6C11BA6B027E,ZTEGDC6F8F30$ZTE3ANNR9W09073,D89A0DA930C9,D89A0DA930CA,ZTEGDB16351C$ZTE3ANNRAM21083,5872C989265B,5872C989265C,ZTEGDC60525A$ZTE3ANNT3H72879,D831399D6FB2,D831399D6FB3,ZTEGDD32ED4E$ZTE3ANNR9W55234,D89A0DAD6AAF,D89A0DAD6AB0,ZTEGDB16E96D$ZTE3ANNR4N57611,4896D95AA15A,4896D95AA15B,ZTEGD98000D0$ZTE3ANNQCA22634,14CA56D45757,14CA56D45758,ZTEGD971BDD5$ZTE3ANNR3Y33585,4896D952D3DE,4896D952D3DF,ZTEGD97EB3E6$ZTE3ANNR8C19586,389148505213,389148505214,ZTEGDB08CCF2$ZTE3ANNRB729227,5872C990E633,5872C990E634,ZTEGDC619CFE$ZTE3ANNR3Y35820,4896D9530840,4896D9530841,ZTEGD97EBCA1$ZTE3ANNQ7111286,C4EBFF8AD0EC,C4EBFF8AD0ED,ZTEGD70A48E8$ZTE3ANNQ8M27978,843C992157A7,843C992157A8,ZTEGD7BAB4B7$ZTE3ANNRB722571,5872C9904A33,5872C9904A34,ZTEGDC6182FE$ZTE3ANNR1Y25670,14CA56CF041F,14CA56CF0420,ZTEGD970DAA1$ZTE3ANNR9W54710,D89A0DAD5E67,D89A0DAD5E68,ZTEGDB16E761$ZTE3ANNRB729452,5872C990EB79,5872C990EB7A,ZTEGDC619DDF$ZTE3ANNQ8M19186,843C99208997,843C99208998,ZTEGD7BA925F$ZTE3ANNR2Q24065,F4E84F82E806,F4E84F82E807,ZTEGD97AD0BB$ZTE3ANNQCA14139,14CA56D3903D,14CA56D3903E,ZTEGD9719CA6$ZTE3ANNQ9J14873,843C992D2DCB,843C992D2DCC,ZTEGD7BB42C4$ZTE3ANNR9W55369,D89A0DAD6DD9,D89A0DAD6DDA,ZTEGDB16E9F4$ZTE3ANNQCA27461,14CA56D4C879,14CA56D4C87A,ZTEGD971D0B0$ZTE3ANNR9F14949,D89A0DA43C41,D89A0DA43C42,ZTEGDB1561B0$ZTE3ANNR4N57649,4896D95AA23E,4896D95AA23F,ZTEGD98000F6$ZTE3ANNT2V65665,D831399191DE,D831399191DF,ZTEGDD30F300$ZTE3ANNQ8118543,689E29BD9165,689E29BD9166,ZTEGD7B782FF$ZTE3ANNR9W09021,D89A0DA92F91,D89A0DA92F92,ZTEGDB1634E8$ZTE3ANNR4N57607,4896D95AA142,4896D95AA143,ZTEGD98000CC$ZTE3ANNRAM47376,5872C98B8E99,5872C98B8E9A,ZTEGDC60B90F', '',0318,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-08-12 08:25:32 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276896, 452, 'F200011067B307F,9877E74840AC$F200011117B2322,9877E77EEA13$F200011103BA6B3,9877E77BD23A$F200010277B4A28,743AEFABAB09$F200011216B2CC2,84011227C391$F200012333B214E,1834AF63389F$F20001017011114,743AEF5E72FE$F200011151B609B,9877E7BCA1BC$F200012325B576B,1834AF632042$F200010282BA374,743AEFAD02E9$F200010319B177F,743AEFD9BF88$F200011113BA032,9877E77E6BCD$F2000101691074C,743AEF5E14F5$F200011201B7CF7,84011205BE7D$F200011070B6207,9877E74943F2$F200011208B3A9F,84011206FFB9$F200011103B67D3,9877E77BB6B8$F20001018412AB7,743AEF747052$F200012022B7CB5,840112BE3EBE$F200011218B52EC,840112282608', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-12 12:03:42 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 15m2s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-12 12:43:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 13m14s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-12 12:28:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 10m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-12 12:28:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 3m33s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-08-12 12:28:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 2m24s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-12 14:47:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 2s105ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52369, 406, 'CP2233325KG,A0B53C971FE5,544D4242005C3074,A0B53C971FE8$CP2241326V8,A0B53CC3C2E4,544D4242005EAD63,A0B53CC3C2E7$CP230132E2N,D4925E037E23,544D424200614BCA,D4925E037E26$CP2319322GM,D4925E9FE49A,544D424200699354,D4925E9FE49D$CP2404325C9,08C7F525BAA3,544D424200772D5C,08C7F525BAA6$CP2301327K6,D4925E028544,544D424200613023,D4925E028547$CP234232UC6,D4925EF9B5E6,544D4242007259F3,D4925EF9B5E9', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""}]','$$$$$$','', 00);[ Date: 2026-08-12 11:02:18 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,250 Total read queries
- 1,383 Total write queries
Queries by database
Key values
- rio Main database
- 4,020 Requests
- 7h25m8s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,996 Requests
User Request type Count Duration etiquetas Total 64 16s709ms select 64 16s709ms intelifix Total 5,996 9h28m48s copy to 353 49m29s ddl 1,030 44m52s others 540 52m55s select 4,071 7h1m30s lenon Total 115 1m15s select 115 1m15s Duration by user
Key values
- 9h28m48s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 64 16s709ms select 64 16s709ms intelifix Total 5,996 9h28m48s copy to 353 49m29s ddl 1,030 44m52s others 540 52m55s select 4,071 7h1m30s lenon Total 115 1m15s select 115 1m15s Queries by host
Key values
- [local] Main host
- 6,175 Requests
- 9h30m20s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,068 Requests
- 4h28m48s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-12 08:44:53 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,989 100-500ms duration
Slowest individual queries
Rank Duration Query 1 40m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-12 12:58:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 28m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-12 12:43:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 20m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-12 12:28:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 9m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 09:14:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m16s analyze verbose;[ Date: 2026-08-12 05:09:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 16:14:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 15:13:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 07:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 17:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 14:13:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 12:13:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 8m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 11:13:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 20:13:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 7m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 08:12:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 10:12:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028372, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-12 15:35:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-12 22:11:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028346, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-12 11:02:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028351, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-12 11:42:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-12 14:47:33 - 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 2h38m30s 281 152ms 40m15s 33s844ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 12 07 7 11m14s 1m36s 08 32 5m57s 11s161ms 09 24 37s642ms 1s568ms 10 8 52s337ms 6s542ms 11 19 15m51s 50s78ms 12 15 1h30m29s 6m1s 13 45 2m31s 3s361ms 14 36 15m8s 25s234ms 15 19 7m33s 23s880ms 16 32 5m16s 9s897ms 17 44 2m57s 4s25ms [ User: intelifix - Total duration: 2h38m30s - Times executed: 281 ]
[ Application: [unknown] - Total duration: 2h38m30s - Times executed: 281 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:58:01 Duration: 40m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:43:38 Duration: 28m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:28:36 Duration: 20m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h12m13s 48 1s408ms 9m23s 2m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 12 07 3 9m31s 3m10s 08 3 7m54s 2m38s 09 3 10m3s 3m21s 10 3 7m36s 2m32s 11 3 8m45s 2m55s 12 3 9m4s 3m1s 13 3 6m23s 2m7s 14 3 9m10s 3m3s 15 3 9m34s 3m11s 16 3 9m54s 3m18s 17 3 9m28s 3m9s 18 3 6m43s 2m14s 19 3 6m14s 2m4s 20 3 8m29s 2m49s 21 3 6m11s 2m3s 22 3 7m7s 2m22s [ User: intelifix - Total duration: 2h12m13s - Times executed: 48 ]
[ Application: psql - Total duration: 2h12m13s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-12 09:14:25 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-12 16:14:14 Duration: 9m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-12 15:13:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
3 1h16m46s 48 223ms 4m37s 1m35s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 12 07 3 5m22s 1m47s 08 3 4m34s 1m31s 09 3 5m37s 1m52s 10 3 5m5s 1m41s 11 3 5m5s 1m41s 12 3 5m9s 1m43s 13 3 4m9s 1m23s 14 3 5m25s 1m48s 15 3 5m32s 1m50s 16 3 5m23s 1m47s 17 3 4m41s 1m33s 18 3 3m50s 1m16s 19 3 3m50s 1m16s 20 3 4m44s 1m34s 21 3 3m45s 1m15s 22 3 4m27s 1m29s [ User: intelifix - Total duration: 1h16m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h16m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-12 15:20:02 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-12 14:19:31 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-12 09:20:36 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m3s 1,328 150ms 5s348ms 951ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 12 07 33 27s511ms 833ms 08 134 2m12s 992ms 09 169 2m42s 964ms 10 211 3m5s 880ms 11 166 2m31s 911ms 12 70 1m8s 978ms 13 86 1m24s 988ms 14 152 2m34s 1s14ms 15 154 2m25s 941ms 16 112 1m30s 810ms 17 41 59s612ms 1s453ms [ User: intelifix - Total duration: 21m3s - Times executed: 1328 ]
[ Application: [unknown] - Total duration: 21m3s - Times executed: 1328 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52175, 413, '73931685850072304194,229767451031,216925447375,216950342331,229830949214,229703003652,229800946678,229827640317,229711171924,229729972345,229836213454,229646798289,229765785469,229699802038,229695277274,229700888192,229702520519,229714739208,229833727374,216926108608,229775039818,229733337386,229777994259,216928470107,229793732024,229643172942,229830032020,229834482735,229708450514,229730228384,229836090210,229638413454,229776659314,216930087480,229730425879', '246554165569,246450380817,246447119397,246634019412,246505099804,246615474448,246633861417,246543601935,246564954557,246241034044,246460954351,246555061527,246512809816,246500453537,246512698592,246519793539,246553024863,226004949701,246444385562,246580091422,246567352244,246602805658,246452274660,246606453153,246476844050,246634155665,246251058198,246512093753,246553151015,246323283755,246446989812,246573945872,246452618688,246587382122,,,,,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-12 10:50:27 Duration: 5s348ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR8C11237,3891484F8E65,3891484F8E66,ZTEGDB08AC55$ZTE3ANNRB729187,5872C990E543,5872C990E544,ZTEGDC619CD6$ZTE3ANNQ8M27884,843C99215573,843C99215574,ZTEGD7BAB459$ZTE3ANNR3Y33942,4896D952DC3C,4896D952DC3D,ZTEGD97EB54B$ZTE3ANNR1Y25649,14CA56CF03A1,14CA56CF03A2,ZTEGD970DA8C$ZTE3ANNR9W49885,D89A0DACED51,D89A0DACED52,ZTEGDB16D488$ZTE3ANNQ8M44172,843C9922D333,843C9922D334,ZTEGD7BAF3F9$ZTE3ANNQ8117200,689E29BD71EB,689E29BD71EC,ZTEGD7B77DC0$ZTE3ANNQ5N03691,3CF9F0AD1BF8,3CF9F0AD1BF9,ZTEGD641C4B2$ZTE3ANNQ9J14752,843C992D2AF5,843C992D2AF6,ZTEGD7BB424B$ZTE3ANNRCP20125,6C11BA6B027D,6C11BA6B027E,ZTEGDC6F8F30$ZTE3ANNR9W09073,D89A0DA930C9,D89A0DA930CA,ZTEGDB16351C$ZTE3ANNRAM21083,5872C989265B,5872C989265C,ZTEGDC60525A$ZTE3ANNT3H72879,D831399D6FB2,D831399D6FB3,ZTEGDD32ED4E$ZTE3ANNR9W55234,D89A0DAD6AAF,D89A0DAD6AB0,ZTEGDB16E96D$ZTE3ANNR4N57611,4896D95AA15A,4896D95AA15B,ZTEGD98000D0$ZTE3ANNQCA22634,14CA56D45757,14CA56D45758,ZTEGD971BDD5$ZTE3ANNR3Y33585,4896D952D3DE,4896D952D3DF,ZTEGD97EB3E6$ZTE3ANNR8C19586,389148505213,389148505214,ZTEGDB08CCF2$ZTE3ANNRB729227,5872C990E633,5872C990E634,ZTEGDC619CFE$ZTE3ANNR3Y35820,4896D9530840,4896D9530841,ZTEGD97EBCA1$ZTE3ANNQ7111286,C4EBFF8AD0EC,C4EBFF8AD0ED,ZTEGD70A48E8$ZTE3ANNQ8M27978,843C992157A7,843C992157A8,ZTEGD7BAB4B7$ZTE3ANNRB722571,5872C9904A33,5872C9904A34,ZTEGDC6182FE$ZTE3ANNR1Y25670,14CA56CF041F,14CA56CF0420,ZTEGD970DAA1$ZTE3ANNR9W54710,D89A0DAD5E67,D89A0DAD5E68,ZTEGDB16E761$ZTE3ANNRB729452,5872C990EB79,5872C990EB7A,ZTEGDC619DDF$ZTE3ANNQ8M19186,843C99208997,843C99208998,ZTEGD7BA925F$ZTE3ANNR2Q24065,F4E84F82E806,F4E84F82E807,ZTEGD97AD0BB$ZTE3ANNQCA14139,14CA56D3903D,14CA56D3903E,ZTEGD9719CA6$ZTE3ANNQ9J14873,843C992D2DCB,843C992D2DCC,ZTEGD7BB42C4$ZTE3ANNR9W55369,D89A0DAD6DD9,D89A0DAD6DDA,ZTEGDB16E9F4$ZTE3ANNQCA27461,14CA56D4C879,14CA56D4C87A,ZTEGD971D0B0$ZTE3ANNR9F14949,D89A0DA43C41,D89A0DA43C42,ZTEGDB1561B0$ZTE3ANNR4N57649,4896D95AA23E,4896D95AA23F,ZTEGD98000F6$ZTE3ANNT2V65665,D831399191DE,D831399191DF,ZTEGDD30F300$ZTE3ANNQ8118543,689E29BD9165,689E29BD9166,ZTEGD7B782FF$ZTE3ANNR9W09021,D89A0DA92F91,D89A0DA92F92,ZTEGDB1634E8$ZTE3ANNR4N57607,4896D95AA142,4896D95AA143,ZTEGD98000CC$ZTE3ANNRAM47376,5872C98B8E99,5872C98B8E9A,ZTEGDC60B90F', '',0318,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-08-12 08:25:32 Duration: 5s55ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276896, 452, 'F200011067B307F,9877E74840AC$F200011117B2322,9877E77EEA13$F200011103BA6B3,9877E77BD23A$F200010277B4A28,743AEFABAB09$F200011216B2CC2,84011227C391$F200012333B214E,1834AF63389F$F20001017011114,743AEF5E72FE$F200011151B609B,9877E7BCA1BC$F200012325B576B,1834AF632042$F200010282BA374,743AEFAD02E9$F200010319B177F,743AEFD9BF88$F200011113BA032,9877E77E6BCD$F2000101691074C,743AEF5E14F5$F200011201B7CF7,84011205BE7D$F200011070B6207,9877E74943F2$F200011208B3A9F,84011206FFB9$F200011103B67D3,9877E77BB6B8$F20001018412AB7,743AEF747052$F200012022B7CB5,840112BE3EBE$F200011218B52EC,840112282608', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-12 12:03:42 Duration: 4s970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 17m12s 3 2m38s 9m16s 5m44s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 12 05 3 17m12s 5m44s [ User: intelifix - Total duration: 17m12s - Times executed: 3 ]
[ Application: psql - Total duration: 17m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-12 05:09:18 Duration: 9m16s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-12 05:14:36 Duration: 5m17s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-12 05:17:14 Duration: 2m38s Database: contagem User: intelifix Remote: [local] Application: psql
6 15m26s 72 9s813ms 44s138ms 12s863ms create table temp0000288116 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 12 07 15 3m14s 12s982ms 08 15 2m59s 11s983ms 09 3 34s751ms 11s583ms 10 6 1m49s 18s218ms 11 8 1m39s 12s476ms 12 12 2m23s 11s994ms 14 4 51s751ms 12s937ms 15 9 1m52s 12s454ms [ User: intelifix - Total duration: 15m26s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15m26s - Times executed: 72 ]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 10:53:59 Duration: 44s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 07:07:10 Duration: 43s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 08:36:14 Duration: 14s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 14m23s 276 204ms 2m30s 3s129ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 12 00 12 37s280ms 3s106ms 01 12 28s781ms 2s398ms 02 12 26s369ms 2s197ms 03 12 32s531ms 2s710ms 04 12 24s784ms 2s65ms 05 12 26s566ms 2s213ms 06 12 25s168ms 2s97ms 07 12 27s410ms 2s284ms 08 12 31s600ms 2s633ms 09 12 33s233ms 2s769ms 10 12 33s521ms 2s793ms 11 12 31s800ms 2s650ms 12 12 29s442ms 2s453ms 13 12 30s746ms 2s562ms 14 12 2m58s 14s839ms 15 12 36s873ms 3s72ms 16 12 38s607ms 3s217ms 17 12 34s495ms 2s874ms 18 12 26s435ms 2s202ms 19 12 27s237ms 2s269ms 20 12 43s733ms 3s644ms 21 12 28s915ms 2s409ms 22 12 30s1ms 2s500ms [ User: intelifix - Total duration: 14m23s - Times executed: 276 ]
[ Application: psql - Total duration: 14m23s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 14:47:37 Duration: 2m30s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 00:05:31 Duration: 12s989ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 20:05:13 Duration: 12s116ms Database: rio User: intelifix Remote: [local] Application: psql
8 12m28s 160 154ms 3m41s 4s680ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 12 00 6 24s362ms 4s60ms 01 6 12s121ms 2s20ms 02 5 7s560ms 1s512ms 03 5 10s59ms 2s11ms 04 6 13s124ms 2s187ms 05 2 5s191ms 2s595ms 07 12 44s443ms 3s703ms 08 12 53s60ms 4s421ms 09 12 46s159ms 3s846ms 10 12 48s262ms 4s21ms 11 12 1m 5s55ms 12 12 4m21s 21s750ms 13 7 11s425ms 1s632ms 14 12 37s114ms 3s92ms 15 12 49s706ms 4s142ms 16 11 27s604ms 2s509ms 17 5 6s690ms 1s338ms 21 5 14s222ms 2s844ms 22 6 16s58ms 2s676ms [ User: intelifix - Total duration: 12m28s - Times executed: 160 ]
[ Application: psql - Total duration: 12m28s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 12:28:43 Duration: 3m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 00:05:18 Duration: 16s396ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 07:35:11 Duration: 10s612ms Database: rio User: intelifix Remote: [local] Application: psql
9 10m19s 1,162 151ms 8s475ms 533ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 12 07 100 1m9s 698ms 08 175 1m34s 539ms 09 160 1m22s 516ms 10 167 1m18s 470ms 11 112 1m1s 548ms 12 11 6s603ms 600ms 13 82 50s453ms 615ms 14 121 59s520ms 491ms 15 113 56s205ms 497ms 16 97 45s371ms 467ms 17 24 14s844ms 618ms [ User: intelifix - Total duration: 10m19s - Times executed: 1162 ]
[ Application: [unknown] - Total duration: 10m19s - Times executed: 1162 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "190", "itens" : "229877419494,229862596982,229863244352,229863262738,229862511318,229862518994,229862570415,229862558695,229862613348,229862360518,229862404360,229863197882,229862371529,229863170911,229868790315,229863822041,229863122242,229863128303,229863096481,229863109917,229863114160,229862843045,229862980208,229863014655,229863029707,229863712434,229863763449,229863141941,229863067387,229862986268,229862997582,229863013847,229863027888,229863046173,229872266175,229873324752,229875300221,229885777280,229875798911,229874653232,229885136679,229885191736,229885195069,229875733652,229875734056,229875737692", "usuario" : "414", "caixa" : "2915281", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-12 07:35:10 Duration: 8s475ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276829", "modelo" : "160", "itens" : "229846562747,229854536274,229840370426,229851582339,229847248403,229839379610,229852284663,229842862038,229852235264,229856166983,229845541424,229843002837,229851663536,229841504767,229856116372,229839980410,229853546368,229853153244,229852361820,229847832938,229843560120,229855182937,229853456786,229842015254,229843557694,229852145356,229846410611,229853967374,229855554567,229856278486,229861880819,229856914161,229837881114,229841912944,229845274450,229839650827,229846165255,229842625976,229853696787,229854545265,229840762540,229853520609,229839597487,229846413136,229842627895,229839350012,229856317581", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-12 07:27:43 Duration: 2s382ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276843", "modelo" : "263", "itens" : "229892358305,229898272036,229901149802,229895439705,229901823033,229909432732,229919775256,229901198594,229916424660,229900467580,229909064660,229899648601,229919352230,229871501118,229919384758,229893868092,229899123241,229876104754,229893039314,229895351010,229876167083,229896313438,229918455262,229895754360,229919296365,229919291921,229870706786,229913163747,229915409498,229910628493,229911940104,229897876183,229910144552,229916161425,229910189506,229900937177,229914665779,229897218789,229919424964,229915852528,229897478792,229915064359", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-12 08:08:25 Duration: 2s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m15s 73 1s645ms 28s956ms 6s792ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 12 07 3 11s693ms 3s897ms 08 2 13s544ms 6s772ms 09 1 4s860ms 4s860ms 10 5 55s721ms 11s144ms 11 1 4s732ms 4s732ms 13 5 54s675ms 10s935ms 14 9 57s50ms 6s338ms 15 22 2m31s 6s868ms 16 7 1m23s 11s868ms 17 18 59s384ms 3s299ms [ User: intelifix - Total duration: 8m15s - Times executed: 73 ]
[ Application: [unknown] - Total duration: 8m15s - Times executed: 73 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 15:37:42 Duration: 28s956ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 13:28:54 Duration: 27s988ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 10:04:57 Duration: 27s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m17s 70 2s894ms 8s428ms 3s675ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 12 08 6 20s795ms 3s465ms 09 5 19s311ms 3s862ms 10 5 16s642ms 3s328ms 11 6 21s307ms 3s551ms 12 4 13s368ms 3s342ms 13 4 14s749ms 3s687ms 14 6 21s635ms 3s605ms 15 6 22s525ms 3s754ms 16 5 17s354ms 3s470ms 17 4 13s151ms 3s287ms 18 4 13s784ms 3s446ms 19 4 13s862ms 3s465ms 20 4 19s468ms 4s867ms 21 4 13s31ms 3s257ms 22 3 16s285ms 5s428ms [ User: intelifix - Total duration: 4m17s - Times executed: 70 ]
[ Application: psql - Total duration: 4m17s - Times executed: 70 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 20:00:13 Duration: 8s428ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 22:20:12 Duration: 7s970ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 14:20:09 Duration: 5s364ms Database: brasilia User: intelifix Remote: [local] Application: psql
12 3m47s 15 10s935ms 44s38ms 15s179ms create table temp0000288216 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 12 14 11 2m14s 12s218ms 16 2 56s149ms 28s74ms 17 2 37s145ms 18s572ms [ User: intelifix - Total duration: 3m47s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 15 ]
-
CREATE TABLE temp0000288216 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 16:34:33 Duration: 44s38ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288216 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 17:19:21 Duration: 25s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288216 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 14:28:42 Duration: 14s579ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m25s 4 5s19ms 1m42s 51s330ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 12 20 2 1m37s 48s849ms 23 2 1m47s 53s810ms [ User: intelifix - Total duration: 3m25s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m25s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-12 23:17:37 Duration: 1m42s 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-08-12 20:08:50 Duration: 1m32s 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-08-12 23:40:14 Duration: 5s525ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2m56s 15 10s913ms 13s745ms 11s754ms create table temp0000288184 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 12 12 15 2m56s 11s754ms [ User: intelifix - Total duration: 2m56s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m56s - Times executed: 15 ]
-
CREATE TABLE temp0000288184 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:13:35 Duration: 13s745ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288184 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:03:30 Duration: 12s940ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288184 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:02:45 Duration: 11s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m50s 14 10s742ms 14s356ms 12s187ms create table temp0000288172 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 12 11 7 1m27s 12s450ms 12 7 1m23s 11s923ms [ User: intelifix - Total duration: 2m50s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 14 ]
-
CREATE TABLE temp0000288172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:01:15 Duration: 14s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 11:21:42 Duration: 13s667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 11:22:07 Duration: 13s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m35s 31 283ms 18s892ms 5s24ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 12 07 3 23s219ms 7s739ms 08 3 9s468ms 3s156ms 09 3 14s259ms 4s753ms 10 1 16s854ms 16s854ms 11 5 23s615ms 4s723ms 12 3 12s379ms 4s126ms 13 3 11s491ms 3s830ms 14 5 23s318ms 4s663ms 15 4 20s855ms 5s213ms 17 1 283ms 283ms [ User: intelifix - Total duration: 2m35s - Times executed: 31 ]
[ Application: psql - Total duration: 2m35s - Times executed: 31 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028332);
Date: 2026-08-12 07:08:51 Duration: 18s892ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028351);
Date: 2026-08-12 11:31:15 Duration: 17s483ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028346);
Date: 2026-08-12 10:55:35 Duration: 16s854ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m7s 43 216ms 22s733ms 2s969ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 12 07 5 2s978ms 595ms 08 5 2s312ms 462ms 09 4 1s224ms 306ms 10 2 850ms 425ms 11 6 36s407ms 6s67ms 12 6 12s802ms 2s133ms 13 2 586ms 293ms 14 7 52s831ms 7s547ms 15 3 1s357ms 452ms 16 1 6s515ms 6s515ms 17 2 9s829ms 4s914ms [ User: intelifix - Total duration: 2m7s - Times executed: 43 ]
[ Application: psql - Total duration: 2m7s - Times executed: 43 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028347);
Date: 2026-08-12 11:13:11 Duration: 22s733ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028369);
Date: 2026-08-12 14:55:45 Duration: 22s175ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028363);
Date: 2026-08-12 14:17:08 Duration: 21s353ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m3s 4 361ms 1m5s 30s903ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 12 20 2 57s678ms 28s839ms 23 2 1m5s 32s967ms [ User: intelifix - Total duration: 2m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-12 23:13:59 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-12 20:05:33 Duration: 57s259ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-12 20:10:08 Duration: 418ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m55s 29 2s400ms 11s116ms 3s983ms create table temp0000288116 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 12 07 4 18s772ms 4s693ms 08 10 29s712ms 2s971ms 09 2 6s253ms 3s126ms 12 4 21s65ms 5s266ms 14 4 22s694ms 5s673ms 15 5 17s27ms 3s405ms [ User: intelifix - Total duration: 1m55s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 29 ]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 14:53:28 Duration: 11s116ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 12:06:44 Duration: 10s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 07:09:17 Duration: 10s200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m44s 6 11s214ms 41s698ms 17s447ms create table temp0000288192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 12 13 6 1m44s 17s447ms [ User: intelifix - Total duration: 1m44s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 6 ]
-
CREATE TABLE temp0000288192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 13:45:23 Duration: 41s698ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 13:45:44 Duration: 13s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 13:47:11 Duration: 13s6ms 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,328 21m3s 150ms 5s348ms 951ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 12 07 33 27s511ms 833ms 08 134 2m12s 992ms 09 169 2m42s 964ms 10 211 3m5s 880ms 11 166 2m31s 911ms 12 70 1m8s 978ms 13 86 1m24s 988ms 14 152 2m34s 1s14ms 15 154 2m25s 941ms 16 112 1m30s 810ms 17 41 59s612ms 1s453ms [ User: intelifix - Total duration: 21m3s - Times executed: 1328 ]
[ Application: [unknown] - Total duration: 21m3s - Times executed: 1328 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52175, 413, '73931685850072304194,229767451031,216925447375,216950342331,229830949214,229703003652,229800946678,229827640317,229711171924,229729972345,229836213454,229646798289,229765785469,229699802038,229695277274,229700888192,229702520519,229714739208,229833727374,216926108608,229775039818,229733337386,229777994259,216928470107,229793732024,229643172942,229830032020,229834482735,229708450514,229730228384,229836090210,229638413454,229776659314,216930087480,229730425879', '246554165569,246450380817,246447119397,246634019412,246505099804,246615474448,246633861417,246543601935,246564954557,246241034044,246460954351,246555061527,246512809816,246500453537,246512698592,246519793539,246553024863,226004949701,246444385562,246580091422,246567352244,246602805658,246452274660,246606453153,246476844050,246634155665,246251058198,246512093753,246553151015,246323283755,246446989812,246573945872,246452618688,246587382122,,,,,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-12 10:50:27 Duration: 5s348ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR8C11237,3891484F8E65,3891484F8E66,ZTEGDB08AC55$ZTE3ANNRB729187,5872C990E543,5872C990E544,ZTEGDC619CD6$ZTE3ANNQ8M27884,843C99215573,843C99215574,ZTEGD7BAB459$ZTE3ANNR3Y33942,4896D952DC3C,4896D952DC3D,ZTEGD97EB54B$ZTE3ANNR1Y25649,14CA56CF03A1,14CA56CF03A2,ZTEGD970DA8C$ZTE3ANNR9W49885,D89A0DACED51,D89A0DACED52,ZTEGDB16D488$ZTE3ANNQ8M44172,843C9922D333,843C9922D334,ZTEGD7BAF3F9$ZTE3ANNQ8117200,689E29BD71EB,689E29BD71EC,ZTEGD7B77DC0$ZTE3ANNQ5N03691,3CF9F0AD1BF8,3CF9F0AD1BF9,ZTEGD641C4B2$ZTE3ANNQ9J14752,843C992D2AF5,843C992D2AF6,ZTEGD7BB424B$ZTE3ANNRCP20125,6C11BA6B027D,6C11BA6B027E,ZTEGDC6F8F30$ZTE3ANNR9W09073,D89A0DA930C9,D89A0DA930CA,ZTEGDB16351C$ZTE3ANNRAM21083,5872C989265B,5872C989265C,ZTEGDC60525A$ZTE3ANNT3H72879,D831399D6FB2,D831399D6FB3,ZTEGDD32ED4E$ZTE3ANNR9W55234,D89A0DAD6AAF,D89A0DAD6AB0,ZTEGDB16E96D$ZTE3ANNR4N57611,4896D95AA15A,4896D95AA15B,ZTEGD98000D0$ZTE3ANNQCA22634,14CA56D45757,14CA56D45758,ZTEGD971BDD5$ZTE3ANNR3Y33585,4896D952D3DE,4896D952D3DF,ZTEGD97EB3E6$ZTE3ANNR8C19586,389148505213,389148505214,ZTEGDB08CCF2$ZTE3ANNRB729227,5872C990E633,5872C990E634,ZTEGDC619CFE$ZTE3ANNR3Y35820,4896D9530840,4896D9530841,ZTEGD97EBCA1$ZTE3ANNQ7111286,C4EBFF8AD0EC,C4EBFF8AD0ED,ZTEGD70A48E8$ZTE3ANNQ8M27978,843C992157A7,843C992157A8,ZTEGD7BAB4B7$ZTE3ANNRB722571,5872C9904A33,5872C9904A34,ZTEGDC6182FE$ZTE3ANNR1Y25670,14CA56CF041F,14CA56CF0420,ZTEGD970DAA1$ZTE3ANNR9W54710,D89A0DAD5E67,D89A0DAD5E68,ZTEGDB16E761$ZTE3ANNRB729452,5872C990EB79,5872C990EB7A,ZTEGDC619DDF$ZTE3ANNQ8M19186,843C99208997,843C99208998,ZTEGD7BA925F$ZTE3ANNR2Q24065,F4E84F82E806,F4E84F82E807,ZTEGD97AD0BB$ZTE3ANNQCA14139,14CA56D3903D,14CA56D3903E,ZTEGD9719CA6$ZTE3ANNQ9J14873,843C992D2DCB,843C992D2DCC,ZTEGD7BB42C4$ZTE3ANNR9W55369,D89A0DAD6DD9,D89A0DAD6DDA,ZTEGDB16E9F4$ZTE3ANNQCA27461,14CA56D4C879,14CA56D4C87A,ZTEGD971D0B0$ZTE3ANNR9F14949,D89A0DA43C41,D89A0DA43C42,ZTEGDB1561B0$ZTE3ANNR4N57649,4896D95AA23E,4896D95AA23F,ZTEGD98000F6$ZTE3ANNT2V65665,D831399191DE,D831399191DF,ZTEGDD30F300$ZTE3ANNQ8118543,689E29BD9165,689E29BD9166,ZTEGD7B782FF$ZTE3ANNR9W09021,D89A0DA92F91,D89A0DA92F92,ZTEGDB1634E8$ZTE3ANNR4N57607,4896D95AA142,4896D95AA143,ZTEGD98000CC$ZTE3ANNRAM47376,5872C98B8E99,5872C98B8E9A,ZTEGDC60B90F', '',0318,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-08-12 08:25:32 Duration: 5s55ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276896, 452, 'F200011067B307F,9877E74840AC$F200011117B2322,9877E77EEA13$F200011103BA6B3,9877E77BD23A$F200010277B4A28,743AEFABAB09$F200011216B2CC2,84011227C391$F200012333B214E,1834AF63389F$F20001017011114,743AEF5E72FE$F200011151B609B,9877E7BCA1BC$F200012325B576B,1834AF632042$F200010282BA374,743AEFAD02E9$F200010319B177F,743AEFD9BF88$F200011113BA032,9877E77E6BCD$F2000101691074C,743AEF5E14F5$F200011201B7CF7,84011205BE7D$F200011070B6207,9877E74943F2$F200011208B3A9F,84011206FFB9$F200011103B67D3,9877E77BB6B8$F20001018412AB7,743AEF747052$F200012022B7CB5,840112BE3EBE$F200011218B52EC,840112282608', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-12 12:03:42 Duration: 4s970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,162 10m19s 151ms 8s475ms 533ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 12 07 100 1m9s 698ms 08 175 1m34s 539ms 09 160 1m22s 516ms 10 167 1m18s 470ms 11 112 1m1s 548ms 12 11 6s603ms 600ms 13 82 50s453ms 615ms 14 121 59s520ms 491ms 15 113 56s205ms 497ms 16 97 45s371ms 467ms 17 24 14s844ms 618ms [ User: intelifix - Total duration: 10m19s - Times executed: 1162 ]
[ Application: [unknown] - Total duration: 10m19s - Times executed: 1162 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "190", "itens" : "229877419494,229862596982,229863244352,229863262738,229862511318,229862518994,229862570415,229862558695,229862613348,229862360518,229862404360,229863197882,229862371529,229863170911,229868790315,229863822041,229863122242,229863128303,229863096481,229863109917,229863114160,229862843045,229862980208,229863014655,229863029707,229863712434,229863763449,229863141941,229863067387,229862986268,229862997582,229863013847,229863027888,229863046173,229872266175,229873324752,229875300221,229885777280,229875798911,229874653232,229885136679,229885191736,229885195069,229875733652,229875734056,229875737692", "usuario" : "414", "caixa" : "2915281", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-12 07:35:10 Duration: 8s475ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276829", "modelo" : "160", "itens" : "229846562747,229854536274,229840370426,229851582339,229847248403,229839379610,229852284663,229842862038,229852235264,229856166983,229845541424,229843002837,229851663536,229841504767,229856116372,229839980410,229853546368,229853153244,229852361820,229847832938,229843560120,229855182937,229853456786,229842015254,229843557694,229852145356,229846410611,229853967374,229855554567,229856278486,229861880819,229856914161,229837881114,229841912944,229845274450,229839650827,229846165255,229842625976,229853696787,229854545265,229840762540,229853520609,229839597487,229846413136,229842627895,229839350012,229856317581", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-12 07:27:43 Duration: 2s382ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276843", "modelo" : "263", "itens" : "229892358305,229898272036,229901149802,229895439705,229901823033,229909432732,229919775256,229901198594,229916424660,229900467580,229909064660,229899648601,229919352230,229871501118,229919384758,229893868092,229899123241,229876104754,229893039314,229895351010,229876167083,229896313438,229918455262,229895754360,229919296365,229919291921,229870706786,229913163747,229915409498,229910628493,229911940104,229897876183,229910144552,229916161425,229910189506,229900937177,229914665779,229897218789,229919424964,229915852528,229897478792,229915064359", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-12 08:08:25 Duration: 2s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 281 2h38m30s 152ms 40m15s 33s844ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 12 07 7 11m14s 1m36s 08 32 5m57s 11s161ms 09 24 37s642ms 1s568ms 10 8 52s337ms 6s542ms 11 19 15m51s 50s78ms 12 15 1h30m29s 6m1s 13 45 2m31s 3s361ms 14 36 15m8s 25s234ms 15 19 7m33s 23s880ms 16 32 5m16s 9s897ms 17 44 2m57s 4s25ms [ User: intelifix - Total duration: 2h38m30s - Times executed: 281 ]
[ Application: [unknown] - Total duration: 2h38m30s - Times executed: 281 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:58:01 Duration: 40m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:43:38 Duration: 28m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:28:36 Duration: 20m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 276 14m23s 204ms 2m30s 3s129ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 12 00 12 37s280ms 3s106ms 01 12 28s781ms 2s398ms 02 12 26s369ms 2s197ms 03 12 32s531ms 2s710ms 04 12 24s784ms 2s65ms 05 12 26s566ms 2s213ms 06 12 25s168ms 2s97ms 07 12 27s410ms 2s284ms 08 12 31s600ms 2s633ms 09 12 33s233ms 2s769ms 10 12 33s521ms 2s793ms 11 12 31s800ms 2s650ms 12 12 29s442ms 2s453ms 13 12 30s746ms 2s562ms 14 12 2m58s 14s839ms 15 12 36s873ms 3s72ms 16 12 38s607ms 3s217ms 17 12 34s495ms 2s874ms 18 12 26s435ms 2s202ms 19 12 27s237ms 2s269ms 20 12 43s733ms 3s644ms 21 12 28s915ms 2s409ms 22 12 30s1ms 2s500ms [ User: intelifix - Total duration: 14m23s - Times executed: 276 ]
[ Application: psql - Total duration: 14m23s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 14:47:37 Duration: 2m30s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 00:05:31 Duration: 12s989ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 20:05:13 Duration: 12s116ms Database: rio User: intelifix Remote: [local] Application: psql
5 160 12m28s 154ms 3m41s 4s680ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 12 00 6 24s362ms 4s60ms 01 6 12s121ms 2s20ms 02 5 7s560ms 1s512ms 03 5 10s59ms 2s11ms 04 6 13s124ms 2s187ms 05 2 5s191ms 2s595ms 07 12 44s443ms 3s703ms 08 12 53s60ms 4s421ms 09 12 46s159ms 3s846ms 10 12 48s262ms 4s21ms 11 12 1m 5s55ms 12 12 4m21s 21s750ms 13 7 11s425ms 1s632ms 14 12 37s114ms 3s92ms 15 12 49s706ms 4s142ms 16 11 27s604ms 2s509ms 17 5 6s690ms 1s338ms 21 5 14s222ms 2s844ms 22 6 16s58ms 2s676ms [ User: intelifix - Total duration: 12m28s - Times executed: 160 ]
[ Application: psql - Total duration: 12m28s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 12:28:43 Duration: 3m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 00:05:18 Duration: 16s396ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 07:35:11 Duration: 10s612ms Database: rio User: intelifix Remote: [local] Application: psql
6 136 33s127ms 151ms 2s886ms 243ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 12 01 17 3s969ms 233ms 04 5 1s164ms 232ms 05 12 3s39ms 253ms 07 14 3s69ms 219ms 08 12 2s566ms 213ms 09 11 2s262ms 205ms 10 14 2s961ms 211ms 11 20 7s330ms 366ms 12 13 2s564ms 197ms 14 5 1s531ms 306ms 15 10 1s917ms 191ms 16 3 749ms 249ms [ User: intelifix - Total duration: 33s127ms - Times executed: 136 ]
[ Application: [unknown] - Total duration: 33s127ms - Times executed: 136 ]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '3CF9F06C359D,9C635B869944,E466AB5166AC,E466AB59395C,E466AB58507C,E466AB535A08,E466AB56D538,3CF9F06BBA0D,E466AB5380D2,E466AB59DE80', NULL, NULL, 0303, 00);
Date: 2026-08-12 11:55:11 Duration: 2s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, 'ZTEGDB16D8DE,ZTEGDB01ABBB,ZTEGD6415ED3,ZTEGD7BBE711,ZTEGDB14E454,843C9932AB09,ZTEGDB00D1D2,ZTEGD97F61AC,ZTEGD64131EC,ZTEGDC6E225F,ZTEGD971CEF7,ZTEGD641DDA9,ZTEGDB00DF9B,ZTEGD641E81F,ZTEGD7BB11B5,ZTEGD971E3AE,ZTEGD970F1A7,ZTEGDC61464B,ZTEGD7BB8096', NULL, NULL, 0318, 00);
Date: 2026-08-12 11:23:45 Duration: 454ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241660392331,241668207986,241730924242,241607892628,241631096688,241710336677,241607893234,241693231215,241602674554,241726874756,241608110708,241659765367,241607892022,241674358283,241673058493,241606021436,241692604150,241708862729', NULL, NULL, 0320, 00);
Date: 2026-08-12 01:29:32 Duration: 445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 111 1m17s 150ms 3s537ms 696ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 12 08 18 7s183ms 399ms 09 9 3s915ms 435ms 10 1 866ms 866ms 11 5 15s627ms 3s125ms 13 28 18s516ms 661ms 14 7 7s115ms 1s16ms 15 6 4s958ms 826ms 16 16 8s383ms 523ms 17 21 10s733ms 511ms [ User: intelifix - Total duration: 1m17s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 1m17s - Times executed: 111 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131771) LIMIT 1;
Date: 2026-08-12 11:31:30 Duration: 3s537ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131663) LIMIT 1;
Date: 2026-08-12 11:36:22 Duration: 3s416ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131154) LIMIT 1;
Date: 2026-08-12 11:38:57 Duration: 2s987ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
8 109 48s995ms 268ms 789ms 449ms 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 #8
Day Hour Count Duration Avg duration Aug 12 01 2 857ms 428ms 04 2 703ms 351ms 05 2 733ms 366ms 06 1 428ms 428ms 07 9 3s602ms 400ms 08 11 4s826ms 438ms 09 10 4s614ms 461ms 10 11 5s447ms 495ms 11 7 3s700ms 528ms 12 6 2s900ms 483ms 13 11 5s298ms 481ms 14 13 5s691ms 437ms 15 9 3s748ms 416ms 16 7 2s961ms 423ms 17 6 2s822ms 470ms 21 2 658ms 329ms [ User: lenon - Total duration: 48s995ms - Times executed: 109 ]
[ Application: [unknown] - Total duration: 48s995ms - Times executed: 109 ]
-
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-08-12 09:05:27 Duration: 789ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-12 14:24:54 Duration: 697ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-12 11:10:54 Duration: 677ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 102 57s305ms 338ms 865ms 561ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 12 01 2 1s247ms 623ms 04 1 512ms 512ms 05 2 881ms 440ms 07 8 4s201ms 525ms 08 11 5s996ms 545ms 09 10 5s643ms 564ms 10 11 6s634ms 603ms 11 7 4s481ms 640ms 12 6 3s427ms 571ms 13 10 5s652ms 565ms 14 13 6s920ms 532ms 15 9 4s837ms 537ms 16 6 3s445ms 574ms 17 6 3s421ms 570ms [ User: intelifix - Total duration: 57s305ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 57s305ms - Times executed: 102 ]
-
select * from rs_menu_grants (184, 20, 1);
Date: 2026-08-12 09:05:27 Duration: 865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (184, 19, 1);
Date: 2026-08-12 14:24:54 Duration: 827ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-12 11:45:13 Duration: 820ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 102 43s909ms 251ms 1s274ms 430ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 12 07 3 908ms 302ms 08 14 5s406ms 386ms 09 11 4s425ms 402ms 10 11 6s12ms 546ms 11 10 4s743ms 474ms 12 10 3s841ms 384ms 13 5 2s47ms 409ms 14 18 7s619ms 423ms 15 11 5s109ms 464ms 16 4 1s722ms 430ms 17 5 2s73ms 414ms [ User: intelifix - Total duration: 43s909ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 43s909ms - Times executed: 102 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-12 10:51:55 Duration: 1s274ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-12 11:10:10 Duration: 736ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-12 09:00:58 Duration: 716ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 93 21s223ms 150ms 1s227ms 228ms create table temp0000237972 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 12 08 13 3s940ms 303ms 10 15 3s19ms 201ms 11 1 197ms 197ms 12 6 946ms 157ms 13 8 1s718ms 214ms 14 6 1s203ms 200ms 15 9 1s839ms 204ms 16 17 3s954ms 232ms 17 18 4s402ms 244ms [ User: intelifix - Total duration: 21s223ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 21s223ms - Times executed: 93 ]
-
CREATE TABLE temp0000237972 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "07-08-2026", "data-ate" : "12-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-12 08:02:52 Duration: 1s227ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237972 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "11-08-2026", "data-ate" : "11-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-12 08:03:29 Duration: 377ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237972 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "12-08-2026", "data-ate" : "12-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-12 17:16:18 Duration: 374ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 84 20s606ms 150ms 841ms 245ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 12 01 1 205ms 205ms 07 3 480ms 160ms 08 1 165ms 165ms 09 1 215ms 215ms 10 3 512ms 170ms 11 6 2s112ms 352ms 12 5 1s322ms 264ms 13 5 1s169ms 233ms 14 14 3s287ms 234ms 15 15 4s399ms 293ms 16 19 4s241ms 223ms 17 10 2s303ms 230ms 21 1 189ms 189ms [ User: intelifix - Total duration: 20s606ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 20s606ms - Times executed: 84 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-12", "data-ate" : "2026-08-12", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-12 11:50:47 Duration: 841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-12", "data-ate" : "2026-08-12", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-12 15:03:17 Duration: 737ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-08-12", "data-ate" : "2026-08-12", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-08-12 16:21:37 Duration: 711ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 80 36s900ms 151ms 1s15ms 461ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 12 08 8 2s508ms 313ms 09 11 3s401ms 309ms 10 9 4s695ms 521ms 11 12 6s172ms 514ms 13 2 838ms 419ms 14 10 4s381ms 438ms 15 18 9s858ms 547ms 16 10 5s43ms 504ms [ User: intelifix - Total duration: 36s900ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 36s900ms - Times executed: 80 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229655513540,229655069298,216898987172,229723352529,216904333845,229724268386,216855982022,216896834763,229720011732,229722349109,216897547694,216896711014,229724775260,229655293238,216946255265,229659207076,229647620930,216904958282,229647319306,229723275776,229719921521,229724425372,216904838798,229657498605,229724393551,229721454061,229656714555,229658983340,216886847379,229719202629,216886554747,229655328594', '','DEFAULT',056,0131,'', '','', 00);
Date: 2026-08-12 15:07:04 Duration: 1s15ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 0, 1, 26, '229885620319,229839197796,229870498607,229855029510,229853668805,229861810206,229854788498,229856934163,229869895057,229868803043,229862364962,229907972848,229894217273,229905204564,229862821225,229875606467,229869482032,229868700609,229875729409,229869002232,229863425559,229873296365,229874750212,229905320917,229872605153,229875648895,229862973439,229869171620,229869861923,229874726875,229875150408,229847154353,229841030625,229894967784,229869036073,229870510909,229862371731,229863797492,229894078494', '','DEFAULT',056,00,'', '','', 00);
Date: 2026-08-12 09:57:10 Duration: 990ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F82E3F711976,BC76C5B478E5,F09BB85837D9,D44649B6A35B,9400B0EB132C,B85FB00C3463,04E7959844F3,C40D96B2C388,CCB1827EEF1B,80E1BFFED580,BC76C5B47E24,A4178B621BDA,C40D96B3018E,345840EC20D0,482CD08DE7E0', '138;1', 'DEFAULT', 09, 0189, '','', '', 00);
Date: 2026-08-12 14:59:56 Duration: 983ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 74 25s325ms 150ms 1s81ms 342ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 12 07 24 10s784ms 449ms 08 10 3s664ms 366ms 09 2 497ms 248ms 10 7 2s191ms 313ms 11 8 2s484ms 310ms 12 4 1s306ms 326ms 13 6 1s670ms 278ms 14 3 661ms 220ms 15 4 801ms 200ms 16 3 565ms 188ms 17 3 696ms 232ms [ User: intelifix - Total duration: 25s325ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 25s325ms - Times executed: 74 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2509896 ORDER BY A.CAI_ORDEM;
Date: 2026-08-12 07:42:02 Duration: 1s81ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3435818 ORDER BY A.CAI_ORDEM;
Date: 2026-08-12 07:38:28 Duration: 761ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2915281 ORDER BY A.CAI_ORDEM;
Date: 2026-08-12 07:34:19 Duration: 659ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 73 8m15s 1s645ms 28s956ms 6s792ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 12 07 3 11s693ms 3s897ms 08 2 13s544ms 6s772ms 09 1 4s860ms 4s860ms 10 5 55s721ms 11s144ms 11 1 4s732ms 4s732ms 13 5 54s675ms 10s935ms 14 9 57s50ms 6s338ms 15 22 2m31s 6s868ms 16 7 1m23s 11s868ms 17 18 59s384ms 3s299ms [ User: intelifix - Total duration: 8m15s - Times executed: 73 ]
[ Application: [unknown] - Total duration: 8m15s - Times executed: 73 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 15:37:42 Duration: 28s956ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 13:28:54 Duration: 27s988ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 10:04:57 Duration: 27s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 72 15m26s 9s813ms 44s138ms 12s863ms create table temp0000288116 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 12 07 15 3m14s 12s982ms 08 15 2m59s 11s983ms 09 3 34s751ms 11s583ms 10 6 1m49s 18s218ms 11 8 1m39s 12s476ms 12 12 2m23s 11s994ms 14 4 51s751ms 12s937ms 15 9 1m52s 12s454ms [ User: intelifix - Total duration: 15m26s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15m26s - Times executed: 72 ]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 10:53:59 Duration: 44s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 07:07:10 Duration: 43s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 08:36:14 Duration: 14s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 70 4m17s 2s894ms 8s428ms 3s675ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 12 08 6 20s795ms 3s465ms 09 5 19s311ms 3s862ms 10 5 16s642ms 3s328ms 11 6 21s307ms 3s551ms 12 4 13s368ms 3s342ms 13 4 14s749ms 3s687ms 14 6 21s635ms 3s605ms 15 6 22s525ms 3s754ms 16 5 17s354ms 3s470ms 17 4 13s151ms 3s287ms 18 4 13s784ms 3s446ms 19 4 13s862ms 3s465ms 20 4 19s468ms 4s867ms 21 4 13s31ms 3s257ms 22 3 16s285ms 5s428ms [ User: intelifix - Total duration: 4m17s - Times executed: 70 ]
[ Application: psql - Total duration: 4m17s - Times executed: 70 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 20:00:13 Duration: 8s428ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 22:20:12 Duration: 7s970ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 14:20:09 Duration: 5s364ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 69 17s623ms 152ms 816ms 255ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 12 07 4 1s85ms 271ms 08 9 1s896ms 210ms 09 9 2s261ms 251ms 10 6 1s923ms 320ms 11 9 2s501ms 277ms 12 1 516ms 516ms 13 4 910ms 227ms 14 6 1s341ms 223ms 15 8 1s906ms 238ms 16 5 1s752ms 350ms 17 8 1s528ms 191ms [ User: intelifix - Total duration: 17s623ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 17s623ms - Times executed: 69 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "132789", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-12", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-12 16:40:16 Duration: 816ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "276291", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-12 10:57:58 Duration: 628ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "131135", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura D=7-3", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-12 12:09:45 Duration: 516ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 66 23s260ms 150ms 3s177ms 352ms create table temp0000288142 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 12 08 13 12s332ms 948ms 09 7 1s793ms 256ms 10 5 1s334ms 266ms 11 5 1s161ms 232ms 12 6 1s24ms 170ms 13 7 1s289ms 184ms 14 12 2s315ms 192ms 15 8 1s448ms 181ms 16 3 559ms 186ms [ User: intelifix - Total duration: 23s260ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 23s260ms - Times executed: 66 ]
-
CREATE TABLE temp0000288142 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 08:07:02 Duration: 3s177ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288142 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 08:08:24 Duration: 2s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288142 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 08:08:01 Duration: 2s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 56 14s291ms 163ms 441ms 255ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 12 07 2 687ms 343ms 08 5 1s357ms 271ms 09 5 1s158ms 231ms 10 3 893ms 297ms 11 20 4s834ms 241ms 12 2 397ms 198ms 13 3 797ms 265ms 14 9 2s424ms 269ms 15 7 1s739ms 248ms [ User: intelifix - Total duration: 14s291ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 14s291ms - Times executed: 56 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"305", "usuario" :"406", "tipo" :"N", "itens" :"001", "nota-fiscal" :"8", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-12 14:47:50 Duration: 441ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"39", "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-08-12 14:35:59 Duration: 424ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"466", "usuario" :"507", "tipo" :"N", "itens" :"007", "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-08-12 07:09:24 Duration: 415ms 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 2m38s 9m16s 5m44s 3 17m12s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 12 05 3 17m12s 5m44s [ User: intelifix - Total duration: 17m12s - Times executed: 3 ]
[ Application: psql - Total duration: 17m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-12 05:09:18 Duration: 9m16s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-12 05:14:36 Duration: 5m17s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-12 05:17:14 Duration: 2m38s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s408ms 9m23s 2m45s 48 2h12m13s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 12 07 3 9m31s 3m10s 08 3 7m54s 2m38s 09 3 10m3s 3m21s 10 3 7m36s 2m32s 11 3 8m45s 2m55s 12 3 9m4s 3m1s 13 3 6m23s 2m7s 14 3 9m10s 3m3s 15 3 9m34s 3m11s 16 3 9m54s 3m18s 17 3 9m28s 3m9s 18 3 6m43s 2m14s 19 3 6m14s 2m4s 20 3 8m29s 2m49s 21 3 6m11s 2m3s 22 3 7m7s 2m22s [ User: intelifix - Total duration: 2h12m13s - Times executed: 48 ]
[ Application: psql - Total duration: 2h12m13s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-12 09:14:25 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-12 16:14:14 Duration: 9m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-12 15:13:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
3 223ms 4m37s 1m35s 48 1h16m46s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 12 07 3 5m22s 1m47s 08 3 4m34s 1m31s 09 3 5m37s 1m52s 10 3 5m5s 1m41s 11 3 5m5s 1m41s 12 3 5m9s 1m43s 13 3 4m9s 1m23s 14 3 5m25s 1m48s 15 3 5m32s 1m50s 16 3 5m23s 1m47s 17 3 4m41s 1m33s 18 3 3m50s 1m16s 19 3 3m50s 1m16s 20 3 4m44s 1m34s 21 3 3m45s 1m15s 22 3 4m27s 1m29s [ User: intelifix - Total duration: 1h16m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h16m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-12 15:20:02 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-12 14:19:31 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-12 09:20:36 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
4 5s19ms 1m42s 51s330ms 4 3m25s 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 Aug 12 20 2 1m37s 48s849ms 23 2 1m47s 53s810ms [ User: intelifix - Total duration: 3m25s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m25s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-12 23:17:37 Duration: 1m42s 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-08-12 20:08:50 Duration: 1m32s 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-08-12 23:40:14 Duration: 5s525ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 152ms 40m15s 33s844ms 281 2h38m30s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 12 07 7 11m14s 1m36s 08 32 5m57s 11s161ms 09 24 37s642ms 1s568ms 10 8 52s337ms 6s542ms 11 19 15m51s 50s78ms 12 15 1h30m29s 6m1s 13 45 2m31s 3s361ms 14 36 15m8s 25s234ms 15 19 7m33s 23s880ms 16 32 5m16s 9s897ms 17 44 2m57s 4s25ms [ User: intelifix - Total duration: 2h38m30s - Times executed: 281 ]
[ Application: [unknown] - Total duration: 2h38m30s - Times executed: 281 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:58:01 Duration: 40m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:43:38 Duration: 28m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-12 12:28:36 Duration: 20m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 361ms 1m5s 30s903ms 4 2m3s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 12 20 2 57s678ms 28s839ms 23 2 1m5s 32s967ms [ User: intelifix - Total duration: 2m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-12 23:13:59 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-12 20:05:33 Duration: 57s259ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-12 20:10:08 Duration: 418ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 11s214ms 41s698ms 17s447ms 6 1m44s create table temp0000288192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 12 13 6 1m44s 17s447ms [ User: intelifix - Total duration: 1m44s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 6 ]
-
CREATE TABLE temp0000288192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 13:45:23 Duration: 41s698ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 13:45:44 Duration: 13s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 13:47:11 Duration: 13s6ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s935ms 44s38ms 15s179ms 15 3m47s create table temp0000288216 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 12 14 11 2m14s 12s218ms 16 2 56s149ms 28s74ms 17 2 37s145ms 18s572ms [ User: intelifix - Total duration: 3m47s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 15 ]
-
CREATE TABLE temp0000288216 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 16:34:33 Duration: 44s38ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288216 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 17:19:21 Duration: 25s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288216 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 14:28:42 Duration: 14s579ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s813ms 44s138ms 12s863ms 72 15m26s create table temp0000288116 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 12 07 15 3m14s 12s982ms 08 15 2m59s 11s983ms 09 3 34s751ms 11s583ms 10 6 1m49s 18s218ms 11 8 1m39s 12s476ms 12 12 2m23s 11s994ms 14 4 51s751ms 12s937ms 15 9 1m52s 12s454ms [ User: intelifix - Total duration: 15m26s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15m26s - Times executed: 72 ]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 10:53:59 Duration: 44s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 07:07:10 Duration: 43s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 08:36:14 Duration: 14s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s742ms 14s356ms 12s187ms 14 2m50s create table temp0000288172 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 12 11 7 1m27s 12s450ms 12 7 1m23s 11s923ms [ User: intelifix - Total duration: 2m50s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 14 ]
-
CREATE TABLE temp0000288172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:01:15 Duration: 14s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 11:21:42 Duration: 13s667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 11:22:07 Duration: 13s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s913ms 13s745ms 11s754ms 15 2m56s create table temp0000288184 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 12 12 15 2m56s 11s754ms [ User: intelifix - Total duration: 2m56s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m56s - Times executed: 15 ]
-
CREATE TABLE temp0000288184 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:13:35 Duration: 13s745ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288184 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:03:30 Duration: 12s940ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288184 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-12 12:02:45 Duration: 11s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s645ms 28s956ms 6s792ms 73 8m15s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 12 07 3 11s693ms 3s897ms 08 2 13s544ms 6s772ms 09 1 4s860ms 4s860ms 10 5 55s721ms 11s144ms 11 1 4s732ms 4s732ms 13 5 54s675ms 10s935ms 14 9 57s50ms 6s338ms 15 22 2m31s 6s868ms 16 7 1m23s 11s868ms 17 18 59s384ms 3s299ms [ User: intelifix - Total duration: 8m15s - Times executed: 73 ]
[ Application: [unknown] - Total duration: 8m15s - Times executed: 73 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 15:37:42 Duration: 28s956ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 13:28:54 Duration: 27s988ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-12', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-12 10:04:57 Duration: 27s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 283ms 18s892ms 5s24ms 31 2m35s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 12 07 3 23s219ms 7s739ms 08 3 9s468ms 3s156ms 09 3 14s259ms 4s753ms 10 1 16s854ms 16s854ms 11 5 23s615ms 4s723ms 12 3 12s379ms 4s126ms 13 3 11s491ms 3s830ms 14 5 23s318ms 4s663ms 15 4 20s855ms 5s213ms 17 1 283ms 283ms [ User: intelifix - Total duration: 2m35s - Times executed: 31 ]
[ Application: psql - Total duration: 2m35s - Times executed: 31 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028332);
Date: 2026-08-12 07:08:51 Duration: 18s892ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028351);
Date: 2026-08-12 11:31:15 Duration: 17s483ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028346);
Date: 2026-08-12 10:55:35 Duration: 16s854ms Database: rio User: intelifix Remote: [local] Application: psql
14 154ms 3m41s 4s680ms 160 12m28s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 12 00 6 24s362ms 4s60ms 01 6 12s121ms 2s20ms 02 5 7s560ms 1s512ms 03 5 10s59ms 2s11ms 04 6 13s124ms 2s187ms 05 2 5s191ms 2s595ms 07 12 44s443ms 3s703ms 08 12 53s60ms 4s421ms 09 12 46s159ms 3s846ms 10 12 48s262ms 4s21ms 11 12 1m 5s55ms 12 12 4m21s 21s750ms 13 7 11s425ms 1s632ms 14 12 37s114ms 3s92ms 15 12 49s706ms 4s142ms 16 11 27s604ms 2s509ms 17 5 6s690ms 1s338ms 21 5 14s222ms 2s844ms 22 6 16s58ms 2s676ms [ User: intelifix - Total duration: 12m28s - Times executed: 160 ]
[ Application: psql - Total duration: 12m28s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 12:28:43 Duration: 3m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 00:05:18 Duration: 16s396ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-12 07:35:11 Duration: 10s612ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s400ms 11s116ms 3s983ms 29 1m55s create table temp0000288116 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 12 07 4 18s772ms 4s693ms 08 10 29s712ms 2s971ms 09 2 6s253ms 3s126ms 12 4 21s65ms 5s266ms 14 4 22s694ms 5s673ms 15 5 17s27ms 3s405ms [ User: intelifix - Total duration: 1m55s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 29 ]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 14:53:28 Duration: 11s116ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 12:06:44 Duration: 10s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-08-2026", "ate" :"12-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-12 07:09:17 Duration: 10s200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2s894ms 8s428ms 3s675ms 70 4m17s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 12 08 6 20s795ms 3s465ms 09 5 19s311ms 3s862ms 10 5 16s642ms 3s328ms 11 6 21s307ms 3s551ms 12 4 13s368ms 3s342ms 13 4 14s749ms 3s687ms 14 6 21s635ms 3s605ms 15 6 22s525ms 3s754ms 16 5 17s354ms 3s470ms 17 4 13s151ms 3s287ms 18 4 13s784ms 3s446ms 19 4 13s862ms 3s465ms 20 4 19s468ms 4s867ms 21 4 13s31ms 3s257ms 22 3 16s285ms 5s428ms [ User: intelifix - Total duration: 4m17s - Times executed: 70 ]
[ Application: psql - Total duration: 4m17s - Times executed: 70 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 20:00:13 Duration: 8s428ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 22:20:12 Duration: 7s970ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-12 14:20:09 Duration: 5s364ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 204ms 2m30s 3s129ms 276 14m23s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 12 00 12 37s280ms 3s106ms 01 12 28s781ms 2s398ms 02 12 26s369ms 2s197ms 03 12 32s531ms 2s710ms 04 12 24s784ms 2s65ms 05 12 26s566ms 2s213ms 06 12 25s168ms 2s97ms 07 12 27s410ms 2s284ms 08 12 31s600ms 2s633ms 09 12 33s233ms 2s769ms 10 12 33s521ms 2s793ms 11 12 31s800ms 2s650ms 12 12 29s442ms 2s453ms 13 12 30s746ms 2s562ms 14 12 2m58s 14s839ms 15 12 36s873ms 3s72ms 16 12 38s607ms 3s217ms 17 12 34s495ms 2s874ms 18 12 26s435ms 2s202ms 19 12 27s237ms 2s269ms 20 12 43s733ms 3s644ms 21 12 28s915ms 2s409ms 22 12 30s1ms 2s500ms [ User: intelifix - Total duration: 14m23s - Times executed: 276 ]
[ Application: psql - Total duration: 14m23s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 14:47:37 Duration: 2m30s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 00:05:31 Duration: 12s989ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-12 20:05:13 Duration: 12s116ms Database: rio User: intelifix Remote: [local] Application: psql
18 216ms 22s733ms 2s969ms 43 2m7s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 12 07 5 2s978ms 595ms 08 5 2s312ms 462ms 09 4 1s224ms 306ms 10 2 850ms 425ms 11 6 36s407ms 6s67ms 12 6 12s802ms 2s133ms 13 2 586ms 293ms 14 7 52s831ms 7s547ms 15 3 1s357ms 452ms 16 1 6s515ms 6s515ms 17 2 9s829ms 4s914ms [ User: intelifix - Total duration: 2m7s - Times executed: 43 ]
[ Application: psql - Total duration: 2m7s - Times executed: 43 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028347);
Date: 2026-08-12 11:13:11 Duration: 22s733ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028369);
Date: 2026-08-12 14:55:45 Duration: 22s175ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028363);
Date: 2026-08-12 14:17:08 Duration: 21s353ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 5s348ms 951ms 1,328 21m3s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 12 07 33 27s511ms 833ms 08 134 2m12s 992ms 09 169 2m42s 964ms 10 211 3m5s 880ms 11 166 2m31s 911ms 12 70 1m8s 978ms 13 86 1m24s 988ms 14 152 2m34s 1s14ms 15 154 2m25s 941ms 16 112 1m30s 810ms 17 41 59s612ms 1s453ms [ User: intelifix - Total duration: 21m3s - Times executed: 1328 ]
[ Application: [unknown] - Total duration: 21m3s - Times executed: 1328 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52175, 413, '73931685850072304194,229767451031,216925447375,216950342331,229830949214,229703003652,229800946678,229827640317,229711171924,229729972345,229836213454,229646798289,229765785469,229699802038,229695277274,229700888192,229702520519,229714739208,229833727374,216926108608,229775039818,229733337386,229777994259,216928470107,229793732024,229643172942,229830032020,229834482735,229708450514,229730228384,229836090210,229638413454,229776659314,216930087480,229730425879', '246554165569,246450380817,246447119397,246634019412,246505099804,246615474448,246633861417,246543601935,246564954557,246241034044,246460954351,246555061527,246512809816,246500453537,246512698592,246519793539,246553024863,226004949701,246444385562,246580091422,246567352244,246602805658,246452274660,246606453153,246476844050,246634155665,246251058198,246512093753,246553151015,246323283755,246446989812,246573945872,246452618688,246587382122,,,,,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-12 10:50:27 Duration: 5s348ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR8C11237,3891484F8E65,3891484F8E66,ZTEGDB08AC55$ZTE3ANNRB729187,5872C990E543,5872C990E544,ZTEGDC619CD6$ZTE3ANNQ8M27884,843C99215573,843C99215574,ZTEGD7BAB459$ZTE3ANNR3Y33942,4896D952DC3C,4896D952DC3D,ZTEGD97EB54B$ZTE3ANNR1Y25649,14CA56CF03A1,14CA56CF03A2,ZTEGD970DA8C$ZTE3ANNR9W49885,D89A0DACED51,D89A0DACED52,ZTEGDB16D488$ZTE3ANNQ8M44172,843C9922D333,843C9922D334,ZTEGD7BAF3F9$ZTE3ANNQ8117200,689E29BD71EB,689E29BD71EC,ZTEGD7B77DC0$ZTE3ANNQ5N03691,3CF9F0AD1BF8,3CF9F0AD1BF9,ZTEGD641C4B2$ZTE3ANNQ9J14752,843C992D2AF5,843C992D2AF6,ZTEGD7BB424B$ZTE3ANNRCP20125,6C11BA6B027D,6C11BA6B027E,ZTEGDC6F8F30$ZTE3ANNR9W09073,D89A0DA930C9,D89A0DA930CA,ZTEGDB16351C$ZTE3ANNRAM21083,5872C989265B,5872C989265C,ZTEGDC60525A$ZTE3ANNT3H72879,D831399D6FB2,D831399D6FB3,ZTEGDD32ED4E$ZTE3ANNR9W55234,D89A0DAD6AAF,D89A0DAD6AB0,ZTEGDB16E96D$ZTE3ANNR4N57611,4896D95AA15A,4896D95AA15B,ZTEGD98000D0$ZTE3ANNQCA22634,14CA56D45757,14CA56D45758,ZTEGD971BDD5$ZTE3ANNR3Y33585,4896D952D3DE,4896D952D3DF,ZTEGD97EB3E6$ZTE3ANNR8C19586,389148505213,389148505214,ZTEGDB08CCF2$ZTE3ANNRB729227,5872C990E633,5872C990E634,ZTEGDC619CFE$ZTE3ANNR3Y35820,4896D9530840,4896D9530841,ZTEGD97EBCA1$ZTE3ANNQ7111286,C4EBFF8AD0EC,C4EBFF8AD0ED,ZTEGD70A48E8$ZTE3ANNQ8M27978,843C992157A7,843C992157A8,ZTEGD7BAB4B7$ZTE3ANNRB722571,5872C9904A33,5872C9904A34,ZTEGDC6182FE$ZTE3ANNR1Y25670,14CA56CF041F,14CA56CF0420,ZTEGD970DAA1$ZTE3ANNR9W54710,D89A0DAD5E67,D89A0DAD5E68,ZTEGDB16E761$ZTE3ANNRB729452,5872C990EB79,5872C990EB7A,ZTEGDC619DDF$ZTE3ANNQ8M19186,843C99208997,843C99208998,ZTEGD7BA925F$ZTE3ANNR2Q24065,F4E84F82E806,F4E84F82E807,ZTEGD97AD0BB$ZTE3ANNQCA14139,14CA56D3903D,14CA56D3903E,ZTEGD9719CA6$ZTE3ANNQ9J14873,843C992D2DCB,843C992D2DCC,ZTEGD7BB42C4$ZTE3ANNR9W55369,D89A0DAD6DD9,D89A0DAD6DDA,ZTEGDB16E9F4$ZTE3ANNQCA27461,14CA56D4C879,14CA56D4C87A,ZTEGD971D0B0$ZTE3ANNR9F14949,D89A0DA43C41,D89A0DA43C42,ZTEGDB1561B0$ZTE3ANNR4N57649,4896D95AA23E,4896D95AA23F,ZTEGD98000F6$ZTE3ANNT2V65665,D831399191DE,D831399191DF,ZTEGDD30F300$ZTE3ANNQ8118543,689E29BD9165,689E29BD9166,ZTEGD7B782FF$ZTE3ANNR9W09021,D89A0DA92F91,D89A0DA92F92,ZTEGDB1634E8$ZTE3ANNR4N57607,4896D95AA142,4896D95AA143,ZTEGD98000CC$ZTE3ANNRAM47376,5872C98B8E99,5872C98B8E9A,ZTEGDC60B90F', '',0318,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-08-12 08:25:32 Duration: 5s55ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276896, 452, 'F200011067B307F,9877E74840AC$F200011117B2322,9877E77EEA13$F200011103BA6B3,9877E77BD23A$F200010277B4A28,743AEFABAB09$F200011216B2CC2,84011227C391$F200012333B214E,1834AF63389F$F20001017011114,743AEF5E72FE$F200011151B609B,9877E7BCA1BC$F200012325B576B,1834AF632042$F200010282BA374,743AEFAD02E9$F200010319B177F,743AEFD9BF88$F200011113BA032,9877E77E6BCD$F2000101691074C,743AEF5E14F5$F200011201B7CF7,84011205BE7D$F200011070B6207,9877E74943F2$F200011208B3A9F,84011206FFB9$F200011103B67D3,9877E77BB6B8$F20001018412AB7,743AEF747052$F200012022B7CB5,840112BE3EBE$F200011218B52EC,840112282608', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-12 12:03:42 Duration: 4s970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 3s537ms 696ms 111 1m17s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 12 08 18 7s183ms 399ms 09 9 3s915ms 435ms 10 1 866ms 866ms 11 5 15s627ms 3s125ms 13 28 18s516ms 661ms 14 7 7s115ms 1s16ms 15 6 4s958ms 826ms 16 16 8s383ms 523ms 17 21 10s733ms 511ms [ User: intelifix - Total duration: 1m17s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 1m17s - Times executed: 111 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131771) LIMIT 1;
Date: 2026-08-12 11:31:30 Duration: 3s537ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131663) LIMIT 1;
Date: 2026-08-12 11:36:22 Duration: 3s416ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131154) LIMIT 1;
Date: 2026-08-12 11:38:57 Duration: 2s987ms Database: brasilia 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 Aug 12 18 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 2s684ms - Times executed: 3 ]
[ Application: psql - Total duration: 2s684ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 23,934 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 6816 ERROR entries
- 0 WARNING entries
- 14 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6,746 Max number of times the same event was reported
- 6,851 Total events found
Rank Times reported Error 1 6,746 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 12 00 60 01 60 02 59 03 55 04 59 05 60 06 59 07 293 08 503 09 603 10 536 11 548 12 368 13 344 14 572 15 533 16 367 17 306 18 229 19 226 20 231 21 228 22 231 23 216 - ERROR: prepared statement "_PLAN000000002A580610" does not exist
- ERROR: prepared statement "_PLAN000000002A4CD420" does not exist
- ERROR: prepared statement "_PLAN000000002A580610" does not exist
Statement: DEALLOCATE "_PLAN000000002A580610"
Date: 2026-08-12 00:00:02 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A4CD420"
Date: 2026-08-12 00:01:03 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A580610"
Date: 2026-08-12 00:02:03 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 12 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-08-12 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-08-12 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-08-12 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 10 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 12 11 1 12 6 14 3 - LOG: process 1507282 still waiting for ShareLock on transaction 4265323 after 1000.126 ms
- LOG: process 1594328 still waiting for ShareLock on transaction 4271062 after 1000.054 ms
- LOG: process 1594328 still waiting for ShareLock on transaction 4271062 after 2059.722 ms
Detail: Process holding the lock: 1510772. Wait queue: 1507282.
Context: while updating tuple (1,53) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(52369,406,'CP2233325KG,A0B53C971FE5,544D4242005C3074,A0B53C971FE8$CP2241326V8,A0B53CC3C2E4,544D4242005EAD63,A0B53CC3C2E7$CP230132E2N,D4925E037E23,544D424200614BCA,D4925E037E26$CP2319322GM,D4925E9FE49A,544D424200699354,D4925E9FE49D$CP2404325C9,08C7F525BAA3,544D424200772D5C,08C7F525BAA6$CP2301327K6,D4925E028544,544D424200613023,D4925E028547$CP234232UC6,D4925EF9B5E6,544D4242007259F3,D4925EF9B5E9','',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""}]','$$$$$$','',00);Date: 2026-08-12 11:02:17 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1585512. Wait queue: 1594328.
Context: while updating tuple (76477,47) 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-12 12:15:23 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1585512. Wait queue: 1594328.
Context: while updating tuple (76477,47) 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-12 12:15:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 12 00 1 06 3 08 1 15 1 20 1 21 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-12 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-12 06:02:14 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-12 06:34:59 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 12 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-12 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-12 03:05:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 6 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 12 16 6 - ERROR: trailing junk after numeric literal at or near "981E19B0E590" at character 27
- ERROR: trailing junk after numeric literal at or near "981E19B0E590" at character 27
- ERROR: trailing junk after numeric literal at or near "0null" at character 38
Statement: select * from rs_caixa_qr(981E19B0E590)
Date: 2026-08-12 16:02:26 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(981E19B0E590)
Date: 2026-08-12 16:02:26 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0null, 'E820E251CDC5' )
Date: 2026-08-12 16:23:15 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 12 10 4 12 2 - ERROR: column "pas_id" does not exist at character 66 2026-08-12 10:04:35 -03 [1418039]: [66-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "pas_id" does not exist at character 66 2026-08-12 10:04:58 -03 [1418039]: [76-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "pas_id" does not exist at character 66 2026-08-12 10:05:48 -03 [1418039]: [89-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0132589);Date: 2026-08-12 10:04:35 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0132589);Date: 2026-08-12 10:04:58 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0132589);Date: 2026-08-12 10:05:48 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
8 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 12 05 4 17 1 - 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-08-12 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-12 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-12 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local]
9 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 12 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-12 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-12 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 12 08 2 10 1 - ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "831202929002721" at character 41
Statement: select * from rs_caixa_qr(389036 ])
Date: 2026-08-12 08:46:50 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(389036 ])
Date: 2026-08-12 08:46:50 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''831202929002721');
Date: 2026-08-12 10:10:28 Database: contagem Application: [unknown] User: intelifix Remote: [local]
11 3 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 12 12 3 - LOG: process 1591585 still waiting for ExclusiveLock on tuple (76477,47) of relation 363850 of database 358220 after 1001.062 ms
- LOG: process 1591585 still waiting for ExclusiveLock on tuple (76477,47) of relation 363850 of database 358220 after 1595.526 ms
- LOG: process 1591585 still waiting for ExclusiveLock on tuple (76477,47) of relation 363850 of database 358220 after 79566.196 ms
Detail: Process holding the lock: 1594328. Wait queue: 1591585.
Context: 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-12 12:17:55 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1594328. Wait queue: 1591585.
Context: 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-12 12:17:55 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1594328. Wait queue: 1591585.
Context: 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028357, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-12 12:19:13 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 12 14 1 16 1 - ERROR: unterminated quoted string at or near "'229760666372'');" at character 39
- ERROR: unterminated quoted string at or near "'241656446064'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229760666372'');
Date: 2026-08-12 14:33:42 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241656446064'');
Date: 2026-08-12 16:15:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 2 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 12 12 2 - ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint
- ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint
Detail: Failing row contains (6465387, null, 1, null, A, 28353, 45, null, null, null).
Context: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statement
Statement: SELECT RS_SETGLOBAL('USUARIO',504);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 028353 ); ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint DETAIL: Failing row contains (6465387, null, 1, null, A, 28353, 45, null, null, null). CONTEXT: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statementDate: 2026-08-12 12:02:33 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Failing row contains (6460969, null, 1, null, A, 28358, 9, null, null, null).
Context: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statement
Statement: SELECT RS_SETGLOBAL('USUARIO',504);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 028358 ); ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint DETAIL: Failing row contains (6460969, null, 1, null, A, 28358, 9, null, null, null). CONTEXT: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statementDate: 2026-08-12 12:11:58 Database: rio Application: psql User: intelifix Remote: [local]
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 12 03 1 - LOG: database system was shut down at 2026-08-12 03:05:01 -03
Date: 2026-08-12 03:05:02