pgBadger-
Global information
- Generated on Wed Jun 17 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 35,351 log entries in 7s
- Log start from 2026-06-17 00:02:01 to 2026-06-17 23:45:15
-
Overview
Global Stats
- 305 Number of unique normalized queries
- 4,944 Number of queries
- 5h48m37s Total query duration
- 2026-06-17 00:02:14 First query
- 2026-06-17 23:42:24 Last query
- 4 queries/s at 2026-06-17 23:41:44 Query peak
- 5h48m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h48m37s Execute total duration
- 3,618 Number of events
- 25 Number of unique normalized events
- 3,014 Max number of times the same event was reported
- 0 Number of cancellation
- 342 Total number of automatic vacuums
- 836 Total number of automatic analyzes
- 17 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 255 Total number of sessions
- 7 sessions at 2026-06-17 06:05:01 Session peak
- 9d11h36m22s Total duration of sessions
- 53m33s Average duration of sessions
- 19 Average queries per session
- 1m22s Average queries duration per session
- 52m11s Average idle time per session
- 265 Total number of connections
- 4 connections/s at 2026-06-17 11:26:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-17 23:41:44 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-17 14:44:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-17 23:41:44 Date
Queries duration
Key values
- 5h48m37s 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 17 00 25 0ms 18s450ms 3s625ms 14s197ms 55s503ms 55s503ms 01 10 0ms 3s499ms 2s280ms 5s265ms 5s265ms 5s265ms 02 10 0ms 3s84ms 2s331ms 5s611ms 5s611ms 5s611ms 03 12 0ms 3s516ms 1s858ms 5s228ms 5s228ms 5s228ms 04 45 0ms 2s623ms 676ms 3s962ms 4s164ms 5s424ms 05 19 0ms 7m42s 32s724ms 5s366ms 2m18s 7m42s 06 18 0ms 12s770ms 2s810ms 14s416ms 19s101ms 19s101ms 07 210 0ms 8m28s 7s777ms 42s752ms 3m39s 8m30s 08 396 150ms 5m52s 3s716ms 39s427ms 3m48s 5m58s 09 702 150ms 7m51s 2s480ms 1m10s 2m11s 7m53s 10 410 150ms 6m1s 2s834ms 24s644ms 1m31s 6m42s 11 448 150ms 5m58s 2s847ms 38s144ms 2m5s 6m41s 12 149 0ms 6m24s 8s361ms 28s880ms 3m41s 6m57s 13 352 0ms 5m52s 2s18ms 11s481ms 40s960ms 5m56s 14 584 150ms 6m49s 3s826ms 1m2s 4m6s 6m52s 15 492 150ms 6m32s 3s110ms 41s342ms 4m1s 6m34s 16 453 150ms 6m25s 3s329ms 41s248ms 3m45s 7m29s 17 251 0ms 5m52s 5s142ms 1m5s 1m15s 6m24s 18 23 0ms 5m32s 17s92ms 3s185ms 33s568ms 5m33s 19 10 0ms 5m23s 36s996ms 3s212ms 5m52s 5m52s 20 64 0ms 5m37s 12s902ms 2m6s 5m37s 5m37s 21 18 0ms 5m16s 20s595ms 5s560ms 5m47s 5m47s 22 18 0ms 5m3s 19s804ms 5s365ms 5m32s 5m32s 23 225 0ms 1m42s 8s597ms 1m21s 1m42s 2m Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 17 00 10 0 1s683ms 235ms 1s46ms 14s197ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 33 0 247ms 453ms 846ms 1s557ms 05 5 0 301ms 0ms 216ms 833ms 06 9 0 2s191ms 2s24ms 2s370ms 14s416ms 07 152 0 8s673ms 2s668ms 13s666ms 4m7s 08 331 0 3s408ms 4s770ms 30s906ms 3m59s 09 620 0 2s415ms 16s643ms 59s697ms 3m50s 10 372 0 2s741ms 5s809ms 23s431ms 4m6s 11 375 0 2s841ms 8s998ms 24s328ms 3m46s 12 114 0 9s489ms 2s616ms 8s968ms 3m51s 13 310 0 2s106ms 5s117ms 7s570ms 1m10s 14 487 0 3s710ms 16s339ms 54s20ms 6m36s 15 418 0 3s64ms 8s576ms 27s644ms 4m10s 16 374 0 3s548ms 8s624ms 33s129ms 4m21s 17 166 0 5s165ms 20s94ms 47s596ms 53s167ms 18 16 0 23s544ms 1s179ms 3s185ms 5m33s 19 4 0 1m28s 0ms 0ms 5m52s 20 4 54 13s920ms 1m5s 2m6s 5m37s 21 9 0 38s877ms 875ms 917ms 5m47s 22 6 0 55s618ms 0ms 1s104ms 5m32s 23 5 220 8s597ms 1m9s 1m21s 1m59s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 17 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 17 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 8 8.00 0.00% 08 0 8 8.00 0.00% 09 0 9 9.00 0.00% 10 0 6 6.00 0.00% 11 0 9 9.00 0.00% 12 0 3 3.00 0.00% 13 0 7 7.00 0.00% 14 0 8 8.00 0.00% 15 0 6 6.00 0.00% 16 0 9 9.00 0.00% 17 0 4 4.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 17 00 11 0.00/s 01 5 0.00/s 02 4 0.00/s 03 8 0.00/s 04 9 0.00/s 05 8 0.00/s 06 13 0.00/s 07 12 0.00/s 08 20 0.01/s 09 21 0.01/s 10 15 0.00/s 11 18 0.01/s 12 10 0.00/s 13 16 0.00/s 14 16 0.00/s 15 15 0.00/s 16 15 0.00/s 17 13 0.00/s 18 6 0.00/s 19 4 0.00/s 20 8 0.00/s 21 6 0.00/s 22 8 0.00/s 23 4 0.00/s Day Hour Count Average Duration Average idle time Jun 17 00 2 54m16s 53m30s 01 10 1h54s 1h51s 02 5 1h36s 1h31s 03 8 24m35s 24m33s 04 5 54m36s 54m30s 05 9 55m20s 54m11s 06 6 56m 55m51s 07 12 56m58s 54m42s 08 16 51m27s 49m55s 09 17 49m1s 47m19s 10 18 53m41s 52m37s 11 17 49m59s 48m44s 12 16 58m48s 57m30s 13 9 58m44s 57m25s 14 14 59m48s 57m9s 15 16 56m57s 55m22s 16 15 57m2s 55m21s 17 16 48m23s 47m2s 18 10 57m15s 56m36s 19 6 1h2m50s 1h1m48s 20 7 35m20s 33m22s 21 5 1h37s 59m23s 22 6 1h1m20s 1h21s 23 10 45m50s 42m36s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-17 11:26:17 Date
Connections per database
Key values
- rio Main Database
- 265 connections Total
Connections per user
Key values
- intelifix Main User
- 265 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-17 06:05:01 Date
Histogram of session times
Key values
- 202 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 255 sessions Total
Sessions per user
Key values
- intelifix Main User
- 255 sessions Total
Sessions per host
Key values
- [local] Main Host
- 255 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,339 buffers Checkpoint Peak
- 2026-06-17 08:39:37 Date
- 270.074 seconds Highest write time
- 0.042 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-06-17 08:39:37 Date
Checkpoints distance
Key values
- 367.01 Mo Distance Peak
- 2026-06-17 08:39:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 17 00 16,118 724.103s 0.021s 724.163s 01 1,369 137.35s 0.015s 137.381s 02 1,676 168.157s 0.012s 168.185s 03 1,488 148.598s 0.02s 148.651s 04 4,065 407.875s 0.026s 407.941s 05 7,752 757.596s 0.032s 757.68s 06 5,471 334.705s 0.004s 334.718s 07 38,783 2,484.687s 0.113s 2,484.898s 08 60,669 2,969.121s 0.168s 2,969.423s 09 63,239 3,239.426s 0.18s 3,239.744s 10 53,263 2,685.18s 0.157s 2,685.451s 11 52,425 3,124.261s 0.177s 3,124.571s 12 32,105 2,314.992s 0.092s 2,315.173s 13 19,832 2,025.163s 0.141s 2,025.411s 14 65,532 3,132.068s 0.204s 3,132.434s 15 56,170 3,221.29s 0.227s 3,221.651s 16 53,133 3,239.464s 0.183s 3,239.763s 17 26,945 2,405.601s 0.082s 2,405.787s 18 4,060 406.881s 0.032s 406.957s 19 25 2.547s 0.004s 2.56s 20 1,097 112.95s 0.007s 112.969s 21 1,562 156.869s 0.021s 156.951s 22 2,429 243.692s 0.026s 243.754s 23 459 84.314s 0.011s 84.409s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 17 00 0 0 6 547 0.002s 0.008s 01 0 0 0 265 0.004s 0.004s 02 0 0 1 275 0.002s 0.004s 03 0 0 1 346 0.003s 0.007s 04 0 0 1 713 0.003s 0.009s 05 0 0 3 685 0.003s 0.009s 06 0 0 1 30 0.002s 0.002s 07 0 0 25 3,701 0.005s 0.012s 08 0 0 30 3,908 0.004s 0.012s 09 0 0 35 5,510 0.003s 0.012s 10 0 0 25 4,395 0.004s 0.012s 11 0 0 28 5,058 0.004s 0.012s 12 0 0 19 2,274 0.005s 0.011s 13 0 0 8 3,967 0.009s 0.012s 14 0 0 43 5,905 0.003s 0.012s 15 0 0 29 5,036 0.007s 0.012s 16 0 0 29 4,426 0.004s 0.012s 17 0 0 38 3,180 0.005s 0.011s 18 0 0 1 885 0.003s 0.009s 19 0 0 0 7 0.002s 0.002s 20 0 0 1 63 0.002s 0.003s 21 0 0 0 267 0.002s 0.008s 22 0 0 1 454 0.004s 0.01s 23 0 0 3 33 0.005s 0.005s Day Hour Count Avg time (sec) Jun 17 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 17 00 11,275.38 kB 39,572.00 kB 01 1,931.75 kB 22,318.25 kB 02 2,295.25 kB 15,348.25 kB 03 1,168.29 kB 3,249.29 kB 04 2,295.33 kB 3,445.89 kB 05 6,591.56 kB 17,997.56 kB 06 5,588.00 kB 12,728.00 kB 07 33,890.33 kB 59,118.67 kB 08 41,166.17 kB 107,727.25 kB 09 47,120.00 kB 98,663.33 kB 10 34,909.42 kB 113,539.58 kB 11 38,099.25 kB 74,923.58 kB 12 27,872.55 kB 64,881.36 kB 13 11,431.50 kB 34,646.42 kB 14 58,278.83 kB 77,039.17 kB 15 39,403.42 kB 83,722.25 kB 16 39,378.08 kB 79,559.83 kB 17 57,672.36 kB 92,125.82 kB 18 1,953.67 kB 48,634.67 kB 19 86.50 kB 26,860.00 kB 20 2,966.33 kB 21,421.00 kB 21 1,021.43 kB 13,229.43 kB 22 1,402.67 kB 6,499.44 kB 23 10,243.60 kB 24,161.60 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-17 11:27:02 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-17 10:01:22 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 17 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 1 104.00 MiB 104.00 MiB 09 2 208.00 MiB 104.00 MiB 10 2 208.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 3 312.00 MiB 104.00 MiB 15 0 0 0 16 2 208.00 MiB 104.00 MiB 17 6 624.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 17 1.73 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025758, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 16:01:51 Duration: 4m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025720, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 07:19:56 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025735, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 10:44:21 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 11:27:02 - 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-17 08:33:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 17:36:33 - 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-17 16:43:22 - 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-17 16:52:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 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-17 14:03:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 17:27:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 17:29:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 10:01:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 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-17 09:50:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 17:15:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 14:45:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 09:03:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-17 14:22:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 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-17 17:22:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-17 17:09:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 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-17 10:07:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 18.50 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-17 09:18:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 18.50 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-17 09:18:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (98) Main table analyzed (database rio)
- 836 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 98 contagem.pg_catalog.pg_attribute 67 rio.pg_catalog.pg_class 51 contagem.pg_catalog.pg_class 47 rio.public.usuarios 46 rio.pg_catalog.pg_type 43 contagem.pg_catalog.pg_type 37 rio.pg_catalog.pg_index 30 rio.public.temp0000282745 29 contagem.public.usuarios 24 contagem.pg_catalog.pg_index 23 rio.public.temp0000282739 22 rio.pg_catalog.pg_depend 22 rio.public.temp0000282818 22 rio.public.temp0000282733 19 contagem.pg_catalog.pg_depend 19 contagem.public.temp0000226428 17 rio.public.temp0000282832 16 rio.public.temp0000282755 16 rio.public.temp0000282870 11 rio.public.temp0000282844 10 rio.public.temp0000282643 10 rio.public.temp0000282729 9 rio.public.temp0000282813 9 rio.public.temp0000282842 8 contagem.public.nf_entrada 7 rio.public.temp0000282773 7 rio.public.temp0000282852 7 rio.public.temp0000282509 6 contagem.public.temp0000226438 6 rio.public.temp0000282775 5 brasilia.pg_catalog.pg_shdepend 5 rio.public.temp0000282846 5 rio.public.temp0000282805 4 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000282727 4 rio.public.tmp_drill_0175 4 rio.public.temp0000282737 4 rio.public.temp0000282517 4 rio.public.temp0000282848 4 contagem.public.temp0000226412 4 rio.public.temp0000282824 3 rio.public.tmp_drill_0302 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000282858 3 rio.public.temp0000282767 3 rio.public.temp0000282797 3 rio.public.temp0000282645 3 rio.public.temp0000282749 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000282735 2 postgres.pg_catalog.pg_shdepend 2 contagem.public.temp0000226422 1 contagem.public.temp0000226440 1 rio.public.temp0000282535 1 rio.public.temp0000282822 1 rio.public.temp0000282834 1 rio.public.temp0000282689 1 rio.public.temp0000282747 1 rio.public.temp0000282753 1 rio.public.temp0000282783 1 rio.public.temp0000282763 1 rio.public.temp0000282757 1 rio.public.temp0000282759 1 rio.public.temp0000282820 1 contagem.public.temp0000226436 1 contagem.public.temp0000226424 1 contagem.public.parametros 1 contagem.public.temp0000226430 1 rio.public.temp0000282815 1 rio.public.temp0000282765 1 rio.public.temp0000282830 1 rio.public.temp0000282777 1 rio.public.temp0000282779 1 Total 836 Vacuums per table
Key values
- pg_catalog.pg_attribute (32) Main table vacuumed on database rio
- 342 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 32 32 0 0 0 0 0 17,739 5,465 7,574,947 338 8,109 rio.public.temp0000282745 29 0 0 0 0 0 0 21,362 1,788 3,446,524 0 0 contagem.pg_catalog.pg_attribute 27 27 0 0 0 0 0 15,954 3,698 7,022,244 42 1,196 contagem.public.usuarios 22 0 0 0 0 0 0 114 84 50,207 1 1 rio.pg_catalog.pg_class 21 19 0 0 0 0 0 3,714 1,354 1,981,503 92 337 rio.pg_catalog.pg_type 17 17 0 0 0 0 0 1,287 381 538,859 52 218 contagem.pg_catalog.pg_class 16 16 0 0 0 0 0 2,648 625 980,573 10 33 rio.public.temp0000282832 15 0 0 0 0 0 0 19,002 57 1,129,968 0 0 contagem.pg_catalog.pg_type 14 14 0 0 0 0 0 1,302 413 627,616 7 14 rio.public.temp0000282818 11 0 0 0 0 0 0 525 140 212,104 0 0 rio.public.temp0000282643 10 0 0 0 0 0 0 1,199 59 80,312 0 0 rio.public.temp0000282842 9 0 0 0 0 0 0 14,238 36 845,469 0 0 contagem.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,356 867 1,663,079 19 103 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 658 181 165,351 44 114 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 379 104 112,243 6 7 rio.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,716 973 1,332,174 71 633 rio.public.temp0000282773 7 0 0 0 0 0 0 9,489 27 564,007 0 0 rio.public.temp0000282870 7 0 0 0 0 0 0 3,289 32 199,371 0 0 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 7,726 1,504 6,685,216 811 3,924 brasilia.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 916 292 382,686 57 115 rio.public.tmp_drill_0175 6 3 0 0 0 0 0 101 11 22,864 0 0 contagem.public.temp0000226438 6 0 0 0 0 0 0 576 36 39,570 0 0 rio.public.temp0000282509 6 0 0 0 0 0 0 691 158 264,458 0 0 rio.public.temp0000282805 4 0 0 0 0 0 0 4,747 15 282,420 0 0 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 1,415 9 253,530 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,854 396 2,338,419 146 529 rio.public.temp0000282858 3 0 0 0 0 0 0 321 17 21,874 0 0 rio.public.temp0000282517 3 0 0 0 0 0 0 161 153 249,712 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 182 82 165,131 8 17 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 310 102 344,812 25 63 rio.public.temp0000282797 2 0 0 0 0 0 0 3,162 8 187,764 0 0 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 78,125 55,042 69,079,463 11,461 219,841 contagem.public.temp0000226422 1 0 0 0 0 0 0 95 6 6,536 0 0 rio.public.temp0000282824 1 0 0 0 0 0 0 91 6 6,291 0 0 rio.public.temp0000282535 1 0 0 0 0 0 0 1,580 4 93,823 0 0 rio.public.usuarios 1 0 0 0 0 0 0 11 8 4,338 3 3 rio.public.temp0000282822 1 0 0 0 0 0 0 91 6 6,291 0 0 rio.public.temp0000282689 1 0 0 0 0 0 0 144 6 9,484 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 58 14 52,276 0 0 rio.public.temp0000282763 1 0 0 0 0 0 0 86 6 5,984 0 0 rio.public.temp0000282757 1 0 0 0 0 0 0 86 6 5,980 0 0 rio.public.temp0000282759 1 0 0 0 0 0 0 1,583 4 94,000 0 0 contagem.public.temp0000226436 1 0 0 0 0 0 0 95 6 6,535 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,472 1,049 3,236,281 1,006 7,274 contagem.public.temp0000226430 1 0 0 0 0 0 0 95 6 6,536 0 0 rio.public.temp0000282815 1 0 0 0 0 0 0 1,583 4 94,000 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 85 2 7,809 0 0 rio.public.temp0000282777 1 0 0 0 0 0 0 87 6 6,047 0 0 rio.public.temp0000282779 1 0 0 0 0 0 0 87 6 6,048 0 0 rio.public.temp0000282645 1 0 0 0 0 0 0 47 6 3,561 0 0 Total 342 187 0 0 0 0 0 226,634 75,260 112,496,290 14,199 242,531 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (18.5) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.44 rio.public.temp0000282745 0 0 0.94 contagem.pg_catalog.pg_attribute 0 0 1.69 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.56 rio.pg_catalog.pg_type 0 0 0.13 contagem.pg_catalog.pg_class 0 0 0.27 rio.public.temp0000282832 0 0 0.7 contagem.pg_catalog.pg_type 0 0 0.13 rio.public.temp0000282818 0 0 0.17 rio.public.temp0000282643 0 0 0.15 rio.public.temp0000282842 0 0 0.46 contagem.pg_catalog.pg_depend 0 0 0.39 rio.pg_catalog.pg_index 0 0 0.08 contagem.pg_catalog.pg_index 0 0 0.08 rio.pg_catalog.pg_depend 0 0 0.59 rio.public.temp0000282773 0 0 0.31 rio.public.temp0000282870 0 0 0.18 rio.pg_catalog.pg_statistic 0 0 0.88 brasilia.pg_catalog.pg_shdepend 0 0 0.16 rio.public.tmp_drill_0175 0 0 0 contagem.public.temp0000226438 0 0 0.06 rio.public.temp0000282509 0 0 0.04 rio.public.temp0000282805 0 0 0.2 rio.public.tmp_drill_0302 0 0 0.06 rio.pg_toast.pg_toast_2619 0 0 0.14 rio.public.temp0000282858 0 0 0.06 rio.public.temp0000282517 0 0 0.05 contagem.public.nf_entrada 0 0 0.03 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000282797 0 0 0.1 rio.auditor.auditor_2026_06 0 0 18.5 contagem.public.temp0000226422 0 0 0.01 rio.public.temp0000282824 0 0 0.02 rio.public.temp0000282535 0 0 0.04 rio.public.usuarios 0 0 0 rio.public.temp0000282822 0 0 0.01 rio.public.temp0000282689 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000282763 0 0 0.01 rio.public.temp0000282757 0 0 0.01 rio.public.temp0000282759 0 0 0.04 contagem.public.temp0000226436 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.12 contagem.public.temp0000226430 0 0 0.01 rio.public.temp0000282815 0 0 0.05 brasilia.pg_catalog.pg_statistic 0 0 0 rio.public.temp0000282777 0 0 0.01 rio.public.temp0000282779 0 0 0.01 rio.public.temp0000282645 0 0 0.01 Total 0 0 29.95 Tuples removed per table
Key values
- pg_catalog.pg_attribute (116029) Main table with removed tuples on database rio
- 292814 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 32 32 116,029 785,239 13,576 133 18,394 contagem.pg_catalog.pg_attribute 27 27 96,473 655,021 64 156 14,494 rio.public.tmp_drill_0302 3 3 20,512 21,191 0 0 535 rio.pg_catalog.pg_statistic 6 6 11,416 49,291 204 0 7,716 rio.pg_catalog.pg_depend 8 8 7,720 153,071 6 0 1,472 contagem.pg_catalog.pg_depend 9 9 7,560 169,223 0 0 1,584 brasilia.pg_catalog.pg_shdepend 6 6 5,489 51,301 298 0 606 contagem.pg_catalog.pg_statistic 1 1 4,195 7,274 0 0 1,011 rio.pg_catalog.pg_type 17 17 3,904 39,707 686 0 1,114 rio.pg_catalog.pg_class 21 19 3,813 76,563 3,577 8 3,009 contagem.pg_catalog.pg_class 16 16 3,322 51,892 0 0 1,862 contagem.pg_catalog.pg_type 14 14 3,255 31,554 0 6 937 rio.pg_catalog.pg_index 9 9 2,579 17,417 17 0 531 contagem.pg_catalog.pg_index 8 8 1,972 15,194 0 7 411 contagem.public.usuarios 22 0 1,331 506 0 0 44 rio.auditor.auditor_2026_06 1 0 1,204 13,124,791 0 0 615,691 rio.pg_toast.pg_toast_2619 3 3 1,104 2,327 1 0 852 contagem.public.nf_entrada 2 2 439 2,320 0 0 138 contagem.pg_toast.pg_toast_2619 2 2 207 224 0 0 118 brasilia.pg_catalog.pg_statistic 1 1 180 449 0 0 36 rio.public.usuarios 1 0 69 621 114 0 16 brasilia.pg_toast.pg_toast_2619 1 1 41 14 0 6 12 contagem.public.temp0000226422 1 0 0 1,132 0 41 87 rio.public.temp0000282805 4 0 0 88,973 0 0 6,400 rio.public.temp0000282824 1 0 0 1,796 0 45 83 rio.public.temp0000282535 1 0 0 22,231 0 0 1,600 rio.public.temp0000282643 10 0 0 54,654 0 384 1,216 rio.public.temp0000282822 1 0 0 1,796 0 45 83 rio.public.temp0000282689 1 0 0 6,102 0 56 136 rio.public.temp0000282773 7 0 0 155,647 0 0 11,200 rio.public.temp0000282832 15 0 0 333,928 0 0 24,000 rio.public.temp0000282763 1 0 0 1,692 0 50 78 rio.public.temp0000282757 1 0 0 1,692 0 50 78 rio.public.temp0000282759 1 0 0 22,272 0 0 1,600 contagem.public.temp0000226436 1 0 0 1,139 0 41 87 contagem.public.temp0000226430 1 0 0 1,136 0 41 87 rio.public.temp0000282815 1 0 0 22,273 0 0 1,600 rio.public.tmp_drill_0175 6 3 0 2,827 861 0 55 rio.public.temp0000282858 3 0 0 19,760 0 135 441 rio.public.temp0000282870 7 0 0 79,556 0 155 5,221 rio.public.temp0000282517 3 0 0 18,812 0 157 419 contagem.public.temp0000226438 6 0 0 6,854 0 240 528 rio.public.temp0000282509 6 0 0 29,444 0 113 655 rio.public.temp0000282745 29 0 0 419,100 0 540 29,668 rio.public.temp0000282842 9 0 0 200,301 0 0 14,400 rio.public.temp0000282797 2 0 0 44,485 0 0 3,200 rio.public.temp0000282777 1 0 0 1,719 0 49 79 rio.public.temp0000282779 1 0 0 1,721 0 49 79 rio.public.temp0000282818 11 0 0 66,697 0 434 2,766 rio.public.temp0000282645 1 0 0 1,886 0 25 39 Total 342 187 292,814 16,864,815 19,404 2,966 776,468 Pages removed per table
Key values
- public.temp0000282745 (540) Main table with removed pages on database rio
- 2966 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282745 29 0 0 540 rio.public.temp0000282818 11 0 0 434 rio.public.temp0000282643 10 0 0 384 contagem.public.temp0000226438 6 0 0 240 rio.public.temp0000282517 3 0 0 157 contagem.pg_catalog.pg_attribute 27 27 96473 156 rio.public.temp0000282870 7 0 0 155 rio.public.temp0000282858 3 0 0 135 rio.pg_catalog.pg_attribute 32 32 116029 133 rio.public.temp0000282509 6 0 0 113 rio.public.temp0000282689 1 0 0 56 rio.public.temp0000282763 1 0 0 50 rio.public.temp0000282757 1 0 0 50 rio.public.temp0000282777 1 0 0 49 rio.public.temp0000282779 1 0 0 49 rio.public.temp0000282824 1 0 0 45 rio.public.temp0000282822 1 0 0 45 contagem.public.temp0000226422 1 0 0 41 contagem.public.temp0000226436 1 0 0 41 contagem.public.temp0000226430 1 0 0 41 rio.public.temp0000282645 1 0 0 25 rio.pg_catalog.pg_class 21 19 3813 8 contagem.pg_catalog.pg_index 8 8 1972 7 brasilia.pg_toast.pg_toast_2619 1 1 41 6 contagem.pg_catalog.pg_type 14 14 3255 6 rio.auditor.auditor_2026_06 1 0 1204 0 rio.public.temp0000282805 4 0 0 0 rio.public.temp0000282535 1 0 0 0 rio.public.usuarios 1 0 69 0 rio.pg_catalog.pg_statistic 6 6 11416 0 contagem.public.nf_entrada 2 2 439 0 rio.public.tmp_drill_0302 3 3 20512 0 rio.public.temp0000282773 7 0 0 0 rio.public.temp0000282832 15 0 0 0 brasilia.pg_catalog.pg_shdepend 6 6 5489 0 contagem.pg_catalog.pg_class 16 16 3322 0 rio.public.temp0000282759 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4195 0 rio.pg_toast.pg_toast_2619 3 3 1104 0 rio.public.temp0000282815 1 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 180 0 rio.public.tmp_drill_0175 6 3 0 0 contagem.pg_toast.pg_toast_2619 2 2 207 0 rio.pg_catalog.pg_type 17 17 3904 0 rio.pg_catalog.pg_depend 8 8 7720 0 rio.public.temp0000282842 9 0 0 0 rio.public.temp0000282797 2 0 0 0 contagem.public.usuarios 22 0 1331 0 contagem.pg_catalog.pg_depend 9 9 7560 0 rio.pg_catalog.pg_index 9 9 2579 0 Total 342 187 292,814 2,966 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 17 00 0 1 01 0 0 02 0 0 03 0 0 04 0 5 05 6 8 06 0 0 07 17 36 08 31 73 09 36 95 10 23 71 11 35 94 12 13 32 13 23 64 14 53 131 15 31 79 16 25 60 17 48 84 18 0 1 19 0 0 20 0 0 21 1 2 22 0 0 23 0 0 - 18.50 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m38s 2m38s 2m38s 2m38s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255169, 184, '919481078449,3093BC4BDD8A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-17 14:38:34 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255069, 450, 'CP2431LV0P7,C4509CEA9EB4$CP2248LVCU9,B85E71D8D038$CP2242LVKDU,B85E71C9E8E8$CP2435LV1HY,C4509CEF4164$CP2439LV4SC,C4509CF494B4$CP2207LV5UE,3C82C06AF43C$CP2210LVAZC,3C82C0CFD6F8$CP2114LV8W9,08A7C0520CBC$CP2523LV00B,B85E710C8E50$CP2439LV9JM,C4509CF4F1E4$CP2205LV5WF,3C82C06B20EC$CP2522LV09K,B85E710C85A4$CP2233LV7WZ,4075C3B5A364$CP2210LV39F,3C82C0C4FB20$CP2239LV3SH,4075C3C20ED8$CP2534LV4RG,3C82C092A490$CP2431LV3K9,C4509CEAAA54$CP2522LV1B9,B85E710DE19C$CP2131LVL6V,ECA81F1A7A7C$CP2206LV7E5,3C82C06737D4$CP2432LV4YT,C4509CEAB8C4$CP2435LV3HA,C4509CF1331C$CP2239LV270,4075C3BFAA08$CP2301LV8K7,B85E71E695B0$CP2530LV02N,F8D2ACC9E6EC$CP2347LV1GW,400FC17E221C$CP2528LV5N7,F8D2AC4CE9C4$CP2429LV5UB,C4509CBD09FC$CP2347LV468,400FC17EF7C4$CP2529LV1N5,3C82C08C9514$CP2107LV0SC,E4BFFAF0F47C$CP2242LV26V,B85E71C84308$CP2109LV4E7,E4BFFAF520DC$CP2120LV5RT,08A7C06CA424$CP2218LV4DU,00CB7ADC2CF8$CP2529LV9WZ,3C82C08C9604$CP2106LVABH,484BD4B40B9C', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 15:41:29 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255068, 450, '921141128769,582FF79C2D60,209A7DBB2895,D0CF0EFD80BC,209A7DBABD49,CC5830E2A90A,94988F93D813,CC5830E2A957,5CFA257F6D1C,186A81D5137B,841EA38D5D10,943C96AB76BA,D833B7CB45C4,209A7DBC6CCC,943C96AA3C70,C4EB429FEE6D,94988F956ABD,D0CF0EFDCDFB,582FF716A015,345D9EB3E4F1,20B82BF82F29,841EA391ACE5,44D454949943,CC583002D67F,186A81D5111A,64FD965E0FC1,841EA3974195,38A6592471B8,64FD965E4CC2,209A7DBC2694,186A81D5B657,D833B7CB4642,6CBAB8EA95DF,D0CF0EFDD724,5CFA25AD2B95,E4C0E29782B4,841EA38BF7D1,44D4549464FB,C03C047F48A5,ACD75BB809F9', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 16:00:19 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1m22s 1m22s 1m22s 1m22s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 08:36:34 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 00:05:21 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 11:25:11 Database: rio User: intelifix Remote: [local] Application: psql
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000282745;-
DROP TABLE IF EXISTS temp0000282745;
Date: 2026-06-17 12:44:45 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282745;
Date: 2026-06-17 09:54:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000282842;-
DROP TABLE IF EXISTS temp0000282842;
Date: 2026-06-17 15:33:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282842;
Date: 2026-06-17 15:33:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
5 1 1s 1s 1s 1s drop table if exists temp0000282832;-
DROP TABLE IF EXISTS temp0000282832;
Date: 2026-06-17 16:44:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282832;
Date: 2026-06-17 16:44:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m38s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255169, 184, '919481078449,3093BC4BDD8A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-06-17 14:38:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1m22s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-17 08:36:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000282745;[ Date: 2026-06-17 12:44:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000282842;[ Date: 2026-06-17 15:33:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s DROP TABLE IF EXISTS temp0000282832;[ Date: 2026-06-17 16:44:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,820 Total read queries
- 883 Total write queries
Queries by database
Key values
- rio Main database
- 3,889 Requests
- 5h33m49s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,852 Requests
User Request type Count Duration etiquetas Total 5 901ms select 5 901ms intelifix Total 4,852 5h47m33s copy to 274 39m11s ddl 609 36m49s others 241 24m29s select 3,728 4h7m1s lenon Total 87 1m3s select 87 1m3s Duration by user
Key values
- 5h47m33s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 5 901ms select 5 901ms intelifix Total 4,852 5h47m33s copy to 274 39m11s ddl 609 36m49s others 241 24m29s select 3,728 4h7m1s lenon Total 87 1m3s select 87 1m3s Queries by host
Key values
- [local] Main host
- 4,944 Requests
- 5h48m37s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,253 Requests
- 2h51m58s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-17 07:55:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,863 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 07:13:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 09:12:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m42s analyze verbose;[ Date: 2026-06-17 05:07:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 14:11:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 15:11:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 16:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 12:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 10:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 11:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 08:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 17:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 13:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 20:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 18:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 19:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 21:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-17 22:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025758, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-17 16:01:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025720, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-17 07:19:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025735, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-17 10:44:21 - 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 1h39m35s 32 896ms 8m28s 3m6s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 17 07 2 8m30s 4m15s 08 2 5m53s 2m56s 09 2 7m57s 3m58s 10 2 6m3s 3m1s 11 2 6m 3m 12 2 6m26s 3m13s 13 2 5m53s 2m56s 14 2 6m54s 3m27s 15 2 6m34s 3m17s 16 2 6m26s 3m13s 17 2 5m53s 2m56s 18 2 5m34s 2m47s 19 2 5m24s 2m42s 20 2 5m39s 2m49s 21 2 5m18s 2m39s 22 2 5m4s 2m32s [ User: intelifix - Total duration: 1h39m35s - Times executed: 32 ]
[ Application: psql - Total duration: 1h39m35s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-17 07:13:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-17 09:12:52 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-17 14:11:51 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: psql
2 1h32m7s 185 153ms 4m19s 29s877ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 17 07 14 11m29s 49s254ms 08 5 8m30s 1m42s 09 13 9m20s 43s133ms 10 14 6m10s 26s441ms 11 10 6m32s 39s290ms 12 9 10m12s 1m8s 13 20 35s788ms 1s789ms 14 34 14m55s 26s334ms 15 20 8m12s 24s628ms 16 22 10m12s 27s856ms 17 24 5m54s 14s768ms [ User: intelifix - Total duration: 1h32m7s - Times executed: 185 ]
[ Application: [unknown] - Total duration: 1h32m7s - Times executed: 185 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025758, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 16:01:51 Duration: 4m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025720, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 07:19:56 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025735, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 10:44:21 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 18m15s 1,210 150ms 2m38s 905ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 17 07 24 15s231ms 634ms 08 93 1m4s 690ms 09 182 2m22s 780ms 10 49 44s926ms 916ms 11 103 1m20s 781ms 12 56 27s81ms 483ms 13 91 1m 669ms 14 157 4m48s 1s836ms 15 174 2m45s 948ms 16 208 2m47s 807ms 17 66 32s574ms 493ms 18 7 6s883ms 983ms [ User: intelifix - Total duration: 18m15s - Times executed: 1210 ]
[ Application: [unknown] - Total duration: 18m15s - Times executed: 1210 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255169, 184, '919481078449,3093BC4BDD8A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-17 14:38:34 Duration: 2m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255069, 450, 'CP2431LV0P7,C4509CEA9EB4$CP2248LVCU9,B85E71D8D038$CP2242LVKDU,B85E71C9E8E8$CP2435LV1HY,C4509CEF4164$CP2439LV4SC,C4509CF494B4$CP2207LV5UE,3C82C06AF43C$CP2210LVAZC,3C82C0CFD6F8$CP2114LV8W9,08A7C0520CBC$CP2523LV00B,B85E710C8E50$CP2439LV9JM,C4509CF4F1E4$CP2205LV5WF,3C82C06B20EC$CP2522LV09K,B85E710C85A4$CP2233LV7WZ,4075C3B5A364$CP2210LV39F,3C82C0C4FB20$CP2239LV3SH,4075C3C20ED8$CP2534LV4RG,3C82C092A490$CP2431LV3K9,C4509CEAAA54$CP2522LV1B9,B85E710DE19C$CP2131LVL6V,ECA81F1A7A7C$CP2206LV7E5,3C82C06737D4$CP2432LV4YT,C4509CEAB8C4$CP2435LV3HA,C4509CF1331C$CP2239LV270,4075C3BFAA08$CP2301LV8K7,B85E71E695B0$CP2530LV02N,F8D2ACC9E6EC$CP2347LV1GW,400FC17E221C$CP2528LV5N7,F8D2AC4CE9C4$CP2429LV5UB,C4509CBD09FC$CP2347LV468,400FC17EF7C4$CP2529LV1N5,3C82C08C9514$CP2107LV0SC,E4BFFAF0F47C$CP2242LV26V,B85E71C84308$CP2109LV4E7,E4BFFAF520DC$CP2120LV5RT,08A7C06CA424$CP2218LV4DU,00CB7ADC2CF8$CP2529LV9WZ,3C82C08C9604$CP2106LVABH,484BD4B40B9C', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 15:41:29 Duration: 4s242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255068, 450, '921141128769,582FF79C2D60,209A7DBB2895,D0CF0EFD80BC,209A7DBABD49,CC5830E2A90A,94988F93D813,CC5830E2A957,5CFA257F6D1C,186A81D5137B,841EA38D5D10,943C96AB76BA,D833B7CB45C4,209A7DBC6CCC,943C96AA3C70,C4EB429FEE6D,94988F956ABD,D0CF0EFDCDFB,582FF716A015,345D9EB3E4F1,20B82BF82F29,841EA391ACE5,44D454949943,CC583002D67F,186A81D5111A,64FD965E0FC1,841EA3974195,38A6592471B8,64FD965E4CC2,209A7DBC2694,186A81D5B657,D833B7CB4642,6CBAB8EA95DF,D0CF0EFDD724,5CFA25AD2B95,E4C0E29782B4,841EA38BF7D1,44D4549464FB,C03C047F48A5,ACD75BB809F9', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 16:00:19 Duration: 4s139ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 10m4s 28 18s145ms 37s533ms 21s572ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 17 08 2 55s678ms 27s839ms 09 4 1m19s 19s781ms 10 2 38s159ms 19s79ms 11 5 1m39s 19s855ms 13 1 32s904ms 32s904ms 14 3 1m7s 22s559ms 15 5 1m49s 21s898ms 16 4 1m20s 20s176ms 17 2 41s6ms 20s503ms [ User: intelifix - Total duration: 10m4s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 10m4s - Times executed: 28 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-17 08:59:05 Duration: 37s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-17 13:55:44 Duration: 32s904ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-17 14:00:06 Duration: 24s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 10m 3 368ms 7m42s 3m20s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 17 05 3 10m 3m20s [ User: intelifix - Total duration: 10m - Times executed: 3 ]
[ Application: psql - Total duration: 10m - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-17 05:07:43 Duration: 7m42s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-17 05:10:01 Duration: 2m18s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-17 05:07:43 Duration: 368ms Database: brasilia User: intelifix Remote: [local] Application: psql
6 9m41s 32 362ms 59s210ms 18s156ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 17 07 2 47s120ms 23s560ms 08 2 28s475ms 14s237ms 09 2 1m 30s252ms 10 2 36s118ms 18s59ms 11 2 32s100ms 16s50ms 12 2 32s985ms 16s492ms 13 2 28s710ms 14s355ms 14 2 40s271ms 20s135ms 15 2 44s99ms 22s49ms 16 2 32s164ms 16s82ms 17 2 32s126ms 16s63ms 18 2 31s618ms 15s809ms 19 2 27s786ms 13s893ms 20 2 49s80ms 24s540ms 21 2 29s732ms 14s866ms 22 2 28s117ms 14s58ms [ User: intelifix - Total duration: 9m41s - Times executed: 32 ]
[ Application: psql - Total duration: 9m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-17 09:13:52 Duration: 59s210ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-17 20:11:27 Duration: 48s422ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-17 07:14:16 Duration: 46s204ms Database: rio User: intelifix Remote: [local] Application: psql
7 7m55s 45 8s149ms 31s272ms 10s561ms create table temp0000282745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 17 07 16 2m53s 10s848ms 08 9 1m36s 10s709ms 09 7 1m17s 11s125ms 10 2 19s318ms 9s659ms 11 3 29s932ms 9s977ms 12 8 1m18s 9s772ms [ User: intelifix - Total duration: 7m55s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 7m55s - Times executed: 45 ]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 07:14:13 Duration: 31s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 09:05:28 Duration: 13s471ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 08:30:42 Duration: 12s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m42s 138 1s895ms 1m25s 3s354ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 17 00 6 21s166ms 3s527ms 01 6 16s373ms 2s728ms 02 6 15s607ms 2s601ms 03 6 15s946ms 2s657ms 04 6 13s237ms 2s206ms 05 6 12s287ms 2s47ms 06 6 13s422ms 2s237ms 07 6 16s516ms 2s752ms 08 6 1m38s 16s405ms 09 6 17s731ms 2s955ms 10 6 17s625ms 2s937ms 11 6 19s575ms 3s262ms 12 6 17s19ms 2s836ms 13 6 15s981ms 2s663ms 14 6 16s592ms 2s765ms 15 6 17s435ms 2s905ms 16 6 17s633ms 2s938ms 17 6 17s552ms 2s925ms 18 6 15s654ms 2s609ms 19 6 17s286ms 2s881ms 20 6 18s358ms 3s59ms 21 6 16s988ms 2s831ms 22 6 14s460ms 2s410ms [ User: intelifix - Total duration: 7m42s - Times executed: 138 ]
[ Application: psql - Total duration: 7m42s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 08:36:34 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 00:05:21 Duration: 8s756ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 11:25:11 Duration: 5s286ms Database: rio User: intelifix Remote: [local] Application: psql
9 6m57s 1,019 150ms 2s280ms 409ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 17 06 3 2s935ms 978ms 07 39 24s622ms 631ms 08 149 1m15s 507ms 09 134 1m5s 485ms 10 148 56s65ms 378ms 11 129 44s619ms 345ms 12 4 2s64ms 516ms 13 132 47s417ms 359ms 14 145 48s24ms 331ms 15 87 33s117ms 380ms 16 49 17s490ms 356ms [ User: intelifix - Total duration: 6m57s - Times executed: 1019 ]
[ Application: [unknown] - Total duration: 6m57s - Times executed: 1019 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254995", "modelo" : "463", "itens" : "241752343841,241723278300,241754651418,241784411023,241723120002,241751727484,241781694158,241751918995,241724078590,241757816889,241757816687,241757818001,241756882141,241781907994,241720495570,241751805068,241758876577,241736522129,241754745164,241748578704,241752289515,241736730915,241781700725,241748556378,241753506872,241750567079,241720863137,241781495777,241783302037,241782337183,241724117483,241783310927,241754648184,241753694545,241757921928,241735066969,241736887798,241751746880,241781867485,241722529304,241722542134,241758924562,241737394245,241735384150,241724203654,241757874852,241735071213,241748741627,241757071228,241783441220,241724397589,241736439416,241751048091,241782584458,241754757589,241757991531,241782624462,241756988794,241757002130,241782361126", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-17 10:00:22 Duration: 2s280ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255060", "modelo" : "464", "itens" : "241768718996,863400608300709,241767819100,241777848080,241742729401,241745617898,241770137788,241739125368,241738666580,241770120414,241746126668,241768766880,241740495670,241761040729,241768971121,241746482338,241764657590,241764657792,241740672635,241738453754,241747690425,863400609010361,241746160612,241760070320,241762741018,241760150204,241777792442,241760249304,241762781931,241746726682,241739418506,241747686989,241762894848,241761416679,241760092443,241762684143,241765463135,241777910815,241738634052,241745818805,241759980008,241738649508,241738581017,241761637082,241762889214,241747476688,241762890505,241764640317,241761058080,241762734350,241740601618,241740626569,241739163554,241747541925,241761455067,241762881840,241742126379,241767653450,241765448082,241761484969,241742338802,241687379409,241763956579,241760166669", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-17 10:00:28 Duration: 2s111ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254846", "modelo" : "463", "itens" : "241782679999,241753547482,241755924359,241706096667,241720076281,241754581939,241748517990,241755069517,241757830404,241753604458,241706240622,241752274564,241723220214,241753514146,241753557382,241722455761,241723825659,241782289906,241735798185,241783423339,241757014252,241722567792,241783435057,83350053181974C,241753587688,241779512127,833500531812058,241736539807,833500527306557,833500602321276,241750119303,833500601209225,833500526112088,241723280220,833500526103009,83350052730874A,241721676078,241754705160,241719955663,241748838404,83350060570631B,241779541928,83350053282162C,241753592639,241748570926,833500533816966,833500602901337,83350060571999B,241758862132,241719930611,241750518084,241725646263,833500533724266", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-17 08:13:38 Duration: 1s958ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m10s 34 8s461ms 39s658ms 10s885ms create table temp0000282832 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 17 14 8 1m52s 14s120ms 16 6 1m7s 11s281ms 17 20 3m9s 9s472ms [ User: intelifix - Total duration: 6m10s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 6m10s - Times executed: 34 ]
-
CREATE TABLE temp0000282832 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 14:04:40 Duration: 39s658ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282832 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 14:22:37 Duration: 12s176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282832 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 16:53:17 Duration: 12s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 5m52s 94 228ms 10s890ms 3s753ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 17 00 6 16s776ms 2s796ms 01 4 6s430ms 1s607ms 02 4 7s709ms 1s927ms 03 5 6s148ms 1s229ms 04 6 9s49ms 1s508ms 05 5 7s161ms 1s432ms 07 6 31s676ms 5s279ms 08 6 42s404ms 7s67ms 09 6 37s727ms 6s287ms 10 6 33s862ms 5s643ms 11 6 36s830ms 6s138ms 12 6 31s626ms 5s271ms 13 2 2s431ms 1s215ms 14 6 32s763ms 5s460ms 15 6 22s751ms 3s791ms 16 5 15s352ms 3s70ms 21 3 3s837ms 1s279ms 22 6 8s313ms 1s385ms [ User: intelifix - Total duration: 5m52s - Times executed: 94 ]
[ Application: psql - Total duration: 5m52s - Times executed: 94 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 00:05:12 Duration: 10s890ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 14:25:11 Duration: 10s341ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 14:55:11 Duration: 9s948ms Database: rio User: intelifix Remote: [local] Application: psql
12 5m31s 31 8s92ms 14s509ms 10s685ms create table temp0000282842 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 17 14 10 1m45s 10s594ms 15 15 2m50s 11s364ms 16 6 54s844ms 9s140ms [ User: intelifix - Total duration: 5m31s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m31s - Times executed: 31 ]
-
CREATE TABLE temp0000282842 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 15:56:51 Duration: 14s509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282842 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 15:57:10 Duration: 12s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282842 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 15:33:59 Duration: 11s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m57s 2 1m24s 1m32s 1m28s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 17 20 1 1m24s 1m24s 23 1 1m32s 1m32s [ User: intelifix - Total duration: 2m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-17 23:39:28 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-17 20:08:13 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
14 2m25s 14 8s564ms 11s915ms 10s385ms create table temp0000282773 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 17 08 4 38s284ms 9s571ms 09 5 50s981ms 10s196ms 10 5 56s123ms 11s224ms [ User: intelifix - Total duration: 2m25s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m25s - Times executed: 14 ]
-
CREATE TABLE temp0000282773 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 10:02:48 Duration: 11s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282773 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 10:02:19 Duration: 11s723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282773 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 10:03:06 Duration: 11s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m9s 2 26s633ms 1m42s 1m4s 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 #15
Day Hour Count Duration Avg duration Jun 17 23 2 2m9s 1m4s [ User: intelifix - Total duration: 2m9s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m9s - 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-17 23:14:21 Duration: 1m42s 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-17 23:41:07 Duration: 26s633ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1m58s 12 8s801ms 11s545ms 9s870ms create table temp0000282870 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 17 17 12 1m58s 9s870ms [ User: intelifix - Total duration: 1m58s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 1m58s - Times executed: 12 ]
-
CREATE TABLE temp0000282870 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 17:10:26 Duration: 11s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282870 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 17:02:01 Duration: 11s275ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282870 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 17:08:55 Duration: 10s406ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 1m55s 2 56s429ms 58s677ms 57s553ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 17 20 1 58s677ms 58s677ms 23 1 56s429ms 56s429ms [ 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-17 20:05:13 Duration: 58s677ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-17 23:18:35 Duration: 56s429ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 1m50s 2 21s994ms 1m28s 55s350ms 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 #18
Day Hour Count Duration Avg duration Jun 17 23 2 1m50s 55s350ms [ User: intelifix - Total duration: 1m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m50s - 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-17 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-17 23:40:21 Duration: 21s994ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1m40s 58 182ms 51s810ms 1s728ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 17 07 6 2s411ms 401ms 08 4 9s989ms 2s497ms 09 5 5s706ms 1s141ms 10 2 52s70ms 26s35ms 11 4 7s369ms 1s842ms 12 4 1s406ms 351ms 14 10 5s338ms 533ms 15 4 2s315ms 578ms 16 4 4s618ms 1s154ms 17 15 9s36ms 602ms [ User: intelifix - Total duration: 1m40s - Times executed: 58 ]
[ Application: psql - Total duration: 1m40s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025734);
Date: 2026-06-17 10:02:39 Duration: 51s810ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025727);
Date: 2026-06-17 08:33:38 Duration: 8s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025739);
Date: 2026-06-17 11:28:08 Duration: 5s616ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m26s 2 19s993ms 1m6s 43s481ms copy auditor.auditor_2026_04 (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 17 23 2 1m26s 43s481ms [ User: intelifix - Total duration: 1m26s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (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-17 23:12:39 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (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-17 23:40:41 Duration: 19s993ms 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,210 18m15s 150ms 2m38s 905ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 17 07 24 15s231ms 634ms 08 93 1m4s 690ms 09 182 2m22s 780ms 10 49 44s926ms 916ms 11 103 1m20s 781ms 12 56 27s81ms 483ms 13 91 1m 669ms 14 157 4m48s 1s836ms 15 174 2m45s 948ms 16 208 2m47s 807ms 17 66 32s574ms 493ms 18 7 6s883ms 983ms [ User: intelifix - Total duration: 18m15s - Times executed: 1210 ]
[ Application: [unknown] - Total duration: 18m15s - Times executed: 1210 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255169, 184, '919481078449,3093BC4BDD8A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-17 14:38:34 Duration: 2m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255069, 450, 'CP2431LV0P7,C4509CEA9EB4$CP2248LVCU9,B85E71D8D038$CP2242LVKDU,B85E71C9E8E8$CP2435LV1HY,C4509CEF4164$CP2439LV4SC,C4509CF494B4$CP2207LV5UE,3C82C06AF43C$CP2210LVAZC,3C82C0CFD6F8$CP2114LV8W9,08A7C0520CBC$CP2523LV00B,B85E710C8E50$CP2439LV9JM,C4509CF4F1E4$CP2205LV5WF,3C82C06B20EC$CP2522LV09K,B85E710C85A4$CP2233LV7WZ,4075C3B5A364$CP2210LV39F,3C82C0C4FB20$CP2239LV3SH,4075C3C20ED8$CP2534LV4RG,3C82C092A490$CP2431LV3K9,C4509CEAAA54$CP2522LV1B9,B85E710DE19C$CP2131LVL6V,ECA81F1A7A7C$CP2206LV7E5,3C82C06737D4$CP2432LV4YT,C4509CEAB8C4$CP2435LV3HA,C4509CF1331C$CP2239LV270,4075C3BFAA08$CP2301LV8K7,B85E71E695B0$CP2530LV02N,F8D2ACC9E6EC$CP2347LV1GW,400FC17E221C$CP2528LV5N7,F8D2AC4CE9C4$CP2429LV5UB,C4509CBD09FC$CP2347LV468,400FC17EF7C4$CP2529LV1N5,3C82C08C9514$CP2107LV0SC,E4BFFAF0F47C$CP2242LV26V,B85E71C84308$CP2109LV4E7,E4BFFAF520DC$CP2120LV5RT,08A7C06CA424$CP2218LV4DU,00CB7ADC2CF8$CP2529LV9WZ,3C82C08C9604$CP2106LVABH,484BD4B40B9C', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 15:41:29 Duration: 4s242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255068, 450, '921141128769,582FF79C2D60,209A7DBB2895,D0CF0EFD80BC,209A7DBABD49,CC5830E2A90A,94988F93D813,CC5830E2A957,5CFA257F6D1C,186A81D5137B,841EA38D5D10,943C96AB76BA,D833B7CB45C4,209A7DBC6CCC,943C96AA3C70,C4EB429FEE6D,94988F956ABD,D0CF0EFDCDFB,582FF716A015,345D9EB3E4F1,20B82BF82F29,841EA391ACE5,44D454949943,CC583002D67F,186A81D5111A,64FD965E0FC1,841EA3974195,38A6592471B8,64FD965E4CC2,209A7DBC2694,186A81D5B657,D833B7CB4642,6CBAB8EA95DF,D0CF0EFDD724,5CFA25AD2B95,E4C0E29782B4,841EA38BF7D1,44D4549464FB,C03C047F48A5,ACD75BB809F9', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 16:00:19 Duration: 4s139ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,019 6m57s 150ms 2s280ms 409ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 17 06 3 2s935ms 978ms 07 39 24s622ms 631ms 08 149 1m15s 507ms 09 134 1m5s 485ms 10 148 56s65ms 378ms 11 129 44s619ms 345ms 12 4 2s64ms 516ms 13 132 47s417ms 359ms 14 145 48s24ms 331ms 15 87 33s117ms 380ms 16 49 17s490ms 356ms [ User: intelifix - Total duration: 6m57s - Times executed: 1019 ]
[ Application: [unknown] - Total duration: 6m57s - Times executed: 1019 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254995", "modelo" : "463", "itens" : "241752343841,241723278300,241754651418,241784411023,241723120002,241751727484,241781694158,241751918995,241724078590,241757816889,241757816687,241757818001,241756882141,241781907994,241720495570,241751805068,241758876577,241736522129,241754745164,241748578704,241752289515,241736730915,241781700725,241748556378,241753506872,241750567079,241720863137,241781495777,241783302037,241782337183,241724117483,241783310927,241754648184,241753694545,241757921928,241735066969,241736887798,241751746880,241781867485,241722529304,241722542134,241758924562,241737394245,241735384150,241724203654,241757874852,241735071213,241748741627,241757071228,241783441220,241724397589,241736439416,241751048091,241782584458,241754757589,241757991531,241782624462,241756988794,241757002130,241782361126", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-17 10:00:22 Duration: 2s280ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255060", "modelo" : "464", "itens" : "241768718996,863400608300709,241767819100,241777848080,241742729401,241745617898,241770137788,241739125368,241738666580,241770120414,241746126668,241768766880,241740495670,241761040729,241768971121,241746482338,241764657590,241764657792,241740672635,241738453754,241747690425,863400609010361,241746160612,241760070320,241762741018,241760150204,241777792442,241760249304,241762781931,241746726682,241739418506,241747686989,241762894848,241761416679,241760092443,241762684143,241765463135,241777910815,241738634052,241745818805,241759980008,241738649508,241738581017,241761637082,241762889214,241747476688,241762890505,241764640317,241761058080,241762734350,241740601618,241740626569,241739163554,241747541925,241761455067,241762881840,241742126379,241767653450,241765448082,241761484969,241742338802,241687379409,241763956579,241760166669", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-17 10:00:28 Duration: 2s111ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254846", "modelo" : "463", "itens" : "241782679999,241753547482,241755924359,241706096667,241720076281,241754581939,241748517990,241755069517,241757830404,241753604458,241706240622,241752274564,241723220214,241753514146,241753557382,241722455761,241723825659,241782289906,241735798185,241783423339,241757014252,241722567792,241783435057,83350053181974C,241753587688,241779512127,833500531812058,241736539807,833500527306557,833500602321276,241750119303,833500601209225,833500526112088,241723280220,833500526103009,83350052730874A,241721676078,241754705160,241719955663,241748838404,83350060570631B,241779541928,83350053282162C,241753592639,241748570926,833500533816966,833500602901337,83350060571999B,241758862132,241719930611,241750518084,241725646263,833500533724266", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-17 08:13:38 Duration: 1s958ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 250 1m25s 155ms 1s406ms 342ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 17 09 156 56s366ms 361ms 10 67 18s791ms 280ms 11 27 10s535ms 390ms [ User: intelifix - Total duration: 1m25s - Times executed: 250 ]
[ Application: [unknown] - Total duration: 1m25s - Times executed: 250 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42423","seriais":"226070373247","usuario":"416","observacao":""}');
Date: 2026-06-17 11:12:44 Duration: 1s406ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"230057328994,241656744051,241714931930,241676750011,241689481433,241654531838,241646427892,241622439603,241692672844,241614556364,241689141927,241727021920,241679608404,241620693047,241620697794,241680328282,241603064042,241676735564,241711202430,241695513839,241622605354,241676755768,241636058496,230049002223,230043590214,241689133340,241668202835,241607295061,241593319410,241656700714","usuario":"416","observacao":""}');
Date: 2026-06-17 09:15:17 Duration: 1s198ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"E44E12B21079,E44E12B3F529,7C7D21EE6BCF,E44E12B3F589,14200453274E,E44E12B3F4F9,7C7D21F2B787,7C7D21F17217,B47CA607FAD2,E44E12B32929,B47CA607F6DE,DC5193DB84CA,DC5193DAE46A,38165A479DCC,DC5193D92536,E44E12B323A1,7C7D21ED3B53,DC5193D923CA,7C7D21ECDB33,E44E12B3F6C5,DC5193D8E2BA,DC5193DB7E9E,B47CA607FC22,38165A479438,DC5193DAE412,DC5193DAE2A6,B47CA607FEB2,B47CA607F782,7C7D21F2B79B,7C7D21F12D77,DC5193D8E2D2,B47CA607F67A,E44E12B0D121,DC5193D92F26,E44E12B3F0D5,7C7D21F12D67,38165A479FD0,B47CA608DEBA,7C7D21ECDC8B,E44E12B3F1E9,B47CA607FC46,E44E12B0D1E1,E44E12B210E5,E44E12920B0F,7C7D21F172F3,DC5193D8EF1E,1420045327D6","usuario":"416","observacao":""}');
Date: 2026-06-17 09:21:21 Duration: 1s179ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 185 1h32m7s 153ms 4m19s 29s877ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 17 07 14 11m29s 49s254ms 08 5 8m30s 1m42s 09 13 9m20s 43s133ms 10 14 6m10s 26s441ms 11 10 6m32s 39s290ms 12 9 10m12s 1m8s 13 20 35s788ms 1s789ms 14 34 14m55s 26s334ms 15 20 8m12s 24s628ms 16 22 10m12s 27s856ms 17 24 5m54s 14s768ms [ User: intelifix - Total duration: 1h32m7s - Times executed: 185 ]
[ Application: [unknown] - Total duration: 1h32m7s - Times executed: 185 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025758, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 16:01:51 Duration: 4m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025720, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 07:19:56 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025735, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 10:44:21 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 138 7m42s 1s895ms 1m25s 3s354ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 17 00 6 21s166ms 3s527ms 01 6 16s373ms 2s728ms 02 6 15s607ms 2s601ms 03 6 15s946ms 2s657ms 04 6 13s237ms 2s206ms 05 6 12s287ms 2s47ms 06 6 13s422ms 2s237ms 07 6 16s516ms 2s752ms 08 6 1m38s 16s405ms 09 6 17s731ms 2s955ms 10 6 17s625ms 2s937ms 11 6 19s575ms 3s262ms 12 6 17s19ms 2s836ms 13 6 15s981ms 2s663ms 14 6 16s592ms 2s765ms 15 6 17s435ms 2s905ms 16 6 17s633ms 2s938ms 17 6 17s552ms 2s925ms 18 6 15s654ms 2s609ms 19 6 17s286ms 2s881ms 20 6 18s358ms 3s59ms 21 6 16s988ms 2s831ms 22 6 14s460ms 2s410ms [ User: intelifix - Total duration: 7m42s - Times executed: 138 ]
[ Application: psql - Total duration: 7m42s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 08:36:34 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 00:05:21 Duration: 8s756ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 11:25:11 Duration: 5s286ms Database: rio User: intelifix Remote: [local] Application: psql
6 127 23s836ms 150ms 361ms 187ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 17 00 3 552ms 184ms 04 23 4s744ms 206ms 05 2 508ms 254ms 07 10 1s903ms 190ms 08 13 2s282ms 175ms 09 13 2s409ms 185ms 10 12 2s196ms 183ms 11 13 2s196ms 168ms 12 11 1s971ms 179ms 14 13 2s499ms 192ms 15 12 2s214ms 184ms 16 2 356ms 178ms [ User: intelifix - Total duration: 23s836ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 23s836ms - Times executed: 127 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241692613343,241655542430,241712531819,241620774547,241608043855,241607021118,241703448800,241703601217,241679105470,241663120106,241650794963,241636104360,241661476667,241649662137,241636138303,241652133141,241678349706', NULL, NULL, 0320, 00);
Date: 2026-06-17 04:41:20 Duration: 361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241693198709,241603000322,241727078591,241627873355,241653132341,241592993138,230049156480,241664785161,241653103146,230048006783,241654909809,241652386577,241715009210,241698697393,230048192133,241628857176,241708797290', NULL, NULL, 0320, 00);
Date: 2026-06-17 05:33:18 Duration: 291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '216898881933,229723278201,216946419703,216855963434,229647743646,216887806474,229659953749,216904941537,216856401435,216903433746', NULL, NULL, 0131, 00);
Date: 2026-06-17 09:53:22 Duration: 289ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 108 17s555ms 150ms 200ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 17 00 1 166ms 166ms 04 3 488ms 162ms 05 1 165ms 165ms 07 3 470ms 156ms 08 13 2s103ms 161ms 09 15 2s421ms 161ms 10 17 2s727ms 160ms 11 12 1s931ms 160ms 12 1 166ms 166ms 13 4 659ms 164ms 14 14 2s281ms 162ms 15 11 1s830ms 166ms 16 11 1s805ms 164ms 17 2 339ms 169ms [ User: intelifix - Total duration: 17s555ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 17s555ms - Times executed: 108 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 062;
Date: 2026-06-17 15:16:57 Duration: 200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-06-17 14:15:07 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-17 15:07:57 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 94 5m52s 228ms 10s890ms 3s753ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 17 00 6 16s776ms 2s796ms 01 4 6s430ms 1s607ms 02 4 7s709ms 1s927ms 03 5 6s148ms 1s229ms 04 6 9s49ms 1s508ms 05 5 7s161ms 1s432ms 07 6 31s676ms 5s279ms 08 6 42s404ms 7s67ms 09 6 37s727ms 6s287ms 10 6 33s862ms 5s643ms 11 6 36s830ms 6s138ms 12 6 31s626ms 5s271ms 13 2 2s431ms 1s215ms 14 6 32s763ms 5s460ms 15 6 22s751ms 3s791ms 16 5 15s352ms 3s70ms 21 3 3s837ms 1s279ms 22 6 8s313ms 1s385ms [ User: intelifix - Total duration: 5m52s - Times executed: 94 ]
[ Application: psql - Total duration: 5m52s - Times executed: 94 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 00:05:12 Duration: 10s890ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 14:25:11 Duration: 10s341ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 14:55:11 Duration: 9s948ms Database: rio User: intelifix Remote: [local] Application: psql
9 93 17s136ms 151ms 342ms 184ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 17 07 4 1s80ms 270ms 08 4 797ms 199ms 09 2 477ms 238ms 10 9 1s581ms 175ms 11 13 2s185ms 168ms 12 1 208ms 208ms 13 15 2s581ms 172ms 14 19 3s455ms 181ms 15 19 3s282ms 172ms 16 4 721ms 180ms 17 3 764ms 254ms [ User: intelifix - Total duration: 17s136ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 17s136ms - Times executed: 93 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"153", "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-17 17:11:38 Duration: 342ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"129", "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-17 14:47:28 Duration: 316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"62", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1512", "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-17 07:25:34 Duration: 288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 83 34s863ms 268ms 680ms 420ms 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 #10
Day Hour Count Duration Avg duration Jun 17 00 2 804ms 402ms 04 3 1s208ms 402ms 05 1 344ms 344ms 06 1 374ms 374ms 07 7 2s615ms 373ms 08 8 3s275ms 409ms 09 8 3s549ms 443ms 10 5 2s353ms 470ms 11 9 3s759ms 417ms 12 3 1s274ms 424ms 13 7 2s980ms 425ms 14 8 3s696ms 462ms 15 6 2s705ms 450ms 16 7 2s552ms 364ms 17 4 1s764ms 441ms 18 1 398ms 398ms 21 2 735ms 367ms 22 1 472ms 472ms [ User: lenon - Total duration: 34s863ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 34s863ms - Times executed: 83 ]
-
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-17 11:08:18 Duration: 680ms 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-17 10:51:59 Duration: 606ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-17 13:09:24 Duration: 576ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 79 56s876ms 155ms 5s558ms 719ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 17 07 7 2s56ms 293ms 09 2 3s184ms 1s592ms 10 8 15s354ms 1s919ms 11 2 1s859ms 929ms 13 13 12s202ms 938ms 14 16 7s37ms 439ms 15 12 5s478ms 456ms 16 14 6s121ms 437ms 17 5 3s579ms 715ms [ User: intelifix - Total duration: 56s876ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 56s876ms - Times executed: 79 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-17 10:13:08 Duration: 5s558ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-17 10:17:05 Duration: 5s298ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0254952) LIMIT 1;
Date: 2026-06-17 13:25:06 Duration: 2s857ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 79 41s379ms 343ms 763ms 523ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 17 00 2 1s111ms 555ms 04 3 1s563ms 521ms 05 1 489ms 489ms 06 1 518ms 518ms 07 7 3s300ms 471ms 08 8 3s996ms 499ms 09 8 4s442ms 555ms 10 5 2s856ms 571ms 11 8 4s17ms 502ms 12 3 1s608ms 536ms 13 6 3s96ms 516ms 14 8 4s485ms 560ms 15 6 3s232ms 538ms 16 6 2s882ms 480ms 17 4 2s143ms 535ms 18 1 474ms 474ms 21 1 526ms 526ms 22 1 632ms 632ms [ User: intelifix - Total duration: 41s379ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 41s379ms - Times executed: 79 ]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-06-17 11:08:18 Duration: 763ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 19, 1);
Date: 2026-06-17 15:46:54 Duration: 694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-06-17 10:51:59 Duration: 692ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 61 11s988ms 150ms 895ms 196ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 17 06 2 1s477ms 738ms 07 1 362ms 362ms 09 8 1s621ms 202ms 10 1 150ms 150ms 11 3 513ms 171ms 13 4 646ms 161ms 14 6 1s46ms 174ms 15 17 2s918ms 171ms 16 12 2s6ms 167ms 17 7 1s245ms 177ms [ User: intelifix - Total duration: 11s988ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 11s988ms - Times executed: 61 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-06-16", "data-ate" : "2026-06-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-06-17 06:53:29 Duration: 895ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-06-16", "data-ate" : "2026-06-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-06-17 06:53:35 Duration: 582ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-16", "data-ate" : "2026-06-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-17 07:56:35 Duration: 362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 58 1m40s 182ms 51s810ms 1s728ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 17 07 6 2s411ms 401ms 08 4 9s989ms 2s497ms 09 5 5s706ms 1s141ms 10 2 52s70ms 26s35ms 11 4 7s369ms 1s842ms 12 4 1s406ms 351ms 14 10 5s338ms 533ms 15 4 2s315ms 578ms 16 4 4s618ms 1s154ms 17 15 9s36ms 602ms [ User: intelifix - Total duration: 1m40s - Times executed: 58 ]
[ Application: psql - Total duration: 1m40s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025734);
Date: 2026-06-17 10:02:39 Duration: 51s810ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025727);
Date: 2026-06-17 08:33:38 Duration: 8s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025739);
Date: 2026-06-17 11:28:08 Duration: 5s616ms Database: rio User: intelifix Remote: [local] Application: psql
15 53 20s465ms 282ms 728ms 386ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 17 07 5 1s921ms 384ms 08 3 1s174ms 391ms 09 7 2s582ms 368ms 10 4 1s463ms 365ms 11 4 1s507ms 376ms 12 2 645ms 322ms 14 11 4s821ms 438ms 15 5 2s183ms 436ms 16 3 1s65ms 355ms 17 9 3s100ms 344ms [ User: intelifix - Total duration: 20s465ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 20s465ms - Times executed: 53 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-17 14:02:13 Duration: 728ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-17 15:48:08 Duration: 600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-17 10:00:24 Duration: 561ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 51 13s768ms 150ms 954ms 269ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 17 08 8 1s669ms 208ms 09 10 2s501ms 250ms 10 3 549ms 183ms 11 7 1s296ms 185ms 12 2 367ms 183ms 13 1 153ms 153ms 15 15 5s796ms 386ms 16 5 1s434ms 286ms [ User: intelifix - Total duration: 13s768ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 13s768ms - Times executed: 51 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '230009262430,229992660204,229954592033,229936937088,229949379212,229958394648,229963923942,229928361729,229959576570,229946987687,229992452832,229931738892,229930557475,229994512124,229949436770,230003352942,230008712949,230002350005,229997392540,229985625667,229969508089,229939299596,229945464363,229946660305,230013006779,229985380616,229928478585,229958588405,229994669917,229955394445,230013511128,230013045066,229928420119,229992608099,230004978903,230013571212,229928445272,229996436172,229953474460,230004939202,229939024767,229992419090,229964212534,229985336772,229926396183,229921630612,229954788190,230008691432,229946543952,229984902735,230012510615,229961872833,230008695876,229930834551,230012688689,229929170506,229949328904,229920937277,230009427092,229958171215,229992682529,230003310817,229945452544,229996637987,229964251225,229936928906,229948258181,229958665056,230008776467,229929529508,229994652542,229959105357,229985335358,229930815054,229952749204,229949404747,229947508805,229930745575,229961986884,229985381121,229992526677,229925782734,229961117091,229956375865,230004750318,229959774042,229949882123,229945180621,229985738002,229954550312,229995786277,229931387792', '113;1', 'DEFAULT', 00, 0287, '','', '', 00);
Date: 2026-06-17 15:14:52 Duration: 954ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '230013998302,229982638091,229977334656,230007892734,230051290303,229967785879,229963244953,229977663050,230029235355,229977417896,229991157587,229977526672,230029354155,229971465980,229991101825,230005288608,229975723343,230052808194,230035784356,230006218787,230035307788,229977212546,230044233037,230035471924,230041903943,229977477172,229982309697,229991154153,230050234251,230021287486,230012396787,229976331719,229977667191,230052384865,229991137585,230052805669,230041903236,230005547072,230035316274,229975609415,230047027686,229980254952,229977385772,230009890606,229971119201,230005464057,229976083030,229976536587,229971179005', '113;1', 'DEFAULT', 00, 0295, '','', '', 00);
Date: 2026-06-17 15:27:04 Duration: 692ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '229927628087,229960513845,230005063737,229996545981,229963868606,229965442239,229984168588,229994697495,230013618690,229930606268,229945470324,229994550613,229935525267,229937863554,229935600909,229958526176,229954146175,229935473040,229993120204,230008822836,229948008405,229927664051,229937045561,229994684666,229986674849,229997654967,229930760830,229927883343,229930934561,229947719005,229953227185,229994568694,230012683336,229969596785,229992559206,229987802244,229949039201,229927878594,230004957890,230008807076,230013561032,230013639096,229993675970,229969610323,229992761426', '113;1', 'DEFAULT', 00, 0287, '','', '', 00);
Date: 2026-06-17 15:22:04 Duration: 572ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 45 7m55s 8s149ms 31s272ms 10s561ms create table temp0000282745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 17 07 16 2m53s 10s848ms 08 9 1m36s 10s709ms 09 7 1m17s 11s125ms 10 2 19s318ms 9s659ms 11 3 29s932ms 9s977ms 12 8 1m18s 9s772ms [ User: intelifix - Total duration: 7m55s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 7m55s - Times executed: 45 ]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 07:14:13 Duration: 31s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 09:05:28 Duration: 13s471ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 08:30:42 Duration: 12s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 43 19s735ms 154ms 5s652ms 458ms create table temp0000282824 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 17 13 9 6s504ms 722ms 14 10 3s182ms 318ms 15 5 6s428ms 1s285ms 16 19 3s619ms 190ms [ User: intelifix - Total duration: 19s735ms - Times executed: 43 ]
[ Application: [unknown] - Total duration: 19s735ms - Times executed: 43 ]
-
CREATE TABLE temp0000282824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-06-2026", "ate" :"17-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-17 15:26:18 Duration: 5s652ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-06-2026", "ate" :"17-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-17 13:35:28 Duration: 4s90ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-06-2026", "ate" :"17-06-2026", "nota-fiscal":"102", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-17 13:53:35 Duration: 517ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 41 12s849ms 151ms 701ms 313ms 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 #19
Day Hour Count Duration Avg duration Jun 17 07 2 490ms 245ms 08 2 1s16ms 508ms 09 13 5s101ms 392ms 10 6 1s887ms 314ms 11 1 316ms 316ms 12 2 695ms 347ms 13 1 212ms 212ms 14 10 2s353ms 235ms 16 4 775ms 193ms [ User: intelifix - Total duration: 12s849ms - Times executed: 41 ]
[ Application: [unknown] - Total duration: 12s849ms - Times executed: 41 ]
-
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 = 3099671 ORDER BY A.CAI_ORDEM;
Date: 2026-06-17 09:50:58 Duration: 701ms 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 = 110112 ORDER BY A.CAI_ORDEM;
Date: 2026-06-17 09:27:26 Duration: 653ms 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 = 110312 ORDER BY A.CAI_ORDEM;
Date: 2026-06-17 10:02:44 Duration: 636ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 36 6s563ms 153ms 299ms 182ms create table temp0000282755 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 17 08 7 1s403ms 200ms 09 4 711ms 177ms 10 5 875ms 175ms 11 19 3s354ms 176ms 12 1 218ms 218ms [ User: intelifix - Total duration: 6s563ms - Times executed: 36 ]
[ Application: [unknown] - Total duration: 6s563ms - Times executed: 36 ]
-
CREATE TABLE temp0000282755 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-15', '2026-06-17');
Date: 2026-06-17 08:01:54 Duration: 299ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282755 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-15', '2026-06-17');
Date: 2026-06-17 12:06:57 Duration: 218ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282755 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-06-15', '2026-06-17');
Date: 2026-06-17 08:19:18 Duration: 204ms 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 368ms 7m42s 3m20s 3 10m analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 17 05 3 10m 3m20s [ User: intelifix - Total duration: 10m - Times executed: 3 ]
[ Application: psql - Total duration: 10m - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-17 05:07:43 Duration: 7m42s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-17 05:10:01 Duration: 2m18s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-17 05:07:43 Duration: 368ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 896ms 8m28s 3m6s 32 1h39m35s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 17 07 2 8m30s 4m15s 08 2 5m53s 2m56s 09 2 7m57s 3m58s 10 2 6m3s 3m1s 11 2 6m 3m 12 2 6m26s 3m13s 13 2 5m53s 2m56s 14 2 6m54s 3m27s 15 2 6m34s 3m17s 16 2 6m26s 3m13s 17 2 5m53s 2m56s 18 2 5m34s 2m47s 19 2 5m24s 2m42s 20 2 5m39s 2m49s 21 2 5m18s 2m39s 22 2 5m4s 2m32s [ User: intelifix - Total duration: 1h39m35s - Times executed: 32 ]
[ Application: psql - Total duration: 1h39m35s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-17 07:13:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-17 09:12:52 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-17 14:11:51 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: psql
3 1m24s 1m32s 1m28s 2 2m57s 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 17 20 1 1m24s 1m24s 23 1 1m32s 1m32s [ User: intelifix - Total duration: 2m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-17 23:39:28 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-17 20:08:13 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 26s633ms 1m42s 1m4s 2 2m9s 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 17 23 2 2m9s 1m4s [ User: intelifix - Total duration: 2m9s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m9s - 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-17 23:14:21 Duration: 1m42s 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-17 23:41:07 Duration: 26s633ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 56s429ms 58s677ms 57s553ms 2 1m55s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 17 20 1 58s677ms 58s677ms 23 1 56s429ms 56s429ms [ 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-17 20:05:13 Duration: 58s677ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-17 23:18:35 Duration: 56s429ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 21s994ms 1m28s 55s350ms 2 1m50s 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 17 23 2 1m50s 55s350ms [ User: intelifix - Total duration: 1m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m50s - 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-17 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-17 23:40:21 Duration: 21s994ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 19s993ms 1m6s 43s481ms 2 1m26s copy auditor.auditor_2026_04 (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 #7
Day Hour Count Duration Avg duration Jun 17 23 2 1m26s 43s481ms [ User: intelifix - Total duration: 1m26s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (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-17 23:12:39 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (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-17 23:40:41 Duration: 19s993ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 153ms 4m19s 29s877ms 185 1h32m7s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 17 07 14 11m29s 49s254ms 08 5 8m30s 1m42s 09 13 9m20s 43s133ms 10 14 6m10s 26s441ms 11 10 6m32s 39s290ms 12 9 10m12s 1m8s 13 20 35s788ms 1s789ms 14 34 14m55s 26s334ms 15 20 8m12s 24s628ms 16 22 10m12s 27s856ms 17 24 5m54s 14s768ms [ User: intelifix - Total duration: 1h32m7s - Times executed: 185 ]
[ Application: [unknown] - Total duration: 1h32m7s - Times executed: 185 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025758, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 16:01:51 Duration: 4m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025720, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 07:19:56 Duration: 4m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025735, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-17 10:44:21 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 18s145ms 37s533ms 21s572ms 28 10m4s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 17 08 2 55s678ms 27s839ms 09 4 1m19s 19s781ms 10 2 38s159ms 19s79ms 11 5 1m39s 19s855ms 13 1 32s904ms 32s904ms 14 3 1m7s 22s559ms 15 5 1m49s 21s898ms 16 4 1m20s 20s176ms 17 2 41s6ms 20s503ms [ User: intelifix - Total duration: 10m4s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 10m4s - Times executed: 28 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-17 08:59:05 Duration: 37s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-17 13:55:44 Duration: 32s904ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-17 14:00:06 Duration: 24s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 362ms 59s210ms 18s156ms 32 9m41s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 17 07 2 47s120ms 23s560ms 08 2 28s475ms 14s237ms 09 2 1m 30s252ms 10 2 36s118ms 18s59ms 11 2 32s100ms 16s50ms 12 2 32s985ms 16s492ms 13 2 28s710ms 14s355ms 14 2 40s271ms 20s135ms 15 2 44s99ms 22s49ms 16 2 32s164ms 16s82ms 17 2 32s126ms 16s63ms 18 2 31s618ms 15s809ms 19 2 27s786ms 13s893ms 20 2 49s80ms 24s540ms 21 2 29s732ms 14s866ms 22 2 28s117ms 14s58ms [ User: intelifix - Total duration: 9m41s - Times executed: 32 ]
[ Application: psql - Total duration: 9m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-17 09:13:52 Duration: 59s210ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-17 20:11:27 Duration: 48s422ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-17 07:14:16 Duration: 46s204ms Database: rio User: intelifix Remote: [local] Application: psql
11 8s461ms 39s658ms 10s885ms 34 6m10s create table temp0000282832 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 17 14 8 1m52s 14s120ms 16 6 1m7s 11s281ms 17 20 3m9s 9s472ms [ User: intelifix - Total duration: 6m10s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 6m10s - Times executed: 34 ]
-
CREATE TABLE temp0000282832 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 14:04:40 Duration: 39s658ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282832 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 14:22:37 Duration: 12s176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282832 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 16:53:17 Duration: 12s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s92ms 14s509ms 10s685ms 31 5m31s create table temp0000282842 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 17 14 10 1m45s 10s594ms 15 15 2m50s 11s364ms 16 6 54s844ms 9s140ms [ User: intelifix - Total duration: 5m31s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m31s - Times executed: 31 ]
-
CREATE TABLE temp0000282842 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 15:56:51 Duration: 14s509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282842 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 15:57:10 Duration: 12s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282842 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 15:33:59 Duration: 11s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s149ms 31s272ms 10s561ms 45 7m55s create table temp0000282745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 17 07 16 2m53s 10s848ms 08 9 1m36s 10s709ms 09 7 1m17s 11s125ms 10 2 19s318ms 9s659ms 11 3 29s932ms 9s977ms 12 8 1m18s 9s772ms [ User: intelifix - Total duration: 7m55s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 7m55s - Times executed: 45 ]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 07:14:13 Duration: 31s272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 09:05:28 Duration: 13s471ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 08:30:42 Duration: 12s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 8s564ms 11s915ms 10s385ms 14 2m25s create table temp0000282773 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 17 08 4 38s284ms 9s571ms 09 5 50s981ms 10s196ms 10 5 56s123ms 11s224ms [ User: intelifix - Total duration: 2m25s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m25s - Times executed: 14 ]
-
CREATE TABLE temp0000282773 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 10:02:48 Duration: 11s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282773 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 10:02:19 Duration: 11s723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282773 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 10:03:06 Duration: 11s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 8s801ms 11s545ms 9s870ms 12 1m58s create table temp0000282870 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 17 17 12 1m58s 9s870ms [ User: intelifix - Total duration: 1m58s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 1m58s - Times executed: 12 ]
-
CREATE TABLE temp0000282870 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 17:10:26 Duration: 11s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282870 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 17:02:01 Duration: 11s275ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282870 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-17 17:08:55 Duration: 10s406ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 228ms 10s890ms 3s753ms 94 5m52s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 17 00 6 16s776ms 2s796ms 01 4 6s430ms 1s607ms 02 4 7s709ms 1s927ms 03 5 6s148ms 1s229ms 04 6 9s49ms 1s508ms 05 5 7s161ms 1s432ms 07 6 31s676ms 5s279ms 08 6 42s404ms 7s67ms 09 6 37s727ms 6s287ms 10 6 33s862ms 5s643ms 11 6 36s830ms 6s138ms 12 6 31s626ms 5s271ms 13 2 2s431ms 1s215ms 14 6 32s763ms 5s460ms 15 6 22s751ms 3s791ms 16 5 15s352ms 3s70ms 21 3 3s837ms 1s279ms 22 6 8s313ms 1s385ms [ User: intelifix - Total duration: 5m52s - Times executed: 94 ]
[ Application: psql - Total duration: 5m52s - Times executed: 94 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 00:05:12 Duration: 10s890ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 14:25:11 Duration: 10s341ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-17 14:55:11 Duration: 9s948ms Database: rio User: intelifix Remote: [local] Application: psql
17 1s895ms 1m25s 3s354ms 138 7m42s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 17 00 6 21s166ms 3s527ms 01 6 16s373ms 2s728ms 02 6 15s607ms 2s601ms 03 6 15s946ms 2s657ms 04 6 13s237ms 2s206ms 05 6 12s287ms 2s47ms 06 6 13s422ms 2s237ms 07 6 16s516ms 2s752ms 08 6 1m38s 16s405ms 09 6 17s731ms 2s955ms 10 6 17s625ms 2s937ms 11 6 19s575ms 3s262ms 12 6 17s19ms 2s836ms 13 6 15s981ms 2s663ms 14 6 16s592ms 2s765ms 15 6 17s435ms 2s905ms 16 6 17s633ms 2s938ms 17 6 17s552ms 2s925ms 18 6 15s654ms 2s609ms 19 6 17s286ms 2s881ms 20 6 18s358ms 3s59ms 21 6 16s988ms 2s831ms 22 6 14s460ms 2s410ms [ User: intelifix - Total duration: 7m42s - Times executed: 138 ]
[ Application: psql - Total duration: 7m42s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 08:36:34 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 00:05:21 Duration: 8s756ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-17 11:25:11 Duration: 5s286ms Database: rio User: intelifix Remote: [local] Application: psql
18 182ms 51s810ms 1s728ms 58 1m40s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 17 07 6 2s411ms 401ms 08 4 9s989ms 2s497ms 09 5 5s706ms 1s141ms 10 2 52s70ms 26s35ms 11 4 7s369ms 1s842ms 12 4 1s406ms 351ms 14 10 5s338ms 533ms 15 4 2s315ms 578ms 16 4 4s618ms 1s154ms 17 15 9s36ms 602ms [ User: intelifix - Total duration: 1m40s - Times executed: 58 ]
[ Application: psql - Total duration: 1m40s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025734);
Date: 2026-06-17 10:02:39 Duration: 51s810ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025727);
Date: 2026-06-17 08:33:38 Duration: 8s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025739);
Date: 2026-06-17 11:28:08 Duration: 5s616ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 2m38s 905ms 1,210 18m15s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 17 07 24 15s231ms 634ms 08 93 1m4s 690ms 09 182 2m22s 780ms 10 49 44s926ms 916ms 11 103 1m20s 781ms 12 56 27s81ms 483ms 13 91 1m 669ms 14 157 4m48s 1s836ms 15 174 2m45s 948ms 16 208 2m47s 807ms 17 66 32s574ms 493ms 18 7 6s883ms 983ms [ User: intelifix - Total duration: 18m15s - Times executed: 1210 ]
[ Application: [unknown] - Total duration: 18m15s - Times executed: 1210 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255169, 184, '919481078449,3093BC4BDD8A', '',0129,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-06-17 14:38:34 Duration: 2m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255069, 450, 'CP2431LV0P7,C4509CEA9EB4$CP2248LVCU9,B85E71D8D038$CP2242LVKDU,B85E71C9E8E8$CP2435LV1HY,C4509CEF4164$CP2439LV4SC,C4509CF494B4$CP2207LV5UE,3C82C06AF43C$CP2210LVAZC,3C82C0CFD6F8$CP2114LV8W9,08A7C0520CBC$CP2523LV00B,B85E710C8E50$CP2439LV9JM,C4509CF4F1E4$CP2205LV5WF,3C82C06B20EC$CP2522LV09K,B85E710C85A4$CP2233LV7WZ,4075C3B5A364$CP2210LV39F,3C82C0C4FB20$CP2239LV3SH,4075C3C20ED8$CP2534LV4RG,3C82C092A490$CP2431LV3K9,C4509CEAAA54$CP2522LV1B9,B85E710DE19C$CP2131LVL6V,ECA81F1A7A7C$CP2206LV7E5,3C82C06737D4$CP2432LV4YT,C4509CEAB8C4$CP2435LV3HA,C4509CF1331C$CP2239LV270,4075C3BFAA08$CP2301LV8K7,B85E71E695B0$CP2530LV02N,F8D2ACC9E6EC$CP2347LV1GW,400FC17E221C$CP2528LV5N7,F8D2AC4CE9C4$CP2429LV5UB,C4509CBD09FC$CP2347LV468,400FC17EF7C4$CP2529LV1N5,3C82C08C9514$CP2107LV0SC,E4BFFAF0F47C$CP2242LV26V,B85E71C84308$CP2109LV4E7,E4BFFAF520DC$CP2120LV5RT,08A7C06CA424$CP2218LV4DU,00CB7ADC2CF8$CP2529LV9WZ,3C82C08C9604$CP2106LVABH,484BD4B40B9C', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 15:41:29 Duration: 4s242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (255068, 450, '921141128769,582FF79C2D60,209A7DBB2895,D0CF0EFD80BC,209A7DBABD49,CC5830E2A90A,94988F93D813,CC5830E2A957,5CFA257F6D1C,186A81D5137B,841EA38D5D10,943C96AB76BA,D833B7CB45C4,209A7DBC6CCC,943C96AA3C70,C4EB429FEE6D,94988F956ABD,D0CF0EFDCDFB,582FF716A015,345D9EB3E4F1,20B82BF82F29,841EA391ACE5,44D454949943,CC583002D67F,186A81D5111A,64FD965E0FC1,841EA3974195,38A6592471B8,64FD965E4CC2,209A7DBC2694,186A81D5B657,D833B7CB4642,6CBAB8EA95DF,D0CF0EFDD724,5CFA25AD2B95,E4C0E29782B4,841EA38BF7D1,44D4549464FB,C03C047F48A5,ACD75BB809F9', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-17 16:00:19 Duration: 4s139ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 155ms 5s558ms 719ms 79 56s876ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 17 07 7 2s56ms 293ms 09 2 3s184ms 1s592ms 10 8 15s354ms 1s919ms 11 2 1s859ms 929ms 13 13 12s202ms 938ms 14 16 7s37ms 439ms 15 12 5s478ms 456ms 16 14 6s121ms 437ms 17 5 3s579ms 715ms [ User: intelifix - Total duration: 56s876ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 56s876ms - Times executed: 79 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042322) LIMIT 1;
Date: 2026-06-17 10:13:08 Duration: 5s558ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-17 10:17:05 Duration: 5s298ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0254952) LIMIT 1;
Date: 2026-06-17 13:25:06 Duration: 2s857ms 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 17 12 1 0ms 0ms [ User: intelifix - Total duration: 686ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 686ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: [unknown]
-
Events
Log levels
Key values
- 15,472 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 3592 ERROR entries
- 0 WARNING entries
- 9 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,014 Max number of times the same event was reported
- 3,618 Total events found
Rank Times reported Error 1 3,014 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 17 06 4 07 230 08 306 09 354 10 315 11 443 12 282 13 122 14 354 15 334 16 237 17 25 18 8 - ERROR: prepared statement "_PLAN000000001C632A90" does not exist
- ERROR: prepared statement "_PLAN000000001C4CA210" does not exist
- ERROR: prepared statement "_PLAN000000002CA7D1C0" does not exist
Statement: DEALLOCATE "_PLAN000000001C632A90"
Date: 2026-06-17 06:57:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000001C4CA210"
Date: 2026-06-17 06:59:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002CA7D1C0"
Date: 2026-06-17 06:59:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 17 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-17 00:05:21 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-17 00:15: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-17 00:25:05 Database: brasilia Application: psql User: intelifix Remote: [local]
3 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 17 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-17 00:05:21 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-17 00:15: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-17 00:25:05 Database: brasilia Application: psql User: intelifix Remote: [local]
4 66 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 17 07 13 08 9 09 14 10 6 11 12 12 6 16 4 17 2 - ERROR: syntax error at or near ":" at character 29
- ERROR: syntax error at or near ":" at character 29
- ERROR: syntax error at or near ":" at character 29
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:8F:FB:00)
Date: 2026-06-17 07:33:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:8F:FB:00)
Date: 2026-06-17 07:33:54 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:8F:FB:00)
Date: 2026-06-17 07:33:54 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 17 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-17 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-17 00: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-17 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
6 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 17 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-17 08:00:26 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-17 08:20:07 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-17 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
7 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 17 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-17 08:00:26 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-17 08: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-17 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
8 22 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 17 07 5 12 2 14 6 15 6 16 3 - ERROR: column "b$tt" does not exist at character 27
- ERROR: column "b$tt" does not exist at character 27
- ERROR: column "b$tt" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(B$TT)
Date: 2026-06-17 07:08:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(B$TT)
Date: 2026-06-17 07:08:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(B$TT)
Date: 2026-06-17 07:08:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 21 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 17 14 3 15 15 16 3 - ERROR: trailing junk after numeric literal at or near "4C" at character 42
- ERROR: trailing junk after numeric literal at or near "4C" at character 42
- ERROR: trailing junk after numeric literal at or near "4C" at character 42
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-99-30-4C)
Date: 2026-06-17 14:55:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-99-30-4C)
Date: 2026-06-17 14:55:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-99-30-4C)
Date: 2026-06-17 14:55:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 17 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-17 07:14:16 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-17 08:11:22 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-17 09:13:52 Database: brasilia Application: psql User: intelifix Remote: [local]
11 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 17 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-17 07:14:16 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-17 08:11:22 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-17 09:13:52 Database: brasilia Application: psql User: intelifix Remote: [local]
12 11 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 17 00 1 05 1 06 1 08 2 09 1 12 1 13 1 15 1 17 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-06-17 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-17 05:07:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-17 06:02:16 Database: testes Application: [unknown] User: lenon Remote: [local]
13 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 17 05 8 - ERROR: relation "public.equipamentos" does not exist at character 49
- ERROR: relation "public.equipamentos" does not exist
- ERROR: relation "public.codigos_barra" does not exist at character 70
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, mod_id FROM public.equipamentos
Date: 2026-06-17 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
Context: remote SQL command: SELECT eq_id, mod_id FROM public.equipamentos
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-17 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, eq_seq, eq_codigo, eq_extra FROM public.codigos_barra
Date: 2026-06-17 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
14 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 17 08 2 14 3 - LOG: process 3537206 still waiting for ShareLock on transaction 1167103 after 1000.165 ms
- LOG: process 3537206 still waiting for ShareLock on transaction 1167103 after 7159.271 ms
- LOG: process 3813927 still waiting for ShareLock on transaction 1190455 after 1000.158 ms
Detail: Process holding the lock: 3540387. Wait queue: 3537206.
Context: while updating tuple (70713,15) 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-17 08:35:12 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3540387. Wait queue: 3537206.
Context: while updating tuple (70713,15) 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-17 08:35:19 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3786839. Wait queue: 3813927.
Context: while updating tuple (70781,58) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(255169,184,'919481078449,3093BC4BDD8A','',0129,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-06-17 14:35:57 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 4 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 17 16 4 - ERROR: unterminated quoted identifier at or near ""}]}');" at character 85
- ERROR: unterminated quoted identifier at or near ""}]}')" at character 95
- ERROR: unterminated quoted identifier at or near ""}]}')" at character 95
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"42","seriais":[{"serial":""},{"serial":"'"}]}');
Date: 2026-06-17 16:44:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"254512","seriais":[{"serial":""},{"serial":"'"}]}')
Date: 2026-06-17 16:44:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"254512","seriais":[{"serial":""},{"serial":"'"}]}')
Date: 2026-06-17 16:45:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 17 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Context: SQL statement " SELECT A.EQ_ID,A.FLU_ID,A.FLU_STATUS,RS_STATUS_FLUXO(A.FLU_STATUS) AS FLU_NOMESTATUS,A.FLU_FINAL, A.WF_ID,B.WF_NOME,B.OFI_ID,C.OFI_NOME,D.CLI_ID,E.CLI_NOME,B.WF_TIPO FROM FLUXOS A INNER JOIN WORK_FLOWS B ON B.WF_ID = A.WF_ID INNER JOIN OFICINAS C ON C.OFI_ID = B.OFI_ID INNER JOIN EQUIPAMENTOS D ON D.EQ_ID = A.EQ_ID INNER JOIN CLIENTES E ON E.CLI_ID = D.CLI_ID WHERE A.EQ_ID = 3291836 ORDER BY A.FLU_ID DESC LIMIT 1 " PL/pgSQL function rs_passo_atual(integer) line 68 at EXECUTE PL/pgSQL function rs_giga_triagem(character varying,integer) line 172 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-17 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-06-17 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-17 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
17 4 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 17 18 4 - ERROR: invalid byte sequence for encoding "UTF8": 0x96
- ERROR: invalid byte sequence for encoding "UTF8": 0x96
- ERROR: invalid byte sequence for encoding "UTF8": 0x96
Date: 2026-06-17 18:27:05 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-17 18:27:05 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-17 18:30:05 Database: contagem Application: [unknown] User: intelifix Remote: [local]
18 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 17 12 1 15 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000282745"
Date: 2026-06-17 12:44:45
Context: automatic vacuum of table "rio.public.temp0000282842"
Date: 2026-06-17 15:33:47
Context: automatic vacuum of table "rio.public.temp0000282832"
Date: 2026-06-17 16:44:47
19 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 17 12 1 15 1 16 1 - LOG: process 3738433 still waiting for AccessExclusiveLock on relation 1235726 of database 358220 after 1000.162 ms
- LOG: process 3828844 still waiting for AccessExclusiveLock on relation 1248134 of database 358220 after 1000.173 ms
- LOG: process 3895152 still waiting for AccessExclusiveLock on relation 1250977 of database 358220 after 1000.133 ms
Detail: Process holding the lock: 3750276. Wait queue: 3738433.
Statement: DROP TABLE IF EXISTS temp0000282745;Date: 2026-06-17 12:44:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3881203. Wait queue: 3828844.
Statement: DROP TABLE IF EXISTS temp0000282842;Date: 2026-06-17 15:33:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3948727. Wait queue: 3895152.
Statement: DROP TABLE IF EXISTS temp0000282832;Date: 2026-06-17 16:44:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
20 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 17 00 1 06 1 - ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-17 00:05:20 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-17 06:05:09 Database: brasilia Application: psql User: intelifix Remote: [local]
21 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 17 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-17 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-17 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
22 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #22
Day Hour Count Jun 17 10 1 11 1 - ERROR: unterminated quoted string at or near "'229991150214'');" at character 39
- ERROR: unterminated quoted string at or near "'216887882947'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229991150214'');
Date: 2026-06-17 10:48:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('216887882947'');
Date: 2026-06-17 11:06:00 Database: rio Application: [unknown] User: intelifix Remote: [local]
23 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #23
Day Hour Count Jun 17 03 1 - LOG: database system was shut down at 2026-06-17 03:05:02 -03
Date: 2026-06-17 03:05:03
24 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #24
Day Hour Count Jun 17 18 1 - ERROR: function rs_lote_entrada_fechar_automatico() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_ENTRADA_FECHAR_AUTOMATICO()Date: 2026-06-17 18:00:02 Database: brasilia Application: psql User: intelifix Remote: [local]
25 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #25
Day Hour Count Jun 17 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-17 21:25:02 Database: brasilia Application: psql User: intelifix Remote: [local]