pgBadger-
Global information
- Generated on Fri Jun 19 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 34,731 log entries in 6s
- Log start from 2026-06-19 00:02:16 to 2026-06-19 23:49:52
-
Overview
Global Stats
- 319 Number of unique normalized queries
- 5,074 Number of queries
- 7h12m10s Total query duration
- 2026-06-19 00:02:16 First query
- 2026-06-19 23:48:13 Last query
- 8 queries/s at 2026-06-19 09:42:28 Query peak
- 7h12m10s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h12m10s Execute total duration
- 3,381 Number of events
- 21 Number of unique normalized events
- 2,795 Max number of times the same event was reported
- 0 Number of cancellation
- 391 Total number of automatic vacuums
- 800 Total number of automatic analyzes
- 22 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 271 Total number of sessions
- 6 sessions at 2026-06-19 13:35:01 Session peak
- 9d14h22m4s Total duration of sessions
- 51m Average duration of sessions
- 18 Average queries per session
- 1m35s Average queries duration per session
- 49m24s Average idle time per session
- 279 Total number of connections
- 5 connections/s at 2026-06-19 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 8 queries/s Query Peak
- 2026-06-19 09:42:28 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-06-19 09:42:28 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-19 23:41:37 Date
Queries duration
Key values
- 7h12m10s 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 19 00 21 0ms 22s156ms 5s313ms 16s660ms 1m9s 1m9s 01 47 0ms 3s800ms 802ms 4s943ms 5s356ms 6s443ms 02 12 0ms 3s379ms 2s200ms 5s127ms 5s588ms 5s588ms 03 12 0ms 4s77ms 2s458ms 7s8ms 7s8ms 7s8ms 04 34 0ms 3s284ms 1s59ms 5s710ms 5s800ms 6s71ms 05 28 0ms 7m59s 22s623ms 6s604ms 2m8s 8m 06 35 0ms 15s953ms 2s473ms 20s966ms 23s309ms 23s309ms 07 467 150ms 9m52s 3s577ms 39s443ms 1m9s 10m34s 08 546 150ms 6m9s 3s997ms 1m 3m53s 7m17s 09 604 150ms 9m39s 3s817ms 50s26ms 4m54s 9m52s 10 539 150ms 6m48s 3s691ms 1m12s 1m32s 7m23s 11 569 0ms 7m37s 2s966ms 50s20ms 4m17s 8m 12 127 0ms 6m39s 10s409ms 48s506ms 1m 6m44s 13 440 0ms 7m16s 4s16ms 32s67ms 5m43s 7m22s 14 833 150ms 8m24s 3s579ms 1m24s 5m26s 8m32s 15 255 0ms 8m53s 9s701ms 1m16s 5m54s 8m56s 16 93 0ms 7m39s 18s340ms 1m 3m39s 7m39s 17 60 0ms 6m15s 8s332ms 3s603ms 18s339ms 6m54s 18 11 0ms 6m14s 39s45ms 2s670ms 2s769ms 6m52s 19 10 0ms 5m28s 37s236ms 2s267ms 2s502ms 5m57s 20 67 0ms 7m1s 13s824ms 1m 1m39s 7m1s 21 20 0ms 5m18s 18s823ms 3s678ms 4s984ms 5m48s 22 16 0ms 5m19s 23s336ms 3s495ms 4s909ms 5m48s 23 228 0ms 1m39s 8s350ms 1m19s 1m27s 2m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 19 00 6 0 2s993ms 0ms 1s298ms 16s660ms 01 34 0 269ms 407ms 780ms 1s271ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 22 0 309ms 335ms 446ms 1s125ms 05 16 0 306ms 406ms 593ms 1s285ms 06 19 0 1s456ms 1s931ms 3s171ms 16s587ms 07 385 0 3s303ms 7s929ms 25s654ms 4m24s 08 451 0 3s752ms 13s499ms 31s238ms 6m53s 09 503 0 3s812ms 10s589ms 38s843ms 5m24s 10 434 0 3s447ms 29s647ms 1m1s 4m6s 11 435 0 3s107ms 9s498ms 31s15ms 4m26s 12 84 0 13s289ms 17s654ms 48s506ms 6m44s 13 359 0 4s419ms 8s252ms 28s654ms 6m39s 14 707 0 3s839ms 34s931ms 1m20s 6m55s 15 200 0 11s376ms 21s241ms 58s292ms 6m2s 16 65 0 23s772ms 12s592ms 57s737ms 6m12s 17 53 0 9s114ms 1s139ms 2s482ms 18s431ms 18 5 0 1m22s 0ms 0ms 419ms 19 4 0 1m29s 0ms 0ms 0ms 20 6 54 15s62ms 0ms 1m 1m59s 21 9 0 38s963ms 0ms 0ms 1s576ms 22 4 0 1m27s 0ms 0ms 0ms 23 7 221 8s350ms 1m4s 1m19s 2m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 19 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 19 00 0 1 1.00 0.00% 01 0 3 3.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 2 2.00 0.00% 06 0 3 3.00 0.00% 07 0 5 5.00 0.00% 08 0 12 12.00 0.00% 09 0 12 12.00 0.00% 10 0 9 9.00 0.00% 11 0 9 9.00 0.00% 12 0 3 3.00 0.00% 13 0 11 11.00 0.00% 14 0 10 10.00 0.00% 15 0 8 8.00 0.00% 16 0 4 4.00 0.00% 17 0 2 2.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 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 19 00 8 0.00/s 01 6 0.00/s 02 4 0.00/s 03 9 0.00/s 04 7 0.00/s 05 9 0.00/s 06 13 0.00/s 07 12 0.00/s 08 18 0.01/s 09 18 0.01/s 10 19 0.01/s 11 18 0.01/s 12 9 0.00/s 13 20 0.01/s 14 18 0.01/s 15 16 0.00/s 16 18 0.01/s 17 10 0.00/s 18 6 0.00/s 19 7 0.00/s 20 10 0.00/s 21 10 0.00/s 22 8 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Jun 19 00 3 1h 59m23s 01 8 1h1m7s 1h1m3s 02 6 1h30s 1h25s 03 9 24m17s 24m14s 04 4 1h45s 1h36s 05 8 56m33s 55m14s 06 8 57m15s 57m4s 07 11 53m48s 51m16s 08 13 53m43s 50m55s 09 20 51m21s 49m25s 10 16 54m7s 52m3s 11 20 50m7s 48m43s 12 16 53m42s 52m19s 13 11 39m34s 36m54s 14 17 58m43s 55m48s 15 20 47m42s 45m38s 16 20 37m2s 35m37s 17 11 1h23s 59m37s 18 10 59m26s 58m43s 19 7 52m51s 51m58s 20 9 40m47s 39m4s 21 7 52m52s 51m58s 22 8 1h45s 59m58s 23 9 43m32s 40m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-19 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 279 connections Total
Connections per user
Key values
- intelifix Main User
- 279 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-19 13:35:01 Date
Histogram of session times
Key values
- 204 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 271 sessions Total
Sessions per user
Key values
- intelifix Main User
- 271 sessions Total
Sessions per host
Key values
- [local] Main Host
- 271 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 271 sessions Total
Application Count Total Duration Average Duration [unknown] 248 9d4h17m51s 53m17s pgAdmin 4 - CONN:2197011 2 4s279ms 2s139ms pgAdmin 4 - CONN:9815960 2 3s933ms 1s966ms pgAdmin 4 - DB:contagem 1 8s593ms 8s593ms pgAdmin 4 - DB:postgres 1 25s174ms 25s174ms pgAdmin 4 - DB:rio 1 9s63ms 9s63ms pg_dump 6 39m2s 6m30s postgres_fdw 1 34m58s 34m58s psql 9 8h49m21s 58m49s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 28,597 buffers Checkpoint Peak
- 2026-06-19 09:04:42 Date
- 269.996 seconds Highest write time
- 4.055 seconds Sync time
Checkpoints Wal files
Key values
- 18 files Wal files usage Peak
- 2026-06-19 09:04:42 Date
Checkpoints distance
Key values
- 571.69 Mo Distance Peak
- 2026-06-19 09:04:42 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 19 00 17,270 513.658s 0.147s 513.929s 01 5,456 547.043s 0.232s 547.421s 02 2,004 201.138s 0.195s 201.432s 03 2,943 295.183s 0.108s 295.487s 04 4,524 453.724s 0.269s 454.234s 05 7,301 686.487s 0.253s 686.873s 06 6,640 433.371s 0.07s 433.511s 07 50,424 2,885.41s 4.386s 2,889.984s 08 67,642 3,148.792s 0.933s 3,149.902s 09 86,308 3,238.677s 0.626s 3,239.48s 10 64,600 3,181.734s 0.841s 3,182.765s 11 56,599 3,022.86s 0.601s 3,023.621s 12 24,420 2,289.435s 0.242s 2,289.768s 13 22,746 1,740.214s 0.548s 1,740.862s 14 48,404 3,205.924s 0.527s 3,206.604s 15 20,054 2,180.121s 0.493s 2,180.739s 16 32,274 2,253.148s 0.288s 2,253.557s 17 5,086 509.872s 0.301s 510.274s 18 589 59.178s 0.065s 59.32s 19 32 3.231s 0.006s 3.249s 20 1,118 113.02s 0.018s 113.051s 21 2,129 213.395s 0.053s 213.483s 22 1,864 187.183s 0.132s 187.358s 23 978 293.256s 0.075s 293.367s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 19 00 0 0 6 431 0.062s 0.009s 01 0 0 1 778 0.062s 0.013s 02 0 0 1 404 0.064s 0.006s 03 0 0 1 430 0.065s 0.008s 04 0 0 1 740 0.067s 0.01s 05 0 0 4 643 0.065s 0.011s 06 0 0 1 366 0.031s 0.005s 07 0 0 31 3,697 4.012s 0.024s 08 0 0 49 4,583 0.173s 0.012s 09 0 0 53 5,421 0.064s 0.012s 10 0 0 46 5,645 0.079s 0.012s 11 0 0 35 4,803 0.066s 0.012s 12 0 0 23 2,158 0.063s 0.01s 13 0 0 13 3,168 0.068s 0.011s 14 0 0 31 4,897 0.044s 0.012s 15 0 0 12 3,004 0.064s 0.012s 16 0 0 23 2,129 0.065s 0.011s 17 0 0 1 1,480 0.058s 0.01s 18 0 0 1 121 0.036s 0.019s 19 0 0 0 7 0.005s 0.001s 20 0 0 0 63 0.010s 0.006s 21 0 0 1 399 0.015s 0.02s 22 0 0 1 416 0.059s 0.011s 23 0 0 3 31 0.063s 0.016s Day Hour Count Avg time (sec) Jun 19 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 19 00 15,893.50 kB 59,689.50 kB 01 2,453.09 kB 32,470.82 kB 02 1,600.50 kB 13,875.33 kB 03 2,007.50 kB 4,477.62 kB 04 2,603.78 kB 4,231.67 kB 05 6,102.33 kB 20,000.00 kB 06 4,387.00 kB 14,223.75 kB 07 41,930.08 kB 69,612.42 kB 08 67,620.67 kB 111,527.50 kB 09 72,567.75 kB 196,361.75 kB 10 62,863.00 kB 127,731.25 kB 11 47,180.75 kB 111,409.25 kB 12 38,068.90 kB 69,709.40 kB 13 18,863.00 kB 45,737.91 kB 14 42,395.50 kB 80,311.42 kB 15 16,891.00 kB 45,764.92 kB 16 33,731.09 kB 66,177.64 kB 17 2,652.60 kB 35,718.80 kB 18 529.25 kB 17,272.25 kB 19 188.00 kB 13,220.00 kB 20 3,616.67 kB 11,668.33 kB 21 1,812.83 kB 7,883.00 kB 22 1,273.62 kB 4,543.88 kB 23 13,219.75 kB 20,560.50 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-19 16:42:42 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-19 10:56:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 19 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 1 104.00 MiB 104.00 MiB 10 8 832.01 MiB 104.00 MiB 11 0 0 0 12 5 520.00 MiB 104.00 MiB 13 1 104.00 MiB 104.00 MiB 14 1 104.00 MiB 104.00 MiB 15 2 208.00 MiB 104.00 MiB 16 4 416.00 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 22 2.23 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 13:46:53 Duration: 7m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-03-01''),DATE(''2026-03-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 14:01:47 Duration: 6m43s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 16:00:37 Duration: 6m12s 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,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 16:42:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 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-19 10:42:16 - 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-19 10:21:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 10:01:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 10:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 14:06:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 13:53:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 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-19 16:14:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 10:54:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 10:56:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 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-19 10:58:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 12:27:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 15:47:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 16:08:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 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-19 12:17:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 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-19 12:22:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 15:55:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 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-19 10:29:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 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-19 12:32:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-19 09:43:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.97 sec Highest CPU-cost vacuum
Table public.usuarios
Database rio - 2026-06-19 11:12:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 4.97 sec Highest CPU-cost vacuum
Table public.usuarios
Database rio - 2026-06-19 11:12:49 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (103) Main table analyzed (database rio)
- 800 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 103 rio.pg_catalog.pg_class 57 rio.public.temp0000283024 51 rio.pg_catalog.pg_type 50 rio.public.usuarios 43 rio.pg_catalog.pg_index 33 contagem.pg_catalog.pg_attribute 30 contagem.public.temp0000226454 28 rio.public.temp0000283028 27 rio.pg_catalog.pg_depend 27 contagem.public.usuarios 25 rio.public.temp0000282535 24 contagem.public.temp0000226434 19 contagem.pg_catalog.pg_class 19 contagem.public.temp0000226442 17 contagem.pg_catalog.pg_type 16 rio.public.temp0000283074 15 rio.public.temp0000283016 15 rio.public.temp0000283004 12 rio.public.temp0000283140 12 rio.public.temp0000283026 12 rio.public.temp0000283104 10 contagem.pg_catalog.pg_index 10 rio.public.temp0000282880 8 contagem.pg_catalog.pg_depend 7 contagem.public.temp0000226458 7 rio.public.temp0000283034 6 rio.public.temp0000283062 6 contagem.public.temp0000226412 6 rio.public.temp0000282517 6 rio.public.temp0000283092 6 rio.public.temp0000283118 6 template1.pg_catalog.pg_shdepend 6 rio.public.temp0000282507 5 rio.public.temp0000283052 4 rio.public.temp0000283110 4 rio.public.temp0000282509 4 rio.public.tmp_drill_0175 4 contagem.public.temp0000226446 3 postgres.pg_catalog.pg_shdepend 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0302 3 rio.public.temp0000283094 3 rio.public.temp0000283008 3 rio.public.temp0000283082 2 rio.public.temp0000282643 2 rio.public.temp0000283130 2 rio.public.temp0000282858 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000283044 2 contagem.public.temp0000226452 2 rio.public.temp0000282537 2 rio.public.temp0000283102 2 rio.public.temp0000283106 2 rio.public.temp0000283036 2 contagem.public.nf_entrada 2 rio.public.temp0000283080 2 rio.public.temp0000283114 2 rio.public.temp0000283022 1 rio.public.temp0000283064 1 rio.public.temp0000282689 1 rio.public.temp0000283030 1 rio.pg_catalog.pg_shdepend 1 rio.public.temp0000283086 1 contagem.public.temp0000226456 1 rio.public.temp0000283020 1 rio.public.temp0000283066 1 rio.public.temp0000283090 1 rio.public.temp0000283096 1 rio.public.temp0000281789 1 rio.public.temp0000283010 1 rio.public.temp0000283122 1 Total 800 Vacuums per table
Key values
- pg_catalog.pg_attribute (43) Main table vacuumed on database rio
- 391 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 43 36 0 0 0 0 0 20,913 4,894 7,706,426 333 7,931 rio.pg_catalog.pg_class 37 28 0 0 0 0 0 5,240 1,533 2,321,805 86 334 rio.pg_catalog.pg_type 31 24 0 0 0 0 0 2,210 564 815,185 69 211 rio.public.temp0000283024 28 0 0 0 0 0 0 12,330 1,725 2,767,104 0 0 rio.public.temp0000283028 27 0 0 0 0 0 0 16,924 3,383 5,240,750 0 0 contagem.public.usuarios 25 0 0 0 0 0 0 128 98 52,575 3 24 rio.public.temp0000283074 14 0 0 0 0 0 0 20,658 1,640 3,247,966 0 0 rio.pg_catalog.pg_index 14 14 0 0 0 0 0 976 252 228,319 59 128 rio.public.temp0000283140 12 0 0 0 0 0 0 12,736 3,219 4,808,874 0 0 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 3,778 1,178 1,793,950 60 588 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,612 2,290 3,834,117 33 841 rio.public.temp0000282535 10 0 0 0 0 0 0 9,553 3,208 4,614,100 0 0 rio.public.temp0000283104 10 0 0 0 0 0 0 9,558 1,625 2,592,015 0 0 rio.public.usuarios 7 3 0 0 0 0 0 115 41 77,268 6 19 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,384 1,809 7,663,400 913 4,088 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 531 187 305,156 11 37 rio.public.temp0000283118 6 0 0 0 0 0 0 24 18 4,644 0 0 rio.public.temp0000283092 6 0 0 0 0 0 0 4,972 3,292 4,533,900 0 0 rio.public.temp0000283062 6 0 0 0 0 0 0 107 21 9,916 0 0 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 907 321 424,250 13 37 rio.public.temp0000282517 5 0 0 0 0 0 0 76 67 80,587 0 0 rio.public.temp0000283034 5 0 0 0 0 0 0 4,775 20 284,910 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 183 75 57,102 6 11 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 3,714 1,147 1,993,510 1 12 template1.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 614 217 198,918 53 109 rio.public.temp0000282509 4 0 0 0 0 0 0 277 23 19,751 0 0 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,097 450 816,036 11 179 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,741 360 2,082,869 132 490 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 229 9 47,186 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,421 1,186 3,780,180 1,006 7,015 contagem.public.temp0000226446 3 0 0 0 0 0 0 288 18 19,786 0 0 rio.public.temp0000283114 2 0 0 0 0 0 0 110 11 8,301 0 0 rio.public.temp0000283080 2 0 0 0 0 0 0 200 12 13,604 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 177 75 143,097 5 10 rio.public.temp0000283036 2 0 0 0 0 0 0 171 12 11,910 0 0 rio.public.temp0000283106 2 0 0 0 0 0 0 1,689 1,595 2,121,934 0 0 rio.public.temp0000283102 2 0 0 0 0 0 0 16 10 2,502 0 0 contagem.public.temp0000226452 2 0 0 0 0 0 0 192 12 13,193 0 0 rio.public.temp0000282643 2 0 0 0 0 0 0 115 59 83,950 0 0 rio.public.temp0000283130 2 0 0 0 0 0 0 16 10 2,716 0 0 rio.public.temp0000283082 2 0 0 0 0 0 0 105 12 10,183 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 82 2 7,455 0 0 rio.public.temp0000283010 1 0 0 0 0 0 0 85 6 5,926 0 0 rio.public.temp0000281789 1 0 0 0 0 0 0 62 6 4,486 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 160 43 100,911 14 25 rio.public.temp0000283086 1 0 0 0 0 0 0 8 5 1,248 0 0 rio.public.temp0000282689 1 0 0 0 0 0 0 48 6 3,642 0 0 rio.public.logs 1 0 0 0 0 0 0 1,336 979 1,201,192 170 4,248 contagem.public.acessorios 1 1 0 0 0 0 0 355 176 650,620 3 205 rio.public.temp0000282507 1 0 0 0 0 0 0 61 6 4,460 0 0 rio.public.temp0000282858 1 0 0 0 0 0 0 8 5 1,342 0 0 rio.public.temp0000283022 1 0 0 0 0 0 0 85 6 5,926 0 0 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 119 23 28,726 1 1 Total 391 177 0 0 0 0 0 158,271 37,941 66,849,879 2,988 26,543 Vacuum throughput per table
Key values
- public.usuarios (4.99) 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 2.52 rio.pg_catalog.pg_class 0 0 0.82 rio.pg_catalog.pg_type 0 0 0.34 rio.public.temp0000283024 0 0 0.64 rio.public.temp0000283028 0 0 0.91 contagem.public.usuarios 0 0 0 rio.public.temp0000283074 0 0 0.72 rio.pg_catalog.pg_index 0 0 0.12 rio.public.temp0000283140 0 0 0.7 rio.pg_catalog.pg_depend 0 0 0.65 contagem.pg_catalog.pg_attribute 0 0 1.04 rio.public.temp0000282535 0 0 0.61 rio.public.temp0000283104 0 0 0.48 rio.public.usuarios 0 0 4.99 rio.pg_catalog.pg_statistic 0 0 1 contagem.pg_catalog.pg_type 0 0 0.15 rio.public.temp0000283118 0 0 0.29 rio.public.temp0000283092 0 0 0.3 rio.public.temp0000283062 0 0 0.25 contagem.pg_catalog.pg_class 0 0 0.18 rio.public.temp0000282517 0 0 0.05 rio.public.temp0000283034 0 0 0.2 contagem.pg_catalog.pg_index 0 0 0.13 rio.public.tmp_drill_0175 0 0 0.18 template1.pg_catalog.pg_shdepend 0 0 0.11 rio.public.temp0000282509 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.31 rio.pg_toast.pg_toast_2619 0 0 0.16 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.28 contagem.public.temp0000226446 0 0 0.04 rio.public.temp0000283114 0 0 0.02 rio.public.temp0000283080 0 0 0.03 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000283036 0 0 0.02 rio.public.temp0000283106 0 0 0.09 rio.public.temp0000283102 0 0 0.02 contagem.public.temp0000226452 0 0 0.02 rio.public.temp0000282643 0 0 0.02 rio.public.temp0000283130 0 0 0.03 rio.public.temp0000283082 0 0 0.03 brasilia.pg_catalog.pg_statistic 0 0 0 rio.public.temp0000283010 0 0 0.01 rio.public.temp0000281789 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000283086 0 0 0 rio.public.temp0000282689 0 0 0.01 rio.public.logs 0 0 0.5 contagem.public.acessorios 0 0 0.13 rio.public.temp0000282507 0 0 0.01 rio.public.temp0000282858 0 0 0.02 rio.public.temp0000283022 0 0 0.01 postgres.pg_catalog.pg_shdepend 0 0 0.05 Total 0 0 19.28 Tuples removed per table
Key values
- pg_catalog.pg_attribute (170237) Main table with removed tuples on database rio
- 321234 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 43 36 170,237 1,046,333 64,370 381 25,856 rio.public.tmp_drill_0175 4 4 55,716 56,576 0 0 1,422 contagem.pg_catalog.pg_attribute 11 11 35,828 283,334 0 124 6,334 rio.pg_catalog.pg_statistic 7 7 12,695 57,922 403 0 9,002 rio.pg_catalog.pg_type 31 24 9,398 76,605 5,664 20 2,194 rio.pg_catalog.pg_depend 12 12 9,120 230,842 6 14 2,126 contagem.pg_catalog.pg_statistic 3 3 6,302 22,828 0 0 3,033 rio.pg_catalog.pg_index 14 14 4,658 27,243 284 0 827 template1.pg_catalog.pg_shdepend 4 4 4,246 33,377 17 0 404 rio.pg_catalog.pg_class 37 28 3,086 142,741 16,589 26 4,980 contagem.pg_catalog.pg_depend 4 4 3,021 75,433 0 0 704 contagem.public.usuarios 25 0 1,587 575 0 0 50 rio.pg_toast.pg_toast_2619 3 3 1,106 2,316 1 3 858 contagem.pg_catalog.pg_type 6 6 1,099 13,502 0 15 378 postgres.pg_catalog.pg_shdepend 1 1 853 8,503 270 0 101 contagem.pg_catalog.pg_class 5 5 708 17,078 0 13 628 contagem.pg_catalog.pg_index 4 4 536 7,592 0 6 198 rio.public.usuarios 7 3 408 4,601 1,052 1 117 contagem.public.nf_entrada 2 2 252 2,367 0 0 138 brasilia.pg_catalog.pg_statistic 1 1 148 449 0 0 36 contagem.pg_toast.pg_toast_2619 1 1 147 113 0 0 63 contagem.public.acessorios 1 1 83 18,921 0 0 182 rio.public.temp0000283114 2 0 0 4,045 0 67 189 rio.public.temp0000282535 10 0 0 223,618 0 0 16,000 rio.public.temp0000283010 1 0 0 1,606 0 51 77 rio.public.temp0000281789 1 0 0 2,484 0 10 54 rio.public.temp0000283140 12 0 0 268,453 0 0 19,200 rio.public.temp0000283080 2 0 0 8,375 0 72 184 rio.public.temp0000283024 28 0 0 223,432 0 760 14,216 rio.public.temp0000283036 2 0 0 3,246 0 101 155 rio.public.temp0000283028 27 0 0 356,466 0 524 25,012 rio.public.temp0000283106 2 0 0 24,322 0 36 1,692 rio.public.temp0000283086 1 0 0 1,005 0 12 52 rio.public.temp0000283118 6 0 0 134,197 0 0 9,600 rio.public.temp0000283092 6 0 0 93,369 0 72 6,584 rio.public.temp0000283102 2 0 0 2,048 0 22 106 rio.public.temp0000283074 14 0 0 312,954 0 0 22,400 rio.public.temp0000282689 1 0 0 1,802 0 24 40 rio.public.tmp_drill_0302 3 3 0 3,404 0 0 92 rio.public.temp0000282517 5 0 0 21,015 0 109 467 rio.public.logs 1 0 0 15,920,605 0 0 636,027 rio.public.temp0000282509 4 0 0 14,158 0 200 312 contagem.public.temp0000226452 2 0 0 2,300 0 80 176 rio.public.temp0000283062 6 0 0 113,495 0 49 8,079 rio.public.temp0000282507 1 0 0 1,010 0 11 53 rio.public.temp0000282858 1 0 0 5,838 0 63 129 rio.public.temp0000282643 2 0 0 4,506 0 29 99 rio.public.temp0000283130 2 0 0 11,704 0 124 260 rio.public.temp0000283104 10 0 0 203,224 0 36 14,492 rio.public.temp0000283034 5 0 0 91,053 0 47 6,481 rio.public.temp0000283022 1 0 0 1,606 0 51 77 contagem.public.temp0000226446 3 0 0 3,445 0 120 264 rio.public.temp0000283082 2 0 0 3,835 0 76 180 Total 391 177 321,234 20,191,871 88,656 3,349 842,380 Pages removed per table
Key values
- public.temp0000283024 (760) Main table with removed pages on database rio
- 3349 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283024 28 0 0 760 rio.public.temp0000283028 27 0 0 524 rio.pg_catalog.pg_attribute 43 36 170237 381 rio.public.temp0000282509 4 0 0 200 contagem.pg_catalog.pg_attribute 11 11 35828 124 rio.public.temp0000283130 2 0 0 124 contagem.public.temp0000226446 3 0 0 120 rio.public.temp0000282517 5 0 0 109 rio.public.temp0000283036 2 0 0 101 contagem.public.temp0000226452 2 0 0 80 rio.public.temp0000283082 2 0 0 76 rio.public.temp0000283080 2 0 0 72 rio.public.temp0000283092 6 0 0 72 rio.public.temp0000283114 2 0 0 67 rio.public.temp0000282858 1 0 0 63 rio.public.temp0000283010 1 0 0 51 rio.public.temp0000283022 1 0 0 51 rio.public.temp0000283062 6 0 0 49 rio.public.temp0000283034 5 0 0 47 rio.public.temp0000283106 2 0 0 36 rio.public.temp0000283104 10 0 0 36 rio.public.temp0000282643 2 0 0 29 rio.pg_catalog.pg_class 37 28 3086 26 rio.public.temp0000282689 1 0 0 24 rio.public.temp0000283102 2 0 0 22 rio.pg_catalog.pg_type 31 24 9398 20 contagem.pg_catalog.pg_type 6 6 1099 15 rio.pg_catalog.pg_depend 12 12 9120 14 contagem.pg_catalog.pg_class 5 5 708 13 rio.public.temp0000283086 1 0 0 12 rio.public.temp0000282507 1 0 0 11 rio.public.temp0000281789 1 0 0 10 contagem.pg_catalog.pg_index 4 4 536 6 rio.pg_toast.pg_toast_2619 3 3 1106 3 rio.public.usuarios 7 3 408 1 rio.public.temp0000282535 10 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 148 0 rio.public.tmp_drill_0175 4 4 55716 0 rio.public.temp0000283140 12 0 0 0 contagem.public.nf_entrada 2 2 252 0 contagem.pg_toast.pg_toast_2619 1 1 147 0 template1.pg_catalog.pg_shdepend 4 4 4246 0 rio.public.temp0000283118 6 0 0 0 rio.public.temp0000283074 14 0 0 0 rio.public.tmp_drill_0302 3 3 0 0 rio.public.logs 1 0 0 0 contagem.public.acessorios 1 1 83 0 contagem.public.usuarios 25 0 1587 0 contagem.pg_catalog.pg_statistic 3 3 6302 0 rio.pg_catalog.pg_statistic 7 7 12695 0 contagem.pg_catalog.pg_depend 4 4 3021 0 rio.pg_catalog.pg_index 14 14 4658 0 postgres.pg_catalog.pg_shdepend 1 1 853 0 Total 391 177 321,234 3,349 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 19 00 0 0 01 0 9 02 0 0 03 0 0 04 0 4 05 5 4 06 1 2 07 40 77 08 47 88 09 43 107 10 66 146 11 34 93 12 36 50 13 19 50 14 48 92 15 20 34 16 25 34 17 7 9 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 - 4.97 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m27s 2m27s 2m27s 2m27s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255803, 184, '919121099568,8020DA4D1D0A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-19 08:09:22 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255062, 449, '71628885850029601179,216703633854,216558740118,216409105962,216635166262,216833544759,216361239292,216868829314,216355040103,216618682028,216868307287,216756245363,216837020823,216699812224,216507584451,216511663233,216908547690', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:49:10 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255064, 504, '519128142945,CC75E2B8C004,A8F5DDEACB65,B0935BEB3E96,BC644BD1E6E5,BC644BC655BE,BC644BDA2805,BC644BD18C54,4C1265E3FF0E,CC75E2BA6DB9,CC75E2BAE226,BC644BE4B374,BC644BD8EBB6,A89FECC46763,F8F532517731,CC75E2B78CE8,CC75E2BDD0F3,BC644BD1CFA2,4C1265EA3F7C,2C584F3677D6,BC644BDFA00F,4C12653E4FB4,BC644BDD6E9D,2C584F30324F,2C584F2F6135,BC644BD0AA69,4C1265E76856,4C1265E78DFE,2C9569EEB2EF,BC644BC61685,BC644BD12F9D,A89FECC11E37,BC644BD0A0E6,A89FECC05E61,F8F53256A6D9,5819F841303C,A89FECBDFBB7,BC644BDF1C61,2C584F3130C8,BC644BCD2547', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:13:42 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m27s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255803, 184, '919121099568,8020DA4D1D0A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-06-19 08:09:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,808 Total read queries
- 1,028 Total write queries
Queries by database
Key values
- rio Main database
- 3,823 Requests
- 6h54m6s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,971 Requests
User Request type Count Duration etiquetas Total 11 15s129ms select 11 15s129ms intelifix Total 4,971 7h10m43s copy to 275 38m41s ddl 751 44m2s others 238 24m52s select 3,706 5h23m7s tcl 1 470ms lenon Total 92 1m11s ddl 1 158ms select 91 1m11s Duration by user
Key values
- 7h10m43s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 11 15s129ms select 11 15s129ms intelifix Total 4,971 7h10m43s copy to 275 38m41s ddl 751 44m2s others 238 24m52s select 3,706 5h23m7s tcl 1 470ms lenon Total 92 1m11s ddl 1 158ms select 91 1m11s Queries by host
Key values
- [local] Main host
- 5,073 Requests
- 7h12m9s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,377 Requests
- 3h59m47s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-19 09:35:49 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,862 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 07:14:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 09:14:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 15:13:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 14:13:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m59s analyze verbose;[ Date: 2026-06-19 05:08:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 16:12:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 11:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-19 13:46:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 7m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 20:12:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 10:11:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-03-01''),DATE(''2026-03-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-19 14:01:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 12:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 17:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 18:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-19 16:00:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 08:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-01-01''),DATE(''2026-01-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-19 15:16:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-03-01''),DATE(''2026-03-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-19 15:35:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-19 13:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-04-01''),DATE(''2026-04-30'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-19 13:53:51 - 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 2h26m5s 190 150ms 7m16s 46s132ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 19 07 8 5m10s 38s872ms 08 21 13m24s 38s297ms 09 29 15m10s 31s381ms 10 21 12m14s 34s966ms 11 15 8m39s 34s643ms 12 13 10m12s 47s122ms 13 20 16m27s 49s398ms 14 31 23m51s 46s192ms 15 16 24m30s 1m31s 16 12 16m8s 1m20s 17 4 15s186ms 3s796ms [ User: intelifix - Total duration: 2h26m5s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 2h26m5s - Times executed: 190 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 13:46:53 Duration: 7m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-03-01''),DATE(''2026-03-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 14:01:47 Duration: 6m43s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 16:00:37 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h53m54s 32 1s101ms 9m52s 3m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 19 07 2 9m55s 4m57s 08 2 6m12s 3m6s 09 2 9m43s 4m51s 10 2 6m50s 3m25s 11 2 7m39s 3m49s 12 2 6m41s 3m20s 13 2 5m43s 2m51s 14 2 8m39s 4m19s 15 2 8m55s 4m27s 16 2 7m42s 3m51s 17 2 6m20s 3m10s 18 2 6m16s 3m8s 19 2 5m29s 2m44s 20 2 7m4s 3m32s 21 2 5m19s 2m39s 22 2 5m21s 2m40s [ User: intelifix - Total duration: 1h53m54s - Times executed: 32 ]
[ Application: psql - Total duration: 1h53m54s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-19 07:14:54 Duration: 9m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-19 09:14:41 Duration: 9m39s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-19 15:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql
3 20m23s 1,001 150ms 2m27s 1s222ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 19 07 94 1m46s 1s135ms 08 120 4m7s 2s65ms 09 131 2m7s 975ms 10 112 1m56s 1s44ms 11 120 2m46s 1s387ms 12 29 25s83ms 864ms 13 71 1m19s 1s119ms 14 172 3m1s 1s52ms 15 94 1m50s 1s174ms 16 21 31s225ms 1s486ms 17 37 30s17ms 811ms [ User: intelifix - Total duration: 20m23s - Times executed: 1001 ]
[ Application: [unknown] - Total duration: 20m23s - Times executed: 1001 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255803, 184, '919121099568,8020DA4D1D0A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-19 08:09:22 Duration: 2m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255062, 449, '71628885850029601179,216703633854,216558740118,216409105962,216635166262,216833544759,216361239292,216868829314,216355040103,216618682028,216868307287,216756245363,216837020823,216699812224,216507584451,216511663233,216908547690', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:49:10 Duration: 9s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255064, 504, '519128142945,CC75E2B8C004,A8F5DDEACB65,B0935BEB3E96,BC644BD1E6E5,BC644BC655BE,BC644BDA2805,BC644BD18C54,4C1265E3FF0E,CC75E2BA6DB9,CC75E2BAE226,BC644BE4B374,BC644BD8EBB6,A89FECC46763,F8F532517731,CC75E2B78CE8,CC75E2BDD0F3,BC644BD1CFA2,4C1265EA3F7C,2C584F3677D6,BC644BDFA00F,4C12653E4FB4,BC644BDD6E9D,2C584F30324F,2C584F2F6135,BC644BD0AA69,4C1265E76856,4C1265E78DFE,2C9569EEB2EF,BC644BC61685,BC644BD12F9D,A89FECC11E37,BC644BD0A0E6,A89FECC05E61,F8F53256A6D9,5819F841303C,A89FECBDFBB7,BC644BDF1C61,2C584F3130C8,BC644BCD2547', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:13:42 Duration: 8s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 11m5s 23 19s223ms 53s422ms 28s919ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 19 07 1 49s694ms 49s694ms 08 4 1m28s 22s141ms 09 2 54s745ms 27s372ms 10 1 27s16ms 27s16ms 11 2 51s870ms 25s935ms 13 1 27s603ms 27s603ms 14 10 5m10s 31s21ms 15 2 55s433ms 27s716ms [ User: intelifix - Total duration: 11m5s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 11m5s - Times executed: 23 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-19', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-19 14:23:26 Duration: 53s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-19', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-19 07:45:20 Duration: 49s694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-19', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-19 14:02:28 Duration: 40s727ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 10m47s 32 410ms 57s653ms 20s227ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 19 07 2 54s253ms 27s126ms 08 2 35s662ms 17s831ms 09 2 55s299ms 27s649ms 10 2 36s40ms 18s20ms 11 2 36s992ms 18s496ms 12 2 31s876ms 15s938ms 13 2 30s246ms 15s123ms 14 2 49s294ms 24s647ms 15 2 51s203ms 25s601ms 16 2 54s396ms 27s198ms 17 2 32s902ms 16s451ms 18 2 35s906ms 17s953ms 19 2 28s171ms 14s85ms 20 2 58s943ms 29s471ms 21 2 28s960ms 14s480ms 22 2 27s129ms 13s564ms [ User: intelifix - Total duration: 10m47s - Times executed: 32 ]
[ Application: psql - Total duration: 10m47s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-19 20:13:00 Duration: 57s653ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-19 09:15:35 Duration: 54s281ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-19 07:15:48 Duration: 53s70ms Database: rio User: intelifix Remote: [local] Application: psql
6 10m9s 3 458ms 7m59s 3m23s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 19 05 3 10m9s 3m23s [ User: intelifix - Total duration: 10m9s - Times executed: 3 ]
[ Application: psql - Total duration: 10m9s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-19 05:08:01 Duration: 7m59s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-19 05:10:10 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-19 05:08:01 Duration: 458ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 8m1s 43 8s248ms 35s760ms 11s193ms create table temp0000283028 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 19 07 5 1m12s 14s419ms 08 17 2m46s 9s786ms 09 11 2m9s 11s817ms 10 4 41s773ms 10s443ms 11 6 1m11s 11s846ms [ User: intelifix - Total duration: 8m1s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m1s - Times executed: 43 ]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 07:12:51 Duration: 35s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 09:10:02 Duration: 13s465ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 09:09:40 Duration: 13s52ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m20s 938 151ms 1s950ms 469ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 19 06 10 7s727ms 772ms 07 200 1m41s 507ms 08 121 53s304ms 440ms 09 144 1m8s 472ms 10 146 1m7s 462ms 11 129 49s960ms 387ms 13 66 34s879ms 528ms 14 107 50s10ms 467ms 15 15 7s574ms 504ms [ User: intelifix - Total duration: 7m20s - Times executed: 938 ]
[ Application: [unknown] - Total duration: 7m20s - Times executed: 938 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255890", "modelo" : "464", "itens" : "241762551325,241742869920,241742973241,241743251428,241759591833,241747397892,241742936772,241739503441,241742834159,241742801429,241768009196,241740758401,241739515462,241778647485,241747445675,241768086881,241746553456,241759661739,241744499393,241764492749,241764480021,241743285168,241745664345,241739649011,241776518994,241740287692,241744283537,241744701738,241742866586,241762805468,241743183845,241743235466,241744278283,241738769395,241762508794,241739658103,241768029502,241738724465,241743221829,241765603351,241765494249,241759725964,241747343544,241771214347,241744339704,241768054959,241746634350,241767910423", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-19 10:02:29 Duration: 1s950ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255739", "modelo" : "320", "itens" : "241651697789,241630155474,230048582934,241711604545,241666093841,241672117178,241704259798,241732915368,241663060426,241682718594,241649833242,241649833141,241691364242,241635989500,241614851523,241652161932,241678314046,241664784656,241654387277,241628844953,241716689800,241730236868,241674170208,241651076685,241646183346,241713882041,241638393955,241712253352,241630118703,241674125152,241663128792,241727339908,241646493253,241694419703,241628252741,241707047680,241595721418,241706821116,241614614956,241680503351,241716679596,241727259192,241706536688,241716471216,241650463135,241708117594,241616877679,241622478900", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-19 07:08:14 Duration: 1s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "256261", "modelo" : "320", "itens" : "241711614142,241620027897,241606125766,241592581022,241618635674,241593165556,241604967886,241670073747,230057069294,241651082141,241614848996,241669933453,241629339198,241656964656,241706669709,241597375866,241694094767,241645852124,241603257394,241635932525,241592596477,241631792020,241617999191,241649237089,241604256672,241609141022,241607972939,241593221320,241670063948,241637835258,241635962831,241661538491,241627863859,230048692642,241635830720,241629335461,241599584668,241634904860,241628864248,241628874956,241597569094,230048923955,241615157994,241711630508,241657096464,241698684766,241658918001,241672136069", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-19 14:50:21 Duration: 1s942ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7m2s 138 2s159ms 11s630ms 3s62ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 19 00 6 20s852ms 3s475ms 01 6 17s671ms 2s945ms 02 6 16s887ms 2s814ms 03 6 17s823ms 2s970ms 04 6 16s187ms 2s697ms 05 6 14s279ms 2s379ms 06 6 15s113ms 2s518ms 07 6 16s417ms 2s736ms 08 6 17s453ms 2s908ms 09 6 18s392ms 3s65ms 10 6 18s140ms 3s23ms 11 6 19s941ms 3s323ms 12 6 16s548ms 2s758ms 13 6 16s662ms 2s777ms 14 6 33s445ms 5s574ms 15 6 25s875ms 4s312ms 16 6 21s585ms 3s597ms 17 6 15s456ms 2s576ms 18 6 16s212ms 2s702ms 19 6 14s498ms 2s416ms 20 6 22s253ms 3s708ms 21 6 15s772ms 2s628ms 22 6 15s171ms 2s528ms [ User: intelifix - Total duration: 7m2s - Times executed: 138 ]
[ Application: psql - Total duration: 7m2s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 15:15:14 Duration: 11s630ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 14:25:19 Duration: 9s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 00:05:27 Duration: 9s64ms Database: rio User: intelifix Remote: [local] Application: psql
10 6m38s 90 212ms 16s693ms 4s424ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 19 00 6 29s209ms 4s868ms 01 6 10s655ms 1s775ms 02 6 9s524ms 1s587ms 03 5 11s487ms 2s297ms 04 6 13s45ms 2s174ms 05 3 5s92ms 1s697ms 06 3 4s690ms 1s563ms 07 6 42s424ms 7s70ms 08 6 46s839ms 7s806ms 09 6 51s636ms 8s606ms 10 6 40s561ms 6s760ms 11 6 42s904ms 7s150ms 12 4 26s16ms 6s504ms 13 1 2s840ms 2s840ms 14 6 35s268ms 5s878ms 15 2 5s645ms 2s822ms 20 1 242ms 242ms 21 5 10s25ms 2s5ms 22 6 10s48ms 1s674ms [ User: intelifix - Total duration: 6m38s - Times executed: 90 ]
[ Application: psql - Total duration: 6m38s - Times executed: 90 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 00:05:17 Duration: 16s693ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 09:55:13 Duration: 11s290ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 09:25:12 Duration: 10s869ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m11s 31 8s392ms 12s888ms 10s54ms create table temp0000283024 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 19 07 11 1m49s 9s967ms 08 12 1m54s 9s555ms 09 6 1m2s 10s342ms 10 2 25s327ms 12s663ms [ User: intelifix - Total duration: 5m11s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m11s - Times executed: 31 ]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:02:33 Duration: 12s888ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:01:31 Duration: 12s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 07:28:02 Duration: 11s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m29s 25 9s48ms 14s213ms 10s776ms create table temp0000283074 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 19 09 4 45s549ms 11s387ms 10 20 3m32s 10s610ms 11 1 11s640ms 11s640ms [ User: intelifix - Total duration: 4m29s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m29s - Times executed: 25 ]
-
CREATE TABLE temp0000283074 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:32:31 Duration: 14s213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283074 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:02:50 Duration: 13s244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283074 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:02:26 Duration: 12s320ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m4s 21 8s550ms 45s822ms 11s623ms create table temp0000283140 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 19 15 8 1m49s 13s739ms 16 13 2m14s 10s321ms [ User: intelifix - Total duration: 4m4s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 21 ]
-
CREATE TABLE temp0000283140 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 15:48:43 Duration: 45s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283140 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 16:15:15 Duration: 12s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283140 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 16:10:07 Duration: 12s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m51s 2 1m20s 1m31s 1m25s 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 19 20 1 1m20s 1m20s 23 1 1m31s 1m31s [ User: intelifix - Total duration: 2m51s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m51s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-19 23:39:06 Duration: 1m31s 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-19 20:08:14 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
15 2m50s 15 8s500ms 14s832ms 11s399ms create table temp0000282535 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 19 10 4 42s175ms 10s543ms 11 4 45s411ms 11s352ms 13 4 48s303ms 12s75ms 14 3 35s99ms 11s699ms [ User: intelifix - Total duration: 2m50s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 15 ]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 13:55:36 Duration: 14s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:25:07 Duration: 14s559ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:40:29 Duration: 12s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m37s 528 150ms 1s744ms 298ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 19 08 63 12s197ms 193ms 09 64 18s759ms 293ms 10 8 2s571ms 321ms 11 51 14s469ms 283ms 13 117 40s111ms 342ms 14 225 1m9s 308ms [ User: intelifix - Total duration: 2m37s - Times executed: 528 ]
[ Application: [unknown] - Total duration: 2m37s - Times executed: 528 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42841","seriais":"216949439201","usuario":"406","observacao":""}');
Date: 2026-06-19 14:23:09 Duration: 1s744ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"5872C98E81D3,D831399866FC,4896D9534662,3CF9F0A29508,4896D955F0B8,C4EBFF891B94,3CF9F0A29202,C4EBFF8927D6,4896D95AE0BA,843C991F6AC9,F4E84F86F09C,D83139A114C4,48D6823AC210,3891484BE5F9,48D6823A90E4,14CA56D71F95,D8313923884E,38914850FE81,3CF9F0AC007E,D83139A10F48,D89A0DA63D0B,5872C98B1765,D89A0DA48A95,6C11BA691B93,3891484F6C87,3CF9F0A9AAC4,D83139A0D642,3CF9F0A61584","usuario":"416","observacao":""}');
Date: 2026-06-19 14:04:26 Duration: 1s68ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"216777593339,216492348889,216745063453,216712184767,216484000523,216765160813,216426964159,216580123450,216743579907,216578234657,216744211013,216474373253,216466716983,216578878591,216765760827,216462787789,216782144041,216454311127,216806194660,216773939705","usuario":"416","observacao":""}');
Date: 2026-06-19 14:04:19 Duration: 1s24ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 2m11s 12 9s734ms 12s939ms 10s939ms create table temp0000283092 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 19 11 6 1m8s 11s461ms 14 6 1m2s 10s416ms [ User: intelifix - Total duration: 2m11s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m11s - Times executed: 12 ]
-
CREATE TABLE temp0000283092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:43:59 Duration: 12s939ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:44:54 Duration: 11s626ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:43:24 Duration: 11s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m9s 13 8s883ms 11s407ms 9s978ms create table temp0000283104 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 19 12 13 2m9s 9s978ms [ User: intelifix - Total duration: 2m9s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 13 ]
-
CREATE TABLE temp0000283104 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 12:07:38 Duration: 11s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283104 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 12:30:10 Duration: 11s365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283104 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 12:26:06 Duration: 11s118ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m5s 62 152ms 15s412ms 2s16ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 19 07 11 6s173ms 561ms 08 13 21s98ms 1s622ms 09 8 5s335ms 666ms 10 10 44s137ms 4s413ms 11 4 1s900ms 475ms 12 5 10s407ms 2s81ms 13 1 2s544ms 2s544ms 14 3 11s224ms 3s741ms 15 3 4s824ms 1s608ms 16 4 17s359ms 4s339ms [ User: intelifix - Total duration: 2m5s - Times executed: 62 ]
[ Application: psql - Total duration: 2m5s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025863);
Date: 2026-06-19 08:55:51 Duration: 15s412ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025879);
Date: 2026-06-19 10:44:25 Duration: 14s483ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025874);
Date: 2026-06-19 10:11:54 Duration: 10s465ms Database: rio User: intelifix Remote: [local] Application: psql
20 2m3s 2 24s258ms 1m39s 1m1s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 19 23 2 2m3s 1m1s [ User: intelifix - Total duration: 2m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-19 23:14:17 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-19 23:40:36 Duration: 24s258ms Database: contagem 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,001 20m23s 150ms 2m27s 1s222ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 19 07 94 1m46s 1s135ms 08 120 4m7s 2s65ms 09 131 2m7s 975ms 10 112 1m56s 1s44ms 11 120 2m46s 1s387ms 12 29 25s83ms 864ms 13 71 1m19s 1s119ms 14 172 3m1s 1s52ms 15 94 1m50s 1s174ms 16 21 31s225ms 1s486ms 17 37 30s17ms 811ms [ User: intelifix - Total duration: 20m23s - Times executed: 1001 ]
[ Application: [unknown] - Total duration: 20m23s - Times executed: 1001 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255803, 184, '919121099568,8020DA4D1D0A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-19 08:09:22 Duration: 2m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255062, 449, '71628885850029601179,216703633854,216558740118,216409105962,216635166262,216833544759,216361239292,216868829314,216355040103,216618682028,216868307287,216756245363,216837020823,216699812224,216507584451,216511663233,216908547690', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:49:10 Duration: 9s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255064, 504, '519128142945,CC75E2B8C004,A8F5DDEACB65,B0935BEB3E96,BC644BD1E6E5,BC644BC655BE,BC644BDA2805,BC644BD18C54,4C1265E3FF0E,CC75E2BA6DB9,CC75E2BAE226,BC644BE4B374,BC644BD8EBB6,A89FECC46763,F8F532517731,CC75E2B78CE8,CC75E2BDD0F3,BC644BD1CFA2,4C1265EA3F7C,2C584F3677D6,BC644BDFA00F,4C12653E4FB4,BC644BDD6E9D,2C584F30324F,2C584F2F6135,BC644BD0AA69,4C1265E76856,4C1265E78DFE,2C9569EEB2EF,BC644BC61685,BC644BD12F9D,A89FECC11E37,BC644BD0A0E6,A89FECC05E61,F8F53256A6D9,5819F841303C,A89FECBDFBB7,BC644BDF1C61,2C584F3130C8,BC644BCD2547', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:13:42 Duration: 8s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 938 7m20s 151ms 1s950ms 469ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 19 06 10 7s727ms 772ms 07 200 1m41s 507ms 08 121 53s304ms 440ms 09 144 1m8s 472ms 10 146 1m7s 462ms 11 129 49s960ms 387ms 13 66 34s879ms 528ms 14 107 50s10ms 467ms 15 15 7s574ms 504ms [ User: intelifix - Total duration: 7m20s - Times executed: 938 ]
[ Application: [unknown] - Total duration: 7m20s - Times executed: 938 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255890", "modelo" : "464", "itens" : "241762551325,241742869920,241742973241,241743251428,241759591833,241747397892,241742936772,241739503441,241742834159,241742801429,241768009196,241740758401,241739515462,241778647485,241747445675,241768086881,241746553456,241759661739,241744499393,241764492749,241764480021,241743285168,241745664345,241739649011,241776518994,241740287692,241744283537,241744701738,241742866586,241762805468,241743183845,241743235466,241744278283,241738769395,241762508794,241739658103,241768029502,241738724465,241743221829,241765603351,241765494249,241759725964,241747343544,241771214347,241744339704,241768054959,241746634350,241767910423", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-19 10:02:29 Duration: 1s950ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255739", "modelo" : "320", "itens" : "241651697789,241630155474,230048582934,241711604545,241666093841,241672117178,241704259798,241732915368,241663060426,241682718594,241649833242,241649833141,241691364242,241635989500,241614851523,241652161932,241678314046,241664784656,241654387277,241628844953,241716689800,241730236868,241674170208,241651076685,241646183346,241713882041,241638393955,241712253352,241630118703,241674125152,241663128792,241727339908,241646493253,241694419703,241628252741,241707047680,241595721418,241706821116,241614614956,241680503351,241716679596,241727259192,241706536688,241716471216,241650463135,241708117594,241616877679,241622478900", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-19 07:08:14 Duration: 1s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "256261", "modelo" : "320", "itens" : "241711614142,241620027897,241606125766,241592581022,241618635674,241593165556,241604967886,241670073747,230057069294,241651082141,241614848996,241669933453,241629339198,241656964656,241706669709,241597375866,241694094767,241645852124,241603257394,241635932525,241592596477,241631792020,241617999191,241649237089,241604256672,241609141022,241607972939,241593221320,241670063948,241637835258,241635962831,241661538491,241627863859,230048692642,241635830720,241629335461,241599584668,241634904860,241628864248,241628874956,241597569094,230048923955,241615157994,241711630508,241657096464,241698684766,241658918001,241672136069", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-19 14:50:21 Duration: 1s942ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 528 2m37s 150ms 1s744ms 298ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 19 08 63 12s197ms 193ms 09 64 18s759ms 293ms 10 8 2s571ms 321ms 11 51 14s469ms 283ms 13 117 40s111ms 342ms 14 225 1m9s 308ms [ User: intelifix - Total duration: 2m37s - Times executed: 528 ]
[ Application: [unknown] - Total duration: 2m37s - Times executed: 528 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42841","seriais":"216949439201","usuario":"406","observacao":""}');
Date: 2026-06-19 14:23:09 Duration: 1s744ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"5872C98E81D3,D831399866FC,4896D9534662,3CF9F0A29508,4896D955F0B8,C4EBFF891B94,3CF9F0A29202,C4EBFF8927D6,4896D95AE0BA,843C991F6AC9,F4E84F86F09C,D83139A114C4,48D6823AC210,3891484BE5F9,48D6823A90E4,14CA56D71F95,D8313923884E,38914850FE81,3CF9F0AC007E,D83139A10F48,D89A0DA63D0B,5872C98B1765,D89A0DA48A95,6C11BA691B93,3891484F6C87,3CF9F0A9AAC4,D83139A0D642,3CF9F0A61584","usuario":"416","observacao":""}');
Date: 2026-06-19 14:04:26 Duration: 1s68ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"216777593339,216492348889,216745063453,216712184767,216484000523,216765160813,216426964159,216580123450,216743579907,216578234657,216744211013,216474373253,216466716983,216578878591,216765760827,216462787789,216782144041,216454311127,216806194660,216773939705","usuario":"416","observacao":""}');
Date: 2026-06-19 14:04:19 Duration: 1s24ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 190 2h26m5s 150ms 7m16s 46s132ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 19 07 8 5m10s 38s872ms 08 21 13m24s 38s297ms 09 29 15m10s 31s381ms 10 21 12m14s 34s966ms 11 15 8m39s 34s643ms 12 13 10m12s 47s122ms 13 20 16m27s 49s398ms 14 31 23m51s 46s192ms 15 16 24m30s 1m31s 16 12 16m8s 1m20s 17 4 15s186ms 3s796ms [ User: intelifix - Total duration: 2h26m5s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 2h26m5s - Times executed: 190 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 13:46:53 Duration: 7m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-03-01''),DATE(''2026-03-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 14:01:47 Duration: 6m43s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 16:00:37 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 152 42s924ms 152ms 4s977ms 282ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 19 01 24 5s631ms 234ms 04 17 4s813ms 283ms 05 9 2s574ms 286ms 07 6 6s269ms 1s44ms 08 11 2s331ms 211ms 09 16 3s465ms 216ms 10 18 3s934ms 218ms 11 20 4s2ms 200ms 12 3 659ms 219ms 13 1 267ms 267ms 14 18 7s55ms 391ms 15 9 1s918ms 213ms [ User: intelifix - Total duration: 42s924ms - Times executed: 152 ]
[ Application: [unknown] - Total duration: 42s924ms - Times executed: 152 ]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229796328898,229850011939,229725610202,229803537492,229796348799,229791607900,229867376674', NULL, NULL, 0145, 00);
Date: 2026-06-19 07:49:09 Duration: 4s977ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '63', 2, '216391568808,216434896066,216421894663', NULL, NULL, 034, 00);
Date: 2026-06-19 14:23:09 Duration: 2s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241615165672,241674161823,241630934046,241678262930,241712584854,241652342937,241652343745,241649378191,241658296974,241655141325,241658253738,241629962930,241694165155,241666645567,241657621926,241713861332,241652188297,241663167685,241730204161,241674149700', NULL, NULL, 0320, 00);
Date: 2026-06-19 04:20:20 Duration: 445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 138 7m2s 2s159ms 11s630ms 3s62ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 19 00 6 20s852ms 3s475ms 01 6 17s671ms 2s945ms 02 6 16s887ms 2s814ms 03 6 17s823ms 2s970ms 04 6 16s187ms 2s697ms 05 6 14s279ms 2s379ms 06 6 15s113ms 2s518ms 07 6 16s417ms 2s736ms 08 6 17s453ms 2s908ms 09 6 18s392ms 3s65ms 10 6 18s140ms 3s23ms 11 6 19s941ms 3s323ms 12 6 16s548ms 2s758ms 13 6 16s662ms 2s777ms 14 6 33s445ms 5s574ms 15 6 25s875ms 4s312ms 16 6 21s585ms 3s597ms 17 6 15s456ms 2s576ms 18 6 16s212ms 2s702ms 19 6 14s498ms 2s416ms 20 6 22s253ms 3s708ms 21 6 15s772ms 2s628ms 22 6 15s171ms 2s528ms [ User: intelifix - Total duration: 7m2s - Times executed: 138 ]
[ Application: psql - Total duration: 7m2s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 15:15:14 Duration: 11s630ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 14:25:19 Duration: 9s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 00:05:27 Duration: 9s64ms Database: rio User: intelifix Remote: [local] Application: psql
7 90 6m38s 212ms 16s693ms 4s424ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 19 00 6 29s209ms 4s868ms 01 6 10s655ms 1s775ms 02 6 9s524ms 1s587ms 03 5 11s487ms 2s297ms 04 6 13s45ms 2s174ms 05 3 5s92ms 1s697ms 06 3 4s690ms 1s563ms 07 6 42s424ms 7s70ms 08 6 46s839ms 7s806ms 09 6 51s636ms 8s606ms 10 6 40s561ms 6s760ms 11 6 42s904ms 7s150ms 12 4 26s16ms 6s504ms 13 1 2s840ms 2s840ms 14 6 35s268ms 5s878ms 15 2 5s645ms 2s822ms 20 1 242ms 242ms 21 5 10s25ms 2s5ms 22 6 10s48ms 1s674ms [ User: intelifix - Total duration: 6m38s - Times executed: 90 ]
[ Application: psql - Total duration: 6m38s - Times executed: 90 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 00:05:17 Duration: 16s693ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 09:55:13 Duration: 11s290ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 09:25:12 Duration: 10s869ms Database: rio User: intelifix Remote: [local] Application: psql
8 87 37s970ms 282ms 754ms 436ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 19 00 1 503ms 503ms 01 3 1s226ms 408ms 04 2 800ms 400ms 05 2 803ms 401ms 06 3 1s189ms 396ms 07 5 2s92ms 418ms 08 10 4s194ms 419ms 09 9 4s50ms 450ms 10 8 3s340ms 417ms 11 8 3s840ms 480ms 12 3 1s201ms 400ms 13 10 4s732ms 473ms 14 8 3s627ms 453ms 15 8 3s359ms 419ms 16 4 1s659ms 414ms 17 2 940ms 470ms 21 1 406ms 406ms [ User: lenon - Total duration: 37s970ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 37s970ms - Times executed: 87 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-19 13:50:46 Duration: 754ms 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-19 08:05:36 Duration: 644ms 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-19 11:21:54 Duration: 642ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 83 16s417ms 150ms 622ms 197ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 19 01 1 186ms 186ms 06 1 622ms 622ms 08 1 153ms 153ms 09 2 469ms 234ms 10 11 1s932ms 175ms 11 11 1s954ms 177ms 12 5 916ms 183ms 13 14 2s637ms 188ms 14 25 4s994ms 199ms 15 12 2s551ms 212ms [ User: intelifix - Total duration: 16s417ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 16s417ms - Times executed: 83 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-18", "data-ate" : "2026-06-18", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-19 06:52:58 Duration: 622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-19", "data-ate" : "2026-06-19", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-19 14:48:14 Duration: 463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "396", "data-de" : "2026-06-19", "data-ate" : "2026-06-19", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 450 }');
Date: 2026-06-19 15:22:06 Duration: 340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 81 43s770ms 356ms 847ms 540ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 19 00 1 573ms 573ms 01 3 1s564ms 521ms 04 2 1s7ms 503ms 05 1 518ms 518ms 06 2 1s14ms 507ms 07 5 2s506ms 501ms 08 9 4s569ms 507ms 09 9 4s988ms 554ms 10 8 4s301ms 537ms 11 8 4s607ms 575ms 12 3 1s540ms 513ms 13 9 5s338ms 593ms 14 8 4s396ms 549ms 15 8 4s62ms 507ms 16 3 1s629ms 543ms 17 2 1s151ms 575ms [ User: intelifix - Total duration: 43s770ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 43s770ms - Times executed: 81 ]
-
select * from rs_menu_grants (416, 19, 1);
Date: 2026-06-19 13:50:46 Duration: 847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (99, 57, 1);
Date: 2026-06-19 14:44:22 Duration: 765ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 72, 1);
Date: 2026-06-19 09:11:02 Duration: 750ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 76 12s445ms 150ms 208ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 19 07 12 2s12ms 167ms 08 7 1s114ms 159ms 09 9 1s414ms 157ms 10 13 2s164ms 166ms 11 15 2s423ms 161ms 13 7 1s174ms 167ms 14 11 1s809ms 164ms 15 2 331ms 165ms [ User: intelifix - Total duration: 12s445ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 12s445ms - Times executed: 76 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-06-19 13:52:50 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-19 07:05:36 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0320;
Date: 2026-06-19 07:05:51 Duration: 195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 74 1m44s 167ms 12s138ms 1s415ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 19 09 13 11s858ms 912ms 10 6 2s415ms 402ms 11 9 7s825ms 869ms 13 13 8s446ms 649ms 14 24 31s525ms 1s313ms 15 6 20s143ms 3s357ms 17 3 22s561ms 7s520ms [ User: intelifix - Total duration: 1m44s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 74 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-19 14:59:38 Duration: 12s138ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-19 17:45:31 Duration: 11s180ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-19 17:44:27 Duration: 10s471ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 62 2m5s 152ms 15s412ms 2s16ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 19 07 11 6s173ms 561ms 08 13 21s98ms 1s622ms 09 8 5s335ms 666ms 10 10 44s137ms 4s413ms 11 4 1s900ms 475ms 12 5 10s407ms 2s81ms 13 1 2s544ms 2s544ms 14 3 11s224ms 3s741ms 15 3 4s824ms 1s608ms 16 4 17s359ms 4s339ms [ User: intelifix - Total duration: 2m5s - Times executed: 62 ]
[ Application: psql - Total duration: 2m5s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025863);
Date: 2026-06-19 08:55:51 Duration: 15s412ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025879);
Date: 2026-06-19 10:44:25 Duration: 14s483ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025874);
Date: 2026-06-19 10:11:54 Duration: 10s465ms Database: rio User: intelifix Remote: [local] Application: psql
14 61 23s741ms 199ms 863ms 389ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 19 07 7 3s72ms 438ms 08 15 5s561ms 370ms 09 7 2s882ms 411ms 10 9 3s434ms 381ms 11 4 1s396ms 349ms 12 6 2s94ms 349ms 13 3 1s231ms 410ms 14 2 798ms 399ms 15 4 1s824ms 456ms 16 4 1s445ms 361ms [ User: intelifix - Total duration: 23s741ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 23s741ms - Times executed: 61 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-06-19 15:10:06 Duration: 863ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-19 09:41:08 Duration: 635ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-19 07:05:50 Duration: 583ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 60 11s734ms 153ms 561ms 195ms create table temp0000283024 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 19 07 6 1s414ms 235ms 08 3 573ms 191ms 09 11 2s100ms 190ms 10 12 2s316ms 193ms 11 28 5s328ms 190ms [ User: intelifix - Total duration: 11s734ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 11s734ms - Times executed: 60 ]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-17', '2026-06-19');
Date: 2026-06-19 07:20:50 Duration: 561ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-17', '2026-06-19');
Date: 2026-06-19 10:16:36 Duration: 254ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-17', '2026-06-19');
Date: 2026-06-19 09:04:57 Duration: 245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 51 10s504ms 151ms 332ms 205ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 19 07 6 1s556ms 259ms 08 6 1s356ms 226ms 09 19 3s394ms 178ms 10 16 3s174ms 198ms 11 3 784ms 261ms 17 1 238ms 238ms [ User: intelifix - Total duration: 10s504ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 10s504ms - Times executed: 51 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"46", "usuario" :"184", "tipo" :"N", "itens" :"01", "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-19 10:02:59 Duration: 332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"316", "usuario" :"507", "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-19 10:56:22 Duration: 328ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"302", "usuario" :"413", "tipo" :"N", "itens" :"02", "nota-fiscal" :"10496", "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-19 08:43:17 Duration: 319ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 46 8s609ms 150ms 273ms 187ms create table temp0000282535 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 19 06 1 170ms 170ms 08 2 316ms 158ms 09 11 1s936ms 176ms 10 13 2s526ms 194ms 11 10 1s896ms 189ms 12 3 547ms 182ms 13 2 426ms 213ms 14 4 788ms 197ms [ User: intelifix - Total duration: 8s609ms - Times executed: 46 ]
[ Application: [unknown] - Total duration: 8s609ms - Times executed: 46 ]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"14-06-2026", "ate" :"19-06-2026", "nota-fiscal":"1088", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-19 09:42:28 Duration: 273ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"14-06-2026", "ate" :"19-06-2026", "nota-fiscal":"1088", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-19 10:01:39 Duration: 246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"14-06-2026", "ate" :"19-06-2026", "nota-fiscal":"1088", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-19 13:55:14 Duration: 236ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 43 8m1s 8s248ms 35s760ms 11s193ms create table temp0000283028 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 19 07 5 1m12s 14s419ms 08 17 2m46s 9s786ms 09 11 2m9s 11s817ms 10 4 41s773ms 10s443ms 11 6 1m11s 11s846ms [ User: intelifix - Total duration: 8m1s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m1s - Times executed: 43 ]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 07:12:51 Duration: 35s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 09:10:02 Duration: 13s465ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 09:09:40 Duration: 13s52ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 41 1m13s 162ms 9s337ms 1s784ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 19 07 4 14s798ms 3s699ms 08 9 15s411ms 1s712ms 09 7 12s311ms 1s758ms 10 7 10s229ms 1s461ms 11 2 4s699ms 2s349ms 12 5 2s458ms 491ms 13 1 235ms 235ms 14 2 10s541ms 5s270ms 15 1 977ms 977ms 16 3 1s498ms 499ms [ User: intelifix - Total duration: 1m13s - Times executed: 41 ]
[ Application: psql - Total duration: 1m13s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025840);
Date: 2026-06-19 07:14:38 Duration: 9s337ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025894);
Date: 2026-06-19 14:19:05 Duration: 8s803ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025871);
Date: 2026-06-19 09:50:52 Duration: 4s664ms Database: rio User: intelifix Remote: [local] Application: psql
20 39 9s641ms 162ms 623ms 247ms create table temp0000226442 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 19 08 1 307ms 307ms 09 7 1s373ms 196ms 10 6 1s306ms 217ms 11 6 1s168ms 194ms 13 9 2s43ms 227ms 14 7 2s23ms 289ms 15 2 976ms 488ms 16 1 441ms 441ms [ User: intelifix - Total duration: 9s641ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 9s641ms - Times executed: 39 ]
-
CREATE TABLE temp0000226442 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"14-06-2026", "ate" :"19-06-2026", "nota-fiscal":"2796", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-19 15:23:19 Duration: 623ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226442 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"14-06-2026", "ate" :"19-06-2026", "nota-fiscal":"1539", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-19 16:07:39 Duration: 441ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226442 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"14-06-2026", "ate" :"19-06-2026", "nota-fiscal":"2796", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-19 14:25:26 Duration: 371ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s101ms 9m52s 3m33s 32 1h53m54s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 19 07 2 9m55s 4m57s 08 2 6m12s 3m6s 09 2 9m43s 4m51s 10 2 6m50s 3m25s 11 2 7m39s 3m49s 12 2 6m41s 3m20s 13 2 5m43s 2m51s 14 2 8m39s 4m19s 15 2 8m55s 4m27s 16 2 7m42s 3m51s 17 2 6m20s 3m10s 18 2 6m16s 3m8s 19 2 5m29s 2m44s 20 2 7m4s 3m32s 21 2 5m19s 2m39s 22 2 5m21s 2m40s [ User: intelifix - Total duration: 1h53m54s - Times executed: 32 ]
[ Application: psql - Total duration: 1h53m54s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-19 07:14:54 Duration: 9m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-19 09:14:41 Duration: 9m39s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-19 15:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql
2 458ms 7m59s 3m23s 3 10m9s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 19 05 3 10m9s 3m23s [ User: intelifix - Total duration: 10m9s - Times executed: 3 ]
[ Application: psql - Total duration: 10m9s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-19 05:08:01 Duration: 7m59s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-19 05:10:10 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-19 05:08:01 Duration: 458ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 1m20s 1m31s 1m25s 2 2m51s 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 19 20 1 1m20s 1m20s 23 1 1m31s 1m31s [ User: intelifix - Total duration: 2m51s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m51s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-19 23:39:06 Duration: 1m31s 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-19 20:08:14 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 24s258ms 1m39s 1m1s 2 2m3s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 19 23 2 2m3s 1m1s [ User: intelifix - Total duration: 2m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-19 23:14:17 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-19 23:40:36 Duration: 24s258ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 150ms 7m16s 46s132ms 190 2h26m5s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 19 07 8 5m10s 38s872ms 08 21 13m24s 38s297ms 09 29 15m10s 31s381ms 10 21 12m14s 34s966ms 11 15 8m39s 34s643ms 12 13 10m12s 47s122ms 13 20 16m27s 49s398ms 14 31 23m51s 46s192ms 15 16 24m30s 1m31s 16 12 16m8s 1m20s 17 4 15s186ms 3s796ms [ User: intelifix - Total duration: 2h26m5s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 2h26m5s - Times executed: 190 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 13:46:53 Duration: 7m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-03-01''),DATE(''2026-03-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 14:01:47 Duration: 6m43s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-19 16:00:37 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 19s223ms 53s422ms 28s919ms 23 11m5s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 19 07 1 49s694ms 49s694ms 08 4 1m28s 22s141ms 09 2 54s745ms 27s372ms 10 1 27s16ms 27s16ms 11 2 51s870ms 25s935ms 13 1 27s603ms 27s603ms 14 10 5m10s 31s21ms 15 2 55s433ms 27s716ms [ User: intelifix - Total duration: 11m5s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 11m5s - Times executed: 23 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-19', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-19 14:23:26 Duration: 53s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-19', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-19 07:45:20 Duration: 49s694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-19', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-19 14:02:28 Duration: 40s727ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 410ms 57s653ms 20s227ms 32 10m47s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 19 07 2 54s253ms 27s126ms 08 2 35s662ms 17s831ms 09 2 55s299ms 27s649ms 10 2 36s40ms 18s20ms 11 2 36s992ms 18s496ms 12 2 31s876ms 15s938ms 13 2 30s246ms 15s123ms 14 2 49s294ms 24s647ms 15 2 51s203ms 25s601ms 16 2 54s396ms 27s198ms 17 2 32s902ms 16s451ms 18 2 35s906ms 17s953ms 19 2 28s171ms 14s85ms 20 2 58s943ms 29s471ms 21 2 28s960ms 14s480ms 22 2 27s129ms 13s564ms [ User: intelifix - Total duration: 10m47s - Times executed: 32 ]
[ Application: psql - Total duration: 10m47s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-19 20:13:00 Duration: 57s653ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-19 09:15:35 Duration: 54s281ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-19 07:15:48 Duration: 53s70ms Database: rio User: intelifix Remote: [local] Application: psql
8 8s550ms 45s822ms 11s623ms 21 4m4s create table temp0000283140 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 19 15 8 1m49s 13s739ms 16 13 2m14s 10s321ms [ User: intelifix - Total duration: 4m4s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 21 ]
-
CREATE TABLE temp0000283140 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 15:48:43 Duration: 45s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283140 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 16:15:15 Duration: 12s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283140 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 16:10:07 Duration: 12s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8s500ms 14s832ms 11s399ms 15 2m50s create table temp0000282535 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 19 10 4 42s175ms 10s543ms 11 4 45s411ms 11s352ms 13 4 48s303ms 12s75ms 14 3 35s99ms 11s699ms [ User: intelifix - Total duration: 2m50s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 15 ]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 13:55:36 Duration: 14s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:25:07 Duration: 14s559ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:40:29 Duration: 12s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s248ms 35s760ms 11s193ms 43 8m1s create table temp0000283028 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 19 07 5 1m12s 14s419ms 08 17 2m46s 9s786ms 09 11 2m9s 11s817ms 10 4 41s773ms 10s443ms 11 6 1m11s 11s846ms [ User: intelifix - Total duration: 8m1s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m1s - Times executed: 43 ]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 07:12:51 Duration: 35s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 09:10:02 Duration: 13s465ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283028 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 09:09:40 Duration: 13s52ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s734ms 12s939ms 10s939ms 12 2m11s create table temp0000283092 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 19 11 6 1m8s 11s461ms 14 6 1m2s 10s416ms [ User: intelifix - Total duration: 2m11s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m11s - Times executed: 12 ]
-
CREATE TABLE temp0000283092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:43:59 Duration: 12s939ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:44:54 Duration: 11s626ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 11:43:24 Duration: 11s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s48ms 14s213ms 10s776ms 25 4m29s create table temp0000283074 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 19 09 4 45s549ms 11s387ms 10 20 3m32s 10s610ms 11 1 11s640ms 11s640ms [ User: intelifix - Total duration: 4m29s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m29s - Times executed: 25 ]
-
CREATE TABLE temp0000283074 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:32:31 Duration: 14s213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283074 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:02:50 Duration: 13s244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283074 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:02:26 Duration: 12s320ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s392ms 12s888ms 10s54ms 31 5m11s create table temp0000283024 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 19 07 11 1m49s 9s967ms 08 12 1m54s 9s555ms 09 6 1m2s 10s342ms 10 2 25s327ms 12s663ms [ User: intelifix - Total duration: 5m11s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m11s - Times executed: 31 ]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:02:33 Duration: 12s888ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 10:01:31 Duration: 12s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283024 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 07:28:02 Duration: 11s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 8s883ms 11s407ms 9s978ms 13 2m9s create table temp0000283104 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 19 12 13 2m9s 9s978ms [ User: intelifix - Total duration: 2m9s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 13 ]
-
CREATE TABLE temp0000283104 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 12:07:38 Duration: 11s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283104 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 12:30:10 Duration: 11s365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283104 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-19 12:26:06 Duration: 11s118ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 212ms 16s693ms 4s424ms 90 6m38s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 19 00 6 29s209ms 4s868ms 01 6 10s655ms 1s775ms 02 6 9s524ms 1s587ms 03 5 11s487ms 2s297ms 04 6 13s45ms 2s174ms 05 3 5s92ms 1s697ms 06 3 4s690ms 1s563ms 07 6 42s424ms 7s70ms 08 6 46s839ms 7s806ms 09 6 51s636ms 8s606ms 10 6 40s561ms 6s760ms 11 6 42s904ms 7s150ms 12 4 26s16ms 6s504ms 13 1 2s840ms 2s840ms 14 6 35s268ms 5s878ms 15 2 5s645ms 2s822ms 20 1 242ms 242ms 21 5 10s25ms 2s5ms 22 6 10s48ms 1s674ms [ User: intelifix - Total duration: 6m38s - Times executed: 90 ]
[ Application: psql - Total duration: 6m38s - Times executed: 90 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 00:05:17 Duration: 16s693ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 09:55:13 Duration: 11s290ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-19 09:25:12 Duration: 10s869ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s159ms 11s630ms 3s62ms 138 7m2s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 19 00 6 20s852ms 3s475ms 01 6 17s671ms 2s945ms 02 6 16s887ms 2s814ms 03 6 17s823ms 2s970ms 04 6 16s187ms 2s697ms 05 6 14s279ms 2s379ms 06 6 15s113ms 2s518ms 07 6 16s417ms 2s736ms 08 6 17s453ms 2s908ms 09 6 18s392ms 3s65ms 10 6 18s140ms 3s23ms 11 6 19s941ms 3s323ms 12 6 16s548ms 2s758ms 13 6 16s662ms 2s777ms 14 6 33s445ms 5s574ms 15 6 25s875ms 4s312ms 16 6 21s585ms 3s597ms 17 6 15s456ms 2s576ms 18 6 16s212ms 2s702ms 19 6 14s498ms 2s416ms 20 6 22s253ms 3s708ms 21 6 15s772ms 2s628ms 22 6 15s171ms 2s528ms [ User: intelifix - Total duration: 7m2s - Times executed: 138 ]
[ Application: psql - Total duration: 7m2s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 15:15:14 Duration: 11s630ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 14:25:19 Duration: 9s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-19 00:05:27 Duration: 9s64ms Database: rio User: intelifix Remote: [local] Application: psql
17 152ms 15s412ms 2s16ms 62 2m5s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 19 07 11 6s173ms 561ms 08 13 21s98ms 1s622ms 09 8 5s335ms 666ms 10 10 44s137ms 4s413ms 11 4 1s900ms 475ms 12 5 10s407ms 2s81ms 13 1 2s544ms 2s544ms 14 3 11s224ms 3s741ms 15 3 4s824ms 1s608ms 16 4 17s359ms 4s339ms [ User: intelifix - Total duration: 2m5s - Times executed: 62 ]
[ Application: psql - Total duration: 2m5s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025863);
Date: 2026-06-19 08:55:51 Duration: 15s412ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025879);
Date: 2026-06-19 10:44:25 Duration: 14s483ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025874);
Date: 2026-06-19 10:11:54 Duration: 10s465ms Database: rio User: intelifix Remote: [local] Application: psql
18 162ms 9s337ms 1s784ms 41 1m13s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 19 07 4 14s798ms 3s699ms 08 9 15s411ms 1s712ms 09 7 12s311ms 1s758ms 10 7 10s229ms 1s461ms 11 2 4s699ms 2s349ms 12 5 2s458ms 491ms 13 1 235ms 235ms 14 2 10s541ms 5s270ms 15 1 977ms 977ms 16 3 1s498ms 499ms [ User: intelifix - Total duration: 1m13s - Times executed: 41 ]
[ Application: psql - Total duration: 1m13s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025840);
Date: 2026-06-19 07:14:38 Duration: 9s337ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025894);
Date: 2026-06-19 14:19:05 Duration: 8s803ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025871);
Date: 2026-06-19 09:50:52 Duration: 4s664ms Database: rio User: intelifix Remote: [local] Application: psql
19 167ms 12s138ms 1s415ms 74 1m44s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 19 09 13 11s858ms 912ms 10 6 2s415ms 402ms 11 9 7s825ms 869ms 13 13 8s446ms 649ms 14 24 31s525ms 1s313ms 15 6 20s143ms 3s357ms 17 3 22s561ms 7s520ms [ User: intelifix - Total duration: 1m44s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 74 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-19 14:59:38 Duration: 12s138ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-19 17:45:31 Duration: 11s180ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-19 17:44:27 Duration: 10s471ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 150ms 2m27s 1s222ms 1,001 20m23s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 19 07 94 1m46s 1s135ms 08 120 4m7s 2s65ms 09 131 2m7s 975ms 10 112 1m56s 1s44ms 11 120 2m46s 1s387ms 12 29 25s83ms 864ms 13 71 1m19s 1s119ms 14 172 3m1s 1s52ms 15 94 1m50s 1s174ms 16 21 31s225ms 1s486ms 17 37 30s17ms 811ms [ User: intelifix - Total duration: 20m23s - Times executed: 1001 ]
[ Application: [unknown] - Total duration: 20m23s - Times executed: 1001 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255803, 184, '919121099568,8020DA4D1D0A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-19 08:09:22 Duration: 2m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255062, 449, '71628885850029601179,216703633854,216558740118,216409105962,216635166262,216833544759,216361239292,216868829314,216355040103,216618682028,216868307287,216756245363,216837020823,216699812224,216507584451,216511663233,216908547690', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:49:10 Duration: 9s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255064, 504, '519128142945,CC75E2B8C004,A8F5DDEACB65,B0935BEB3E96,BC644BD1E6E5,BC644BC655BE,BC644BDA2805,BC644BD18C54,4C1265E3FF0E,CC75E2BA6DB9,CC75E2BAE226,BC644BE4B374,BC644BD8EBB6,A89FECC46763,F8F532517731,CC75E2B78CE8,CC75E2BDD0F3,BC644BD1CFA2,4C1265EA3F7C,2C584F3677D6,BC644BDFA00F,4C12653E4FB4,BC644BDD6E9D,2C584F30324F,2C584F2F6135,BC644BD0AA69,4C1265E76856,4C1265E78DFE,2C9569EEB2EF,BC644BC61685,BC644BD12F9D,A89FECC11E37,BC644BD0A0E6,A89FECC05E61,F8F53256A6D9,5819F841303C,A89FECBDFBB7,BC644BDF1C61,2C584F3130C8,BC644BCD2547', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-19 07:13:42 Duration: 8s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 19 20 1 0ms 0ms [ User: intelifix - Total duration: 242ms - Times executed: 1 ]
[ Application: psql - Total duration: 242ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 15,198 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 3364 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,795 Max number of times the same event was reported
- 3,381 Total events found
Rank Times reported Error 1 2,795 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 19 07 212 08 398 09 354 10 332 11 340 12 66 13 111 14 361 15 97 16 81 17 96 18 60 19 59 20 60 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN000000002EE71B30" does not exist
- ERROR: prepared statement "_PLAN000000002EE751F0" does not exist
- ERROR: prepared statement "_PLAN000000002EE751F0" does not exist
Statement: DEALLOCATE "_PLAN000000002EE71B30"
Date: 2026-06-19 07:03:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002EE751F0"
Date: 2026-06-19 07:03:14 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002EE751F0"
Date: 2026-06-19 07:03:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 19 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-19 00:05:27 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-19 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-19 00:25:06 Database: brasilia Application: psql User: intelifix Remote: [local]
3 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 19 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-19 00:05:27 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-19 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-19 00:25:06 Database: brasilia Application: psql User: intelifix Remote: [local]
4 48 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 19 07 29 08 3 09 3 10 13 - ERROR: trailing junk after numeric literal at or near "9B" at character 42
- ERROR: trailing junk after numeric literal at or near "9B" at character 42
- ERROR: trailing junk after numeric literal at or near "9B" at character 42
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-81-CA-9B)
Date: 2026-06-19 07:03:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-81-CA-9B)
Date: 2026-06-19 07:03:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-81-CA-9B)
Date: 2026-06-19 07:03:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 19 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-19 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-19 00:35:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-19 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
6 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 19 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-19 08:00:23 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-19 08:20:06 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-19 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
7 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 19 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES() NOTICE: table "tmp_entrada" does not exist, skippingDate: 2026-06-19 08:00:23 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-19 08:20:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-19 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
8 31 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 19 07 22 10 9 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-97-D0-CC)
Date: 2026-06-19 07:03:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-97-D0-CC)
Date: 2026-06-19 07:03:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-97-D0-CC)
Date: 2026-06-19 07:03:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 31 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 19 07 2 08 2 09 5 11 6 12 7 14 8 15 1 - ERROR: syntax error at or near "[" at character 35
- ERROR: syntax error at or near "[" at character 35
- ERROR: syntax error at or near ":" at character 32
Statement: select * from rs_caixa_qr(3115185 [)
Date: 2026-06-19 07:50:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3115185 [)
Date: 2026-06-19 07:50:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(https://a2techcon.ddns.net/recepcao_lote_carrega.php$1lote=42847&erro=&itens=0#:~:text=3%0A%2D%3E%3E%20Caixa-,111058,-Dados%20do%20Lote)
Date: 2026-06-19 08:51:21 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
10 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 19 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-19 07:15:48 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-19 08:11:45 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-19 09:15:35 Database: brasilia Application: psql User: intelifix Remote: [local]
11 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 19 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-19 07:15:48 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-19 08:11:45 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-19 09:15:35 Database: brasilia Application: psql User: intelifix Remote: [local]
12 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 19 00 1 06 3 10 1 20 1 21 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-19 00:02:18 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-19 06:02:18 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-19 06:06:39 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
13 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 19 05 8 - ERROR: relation "public.equipamentos" does not exist at character 49
- ERROR: relation "public.equipamentos" does not exist
- ERROR: relation "public.codigos_barra" does not exist at character 70
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, mod_id FROM public.equipamentos
Date: 2026-06-19 05:30:02 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
Context: remote SQL command: SELECT eq_id, mod_id FROM public.equipamentos
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-19 05:30:02 Database: rio Application: psql User: intelifix Remote: [local]
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, eq_seq, eq_codigo, eq_extra FROM public.codigos_barra
Date: 2026-06-19 05:30:02 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
14 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 19 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-19 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-19 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-19 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
15 3 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 19 14 3 - ERROR: invalid byte sequence for encoding "UTF8": 0x84
- ERROR: invalid byte sequence for encoding "UTF8": 0x84
- ERROR: invalid byte sequence for encoding "UTF8": 0x84
Date: 2026-06-19 14:04:21 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-19 14:04:28 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-19 14:04:28 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 19 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-19 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-19 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 19 08 2 - LOG: process 506558 still waiting for ShareLock on transaction 1285210 after 1000.163 ms
- LOG: process 506558 still waiting for ShareLock on transaction 1285210 after 8977.149 ms
Detail: Process holding the lock: 518428. Wait queue: 506558.
Context: while updating tuple (18738,44) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(255803,184,'919121099568,8020DA4D1D0A','',0129,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-06-19 08:06:56 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 518428. Wait queue: 506558.
Context: while updating tuple (18738,44) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(255803,184,'919121099568,8020DA4D1D0A','',0129,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-06-19 08:07:04 Database: rio Application: [unknown] User: intelifix Remote: [local]
18 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 19 00 1 06 1 - ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-19 00:05:23 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-19 06:05:11 Database: brasilia Application: psql User: intelifix Remote: [local]
19 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 19 03 1 - LOG: database system was shut down at 2026-06-19 03:05:02 -03
Date: 2026-06-19 03:05:03
20 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 19 18 1 - ERROR: function rs_lote_entrada_fechar_automatico() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_ENTRADA_FECHAR_AUTOMATICO()Date: 2026-06-19 18:00:01 Database: brasilia Application: psql User: intelifix Remote: [local]
21 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 19 21 1 - ERROR: function rs_del_temporario() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_DEL_TEMPORARIO()Date: 2026-06-19 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]