pgBadger-
Global information
- Generated on Wed Jun 3 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 39,749 log entries in 6s
- Log start from 2026-06-03 00:01:01 to 2026-06-03 23:40:22
-
Overview
Global Stats
- 307 Number of unique normalized queries
- 6,562 Number of queries
- 7h18m29s Total query duration
- 2026-06-03 00:01:02 First query
- 2026-06-03 23:37:08 Last query
- 5 queries/s at 2026-06-03 15:35:34 Query peak
- 7h18m29s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h18m29s Execute total duration
- 2,525 Number of events
- 11 Number of unique normalized events
- 2,074 Max number of times the same event was reported
- 0 Number of cancellation
- 654 Total number of automatic vacuums
- 1,134 Total number of automatic analyzes
- 13 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 220 Total number of sessions
- 7 sessions at 2026-06-03 13:07:39 Session peak
- 7d23h26m57s Total duration of sessions
- 52m12s Average duration of sessions
- 29 Average queries per session
- 1m59s Average queries duration per session
- 50m13s Average idle time per session
- 645 Total number of connections
- 4 connections/s at 2026-06-03 03:05:16 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-03 15:35:34 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-03 08:31:29 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-03 23:36:35 Date
Queries duration
Key values
- 7h18m29s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 03 00 27 0ms 18s274ms 3s141ms 5s26ms 57s256ms 57s256ms 01 12 0ms 3s501ms 2s174ms 4s659ms 4s899ms 4s899ms 02 10 0ms 3s716ms 2s557ms 5s565ms 5s565ms 5s565ms 03 11 0ms 3s769ms 2s417ms 6s99ms 6s99ms 6s99ms 04 40 0ms 3s583ms 862ms 4s963ms 5s192ms 6s247ms 05 17 0ms 7m54s 37s498ms 2m12s 7m54s 7m54s 06 15 0ms 8s737ms 2s871ms 3s835ms 20s909ms 20s909ms 07 389 0ms 7m41s 5s214ms 1m11s 3m45s 7m52s 08 481 0ms 5m55s 2s470ms 31s811ms 1m2s 6m2s 09 726 150ms 5m58s 1s879ms 31s111ms 53s24ms 6m33s 10 659 150ms 8m13s 2s687ms 1m13s 3m35s 8m17s 11 633 150ms 6m19s 2s367ms 37s303ms 3m51s 6m55s 12 191 0ms 6m2s 5s667ms 18s442ms 3m31s 6m36s 13 568 0ms 5m28s 1s540ms 16s182ms 42s469ms 5m58s 14 856 150ms 6m21s 2s577ms 1m8s 3m53s 7m32s 15 786 150ms 6m28s 2s262ms 40s437ms 3m47s 6m34s 16 594 0ms 46m36s 7s284ms 56s733ms 3m45s 46m37s 17 189 0ms 43m51s 18s241ms 51s502ms 1m1s 43m52s 18 15 0ms 5m9s 24s259ms 4s81ms 5m39s 5m39s 19 13 469ms 5m3s 27s229ms 5m32s 5m32s 5m32s 20 68 0ms 5m36s 11s863ms 2m8s 5m36s 5m36s 21 24 0ms 4m59s 14s866ms 6s372ms 5m26s 5m26s 22 19 0ms 5m6s 19s102ms 5s97ms 5m33s 5m33s 23 219 0ms 1m23s 7s395ms 1m6s 1m20s 1m39s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 03 00 13 0 502ms 356ms 2s140ms 2s709ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 28 0 222ms 327ms 378ms 1s295ms 05 4 0 301ms 0ms 170ms 1s35ms 06 6 0 685ms 0ms 1s661ms 2s451ms 07 307 0 5s218ms 6s174ms 1m3s 4m31s 08 370 0 2s370ms 7s674ms 11s531ms 3m37s 09 567 0 1s829ms 9s191ms 18s683ms 3m56s 10 484 0 3s4ms 10s160ms 1m4s 4m3s 11 480 0 2s519ms 6s980ms 11s992ms 3m56s 12 121 0 7s470ms 2s482ms 3s669ms 3m53s 13 430 0 1s752ms 9s433ms 14s924ms 1m19s 14 658 0 2s681ms 18s340ms 1m4s 4m12s 15 602 0 2s347ms 9s76ms 21s196ms 4m4s 16 449 0 8s907ms 20s963ms 50s234ms 6m54s 17 141 0 23s535ms 6s262ms 47s887ms 43m52s 18 6 0 56s722ms 0ms 894ms 5m39s 19 4 0 1m23s 0ms 5m32s 5m32s 20 6 53 13s247ms 55s216ms 2m8s 5m36s 21 11 0 29s920ms 354ms 1s333ms 5m26s 22 4 0 1m23s 0ms 0ms 5m33s 23 4 215 7s395ms 1m5s 1m6s 1m39s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 03 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 2 2.00 0.00% 07 0 6 6.00 0.00% 08 0 8 8.00 0.00% 09 0 8 8.00 0.00% 10 0 8 8.00 0.00% 11 0 10 10.00 0.00% 12 0 5 5.00 0.00% 13 0 8 8.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 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 03 00 26 0.01/s 01 17 0.00/s 02 18 0.01/s 03 20 0.01/s 04 19 0.01/s 05 22 0.01/s 06 22 0.01/s 07 31 0.01/s 08 35 0.01/s 09 35 0.01/s 10 36 0.01/s 11 36 0.01/s 12 33 0.01/s 13 35 0.01/s 14 36 0.01/s 15 34 0.01/s 16 34 0.01/s 17 30 0.01/s 18 26 0.01/s 19 21 0.01/s 20 27 0.01/s 21 25 0.01/s 22 23 0.01/s 23 4 0.00/s Day Hour Count Average Duration Average idle time Jun 03 00 2 37m 36m17s 01 8 1h1m7s 1h1m4s 02 3 1h 59m51s 03 6 22m29s 22m24s 04 3 1h1m 1h48s 05 5 58m36s 56m29s 06 3 1h 59m45s 07 9 48m15s 44m29s 08 14 54m39s 53m14s 09 18 50m32s 49m16s 10 16 50m18s 48m27s 11 16 52m31s 50m57s 12 16 52m4s 50m57s 13 7 53m52s 51m47s 14 17 52m30s 50m20s 15 16 53m42s 51m51s 16 15 56m41s 51m53s 17 14 57m25s 53m19s 18 9 54m46s 54m6s 19 3 1h1m42s 59m44s 20 5 27m23s 24m41s 21 4 1h45s 59m16s 22 6 52m10s 51m9s 23 5 42m1s 36m37s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-03 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 645 connections Total
Connections per user
Key values
- intelifix Main User
- 645 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-03 13:07:39 Date
Histogram of session times
Key values
- 167 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 220 sessions Total
Sessions per user
Key values
- intelifix Main User
- 220 sessions Total
Sessions per host
Key values
- [local] Main Host
- 220 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 31,127 buffers Checkpoint Peak
- 2026-06-03 16:49:37 Date
- 270.028 seconds Highest write time
- 0.043 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-06-03 10:49:36 Date
Checkpoints distance
Key values
- 460.63 Mo Distance Peak
- 2026-06-03 10:49:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 03 00 16,509 735.408s 0.023s 735.461s 01 1,771 177.676s 0.017s 177.726s 02 1,547 155.312s 0.014s 155.352s 03 1,086 108.315s 0.027s 108.368s 04 4,711 472.079s 0.023s 472.136s 05 7,769 747.648s 0.027s 747.713s 06 3,913 269.629s 0.002s 269.635s 07 43,614 2,776.573s 0.091s 2,776.751s 08 78,974 2,985.246s 0.187s 2,985.576s 09 67,258 3,239.287s 0.225s 3,239.654s 10 81,433 3,239.349s 0.231s 3,239.751s 11 68,795 3,239.24s 0.248s 3,239.655s 12 51,161 2,410.737s 0.127s 2,410.956s 13 26,592 2,189.426s 0.165s 2,189.702s 14 74,011 3,239.235s 0.283s 3,239.71s 15 63,578 3,239.219s 0.261s 3,239.65s 16 165,334 3,239.313s 0.287s 3,239.763s 17 145,619 2,969.336s 0.208s 2,969.645s 18 1,816 182.1s 0.01s 182.133s 19 48 4.859s 0.005s 4.87s 20 2,304 373.027s 0.003s 373.037s 21 1,994 200.034s 0.026s 200.097s 22 2,138 214.595s 0.019s 214.639s 23 883 88.647s 0.009s 88.677s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 03 00 0 0 6 524 0.003s 0.007s 01 0 0 0 398 0.003s 0.006s 02 0 0 1 391 0.002s 0.007s 03 0 0 0 282 0.003s 0.006s 04 0 0 2 697 0.002s 0.009s 05 0 0 3 643 0.003s 0.009s 06 0 0 1 7 0.002s 0.001s 07 0 0 32 3,199 0.003s 0.012s 08 0 0 40 4,946 0.004s 0.012s 09 0 0 40 6,193 0.004s 0.012s 10 0 0 41 6,178 0.004s 0.012s 11 0 0 34 6,094 0.011s 0.012s 12 0 0 19 2,641 0.007s 0.012s 13 0 0 12 4,355 0.012s 0.012s 14 0 0 45 6,572 0.004s 0.012s 15 0 0 40 6,118 0.009s 0.012s 16 0 0 77 4,959 0.006s 0.012s 17 0 0 65 3,569 0.006s 0.011s 18 0 0 0 91 0.002s 0.007s 19 0 0 0 8 0.002s 0.002s 20 0 0 2 59 0.002s 0.002s 21 0 0 1 324 0.010s 0.007s 22 0 0 0 421 0.003s 0.007s 23 0 0 0 33 0.003s 0.007s Day Hour Count Avg time (sec) Jun 03 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 03 00 12,929.86 kB 38,964.71 kB 01 1,610.83 kB 22,439.33 kB 02 1,334.00 kB 12,531.17 kB 03 1,009.33 kB 2,667.67 kB 04 2,858.78 kB 3,558.33 kB 05 6,299.78 kB 19,267.89 kB 06 10,037.00 kB 15,538.00 kB 07 44,594.50 kB 72,416.58 kB 08 54,832.42 kB 126,382.50 kB 09 53,374.92 kB 116,987.58 kB 10 56,348.17 kB 108,424.25 kB 11 46,474.58 kB 127,717.75 kB 12 26,745.67 kB 77,986.33 kB 13 15,687.92 kB 35,638.33 kB 14 61,873.75 kB 89,941.75 kB 15 53,582.00 kB 96,455.00 kB 16 105,193.00 kB 151,072.17 kB 17 97,220.55 kB 125,279.55 kB 18 1,118.67 kB 131,972.50 kB 19 100.50 kB 85,421.00 kB 20 13,468.00 kB 71,604.50 kB 21 1,365.00 kB 45,998.14 kB 22 1,644.00 kB 22,859.14 kB 23 354.00 kB 12,483.00 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-03 10:41:48 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-03 16:09:15 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 104.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 1 104.00 MiB 104.00 MiB 14 3 311.99 MiB 104.00 MiB 15 0 0 0 16 4 415.98 MiB 104.00 MiB 17 3 311.99 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 13 1.32 GiB 103.99 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0248997,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 16:44:54 Duration: 46m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0249092,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 17:46:21 Duration: 43m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025106, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-03 07:11:23 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 10:41:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 16:38:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 11:25:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 16:23:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 16:09:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,304,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 14:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 17:25:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,304,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 16:54:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 17:17:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 13:38:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 14:01:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 17:32:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 103.99 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,317,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-03 14:19:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 15.61 sec Highest CPU-cost vacuum
Table public.caixa_itens
Database rio - 2026-06-03 17:47:12 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 15.61 sec Highest CPU-cost vacuum
Table public.caixa_itens
Database rio - 2026-06-03 17:47:12 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (148) Main table analyzed (database rio)
- 1,134 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 148 rio.pg_catalog.pg_class 74 rio.pg_catalog.pg_type 64 contagem.pg_catalog.pg_attribute 58 rio.public.temp0000281577 56 rio.public.usuarios 53 contagem.pg_catalog.pg_class 41 rio.pg_catalog.pg_index 41 contagem.public.temp0000226330 34 rio.public.temp0000281479 32 contagem.public.temp0000226328 32 contagem.pg_catalog.pg_type 31 rio.pg_catalog.pg_depend 30 contagem.public.usuarios 24 rio.public.temp0000281623 21 contagem.pg_catalog.pg_index 21 rio.public.temp0000281613 21 rio.public.temp0000281667 21 rio.public.temp0000281335 19 rio.public.temp0000281631 18 rio.public.temp0000281587 18 rio.public.temp0000281583 18 rio.public.temp0000281645 17 contagem.public.temp0000226322 16 contagem.pg_catalog.pg_depend 16 rio.public.temp0000281615 15 rio.public.temp0000281693 11 rio.public.temp0000281327 11 contagem.public.temp0000226304 11 rio.public.temp0000281673 10 rio.public.temp0000281649 10 rio.public.temp0000281523 9 rio.public.temp0000281627 8 rio.public.temp0000281675 8 rio.public.temp0000281617 8 rio.public.temp0000281093 7 contagem.public.temp0000226296 7 contagem.auditor.auditor_2026_06 6 postgres.pg_catalog.pg_shdepend 6 contagem.pg_catalog.pg_shdepend 5 rio.public.temp0000281651 5 rio.public.temp0000281663 5 rio.public.tmp_drill_0175 5 rio.public.temp0000281655 5 rio.auditor.auditor_2026_06 5 template1.pg_catalog.pg_shdepend 5 contagem.public.nf_entrada 4 rio.public.temp0000281573 4 rio.public.temp0000281599 4 rio.public.temp0000281593 3 rio.public.temp0000281683 3 rio.public.temp0000281671 3 rio.public.temp0000281339 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000281575 2 contagem.public.temp0000226294 2 rio.public.temp0000281687 2 rio.public.temp0000281629 2 rio.public.tmp_drill_0302 2 rio.public.temp0000281601 1 rio.public.temp0000281301 1 rio.public.temp0000281589 1 rio.public.temp0000281619 1 rio.public.temp0000281597 1 contagem.public.parametros 1 rio.public.temp0000281695 1 rio.public.temp0000281591 1 rio.public.temp0000281585 1 rio.public.temp0000281633 1 rio.public.temp0000281647 1 Total 1,134 Vacuums per table
Key values
- pg_catalog.pg_attribute (97) Main table vacuumed on database rio
- 654 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 97 47 0 0 0 0 0 27,053 7,230 10,484,369 458 11,044 rio.pg_catalog.pg_class 77 25 0 0 0 0 0 5,325 1,758 2,351,283 93 338 rio.pg_catalog.pg_type 71 23 0 0 0 0 0 2,030 619 718,007 96 326 rio.public.temp0000281577 55 0 0 0 0 0 0 42,048 257 2,523,654 0 0 rio.public.usuarios 40 2 0 0 0 0 0 87 41 68,168 2 2 rio.pg_catalog.pg_index 37 15 0 0 0 0 0 1,096 318 246,365 50 106 contagem.public.usuarios 25 0 0 0 0 0 0 139 89 47,520 0 0 contagem.pg_catalog.pg_attribute 22 22 0 0 0 0 0 13,982 3,708 6,688,864 52 1,319 rio.public.temp0000281335 19 0 0 0 0 0 0 1,456 105 102,909 0 0 rio.pg_catalog.pg_depend 18 12 0 0 0 0 0 3,732 1,423 1,932,885 76 760 contagem.pg_catalog.pg_class 14 14 0 0 0 0 0 2,483 630 930,972 33 237 contagem.pg_catalog.pg_type 14 14 0 0 0 0 0 1,276 382 585,282 13 32 rio.public.temp0000281693 11 0 0 0 0 0 0 3,134 35 190,954 0 0 rio.pg_catalog.pg_statistic 11 11 0 0 0 0 0 13,714 3,509 16,487,636 1,186 5,646 rio.public.temp0000281673 10 0 0 0 0 0 0 12,394 38 737,146 0 0 rio.public.temp0000281327 10 0 0 0 0 0 0 726 56 53,703 0 0 rio.public.temp0000281523 9 0 0 0 0 0 0 773 50 54,286 0 0 contagem.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,028 616 1,273,916 11 72 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 383 111 104,505 12 16 rio.public.temp0000281093 7 0 0 0 0 0 0 255 37 21,796 0 0 rio.public.temp0000281617 7 0 0 0 0 0 0 9,290 27 552,266 0 0 rio.public.tmp_drill_0175 6 5 0 0 0 0 0 231 15 52,610 0 0 rio.public.temp0000281667 6 0 0 0 0 0 0 763 167 280,265 0 0 rio.auditor.auditor_2026_06 6 0 0 0 0 0 0 235,500 86,727 124,079,800 73,596 1,587,721 rio.public.temp0000281651 5 0 0 0 0 0 0 6,196 19 368,514 0 0 contagem.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,547 1,457 4,870,917 1,101 7,210 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,192 492 2,731,329 150 569 rio.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 800 269 423,590 38 70 rio.public.temp0000281615 3 0 0 0 0 0 0 184 15 13,240 0 0 contagem.auditor.auditor_2026_06 3 0 0 0 0 0 0 15,635 8,644 11,242,669 2,741 53,698 rio.public.temp0000281671 3 0 0 0 0 0 0 107 12 8,330 0 0 rio.public.temp0000281339 3 0 0 0 0 0 0 234 18 16,183 0 0 rio.public.temp0000281627 2 0 0 0 0 0 0 162 10 11,064 0 0 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 384 131 210,542 15 20 rio.public.temp0000281631 2 0 0 0 0 0 0 186 12 12,826 0 0 contagem.public.temp0000226322 2 0 0 0 0 0 0 99 11 7,603 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 336 86 311,708 31 82 rio.public.temp0000281629 2 0 0 0 0 0 0 3,094 1,551 2,145,555 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 1,892 6 318,443 0 0 rio.public.caixa_itens_exclusao 2 0 0 0 0 0 0 854 332 1,444,149 316 37,605 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 457 166 263,628 18 43 rio.public.temp0000281687 2 0 0 0 0 0 0 177 11 12,459 0 0 rio.public.nf_entrada_arquivo_erros 2 0 0 0 0 0 0 745 347 971,180 150 7,017 rio.public.temp0000281619 1 0 0 0 0 0 0 90 6 6,233 0 0 rio.public.temp0000281683 1 0 0 0 0 0 0 8 5 1,335 0 0 rio.public.logs 1 0 0 0 0 0 0 551 201 267,458 176 4,208 rio.public.temp0000281601 1 0 0 0 0 0 0 8 5 1,312 0 0 rio.public.temp0000281301 1 0 0 0 0 0 0 172 6 11,171 0 0 rio.public.temp0000281479 1 0 0 0 0 0 0 90 6 6,233 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 61 31 100,790 15 2,775 rio.public.lote_caixas 1 1 0 0 0 0 0 921 437 1,916,853 3 8 rio.public.temp0000281599 1 0 0 0 0 0 0 67 6 4,825 0 0 rio.public.caixa_itens 1 1 0 0 0 0 0 52,956 35,756 150,093,586 427 25,433 rio.public.temp0000281633 1 0 0 0 0 0 0 8 5 1,319 0 0 rio.public.temp0000281647 1 0 0 0 0 0 0 96 6 6,597 0 0 rio.public.temp0000281695 1 0 0 0 0 0 0 109 6 7,392 0 0 rio.public.temp0000281655 1 0 0 0 0 0 0 119 6 7,984 0 0 rio.public.temp0000281585 1 0 0 0 0 0 0 8 5 1,309 0 0 Total 654 228 0 0 0 0 0 473,443 158,024 348,387,487 80,859 1,746,357 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (29.27) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.63 rio.pg_catalog.pg_class 0 0 0.78 rio.pg_catalog.pg_type 0 0 0.29 rio.public.temp0000281577 0 0 1.69 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.11 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.57 rio.public.temp0000281335 0 0 0.21 rio.pg_catalog.pg_depend 0 0 0.68 contagem.pg_catalog.pg_class 0 0 0.28 contagem.pg_catalog.pg_type 0 0 0.26 rio.public.temp0000281693 0 0 0.48 rio.pg_catalog.pg_statistic 0 0 1.61 rio.public.temp0000281673 0 0 0.47 rio.public.temp0000281327 0 0 0.08 rio.public.temp0000281523 0 0 0.12 contagem.pg_catalog.pg_depend 0 0 0.26 contagem.pg_catalog.pg_index 0 0 0.07 rio.public.temp0000281093 0 0 0.07 rio.public.temp0000281617 0 0 0.32 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000281667 0 0 0.09 rio.auditor.auditor_2026_06 0 0 29.27 rio.public.temp0000281651 0 0 0.22 contagem.pg_catalog.pg_statistic 0 0 0.39 rio.pg_toast.pg_toast_2619 0 0 0.2 rio.pg_catalog.pg_shdepend 0 0 0.15 rio.public.temp0000281615 0 0 0.06 contagem.auditor.auditor_2026_06 0 0 2.81 rio.public.temp0000281671 0 0 0.09 rio.public.temp0000281339 0 0 0.03 rio.public.temp0000281627 0 0 0.02 contagem.pg_catalog.pg_shdepend 0 0 0.08 rio.public.temp0000281631 0 0 0.02 contagem.public.temp0000226322 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000281629 0 0 0.11 rio.public.tmp_drill_0302 0 0 0.06 rio.public.caixa_itens_exclusao 0 0 0.17 postgres.pg_catalog.pg_shdepend 0 0 0.08 rio.public.temp0000281687 0 0 0.03 rio.public.nf_entrada_arquivo_erros 0 0 0.18 rio.public.temp0000281619 0 0 0 rio.public.temp0000281683 0 0 0.01 rio.public.logs 0 0 0.26 rio.public.temp0000281601 0 0 0.01 rio.public.temp0000281301 0 0 0.02 rio.public.temp0000281479 0 0 0.01 rio.public.equipamentos_referencia 0 0 0.01 rio.public.lote_caixas 0 0 0.57 rio.public.temp0000281599 0 0 0.01 rio.public.caixa_itens 0 0 15.61 rio.public.temp0000281633 0 0 0 rio.public.temp0000281647 0 0 0.01 rio.public.temp0000281695 0 0 0.02 rio.public.temp0000281655 0 0 0.01 rio.public.temp0000281585 0 0 0.01 Total 0 0 63.62 Tuples removed per table
Key values
- pg_catalog.pg_attribute (210915) Main table with removed tuples on database rio
- 431387 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 97 47 210,915 3,014,036 834,953 303 73,711 contagem.pg_catalog.pg_attribute 22 22 84,336 530,896 64 118 11,921 rio.public.tmp_drill_0302 2 2 28,608 28,814 0 0 724 rio.public.caixa_itens 1 1 19,962 4,416,075 0 0 41,807 rio.pg_catalog.pg_statistic 11 11 17,556 95,006 1,737 0 14,146 rio.pg_catalog.pg_depend 18 12 13,259 384,249 40,503 0 3,309 rio.pg_catalog.pg_type 71 23 9,451 211,471 47,664 16 5,787 contagem.pg_catalog.pg_statistic 4 4 6,904 31,152 0 0 4,044 rio.auditor.auditor_2026_06 6 0 5,608 18,689,486 0 0 900,685 rio.pg_catalog.pg_index 37 15 4,800 87,782 16,057 0 2,268 rio.pg_catalog.pg_shdepend 4 4 4,163 37,137 4 0 404 rio.pg_catalog.pg_class 77 25 3,919 419,739 116,723 54 11,416 contagem.pg_catalog.pg_type 14 14 3,572 31,518 2 13 892 contagem.pg_catalog.pg_depend 8 8 3,352 151,971 6 0 1,384 rio.public.nf_entrada_arquivo_erros 2 0 2,453 16,460,728 3 0 292,231 postgres.pg_catalog.pg_shdepend 2 2 1,912 18,509 1 0 202 contagem.pg_catalog.pg_index 8 8 1,890 15,189 1 4 411 contagem.pg_catalog.pg_class 14 14 1,817 45,353 4 42 1,610 contagem.pg_catalog.pg_shdepend 2 2 1,794 18,528 1 0 202 rio.public.tmp_drill_0175 6 5 1,730 4,072 646 0 95 contagem.public.usuarios 25 0 1,511 580 0 0 50 rio.pg_toast.pg_toast_2619 4 4 1,231 3,370 72 0 1,136 rio.public.caixa_itens_exclusao 2 0 282 2,522,142 0 0 21,027 contagem.pg_toast.pg_toast_2619 2 2 192 238 0 0 116 rio.public.usuarios 40 2 124 33,777 13,537 0 651 rio.public.lote_caixas 1 1 46 456,563 0 0 3,865 rio.public.temp0000281651 5 0 0 108,954 0 0 8,000 rio.public.temp0000281673 10 0 0 217,971 0 0 16,000 rio.public.temp0000281619 1 0 0 1,408 0 46 82 rio.public.temp0000281683 1 0 0 1,686 0 33 95 rio.public.temp0000281627 2 0 0 6,677 0 40 152 rio.public.temp0000281327 10 0 0 42,456 0 391 953 rio.public.logs 1 0 0 15,799,743 0 0 631,222 rio.public.temp0000281601 1 0 0 1,407 0 46 82 rio.public.temp0000281301 1 0 0 7,271 0 28 164 rio.public.temp0000281093 7 0 0 47,565 0 146 1,070 rio.public.temp0000281479 1 0 0 1,407 0 46 82 rio.public.temp0000281615 3 0 0 24,624 0 92 1,764 rio.public.equipamentos_referencia 1 0 0 5,009,367 0 0 27,079 rio.public.temp0000281631 2 0 0 3,008 0 86 170 contagem.public.temp0000226322 2 0 0 2,152 0 90 166 rio.public.temp0000281693 11 0 0 239,903 0 0 17,600 rio.public.temp0000281335 19 0 0 96,253 0 520 2,168 rio.public.temp0000281667 6 0 0 40,292 0 241 911 rio.public.temp0000281629 2 0 0 43,566 0 0 3,200 rio.public.temp0000281617 7 0 0 152,495 0 0 11,200 rio.public.temp0000281599 1 0 0 1,115 0 5 59 rio.public.temp0000281577 55 0 0 734,982 0 825 53,255 rio.public.temp0000281687 2 0 0 14,930 0 47 337 rio.public.temp0000281523 9 0 0 56,847 0 322 1,278 rio.public.temp0000281633 1 0 0 1,543 0 41 87 rio.public.temp0000281647 1 0 0 1,544 0 40 88 contagem.auditor.auditor_2026_06 3 0 0 1,175,033 0 0 51,811 rio.public.temp0000281671 3 0 0 45,253 0 37 3,291 rio.public.temp0000281695 1 0 0 1,768 0 27 101 rio.public.temp0000281339 3 0 0 10,206 0 110 210 rio.public.temp0000281655 1 0 0 4,962 0 17 111 rio.public.temp0000281585 1 0 0 1,403 0 47 81 Total 654 228 431,387 71,606,172 1,071,978 3,873 2,226,963 Pages removed per table
Key values
- public.temp0000281577 (825) Main table with removed pages on database rio
- 3873 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000281577 55 0 0 825 rio.public.temp0000281335 19 0 0 520 rio.public.temp0000281327 10 0 0 391 rio.public.temp0000281523 9 0 0 322 rio.pg_catalog.pg_attribute 97 47 210915 303 rio.public.temp0000281667 6 0 0 241 rio.public.temp0000281093 7 0 0 146 contagem.pg_catalog.pg_attribute 22 22 84336 118 rio.public.temp0000281339 3 0 0 110 rio.public.temp0000281615 3 0 0 92 contagem.public.temp0000226322 2 0 0 90 rio.public.temp0000281631 2 0 0 86 rio.pg_catalog.pg_class 77 25 3919 54 rio.public.temp0000281687 2 0 0 47 rio.public.temp0000281585 1 0 0 47 rio.public.temp0000281619 1 0 0 46 rio.public.temp0000281601 1 0 0 46 rio.public.temp0000281479 1 0 0 46 contagem.pg_catalog.pg_class 14 14 1817 42 rio.public.temp0000281633 1 0 0 41 rio.public.temp0000281627 2 0 0 40 rio.public.temp0000281647 1 0 0 40 rio.public.temp0000281671 3 0 0 37 rio.public.temp0000281683 1 0 0 33 rio.public.temp0000281301 1 0 0 28 rio.public.temp0000281695 1 0 0 27 rio.public.temp0000281655 1 0 0 17 rio.pg_catalog.pg_type 71 23 9451 16 contagem.pg_catalog.pg_type 14 14 3572 13 rio.public.temp0000281599 1 0 0 5 contagem.pg_catalog.pg_index 8 8 1890 4 rio.pg_catalog.pg_index 37 15 4800 0 rio.public.temp0000281651 5 0 0 0 rio.public.temp0000281673 10 0 0 0 rio.public.tmp_drill_0175 6 5 1730 0 rio.pg_catalog.pg_depend 18 12 13259 0 contagem.pg_catalog.pg_depend 8 8 3352 0 rio.public.logs 1 0 0 0 contagem.pg_catalog.pg_shdepend 2 2 1794 0 contagem.pg_catalog.pg_statistic 4 4 6904 0 rio.public.equipamentos_referencia 1 0 0 0 contagem.public.usuarios 25 0 1511 0 rio.public.lote_caixas 1 1 46 0 rio.public.temp0000281693 11 0 0 0 contagem.pg_toast.pg_toast_2619 2 2 192 0 rio.public.temp0000281629 2 0 0 0 rio.public.temp0000281617 7 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1231 0 rio.public.tmp_drill_0302 2 2 28608 0 rio.public.caixa_itens_exclusao 2 0 282 0 postgres.pg_catalog.pg_shdepend 2 2 1912 0 rio.pg_catalog.pg_shdepend 4 4 4163 0 rio.pg_catalog.pg_statistic 11 11 17556 0 rio.public.caixa_itens 1 1 19962 0 rio.public.nf_entrada_arquivo_erros 2 0 2453 0 rio.public.usuarios 40 2 124 0 rio.auditor.auditor_2026_06 6 0 5608 0 contagem.auditor.auditor_2026_06 3 0 0 0 Total 654 228 431,387 3,873 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 03 00 1 1 01 0 0 02 0 0 03 0 0 04 1 6 05 5 0 06 0 1 07 17 48 08 65 134 09 50 131 10 54 122 11 40 134 12 10 50 13 34 89 14 53 143 15 45 134 16 213 100 17 66 40 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 - 15.61 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 30s868ms 30s868ms 30s868ms 30s868ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 10:35:39 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 00:05:22 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 17:15:07 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s444ms 1s444ms 1s444ms 1s444ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248820, 450, 'F200012004B1212,84011295ACF1$F200012236B05C4,1834AF275758$F200011008B005C,9877E70765A1$F20001020613C6F,743AEF70B1EC$F200010209B8829,743AEF712836$F200011081B1884,9877E74B1B76$F200011081BA8F5,9877E74B5AA7$F200010318B0C99,743AEFD95A24$F200012005B5BC6,840112961CF8$F200010266B3F72,743AEF9B00DD$F200011148B3A84,9877E7BC1760$F200011081B05C1,9877E74B1342$F200011291B2E87,8401125FFFBB$F200011301B1135,8401127FBD08$F200010209B7500,743AEF711FD8', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 11:07:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40131, 413, '834066910000557,230048419809,241637607278,241732173747,241618234445,241672704969,241605375053,241700946378,241715043557,241713368499,241677396268,241729498301,241704667796,241704260204,241598819812,241646287575,241654580406,241664691213,241622436673,241646307072,241618233031,241714991532,241622593939,241729500019,241731231321,230043580516,241616298599,241679919702,241680483551,241703553838,241629320511,241729516888,241728536074,241689137784,241608698902,241673337185,241689024160,241622537188,241695484061,241622435663,241664813447,241704666584,241729497492,241659742638,241676761628', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 09:03:15 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40089, 413, '270911028503111299,216943715062,229690462428,229745117492,229726647182,229806022539,229813488990,229726514465,229670077284,229925527882,229668615155,229933850918,229805688588,229740301737,229812312749,229807371324,229805220306,229786702236,229669619608,229810965456,229865948588,229690956370,229687901718,229661312535,229836978185,229738491515,229742912025,229672811121,229747436585,216944572733,229864991818,229754807798', '246468617388,246123348899,246539908397,246506499806,246581715968,246627000209,246520474649,246514461515,226404758697,246517022528,246003345067,246581936472,246526698387,246627976880,246581378506,246598464449,246596243043,246470040828,246639725569,246652592942,246513878898,246513910115,246467969211,246640621022,246529286575,246558726676,246492149214,246548282122,246462745053,246649823749,246572080315', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-03 09:28:12 Database: contagem User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 30s868ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-03 10:35:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s444ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40202, 407, '834150922002180,241604720512$835162924005739,241689117782$834150922002564,241604758797$834257937001636,241628279309$835016903002566,241649717798', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""}]','$$$$','', 00);[ Date: 2026-06-03 09:03:15 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,695 Total read queries
- 1,583 Total write queries
Queries by database
Key values
- rio Main database
- 5,166 Requests
- 6h58m13s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,469 Requests
User Request type Count Duration etiquetas Total 4 680ms select 4 680ms intelifix Total 6,469 7h17m46s copy to 268 33m45s ddl 1,315 41m12s others 284 29m9s select 4,602 5h33m39s lenon Total 89 42s843ms select 89 42s843ms Duration by user
Key values
- 7h17m46s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 4 680ms select 4 680ms intelifix Total 6,469 7h17m46s copy to 268 33m45s ddl 1,315 41m12s others 284 29m9s select 4,602 5h33m39s lenon Total 89 42s843ms select 89 42s843ms Queries by host
Key values
- [local] Main host
- 6,562 Requests
- 7h18m29s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,837 Requests
- 4h24m32s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-03 10:45:06 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,058 100-500ms duration
Slowest individual queries
Rank Duration Query 1 46m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0248997,0) ;', '/var/www/html/tmp/temp_94.xlsx');[ Date: 2026-06-03 16:44:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 43m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0249092,0) ;', '/var/www/html/tmp/temp_94.xlsx');[ Date: 2026-06-03 17:46:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 8m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 10:13:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m54s analyze verbose;[ Date: 2026-06-03 05:07:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 07:12:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 15:11:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 14:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 11:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 16:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 12:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 17:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 09:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 08:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 20:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 13:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 18:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 22:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 19:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-03 21:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 4m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025106, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-03 07:11:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3h3m17s 216 150ms 46m36s 50s914ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 03 07 16 15m57s 59s843ms 08 15 4m 16s27ms 09 12 4m36s 23s76ms 10 22 9m48s 26s734ms 11 28 9m8s 19s571ms 12 5 7m26s 1m29s 13 29 2m3s 4s273ms 14 31 16m50s 32s605ms 15 31 11m30s 22s282ms 16 19 55m2s 2m53s 17 8 46m51s 5m51s [ User: intelifix - Total duration: 3h3m17s - Times executed: 216 ]
[ Application: [unknown] - Total duration: 3h3m17s - Times executed: 216 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0248997,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 16:44:54 Duration: 46m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0249092,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 17:46:21 Duration: 43m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025106, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-03 07:11:23 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h37m11s 32 931ms 8m13s 3m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 03 07 2 7m43s 3m51s 08 2 5m56s 2m58s 09 2 5m59s 2m59s 10 2 8m21s 4m10s 11 2 6m25s 3m12s 12 2 6m4s 3m2s 13 2 5m29s 2m44s 14 2 6m22s 3m11s 15 2 6m30s 3m15s 16 2 6m13s 3m6s 17 2 6m2s 3m1s 18 2 5m10s 2m35s 19 2 5m4s 2m32s 20 2 5m39s 2m49s 21 2 5m1s 2m30s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h37m11s - Times executed: 32 ]
[ Application: psql - Total duration: 1h37m11s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-03 10:13:14 Duration: 8m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-03 07:12:42 Duration: 7m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-03 15:11:30 Duration: 6m28s Database: rio User: intelifix Remote: [local] Application: psql
3 18m45s 1,662 150ms 4s659ms 677ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 03 07 16 17s285ms 1s80ms 08 105 1m13s 701ms 09 213 2m47s 784ms 10 171 1m46s 620ms 11 207 2m16s 660ms 12 69 45s619ms 661ms 13 140 1m36s 688ms 14 304 3m6s 614ms 15 242 2m20s 578ms 16 168 1m51s 661ms 17 27 45s55ms 1s668ms [ User: intelifix - Total duration: 18m45s - Times executed: 1662 ]
[ Application: [unknown] - Total duration: 18m45s - Times executed: 1662 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248820, 450, 'F200012004B1212,84011295ACF1$F200012236B05C4,1834AF275758$F200011008B005C,9877E70765A1$F20001020613C6F,743AEF70B1EC$F200010209B8829,743AEF712836$F200011081B1884,9877E74B1B76$F200011081BA8F5,9877E74B5AA7$F200010318B0C99,743AEFD95A24$F200012005B5BC6,840112961CF8$F200010266B3F72,743AEF9B00DD$F200011148B3A84,9877E7BC1760$F200011081B05C1,9877E74B1342$F200011291B2E87,8401125FFFBB$F200011301B1135,8401127FBD08$F200010209B7500,743AEF711FD8', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 11:07:33 Duration: 4s659ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40131, 413, '834066910000557,230048419809,241637607278,241732173747,241618234445,241672704969,241605375053,241700946378,241715043557,241713368499,241677396268,241729498301,241704667796,241704260204,241598819812,241646287575,241654580406,241664691213,241622436673,241646307072,241618233031,241714991532,241622593939,241729500019,241731231321,230043580516,241616298599,241679919702,241680483551,241703553838,241629320511,241729516888,241728536074,241689137784,241608698902,241673337185,241689024160,241622537188,241695484061,241622435663,241664813447,241704666584,241729497492,241659742638,241676761628', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 09:03:15 Duration: 3s914ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40089, 413, '270911028503111299,216943715062,229690462428,229745117492,229726647182,229806022539,229813488990,229726514465,229670077284,229925527882,229668615155,229933850918,229805688588,229740301737,229812312749,229807371324,229805220306,229786702236,229669619608,229810965456,229865948588,229690956370,229687901718,229661312535,229836978185,229738491515,229742912025,229672811121,229747436585,216944572733,229864991818,229754807798', '246468617388,246123348899,246539908397,246506499806,246581715968,246627000209,246520474649,246514461515,226404758697,246517022528,246003345067,246581936472,246526698387,246627976880,246581378506,246598464449,246596243043,246470040828,246639725569,246652592942,246513878898,246513910115,246467969211,246640621022,246529286575,246558726676,246492149214,246548282122,246462745053,246649823749,246572080315', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-03 09:28:12 Duration: 3s723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 16m22s 100 7s876ms 30s330ms 9s829ms create table temp0000281577 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 03 07 20 3m27s 10s391ms 08 6 52s906ms 8s817ms 09 7 1m9s 9s986ms 10 9 1m27s 9s723ms 11 10 1m39s 9s944ms 12 9 1m25s 9s546ms 14 18 3m 10s26ms 15 17 2m41s 9s502ms 16 4 37s455ms 9s363ms [ User: intelifix - Total duration: 16m22s - Times executed: 100 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 100 ]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 07:04:55 Duration: 30s330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:30:54 Duration: 12s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:27:51 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 10m7s 2 2m12s 7m54s 5m3s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 03 05 2 10m7s 5m3s [ User: intelifix - Total duration: 10m7s - Times executed: 2 ]
[ Application: psql - Total duration: 10m7s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-03 05:07:56 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-03 05:10:08 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
6 9m26s 32 414ms 1m 17s718ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 03 07 2 1m 30s82ms 08 2 28s782ms 14s391ms 09 2 28s912ms 14s456ms 10 2 1m3s 31s537ms 11 2 34s693ms 17s346ms 12 2 30s773ms 15s386ms 13 2 28s871ms 14s435ms 14 2 38s517ms 19s258ms 15 2 31s180ms 15s590ms 16 2 39s716ms 19s858ms 17 2 38s625ms 19s312ms 18 2 28s623ms 14s311ms 19 2 27s427ms 13s713ms 20 2 35s323ms 17s661ms 21 2 25s639ms 12s819ms 22 2 26s649ms 13s324ms [ User: intelifix - Total duration: 9m26s - Times executed: 32 ]
[ Application: psql - Total duration: 9m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-03 10:14:15 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-03 07:13:40 Duration: 58s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-03 16:11:48 Duration: 38s338ms Database: rio User: intelifix Remote: [local] Application: psql
7 8m37s 138 2s659ms 35s113ms 3s746ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 03 00 6 27s287ms 4s547ms 01 6 19s27ms 3s171ms 02 6 19s443ms 3s240ms 03 6 19s864ms 3s310ms 04 6 19s495ms 3s249ms 05 6 20s981ms 3s496ms 06 6 20s553ms 3s425ms 07 6 21s256ms 3s542ms 08 6 20s953ms 3s492ms 09 6 20s410ms 3s401ms 10 6 54s49ms 9s8ms 11 6 23s301ms 3s883ms 12 6 19s423ms 3s237ms 13 6 22s368ms 3s728ms 14 6 24s533ms 4s88ms 15 6 23s152ms 3s858ms 16 6 19s492ms 3s248ms 17 6 22s789ms 3s798ms 18 6 20s593ms 3s432ms 19 6 18s390ms 3s65ms 20 6 22s188ms 3s698ms 21 6 19s354ms 3s225ms 22 6 18s155ms 3s25ms [ User: intelifix - Total duration: 8m37s - Times executed: 138 ]
[ Application: psql - Total duration: 8m37s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 10:35:39 Duration: 35s113ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 00:05:22 Duration: 11s402ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 17:15:07 Duration: 6s807ms Database: rio User: intelifix Remote: [local] Application: psql
8 7m43s 1,073 150ms 2s222ms 431ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 03 07 39 18s989ms 486ms 08 132 1m 457ms 09 124 1m4s 521ms 10 129 52s187ms 404ms 11 126 54s205ms 430ms 12 1 598ms 598ms 13 108 49s57ms 454ms 14 153 1m4s 418ms 15 138 55s178ms 399ms 16 120 42s645ms 355ms 17 3 1s202ms 400ms [ User: intelifix - Total duration: 7m43s - Times executed: 1073 ]
[ Application: [unknown] - Total duration: 7m43s - Times executed: 1073 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "248621", "modelo" : "320", "itens" : "241653977888,241619737790,241637573134,241709642839,241645557998,241637569294,241679413536,241666135562,241679570017,241667123145,241663331720,241679603555,241716627190,241666044263,241604242732,241662959607,241651752947,241614857381,241634749413,241682555268,241651968905,241709684257,241706999719,241651455970,241645592828,241651109517,241693226062,241651321233,241698310409,241694301432,241645588911,241669078688,241699444649,241632223151,241666276586,241645559009,241629349199,241657192636,241595212547,241677538909,241594034463,241651083858,241603253253,241690018689,241702789510,241629914766,241669657892,241627961220", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-03 08:02:48 Duration: 2s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "248298", "modelo" : "320", "itens" : "241703627178,241658049598,241689321619,230040072732,241601677879,241653892224,241617910924,241706562729,241601054250,241694330627,241637716784,241596674956,241670244549,241655283235,241694381013,241651469608,241665722537,241712096871,241712663145,241666828895,835119918004731,835015903003142,241647194062,241652847486,241596174851,835037906000389,835212931004028,835225933004601,835233934003480,834200929001077,835196929002814,835211931000883,834275940000326,835177926001469,835140921001282,835156923005989,241703636977,835100915000982,834240935000002,834051908002267,834269939001651,834319946001787,835106916002367,835043907001924,835015903001990,241639184346,835252937000319,241677784365", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-03 07:41:02 Duration: 2s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "141", "itens" : "229781864255,229859276871,229810605062,216932119800,229663222037,229816262932,229809817880,229808037987,229663640417,216937123050,229816823851,229865345567,229690456972,229747087785,229665571840,229663656680,229664424971,229746294768,229664042734,229884605460", "usuario" : "405", "caixa" : "1241122", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-03 09:19:55 Duration: 2s51ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 5m45s 93 218ms 9s946ms 3s713ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 03 00 5 15s108ms 3s21ms 01 6 7s70ms 1s178ms 02 4 6s134ms 1s533ms 03 4 6s534ms 1s633ms 04 6 8s773ms 1s462ms 05 5 8s258ms 1s651ms 07 6 33s188ms 5s531ms 08 6 33s576ms 5s596ms 09 6 35s963ms 5s993ms 10 6 33s644ms 5s607ms 11 6 38s425ms 6s404ms 12 6 30s143ms 5s23ms 13 1 2s402ms 2s402ms 14 6 26s91ms 4s348ms 15 6 37s777ms 6s296ms 16 4 8s515ms 2s128ms 21 4 5s571ms 1s392ms 22 6 8s175ms 1s362ms [ User: intelifix - Total duration: 5m45s - Times executed: 93 ]
[ Application: psql - Total duration: 5m45s - Times executed: 93 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 00:05:11 Duration: 9s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 09:45:10 Duration: 9s19ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 11:05:10 Duration: 8s962ms Database: rio User: intelifix Remote: [local] Application: psql
10 3m49s 22 5s125ms 16s45ms 10s425ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 03 09 5 43s399ms 8s679ms 10 2 18s413ms 9s206ms 11 1 7s85ms 7s85ms 13 3 28s43ms 9s347ms 14 2 19s803ms 9s901ms 15 2 18s848ms 9s424ms 16 5 1m3s 12s609ms 17 2 30s727ms 15s363ms [ User: intelifix - Total duration: 3m49s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 3m49s - Times executed: 22 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-03', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-03 17:08:27 Duration: 16s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-03', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-03 17:12:35 Duration: 14s682ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-03', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-03 16:59:48 Duration: 14s435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 3m46s 45 752ms 18s354ms 5s39ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 03 08 3 19s390ms 6s463ms 09 3 18s686ms 6s228ms 10 3 20s987ms 6s995ms 11 3 18s259ms 6s86ms 12 3 12s112ms 4s37ms 13 3 10s928ms 3s642ms 14 3 29s812ms 9s937ms 15 3 29s326ms 9s775ms 16 3 30s968ms 10s322ms 17 3 21s216ms 7s72ms 18 3 2s966ms 988ms 19 3 3s455ms 1s151ms 20 3 2s894ms 964ms 21 3 2s749ms 916ms 22 3 3s21ms 1s7ms [ User: intelifix - Total duration: 3m46s - Times executed: 45 ]
[ Application: psql - Total duration: 3m46s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-03 17:00:19 Duration: 18s354ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-03 14:20:18 Duration: 17s241ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-03 16:20:17 Duration: 16s543ms Database: rio User: intelifix Remote: [local] Application: psql
12 3m6s 40 3s316ms 13s663ms 4s667ms create table temp0000281577 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 03 07 8 29s965ms 3s745ms 08 2 7s819ms 3s909ms 09 2 8s963ms 4s481ms 11 6 25s344ms 4s224ms 12 5 21s730ms 4s346ms 14 4 20s911ms 5s227ms 15 11 52s288ms 4s753ms 16 2 19s658ms 9s829ms [ User: intelifix - Total duration: 3m6s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 40 ]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:31:50 Duration: 13s663ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:32:06 Duration: 5s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 15:43:15 Duration: 5s821ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m46s 55 202ms 59s102ms 3s27ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 03 07 8 3s131ms 391ms 08 6 52s372ms 8s728ms 09 4 18s949ms 4s737ms 10 5 1m 12s139ms 11 5 8s194ms 1s638ms 12 3 962ms 320ms 13 1 1s419ms 1s419ms 14 8 4s886ms 610ms 15 6 2s420ms 403ms 16 6 9s811ms 1s635ms 17 3 3s645ms 1s215ms [ User: intelifix - Total duration: 2m46s - Times executed: 55 ]
[ Application: psql - Total duration: 2m46s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025127);
Date: 2026-06-03 10:43:48 Duration: 59s102ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025115);
Date: 2026-06-03 08:31:25 Duration: 41s258ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025119);
Date: 2026-06-03 09:05:04 Duration: 17s25ms Database: rio User: intelifix Remote: [local] Application: psql
14 2m40s 2 1m19s 1m20s 1m20s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 03 20 1 1m19s 1m19s 23 1 1m20s 1m20s [ User: intelifix - Total duration: 2m40s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m40s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-03 23:34:52 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-03 20:08:02 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
15 2m39s 125 160ms 18s293ms 1s275ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 03 07 8 8s46ms 1s5ms 08 7 13s378ms 1s911ms 09 5 4s485ms 897ms 10 17 14s899ms 876ms 11 22 8s125ms 369ms 13 24 1m1s 2s568ms 14 10 5s462ms 546ms 15 27 41s401ms 1s533ms 16 5 2s24ms 404ms [ User: intelifix - Total duration: 2m39s - Times executed: 125 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 125 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (015395) LIMIT 1;
Date: 2026-06-03 13:57:55 Duration: 18s293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (036882) LIMIT 1;
Date: 2026-06-03 13:38:03 Duration: 10s888ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (036882) LIMIT 1;
Date: 2026-06-03 15:40:58 Duration: 9s779ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 2m39s 18 8s32ms 10s74ms 8s847ms create table temp0000281693 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 03 16 10 1m29s 8s975ms 17 8 1m9s 8s687ms [ User: intelifix - Total duration: 2m39s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 18 ]
-
CREATE TABLE temp0000281693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 16:09:30 Duration: 10s74ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 16:55:19 Duration: 9s650ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 16:09:57 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m15s 14 8s656ms 11s422ms 9s665ms create table temp0000281617 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 03 08 6 56s261ms 9s376ms 09 8 1m19s 9s881ms [ User: intelifix - Total duration: 2m15s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m15s - Times executed: 14 ]
-
CREATE TABLE temp0000281617 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:13:51 Duration: 11s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281617 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:06:32 Duration: 11s240ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281617 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 08:32:14 Duration: 10s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m14s 13 8s492ms 12s117ms 10s356ms create table temp0000281673 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 03 13 3 32s29ms 10s676ms 14 10 1m42s 10s260ms [ User: intelifix - Total duration: 2m14s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 13 ]
-
CREATE TABLE temp0000281673 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 14:12:12 Duration: 12s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281673 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 14:02:22 Duration: 11s193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281673 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 13:38:42 Duration: 11s174ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m45s 378 150ms 1s93ms 280ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 03 07 153 42s42ms 274ms 08 8 1s846ms 230ms 09 51 13s297ms 260ms 10 50 12s771ms 255ms 13 42 13s85ms 311ms 15 21 8s21ms 381ms 17 53 14s919ms 281ms [ User: intelifix - Total duration: 1m45s - Times executed: 378 ]
[ Application: [unknown] - Total duration: 1m45s - Times executed: 378 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"37951","seriais":"3CF9F0AC5262,C4EBFF8E1244,F4E84F870170,C4EBFF8F154C,5872C991AA35,D83139936BCC,D83139936AAC,3891484F7491,C4EBFF8F07F0,C4EBFF8B1130,843C992EB2E7,D89A0DB0A5DD,843C99220205,843C992F14A3,3891484A4C07,F4E84F86FA98,14CA56CE52D7,843C9935C17D,6C11BA6F056D,D89A0DAA3E63,C4EBFF890604,D89A0DABF397,5872C98B0403,3CF9F0ADF3A4,6C11BA6ED7A1,3891484F6E25,3CF9F0A9F36C,D89A0DAC89BB,3CF9F0AC4A0A","usuario":"409","observacao":""}');
Date: 2026-06-03 13:25:15 Duration: 1s93ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"36882","seriais":"226156202544,","usuario":"409","observacao":""}');
Date: 2026-06-03 15:23:45 Duration: 900ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"39963","seriais":"A8705D830CDD,","usuario":"409","observacao":""}');
Date: 2026-06-03 15:09:49 Duration: 855ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 1m42s 2 46s132ms 56s558ms 51s345ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 03 20 1 56s558ms 56s558ms 23 1 46s132ms 46s132ms [ User: intelifix - Total duration: 1m42s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m42s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-03 20:05:15 Duration: 56s558ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-03 23:16:54 Duration: 46s132ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,662 18m45s 150ms 4s659ms 677ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 03 07 16 17s285ms 1s80ms 08 105 1m13s 701ms 09 213 2m47s 784ms 10 171 1m46s 620ms 11 207 2m16s 660ms 12 69 45s619ms 661ms 13 140 1m36s 688ms 14 304 3m6s 614ms 15 242 2m20s 578ms 16 168 1m51s 661ms 17 27 45s55ms 1s668ms [ User: intelifix - Total duration: 18m45s - Times executed: 1662 ]
[ Application: [unknown] - Total duration: 18m45s - Times executed: 1662 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248820, 450, 'F200012004B1212,84011295ACF1$F200012236B05C4,1834AF275758$F200011008B005C,9877E70765A1$F20001020613C6F,743AEF70B1EC$F200010209B8829,743AEF712836$F200011081B1884,9877E74B1B76$F200011081BA8F5,9877E74B5AA7$F200010318B0C99,743AEFD95A24$F200012005B5BC6,840112961CF8$F200010266B3F72,743AEF9B00DD$F200011148B3A84,9877E7BC1760$F200011081B05C1,9877E74B1342$F200011291B2E87,8401125FFFBB$F200011301B1135,8401127FBD08$F200010209B7500,743AEF711FD8', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 11:07:33 Duration: 4s659ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40131, 413, '834066910000557,230048419809,241637607278,241732173747,241618234445,241672704969,241605375053,241700946378,241715043557,241713368499,241677396268,241729498301,241704667796,241704260204,241598819812,241646287575,241654580406,241664691213,241622436673,241646307072,241618233031,241714991532,241622593939,241729500019,241731231321,230043580516,241616298599,241679919702,241680483551,241703553838,241629320511,241729516888,241728536074,241689137784,241608698902,241673337185,241689024160,241622537188,241695484061,241622435663,241664813447,241704666584,241729497492,241659742638,241676761628', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 09:03:15 Duration: 3s914ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40089, 413, '270911028503111299,216943715062,229690462428,229745117492,229726647182,229806022539,229813488990,229726514465,229670077284,229925527882,229668615155,229933850918,229805688588,229740301737,229812312749,229807371324,229805220306,229786702236,229669619608,229810965456,229865948588,229690956370,229687901718,229661312535,229836978185,229738491515,229742912025,229672811121,229747436585,216944572733,229864991818,229754807798', '246468617388,246123348899,246539908397,246506499806,246581715968,246627000209,246520474649,246514461515,226404758697,246517022528,246003345067,246581936472,246526698387,246627976880,246581378506,246598464449,246596243043,246470040828,246639725569,246652592942,246513878898,246513910115,246467969211,246640621022,246529286575,246558726676,246492149214,246548282122,246462745053,246649823749,246572080315', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-03 09:28:12 Duration: 3s723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,073 7m43s 150ms 2s222ms 431ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 03 07 39 18s989ms 486ms 08 132 1m 457ms 09 124 1m4s 521ms 10 129 52s187ms 404ms 11 126 54s205ms 430ms 12 1 598ms 598ms 13 108 49s57ms 454ms 14 153 1m4s 418ms 15 138 55s178ms 399ms 16 120 42s645ms 355ms 17 3 1s202ms 400ms [ User: intelifix - Total duration: 7m43s - Times executed: 1073 ]
[ Application: [unknown] - Total duration: 7m43s - Times executed: 1073 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "248621", "modelo" : "320", "itens" : "241653977888,241619737790,241637573134,241709642839,241645557998,241637569294,241679413536,241666135562,241679570017,241667123145,241663331720,241679603555,241716627190,241666044263,241604242732,241662959607,241651752947,241614857381,241634749413,241682555268,241651968905,241709684257,241706999719,241651455970,241645592828,241651109517,241693226062,241651321233,241698310409,241694301432,241645588911,241669078688,241699444649,241632223151,241666276586,241645559009,241629349199,241657192636,241595212547,241677538909,241594034463,241651083858,241603253253,241690018689,241702789510,241629914766,241669657892,241627961220", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-03 08:02:48 Duration: 2s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "248298", "modelo" : "320", "itens" : "241703627178,241658049598,241689321619,230040072732,241601677879,241653892224,241617910924,241706562729,241601054250,241694330627,241637716784,241596674956,241670244549,241655283235,241694381013,241651469608,241665722537,241712096871,241712663145,241666828895,835119918004731,835015903003142,241647194062,241652847486,241596174851,835037906000389,835212931004028,835225933004601,835233934003480,834200929001077,835196929002814,835211931000883,834275940000326,835177926001469,835140921001282,835156923005989,241703636977,835100915000982,834240935000002,834051908002267,834269939001651,834319946001787,835106916002367,835043907001924,835015903001990,241639184346,835252937000319,241677784365", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-03 07:41:02 Duration: 2s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "141", "itens" : "229781864255,229859276871,229810605062,216932119800,229663222037,229816262932,229809817880,229808037987,229663640417,216937123050,229816823851,229865345567,229690456972,229747087785,229665571840,229663656680,229664424971,229746294768,229664042734,229884605460", "usuario" : "405", "caixa" : "1241122", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-03 09:19:55 Duration: 2s51ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 378 1m45s 150ms 1s93ms 280ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 03 07 153 42s42ms 274ms 08 8 1s846ms 230ms 09 51 13s297ms 260ms 10 50 12s771ms 255ms 13 42 13s85ms 311ms 15 21 8s21ms 381ms 17 53 14s919ms 281ms [ User: intelifix - Total duration: 1m45s - Times executed: 378 ]
[ Application: [unknown] - Total duration: 1m45s - Times executed: 378 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"37951","seriais":"3CF9F0AC5262,C4EBFF8E1244,F4E84F870170,C4EBFF8F154C,5872C991AA35,D83139936BCC,D83139936AAC,3891484F7491,C4EBFF8F07F0,C4EBFF8B1130,843C992EB2E7,D89A0DB0A5DD,843C99220205,843C992F14A3,3891484A4C07,F4E84F86FA98,14CA56CE52D7,843C9935C17D,6C11BA6F056D,D89A0DAA3E63,C4EBFF890604,D89A0DABF397,5872C98B0403,3CF9F0ADF3A4,6C11BA6ED7A1,3891484F6E25,3CF9F0A9F36C,D89A0DAC89BB,3CF9F0AC4A0A","usuario":"409","observacao":""}');
Date: 2026-06-03 13:25:15 Duration: 1s93ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"36882","seriais":"226156202544,","usuario":"409","observacao":""}');
Date: 2026-06-03 15:23:45 Duration: 900ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"39963","seriais":"A8705D830CDD,","usuario":"409","observacao":""}');
Date: 2026-06-03 15:09:49 Duration: 855ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 216 3h3m17s 150ms 46m36s 50s914ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 03 07 16 15m57s 59s843ms 08 15 4m 16s27ms 09 12 4m36s 23s76ms 10 22 9m48s 26s734ms 11 28 9m8s 19s571ms 12 5 7m26s 1m29s 13 29 2m3s 4s273ms 14 31 16m50s 32s605ms 15 31 11m30s 22s282ms 16 19 55m2s 2m53s 17 8 46m51s 5m51s [ User: intelifix - Total duration: 3h3m17s - Times executed: 216 ]
[ Application: [unknown] - Total duration: 3h3m17s - Times executed: 216 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0248997,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 16:44:54 Duration: 46m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0249092,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 17:46:21 Duration: 43m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025106, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-03 07:11:23 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 153 27s779ms 150ms 463ms 181ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 03 00 1 155ms 155ms 07 3 1s27ms 342ms 10 2 406ms 203ms 11 5 812ms 162ms 12 2 344ms 172ms 13 9 1s582ms 175ms 14 32 6s57ms 189ms 15 34 5s728ms 168ms 16 54 9s639ms 178ms 17 11 2s25ms 184ms [ User: intelifix - Total duration: 27s779ms - Times executed: 153 ]
[ Application: [unknown] - Total duration: 27s779ms - Times executed: 153 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-02", "data-ate" : "2026-06-02", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-03 07:55:00 Duration: 463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-06-02", "data-ate" : "2026-06-02", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-03 07:55:24 Duration: 412ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-06-03", "data-ate" : "2026-06-03", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-06-03 14:48:10 Duration: 380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 138 8m37s 2s659ms 35s113ms 3s746ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 03 00 6 27s287ms 4s547ms 01 6 19s27ms 3s171ms 02 6 19s443ms 3s240ms 03 6 19s864ms 3s310ms 04 6 19s495ms 3s249ms 05 6 20s981ms 3s496ms 06 6 20s553ms 3s425ms 07 6 21s256ms 3s542ms 08 6 20s953ms 3s492ms 09 6 20s410ms 3s401ms 10 6 54s49ms 9s8ms 11 6 23s301ms 3s883ms 12 6 19s423ms 3s237ms 13 6 22s368ms 3s728ms 14 6 24s533ms 4s88ms 15 6 23s152ms 3s858ms 16 6 19s492ms 3s248ms 17 6 22s789ms 3s798ms 18 6 20s593ms 3s432ms 19 6 18s390ms 3s65ms 20 6 22s188ms 3s698ms 21 6 19s354ms 3s225ms 22 6 18s155ms 3s25ms [ User: intelifix - Total duration: 8m37s - Times executed: 138 ]
[ Application: psql - Total duration: 8m37s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 10:35:39 Duration: 35s113ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 00:05:22 Duration: 11s402ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 17:15:07 Duration: 6s807ms Database: rio User: intelifix Remote: [local] Application: psql
7 131 21s347ms 150ms 208ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 03 00 1 155ms 155ms 07 3 493ms 164ms 08 12 1s928ms 160ms 09 21 3s438ms 163ms 10 14 2s277ms 162ms 11 17 2s755ms 162ms 12 5 838ms 167ms 13 20 3s209ms 160ms 14 19 3s104ms 163ms 15 7 1s151ms 164ms 16 8 1s351ms 168ms 17 4 640ms 160ms [ User: intelifix - Total duration: 21s347ms - Times executed: 131 ]
[ Application: [unknown] - Total duration: 21s347ms - Times executed: 131 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-06-03 16:00:14 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0302;
Date: 2026-06-03 09:30:55 Duration: 197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-03 09:52:45 Duration: 192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 125 2m39s 160ms 18s293ms 1s275ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 03 07 8 8s46ms 1s5ms 08 7 13s378ms 1s911ms 09 5 4s485ms 897ms 10 17 14s899ms 876ms 11 22 8s125ms 369ms 13 24 1m1s 2s568ms 14 10 5s462ms 546ms 15 27 41s401ms 1s533ms 16 5 2s24ms 404ms [ User: intelifix - Total duration: 2m39s - Times executed: 125 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 125 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (015395) LIMIT 1;
Date: 2026-06-03 13:57:55 Duration: 18s293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (036882) LIMIT 1;
Date: 2026-06-03 13:38:03 Duration: 10s888ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (036882) LIMIT 1;
Date: 2026-06-03 15:40:58 Duration: 9s779ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 111 21s223ms 150ms 367ms 191ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 03 00 2 354ms 177ms 04 24 4s512ms 188ms 05 2 367ms 183ms 07 14 2s602ms 185ms 08 8 1s567ms 195ms 09 13 2s613ms 201ms 10 6 1s221ms 203ms 11 10 1s779ms 177ms 12 9 1s633ms 181ms 14 6 1s89ms 181ms 15 10 1s802ms 180ms 16 7 1s679ms 239ms [ User: intelifix - Total duration: 21s223ms - Times executed: 111 ]
[ Application: [unknown] - Total duration: 21s223ms - Times executed: 111 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'B85E71C5B5FC,C4509CAC42A4,C4509CE88E3C,80DAC2CDC8CC,B85E71BA8E84,B85E710E297C,B85E71D9EB80,484BD4B5A414,C4509CE8ADD4,E4BFFAEFDF5C,B85E71D3C458,E4BFFAEFD89C,F8D2AC13CE54,B85E71E6341C,C4509CE89334,B85E71CFD528,B85E71D0AD54,08A7C0706D54,B85E71EDE608,08A7C078455C,400FC17F8D64,B85E71D9C858,4075C3B91A80,B85E71CD5DFC,08A7C04B4C5C,ECA81FF60744,C4509CEA4ED4,B85E71EDE270,80DAC2CC9DF8,484BD496C05C,B85E71C78044', NULL, NULL, 0185, 00);
Date: 2026-06-03 16:00:16 Duration: 367ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '80DAC2D0A394,80DAC2CBFF88,CCF3C8489B3C,E4BFFAF7448C,CCF3C8468B0C,B85E71EECA50,1C9ECCF2D264,400FC17F1CE4,E4BFFAF36D04,4075C3996938,08A7C051CA2C,B85E71EF2068,484BD4967514,1C9D726A72CC,E4BFFAF94EBC,8C6A8DBF841C,B85E71D13EB8,484BD4998E34,80DAC2D03CEC,C4509CAEF66C,3C82C0C78FAC,F8D2AC4CF270,F8D2AC4CFCC0,B85E71BD095C', NULL, NULL, 0185, 00);
Date: 2026-06-03 16:35:29 Duration: 335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '216851353759,216845066579,216682275473,216895668599,216730406971,216885772337,216683950104,216880741128,216621106484,216624207179,216648066163', NULL, NULL, 064, 00);
Date: 2026-06-03 08:10:03 Duration: 306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 109 22s782ms 150ms 1s191ms 209ms create table temp0000226330 as select * from rs_caixas_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 03 10 45 9s315ms 207ms 13 52 11s321ms 217ms 15 12 2s145ms 178ms [ User: intelifix - Total duration: 22s782ms - Times executed: 109 ]
[ Application: [unknown] - Total duration: 22s782ms - Times executed: 109 ]
-
CREATE TABLE temp0000226330 AS SELECT * FROM RS_CAIXAS_LISTA (37949);
Date: 2026-06-03 10:09:03 Duration: 1s191ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226330 AS SELECT * FROM RS_CAIXAS_LISTA (37951);
Date: 2026-06-03 13:25:37 Duration: 319ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226330 AS SELECT * FROM RS_CAIXAS_LISTA (37951);
Date: 2026-06-03 13:34:17 Duration: 292ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 100 16m22s 7s876ms 30s330ms 9s829ms create table temp0000281577 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 03 07 20 3m27s 10s391ms 08 6 52s906ms 8s817ms 09 7 1m9s 9s986ms 10 9 1m27s 9s723ms 11 10 1m39s 9s944ms 12 9 1m25s 9s546ms 14 18 3m 10s26ms 15 17 2m41s 9s502ms 16 4 37s455ms 9s363ms [ User: intelifix - Total duration: 16m22s - Times executed: 100 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 100 ]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 07:04:55 Duration: 30s330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:30:54 Duration: 12s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:27:51 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 96 27s293ms 162ms 3s862ms 284ms create table temp0000281613 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 03 08 3 4s305ms 1s435ms 09 9 2s952ms 328ms 10 6 1s679ms 279ms 11 9 1s894ms 210ms 12 8 1s590ms 198ms 13 15 3s193ms 212ms 14 18 4s157ms 230ms 15 12 3s31ms 252ms 16 15 4s216ms 281ms 17 1 272ms 272ms [ User: intelifix - Total duration: 27s293ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 27s293ms - Times executed: 96 ]
-
CREATE TABLE temp0000281613 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 08:16:10 Duration: 3s862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281613 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1507", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 09:54:38 Duration: 493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281613 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1507", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 10:10:06 Duration: 451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 93 5m45s 218ms 9s946ms 3s713ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 03 00 5 15s108ms 3s21ms 01 6 7s70ms 1s178ms 02 4 6s134ms 1s533ms 03 4 6s534ms 1s633ms 04 6 8s773ms 1s462ms 05 5 8s258ms 1s651ms 07 6 33s188ms 5s531ms 08 6 33s576ms 5s596ms 09 6 35s963ms 5s993ms 10 6 33s644ms 5s607ms 11 6 38s425ms 6s404ms 12 6 30s143ms 5s23ms 13 1 2s402ms 2s402ms 14 6 26s91ms 4s348ms 15 6 37s777ms 6s296ms 16 4 8s515ms 2s128ms 21 4 5s571ms 1s392ms 22 6 8s175ms 1s362ms [ User: intelifix - Total duration: 5m45s - Times executed: 93 ]
[ Application: psql - Total duration: 5m45s - Times executed: 93 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 00:05:11 Duration: 9s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 09:45:10 Duration: 9s19ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 11:05:10 Duration: 8s962ms Database: rio User: intelifix Remote: [local] Application: psql
14 91 16s371ms 150ms 321ms 179ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 03 07 4 961ms 240ms 08 6 1s72ms 178ms 09 17 2s892ms 170ms 10 9 1s466ms 162ms 11 11 1s998ms 181ms 12 2 375ms 187ms 13 9 1s501ms 166ms 14 8 1s540ms 192ms 15 20 3s614ms 180ms 16 2 427ms 213ms 17 3 520ms 173ms [ User: intelifix - Total duration: 16s371ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 16s371ms - Times executed: 91 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"320", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-03 07:11:40 Duration: 321ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"126", "usuario" :"320", "tipo" :"N", "itens" :"005", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-03 11:10:46 Duration: 298ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"320", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-03 14:58:08 Duration: 254ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 85 37s682ms 261ms 774ms 443ms 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 #15
Day Hour Count Duration Avg duration Jun 03 00 2 771ms 385ms 04 2 719ms 359ms 05 1 386ms 386ms 06 2 740ms 370ms 07 6 2s680ms 446ms 08 8 3s374ms 421ms 09 7 2s717ms 388ms 10 8 3s421ms 427ms 11 8 4s480ms 560ms 12 5 2s89ms 417ms 13 8 3s570ms 446ms 14 8 4s111ms 513ms 15 8 3s771ms 471ms 16 7 3s2ms 428ms 17 3 1s120ms 373ms 21 2 721ms 360ms [ User: lenon - Total duration: 37s682ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 37s682ms - Times executed: 85 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-03 14:24:40 Duration: 774ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-03 11:06:27 Duration: 751ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-03 15:09:39 Duration: 750ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
16 82 28s453ms 160ms 3s726ms 346ms create table temp0000281479 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 03 07 2 7s269ms 3s634ms 08 10 2s61ms 206ms 09 9 2s8ms 223ms 10 8 2s145ms 268ms 11 12 3s356ms 279ms 12 8 2s475ms 309ms 14 13 3s910ms 300ms 15 9 2s77ms 230ms 16 10 2s883ms 288ms 17 1 263ms 263ms [ User: intelifix - Total duration: 28s453ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 28s453ms - Times executed: 82 ]
-
CREATE TABLE temp0000281479 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 07:53:52 Duration: 3s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281479 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 07:53:23 Duration: 3s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281479 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1065299", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:29:05 Duration: 516ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 81 44s470ms 332ms 846ms 549ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 03 00 2 1s262ms 631ms 04 2 992ms 496ms 05 1 452ms 452ms 06 1 483ms 483ms 07 5 2s788ms 557ms 08 8 4s125ms 515ms 09 7 3s524ms 503ms 10 8 4s288ms 536ms 11 8 5s230ms 653ms 12 5 2s544ms 508ms 13 7 3s724ms 532ms 14 8 4s880ms 610ms 15 8 4s479ms 559ms 16 7 3s848ms 549ms 17 3 1s387ms 462ms 21 1 456ms 456ms [ User: intelifix - Total duration: 44s470ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 44s470ms - Times executed: 81 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-06-03 14:24:40 Duration: 846ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (320, 21, 1);
Date: 2026-06-03 11:06:27 Duration: 843ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-06-03 15:09:39 Duration: 832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 80 24s992ms 150ms 4s182ms 312ms create table temp0000281619 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 03 08 3 8s257ms 2s752ms 09 11 1s944ms 176ms 10 11 2s48ms 186ms 11 2 490ms 245ms 12 1 166ms 166ms 13 6 944ms 157ms 14 21 3s540ms 168ms 15 9 2s108ms 234ms 16 16 5s491ms 343ms [ User: intelifix - Total duration: 24s992ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 24s992ms - Times executed: 80 ]
-
CREATE TABLE temp0000281619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 08:37:06 Duration: 4s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 08:23:07 Duration: 3s904ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1065299", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:16:24 Duration: 533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 72 19s611ms 151ms 3s655ms 272ms create table temp0000281601 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 03 07 1 3s655ms 3s655ms 09 5 862ms 172ms 10 13 2s203ms 169ms 11 13 2s329ms 179ms 12 4 784ms 196ms 13 2 390ms 195ms 14 7 1s562ms 223ms 15 13 2s917ms 224ms 16 11 3s982ms 362ms 17 3 924ms 308ms [ User: intelifix - Total duration: 19s611ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 19s611ms - Times executed: 72 ]
-
CREATE TABLE temp0000281601 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 07:53:13 Duration: 3s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281601 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1065299", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:40:58 Duration: 573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281601 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1065299", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:34:45 Duration: 506ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 67 25s313ms 160ms 3s666ms 377ms create table temp0000281615 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 03 08 7 8s401ms 1s200ms 09 5 1s613ms 322ms 10 7 2s33ms 290ms 11 7 1s887ms 269ms 12 3 703ms 234ms 13 2 371ms 185ms 14 19 5s258ms 276ms 15 9 2s297ms 255ms 16 8 2s746ms 343ms [ User: intelifix - Total duration: 25s313ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 25s313ms - Times executed: 67 ]
-
CREATE TABLE temp0000281615 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 08:21:14 Duration: 3s666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281615 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 08:22:15 Duration: 3s444ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281615 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"1065299", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:30:00 Duration: 472ms 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 2m12s 7m54s 5m3s 2 10m7s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 03 05 2 10m7s 5m3s [ User: intelifix - Total duration: 10m7s - Times executed: 2 ]
[ Application: psql - Total duration: 10m7s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-03 05:07:56 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-03 05:10:08 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
2 931ms 8m13s 3m2s 32 1h37m11s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 03 07 2 7m43s 3m51s 08 2 5m56s 2m58s 09 2 5m59s 2m59s 10 2 8m21s 4m10s 11 2 6m25s 3m12s 12 2 6m4s 3m2s 13 2 5m29s 2m44s 14 2 6m22s 3m11s 15 2 6m30s 3m15s 16 2 6m13s 3m6s 17 2 6m2s 3m1s 18 2 5m10s 2m35s 19 2 5m4s 2m32s 20 2 5m39s 2m49s 21 2 5m1s 2m30s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h37m11s - Times executed: 32 ]
[ Application: psql - Total duration: 1h37m11s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-03 10:13:14 Duration: 8m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-03 07:12:42 Duration: 7m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-03 15:11:30 Duration: 6m28s Database: rio User: intelifix Remote: [local] Application: psql
3 1m19s 1m20s 1m20s 2 2m40s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 03 20 1 1m19s 1m19s 23 1 1m20s 1m20s [ User: intelifix - Total duration: 2m40s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m40s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-03 23:34:52 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-03 20:08:02 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 46s132ms 56s558ms 51s345ms 2 1m42s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 03 20 1 56s558ms 56s558ms 23 1 46s132ms 46s132ms [ User: intelifix - Total duration: 1m42s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m42s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-03 20:05:15 Duration: 56s558ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-03 23:16:54 Duration: 46s132ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 150ms 46m36s 50s914ms 216 3h3m17s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 03 07 16 15m57s 59s843ms 08 15 4m 16s27ms 09 12 4m36s 23s76ms 10 22 9m48s 26s734ms 11 28 9m8s 19s571ms 12 5 7m26s 1m29s 13 29 2m3s 4s273ms 14 31 16m50s 32s605ms 15 31 11m30s 22s282ms 16 19 55m2s 2m53s 17 8 46m51s 5m51s [ User: intelifix - Total duration: 3h3m17s - Times executed: 216 ]
[ Application: [unknown] - Total duration: 3h3m17s - Times executed: 216 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0248997,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 16:44:54 Duration: 46m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lote_devolucao(''/var/www/html/uploads/QUERIES 94.xlsx'',0249092,0) ;', '/var/www/html/tmp/temp_94.xlsx');
Date: 2026-06-03 17:46:21 Duration: 43m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025106, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-03 07:11:23 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 414ms 1m 17s718ms 32 9m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 03 07 2 1m 30s82ms 08 2 28s782ms 14s391ms 09 2 28s912ms 14s456ms 10 2 1m3s 31s537ms 11 2 34s693ms 17s346ms 12 2 30s773ms 15s386ms 13 2 28s871ms 14s435ms 14 2 38s517ms 19s258ms 15 2 31s180ms 15s590ms 16 2 39s716ms 19s858ms 17 2 38s625ms 19s312ms 18 2 28s623ms 14s311ms 19 2 27s427ms 13s713ms 20 2 35s323ms 17s661ms 21 2 25s639ms 12s819ms 22 2 26s649ms 13s324ms [ User: intelifix - Total duration: 9m26s - Times executed: 32 ]
[ Application: psql - Total duration: 9m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-03 10:14:15 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-03 07:13:40 Duration: 58s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-03 16:11:48 Duration: 38s338ms Database: rio User: intelifix Remote: [local] Application: psql
7 5s125ms 16s45ms 10s425ms 22 3m49s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 03 09 5 43s399ms 8s679ms 10 2 18s413ms 9s206ms 11 1 7s85ms 7s85ms 13 3 28s43ms 9s347ms 14 2 19s803ms 9s901ms 15 2 18s848ms 9s424ms 16 5 1m3s 12s609ms 17 2 30s727ms 15s363ms [ User: intelifix - Total duration: 3m49s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 3m49s - Times executed: 22 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-03', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-03 17:08:27 Duration: 16s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-03', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-03 17:12:35 Duration: 14s682ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-03', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-03 16:59:48 Duration: 14s435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 8s492ms 12s117ms 10s356ms 13 2m14s create table temp0000281673 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 03 13 3 32s29ms 10s676ms 14 10 1m42s 10s260ms [ User: intelifix - Total duration: 2m14s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 13 ]
-
CREATE TABLE temp0000281673 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 14:12:12 Duration: 12s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281673 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 14:02:22 Duration: 11s193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281673 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 13:38:42 Duration: 11s174ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7s876ms 30s330ms 9s829ms 100 16m22s create table temp0000281577 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 03 07 20 3m27s 10s391ms 08 6 52s906ms 8s817ms 09 7 1m9s 9s986ms 10 9 1m27s 9s723ms 11 10 1m39s 9s944ms 12 9 1m25s 9s546ms 14 18 3m 10s26ms 15 17 2m41s 9s502ms 16 4 37s455ms 9s363ms [ User: intelifix - Total duration: 16m22s - Times executed: 100 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 100 ]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 07:04:55 Duration: 30s330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:30:54 Duration: 12s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:27:51 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s656ms 11s422ms 9s665ms 14 2m15s create table temp0000281617 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 03 08 6 56s261ms 9s376ms 09 8 1m19s 9s881ms [ User: intelifix - Total duration: 2m15s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m15s - Times executed: 14 ]
-
CREATE TABLE temp0000281617 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:13:51 Duration: 11s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281617 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 09:06:32 Duration: 11s240ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281617 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 08:32:14 Duration: 10s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s32ms 10s74ms 8s847ms 18 2m39s create table temp0000281693 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 03 16 10 1m29s 8s975ms 17 8 1m9s 8s687ms [ User: intelifix - Total duration: 2m39s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 18 ]
-
CREATE TABLE temp0000281693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 16:09:30 Duration: 10s74ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 16:55:19 Duration: 9s650ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-03 16:09:57 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 752ms 18s354ms 5s39ms 45 3m46s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 03 08 3 19s390ms 6s463ms 09 3 18s686ms 6s228ms 10 3 20s987ms 6s995ms 11 3 18s259ms 6s86ms 12 3 12s112ms 4s37ms 13 3 10s928ms 3s642ms 14 3 29s812ms 9s937ms 15 3 29s326ms 9s775ms 16 3 30s968ms 10s322ms 17 3 21s216ms 7s72ms 18 3 2s966ms 988ms 19 3 3s455ms 1s151ms 20 3 2s894ms 964ms 21 3 2s749ms 916ms 22 3 3s21ms 1s7ms [ User: intelifix - Total duration: 3m46s - Times executed: 45 ]
[ Application: psql - Total duration: 3m46s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-03 17:00:19 Duration: 18s354ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-03 14:20:18 Duration: 17s241ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-03 16:20:17 Duration: 16s543ms Database: rio User: intelifix Remote: [local] Application: psql
13 3s316ms 13s663ms 4s667ms 40 3m6s create table temp0000281577 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 03 07 8 29s965ms 3s745ms 08 2 7s819ms 3s909ms 09 2 8s963ms 4s481ms 11 6 25s344ms 4s224ms 12 5 21s730ms 4s346ms 14 4 20s911ms 5s227ms 15 11 52s288ms 4s753ms 16 2 19s658ms 9s829ms [ User: intelifix - Total duration: 3m6s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 40 ]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:31:50 Duration: 13s663ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 16:32:06 Duration: 5s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-05-2026", "ate" :"03-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-03 15:43:15 Duration: 5s821ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2s659ms 35s113ms 3s746ms 138 8m37s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 03 00 6 27s287ms 4s547ms 01 6 19s27ms 3s171ms 02 6 19s443ms 3s240ms 03 6 19s864ms 3s310ms 04 6 19s495ms 3s249ms 05 6 20s981ms 3s496ms 06 6 20s553ms 3s425ms 07 6 21s256ms 3s542ms 08 6 20s953ms 3s492ms 09 6 20s410ms 3s401ms 10 6 54s49ms 9s8ms 11 6 23s301ms 3s883ms 12 6 19s423ms 3s237ms 13 6 22s368ms 3s728ms 14 6 24s533ms 4s88ms 15 6 23s152ms 3s858ms 16 6 19s492ms 3s248ms 17 6 22s789ms 3s798ms 18 6 20s593ms 3s432ms 19 6 18s390ms 3s65ms 20 6 22s188ms 3s698ms 21 6 19s354ms 3s225ms 22 6 18s155ms 3s25ms [ User: intelifix - Total duration: 8m37s - Times executed: 138 ]
[ Application: psql - Total duration: 8m37s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 10:35:39 Duration: 35s113ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 00:05:22 Duration: 11s402ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-03 17:15:07 Duration: 6s807ms Database: rio User: intelifix Remote: [local] Application: psql
15 218ms 9s946ms 3s713ms 93 5m45s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 03 00 5 15s108ms 3s21ms 01 6 7s70ms 1s178ms 02 4 6s134ms 1s533ms 03 4 6s534ms 1s633ms 04 6 8s773ms 1s462ms 05 5 8s258ms 1s651ms 07 6 33s188ms 5s531ms 08 6 33s576ms 5s596ms 09 6 35s963ms 5s993ms 10 6 33s644ms 5s607ms 11 6 38s425ms 6s404ms 12 6 30s143ms 5s23ms 13 1 2s402ms 2s402ms 14 6 26s91ms 4s348ms 15 6 37s777ms 6s296ms 16 4 8s515ms 2s128ms 21 4 5s571ms 1s392ms 22 6 8s175ms 1s362ms [ User: intelifix - Total duration: 5m45s - Times executed: 93 ]
[ Application: psql - Total duration: 5m45s - Times executed: 93 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 00:05:11 Duration: 9s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 09:45:10 Duration: 9s19ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-03 11:05:10 Duration: 8s962ms Database: rio User: intelifix Remote: [local] Application: psql
16 202ms 59s102ms 3s27ms 55 2m46s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 03 07 8 3s131ms 391ms 08 6 52s372ms 8s728ms 09 4 18s949ms 4s737ms 10 5 1m 12s139ms 11 5 8s194ms 1s638ms 12 3 962ms 320ms 13 1 1s419ms 1s419ms 14 8 4s886ms 610ms 15 6 2s420ms 403ms 16 6 9s811ms 1s635ms 17 3 3s645ms 1s215ms [ User: intelifix - Total duration: 2m46s - Times executed: 55 ]
[ Application: psql - Total duration: 2m46s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025127);
Date: 2026-06-03 10:43:48 Duration: 59s102ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025115);
Date: 2026-06-03 08:31:25 Duration: 41s258ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025119);
Date: 2026-06-03 09:05:04 Duration: 17s25ms Database: rio User: intelifix Remote: [local] Application: psql
17 160ms 18s293ms 1s275ms 125 2m39s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 03 07 8 8s46ms 1s5ms 08 7 13s378ms 1s911ms 09 5 4s485ms 897ms 10 17 14s899ms 876ms 11 22 8s125ms 369ms 13 24 1m1s 2s568ms 14 10 5s462ms 546ms 15 27 41s401ms 1s533ms 16 5 2s24ms 404ms [ User: intelifix - Total duration: 2m39s - Times executed: 125 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 125 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (015395) LIMIT 1;
Date: 2026-06-03 13:57:55 Duration: 18s293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (036882) LIMIT 1;
Date: 2026-06-03 13:38:03 Duration: 10s888ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (036882) LIMIT 1;
Date: 2026-06-03 15:40:58 Duration: 9s779ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 150ms 4s659ms 677ms 1,662 18m45s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 03 07 16 17s285ms 1s80ms 08 105 1m13s 701ms 09 213 2m47s 784ms 10 171 1m46s 620ms 11 207 2m16s 660ms 12 69 45s619ms 661ms 13 140 1m36s 688ms 14 304 3m6s 614ms 15 242 2m20s 578ms 16 168 1m51s 661ms 17 27 45s55ms 1s668ms [ User: intelifix - Total duration: 18m45s - Times executed: 1662 ]
[ Application: [unknown] - Total duration: 18m45s - Times executed: 1662 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248820, 450, 'F200012004B1212,84011295ACF1$F200012236B05C4,1834AF275758$F200011008B005C,9877E70765A1$F20001020613C6F,743AEF70B1EC$F200010209B8829,743AEF712836$F200011081B1884,9877E74B1B76$F200011081BA8F5,9877E74B5AA7$F200010318B0C99,743AEFD95A24$F200012005B5BC6,840112961CF8$F200010266B3F72,743AEF9B00DD$F200011148B3A84,9877E7BC1760$F200011081B05C1,9877E74B1342$F200011291B2E87,8401125FFFBB$F200011301B1135,8401127FBD08$F200010209B7500,743AEF711FD8', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 11:07:33 Duration: 4s659ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40131, 413, '834066910000557,230048419809,241637607278,241732173747,241618234445,241672704969,241605375053,241700946378,241715043557,241713368499,241677396268,241729498301,241704667796,241704260204,241598819812,241646287575,241654580406,241664691213,241622436673,241646307072,241618233031,241714991532,241622593939,241729500019,241731231321,230043580516,241616298599,241679919702,241680483551,241703553838,241629320511,241729516888,241728536074,241689137784,241608698902,241673337185,241689024160,241622537188,241695484061,241622435663,241664813447,241704666584,241729497492,241659742638,241676761628', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-03 09:03:15 Duration: 3s914ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40089, 413, '270911028503111299,216943715062,229690462428,229745117492,229726647182,229806022539,229813488990,229726514465,229670077284,229925527882,229668615155,229933850918,229805688588,229740301737,229812312749,229807371324,229805220306,229786702236,229669619608,229810965456,229865948588,229690956370,229687901718,229661312535,229836978185,229738491515,229742912025,229672811121,229747436585,216944572733,229864991818,229754807798', '246468617388,246123348899,246539908397,246506499806,246581715968,246627000209,246520474649,246514461515,226404758697,246517022528,246003345067,246581936472,246526698387,246627976880,246581378506,246598464449,246596243043,246470040828,246639725569,246652592942,246513878898,246513910115,246467969211,246640621022,246529286575,246558726676,246492149214,246548282122,246462745053,246649823749,246572080315', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-03 09:28:12 Duration: 3s723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 332ms 846ms 549ms 81 44s470ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 03 00 2 1s262ms 631ms 04 2 992ms 496ms 05 1 452ms 452ms 06 1 483ms 483ms 07 5 2s788ms 557ms 08 8 4s125ms 515ms 09 7 3s524ms 503ms 10 8 4s288ms 536ms 11 8 5s230ms 653ms 12 5 2s544ms 508ms 13 7 3s724ms 532ms 14 8 4s880ms 610ms 15 8 4s479ms 559ms 16 7 3s848ms 549ms 17 3 1s387ms 462ms 21 1 456ms 456ms [ User: intelifix - Total duration: 44s470ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 44s470ms - Times executed: 81 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-06-03 14:24:40 Duration: 846ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (320, 21, 1);
Date: 2026-06-03 11:06:27 Duration: 843ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-06-03 15:09:39 Duration: 832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 261ms 774ms 443ms 85 37s682ms 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 #20
Day Hour Count Duration Avg duration Jun 03 00 2 771ms 385ms 04 2 719ms 359ms 05 1 386ms 386ms 06 2 740ms 370ms 07 6 2s680ms 446ms 08 8 3s374ms 421ms 09 7 2s717ms 388ms 10 8 3s421ms 427ms 11 8 4s480ms 560ms 12 5 2s89ms 417ms 13 8 3s570ms 446ms 14 8 4s111ms 513ms 15 8 3s771ms 471ms 16 7 3s2ms 428ms 17 3 1s120ms 373ms 21 2 721ms 360ms [ User: lenon - Total duration: 37s682ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 37s682ms - Times executed: 85 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-03 14:24:40 Duration: 774ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-03 11:06:27 Duration: 751ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-03 15:09:39 Duration: 750ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 03 16 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 5m38s - Times executed: 3 ]
[ Application: psql - Total duration: 5m37s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 605ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: contagem Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 15,686 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 430 FATAL entries
- 2090 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,074 Max number of times the same event was reported
- 2,525 Total events found
Rank Times reported Error 1 2,074 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 03 07 34 08 258 09 310 10 259 11 285 12 125 13 118 14 245 15 260 16 161 17 19 - ERROR: prepared statement "_PLAN0000000029798800" does not exist
- ERROR: prepared statement "_PLAN000000002EA168F0" does not exist
- ERROR: prepared statement "_PLAN000000002979D100" does not exist
Statement: DEALLOCATE "_PLAN0000000029798800"
Date: 2026-06-03 07:23:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002EA168F0"
Date: 2026-06-03 07:27:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002979D100"
Date: 2026-06-03 07:32:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 418 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 03 00 17 01 14 02 15 03 14 04 14 05 19 06 16 07 16 08 19 09 19 10 19 11 20 12 24 13 20 14 19 15 19 16 19 17 21 18 19 19 17 20 18 21 20 22 19 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-03 00:02:03 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-03 00:02:04 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-03 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 10 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 03 08 2 09 4 11 3 14 1 - ERROR: trailing junk after numeric literal at or near "946A771F7ED6" at character 27
- ERROR: trailing junk after numeric literal at or near "946A771F7ED6" at character 27
- ERROR: trailing junk after numeric literal at or near "2297443991Vi" at character 27
Statement: SELECT * FROM RS_ETIQUETA(946A771F7ED6)
Date: 2026-06-03 08:35:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(946A771F7ED6)
Date: 2026-06-03 08:35:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(2297443991Vi)
Date: 2026-06-03 09:13:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 7 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 03 18 3 19 2 20 2 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-06-03 18:00:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-03 18:35:32 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-03 18:55:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 03 09 1 10 3 - LOG: process 652012 still waiting for ShareLock on transaction 472010 after 1000.055 ms
- LOG: process 767634 still waiting for ShareLock on transaction 480212 after 1000.133 ms
- LOG: process 767634 still waiting for ShareLock on transaction 480212 after 7838.559 ms
Detail: Process holding the lock: 652014. Wait queue: 652012.
Context: while updating tuple (1,25) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(40202,407,'834150922002180,241604720512$835162924005739,241689117782$834150922002564,241604758797$834257937001636,241628279309$835016903002566,241649717798','',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""}]','$$$$','',00);Date: 2026-06-03 09:03:15 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 791667. Wait queue: 767634.
Context: while updating tuple (69160,78) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-03 10:35:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 791667. Wait queue: 767634.
Context: while updating tuple (69160,78) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-03 10:35:14 Database: rio Application: psql User: intelifix Remote: [local]
6 3 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 03 03 3 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-03 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-03 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT B.TEC_ID FROM USUARIOS A INNER JOIN TECNICOS B ON B.USU_ID = A.USU_ID AND B.TEC_STATUS = 0 WHERE A.USU_CHAVE = cUser AND A.USU_ATIVO = 'S'" PL/pgSQL function rs_giga_triagem(character varying,integer) line 115 at SQL statement SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-03 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
7 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 03 09 2 - ERROR: syntax error at or near "229795738505" at character 32
- ERROR: syntax error at or near "229795738505" at character 46
Statement: SELECT RS_SERIAL_TEMPORARIO( ''229795738505' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''229795738505' )
Date: 2026-06-03 09:42:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0145, ''229795738505' )
Date: 2026-06-03 09:42:38 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 03 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-03 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-06-03 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
9 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 03 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-03 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-03 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 03 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-03 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 03 03 1 - LOG: database system was shut down at 2026-06-03 03:05:01 -03
Date: 2026-06-03 03:05:02