pgBadger-
Global information
- Generated on Fri Jun 12 23:50:07 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 29,928 log entries in 6s
- Log start from 2026-06-12 00:02:01 to 2026-06-12 23:49:53
-
Overview
Global Stats
- 285 Number of unique normalized queries
- 4,948 Number of queries
- 5h46m8s Total query duration
- 2026-06-12 00:02:08 First query
- 2026-06-12 23:43:28 Last query
- 6 queries/s at 2026-06-12 11:43:49 Query peak
- 5h46m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h46m8s Execute total duration
- 2,234 Number of events
- 23 Number of unique normalized events
- 1,733 Max number of times the same event was reported
- 0 Number of cancellation
- 381 Total number of automatic vacuums
- 765 Total number of automatic analyzes
- 22 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 227 Total number of sessions
- 6 sessions at 2026-06-12 13:05:07 Session peak
- 8d15h30m39s Total duration of sessions
- 54m50s Average duration of sessions
- 21 Average queries per session
- 1m31s Average queries duration per session
- 53m19s Average idle time per session
- 233 Total number of connections
- 4 connections/s at 2026-06-12 09:57:40 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-06-12 11:43:49 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-06-12 11:43:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-12 23:41:26 Date
Queries duration
Key values
- 5h46m8s 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 12 00 23 0ms 17s910ms 3s897ms 8s637ms 55s967ms 55s967ms 01 12 0ms 2s843ms 1s669ms 4s274ms 4s274ms 4s274ms 02 11 729ms 2s890ms 1s889ms 3s904ms 3s904ms 3s904ms 03 12 0ms 2s826ms 1s942ms 5s333ms 5s333ms 5s333ms 04 25 0ms 2s903ms 1s165ms 4s179ms 5s891ms 5s999ms 05 25 0ms 7m36s 24s541ms 4s982ms 2m13s 7m36s 06 18 0ms 8s541ms 2s558ms 8s560ms 18s896ms 18s896ms 07 351 0ms 8m17s 5s148ms 59s650ms 3m58s 8m42s 08 536 0ms 6m37s 4s179ms 1m15s 4m1s 7m11s 09 543 150ms 6m40s 2s912ms 46s329ms 4m9s 6m43s 10 597 0ms 6m11s 2s885ms 1m10s 1m56s 7m21s 11 541 150ms 7m23s 3s609ms 1m 3m34s 7m44s 12 144 0ms 6m41s 7s138ms 58s225ms 1m20s 6m43s 13 167 0ms 5m53s 3s298ms 13s958ms 18s786ms 5m53s 14 678 150ms 6m21s 2s697ms 52s629ms 3m57s 6m57s 15 700 150ms 7m52s 2s598ms 1m 3m55s 7m55s 16 123 0ms 6m39s 5s258ms 23s673ms 35s745ms 6m39s 17 94 0ms 5m34s 4s333ms 3s861ms 30s662ms 5m34s 18 11 0ms 5m33s 34s533ms 31s130ms 5m33s 5m33s 19 10 0ms 5m40s 38s875ms 31s1ms 5m40s 5m40s 20 72 0ms 6m8s 12s99ms 1m27s 6m49s 6m49s 21 17 0ms 5m38s 23s40ms 28s207ms 5m38s 5m38s 22 16 0ms 5m34s 24s643ms 30s731ms 5m34s 5m34s 23 222 0ms 1m42s 8s627ms 1m13s 1m42s 1m56s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 12 00 9 0 1s258ms 159ms 1s376ms 8s637ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 13 0 342ms 344ms 403ms 1s143ms 05 12 0 286ms 214ms 282ms 881ms 06 4 0 2s339ms 0ms 795ms 8s560ms 07 279 0 5s30ms 11s870ms 56s231ms 3m58s 08 441 0 3s757ms 21s915ms 57s422ms 4m5s 09 425 0 3s23ms 8s605ms 26s342ms 4m38s 10 471 0 2s700ms 8s523ms 58s420ms 4m8s 11 410 0 3s883ms 22s818ms 53s143ms 3m49s 12 109 0 8s231ms 5s187ms 48s934ms 2m27s 13 118 0 3s932ms 2s114ms 3s509ms 33s512ms 14 552 0 2s497ms 11s60ms 40s58ms 4m42s 15 558 0 2s919ms 24s761ms 45s863ms 4m11s 16 71 0 7s321ms 3s188ms 9s789ms 6m39s 17 81 0 4s789ms 3s243ms 3s861ms 5m34s 18 5 0 1m12s 216ms 31s130ms 5m33s 19 4 0 1m32s 0ms 31s1ms 5m40s 20 9 57 12s916ms 1m3s 1m27s 6m49s 21 5 0 1m13s 0ms 28s207ms 5m38s 22 4 0 1m31s 0ms 30s731ms 5m34s 23 5 217 8s627ms 1m4s 1m13s 1m56s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 12 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 12 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 8 8.00 0.00% 08 0 9 9.00 0.00% 09 0 9 9.00 0.00% 10 0 5 5.00 0.00% 11 0 6 6.00 0.00% 12 0 2 2.00 0.00% 13 0 9 9.00 0.00% 14 0 6 6.00 0.00% 15 0 7 7.00 0.00% 16 0 3 3.00 0.00% 17 0 2 2.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 12 00 10 0.00/s 01 5 0.00/s 02 4 0.00/s 03 8 0.00/s 04 8 0.00/s 05 9 0.00/s 06 10 0.00/s 07 12 0.00/s 08 19 0.01/s 09 19 0.01/s 10 12 0.00/s 11 13 0.00/s 12 11 0.00/s 13 14 0.00/s 14 17 0.00/s 15 13 0.00/s 16 9 0.00/s 17 9 0.00/s 18 4 0.00/s 19 4 0.00/s 20 10 0.00/s 21 4 0.00/s 22 4 0.00/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jun 12 00 2 1h 59m15s 01 9 1h1m 1h57s 02 4 1h 59m55s 03 8 27m6s 27m3s 04 4 1h45s 1h38s 05 7 1h25s 58m58s 06 8 57m39s 57m33s 07 9 1h40s 57m20s 08 13 54m22s 51m30s 09 20 50m40s 49m21s 10 15 57m59s 56m4s 11 13 59m6s 56m36s 12 15 54m7s 52m58s 13 10 55m18s 54m23s 14 14 59m36s 57m26s 15 16 57m21s 55m28s 16 15 54m31s 53m48s 17 7 55m43s 54m44s 18 9 1h1m54s 1h1m12s 19 4 53m44s 52m7s 20 7 36m14s 34m9s 21 6 1h30s 59m24s 22 5 1h36s 59m17s 23 7 39m17s 34m44s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-12 09:57:40 Date
Connections per database
Key values
- rio Main Database
- 233 connections Total
Connections per user
Key values
- intelifix Main User
- 233 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-12 13:05:07 Date
Histogram of session times
Key values
- 190 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 227 sessions Total
Sessions per user
Key values
- intelifix Main User
- 227 sessions Total
Sessions per host
Key values
- [local] Main Host
- 227 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,337 buffers Checkpoint Peak
- 2026-06-12 00:19:41 Date
- 270.075 seconds Highest write time
- 0.119 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-06-12 15:04:39 Date
Checkpoints distance
Key values
- 298.11 Mo Distance Peak
- 2026-06-12 15:04:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 12 00 25,617 736.18s 0.021s 736.242s 01 1,426 143.016s 0.026s 143.074s 02 1,326 133.035s 0.012s 133.072s 03 1,534 153.174s 0.036s 153.238s 04 3,959 397.941s 0.031s 398.009s 05 6,822 655.857s 0.028s 655.922s 06 6,290 522.637s 0.016s 522.686s 07 41,035 2,413.399s 0.132s 2,413.639s 08 73,039 3,208.343s 0.169s 3,208.649s 09 67,514 3,185.266s 0.183s 3,185.594s 10 63,978 3,201.32s 0.192s 3,201.664s 11 72,161 3,239.308s 0.195s 3,239.675s 12 39,053 1,818.152s 0.163s 1,818.389s 13 9,754 1,008.956s 0.095s 1,009.118s 14 52,292 3,187.159s 0.193s 3,187.497s 15 55,544 3,213.433s 0.185s 3,213.806s 16 14,774 1,602.458s 0.082s 1,602.622s 17 1,870 187.979s 0.039s 188.08s 18 262 26.339s 0.004s 26.353s 19 22 2.23s 0.003s 2.238s 20 927 189.353s 0.009s 189.375s 21 2,083 209.033s 0.032s 209.117s 22 2,267 227.659s 0.028s 227.726s 23 4,845 373.13s 0.008s 373.159s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 12 00 0 0 6 523 0.003s 0.009s 01 0 0 1 386 0.004s 0.006s 02 0 0 0 318 0.002s 0.005s 03 0 0 1 336 0.003s 0.007s 04 0 0 1 702 0.004s 0.009s 05 0 0 3 601 0.002s 0.008s 06 0 0 1 463 0.002s 0.005s 07 0 0 27 3,046 0.004s 0.012s 08 0 0 44 4,570 0.005s 0.012s 09 0 0 35 5,402 0.003s 0.012s 10 0 0 38 5,706 0.005s 0.012s 11 0 0 47 5,647 0.004s 0.012s 12 0 0 24 1,882 0.110s 0.009s 13 0 0 4 2,385 0.006s 0.011s 14 0 0 34 5,522 0.003s 0.012s 15 0 0 32 5,506 0.003s 0.012s 16 0 0 13 2,248 0.005s 0.011s 17 0 0 0 689 0.004s 0.01s 18 0 0 1 26 0.002s 0.002s 19 0 0 0 4 0.002s 0.001s 20 0 0 1 60 0.002s 0.004s 21 0 0 0 445 0.003s 0.01s 22 0 0 1 410 0.004s 0.01s 23 0 0 1 32 0.002s 0.004s Day Hour Count Avg time (sec) Jun 12 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 12 00 12,749.38 kB 47,266.62 kB 01 1,257.83 kB 26,146.50 kB 02 1,436.60 kB 15,164.60 kB 03 1,238.57 kB 3,611.86 kB 04 2,374.33 kB 3,096.11 kB 05 6,540.00 kB 15,240.38 kB 06 4,214.60 kB 10,673.00 kB 07 36,917.17 kB 65,090.25 kB 08 59,104.50 kB 87,371.17 kB 09 48,840.33 kB 104,413.42 kB 10 51,678.33 kB 99,287.33 kB 11 63,912.83 kB 101,865.33 kB 12 43,337.56 kB 85,840.89 kB 13 5,551.73 kB 40,794.00 kB 14 47,038.92 kB 88,149.67 kB 15 44,027.42 kB 107,215.33 kB 16 18,638.00 kB 48,720.73 kB 17 1,111.40 kB 18,857.40 kB 18 506.00 kB 10,258.50 kB 19 170.00 kB 8,772.00 kB 20 5,990.00 kB 14,321.33 kB 21 1,029.90 kB 7,983.90 kB 22 1,367.67 kB 3,754.78 kB 23 4,823.75 kB 10,308.75 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-12 10:51:55 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-12 11:15:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 12 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 3 311.99 MiB 104.00 MiB 08 5 519.98 MiB 104.00 MiB 09 1 104.00 MiB 104.00 MiB 10 5 519.99 MiB 104.00 MiB 11 3 312.00 MiB 104.00 MiB 12 3 312.00 MiB 104.00 MiB 13 0 0 0 14 2 208.00 MiB 104.00 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 22 2.23 GiB 103.99 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025568, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 15:23:16 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025540, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 10:22:00 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025558, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 14:20:02 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 10:51:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 12:23:43 - 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-12 10:40:29 - 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-12 10:43:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 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-12 11:15:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 11:18:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 12:17:10 - 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-12 11:01:07 - 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-12 12:04:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 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-12 14:24:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 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-12 14:48:52 - 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-12 08:39:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 07:35:55 - 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-12 09:32:41 - 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-12 07:57:46 - 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-12 10:15:14 - 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-12 08:04:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 08:06:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 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-12 07:44:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-12 08:14:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 11.69 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-12 12:03:55 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 11.69 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-12 12:03:55 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (124) Main table analyzed (database rio)
- 765 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 124 rio.pg_catalog.pg_class 69 rio.pg_catalog.pg_type 61 rio.public.usuarios 46 rio.public.temp0000282405 46 rio.pg_catalog.pg_index 43 rio.pg_catalog.pg_depend 34 contagem.pg_catalog.pg_attribute 31 rio.public.temp0000282425 26 rio.public.temp0000282395 19 rio.public.temp0000282399 19 contagem.pg_catalog.pg_class 18 contagem.pg_catalog.pg_type 14 rio.public.temp0000282267 13 contagem.public.usuarios 13 rio.public.temp0000282465 12 rio.public.temp0000282453 10 rio.public.temp0000282431 9 contagem.pg_catalog.pg_index 8 rio.public.temp0000282429 8 rio.public.temp0000282279 8 rio.public.temp0000282435 8 rio.public.temp0000282409 7 contagem.public.temp0000226384 7 rio.public.temp0000282319 7 rio.pg_catalog.pg_shdepend 6 rio.public.temp0000281897 6 contagem.pg_catalog.pg_depend 6 rio.public.temp0000281335 6 rio.public.temp0000282315 6 contagem.public.temp0000226376 6 rio.public.temp0000282049 5 contagem.pg_catalog.pg_shdepend 5 rio.public.temp0000282449 5 rio.public.temp0000282397 5 rio.public.temp0000282481 4 contagem.public.temp0000226380 3 rio.public.temp0000282427 3 rio.public.temp0000282393 3 rio.public.tmp_drill_0175 3 rio.public.temp0000282415 3 template1.pg_catalog.pg_shdepend 2 contagem.public.temp0000226372 2 rio.public.temp0000282457 2 rio.public.tmp_drill_0302 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000282421 2 rio.public.temp0000281789 2 rio.public.temp0000282413 2 rio.public.temp0000282419 2 contagem.public.temp0000226382 1 rio.public.temp0000282477 1 rio.public.temp0000282407 1 contagem.public.temp0000226378 1 rio.public.temp0000282469 1 rio.public.temp0000282411 1 rio.public.temp0000282403 1 rio.auditor.auditor_2026_06 1 rio.public.temp0000282417 1 rio.public.temp0000282455 1 rio.public.temp0000282445 1 postgres.pg_catalog.pg_shdepend 1 Total 765 Vacuums per table
Key values
- pg_catalog.pg_attribute (55) Main table vacuumed on database rio
- 381 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 49 0 0 0 0 0 27,847 6,348 9,748,746 396 10,622 rio.public.temp0000282405 46 0 0 0 0 0 0 39,754 336 2,618,166 0 0 rio.pg_catalog.pg_class 41 35 0 0 0 0 0 6,543 1,502 2,240,425 80 303 rio.pg_catalog.pg_type 36 32 0 0 0 0 0 2,748 720 911,693 85 262 rio.public.temp0000282425 25 0 0 0 0 0 0 29,862 4,795 7,763,099 0 0 rio.pg_catalog.pg_index 17 17 0 0 0 0 0 1,003 276 237,772 53 115 rio.pg_catalog.pg_depend 14 14 0 0 0 0 0 4,520 1,521 2,148,144 79 736 contagem.public.usuarios 13 0 0 0 0 0 0 53 39 24,691 0 0 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 5,409 1,893 3,103,286 19 424 rio.public.temp0000282453 9 0 0 0 0 0 0 11,147 37 663,457 0 0 rio.public.temp0000282279 8 0 0 0 0 0 0 533 43 38,369 0 0 rio.public.temp0000282319 7 0 0 0 0 0 0 479 126 183,038 0 0 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 8,292 1,777 8,098,571 862 4,204 rio.public.temp0000281335 6 0 0 0 0 0 0 316 34 23,776 0 0 rio.pg_toast.pg_toast_2619 6 6 0 0 0 0 0 2,240 529 2,785,130 123 392 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 398 165 232,999 5 12 rio.public.temp0000281897 5 0 0 0 0 0 0 295 25 21,605 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 559 218 299,088 6 21 rio.public.temp0000282465 4 0 0 0 0 0 0 453 23 30,637 0 0 rio.public.temp0000282481 4 0 0 0 0 0 0 4,720 15 280,827 0 0 rio.public.temp0000282049 4 0 0 0 0 0 0 240 16 16,767 0 0 rio.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 584 185 204,181 25 41 rio.public.tmp_drill_0302 4 1 0 0 0 0 0 25 18 17,039 1 19 rio.public.temp0000282427 3 0 0 0 0 0 0 4,713 12 279,876 0 0 contagem.public.temp0000226384 3 0 0 0 0 0 0 368 18 24,677 0 0 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 84 9 20,595 0 0 rio.public.temp0000282415 3 0 0 0 0 0 0 4,707 12 279,522 0 0 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 142 52 39,154 5 5 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 512 199 383,269 5 36 rio.public.temp0000282421 2 0 0 0 0 0 0 1,692 10 101,412 0 0 brasilia.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 286 101 117,552 22 44 rio.public.temp0000282315 2 0 0 0 0 0 0 90 12 6,884 0 0 rio.public.temp0000282413 2 0 0 0 0 0 0 1,689 10 101,232 0 0 rio.public.temp0000282419 2 0 0 0 0 0 0 1,575 7 94,066 0 0 contagem.public.temp0000226372 2 0 0 0 0 0 0 106 12 7,946 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 810 463 1,312,927 155 7,757 rio.public.temp0000282411 1 0 0 0 0 0 0 67 4 4,556 0 0 rio.public.temp0000282403 1 0 0 0 0 0 0 8 5 1,367 0 0 rio.public.temp0000281789 1 0 0 0 0 0 0 144 6 9,492 0 0 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 92,194 34,030 46,645,366 28,723 586,920 rio.public.temp0000282435 1 0 0 0 0 0 0 77 6 5,431 0 0 rio.public.temp0000282455 1 0 0 0 0 0 0 140 6 9,281 0 0 rio.public.temp0000282445 1 0 0 0 0 0 0 127 4 8,096 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,498 1,050 3,279,889 1,005 7,271 rio.public.temp0000282477 1 0 0 0 0 0 0 143 6 9,430 0 0 rio.public.temp0000282407 1 0 0 0 0 0 0 119 6 7,998 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 11,615 10,849 13,966,685 0 0 contagem.public.temp0000226378 1 0 0 0 0 0 0 51 6 3,854 0 0 contagem.public.fluxos 1 1 0 0 0 0 0 7,277 4,615 13,047,992 377 17,483 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 97 2 8,594 0 0 rio.public.temp0000282457 1 0 0 0 0 0 0 140 6 9,279 0 0 rio.public.usuarios 1 1 0 0 0 0 0 35 12 14,169 1 2 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 197 68 186,238 37 105 rio.public.temp0000282409 1 0 0 0 0 0 0 119 117 237,475 0 0 Total 381 198 0 0 0 0 0 279,842 72,356 121,915,810 32,064 636,774 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (11.69) 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.27 rio.public.temp0000282405 0 0 1.34 rio.pg_catalog.pg_class 0 0 0.64 rio.pg_catalog.pg_type 0 0 0.23 rio.public.temp0000282425 0 0 1.25 rio.pg_catalog.pg_index 0 0 0.09 rio.pg_catalog.pg_depend 0 0 0.75 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.79 rio.public.temp0000282453 0 0 0.39 rio.public.temp0000282279 0 0 0.1 rio.public.temp0000282319 0 0 0.08 rio.pg_catalog.pg_statistic 0 0 0.9 rio.public.temp0000281335 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.21 contagem.pg_catalog.pg_type 0 0 0.07 rio.public.temp0000281897 0 0 0.06 contagem.pg_catalog.pg_class 0 0 0.12 rio.public.temp0000282465 0 0 0.07 rio.public.temp0000282481 0 0 0.19 rio.public.temp0000282049 0 0 0.05 rio.pg_catalog.pg_shdepend 0 0 0.07 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000282427 0 0 0.15 contagem.public.temp0000226384 0 0 0.04 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000282415 0 0 0.14 contagem.pg_catalog.pg_index 0 0 0.04 contagem.pg_catalog.pg_depend 0 0 0.1 rio.public.temp0000282421 0 0 0.06 brasilia.pg_catalog.pg_shdepend 0 0 0.04 rio.public.temp0000282315 0 0 0.02 rio.public.temp0000282413 0 0 0.06 rio.public.temp0000282419 0 0 0.1 contagem.public.temp0000226372 0 0 0.03 rio.public.nf_entrada_arquivo_erros 0 0 0.22 rio.public.temp0000282411 0 0 0 rio.public.temp0000282403 0 0 0.01 rio.public.temp0000281789 0 0 0.01 rio.auditor.auditor_2026_06 0 0 11.69 rio.public.temp0000282435 0 0 0.01 rio.public.temp0000282455 0 0 0.02 rio.public.temp0000282445 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.12 rio.public.temp0000282477 0 0 0.02 rio.public.temp0000282407 0 0 0.02 contagem.auditor.auditor_2026_06 0 0 3.11 contagem.public.temp0000226378 0 0 0.01 contagem.public.fluxos 0 0 2.15 brasilia.pg_catalog.pg_statistic 0 0 0 rio.public.temp0000282457 0 0 0.01 rio.public.usuarios 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000282409 0 0 0.02 Total 0 0 28.91 Tuples removed per table
Key values
- pg_catalog.pg_attribute (217638) Main table with removed tuples on database rio
- 309489 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 55 49 217,638 1,359,129 69,640 374 33,504 contagem.pg_catalog.pg_attribute 10 10 28,646 244,005 0 115 5,228 rio.pg_catalog.pg_type 36 32 11,691 86,010 4,508 17 2,499 rio.pg_catalog.pg_statistic 6 6 11,310 49,768 262 0 7,716 rio.pg_catalog.pg_depend 14 14 9,242 267,981 1,913 0 2,588 rio.pg_catalog.pg_index 17 17 4,955 33,099 521 7 953 contagem.public.fluxos 1 1 4,635 386,140 0 0 5,032 rio.pg_catalog.pg_shdepend 4 4 4,412 34,185 325 0 404 rio.pg_catalog.pg_class 41 35 4,131 155,749 13,786 0 5,057 contagem.pg_catalog.pg_statistic 1 1 4,041 7,274 0 0 1,011 brasilia.pg_catalog.pg_shdepend 2 2 2,288 16,940 0 0 202 contagem.pg_catalog.pg_depend 2 2 1,451 37,733 0 0 352 rio.pg_toast.pg_toast_2619 6 6 1,298 3,117 15 0 1,437 contagem.public.usuarios 13 0 769 299 0 0 26 rio.public.nf_entrada_arquivo_erros 1 0 702 8,293,378 0 0 147,769 contagem.pg_catalog.pg_class 4 4 659 13,979 0 2 504 contagem.pg_catalog.pg_index 3 3 498 5,697 0 0 159 contagem.pg_catalog.pg_type 5 5 373 11,265 0 15 300 rio.public.tmp_drill_0302 4 1 209 1,615 703 0 26 brasilia.pg_catalog.pg_statistic 1 1 184 449 0 0 36 rio.auditor.auditor_2026_06 1 0 173 10,337,508 0 0 482,329 contagem.pg_toast.pg_toast_2619 1 1 163 109 0 0 65 rio.public.usuarios 1 1 21 635 128 0 16 rio.public.temp0000282411 1 0 0 1,188 0 0 64 rio.public.temp0000282427 3 0 0 66,316 0 0 4,800 rio.public.temp0000282403 1 0 0 1,974 0 18 110 rio.public.temp0000282421 2 0 0 24,135 0 15 1,713 rio.public.temp0000281789 1 0 0 6,081 0 56 136 rio.public.temp0000282279 8 0 0 32,830 0 253 771 contagem.public.temp0000226384 3 0 0 3,465 0 104 344 rio.public.temp0000281335 6 0 0 19,453 0 271 433 rio.public.temp0000282435 1 0 0 3,105 0 59 69 rio.public.temp0000282425 25 0 0 552,438 0 0 40,000 rio.public.temp0000282405 46 0 0 598,080 0 449 42,495 rio.public.temp0000282315 2 0 0 3,590 0 54 74 rio.public.temp0000282413 2 0 0 24,073 0 17 1,711 rio.public.temp0000282455 1 0 0 2,496 0 60 132 rio.public.tmp_drill_0175 3 3 0 827 0 0 23 rio.public.temp0000282445 1 0 0 2,275 0 0 128 rio.public.temp0000282415 3 0 0 66,247 0 0 4,800 rio.public.temp0000282419 2 0 0 44,220 0 0 3,200 rio.public.temp0000282319 7 0 0 28,696 0 193 639 rio.public.temp0000282465 4 0 0 25,129 0 204 564 rio.public.temp0000282453 9 0 0 179,405 0 58 12,934 rio.public.temp0000282481 4 0 0 88,467 0 0 6,400 rio.public.temp0000282477 1 0 0 6,033 0 57 135 rio.public.temp0000282407 1 0 0 1,974 0 17 111 contagem.auditor.auditor_2026_06 1 0 0 1,653,678 0 0 71,207 contagem.public.temp0000226378 1 0 0 1,161 0 21 43 rio.public.temp0000282049 4 0 0 31,017 0 33 1,951 rio.public.temp0000282457 1 0 0 2,496 0 60 132 contagem.public.temp0000226372 2 0 0 2,366 0 38 90 rio.public.temp0000282409 1 0 0 1,974 0 17 111 rio.public.temp0000281897 5 0 0 24,548 0 239 593 Total 381 198 309,489 24,845,801 91,801 2,823 893,126 Pages removed per table
Key values
- public.temp0000282405 (449) Main table with removed pages on database rio
- 2823 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282405 46 0 0 449 rio.pg_catalog.pg_attribute 55 49 217638 374 rio.public.temp0000281335 6 0 0 271 rio.public.temp0000282279 8 0 0 253 rio.public.temp0000281897 5 0 0 239 rio.public.temp0000282465 4 0 0 204 rio.public.temp0000282319 7 0 0 193 contagem.pg_catalog.pg_attribute 10 10 28646 115 contagem.public.temp0000226384 3 0 0 104 rio.public.temp0000282455 1 0 0 60 rio.public.temp0000282457 1 0 0 60 rio.public.temp0000282435 1 0 0 59 rio.public.temp0000282453 9 0 0 58 rio.public.temp0000282477 1 0 0 57 rio.public.temp0000281789 1 0 0 56 rio.public.temp0000282315 2 0 0 54 contagem.public.temp0000226372 2 0 0 38 rio.public.temp0000282049 4 0 0 33 contagem.public.temp0000226378 1 0 0 21 rio.public.temp0000282403 1 0 0 18 rio.public.temp0000282413 2 0 0 17 rio.public.temp0000282407 1 0 0 17 rio.pg_catalog.pg_type 36 32 11691 17 rio.public.temp0000282409 1 0 0 17 rio.public.temp0000282421 2 0 0 15 contagem.pg_catalog.pg_type 5 5 373 15 rio.pg_catalog.pg_index 17 17 4955 7 contagem.pg_catalog.pg_class 4 4 659 2 contagem.pg_catalog.pg_depend 2 2 1451 0 rio.public.nf_entrada_arquivo_erros 1 0 702 0 rio.public.temp0000282411 1 0 0 0 rio.public.temp0000282427 3 0 0 0 rio.pg_catalog.pg_statistic 6 6 11310 0 brasilia.pg_catalog.pg_shdepend 2 2 2288 0 rio.pg_catalog.pg_class 41 35 4131 0 rio.auditor.auditor_2026_06 1 0 173 0 rio.public.temp0000282425 25 0 0 0 contagem.public.usuarios 13 0 769 0 rio.pg_catalog.pg_depend 14 14 9242 0 rio.public.tmp_drill_0175 3 3 0 0 rio.public.temp0000282445 1 0 0 0 rio.public.temp0000282415 3 0 0 0 rio.pg_toast.pg_toast_2619 6 6 1298 0 rio.public.temp0000282419 2 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4041 0 rio.public.temp0000282481 4 0 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 contagem.public.fluxos 1 1 4635 0 brasilia.pg_catalog.pg_statistic 1 1 184 0 rio.public.usuarios 1 1 21 0 contagem.pg_catalog.pg_index 3 3 498 0 rio.pg_catalog.pg_shdepend 4 4 4412 0 contagem.pg_toast.pg_toast_2619 1 1 163 0 rio.public.tmp_drill_0302 4 1 209 0 Total 381 198 309,489 2,823 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 12 00 2 1 01 0 0 02 0 0 03 0 0 04 0 5 05 5 2 06 1 2 07 42 70 08 58 77 09 33 89 10 61 120 11 46 105 12 23 28 13 15 35 14 41 102 15 31 83 16 21 41 17 1 5 18 0 0 19 0 0 20 0 0 21 1 0 22 0 0 23 0 0 - 11.69 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 4m6s 1m24s 2m42s 2m3s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 08:07:52 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 09:46:35 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 00:05:22 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000282481;-
DROP TABLE IF EXISTS temp0000282481;
Date: 2026-06-12 16:19:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282481;
Date: 2026-06-12 16:19:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m42s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-12 08:07:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m24s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-12 09:46:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000282481;[ Date: 2026-06-12 16:19:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,585 Total read queries
- 1,122 Total write queries
Queries by database
Key values
- rio Main database
- 4,246 Requests
- 5h32m49s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,870 Requests
User Request type Count Duration etiquetas Total 2 307ms select 2 307ms intelifix Total 4,870 5h45m19s copy to 274 39m14s ddl 848 40m29s others 241 26m27s select 3,507 3h59m7s lenon Total 76 48s788ms select 76 48s788ms Duration by user
Key values
- 5h45m19s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 2 307ms select 2 307ms intelifix Total 4,870 5h45m19s copy to 274 39m14s ddl 848 40m29s others 241 26m27s select 3,507 3h59m7s lenon Total 76 48s788ms select 76 48s788ms Queries by host
Key values
- [local] Main host
- 4,948 Requests
- 5h46m8s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,272 Requests
- 2h43m9s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-12 09:01:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,981 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 07:13:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 15:12:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m36s analyze verbose;[ Date: 2026-06-12 05:07:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 11:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 12:11:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 09:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 16:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 08:11:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 14:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 10:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 20:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 13:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 19:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 21:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 17:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 22:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-12 18:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025568, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-12 15:23:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025540, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-12 10:22:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025558, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-12 14:20:02 - 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 1h43m23s 32 953ms 8m17s 3m13s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 12 07 2 8m19s 4m9s 08 2 6m40s 3m20s 09 2 6m45s 3m22s 10 2 6m14s 3m7s 11 2 7m25s 3m42s 12 2 6m44s 3m22s 13 2 5m54s 2m57s 14 2 6m22s 3m11s 15 2 7m55s 3m57s 16 2 6m42s 3m21s 17 2 5m36s 2m48s 18 2 5m34s 2m47s 19 2 5m41s 2m50s 20 2 6m10s 3m5s 21 2 5m39s 2m49s 22 2 5m35s 2m47s [ User: intelifix - Total duration: 1h43m23s - Times executed: 32 ]
[ Application: psql - Total duration: 1h43m23s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-12 07:13:18 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-12 15:12:54 Duration: 7m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-12 11:12:24 Duration: 7m23s Database: rio User: intelifix Remote: [local] Application: psql
2 1h25m53s 198 151ms 4m10s 26s25ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 12 07 11 10m32s 57s473ms 08 22 16m9s 44s49ms 09 18 9m19s 31s105ms 10 27 8m40s 19s284ms 11 24 13m52s 34s690ms 12 10 5m37s 33s702ms 13 5 7s153ms 1s430ms 14 41 10m58s 16s62ms 15 26 9m40s 22s315ms 16 13 55s264ms 4s251ms 17 1 366ms 366ms [ User: intelifix - Total duration: 1h25m53s - Times executed: 198 ]
[ Application: [unknown] - Total duration: 1h25m53s - Times executed: 198 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025568, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 15:23:16 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025540, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 10:22:00 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025558, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 14:20:02 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
3 11m56s 1,176 150ms 4s226ms 609ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 12 07 59 50s613ms 857ms 08 114 1m20s 708ms 09 167 1m44s 627ms 10 167 1m52s 674ms 11 146 1m29s 609ms 12 65 30s460ms 468ms 13 65 37s455ms 576ms 14 192 1m38s 512ms 15 173 1m33s 540ms 16 26 17s491ms 672ms 17 2 1s768ms 884ms [ User: intelifix - Total duration: 11m56s - Times executed: 1176 ]
[ Application: [unknown] - Total duration: 11m56s - Times executed: 1176 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41525, 413, '246049752234', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 10:44:38 Duration: 4s226ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41289, 413, '226060172532', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 10:05:17 Duration: 3s867ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252864, 450, 'F200011102B2880,9877E77B5EAC$F200011235B206C,84011229ED1D$F200012312B090F,1834AF619111$F200011022B21A6,9877E70A8617$F200011324B31CE,84011282778E$F200011050E6B6A,9877E70C8804$F200010300E5F9C,743AEFC4F6BA$F200012057B41E1,840112C2098E$F200011054B43CF,9877E74CE785', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 08:38:07 Duration: 3s793ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 11m31s 34 15s573ms 35s458ms 20s333ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 12 07 2 51s32ms 25s516ms 08 1 20s912ms 20s912ms 09 2 34s101ms 17s50ms 10 4 1m15s 18s804ms 11 4 1m21s 20s286ms 12 2 40s680ms 20s340ms 13 1 17s773ms 17s773ms 14 3 57s436ms 19s145ms 15 15 5m13s 20s868ms [ User: intelifix - Total duration: 11m31s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 11m31s - Times executed: 34 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-12', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-12 07:36:11 Duration: 35s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-12', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-12 15:38:24 Duration: 24s237ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-12', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-12 15:44:44 Duration: 23s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 11m14s 67 8s296ms 12s467ms 10s60ms create table temp0000282405 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 12 07 8 1m11s 8s993ms 08 17 3m2s 10s737ms 09 5 48s835ms 9s767ms 10 8 1m18s 9s821ms 11 6 58s797ms 9s799ms 14 18 2m59s 9s998ms 15 5 53s415ms 10s683ms [ User: intelifix - Total duration: 11m14s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 11m14s - Times executed: 67 ]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:55:25 Duration: 12s467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:56:58 Duration: 12s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:30:35 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10m53s 138 2s136ms 2m45s 4s738ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 12 00 6 23s637ms 3s939ms 01 6 14s34ms 2s339ms 02 6 14s733ms 2s455ms 03 6 14s489ms 2s414ms 04 6 14s835ms 2s472ms 05 6 15s212ms 2s535ms 06 6 14s159ms 2s359ms 07 6 17s423ms 2s903ms 08 6 3m 30s28ms 09 6 1m47s 17s858ms 10 6 18s272ms 3s45ms 11 6 19s21ms 3s170ms 12 6 16s820ms 2s803ms 13 6 18s592ms 3s98ms 14 6 21s198ms 3s533ms 15 6 20s284ms 3s380ms 16 6 17s321ms 2s886ms 17 6 17s596ms 2s932ms 18 6 15s502ms 2s583ms 19 6 17s613ms 2s935ms 20 6 18s673ms 3s112ms 21 6 17s637ms 2s939ms 22 6 19s577ms 3s262ms [ User: intelifix - Total duration: 10m53s - Times executed: 138 ]
[ Application: psql - Total duration: 10m53s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 08:07:52 Duration: 2m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 09:46:35 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 00:05:22 Duration: 8s301ms Database: rio User: intelifix Remote: [local] Application: psql
7 9m58s 32 392ms 52s44ms 18s702ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 12 07 2 49s170ms 24s585ms 08 2 42s345ms 21s172ms 09 2 51s202ms 25s601ms 10 2 46s489ms 23s244ms 11 2 41s229ms 20s614ms 12 2 34s504ms 17s252ms 13 2 32s35ms 16s17ms 14 2 30s619ms 15s309ms 15 2 53s129ms 26s564ms 16 2 32s829ms 16s414ms 17 2 28s815ms 14s407ms 18 2 30s82ms 15s41ms 19 2 29s736ms 14s868ms 20 2 39s288ms 19s644ms 21 2 27s205ms 13s602ms 22 2 29s778ms 14s889ms [ User: intelifix - Total duration: 9m58s - Times executed: 32 ]
[ Application: psql - Total duration: 9m58s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-12 15:13:46 Duration: 52s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-12 09:12:30 Duration: 48s641ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-12 07:14:06 Duration: 47s982ms Database: rio User: intelifix Remote: [local] Application: psql
8 9m50s 3 348ms 7m36s 3m16s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 12 05 3 9m50s 3m16s [ User: intelifix - Total duration: 9m50s - Times executed: 3 ]
[ Application: psql - Total duration: 9m50s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-12 05:07:37 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-12 05:09:52 Duration: 2m13s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-12 05:07:38 Duration: 348ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 9m31s 53 8s370ms 42s167ms 10s773ms create table temp0000282425 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 12 07 2 21s20ms 10s510ms 08 10 1m37s 9s743ms 09 5 48s645ms 9s729ms 10 16 3m15s 12s193ms 11 11 1m52s 10s255ms 12 9 1m35s 10s665ms [ User: intelifix - Total duration: 9m31s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 9m31s - Times executed: 53 ]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 10:16:04 Duration: 42s167ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 11:19:03 Duration: 12s777ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 11:15:59 Duration: 12s395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m54s 949 150ms 3s873ms 436ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 12 07 103 1m6s 646ms 08 152 1m6s 439ms 09 120 1m 505ms 10 148 1m 411ms 11 124 53s282ms 429ms 13 4 1s324ms 331ms 14 150 53s914ms 359ms 15 146 50s749ms 347ms 17 2 364ms 182ms [ User: intelifix - Total duration: 6m54s - Times executed: 949 ]
[ Application: [unknown] - Total duration: 6m54s - Times executed: 949 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242675", "modelo" : "295", "itens" : "229971175873,230005697289,229990437180,230020627186,230032364359,230032584661,230031793439,230005401526,230005523333,229971595061,229972634242,229976633746,230031679612,230019623744,230005405465,229972365372,229975988902,229976596469,229967380206,229977082937,229989029804", "usuario" : "405", "caixa" : "2899458", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-12 09:49:40 Duration: 3s873ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252914", "modelo" : "464", "itens" : "241745312033,241746132932,241764038911,241761456582,241768795974,241768795469,241764044242,241739395170,241767534953,241764844354,241768722129,241767659814,241745582643,241767650723,241770061418,241767520609,241742653030,241742722633,241760030720,241777665358,241687504651,241768693843,241760026476,241742289201,241770196784,241764807683,241767400115,241777729203,241761468806,241770129000,241745599614,241767829000,241742754252,241760235363,241740752037,241762652648,241764040808,241765318698,241740788505,241770088490,241767694565,241767580817,241744936081,241764812634,241767420117,241759988189,241745536274,241764896076,241764775155,241765363451,241764910119,241747528185,241770234061,241768820725,241777798301,241738562934,241770126777,241759931619,241745996678,241777722435,241768474955,241761586370,241779117486,241767522932,241764827281,241742715056,241768704147,241768698388,241738831322,241762458082,241742719096,241738742525,241762490612,241744246081,241767715274,241742735159,241777698593,241745406890,241742713945,241777655357,241779105768,241767496363,241764686078,241738390415,241768815875,241768636486,241770174964,241779091828,241770949696,241768703541", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-12 08:07:18 Duration: 2s746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252978", "modelo" : "463", "itens" : "241722347288,241755726382,241720472437,241753763037,241722345672,241719226063,241749941127,241755507898,241753736771,241725443741,241722957886,241752445770,241782010710,241704965962,241724984650,241757231827,241782101426,241749950926,241704914263,241737120224,241782308695,241704934747,241757294863,241725532336,241752425061,241754297084,241736965662,241749933954,241754333856,241755531515,241758119601,241749952441,241782299705,241755702239,241749836873,241783516277,241784698604,241752001833,241705682834,241781997879,241753756773,241749939207,241752120812,241780482435,241779377590,241748792137,241780621820,241737021224,241737928191,241752199203,241784697593,241754260112,241754132647,241725540014,241704877390,241752403948,241724793139,241736053744,241784718606,241749929812,241725565066,241753761825,241736958792,241754260314,241719313547,241782098900,241784742525,241704877087,241721794350,241757054054,241753725457,241757340323,241754126787,241704994450,241736965864,241724780916,241724327481,241724338492,241780520318,241751745264,241758908601,241720836467,241755163342,241748899093,241756856178,241737889602", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-12 07:58:13 Duration: 2s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m38s 92 517ms 12s292ms 3s26ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 12 00 5 19s300ms 3s860ms 01 6 5s997ms 999ms 02 5 6s52ms 1s210ms 03 5 8s615ms 1s723ms 04 6 9s839ms 1s639ms 05 3 4s207ms 1s402ms 06 4 5s412ms 1s353ms 07 6 36s474ms 6s79ms 08 5 29s461ms 5s892ms 09 6 28s816ms 4s802ms 10 6 27s702ms 4s617ms 11 6 33s391ms 5s565ms 12 1 524ms 524ms 13 2 1s652ms 826ms 14 6 18s867ms 3s144ms 15 6 23s201ms 3s866ms 16 2 2s783ms 1s391ms 21 6 6s971ms 1s161ms 22 6 9s150ms 1s525ms [ User: intelifix - Total duration: 4m38s - Times executed: 92 ]
[ Application: psql - Total duration: 4m38s - Times executed: 92 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 00:05:14 Duration: 12s292ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 08:35:09 Duration: 7s872ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 07:45:08 Duration: 7s434ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m21s 43 4s749ms 12s570ms 6s74ms create table temp0000282405 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 12 07 11 59s659ms 5s423ms 08 8 45s768ms 5s721ms 09 2 18s371ms 9s185ms 10 12 1m10s 5s884ms 14 6 38s544ms 6s424ms 15 4 28s241ms 7s60ms [ User: intelifix - Total duration: 4m21s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 4m21s - Times executed: 43 ]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 09:52:56 Duration: 12s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 15:09:52 Duration: 8s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 10:06:33 Duration: 7s517ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m56s 2 1m26s 1m29s 1m28s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 12 20 1 1m26s 1m26s 23 1 1m29s 1m29s [ User: intelifix - Total duration: 2m56s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-12 23:39:23 Duration: 1m29s 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-12 20:08:33 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
14 2m46s 52 203ms 25s131ms 3s194ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 12 07 7 17s47ms 2s435ms 08 9 25s115ms 2s790ms 09 3 22s535ms 7s511ms 10 8 37s72ms 4s634ms 11 7 17s817ms 2s545ms 12 3 34s541ms 11s513ms 14 10 7s514ms 751ms 15 2 726ms 363ms 16 3 3s756ms 1s252ms [ User: intelifix - Total duration: 2m46s - Times executed: 52 ]
[ Application: psql - Total duration: 2m46s - Times executed: 52 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025543);
Date: 2026-06-12 10:52:54 Duration: 25s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025556);
Date: 2026-06-12 12:25:27 Duration: 24s596ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025536);
Date: 2026-06-12 09:34:27 Duration: 21s822ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m34s 15 8s625ms 11s945ms 10s277ms create table temp0000282453 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 12 13 1 9s249ms 9s249ms 14 14 2m24s 10s350ms [ User: intelifix - Total duration: 2m34s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 15 ]
-
CREATE TABLE temp0000282453 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 14:55:23 Duration: 11s945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282453 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 14:25:41 Duration: 11s776ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282453 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 14:50:51 Duration: 11s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m4s 2 22s464ms 1m42s 1m2s 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 #16
Day Hour Count Duration Avg duration Jun 12 23 2 2m4s 1m2s [ User: intelifix - Total duration: 2m4s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m4s - 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-12 23:14:39 Duration: 1m42s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:40:55 Duration: 22s464ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 2m 2 20s792ms 1m39s 1m copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 12 23 2 2m 1m [ User: intelifix - Total duration: 2m - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:11:43 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:40:14 Duration: 20s792ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1m57s 2 54s709ms 1m2s 58s545ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 12 20 1 1m2s 1m2s 23 1 54s709ms 54s709ms [ User: intelifix - Total duration: 1m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-12 20:05:31 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-12 23:18:45 Duration: 54s709ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 1m33s 2 19s490ms 1m13s 46s568ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 12 23 2 1m33s 46s568ms [ User: intelifix - Total duration: 1m33s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:12:57 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:40:33 Duration: 19s490ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1m26s 109 150ms 14s988ms 792ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 12 07 2 501ms 250ms 08 5 1s936ms 387ms 09 5 1s219ms 243ms 10 24 11s277ms 469ms 11 6 3s34ms 505ms 14 42 56s600ms 1s347ms 15 22 11s87ms 503ms 16 3 745ms 248ms [ User: intelifix - Total duration: 1m26s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 1m26s - Times executed: 109 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-12 14:20:16 Duration: 14s988ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-12 14:21:26 Duration: 10s73ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-12 14:19:32 Duration: 5s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,176 11m56s 150ms 4s226ms 609ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 12 07 59 50s613ms 857ms 08 114 1m20s 708ms 09 167 1m44s 627ms 10 167 1m52s 674ms 11 146 1m29s 609ms 12 65 30s460ms 468ms 13 65 37s455ms 576ms 14 192 1m38s 512ms 15 173 1m33s 540ms 16 26 17s491ms 672ms 17 2 1s768ms 884ms [ User: intelifix - Total duration: 11m56s - Times executed: 1176 ]
[ Application: [unknown] - Total duration: 11m56s - Times executed: 1176 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41525, 413, '246049752234', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 10:44:38 Duration: 4s226ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41289, 413, '226060172532', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 10:05:17 Duration: 3s867ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252864, 450, 'F200011102B2880,9877E77B5EAC$F200011235B206C,84011229ED1D$F200012312B090F,1834AF619111$F200011022B21A6,9877E70A8617$F200011324B31CE,84011282778E$F200011050E6B6A,9877E70C8804$F200010300E5F9C,743AEFC4F6BA$F200012057B41E1,840112C2098E$F200011054B43CF,9877E74CE785', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 08:38:07 Duration: 3s793ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 949 6m54s 150ms 3s873ms 436ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 12 07 103 1m6s 646ms 08 152 1m6s 439ms 09 120 1m 505ms 10 148 1m 411ms 11 124 53s282ms 429ms 13 4 1s324ms 331ms 14 150 53s914ms 359ms 15 146 50s749ms 347ms 17 2 364ms 182ms [ User: intelifix - Total duration: 6m54s - Times executed: 949 ]
[ Application: [unknown] - Total duration: 6m54s - Times executed: 949 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242675", "modelo" : "295", "itens" : "229971175873,230005697289,229990437180,230020627186,230032364359,230032584661,230031793439,230005401526,230005523333,229971595061,229972634242,229976633746,230031679612,230019623744,230005405465,229972365372,229975988902,229976596469,229967380206,229977082937,229989029804", "usuario" : "405", "caixa" : "2899458", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-12 09:49:40 Duration: 3s873ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252914", "modelo" : "464", "itens" : "241745312033,241746132932,241764038911,241761456582,241768795974,241768795469,241764044242,241739395170,241767534953,241764844354,241768722129,241767659814,241745582643,241767650723,241770061418,241767520609,241742653030,241742722633,241760030720,241777665358,241687504651,241768693843,241760026476,241742289201,241770196784,241764807683,241767400115,241777729203,241761468806,241770129000,241745599614,241767829000,241742754252,241760235363,241740752037,241762652648,241764040808,241765318698,241740788505,241770088490,241767694565,241767580817,241744936081,241764812634,241767420117,241759988189,241745536274,241764896076,241764775155,241765363451,241764910119,241747528185,241770234061,241768820725,241777798301,241738562934,241770126777,241759931619,241745996678,241777722435,241768474955,241761586370,241779117486,241767522932,241764827281,241742715056,241768704147,241768698388,241738831322,241762458082,241742719096,241738742525,241762490612,241744246081,241767715274,241742735159,241777698593,241745406890,241742713945,241777655357,241779105768,241767496363,241764686078,241738390415,241768815875,241768636486,241770174964,241779091828,241770949696,241768703541", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-12 08:07:18 Duration: 2s746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252978", "modelo" : "463", "itens" : "241722347288,241755726382,241720472437,241753763037,241722345672,241719226063,241749941127,241755507898,241753736771,241725443741,241722957886,241752445770,241782010710,241704965962,241724984650,241757231827,241782101426,241749950926,241704914263,241737120224,241782308695,241704934747,241757294863,241725532336,241752425061,241754297084,241736965662,241749933954,241754333856,241755531515,241758119601,241749952441,241782299705,241755702239,241749836873,241783516277,241784698604,241752001833,241705682834,241781997879,241753756773,241749939207,241752120812,241780482435,241779377590,241748792137,241780621820,241737021224,241737928191,241752199203,241784697593,241754260112,241754132647,241725540014,241704877390,241752403948,241724793139,241736053744,241784718606,241749929812,241725565066,241753761825,241736958792,241754260314,241719313547,241782098900,241784742525,241704877087,241721794350,241757054054,241753725457,241757340323,241754126787,241704994450,241736965864,241724780916,241724327481,241724338492,241780520318,241751745264,241758908601,241720836467,241755163342,241748899093,241756856178,241737889602", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-12 07:58:13 Duration: 2s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 198 1h25m53s 151ms 4m10s 26s25ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 12 07 11 10m32s 57s473ms 08 22 16m9s 44s49ms 09 18 9m19s 31s105ms 10 27 8m40s 19s284ms 11 24 13m52s 34s690ms 12 10 5m37s 33s702ms 13 5 7s153ms 1s430ms 14 41 10m58s 16s62ms 15 26 9m40s 22s315ms 16 13 55s264ms 4s251ms 17 1 366ms 366ms [ User: intelifix - Total duration: 1h25m53s - Times executed: 198 ]
[ Application: [unknown] - Total duration: 1h25m53s - Times executed: 198 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025568, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 15:23:16 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025540, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 10:22:00 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025558, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 14:20:02 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
4 138 10m53s 2s136ms 2m45s 4s738ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 12 00 6 23s637ms 3s939ms 01 6 14s34ms 2s339ms 02 6 14s733ms 2s455ms 03 6 14s489ms 2s414ms 04 6 14s835ms 2s472ms 05 6 15s212ms 2s535ms 06 6 14s159ms 2s359ms 07 6 17s423ms 2s903ms 08 6 3m 30s28ms 09 6 1m47s 17s858ms 10 6 18s272ms 3s45ms 11 6 19s21ms 3s170ms 12 6 16s820ms 2s803ms 13 6 18s592ms 3s98ms 14 6 21s198ms 3s533ms 15 6 20s284ms 3s380ms 16 6 17s321ms 2s886ms 17 6 17s596ms 2s932ms 18 6 15s502ms 2s583ms 19 6 17s613ms 2s935ms 20 6 18s673ms 3s112ms 21 6 17s637ms 2s939ms 22 6 19s577ms 3s262ms [ User: intelifix - Total duration: 10m53s - Times executed: 138 ]
[ Application: psql - Total duration: 10m53s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 08:07:52 Duration: 2m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 09:46:35 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 00:05:22 Duration: 8s301ms Database: rio User: intelifix Remote: [local] Application: psql
5 119 22s999ms 150ms 403ms 193ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 12 00 3 494ms 164ms 04 8 2s536ms 317ms 05 7 1s571ms 224ms 07 11 2s8ms 182ms 08 17 3s215ms 189ms 09 10 1s811ms 181ms 10 16 2s798ms 174ms 11 13 2s241ms 172ms 14 15 2s770ms 184ms 15 19 3s550ms 186ms [ User: intelifix - Total duration: 22s999ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 22s999ms - Times executed: 119 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241700850915,241694839799,241703770628,241622668390,241700783658,241680527494,241649693049,241692999092,241668248293,241620774951,241604200001,241726984868,241602636671,241620787679,241649659914,241676646565,241689087476,241694912131,241627876890,241610077790,230049391229,241708758903', NULL, NULL, 0320, 00);
Date: 2026-06-12 04:31:20 Duration: 403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241639093047,241617140815,241714628184,241674586869,230049329909,241661099302,241604944349,241712193346,241661472324,241610084660,241727109201,241700846671,241674236880,241638879917,241730537481,241652004565,241664268993,241674482842,241728343250,241726717692,241617494867,241649455371,241691093150', NULL, NULL, 0320, 00);
Date: 2026-06-12 04:39:17 Duration: 347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241607740515,241651315676,241617469309,241649132837,241617328486,241708752842,241676767082,241696814561,241649131221,241631334040,241608095476,241667227980,241646237391,241595001011,241617550911,241639048800,241653797691,241667152643,241688896571,241688831919,241608097092,241617480220', NULL, NULL, 0320, 00);
Date: 2026-06-12 04:37:06 Duration: 344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 109 1m26s 150ms 14s988ms 792ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 12 07 2 501ms 250ms 08 5 1s936ms 387ms 09 5 1s219ms 243ms 10 24 11s277ms 469ms 11 6 3s34ms 505ms 14 42 56s600ms 1s347ms 15 22 11s87ms 503ms 16 3 745ms 248ms [ User: intelifix - Total duration: 1m26s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 1m26s - Times executed: 109 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-12 14:20:16 Duration: 14s988ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-12 14:21:26 Duration: 10s73ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-12 14:19:32 Duration: 5s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 104 16s752ms 150ms 194ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 12 07 7 1s131ms 161ms 08 12 1s912ms 159ms 09 12 1s994ms 166ms 10 7 1s108ms 158ms 11 16 2s533ms 158ms 13 1 157ms 157ms 14 14 2s250ms 160ms 15 32 5s179ms 161ms 16 3 484ms 161ms [ User: intelifix - Total duration: 16s752ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 16s752ms - Times executed: 104 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0153;
Date: 2026-06-12 15:38:20 Duration: 194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-06-12 09:10:18 Duration: 190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-06-12 11:36:12 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 103 33s977ms 150ms 1s279ms 329ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 12 08 22 9s397ms 427ms 09 15 7s184ms 478ms 17 66 17s395ms 263ms [ User: intelifix - Total duration: 33s977ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 33s977ms - Times executed: 103 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"241708576786,241668024759,241694546786,241713745461,241604206465,241704649310,241652857487,241654629905,241695592635,241614550001,241708806281,241663841826,241646316972,241714927282,241708896570,241698694161,241622526177,241622537794,241607210407,241659745466,241715044062,241689101519,241622570526,241664802537,241656758597,241673377795,241732071414,241730919719,241646313740,241727442343,241659777287,241711211623,241631503956,241617378491,241618234950,241663841018,241664779201,241660144551,241727044952,241665511630,241629196177,241680480218,241594983759,241730932728,241599285065,241617330205,241678323643,241671995674,241730923838,241715485373,241729500827","usuario":"409","observacao":""}');
Date: 2026-06-12 09:01:53 Duration: 1s279ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"4896D95011E2,5872C98EFC5B,D89A0DB00167,D89A0D851CBB,D83139932E16,F4E84F80E994,F4E84F839BBE,843C992CAFA1,3891485118F1,843C992D38CF,6C11BA67B83D,D89A0DA42DF5,D831399353AE,D89A0DB09BB1,6C11BA6720C3,D831398CAD0A,C4EBFF8BA940,D83139A0E428,843C992C8BA7,D831399E7212,F4E84F89173A,5872C98B12A9,D8313996E8B2,D831399865DC,6C11BA6C4EC9,3891484DFD79,D89A0DAC204F,D89A0DAC710D,4896D950F882,843C99208601,6C11BA66F09F,3891484C7D5B,6C11BA691C59,843C991F7D41,3CF9F0A8C26E,F4E84F839954,843C992C85D1,4896D94FE308,689E29BCE587","usuario":"409","observacao":""}');
Date: 2026-06-12 08:57:13 Duration: 1s74ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"216468912125,216807950814,216763108490,216721635072,216709629411,216742637682,216479880424,216463250114,216469223648,216773596383,216426674759,216780386372,216808356565,216678173838,184291595674,216493416985,184295839095,216485132945","usuario":"409","observacao":""}');
Date: 2026-06-12 08:52:48 Duration: 936ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 92 4m38s 517ms 12s292ms 3s26ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 12 00 5 19s300ms 3s860ms 01 6 5s997ms 999ms 02 5 6s52ms 1s210ms 03 5 8s615ms 1s723ms 04 6 9s839ms 1s639ms 05 3 4s207ms 1s402ms 06 4 5s412ms 1s353ms 07 6 36s474ms 6s79ms 08 5 29s461ms 5s892ms 09 6 28s816ms 4s802ms 10 6 27s702ms 4s617ms 11 6 33s391ms 5s565ms 12 1 524ms 524ms 13 2 1s652ms 826ms 14 6 18s867ms 3s144ms 15 6 23s201ms 3s866ms 16 2 2s783ms 1s391ms 21 6 6s971ms 1s161ms 22 6 9s150ms 1s525ms [ User: intelifix - Total duration: 4m38s - Times executed: 92 ]
[ Application: psql - Total duration: 4m38s - Times executed: 92 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 00:05:14 Duration: 12s292ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 08:35:09 Duration: 7s872ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 07:45:08 Duration: 7s434ms Database: rio User: intelifix Remote: [local] Application: psql
10 90 24s507ms 150ms 5s441ms 272ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 12 07 1 546ms 546ms 09 1 167ms 167ms 10 3 484ms 161ms 11 9 1s531ms 170ms 12 2 329ms 164ms 13 6 1s47ms 174ms 14 15 2s460ms 164ms 15 51 17s537ms 343ms 16 2 401ms 200ms [ User: intelifix - Total duration: 24s507ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 24s507ms - Times executed: 90 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-12", "data-ate" : "2026-06-12", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-06-12 15:33:26 Duration: 5s441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-11", "data-ate" : "2026-06-12", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-06-12 15:39:03 Duration: 2s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-11", "data-ate" : "2026-06-11", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-06-12 15:39:11 Duration: 1s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 82 21s899ms 150ms 5s35ms 267ms create table temp0000282413 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 12 07 4 6s187ms 1s546ms 08 2 867ms 433ms 09 7 2s285ms 326ms 10 11 1s764ms 160ms 11 7 1s217ms 173ms 12 4 771ms 192ms 13 7 1s270ms 181ms 14 14 2s773ms 198ms 15 21 3s865ms 184ms 16 5 895ms 179ms [ User: intelifix - Total duration: 21s899ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 21s899ms - Times executed: 82 ]
-
CREATE TABLE temp0000282413 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 07:26:58 Duration: 5s35ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282413 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"64386", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 09:02:43 Duration: 631ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282413 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"64386", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 09:02:52 Duration: 511ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 72 31s589ms 261ms 679ms 438ms 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 #12
Day Hour Count Duration Avg duration Jun 12 00 2 951ms 475ms 04 2 741ms 370ms 05 2 726ms 363ms 06 1 313ms 313ms 07 7 3s16ms 430ms 08 8 3s400ms 425ms 09 9 3s782ms 420ms 10 5 2s309ms 461ms 11 6 2s702ms 450ms 12 2 963ms 481ms 13 9 4s50ms 450ms 14 6 2s965ms 494ms 15 7 3s359ms 479ms 16 3 1s177ms 392ms 17 2 754ms 377ms 20 1 375ms 375ms [ User: lenon - Total duration: 31s589ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 31s589ms - Times executed: 72 ]
-
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-12 13:59:50 Duration: 679ms 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-12 15:02:10 Duration: 651ms 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-12 14:55:14 Duration: 647ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
13 69 37s487ms 324ms 794ms 543ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 12 00 2 1s244ms 622ms 04 2 1s9ms 504ms 05 2 974ms 487ms 06 1 482ms 482ms 07 7 3s618ms 516ms 08 8 4s366ms 545ms 09 9 4s652ms 516ms 10 4 2s176ms 544ms 11 6 3s333ms 555ms 12 2 1s175ms 587ms 13 8 4s306ms 538ms 14 6 3s520ms 586ms 15 7 4s157ms 593ms 16 3 1s449ms 483ms 17 2 1s19ms 509ms [ User: intelifix - Total duration: 37s487ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 37s487ms - Times executed: 69 ]
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-06-12 15:02:10 Duration: 794ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (434, 18, 1);
Date: 2026-06-12 13:59:50 Duration: 746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 21, 1);
Date: 2026-06-12 09:57:42 Duration: 721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 67 11m14s 8s296ms 12s467ms 10s60ms create table temp0000282405 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 12 07 8 1m11s 8s993ms 08 17 3m2s 10s737ms 09 5 48s835ms 9s767ms 10 8 1m18s 9s821ms 11 6 58s797ms 9s799ms 14 18 2m59s 9s998ms 15 5 53s415ms 10s683ms [ User: intelifix - Total duration: 11m14s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 11m14s - Times executed: 67 ]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:55:25 Duration: 12s467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:56:58 Duration: 12s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:30:35 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 63 23s25ms 263ms 564ms 365ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 12 07 7 2s498ms 356ms 08 13 4s691ms 360ms 09 6 2s308ms 384ms 10 9 3s706ms 411ms 11 8 2s637ms 329ms 12 5 1s850ms 370ms 13 1 375ms 375ms 14 7 2s601ms 371ms 15 2 693ms 346ms 16 5 1s660ms 332ms [ User: intelifix - Total duration: 23s25ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 23s25ms - Times executed: 63 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-12 12:03:32 Duration: 564ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-12 10:54:51 Duration: 563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-12 10:57:01 Duration: 527ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 58 18s479ms 150ms 953ms 318ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 12 07 10 5s327ms 532ms 08 15 5s7ms 333ms 09 5 1s369ms 273ms 10 5 1s652ms 330ms 11 7 1s572ms 224ms 13 1 326ms 326ms 14 8 1s564ms 195ms 15 7 1s659ms 237ms [ User: intelifix - Total duration: 18s479ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 18s479ms - Times executed: 58 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3069521 ORDER BY A.CAI_ORDEM;
Date: 2026-06-12 08:05:05 Duration: 953ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3069508 ORDER BY A.CAI_ORDEM;
Date: 2026-06-12 07:55:14 Duration: 935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2578949 ORDER BY A.CAI_ORDEM;
Date: 2026-06-12 07:49:11 Duration: 868ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 58 13s203ms 150ms 3s611ms 227ms create table temp0000226360 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 12 08 3 507ms 169ms 09 7 1s180ms 168ms 10 2 304ms 152ms 11 2 319ms 159ms 13 5 4s330ms 866ms 14 6 976ms 162ms 15 15 2s488ms 165ms 16 17 2s928ms 172ms 17 1 168ms 168ms [ User: intelifix - Total duration: 13s203ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 13s203ms - Times executed: 58 ]
-
CREATE TABLE temp0000226360 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 13:17:03 Duration: 3s611ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226360 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"129", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 16:14:36 Duration: 212ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226360 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"129", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 16:11:31 Duration: 203ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 53 9m31s 8s370ms 42s167ms 10s773ms create table temp0000282425 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 12 07 2 21s20ms 10s510ms 08 10 1m37s 9s743ms 09 5 48s645ms 9s729ms 10 16 3m15s 12s193ms 11 11 1m52s 10s255ms 12 9 1m35s 10s665ms [ User: intelifix - Total duration: 9m31s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 9m31s - Times executed: 53 ]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 10:16:04 Duration: 42s167ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 11:19:03 Duration: 12s777ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 11:15:59 Duration: 12s395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 52 2m46s 203ms 25s131ms 3s194ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 12 07 7 17s47ms 2s435ms 08 9 25s115ms 2s790ms 09 3 22s535ms 7s511ms 10 8 37s72ms 4s634ms 11 7 17s817ms 2s545ms 12 3 34s541ms 11s513ms 14 10 7s514ms 751ms 15 2 726ms 363ms 16 3 3s756ms 1s252ms [ User: intelifix - Total duration: 2m46s - Times executed: 52 ]
[ Application: psql - Total duration: 2m46s - Times executed: 52 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025543);
Date: 2026-06-12 10:52:54 Duration: 25s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025556);
Date: 2026-06-12 12:25:27 Duration: 24s596ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025536);
Date: 2026-06-12 09:34:27 Duration: 21s822ms Database: rio User: intelifix Remote: [local] Application: psql
20 51 33s920ms 151ms 17s831ms 665ms create table temp0000282403 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 12 07 2 18s225ms 9s112ms 09 6 1s902ms 317ms 10 6 1s57ms 176ms 11 8 1s457ms 182ms 12 6 2s519ms 419ms 13 7 3s274ms 467ms 14 12 4s812ms 401ms 15 3 487ms 162ms 16 1 183ms 183ms [ User: intelifix - Total duration: 33s920ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 33s920ms - Times executed: 51 ]
-
CREATE TABLE temp0000282403 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 07:06:06 Duration: 17s831ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282403 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 13:53:28 Duration: 620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282403 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 12:25:50 Duration: 603ms 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 348ms 7m36s 3m16s 3 9m50s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 12 05 3 9m50s 3m16s [ User: intelifix - Total duration: 9m50s - Times executed: 3 ]
[ Application: psql - Total duration: 9m50s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-12 05:07:37 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-12 05:09:52 Duration: 2m13s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-12 05:07:38 Duration: 348ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 953ms 8m17s 3m13s 32 1h43m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 12 07 2 8m19s 4m9s 08 2 6m40s 3m20s 09 2 6m45s 3m22s 10 2 6m14s 3m7s 11 2 7m25s 3m42s 12 2 6m44s 3m22s 13 2 5m54s 2m57s 14 2 6m22s 3m11s 15 2 7m55s 3m57s 16 2 6m42s 3m21s 17 2 5m36s 2m48s 18 2 5m34s 2m47s 19 2 5m41s 2m50s 20 2 6m10s 3m5s 21 2 5m39s 2m49s 22 2 5m35s 2m47s [ User: intelifix - Total duration: 1h43m23s - Times executed: 32 ]
[ Application: psql - Total duration: 1h43m23s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-12 07:13:18 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-12 15:12:54 Duration: 7m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-12 11:12:24 Duration: 7m23s Database: rio User: intelifix Remote: [local] Application: psql
3 1m26s 1m29s 1m28s 2 2m56s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 12 20 1 1m26s 1m26s 23 1 1m29s 1m29s [ User: intelifix - Total duration: 2m56s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-12 23:39:23 Duration: 1m29s 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-12 20:08:33 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 22s464ms 1m42s 1m2s 2 2m4s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 12 23 2 2m4s 1m2s [ User: intelifix - Total duration: 2m4s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m4s - 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-12 23:14:39 Duration: 1m42s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:40:55 Duration: 22s464ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 20s792ms 1m39s 1m 2 2m copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 12 23 2 2m 1m [ User: intelifix - Total duration: 2m - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:11:43 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:40:14 Duration: 20s792ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 54s709ms 1m2s 58s545ms 2 1m57s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 12 20 1 1m2s 1m2s 23 1 54s709ms 54s709ms [ User: intelifix - Total duration: 1m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-12 20:05:31 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-12 23:18:45 Duration: 54s709ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 19s490ms 1m13s 46s568ms 2 1m33s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 12 23 2 1m33s 46s568ms [ User: intelifix - Total duration: 1m33s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:12:57 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-12 23:40:33 Duration: 19s490ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 151ms 4m10s 26s25ms 198 1h25m53s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 12 07 11 10m32s 57s473ms 08 22 16m9s 44s49ms 09 18 9m19s 31s105ms 10 27 8m40s 19s284ms 11 24 13m52s 34s690ms 12 10 5m37s 33s702ms 13 5 7s153ms 1s430ms 14 41 10m58s 16s62ms 15 26 9m40s 22s315ms 16 13 55s264ms 4s251ms 17 1 366ms 366ms [ User: intelifix - Total duration: 1h25m53s - Times executed: 198 ]
[ Application: [unknown] - Total duration: 1h25m53s - Times executed: 198 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025568, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 15:23:16 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025540, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 10:22:00 Duration: 4m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025558, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-12 14:20:02 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
9 15s573ms 35s458ms 20s333ms 34 11m31s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 12 07 2 51s32ms 25s516ms 08 1 20s912ms 20s912ms 09 2 34s101ms 17s50ms 10 4 1m15s 18s804ms 11 4 1m21s 20s286ms 12 2 40s680ms 20s340ms 13 1 17s773ms 17s773ms 14 3 57s436ms 19s145ms 15 15 5m13s 20s868ms [ User: intelifix - Total duration: 11m31s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 11m31s - Times executed: 34 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-12', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-12 07:36:11 Duration: 35s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-12', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-12 15:38:24 Duration: 24s237ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-12', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-12 15:44:44 Duration: 23s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 392ms 52s44ms 18s702ms 32 9m58s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 12 07 2 49s170ms 24s585ms 08 2 42s345ms 21s172ms 09 2 51s202ms 25s601ms 10 2 46s489ms 23s244ms 11 2 41s229ms 20s614ms 12 2 34s504ms 17s252ms 13 2 32s35ms 16s17ms 14 2 30s619ms 15s309ms 15 2 53s129ms 26s564ms 16 2 32s829ms 16s414ms 17 2 28s815ms 14s407ms 18 2 30s82ms 15s41ms 19 2 29s736ms 14s868ms 20 2 39s288ms 19s644ms 21 2 27s205ms 13s602ms 22 2 29s778ms 14s889ms [ User: intelifix - Total duration: 9m58s - Times executed: 32 ]
[ Application: psql - Total duration: 9m58s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-12 15:13:46 Duration: 52s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-12 09:12:30 Duration: 48s641ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-12 07:14:06 Duration: 47s982ms Database: rio User: intelifix Remote: [local] Application: psql
11 8s370ms 42s167ms 10s773ms 53 9m31s create table temp0000282425 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 12 07 2 21s20ms 10s510ms 08 10 1m37s 9s743ms 09 5 48s645ms 9s729ms 10 16 3m15s 12s193ms 11 11 1m52s 10s255ms 12 9 1m35s 10s665ms [ User: intelifix - Total duration: 9m31s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 9m31s - Times executed: 53 ]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 10:16:04 Duration: 42s167ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 11:19:03 Duration: 12s777ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 11:15:59 Duration: 12s395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s625ms 11s945ms 10s277ms 15 2m34s create table temp0000282453 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 12 13 1 9s249ms 9s249ms 14 14 2m24s 10s350ms [ User: intelifix - Total duration: 2m34s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 15 ]
-
CREATE TABLE temp0000282453 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 14:55:23 Duration: 11s945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282453 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 14:25:41 Duration: 11s776ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282453 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 14:50:51 Duration: 11s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s296ms 12s467ms 10s60ms 67 11m14s create table temp0000282405 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 12 07 8 1m11s 8s993ms 08 17 3m2s 10s737ms 09 5 48s835ms 9s767ms 10 8 1m18s 9s821ms 11 6 58s797ms 9s799ms 14 18 2m59s 9s998ms 15 5 53s415ms 10s683ms [ User: intelifix - Total duration: 11m14s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 11m14s - Times executed: 67 ]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:55:25 Duration: 12s467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:56:58 Duration: 12s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-12 08:30:35 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4s749ms 12s570ms 6s74ms 43 4m21s create table temp0000282405 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 12 07 11 59s659ms 5s423ms 08 8 45s768ms 5s721ms 09 2 18s371ms 9s185ms 10 12 1m10s 5s884ms 14 6 38s544ms 6s424ms 15 4 28s241ms 7s60ms [ User: intelifix - Total duration: 4m21s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 4m21s - Times executed: 43 ]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 09:52:56 Duration: 12s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 15:09:52 Duration: 8s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282405 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 10:06:33 Duration: 7s517ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2s136ms 2m45s 4s738ms 138 10m53s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 12 00 6 23s637ms 3s939ms 01 6 14s34ms 2s339ms 02 6 14s733ms 2s455ms 03 6 14s489ms 2s414ms 04 6 14s835ms 2s472ms 05 6 15s212ms 2s535ms 06 6 14s159ms 2s359ms 07 6 17s423ms 2s903ms 08 6 3m 30s28ms 09 6 1m47s 17s858ms 10 6 18s272ms 3s45ms 11 6 19s21ms 3s170ms 12 6 16s820ms 2s803ms 13 6 18s592ms 3s98ms 14 6 21s198ms 3s533ms 15 6 20s284ms 3s380ms 16 6 17s321ms 2s886ms 17 6 17s596ms 2s932ms 18 6 15s502ms 2s583ms 19 6 17s613ms 2s935ms 20 6 18s673ms 3s112ms 21 6 17s637ms 2s939ms 22 6 19s577ms 3s262ms [ User: intelifix - Total duration: 10m53s - Times executed: 138 ]
[ Application: psql - Total duration: 10m53s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 08:07:52 Duration: 2m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 09:46:35 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-12 00:05:22 Duration: 8s301ms Database: rio User: intelifix Remote: [local] Application: psql
16 203ms 25s131ms 3s194ms 52 2m46s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 12 07 7 17s47ms 2s435ms 08 9 25s115ms 2s790ms 09 3 22s535ms 7s511ms 10 8 37s72ms 4s634ms 11 7 17s817ms 2s545ms 12 3 34s541ms 11s513ms 14 10 7s514ms 751ms 15 2 726ms 363ms 16 3 3s756ms 1s252ms [ User: intelifix - Total duration: 2m46s - Times executed: 52 ]
[ Application: psql - Total duration: 2m46s - Times executed: 52 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025543);
Date: 2026-06-12 10:52:54 Duration: 25s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025556);
Date: 2026-06-12 12:25:27 Duration: 24s596ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025536);
Date: 2026-06-12 09:34:27 Duration: 21s822ms Database: rio User: intelifix Remote: [local] Application: psql
17 517ms 12s292ms 3s26ms 92 4m38s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 12 00 5 19s300ms 3s860ms 01 6 5s997ms 999ms 02 5 6s52ms 1s210ms 03 5 8s615ms 1s723ms 04 6 9s839ms 1s639ms 05 3 4s207ms 1s402ms 06 4 5s412ms 1s353ms 07 6 36s474ms 6s79ms 08 5 29s461ms 5s892ms 09 6 28s816ms 4s802ms 10 6 27s702ms 4s617ms 11 6 33s391ms 5s565ms 12 1 524ms 524ms 13 2 1s652ms 826ms 14 6 18s867ms 3s144ms 15 6 23s201ms 3s866ms 16 2 2s783ms 1s391ms 21 6 6s971ms 1s161ms 22 6 9s150ms 1s525ms [ User: intelifix - Total duration: 4m38s - Times executed: 92 ]
[ Application: psql - Total duration: 4m38s - Times executed: 92 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 00:05:14 Duration: 12s292ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 08:35:09 Duration: 7s872ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-12 07:45:08 Duration: 7s434ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 14s988ms 792ms 109 1m26s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 12 07 2 501ms 250ms 08 5 1s936ms 387ms 09 5 1s219ms 243ms 10 24 11s277ms 469ms 11 6 3s34ms 505ms 14 42 56s600ms 1s347ms 15 22 11s87ms 503ms 16 3 745ms 248ms [ User: intelifix - Total duration: 1m26s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 1m26s - Times executed: 109 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-12 14:20:16 Duration: 14s988ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-12 14:21:26 Duration: 10s73ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-12 14:19:32 Duration: 5s345ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 151ms 17s831ms 665ms 51 33s920ms create table temp0000282403 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 12 07 2 18s225ms 9s112ms 09 6 1s902ms 317ms 10 6 1s57ms 176ms 11 8 1s457ms 182ms 12 6 2s519ms 419ms 13 7 3s274ms 467ms 14 12 4s812ms 401ms 15 3 487ms 162ms 16 1 183ms 183ms [ User: intelifix - Total duration: 33s920ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 33s920ms - Times executed: 51 ]
-
CREATE TABLE temp0000282403 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 07:06:06 Duration: 17s831ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282403 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 13:53:28 Duration: 620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282403 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"07-06-2026", "ate" :"12-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-12 12:25:50 Duration: 603ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 4s226ms 609ms 1,176 11m56s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 12 07 59 50s613ms 857ms 08 114 1m20s 708ms 09 167 1m44s 627ms 10 167 1m52s 674ms 11 146 1m29s 609ms 12 65 30s460ms 468ms 13 65 37s455ms 576ms 14 192 1m38s 512ms 15 173 1m33s 540ms 16 26 17s491ms 672ms 17 2 1s768ms 884ms [ User: intelifix - Total duration: 11m56s - Times executed: 1176 ]
[ Application: [unknown] - Total duration: 11m56s - Times executed: 1176 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41525, 413, '246049752234', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 10:44:38 Duration: 4s226ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41289, 413, '226060172532', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 10:05:17 Duration: 3s867ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252864, 450, 'F200011102B2880,9877E77B5EAC$F200011235B206C,84011229ED1D$F200012312B090F,1834AF619111$F200011022B21A6,9877E70A8617$F200011324B31CE,84011282778E$F200011050E6B6A,9877E70C8804$F200010300E5F9C,743AEFC4F6BA$F200012057B41E1,840112C2098E$F200011054B43CF,9877E74CE785', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-12 08:38:07 Duration: 3s793ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 12 16 1 0ms 0ms [ User: intelifix - Total duration: 2s440ms - Times executed: 1 ]
[ Application: psql - Total duration: 2s440ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 12,559 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 2208 ERROR entries
- 0 WARNING entries
- 14 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,733 Max number of times the same event was reported
- 2,234 Total events found
Rank Times reported Error 1 1,733 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 12 07 50 08 260 09 213 10 177 11 303 12 61 13 44 14 346 15 256 16 21 17 2 - ERROR: prepared statement "_PLAN0000000026C72280" does not exist
- ERROR: prepared statement "_PLAN000000002FCBE700" does not exist
- ERROR: prepared statement "_PLAN0000000026C6E2A0" does not exist
Statement: DEALLOCATE "_PLAN0000000026C72280"
Date: 2026-06-12 07:11:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002FCBE700"
Date: 2026-06-12 07:14:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000026C6E2A0"
Date: 2026-06-12 07:16:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 12 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-12 00:05:22 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-12 00:15:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-12 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
3 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 12 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-12 00:05:22 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-12 00:15:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-12 00:25:04 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 12 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-12 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-12 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-12 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 12 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-12 08:00:23 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-12 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-12 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
6 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 12 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-12 08:00:23 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-12 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-12 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 12 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-12 07:14:06 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-12 08:12:20 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-12 09:12:30 Database: brasilia Application: psql User: intelifix Remote: [local]
8 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 12 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-12 07:14:06 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-12 08:12:20 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-12 09:12:30 Database: brasilia Application: psql User: intelifix Remote: [local]
9 12 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 12 10 12 - ERROR: trailing junk after numeric literal at or near "087E647E8979" at character 27
- ERROR: trailing junk after numeric literal at or near "087E647E8979" at character 27
- ERROR: trailing junk after numeric literal at or near "6C55E8E6B6E8" at character 27
Statement: SELECT * FROM RS_ETIQUETA(087E647E8979)
Date: 2026-06-12 10:08:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(087E647E8979)
Date: 2026-06-12 10:08:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(6C55E8E6B6E8)
Date: 2026-06-12 10:42:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 12 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-12 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-12 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-12 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
11 6 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 12 09 6 - ERROR: process 3926701 detected deadlock while waiting for ShareLock on transaction 972481 after 1000.174 ms
- ERROR: process 3926701 detected deadlock while waiting for ShareLock on transaction 972481 after 1000.158 ms
- ERROR: process 3926701 detected deadlock while waiting for ShareLock on transaction 972481 after 1000.139 ms
Detail: Process holding the lock: 3971465. Wait queue: .
Context: while updating tuple (18738,36) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025538, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-12 09:45:51 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3971465. Wait queue: .
Context: while updating tuple (70250,94) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025538, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-12 09:45:53 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3971465. Wait queue: .
Context: while updating tuple (18738,36) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025538, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-12 09:45:54 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 12 00 1 01 1 04 1 05 1 06 1 07 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-12 00:02:09 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-12 01:05:04 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-12 04:35:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
13 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 12 08 3 09 3 - LOG: process 3858730 still waiting for ShareLock on transaction 963780 after 1000.135 ms
- LOG: process 3858730 still waiting for ShareLock on transaction 963780 after 7536.246 ms
- LOG: process 3858730 still waiting for ShareLock on transaction 963780 after 82432.729 ms
Detail: Process holding the lock: 3876318. Wait queue: 3858730.
Context: while updating tuple (70217,62) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-12 08:05:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3876318. Wait queue: 3858730.
Context: while updating tuple (70217,62) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-12 08:05:16 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3876318. Wait queue: 3858730.
Context: while updating tuple (70217,62) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-12 08:06:31 Database: rio Application: psql User: intelifix Remote: [local]
14 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 12 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-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_smart_modelos() line 20 at FOR over SELECT rows PL/pgSQL expression "ARRAY( SELECT MOD_ID FROM RS_SMART_MODELOS() )" PL/pgSQL function rs_equip_id(character varying,integer) line 22 during statement block local variable initialization PL/pgSQL function rs_giga_triagem(character varying,integer) line 122 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-12 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-06-12 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
15 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 12 09 3 - ERROR: column "f0Ç81Ç75Ç1cÇ74Ç78" does not exist at character 27
- ERROR: column "f0Ç81Ç75Ç1cÇ74Ç78" does not exist at character 27
- ERROR: column "f0Ç81Ç75Ç1cÇ74Ç78" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(F0Ç81Ç75Ç1CÇ74Ç78)
Date: 2026-06-12 09:36:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(F0Ç81Ç75Ç1CÇ74Ç78)
Date: 2026-06-12 09:36:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(F0Ç81Ç75Ç1CÇ74Ç78)
Date: 2026-06-12 09:36:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
16 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 12 10 3 - ERROR: syntax error at or near "919401039257" at character 79
- ERROR: syntax error at or near ""},{"" at character 93
- ERROR: syntax error at or near ""},{"" at character 84
Statement: SELECT RS_SERIAL_TEMPORARIO( '919401039257'' ) OR RS_SERIAL_TEMPORARIO_VIVO( '919401039257'' )
Date: 2026-06-12 10:47:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"253079","seriais":[{"serial":"919401039257'"},{"serial":""}]}')
Date: 2026-06-12 10:47:54 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"129","seriais":[{"serial":"919401039257'"},{"serial":""}]}');
Date: 2026-06-12 10:47:54 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 12 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-12 00:05:19 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-12 06:05:09 Database: brasilia Application: psql User: intelifix Remote: [local]
18 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 12 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-12 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-12 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
19 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 12 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-12 21:25:02 Database: brasilia Application: psql User: intelifix Remote: [local]
20 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 12 16 1 - LOG: process 35353 still waiting for AccessExclusiveLock on relation 1107914 of database 358220 after 1000.195 ms
Detail: Process holding the lock: 65227. Wait queue: 35353.
Statement: DROP TABLE IF EXISTS temp0000282481;Date: 2026-06-12 16:19:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
21 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 12 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-12 18:00:01 Database: brasilia Application: psql User: intelifix Remote: [local]
22 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #22
Day Hour Count Jun 12 16 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000282481"
Date: 2026-06-12 16:19:48
23 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #23
Day Hour Count Jun 12 03 1 - LOG: database system was shut down at 2026-06-12 03:05:01 -03
Date: 2026-06-12 03:05:02