pgBadger-
Global information
- Generated on Wed Jun 10 23:50:07 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 34,555 log entries in 6s
- Log start from 2026-06-10 00:02:09 to 2026-06-10 23:42:45
-
Overview
Global Stats
- 285 Number of unique normalized queries
- 5,849 Number of queries
- 6h2s Total query duration
- 2026-06-10 00:02:09 First query
- 2026-06-10 23:40:54 Last query
- 4 queries/s at 2026-06-10 08:58:27 Query peak
- 6h2s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h2s Execute total duration
- 2,296 Number of events
- 19 Number of unique normalized events
- 1,810 Max number of times the same event was reported
- 0 Number of cancellation
- 475 Total number of automatic vacuums
- 1,014 Total number of automatic analyzes
- 21 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 246 Total number of sessions
- 7 sessions at 2026-06-10 08:08:41 Session peak
- 9d7h6m31s Total duration of sessions
- 54m25s Average duration of sessions
- 23 Average queries per session
- 1m27s Average queries duration per session
- 52m57s Average idle time per session
- 253 Total number of connections
- 4 connections/s at 2026-06-10 15:38:09 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-10 08:58:27 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-10 08:58:27 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-10 23:40:16 Date
Queries duration
Key values
- 6h2s 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 10 00 18 0ms 17s463ms 4s785ms 7s682ms 54s346ms 54s346ms 01 12 0ms 3s986ms 2s397ms 5s118ms 6s271ms 6s271ms 02 11 0ms 3s859ms 2s538ms 6s698ms 6s698ms 6s698ms 03 12 0ms 3s381ms 2s89ms 5s463ms 5s463ms 5s463ms 04 49 0ms 2s998ms 692ms 3s647ms 5s171ms 7s583ms 05 19 0ms 7m55s 32s964ms 2m9s 7m56s 7m56s 06 16 0ms 8s139ms 2s998ms 8s197ms 18s679ms 18s679ms 07 172 0ms 6m50s 8s907ms 51s124ms 3m57s 6m51s 08 505 0ms 6m 2s441ms 46s299ms 1m3s 6m34s 09 672 150ms 6m53s 3s61ms 51s846ms 3m33s 11m19s 10 568 150ms 7m7s 1s760ms 21s846ms 43s944ms 7m43s 11 659 150ms 6m58s 2s581ms 48s155ms 3m52s 8m2s 12 133 0ms 7m3s 7s773ms 10s890ms 2m31s 7m56s 13 385 0ms 6m25s 1s929ms 20s183ms 23s897ms 6m58s 14 719 150ms 6m58s 3s7ms 1m13s 3m47s 7m36s 15 707 150ms 8m55s 3s35ms 1m7s 3m55s 9m1s 16 593 150ms 6m18s 3s474ms 1m13s 3m45s 7m2s 17 250 0ms 6m32s 3s100ms 28s808ms 56s392ms 6m34s 18 12 0ms 5m29s 31s246ms 2s925ms 5m57s 5m57s 19 10 0ms 5m26s 37s265ms 5m56s 5m56s 5m56s 20 65 0ms 6m24s 13s889ms 1m38s 6m24s 6m24s 21 23 0ms 5m29s 16s957ms 31s597ms 5m29s 5m29s 22 16 0ms 5m38s 24s759ms 33s591ms 5m38s 5m38s 23 223 0ms 1m39s 8s273ms 1m17s 1m55s 2m20s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 10 00 4 0 2s236ms 0ms 1s262ms 7s682ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 37 0 234ms 301ms 468ms 1s909ms 05 5 0 335ms 0ms 475ms 1s7ms 06 4 0 2s265ms 0ms 862ms 8s197ms 07 119 0 10s209ms 2s580ms 14s804ms 3m57s 08 394 0 2s263ms 9s464ms 39s880ms 55s484ms 09 514 0 3s332ms 11s515ms 27s534ms 3m36s 10 431 0 1s932ms 7s589ms 21s400ms 52s96ms 11 520 0 2s683ms 10s404ms 19s964ms 4m9s 12 88 0 10s569ms 1s969ms 3s788ms 4m12s 13 283 0 2s284ms 5s432ms 11s798ms 28s254ms 14 539 0 3s87ms 22s501ms 1m1s 4m9s 15 543 0 3s115ms 12s968ms 56s967ms 3m54s 16 456 0 3s801ms 23s791ms 56s844ms 3m55s 17 188 0 3s494ms 3s177ms 9s809ms 56s392ms 18 6 0 59s789ms 0ms 1s12ms 5m57s 19 4 0 1m29s 0ms 5m56s 5m56s 20 5 54 14s994ms 58s733ms 1m36s 6m24s 21 11 0 33s64ms 883ms 31s597ms 5m29s 22 4 0 1m33s 0ms 33s591ms 5m38s 23 3 220 8s273ms 1m7s 1m17s 2m20s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 10 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 10 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 6 6.00 0.00% 08 0 9 9.00 0.00% 09 0 8 8.00 0.00% 10 0 7 7.00 0.00% 11 0 6 6.00 0.00% 12 0 3 3.00 0.00% 13 0 14 14.00 0.00% 14 0 9 9.00 0.00% 15 0 7 7.00 0.00% 16 0 6 6.00 0.00% 17 0 3 3.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 10 00 11 0.00/s 01 5 0.00/s 02 4 0.00/s 03 9 0.00/s 04 6 0.00/s 05 8 0.00/s 06 10 0.00/s 07 17 0.00/s 08 19 0.01/s 09 17 0.00/s 10 15 0.00/s 11 16 0.00/s 12 7 0.00/s 13 19 0.01/s 14 19 0.01/s 15 16 0.00/s 16 13 0.00/s 17 10 0.00/s 18 4 0.00/s 19 4 0.00/s 20 9 0.00/s 21 8 0.00/s 22 4 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jun 10 00 4 1h12s 59m50s 01 10 1h52s 1h49s 02 5 1h36s 1h30s 03 8 23m21s 23m18s 04 4 1h45s 1h36s 05 6 1h30s 58m45s 06 8 57m39s 57m33s 07 11 52m39s 50m20s 08 16 50m33s 49m15s 09 18 53m19s 51m24s 10 14 1h10s 58m59s 11 16 56m7s 54m20s 12 14 1h37s 59m23s 13 12 43m14s 42m13s 14 15 58m27s 56m3s 15 18 57m19s 55m20s 16 17 57m53s 55m52s 17 12 57m34s 56m30s 18 10 1h18s 59m40s 19 4 50m 48m27s 20 7 36m17s 34m8s 21 5 1h36s 59m18s 22 6 1h1m26s 1h20s 23 6 35m8s 30m1s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-10 15:38:09 Date
Connections per database
Key values
- rio Main Database
- 253 connections Total
Connections per user
Key values
- intelifix Main User
- 253 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-10 08:08:41 Date
Histogram of session times
Key values
- 202 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 246 sessions Total
Sessions per user
Key values
- intelifix Main User
- 246 sessions Total
Sessions per host
Key values
- [local] Main Host
- 246 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 34,695 buffers Checkpoint Peak
- 2026-06-10 08:19:38 Date
- 270.046 seconds Highest write time
- 0.045 seconds Sync time
Checkpoints Wal files
Key values
- 16 files Wal files usage Peak
- 2026-06-10 16:04:41 Date
Checkpoints distance
Key values
- 498.89 Mo Distance Peak
- 2026-06-10 16:04:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 10 00 13,968 667.717s 0.02s 667.776s 01 1,992 200.055s 0.017s 200.098s 02 1,697 170.378s 0.015s 170.416s 03 1,792 179.21s 0.031s 179.272s 04 4,997 501.574s 0.036s 501.654s 05 6,872 643.677s 0.038s 643.758s 06 6,842 527.053s 0.012s 527.09s 07 37,611 2,354.18s 0.085s 2,354.354s 08 85,687 3,002.16s 0.2s 3,002.509s 09 80,935 3,239.28s 0.227s 3,239.663s 10 51,186 3,130.41s 0.196s 3,130.75s 11 60,980 3,236.23s 0.221s 3,236.615s 12 30,519 2,208.154s 0.061s 2,208.294s 13 21,690 1,966.973s 0.142s 1,967.223s 14 89,052 3,239.272s 0.252s 3,239.691s 15 72,495 3,239.293s 0.2s 3,239.652s 16 77,687 3,232.261s 0.313s 3,232.729s 17 26,774 2,252.967s 0.092s 2,253.17s 18 763 76.468s 0.01s 76.501s 19 21 2.128s 0.003s 2.135s 20 1,727 309.933s 0.007s 309.954s 21 2,707 271.72s 0.031s 271.801s 22 1,892 190.021s 0.021s 190.073s 23 3,848 440.606s 0.011s 440.635s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 10 00 0 0 5 531 0.003s 0.008s 01 0 0 1 467 0.003s 0.006s 02 0 0 0 361 0.003s 0.005s 03 0 0 1 413 0.004s 0.007s 04 0 0 1 822 0.003s 0.01s 05 0 0 3 605 0.003s 0.009s 06 0 0 2 298 0.003s 0.005s 07 0 0 22 3,022 0.004s 0.012s 08 0 0 37 5,108 0.003s 0.012s 09 0 0 46 6,005 0.005s 0.012s 10 0 0 19 5,478 0.003s 0.012s 11 0 0 36 5,601 0.003s 0.012s 12 0 0 12 2,104 0.003s 0.011s 13 0 0 9 4,056 0.004s 0.012s 14 0 0 52 6,190 0.004s 0.012s 15 0 0 44 5,837 0.004s 0.012s 16 0 0 48 5,213 0.006s 0.012s 17 0 0 15 3,762 0.003s 0.012s 18 0 0 0 68 0.002s 0.006s 19 0 0 0 3 0.002s 0.001s 20 0 0 2 58 0.003s 0.004s 21 0 0 1 442 0.003s 0.01s 22 0 0 0 395 0.002s 0.007s 23 0 0 2 32 0.004s 0.004s Day Hour Count Avg time (sec) Jun 10 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 10 00 11,908.29 kB 35,286.86 kB 01 1,741.83 kB 19,896.67 kB 02 1,752.40 kB 11,819.60 kB 03 1,330.86 kB 3,518.57 kB 04 2,543.50 kB 3,629.40 kB 05 5,699.33 kB 18,923.33 kB 06 4,213.20 kB 12,966.80 kB 07 30,555.75 kB 71,065.42 kB 08 50,807.08 kB 86,721.25 kB 09 62,716.50 kB 92,531.08 kB 10 25,965.42 kB 58,542.58 kB 11 49,138.08 kB 85,117.42 kB 12 18,174.45 kB 59,312.55 kB 13 12,051.17 kB 33,158.33 kB 14 69,966.50 kB 93,586.33 kB 15 61,276.58 kB 111,001.67 kB 16 64,892.50 kB 170,987.92 kB 17 20,908.58 kB 73,200.17 kB 18 616.60 kB 40,592.80 kB 19 165.00 kB 29,300.00 kB 20 6,958.67 kB 25,632.33 kB 21 1,489.00 kB 14,760.44 kB 22 1,470.00 kB 7,042.00 kB 23 8,369.33 kB 16,237.33 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-10 17:42:51 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-10 17:42:51 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 3 311.99 MiB 104.00 MiB 09 1 104.00 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 1 104.00 MiB 104.00 MiB 13 0 0 0 14 4 415.98 MiB 104.00 MiB 15 3 311.99 MiB 104.00 MiB 16 5 519.98 MiB 104.00 MiB 17 2 207.99 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 21 2.13 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( 025403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 09:11:09 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025413, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 12:38:25 Duration: 4m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025411, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 11:26:46 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 17:42:51 - 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-10 09:29:34 - 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-10 08:26:34 - 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-10 14:48:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 14:55:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 15:55:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-10 12:20:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 14:16:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 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-10 14:27:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 11:04:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 10:57:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 15:03:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 16:52:46 - 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-10 16:32:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 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-10 16:35:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 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-10 16:37:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 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-10 17:33:38 - 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-10 08:51:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 103.99 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 16:44:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 103.99 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-10 08:34:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 10.11 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-10 14:27:56 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 10.11 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-10 14:27:56 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (138) Main table analyzed (database rio)
- 1,014 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 138 rio.pg_catalog.pg_class 72 rio.pg_catalog.pg_type 60 rio.public.temp0000282137 56 contagem.pg_catalog.pg_attribute 52 rio.public.usuarios 48 contagem.pg_catalog.pg_class 41 rio.pg_catalog.pg_index 37 contagem.pg_catalog.pg_type 32 rio.public.temp0000282135 31 rio.pg_catalog.pg_depend 29 contagem.public.usuarios 29 rio.public.temp0000282233 26 rio.public.temp0000282185 24 rio.public.temp0000282023 23 contagem.pg_catalog.pg_index 22 contagem.public.temp0000226364 20 contagem.pg_catalog.pg_depend 20 rio.public.temp0000282143 16 rio.public.temp0000281897 15 rio.public.temp0000282227 15 rio.public.temp0000282171 15 rio.public.temp0000282193 14 rio.public.temp0000282157 14 rio.public.temp0000281335 13 rio.public.temp0000282217 10 contagem.public.nf_entrada 10 contagem.public.temp0000226366 9 rio.public.temp0000282115 9 rio.public.temp0000282181 8 rio.public.temp0000282073 8 contagem.pg_catalog.pg_shdepend 7 contagem.public.temp0000226368 6 rio.public.temp0000282163 6 rio.public.tmp_drill_0175 5 rio.public.temp0000282161 5 rio.public.temp0000282145 5 rio.pg_catalog.pg_shdepend 4 postgres.pg_catalog.pg_shdepend 4 rio.public.tmp_drill_0302 4 template1.pg_catalog.pg_shdepend 4 rio.public.temp0000282223 3 contagem.public.temp0000226362 3 rio.public.temp0000282239 3 rio.public.temp0000282259 3 rio.public.temp0000282141 2 contagem.auditor.auditor_2026_06 2 rio.public.temp0000282229 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000282225 2 rio.public.temp0000282167 2 rio.public.temp0000282129 2 rio.public.temp0000282261 1 contagem.public.parametros 1 rio.public.temp0000282165 1 rio.public.temp0000282175 1 rio.auditor.auditor_2026_06 1 rio.public.temp0000282249 1 rio.public.temp0000282231 1 rio.public.temp0000282235 1 rio.public.temp0000282169 1 rio.public.temp0000282139 1 rio.public.temp0000282197 1 rio.public.temp0000282209 1 rio.public.temp0000282243 1 rio.public.temp0000282131 1 contagem.public.temp0000226358 1 rio.public.temp0000282159 1 rio.public.temp0000282257 1 rio.public.temp0000282213 1 contagem.public.temp0000226360 1 rio.public.temp0000282153 1 rio.public.temp0000282199 1 rio.public.temp0000282203 1 Total 1,014 Vacuums per table
Key values
- public.temp0000282137 (55) Main table vacuumed on database rio
- 475 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000282137 55 0 0 0 0 0 0 40,326 2,031 4,851,704 0 0 rio.pg_catalog.pg_attribute 45 44 0 0 0 0 0 27,140 6,540 10,132,595 423 10,836 contagem.public.usuarios 28 0 0 0 0 0 0 137 96 52,583 0 0 contagem.pg_catalog.pg_attribute 26 26 0 0 0 0 0 16,229 3,874 7,300,454 53 1,180 rio.pg_catalog.pg_class 25 25 0 0 0 0 0 5,738 1,857 2,660,126 100 414 rio.public.temp0000282233 25 0 0 0 0 0 0 31,307 95 1,861,863 0 0 rio.pg_catalog.pg_type 22 22 0 0 0 0 0 2,169 628 848,155 81 310 rio.public.temp0000282023 21 0 0 0 0 0 0 1,995 119 138,795 0 0 contagem.pg_catalog.pg_class 17 17 0 0 0 0 0 3,209 692 1,054,243 11 34 rio.pg_catalog.pg_index 15 15 0 0 0 0 0 914 257 243,151 50 133 rio.public.temp0000281897 14 0 0 0 0 0 0 1,437 79 97,166 0 0 rio.public.temp0000282171 14 0 0 0 0 0 0 18,763 1,612 3,098,343 0 0 contagem.pg_catalog.pg_type 14 14 0 0 0 0 0 1,370 360 586,974 7 14 rio.public.temp0000281335 13 0 0 0 0 0 0 1,295 161 237,038 0 0 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,733 1,362 1,847,646 64 582 contagem.pg_catalog.pg_index 10 10 0 0 0 0 0 453 139 147,724 4 6 contagem.pg_catalog.pg_depend 10 10 0 0 0 0 0 2,629 823 1,608,657 10 48 contagem.public.temp0000226366 9 0 0 0 0 0 0 833 54 57,474 0 0 rio.public.temp0000282115 9 0 0 0 0 0 0 954 126 196,865 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,849 2,392 11,174,659 1,003 4,669 rio.public.tmp_drill_0175 6 4 0 0 0 0 0 135 30 53,692 1 31 rio.pg_toast.pg_toast_2619 6 6 0 0 0 0 0 2,113 457 2,097,305 108 362 rio.public.usuarios 5 3 0 0 0 0 0 95 26 46,833 4 21 contagem.public.temp0000226368 5 0 0 0 0 0 0 382 29 27,084 0 0 rio.public.temp0000282161 5 0 0 0 0 0 0 6,259 19 372,231 0 0 rio.public.temp0000282227 4 0 0 0 0 0 0 295 20 20,956 0 0 rio.public.tmp_drill_0302 4 4 0 0 0 0 0 477 29 127,834 0 0 template1.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 613 206 262,736 76 622 rio.public.temp0000282073 4 0 0 0 0 0 0 358 21 24,534 0 0 rio.public.temp0000282163 3 0 0 0 0 0 0 3,134 14 189,075 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 407 129 171,221 21 45 rio.auditor.auditor_2026_06 2 0 0 0 0 0 0 130,354 61,142 80,382,960 34,429 678,024 rio.public.temp0000282217 2 0 0 0 0 0 0 128 11 9,367 0 0 rio.public.temp0000282225 2 0 0 0 0 0 0 1,688 10 101,183 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 296 102 318,994 22 55 contagem.public.nf_entrada 2 2 0 0 0 0 0 149 65 145,797 10 52 rio.public.temp0000282141 2 0 0 0 0 0 0 131 12 9,308 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 274 73 89,979 17 31 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,244 1,181 3,775,262 1,010 7,190 rio.public.temp0000282167 2 0 0 0 0 0 0 1,675 10 100,391 0 0 rio.public.temp0000282249 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 539 211 617,188 168 8,513 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 94 2 7,373 0 0 contagem.public.temp0000226364 1 0 0 0 0 0 0 93 6 6,414 0 0 rio.public.temp0000282235 1 0 0 0 0 0 0 123 6 8,243 0 0 rio.public.temp0000282231 1 0 0 0 0 0 0 123 6 8,245 0 0 rio.public.temp0000282229 1 0 0 0 0 0 0 123 6 8,245 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 18,666 10,142 13,357,717 4,242 92,864 rio.public.temp0000282181 1 0 0 0 0 0 0 1,565 4 92,938 0 0 rio.public.temp0000282165 1 0 0 0 0 0 0 111 6 7,514 0 0 rio.public.temp0000282257 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000282203 1 0 0 0 0 0 0 8 5 1,251 0 0 rio.public.temp0000282243 1 0 0 0 0 0 0 143 6 9,431 0 0 rio.public.temp0000282259 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000282157 1 0 0 0 0 0 0 112 6 7,572 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 175 59 216,059 55 10,175 rio.public.temp0000282159 1 0 0 0 0 0 0 112 6 7,572 0 0 Total 475 235 0 0 0 0 0 345,686 97,363 150,881,041 41,969 816,211 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (19.12) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000282137 0 0 1.45 rio.pg_catalog.pg_attribute 0 0 3.1 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.69 rio.pg_catalog.pg_class 0 0 0.73 rio.public.temp0000282233 0 0 1.24 rio.pg_catalog.pg_type 0 0 0.29 rio.public.temp0000282023 0 0 0.24 contagem.pg_catalog.pg_class 0 0 0.26 rio.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000281897 0 0 0.16 rio.public.temp0000282171 0 0 0.67 contagem.pg_catalog.pg_type 0 0 0.13 rio.public.temp0000281335 0 0 0.19 rio.pg_catalog.pg_depend 0 0 0.64 contagem.pg_catalog.pg_index 0 0 0.11 contagem.pg_catalog.pg_depend 0 0 0.4 contagem.public.temp0000226366 0 0 0.1 rio.public.temp0000282115 0 0 0.1 rio.pg_catalog.pg_statistic 0 0 1.18 rio.public.tmp_drill_0175 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.13 rio.public.usuarios 0 0 0.01 contagem.public.temp0000226368 0 0 0.08 rio.public.temp0000282161 0 0 0.25 rio.public.temp0000282227 0 0 0.05 rio.public.tmp_drill_0302 0 0 0.01 template1.pg_catalog.pg_shdepend 0 0 0.08 rio.public.temp0000282073 0 0 0.05 rio.public.temp0000282163 0 0 0.1 postgres.pg_catalog.pg_shdepend 0 0 0.05 rio.auditor.auditor_2026_06 0 0 19.12 rio.public.temp0000282217 0 0 0.03 rio.public.temp0000282225 0 0 0.07 contagem.pg_toast.pg_toast_2619 0 0 0.01 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000282141 0 0 0.02 rio.pg_catalog.pg_shdepend 0 0 0.04 contagem.pg_catalog.pg_statistic 0 0 0.22 rio.public.temp0000282167 0 0 0.06 rio.public.temp0000282249 0 0 0 rio.public.nf_entrada_arquivo_erros 0 0 0.16 brasilia.pg_catalog.pg_statistic 0 0 0 contagem.public.temp0000226364 0 0 0.01 rio.public.temp0000282235 0 0 0.01 rio.public.temp0000282231 0 0 0.01 rio.public.temp0000282229 0 0 0.01 contagem.auditor.auditor_2026_06 0 0 3.36 rio.public.temp0000282181 0 0 0.05 rio.public.temp0000282165 0 0 0.02 rio.public.temp0000282257 0 0 0 rio.public.temp0000282203 0 0 0.01 rio.public.temp0000282243 0 0 0.01 rio.public.temp0000282259 0 0 0 rio.public.temp0000282157 0 0 0.01 rio.public.equipamentos_referencia 0 0 0.03 rio.public.temp0000282159 0 0 0.01 Total 0 0 36.85 Tuples removed per table
Key values
- pg_catalog.pg_attribute (213923) Main table with removed tuples on database rio
- 392899 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 45 44 213,923 1,109,282 14,641 385 27,034 contagem.pg_catalog.pg_attribute 26 26 94,945 663,595 0 1 15,384 rio.pg_catalog.pg_statistic 8 8 15,169 69,293 0 0 10,288 rio.pg_catalog.pg_type 22 22 9,014 50,758 238 26 1,529 rio.public.tmp_drill_0302 4 4 5,876 6,693 0 0 171 rio.pg_catalog.pg_depend 11 11 5,863 213,786 344 28 1,902 contagem.pg_catalog.pg_depend 10 10 5,354 189,222 694 0 1,760 contagem.pg_catalog.pg_statistic 2 2 5,204 14,878 0 0 2,022 rio.pg_catalog.pg_class 25 25 5,172 92,369 392 46 3,441 rio.auditor.auditor_2026_06 2 0 4,325 15,911,494 0 0 743,801 rio.pg_catalog.pg_index 15 15 4,280 29,087 10 8 836 contagem.pg_catalog.pg_class 17 17 4,201 57,792 532 0 2,104 contagem.pg_catalog.pg_type 14 14 3,727 31,714 214 4 974 template1.pg_catalog.pg_shdepend 4 4 3,571 35,205 11 0 404 postgres.pg_catalog.pg_shdepend 3 3 2,947 25,229 123 0 303 contagem.pg_catalog.pg_index 10 10 2,220 18,975 0 17 497 rio.pg_catalog.pg_shdepend 2 2 2,128 16,998 0 0 202 contagem.public.usuarios 28 0 1,734 644 0 0 56 rio.pg_toast.pg_toast_2619 6 6 1,404 2,555 1 0 1,704 rio.public.tmp_drill_0175 6 4 690 2,886 690 0 62 contagem.public.nf_entrada 2 2 438 2,271 0 0 138 rio.public.usuarios 5 3 277 3,150 615 1 80 contagem.pg_toast.pg_toast_2619 2 2 222 231 0 0 128 brasilia.pg_catalog.pg_statistic 1 1 178 449 0 0 36 rio.public.nf_entrada_arquivo_erros 1 0 37 8,281,173 0 0 147,375 rio.public.temp0000282249 1 0 0 2,483 0 0 128 rio.public.temp0000282163 3 0 0 46,162 0 24 3,304 contagem.public.temp0000226366 9 0 0 9,904 0 391 761 rio.public.temp0000282217 2 0 0 9,906 0 34 222 contagem.public.temp0000226364 1 0 0 1,105 0 43 85 rio.public.temp0000282225 2 0 0 24,362 0 13 1,715 rio.public.temp0000282227 4 0 0 26,375 0 102 602 rio.public.temp0000282235 1 0 0 2,347 0 13 115 rio.public.temp0000282231 1 0 0 2,347 0 13 115 rio.public.temp0000282229 1 0 0 2,347 0 13 115 rio.public.temp0000282137 55 0 0 640,457 0 313 44,999 contagem.auditor.auditor_2026_06 1 0 0 1,386,814 0 0 61,007 contagem.public.temp0000226368 5 0 0 5,546 0 214 426 rio.public.temp0000282181 1 0 0 22,015 0 0 1,600 rio.public.temp0000281897 14 0 0 62,497 0 506 1,414 rio.public.temp0000282141 2 0 0 5,590 0 77 115 rio.public.temp0000282165 1 0 0 2,178 0 25 103 rio.public.temp0000282257 1 0 0 2,550 0 0 128 rio.public.temp0000282115 9 0 0 45,816 0 304 1,040 rio.public.temp0000282023 21 0 0 102,096 0 763 2,309 rio.public.temp0000282203 1 0 0 1,024 0 10 54 rio.public.temp0000281335 13 0 0 62,784 0 502 1,418 rio.public.temp0000282243 1 0 0 5,961 0 57 135 rio.public.temp0000282233 25 0 0 550,184 0 0 40,000 rio.public.temp0000282259 1 0 0 2,568 0 0 128 rio.public.temp0000282157 1 0 0 2,177 0 24 104 rio.public.temp0000282167 2 0 0 24,184 0 25 1,703 rio.public.equipamentos_referencia 1 0 0 5,048,699 0 0 27,291 rio.public.temp0000282161 5 0 0 109,989 0 0 8,000 rio.public.temp0000282171 14 0 0 307,843 0 0 22,400 rio.public.temp0000282159 1 0 0 2,177 0 24 104 rio.public.temp0000282073 4 0 0 20,614 0 172 468 Total 475 235 392,899 35,370,830 18,505 4,178 1,184,339 Pages removed per table
Key values
- public.temp0000282023 (763) Main table with removed pages on database rio
- 4178 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282023 21 0 0 763 rio.public.temp0000281897 14 0 0 506 rio.public.temp0000281335 13 0 0 502 contagem.public.temp0000226366 9 0 0 391 rio.pg_catalog.pg_attribute 45 44 213923 385 rio.public.temp0000282137 55 0 0 313 rio.public.temp0000282115 9 0 0 304 contagem.public.temp0000226368 5 0 0 214 rio.public.temp0000282073 4 0 0 172 rio.public.temp0000282227 4 0 0 102 rio.public.temp0000282141 2 0 0 77 rio.public.temp0000282243 1 0 0 57 rio.pg_catalog.pg_class 25 25 5172 46 contagem.public.temp0000226364 1 0 0 43 rio.public.temp0000282217 2 0 0 34 rio.pg_catalog.pg_depend 11 11 5863 28 rio.pg_catalog.pg_type 22 22 9014 26 rio.public.temp0000282165 1 0 0 25 rio.public.temp0000282167 2 0 0 25 rio.public.temp0000282163 3 0 0 24 rio.public.temp0000282157 1 0 0 24 rio.public.temp0000282159 1 0 0 24 contagem.pg_catalog.pg_index 10 10 2220 17 rio.public.temp0000282225 2 0 0 13 rio.public.temp0000282235 1 0 0 13 rio.public.temp0000282231 1 0 0 13 rio.public.temp0000282229 1 0 0 13 rio.public.temp0000282203 1 0 0 10 rio.pg_catalog.pg_index 15 15 4280 8 contagem.pg_catalog.pg_type 14 14 3727 4 contagem.pg_catalog.pg_attribute 26 26 94945 1 rio.public.usuarios 5 3 277 1 rio.public.temp0000282249 1 0 0 0 rio.public.nf_entrada_arquivo_erros 1 0 37 0 brasilia.pg_catalog.pg_statistic 1 1 178 0 rio.auditor.auditor_2026_06 2 0 4325 0 rio.public.tmp_drill_0175 6 4 690 0 contagem.pg_toast.pg_toast_2619 2 2 222 0 contagem.public.nf_entrada 2 2 438 0 rio.public.tmp_drill_0302 4 4 5876 0 rio.pg_catalog.pg_statistic 8 8 15169 0 postgres.pg_catalog.pg_shdepend 3 3 2947 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.public.temp0000282181 1 0 0 0 rio.pg_catalog.pg_shdepend 2 2 2128 0 contagem.pg_catalog.pg_statistic 2 2 5204 0 contagem.public.usuarios 28 0 1734 0 contagem.pg_catalog.pg_class 17 17 4201 0 rio.pg_toast.pg_toast_2619 6 6 1404 0 rio.public.temp0000282257 1 0 0 0 contagem.pg_catalog.pg_depend 10 10 5354 0 rio.public.temp0000282233 25 0 0 0 rio.public.temp0000282259 1 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 rio.public.temp0000282161 5 0 0 0 rio.public.temp0000282171 14 0 0 0 template1.pg_catalog.pg_shdepend 4 4 3571 0 Total 475 235 392,899 4,178 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 10 00 0 1 01 0 0 02 0 0 03 0 0 04 0 2 05 5 1 06 0 0 07 14 27 08 60 111 09 56 127 10 41 107 11 39 99 12 8 35 13 29 62 14 73 135 15 76 139 16 39 97 17 34 68 18 0 0 19 0 0 20 0 0 21 1 3 22 0 0 23 0 0 - 10.11 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 4,158 Total read queries
- 1,439 Total write queries
Queries by database
Key values
- rio Main database
- 4,757 Requests
- 5h44m10s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,759 Requests
User Request type Count Duration etiquetas Total 6 994ms select 6 994ms intelifix Total 5,759 5h59m10s copy to 274 38m12s ddl 1,165 42m37s others 252 24m23s select 4,068 4h13m55s lenon Total 84 51s173ms select 84 51s173ms Duration by user
Key values
- 5h59m10s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 6 994ms select 6 994ms intelifix Total 5,759 5h59m10s copy to 274 38m12s ddl 1,165 42m37s others 252 24m23s select 4,068 4h13m55s lenon Total 84 51s173ms select 84 51s173ms Queries by host
Key values
- [local] Main host
- 5,849 Requests
- 6h2s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,161 Requests
- 2h56m17s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-10 16:05:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,515 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 15:13:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m55s analyze verbose;[ Date: 2026-06-10 05:07:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 10:12:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 12:12:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 11:12:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 14:12:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 09:11:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 07:11:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 17:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 13:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 20:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 16:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 08:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 22:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 18:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 21:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-10 19:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-10 09:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025413, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-10 12:38:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025411, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-10 11:26:46 - 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 1h45m12s 32 926ms 8m55s 3m17s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 10 07 2 6m52s 3m26s 08 2 6m1s 3m 09 2 7m 3m30s 10 2 7m9s 3m34s 11 2 7m5s 3m32s 12 2 7m5s 3m32s 13 2 6m26s 3m13s 14 2 7m2s 3m31s 15 2 8m59s 4m29s 16 2 6m19s 3m9s 17 2 6m35s 3m17s 18 2 5m29s 2m44s 19 2 5m27s 2m43s 20 2 6m26s 3m13s 21 2 5m30s 2m45s 22 2 5m39s 2m49s [ User: intelifix - Total duration: 1h45m12s - Times executed: 32 ]
[ Application: psql - Total duration: 1h45m12s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-10 15:13:57 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-10 10:12:08 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-10 12:12:05 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
2 1h33m6s 260 151ms 4m17s 21s487ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 10 07 16 11m34s 43s427ms 08 15 3m49s 15s299ms 09 19 15m34s 49s193ms 10 16 1m3s 3s947ms 11 19 10m13s 32s305ms 12 8 6m48s 51s57ms 13 12 8s168ms 680ms 14 45 12m42s 16s948ms 15 40 12m48s 19s216ms 16 56 16m29s 17s668ms 17 14 1m53s 8s108ms [ User: intelifix - Total duration: 1h33m6s - Times executed: 260 ]
[ Application: [unknown] - Total duration: 1h33m6s - Times executed: 260 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 09:11:09 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025413, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 12:38:25 Duration: 4m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025411, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 11:26:46 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 17m54s 1,433 150ms 4s356ms 749ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 10 07 16 9s279ms 579ms 08 96 1m18s 818ms 09 168 2m30s 893ms 10 166 2m8s 775ms 11 193 2m16s 708ms 12 45 36s831ms 818ms 13 80 1m17s 965ms 14 177 2m24s 813ms 15 182 1m58s 651ms 16 212 2m30s 707ms 17 98 44s531ms 454ms [ User: intelifix - Total duration: 17m54s - Times executed: 1433 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 1433 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41099, 418, 'ZTE3ANNR3Y03463,4896D95011E2,4896D95011E3,ZTEGD97E3E3C$ZTE3ANNRB708327,5872C98EFC5B,5872C98EFC5C,ZTEGDC614B5A$ZTE3ANNRAD23510,D89A0DB00167,D89A0DB00168,ZTEGDB1757E1$ZTE3ANNR9329896,D89A0D851CBB,D89A0D851CBC,ZTEGDB14E8C7$ZTE3ANNT2V83253,D83139932E16,D83139932E17,ZTEGDD3137B4$ZTE3ANNR2Q02286,F4E84F80E994,F4E84F80E995,ZTEGD97A7BA8$ZTE3ANNR2Q31733,F4E84F839BBE,F4E84F839BBF,ZTEGD97AEEAF$ZTE3ANNQ9J09490,843C992CAFA1,843C992CAFA2,ZTEGD7BB2DBD$ZTE3ANNR8C28071,3891485118F1,3891485118F2,ZTEGDB08EE17$ZTE3ANNQ9J15343,843C992D38CF,843C992D38D0,ZTEGD7BB449A$ZTE3ANNRC560689,6C11BA67B83D,6C11BA67B83E,ZTEGDC6F02D0$ZTE3ANNR9F14339,D89A0DA42DF5,D89A0DA42DF6,ZTEGDB155F4E$ZTE3ANNT2V84857,D831399353AE,D831399353AF,ZTEGDD313DF8$ZTE3ANNRAD30093,D89A0DB09BB1,D89A0DB09BB2,ZTEGDB177198$ZTE3ANNRC554226,6C11BA6720C3,6C11BA6720C4,ZTEGDC6EE991$ZTE3ANNT2V12211,D831398CAD0A,D831398CAD0B,ZTEGDD302232$ZTE3ANNQ7507766,C4EBFF8BA940,C4EBFF8BA941,ZTEGD70A6CF6$ZTE3ANNT3J10617,D83139A0E428,D83139A0E429,ZTEGDD3380B7$ZTE3ANNQ9J07955,843C992C8BA7,843C992C8BA8,ZTEGD7BB27BE$ZTE3ANNT3H83903,D831399E7212,D831399E7213,ZTEGDD33185E$ZTE3ANNR3J30415,F4E84F89173A,F4E84F89173B,ZTEGD97BD899$ZTE3ANNRAM42088,5872C98B12A9,5872C98B12AA,ZTEGDC60A467$ZTE3ANNT3H01583,D8313996E8B2,D8313996E8B3,ZTEGDD31D6CE$ZTE3ANNT3H17846,D831399865DC,D831399865DD,ZTEGDD321655$ZTE3ANNRCP34303,6C11BA6C4EC9,6C11BA6C4ECA,ZTEGDC6FC692$ZTE3ANNR7B55331,3891484DFD79,3891484DFD7A,ZTEGDB086983$ZTE3ANNR9W41138,D89A0DAC204F,D89A0DAC2050,ZTEGDB16B25D$ZTE3ANNR9W44583,D89A0DAC710D,D89A0DAC710E,ZTEGDB16BFD2$ZTE3ANNR3Y13303,4896D950F882,4896D950F883,ZTEGD97E64AC$ZTE3ANNQ8M19033,843C99208601,843C99208602,ZTEGD7BA91C6$ZTE3ANNRC552172,6C11BA66F09F,6C11BA66F0A0,ZTEGDC6EE18B$ZTE3ANNR7B38942,3891484C7D5B,3891484C7D5C,ZTEGDB08297E$ZTE3ANNRC575883,6C11BA691C59,6C11BA691C5A,ZTEGDC6F3E2A$ZTE3ANNQ8M07737,843C991F7D41,843C991F7D42,ZTEGD7BA65A6$ZTE3ANNQ4N02080,3CF9F0A8C26E,3CF9F0A8C26F,ZTEGD6410B1B$ZTE3ANNR2Q31630,F4E84F839954,F4E84F839955,ZTEGD97AEE48$ZTE3ANNQ9J07706,843C992C85D1,843C992C85D2,ZTEGD7BB26C5$ZTE3ANNR3Y01464,4896D94FE308,4896D94FE309,ZTEGD97E366D$ZTE3ANNQ8111210,689E29BCE587,689E29BCE588,ZTEGD7B7665A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 13:58:58 Duration: 4s356ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251863, 304, '834284941000654,241631308202,241628286784,241617544142,241677771738,241631087394,241597366067,241701283538,241699370827,241649192439,230048413647,241669498001,241649362029,241701256464,230049276671,241677774566,241710334960,241649329904,241608701933,241666240624,241601558395,241703863240,241674544666,241673070516,241656316579,241629242950,241605340707,241603055152,241604999405,241649362534,241639128000,241674265065,241665832626,241661094251,241596617172,241672334147,241620272647,241658125768,230047935059,241728297992,241649191126', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 14:29:45 Duration: 4s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251304, 504, 'E44E12B38D9D,ZTE3A8TR7R18055C7D21F1522F,ZTE3A8TT2L01399C7D21F240BF,ZTE3A8TT2L16667$E44E12926A2F,ZTE3A8TR5U17146F2A6,ZTE3A8TT3302025D6,ZTE3A8TT3C17753A4862B4,ZTE3A8TR4H20401$B47CA608ED76,ZTE3A8TR8U20277C7D21EB93AF,ZTE3A8TRB709287C7D21F15573,ZTE3A8TT2L01608,ZTE3A8TT3305136AA,ZTE3A8TT3307402$E44E12B1B8AD,ZTE3A8TR7913543E,ZTE3A8TT3307383$E44E12B0EAB5,ZTE3A8TR7900361A476230,ZTE3A8TR4H03984$E44E1292D577,ZTE3A8TR5U24012$E44E12B0A725,ZTE3A8TR6D21537C7D21F15607,ZTE3A8TT2L01645,ZTE3A8TT3305388$B47CA607FC12,ZTE3A8TR8U04828C7D21F23E23,ZTE3A8TT2L16500$E44E12926AE3,ZTE3A8TR5U17191$B47CA608F49A,ZTE3A8TR8U20734$E44E12B2A679,ZTE3A8TR7R03262$DC5193D9634E,ZTE3A8TQCH13842EDA,ZTE3A8TT3310998$E44E12B38D19,ZTE3A8TR7R18022$E44E12B3B631,ZTE3A8TR7R20652C7D21F1707F,ZTE3A8TT2L03339C7D21EB9333,ZTE3A8TRB709256$E44E12B23DC9,ZTE3A8TR7922062$E44E12B0E995,ZTE3A8TR7900289C7D21F2B8C3,ZTE3A8TT2L24348A478604,ZTE3A8TR4H06277C7D21F134DF,ZTE3A8TRCS25023$E44E12B245C5,ZTE3A8TR7922573D36,ZTE3A8TT3310893A4865C4,ZTE3A8TR4H20597$DC5193D96426,ZTE3A8TQCH13896', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 08:58:27 Duration: 4s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 13m54s 78 8s564ms 35s673ms 10s699ms create table temp0000282137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 10 07 12 2m20s 11s683ms 08 6 1m 10s127ms 09 12 2m5s 10s494ms 11 10 1m46s 10s681ms 12 3 31s112ms 10s370ms 14 14 2m33s 10s968ms 15 13 2m11s 10s140ms 16 8 1m24s 10s539ms [ User: intelifix - Total duration: 13m54s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 13m54s - Times executed: 78 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 07:03:15 Duration: 35s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:39:13 Duration: 13s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 11:20:56 Duration: 13s283ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 10m23s 32 422ms 49s466ms 19s471ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 10 07 2 48s294ms 24s147ms 08 2 32s717ms 16s358ms 09 2 48s996ms 24s498ms 10 2 31s946ms 15s973ms 11 2 50s714ms 25s357ms 12 2 47s956ms 23s978ms 13 2 32s275ms 16s137ms 14 2 31s76ms 15s538ms 15 2 48s241ms 24s120ms 16 2 32s461ms 16s230ms 17 2 48s141ms 24s70ms 18 2 27s748ms 13s874ms 19 2 29s565ms 14s782ms 20 2 49s896ms 24s948ms 21 2 30s509ms 15s254ms 22 2 32s534ms 16s267ms [ User: intelifix - Total duration: 10m23s - Times executed: 32 ]
[ Application: psql - Total duration: 10m23s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-10 11:12:50 Duration: 49s466ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-10 20:12:14 Duration: 48s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-10 09:12:43 Duration: 47s396ms Database: rio User: intelifix Remote: [local] Application: psql
6 10m5s 3 359ms 7m55s 3m21s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 10 05 3 10m5s 3m21s [ User: intelifix - Total duration: 10m5s - Times executed: 3 ]
[ Application: psql - Total duration: 10m5s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-10 05:07:57 Duration: 7m55s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-10 05:10:07 Duration: 2m9s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-10 05:07:57 Duration: 359ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 8m22s 27 14s444ms 32s41ms 18s602ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 10 08 1 32s41ms 32s41ms 09 1 17s69ms 17s69ms 10 3 50s417ms 16s805ms 11 3 49s652ms 16s550ms 13 3 1m3s 21s155ms 14 7 2m7s 18s285ms 15 1 23s646ms 23s646ms 16 7 1m57s 16s756ms 17 1 20s679ms 20s679ms [ User: intelifix - Total duration: 8m22s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 8m22s - Times executed: 27 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-10', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-10 08:56:09 Duration: 32s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-10', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-10 15:48:19 Duration: 23s646ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-10', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-10 13:55:40 Duration: 23s360ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m12s 138 2s272ms 9s109ms 3s135ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 10 00 6 25s701ms 4s283ms 01 6 19s412ms 3s235ms 02 6 20s89ms 3s348ms 03 6 16s810ms 2s801ms 04 6 16s179ms 2s696ms 05 6 15s189ms 2s531ms 06 6 15s813ms 2s635ms 07 6 16s465ms 2s744ms 08 6 18s278ms 3s46ms 09 6 21s287ms 3s547ms 10 6 20s649ms 3s441ms 11 6 19s411ms 3s235ms 12 6 20s880ms 3s480ms 13 6 19s130ms 3s188ms 14 6 22s205ms 3s700ms 15 6 20s899ms 3s483ms 16 6 21s249ms 3s541ms 17 6 18s345ms 3s57ms 18 6 16s220ms 2s703ms 19 6 15s686ms 2s614ms 20 6 18s105ms 3s17ms 21 6 18s481ms 3s80ms 22 6 16s198ms 2s699ms [ User: intelifix - Total duration: 7m12s - Times executed: 138 ]
[ Application: psql - Total duration: 7m12s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 00:05:21 Duration: 9s109ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 09:35:14 Duration: 5s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 15:15:11 Duration: 4s594ms Database: rio User: intelifix Remote: [local] Application: psql
9 7m3s 896 150ms 6s693ms 472ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 10 07 15 10s220ms 681ms 08 81 45s584ms 562ms 09 126 53s71ms 421ms 10 134 1m17s 579ms 11 121 52s797ms 436ms 12 1 536ms 536ms 13 105 47s15ms 447ms 14 144 1m5s 455ms 15 136 55s968ms 411ms 16 29 12s842ms 442ms 17 4 2s133ms 533ms [ User: intelifix - Total duration: 7m3s - Times executed: 896 ]
[ Application: [unknown] - Total duration: 7m3s - Times executed: 896 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "295", "itens" : "230006987280,229985939110,229976816569,230028528282,229971395468,229985245978,230031784549,229990633844,230029112538,229973180716,230019964361,230013926476,230010420108,229972453035,230006294452,229989646082,230005977901,229961005565,229982182941,229985235169", "usuario" : "405", "caixa" : "2913593", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-10 10:30:53 Duration: 6s693ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251792", "modelo" : "464", "itens" : "241764357078,241745717481,241738844050,241764365564,241747446685,241764173144,241765571732,241738425266,241764160820,241739492026,241776668000,241764369302,241740752340,241740600204,241764468403,241761360109,241740262943,241745660406,241764402942,241743270420,241747362839,241739634666,241771218791,241739551426,241743293250,241762637595,241747396276,241742801328,241776805667,241746639502,241738786367,241759915556,241747355868,241747433553,241742872042,241768002429,241738868496,241747257676,241764183751,241739649819,241739680911,241743276278,241744542934,241776663353,241764363241,241761343541,241738459512,241739565265,241746644149,241743312646,241747141325,241738611020,241764421934,241762499399,241763332445,241740175964,241767907088,241738811825,241738652640,241739852342,241738477392,241764547781,241745728088,241745715259,241743344646,241738722647,241776519297,241762327284,241776516368,241761508406,241767420824,241745496876,241739845876,241739444142,241761333843,241738639002,241762351025,241746492036,241767951616,241738619707,241762512735,241738476281,241776537380,241738426680,241747547682,241762531626,241764545761,241745696772,241765569711,241765423131,241739652648,241764301922,241742819915,241760866367", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-10 08:10:24 Duration: 2s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251710", "modelo" : "320", "itens" : "241697497994,241668731226,241693172646,241715205974,241616375880,241635816071,241597306162,241654954056,241706802932,241672643246,241694140709,241607669800,241663818186,834218932000257,835192928003839,834201929001016,835100915003473,835139921002318,834317946001129,834218932000736,835350951005051,835203930003455,835156923005968,834204930002892,834032905003598,835015903003905,836028905004043,835314946001791,834218932000504,835116917002073,834204930003265,834295943000688,835238935000953,835136920003224,835009902000780,834211931000669,834200929002119,836028905004200,834334948000723,835163924001500,836028905003772,835126919004511,835127919000149,836033906001246,836016903004725,835162924005159,834284941000710,835204930000733", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-10 07:17:27 Duration: 2s425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m14s 106 159ms 10s789ms 3s537ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 10 00 6 17s52ms 2s842ms 01 6 9s351ms 1s558ms 02 5 7s839ms 1s567ms 03 5 8s72ms 1s614ms 04 6 9s71ms 1s511ms 05 5 4s95ms 819ms 06 4 6s864ms 1s716ms 07 6 33s731ms 5s621ms 08 6 41s959ms 6s993ms 09 6 36s947ms 6s157ms 10 6 29s124ms 4s854ms 11 6 34s502ms 5s750ms 12 6 30s721ms 5s120ms 13 4 5s620ms 1s405ms 14 6 32s383ms 5s397ms 15 6 34s672ms 5s778ms 16 6 17s549ms 2s924ms 21 5 7s645ms 1s529ms 22 6 7s763ms 1s293ms [ User: intelifix - Total duration: 6m14s - Times executed: 106 ]
[ Application: psql - Total duration: 6m14s - Times executed: 106 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 00:05:12 Duration: 10s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 08:25:11 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 07:35:10 Duration: 8s814ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m59s 35 8s420ms 13s481ms 10s281ms create table temp0000282233 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 10 14 11 2m 10s984ms 15 10 1m39s 9s962ms 16 8 1m19s 9s928ms 17 6 59s970ms 9s995ms [ User: intelifix - Total duration: 5m59s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 5m59s - Times executed: 35 ]
-
CREATE TABLE temp0000282233 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:28:28 Duration: 13s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282233 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:17:11 Duration: 12s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282233 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:50:05 Duration: 12s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m21s 53 4s517ms 14s40ms 6s59ms create table temp0000282137 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 10 07 6 37s772ms 6s295ms 08 7 34s591ms 4s941ms 09 2 11s807ms 5s903ms 11 10 1m6s 6s659ms 14 4 24s656ms 6s164ms 15 16 1m36s 6s22ms 16 8 49s371ms 6s171ms [ User: intelifix - Total duration: 5m21s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 53 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 11:27:54 Duration: 14s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 07:09:24 Duration: 12s465ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 15:09:56 Duration: 7s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m58s 23 8s990ms 12s605ms 10s389ms create table temp0000282171 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 10 08 11 1m54s 10s406ms 09 5 53s332ms 10s666ms 10 3 30s54ms 10s18ms 11 4 41s90ms 10s272ms [ User: intelifix - Total duration: 3m58s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 23 ]
-
CREATE TABLE temp0000282171 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 09:33:20 Duration: 12s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282171 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 11:05:24 Duration: 11s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282171 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 08:45:06 Duration: 11s451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m21s 47 235ms 1m3s 4s289ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 10 07 5 2s303ms 460ms 08 5 47s434ms 9s486ms 09 7 14s922ms 2s131ms 10 1 4s766ms 4s766ms 11 4 4s161ms 1s40ms 12 1 553ms 553ms 14 9 46s896ms 5s210ms 15 7 1m5s 9s417ms 16 6 4s34ms 672ms 17 2 10s634ms 5s317ms [ User: intelifix - Total duration: 3m21s - Times executed: 47 ]
[ Application: psql - Total duration: 3m21s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025429);
Date: 2026-06-10 15:57:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025419);
Date: 2026-06-10 14:50:15 Duration: 40s93ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025396);
Date: 2026-06-10 08:27:52 Duration: 39s624ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m2s 2 1m30s 1m31s 1m31s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 10 20 1 1m31s 1m31s 23 1 1m30s 1m30s [ User: intelifix - Total duration: 3m2s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m2s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-10 20:08:41 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-10 23:38:13 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
16 2m2s 2 23s61ms 1m39s 1m1s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 10 23 2 2m2s 1m1s [ User: intelifix - Total duration: 2m2s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m2s - 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-10 23:14:13 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-10 23:39:46 Duration: 23s61ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1m59s 2 55s203ms 1m3s 59s598ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 10 20 1 1m3s 1m3s 23 1 55s203ms 55s203ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-10 20:05:27 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-10 23:17:56 Duration: 55s203ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 1m45s 2 21s142ms 1m24s 52s615ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 10 23 2 1m45s 52s615ms [ User: intelifix - Total duration: 1m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m45s - 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-10 23:11:28 Duration: 1m24s 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-10 23:39:02 Duration: 21s142ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1m31s 9 9s198ms 11s617ms 10s172ms create table temp0000282137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 10 07 3 28s342ms 9s447ms 09 3 30s776ms 10s258ms 14 1 10s889ms 10s889ms 15 1 9s928ms 9s928ms 16 1 11s617ms 11s617ms [ User: intelifix - Total duration: 1m31s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m31s - Times executed: 9 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-10 16:13:07 Duration: 11s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-10 14:56:53 Duration: 10s889ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-10 09:50:32 Duration: 10s654ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m26s 2 21s51ms 1m5s 43s439ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 10 23 2 1m26s 43s439ms [ User: intelifix - Total duration: 1m26s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-10 23:12:33 Duration: 1m5s 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-10 23:39:23 Duration: 21s51ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,433 17m54s 150ms 4s356ms 749ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 10 07 16 9s279ms 579ms 08 96 1m18s 818ms 09 168 2m30s 893ms 10 166 2m8s 775ms 11 193 2m16s 708ms 12 45 36s831ms 818ms 13 80 1m17s 965ms 14 177 2m24s 813ms 15 182 1m58s 651ms 16 212 2m30s 707ms 17 98 44s531ms 454ms [ User: intelifix - Total duration: 17m54s - Times executed: 1433 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 1433 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41099, 418, 'ZTE3ANNR3Y03463,4896D95011E2,4896D95011E3,ZTEGD97E3E3C$ZTE3ANNRB708327,5872C98EFC5B,5872C98EFC5C,ZTEGDC614B5A$ZTE3ANNRAD23510,D89A0DB00167,D89A0DB00168,ZTEGDB1757E1$ZTE3ANNR9329896,D89A0D851CBB,D89A0D851CBC,ZTEGDB14E8C7$ZTE3ANNT2V83253,D83139932E16,D83139932E17,ZTEGDD3137B4$ZTE3ANNR2Q02286,F4E84F80E994,F4E84F80E995,ZTEGD97A7BA8$ZTE3ANNR2Q31733,F4E84F839BBE,F4E84F839BBF,ZTEGD97AEEAF$ZTE3ANNQ9J09490,843C992CAFA1,843C992CAFA2,ZTEGD7BB2DBD$ZTE3ANNR8C28071,3891485118F1,3891485118F2,ZTEGDB08EE17$ZTE3ANNQ9J15343,843C992D38CF,843C992D38D0,ZTEGD7BB449A$ZTE3ANNRC560689,6C11BA67B83D,6C11BA67B83E,ZTEGDC6F02D0$ZTE3ANNR9F14339,D89A0DA42DF5,D89A0DA42DF6,ZTEGDB155F4E$ZTE3ANNT2V84857,D831399353AE,D831399353AF,ZTEGDD313DF8$ZTE3ANNRAD30093,D89A0DB09BB1,D89A0DB09BB2,ZTEGDB177198$ZTE3ANNRC554226,6C11BA6720C3,6C11BA6720C4,ZTEGDC6EE991$ZTE3ANNT2V12211,D831398CAD0A,D831398CAD0B,ZTEGDD302232$ZTE3ANNQ7507766,C4EBFF8BA940,C4EBFF8BA941,ZTEGD70A6CF6$ZTE3ANNT3J10617,D83139A0E428,D83139A0E429,ZTEGDD3380B7$ZTE3ANNQ9J07955,843C992C8BA7,843C992C8BA8,ZTEGD7BB27BE$ZTE3ANNT3H83903,D831399E7212,D831399E7213,ZTEGDD33185E$ZTE3ANNR3J30415,F4E84F89173A,F4E84F89173B,ZTEGD97BD899$ZTE3ANNRAM42088,5872C98B12A9,5872C98B12AA,ZTEGDC60A467$ZTE3ANNT3H01583,D8313996E8B2,D8313996E8B3,ZTEGDD31D6CE$ZTE3ANNT3H17846,D831399865DC,D831399865DD,ZTEGDD321655$ZTE3ANNRCP34303,6C11BA6C4EC9,6C11BA6C4ECA,ZTEGDC6FC692$ZTE3ANNR7B55331,3891484DFD79,3891484DFD7A,ZTEGDB086983$ZTE3ANNR9W41138,D89A0DAC204F,D89A0DAC2050,ZTEGDB16B25D$ZTE3ANNR9W44583,D89A0DAC710D,D89A0DAC710E,ZTEGDB16BFD2$ZTE3ANNR3Y13303,4896D950F882,4896D950F883,ZTEGD97E64AC$ZTE3ANNQ8M19033,843C99208601,843C99208602,ZTEGD7BA91C6$ZTE3ANNRC552172,6C11BA66F09F,6C11BA66F0A0,ZTEGDC6EE18B$ZTE3ANNR7B38942,3891484C7D5B,3891484C7D5C,ZTEGDB08297E$ZTE3ANNRC575883,6C11BA691C59,6C11BA691C5A,ZTEGDC6F3E2A$ZTE3ANNQ8M07737,843C991F7D41,843C991F7D42,ZTEGD7BA65A6$ZTE3ANNQ4N02080,3CF9F0A8C26E,3CF9F0A8C26F,ZTEGD6410B1B$ZTE3ANNR2Q31630,F4E84F839954,F4E84F839955,ZTEGD97AEE48$ZTE3ANNQ9J07706,843C992C85D1,843C992C85D2,ZTEGD7BB26C5$ZTE3ANNR3Y01464,4896D94FE308,4896D94FE309,ZTEGD97E366D$ZTE3ANNQ8111210,689E29BCE587,689E29BCE588,ZTEGD7B7665A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 13:58:58 Duration: 4s356ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251863, 304, '834284941000654,241631308202,241628286784,241617544142,241677771738,241631087394,241597366067,241701283538,241699370827,241649192439,230048413647,241669498001,241649362029,241701256464,230049276671,241677774566,241710334960,241649329904,241608701933,241666240624,241601558395,241703863240,241674544666,241673070516,241656316579,241629242950,241605340707,241603055152,241604999405,241649362534,241639128000,241674265065,241665832626,241661094251,241596617172,241672334147,241620272647,241658125768,230047935059,241728297992,241649191126', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 14:29:45 Duration: 4s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251304, 504, 'E44E12B38D9D,ZTE3A8TR7R18055C7D21F1522F,ZTE3A8TT2L01399C7D21F240BF,ZTE3A8TT2L16667$E44E12926A2F,ZTE3A8TR5U17146F2A6,ZTE3A8TT3302025D6,ZTE3A8TT3C17753A4862B4,ZTE3A8TR4H20401$B47CA608ED76,ZTE3A8TR8U20277C7D21EB93AF,ZTE3A8TRB709287C7D21F15573,ZTE3A8TT2L01608,ZTE3A8TT3305136AA,ZTE3A8TT3307402$E44E12B1B8AD,ZTE3A8TR7913543E,ZTE3A8TT3307383$E44E12B0EAB5,ZTE3A8TR7900361A476230,ZTE3A8TR4H03984$E44E1292D577,ZTE3A8TR5U24012$E44E12B0A725,ZTE3A8TR6D21537C7D21F15607,ZTE3A8TT2L01645,ZTE3A8TT3305388$B47CA607FC12,ZTE3A8TR8U04828C7D21F23E23,ZTE3A8TT2L16500$E44E12926AE3,ZTE3A8TR5U17191$B47CA608F49A,ZTE3A8TR8U20734$E44E12B2A679,ZTE3A8TR7R03262$DC5193D9634E,ZTE3A8TQCH13842EDA,ZTE3A8TT3310998$E44E12B38D19,ZTE3A8TR7R18022$E44E12B3B631,ZTE3A8TR7R20652C7D21F1707F,ZTE3A8TT2L03339C7D21EB9333,ZTE3A8TRB709256$E44E12B23DC9,ZTE3A8TR7922062$E44E12B0E995,ZTE3A8TR7900289C7D21F2B8C3,ZTE3A8TT2L24348A478604,ZTE3A8TR4H06277C7D21F134DF,ZTE3A8TRCS25023$E44E12B245C5,ZTE3A8TR7922573D36,ZTE3A8TT3310893A4865C4,ZTE3A8TR4H20597$DC5193D96426,ZTE3A8TQCH13896', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 08:58:27 Duration: 4s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 896 7m3s 150ms 6s693ms 472ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 10 07 15 10s220ms 681ms 08 81 45s584ms 562ms 09 126 53s71ms 421ms 10 134 1m17s 579ms 11 121 52s797ms 436ms 12 1 536ms 536ms 13 105 47s15ms 447ms 14 144 1m5s 455ms 15 136 55s968ms 411ms 16 29 12s842ms 442ms 17 4 2s133ms 533ms [ User: intelifix - Total duration: 7m3s - Times executed: 896 ]
[ Application: [unknown] - Total duration: 7m3s - Times executed: 896 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "295", "itens" : "230006987280,229985939110,229976816569,230028528282,229971395468,229985245978,230031784549,229990633844,230029112538,229973180716,230019964361,230013926476,230010420108,229972453035,230006294452,229989646082,230005977901,229961005565,229982182941,229985235169", "usuario" : "405", "caixa" : "2913593", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-10 10:30:53 Duration: 6s693ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251792", "modelo" : "464", "itens" : "241764357078,241745717481,241738844050,241764365564,241747446685,241764173144,241765571732,241738425266,241764160820,241739492026,241776668000,241764369302,241740752340,241740600204,241764468403,241761360109,241740262943,241745660406,241764402942,241743270420,241747362839,241739634666,241771218791,241739551426,241743293250,241762637595,241747396276,241742801328,241776805667,241746639502,241738786367,241759915556,241747355868,241747433553,241742872042,241768002429,241738868496,241747257676,241764183751,241739649819,241739680911,241743276278,241744542934,241776663353,241764363241,241761343541,241738459512,241739565265,241746644149,241743312646,241747141325,241738611020,241764421934,241762499399,241763332445,241740175964,241767907088,241738811825,241738652640,241739852342,241738477392,241764547781,241745728088,241745715259,241743344646,241738722647,241776519297,241762327284,241776516368,241761508406,241767420824,241745496876,241739845876,241739444142,241761333843,241738639002,241762351025,241746492036,241767951616,241738619707,241762512735,241738476281,241776537380,241738426680,241747547682,241762531626,241764545761,241745696772,241765569711,241765423131,241739652648,241764301922,241742819915,241760866367", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-10 08:10:24 Duration: 2s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "251710", "modelo" : "320", "itens" : "241697497994,241668731226,241693172646,241715205974,241616375880,241635816071,241597306162,241654954056,241706802932,241672643246,241694140709,241607669800,241663818186,834218932000257,835192928003839,834201929001016,835100915003473,835139921002318,834317946001129,834218932000736,835350951005051,835203930003455,835156923005968,834204930002892,834032905003598,835015903003905,836028905004043,835314946001791,834218932000504,835116917002073,834204930003265,834295943000688,835238935000953,835136920003224,835009902000780,834211931000669,834200929002119,836028905004200,834334948000723,835163924001500,836028905003772,835126919004511,835127919000149,836033906001246,836016903004725,835162924005159,834284941000710,835204930000733", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-10 07:17:27 Duration: 2s425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 260 1h33m6s 151ms 4m17s 21s487ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 10 07 16 11m34s 43s427ms 08 15 3m49s 15s299ms 09 19 15m34s 49s193ms 10 16 1m3s 3s947ms 11 19 10m13s 32s305ms 12 8 6m48s 51s57ms 13 12 8s168ms 680ms 14 45 12m42s 16s948ms 15 40 12m48s 19s216ms 16 56 16m29s 17s668ms 17 14 1m53s 8s108ms [ User: intelifix - Total duration: 1h33m6s - Times executed: 260 ]
[ Application: [unknown] - Total duration: 1h33m6s - Times executed: 260 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 09:11:09 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025413, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 12:38:25 Duration: 4m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025411, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 11:26:46 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 223 1m8s 150ms 1s51ms 305ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 10 08 91 25s332ms 278ms 09 75 21s474ms 286ms 11 57 21s311ms 373ms [ User: intelifix - Total duration: 1m8s - Times executed: 223 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 223 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"D831392454FC,3CF9F0AA49C4,5872C9894B27,D89A0DA43347,D831391E20D6,4896D94FEB7E,6C11BA624A65,843C9922670F,38914851157F,6C11BA6D2D29,48D6822F3D8E,C4EBFF8906A0,3891484A7499,48D6822F0B60,4896D950123C,4896D957AD7E,3891484BF049,6C11BA66DF17,F4E84F839828,843C992F1551,F4E84F841F28,38914850DFBB,5872C9902855,3CF9F0AD9476,D83139921A6A,843C992C447F,F4E84F8399CC,3CF9F0AA0080,F4E84F86DD3A,4896D951CAEE,5872C98CDC05,D831399D0F82,3CF9F0ACB06A,4896D957AED4,389148511693,6C11BA67A93D,3CF9F0A29BAA,3CF9F0A8A3CC,689E29BDFE9D,3CF9F0AA50CC,C4EBFF892062,689E29BE0497,F4E84F841EF2","usuario":"416","observacao":""}');
Date: 2026-06-10 11:18:26 Duration: 1s51ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"A456CCE025D0,905851ACEE53,54A65C89DBA8,087E64841744,087E6482DE2E,B42A0E9BDE08,D4B92F286586,1062D0133B12,383FB3AA5F3C,10C25A16A119,80D04A927995,1062D0126044,54A65C8B2645,905851AC77A0,480033E9EAF6,946A77276817,A456CCE6C209,80D04A913294,80D04A9663EC,BC9B689998F1,80D04A986C77,1062D0C987C9,80D04AB8E886,80D04A913614,10C25A16AC95","usuario":"416","observacao":""}');
Date: 2026-06-10 11:17:57 Duration: 955ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"905851A91BC6,946A7725C314,70037E9CEAB6,D4B92F2700B7,9058514550CC,D4B92F2A0B4D,BC9B68958E80,BC9B68966EA3,BC9B6898A4E6,54A65C898A2C,70037E9F0148,1062D0115461,54A65C8AE5B6,70037E9D568E,087E64816D3B,80D04A97FDB9,383FB3A8AAD4,90585141EDAC,5C769597505A,5C76959641E5,383FB3A68809,80D04A96DF68,80D04AB82C66,B42A0E9A9DD6,1062D0C818B2,54A65C8C665B,70037E9C71A9","usuario":"416","observacao":""}');
Date: 2026-06-10 11:14:31 Duration: 895ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 165 28s489ms 150ms 601ms 172ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 10 07 2 764ms 382ms 08 1 166ms 166ms 10 1 156ms 156ms 11 10 1s679ms 167ms 12 6 1s24ms 170ms 13 8 1s349ms 168ms 14 32 5s257ms 164ms 15 47 7s927ms 168ms 16 43 7s525ms 175ms 17 15 2s638ms 175ms [ User: intelifix - Total duration: 28s489ms - Times executed: 165 ]
[ Application: [unknown] - Total duration: 28s489ms - Times executed: 165 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-06-09", "data-ate" : "2026-06-09", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-06-10 07:01:18 Duration: 601ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-06-10", "data-ate" : "2026-06-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-06-10 17:06:25 Duration: 268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-10", "data-ate" : "2026-06-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-10 16:08:04 Duration: 235ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 144 1m14s 151ms 9s922ms 519ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 10 07 15 7s133ms 475ms 08 1 1s738ms 1s738ms 09 3 3s245ms 1s81ms 10 23 18s784ms 816ms 11 16 5s436ms 339ms 13 9 4s33ms 448ms 14 22 9s819ms 446ms 15 14 7s118ms 508ms 16 34 15s591ms 458ms 17 7 1s917ms 273ms [ User: intelifix - Total duration: 1m14s - Times executed: 144 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 144 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-10 10:23:50 Duration: 9s922ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0252020) LIMIT 1;
Date: 2026-06-10 15:07:16 Duration: 2s173ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-10 09:25:14 Duration: 2s152ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 138 7m12s 2s272ms 9s109ms 3s135ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 10 00 6 25s701ms 4s283ms 01 6 19s412ms 3s235ms 02 6 20s89ms 3s348ms 03 6 16s810ms 2s801ms 04 6 16s179ms 2s696ms 05 6 15s189ms 2s531ms 06 6 15s813ms 2s635ms 07 6 16s465ms 2s744ms 08 6 18s278ms 3s46ms 09 6 21s287ms 3s547ms 10 6 20s649ms 3s441ms 11 6 19s411ms 3s235ms 12 6 20s880ms 3s480ms 13 6 19s130ms 3s188ms 14 6 22s205ms 3s700ms 15 6 20s899ms 3s483ms 16 6 21s249ms 3s541ms 17 6 18s345ms 3s57ms 18 6 16s220ms 2s703ms 19 6 15s686ms 2s614ms 20 6 18s105ms 3s17ms 21 6 18s481ms 3s80ms 22 6 16s198ms 2s699ms [ User: intelifix - Total duration: 7m12s - Times executed: 138 ]
[ Application: psql - Total duration: 7m12s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 00:05:21 Duration: 9s109ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 09:35:14 Duration: 5s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 15:15:11 Duration: 4s594ms Database: rio User: intelifix Remote: [local] Application: psql
8 122 19s637ms 150ms 197ms 160ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 10 04 2 309ms 154ms 05 1 157ms 157ms 07 3 516ms 172ms 08 12 1s890ms 157ms 09 10 1s583ms 158ms 10 8 1s284ms 160ms 11 23 3s715ms 161ms 12 4 641ms 160ms 13 13 2s101ms 161ms 14 17 2s720ms 160ms 15 9 1s456ms 161ms 16 4 658ms 164ms 17 16 2s602ms 162ms [ User: intelifix - Total duration: 19s637ms - Times executed: 122 ]
[ Application: [unknown] - Total duration: 19s637ms - Times executed: 122 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-10 15:10:25 Duration: 197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-10 17:01:12 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0302;
Date: 2026-06-10 14:17:46 Duration: 191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 117 22s665ms 150ms 372ms 193ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 10 04 31 6s630ms 213ms 05 2 514ms 257ms 07 12 2s297ms 191ms 08 10 1s907ms 190ms 09 16 2s816ms 176ms 10 10 1s720ms 172ms 11 9 1s588ms 176ms 12 6 978ms 163ms 14 8 1s551ms 193ms 15 11 2s264ms 205ms 16 2 395ms 197ms [ User: intelifix - Total duration: 22s665ms - Times executed: 117 ]
[ Application: [unknown] - Total duration: 22s665ms - Times executed: 117 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241728795370,241712647789,241630944451,241691487789,241630023138,241675891835,241699921116,241714699909,241606057880,241652872843,241628880715,241712626474,241609349403,241689767374,241658382943,241728066275', NULL, NULL, 0320, 00);
Date: 2026-06-10 04:45:03 Duration: 372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241732860313,241709383947,241631487388,241609267677,241699383252,241728496373,241629398194,241671996179,241649301720,241689354248,241649142737,241714506377,241660421627,241631757089,241646132836,241652447795,241615091019,241714013849,241595372136,241604640729,241728864849,241594045373,241652268383', NULL, NULL, 0320, 00);
Date: 2026-06-10 05:00:15 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '230048559799,241631485368,241709393241,241658341626,241649391931,241698730809,241631313051,241689059820,241621216464,241646355764,241654308202,241601068392,241619354768,241631527796,241607719299,241689291414,241711023344', NULL, NULL, 0320, 00);
Date: 2026-06-10 04:48:03 Duration: 301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 106 6m14s 159ms 10s789ms 3s537ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 10 00 6 17s52ms 2s842ms 01 6 9s351ms 1s558ms 02 5 7s839ms 1s567ms 03 5 8s72ms 1s614ms 04 6 9s71ms 1s511ms 05 5 4s95ms 819ms 06 4 6s864ms 1s716ms 07 6 33s731ms 5s621ms 08 6 41s959ms 6s993ms 09 6 36s947ms 6s157ms 10 6 29s124ms 4s854ms 11 6 34s502ms 5s750ms 12 6 30s721ms 5s120ms 13 4 5s620ms 1s405ms 14 6 32s383ms 5s397ms 15 6 34s672ms 5s778ms 16 6 17s549ms 2s924ms 21 5 7s645ms 1s529ms 22 6 7s763ms 1s293ms [ User: intelifix - Total duration: 6m14s - Times executed: 106 ]
[ Application: psql - Total duration: 6m14s - Times executed: 106 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 00:05:12 Duration: 10s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 08:25:11 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 07:35:10 Duration: 8s814ms Database: rio User: intelifix Remote: [local] Application: psql
11 93 17s847ms 150ms 285ms 191ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 10 07 3 712ms 237ms 08 12 2s421ms 201ms 09 22 4s75ms 185ms 10 9 1s728ms 192ms 11 5 1s118ms 223ms 14 2 341ms 170ms 15 15 3s47ms 203ms 16 17 3s86ms 181ms 17 8 1s315ms 164ms [ User: intelifix - Total duration: 17s847ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 17s847ms - Times executed: 93 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"458", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-10 15:10:56 Duration: 285ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"137", "usuario" :"507", "tipo" :"N", "itens" :"002", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-10 08:34:47 Duration: 284ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"299", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-10 16:35:32 Duration: 276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 85 27s56ms 155ms 4s982ms 318ms create table temp0000282161 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 10 08 18 8s200ms 455ms 09 7 1s445ms 206ms 10 15 3s372ms 224ms 11 4 1s32ms 258ms 12 1 216ms 216ms 13 1 247ms 247ms 14 4 1s79ms 269ms 15 11 3s488ms 317ms 16 21 6s959ms 331ms 17 3 1s14ms 338ms [ User: intelifix - Total duration: 27s56ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 27s56ms - Times executed: 85 ]
-
CREATE TABLE temp0000282161 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 08:02:44 Duration: 4s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282161 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 16:18:51 Duration: 491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282161 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 16:21:11 Duration: 488ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 83 26s293ms 162ms 6s179ms 316ms create table temp0000282181 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 10 08 5 7s38ms 1s407ms 09 17 3s779ms 222ms 10 13 2s771ms 213ms 11 8 1s927ms 240ms 12 4 972ms 243ms 13 5 1s311ms 262ms 14 10 2s957ms 295ms 15 18 4s916ms 273ms 16 3 618ms 206ms [ User: intelifix - Total duration: 26s293ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 26s293ms - Times executed: 83 ]
-
CREATE TABLE temp0000282181 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 08:37:20 Duration: 6s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282181 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"1516", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 15:27:36 Duration: 398ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282181 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"1516", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 14:49:46 Duration: 396ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 80 35s293ms 278ms 817ms 441ms 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 #14
Day Hour Count Duration Avg duration Jun 10 00 1 514ms 514ms 04 2 717ms 358ms 05 1 426ms 426ms 06 1 353ms 353ms 07 6 2s268ms 378ms 08 9 3s660ms 406ms 09 7 2s701ms 385ms 10 6 3s266ms 544ms 11 6 2s694ms 449ms 12 2 1s41ms 520ms 13 12 5s691ms 474ms 14 9 4s137ms 459ms 15 7 3s224ms 460ms 16 5 1s985ms 397ms 17 3 1s368ms 456ms 21 3 1s240ms 413ms [ User: lenon - Total duration: 35s293ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 35s293ms - Times executed: 80 ]
-
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-10 10:49:54 Duration: 817ms 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-10 10:08:46 Duration: 685ms 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-10 15:38:10 Duration: 664ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
15 78 13m54s 8s564ms 35s673ms 10s699ms create table temp0000282137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 10 07 12 2m20s 11s683ms 08 6 1m 10s127ms 09 12 2m5s 10s494ms 11 10 1m46s 10s681ms 12 3 31s112ms 10s370ms 14 14 2m33s 10s968ms 15 13 2m11s 10s140ms 16 8 1m24s 10s539ms [ User: intelifix - Total duration: 13m54s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 13m54s - Times executed: 78 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 07:03:15 Duration: 35s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:39:13 Duration: 13s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 11:20:56 Duration: 13s283ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 78 25s59ms 159ms 5s741ms 321ms create table temp0000282165 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 10 08 4 6s321ms 1s580ms 09 22 4s713ms 214ms 10 14 3s293ms 235ms 11 11 2s973ms 270ms 12 8 2s283ms 285ms 13 5 1s625ms 325ms 14 13 3s680ms 283ms 15 1 168ms 168ms [ User: intelifix - Total duration: 25s59ms - Times executed: 78 ]
[ Application: [unknown] - Total duration: 25s59ms - Times executed: 78 ]
-
CREATE TABLE temp0000282165 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 08:16:18 Duration: 5s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282165 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 13:43:45 Duration: 414ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282165 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 11:22:16 Duration: 374ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 76 28s653ms 151ms 575ms 377ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 10 07 4 1s286ms 321ms 08 7 2s523ms 360ms 09 4 1s742ms 435ms 10 2 609ms 304ms 11 3 1s161ms 387ms 12 5 1s732ms 346ms 13 2 645ms 322ms 14 9 3s651ms 405ms 15 24 9s138ms 380ms 16 14 5s319ms 379ms 17 2 842ms 421ms [ User: intelifix - Total duration: 28s653ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 28s653ms - Times executed: 76 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-10 15:21:16 Duration: 575ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-10 16:48:59 Duration: 545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-10 09:28:27 Duration: 543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 74 40s295ms 355ms 990ms 544ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 10 00 1 748ms 748ms 04 2 1s1ms 500ms 07 5 2s73ms 414ms 08 9 4s662ms 518ms 09 7 3s491ms 498ms 10 6 3s944ms 657ms 11 6 3s356ms 559ms 12 2 1s195ms 597ms 13 11 6s210ms 564ms 14 9 5s5ms 556ms 15 7 3s877ms 553ms 16 4 2s97ms 524ms 17 3 1s688ms 562ms 21 2 939ms 469ms [ User: intelifix - Total duration: 40s295ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 40s295ms - Times executed: 74 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-10 10:49:54 Duration: 990ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 72, 1);
Date: 2026-06-10 15:38:10 Duration: 804ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-06-10 10:08:46 Duration: 772ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 53 5m21s 4s517ms 14s40ms 6s59ms create table temp0000282137 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 10 07 6 37s772ms 6s295ms 08 7 34s591ms 4s941ms 09 2 11s807ms 5s903ms 11 10 1m6s 6s659ms 14 4 24s656ms 6s164ms 15 16 1m36s 6s22ms 16 8 49s371ms 6s171ms [ User: intelifix - Total duration: 5m21s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 53 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 11:27:54 Duration: 14s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 07:09:24 Duration: 12s465ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 15:09:56 Duration: 7s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 48 22s666ms 228ms 6s786ms 472ms create table temp0000282235 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 10 13 1 6s786ms 6s786ms 14 13 4s204ms 323ms 15 13 4s169ms 320ms 16 21 7s506ms 357ms [ User: intelifix - Total duration: 22s666ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 22s666ms - Times executed: 48 ]
-
CREATE TABLE temp0000282235 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 13:52:32 Duration: 6s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282235 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 16:15:30 Duration: 484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282235 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"79409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 16:16:27 Duration: 473ms 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 359ms 7m55s 3m21s 3 10m5s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 10 05 3 10m5s 3m21s [ User: intelifix - Total duration: 10m5s - Times executed: 3 ]
[ Application: psql - Total duration: 10m5s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-10 05:07:57 Duration: 7m55s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-10 05:10:07 Duration: 2m9s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-10 05:07:57 Duration: 359ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 926ms 8m55s 3m17s 32 1h45m12s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 10 07 2 6m52s 3m26s 08 2 6m1s 3m 09 2 7m 3m30s 10 2 7m9s 3m34s 11 2 7m5s 3m32s 12 2 7m5s 3m32s 13 2 6m26s 3m13s 14 2 7m2s 3m31s 15 2 8m59s 4m29s 16 2 6m19s 3m9s 17 2 6m35s 3m17s 18 2 5m29s 2m44s 19 2 5m27s 2m43s 20 2 6m26s 3m13s 21 2 5m30s 2m45s 22 2 5m39s 2m49s [ User: intelifix - Total duration: 1h45m12s - Times executed: 32 ]
[ Application: psql - Total duration: 1h45m12s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-10 15:13:57 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-10 10:12:08 Duration: 7m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-10 12:12:05 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
3 1m30s 1m31s 1m31s 2 3m2s 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 10 20 1 1m31s 1m31s 23 1 1m30s 1m30s [ User: intelifix - Total duration: 3m2s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m2s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-10 20:08:41 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-10 23:38:13 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 23s61ms 1m39s 1m1s 2 2m2s 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 10 23 2 2m2s 1m1s [ User: intelifix - Total duration: 2m2s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m2s - 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-10 23:14:13 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-10 23:39:46 Duration: 23s61ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 55s203ms 1m3s 59s598ms 2 1m59s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 10 20 1 1m3s 1m3s 23 1 55s203ms 55s203ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-10 20:05:27 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-10 23:17:56 Duration: 55s203ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 21s142ms 1m24s 52s615ms 2 1m45s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 10 23 2 1m45s 52s615ms [ User: intelifix - Total duration: 1m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m45s - 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-10 23:11:28 Duration: 1m24s 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-10 23:39:02 Duration: 21s142ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 21s51ms 1m5s 43s439ms 2 1m26s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 10 23 2 1m26s 43s439ms [ User: intelifix - Total duration: 1m26s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-10 23:12:33 Duration: 1m5s 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-10 23:39:23 Duration: 21s51ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 151ms 4m17s 21s487ms 260 1h33m6s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 10 07 16 11m34s 43s427ms 08 15 3m49s 15s299ms 09 19 15m34s 49s193ms 10 16 1m3s 3s947ms 11 19 10m13s 32s305ms 12 8 6m48s 51s57ms 13 12 8s168ms 680ms 14 45 12m42s 16s948ms 15 40 12m48s 19s216ms 16 56 16m29s 17s668ms 17 14 1m53s 8s108ms [ User: intelifix - Total duration: 1h33m6s - Times executed: 260 ]
[ Application: [unknown] - Total duration: 1h33m6s - Times executed: 260 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 09:11:09 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025413, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 12:38:25 Duration: 4m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025411, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-10 11:26:46 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 422ms 49s466ms 19s471ms 32 10m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 10 07 2 48s294ms 24s147ms 08 2 32s717ms 16s358ms 09 2 48s996ms 24s498ms 10 2 31s946ms 15s973ms 11 2 50s714ms 25s357ms 12 2 47s956ms 23s978ms 13 2 32s275ms 16s137ms 14 2 31s76ms 15s538ms 15 2 48s241ms 24s120ms 16 2 32s461ms 16s230ms 17 2 48s141ms 24s70ms 18 2 27s748ms 13s874ms 19 2 29s565ms 14s782ms 20 2 49s896ms 24s948ms 21 2 30s509ms 15s254ms 22 2 32s534ms 16s267ms [ User: intelifix - Total duration: 10m23s - Times executed: 32 ]
[ Application: psql - Total duration: 10m23s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-10 11:12:50 Duration: 49s466ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-10 20:12:14 Duration: 48s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-10 09:12:43 Duration: 47s396ms Database: rio User: intelifix Remote: [local] Application: psql
10 14s444ms 32s41ms 18s602ms 27 8m22s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 10 08 1 32s41ms 32s41ms 09 1 17s69ms 17s69ms 10 3 50s417ms 16s805ms 11 3 49s652ms 16s550ms 13 3 1m3s 21s155ms 14 7 2m7s 18s285ms 15 1 23s646ms 23s646ms 16 7 1m57s 16s756ms 17 1 20s679ms 20s679ms [ User: intelifix - Total duration: 8m22s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 8m22s - Times executed: 27 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-10', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-10 08:56:09 Duration: 32s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-10', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-10 15:48:19 Duration: 23s646ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-10', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-10 13:55:40 Duration: 23s360ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s564ms 35s673ms 10s699ms 78 13m54s create table temp0000282137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 10 07 12 2m20s 11s683ms 08 6 1m 10s127ms 09 12 2m5s 10s494ms 11 10 1m46s 10s681ms 12 3 31s112ms 10s370ms 14 14 2m33s 10s968ms 15 13 2m11s 10s140ms 16 8 1m24s 10s539ms [ User: intelifix - Total duration: 13m54s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 13m54s - Times executed: 78 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 07:03:15 Duration: 35s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:39:13 Duration: 13s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 11:20:56 Duration: 13s283ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s990ms 12s605ms 10s389ms 23 3m58s create table temp0000282171 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 10 08 11 1m54s 10s406ms 09 5 53s332ms 10s666ms 10 3 30s54ms 10s18ms 11 4 41s90ms 10s272ms [ User: intelifix - Total duration: 3m58s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 23 ]
-
CREATE TABLE temp0000282171 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 09:33:20 Duration: 12s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282171 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 11:05:24 Duration: 11s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282171 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 08:45:06 Duration: 11s451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s420ms 13s481ms 10s281ms 35 5m59s create table temp0000282233 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 10 14 11 2m 10s984ms 15 10 1m39s 9s962ms 16 8 1m19s 9s928ms 17 6 59s970ms 9s995ms [ User: intelifix - Total duration: 5m59s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 5m59s - Times executed: 35 ]
-
CREATE TABLE temp0000282233 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:28:28 Duration: 13s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282233 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:17:11 Duration: 12s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282233 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-10 14:50:05 Duration: 12s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 9s198ms 11s617ms 10s172ms 9 1m31s create table temp0000282137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 10 07 3 28s342ms 9s447ms 09 3 30s776ms 10s258ms 14 1 10s889ms 10s889ms 15 1 9s928ms 9s928ms 16 1 11s617ms 11s617ms [ User: intelifix - Total duration: 1m31s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m31s - Times executed: 9 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-10 16:13:07 Duration: 11s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-10 14:56:53 Duration: 10s889ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-10 09:50:32 Duration: 10s654ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 4s517ms 14s40ms 6s59ms 53 5m21s create table temp0000282137 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 10 07 6 37s772ms 6s295ms 08 7 34s591ms 4s941ms 09 2 11s807ms 5s903ms 11 10 1m6s 6s659ms 14 4 24s656ms 6s164ms 15 16 1m36s 6s22ms 16 8 49s371ms 6s171ms [ User: intelifix - Total duration: 5m21s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 53 ]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 11:27:54 Duration: 14s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 07:09:24 Duration: 12s465ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282137 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"05-06-2026", "ate" :"10-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-10 15:09:56 Duration: 7s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 235ms 1m3s 4s289ms 47 3m21s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 10 07 5 2s303ms 460ms 08 5 47s434ms 9s486ms 09 7 14s922ms 2s131ms 10 1 4s766ms 4s766ms 11 4 4s161ms 1s40ms 12 1 553ms 553ms 14 9 46s896ms 5s210ms 15 7 1m5s 9s417ms 16 6 4s34ms 672ms 17 2 10s634ms 5s317ms [ User: intelifix - Total duration: 3m21s - Times executed: 47 ]
[ Application: psql - Total duration: 3m21s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025429);
Date: 2026-06-10 15:57:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025419);
Date: 2026-06-10 14:50:15 Duration: 40s93ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025396);
Date: 2026-06-10 08:27:52 Duration: 39s624ms Database: rio User: intelifix Remote: [local] Application: psql
17 159ms 10s789ms 3s537ms 106 6m14s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 10 00 6 17s52ms 2s842ms 01 6 9s351ms 1s558ms 02 5 7s839ms 1s567ms 03 5 8s72ms 1s614ms 04 6 9s71ms 1s511ms 05 5 4s95ms 819ms 06 4 6s864ms 1s716ms 07 6 33s731ms 5s621ms 08 6 41s959ms 6s993ms 09 6 36s947ms 6s157ms 10 6 29s124ms 4s854ms 11 6 34s502ms 5s750ms 12 6 30s721ms 5s120ms 13 4 5s620ms 1s405ms 14 6 32s383ms 5s397ms 15 6 34s672ms 5s778ms 16 6 17s549ms 2s924ms 21 5 7s645ms 1s529ms 22 6 7s763ms 1s293ms [ User: intelifix - Total duration: 6m14s - Times executed: 106 ]
[ Application: psql - Total duration: 6m14s - Times executed: 106 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 00:05:12 Duration: 10s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 08:25:11 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-10 07:35:10 Duration: 8s814ms Database: rio User: intelifix Remote: [local] Application: psql
18 2s272ms 9s109ms 3s135ms 138 7m12s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 10 00 6 25s701ms 4s283ms 01 6 19s412ms 3s235ms 02 6 20s89ms 3s348ms 03 6 16s810ms 2s801ms 04 6 16s179ms 2s696ms 05 6 15s189ms 2s531ms 06 6 15s813ms 2s635ms 07 6 16s465ms 2s744ms 08 6 18s278ms 3s46ms 09 6 21s287ms 3s547ms 10 6 20s649ms 3s441ms 11 6 19s411ms 3s235ms 12 6 20s880ms 3s480ms 13 6 19s130ms 3s188ms 14 6 22s205ms 3s700ms 15 6 20s899ms 3s483ms 16 6 21s249ms 3s541ms 17 6 18s345ms 3s57ms 18 6 16s220ms 2s703ms 19 6 15s686ms 2s614ms 20 6 18s105ms 3s17ms 21 6 18s481ms 3s80ms 22 6 16s198ms 2s699ms [ User: intelifix - Total duration: 7m12s - Times executed: 138 ]
[ Application: psql - Total duration: 7m12s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 00:05:21 Duration: 9s109ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 09:35:14 Duration: 5s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-10 15:15:11 Duration: 4s594ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 4s356ms 749ms 1,433 17m54s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 10 07 16 9s279ms 579ms 08 96 1m18s 818ms 09 168 2m30s 893ms 10 166 2m8s 775ms 11 193 2m16s 708ms 12 45 36s831ms 818ms 13 80 1m17s 965ms 14 177 2m24s 813ms 15 182 1m58s 651ms 16 212 2m30s 707ms 17 98 44s531ms 454ms [ User: intelifix - Total duration: 17m54s - Times executed: 1433 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 1433 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (41099, 418, 'ZTE3ANNR3Y03463,4896D95011E2,4896D95011E3,ZTEGD97E3E3C$ZTE3ANNRB708327,5872C98EFC5B,5872C98EFC5C,ZTEGDC614B5A$ZTE3ANNRAD23510,D89A0DB00167,D89A0DB00168,ZTEGDB1757E1$ZTE3ANNR9329896,D89A0D851CBB,D89A0D851CBC,ZTEGDB14E8C7$ZTE3ANNT2V83253,D83139932E16,D83139932E17,ZTEGDD3137B4$ZTE3ANNR2Q02286,F4E84F80E994,F4E84F80E995,ZTEGD97A7BA8$ZTE3ANNR2Q31733,F4E84F839BBE,F4E84F839BBF,ZTEGD97AEEAF$ZTE3ANNQ9J09490,843C992CAFA1,843C992CAFA2,ZTEGD7BB2DBD$ZTE3ANNR8C28071,3891485118F1,3891485118F2,ZTEGDB08EE17$ZTE3ANNQ9J15343,843C992D38CF,843C992D38D0,ZTEGD7BB449A$ZTE3ANNRC560689,6C11BA67B83D,6C11BA67B83E,ZTEGDC6F02D0$ZTE3ANNR9F14339,D89A0DA42DF5,D89A0DA42DF6,ZTEGDB155F4E$ZTE3ANNT2V84857,D831399353AE,D831399353AF,ZTEGDD313DF8$ZTE3ANNRAD30093,D89A0DB09BB1,D89A0DB09BB2,ZTEGDB177198$ZTE3ANNRC554226,6C11BA6720C3,6C11BA6720C4,ZTEGDC6EE991$ZTE3ANNT2V12211,D831398CAD0A,D831398CAD0B,ZTEGDD302232$ZTE3ANNQ7507766,C4EBFF8BA940,C4EBFF8BA941,ZTEGD70A6CF6$ZTE3ANNT3J10617,D83139A0E428,D83139A0E429,ZTEGDD3380B7$ZTE3ANNQ9J07955,843C992C8BA7,843C992C8BA8,ZTEGD7BB27BE$ZTE3ANNT3H83903,D831399E7212,D831399E7213,ZTEGDD33185E$ZTE3ANNR3J30415,F4E84F89173A,F4E84F89173B,ZTEGD97BD899$ZTE3ANNRAM42088,5872C98B12A9,5872C98B12AA,ZTEGDC60A467$ZTE3ANNT3H01583,D8313996E8B2,D8313996E8B3,ZTEGDD31D6CE$ZTE3ANNT3H17846,D831399865DC,D831399865DD,ZTEGDD321655$ZTE3ANNRCP34303,6C11BA6C4EC9,6C11BA6C4ECA,ZTEGDC6FC692$ZTE3ANNR7B55331,3891484DFD79,3891484DFD7A,ZTEGDB086983$ZTE3ANNR9W41138,D89A0DAC204F,D89A0DAC2050,ZTEGDB16B25D$ZTE3ANNR9W44583,D89A0DAC710D,D89A0DAC710E,ZTEGDB16BFD2$ZTE3ANNR3Y13303,4896D950F882,4896D950F883,ZTEGD97E64AC$ZTE3ANNQ8M19033,843C99208601,843C99208602,ZTEGD7BA91C6$ZTE3ANNRC552172,6C11BA66F09F,6C11BA66F0A0,ZTEGDC6EE18B$ZTE3ANNR7B38942,3891484C7D5B,3891484C7D5C,ZTEGDB08297E$ZTE3ANNRC575883,6C11BA691C59,6C11BA691C5A,ZTEGDC6F3E2A$ZTE3ANNQ8M07737,843C991F7D41,843C991F7D42,ZTEGD7BA65A6$ZTE3ANNQ4N02080,3CF9F0A8C26E,3CF9F0A8C26F,ZTEGD6410B1B$ZTE3ANNR2Q31630,F4E84F839954,F4E84F839955,ZTEGD97AEE48$ZTE3ANNQ9J07706,843C992C85D1,843C992C85D2,ZTEGD7BB26C5$ZTE3ANNR3Y01464,4896D94FE308,4896D94FE309,ZTEGD97E366D$ZTE3ANNQ8111210,689E29BCE587,689E29BCE588,ZTEGD7B7665A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 13:58:58 Duration: 4s356ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251863, 304, '834284941000654,241631308202,241628286784,241617544142,241677771738,241631087394,241597366067,241701283538,241699370827,241649192439,230048413647,241669498001,241649362029,241701256464,230049276671,241677774566,241710334960,241649329904,241608701933,241666240624,241601558395,241703863240,241674544666,241673070516,241656316579,241629242950,241605340707,241603055152,241604999405,241649362534,241639128000,241674265065,241665832626,241661094251,241596617172,241672334147,241620272647,241658125768,230047935059,241728297992,241649191126', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 14:29:45 Duration: 4s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251304, 504, 'E44E12B38D9D,ZTE3A8TR7R18055C7D21F1522F,ZTE3A8TT2L01399C7D21F240BF,ZTE3A8TT2L16667$E44E12926A2F,ZTE3A8TR5U17146F2A6,ZTE3A8TT3302025D6,ZTE3A8TT3C17753A4862B4,ZTE3A8TR4H20401$B47CA608ED76,ZTE3A8TR8U20277C7D21EB93AF,ZTE3A8TRB709287C7D21F15573,ZTE3A8TT2L01608,ZTE3A8TT3305136AA,ZTE3A8TT3307402$E44E12B1B8AD,ZTE3A8TR7913543E,ZTE3A8TT3307383$E44E12B0EAB5,ZTE3A8TR7900361A476230,ZTE3A8TR4H03984$E44E1292D577,ZTE3A8TR5U24012$E44E12B0A725,ZTE3A8TR6D21537C7D21F15607,ZTE3A8TT2L01645,ZTE3A8TT3305388$B47CA607FC12,ZTE3A8TR8U04828C7D21F23E23,ZTE3A8TT2L16500$E44E12926AE3,ZTE3A8TR5U17191$B47CA608F49A,ZTE3A8TR8U20734$E44E12B2A679,ZTE3A8TR7R03262$DC5193D9634E,ZTE3A8TQCH13842EDA,ZTE3A8TT3310998$E44E12B38D19,ZTE3A8TR7R18022$E44E12B3B631,ZTE3A8TR7R20652C7D21F1707F,ZTE3A8TT2L03339C7D21EB9333,ZTE3A8TRB709256$E44E12B23DC9,ZTE3A8TR7922062$E44E12B0E995,ZTE3A8TR7900289C7D21F2B8C3,ZTE3A8TT2L24348A478604,ZTE3A8TR4H06277C7D21F134DF,ZTE3A8TRCS25023$E44E12B245C5,ZTE3A8TR7922573D36,ZTE3A8TT3310893A4865C4,ZTE3A8TR4H20597$DC5193D96426,ZTE3A8TQCH13896', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-10 08:58:27 Duration: 4s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 355ms 990ms 544ms 74 40s295ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 10 00 1 748ms 748ms 04 2 1s1ms 500ms 07 5 2s73ms 414ms 08 9 4s662ms 518ms 09 7 3s491ms 498ms 10 6 3s944ms 657ms 11 6 3s356ms 559ms 12 2 1s195ms 597ms 13 11 6s210ms 564ms 14 9 5s5ms 556ms 15 7 3s877ms 553ms 16 4 2s97ms 524ms 17 3 1s688ms 562ms 21 2 939ms 469ms [ User: intelifix - Total duration: 40s295ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 40s295ms - Times executed: 74 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-10 10:49:54 Duration: 990ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 72, 1);
Date: 2026-06-10 15:38:10 Duration: 804ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-06-10 10:08:46 Duration: 772ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 13,987 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 2279 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,810 Max number of times the same event was reported
- 2,296 Total events found
Rank Times reported Error 1 1,810 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 10 07 39 08 188 09 242 10 266 11 207 12 65 13 107 14 202 15 210 16 207 17 77 - ERROR: prepared statement "_PLAN0000000027189B90" does not exist
- ERROR: prepared statement "_PLAN0000000027189B90" does not exist
- ERROR: prepared statement "_PLAN0000000029E8ACE0" does not exist
Statement: DEALLOCATE "_PLAN0000000027189B90"
Date: 2026-06-10 07:08:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000027189B90"
Date: 2026-06-10 07:09:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E8ACE0"
Date: 2026-06-10 07:12:19 Database: contagem 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 10 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-10 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-10 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-10 00:25:07 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 10 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-10 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-10 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-10 00:25:07 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 10 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-10 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-10 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-10 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 10 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-10 08:00:27 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-10 08:20:06 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-10 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 10 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-10 08:00:27 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-10 08:20:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-10 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 10 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-10 07:12:39 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-10 08:11:34 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-10 09:12:43 Database: brasilia Application: psql User: intelifix Remote: [local]
8 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 10 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-10 07:12:39 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-10 08:11:34 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-10 09:12:43 Database: brasilia Application: psql User: intelifix Remote: [local]
9 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 10 00 1 03 1 06 1 07 3 11 1 20 1 21 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-06-10 00:02:09 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-10 03:20:51 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-10 06:02:10 Database: testes Application: [unknown] User: lenon Remote: [local]
10 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 10 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-10 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-10 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-10 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
11 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 10 08 2 15 5 - ERROR: syntax error at or near "107412" at character 133
- ERROR: syntax error at or near "107412" at character 133
- ERROR: syntax error at or near "3056946" at character 35
Statement: select * from rs_caixa_qr(t 107412)
Date: 2026-06-10 08:45:16 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(t 107412)
Date: 2026-06-10 08:45:17 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3056946 3056946 )
Date: 2026-06-10 15:39:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 10 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-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-10 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
13 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 10 09 2 13 2 - ERROR: column "t51231008477" does not exist at character 27
- ERROR: column "t51231008477" does not exist at character 27
- ERROR: column "cai_id" does not exist at character 39
Statement: select * from rs_caixa_qr(T51231008477)
Date: 2026-06-10 09:55:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(T51231008477)
Date: 2026-06-10 09:55:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM temp0000226364 ORDER BY CAI_ID DESC
Date: 2026-06-10 13:30:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
14 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 10 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-10 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 10 11 2 - ERROR: trailing junk after numeric literal at or near "2102313BFARYN2927835" at character 27
- ERROR: trailing junk after numeric literal at or near "2102313BFARYN2927835" at character 27
Statement: select * from rs_caixa_qr(2102313BFARYN2927835)
Date: 2026-06-10 11:48:54 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(2102313BFARYN2927835)
Date: 2026-06-10 11:48:54 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
16 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 10 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-10 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-10 06:05:09 Database: brasilia Application: psql User: intelifix Remote: [local]
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 10 03 1 - LOG: database system was shut down at 2026-06-10 03:05:01 -03
Date: 2026-06-10 03:05:02
18 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 10 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() /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(Date: 2026-06-10 18:00:01 Database: brasilia Application: psql 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 10 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-10 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]