pgBadger-
Global information
- Generated on Tue Jun 16 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 35,461 log entries in 7s
- Log start from 2026-06-16 00:02:01 to 2026-06-16 23:40:19
-
Overview
Global Stats
- 286 Number of unique normalized queries
- 5,598 Number of queries
- 6h11m11s Total query duration
- 2026-06-16 00:02:12 First query
- 2026-06-16 23:38:33 Last query
- 5 queries/s at 2026-06-16 23:38:05 Query peak
- 6h11m11s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h11m11s Execute total duration
- 2,886 Number of events
- 21 Number of unique normalized events
- 2,374 Max number of times the same event was reported
- 0 Number of cancellation
- 445 Total number of automatic vacuums
- 926 Total number of automatic analyzes
- 27 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 264 Total number of sessions
- 6 sessions at 2026-06-16 00:05:01 Session peak
- 9d15h5m24s Total duration of sessions
- 52m31s Average duration of sessions
- 21 Average queries per session
- 1m24s Average queries duration per session
- 51m6s Average idle time per session
- 275 Total number of connections
- 5 connections/s at 2026-06-16 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-16 23:38:05 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-16 14:11:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-16 23:38:05 Date
Queries duration
Key values
- 6h11m11s 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 16 00 25 0ms 18s540ms 3s623ms 11s795ms 55s896ms 55s896ms 01 13 0ms 3s144ms 1s906ms 4s639ms 4s639ms 4s639ms 02 12 0ms 2s968ms 1s800ms 4s434ms 4s434ms 4s434ms 03 16 0ms 3s188ms 1s589ms 4s671ms 5s624ms 5s624ms 04 32 0ms 3s65ms 901ms 4s167ms 4s791ms 5s162ms 05 21 0ms 7m24s 28s490ms 6s624ms 2m4s 7m24s 06 15 0ms 11s176ms 3s294ms 12s305ms 19s72ms 19s72ms 07 110 0ms 6m31s 12s874ms 49s829ms 3m35s 6m31s 08 527 150ms 5m32s 3s734ms 1m10s 3m39s 5m41s 09 695 150ms 8m19s 2s573ms 48s584ms 3m56s 8m24s 10 737 151ms 7m13s 2s350ms 41s923ms 4m5s 8m 11 561 150ms 7m7s 3s667ms 1m14s 4m27s 7m51s 12 156 0ms 6m19s 9s487ms 45s31ms 3m44s 6m57s 13 342 0ms 5m34s 1s982ms 19s974ms 29s122ms 5m34s 14 630 150ms 6m3s 3s244ms 1m11s 2m18s 10m13s 15 582 150ms 6m57s 3s414ms 57s34ms 3m46s 7m3s 16 483 150ms 5m55s 2s355ms 32s89ms 1m5s 6m24s 17 271 0ms 5m44s 4s128ms 57s565ms 1m7s 5m44s 18 34 0ms 5m38s 11s772ms 3s550ms 28s781ms 5m38s 19 10 0ms 5m17s 36s306ms 3s258ms 5m46s 5m46s 20 66 0ms 5m26s 12s55ms 2m4s 5m26s 5m26s 21 19 0ms 5m35s 20s462ms 28s280ms 5m35s 5m35s 22 19 0ms 5m13s 19s537ms 4s555ms 5m46s 5m46s 23 222 0ms 1m29s 7s677ms 1m11s 1m29s 2m7s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 16 00 10 0 1s474ms 1s45ms 1s357ms 11s795ms 01 1 0 204ms 0ms 204ms 204ms 02 0 0 0ms 0ms 0ms 0ms 03 4 0 299ms 0ms 159ms 1s38ms 04 21 0 269ms 411ms 730ms 1s441ms 05 6 0 339ms 0ms 186ms 1s545ms 06 4 0 3s277ms 0ms 802ms 12s305ms 07 70 0 16s528ms 2s401ms 49s829ms 6m31s 08 403 0 3s699ms 12s141ms 1m3s 3m51s 09 563 0 2s745ms 18s565ms 39s892ms 4m13s 10 577 0 2s530ms 11s476ms 26s670ms 4m38s 11 423 0 3s882ms 20s277ms 1m3s 4m30s 12 103 0 11s852ms 2s451ms 19s974ms 3m48s 13 301 0 2s84ms 7s414ms 19s702ms 35s991ms 14 493 0 3s359ms 21s822ms 1m 4m9s 15 446 0 3s180ms 20s690ms 56s156ms 3m51s 16 391 0 2s465ms 6s391ms 22s956ms 4m12s 17 187 0 4s22ms 7s513ms 47s798ms 57s198ms 18 28 0 13s659ms 878ms 1s636ms 5m38s 19 4 0 1m26s 0ms 0ms 5m46s 20 6 53 13s182ms 1m7s 2m4s 5m26s 21 9 0 40s708ms 1s16ms 28s280ms 5m35s 22 6 0 57s919ms 0ms 841ms 5m46s 23 4 218 7s677ms 1m5s 1m11s 2m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 16 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 16 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 8 8.00 0.00% 08 0 8 8.00 0.00% 09 0 10 10.00 0.00% 10 0 8 8.00 0.00% 11 0 10 10.00 0.00% 12 0 4 4.00 0.00% 13 0 8 8.00 0.00% 14 0 8 8.00 0.00% 15 0 8 8.00 0.00% 16 0 7 7.00 0.00% 17 0 6 6.00 0.00% 18 0 2 2.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 16 00 11 0.00/s 01 4 0.00/s 02 4 0.00/s 03 12 0.00/s 04 10 0.00/s 05 6 0.00/s 06 11 0.00/s 07 16 0.00/s 08 18 0.01/s 09 19 0.01/s 10 20 0.01/s 11 19 0.01/s 12 9 0.00/s 13 16 0.00/s 14 18 0.01/s 15 16 0.00/s 16 15 0.00/s 17 11 0.00/s 18 9 0.00/s 19 4 0.00/s 20 8 0.00/s 21 7 0.00/s 22 6 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Jun 16 00 1 45m39s 44m8s 01 10 1h1m12s 1h1m9s 02 4 1h 59m55s 03 9 22m3s 22m 04 7 1h26s 1h22s 05 6 1h30s 58m50s 06 6 55m58s 55m50s 07 12 52m24s 50m26s 08 16 54m20s 52m17s 09 20 50m32s 49m3s 10 20 49m30s 48m3s 11 17 48m31s 46m29s 12 17 53m17s 51m50s 13 8 55m17s 53m52s 14 17 52m22s 50m21s 15 18 57m21s 55m30s 16 15 58m52s 57m36s 17 17 53m35s 52m30s 18 8 1h 59m10s 19 9 1h20s 59m39s 20 7 35m17s 33m24s 21 6 51m40s 50m35s 22 6 57m10s 56m8s 23 8 41m49s 38m16s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-16 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 275 connections Total
Connections per user
Key values
- intelifix Main User
- 275 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-16 00:05:01 Date
Histogram of session times
Key values
- 206 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 264 sessions Total
Sessions per user
Key values
- intelifix Main User
- 264 sessions Total
Sessions per host
Key values
- [local] Main Host
- 264 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 39,299 buffers Checkpoint Peak
- 2026-06-16 11:54:39 Date
- 270.062 seconds Highest write time
- 0.047 seconds Sync time
Checkpoints Wal files
Key values
- 16 files Wal files usage Peak
- 2026-06-16 11:54:39 Date
Checkpoints distance
Key values
- 525.19 Mo Distance Peak
- 2026-06-16 11:54:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 16 00 29,991 743.295s 0.023s 743.362s 01 1,851 185.875s 0.017s 185.92s 02 1,405 141.165s 0.02s 141.216s 03 2,530 253.036s 0.02s 253.09s 04 3,202 321.268s 0.023s 321.326s 05 8,326 822.651s 0.026s 822.719s 06 6,001 433.611s 0.008s 433.636s 07 30,315 2,154.82s 0.07s 2,154.969s 08 67,300 3,239.424s 0.165s 3,239.734s 09 76,940 3,239.232s 0.25s 3,239.653s 10 63,115 3,157.155s 0.275s 3,157.654s 11 102,674 3,239.309s 0.216s 3,239.706s 12 48,635 2,808.272s 0.091s 2,808.462s 13 20,404 2,000.765s 0.125s 2,001.002s 14 69,622 3,147.602s 0.227s 3,147.987s 15 65,773 3,239.387s 0.174s 3,239.712s 16 45,999 3,056.296s 0.156s 3,056.564s 17 24,298 2,453.611s 0.075s 2,453.784s 18 3,877 389.485s 0.049s 389.586s 19 31 3.154s 0.006s 3.168s 20 1,813 182.308s 0.004s 182.322s 21 1,517 152.208s 0.021s 152.264s 22 1,811 181.864s 0.027s 181.927s 23 1,602 296.113s 0.004s 296.129s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 16 00 0 0 7 615 0.004s 0.008s 01 0 0 0 425 0.003s 0.006s 02 0 0 1 385 0.003s 0.007s 03 0 0 0 484 0.002s 0.008s 04 0 0 1 486 0.003s 0.008s 05 0 0 4 847 0.003s 0.009s 06 0 0 1 215 0.002s 0.004s 07 0 0 19 2,426 0.004s 0.012s 08 0 0 45 4,834 0.004s 0.012s 09 0 0 39 5,856 0.009s 0.012s 10 0 0 33 6,953 0.003s 0.012s 11 0 0 59 5,569 0.007s 0.012s 12 0 0 30 2,407 0.007s 0.012s 13 0 0 11 3,516 0.003s 0.012s 14 0 0 44 5,505 0.014s 0.012s 15 0 0 55 5,294 0.004s 0.012s 16 0 0 23 4,220 0.003s 0.012s 17 0 0 32 3,467 0.003s 0.012s 18 0 0 1 1,452 0.003s 0.011s 19 0 0 0 11 0.002s 0.003s 20 0 0 1 61 0.002s 0.002s 21 0 0 0 308 0.003s 0.007s 22 0 0 1 472 0.003s 0.008s 23 0 0 3 35 0.001s 0.003s Day Hour Count Avg time (sec) Jun 16 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 16 00 13,388.00 kB 48,026.62 kB 01 1,580.83 kB 26,072.17 kB 02 1,039.57 kB 13,806.00 kB 03 1,541.88 kB 3,200.75 kB 04 2,031.00 kB 3,152.00 kB 05 6,357.22 kB 17,138.22 kB 06 4,197.75 kB 11,412.75 kB 07 26,108.50 kB 63,737.17 kB 08 61,993.33 kB 90,865.00 kB 09 52,954.58 kB 91,262.67 kB 10 44,711.17 kB 89,032.08 kB 11 80,989.92 kB 120,225.58 kB 12 39,979.67 kB 151,827.75 kB 13 15,501.75 kB 64,286.75 kB 14 60,803.58 kB 97,508.67 kB 15 73,904.50 kB 125,547.08 kB 16 31,706.67 kB 76,157.25 kB 17 43,660.17 kB 73,269.17 kB 18 1,667.73 kB 38,986.18 kB 19 94.00 kB 19,260.50 kB 20 7,812.00 kB 16,996.00 kB 21 1,265.67 kB 11,751.67 kB 22 1,193.88 kB 6,340.50 kB 23 19,474.67 kB 33,015.00 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-16 14:24:28 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-16 14:24:28 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 16 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 4 416.00 MiB 104.00 MiB 09 0 0 0 10 2 208.00 MiB 104.00 MiB 11 5 520.00 MiB 104.00 MiB 12 1 104.00 MiB 104.00 MiB 13 0 0 0 14 6 624.01 MiB 104.00 MiB 15 3 312.00 MiB 104.00 MiB 16 1 104.00 MiB 104.00 MiB 17 5 520.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 27 2.74 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( 025666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 11:10:18 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025664, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 10:49:39 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025660, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 09:43:06 Duration: 4m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 14:23:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 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-16 14:24:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 12:22:28 - 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-16 08:49:47 - 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-16 11:27:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 15:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 17:45:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 11:44:19 - 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-16 10:48:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 10:41:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 17:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 14:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 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-16 14:34:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-16 08:56:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 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-16 15:00:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 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-16 08:22:04 - 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-16 08:41:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 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-16 11:50:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 16:28:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-16 15:08:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 15.75 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-16 09:25:58 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 15.75 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-16 09:25:58 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (145) Main table analyzed (database rio)
- 926 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 145 rio.pg_catalog.pg_class 77 rio.pg_catalog.pg_type 64 rio.public.temp0000282699 51 rio.pg_catalog.pg_index 47 rio.public.usuarios 47 rio.public.temp0000282621 47 rio.pg_catalog.pg_depend 38 rio.public.temp0000282707 33 rio.public.temp0000282623 33 contagem.pg_catalog.pg_attribute 32 contagem.public.usuarios 28 rio.public.temp0000282673 25 rio.public.temp0000282647 24 rio.public.temp0000282627 21 contagem.pg_catalog.pg_class 20 contagem.pg_catalog.pg_type 16 contagem.public.temp0000226414 14 rio.public.temp0000282643 14 rio.public.temp0000282535 13 contagem.pg_catalog.pg_index 10 rio.public.temp0000282617 9 rio.public.temp0000282517 8 rio.public.temp0000282645 8 contagem.pg_catalog.pg_depend 8 rio.public.temp0000282619 7 rio.public.temp0000282639 7 contagem.public.temp0000226416 7 rio.public.tmp_drill_0175 7 rio.public.temp0000282615 5 brasilia.pg_catalog.pg_shdepend 5 contagem.pg_catalog.pg_shdepend 5 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000282691 4 rio.public.temp0000282705 4 postgres.pg_catalog.pg_shdepend 4 rio.public.tmp_drill_0302 3 rio.public.temp0000282659 3 contagem.public.nf_entrada 3 rio.public.temp0000282689 2 rio.public.temp0000282587 2 rio.public.temp0000282509 2 rio.public.temp0000282703 2 contagem.public.temp0000226408 2 rio.public.temp0000282695 2 rio.public.temp0000282649 2 rio.public.temp0000282611 2 rio.public.temp0000282729 1 rio.public.temp0000282637 1 rio.public.temp0000282671 1 contagem.public.temp0000226422 1 rio.public.temp0000282653 1 rio.public.temp0000282685 1 rio.public.temp0000282697 1 rio.public.temp0000282723 1 rio.public.temp0000282709 1 contagem.public.temp0000226424 1 Total 926 Vacuums per table
Key values
- pg_catalog.pg_attribute (55) Main table vacuumed on database rio
- 445 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 55 53 0 0 0 0 0 30,277 7,109 10,927,286 463 11,824 rio.public.temp0000282621 47 0 0 0 0 0 0 46,696 301 2,981,146 0 0 rio.pg_catalog.pg_class 35 33 0 0 0 0 0 6,471 1,896 2,795,061 103 392 rio.public.temp0000282699 33 0 0 0 0 0 0 9,723 280 801,552 0 0 rio.public.temp0000282707 32 0 0 0 0 0 0 41,176 3,274 6,460,798 0 0 rio.pg_catalog.pg_type 32 30 0 0 0 0 0 2,926 820 1,043,420 100 330 contagem.public.usuarios 28 0 0 0 0 0 0 117 86 51,811 1 1 rio.public.temp0000282647 24 0 0 0 0 0 0 28,414 1,663 3,694,485 0 0 rio.pg_catalog.pg_index 17 17 0 0 0 0 0 1,156 263 262,001 53 125 rio.pg_catalog.pg_depend 15 15 0 0 0 0 0 4,915 1,600 2,179,811 98 748 contagem.pg_catalog.pg_attribute 12 12 0 0 0 0 0 7,395 2,088 3,719,718 29 649 rio.public.temp0000282643 10 0 0 0 0 0 0 1,296 190 312,533 0 0 rio.public.temp0000282645 8 0 0 0 0 0 0 254 85 69,087 0 0 rio.public.temp0000282517 8 0 0 0 0 0 0 1,014 46 67,946 0 0 rio.public.tmp_drill_0175 7 7 0 0 0 0 0 5,328 21 929,278 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,246 315 460,041 10 30 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 10,015 2,415 11,016,132 1,156 4,958 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 557 186 261,480 6 12 contagem.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 782 234 313,911 41 68 contagem.public.temp0000226416 5 0 0 0 0 0 0 475 30 32,677 0 0 rio.public.usuarios 5 5 0 0 0 0 0 155 49 89,235 11 82 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 1,891 459 2,218,241 68 144 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,041 309 629,436 6 39 rio.public.temp0000282705 4 0 0 0 0 0 0 4,832 1,594 2,295,526 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 224 82 64,564 2 2 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 1,535 9 265,751 0 0 rio.public.temp0000282695 2 0 0 0 0 0 0 96 9 7,126 0 0 rio.public.temp0000282611 2 0 0 0 0 0 0 122 71 108,586 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 297 77 87,005 19 30 rio.public.temp0000282689 2 0 0 0 0 0 0 332 12 21,649 0 0 rio.public.temp0000282587 2 0 0 0 0 0 0 120 11 8,980 0 0 rio.public.temp0000282723 1 0 0 0 0 0 0 104 6 7,082 0 0 rio.public.temp0000282703 1 0 0 0 0 0 0 92 6 6,352 0 0 rio.public.temp0000282535 1 0 0 0 0 0 0 1,579 4 93,764 0 0 rio.public.temp0000282709 1 0 0 0 0 0 0 8 5 1,315 0 0 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 71,689 46,690 58,624,448 12,502 236,739 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 82 2 7,479 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 135 2 10,589 0 0 rio.public.temp0000282671 1 0 0 0 0 0 0 83 6 5,803 0 0 rio.public.logs 1 0 0 0 0 0 0 1,012 804 978,440 94 2,350 rio.public.temp0000282637 1 0 0 0 0 0 0 82 6 5,740 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 919 439 1,220,300 247 11,968 rio.public.acessos 1 0 0 0 0 0 0 19 19 40,671 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,188 6 153,985 0 0 rio.public.temp0000282659 1 0 0 0 0 0 0 8 5 1,295 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 15,027 13,975 16,939,506 0 0 rio.public.temp0000282509 1 0 0 0 0 0 0 159 6 10,405 0 0 rio.public.temp0000282653 1 0 0 0 0 0 0 8 5 1,296 0 0 Total 445 218 0 0 0 0 0 304,072 87,570 132,284,743 15,009 270,491 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (15.75) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.54 rio.public.temp0000282621 0 0 1.71 rio.pg_catalog.pg_class 0 0 0.73 rio.public.temp0000282699 0 0 0.66 rio.public.temp0000282707 0 0 1.58 rio.pg_catalog.pg_type 0 0 0.29 contagem.public.usuarios 0 0 0 rio.public.temp0000282647 0 0 1.19 rio.pg_catalog.pg_index 0 0 0.09 rio.pg_catalog.pg_depend 0 0 0.76 contagem.pg_catalog.pg_attribute 0 0 0.99 rio.public.temp0000282643 0 0 0.15 rio.public.temp0000282645 0 0 0.06 rio.public.temp0000282517 0 0 0.13 rio.public.tmp_drill_0175 0 0 0.22 contagem.pg_catalog.pg_class 0 0 0.21 rio.pg_catalog.pg_statistic 0 0 1.06 contagem.pg_catalog.pg_type 0 0 0.1 contagem.pg_catalog.pg_shdepend 0 0 0.12 contagem.public.temp0000226416 0 0 0.05 rio.public.usuarios 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.14 contagem.pg_catalog.pg_depend 0 0 0.16 rio.public.temp0000282705 0 0 0.16 contagem.pg_catalog.pg_index 0 0 0.06 rio.public.tmp_drill_0302 0 0 0.05 rio.public.temp0000282695 0 0 0.05 rio.public.temp0000282611 0 0 0.02 rio.pg_catalog.pg_shdepend 0 0 0.04 rio.public.temp0000282689 0 0 0.04 rio.public.temp0000282587 0 0 0.01 rio.public.temp0000282723 0 0 0.01 rio.public.temp0000282703 0 0 0.01 rio.public.temp0000282535 0 0 0.05 rio.public.temp0000282709 0 0 0.01 rio.auditor.auditor_2026_06 0 0 15.75 brasilia.pg_catalog.pg_statistic 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000282671 0 0 0.01 rio.public.logs 0 0 0.34 rio.public.temp0000282637 0 0 0.01 rio.public.nf_entrada_arquivo_erros 0 0 0.23 rio.public.acessos 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.public.temp0000282659 0 0 0.01 contagem.auditor.auditor_2026_06 0 0 3.83 rio.public.temp0000282509 0 0 0.02 rio.public.temp0000282653 0 0 0.01 Total 0 0 34.71 Tuples removed per table
Key values
- pg_catalog.pg_attribute (225951) Main table with removed tuples on database rio
- 443038 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 55 53 225,951 1,354,295 67,004 487 34,286 rio.public.tmp_drill_0175 7 7 79,631 80,750 0 0 2,028 contagem.pg_catalog.pg_attribute 12 12 42,312 291,748 34 101 6,375 rio.public.tmp_drill_0302 3 3 22,619 23,135 0 0 582 rio.pg_catalog.pg_depend 15 15 16,071 287,792 1,301 0 2,760 rio.pg_catalog.pg_statistic 7 7 13,146 58,434 0 0 9,002 rio.pg_catalog.pg_type 32 30 11,290 74,994 2,048 20 2,274 rio.pg_catalog.pg_index 17 17 4,822 32,757 11 0 993 rio.pg_catalog.pg_class 35 33 4,656 126,834 4,686 30 4,478 contagem.pg_catalog.pg_shdepend 5 5 4,563 43,059 671 0 505 contagem.pg_catalog.pg_statistic 1 1 4,144 7,274 0 0 1,011 rio.pg_catalog.pg_shdepend 2 2 2,304 16,974 4 0 202 contagem.pg_catalog.pg_class 7 7 2,245 24,022 4 26 827 contagem.public.usuarios 28 0 1,722 644 0 0 56 contagem.pg_catalog.pg_depend 4 4 1,679 75,337 0 0 704 rio.auditor.auditor_2026_06 1 0 1,353 12,024,065 0 0 564,073 rio.pg_toast.pg_toast_2619 5 5 1,240 2,468 3 0 1,345 contagem.pg_catalog.pg_type 6 6 1,110 13,478 0 6 391 contagem.pg_catalog.pg_index 4 4 1,017 7,582 1 9 205 rio.public.nf_entrada_arquivo_erros 1 0 487 8,326,542 0 0 148,227 rio.public.usuarios 5 5 410 2,928 393 0 80 brasilia.pg_catalog.pg_statistic 1 1 153 449 0 0 36 contagem.pg_toast.pg_toast_2619 1 1 113 117 0 0 54 rio.public.temp0000282645 8 0 0 14,964 0 202 310 rio.public.temp0000282699 33 0 0 256,237 0 926 13,026 rio.public.temp0000282723 1 0 0 1,991 0 32 96 contagem.public.temp0000226416 5 0 0 5,650 0 205 435 rio.public.temp0000282695 2 0 0 23,957 0 44 1,684 rio.public.temp0000282705 4 0 0 68,424 0 44 4,884 rio.public.temp0000282703 1 0 0 1,755 0 44 84 rio.public.temp0000282535 1 0 0 22,212 0 0 1,600 rio.public.temp0000282709 1 0 0 1,755 0 43 85 rio.public.temp0000282647 24 0 0 532,489 0 0 38,400 rio.public.temp0000282611 2 0 0 4,964 0 15 113 rio.public.temp0000282621 47 0 0 796,977 0 542 56,994 rio.public.temp0000282671 1 0 0 1,544 0 53 75 rio.public.logs 1 0 0 15,896,386 0 0 635,046 rio.public.temp0000282707 32 0 0 690,551 0 30 49,698 rio.public.temp0000282637 1 0 0 1,505 0 54 74 rio.public.acessos 1 0 0 102,535 0 0 859 rio.public.temp0000282689 2 0 0 14,106 0 68 316 rio.public.temp0000282659 1 0 0 1,506 0 54 74 contagem.auditor.auditor_2026_06 1 0 0 1,966,568 0 0 85,536 rio.public.temp0000282509 1 0 0 6,735 0 41 151 rio.public.temp0000282643 10 0 0 58,155 0 427 1,301 rio.public.temp0000282587 2 0 0 11,761 0 56 264 rio.public.temp0000282517 8 0 0 56,290 0 275 1,261 rio.public.temp0000282653 1 0 0 1,506 0 54 74 Total 445 218 443,038 43,416,201 76,160 3,888 1,672,934 Pages removed per table
Key values
- public.temp0000282699 (926) Main table with removed pages on database rio
- 3888 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282699 33 0 0 926 rio.public.temp0000282621 47 0 0 542 rio.pg_catalog.pg_attribute 55 53 225951 487 rio.public.temp0000282643 10 0 0 427 rio.public.temp0000282517 8 0 0 275 contagem.public.temp0000226416 5 0 0 205 rio.public.temp0000282645 8 0 0 202 contagem.pg_catalog.pg_attribute 12 12 42312 101 rio.public.temp0000282689 2 0 0 68 rio.public.temp0000282587 2 0 0 56 rio.public.temp0000282637 1 0 0 54 rio.public.temp0000282659 1 0 0 54 rio.public.temp0000282653 1 0 0 54 rio.public.temp0000282671 1 0 0 53 rio.public.temp0000282695 2 0 0 44 rio.public.temp0000282705 4 0 0 44 rio.public.temp0000282703 1 0 0 44 rio.public.temp0000282709 1 0 0 43 rio.public.temp0000282509 1 0 0 41 rio.public.temp0000282723 1 0 0 32 rio.pg_catalog.pg_class 35 33 4656 30 rio.public.temp0000282707 32 0 0 30 contagem.pg_catalog.pg_class 7 7 2245 26 rio.pg_catalog.pg_type 32 30 11290 20 rio.public.temp0000282611 2 0 0 15 contagem.pg_catalog.pg_index 4 4 1017 9 contagem.pg_catalog.pg_type 6 6 1110 6 contagem.pg_catalog.pg_depend 4 4 1679 0 contagem.pg_catalog.pg_shdepend 5 5 4563 0 rio.public.tmp_drill_0175 7 7 79631 0 rio.public.usuarios 5 5 410 0 rio.pg_catalog.pg_depend 15 15 16071 0 rio.pg_toast.pg_toast_2619 5 5 1240 0 contagem.public.usuarios 28 0 1722 0 rio.public.temp0000282535 1 0 0 0 rio.public.temp0000282647 24 0 0 0 rio.auditor.auditor_2026_06 1 0 1353 0 brasilia.pg_catalog.pg_statistic 1 1 153 0 contagem.pg_toast.pg_toast_2619 1 1 113 0 rio.public.tmp_drill_0302 3 3 22619 0 rio.pg_catalog.pg_index 17 17 4822 0 rio.public.logs 1 0 0 0 rio.pg_catalog.pg_statistic 7 7 13146 0 rio.pg_catalog.pg_shdepend 2 2 2304 0 rio.public.nf_entrada_arquivo_erros 1 0 487 0 rio.public.acessos 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4144 0 contagem.auditor.auditor_2026_06 1 0 0 0 Total 445 218 443,038 3,888 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 16 00 1 0 01 0 0 02 0 0 03 0 1 04 0 7 05 5 7 06 0 0 07 15 21 08 54 108 09 35 87 10 54 117 11 45 103 12 19 32 13 21 61 14 58 113 15 57 113 16 32 83 17 46 69 18 2 3 19 0 0 20 0 0 21 1 0 22 0 1 23 0 0 - 15.75 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000282707;-
DROP TABLE IF EXISTS temp0000282707;
Date: 2026-06-16 16:29:01 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282707;
Date: 2026-06-16 16:29:01 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s1ms DROP TABLE IF EXISTS temp0000282707;[ Date: 2026-06-16 16:29:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,060 Total read queries
- 1,289 Total write queries
Queries by database
Key values
- rio Main database
- 4,814 Requests
- 5h58m40s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,497 Requests
User Request type Count Duration etiquetas Total 4 627ms select 4 627ms intelifix Total 5,497 6h10m7s copy to 271 35m17s ddl 1,018 49m56s others 248 22m56s select 3,959 4h21m55s lenon Total 97 1m3s select 97 1m3s Duration by user
Key values
- 6h10m7s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 4 627ms select 4 627ms intelifix Total 5,497 6h10m7s copy to 271 35m17s ddl 1,018 49m56s others 248 22m56s select 3,959 4h21m55s lenon Total 97 1m3s select 97 1m3s Queries by host
Key values
- [local] Main host
- 5,598 Requests
- 6h11m11s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,881 Requests
- 3h19m23s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-16 09:18:07 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,304 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 09:13:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m24s analyze verbose;[ Date: 2026-06-16 05:07:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 10:12:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 11:12:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 15:11:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 07:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 12:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;[ Date: 2026-06-16 14:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 16:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 17:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 18:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 21:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 13:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 08:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 20:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 19:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-16 22:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-16 11:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025664, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-16 10:49:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025660, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-16 09:43:06 - 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 1h49m49s 226 153ms 4m25s 29s157ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 16 07 6 11m20s 1m53s 08 17 14m47s 52s225ms 09 17 10m37s 37s470ms 10 22 10m31s 28s718ms 11 20 13m9s 39s450ms 12 7 12m2s 1m43s 13 38 1m21s 2s146ms 14 31 15m31s 30s41ms 15 28 10m36s 22s736ms 16 18 5m13s 17s430ms 17 22 4m37s 12s618ms [ User: intelifix - Total duration: 1h49m49s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h49m49s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 11:10:18 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025664, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 10:49:39 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025660, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 09:43:06 Duration: 4m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h33m7s 31 772ms 8m19s 3m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 16 07 2 6m33s 3m16s 08 2 5m34s 2m47s 09 2 8m23s 4m11s 10 2 7m15s 3m37s 11 2 7m13s 3m36s 12 2 6m20s 3m10s 13 2 5m36s 2m48s 14 1 8s725ms 8s725ms 15 2 6m59s 3m29s 16 2 5m59s 2m59s 17 2 5m45s 2m52s 18 2 5m39s 2m49s 19 2 5m18s 2m39s 20 2 5m27s 2m43s 21 2 5m36s 2m48s 22 2 5m14s 2m37s [ User: intelifix - Total duration: 1h33m7s - Times executed: 31 ]
[ Application: psql - Total duration: 1h33m7s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-16 09:13:21 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-16 10:12:14 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-16 11:12:08 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: psql
3 16m42s 97 8s9ms 36s217ms 10s330ms create table temp0000282621 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 16 07 15 2m45s 11s55ms 08 20 3m20s 10s20ms 09 9 1m36s 10s679ms 10 9 1m35s 10s647ms 11 8 1m25s 10s724ms 12 15 2m32s 10s165ms 14 5 50s131ms 10s26ms 15 10 1m36s 9s624ms 16 6 59s210ms 9s868ms [ User: intelifix - Total duration: 16m42s - Times executed: 97 ]
[ Application: [unknown] - Total duration: 16m42s - Times executed: 97 ]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 07:02:40 Duration: 36s217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:05:12 Duration: 12s733ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 08:16:33 Duration: 12s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 16m4s 1,362 151ms 5s383ms 708ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 16 07 16 6s841ms 427ms 08 105 1m7s 645ms 09 234 2m35s 664ms 10 219 2m16s 624ms 11 130 1m24s 648ms 12 40 27s511ms 687ms 13 49 50s927ms 1s39ms 14 165 2m2s 740ms 15 154 2m9s 838ms 16 175 2m7s 730ms 17 57 42s653ms 748ms 18 18 13s453ms 747ms [ User: intelifix - Total duration: 16m4s - Times executed: 1362 ]
[ Application: [unknown] - Total duration: 16m4s - Times executed: 1362 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (254517, 450, 'F200010347B4AAA,9877E702FEC5$F20001008010088,743AEF2F9C7A$F200011133B6438,9877E7BA3C40$F200012189B1A6A,1834AF24CBCC$F200011175B5207,9877E7BF6548$F200011252B00B1,840112377778$F200011299B04A8,84011261BC0A$F200011133B8F76,9877E7BA4F2C$F200010244B57FC,743AEF951EC8$F200012154B2C0D,840112EB9130$F200011349B51A6,84011293ED3E$F200010272B2328,743AEF9C42AC$F200010272B58FD,743AEF9C5A37$F200012084B7E2D,840112DF609F$F20001018112ACE,743AEF73CF60$F200012258B40FA,1834AF28CC88$F200012266B479B,1834AF297ED0$F200012031B947C,840112C004BB$F200013235B1163,1834AF9A49A1$F200010284BB61F,743AEFADA28B$F200011181B4584,9877E7C0C762$F200012256B02BA,1834AF287CBE$F200011133B8E65,9877E7BA4EB5$F200012073B8A59,840112DCF955$F200011133B5650,9877E7BA362E$F200012074B4955,840112DD2A24$F200012325B6B0C,1834AF6328D8$F200011315B09EC,84011280E618$F200011133B847C,9877E7BA4A5C$F200010349B2A4E,9877E705152C$F200010336E307A,9877E7006C63$F200012081B829A,840112DE6A10$F20001020614A69,743AEF70B80C$F200011168B5161,9877E7BDB413$F200012073B111F,840112DCC449$F200011294B67FA,84011260F508$F200011277B5107,8401125E7BF8$F200010302E4085,743AEFC569BC$F200012189B39C0,1834AF24D986$F200012063BAFA8,840112DADA42', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-16 14:19:27 Duration: 5s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42140, 413, '73901885850064400141,229642886370,229828798397,216923572850,229695682242,216923761432,229701313442,229825778900,229822764655,229641569003,216924363140,229827510910,229641969906,229709031031,216931170707,216928143150,229825768999,229711755976,229822725358,229698058488,229699648082,229678789302,229704159107,216950174862,229880273646,229794158282,229776371531,216926521836,229704997785,229823943951,229707841633,229825996878,229646915170,229716740717,229824016281,229639456271,229712464564,229822936366', '246479380314,246633836161,246442470000,246501112951,246438806768,246523556880,246233187374,246624240108,246481216878,246441022137,246634223349,246477285361,246540460001,246448793344,246448161936,226007185071,246542539192,246633223846,246522476079,246512860809,246489854141,246506257986,246445749499,246622963653,246608191729,246576770627,246564149393,246536604854,246624003036,246476109095,246202136566,246547695364,246525970203,246624616788,246449093250,246534890524,246625428090', 0137, 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-16 13:45:51 Duration: 4s112ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42139, 413, '270911029116101480,229688498600,229806106082,216937104159,229670274554,229669228908,229669723232,229933044262,229691482034,229933736888,229743796869,229884558283,229859811021,229859485152,229809329719,229690317587,229781129705,229785018591,229806866773,229754472031,229837165757,229812839499,229934079098,229859675979,229879889209,216938087475,229837162020,216945104154,229691600104,229782744958,229934313443,229672901433,229780879602,216936878199,229746874151,216936626581,229813058488,229780983047', '246524788808,246580143043,246475697080,226395659415,246516087374,246516076464,226022782138,246513766284,246298547176,246547746783,246546049198,246648475570,246648809698,246628672639,246525421025,246587289408,246583689820,246581668993,246586144459,246639354343,246613044054,246205445262,246650025968,246652097584,246441952845,246639915666,246472605757,246513666274,246598529304,246173941021,246488597991,246584828405,246464676072,246570469405,246463865050,246628567779,246586923435', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-16 10:47:02 Duration: 3s852ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 9m29s 3 324ms 7m24s 3m9s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 16 05 3 9m29s 3m9s [ User: intelifix - Total duration: 9m29s - Times executed: 3 ]
[ Application: psql - Total duration: 9m29s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-16 05:07:25 Duration: 7m24s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-16 05:09:30 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-16 05:07:26 Duration: 324ms Database: brasilia User: intelifix Remote: [local] Application: psql
6 9m18s 29 15s373ms 31s332ms 19s263ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 16 08 1 31s332ms 31s332ms 09 4 1m8s 17s216ms 10 4 1m16s 19s170ms 11 4 1m12s 18s6ms 12 1 17s381ms 17s381ms 13 2 38s925ms 19s462ms 14 3 1m 20s88ms 15 5 1m41s 20s273ms 16 4 1m14s 18s580ms 17 1 17s459ms 17s459ms [ User: intelifix - Total duration: 9m18s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 9m18s - Times executed: 29 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-16 08:43:19 Duration: 31s332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-16 14:15:56 Duration: 23s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-16 10:54:49 Duration: 22s563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9m10s 32 363ms 55s84ms 17s213ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 16 07 2 47s766ms 23s883ms 08 2 27s725ms 13s862ms 09 2 56s487ms 28s243ms 10 2 38s947ms 19s473ms 11 2 34s383ms 17s191ms 12 2 34s494ms 17s247ms 13 2 29s958ms 14s979ms 14 2 40s66ms 20s33ms 15 2 34s621ms 17s310ms 16 2 27s597ms 13s798ms 17 2 29s368ms 14s684ms 18 2 27s100ms 13s550ms 19 2 27s816ms 13s908ms 20 2 35s148ms 17s574ms 21 2 27s249ms 13s624ms 22 2 32s110ms 16s55ms [ User: intelifix - Total duration: 9m10s - Times executed: 32 ]
[ Application: psql - Total duration: 9m10s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-16 09:14:16 Duration: 55s84ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-16 07:12:19 Duration: 46s621ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-16 14:11:44 Duration: 39s491ms Database: rio User: intelifix Remote: [local] Application: psql
8 8m5s 47 8s355ms 14s426ms 10s320ms create table temp0000282707 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 16 14 20 3m37s 10s880ms 15 9 1m35s 10s604ms 16 4 41s337ms 10s334ms 17 14 2m10s 9s334ms [ User: intelifix - Total duration: 8m5s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m5s - Times executed: 47 ]
-
CREATE TABLE temp0000282707 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 14:18:35 Duration: 14s426ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282707 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 14:17:52 Duration: 12s972ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282707 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:10:36 Duration: 12s710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 6m48s 138 2s198ms 9s71ms 2s956ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 16 00 6 22s327ms 3s721ms 01 6 16s964ms 2s827ms 02 6 16s94ms 2s682ms 03 6 15s627ms 2s604ms 04 6 17s69ms 2s844ms 05 6 17s145ms 2s857ms 06 6 15s212ms 2s535ms 07 6 15s547ms 2s591ms 08 6 16s35ms 2s672ms 09 6 21s162ms 3s527ms 10 6 18s430ms 3s71ms 11 6 17s615ms 2s935ms 12 6 20s86ms 3s347ms 13 6 18s290ms 3s48ms 14 6 20s18ms 3s336ms 15 6 18s705ms 3s117ms 16 6 18s959ms 3s159ms 17 6 17s138ms 2s856ms 18 6 17s796ms 2s966ms 19 6 16s256ms 2s709ms 20 6 17s703ms 2s950ms 21 6 17s254ms 2s875ms 22 6 16s605ms 2s767ms [ User: intelifix - Total duration: 6m48s - Times executed: 138 ]
[ Application: psql - Total duration: 6m48s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 00:05:21 Duration: 9s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 09:15:10 Duration: 4s355ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 14:45:12 Duration: 4s302ms Database: rio User: intelifix Remote: [local] Application: psql
10 6m46s 909 151ms 2s978ms 446ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 16 08 123 1m10s 575ms 09 110 54s1ms 490ms 10 143 1m10s 490ms 11 113 51s712ms 457ms 12 1 289ms 289ms 13 112 40s718ms 363ms 14 125 48s313ms 386ms 15 100 36s278ms 362ms 16 71 28s672ms 403ms 17 11 5s197ms 472ms [ User: intelifix - Total duration: 6m46s - Times executed: 909 ]
[ Application: [unknown] - Total duration: 6m46s - Times executed: 909 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "320", "itens" : "241689127278,241670208888,241664144459,241669505072,241646217389,241629093339,241609271315,241698575866,241708920008,241616572746,230048970425,241620270526,241651948802,241614920621,241607325771,241674119090,241695486889,241654449506,241598621533,230049190929,241691075168,241601000609,241715615464,241703605055,241599503953,230043641229,241655643147,241700691124,241667082131,241690076675,241631751231,241704818293,241653303042,241669667994,241696947177,241714587799,241638980511,241673038996,241699257582,241600982526,241698489012,241676413939,241661171835,241669503456,241674573434,241596099210,241602978096", "usuario" : "405", "caixa" : "2754072", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-16 08:09:37 Duration: 2s978ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254432", "modelo" : "464", "itens" : "241770106977,241767471435,241770056972,241764823039,241746091537,241767465171,241767412136,241770171833,241767498888,241777810323,241768725967,241768720513,241768813148,241738273658,241767914665,241760017788,241688046780,241688005665,241767785359,241761196377,241764699110,241768866486,241761567378,241770183551,241761497192,241770171530,241745965362,241770108290,241768695661,241761233654,241764917290,241744249516,241742685356,241746185967,241768719704,241747338391,241739667474,241742389716,241764854153,241739468285,241765136178,241745562944,241770125767,241740608082,241743673747,241745617393,241777648184,241740622731,241745464146,241768819714,241745527384,241744091218,241770127080,241767471940,241770118493,241738388494,241744247697,241743572424,241767474869,241767483355,241770145870,241768810623,241778925470,241742910104,241767725353", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-16 10:49:39 Duration: 2s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254431", "modelo" : "320", "itens" : "241672947394,241665728597,241598123650,241651316989,241715598088,241712022241,241617671327,241646644356,241649356270,241614474662,241631073151,241620565862,241689311315,230040261112,241615899919,241649141626,241597439913,241672351927,241656357290,230043642239,241664866280,241714603435,241714603940,241661136174,241706984061,241674509107,241696798599,241619839090,834198929000623,241728327187,241699221519,241698730607,241729935167,241712679914,241659862728,241638344556,241664261317,241608707286,241629850821,241667045662,241698561017,241669707796,241653381131,241728291124,241678303237,241704185471,241699209496,241646363543", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-16 10:46:41 Duration: 2s63ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m30s 37 8s879ms 13s139ms 10s546ms create table temp0000282647 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 16 08 9 1m31s 10s137ms 09 2 18s437ms 9s218ms 10 4 43s41ms 10s760ms 11 20 3m37s 10s877ms 12 2 19s938ms 9s969ms [ User: intelifix - Total duration: 6m30s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 6m30s - Times executed: 37 ]
-
CREATE TABLE temp0000282647 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:51:02 Duration: 13s139ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282647 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:52:06 Duration: 13s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282647 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:52:44 Duration: 12s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 6m3s 1 6m3s 6m3s 6m3s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 16 14 1 6m3s 6m3s [ User: intelifix - Total duration: 6m3s - Times executed: 1 ]
[ Application: psql - Total duration: 6m3s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-16 14:11:05 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: psql
13 5m46s 100 244ms 10s871ms 3s466ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 16 00 6 17s567ms 2s927ms 01 6 7s620ms 1s270ms 02 6 5s507ms 917ms 03 5 8s389ms 1s677ms 04 5 6s126ms 1s225ms 05 5 9s647ms 1s929ms 06 3 4s641ms 1s547ms 07 6 32s752ms 5s458ms 08 6 39s18ms 6s503ms 09 6 37s376ms 6s229ms 10 6 33s960ms 5s660ms 11 6 31s900ms 5s316ms 12 6 31s593ms 5s265ms 13 1 1s436ms 1s436ms 14 6 28s446ms 4s741ms 15 6 25s518ms 4s253ms 16 5 13s73ms 2s614ms 21 4 5s168ms 1s292ms 22 6 6s913ms 1s152ms [ User: intelifix - Total duration: 5m46s - Times executed: 100 ]
[ Application: psql - Total duration: 5m46s - Times executed: 100 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 00:05:12 Duration: 10s871ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 07:25:10 Duration: 9s267ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 10:15:10 Duration: 8s634ms Database: rio User: intelifix Remote: [local] Application: psql
14 4m52s 30 7s667ms 12s385ms 9s762ms create table temp0000282699 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 16 15 18 3m1s 10s102ms 17 12 1m51s 9s251ms [ User: intelifix - Total duration: 4m52s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 4m52s - Times executed: 30 ]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:15:31 Duration: 12s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:15:48 Duration: 12s199ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:12:46 Duration: 12s197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m15s 77 154ms 1m11s 2s543ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 16 07 6 2s522ms 420ms 08 10 12s156ms 1s215ms 09 4 2s955ms 738ms 10 5 7s780ms 1s556ms 11 8 1m48s 13s535ms 12 7 19s383ms 2s769ms 14 9 21s588ms 2s398ms 15 16 13s813ms 863ms 16 3 1s711ms 570ms 17 9 5s624ms 624ms [ User: intelifix - Total duration: 3m15s - Times executed: 77 ]
[ Application: psql - Total duration: 3m15s - Times executed: 77 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025672);
Date: 2026-06-16 11:46:07 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025668);
Date: 2026-06-16 11:28:39 Duration: 28s917ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025676);
Date: 2026-06-16 12:24:05 Duration: 17s465ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m44s 2 1m19s 1m25s 1m22s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 16 20 1 1m19s 1m19s 23 1 1m25s 1m25s [ User: intelifix - Total duration: 2m44s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m44s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-16 23:36:06 Duration: 1m25s 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-16 20:08:09 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
17 1m53s 23 3s928ms 9s620ms 4s923ms create table temp0000282699 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 16 15 13 1m9s 5s364ms 17 10 43s504ms 4s350ms [ User: intelifix - Total duration: 1m53s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 23 ]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:13:22 Duration: 9s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:13:49 Duration: 8s111ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:16:32 Duration: 6s521ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m50s 2 20s496ms 1m29s 55s60ms 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 #18
Day Hour Count Duration Avg duration Jun 16 23 2 1m50s 55s60ms [ User: intelifix - Total duration: 1m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m50s - 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-16 23:13:51 Duration: 1m29s 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-16 23:37:30 Duration: 20s496ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1m48s 2 49s785ms 58s239ms 54s12ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 16 20 1 58s239ms 58s239ms 23 1 49s785ms 49s785ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-16 20:05:16 Duration: 58s239ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-16 23:17:45 Duration: 49s785ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 1m46s 24 2s875ms 10s484ms 4s435ms create table temp0000282621 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 16 07 4 19s872ms 4s968ms 08 6 22s409ms 3s734ms 09 5 21s769ms 4s353ms 10 3 10s926ms 3s642ms 15 3 15s422ms 5s140ms 16 3 16s48ms 5s349ms [ User: intelifix - Total duration: 1m46s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 1m46s - Times executed: 24 ]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 07:10:13 Duration: 10s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 09:44:36 Duration: 6s244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:34:34 Duration: 6s225ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,362 16m4s 151ms 5s383ms 708ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 16 07 16 6s841ms 427ms 08 105 1m7s 645ms 09 234 2m35s 664ms 10 219 2m16s 624ms 11 130 1m24s 648ms 12 40 27s511ms 687ms 13 49 50s927ms 1s39ms 14 165 2m2s 740ms 15 154 2m9s 838ms 16 175 2m7s 730ms 17 57 42s653ms 748ms 18 18 13s453ms 747ms [ User: intelifix - Total duration: 16m4s - Times executed: 1362 ]
[ Application: [unknown] - Total duration: 16m4s - Times executed: 1362 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (254517, 450, 'F200010347B4AAA,9877E702FEC5$F20001008010088,743AEF2F9C7A$F200011133B6438,9877E7BA3C40$F200012189B1A6A,1834AF24CBCC$F200011175B5207,9877E7BF6548$F200011252B00B1,840112377778$F200011299B04A8,84011261BC0A$F200011133B8F76,9877E7BA4F2C$F200010244B57FC,743AEF951EC8$F200012154B2C0D,840112EB9130$F200011349B51A6,84011293ED3E$F200010272B2328,743AEF9C42AC$F200010272B58FD,743AEF9C5A37$F200012084B7E2D,840112DF609F$F20001018112ACE,743AEF73CF60$F200012258B40FA,1834AF28CC88$F200012266B479B,1834AF297ED0$F200012031B947C,840112C004BB$F200013235B1163,1834AF9A49A1$F200010284BB61F,743AEFADA28B$F200011181B4584,9877E7C0C762$F200012256B02BA,1834AF287CBE$F200011133B8E65,9877E7BA4EB5$F200012073B8A59,840112DCF955$F200011133B5650,9877E7BA362E$F200012074B4955,840112DD2A24$F200012325B6B0C,1834AF6328D8$F200011315B09EC,84011280E618$F200011133B847C,9877E7BA4A5C$F200010349B2A4E,9877E705152C$F200010336E307A,9877E7006C63$F200012081B829A,840112DE6A10$F20001020614A69,743AEF70B80C$F200011168B5161,9877E7BDB413$F200012073B111F,840112DCC449$F200011294B67FA,84011260F508$F200011277B5107,8401125E7BF8$F200010302E4085,743AEFC569BC$F200012189B39C0,1834AF24D986$F200012063BAFA8,840112DADA42', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-16 14:19:27 Duration: 5s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42140, 413, '73901885850064400141,229642886370,229828798397,216923572850,229695682242,216923761432,229701313442,229825778900,229822764655,229641569003,216924363140,229827510910,229641969906,229709031031,216931170707,216928143150,229825768999,229711755976,229822725358,229698058488,229699648082,229678789302,229704159107,216950174862,229880273646,229794158282,229776371531,216926521836,229704997785,229823943951,229707841633,229825996878,229646915170,229716740717,229824016281,229639456271,229712464564,229822936366', '246479380314,246633836161,246442470000,246501112951,246438806768,246523556880,246233187374,246624240108,246481216878,246441022137,246634223349,246477285361,246540460001,246448793344,246448161936,226007185071,246542539192,246633223846,246522476079,246512860809,246489854141,246506257986,246445749499,246622963653,246608191729,246576770627,246564149393,246536604854,246624003036,246476109095,246202136566,246547695364,246525970203,246624616788,246449093250,246534890524,246625428090', 0137, 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-16 13:45:51 Duration: 4s112ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42139, 413, '270911029116101480,229688498600,229806106082,216937104159,229670274554,229669228908,229669723232,229933044262,229691482034,229933736888,229743796869,229884558283,229859811021,229859485152,229809329719,229690317587,229781129705,229785018591,229806866773,229754472031,229837165757,229812839499,229934079098,229859675979,229879889209,216938087475,229837162020,216945104154,229691600104,229782744958,229934313443,229672901433,229780879602,216936878199,229746874151,216936626581,229813058488,229780983047', '246524788808,246580143043,246475697080,226395659415,246516087374,246516076464,226022782138,246513766284,246298547176,246547746783,246546049198,246648475570,246648809698,246628672639,246525421025,246587289408,246583689820,246581668993,246586144459,246639354343,246613044054,246205445262,246650025968,246652097584,246441952845,246639915666,246472605757,246513666274,246598529304,246173941021,246488597991,246584828405,246464676072,246570469405,246463865050,246628567779,246586923435', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-16 10:47:02 Duration: 3s852ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 909 6m46s 151ms 2s978ms 446ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 16 08 123 1m10s 575ms 09 110 54s1ms 490ms 10 143 1m10s 490ms 11 113 51s712ms 457ms 12 1 289ms 289ms 13 112 40s718ms 363ms 14 125 48s313ms 386ms 15 100 36s278ms 362ms 16 71 28s672ms 403ms 17 11 5s197ms 472ms [ User: intelifix - Total duration: 6m46s - Times executed: 909 ]
[ Application: [unknown] - Total duration: 6m46s - Times executed: 909 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "320", "itens" : "241689127278,241670208888,241664144459,241669505072,241646217389,241629093339,241609271315,241698575866,241708920008,241616572746,230048970425,241620270526,241651948802,241614920621,241607325771,241674119090,241695486889,241654449506,241598621533,230049190929,241691075168,241601000609,241715615464,241703605055,241599503953,230043641229,241655643147,241700691124,241667082131,241690076675,241631751231,241704818293,241653303042,241669667994,241696947177,241714587799,241638980511,241673038996,241699257582,241600982526,241698489012,241676413939,241661171835,241669503456,241674573434,241596099210,241602978096", "usuario" : "405", "caixa" : "2754072", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-16 08:09:37 Duration: 2s978ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254432", "modelo" : "464", "itens" : "241770106977,241767471435,241770056972,241764823039,241746091537,241767465171,241767412136,241770171833,241767498888,241777810323,241768725967,241768720513,241768813148,241738273658,241767914665,241760017788,241688046780,241688005665,241767785359,241761196377,241764699110,241768866486,241761567378,241770183551,241761497192,241770171530,241745965362,241770108290,241768695661,241761233654,241764917290,241744249516,241742685356,241746185967,241768719704,241747338391,241739667474,241742389716,241764854153,241739468285,241765136178,241745562944,241770125767,241740608082,241743673747,241745617393,241777648184,241740622731,241745464146,241768819714,241745527384,241744091218,241770127080,241767471940,241770118493,241738388494,241744247697,241743572424,241767474869,241767483355,241770145870,241768810623,241778925470,241742910104,241767725353", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-16 10:49:39 Duration: 2s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "254431", "modelo" : "320", "itens" : "241672947394,241665728597,241598123650,241651316989,241715598088,241712022241,241617671327,241646644356,241649356270,241614474662,241631073151,241620565862,241689311315,230040261112,241615899919,241649141626,241597439913,241672351927,241656357290,230043642239,241664866280,241714603435,241714603940,241661136174,241706984061,241674509107,241696798599,241619839090,834198929000623,241728327187,241699221519,241698730607,241729935167,241712679914,241659862728,241638344556,241664261317,241608707286,241629850821,241667045662,241698561017,241669707796,241653381131,241728291124,241678303237,241704185471,241699209496,241646363543", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-16 10:46:41 Duration: 2s63ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 226 1h49m49s 153ms 4m25s 29s157ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 16 07 6 11m20s 1m53s 08 17 14m47s 52s225ms 09 17 10m37s 37s470ms 10 22 10m31s 28s718ms 11 20 13m9s 39s450ms 12 7 12m2s 1m43s 13 38 1m21s 2s146ms 14 31 15m31s 30s41ms 15 28 10m36s 22s736ms 16 18 5m13s 17s430ms 17 22 4m37s 12s618ms [ User: intelifix - Total duration: 1h49m49s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h49m49s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 11:10:18 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025664, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 10:49:39 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025660, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 09:43:06 Duration: 4m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 145 38s769ms 150ms 766ms 267ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 16 09 90 23s204ms 257ms 10 55 15s564ms 282ms [ User: intelifix - Total duration: 38s769ms - Times executed: 145 ]
[ Application: [unknown] - Total duration: 38s769ms - Times executed: 145 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42321","seriais":"14CA56CD7081,C4EBFF8B9020,D831398ED5CA,D89A0DA91803,5872C98D0AC1,C4EBFF8F050E,3CF9F0A28182,843C9920D2CF,3891484BD9B7,6C11BA6763DD,38914851FA3F,38914851DA53,14CA56D6D23D,38914851FA8D,3CF9F0AC59A0,3CF9F0A8BD70,843C991F14AD,389148519D75,4896D9540C86,3891484A48AD,48D68237E562,14CA56CF5B01,48D68237E532,38914851A621,5872C98AE687,3CF9F0AB3F2E,38914851F3C1","usuario":"416","observacao":""}');
Date: 2026-06-16 09:50:55 Duration: 766ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42322","seriais":"F8F5325A66E3,5819F843A2D6,BC644BD55ABE,BC644BD25BA2,BC644BC5DFE4,4C1265E71950,CC75E2B9AEFB,BC644BD3DB35,F8F53252308B,2C9569F08D09,4C12653C2DC4,A8F5DDE9402E,BC644BCD82D0,A8F5DDE410B3,BC644BD644C9,BC644BCE8F3B,B0DAF9619A97","usuario":"406","observacao":""}');
Date: 2026-06-16 10:13:21 Duration: 681ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42321","seriais":"F4E84F80D356,3CF9F0AC5EE6,389148519B29,D89A0DAC1CFB,D831391FC0AA,3CF9F0AC1FEC,D89A0DAFDDF1,F4E84F80C474,D831398CD1D6,D89A0DAFE325,14CA56CD721F,3CF9F0AC5DF6,D89A0DAC407D,D831399022C4,6C11BA675EF7,4896D9532C64,843C991F735D,38914851F23B,5872C98AE6DB,38914851F98B","usuario":"406","observacao":""}');
Date: 2026-06-16 09:56:35 Duration: 673ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 138 6m48s 2s198ms 9s71ms 2s956ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 16 00 6 22s327ms 3s721ms 01 6 16s964ms 2s827ms 02 6 16s94ms 2s682ms 03 6 15s627ms 2s604ms 04 6 17s69ms 2s844ms 05 6 17s145ms 2s857ms 06 6 15s212ms 2s535ms 07 6 15s547ms 2s591ms 08 6 16s35ms 2s672ms 09 6 21s162ms 3s527ms 10 6 18s430ms 3s71ms 11 6 17s615ms 2s935ms 12 6 20s86ms 3s347ms 13 6 18s290ms 3s48ms 14 6 20s18ms 3s336ms 15 6 18s705ms 3s117ms 16 6 18s959ms 3s159ms 17 6 17s138ms 2s856ms 18 6 17s796ms 2s966ms 19 6 16s256ms 2s709ms 20 6 17s703ms 2s950ms 21 6 17s254ms 2s875ms 22 6 16s605ms 2s767ms [ User: intelifix - Total duration: 6m48s - Times executed: 138 ]
[ Application: psql - Total duration: 6m48s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 00:05:21 Duration: 9s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 09:15:10 Duration: 4s355ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 14:45:12 Duration: 4s302ms Database: rio User: intelifix Remote: [local] Application: psql
6 123 1m1s 150ms 4s211ms 496ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 16 08 3 4s984ms 1s661ms 09 4 4s628ms 1s157ms 10 15 11s231ms 748ms 11 6 3s5ms 500ms 13 35 15s763ms 450ms 14 21 7s577ms 360ms 15 14 4s426ms 316ms 16 15 5s58ms 337ms 17 10 4s345ms 434ms [ User: intelifix - Total duration: 1m1s - Times executed: 123 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 123 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-16 08:31:02 Duration: 4s211ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042044) LIMIT 1;
Date: 2026-06-16 09:32:44 Duration: 3s45ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042321) LIMIT 1;
Date: 2026-06-16 10:53:36 Duration: 1s793ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 120 21s450ms 150ms 748ms 178ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 16 00 1 180ms 180ms 07 1 748ms 748ms 08 3 514ms 171ms 09 1 154ms 154ms 10 2 307ms 153ms 11 11 1s863ms 169ms 12 6 1s22ms 170ms 13 8 1s399ms 174ms 14 10 1s737ms 173ms 15 23 3s955ms 171ms 16 31 5s219ms 168ms 17 23 4s346ms 188ms [ User: intelifix - Total duration: 21s450ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 21s450ms - Times executed: 120 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-06-15", "data-ate" : "2026-06-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 366 }');
Date: 2026-06-16 07:49:05 Duration: 748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-16", "data-ate" : "2026-06-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-16 17:36:19 Duration: 264ms 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-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-16 17:35:35 Duration: 239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 114 18s669ms 150ms 210ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 16 03 1 153ms 153ms 04 2 352ms 176ms 05 1 201ms 201ms 07 2 307ms 153ms 08 5 835ms 167ms 09 8 1s239ms 154ms 10 20 3s341ms 167ms 11 11 1s790ms 162ms 12 3 485ms 161ms 13 11 1s756ms 159ms 14 15 2s416ms 161ms 15 13 2s117ms 162ms 16 16 2s648ms 165ms 17 6 1s24ms 170ms [ User: intelifix - Total duration: 18s669ms - Times executed: 114 ]
[ Application: [unknown] - Total duration: 18s669ms - Times executed: 114 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-06-16 10:44:30 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 039;
Date: 2026-06-16 16:25:56 Duration: 209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-16 17:13:15 Duration: 201ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 106 32s317ms 173ms 488ms 304ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 16 07 1 183ms 183ms 08 48 14s338ms 298ms 11 17 5s494ms 323ms 14 40 12s300ms 307ms [ User: intelifix - Total duration: 32s317ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 32s317ms - Times executed: 106 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (135757);
Date: 2026-06-16 11:48:15 Duration: 488ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0229989);
Date: 2026-06-16 14:29:47 Duration: 483ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (135757);
Date: 2026-06-16 11:48:20 Duration: 476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 101 19s455ms 150ms 370ms 192ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 16 00 3 545ms 181ms 04 15 3s520ms 234ms 05 3 681ms 227ms 07 6 1s271ms 211ms 08 12 2s246ms 187ms 09 13 2s559ms 196ms 10 11 1s958ms 178ms 11 8 1s299ms 162ms 12 9 1s564ms 173ms 14 9 1s596ms 177ms 15 9 1s629ms 181ms 16 3 584ms 194ms [ User: intelifix - Total duration: 19s455ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 19s455ms - Times executed: 101 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241649356270,241646644356,241617671327,241712022241,241715598088,241651316989,241598123650,241665728597,241629850821,241608707286,241664261317,241638344556,241659862728,241712679914,241729935167,241698730607,241699221519,241670316071,241728327187', NULL, NULL, 0320, 00);
Date: 2026-06-16 04:43:57 Duration: 370ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216729972328,216854256578,216850397896,216441292527,216825577898,216605840113,216902411032,216527493151', NULL, NULL, 064, 00);
Date: 2026-06-16 07:02:06 Duration: 322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241615252022,241619839090,241696798599,241674509107,241706984061,241661136174,241714603940,241714603435,241656357290,241672351927,241597439913,241649141626,241615899919,230040261112,241689311315,241620565862,241631073151,241614474662,241672947394,241676438486', NULL, NULL, 0320, 00);
Date: 2026-06-16 04:45:50 Duration: 322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 100 5m46s 244ms 10s871ms 3s466ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 16 00 6 17s567ms 2s927ms 01 6 7s620ms 1s270ms 02 6 5s507ms 917ms 03 5 8s389ms 1s677ms 04 5 6s126ms 1s225ms 05 5 9s647ms 1s929ms 06 3 4s641ms 1s547ms 07 6 32s752ms 5s458ms 08 6 39s18ms 6s503ms 09 6 37s376ms 6s229ms 10 6 33s960ms 5s660ms 11 6 31s900ms 5s316ms 12 6 31s593ms 5s265ms 13 1 1s436ms 1s436ms 14 6 28s446ms 4s741ms 15 6 25s518ms 4s253ms 16 5 13s73ms 2s614ms 21 4 5s168ms 1s292ms 22 6 6s913ms 1s152ms [ User: intelifix - Total duration: 5m46s - Times executed: 100 ]
[ Application: psql - Total duration: 5m46s - Times executed: 100 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 00:05:12 Duration: 10s871ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 07:25:10 Duration: 9s267ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 10:15:10 Duration: 8s634ms Database: rio User: intelifix Remote: [local] Application: psql
12 97 16m42s 8s9ms 36s217ms 10s330ms create table temp0000282621 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 16 07 15 2m45s 11s55ms 08 20 3m20s 10s20ms 09 9 1m36s 10s679ms 10 9 1m35s 10s647ms 11 8 1m25s 10s724ms 12 15 2m32s 10s165ms 14 5 50s131ms 10s26ms 15 10 1m36s 9s624ms 16 6 59s210ms 9s868ms [ User: intelifix - Total duration: 16m42s - Times executed: 97 ]
[ Application: [unknown] - Total duration: 16m42s - Times executed: 97 ]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 07:02:40 Duration: 36s217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:05:12 Duration: 12s733ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 08:16:33 Duration: 12s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 93 39s575ms 272ms 722ms 425ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 16 00 2 959ms 479ms 03 1 374ms 374ms 04 2 783ms 391ms 05 1 532ms 532ms 06 1 337ms 337ms 07 7 2s749ms 392ms 08 7 3s18ms 431ms 09 9 3s986ms 442ms 10 8 3s279ms 409ms 11 9 4s43ms 449ms 12 4 1s929ms 482ms 13 8 3s579ms 447ms 14 8 3s460ms 432ms 15 8 3s78ms 384ms 16 7 2s682ms 383ms 17 6 2s881ms 480ms 18 2 710ms 355ms 21 2 842ms 421ms 22 1 345ms 345ms [ User: lenon - Total duration: 39s575ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 39s575ms - Times executed: 93 ]
-
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-16 17:17:55 Duration: 722ms 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-16 17:11:12 Duration: 631ms 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-16 12:13:35 Duration: 615ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
14 89 20s275ms 160ms 347ms 227ms create table temp0000282535 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 16 07 2 406ms 203ms 08 14 2s795ms 199ms 09 14 3s200ms 228ms 10 14 3s830ms 273ms 11 14 3s525ms 251ms 12 9 2s85ms 231ms 14 6 1s279ms 213ms 15 8 1s547ms 193ms 16 8 1s605ms 200ms [ User: intelifix - Total duration: 20s275ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 20s275ms - Times executed: 89 ]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79782", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 10:52:12 Duration: 347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79782", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 10:38:37 Duration: 324ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79782", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 11:57:16 Duration: 323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 86 28s993ms 178ms 5s212ms 337ms create table temp0000282703 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 16 13 4 6s36ms 1s509ms 14 36 9s861ms 273ms 15 15 4s545ms 303ms 16 14 3s814ms 272ms 17 17 4s735ms 278ms [ User: intelifix - Total duration: 28s993ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 28s993ms - Times executed: 86 ]
-
CREATE TABLE temp0000282703 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 13:32:48 Duration: 5s212ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282703 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79782", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:18:27 Duration: 443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282703 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79782", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 17:27:47 Duration: 401ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 85 45s145ms 361ms 841ms 531ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 16 00 1 636ms 636ms 03 1 510ms 510ms 04 2 1s1ms 500ms 05 1 623ms 623ms 07 5 2s503ms 500ms 08 7 3s846ms 549ms 09 9 4s810ms 534ms 10 8 4s54ms 506ms 11 8 4s398ms 549ms 12 4 2s276ms 569ms 13 7 3s800ms 542ms 14 8 4s339ms 542ms 15 8 3s867ms 483ms 16 7 3s423ms 489ms 17 6 3s461ms 576ms 18 2 1s30ms 515ms 21 1 561ms 561ms [ User: intelifix - Total duration: 45s145ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 45s145ms - Times executed: 85 ]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-06-16 17:17:55 Duration: 841ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-06-16 10:39:13 Duration: 764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (184, 19, 1);
Date: 2026-06-16 17:11:12 Duration: 751ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 77 3m15s 154ms 1m11s 2s543ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 16 07 6 2s522ms 420ms 08 10 12s156ms 1s215ms 09 4 2s955ms 738ms 10 5 7s780ms 1s556ms 11 8 1m48s 13s535ms 12 7 19s383ms 2s769ms 14 9 21s588ms 2s398ms 15 16 13s813ms 863ms 16 3 1s711ms 570ms 17 9 5s624ms 624ms [ User: intelifix - Total duration: 3m15s - Times executed: 77 ]
[ Application: psql - Total duration: 3m15s - Times executed: 77 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025672);
Date: 2026-06-16 11:46:07 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025668);
Date: 2026-06-16 11:28:39 Duration: 28s917ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025676);
Date: 2026-06-16 12:24:05 Duration: 17s465ms Database: rio User: intelifix Remote: [local] Application: psql
18 75 49s24ms 158ms 4s234ms 653ms create table temp0000282659 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 16 08 4 5s555ms 1s388ms 09 20 12s371ms 618ms 10 28 18s963ms 677ms 11 12 7s874ms 656ms 12 5 2s971ms 594ms 13 1 158ms 158ms 15 1 165ms 165ms 16 3 742ms 247ms 17 1 221ms 221ms [ User: intelifix - Total duration: 49s24ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 49s24ms - Times executed: 75 ]
-
CREATE TABLE temp0000282659 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 08:17:47 Duration: 4s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282659 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"1-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 10:44:12 Duration: 1s18ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282659 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"1-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 11:24:41 Duration: 952ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 68 13s935ms 152ms 648ms 204ms create table temp0000226412 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 16 08 1 648ms 648ms 10 10 1s666ms 166ms 11 8 1s613ms 201ms 13 16 2s906ms 181ms 14 13 2s742ms 210ms 15 14 2s706ms 193ms 16 6 1s651ms 275ms [ User: intelifix - Total duration: 13s935ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 13s935ms - Times executed: 68 ]
-
CREATE TABLE temp0000226412 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 08:29:33 Duration: 648ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226412 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"2794", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 16:55:13 Duration: 308ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226412 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"2794", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 16:27:19 Duration: 293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 62 22s884ms 253ms 623ms 369ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 16 07 3 1s75ms 358ms 08 8 3s6ms 375ms 09 5 2s275ms 455ms 10 3 1s137ms 379ms 11 7 2s779ms 397ms 12 4 1s534ms 383ms 13 1 433ms 433ms 14 8 2s739ms 342ms 15 10 3s420ms 342ms 16 4 1s373ms 343ms 17 9 3s108ms 345ms [ User: intelifix - Total duration: 22s884ms - Times executed: 62 ]
[ Application: [unknown] - Total duration: 22s884ms - Times executed: 62 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-16 09:35:53 Duration: 623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-16 11:03:04 Duration: 544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-16 14:59:25 Duration: 523ms 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 6m3s 6m3s 6m3s 1 6m3s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 16 14 1 6m3s 6m3s [ User: intelifix - Total duration: 6m3s - Times executed: 1 ]
[ Application: psql - Total duration: 6m3s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-16 14:11:05 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: psql
2 324ms 7m24s 3m9s 3 9m29s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 16 05 3 9m29s 3m9s [ User: intelifix - Total duration: 9m29s - Times executed: 3 ]
[ Application: psql - Total duration: 9m29s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-16 05:07:25 Duration: 7m24s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-16 05:09:30 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-16 05:07:26 Duration: 324ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 772ms 8m19s 3m 31 1h33m7s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 16 07 2 6m33s 3m16s 08 2 5m34s 2m47s 09 2 8m23s 4m11s 10 2 7m15s 3m37s 11 2 7m13s 3m36s 12 2 6m20s 3m10s 13 2 5m36s 2m48s 14 1 8s725ms 8s725ms 15 2 6m59s 3m29s 16 2 5m59s 2m59s 17 2 5m45s 2m52s 18 2 5m39s 2m49s 19 2 5m18s 2m39s 20 2 5m27s 2m43s 21 2 5m36s 2m48s 22 2 5m14s 2m37s [ User: intelifix - Total duration: 1h33m7s - Times executed: 31 ]
[ Application: psql - Total duration: 1h33m7s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-16 09:13:21 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-16 10:12:14 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-16 11:12:08 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: psql
4 1m19s 1m25s 1m22s 2 2m44s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 16 20 1 1m19s 1m19s 23 1 1m25s 1m25s [ User: intelifix - Total duration: 2m44s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m44s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-16 23:36:06 Duration: 1m25s 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-16 20:08:09 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
5 20s496ms 1m29s 55s60ms 2 1m50s 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 #5
Day Hour Count Duration Avg duration Jun 16 23 2 1m50s 55s60ms [ User: intelifix - Total duration: 1m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m50s - 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-16 23:13:51 Duration: 1m29s 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-16 23:37:30 Duration: 20s496ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 49s785ms 58s239ms 54s12ms 2 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 16 20 1 58s239ms 58s239ms 23 1 49s785ms 49s785ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-16 20:05:16 Duration: 58s239ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-16 23:17:45 Duration: 49s785ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 153ms 4m25s 29s157ms 226 1h49m49s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 16 07 6 11m20s 1m53s 08 17 14m47s 52s225ms 09 17 10m37s 37s470ms 10 22 10m31s 28s718ms 11 20 13m9s 39s450ms 12 7 12m2s 1m43s 13 38 1m21s 2s146ms 14 31 15m31s 30s41ms 15 28 10m36s 22s736ms 16 18 5m13s 17s430ms 17 22 4m37s 12s618ms [ User: intelifix - Total duration: 1h49m49s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h49m49s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 11:10:18 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025664, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 10:49:39 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025660, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-16 09:43:06 Duration: 4m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 15s373ms 31s332ms 19s263ms 29 9m18s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 16 08 1 31s332ms 31s332ms 09 4 1m8s 17s216ms 10 4 1m16s 19s170ms 11 4 1m12s 18s6ms 12 1 17s381ms 17s381ms 13 2 38s925ms 19s462ms 14 3 1m 20s88ms 15 5 1m41s 20s273ms 16 4 1m14s 18s580ms 17 1 17s459ms 17s459ms [ User: intelifix - Total duration: 9m18s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 9m18s - Times executed: 29 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-16 08:43:19 Duration: 31s332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-16 14:15:56 Duration: 23s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-16', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-16 10:54:49 Duration: 22s563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 363ms 55s84ms 17s213ms 32 9m10s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 16 07 2 47s766ms 23s883ms 08 2 27s725ms 13s862ms 09 2 56s487ms 28s243ms 10 2 38s947ms 19s473ms 11 2 34s383ms 17s191ms 12 2 34s494ms 17s247ms 13 2 29s958ms 14s979ms 14 2 40s66ms 20s33ms 15 2 34s621ms 17s310ms 16 2 27s597ms 13s798ms 17 2 29s368ms 14s684ms 18 2 27s100ms 13s550ms 19 2 27s816ms 13s908ms 20 2 35s148ms 17s574ms 21 2 27s249ms 13s624ms 22 2 32s110ms 16s55ms [ User: intelifix - Total duration: 9m10s - Times executed: 32 ]
[ Application: psql - Total duration: 9m10s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-16 09:14:16 Duration: 55s84ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-16 07:12:19 Duration: 46s621ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-16 14:11:44 Duration: 39s491ms Database: rio User: intelifix Remote: [local] Application: psql
10 8s879ms 13s139ms 10s546ms 37 6m30s create table temp0000282647 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 16 08 9 1m31s 10s137ms 09 2 18s437ms 9s218ms 10 4 43s41ms 10s760ms 11 20 3m37s 10s877ms 12 2 19s938ms 9s969ms [ User: intelifix - Total duration: 6m30s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 6m30s - Times executed: 37 ]
-
CREATE TABLE temp0000282647 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:51:02 Duration: 13s139ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282647 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:52:06 Duration: 13s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282647 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:52:44 Duration: 12s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s9ms 36s217ms 10s330ms 97 16m42s create table temp0000282621 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 16 07 15 2m45s 11s55ms 08 20 3m20s 10s20ms 09 9 1m36s 10s679ms 10 9 1m35s 10s647ms 11 8 1m25s 10s724ms 12 15 2m32s 10s165ms 14 5 50s131ms 10s26ms 15 10 1m36s 9s624ms 16 6 59s210ms 9s868ms [ User: intelifix - Total duration: 16m42s - Times executed: 97 ]
[ Application: [unknown] - Total duration: 16m42s - Times executed: 97 ]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 07:02:40 Duration: 36s217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 11:05:12 Duration: 12s733ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 08:16:33 Duration: 12s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s355ms 14s426ms 10s320ms 47 8m5s create table temp0000282707 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 16 14 20 3m37s 10s880ms 15 9 1m35s 10s604ms 16 4 41s337ms 10s334ms 17 14 2m10s 9s334ms [ User: intelifix - Total duration: 8m5s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m5s - Times executed: 47 ]
-
CREATE TABLE temp0000282707 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 14:18:35 Duration: 14s426ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282707 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 14:17:52 Duration: 12s972ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282707 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:10:36 Duration: 12s710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 7s667ms 12s385ms 9s762ms 30 4m52s create table temp0000282699 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 16 15 18 3m1s 10s102ms 17 12 1m51s 9s251ms [ User: intelifix - Total duration: 4m52s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 4m52s - Times executed: 30 ]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:15:31 Duration: 12s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:15:48 Duration: 12s199ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-16 15:12:46 Duration: 12s197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3s928ms 9s620ms 4s923ms 23 1m53s create table temp0000282699 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 16 15 13 1m9s 5s364ms 17 10 43s504ms 4s350ms [ User: intelifix - Total duration: 1m53s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 23 ]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:13:22 Duration: 9s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:13:49 Duration: 8s111ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:16:32 Duration: 6s521ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2s875ms 10s484ms 4s435ms 24 1m46s create table temp0000282621 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 16 07 4 19s872ms 4s968ms 08 6 22s409ms 3s734ms 09 5 21s769ms 4s353ms 10 3 10s926ms 3s642ms 15 3 15s422ms 5s140ms 16 3 16s48ms 5s349ms [ User: intelifix - Total duration: 1m46s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 1m46s - Times executed: 24 ]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 07:10:13 Duration: 10s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 09:44:36 Duration: 6s244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282621 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 15:34:34 Duration: 6s225ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 244ms 10s871ms 3s466ms 100 5m46s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 16 00 6 17s567ms 2s927ms 01 6 7s620ms 1s270ms 02 6 5s507ms 917ms 03 5 8s389ms 1s677ms 04 5 6s126ms 1s225ms 05 5 9s647ms 1s929ms 06 3 4s641ms 1s547ms 07 6 32s752ms 5s458ms 08 6 39s18ms 6s503ms 09 6 37s376ms 6s229ms 10 6 33s960ms 5s660ms 11 6 31s900ms 5s316ms 12 6 31s593ms 5s265ms 13 1 1s436ms 1s436ms 14 6 28s446ms 4s741ms 15 6 25s518ms 4s253ms 16 5 13s73ms 2s614ms 21 4 5s168ms 1s292ms 22 6 6s913ms 1s152ms [ User: intelifix - Total duration: 5m46s - Times executed: 100 ]
[ Application: psql - Total duration: 5m46s - Times executed: 100 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 00:05:12 Duration: 10s871ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 07:25:10 Duration: 9s267ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-16 10:15:10 Duration: 8s634ms Database: rio User: intelifix Remote: [local] Application: psql
17 2s198ms 9s71ms 2s956ms 138 6m48s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 16 00 6 22s327ms 3s721ms 01 6 16s964ms 2s827ms 02 6 16s94ms 2s682ms 03 6 15s627ms 2s604ms 04 6 17s69ms 2s844ms 05 6 17s145ms 2s857ms 06 6 15s212ms 2s535ms 07 6 15s547ms 2s591ms 08 6 16s35ms 2s672ms 09 6 21s162ms 3s527ms 10 6 18s430ms 3s71ms 11 6 17s615ms 2s935ms 12 6 20s86ms 3s347ms 13 6 18s290ms 3s48ms 14 6 20s18ms 3s336ms 15 6 18s705ms 3s117ms 16 6 18s959ms 3s159ms 17 6 17s138ms 2s856ms 18 6 17s796ms 2s966ms 19 6 16s256ms 2s709ms 20 6 17s703ms 2s950ms 21 6 17s254ms 2s875ms 22 6 16s605ms 2s767ms [ User: intelifix - Total duration: 6m48s - Times executed: 138 ]
[ Application: psql - Total duration: 6m48s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 00:05:21 Duration: 9s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 09:15:10 Duration: 4s355ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-16 14:45:12 Duration: 4s302ms Database: rio User: intelifix Remote: [local] Application: psql
18 154ms 1m11s 2s543ms 77 3m15s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 16 07 6 2s522ms 420ms 08 10 12s156ms 1s215ms 09 4 2s955ms 738ms 10 5 7s780ms 1s556ms 11 8 1m48s 13s535ms 12 7 19s383ms 2s769ms 14 9 21s588ms 2s398ms 15 16 13s813ms 863ms 16 3 1s711ms 570ms 17 9 5s624ms 624ms [ User: intelifix - Total duration: 3m15s - Times executed: 77 ]
[ Application: psql - Total duration: 3m15s - Times executed: 77 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025672);
Date: 2026-06-16 11:46:07 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025668);
Date: 2026-06-16 11:28:39 Duration: 28s917ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025676);
Date: 2026-06-16 12:24:05 Duration: 17s465ms Database: rio User: intelifix Remote: [local] Application: psql
19 151ms 5s383ms 708ms 1,362 16m4s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 16 07 16 6s841ms 427ms 08 105 1m7s 645ms 09 234 2m35s 664ms 10 219 2m16s 624ms 11 130 1m24s 648ms 12 40 27s511ms 687ms 13 49 50s927ms 1s39ms 14 165 2m2s 740ms 15 154 2m9s 838ms 16 175 2m7s 730ms 17 57 42s653ms 748ms 18 18 13s453ms 747ms [ User: intelifix - Total duration: 16m4s - Times executed: 1362 ]
[ Application: [unknown] - Total duration: 16m4s - Times executed: 1362 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (254517, 450, 'F200010347B4AAA,9877E702FEC5$F20001008010088,743AEF2F9C7A$F200011133B6438,9877E7BA3C40$F200012189B1A6A,1834AF24CBCC$F200011175B5207,9877E7BF6548$F200011252B00B1,840112377778$F200011299B04A8,84011261BC0A$F200011133B8F76,9877E7BA4F2C$F200010244B57FC,743AEF951EC8$F200012154B2C0D,840112EB9130$F200011349B51A6,84011293ED3E$F200010272B2328,743AEF9C42AC$F200010272B58FD,743AEF9C5A37$F200012084B7E2D,840112DF609F$F20001018112ACE,743AEF73CF60$F200012258B40FA,1834AF28CC88$F200012266B479B,1834AF297ED0$F200012031B947C,840112C004BB$F200013235B1163,1834AF9A49A1$F200010284BB61F,743AEFADA28B$F200011181B4584,9877E7C0C762$F200012256B02BA,1834AF287CBE$F200011133B8E65,9877E7BA4EB5$F200012073B8A59,840112DCF955$F200011133B5650,9877E7BA362E$F200012074B4955,840112DD2A24$F200012325B6B0C,1834AF6328D8$F200011315B09EC,84011280E618$F200011133B847C,9877E7BA4A5C$F200010349B2A4E,9877E705152C$F200010336E307A,9877E7006C63$F200012081B829A,840112DE6A10$F20001020614A69,743AEF70B80C$F200011168B5161,9877E7BDB413$F200012073B111F,840112DCC449$F200011294B67FA,84011260F508$F200011277B5107,8401125E7BF8$F200010302E4085,743AEFC569BC$F200012189B39C0,1834AF24D986$F200012063BAFA8,840112DADA42', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-16 14:19:27 Duration: 5s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42140, 413, '73901885850064400141,229642886370,229828798397,216923572850,229695682242,216923761432,229701313442,229825778900,229822764655,229641569003,216924363140,229827510910,229641969906,229709031031,216931170707,216928143150,229825768999,229711755976,229822725358,229698058488,229699648082,229678789302,229704159107,216950174862,229880273646,229794158282,229776371531,216926521836,229704997785,229823943951,229707841633,229825996878,229646915170,229716740717,229824016281,229639456271,229712464564,229822936366', '246479380314,246633836161,246442470000,246501112951,246438806768,246523556880,246233187374,246624240108,246481216878,246441022137,246634223349,246477285361,246540460001,246448793344,246448161936,226007185071,246542539192,246633223846,246522476079,246512860809,246489854141,246506257986,246445749499,246622963653,246608191729,246576770627,246564149393,246536604854,246624003036,246476109095,246202136566,246547695364,246525970203,246624616788,246449093250,246534890524,246625428090', 0137, 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-16 13:45:51 Duration: 4s112ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42139, 413, '270911029116101480,229688498600,229806106082,216937104159,229670274554,229669228908,229669723232,229933044262,229691482034,229933736888,229743796869,229884558283,229859811021,229859485152,229809329719,229690317587,229781129705,229785018591,229806866773,229754472031,229837165757,229812839499,229934079098,229859675979,229879889209,216938087475,229837162020,216945104154,229691600104,229782744958,229934313443,229672901433,229780879602,216936878199,229746874151,216936626581,229813058488,229780983047', '246524788808,246580143043,246475697080,226395659415,246516087374,246516076464,226022782138,246513766284,246298547176,246547746783,246546049198,246648475570,246648809698,246628672639,246525421025,246587289408,246583689820,246581668993,246586144459,246639354343,246613044054,246205445262,246650025968,246652097584,246441952845,246639915666,246472605757,246513666274,246598529304,246173941021,246488597991,246584828405,246464676072,246570469405,246463865050,246628567779,246586923435', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-16 10:47:02 Duration: 3s852ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 158ms 4s234ms 653ms 75 49s24ms create table temp0000282659 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 16 08 4 5s555ms 1s388ms 09 20 12s371ms 618ms 10 28 18s963ms 677ms 11 12 7s874ms 656ms 12 5 2s971ms 594ms 13 1 158ms 158ms 15 1 165ms 165ms 16 3 742ms 247ms 17 1 221ms 221ms [ User: intelifix - Total duration: 49s24ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 49s24ms - Times executed: 75 ]
-
CREATE TABLE temp0000282659 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-06-2026", "ate" :"16-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 08:17:47 Duration: 4s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282659 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"1-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 10:44:12 Duration: 1s18ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282659 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"1-06-2026", "ate" :"16-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-16 11:24:41 Duration: 952ms 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 NO DATASET
-
Events
Log levels
Key values
- 14,928 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 2869 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,374 Max number of times the same event was reported
- 2,886 Total events found
Rank Times reported Error 1 2,374 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 16 07 62 08 213 09 374 10 271 11 311 12 144 13 76 14 360 15 243 16 279 17 26 18 15 - ERROR: prepared statement "_PLAN00000000308EC380" does not exist
- ERROR: prepared statement "_PLAN00000000308EA820" does not exist
- ERROR: prepared statement "_PLAN00000000308EDA50" does not exist
Statement: DEALLOCATE "_PLAN00000000308EC380"
Date: 2026-06-16 07:16:36 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000308EA820"
Date: 2026-06-16 07:17:50 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000308EDA50"
Date: 2026-06-16 07:19:12 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
2 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 16 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-16 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-16 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-16 00:25:05 Database: brasilia Application: psql User: intelifix Remote: [local]
3 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 16 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-16 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-16 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-16 00:25:05 Database: brasilia Application: psql User: intelifix Remote: [local]
4 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 16 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-16 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-16 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-16 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 16 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-16 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-16 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-16 08:40:06 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 16 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-16 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-16 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-16 08:40:06 Database: rio Application: psql User: intelifix Remote: [local]
7 26 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 16 11 4 12 4 14 4 15 11 16 3 - 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:A8:CA:D2)
Date: 2026-06-16 11:41:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:A8:CA:D2)
Date: 2026-06-16 11:41:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88:0F:A2:A8:CA:D2)
Date: 2026-06-16 11:41:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 16 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-16 07:12:19 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-16 08:11:02 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-16 09:14:16 Database: brasilia Application: psql User: intelifix Remote: [local]
9 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 16 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-16 07:12:19 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-16 08:11:02 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-16 09:14:16 Database: brasilia Application: psql User: intelifix Remote: [local]
10 11 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 16 09 3 10 4 14 4 - ERROR: trailing junk after numeric literal at or near "82935495100A714" at character 27
- ERROR: trailing junk after numeric literal at or near "82935495100A714" at character 27
- ERROR: trailing junk after numeric literal at or near "82935495100A714" at character 27
Statement: SELECT * FROM RS_ETIQUETA(82935495100A714)
Date: 2026-06-16 09:08:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(82935495100A714)
Date: 2026-06-16 09:08:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(82935495100A714)
Date: 2026-06-16 09:08:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
11 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 16 00 1 04 4 06 1 10 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-16 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-16 04:08:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-16 04:09:02 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
12 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 16 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-16 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-16 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-16 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
13 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 16 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-16 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
14 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 16 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 16 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-16 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-16 06:05:09 Database: brasilia Application: psql User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 16 03 1 - LOG: database system was shut down at 2026-06-16 03:05:01 -03
Date: 2026-06-16 03:05:03
17 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 16 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-16 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]
18 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 16 16 1 - LOG: process 2969711 still waiting for AccessExclusiveLock on relation 1209947 of database 358220 after 1000.127 ms
Detail: Process holding the lock: 2993817. Wait queue: 2969711.
Statement: DROP TABLE IF EXISTS temp0000282707;Date: 2026-06-16 16:29:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
19 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 16 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-16 18:00:02 Database: brasilia Application: psql User: intelifix Remote: [local]
20 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 16 11 1 - ERROR: column "cai_id" does not exist at character 39
Statement: SELECT * FROM temp0000226414 ORDER BY CAI_ID DESC
Date: 2026-06-16 11:04:38 Database: contagem Application: [unknown] User: intelifix Remote: [local]
21 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 16 16 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000282707"
Date: 2026-06-16 16:29:01