pgBadger-
Global information
- Generated on Fri Oct 9 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 32,466 log entries in 9s
- Log start from 2026-10-09 00:02:02 to 2026-10-09 23:45:23
-
Overview
Global Stats
- 343 Number of unique normalized queries
- 4,889 Number of queries
- 6h34m46s Total query duration
- 2026-10-09 00:02:07 First query
- 2026-10-09 23:42:53 Last query
- 5 queries/s at 2026-10-09 23:42:31 Query peak
- 6h34m46s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h34m46s Execute total duration
- 2,332 Number of events
- 17 Number of unique normalized events
- 2,270 Max number of times the same event was reported
- 0 Number of cancellation
- 487 Total number of automatic vacuums
- 1,001 Total number of automatic analyzes
- 29 Number temporary file
- 249.97 MiB Max size of temporary file
- 86.35 MiB Average size of temporary file
- 324 Total number of sessions
- 9 sessions at 2026-10-09 01:05:01 Session peak
- 12d4h19m39s Total duration of sessions
- 54m8s Average duration of sessions
- 15 Average queries per session
- 1m13s Average queries duration per session
- 52m54s Average idle time per session
- 345 Total number of connections
- 6 connections/s at 2026-10-09 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-09 23:42:31 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-10-09 08:07:54 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-09 23:42:31 Date
Queries duration
Key values
- 6h34m46s 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) Oct 09 00 26 0ms 13s317ms 3s238ms 8s439ms 54s447ms 54s447ms 01 18 0ms 3s456ms 1s346ms 4s167ms 4s231ms 4s231ms 02 17 0ms 3s504ms 1s540ms 5s380ms 5s380ms 5s380ms 03 18 0ms 6s34ms 1s642ms 5s104ms 7s387ms 7s387ms 04 18 0ms 3s493ms 1s454ms 4s888ms 4s888ms 4s888ms 05 21 0ms 9m18s 1m1s 2m43s 6m51s 9m18s 06 26 0ms 10s40ms 2s177ms 8s22ms 27s790ms 27s790ms 07 345 0ms 6m29s 2s901ms 30s392ms 1m5s 6m29s 08 361 150ms 6m21s 4s644ms 40s969ms 5m51s 6m24s 09 433 0ms 5m56s 5s185ms 48s146ms 4m13s 5m57s 10 575 150ms 6m12s 6s13ms 2m3s 3m58s 13m10s 11 568 150ms 6m7s 3s921ms 55s901ms 5m55s 6m12s 12 113 0ms 5m57s 6s817ms 8s431ms 54s997ms 5m57s 13 294 0ms 5m44s 3s399ms 33s601ms 47s806ms 5m44s 14 597 150ms 6m10s 2s708ms 40s119ms 4m14s 6m23s 15 499 152ms 6m3s 2s56ms 13s60ms 26s602ms 6m55s 16 296 0ms 5m52s 2s703ms 6s856ms 50s56ms 5m56s 17 117 0ms 5m34s 6s258ms 6s412ms 47s387ms 5m34s 18 26 0ms 5m30s 24s623ms 3m31s 5m30s 5m30s 19 24 0ms 5m28s 25s642ms 3m29s 5m28s 5m28s 20 109 0ms 5m29s 10s709ms 1m10s 3m23s 6m30s 21 31 0ms 5m17s 19s576ms 3m20s 5m47s 5m47s 22 30 0ms 5m13s 20s359ms 3m25s 5m58s 5m58s 23 327 0ms 1m2s 6s 1m7s 1m14s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 09 00 4 0 2s109ms 0ms 0ms 8s439ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 10 0 1s44ms 576ms 693ms 8s22ms 07 312 0 2s915ms 6s748ms 15s626ms 3m39s 08 283 0 5s231ms 5s34ms 12s699ms 5m58s 09 253 0 5s84ms 10s217ms 47s870ms 5m37s 10 398 0 6s197ms 58s127ms 1m12s 6m5s 11 452 0 3s907ms 10s954ms 55s638ms 6m11s 12 76 0 9s354ms 2s575ms 6s889ms 3m52s 13 224 0 3s515ms 5s799ms 10s44ms 3m41s 14 475 0 2s877ms 11s481ms 19s411ms 5m58s 15 349 0 2s650ms 6s913ms 11s72ms 3m46s 16 224 0 3s339ms 3s746ms 5s964ms 3m37s 17 96 0 7s296ms 3s587ms 6s412ms 3m37s 18 8 0 1m13s 1s74ms 3m31s 5m30s 19 6 0 1m37s 46s609ms 3m29s 5m28s 20 10 80 12s573ms 1m3s 1m10s 5m30s 21 8 0 1m10s 492ms 3m20s 5m47s 22 6 0 1m33s 0ms 3m25s 5m58s 23 7 320 6s 1m4s 1m7s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 09 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 Oct 09 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 7 7.00 0.00% 08 0 11 11.00 0.00% 09 0 11 11.00 0.00% 10 0 11 11.00 0.00% 11 0 9 9.00 0.00% 12 0 5 5.00 0.00% 13 0 9 9.00 0.00% 14 0 9 9.00 0.00% 15 0 8 8.00 0.00% 16 0 7 7.00 0.00% 17 0 3 3.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 09 00 19 0.01/s 01 9 0.00/s 02 7 0.00/s 03 15 0.00/s 04 6 0.00/s 05 7 0.00/s 06 15 0.00/s 07 15 0.00/s 08 18 0.01/s 09 21 0.01/s 10 22 0.01/s 11 21 0.01/s 12 13 0.00/s 13 21 0.01/s 14 22 0.01/s 15 19 0.01/s 16 14 0.00/s 17 13 0.00/s 18 9 0.00/s 19 10 0.00/s 20 10 0.00/s 21 8 0.00/s 22 9 0.00/s 23 22 0.01/s Day Hour Count Average Duration Average idle time Oct 09 00 4 47m30s 47m9s 01 17 1h1m44s 1h1m43s 02 8 1h 59m57s 03 15 21m38s 21m36s 04 6 1h1m 1h55s 05 7 53m17s 50m14s 06 6 57m30s 57m21s 07 14 1h17s 59m5s 08 16 54m17s 52m32s 09 19 55m13s 53m14s 10 22 52m53s 50m16s 11 22 55m39s 53m57s 12 21 52m48s 52m12s 13 11 53m 51m29s 14 21 59m38s 58m21s 15 21 57m54s 57m5s 16 18 57m34s 56m49s 17 14 1h1m29s 1h37s 18 12 1h22s 59m29s 19 8 1h2s 58m45s 20 13 48m1s 46m32s 21 8 54m8s 52m52s 22 7 1h45s 59m18s 23 14 36m50s 34m30s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-10-09 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 345 connections Total
Connections per user
Key values
- intelifix Main User
- 345 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-09 01:05:01 Date
Histogram of session times
Key values
- 267 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 324 sessions Total
Sessions per user
Key values
- intelifix Main User
- 324 sessions Total
Sessions per host
Key values
- [local] Main Host
- 324 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 26,592 buffers Checkpoint Peak
- 2026-10-09 00:09:45 Date
- 270.054 seconds Highest write time
- 0.139 seconds Sync time
Checkpoints Wal files
Key values
- 18 files Wal files usage Peak
- 2026-10-09 10:24:37 Date
Checkpoints distance
Key values
- 592.34 Mo Distance Peak
- 2026-10-09 10:24:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 09 00 37,495 652.007s 0.013s 652.038s 01 1,022 102.493s 0.012s 102.521s 02 1,553 155.511s 0.014s 155.54s 03 1,135 113.019s 0.025s 113.067s 04 1,477 148.096s 0.014s 148.125s 05 8,397 840.568s 0.047s 840.636s 06 5,746 393.868s 0.007s 393.885s 07 28,919 1,872.221s 0.064s 1,872.32s 08 36,876 2,563.624s 0.091s 2,563.775s 09 43,242 3,131.341s 0.163s 3,131.597s 10 84,591 3,239.259s 0.264s 3,239.684s 11 83,195 3,239.36s 0.204s 3,239.677s 12 16,706 1,461.286s 0.046s 1,461.384s 13 29,158 2,102.94s 0.238s 2,103.237s 14 66,336 3,239.284s 0.211s 3,239.591s 15 58,484 3,239.524s 0.171s 3,239.767s 16 26,531 2,241.183s 0.084s 2,241.312s 17 9,128 917.897s 0.04s 917.975s 18 1,354 135.75s 0.01s 135.769s 19 23 2.313s 0.002s 2.317s 20 842 86.694s 0.016s 86.721s 21 3,275 327.783s 0.013s 327.817s 22 3,035 303.739s 0.012s 303.772s 23 473 47.823s 0.01s 47.844s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 09 00 0 0 9 465 0.002s 0.006s 01 0 0 0 385 0.002s 0.006s 02 0 0 0 423 0.002s 0.006s 03 0 0 1 276 0.007s 0.006s 04 0 0 0 429 0.003s 0.006s 05 0 0 4 485 0.013s 0.009s 06 0 0 1 108 0.001s 0.004s 07 0 0 11 2,514 0.002s 0.011s 08 0 0 22 4,557 0.003s 0.012s 09 0 0 77 6,251 0.007s 0.012s 10 0 0 107 9,062 0.007s 0.012s 11 0 0 63 7,601 0.030s 0.012s 12 0 0 6 2,346 0.003s 0.011s 13 0 0 19 4,439 0.120s 0.012s 14 0 0 35 7,050 0.003s 0.012s 15 0 0 24 5,503 0.003s 0.012s 16 0 0 9 3,861 0.003s 0.012s 17 0 0 3 2,205 0.002s 0.012s 18 0 0 0 96 0.002s 0.004s 19 0 0 0 3 0.001s 0.001s 20 0 0 0 86 0.005s 0.003s 21 0 0 1 428 0.002s 0.006s 22 0 0 1 445 0.002s 0.007s 23 0 0 0 43 0.002s 0.005s Day Hour Count Avg time (sec) Oct 09 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 Oct 09 00 22,447.67 kB 59,364.83 kB 01 789.00 kB 32,601.83 kB 02 1,290.50 kB 17,827.33 kB 03 1,008.50 kB 3,320.33 kB 04 1,185.50 kB 1,914.50 kB 05 7,377.00 kB 14,027.75 kB 06 4,307.00 kB 11,697.00 kB 07 16,997.64 kB 20,907.82 kB 08 30,415.25 kB 71,018.75 kB 09 104,969.25 kB 130,288.17 kB 10 145,010.75 kB 238,233.33 kB 11 86,371.25 kB 164,749.00 kB 12 8,866.64 kB 71,197.09 kB 13 26,250.33 kB 40,604.58 kB 14 47,553.33 kB 100,361.42 kB 15 32,787.75 kB 61,721.25 kB 16 11,963.67 kB 38,310.33 kB 17 4,003.67 kB 14,825.92 kB 18 1,577.75 kB 7,852.25 kB 19 189.00 kB 6,085.00 kB 20 2,729.67 kB 5,543.00 kB 21 2,699.83 kB 4,419.00 kB 22 2,288.71 kB 3,658.57 kB 23 213.60 kB 3,439.60 kB -
Temporary Files
Size of temporary files
Key values
- 499.94 MiB Temp Files size Peak
- 2026-10-09 05:31:57 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-09 05:32:05 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 68.01 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 1 104.00 MiB 104.00 MiB 10 8 1.02 GiB 130.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 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 16 1.03 GiB 37.28 MiB 249.97 MiB 65.60 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-09 05:32:06 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-09 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 6 623.98 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( 030943, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 08:01:39 Duration: 6m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030991, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 10:11:48 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 14:25:46 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 4 310.54 MiB 57.72 MiB 94.99 MiB 77.64 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-09 05:30:41 Duration: 39s255ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-09 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 3 520.04 MiB 104.00 MiB 208.02 MiB 173.35 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030992);
Date: 2026-10-09 10:17:53 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030996);
Date: 2026-10-09 10:20:34 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031010);
Date: 2026-10-09 10:59:43 Duration: 59s950ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 249.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 249.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 208.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030992);[ Date: 2026-10-09 10:17:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 208.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030996);[ Date: 2026-10-09 10:20:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
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-10-09 10:57:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031004);[ Date: 2026-10-09 10:45:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
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-10-09 10:47:12 - 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-10-09 10:28:25 - 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-10-09 09:54:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 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-10-09 10:16:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 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-10-09 10:39:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 94.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-09 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 94.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-09 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 62.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-09 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 57.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-09 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 41.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 41.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 41.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 41.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 41.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-09 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.84 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-09 10:25:25 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 9.84 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-09 10:25:25 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (95) Main table analyzed (database rio)
- 1,001 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 95 rio.public.temp0000293812 61 contagem.pg_catalog.pg_attribute 51 rio.pg_catalog.pg_class 48 rio.public.usuarios 45 rio.pg_catalog.pg_type 40 brasilia.pg_catalog.pg_attribute 39 contagem.pg_catalog.pg_class 39 contagem.pg_catalog.pg_type 37 rio.pg_catalog.pg_index 26 contagem.pg_catalog.pg_index 25 rio.public.temp0000293828 25 rio.public.temp0000293900 24 rio.public.temp0000293890 24 rio.public.temp0000293800 22 contagem.pg_catalog.pg_depend 20 rio.pg_catalog.pg_depend 19 brasilia.pg_catalog.pg_class 18 rio.public.temp0000293836 18 rio.public.temp0000293806 18 rio.public.temp0000293820 17 brasilia.pg_catalog.pg_type 16 contagem.public.temp0000227488 16 contagem.public.usuarios 15 rio.public.temp0000292754 15 contagem.public.nf_entrada 14 rio.public.temp0000293804 11 brasilia.pg_catalog.pg_index 10 rio.public.temp0000293702 10 rio.public.temp0000293886 9 brasilia.public.temp0000241934 8 rio.public.temp0000293852 8 brasilia.public.usuarios 8 rio.public.temp0000293870 8 rio.public.temp0000293846 7 rio.public.temp0000293794 7 brasilia.pg_catalog.pg_depend 7 contagem.public.temp0000227506 6 rio.public.temp0000293884 6 contagem.public.temp0000227490 6 rio.public.temp0000293814 6 brasilia.public.temp0000241902 5 testes.pg_catalog.pg_shdepend 4 brasilia.public.temp0000241892 4 rio.public.temp0000292986 4 contagem.public.temp0000227486 4 rio.public.temp0000293888 4 rio.public.temp0000293000 4 rio.public.temp0000293898 4 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000241904 3 brasilia.public.temp0000241932 3 contagem.public.temp0000227494 3 contagem.public.temp0000227498 3 rio.public.temp0000293902 3 contagem.public.temp0000227468 3 brasilia.public.temp0000241898 3 rio.public.temp0000293850 2 rio.public.temp0000293896 2 rio.public.temp0000293882 2 contagem.auditor.auditor_2026_10 2 contagem.public.temp0000227492 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241894 2 rio.public.tmp_drill_0302 2 rio.public.tmp_drill_0320 2 rio.public.temp0000293904 2 brasilia.public.temp0000241928 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241978 1 postgres.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241986 1 brasilia.public.temp0000241984 1 rio.public.temp0000293908 1 rio.public.temp0000293832 1 rio.public.temp0000293860 1 contagem.public.temp0000227496 1 brasilia.public.temp0000241896 1 rio.auditor.auditor_2026_10 1 brasilia.public.temp0000241908 1 rio.public.temp0000293854 1 rio.public.temp0000293796 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241936 1 brasilia.auditor.auditor_2026_10 1 Total 1,001 Vacuums per table
Key values
- public.temp0000293812 (49) Main table vacuumed on database rio
- 487 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.temp0000293812 49 0 0 0 0 0 0 15,000 4,331 6,470,589 0 0 contagem.pg_catalog.pg_attribute 32 32 0 0 0 0 0 25,993 1,876 5,991,392 29 809 rio.pg_catalog.pg_attribute 30 30 0 0 0 0 0 17,490 4,574 7,054,527 253 6,080 rio.public.temp0000293828 26 0 0 0 0 0 0 15,911 122 961,535 0 0 rio.public.temp0000293890 23 0 0 0 0 0 0 3,751 471 812,185 0 0 rio.public.temp0000293836 19 0 0 0 0 0 0 22,330 5,637 8,541,754 0 0 rio.pg_catalog.pg_class 17 17 0 0 0 0 0 3,337 1,021 1,577,359 80 298 contagem.pg_catalog.pg_type 17 17 0 0 0 0 0 2,016 147 385,898 4 10 contagem.pg_catalog.pg_class 17 17 0 0 0 0 0 4,560 257 769,355 6 19 contagem.public.usuarios 15 0 0 0 0 0 0 64 51 29,533 1 1 rio.pg_catalog.pg_type 15 15 0 0 0 0 0 1,666 499 717,286 52 144 contagem.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,539 562 1,539,994 16 82 contagem.pg_catalog.pg_index 13 13 0 0 0 0 0 932 132 217,934 7 11 rio.public.temp0000292754 12 0 0 0 0 0 0 886 71 62,806 0 0 contagem.public.temp0000227488 12 0 0 0 0 0 0 1,421 72 95,573 0 0 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,677 1,788 2,833,069 63 1,633 rio.public.temp0000293702 9 0 0 0 0 0 0 591 193 280,577 0 0 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 562 144 160,472 24 50 rio.public.usuarios 9 4 0 0 0 0 0 106 41 95,428 5 5 postgres.pg_catalog.pg_shdepend 9 9 0 0 0 0 0 2,287 576 1,396,090 38 59 rio.public.temp0000293800 9 0 0 0 0 0 0 641 127 172,991 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,628 2,095 9,303,005 893 3,818 rio.public.temp0000293852 8 0 0 0 0 0 0 5,674 33 341,891 0 0 rio.public.tmp_drill_0302 7 2 0 0 0 0 0 95 27 46,502 1 51 rio.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,437 706 1,191,968 33 289 rio.public.temp0000293846 7 0 0 0 0 0 0 406 120 167,063 0 0 rio.public.temp0000293814 6 0 0 0 0 0 0 9,345 24 554,973 0 0 contagem.public.temp0000227490 5 0 0 0 0 0 0 597 30 40,176 0 0 brasilia.pg_catalog.pg_class 5 5 0 0 0 0 0 1,001 380 584,588 17 58 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 493 185 264,447 14 42 rio.public.temp0000293804 4 0 0 0 0 0 0 145 19 12,861 0 0 contagem.public.nf_entrada 3 3 0 0 0 0 0 373 120 218,076 7 7 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,769 306 1,837,079 146 502 contagem.public.temp0000227494 3 0 0 0 0 0 0 356 18 23,943 0 0 brasilia.public.temp0000241904 3 0 0 0 0 0 0 777 12 47,652 0 0 rio.public.temp0000292986 3 0 0 0 0 0 0 190 18 13,768 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 172 47 40,282 11 23 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 330 73 342,516 31 82 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 774 315 451,874 19 167 contagem.public.temp0000227498 2 0 0 0 0 0 0 237 12 15,941 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,962 1,140 4,516,446 984 6,605 brasilia.public.temp0000241898 2 0 0 0 0 0 0 263 7 16,658 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 299 47 188,501 19 46 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 61 6 13,455 0 0 rio.public.temp0000293904 2 0 0 0 0 0 0 1,944 1,867 2,520,826 0 0 rio.public.temp0000293820 2 0 0 0 0 0 0 85 9 6,457 0 0 rio.public.temp0000293000 2 0 0 0 0 0 0 93 12 7,139 0 0 rio.public.temp0000293794 2 0 0 0 0 0 0 46 41 53,688 0 0 contagem.public.temp0000227486 2 0 0 0 0 0 0 236 12 15,880 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,011 245 1,089,571 203 1,806 brasilia.auditor.auditor_2026_10 1 0 0 0 0 0 0 13,458 8,912 12,473,721 2,128 61,869 rio.auditor.auditor_2026_10 1 0 0 0 0 0 0 49,937 27,167 35,544,503 11,484 235,756 rio.public.temp0000293854 1 0 0 0 0 0 0 8 5 1,286 0 0 rio.public.temp0000293884 1 0 0 0 0 0 0 83 6 5,804 0 0 rio.pg_catalog.pg_constraint 1 1 0 0 0 0 0 25 9 16,889 0 0 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 262 101 228,220 15 36 rio.public.temp0000293832 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000293860 1 0 0 0 0 0 0 77 6 5,438 0 0 contagem.public.temp0000227496 1 0 0 0 0 0 0 118 6 7,941 0 0 brasilia.public.temp0000241894 1 0 0 0 0 0 0 259 4 15,884 0 0 rio.public.temp0000293850 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000293882 1 0 0 0 0 0 0 83 6 5,804 0 0 brasilia.public.temp0000241978 1 0 0 0 0 0 0 110 6 7,407 0 0 contagem.auditor.auditor_2026_10 1 0 0 0 0 0 0 23,692 9,231 13,600,111 7,188 156,835 brasilia.public.temp0000241986 1 0 0 0 0 0 0 259 4 15,884 0 0 Total 487 237 0 0 0 0 0 263,062 76,089 126,031,459 23,771 477,193 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (9.84) 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.temp0000293812 0 0 0.43 contagem.pg_catalog.pg_attribute 0 0 1.65 rio.pg_catalog.pg_attribute 0 0 2.07 rio.public.temp0000293828 0 0 0.47 rio.public.temp0000293890 0 0 0.15 rio.public.temp0000293836 0 0 0.88 rio.pg_catalog.pg_class 0 0 0.54 contagem.pg_catalog.pg_type 0 0 0.08 contagem.pg_catalog.pg_class 0 0 0.27 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_type 0 0 0.18 contagem.pg_catalog.pg_depend 0 0 0.39 contagem.pg_catalog.pg_index 0 0 0.03 rio.public.temp0000292754 0 0 0.04 contagem.public.temp0000227488 0 0 0.03 brasilia.pg_catalog.pg_attribute 0 0 0.86 rio.public.temp0000293702 0 0 0.03 rio.pg_catalog.pg_index 0 0 0.06 rio.public.usuarios 0 0 0 postgres.pg_catalog.pg_shdepend 0 0 0.29 rio.public.temp0000293800 0 0 0.02 rio.pg_catalog.pg_statistic 0 0 1.4 rio.public.temp0000293852 0 0 0.27 rio.public.tmp_drill_0302 0 0 0 rio.pg_catalog.pg_depend 0 0 0.42 rio.public.temp0000293846 0 0 0.03 rio.public.temp0000293814 0 0 0.21 contagem.public.temp0000227490 0 0 0.01 brasilia.pg_catalog.pg_class 0 0 0.37 brasilia.pg_catalog.pg_type 0 0 0.09 rio.public.temp0000293804 0 0 0 contagem.public.nf_entrada 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.37 contagem.public.temp0000227494 0 0 0 brasilia.public.temp0000241904 0 0 0 rio.public.temp0000292986 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.03 brasilia.pg_catalog.pg_depend 0 0 0.23 contagem.public.temp0000227498 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.38 brasilia.public.temp0000241898 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.public.tmp_drill_0320 0 0 0 rio.public.temp0000293904 0 0 0.07 rio.public.temp0000293820 0 0 0 rio.public.temp0000293000 0 0 0.01 rio.public.temp0000293794 0 0 0 contagem.public.temp0000227486 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.27 brasilia.auditor.auditor_2026_10 0 0 2.61 rio.auditor.auditor_2026_10 0 0 9.84 rio.public.temp0000293854 0 0 0 rio.public.temp0000293884 0 0 0 rio.pg_catalog.pg_constraint 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.04 rio.public.temp0000293832 0 0 0 rio.public.temp0000293860 0 0 0.01 contagem.public.temp0000227496 0 0 0.01 brasilia.public.temp0000241894 0 0 0 rio.public.temp0000293850 0 0 0 rio.public.temp0000293882 0 0 0.01 brasilia.public.temp0000241978 0 0 0.01 contagem.auditor.auditor_2026_10 0 0 4.77 brasilia.public.temp0000241986 0 0 0 Total 0 0 30.01 Tuples removed per table
Key values
- pg_catalog.pg_attribute (214592) Main table with removed tuples on database contagem
- 466115 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 32 32 214,592 791,624 238 825 19,327 rio.pg_catalog.pg_attribute 30 30 115,869 731,614 17,227 463 17,446 brasilia.pg_catalog.pg_attribute 11 11 40,974 252,457 768 76 5,987 rio.pg_catalog.pg_statistic 8 8 14,159 66,233 241 0 10,288 contagem.pg_catalog.pg_type 17 17 14,119 39,130 14 116 1,217 postgres.pg_catalog.pg_shdepend 9 9 9,553 162,765 653 0 1,354 contagem.pg_catalog.pg_index 13 13 6,926 24,673 8 54 683 contagem.pg_catalog.pg_class 17 17 6,428 64,532 27 126 3,018 contagem.pg_catalog.pg_statistic 2 2 5,581 14,924 0 0 2,022 rio.pg_catalog.pg_depend 7 7 5,563 133,367 3,845 0 1,316 brasilia.pg_catalog.pg_statistic 2 2 5,027 15,421 0 0 2,142 rio.auditor.auditor_2026_10 1 0 4,648 5,125,352 0 0 247,569 rio.pg_catalog.pg_type 15 15 4,490 35,217 1,228 30 1,087 contagem.pg_catalog.pg_depend 13 13 2,946 244,258 42 29 2,406 rio.pg_catalog.pg_class 17 17 2,705 70,298 3,864 53 2,408 brasilia.pg_catalog.pg_depend 2 2 2,137 35,621 0 0 366 rio.pg_catalog.pg_index 9 9 1,845 17,885 653 8 500 brasilia.pg_catalog.pg_class 5 5 1,567 16,885 0 19 610 brasilia.pg_catalog.pg_shdepend 1 1 1,188 18,059 0 0 151 contagem.public.nf_entrada 3 3 1,151 4,754 0 0 261 brasilia.pg_catalog.pg_type 5 5 1,017 11,081 0 10 335 rio.pg_toast.pg_toast_2619 3 3 987 2,218 0 59 669 contagem.public.usuarios 15 0 906 360 0 0 30 brasilia.pg_catalog.pg_index 3 3 600 5,655 0 0 162 rio.public.tmp_drill_0302 7 2 479 6,023 2,395 0 99 rio.public.usuarios 9 4 250 5,932 1,351 0 171 brasilia.pg_toast.pg_toast_2619 2 2 206 274 0 0 144 contagem.pg_toast.pg_toast_2619 2 2 178 234 0 0 114 rio.pg_catalog.pg_constraint 1 1 24 1,372 0 0 37 contagem.public.temp0000227498 2 0 0 2,830 0 35 221 rio.public.temp0000293702 9 0 0 25,960 0 270 594 rio.public.temp0000293890 23 0 0 93,872 0 1,027 3,645 rio.public.temp0000292754 12 0 0 37,684 0 446 866 brasilia.auditor.auditor_2026_10 1 0 0 1,562,005 0 0 68,567 rio.public.temp0000293814 6 0 0 132,784 0 0 9,344 contagem.public.temp0000227488 12 0 0 16,966 0 213 1,323 brasilia.public.temp0000241898 2 0 0 6,800 0 0 512 rio.public.tmp_drill_0320 2 2 0 644 0 0 18 rio.public.temp0000293904 2 0 0 27,676 0 52 1,932 rio.public.temp0000293854 1 0 0 1,116 0 59 69 rio.public.temp0000293820 2 0 0 2,247 0 55 137 rio.public.temp0000293000 2 0 0 3,365 0 51 77 rio.public.temp0000293884 1 0 0 1,233 0 53 75 contagem.public.temp0000227490 5 0 0 7,072 0 88 552 rio.public.temp0000293794 2 0 0 2,603 0 5 59 contagem.public.temp0000227486 2 0 0 2,829 0 36 220 contagem.public.temp0000227494 3 0 0 4,242 0 52 332 rio.public.temp0000293812 49 0 0 272,950 0 538 16,966 rio.public.temp0000293832 1 0 0 1,033 0 0 64 rio.public.temp0000293836 19 0 0 501,706 0 0 35,264 rio.public.temp0000293860 1 0 0 1,137 0 59 69 contagem.public.temp0000227496 1 0 0 1,413 0 18 110 brasilia.public.temp0000241894 1 0 0 3,401 0 0 256 rio.public.temp0000293804 4 0 0 10,898 0 71 249 rio.public.temp0000293850 1 0 0 1,033 0 0 64 brasilia.public.temp0000241904 3 0 0 10,200 0 0 768 rio.public.temp0000293846 7 0 0 20,787 0 292 476 rio.public.temp0000293882 1 0 0 1,233 0 53 75 brasilia.public.temp0000241978 1 0 0 4,755 0 26 102 rio.public.temp0000292986 3 0 0 7,304 0 26 166 rio.public.temp0000293828 26 0 0 306,888 0 586 21,430 rio.public.temp0000293852 8 0 0 160,909 0 109 11,283 rio.public.temp0000293800 9 0 0 31,273 0 432 720 contagem.auditor.auditor_2026_10 1 0 0 1,072,369 0 0 50,131 brasilia.public.temp0000241986 1 0 0 3,401 0 0 256 Total 487 237 466,115 12,242,836 32,554 6,520 548,911 Pages removed per table
Key values
- public.temp0000293890 (1027) Main table with removed pages on database rio
- 6520 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293890 23 0 0 1027 contagem.pg_catalog.pg_attribute 32 32 214592 825 rio.public.temp0000293828 26 0 0 586 rio.public.temp0000293812 49 0 0 538 rio.pg_catalog.pg_attribute 30 30 115869 463 rio.public.temp0000292754 12 0 0 446 rio.public.temp0000293800 9 0 0 432 rio.public.temp0000293846 7 0 0 292 rio.public.temp0000293702 9 0 0 270 contagem.public.temp0000227488 12 0 0 213 contagem.pg_catalog.pg_class 17 17 6428 126 contagem.pg_catalog.pg_type 17 17 14119 116 rio.public.temp0000293852 8 0 0 109 contagem.public.temp0000227490 5 0 0 88 brasilia.pg_catalog.pg_attribute 11 11 40974 76 rio.public.temp0000293804 4 0 0 71 rio.public.temp0000293854 1 0 0 59 rio.pg_toast.pg_toast_2619 3 3 987 59 rio.public.temp0000293860 1 0 0 59 rio.public.temp0000293820 2 0 0 55 contagem.pg_catalog.pg_index 13 13 6926 54 rio.public.temp0000293884 1 0 0 53 rio.pg_catalog.pg_class 17 17 2705 53 rio.public.temp0000293882 1 0 0 53 rio.public.temp0000293904 2 0 0 52 contagem.public.temp0000227494 3 0 0 52 rio.public.temp0000293000 2 0 0 51 contagem.public.temp0000227486 2 0 0 36 contagem.public.temp0000227498 2 0 0 35 rio.pg_catalog.pg_type 15 15 4490 30 contagem.pg_catalog.pg_depend 13 13 2946 29 brasilia.public.temp0000241978 1 0 0 26 rio.public.temp0000292986 3 0 0 26 brasilia.pg_catalog.pg_class 5 5 1567 19 contagem.public.temp0000227496 1 0 0 18 brasilia.pg_catalog.pg_type 5 5 1017 10 rio.pg_catalog.pg_index 9 9 1845 8 rio.public.temp0000293794 2 0 0 5 brasilia.pg_toast.pg_toast_2619 2 2 206 0 brasilia.pg_catalog.pg_depend 2 2 2137 0 brasilia.pg_catalog.pg_statistic 2 2 5027 0 contagem.public.nf_entrada 3 3 1151 0 brasilia.auditor.auditor_2026_10 1 0 0 0 rio.public.temp0000293814 6 0 0 0 brasilia.public.temp0000241898 2 0 0 0 contagem.pg_toast.pg_toast_2619 2 2 178 0 rio.public.tmp_drill_0302 7 2 479 0 rio.public.tmp_drill_0320 2 2 0 0 rio.public.usuarios 9 4 250 0 rio.auditor.auditor_2026_10 1 0 4648 0 rio.pg_catalog.pg_depend 7 7 5563 0 rio.pg_catalog.pg_constraint 1 1 24 0 brasilia.pg_catalog.pg_shdepend 1 1 1188 0 contagem.pg_catalog.pg_statistic 2 2 5581 0 rio.public.temp0000293832 1 0 0 0 rio.public.temp0000293836 19 0 0 0 brasilia.public.temp0000241894 1 0 0 0 rio.public.temp0000293850 1 0 0 0 brasilia.public.temp0000241904 3 0 0 0 contagem.public.usuarios 15 0 906 0 rio.pg_catalog.pg_statistic 8 8 14159 0 postgres.pg_catalog.pg_shdepend 9 9 9553 0 contagem.auditor.auditor_2026_10 1 0 0 0 brasilia.pg_catalog.pg_index 3 3 600 0 brasilia.public.temp0000241986 1 0 0 0 Total 487 237 466,115 6,520 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 09 00 0 1 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 1 2 07 5 28 08 30 80 09 84 142 10 142 221 11 67 148 12 14 34 13 37 68 14 60 137 15 20 80 16 17 34 17 4 23 18 0 0 19 0 0 20 0 0 21 0 3 22 0 0 23 0 0 - 9.84 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 21s350ms 21s350ms 21s350ms 21s350ms select * from rs_nf_entrada_exclui (?);-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (031004);
Date: 2026-10-09 10:45:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (01742);
Date: 2026-10-09 10:16:43 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (0640);
Date: 2026-10-09 12:15:24 Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1 1s 1s 1s 1s drop table if exists temp0000293812;-
DROP TABLE IF EXISTS temp0000293812;
Date: 2026-10-09 09:40:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293812;
Date: 2026-10-09 09:44:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293812;
Date: 2026-10-09 09:40:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s 1s 1s 1s drop table if exists temp0000293836;-
DROP TABLE IF EXISTS temp0000293836;
Date: 2026-10-09 10:32:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293836;
Date: 2026-10-09 10:59:18 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293836;
Date: 2026-10-09 10:32:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000293828;-
DROP TABLE IF EXISTS temp0000293828;
Date: 2026-10-09 10:40:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293828;
Date: 2026-10-09 10:40:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 21s350ms SELECT * FROM RS_NF_ENTRADA_EXCLUI (031004);[ Date: 2026-10-09 10:45:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000293812;[ Date: 2026-10-09 09:40:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000293836;[ Date: 2026-10-09 10:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000293828;[ Date: 2026-10-09 10:40:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,201 Total read queries
- 1,178 Total write queries
Queries by database
Key values
- rio Main database
- 2,956 Requests
- 4h48m40s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,347 1h35m43s copy to 139 10m53s ddl 96 1m29s others 231 9m30s select 881 1h13m49s contagem Total 584 10m22s copy to 116 1m24s ddl 85 41s790ms others 6 2m58s select 377 5m17s rio Total 2,956 4h48m40s copy to 145 29m32s ddl 597 44m46s others 273 25m56s select 1,941 3h8m25s testes Total 2 609ms select 2 609ms Queries by user
Key values
- intelifix Main user
- 4,790 Requests
User Request type Count Duration etiquetas Total 4 732ms select 4 732ms intelifix Total 4,790 6h34m1s copy to 400 41m50s ddl 778 46m58s others 510 38m25s select 3,102 4h26m46s lenon Total 95 44s831ms select 95 44s831ms Duration by user
Key values
- 6h34m1s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 4 732ms select 4 732ms intelifix Total 4,790 6h34m1s copy to 400 41m50s ddl 778 46m58s others 510 38m25s select 3,102 4h26m46s lenon Total 95 44s831ms select 95 44s831ms Queries by host
Key values
- [local] Main host
- 4,889 Requests
- 6h34m46s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,770 Requests
- 3h28m41s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-09 08:04:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,459 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m18s analyze verbose;[ Date: 2026-10-09 05:09:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m51s analyze verbose;[ Date: 2026-10-09 05:16:12 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
3 6m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 07:11:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030943, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 08:01:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030991, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 10:11:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 14:25:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031019, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 11:27:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031025, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 11:52:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030995, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 10:26:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 10:11:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 15:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 12:10:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030946, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 09:13:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 14:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 16:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030945, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-09 08:32:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 11:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 13:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 09:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-09 17:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h36m43s 48 2s162ms 6m29s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 09 07 3 7m3s 2m21s 08 3 5m45s 1m55s 09 3 5m53s 1m57s 10 3 6m23s 2m7s 11 3 6m7s 2m2s 12 3 6m16s 2m5s 13 3 6m2s 2m 14 3 6m13s 2m4s 15 3 6m23s 2m7s 16 3 6m11s 2m3s 17 3 5m52s 1m57s 18 3 5m48s 1m56s 19 3 5m46s 1m55s 20 3 5m48s 1m56s 21 3 5m35s 1m51s 22 3 5m31s 1m50s [ User: intelifix - Total duration: 1h36m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 07:11:31 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 10:11:06 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 15:11:05 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: psql
2 1h6m8s 48 273ms 3m48s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 09 07 3 4m37s 1m32s 08 3 3m58s 1m19s 09 3 4m1s 1m20s 10 3 4m17s 1m25s 11 3 4m21s 1m27s 12 3 4m23s 1m27s 13 3 4m10s 1m23s 14 3 4m20s 1m26s 15 3 4m13s 1m24s 16 3 4m6s 1m22s 17 3 4m5s 1m21s 18 3 3m59s 1m19s 19 3 3m58s 1m19s 20 3 3m52s 1m17s 21 3 3m48s 1m16s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h6m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 12:15:38 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 11:15:25 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 14:15:31 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h5m58s 147 159ms 6m21s 26s925ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 09 07 7 40s222ms 5s746ms 08 10 12m35s 1m15s 09 24 8m6s 20s280ms 10 35 22m27s 38s508ms 11 26 13m45s 31s738ms 12 1 17s969ms 17s969ms 13 12 10s567ms 880ms 14 14 6m28s 27s742ms 15 13 37s785ms 2s906ms 16 2 13s243ms 6s621ms 17 3 35s155ms 11s718ms [ User: intelifix - Total duration: 1h5m58s - Times executed: 147 ]
[ Application: [unknown] - Total duration: 1h5m58s - Times executed: 147 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030943, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 08:01:39 Duration: 6m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030991, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 10:11:48 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 14:25:46 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m53s 3 2m43s 9m18s 6m17s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 09 05 3 18m53s 6m17s [ User: intelifix - Total duration: 18m53s - Times executed: 3 ]
[ Application: psql - Total duration: 18m53s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-09 05:09:20 Duration: 9m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-09 05:16:12 Duration: 6m51s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-09 05:18:55 Duration: 2m43s Database: contagem User: intelifix Remote: [local] Application: psql
5 13m10s 1,173 150ms 3s213ms 673ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 09 08 29 13s255ms 457ms 09 34 14s283ms 420ms 10 139 1m28s 633ms 11 214 2m22s 667ms 12 27 22s856ms 846ms 13 113 1m19s 701ms 14 253 2m54s 691ms 15 247 3m2s 739ms 16 104 1m5s 632ms 17 13 6s139ms 472ms [ User: intelifix - Total duration: 13m10s - Times executed: 1173 ]
[ Application: [unknown] - Total duration: 13m10s - Times executed: 1173 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (140140, 399, '2102313BFARYM8941648,E8136E752209,48575443F1B3FCA6,E8136E75220CBFARYMA913892,6C442A91DEA5,485754439F5D47A7,6C442A91DEA8BFARYM8941611,E8136E7502B1,48575443F1B224A6,E8136E7502B4BFARYMA914227,6C442A93754B,485754439FAED6A7,6C442A93754E', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','', 00);
Date: 2026-10-09 13:57:41 Duration: 3s213ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295030, 503, '833010902002198,229979650012,229980138094,229980463031,230011353846,230044186365,230036926476,230052923234,230030693646,230032571529,230033997189,230041761528,230030349718', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-09 15:29:31 Duration: 2s965ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (294833, 450, '921231003546,44D45460D7A9,D833B7CB0623,4C195DFA735F,44D454C2D5C5,B0FC88EB56EA,D0CF0EFCFDAD,B0BBE54BA696,582FF70085B8,94988F95A7C5,E4C0E21C6685,8CFDDE8D6D43,44D45460580C,38A6591AB417,186A81D5BC9A,B0BBE54B3283,E4C0E29780F4,841EA38872C2,CC5830E21BC8,8CFDDE8727E4,C4EB42A282AB,5447CC4A852F,B0BBE53D186B,841EA38D4332,5CFA25AC57EA,44D454602C92,CC5830E1CBBF,841EA3883272,8CC5B4E2AA50,5CFA2514EE8D,186A81D4E9E4,CC5830E0B700,E8D2FF970329,C4EB42EB5645,3C585D79EFBE,64FD96544653', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-09 12:06:29 Duration: 2s614ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 12m25s 63 11s74ms 13s736ms 11s837ms create table temp0000293812 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 09 09 47 9m5s 11s611ms 11 16 3m20s 12s500ms [ User: intelifix - Total duration: 12m25s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 12m25s - Times executed: 63 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:14:41 Duration: 13s736ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:31:02 Duration: 12s935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:15:59 Duration: 12s707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9m46s 271 181ms 7s628ms 2s164ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 09 00 12 24s217ms 2s18ms 01 12 21s579ms 1s798ms 02 12 21s514ms 1s792ms 03 12 25s125ms 2s93ms 04 12 21s573ms 1s797ms 05 12 21s359ms 1s779ms 06 12 21s527ms 1s793ms 07 12 23s224ms 1s935ms 08 12 29s112ms 2s426ms 09 12 26s395ms 2s199ms 10 12 27s887ms 2s323ms 11 12 28s203ms 2s350ms 12 12 27s501ms 2s291ms 13 12 28s128ms 2s344ms 14 12 29s247ms 2s437ms 15 12 27s480ms 2s290ms 16 12 26s126ms 2s177ms 17 12 25s793ms 2s149ms 18 10 25s404ms 2s540ms 19 10 25s75ms 2s507ms 20 11 29s917ms 2s719ms 21 12 24s809ms 2s67ms 22 12 25s330ms 2s110ms [ User: intelifix - Total duration: 9m46s - Times executed: 271 ]
[ Application: psql - Total duration: 9m46s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 08:15:10 Duration: 7s628ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 20:05:07 Duration: 6s226ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 03:05:22 Duration: 6s34ms Database: rio User: intelifix Remote: [local] Application: psql
8 7m45s 38 11s363ms 12s957ms 12s246ms create table temp0000293828 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 09 09 3 35s131ms 11s710ms 10 30 6m8s 12s277ms 11 5 1m1s 12s380ms [ User: intelifix - Total duration: 7m45s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 38 ]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:45:02 Duration: 12s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:20:18 Duration: 12s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:48:11 Duration: 12s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 6m11s 30 11s806ms 13s366ms 12s380ms create table temp0000293836 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 09 09 3 37s280ms 12s426ms 10 25 5m8s 12s358ms 11 2 25s173ms 12s586ms [ User: intelifix - Total duration: 6m11s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m11s - Times executed: 30 ]
-
CREATE TABLE temp0000293836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:15:06 Duration: 13s366ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:16:41 Duration: 13s26ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:32:03 Duration: 13s12ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m32s 643 152ms 2s333ms 516ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 09 06 2 834ms 417ms 07 45 24s503ms 544ms 08 112 42s64ms 375ms 09 70 32s133ms 459ms 10 96 1m2s 649ms 11 86 55s604ms 646ms 12 5 3s92ms 618ms 13 39 27s391ms 702ms 14 103 47s876ms 464ms 15 39 18s888ms 484ms 16 28 11s58ms 394ms 17 18 6s327ms 351ms [ User: intelifix - Total duration: 5m32s - Times executed: 643 ]
[ Application: [unknown] - Total duration: 5m32s - Times executed: 643 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295066", "modelo" : "320", "itens" : "241620009613,241667242528,241653175981,241653183333,241663193244,241667244144,241608757796,241651789516,241651793153,241693205353,241651668998,241603275454,241631307797,241703505977,241646587279,241607160627,241599556281,241594003753,241661047680,241593990015,230040447493,241649369099,241645911928,241649557479,241656348198,241661295662,241607161637,241631308101,241673235761,241649323641,241649839303,241708480919,241656403636,241694974864,241603284243,241607757990,241649325661,230048868797,241654961936,241667890224,241649266789,241659712938,241598642242,241661045559,241619808000,241604353349,241657873140,241635346676", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-09 11:49:04 Duration: 2s333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294847", "modelo" : "463", "itens" : "241787549195,241723940520,241718778084,241737910009,833500533627358,241720927991,241796154862,83350060983029B,241782046268,241791780721,241723114344,241790315863,241794258997,241787522325,241789562648,833500610002855,241718912543,241755064163,241787747071,241789513249,241735818692,241794073043,241751829818,241796195270,241790321319,241751835778,241757614546,241736891436,241751495565,241750260204,241723942540,241757614849,241755067597,241787520507,241718810109,241718822534,241718763841,241782518087,241718747980,241785823147,241704892443,241793478911,241752335557,241756993947,241787472545,241789689809,241750272831,241794161234,241751827393,241718795662,241785910911,833500603321896,241752347881,241737815476,241787378696,241757867982,241794164466,241723920619,241720983250,241736885273", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-09 10:10:56 Duration: 2s110ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295091", "modelo" : "320", "itens" : "241666297373,241620325760,241653147089,241602968297,834291942000193,241629341523,835205930000242,241638381631,241634843541,241652057880,241608948297,230049391835,241637500524,241619955870,835146922004084,241668729306,241617623241,241617462743,241620940423,241637879606,241593192125,241607329509,241619978195,241635832437,241703464256,241694320424,241674257387,241645515368,241679551429,241593236876,241673199292,241646245877,241690569709,241615925454,241661513843,241629434764,241631585759,241621049602,241708386262,241647193759,241663069214,241658117484,241667991019,241672836979,241656340421,241653866385,241629377788,230057032648", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-09 14:48:16 Duration: 2s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 5m12s 59 2s20ms 12s54ms 5s301ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 09 08 3 29s585ms 9s861ms 09 5 36s794ms 7s358ms 10 3 13s333ms 4s444ms 11 4 28s895ms 7s223ms 12 4 14s280ms 3s570ms 13 4 26s939ms 6s734ms 14 13 1m26s 6s681ms 15 5 24s171ms 4s834ms 16 5 16s150ms 3s230ms 17 13 35s764ms 2s751ms [ User: intelifix - Total duration: 5m12s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 5m12s - Times executed: 59 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 08:36:27 Duration: 12s54ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 14:29:42 Duration: 11s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 13:43:27 Duration: 11s751ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m5s 36 150ms 1m 6s823ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 09 07 1 603ms 603ms 08 2 475ms 237ms 09 6 36s219ms 6s36ms 10 18 3m25s 11s402ms 11 6 1s556ms 259ms 14 3 1s551ms 517ms [ User: intelifix - Total duration: 4m5s - Times executed: 36 ]
[ Application: psql - Total duration: 4m5s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030992);
Date: 2026-10-09 10:17:53 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030996);
Date: 2026-10-09 10:20:34 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031010);
Date: 2026-10-09 10:59:43 Duration: 59s950ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m28s 127 168ms 13s219ms 1s639ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 09 00 5 16s133ms 3s226ms 01 6 2s650ms 441ms 02 5 4s679ms 935ms 03 4 4s35ms 1s8ms 04 6 4s601ms 766ms 05 4 3s975ms 993ms 07 12 14s725ms 1s227ms 08 13 16s320ms 1s255ms 09 12 18s37ms 1s503ms 10 12 21s34ms 1s752ms 11 11 25s818ms 2s347ms 12 5 7s304ms 1s460ms 13 1 341ms 341ms 14 6 20s408ms 3s401ms 15 9 14s286ms 1s587ms 16 5 4s261ms 852ms 21 5 13s793ms 2s758ms 22 6 15s870ms 2s645ms [ User: intelifix - Total duration: 3m28s - Times executed: 127 ]
[ Application: psql - Total duration: 3m28s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 00:05:15 Duration: 13s219ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 14:25:08 Duration: 6s648ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 11:55:08 Duration: 6s601ms Database: rio User: intelifix Remote: [local] Application: psql
14 2m58s 15 10s934ms 14s920ms 11s909ms create table temp0000293812 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 09 09 13 2m31s 11s624ms 11 2 27s525ms 13s762ms [ User: intelifix - Total duration: 2m58s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m58s - Times executed: 15 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-10-09 11:14:19 Duration: 14s920ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-10-09 11:16:18 Duration: 12s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-10-09 09:49:21 Duration: 12s344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m36s 364 150ms 1s882ms 430ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 09 07 220 1m48s 491ms 08 63 21s949ms 348ms 16 55 16s362ms 297ms 17 26 10s163ms 390ms [ User: intelifix - Total duration: 2m36s - Times executed: 364 ]
[ Application: [unknown] - Total duration: 2m36s - Times executed: 364 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140284","seriais":"241782044955,241789278096,241724455878,241754248190,241734601919,241790559905,241720462537,241753785160,241722438890,241720424452,241780544764,241754214955,241757357293,241734681725,241758126773,241722361129,241797804058,241722440811,241704974751,241797776378,241787091924,241794916570,241787084347,241794921117,241720407278,241720436675,241754256474,241801947290,241724349706,241794800017,241754217076,241754236169,241720426270,241787139504,241722044150,241802008788,241725821837,241757346787,241725811432,241789147982","usuario":"399","observacao":""}');
Date: 2026-10-09 07:25:42 Duration: 1s882ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140284","seriais":"241744373041,241746459204,241814549205,241778591319,241776798595,241776799101,241775607783,241776817082,241814535264,241775594146,241825180726,241743288603,241744496262,241825361226,241771145474,241814386181,241765608907,241813633549,241814559711,241771298901,241745445962,241745689397,241762618402,241772822832,241771159011,241764000726,241771501222,241764301720,241814246066,241812948802,241814236772,241814269098,241771436164,241825233738,241824674458,241769278603","usuario":"399","observacao":""}');
Date: 2026-10-09 07:33:25 Duration: 1s797ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140284","seriais":"241775851523,241762534959,241764403750,241776518489,241775244157,241747220727,241775245571,241764368493,241776524349,241761357380,241814185151,241813332633,241765420202,241765413860,241776686991,241776507983,241738791318,241740540827,241763492943,241743221627,241813352938,241762586075,241742122137,241747162236,241812982341,241759946367,241778564144,241814185959,241747257878,241761333035,241827842029,241778770809,241812956782,241775253249,241776639411,241759928587,241813360919,241827571924","usuario":"399","observacao":""}');
Date: 2026-10-09 07:51:55 Duration: 1s796ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 2m18s 11 11s710ms 13s539ms 12s568ms create table temp0000293890 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 09 13 8 1m40s 12s602ms 14 3 37s433ms 12s477ms [ User: intelifix - Total duration: 2m18s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m18s - Times executed: 11 ]
-
CREATE TABLE temp0000293890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 13:43:34 Duration: 13s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 13:50:28 Duration: 12s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 14:54:51 Duration: 12s952ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m13s 4 4s275ms 1m2s 33s419ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 09 20 2 1m7s 33s566ms 23 2 1m6s 33s273ms [ User: intelifix - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-09 20:08:41 Duration: 1m2s 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-10-09 23:16:37 Duration: 1m2s 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-10-09 23:33:55 Duration: 4s324ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m10s 36 216ms 23s196ms 3s625ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 09 07 1 23s196ms 23s196ms 08 1 4s442ms 4s442ms 09 10 35s764ms 3s576ms 10 11 38s393ms 3s490ms 11 5 14s364ms 2s872ms 13 6 7s950ms 1s325ms 14 2 6s399ms 3s199ms [ User: intelifix - Total duration: 2m10s - Times executed: 36 ]
[ Application: psql - Total duration: 2m10s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030943);
Date: 2026-10-09 07:55:09 Duration: 23s196ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031010);
Date: 2026-10-09 10:59:53 Duration: 9s144ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030947);
Date: 2026-10-09 09:14:42 Duration: 9s38ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m2s 10 11s869ms 12s787ms 12s274ms create table temp0000293852 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 09 10 4 48s555ms 12s138ms 11 1 12s105ms 12s105ms 14 5 1m2s 12s416ms [ User: intelifix - Total duration: 2m2s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 10 ]
-
CREATE TABLE temp0000293852 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 14:22:25 Duration: 12s787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293852 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 14:24:15 Duration: 12s686ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293852 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:17:42 Duration: 12s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m1s 38 583ms 13s273ms 3s200ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 09 08 3 13s441ms 4s480ms 09 2 7s544ms 3s772ms 10 3 23s765ms 7s921ms 11 2 6s857ms 3s428ms 12 3 12s662ms 4s220ms 13 3 2s410ms 803ms 14 3 22s677ms 7s559ms 15 3 19s315ms 6s438ms 16 3 2s633ms 877ms 17 3 2s364ms 788ms 18 2 1s514ms 757ms 19 2 1s495ms 747ms 20 2 1s617ms 808ms 21 2 1s608ms 804ms 22 2 1s726ms 863ms [ User: intelifix - Total duration: 2m1s - Times executed: 38 ]
[ Application: psql - Total duration: 2m1s - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-09 10:20:15 Duration: 13s273ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-09 12:00:12 Duration: 11s38ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-09 14:00:11 Duration: 9s527ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,173 13m10s 150ms 3s213ms 673ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 09 08 29 13s255ms 457ms 09 34 14s283ms 420ms 10 139 1m28s 633ms 11 214 2m22s 667ms 12 27 22s856ms 846ms 13 113 1m19s 701ms 14 253 2m54s 691ms 15 247 3m2s 739ms 16 104 1m5s 632ms 17 13 6s139ms 472ms [ User: intelifix - Total duration: 13m10s - Times executed: 1173 ]
[ Application: [unknown] - Total duration: 13m10s - Times executed: 1173 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (140140, 399, '2102313BFARYM8941648,E8136E752209,48575443F1B3FCA6,E8136E75220CBFARYMA913892,6C442A91DEA5,485754439F5D47A7,6C442A91DEA8BFARYM8941611,E8136E7502B1,48575443F1B224A6,E8136E7502B4BFARYMA914227,6C442A93754B,485754439FAED6A7,6C442A93754E', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','', 00);
Date: 2026-10-09 13:57:41 Duration: 3s213ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295030, 503, '833010902002198,229979650012,229980138094,229980463031,230011353846,230044186365,230036926476,230052923234,230030693646,230032571529,230033997189,230041761528,230030349718', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-09 15:29:31 Duration: 2s965ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (294833, 450, '921231003546,44D45460D7A9,D833B7CB0623,4C195DFA735F,44D454C2D5C5,B0FC88EB56EA,D0CF0EFCFDAD,B0BBE54BA696,582FF70085B8,94988F95A7C5,E4C0E21C6685,8CFDDE8D6D43,44D45460580C,38A6591AB417,186A81D5BC9A,B0BBE54B3283,E4C0E29780F4,841EA38872C2,CC5830E21BC8,8CFDDE8727E4,C4EB42A282AB,5447CC4A852F,B0BBE53D186B,841EA38D4332,5CFA25AC57EA,44D454602C92,CC5830E1CBBF,841EA3883272,8CC5B4E2AA50,5CFA2514EE8D,186A81D4E9E4,CC5830E0B700,E8D2FF970329,C4EB42EB5645,3C585D79EFBE,64FD96544653', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-09 12:06:29 Duration: 2s614ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 643 5m32s 152ms 2s333ms 516ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 09 06 2 834ms 417ms 07 45 24s503ms 544ms 08 112 42s64ms 375ms 09 70 32s133ms 459ms 10 96 1m2s 649ms 11 86 55s604ms 646ms 12 5 3s92ms 618ms 13 39 27s391ms 702ms 14 103 47s876ms 464ms 15 39 18s888ms 484ms 16 28 11s58ms 394ms 17 18 6s327ms 351ms [ User: intelifix - Total duration: 5m32s - Times executed: 643 ]
[ Application: [unknown] - Total duration: 5m32s - Times executed: 643 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295066", "modelo" : "320", "itens" : "241620009613,241667242528,241653175981,241653183333,241663193244,241667244144,241608757796,241651789516,241651793153,241693205353,241651668998,241603275454,241631307797,241703505977,241646587279,241607160627,241599556281,241594003753,241661047680,241593990015,230040447493,241649369099,241645911928,241649557479,241656348198,241661295662,241607161637,241631308101,241673235761,241649323641,241649839303,241708480919,241656403636,241694974864,241603284243,241607757990,241649325661,230048868797,241654961936,241667890224,241649266789,241659712938,241598642242,241661045559,241619808000,241604353349,241657873140,241635346676", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-09 11:49:04 Duration: 2s333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294847", "modelo" : "463", "itens" : "241787549195,241723940520,241718778084,241737910009,833500533627358,241720927991,241796154862,83350060983029B,241782046268,241791780721,241723114344,241790315863,241794258997,241787522325,241789562648,833500610002855,241718912543,241755064163,241787747071,241789513249,241735818692,241794073043,241751829818,241796195270,241790321319,241751835778,241757614546,241736891436,241751495565,241750260204,241723942540,241757614849,241755067597,241787520507,241718810109,241718822534,241718763841,241782518087,241718747980,241785823147,241704892443,241793478911,241752335557,241756993947,241787472545,241789689809,241750272831,241794161234,241751827393,241718795662,241785910911,833500603321896,241752347881,241737815476,241787378696,241757867982,241794164466,241723920619,241720983250,241736885273", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-09 10:10:56 Duration: 2s110ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295091", "modelo" : "320", "itens" : "241666297373,241620325760,241653147089,241602968297,834291942000193,241629341523,835205930000242,241638381631,241634843541,241652057880,241608948297,230049391835,241637500524,241619955870,835146922004084,241668729306,241617623241,241617462743,241620940423,241637879606,241593192125,241607329509,241619978195,241635832437,241703464256,241694320424,241674257387,241645515368,241679551429,241593236876,241673199292,241646245877,241690569709,241615925454,241661513843,241629434764,241631585759,241621049602,241708386262,241647193759,241663069214,241658117484,241667991019,241672836979,241656340421,241653866385,241629377788,230057032648", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-09 14:48:16 Duration: 2s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 364 2m36s 150ms 1s882ms 430ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 09 07 220 1m48s 491ms 08 63 21s949ms 348ms 16 55 16s362ms 297ms 17 26 10s163ms 390ms [ User: intelifix - Total duration: 2m36s - Times executed: 364 ]
[ Application: [unknown] - Total duration: 2m36s - Times executed: 364 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140284","seriais":"241782044955,241789278096,241724455878,241754248190,241734601919,241790559905,241720462537,241753785160,241722438890,241720424452,241780544764,241754214955,241757357293,241734681725,241758126773,241722361129,241797804058,241722440811,241704974751,241797776378,241787091924,241794916570,241787084347,241794921117,241720407278,241720436675,241754256474,241801947290,241724349706,241794800017,241754217076,241754236169,241720426270,241787139504,241722044150,241802008788,241725821837,241757346787,241725811432,241789147982","usuario":"399","observacao":""}');
Date: 2026-10-09 07:25:42 Duration: 1s882ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140284","seriais":"241744373041,241746459204,241814549205,241778591319,241776798595,241776799101,241775607783,241776817082,241814535264,241775594146,241825180726,241743288603,241744496262,241825361226,241771145474,241814386181,241765608907,241813633549,241814559711,241771298901,241745445962,241745689397,241762618402,241772822832,241771159011,241764000726,241771501222,241764301720,241814246066,241812948802,241814236772,241814269098,241771436164,241825233738,241824674458,241769278603","usuario":"399","observacao":""}');
Date: 2026-10-09 07:33:25 Duration: 1s797ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140284","seriais":"241775851523,241762534959,241764403750,241776518489,241775244157,241747220727,241775245571,241764368493,241776524349,241761357380,241814185151,241813332633,241765420202,241765413860,241776686991,241776507983,241738791318,241740540827,241763492943,241743221627,241813352938,241762586075,241742122137,241747162236,241812982341,241759946367,241778564144,241814185959,241747257878,241761333035,241827842029,241778770809,241812956782,241775253249,241776639411,241759928587,241813360919,241827571924","usuario":"399","observacao":""}');
Date: 2026-10-09 07:51:55 Duration: 1s796ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 271 9m46s 181ms 7s628ms 2s164ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 09 00 12 24s217ms 2s18ms 01 12 21s579ms 1s798ms 02 12 21s514ms 1s792ms 03 12 25s125ms 2s93ms 04 12 21s573ms 1s797ms 05 12 21s359ms 1s779ms 06 12 21s527ms 1s793ms 07 12 23s224ms 1s935ms 08 12 29s112ms 2s426ms 09 12 26s395ms 2s199ms 10 12 27s887ms 2s323ms 11 12 28s203ms 2s350ms 12 12 27s501ms 2s291ms 13 12 28s128ms 2s344ms 14 12 29s247ms 2s437ms 15 12 27s480ms 2s290ms 16 12 26s126ms 2s177ms 17 12 25s793ms 2s149ms 18 10 25s404ms 2s540ms 19 10 25s75ms 2s507ms 20 11 29s917ms 2s719ms 21 12 24s809ms 2s67ms 22 12 25s330ms 2s110ms [ User: intelifix - Total duration: 9m46s - Times executed: 271 ]
[ Application: psql - Total duration: 9m46s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 08:15:10 Duration: 7s628ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 20:05:07 Duration: 6s226ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 03:05:22 Duration: 6s34ms Database: rio User: intelifix Remote: [local] Application: psql
5 147 1h5m58s 159ms 6m21s 26s925ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 09 07 7 40s222ms 5s746ms 08 10 12m35s 1m15s 09 24 8m6s 20s280ms 10 35 22m27s 38s508ms 11 26 13m45s 31s738ms 12 1 17s969ms 17s969ms 13 12 10s567ms 880ms 14 14 6m28s 27s742ms 15 13 37s785ms 2s906ms 16 2 13s243ms 6s621ms 17 3 35s155ms 11s718ms [ User: intelifix - Total duration: 1h5m58s - Times executed: 147 ]
[ Application: [unknown] - Total duration: 1h5m58s - Times executed: 147 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030943, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 08:01:39 Duration: 6m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030991, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 10:11:48 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 14:25:46 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 127 3m28s 168ms 13s219ms 1s639ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 09 00 5 16s133ms 3s226ms 01 6 2s650ms 441ms 02 5 4s679ms 935ms 03 4 4s35ms 1s8ms 04 6 4s601ms 766ms 05 4 3s975ms 993ms 07 12 14s725ms 1s227ms 08 13 16s320ms 1s255ms 09 12 18s37ms 1s503ms 10 12 21s34ms 1s752ms 11 11 25s818ms 2s347ms 12 5 7s304ms 1s460ms 13 1 341ms 341ms 14 6 20s408ms 3s401ms 15 9 14s286ms 1s587ms 16 5 4s261ms 852ms 21 5 13s793ms 2s758ms 22 6 15s870ms 2s645ms [ User: intelifix - Total duration: 3m28s - Times executed: 127 ]
[ Application: psql - Total duration: 3m28s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 00:05:15 Duration: 13s219ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 14:25:08 Duration: 6s648ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 11:55:08 Duration: 6s601ms Database: rio User: intelifix Remote: [local] Application: psql
7 87 28s370ms 304ms 426ms 326ms 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 #7
Day Hour Count Duration Avg duration Oct 09 06 1 304ms 304ms 07 7 2s196ms 313ms 08 8 2s499ms 312ms 09 11 3s619ms 329ms 10 11 3s641ms 331ms 11 9 2s896ms 321ms 12 5 1s762ms 352ms 13 9 2s883ms 320ms 14 8 2s662ms 332ms 15 8 2s714ms 339ms 16 7 2s236ms 319ms 17 3 952ms 317ms [ User: lenon - Total duration: 28s370ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 28s370ms - Times executed: 87 ]
-
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-10-09 12:11:46 Duration: 426ms Database: brasilia 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-10-09 09:59:10 Duration: 418ms 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-10-09 15:05:10 Duration: 395ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 83 31s950ms 338ms 514ms 384ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 09 07 5 1s808ms 361ms 08 8 3s112ms 389ms 09 11 4s305ms 391ms 10 11 4s235ms 385ms 11 9 3s385ms 376ms 12 5 2s50ms 410ms 13 9 3s346ms 371ms 14 8 3s130ms 391ms 15 8 3s110ms 388ms 16 6 2s293ms 382ms 17 3 1s170ms 390ms [ User: intelifix - Total duration: 31s950ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 31s950ms - Times executed: 83 ]
-
select * from rs_menu_grants (406, 53, 1);
Date: 2026-10-09 08:25:00 Duration: 514ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-10-09 12:11:46 Duration: 492ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (472, 19, 1);
Date: 2026-10-09 08:16:41 Duration: 480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 79 18s427ms 150ms 645ms 233ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 09 07 8 2s683ms 335ms 08 5 1s570ms 314ms 09 8 1s560ms 195ms 10 7 1s447ms 206ms 11 14 2s716ms 194ms 12 13 2s923ms 224ms 14 21 4s697ms 223ms 15 3 827ms 275ms [ User: intelifix - Total duration: 18s427ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 18s427ms - Times executed: 79 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216507067778,216333579310,216697619305,216632720110,216724106076,216831942538,216800783234,216738592642,216815683858,216879676163', NULL, NULL, 062, 00);
Date: 2026-10-09 08:16:41 Duration: 645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230042952946,230022067192,230031748989,230032359308,230012400122,229972943139,230031793237', NULL, NULL, 0295, 00);
Date: 2026-10-09 07:57:41 Duration: 622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '230015190809,229953119801,229985330611,229953630716,229930296990,229935705363,229957970713,229937717882,229953208799,229920862647,229998091329,230002837986,229959961334,230003829711,229992968998', NULL, NULL, 0287, 00);
Date: 2026-10-09 14:45:04 Duration: 514ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 67 19s847ms 263ms 356ms 296ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 09 07 2 556ms 278ms 08 7 1s971ms 281ms 09 14 4s65ms 290ms 10 15 4s527ms 301ms 11 8 2s415ms 301ms 12 1 288ms 288ms 13 7 2s134ms 304ms 14 5 1s575ms 315ms 15 3 894ms 298ms 16 1 291ms 291ms 17 4 1s126ms 281ms [ User: intelifix - Total duration: 19s847ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 19s847ms - Times executed: 67 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-09 14:16:17 Duration: 356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-09 10:56:27 Duration: 326ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-09 13:43:10 Duration: 325ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 63 12m25s 11s74ms 13s736ms 11s837ms create table temp0000293812 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 09 09 47 9m5s 11s611ms 11 16 3m20s 12s500ms [ User: intelifix - Total duration: 12m25s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 12m25s - Times executed: 63 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:14:41 Duration: 13s736ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:31:02 Duration: 12s935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:15:59 Duration: 12s707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 59 5m12s 2s20ms 12s54ms 5s301ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 09 08 3 29s585ms 9s861ms 09 5 36s794ms 7s358ms 10 3 13s333ms 4s444ms 11 4 28s895ms 7s223ms 12 4 14s280ms 3s570ms 13 4 26s939ms 6s734ms 14 13 1m26s 6s681ms 15 5 24s171ms 4s834ms 16 5 16s150ms 3s230ms 17 13 35s764ms 2s751ms [ User: intelifix - Total duration: 5m12s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 5m12s - Times executed: 59 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 08:36:27 Duration: 12s54ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 14:29:42 Duration: 11s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 13:43:27 Duration: 11s751ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 52 1m10s 574ms 20s960ms 1s348ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 09 08 3 2s277ms 759ms 09 4 9s176ms 2s294ms 10 3 2s542ms 847ms 11 4 3s665ms 916ms 12 3 3s280ms 1s93ms 13 3 2s564ms 854ms 14 3 2s211ms 737ms 15 3 2s317ms 772ms 16 3 2s319ms 773ms 17 3 2s86ms 695ms 18 4 23s443ms 5s860ms 19 4 3s435ms 858ms 20 4 3s804ms 951ms 21 4 2s946ms 736ms 22 4 4s58ms 1s14ms [ User: intelifix - Total duration: 1m10s - Times executed: 52 ]
[ Application: psql - Total duration: 1m10s - Times executed: 52 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-09 18:00:23 Duration: 20s960ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-09 09:20:08 Duration: 6s994ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-09 22:20:04 Duration: 1s698ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 48 1h36m43s 2s162ms 6m29s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 09 07 3 7m3s 2m21s 08 3 5m45s 1m55s 09 3 5m53s 1m57s 10 3 6m23s 2m7s 11 3 6m7s 2m2s 12 3 6m16s 2m5s 13 3 6m2s 2m 14 3 6m13s 2m4s 15 3 6m23s 2m7s 16 3 6m11s 2m3s 17 3 5m52s 1m57s 18 3 5m48s 1m56s 19 3 5m46s 1m55s 20 3 5m48s 1m56s 21 3 5m35s 1m51s 22 3 5m31s 1m50s [ User: intelifix - Total duration: 1h36m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 07:11:31 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 10:11:06 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 15:11:05 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: psql
15 48 1h6m8s 273ms 3m48s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 09 07 3 4m37s 1m32s 08 3 3m58s 1m19s 09 3 4m1s 1m20s 10 3 4m17s 1m25s 11 3 4m21s 1m27s 12 3 4m23s 1m27s 13 3 4m10s 1m23s 14 3 4m20s 1m26s 15 3 4m13s 1m24s 16 3 4m6s 1m22s 17 3 4m5s 1m21s 18 3 3m59s 1m19s 19 3 3m58s 1m19s 20 3 3m52s 1m17s 21 3 3m48s 1m16s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h6m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 12:15:38 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 11:15:25 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 14:15:31 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
16 45 12s588ms 151ms 962ms 279ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 09 09 7 1s688ms 241ms 10 5 1s166ms 233ms 11 20 6s739ms 336ms 12 1 431ms 431ms 13 2 564ms 282ms 14 10 1s998ms 199ms [ User: intelifix - Total duration: 12s588ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 12s588ms - Times executed: 45 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '241631409603,241618130418,241645674957,241672011434,241603112229,241638978186,241616767489,241650978089,241653955058,241607318396,241635367587,241700762242,241645881117,241651668695,241639027383,241631308101,241673235761,241649323641,241649839303,241708480919,241656403636,241694974864,241603284243,241607757990,241649325661,230048868797,241654961936,241667890224,241659712938,241649266789,241598642242,241661045559,241619808000,241604353349,241657873140,241635346676,241726778608,241607756879,241609637893,241639024454,241607369917,241619355677,241655167185,241651144245,241637436173,241703505977,241646587279,241607160627,241599556281,241594003753,241661047680,241593990015,230040447493,241649369099,241645911928,241649557479,241656348198,241607161637,241661295662,241620009613,241667242528,241653175981,241653183333,241663193244,241667244144,241608757796,241651789516,241651793153,241693205353,241651668998,241603275454,241631307797,241667691921', '113;1', 'DEFAULT', 00, 0320, '','', '', 00);
Date: 2026-10-09 11:21:07 Duration: 962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D831391FAD72,D831391FB774,6C11BA65AD11,6C11BA684FC9,689E29BC289F,F4E84F88AA98,4896D956D51E,4896D953DB96,D89A0DA8F397,48D6823A8244,843C9921487D,3CF9F0A66F00,6C11BA6D1C55,3CF9F0AAC794,D89A0D85A03D,4896D9504F0E,F4E84F89C870,14CA56D389B9,C4EBFF9042A8,4896D95296A0', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-09 11:43:55 Duration: 785ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '319022491934,317171007184,5C769592812C,5C7695978B63,14B7F80E90EB,BC9B689A3D24,54A65C122084,383FB3AA4304,1062D0128F99,319141170101,A456CCE402C1,319137603434,318183159909,319056467183,318072415962,318339001117', '138;1', 'DEFAULT', 09, 046, '','', '', 00);
Date: 2026-10-09 11:50:28 Duration: 640ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
17 43 49s280ms 159ms 10s891ms 1s146ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 09 07 3 1s544ms 514ms 08 1 10s891ms 10s891ms 09 7 2s171ms 310ms 10 11 7s537ms 685ms 11 10 18s174ms 1s817ms 13 4 915ms 228ms 14 2 3s94ms 1s547ms 15 5 4s950ms 990ms [ User: intelifix - Total duration: 49s280ms - Times executed: 43 ]
[ Application: [unknown] - Total duration: 49s280ms - Times executed: 43 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0140284) LIMIT 1;
Date: 2026-10-09 08:11:26 Duration: 10s891ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139907) LIMIT 1;
Date: 2026-10-09 11:21:38 Duration: 3s602ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139950) LIMIT 1;
Date: 2026-10-09 11:09:25 Duration: 2s911ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 42 1m53s 2s444ms 3s380ms 2s695ms create table temp0000293812 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 09 09 35 1m30s 2s589ms 11 7 22s578ms 3s225ms [ User: intelifix - Total duration: 1m53s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 42 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-10-2026", "ate" :"09-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-09 11:19:05 Duration: 3s380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-10-2026", "ate" :"09-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-09 11:31:26 Duration: 3s362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-10-2026", "ate" :"09-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-09 11:19:22 Duration: 3s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 42 19s31ms 351ms 2s917ms 453ms create table temp0000227488 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 09 09 25 12s4ms 480ms 10 9 3s753ms 417ms 11 8 3s273ms 409ms [ User: intelifix - Total duration: 19s31ms - Times executed: 42 ]
[ Application: [unknown] - Total duration: 19s31ms - Times executed: 42 ]
-
CREATE TABLE temp0000227488 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-10-09 09:03:36 Duration: 2s917ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227488 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-10-09 10:00:06 Duration: 536ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227488 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-10-09 11:16:20 Duration: 523ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 38 7m45s 11s363ms 12s957ms 12s246ms create table temp0000293828 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 09 09 3 35s131ms 11s710ms 10 30 6m8s 12s277ms 11 5 1m1s 12s380ms [ User: intelifix - Total duration: 7m45s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 38 ]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:45:02 Duration: 12s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:20:18 Duration: 12s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:48:11 Duration: 12s854ms 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 2m43s 9m18s 6m17s 3 18m53s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 09 05 3 18m53s 6m17s [ User: intelifix - Total duration: 18m53s - Times executed: 3 ]
[ Application: psql - Total duration: 18m53s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-09 05:09:20 Duration: 9m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-09 05:16:12 Duration: 6m51s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-09 05:18:55 Duration: 2m43s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s162ms 6m29s 2m 48 1h36m43s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 09 07 3 7m3s 2m21s 08 3 5m45s 1m55s 09 3 5m53s 1m57s 10 3 6m23s 2m7s 11 3 6m7s 2m2s 12 3 6m16s 2m5s 13 3 6m2s 2m 14 3 6m13s 2m4s 15 3 6m23s 2m7s 16 3 6m11s 2m3s 17 3 5m52s 1m57s 18 3 5m48s 1m56s 19 3 5m46s 1m55s 20 3 5m48s 1m56s 21 3 5m35s 1m51s 22 3 5m31s 1m50s [ User: intelifix - Total duration: 1h36m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 07:11:31 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 10:11:06 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-09 15:11:05 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: psql
3 273ms 3m48s 1m22s 48 1h6m8s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 09 07 3 4m37s 1m32s 08 3 3m58s 1m19s 09 3 4m1s 1m20s 10 3 4m17s 1m25s 11 3 4m21s 1m27s 12 3 4m23s 1m27s 13 3 4m10s 1m23s 14 3 4m20s 1m26s 15 3 4m13s 1m24s 16 3 4m6s 1m22s 17 3 4m5s 1m21s 18 3 3m59s 1m19s 19 3 3m58s 1m19s 20 3 3m52s 1m17s 21 3 3m48s 1m16s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h6m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h6m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 12:15:38 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 11:15:25 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-09 14:15:31 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s275ms 1m2s 33s419ms 4 2m13s 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 Oct 09 20 2 1m7s 33s566ms 23 2 1m6s 33s273ms [ User: intelifix - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-09 20:08:41 Duration: 1m2s 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-10-09 23:16:37 Duration: 1m2s 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-10-09 23:33:55 Duration: 4s324ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 159ms 6m21s 26s925ms 147 1h5m58s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 09 07 7 40s222ms 5s746ms 08 10 12m35s 1m15s 09 24 8m6s 20s280ms 10 35 22m27s 38s508ms 11 26 13m45s 31s738ms 12 1 17s969ms 17s969ms 13 12 10s567ms 880ms 14 14 6m28s 27s742ms 15 13 37s785ms 2s906ms 16 2 13s243ms 6s621ms 17 3 35s155ms 11s718ms [ User: intelifix - Total duration: 1h5m58s - Times executed: 147 ]
[ Application: [unknown] - Total duration: 1h5m58s - Times executed: 147 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030943, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 08:01:39 Duration: 6m21s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030991, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 10:11:48 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-09 14:25:46 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 11s710ms 13s539ms 12s568ms 11 2m18s create table temp0000293890 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 09 13 8 1m40s 12s602ms 14 3 37s433ms 12s477ms [ User: intelifix - Total duration: 2m18s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m18s - Times executed: 11 ]
-
CREATE TABLE temp0000293890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 13:43:34 Duration: 13s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 13:50:28 Duration: 12s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 14:54:51 Duration: 12s952ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11s806ms 13s366ms 12s380ms 30 6m11s create table temp0000293836 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 09 09 3 37s280ms 12s426ms 10 25 5m8s 12s358ms 11 2 25s173ms 12s586ms [ User: intelifix - Total duration: 6m11s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m11s - Times executed: 30 ]
-
CREATE TABLE temp0000293836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:15:06 Duration: 13s366ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:16:41 Duration: 13s26ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:32:03 Duration: 13s12ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s869ms 12s787ms 12s274ms 10 2m2s create table temp0000293852 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 09 10 4 48s555ms 12s138ms 11 1 12s105ms 12s105ms 14 5 1m2s 12s416ms [ User: intelifix - Total duration: 2m2s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 10 ]
-
CREATE TABLE temp0000293852 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 14:22:25 Duration: 12s787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293852 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 14:24:15 Duration: 12s686ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293852 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:17:42 Duration: 12s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s363ms 12s957ms 12s246ms 38 7m45s create table temp0000293828 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 09 09 3 35s131ms 11s710ms 10 30 6m8s 12s277ms 11 5 1m1s 12s380ms [ User: intelifix - Total duration: 7m45s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 38 ]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:45:02 Duration: 12s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:20:18 Duration: 12s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293828 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 10:48:11 Duration: 12s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s934ms 14s920ms 11s909ms 15 2m58s create table temp0000293812 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 09 09 13 2m31s 11s624ms 11 2 27s525ms 13s762ms [ User: intelifix - Total duration: 2m58s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m58s - Times executed: 15 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-10-09 11:14:19 Duration: 14s920ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-10-09 11:16:18 Duration: 12s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-10-09 09:49:21 Duration: 12s344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 11s74ms 13s736ms 11s837ms 63 12m25s create table temp0000293812 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 09 09 47 9m5s 11s611ms 11 16 3m20s 12s500ms [ User: intelifix - Total duration: 12m25s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 12m25s - Times executed: 63 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:14:41 Duration: 13s736ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:31:02 Duration: 12s935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-09 11:15:59 Duration: 12s707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 150ms 1m 6s823ms 36 4m5s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 09 07 1 603ms 603ms 08 2 475ms 237ms 09 6 36s219ms 6s36ms 10 18 3m25s 11s402ms 11 6 1s556ms 259ms 14 3 1s551ms 517ms [ User: intelifix - Total duration: 4m5s - Times executed: 36 ]
[ Application: psql - Total duration: 4m5s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030992);
Date: 2026-10-09 10:17:53 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030996);
Date: 2026-10-09 10:20:34 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031010);
Date: 2026-10-09 10:59:43 Duration: 59s950ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s20ms 12s54ms 5s301ms 59 5m12s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 09 08 3 29s585ms 9s861ms 09 5 36s794ms 7s358ms 10 3 13s333ms 4s444ms 11 4 28s895ms 7s223ms 12 4 14s280ms 3s570ms 13 4 26s939ms 6s734ms 14 13 1m26s 6s681ms 15 5 24s171ms 4s834ms 16 5 16s150ms 3s230ms 17 13 35s764ms 2s751ms [ User: intelifix - Total duration: 5m12s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 5m12s - Times executed: 59 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 08:36:27 Duration: 12s54ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 14:29:42 Duration: 11s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-09', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-09 13:43:27 Duration: 11s751ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 216ms 23s196ms 3s625ms 36 2m10s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 09 07 1 23s196ms 23s196ms 08 1 4s442ms 4s442ms 09 10 35s764ms 3s576ms 10 11 38s393ms 3s490ms 11 5 14s364ms 2s872ms 13 6 7s950ms 1s325ms 14 2 6s399ms 3s199ms [ User: intelifix - Total duration: 2m10s - Times executed: 36 ]
[ Application: psql - Total duration: 2m10s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030943);
Date: 2026-10-09 07:55:09 Duration: 23s196ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031010);
Date: 2026-10-09 10:59:53 Duration: 9s144ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030947);
Date: 2026-10-09 09:14:42 Duration: 9s38ms Database: rio User: intelifix Remote: [local] Application: psql
15 583ms 13s273ms 3s200ms 38 2m1s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 09 08 3 13s441ms 4s480ms 09 2 7s544ms 3s772ms 10 3 23s765ms 7s921ms 11 2 6s857ms 3s428ms 12 3 12s662ms 4s220ms 13 3 2s410ms 803ms 14 3 22s677ms 7s559ms 15 3 19s315ms 6s438ms 16 3 2s633ms 877ms 17 3 2s364ms 788ms 18 2 1s514ms 757ms 19 2 1s495ms 747ms 20 2 1s617ms 808ms 21 2 1s608ms 804ms 22 2 1s726ms 863ms [ User: intelifix - Total duration: 2m1s - Times executed: 38 ]
[ Application: psql - Total duration: 2m1s - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-09 10:20:15 Duration: 13s273ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-09 12:00:12 Duration: 11s38ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-09 14:00:11 Duration: 9s527ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s444ms 3s380ms 2s695ms 42 1m53s create table temp0000293812 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 09 09 35 1m30s 2s589ms 11 7 22s578ms 3s225ms [ User: intelifix - Total duration: 1m53s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 42 ]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-10-2026", "ate" :"09-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-09 11:19:05 Duration: 3s380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-10-2026", "ate" :"09-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-09 11:31:26 Duration: 3s362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-10-2026", "ate" :"09-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-09 11:19:22 Duration: 3s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 181ms 7s628ms 2s164ms 271 9m46s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 09 00 12 24s217ms 2s18ms 01 12 21s579ms 1s798ms 02 12 21s514ms 1s792ms 03 12 25s125ms 2s93ms 04 12 21s573ms 1s797ms 05 12 21s359ms 1s779ms 06 12 21s527ms 1s793ms 07 12 23s224ms 1s935ms 08 12 29s112ms 2s426ms 09 12 26s395ms 2s199ms 10 12 27s887ms 2s323ms 11 12 28s203ms 2s350ms 12 12 27s501ms 2s291ms 13 12 28s128ms 2s344ms 14 12 29s247ms 2s437ms 15 12 27s480ms 2s290ms 16 12 26s126ms 2s177ms 17 12 25s793ms 2s149ms 18 10 25s404ms 2s540ms 19 10 25s75ms 2s507ms 20 11 29s917ms 2s719ms 21 12 24s809ms 2s67ms 22 12 25s330ms 2s110ms [ User: intelifix - Total duration: 9m46s - Times executed: 271 ]
[ Application: psql - Total duration: 9m46s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 08:15:10 Duration: 7s628ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 20:05:07 Duration: 6s226ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-09 03:05:22 Duration: 6s34ms Database: rio User: intelifix Remote: [local] Application: psql
18 168ms 13s219ms 1s639ms 127 3m28s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 09 00 5 16s133ms 3s226ms 01 6 2s650ms 441ms 02 5 4s679ms 935ms 03 4 4s35ms 1s8ms 04 6 4s601ms 766ms 05 4 3s975ms 993ms 07 12 14s725ms 1s227ms 08 13 16s320ms 1s255ms 09 12 18s37ms 1s503ms 10 12 21s34ms 1s752ms 11 11 25s818ms 2s347ms 12 5 7s304ms 1s460ms 13 1 341ms 341ms 14 6 20s408ms 3s401ms 15 9 14s286ms 1s587ms 16 5 4s261ms 852ms 21 5 13s793ms 2s758ms 22 6 15s870ms 2s645ms [ User: intelifix - Total duration: 3m28s - Times executed: 127 ]
[ Application: psql - Total duration: 3m28s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 00:05:15 Duration: 13s219ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 14:25:08 Duration: 6s648ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-09 11:55:08 Duration: 6s601ms Database: rio User: intelifix Remote: [local] Application: psql
19 574ms 20s960ms 1s348ms 52 1m10s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 09 08 3 2s277ms 759ms 09 4 9s176ms 2s294ms 10 3 2s542ms 847ms 11 4 3s665ms 916ms 12 3 3s280ms 1s93ms 13 3 2s564ms 854ms 14 3 2s211ms 737ms 15 3 2s317ms 772ms 16 3 2s319ms 773ms 17 3 2s86ms 695ms 18 4 23s443ms 5s860ms 19 4 3s435ms 858ms 20 4 3s804ms 951ms 21 4 2s946ms 736ms 22 4 4s58ms 1s14ms [ User: intelifix - Total duration: 1m10s - Times executed: 52 ]
[ Application: psql - Total duration: 1m10s - Times executed: 52 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-09 18:00:23 Duration: 20s960ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-09 09:20:08 Duration: 6s994ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-09 22:20:04 Duration: 1s698ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 159ms 10s891ms 1s146ms 43 49s280ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 09 07 3 1s544ms 514ms 08 1 10s891ms 10s891ms 09 7 2s171ms 310ms 10 11 7s537ms 685ms 11 10 18s174ms 1s817ms 13 4 915ms 228ms 14 2 3s94ms 1s547ms 15 5 4s950ms 990ms [ User: intelifix - Total duration: 49s280ms - Times executed: 43 ]
[ Application: [unknown] - Total duration: 49s280ms - Times executed: 43 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0140284) LIMIT 1;
Date: 2026-10-09 08:11:26 Duration: 10s891ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139907) LIMIT 1;
Date: 2026-10-09 11:21:38 Duration: 3s602ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139950) LIMIT 1;
Date: 2026-10-09 11:09:25 Duration: 2s911ms 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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 09 20 3 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 8m54s - Times executed: 5 ]
[ Application: psql - Total duration: 8m54s - Times executed: 5 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 12,980 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 28 FATAL entries
- 2296 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,270 Max number of times the same event was reported
- 2,332 Total events found
Rank Times reported Error 1 2,270 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 09 06 4 07 151 08 229 09 286 10 328 11 284 12 108 13 113 14 333 15 273 16 109 17 52 - ERROR: prepared statement "_PLAN0000000029EB4A30" does not exist
- ERROR: prepared statement "_PLAN000000002A489160" does not exist
- ERROR: prepared statement "_PLAN000000002A154860" does not exist
Statement: DEALLOCATE "_PLAN0000000029EB4A30"
Date: 2026-10-09 06:56:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A489160"
Date: 2026-10-09 06:57:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A154860"
Date: 2026-10-09 06:58:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 17 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 09 00 1 01 1 03 1 07 1 14 1 17 1 18 1 22 1 23 9 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-09 00:42:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-09 01:51:52 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-09 03:20:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 09 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-09 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-09 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-09 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 09 10 3 13 2 15 1 - ERROR: syntax error at or near "144621" at character 29
- ERROR: syntax error at or near "144621" at character 29
- ERROR: syntax error at or near "144621" at character 29
Statement: select * from rs_caixa_qr(''144621)
Date: 2026-10-09 10:38:03 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(''144621)
Date: 2026-10-09 10:38:04 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(''144621)
Date: 2026-10-09 10:38:08 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 09 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-09 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-09 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-09 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local]
6 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 09 10 2 14 2 - ERROR: trailing junk after numeric literal at or near "5447CC49B0A4" at character 27
- ERROR: trailing junk after numeric literal at or near "5447CC49B0A4" at character 27
- ERROR: trailing junk after numeric literal at or near "407135c" at character 27
Statement: select * from rs_caixa_qr(5447CC49B0A4)
Date: 2026-10-09 10:27:45 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(5447CC49B0A4)
Date: 2026-10-09 10:27:46 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(407135c)
Date: 2026-10-09 14:16:27 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 09 16 4 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-10-09 16:18:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-10-09 16:18:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-10-09 16:24:19 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 09 09 1 10 2 - LOG: process 1578354 still waiting for AccessExclusiveLock on relation 5910755 of database 358220 after 1000.092 ms
- LOG: process 1622637 still waiting for AccessExclusiveLock on relation 5938027 of database 358220 after 1000.114 ms
- LOG: process 1656344 still waiting for AccessExclusiveLock on relation 5940431 of database 358220 after 1000.077 ms
Detail: Process holding the lock: 1600615. Wait queue: 1578354.
Statement: DROP TABLE IF EXISTS temp0000293812;Date: 2026-10-09 09:40:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1650727. Wait queue: 1622637.
Statement: DROP TABLE IF EXISTS temp0000293836;Date: 2026-10-09 10:32:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1660755. Wait queue: 1656344.
Statement: DROP TABLE IF EXISTS temp0000293828;Date: 2026-10-09 10:40:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 09 10 3 - LOG: process 1656344 still waiting for ShareLock on transaction 7499620 after 1000.091 ms
- LOG: process 1656344 still waiting for ShareLock on transaction 7499620 after 5450.642 ms
- LOG: process 1656344 still waiting for ShareLock on transaction 7499620 after 9886.293 ms
Detail: Process holding the lock: 1634314. Wait queue: 1656344.
Context: while deleting tuple (638,20) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(031004)Date: 2026-10-09 10:45:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1634314. Wait queue: 1656344.
Context: while deleting tuple (638,20) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(031004)Date: 2026-10-09 10:45:29 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1634314. Wait queue: 1656344.
Context: while deleting tuple (638,20) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(031004)Date: 2026-10-09 10:45:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 09 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-10-09 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-09 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-09 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
11 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 09 09 1 10 2 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000293812"
Date: 2026-10-09 09:40:17
Context: automatic vacuum of table "rio.public.temp0000293836"
Date: 2026-10-09 10:32:17
Context: automatic vacuum of table "rio.public.temp0000293828"
Date: 2026-10-09 10:40:17
12 3 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 09 09 3 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(22974105013229791050113)Date: 2026-10-09 09:47:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(22974105013229791050113)Date: 2026-10-09 09:47:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(22974105013229791050113)Date: 2026-10-09 09:47:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 09 03 1 - LOG: database system was shut down at 2026-10-09 03:05:01 -03
Date: 2026-10-09 03:05:02
14 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 09 10 1 - FATAL: connection to client lost
Date: 2026-10-09 10:05:08 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #15
Day Hour Count Oct 09 10 1 - LOG: could not send data to client: Broken pipe
Date: 2026-10-09 10:05:08 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
16 1 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 09 10 1 - ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint
Detail: Failing row contains (6475905, null, 1, null, A, 31004, 13, 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',434);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 031004 ); ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint DETAIL: Failing row contains (6475905, null, 1, null, A, 31004, 13, 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-10-09 10:45:44 Database: rio Application: psql User: intelifix Remote: [local]
17 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 09 11 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140114,399,'835231934002169,241707053742','',0321,00,'[{"item":"0","qrcode":""}]','$$$','',0241707053742);Date: 2026-10-09 11:08:21 Database: brasilia Application: [unknown] User: intelifix Remote: [local]