pgBadger-
Global information
- Generated on Tue Jun 9 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 35,256 log entries in 5s
- Log start from 2026-06-09 00:02:01 to 2026-06-09 23:40:21
-
Overview
Global Stats
- 288 Number of unique normalized queries
- 5,600 Number of queries
- 6h5m28s Total query duration
- 2026-06-09 00:02:08 First query
- 2026-06-09 23:38:53 Last query
- 4 queries/s at 2026-06-09 15:40:12 Query peak
- 6h5m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h5m28s Execute total duration
- 2,410 Number of events
- 22 Number of unique normalized events
- 1,922 Max number of times the same event was reported
- 0 Number of cancellation
- 458 Total number of automatic vacuums
- 986 Total number of automatic analyzes
- 19 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 223 Total number of sessions
- 6 sessions at 2026-06-09 08:27:58 Session peak
- 8d4h57m42s Total duration of sessions
- 52m59s Average duration of sessions
- 25 Average queries per session
- 1m38s Average queries duration per session
- 51m21s Average idle time per session
- 568 Total number of connections
- 5 connections/s at 2026-06-09 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-09 15:40:12 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-09 15:38:57 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-09 23:38:41 Date
Queries duration
Key values
- 6h5m28s 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 09 00 29 0ms 17s898ms 2s838ms 4s100ms 7s407ms 54s380ms 01 12 0ms 2s809ms 1s787ms 3s844ms 4s167ms 4s167ms 02 11 0ms 2s432ms 1s854ms 3s963ms 3s963ms 3s963ms 03 13 0ms 3s636ms 1s926ms 5s189ms 5s189ms 5s189ms 04 24 0ms 2s703ms 1s115ms 4s543ms 5s250ms 5s250ms 05 37 0ms 7m32s 16s567ms 5s716ms 2m6s 7m32s 06 13 0ms 8s260ms 2s989ms 7s736ms 18s457ms 18s457ms 07 190 0ms 6m27s 8s998ms 51s76ms 3m38s 6m55s 08 446 0ms 5m25s 3s564ms 42s378ms 3m47s 5m55s 09 561 150ms 6m42s 2s835ms 1m2s 3m41s 6m42s 10 682 150ms 7m52s 3s825ms 1m39s 3m56s 8m22s 11 672 150ms 5m51s 2s415ms 1m9s 1m58s 5m57s 12 125 0ms 5m40s 6s126ms 12s733ms 44s795ms 5m40s 13 310 0ms 5m19s 2s541ms 23s375ms 56s55ms 5m50s 14 439 150ms 6m7s 3s797ms 57s433ms 4m 7m4s 15 644 150ms 6m45s 3s464ms 3m43s 3m55s 6m51s 16 613 150ms 6m15s 1s944ms 28s561ms 51s462ms 6m52s 17 427 0ms 5m49s 2s818ms 45s717ms 1m3s 6m6s 18 12 0ms 5m20s 30s681ms 3s123ms 5m48s 5m48s 19 10 0ms 5m27s 37s222ms 3s99ms 5m55s 5m55s 20 73 0ms 6m14s 12s559ms 1m38s 2m2s 6m14s 21 18 0ms 5m22s 20s928ms 4s909ms 5m51s 5m51s 22 16 0ms 5m20s 23s223ms 4s713ms 5m48s 5m48s 23 223 0ms 1m38s 7s737ms 1m27s 1m45s 2m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 09 00 13 0 765ms 189ms 342ms 7s407ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 12 0 290ms 275ms 827ms 1s91ms 05 24 0 225ms 240ms 363ms 1s166ms 06 4 0 2s154ms 0ms 882ms 7s736ms 07 99 0 13s585ms 3s95ms 42s279ms 3m43s 08 353 0 3s480ms 4s940ms 7s837ms 3m55s 09 466 0 2s846ms 7s913ms 53s813ms 3m48s 10 560 0 3s701ms 49s84ms 1m37s 4m33s 11 556 0 2s376ms 11s621ms 1m 4m1s 12 92 0 7s92ms 2s515ms 3s607ms 3m35s 13 251 0 2s572ms 4s285ms 8s558ms 1m42s 14 355 0 3s656ms 6s863ms 54s187ms 4m7s 15 528 0 3s515ms 9s308ms 3m43s 3m59s 16 493 0 2s92ms 13s651ms 19s916ms 3m44s 17 314 0 2s401ms 15s848ms 29s515ms 52s776ms 18 5 0 1m10s 0ms 1s372ms 5m48s 19 4 0 1m28s 0ms 0ms 5m55s 20 14 53 13s396ms 57s510ms 1m35s 6m14s 21 7 0 50s348ms 340ms 863ms 5m51s 22 4 0 1m27s 0ms 0ms 5m48s 23 6 217 7s737ms 1m8s 1m27s 2m16s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 09 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 09 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 6 6.00 0.00% 08 0 9 9.00 0.00% 09 0 9 9.00 0.00% 10 0 7 7.00 0.00% 11 0 6 6.00 0.00% 12 0 2 2.00 0.00% 13 0 7 7.00 0.00% 14 0 5 5.00 0.00% 15 0 8 8.00 0.00% 16 0 6 6.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 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 09 00 25 0.01/s 01 17 0.00/s 02 17 0.00/s 03 21 0.01/s 04 19 0.01/s 05 23 0.01/s 06 23 0.01/s 07 28 0.01/s 08 38 0.01/s 09 35 0.01/s 10 35 0.01/s 11 36 0.01/s 12 29 0.01/s 13 33 0.01/s 14 33 0.01/s 15 33 0.01/s 16 33 0.01/s 17 30 0.01/s 18 28 0.01/s 19 3 0.00/s 20 11 0.00/s 21 5 0.00/s 22 6 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jun 09 00 2 35m 34m19s 01 7 1h1m17s 1h1m14s 02 3 1h 59m53s 03 7 25m16s 25m13s 04 3 1h 59m51s 05 6 52m40s 50m58s 06 3 1h 59m47s 07 10 49m50s 46m59s 08 11 53m24s 50m59s 09 16 57m53s 56m14s 10 16 53m 50m17s 11 15 51m52s 50m4s 12 15 57m23s 56m32s 13 10 54m37s 53m19s 14 11 1h1m54s 59m23s 15 14 59m1s 56m22s 16 15 57m17s 55m57s 17 16 51m42s 50m26s 18 12 40m21s 39m50s 19 5 1h36s 59m21s 20 6 31m12s 28m39s 21 7 1h1m37s 1h43s 22 5 1h1m4s 59m49s 23 8 41m51s 38m15s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-09 03:05:17 Date
Connections per database
Key values
- brasilia Main Database
- 568 connections Total
Connections per user
Key values
- intelifix Main User
- 568 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-09 08:27:58 Date
Histogram of session times
Key values
- 179 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 223 sessions Total
Sessions per user
Key values
- intelifix Main User
- 223 sessions Total
Sessions per host
Key values
- [local] Main Host
- 223 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 223 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 28,253 buffers Checkpoint Peak
- 2026-06-09 08:14:35 Date
- 270.048 seconds Highest write time
- 0.095 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-06-09 10:14:35 Date
Checkpoints distance
Key values
- 476.52 Mo Distance Peak
- 2026-06-09 10:14:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 09 00 14,795 763.835s 0.023s 763.898s 01 2,524 253.051s 0.021s 253.104s 02 2,022 202.656s 0.014s 202.693s 03 2,293 230.092s 0.016s 230.137s 04 2,812 281.824s 0.017s 281.871s 05 9,353 902.091s 0.035s 902.173s 06 4,467 269.932s 0.002s 269.949s 07 37,318 2,626.893s 0.09s 2,627.062s 08 73,840 3,105.83s 0.164s 3,106.122s 09 55,379 3,118.285s 0.184s 3,118.62s 10 106,013 3,239.259s 0.298s 3,239.742s 11 76,571 3,239.263s 0.22s 3,239.664s 12 32,628 2,362.534s 0.094s 2,362.706s 13 26,529 2,021.386s 0.143s 2,021.626s 14 58,824 3,239.496s 0.17s 3,239.807s 15 73,338 3,239.305s 0.22s 3,239.701s 16 44,103 3,142.322s 0.195s 3,142.647s 17 25,598 2,276.656s 0.137s 2,276.927s 18 1,634 163.832s 0.051s 163.906s 19 24 2.43s 0.006s 2.44s 20 2,075 208.215s 0.013s 208.25s 21 2,361 241.604s 0.018s 241.665s 22 1,934 194.302s 0.026s 194.37s 23 2,028 294.61s 0.005s 294.627s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 09 00 0 0 5 706 0.002s 0.01s 01 0 0 1 462 0.003s 0.007s 02 0 0 0 346 0.003s 0.005s 03 0 0 1 417 0.002s 0.006s 04 0 0 1 520 0.002s 0.007s 05 0 0 4 753 0.003s 0.009s 06 0 0 0 8 0.002s 0.001s 07 0 0 27 2,123 0.004s 0.012s 08 0 0 33 4,257 0.005s 0.012s 09 0 0 33 5,071 0.004s 0.012s 10 0 0 65 6,307 0.035s 0.012s 11 0 0 45 6,221 0.003s 0.012s 12 0 0 14 2,351 0.004s 0.012s 13 0 0 13 3,693 0.008s 0.012s 14 0 0 39 5,433 0.005s 0.012s 15 0 0 49 5,951 0.004s 0.012s 16 0 0 21 4,911 0.004s 0.012s 17 0 0 35 4,243 0.004s 0.012s 18 0 0 0 370 0.038s 0.011s 19 0 0 0 4 0.003s 0.002s 20 0 0 2 124 0.002s 0.005s 21 0 0 0 396 0.003s 0.008s 22 0 0 1 404 0.006s 0.011s 23 0 0 2 29 0.002s 0.003s Day Hour Count Avg time (sec) Jun 09 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 09 00 9,556.78 kB 28,919.11 kB 01 1,732.43 kB 13,517.86 kB 02 1,941.40 kB 8,011.20 kB 03 1,707.00 kB 3,214.57 kB 04 2,019.14 kB 3,205.43 kB 05 7,113.56 kB 16,356.11 kB 06 7,872.00 kB 12,715.00 kB 07 36,986.83 kB 70,665.75 kB 08 44,558.00 kB 84,345.33 kB 09 44,652.08 kB 101,733.00 kB 10 89,564.50 kB 174,010.83 kB 11 60,613.50 kB 106,938.00 kB 12 19,066.33 kB 54,801.33 kB 13 17,919.42 kB 35,092.50 kB 14 53,508.33 kB 79,622.83 kB 15 66,569.92 kB 106,503.00 kB 16 29,735.33 kB 80,494.67 kB 17 47,528.08 kB 86,365.33 kB 18 839.20 kB 79,954.20 kB 19 168.00 kB 57,856.00 kB 20 3,740.80 kB 44,125.60 kB 21 1,925.71 kB 24,312.29 kB 22 1,187.67 kB 11,422.22 kB 23 10,205.33 kB 19,821.33 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-09 11:04:04 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-09 14:15:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 09 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 2 207.99 MiB 104.00 MiB 10 7 727.97 MiB 104.00 MiB 11 5 519.98 MiB 104.00 MiB 12 0 0 0 13 1 104.00 MiB 104.00 MiB 14 3 311.99 MiB 104.00 MiB 15 0 0 0 16 0 0 0 17 1 104.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 19 1.93 GiB 103.99 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025340, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 10:06:57 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025365, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 14:30:00 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025355, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 11:43:41 Duration: 3m58s 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,317,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-09 11:04:04 - 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-09 10:07:35 - 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-09 11:45:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-09 14:00:15 - 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-09 09:55:05 - 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-09 10:54:42 - 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-09 10:59:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-09 11:33:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-09 09:14:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-09 10:38:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-09 13:52:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 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-09 14:15:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 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-09 11:53:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-09 17:29:32 - 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-09 11:58:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 103.99 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-09 10:13:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 103.99 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-09 14:06:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 103.99 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-09 10:21:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 103.99 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-09 10:48:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.35 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-09 11:17:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 7.35 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-09 11:17:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (141) Main table analyzed (database rio)
- 986 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 141 rio.public.temp0000281991 81 rio.pg_catalog.pg_class 75 rio.pg_catalog.pg_type 64 rio.public.usuarios 51 rio.public.temp0000282099 49 rio.pg_catalog.pg_index 41 contagem.pg_catalog.pg_attribute 36 contagem.public.temp0000226340 33 rio.pg_catalog.pg_depend 32 rio.public.temp0000281989 31 rio.public.temp0000282061 26 rio.public.temp0000282055 26 contagem.public.usuarios 25 rio.public.temp0000282043 22 contagem.pg_catalog.pg_class 20 rio.public.temp0000282025 18 contagem.pg_catalog.pg_type 16 rio.public.temp0000281993 14 rio.public.temp0000282023 11 contagem.pg_catalog.pg_index 10 contagem.public.temp0000226346 9 contagem.pg_catalog.pg_depend 8 rio.public.temp0000281999 8 template1.pg_catalog.pg_shdepend 8 rio.public.temp0000281983 8 rio.public.temp0000281897 7 contagem.public.temp0000226294 7 rio.public.temp0000282029 6 rio.public.temp0000282093 6 rio.public.temp0000281941 6 rio.public.temp0000282047 5 contagem.public.temp0000226356 5 rio.public.temp0000281335 5 rio.public.temp0000281995 4 rio.public.temp0000282011 4 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000282073 4 rio.public.temp0000282035 4 rio.public.temp0000282015 4 rio.public.tmp_drill_0175 3 rio.public.temp0000282071 3 contagem.public.nf_entrada 3 postgres.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0302 3 rio.public.temp0000282075 3 rio.public.temp0000282021 2 rio.public.temp0000282091 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000282031 2 rio.public.temp0000282103 2 contagem.public.temp0000226354 2 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000282085 1 rio.public.temp0000282069 1 rio.public.temp0000282121 1 rio.public.temp0000281985 1 rio.public.temp0000282083 1 rio.public.temp0000282017 1 contagem.auditor.auditor_2026_06 1 rio.public.temp0000282115 1 rio.public.temp0000281923 1 rio.public.temp0000282081 1 rio.public.temp0000282107 1 contagem.public.temp0000226348 1 rio.public.temp0000282051 1 rio.public.temp0000282013 1 rio.public.temp0000282001 1 rio.public.temp0000282053 1 rio.public.temp0000282113 1 rio.public.temp0000282087 1 rio.public.temp0000282111 1 rio.public.temp0000282063 1 rio.auditor.auditor_2026_06 1 Total 986 Vacuums per table
Key values
- public.temp0000281991 (80) Main table vacuumed on database rio
- 458 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000281991 80 0 0 0 0 0 0 62,615 386 3,754,205 0 0 rio.pg_catalog.pg_attribute 53 47 0 0 0 0 0 28,681 7,782 11,523,586 489 12,299 rio.pg_catalog.pg_class 34 29 0 0 0 0 0 6,023 1,961 2,855,592 118 407 rio.pg_catalog.pg_type 32 27 0 0 0 0 0 2,515 673 888,529 95 329 rio.public.temp0000282099 24 0 0 0 0 0 0 13,438 293 1,102,462 0 0 contagem.public.usuarios 23 0 0 0 0 0 0 105 83 41,931 3 3 rio.pg_catalog.pg_index 22 17 0 0 0 0 0 1,283 377 294,045 70 162 rio.public.temp0000282043 22 0 0 0 0 0 0 23,425 1,637 3,374,194 0 0 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,109 1,529 2,023,144 76 726 contagem.pg_catalog.pg_attribute 13 13 0 0 0 0 0 8,393 2,410 4,159,381 42 1,184 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 11,772 2,678 12,213,013 1,123 4,647 rio.public.temp0000282023 7 0 0 0 0 0 0 811 39 54,250 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,321 262 416,364 19 50 rio.public.temp0000281941 6 0 0 0 0 0 0 9,370 1,581 2,538,083 0 0 contagem.public.temp0000226346 6 0 0 0 0 0 0 867 269 366,835 0 0 rio.public.usuarios 6 3 0 0 0 0 0 105 42 70,840 9 54 postgres.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 1,171 380 616,042 62 118 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 617 133 230,872 6 16 rio.public.temp0000282093 6 0 0 0 0 0 0 6,250 22 372,238 0 0 rio.public.temp0000281897 5 0 0 0 0 0 0 570 29 38,517 0 0 rio.public.temp0000281335 5 0 0 0 0 0 0 423 94 139,777 0 0 rio.public.tmp_drill_0302 5 3 0 0 0 0 0 1,118 23 211,880 1 55 contagem.public.temp0000226340 5 0 0 0 0 0 0 460 30 31,760 0 0 rio.public.tmp_drill_0175 5 2 0 0 0 0 0 101 39 52,048 1 12 rio.public.temp0000282035 4 0 0 0 0 0 0 304 23 21,579 0 0 rio.public.temp0000282015 4 0 0 0 0 0 0 383 24 26,322 0 0 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,112 290 633,849 10 66 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 187 63 58,646 5 8 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,160 487 2,783,839 125 509 rio.public.temp0000282073 3 0 0 0 0 0 0 451 181 317,503 0 0 rio.public.temp0000282031 2 0 0 0 0 0 0 176 12 12,214 0 0 template1.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 441 166 238,263 27 61 rio.public.temp0000282103 2 0 0 0 0 0 0 216 113 211,053 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,913 180 760,253 148 1,359 rio.auditor.auditor_2026_06 2 0 0 0 0 0 0 98,087 46,459 61,786,406 25,746 567,412 rio.public.temp0000282021 2 0 0 0 0 0 0 1,646 10 98,625 0 0 rio.public.temp0000282091 2 0 0 0 0 0 0 3,120 8 185,286 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 209 65 109,962 7 12 rio.public.temp0000282121 2 0 0 0 0 0 0 3,124 8 185,522 0 0 rio.public.temp0000281923 1 0 0 0 0 0 0 54 52 81,099 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 16,144 8,655 11,281,693 3,457 77,549 rio.public.temp0000282115 1 0 0 0 0 0 0 169 6 11,013 0 0 rio.public.temp0000282107 1 0 0 0 0 0 0 108 6 7,330 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 154 62 219,396 46 8,510 rio.public.temp0000282013 1 0 0 0 0 0 0 87 6 6,044 0 0 rio.public.temp0000282053 1 0 0 0 0 0 0 91 6 6,289 0 0 rio.public.temp0000282113 1 0 0 0 0 0 0 168 6 10,949 0 0 rio.public.temp0000282087 1 0 0 0 0 0 0 8 5 1,347 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 703 307 853,916 194 9,206 rio.public.temp0000282111 1 0 0 0 0 0 0 169 6 11,012 0 0 rio.public.temp0000282085 1 0 0 0 0 0 0 104 6 7,083 0 0 rio.public.temp0000282069 1 0 0 0 0 0 0 1,560 4 92,643 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 166 3 18,024 0 0 rio.public.logs 1 0 0 0 0 0 0 798 479 598,883 150 3,746 rio.public.notas_fiscais 1 0 0 0 0 0 0 16 14 38,849 1 178 rio.public.temp0000282017 1 0 0 0 0 0 0 87 6 6,046 0 0 Total 458 201 0 0 0 0 0 320,658 80,470 128,050,526 32,030 688,678 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (14.56) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000281991 0 0 2.4 rio.pg_catalog.pg_attribute 0 0 3.58 rio.pg_catalog.pg_class 0 0 0.78 rio.pg_catalog.pg_type 0 0 0.28 rio.public.temp0000282099 0 0 0.59 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.1 rio.public.temp0000282043 0 0 1.05 rio.pg_catalog.pg_depend 0 0 0.73 contagem.pg_catalog.pg_attribute 0 0 0.99 rio.pg_catalog.pg_statistic 0 0 1.28 rio.public.temp0000282023 0 0 0.08 contagem.pg_catalog.pg_class 0 0 0.19 rio.public.temp0000281941 0 0 0.32 contagem.public.temp0000226346 0 0 0.1 rio.public.usuarios 0 0 4.97 postgres.pg_catalog.pg_shdepend 0 0 0.15 contagem.pg_catalog.pg_type 0 0 0.08 rio.public.temp0000282093 0 0 0.29 rio.public.temp0000281897 0 0 0.08 rio.public.temp0000281335 0 0 0.07 rio.public.tmp_drill_0302 0 0 0.03 contagem.public.temp0000226340 0 0 0.05 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000282035 0 0 0.03 rio.public.temp0000282015 0 0 0.03 contagem.pg_catalog.pg_depend 0 0 0.16 contagem.pg_catalog.pg_index 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.2 rio.public.temp0000282073 0 0 0.06 rio.public.temp0000282031 0 0 0.03 template1.pg_catalog.pg_shdepend 0 0 0.07 rio.public.temp0000282103 0 0 0.03 contagem.pg_catalog.pg_statistic 0 0 0.13 rio.auditor.auditor_2026_06 0 0 14.56 rio.public.temp0000282021 0 0 0.06 rio.public.temp0000282091 0 0 0.1 contagem.public.nf_entrada 0 0 0.04 rio.public.temp0000282121 0 0 0.08 rio.public.temp0000281923 0 0 0.01 contagem.auditor.auditor_2026_06 0 0 2.98 rio.public.temp0000282115 0 0 0.02 rio.public.temp0000282107 0 0 0.01 rio.public.equipamentos_referencia 0 0 0.03 rio.public.temp0000282013 0 0 0 rio.public.temp0000282053 0 0 0.01 rio.public.temp0000282113 0 0 0.02 rio.public.temp0000282087 0 0 0.01 rio.public.nf_entrada_arquivo_erros 0 0 0.15 rio.public.temp0000282111 0 0 0.01 rio.public.temp0000282085 0 0 0.01 rio.public.temp0000282069 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.logs 0 0 0.23 rio.public.notas_fiscais 0 0 0 rio.public.temp0000282017 0 0 0.01 Total 0 0 37.36 Tuples removed per table
Key values
- pg_catalog.pg_attribute (206131) Main table with removed tuples on database rio
- 345574 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 53 47 206,131 1,365,419 86,216 278 32,934 contagem.pg_catalog.pg_attribute 13 13 48,477 317,962 0 133 6,984 rio.public.tmp_drill_0302 5 3 16,495 17,491 498 0 429 rio.pg_catalog.pg_statistic 9 9 16,198 75,358 0 0 11,574 rio.pg_catalog.pg_depend 13 13 9,266 254,590 4,729 14 2,348 rio.pg_catalog.pg_type 32 27 8,932 79,976 6,508 22 2,293 postgres.pg_catalog.pg_shdepend 6 6 6,025 55,749 56 0 606 rio.pg_catalog.pg_index 22 17 5,056 45,573 3,132 15 1,305 contagem.pg_catalog.pg_statistic 2 2 4,900 14,865 0 0 2,022 rio.pg_catalog.pg_class 34 29 4,861 137,790 15,848 18 4,688 contagem.pg_catalog.pg_depend 4 4 4,063 75,488 0 0 704 contagem.pg_catalog.pg_class 7 7 2,718 23,202 0 45 863 contagem.pg_catalog.pg_type 6 6 2,331 13,528 0 19 391 template1.pg_catalog.pg_shdepend 2 2 1,750 18,548 0 0 202 rio.auditor.auditor_2026_06 2 0 1,739 13,699,962 0 0 635,914 contagem.public.usuarios 23 0 1,426 529 0 0 46 contagem.public.nf_entrada 2 2 1,352 2,242 0 0 138 rio.pg_toast.pg_toast_2619 4 4 1,160 3,177 0 0 1,028 rio.public.tmp_drill_0175 5 2 1,157 3,119 981 0 58 contagem.pg_catalog.pg_index 4 4 1,039 7,600 0 0 206 rio.public.usuarios 6 3 295 4,166 1,124 0 98 contagem.pg_toast.pg_toast_2619 1 1 147 115 0 0 62 rio.public.nf_entrada_arquivo_erros 1 0 56 8,268,282 0 0 147,041 rio.public.temp0000281941 6 0 0 131,831 0 0 9,600 rio.public.temp0000282031 2 0 0 3,461 0 96 160 rio.public.temp0000281897 5 0 0 29,970 0 215 681 rio.public.temp0000281923 1 0 0 2,063 0 18 46 contagem.auditor.auditor_2026_06 1 0 0 1,161,447 0 0 51,113 rio.public.temp0000282115 1 0 0 7,062 0 31 161 contagem.public.temp0000226346 6 0 0 6,317 0 270 818 rio.public.temp0000282107 1 0 0 2,155 0 28 100 rio.public.temp0000282073 3 0 0 18,784 0 85 427 rio.public.temp0000282103 2 0 0 4,300 0 56 200 rio.public.temp0000282099 24 0 0 243,991 0 512 13,568 rio.public.equipamentos_referencia 1 0 0 5,037,519 0 0 27,231 rio.public.temp0000282013 1 0 0 1,719 0 49 79 rio.public.temp0000282053 1 0 0 1,770 0 45 83 rio.public.temp0000282035 4 0 0 7,514 0 161 351 rio.public.temp0000282113 1 0 0 7,035 0 32 160 rio.public.temp0000281335 5 0 0 19,875 0 189 451 rio.public.temp0000282087 1 0 0 2,145 0 29 99 rio.public.temp0000282015 4 0 0 7,515 0 161 351 rio.public.temp0000282111 1 0 0 7,067 0 31 161 rio.public.temp0000282043 22 0 0 482,815 0 0 35,200 rio.public.temp0000282021 2 0 0 23,655 0 49 1,679 rio.public.temp0000282085 1 0 0 2,034 0 32 96 contagem.public.temp0000226340 5 0 0 5,480 0 220 420 rio.public.temp0000282069 1 0 0 21,955 0 0 1,600 rio.public.temp0000281991 80 0 0 1,014,653 0 1,458 72,078 rio.public.temp0000282091 2 0 0 43,912 0 0 3,200 rio.public.temp0000282121 2 0 0 43,947 0 0 3,200 rio.public.temp0000282023 7 0 0 39,635 0 250 902 rio.public.logs 1 0 0 15,842,514 0 0 632,991 rio.public.notas_fiscais 1 0 0 162,824 0 0 881 rio.public.temp0000282093 6 0 0 131,752 0 0 9,600 rio.public.temp0000282017 1 0 0 1,719 0 49 79 Total 458 201 345,574 49,005,166 119,092 4,610 1,719,700 Pages removed per table
Key values
- public.temp0000281991 (1458) Main table with removed pages on database rio
- 4610 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000281991 80 0 0 1458 rio.public.temp0000282099 24 0 0 512 rio.pg_catalog.pg_attribute 53 47 206131 278 contagem.public.temp0000226346 6 0 0 270 rio.public.temp0000282023 7 0 0 250 contagem.public.temp0000226340 5 0 0 220 rio.public.temp0000281897 5 0 0 215 rio.public.temp0000281335 5 0 0 189 rio.public.temp0000282035 4 0 0 161 rio.public.temp0000282015 4 0 0 161 contagem.pg_catalog.pg_attribute 13 13 48477 133 rio.public.temp0000282031 2 0 0 96 rio.public.temp0000282073 3 0 0 85 rio.public.temp0000282103 2 0 0 56 rio.public.temp0000282013 1 0 0 49 rio.public.temp0000282021 2 0 0 49 rio.public.temp0000282017 1 0 0 49 rio.public.temp0000282053 1 0 0 45 contagem.pg_catalog.pg_class 7 7 2718 45 rio.public.temp0000282113 1 0 0 32 rio.public.temp0000282085 1 0 0 32 rio.public.temp0000282115 1 0 0 31 rio.public.temp0000282111 1 0 0 31 rio.public.temp0000282087 1 0 0 29 rio.public.temp0000282107 1 0 0 28 rio.pg_catalog.pg_type 32 27 8932 22 contagem.pg_catalog.pg_type 6 6 2331 19 rio.public.temp0000281923 1 0 0 18 rio.pg_catalog.pg_class 34 29 4861 18 rio.pg_catalog.pg_index 22 17 5056 15 rio.pg_catalog.pg_depend 13 13 9266 14 rio.public.temp0000281941 6 0 0 0 template1.pg_catalog.pg_shdepend 2 2 1750 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 contagem.pg_catalog.pg_statistic 2 2 4900 0 rio.pg_catalog.pg_statistic 9 9 16198 0 rio.public.nf_entrada_arquivo_erros 1 0 56 0 rio.public.tmp_drill_0302 5 3 16495 0 rio.auditor.auditor_2026_06 2 0 1739 0 rio.public.temp0000282043 22 0 0 0 rio.public.usuarios 6 3 295 0 rio.public.temp0000282069 1 0 0 0 rio.public.tmp_drill_0175 5 2 1157 0 contagem.pg_toast.pg_toast_2619 1 1 147 0 rio.public.temp0000282091 2 0 0 0 contagem.public.nf_entrada 2 2 1352 0 rio.public.temp0000282121 2 0 0 0 contagem.pg_catalog.pg_depend 4 4 4063 0 contagem.pg_catalog.pg_index 4 4 1039 0 rio.pg_toast.pg_toast_2619 4 4 1160 0 contagem.public.usuarios 23 0 1426 0 rio.public.logs 1 0 0 0 rio.public.notas_fiscais 1 0 0 0 postgres.pg_catalog.pg_shdepend 6 6 6025 0 rio.public.temp0000282093 6 0 0 0 Total 458 201 345,574 4,610 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 09 00 0 4 01 0 0 02 0 0 03 0 0 04 0 1 05 4 4 06 0 0 07 23 37 08 33 75 09 41 89 10 80 128 11 54 134 12 9 40 13 30 58 14 46 104 15 59 129 16 32 92 17 44 86 18 0 0 19 0 0 20 0 0 21 3 5 22 0 0 23 0 0 - 7.35 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 1m47s 1m47s 1m47s 1m47s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:06:57 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 00:05:19 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:55:10 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 1m47s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-09 10:06:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,160 Total read queries
- 1,188 Total write queries
Queries by database
Key values
- rio Main database
- 4,576 Requests
- 5h50m58s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,516 Requests
User Request type Count Duration etiquetas Total 2 333ms select 2 333ms intelifix Total 5,516 6h4m39s copy to 270 35m42s ddl 917 47m59s others 252 24m18s select 4,077 4h16m39s lenon Total 82 48s241ms ddl 1 321ms select 81 47s920ms Duration by user
Key values
- 6h4m39s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 2 333ms select 2 333ms intelifix Total 5,516 6h4m39s copy to 270 35m42s ddl 917 47m59s others 252 24m18s select 4,077 4h16m39s lenon Total 82 48s241ms ddl 1 321ms select 81 47s920ms Queries by host
Key values
- [local] Main host
- 5,599 Requests
- 6h5m28s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,886 Requests
- 3h14m45s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-09 09:57:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,259 100-500ms duration
Slowest individual queries
Rank Duration Query 1 7m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 10:12:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m32s analyze verbose;[ Date: 2026-06-09 05:07:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 15:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 09:11:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 07:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 16:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 20:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 14:11:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 11:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 17:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 12:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 19:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 08:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 21:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 18:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 22:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-09 13:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025340, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-09 10:06:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025365, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-09 14:30:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 3m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025355, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-09 11:43:41 - 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 1h47m48s 215 150ms 4m30s 30s87ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 09 07 10 14m32s 1m27s 08 18 11m22s 37s942ms 09 13 9m35s 44s294ms 10 36 19m15s 32s100ms 11 25 11m7s 26s703ms 12 4 3m46s 56s643ms 13 19 2m45s 8s726ms 14 19 10m49s 34s193ms 15 40 19m9s 28s731ms 16 22 4m26s 12s95ms 17 9 57s224ms 6s358ms [ User: intelifix - Total duration: 1h47m48s - Times executed: 215 ]
[ Application: [unknown] - Total duration: 1h47m48s - Times executed: 215 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025340, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 10:06:57 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025365, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 14:30:00 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025355, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 11:43:41 Duration: 3m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h36m41s 32 966ms 7m52s 3m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 09 07 2 6m30s 3m15s 08 2 5m26s 2m43s 09 2 6m50s 3m25s 10 2 7m56s 3m58s 11 2 5m56s 2m58s 12 2 5m44s 2m52s 13 2 5m20s 2m40s 14 2 6m8s 3m4s 15 2 6m47s 3m23s 16 2 6m17s 3m8s 17 2 5m51s 2m55s 18 2 5m21s 2m40s 19 2 5m28s 2m44s 20 2 6m15s 3m7s 21 2 5m23s 2m41s 22 2 5m21s 2m40s [ User: intelifix - Total duration: 1h36m41s - Times executed: 32 ]
[ Application: psql - Total duration: 1h36m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-09 10:12:54 Duration: 7m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-09 15:11:47 Duration: 6m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-09 09:11:43 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
3 18m12s 111 7s927ms 12s957ms 9s841ms create table temp0000281991 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 09 07 16 2m18s 8s649ms 08 22 3m36s 9s860ms 09 8 1m19s 9s894ms 10 13 2m7s 9s839ms 11 3 31s388ms 10s462ms 12 3 29s818ms 9s939ms 14 17 2m56s 10s409ms 15 23 3m49s 9s958ms 16 6 1m2s 10s456ms [ User: intelifix - Total duration: 18m12s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 18m12s - Times executed: 111 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 14:55:20 Duration: 12s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 14:39:51 Duration: 12s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:39:07 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 14m24s 1,541 150ms 4s684ms 561ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 09 07 22 9s631ms 437ms 08 155 1m28s 569ms 09 235 2m20s 595ms 10 248 2m6s 508ms 11 256 2m14s 524ms 12 63 35s918ms 570ms 13 37 26s861ms 725ms 14 142 1m23s 586ms 15 143 1m21s 572ms 16 151 1m24s 560ms 17 89 54s36ms 607ms [ User: intelifix - Total duration: 14m24s - Times executed: 1541 ]
[ Application: [unknown] - Total duration: 14m24s - Times executed: 1541 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40722, 413, '270911029492101746,229781914563,229879773339,229933293961,229739206668,229661330517,216944319295,229934091424,229737905363,229740807374,229784320915,229934151127,229850108793,229664179010,229865556777,216944538688,229782280211,229816672950,229661857290,229726918398,216944748888,229746200315,216940146565,229689789297,229859553442,229865710508,229924827578,229880060719,216939175876,229663764850,229727369206', '246587048699,246652924242,246243043051,246530971028,246465156276,246461395561,246489844870,246568786670,246549651717,246587378181,246113560022,246640163244,246471878403,246648415463,246461361114,246600923354,246628893951,246465889008,246520363954,246456894561,246548359199,246462467495,246513702945,246650044758,246648418392,246639290724,246652467272,246463303750,246467454660,246523822541,,,,,,,,,,,,,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-09 08:35:05 Duration: 4s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (250678, 404, '71429385850007003913,216353764153,216879314254,216864234668,184272657383,216543529104H010937088,216610826872H010999243,216628107481,216640449719,216861195370,216819500314,216834219909,216641413842,216737015069,216699619196,216553095660,216812463858,216635748901H010980467,216633821620H010979362,216633711127,216504516183,216397803434,216553090711,216639105255,216874617577,216815427390,216503219401,216518197383,216733341838,216791107474,216408845656,216870665980,216700132233H010994646,216618212532', '',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":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-09 08:57:23 Duration: 3s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40750, 418, '834025904002893,230044989508,230030647681,230027470717,230041417677,230045166674,230043978286,230051020827,229976184959,229975061629,230044379718,230001268192,230014861832,230041322742,230049499903,229989804762,229975039303,230032772132,229960982028,230043993238,229981906067,230041417980,229990019104,229988145969,230010183945,230027078703,230051782023,229991498989,230051777072,229977030811,230030660512,230030658793', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-09 10:58:38 Duration: 3s46ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 9m59s 40 5s721ms 35s834ms 14s993ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 09 08 1 8s985ms 8s985ms 09 3 43s212ms 14s404ms 10 2 29s316ms 14s658ms 13 1 14s556ms 14s556ms 14 5 1m10s 14s61ms 15 3 40s832ms 13s610ms 16 11 2m42s 14s796ms 17 12 3m 15s53ms 20 2 49s131ms 24s565ms [ User: intelifix - Total duration: 9m59s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 9m59s - Times executed: 40 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-09', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-09 20:17:55 Duration: 35s834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-09', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-09 09:51:55 Duration: 25s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-09', 099, '', '', 0, 6, '2026-06-01');
Date: 2026-06-09 16:31:49 Duration: 16s841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 9m39s 2 2m6s 7m32s 4m49s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 09 05 2 9m39s 4m49s [ User: intelifix - Total duration: 9m39s - Times executed: 2 ]
[ Application: psql - Total duration: 9m39s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-09 05:07:33 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-09 05:09:40 Duration: 2m6s Database: contagem User: intelifix Remote: [local] Application: psql
7 9m10s 32 406ms 44s863ms 17s217ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 09 07 2 39s852ms 19s926ms 08 2 30s53ms 15s26ms 09 2 42s600ms 21s300ms 10 2 43s469ms 21s734ms 11 2 35s154ms 17s577ms 12 2 36s397ms 18s198ms 13 2 30s866ms 15s433ms 14 2 35s279ms 17s639ms 15 2 36s875ms 18s437ms 16 2 29s313ms 14s656ms 17 2 35s626ms 17s813ms 18 2 28s657ms 14s328ms 19 2 26s795ms 13s397ms 20 2 45s510ms 22s755ms 21 2 27s799ms 13s899ms 22 2 26s706ms 13s353ms [ User: intelifix - Total duration: 9m10s - Times executed: 32 ]
[ Application: psql - Total duration: 9m10s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-09 20:12:00 Duration: 44s863ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-09 10:13:36 Duration: 42s390ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-09 09:12:25 Duration: 41s804ms Database: rio User: intelifix Remote: [local] Application: psql
8 8m25s 138 2s86ms 1m50s 3s664ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 09 00 6 19s637ms 3s272ms 01 6 14s61ms 2s343ms 02 6 13s976ms 2s329ms 03 6 16s662ms 2s777ms 04 6 14s183ms 2s363ms 05 6 16s677ms 2s779ms 06 6 13s384ms 2s230ms 07 6 16s450ms 2s741ms 08 6 18s544ms 3s90ms 09 6 17s133ms 2s855ms 10 6 2m7s 21s242ms 11 6 18s49ms 3s8ms 12 6 18s4ms 3s 13 6 17s638ms 2s939ms 14 6 21s619ms 3s603ms 15 6 19s317ms 3s219ms 16 6 19s816ms 3s302ms 17 6 17s628ms 2s938ms 18 6 17s226ms 2s871ms 19 6 16s613ms 2s768ms 20 6 19s296ms 3s216ms 21 6 16s742ms 2s790ms 22 6 15s536ms 2s589ms [ User: intelifix - Total duration: 8m25s - Times executed: 138 ]
[ Application: psql - Total duration: 8m25s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:06:57 Duration: 1m50s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 00:05:19 Duration: 7s687ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:55:10 Duration: 4s481ms Database: rio User: intelifix Remote: [local] Application: psql
9 7m21s 44 8s183ms 13s975ms 10s39ms create table temp0000282043 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 09 09 8 1m15s 9s393ms 10 17 2m50s 10s12ms 11 19 3m16s 10s334ms [ User: intelifix - Total duration: 7m21s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 7m21s - Times executed: 44 ]
-
CREATE TABLE temp0000282043 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:34:09 Duration: 13s975ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282043 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:53:27 Duration: 12s433ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282043 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 10:55:21 Duration: 12s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m23s 860 150ms 2s306ms 445ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 09 08 88 1m 684ms 09 81 39s900ms 492ms 10 124 48s433ms 390ms 11 131 57s524ms 439ms 13 82 36s43ms 439ms 14 106 49s710ms 468ms 15 139 53s697ms 386ms 16 85 29s476ms 346ms 17 24 8s313ms 346ms [ User: intelifix - Total duration: 6m23s - Times executed: 860 ]
[ Application: [unknown] - Total duration: 6m23s - Times executed: 860 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "250709", "modelo" : "464", "itens" : "241762499400,241768002732,241776813749,241746373034,241767995559,241759958994,241742814157,241746365659,241759939699,241742830826,241746658089,241742803247,241764632538,241740772140,241759508894,241767938708,241744782733,241743353536,241765621131,241744864862,241745794964,241764701232,241759486367,241765150019,241765151130,241738590614,241740632227,241759864564,241744753841,241765234751,241746638289,241762781830,241759960107,241760199703,241765291323,241761512929,241744022446,241741296668,241746113839,241744357180,241764708101,241778110509,241742835977,241763508499,241759828803,241768036169,241759617188,241776822639,241739117387,241742656060,241759959601,241739435959,241764679411,241745427374,241738662540,241742833755,241759938083,241759941923,241767851023,241744359099,241742217880,241759819610,241746448900,241747360819,241742830119,241742807085,241742398101,241763980017,241760834344,241764536366,241763992644,241747583949,241738776063,241739664747,241738716282,241738676884,241738775053,241764547175,241765417800,241745570723,241738620617,241764544145,241764550308,241762580621,241747258484,241764138493,241761353340,241743373740,241744528487,241744781218,241739685254,241763285975,241762784860,241739568598,241760053651,241739443334,241739567992,241740265165,241747517881,241738460018", "usuario" : "414", "caixa" : "3043066", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-09 08:50:32 Duration: 2s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251174", "modelo" : "320", "itens" : "241712523838,241729942643,241727947172,241704331928,241680394653,241711629496,241714829696,241704279295,241689483049,241688964760,241730499700,241668735468,241730469696,241714748196,241649648802,241695603141,241659784864,241605413946,241659717180,241727000426,241645846870,241701596980,230043534248,241634359396,241727455778,241628157983,241712993940,241717129292,241703694559,241658164964,241728744456,241676777184,241630161839,241617367480,241593084561,241654447788,241654470216,241726980424,241598870727,241654561414,241632297983,241634789797,241630941926,241628215969,241717140911,241658334150,241634787979,241675355362", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-09 08:06:32 Duration: 1s922ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251182", "modelo" : "320", "itens" : "241682713443,241678333947,241647373754,241675469313,241695527880,241664839207,241656689803,241649688907,241646257292,241598148197,241646251030,241717127373,241714934859,241717148385,241607256774,241727333948,241716530313,241593782340,241716534757,241716463538,241650450811,241660481330,241614582226,241671699405,241714934556,241714935768,241701351727,241658668099,241714902533,241678260708,241620798791,241636073448,241638293945,241676212528,241608696679,241618161128,241708369213,241597544547,241607287585,230055048895,241646252848,241698752629,241695563238,241730455476,241712558689,241689966283,241658217494,241602969207", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-09 08:09:57 Duration: 1s718ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 5m6s 102 221ms 10s817ms 3s9ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 09 00 6 16s862ms 2s810ms 01 6 7s393ms 1s232ms 02 5 6s424ms 1s284ms 03 6 8s177ms 1s362ms 04 6 9s86ms 1s514ms 05 5 11s677ms 2s335ms 07 6 25s123ms 4s187ms 08 6 39s969ms 6s661ms 09 6 17s659ms 2s943ms 10 5 24s343ms 4s868ms 11 6 26s920ms 4s486ms 12 6 30s220ms 5s36ms 13 6 5s618ms 936ms 14 5 23s75ms 4s615ms 15 5 22s218ms 4s443ms 16 6 16s664ms 2s777ms 21 5 7s528ms 1s505ms 22 6 8s26ms 1s337ms [ User: intelifix - Total duration: 5m6s - Times executed: 102 ]
[ Application: psql - Total duration: 5m6s - Times executed: 102 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 00:05:12 Duration: 10s817ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 08:15:10 Duration: 8s169ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 08:25:09 Duration: 7s679ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m26s 67 2s713ms 8s934ms 3s975ms create table temp0000281991 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 09 07 20 1m11s 3s569ms 08 8 26s549ms 3s318ms 09 6 20s65ms 3s344ms 10 6 25s725ms 4s287ms 14 7 31s134ms 4s447ms 15 14 1m4s 4s604ms 16 6 27s5ms 4s500ms [ User: intelifix - Total duration: 4m26s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 4m26s - Times executed: 67 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 07:15:41 Duration: 8s934ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 10:55:11 Duration: 5s923ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 15:34:43 Duration: 5s621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m58s 71 163ms 1m26s 2s511ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 09 07 7 2s708ms 386ms 08 8 2s882ms 360ms 09 6 18s207ms 3s34ms 10 11 2m3s 11s183ms 11 7 15s419ms 2s202ms 12 1 513ms 513ms 13 2 1s756ms 878ms 14 8 6s914ms 864ms 15 8 2s800ms 350ms 16 2 829ms 414ms 17 11 3s286ms 298ms [ User: intelifix - Total duration: 2m58s - Times executed: 71 ]
[ Application: psql - Total duration: 2m58s - Times executed: 71 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025341);
Date: 2026-06-09 10:09:36 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025346);
Date: 2026-06-09 10:40:06 Duration: 25s332ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025338);
Date: 2026-06-09 09:57:17 Duration: 14s668ms Database: rio User: intelifix Remote: [local] Application: psql
14 2m44s 17 8s378ms 11s164ms 9s683ms create table temp0000282099 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 09 17 17 2m44s 9s683ms [ User: intelifix - Total duration: 2m44s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 17 ]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 17:40:15 Duration: 11s164ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 17:23:06 Duration: 10s638ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 17:27:04 Duration: 10s594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m41s 2 1m20s 1m21s 1m20s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 09 20 1 1m21s 1m21s 23 1 1m20s 1m20s [ User: intelifix - Total duration: 2m41s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m41s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-09 20:08:13 Duration: 1m21s 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-09 23:36:32 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
16 2m17s 376 150ms 1s394ms 365ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 09 09 55 31s477ms 572ms 10 37 14s23ms 379ms 11 36 16s258ms 451ms 13 42 14s561ms 346ms 15 50 16s386ms 327ms 16 84 31s564ms 375ms 17 72 13s237ms 183ms [ User: intelifix - Total duration: 2m17s - Times executed: 376 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 376 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40998","seriais":"246023033846","usuario":"416","observacao":""}');
Date: 2026-06-09 09:45:33 Duration: 1s394ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"6877DA5F86FF,802D1A1FA17C,6877DA5EF903,D8E8448B8F5A,D8E8448AF8FA,6877DA5D5BF7,30424092428C,6877DA5FAF83,6877DA5D0A4B,802D1A1F87D0,D8E8448D1476,802D1A1F8FB8,6877DA5D5BAB,6877DA601E37,6877DA5C1023,6877DA58C39F,6877DA5EF923,802D1A206BFC,D8E8448D138E,6877DA58C163,6877DA5C188F,D8E8448AF956,F42D0644B7D3,6877DA58C3BB,F42D0645CE43,D8E8448C5A12,802D1A01BC84,6877DA5979E3,D8E8448D0AE2,D8E8448C5B2A,203AEBA72F2A,6877DA5EFE5F,D8E844AB7932,6877DA59D34F,6877DA60945F,E8436853B0B0,CC29BDEDF7A5,203AEBA7199A,203AEBA84F9E,6877DA5FAB57,CC29BDEDF621,D8E8448A61AE","usuario":"416","observacao":""}');
Date: 2026-06-09 11:53:00 Duration: 1s115ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40998","seriais":"246108470019","usuario":"416","observacao":""}');
Date: 2026-06-09 09:51:54 Duration: 1s111ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 1m57s 2 19s254ms 1m38s 58s734ms 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 #17
Day Hour Count Duration Avg duration Jun 09 23 2 1m57s 58s734ms [ User: intelifix - Total duration: 1m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m57s - 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-09 23:14:20 Duration: 1m38s 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-09 23:37:54 Duration: 19s254ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1m55s 2 54s235ms 1m1s 57s626ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 09 20 1 1m1s 1m1s 23 1 54s235ms 54s235ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-09 20:05:19 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-09 23:18:07 Duration: 54s235ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 1m54s 9 9s142ms 33s481ms 12s675ms create table temp0000281991 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 09 07 3 53s167ms 17s722ms 08 1 10s767ms 10s767ms 09 1 10s128ms 10s128ms 10 2 20s570ms 10s285ms 14 1 9s351ms 9s351ms 15 1 10s97ms 10s97ms [ User: intelifix - Total duration: 1m54s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 9 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-09 07:02:56 Duration: 33s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-09 08:20:17 Duration: 10s767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-09 10:45:34 Duration: 10s665ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m46s 2 17s535ms 1m28s 53s223ms copy auditor.auditor_2026_03 (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 09 23 2 1m46s 53s223ms [ User: intelifix - Total duration: 1m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (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-09 23:11:32 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (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-09 23:37:18 Duration: 17s535ms 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,541 14m24s 150ms 4s684ms 561ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 09 07 22 9s631ms 437ms 08 155 1m28s 569ms 09 235 2m20s 595ms 10 248 2m6s 508ms 11 256 2m14s 524ms 12 63 35s918ms 570ms 13 37 26s861ms 725ms 14 142 1m23s 586ms 15 143 1m21s 572ms 16 151 1m24s 560ms 17 89 54s36ms 607ms [ User: intelifix - Total duration: 14m24s - Times executed: 1541 ]
[ Application: [unknown] - Total duration: 14m24s - Times executed: 1541 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40722, 413, '270911029492101746,229781914563,229879773339,229933293961,229739206668,229661330517,216944319295,229934091424,229737905363,229740807374,229784320915,229934151127,229850108793,229664179010,229865556777,216944538688,229782280211,229816672950,229661857290,229726918398,216944748888,229746200315,216940146565,229689789297,229859553442,229865710508,229924827578,229880060719,216939175876,229663764850,229727369206', '246587048699,246652924242,246243043051,246530971028,246465156276,246461395561,246489844870,246568786670,246549651717,246587378181,246113560022,246640163244,246471878403,246648415463,246461361114,246600923354,246628893951,246465889008,246520363954,246456894561,246548359199,246462467495,246513702945,246650044758,246648418392,246639290724,246652467272,246463303750,246467454660,246523822541,,,,,,,,,,,,,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-09 08:35:05 Duration: 4s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (250678, 404, '71429385850007003913,216353764153,216879314254,216864234668,184272657383,216543529104H010937088,216610826872H010999243,216628107481,216640449719,216861195370,216819500314,216834219909,216641413842,216737015069,216699619196,216553095660,216812463858,216635748901H010980467,216633821620H010979362,216633711127,216504516183,216397803434,216553090711,216639105255,216874617577,216815427390,216503219401,216518197383,216733341838,216791107474,216408845656,216870665980,216700132233H010994646,216618212532', '',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":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-09 08:57:23 Duration: 3s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40750, 418, '834025904002893,230044989508,230030647681,230027470717,230041417677,230045166674,230043978286,230051020827,229976184959,229975061629,230044379718,230001268192,230014861832,230041322742,230049499903,229989804762,229975039303,230032772132,229960982028,230043993238,229981906067,230041417980,229990019104,229988145969,230010183945,230027078703,230051782023,229991498989,230051777072,229977030811,230030660512,230030658793', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-09 10:58:38 Duration: 3s46ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 860 6m23s 150ms 2s306ms 445ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 09 08 88 1m 684ms 09 81 39s900ms 492ms 10 124 48s433ms 390ms 11 131 57s524ms 439ms 13 82 36s43ms 439ms 14 106 49s710ms 468ms 15 139 53s697ms 386ms 16 85 29s476ms 346ms 17 24 8s313ms 346ms [ User: intelifix - Total duration: 6m23s - Times executed: 860 ]
[ Application: [unknown] - Total duration: 6m23s - Times executed: 860 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "250709", "modelo" : "464", "itens" : "241762499400,241768002732,241776813749,241746373034,241767995559,241759958994,241742814157,241746365659,241759939699,241742830826,241746658089,241742803247,241764632538,241740772140,241759508894,241767938708,241744782733,241743353536,241765621131,241744864862,241745794964,241764701232,241759486367,241765150019,241765151130,241738590614,241740632227,241759864564,241744753841,241765234751,241746638289,241762781830,241759960107,241760199703,241765291323,241761512929,241744022446,241741296668,241746113839,241744357180,241764708101,241778110509,241742835977,241763508499,241759828803,241768036169,241759617188,241776822639,241739117387,241742656060,241759959601,241739435959,241764679411,241745427374,241738662540,241742833755,241759938083,241759941923,241767851023,241744359099,241742217880,241759819610,241746448900,241747360819,241742830119,241742807085,241742398101,241763980017,241760834344,241764536366,241763992644,241747583949,241738776063,241739664747,241738716282,241738676884,241738775053,241764547175,241765417800,241745570723,241738620617,241764544145,241764550308,241762580621,241747258484,241764138493,241761353340,241743373740,241744528487,241744781218,241739685254,241763285975,241762784860,241739568598,241760053651,241739443334,241739567992,241740265165,241747517881,241738460018", "usuario" : "414", "caixa" : "3043066", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-09 08:50:32 Duration: 2s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251174", "modelo" : "320", "itens" : "241712523838,241729942643,241727947172,241704331928,241680394653,241711629496,241714829696,241704279295,241689483049,241688964760,241730499700,241668735468,241730469696,241714748196,241649648802,241695603141,241659784864,241605413946,241659717180,241727000426,241645846870,241701596980,230043534248,241634359396,241727455778,241628157983,241712993940,241717129292,241703694559,241658164964,241728744456,241676777184,241630161839,241617367480,241593084561,241654447788,241654470216,241726980424,241598870727,241654561414,241632297983,241634789797,241630941926,241628215969,241717140911,241658334150,241634787979,241675355362", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-09 08:06:32 Duration: 1s922ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251182", "modelo" : "320", "itens" : "241682713443,241678333947,241647373754,241675469313,241695527880,241664839207,241656689803,241649688907,241646257292,241598148197,241646251030,241717127373,241714934859,241717148385,241607256774,241727333948,241716530313,241593782340,241716534757,241716463538,241650450811,241660481330,241614582226,241671699405,241714934556,241714935768,241701351727,241658668099,241714902533,241678260708,241620798791,241636073448,241638293945,241676212528,241608696679,241618161128,241708369213,241597544547,241607287585,230055048895,241646252848,241698752629,241695563238,241730455476,241712558689,241689966283,241658217494,241602969207", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-09 08:09:57 Duration: 1s718ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 376 2m17s 150ms 1s394ms 365ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 09 09 55 31s477ms 572ms 10 37 14s23ms 379ms 11 36 16s258ms 451ms 13 42 14s561ms 346ms 15 50 16s386ms 327ms 16 84 31s564ms 375ms 17 72 13s237ms 183ms [ User: intelifix - Total duration: 2m17s - Times executed: 376 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 376 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40998","seriais":"246023033846","usuario":"416","observacao":""}');
Date: 2026-06-09 09:45:33 Duration: 1s394ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"6877DA5F86FF,802D1A1FA17C,6877DA5EF903,D8E8448B8F5A,D8E8448AF8FA,6877DA5D5BF7,30424092428C,6877DA5FAF83,6877DA5D0A4B,802D1A1F87D0,D8E8448D1476,802D1A1F8FB8,6877DA5D5BAB,6877DA601E37,6877DA5C1023,6877DA58C39F,6877DA5EF923,802D1A206BFC,D8E8448D138E,6877DA58C163,6877DA5C188F,D8E8448AF956,F42D0644B7D3,6877DA58C3BB,F42D0645CE43,D8E8448C5A12,802D1A01BC84,6877DA5979E3,D8E8448D0AE2,D8E8448C5B2A,203AEBA72F2A,6877DA5EFE5F,D8E844AB7932,6877DA59D34F,6877DA60945F,E8436853B0B0,CC29BDEDF7A5,203AEBA7199A,203AEBA84F9E,6877DA5FAB57,CC29BDEDF621,D8E8448A61AE","usuario":"416","observacao":""}');
Date: 2026-06-09 11:53:00 Duration: 1s115ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40998","seriais":"246108470019","usuario":"416","observacao":""}');
Date: 2026-06-09 09:51:54 Duration: 1s111ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 215 1h47m48s 150ms 4m30s 30s87ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 09 07 10 14m32s 1m27s 08 18 11m22s 37s942ms 09 13 9m35s 44s294ms 10 36 19m15s 32s100ms 11 25 11m7s 26s703ms 12 4 3m46s 56s643ms 13 19 2m45s 8s726ms 14 19 10m49s 34s193ms 15 40 19m9s 28s731ms 16 22 4m26s 12s95ms 17 9 57s224ms 6s358ms [ User: intelifix - Total duration: 1h47m48s - Times executed: 215 ]
[ Application: [unknown] - Total duration: 1h47m48s - Times executed: 215 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025340, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 10:06:57 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025365, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 14:30:00 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025355, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 11:43:41 Duration: 3m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 138 8m25s 2s86ms 1m50s 3s664ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 09 00 6 19s637ms 3s272ms 01 6 14s61ms 2s343ms 02 6 13s976ms 2s329ms 03 6 16s662ms 2s777ms 04 6 14s183ms 2s363ms 05 6 16s677ms 2s779ms 06 6 13s384ms 2s230ms 07 6 16s450ms 2s741ms 08 6 18s544ms 3s90ms 09 6 17s133ms 2s855ms 10 6 2m7s 21s242ms 11 6 18s49ms 3s8ms 12 6 18s4ms 3s 13 6 17s638ms 2s939ms 14 6 21s619ms 3s603ms 15 6 19s317ms 3s219ms 16 6 19s816ms 3s302ms 17 6 17s628ms 2s938ms 18 6 17s226ms 2s871ms 19 6 16s613ms 2s768ms 20 6 19s296ms 3s216ms 21 6 16s742ms 2s790ms 22 6 15s536ms 2s589ms [ User: intelifix - Total duration: 8m25s - Times executed: 138 ]
[ Application: psql - Total duration: 8m25s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:06:57 Duration: 1m50s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 00:05:19 Duration: 7s687ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:55:10 Duration: 4s481ms Database: rio User: intelifix Remote: [local] Application: psql
6 134 1m6s 151ms 9s143ms 496ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 09 08 11 3s732ms 339ms 09 1 357ms 357ms 10 9 10s474ms 1s163ms 11 19 5s741ms 302ms 13 15 7s176ms 478ms 14 10 2s662ms 266ms 15 36 17s181ms 477ms 16 31 18s926ms 610ms 17 2 336ms 168ms [ User: intelifix - Total duration: 1m6s - Times executed: 134 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 134 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-09 16:50:52 Duration: 9s143ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-09 10:00:10 Duration: 7s816ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0251466) LIMIT 1;
Date: 2026-06-09 15:43:16 Duration: 1s684ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 111 18m12s 7s927ms 12s957ms 9s841ms create table temp0000281991 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 09 07 16 2m18s 8s649ms 08 22 3m36s 9s860ms 09 8 1m19s 9s894ms 10 13 2m7s 9s839ms 11 3 31s388ms 10s462ms 12 3 29s818ms 9s939ms 14 17 2m56s 10s409ms 15 23 3m49s 9s958ms 16 6 1m2s 10s456ms [ User: intelifix - Total duration: 18m12s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 18m12s - Times executed: 111 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 14:55:20 Duration: 12s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 14:39:51 Duration: 12s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:39:07 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 102 5m6s 221ms 10s817ms 3s9ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 09 00 6 16s862ms 2s810ms 01 6 7s393ms 1s232ms 02 5 6s424ms 1s284ms 03 6 8s177ms 1s362ms 04 6 9s86ms 1s514ms 05 5 11s677ms 2s335ms 07 6 25s123ms 4s187ms 08 6 39s969ms 6s661ms 09 6 17s659ms 2s943ms 10 5 24s343ms 4s868ms 11 6 26s920ms 4s486ms 12 6 30s220ms 5s36ms 13 6 5s618ms 936ms 14 5 23s75ms 4s615ms 15 5 22s218ms 4s443ms 16 6 16s664ms 2s777ms 21 5 7s528ms 1s505ms 22 6 8s26ms 1s337ms [ User: intelifix - Total duration: 5m6s - Times executed: 102 ]
[ Application: psql - Total duration: 5m6s - Times executed: 102 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 00:05:12 Duration: 10s817ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 08:15:10 Duration: 8s169ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 08:25:09 Duration: 7s679ms Database: rio User: intelifix Remote: [local] Application: psql
9 102 19s967ms 150ms 365ms 195ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 09 00 8 1s425ms 178ms 04 6 1s397ms 232ms 05 20 4s339ms 216ms 07 11 2s361ms 214ms 08 6 1s110ms 185ms 09 7 1s479ms 211ms 10 11 2s21ms 183ms 11 10 1s756ms 175ms 12 5 842ms 168ms 14 5 876ms 175ms 15 9 1s635ms 181ms 16 1 235ms 235ms 17 3 484ms 161ms [ User: intelifix - Total duration: 19s967ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 19s967ms - Times executed: 102 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241747232748,241761363442,241768090519,241744144354,241776785362,241744476182,241761144857,241764546670,241778108184,241776822235,241759917475,241747252828,241763971228,241759716771,241763971329,241763993048,241759732935,241765595168,241767976567,241745715360,241742793145,241743249407,241762540011,241759935053,241764067880,241776841833,241762628403,241767950505,241742117691,241746460821,241743247588,241742967482,241770124151,241743257488,241744295053,241776842742,241765622646,241744287678,241743189299,241742698589,241744716789,241744605162,241761474867,241745603655', NULL, NULL, 0464, 00);
Date: 2026-06-09 05:27:14 Duration: 365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '63', 2, '229713396989,229640789701,229828194343,229825855978,229679143355,229695153144,229703066385,229792961332,229798573540,229646802735', NULL, NULL, 0137, 00);
Date: 2026-06-09 07:51:13 Duration: 326ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241679278090,241619428691,241675388294,241650424949,241649554146,241657201627,241732845058,241677406572,241647346276,241631765878,241630832544,241596193237,241667775666,241675858295,241605925062,230040148395,241715534850,241674120203,241708671521,241663288102,241628857883,241695279494,241630988900', NULL, NULL, 0320, 00);
Date: 2026-06-09 04:57:01 Duration: 300ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 97 17s59ms 150ms 367ms 175ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 09 05 1 199ms 199ms 07 2 484ms 242ms 08 6 1s597ms 266ms 10 1 173ms 173ms 11 2 309ms 154ms 13 3 498ms 166ms 14 5 854ms 170ms 15 19 3s133ms 164ms 16 38 6s429ms 169ms 17 20 3s379ms 168ms [ User: intelifix - Total duration: 17s59ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 17s59ms - Times executed: 97 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-08", "data-ate" : "2026-06-08", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-09 08:00:15 Duration: 367ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-08", "data-ate" : "2026-06-08", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-09 07:59:21 Duration: 321ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-06-08", "data-ate" : "2026-06-08", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-09 08:01:49 Duration: 308ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 77 32s777ms 273ms 704ms 425ms 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 #11
Day Hour Count Duration Avg duration Jun 09 00 1 381ms 381ms 04 2 772ms 386ms 05 1 315ms 315ms 06 1 377ms 377ms 07 6 2s368ms 394ms 08 8 3s469ms 433ms 09 8 3s545ms 443ms 10 7 2s666ms 380ms 11 6 2s779ms 463ms 12 2 855ms 427ms 13 7 3s152ms 450ms 14 5 2s84ms 416ms 15 8 3s593ms 449ms 16 6 2s328ms 388ms 17 5 2s360ms 472ms 20 2 931ms 465ms 21 1 392ms 392ms 23 1 403ms 403ms [ User: lenon - Total duration: 32s777ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 32s777ms - Times executed: 77 ]
-
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-09 17:05:05 Duration: 704ms 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-09 10:37:53 Duration: 661ms 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-09 15:52:41 Duration: 654ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
12 72 38s248ms 338ms 820ms 531ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 09 00 1 585ms 585ms 04 2 985ms 492ms 05 1 409ms 409ms 07 5 2s331ms 466ms 08 8 4s449ms 556ms 09 8 4s319ms 539ms 10 7 3s261ms 465ms 11 6 3s363ms 560ms 12 2 1s86ms 543ms 13 7 3s852ms 550ms 14 5 2s705ms 541ms 15 8 4s499ms 562ms 16 6 2s964ms 494ms 17 5 2s856ms 571ms 23 1 577ms 577ms [ User: intelifix - Total duration: 38s248ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 38s248ms - Times executed: 72 ]
-
select * from rs_menu_grants (502, 20, 1);
Date: 2026-06-09 10:37:53 Duration: 820ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-06-09 17:05:05 Duration: 787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (184, 20, 1);
Date: 2026-06-09 14:40:58 Duration: 759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 71 2m58s 163ms 1m26s 2s511ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 09 07 7 2s708ms 386ms 08 8 2s882ms 360ms 09 6 18s207ms 3s34ms 10 11 2m3s 11s183ms 11 7 15s419ms 2s202ms 12 1 513ms 513ms 13 2 1s756ms 878ms 14 8 6s914ms 864ms 15 8 2s800ms 350ms 16 2 829ms 414ms 17 11 3s286ms 298ms [ User: intelifix - Total duration: 2m58s - Times executed: 71 ]
[ Application: psql - Total duration: 2m58s - Times executed: 71 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025341);
Date: 2026-06-09 10:09:36 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025346);
Date: 2026-06-09 10:40:06 Duration: 25s332ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025338);
Date: 2026-06-09 09:57:17 Duration: 14s668ms Database: rio User: intelifix Remote: [local] Application: psql
14 67 4m26s 2s713ms 8s934ms 3s975ms create table temp0000281991 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 09 07 20 1m11s 3s569ms 08 8 26s549ms 3s318ms 09 6 20s65ms 3s344ms 10 6 25s725ms 4s287ms 14 7 31s134ms 4s447ms 15 14 1m4s 4s604ms 16 6 27s5ms 4s500ms [ User: intelifix - Total duration: 4m26s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 4m26s - Times executed: 67 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 07:15:41 Duration: 8s934ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 10:55:11 Duration: 5s923ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 15:34:43 Duration: 5s621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 66 22s661ms 221ms 644ms 343ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 09 07 6 1s892ms 315ms 08 4 1s478ms 369ms 09 6 2s431ms 405ms 10 15 4s735ms 315ms 11 7 2s265ms 323ms 12 4 1s404ms 351ms 13 6 2s138ms 356ms 14 6 2s66ms 344ms 15 4 1s361ms 340ms 16 2 753ms 376ms 17 6 2s135ms 355ms [ User: intelifix - Total duration: 22s661ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 22s661ms - Times executed: 66 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-09 09:13:43 Duration: 644ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-09 14:21:56 Duration: 538ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-09 13:59:16 Duration: 498ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 64 19s500ms 152ms 986ms 304ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 09 08 3 2s205ms 735ms 09 1 256ms 256ms 10 10 2s582ms 258ms 11 10 3s89ms 308ms 13 8 2s166ms 270ms 14 5 1s306ms 261ms 15 14 5s107ms 364ms 16 10 2s245ms 224ms 17 3 539ms 179ms [ User: intelifix - Total duration: 19s500ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 19s500ms - Times executed: 64 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3043066 ORDER BY A.CAI_ORDEM;
Date: 2026-06-09 08:42:00 Duration: 986ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 106789 ORDER BY A.CAI_ORDEM;
Date: 2026-06-09 13:28:45 Duration: 841ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 106854 ORDER BY A.CAI_ORDEM;
Date: 2026-06-09 15:47:55 Duration: 771ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 56 15s20ms 150ms 1s106ms 268ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 09 07 2 403ms 201ms 08 4 823ms 205ms 09 11 2s306ms 209ms 10 4 822ms 205ms 11 11 4s257ms 387ms 12 2 425ms 212ms 13 2 1s210ms 605ms 16 5 1s30ms 206ms 17 15 3s740ms 249ms [ User: intelifix - Total duration: 15s20ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 15s20ms - Times executed: 56 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '743AEFC4F723,9877E749BAB3,9877E70016E9,840112C25B65,8401125FD965,9877E77CC7AA,9877E74B5AF4,84011228B335,9877E7C00FCC,9877E7C08823,84011260A871,8401122A2563,9877E7B9CB60,9877E77CD3A4,1834AF635093,8401128398F6,743AEFAD77C0,8401125FE711,8401127FBAB5,743AEF9C72FD,743AEF95A35F,743AEFC52097,743AEFAD97A9,840112806A79,84011281EE43,743AEFAB9E36,743AEF74D82C', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-06-09 11:55:33 Duration: 1s106ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '743AEF712836,743AEFDB94E5,8401126049E3,743AEF959AF3,840112934036,9877E77CA98F,840112801BB2,84011282C797,84011203BC51,840112C2AA95,743AEFDC7AAA,743AEFDA09C5,9877E77BF969,743AEF5D76B8,840112935981,743AEF9D0FDC,840112806165,840112082EA3,840112602F87,9877E70BEB25,9877E70003A2,743AEFAF4971,743AEF74D2C2', '95;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-06-09 13:31:45 Duration: 849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '216563070821,216555429198,184269759413,216740158697,216724982436,216637577182,216798672344,216632493645,216554503643,216910143043,216400469003,216347692932,216404165671,216838804958,216857160611', '95;1', 'DEFAULT', 09, 062, '','', '', 00);
Date: 2026-06-09 17:09:49 Duration: 677ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 55 11s465ms 150ms 318ms 208ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 09 07 9 1s929ms 214ms 08 6 1s298ms 216ms 09 3 622ms 207ms 10 3 728ms 242ms 14 3 625ms 208ms 15 7 1s528ms 218ms 16 11 2s94ms 190ms 17 13 2s636ms 202ms [ User: intelifix - Total duration: 11s465ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 11s465ms - Times executed: 55 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"189", "usuario" :"507", "tipo" :"N", "itens" :"004", "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-09 10:55:05 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
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-09 17:23:34 Duration: 292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"002", "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-09 07:15:50 Duration: 279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 49 8s36ms 150ms 253ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 09 00 1 155ms 155ms 04 2 334ms 167ms 05 1 154ms 154ms 07 3 473ms 157ms 08 4 620ms 155ms 09 7 1s204ms 172ms 10 1 173ms 173ms 11 6 1s29ms 171ms 12 1 151ms 151ms 13 1 150ms 150ms 14 5 818ms 163ms 15 8 1s297ms 162ms 16 8 1s309ms 163ms 17 1 163ms 163ms [ User: intelifix - Total duration: 8s36ms - Times executed: 49 ]
[ Application: [unknown] - Total duration: 8s36ms - Times executed: 49 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-09 11:54:30 Duration: 253ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-09 09:18:06 Duration: 196ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 039;
Date: 2026-06-09 15:15:32 Duration: 190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 46 8s286ms 153ms 216ms 180ms create table temp0000282099 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 09 14 20 3s562ms 178ms 15 13 2s383ms 183ms 16 9 1s605ms 178ms 17 4 735ms 183ms [ User: intelifix - Total duration: 8s286ms - Times executed: 46 ]
[ Application: [unknown] - Total duration: 8s286ms - Times executed: 46 ]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-07', '2026-06-09');
Date: 2026-06-09 16:43:21 Duration: 216ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-07', '2026-06-09');
Date: 2026-06-09 16:50:25 Duration: 213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-07', '2026-06-09');
Date: 2026-06-09 15:21:47 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m6s 7m32s 4m49s 2 9m39s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 09 05 2 9m39s 4m49s [ User: intelifix - Total duration: 9m39s - Times executed: 2 ]
[ Application: psql - Total duration: 9m39s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-09 05:07:33 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-09 05:09:40 Duration: 2m6s Database: contagem User: intelifix Remote: [local] Application: psql
2 966ms 7m52s 3m1s 32 1h36m41s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 09 07 2 6m30s 3m15s 08 2 5m26s 2m43s 09 2 6m50s 3m25s 10 2 7m56s 3m58s 11 2 5m56s 2m58s 12 2 5m44s 2m52s 13 2 5m20s 2m40s 14 2 6m8s 3m4s 15 2 6m47s 3m23s 16 2 6m17s 3m8s 17 2 5m51s 2m55s 18 2 5m21s 2m40s 19 2 5m28s 2m44s 20 2 6m15s 3m7s 21 2 5m23s 2m41s 22 2 5m21s 2m40s [ User: intelifix - Total duration: 1h36m41s - Times executed: 32 ]
[ Application: psql - Total duration: 1h36m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-09 10:12:54 Duration: 7m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-09 15:11:47 Duration: 6m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-09 09:11:43 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
3 1m20s 1m21s 1m20s 2 2m41s 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 09 20 1 1m21s 1m21s 23 1 1m20s 1m20s [ User: intelifix - Total duration: 2m41s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m41s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-09 20:08:13 Duration: 1m21s 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-09 23:36:32 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 19s254ms 1m38s 58s734ms 2 1m57s 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 09 23 2 1m57s 58s734ms [ User: intelifix - Total duration: 1m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m57s - 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-09 23:14:20 Duration: 1m38s 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-09 23:37:54 Duration: 19s254ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 54s235ms 1m1s 57s626ms 2 1m55s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 09 20 1 1m1s 1m1s 23 1 54s235ms 54s235ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-09 20:05:19 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-09 23:18:07 Duration: 54s235ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 17s535ms 1m28s 53s223ms 2 1m46s copy auditor.auditor_2026_03 (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 #6
Day Hour Count Duration Avg duration Jun 09 23 2 1m46s 53s223ms [ User: intelifix - Total duration: 1m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (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-09 23:11:32 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (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-09 23:37:18 Duration: 17s535ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 150ms 4m30s 30s87ms 215 1h47m48s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 09 07 10 14m32s 1m27s 08 18 11m22s 37s942ms 09 13 9m35s 44s294ms 10 36 19m15s 32s100ms 11 25 11m7s 26s703ms 12 4 3m46s 56s643ms 13 19 2m45s 8s726ms 14 19 10m49s 34s193ms 15 40 19m9s 28s731ms 16 22 4m26s 12s95ms 17 9 57s224ms 6s358ms [ User: intelifix - Total duration: 1h47m48s - Times executed: 215 ]
[ Application: [unknown] - Total duration: 1h47m48s - Times executed: 215 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025340, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 10:06:57 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025365, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 14:30:00 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025355, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-09 11:43:41 Duration: 3m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 406ms 44s863ms 17s217ms 32 9m10s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 09 07 2 39s852ms 19s926ms 08 2 30s53ms 15s26ms 09 2 42s600ms 21s300ms 10 2 43s469ms 21s734ms 11 2 35s154ms 17s577ms 12 2 36s397ms 18s198ms 13 2 30s866ms 15s433ms 14 2 35s279ms 17s639ms 15 2 36s875ms 18s437ms 16 2 29s313ms 14s656ms 17 2 35s626ms 17s813ms 18 2 28s657ms 14s328ms 19 2 26s795ms 13s397ms 20 2 45s510ms 22s755ms 21 2 27s799ms 13s899ms 22 2 26s706ms 13s353ms [ User: intelifix - Total duration: 9m10s - Times executed: 32 ]
[ Application: psql - Total duration: 9m10s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-09 20:12:00 Duration: 44s863ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-09 10:13:36 Duration: 42s390ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-09 09:12:25 Duration: 41s804ms Database: rio User: intelifix Remote: [local] Application: psql
9 5s721ms 35s834ms 14s993ms 40 9m59s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 09 08 1 8s985ms 8s985ms 09 3 43s212ms 14s404ms 10 2 29s316ms 14s658ms 13 1 14s556ms 14s556ms 14 5 1m10s 14s61ms 15 3 40s832ms 13s610ms 16 11 2m42s 14s796ms 17 12 3m 15s53ms 20 2 49s131ms 24s565ms [ User: intelifix - Total duration: 9m59s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 9m59s - Times executed: 40 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-09', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-09 20:17:55 Duration: 35s834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-09', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-09 09:51:55 Duration: 25s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-09', 099, '', '', 0, 6, '2026-06-01');
Date: 2026-06-09 16:31:49 Duration: 16s841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s142ms 33s481ms 12s675ms 9 1m54s create table temp0000281991 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 09 07 3 53s167ms 17s722ms 08 1 10s767ms 10s767ms 09 1 10s128ms 10s128ms 10 2 20s570ms 10s285ms 14 1 9s351ms 9s351ms 15 1 10s97ms 10s97ms [ User: intelifix - Total duration: 1m54s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 9 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-09 07:02:56 Duration: 33s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-09 08:20:17 Duration: 10s767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-09 10:45:34 Duration: 10s665ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s183ms 13s975ms 10s39ms 44 7m21s create table temp0000282043 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 09 09 8 1m15s 9s393ms 10 17 2m50s 10s12ms 11 19 3m16s 10s334ms [ User: intelifix - Total duration: 7m21s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 7m21s - Times executed: 44 ]
-
CREATE TABLE temp0000282043 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:34:09 Duration: 13s975ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282043 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:53:27 Duration: 12s433ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282043 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 10:55:21 Duration: 12s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 7s927ms 12s957ms 9s841ms 111 18m12s create table temp0000281991 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 09 07 16 2m18s 8s649ms 08 22 3m36s 9s860ms 09 8 1m19s 9s894ms 10 13 2m7s 9s839ms 11 3 31s388ms 10s462ms 12 3 29s818ms 9s939ms 14 17 2m56s 10s409ms 15 23 3m49s 9s958ms 16 6 1m2s 10s456ms [ User: intelifix - Total duration: 18m12s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 18m12s - Times executed: 111 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 14:55:20 Duration: 12s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 14:39:51 Duration: 12s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 11:39:07 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s378ms 11s164ms 9s683ms 17 2m44s create table temp0000282099 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 09 17 17 2m44s 9s683ms [ User: intelifix - Total duration: 2m44s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 17 ]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 17:40:15 Duration: 11s164ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 17:23:06 Duration: 10s638ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-09 17:27:04 Duration: 10s594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2s713ms 8s934ms 3s975ms 67 4m26s create table temp0000281991 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 09 07 20 1m11s 3s569ms 08 8 26s549ms 3s318ms 09 6 20s65ms 3s344ms 10 6 25s725ms 4s287ms 14 7 31s134ms 4s447ms 15 14 1m4s 4s604ms 16 6 27s5ms 4s500ms [ User: intelifix - Total duration: 4m26s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 4m26s - Times executed: 67 ]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 07:15:41 Duration: 8s934ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 10:55:11 Duration: 5s923ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281991 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"04-06-2026", "ate" :"09-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-09 15:34:43 Duration: 5s621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2s86ms 1m50s 3s664ms 138 8m25s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 09 00 6 19s637ms 3s272ms 01 6 14s61ms 2s343ms 02 6 13s976ms 2s329ms 03 6 16s662ms 2s777ms 04 6 14s183ms 2s363ms 05 6 16s677ms 2s779ms 06 6 13s384ms 2s230ms 07 6 16s450ms 2s741ms 08 6 18s544ms 3s90ms 09 6 17s133ms 2s855ms 10 6 2m7s 21s242ms 11 6 18s49ms 3s8ms 12 6 18s4ms 3s 13 6 17s638ms 2s939ms 14 6 21s619ms 3s603ms 15 6 19s317ms 3s219ms 16 6 19s816ms 3s302ms 17 6 17s628ms 2s938ms 18 6 17s226ms 2s871ms 19 6 16s613ms 2s768ms 20 6 19s296ms 3s216ms 21 6 16s742ms 2s790ms 22 6 15s536ms 2s589ms [ User: intelifix - Total duration: 8m25s - Times executed: 138 ]
[ Application: psql - Total duration: 8m25s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:06:57 Duration: 1m50s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 00:05:19 Duration: 7s687ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-09 10:55:10 Duration: 4s481ms Database: rio User: intelifix Remote: [local] Application: psql
16 221ms 10s817ms 3s9ms 102 5m6s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 09 00 6 16s862ms 2s810ms 01 6 7s393ms 1s232ms 02 5 6s424ms 1s284ms 03 6 8s177ms 1s362ms 04 6 9s86ms 1s514ms 05 5 11s677ms 2s335ms 07 6 25s123ms 4s187ms 08 6 39s969ms 6s661ms 09 6 17s659ms 2s943ms 10 5 24s343ms 4s868ms 11 6 26s920ms 4s486ms 12 6 30s220ms 5s36ms 13 6 5s618ms 936ms 14 5 23s75ms 4s615ms 15 5 22s218ms 4s443ms 16 6 16s664ms 2s777ms 21 5 7s528ms 1s505ms 22 6 8s26ms 1s337ms [ User: intelifix - Total duration: 5m6s - Times executed: 102 ]
[ Application: psql - Total duration: 5m6s - Times executed: 102 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 00:05:12 Duration: 10s817ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 08:15:10 Duration: 8s169ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-09 08:25:09 Duration: 7s679ms Database: rio User: intelifix Remote: [local] Application: psql
17 163ms 1m26s 2s511ms 71 2m58s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 09 07 7 2s708ms 386ms 08 8 2s882ms 360ms 09 6 18s207ms 3s34ms 10 11 2m3s 11s183ms 11 7 15s419ms 2s202ms 12 1 513ms 513ms 13 2 1s756ms 878ms 14 8 6s914ms 864ms 15 8 2s800ms 350ms 16 2 829ms 414ms 17 11 3s286ms 298ms [ User: intelifix - Total duration: 2m58s - Times executed: 71 ]
[ Application: psql - Total duration: 2m58s - Times executed: 71 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025341);
Date: 2026-06-09 10:09:36 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025346);
Date: 2026-06-09 10:40:06 Duration: 25s332ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025338);
Date: 2026-06-09 09:57:17 Duration: 14s668ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 4s684ms 561ms 1,541 14m24s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 09 07 22 9s631ms 437ms 08 155 1m28s 569ms 09 235 2m20s 595ms 10 248 2m6s 508ms 11 256 2m14s 524ms 12 63 35s918ms 570ms 13 37 26s861ms 725ms 14 142 1m23s 586ms 15 143 1m21s 572ms 16 151 1m24s 560ms 17 89 54s36ms 607ms [ User: intelifix - Total duration: 14m24s - Times executed: 1541 ]
[ Application: [unknown] - Total duration: 14m24s - Times executed: 1541 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40722, 413, '270911029492101746,229781914563,229879773339,229933293961,229739206668,229661330517,216944319295,229934091424,229737905363,229740807374,229784320915,229934151127,229850108793,229664179010,229865556777,216944538688,229782280211,229816672950,229661857290,229726918398,216944748888,229746200315,216940146565,229689789297,229859553442,229865710508,229924827578,229880060719,216939175876,229663764850,229727369206', '246587048699,246652924242,246243043051,246530971028,246465156276,246461395561,246489844870,246568786670,246549651717,246587378181,246113560022,246640163244,246471878403,246648415463,246461361114,246600923354,246628893951,246465889008,246520363954,246456894561,246548359199,246462467495,246513702945,246650044758,246648418392,246639290724,246652467272,246463303750,246467454660,246523822541,,,,,,,,,,,,,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-09 08:35:05 Duration: 4s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (250678, 404, '71429385850007003913,216353764153,216879314254,216864234668,184272657383,216543529104H010937088,216610826872H010999243,216628107481,216640449719,216861195370,216819500314,216834219909,216641413842,216737015069,216699619196,216553095660,216812463858,216635748901H010980467,216633821620H010979362,216633711127,216504516183,216397803434,216553090711,216639105255,216874617577,216815427390,216503219401,216518197383,216733341838,216791107474,216408845656,216870665980,216700132233H010994646,216618212532', '',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":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-09 08:57:23 Duration: 3s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40750, 418, '834025904002893,230044989508,230030647681,230027470717,230041417677,230045166674,230043978286,230051020827,229976184959,229975061629,230044379718,230001268192,230014861832,230041322742,230049499903,229989804762,229975039303,230032772132,229960982028,230043993238,229981906067,230041417980,229990019104,229988145969,230010183945,230027078703,230051782023,229991498989,230051777072,229977030811,230030660512,230030658793', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-09 10:58:38 Duration: 3s46ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 338ms 820ms 531ms 72 38s248ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 09 00 1 585ms 585ms 04 2 985ms 492ms 05 1 409ms 409ms 07 5 2s331ms 466ms 08 8 4s449ms 556ms 09 8 4s319ms 539ms 10 7 3s261ms 465ms 11 6 3s363ms 560ms 12 2 1s86ms 543ms 13 7 3s852ms 550ms 14 5 2s705ms 541ms 15 8 4s499ms 562ms 16 6 2s964ms 494ms 17 5 2s856ms 571ms 23 1 577ms 577ms [ User: intelifix - Total duration: 38s248ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 38s248ms - Times executed: 72 ]
-
select * from rs_menu_grants (502, 20, 1);
Date: 2026-06-09 10:37:53 Duration: 820ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-06-09 17:05:05 Duration: 787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (184, 20, 1);
Date: 2026-06-09 14:40:58 Duration: 759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 151ms 9s143ms 496ms 134 1m6s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 09 08 11 3s732ms 339ms 09 1 357ms 357ms 10 9 10s474ms 1s163ms 11 19 5s741ms 302ms 13 15 7s176ms 478ms 14 10 2s662ms 266ms 15 36 17s181ms 477ms 16 31 18s926ms 610ms 17 2 336ms 168ms [ User: intelifix - Total duration: 1m6s - Times executed: 134 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 134 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-09 16:50:52 Duration: 9s143ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-09 10:00:10 Duration: 7s816ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0251466) LIMIT 1;
Date: 2026-06-09 15:43:16 Duration: 1s684ms 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 09 19 1 0ms 0ms [ User: intelifix - Total duration: 5m27s - Times executed: 1 ]
[ Application: psql - Total duration: 5m27s - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,183 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 344 FATAL entries
- 2062 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,922 Max number of times the same event was reported
- 2,410 Total events found
Rank Times reported Error 1 1,922 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 09 07 107 08 188 09 208 10 268 11 280 12 124 13 110 14 229 15 238 16 123 17 47 - ERROR: prepared statement "_PLAN000000003EAA8440" does not exist
- ERROR: prepared statement "_PLAN000000002EF14100" does not exist
- ERROR: prepared statement "_PLAN00000000356E0E20" does not exist
Statement: DEALLOCATE "_PLAN000000003EAA8440"
Date: 2026-06-09 07:12:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002EF14100"
Date: 2026-06-09 07:13:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000356E0E20"
Date: 2026-06-09 07:14:38 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 339 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 09 00 17 01 14 02 14 03 14 04 14 05 19 06 16 07 16 08 20 09 20 10 20 11 20 12 21 13 19 14 19 15 19 16 19 17 19 18 17 20 1 22 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-09 00:02:08 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-09 00:02:09 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-09 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 09 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-09 08:00:25 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-09 08:20:06 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 46119: "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-09 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
4 25 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 09 18 1 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-09 18:55:04 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-09 19:05:04 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-09 19:15:04 Database: brasilia Application: psql User: intelifix Remote: [local]
5 25 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 09 18 1 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-09 18:55:04 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-09 19:05:04 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-09 19:15:04 Database: brasilia Application: psql User: intelifix Remote: [local]
6 12 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 09 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()Date: 2026-06-09 19:00:07 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-09 19:20:07 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-09 19:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
7 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 09 09 3 10 1 16 5 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 72
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"250967","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-06-09 09:35:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"250967","seriais":[{"serial":"'"},{"serial":"4C195DD47FC7"}]}')
Date: 2026-06-09 09:35:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"155","seriais":[{"serial":"'"},{"serial":"4C195DD47FC7"}]}');
Date: 2026-06-09 09:35:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 8 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 09 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-09 19: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-09 19:35: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-09 20:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
9 4 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 09 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-09 19:10:55 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-09 20:12:00 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-09 21:10:50 Database: brasilia Application: psql User: intelifix Remote: [local]
10 4 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 09 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-09 19:10:55 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-09 20:12:00 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-09 21:10:50 Database: brasilia Application: psql User: intelifix Remote: [local]
11 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 09 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-09 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-09 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
12 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 09 10 2 - LOG: process 1135433 still waiting for ShareLock on transaction 792202 after 1000.187 ms
- LOG: process 1135433 still waiting for ShareLock on transaction 792202 after 85719.300 ms
Detail: Process holding the lock: 1135480. Wait queue: 1135433.
Context: while updating tuple (69697,13) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-09 10:05:11 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1135480. Wait queue: 1135433.
Context: while updating tuple (69697,13) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-09 10:06:35 Database: rio Application: psql User: intelifix Remote: [local]
13 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 09 09 2 - ERROR: unterminated quoted string at or near "''' )" at character 42
- ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''' )
Date: 2026-06-09 09:51:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-06-09 09:51:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 2 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 09 18 2 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-06-09 18:00:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-09 18:35:32 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 09 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-09 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-06-09 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
16 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 09 08 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(40722,413,'270911029405104508,229752665872$270911029024105859,229660669307$270911028455109116,216940203844$270911029015109690,216945424365$270911029064122188,229688469708$270911029445101495,229779222022$270911029402100875,229750294552$270911029024105923,229661729904$270911029363103125,229749219105$270911029443105337,229778909612$270911029123101578,229727096676$270911021305100096,229879749194$270911028454106920,216939234647$270911028503104382,216943071835$270911029115100216,229816910426$270911020275101407,229816393248$270911028454102663,216939664162$270911020033108403,229784282628$270911021146104021,229837168787$270911029415104101,229751846263$270911020214101315,229813434665','246641968391,246457217375,246465279700,246461247791,246516645768,246559519717,246551545762,246485882239,246552055868,246557150721,246520362035,246652912446,246465297075,246468120113,226278920817,246636085674,246463650103,246584744659,246639356060,246531787582,246611840716,,,,,,,,,,,,,,,,,,,,,,,,,,,,,',0141,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0229752665872);Date: 2026-06-09 08:39:48 Database: contagem Application: [unknown] User: intelifix Remote: [local]
17 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 09 03 1 - FATAL: the database system is shutting down
Date: 2026-06-09 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 09 03 1 - LOG: database system was shut down at 2026-06-09 03:05:02 -03
Date: 2026-06-09 03:05:03
19 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 09 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-09 21:25:02 Database: brasilia Application: psql User: intelifix Remote: [local]
20 1 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 09 03 1 - FATAL: terminating connection due to administrator command
Date: 2026-06-09 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
21 1 FATAL: database "..." does not exist NOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 09 10 1 - FATAL: database "jaboatao" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-06-09 10:49:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
22 1 LOG: skipping analyze of "..." --- lock not availableNOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #22
Day Hour Count Jun 09 17 1 - LOG: skipping analyze of "temp0000282121" --- lock not availableNOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-06-09 17:30:30