pgBadger-
Global information
- Generated on Fri Jun 5 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 38,241 log entries in 7s
- Log start from 2026-06-05 00:02:06 to 2026-06-05 23:45:19
-
Overview
Global Stats
- 313 Number of unique normalized queries
- 6,309 Number of queries
- 7h27m11s Total query duration
- 2026-06-05 00:02:06 First query
- 2026-06-05 23:42:26 Last query
- 5 queries/s at 2026-06-05 10:23:57 Query peak
- 7h27m11s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h27m11s Execute total duration
- 2,236 Number of events
- 18 Number of unique normalized events
- 1,732 Max number of times the same event was reported
- 0 Number of cancellation
- 694 Total number of automatic vacuums
- 1,183 Total number of automatic analyzes
- 38 Number temporary file
- 104.00 MiB Max size of temporary file
- 103.64 MiB Average size of temporary file
- 200 Total number of sessions
- 6 sessions at 2026-06-05 13:08:48 Session peak
- 7d15h44m Total duration of sessions
- 55m7s Average duration of sessions
- 31 Average queries per session
- 2m14s Average queries duration per session
- 52m53s Average idle time per session
- 607 Total number of connections
- 4 connections/s at 2026-06-05 06:02:06 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-05 10:23:57 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-05 09:08:43 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-05 20:08:20 Date
Queries duration
Key values
- 7h27m11s 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 05 00 12 0ms 25s909ms 7s19ms 1m3s 1m3s 1m3s 01 6 0ms 3s183ms 2s839ms 3s183ms 3s183ms 3s183ms 02 6 2s491ms 3s134ms 2s785ms 3s134ms 3s134ms 3s134ms 03 6 0ms 3s525ms 2s679ms 3s525ms 3s525ms 3s525ms 04 6 0ms 2s988ms 2s835ms 2s988ms 2s988ms 2s988ms 05 8 0ms 8m25s 1m21s 2m4s 8m25s 8m25s 06 50 0ms 32s754ms 3s292ms 31s221ms 38s589ms 38s589ms 07 466 150ms 11m6s 6s204ms 1m50s 4m11s 11m23s 08 827 150ms 7m53s 2s839ms 55s898ms 4m22s 7m59s 09 626 150ms 12m21s 4s446ms 1m30s 4m32s 12m29s 10 760 150ms 6m48s 3s102ms 1m13s 4m20s 6m51s 11 756 150ms 9m13s 3s417ms 1m30s 4m16s 9m20s 12 131 0ms 5m40s 5s856ms 58s106ms 1m1s 5m42s 13 593 0ms 5m30s 3s658ms 43s487ms 4m46s 5m59s 14 994 150ms 9m13s 2s857ms 1m31s 2m18s 10m29s 15 549 150ms 8m41s 2s682ms 55s187ms 1m43s 8m49s 16 103 0ms 6m13s 6s476ms 20s377ms 42s47ms 6m43s 17 56 0ms 5m54s 7s801ms 3s182ms 36s400ms 5m54s 18 11 0ms 5m9s 32s342ms 3s418ms 5m37s 5m37s 19 10 0ms 5m25s 37s455ms 3s256ms 5m54s 5m54s 20 71 0ms 9m28s 15s330ms 2m2s 9m28s 9m28s 21 22 0ms 5m29s 17s885ms 32s597ms 5m29s 5m29s 22 16 0ms 5m37s 24s991ms 33s924ms 5m37s 5m37s 23 224 0ms 1m51s 8s650ms 1m17s 1m36s 1m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 05 00 2 0 3s163ms 0ms 6s327ms 6s327ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 9 0 919ms 932ms 1s217ms 5s458ms 07 346 0 6s789ms 48s116ms 1m33s 6m29s 08 664 0 2s740ms 14s520ms 55s898ms 5m6s 09 506 0 4s525ms 27s753ms 1m17s 4m32s 10 554 0 3s145ms 24s5ms 1m3s 4m11s 11 614 0 3s518ms 17s876ms 1m24s 5m23s 12 88 0 7s614ms 7s649ms 45s339ms 5m40s 13 455 0 3s589ms 7s934ms 24s179ms 4m17s 14 839 0 2s697ms 56s700ms 1m9s 4m14s 15 435 0 2s899ms 12s208ms 30s155ms 2m29s 16 72 0 8s262ms 3s557ms 7s393ms 50s73ms 17 42 0 9s889ms 1s399ms 2s337ms 5m54s 18 5 0 1m7s 0ms 546ms 5m37s 19 4 0 1m29s 0ms 1s560ms 5m54s 20 9 56 16s375ms 1m10s 2m1s 9m28s 21 11 0 33s267ms 819ms 32s597ms 5m29s 22 4 0 1m32s 0ms 33s924ms 5m37s 23 5 219 8s650ms 1m10s 1m17s 1m51s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 05 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 05 00 0 0 0.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 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 7 7.00 0.00% 08 0 10 10.00 0.00% 09 0 10 10.00 0.00% 10 0 8 8.00 0.00% 11 0 13 13.00 0.00% 12 0 2 2.00 0.00% 13 0 10 10.00 0.00% 14 0 11 11.00 0.00% 15 0 4 4.00 0.00% 16 0 4 4.00 0.00% 17 0 2 2.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 05 00 22 0.01/s 01 17 0.00/s 02 17 0.00/s 03 18 0.01/s 04 18 0.01/s 05 22 0.01/s 06 24 0.01/s 07 29 0.01/s 08 35 0.01/s 09 32 0.01/s 10 37 0.01/s 11 33 0.01/s 12 25 0.01/s 13 35 0.01/s 14 36 0.01/s 15 28 0.01/s 16 30 0.01/s 17 26 0.01/s 18 24 0.01/s 19 23 0.01/s 20 26 0.01/s 21 25 0.01/s 22 22 0.01/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jun 05 00 4 57m35s 57m14s 01 6 1h1m 1h57s 02 3 1h 59m55s 03 5 24m38s 24m35s 04 3 1h1m 1h54s 05 3 56m40s 53m4s 06 4 47m30s 46m49s 07 8 58m25s 52m24s 08 13 57m19s 54m18s 09 15 59m12s 56m6s 10 14 57m6s 54m18s 11 20 47m57s 45m48s 12 12 56m4s 55m 13 5 1h1m17s 54m3s 14 18 54m54s 52m17s 15 16 59m 57m28s 16 10 57m35s 56m28s 17 10 1h2m23s 1h1m39s 18 8 54m10s 53m25s 19 3 1h1s 57m56s 20 6 38m22s 35m20s 21 4 1h2m 1h22s 22 5 1h36s 59m16s 23 5 43m5s 36m37s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-05 06:02:06 Date
Connections per database
Key values
- brasilia Main Database
- 607 connections Total
Connections per user
Key values
- intelifix Main User
- 607 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-05 13:08:48 Date
Histogram of session times
Key values
- 163 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 200 sessions Total
Sessions per user
Key values
- intelifix Main User
- 200 sessions Total
Sessions per host
Key values
- [local] Main Host
- 200 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,725 buffers Checkpoint Peak
- 2026-06-05 07:44:37 Date
- 270.022 seconds Highest write time
- 0.117 seconds Sync time
Checkpoints Wal files
Key values
- 18 files Wal files usage Peak
- 2026-06-05 13:44:39 Date
Checkpoints distance
Key values
- 567.54 Mo Distance Peak
- 2026-06-05 13:44:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 05 00 4,156 269.403s 0.002s 269.41s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 6,747 0.369s 0.008s 0.392s 04 0 0s 0s 0s 05 4,368 437.475s 0.011s 437.503s 06 2,181 224.729s 0.006s 224.744s 07 84,020 2,835.637s 0.131s 2,835.901s 08 77,213 3,239.34s 0.228s 3,239.737s 09 68,319 3,239.265s 0.219s 3,239.646s 10 76,938 3,239.311s 0.316s 3,239.818s 11 95,208 3,231.089s 0.31s 3,231.625s 12 21,636 1,339.36s 0.058s 1,339.491s 13 69,399 2,445.776s 0.22s 2,446.151s 14 87,233 3,239.196s 0.283s 3,239.702s 15 45,639 2,859.323s 0.218s 2,859.683s 16 19,834 1,726.687s 0.073s 1,726.83s 17 6,036 605.937s 0.075s 606.067s 18 641 64.412s 0.009s 64.446s 19 21 2.13s 0.002s 2.137s 20 1,316 271.839s 0.009s 271.865s 21 3,938 394.935s 0.139s 395.118s 22 2,081 208.924s 0.019s 208.977s 23 2,975 320.761s 0.011s 320.795s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 05 00 0 0 2 22 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 2 26 0.005s 0.003s 04 0 0 0 0 0s 0s 05 0 0 3 95 0.002s 0.004s 06 0 0 0 144 0.002s 0.002s 07 0 0 56 3,670 0.006s 0.012s 08 0 0 47 4,760 0.015s 0.012s 09 0 0 45 5,955 0.003s 0.012s 10 0 0 59 7,202 0.009s 0.012s 11 0 0 56 7,167 0.007s 0.012s 12 0 0 13 1,672 0.003s 0.011s 13 0 0 58 5,450 0.007s 0.011s 14 0 0 58 7,112 0.008s 0.012s 15 0 0 32 4,618 0.014s 0.012s 16 0 0 10 2,190 0.003s 0.012s 17 0 0 2 1,699 0.003s 0.01s 18 0 0 0 37 0.002s 0.006s 19 0 0 0 4 0.001s 0.001s 20 0 0 2 59 0.002s 0.004s 21 0 0 3 462 0.064s 0.008s 22 0 0 1 422 0.003s 0.007s 23 0 0 1 34 0.003s 0.006s Day Hour Count Avg time (sec) Jun 05 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 05 00 24,284.00 kB 24,284.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 21,994.50 kB 21,994.50 kB 04 0.00 kB 0.00 kB 05 10,065.75 kB 14,967.75 kB 06 5,031.50 kB 21,577.50 kB 07 75,925.92 kB 119,986.42 kB 08 64,074.17 kB 134,525.33 kB 09 61,098.67 kB 85,685.00 kB 10 80,906.75 kB 135,971.08 kB 11 76,974.08 kB 154,309.33 kB 12 21,094.30 kB 86,874.60 kB 13 86,701.00 kB 142,928.45 kB 14 78,637.08 kB 168,537.75 kB 15 43,234.00 kB 111,408.92 kB 16 13,969.08 kB 46,859.67 kB 17 3,722.90 kB 24,769.20 kB 18 428.60 kB 12,438.00 kB 19 164.00 kB 8,992.00 kB 20 5,133.25 kB 15,121.00 kB 21 9,037.57 kB 34,626.14 kB 22 1,592.43 kB 24,399.71 kB 23 3,536.80 kB 14,197.80 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-05 15:05:44 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-05 07:15:44 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 05 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 5 519.98 MiB 104.00 MiB 08 0 0 0 09 6 623.97 MiB 104.00 MiB 10 7 727.97 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 3 311.99 MiB 104.00 MiB 13 0 0 0 14 11 1.12 GiB 104.00 MiB 15 3 298.65 MiB 99.55 MiB 16 2 207.99 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 38 3.85 GiB 90.66 MiB 104.00 MiB 103.64 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025162, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 07:15:50 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025180, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 08:47:21 Duration: 5m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025186, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 09:40:19 Duration: 4m30s 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,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 15:05:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 15:06: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-05 07:06:36 - 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-05 14:34:53 - 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-05 14:40: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-05 14:45:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 14:54:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 14:56:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 14:58:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 16:23:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 14:14:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 14:15:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 10:31:10 - 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-05 07:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 07:52:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 10:09:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 10:12:33 - 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-05 10:38:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 12:14:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-05 07:24:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 37.10 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-06-05 13:37:32 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 37.10 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-06-05 13:37:32 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (161) Main table analyzed (database rio)
- 1,183 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 161 rio.pg_catalog.pg_class 90 rio.pg_catalog.pg_type 80 contagem.pg_catalog.pg_attribute 62 rio.pg_catalog.pg_index 56 rio.public.usuarios 51 rio.pg_catalog.pg_depend 48 rio.public.temp0000281731 46 contagem.pg_catalog.pg_class 44 contagem.pg_catalog.pg_type 37 rio.public.temp0000281715 32 rio.public.temp0000281741 31 rio.public.temp0000281713 25 contagem.pg_catalog.pg_index 25 rio.public.temp0000281745 24 rio.public.temp0000281831 23 contagem.public.usuarios 22 contagem.pg_catalog.pg_depend 20 rio.public.temp0000281743 20 rio.public.temp0000281723 18 rio.public.temp0000281719 17 rio.public.temp0000281753 15 rio.public.temp0000281801 14 rio.public.temp0000281825 14 rio.public.temp0000281769 10 contagem.public.nf_entrada 10 contagem.pg_catalog.pg_shdepend 10 rio.public.temp0000281821 9 rio.pg_catalog.pg_shdepend 9 rio.public.temp0000281327 8 rio.public.temp0000281797 8 rio.public.temp0000281335 7 rio.public.temp0000281739 7 rio.public.temp0000281523 7 rio.public.temp0000281799 6 rio.public.temp0000281717 6 rio.public.temp0000281725 6 postgres.pg_catalog.pg_shdepend 5 rio.public.temp0000281833 5 contagem.public.temp0000226340 5 rio.public.temp0000281747 5 rio.public.temp0000281779 5 template1.pg_catalog.pg_shdepend 5 rio.public.temp0000281721 5 rio.public.temp0000281709 5 rio.public.temp0000281755 5 rio.public.temp0000281839 5 contagem.public.temp0000226346 4 rio.public.temp0000281813 4 contagem.public.temp0000226296 3 rio.public.temp0000281727 3 contagem.public.temp0000226344 3 rio.public.tmp_drill_0175 3 rio.public.temp0000281763 3 contagem.auditor.auditor_2026_06 2 rio.public.temp0000281795 2 rio.public.temp0000281757 2 contagem.public.temp0000226304 2 rio.public.temp0000281773 2 rio.public.temp0000281819 2 rio.public.tmp_drill_0302 2 rio.auditor.auditor_2026_06 2 rio.public.temp0000281815 2 rio.public.temp0000281207 2 rio.public.temp0000281785 1 rio.public.temp0000281793 1 rio.public.temp0000281749 1 rio.public.temp0000281729 1 rio.public.temp0000281817 1 contagem.public.temp0000226294 1 rio.public.temp0000281737 1 rio.public.temp0000281787 1 rio.public.temp0000281789 1 rio.public.temp0000281807 1 contagem.public.parametros 1 rio.public.temp0000281791 1 Total 1,183 Vacuums per table
Key values
- pg_catalog.pg_attribute (114) Main table vacuumed on database rio
- 694 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 114 65 0 0 0 0 0 39,449 8,634 13,852,713 465 11,249 rio.pg_catalog.pg_class 93 49 0 0 0 0 0 9,547 2,172 3,166,032 109 364 rio.pg_catalog.pg_type 76 44 0 0 0 0 0 3,888 911 1,181,762 109 356 rio.public.temp0000281731 47 0 0 0 0 0 0 46,187 303 2,944,818 0 0 rio.pg_catalog.pg_index 35 28 0 0 0 0 0 1,586 470 399,950 62 135 rio.pg_catalog.pg_depend 32 24 0 0 0 0 0 7,690 2,637 3,811,190 130 906 rio.public.temp0000281715 31 0 0 0 0 0 0 24,877 1,656 3,452,517 0 0 contagem.pg_catalog.pg_attribute 29 28 0 0 0 0 0 17,554 4,629 8,067,013 48 1,457 contagem.public.usuarios 22 0 0 0 0 0 0 114 82 44,804 2 2 contagem.pg_catalog.pg_class 17 17 0 0 0 0 0 3,292 902 1,348,361 35 467 contagem.pg_catalog.pg_type 15 15 0 0 0 0 0 1,533 420 641,667 11 28 rio.public.temp0000281825 14 0 0 0 0 0 0 17,095 53 1,016,852 0 0 contagem.pg_catalog.pg_depend 11 11 0 0 0 0 0 2,852 837 1,718,511 8 37 template1.pg_catalog.pg_shdepend 10 10 0 0 0 0 0 1,936 579 1,012,693 133 264 contagem.pg_catalog.pg_index 10 10 0 0 0 0 0 545 199 140,803 8 11 rio.public.temp0000281769 10 0 0 0 0 0 0 756 155 222,520 0 0 rio.pg_catalog.pg_statistic 10 10 0 0 0 0 0 12,559 2,876 13,482,929 1,200 5,014 rio.public.temp0000281327 8 0 0 0 0 0 0 415 44 31,563 0 0 rio.public.temp0000281821 8 0 0 0 0 0 0 4,679 27 280,560 0 0 rio.public.temp0000281523 7 0 0 0 0 0 0 446 37 32,386 0 0 rio.public.temp0000281335 7 0 0 0 0 0 0 573 39 39,776 0 0 rio.public.temp0000281799 6 0 0 0 0 0 0 7,764 23 461,629 0 0 rio.public.usuarios 6 5 0 0 0 0 0 127 32 53,494 6 106 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,324 494 3,130,427 152 548 rio.public.temp0000281839 5 0 0 0 0 0 0 4,667 19 280,158 0 0 contagem.public.temp0000226340 5 0 0 0 0 0 0 455 198 312,337 0 0 contagem.public.nf_entrada 4 4 0 0 0 0 0 340 119 162,677 2 4 rio.public.temp0000281721 4 0 0 0 0 0 0 3,199 17 191,407 0 0 contagem.public.temp0000226346 4 0 0 0 0 0 0 366 109 168,098 0 0 rio.public.temp0000281739 3 0 0 0 0 0 0 24 15 3,979 0 0 rio.auditor.auditor_2026_06 3 0 0 0 0 0 0 122,945 46,534 64,337,577 38,120 820,587 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 88 9 20,111 0 0 rio.public.temp0000281763 3 0 0 0 0 0 0 1,558 10 93,601 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 1,015 19 193,473 1 46 rio.public.temp0000281709 2 0 0 0 0 0 0 130 8 8,876 0 0 rio.public.temp0000281815 2 0 0 0 0 0 0 3,105 8 184,401 0 0 rio.public.temp0000281755 2 0 0 0 0 0 0 132 12 9,369 0 0 rio.public.temp0000281795 2 0 0 0 0 0 0 3,104 8 184,342 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 270 59 223,462 18 43 rio.public.temp0000281773 2 0 0 0 0 0 0 1,556 7 92,945 0 0 rio.public.temp0000281727 2 0 0 0 0 0 0 182 12 12,587 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 148 45 94,644 3 6 rio.public.giga_testes 1 1 0 0 0 0 0 17,435 14,639 51,471,028 147 2,546 rio.public.temp0000281745 1 0 0 0 0 0 0 8 5 1,311 0 0 contagem.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 215 65 107,584 10 16 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,542 512 1,902,170 482 3,617 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 557 191 543,090 163 8,033 rio.public.temp0000281719 1 0 0 0 0 0 0 89 6 6,173 0 0 rio.public.codigos_barra 1 1 0 0 0 0 0 48,322 41,158 216,917,059 77 5,329 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 226 65 131,712 5 5 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 5,645 4,597 6,001,641 446 13,850 rio.public.temp0000281833 1 0 0 0 0 0 0 114 6 7,699 0 0 rio.public.temp0000281749 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.logs 1 0 0 0 0 0 0 677 307 396,805 176 4,322 rio.public.temp0000281801 1 0 0 0 0 0 0 115 6 7,736 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 137 58 201,015 33 6,105 rio.public.temp0000281729 1 0 0 0 0 0 0 89 6 6,173 0 0 rio.public.temp0000281817 1 0 0 0 0 0 0 108 6 7,329 0 0 rio.public.temp0000281819 1 0 0 0 0 0 0 108 6 7,329 0 0 rio.public.notas_fiscais 1 0 0 0 0 0 0 14 11 28,639 1 185 rio.public.temp0000281737 1 0 0 0 0 0 0 38 6 3,054 0 0 rio.public.temp0000281789 1 0 0 0 0 0 0 97 6 6,646 0 0 Total 694 338 0 0 0 0 0 427,674 137,079 404,867,704 42,162 885,638 Vacuum throughput per table
Key values
- public.codigos_barra (37.1) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 5.18 rio.pg_catalog.pg_class 0 0 1.13 rio.pg_catalog.pg_type 0 0 0.5 rio.public.temp0000281731 0 0 1.65 rio.pg_catalog.pg_index 0 0 0.21 rio.pg_catalog.pg_depend 0 0 1.39 rio.public.temp0000281715 0 0 1.37 contagem.pg_catalog.pg_attribute 0 0 1.79 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_class 0 0 0.35 contagem.pg_catalog.pg_type 0 0 0.16 rio.public.temp0000281825 0 0 0.69 contagem.pg_catalog.pg_depend 0 0 0.39 template1.pg_catalog.pg_shdepend 0 0 0.35 contagem.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000281769 0 0 0.14 rio.pg_catalog.pg_statistic 0 0 1.36 rio.public.temp0000281327 0 0 0.07 rio.public.temp0000281821 0 0 0.37 rio.public.temp0000281523 0 0 0.07 rio.public.temp0000281335 0 0 0.07 rio.public.temp0000281799 0 0 0.26 rio.public.usuarios 0 0 4.12 rio.pg_toast.pg_toast_2619 0 0 0.35 rio.public.temp0000281839 0 0 0.25 contagem.public.temp0000226340 0 0 0.06 contagem.public.nf_entrada 0 0 0.05 rio.public.temp0000281721 0 0 0.15 contagem.public.temp0000226346 0 0 0.06 rio.public.temp0000281739 0 0 0.03 rio.auditor.auditor_2026_06 0 0 16.05 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000281763 0 0 0.12 rio.public.tmp_drill_0302 0 0 0.02 rio.public.temp0000281709 0 0 0 rio.public.temp0000281815 0 0 0.09 rio.public.temp0000281755 0 0 0.02 rio.public.temp0000281795 0 0 0.09 contagem.pg_toast.pg_toast_2619 0 0 0.03 rio.public.temp0000281773 0 0 0.07 rio.public.temp0000281727 0 0 0.02 rio.pg_catalog.pg_shdepend 0 0 0.02 rio.public.giga_testes 0 0 13.47 rio.public.temp0000281745 0 0 0 contagem.pg_catalog.pg_shdepend 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.12 rio.public.nf_entrada_arquivo_erros 0 0 0.21 rio.public.temp0000281719 0 0 0.01 rio.public.codigos_barra 0 0 37.1 postgres.pg_catalog.pg_shdepend 0 0 0.05 contagem.auditor.auditor_2026_06 0 0 1.4 rio.public.temp0000281833 0 0 0.01 rio.public.temp0000281749 0 0 0 rio.public.logs 0 0 0.21 rio.public.temp0000281801 0 0 0.01 rio.public.equipamentos_referencia 0 0 0.02 rio.public.temp0000281729 0 0 0.01 rio.public.temp0000281817 0 0 0.01 rio.public.temp0000281819 0 0 0.01 rio.public.notas_fiscais 0 0 0.01 rio.public.temp0000281737 0 0 0 rio.public.temp0000281789 0 0 0.01 Total 0 0 91.89 Tuples removed per table
Key values
- pg_catalog.pg_attribute (342621) Main table with removed tuples on database rio
- 583234 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 114 65 342,621 3,095,429 567,065 960 74,453 contagem.pg_catalog.pg_attribute 29 28 107,654 708,618 6,336 301 15,498 rio.pg_catalog.pg_depend 32 24 23,849 665,520 61,555 0 6,223 rio.pg_catalog.pg_type 76 44 17,914 207,859 35,156 34 5,675 rio.pg_catalog.pg_statistic 10 10 16,883 84,863 409 0 12,860 rio.public.tmp_drill_0302 2 2 15,008 15,008 0 0 378 template1.pg_catalog.pg_shdepend 10 10 10,074 93,684 1,054 0 1,010 rio.pg_catalog.pg_index 35 28 7,662 76,530 8,966 23 2,020 contagem.pg_catalog.pg_depend 11 11 7,468 209,301 2,133 0 1,930 contagem.pg_catalog.pg_type 15 15 5,713 33,729 0 37 969 rio.pg_catalog.pg_class 93 49 5,580 425,209 99,633 60 12,915 contagem.pg_catalog.pg_class 17 17 5,148 59,855 1,526 12 2,125 contagem.pg_catalog.pg_statistic 1 1 4,019 7,274 0 0 1,011 contagem.pg_catalog.pg_index 10 10 2,926 18,969 1 11 531 postgres.pg_catalog.pg_shdepend 1 1 1,344 9,284 0 0 101 contagem.public.usuarios 22 0 1,285 490 0 0 44 contagem.pg_catalog.pg_shdepend 1 1 1,267 9,281 0 0 101 rio.pg_toast.pg_toast_2619 5 5 1,238 3,428 3 116 870 rio.public.codigos_barra 1 1 1,160 9,501,439 0 0 63,637 contagem.public.nf_entrada 4 4 893 5,331 193 2 278 rio.public.nf_entrada_arquivo_erros 1 0 745 8,226,979 0 0 146,452 rio.auditor.auditor_2026_06 3 0 708 13,891,013 0 0 640,377 rio.pg_catalog.pg_shdepend 1 1 668 10,283 999 0 101 rio.public.giga_testes 1 1 571 3,614,293 0 0 95,439 rio.public.usuarios 6 5 413 3,815 779 1 96 rio.public.tmp_drill_0175 3 3 262 843 0 0 23 contagem.pg_toast.pg_toast_2619 2 2 161 240 0 12 100 rio.public.temp0000281739 3 0 0 4,959 0 114 270 rio.public.temp0000281745 1 0 0 1,483 0 45 83 rio.public.temp0000281721 4 0 0 67,009 0 47 4,881 rio.public.temp0000281709 2 0 0 2,012 0 0 128 rio.public.temp0000281815 2 0 0 43,701 0 0 3,200 rio.public.temp0000281715 31 0 0 676,716 0 0 49,600 rio.public.temp0000281755 2 0 0 5,625 0 76 116 rio.public.temp0000281839 5 0 0 109,302 0 0 8,000 rio.public.temp0000281719 1 0 0 1,435 0 47 81 rio.public.temp0000281763 3 0 0 65,464 0 0 4,800 rio.public.temp0000281523 7 0 0 33,149 0 144 752 rio.public.temp0000281731 47 0 0 722,969 0 589 52,531 contagem.auditor.auditor_2026_06 1 0 0 662,889 0 0 29,100 rio.public.temp0000281833 1 0 0 2,067 0 22 106 rio.public.temp0000281795 2 0 0 43,690 0 0 3,200 rio.public.temp0000281749 1 0 0 1,035 0 0 64 rio.public.temp0000281327 8 0 0 33,024 0 281 743 rio.public.logs 1 0 0 15,815,321 0 0 631,816 rio.public.temp0000281801 1 0 0 4,780 0 21 107 rio.public.temp0000281825 14 0 0 306,000 0 0 22,400 contagem.public.temp0000226346 4 0 0 4,340 0 179 333 rio.public.equipamentos_referencia 1 0 0 5,018,100 0 0 27,126 rio.public.temp0000281729 1 0 0 1,435 0 47 81 contagem.public.temp0000226340 5 0 0 5,395 0 225 415 rio.public.temp0000281817 1 0 0 1,886 0 28 100 rio.public.temp0000281773 2 0 0 43,687 0 0 3,200 rio.public.temp0000281821 8 0 0 174,847 0 0 12,800 rio.public.temp0000281819 1 0 0 1,886 0 28 100 rio.public.temp0000281727 2 0 0 2,974 0 90 166 rio.public.notas_fiscais 1 0 0 161,091 0 0 872 rio.public.temp0000281737 1 0 0 1,332 0 2 30 rio.public.temp0000281799 6 0 0 131,076 0 0 9,600 rio.public.temp0000281769 10 0 0 33,537 0 397 755 rio.public.temp0000281335 7 0 0 27,484 0 208 624 rio.public.temp0000281789 1 0 0 3,963 0 39 89 Total 694 338 583,234 65,194,230 785,808 4,198 1,953,486 Pages removed per table
Key values
- pg_catalog.pg_attribute (960) Main table with removed pages on database rio
- 4198 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 114 65 342621 960 rio.public.temp0000281731 47 0 0 589 rio.public.temp0000281769 10 0 0 397 contagem.pg_catalog.pg_attribute 29 28 107654 301 rio.public.temp0000281327 8 0 0 281 contagem.public.temp0000226340 5 0 0 225 rio.public.temp0000281335 7 0 0 208 contagem.public.temp0000226346 4 0 0 179 rio.public.temp0000281523 7 0 0 144 rio.pg_toast.pg_toast_2619 5 5 1238 116 rio.public.temp0000281739 3 0 0 114 rio.public.temp0000281727 2 0 0 90 rio.public.temp0000281755 2 0 0 76 rio.pg_catalog.pg_class 93 49 5580 60 rio.public.temp0000281721 4 0 0 47 rio.public.temp0000281719 1 0 0 47 rio.public.temp0000281729 1 0 0 47 rio.public.temp0000281745 1 0 0 45 rio.public.temp0000281789 1 0 0 39 contagem.pg_catalog.pg_type 15 15 5713 37 rio.pg_catalog.pg_type 76 44 17914 34 rio.public.temp0000281817 1 0 0 28 rio.public.temp0000281819 1 0 0 28 rio.pg_catalog.pg_index 35 28 7662 23 rio.public.temp0000281833 1 0 0 22 rio.public.temp0000281801 1 0 0 21 contagem.pg_catalog.pg_class 17 17 5148 12 contagem.pg_toast.pg_toast_2619 2 2 161 12 contagem.pg_catalog.pg_index 10 10 2926 11 contagem.public.nf_entrada 4 4 893 2 rio.public.temp0000281737 1 0 0 2 rio.public.usuarios 6 5 413 1 rio.pg_catalog.pg_shdepend 1 1 668 0 rio.public.tmp_drill_0302 2 2 15008 0 rio.public.giga_testes 1 1 571 0 template1.pg_catalog.pg_shdepend 10 10 10074 0 contagem.pg_catalog.pg_shdepend 1 1 1267 0 rio.public.temp0000281709 2 0 0 0 rio.auditor.auditor_2026_06 3 0 708 0 rio.public.temp0000281815 2 0 0 0 rio.public.temp0000281715 31 0 0 0 rio.public.tmp_drill_0175 3 3 262 0 contagem.pg_catalog.pg_statistic 1 1 4019 0 rio.public.nf_entrada_arquivo_erros 1 0 745 0 contagem.public.usuarios 22 0 1285 0 rio.public.temp0000281839 5 0 0 0 rio.public.codigos_barra 1 1 1160 0 rio.public.temp0000281763 3 0 0 0 rio.pg_catalog.pg_depend 32 24 23849 0 postgres.pg_catalog.pg_shdepend 1 1 1344 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.public.temp0000281795 2 0 0 0 rio.public.temp0000281749 1 0 0 0 rio.public.logs 1 0 0 0 rio.public.temp0000281825 14 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 rio.public.temp0000281773 2 0 0 0 rio.public.temp0000281821 8 0 0 0 rio.public.notas_fiscais 1 0 0 0 rio.public.temp0000281799 6 0 0 0 rio.pg_catalog.pg_statistic 10 10 16883 0 contagem.pg_catalog.pg_depend 11 11 7468 0 Total 694 338 583,234 4,198 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 4 0 06 6 7 07 88 87 08 65 106 09 64 118 10 109 199 11 88 152 12 17 31 13 51 126 14 99 212 15 70 86 16 22 36 17 10 22 18 0 0 19 0 0 20 0 0 21 1 1 22 0 0 23 0 0 - 37.10 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 4 2m23s 13s992ms 1m 35s808ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 13:36:12 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 10:26:11 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 00:05:21 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s546ms 1s546ms 1s546ms 1s546ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40239, 413, '246329668092', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-05 08:54:44 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249667, 450, '255100117482026,216539329401,216605273233,216530367078,216890530209,216823652840,216847518692,216830665656,216362380606,216565131527,216855008100,216827099607,216441392638,216843677588,216687570222,216338688204,216783432136,216803781518,216525833550,216828954962,216842853535,216539002445,216886030118,216448908690,216526341838,216605926787,216853207676,216472346264,216895683753,216542542532,216683944446,216895263353,216528844562,216882619616,216810990415,216568438000,216855480425,216805358911,216850208507,216901269416,216822531530', '',064,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-05 15:29:25 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248831, 450, 'CP240932MWG,08C7F52E85E8,544D424200785C95,08C7F52E85EB$CP232232328,D4925EB34B03,544D4242006B98CB,D4925EB34B06$CP2239323HZ,A0B53CC09F33,544D4242005E7C18,A0B53CC09F36$CP240432HVA,08C7F52799DA,544D42420077629B,08C7F52799DD$CP234232NQK,D4925EF8DEA3,544D424200724208,D4925EF8DEA6$CP23253226Z,D4925EC9667F,544D4242006D0359,D4925EC96682$CP23423257C,D4925EF63FE4,544D42420071F781,D4925EF63FE7$CP24113237C,08C7F52FFBCB,544D424200788620,08C7F52FFBCE$CP240432685,08C7F525DC24,544D424200773115,08C7F525DC27$CP234532ET9,08C7F5040A6A,544D42420073710F,08C7F5040A6D$CP2319327R4,D4925EA0ADD6,544D42420069A9B0,D4925EA0ADD9$CP230232HE5,D4925E08BC0D,544D42420061E02A,D4925E08BC10$CP2319328LK,D4925EA0CED9,544D42420069AD5B,D4925EA0CEDC$CP232232CKY,D4925EBD5129,544D4242006BC15C,D4925EBD512C$CP234532EHY,08C7F503FF96,544D424200736FDB,08C7F503FF99$CP240332FA3,08C7F5231831,544D42420076E26E,08C7F5231834$CP230232PV9,D4925E09B34E,544D42420061FBA3,D4925E09B351$CP23013208A,D4925E016CAF,544D4242006110F6,D4925E016CB2$CP230232PWW,D4925E09B534,544D42420061FBD9,D4925E09B537$CP2319327MT,D4925EA0AA01,544D42420069A943,D4925EA0AA04$CP2319327SV,D4925EA0AFE0,544D42420069A9EA,D4925EA0AFE3$CP24043214P,08C7F52518B5,544D424200771B5E,08C7F52518B8$CP234532FT6,08C7F5043098,544D42420073754D,08C7F504309B$CP232032JMT,D4925EA64D9F,544D42420069FF8D,D4925EA64DA2$CP2320327BY,D4925EA49D06,544D42420069CF7C,D4925EA49D09$CP2319327QK,D4925EA0AD34,544D42420069A99E,D4925EA0AD37$CP240432HA3,08C7F5278390,544D424200776021,08C7F5278393$CP2250321MD,A0B53CF9643A,544D42420060AEF0,A0B53CF9643D$CP2409325LV,08C7F52C1633,544D424200781748,08C7F52C1636$CP230232L49,D4925E092372,544D42420061EBA7,D4925E092375$CP230132V3J,D4925E05BDB7,544D424200618BBE,D4925E05BDBA$CP232232CHK,D4925EBD4E6B,544D4242006BC10E,D4925EBD4E6E$CP24043273S,08C7F525FD5D,544D4242007734C6,08C7F525FD60$CP232532D9W,D4925ECCA54B,544D4242006D4BE9,D4925ECCA54E$CP233032F19,D4925EE41534,544D4242006E8985,D4925EE41537$CP2301327JQ,D4925E0284BD,544D424200613014,D4925E0284C0$CP2302323KA,D4925E06AA09,544D42420061A546,D4925E06AA0C$CP23223225M,D4925EB328AA,544D4242006B94FA,D4925EB328AD$CP23203221C,D4925EA3D154,544D42420069B8DA,D4925EA3D157$CP2407321KS,08C7F52966FB,544D42420077D3BC,08C7F52966FE', '',0298,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-05 10:37:16 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-05 13:36:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 54s309ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-05 10:26:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 14s317ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-05 09:05:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 13s992ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-05 08:05:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 1s546ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40146, 407, '2102312JCYRYL3902891,541310DD7F88,485754430E32ADA2$2102312JCYRYL3901371,541310DD1D0D,485754430E2CE2A2$2102312JCYRYL4901540,30FD6515E1B1,4857544342F73CA2', '',0147,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$','', 00);[ Date: 2026-06-05 09:37:45 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,664 Total read queries
- 1,440 Total write queries
Queries by database
Key values
- rio Main database
- 5,498 Requests
- 7h11m42s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,219 Requests
User Request type Count Duration etiquetas Total 13 2s400ms select 13 2s400ms intelifix Total 6,219 7h26m25s copy to 275 39m19s ddl 1,165 56m26s others 205 29m57s select 4,574 5h20m42s lenon Total 77 43s882ms select 77 43s882ms Duration by user
Key values
- 7h26m25s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 13 2s400ms select 13 2s400ms intelifix Total 6,219 7h26m25s copy to 275 39m19s ddl 1,165 56m26s others 205 29m57s select 4,574 5h20m42s lenon Total 77 43s882ms select 77 43s882ms Queries by host
Key values
- [local] Main host
- 6,309 Requests
- 7h27m11s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,608 Requests
- 3h56m12s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-05 08:45:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,416 100-500ms duration
Slowest individual queries
Rank Duration Query 1 12m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 09:17:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 07:16:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 20:14:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 11:14:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 14:14:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 15:13:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m25s analyze verbose;[ Date: 2026-06-05 05:08:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 08:12:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 10:11:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 16:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 17:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025162, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-05 07:15:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 12:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 22:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 13:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 21:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 19:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-05 18:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025180, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-05 08:47:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025186, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-05 09:40:19 - 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 2h4m59s 249 154ms 5m42s 30s119ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 05 07 30 18m53s 37s792ms 08 37 14m16s 23s146ms 09 23 18m 46s975ms 10 28 14m33s 31s205ms 11 39 18m41s 28s762ms 12 8 3m21s 25s207ms 13 29 16m13s 33s558ms 14 39 14m15s 21s926ms 15 9 4m44s 31s571ms 16 6 1m57s 19s633ms 17 1 1s604ms 1s604ms [ User: intelifix - Total duration: 2h4m59s - Times executed: 249 ]
[ Application: [unknown] - Total duration: 2h4m59s - Times executed: 249 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025162, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 07:15:50 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025180, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 08:47:21 Duration: 5m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025186, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 09:40:19 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h26s 32 983ms 12m21s 3m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 05 07 2 11m11s 5m35s 08 2 7m56s 3m58s 09 2 12m25s 6m12s 10 2 6m49s 3m24s 11 2 9m16s 4m38s 12 2 5m41s 2m50s 13 2 5m32s 2m46s 14 2 9m15s 4m37s 15 2 8m48s 4m24s 16 2 6m14s 3m7s 17 2 5m56s 2m58s 18 2 5m10s 2m35s 19 2 5m26s 2m43s 20 2 9m31s 4m45s 21 2 5m31s 2m45s 22 2 5m38s 2m49s [ User: intelifix - Total duration: 2h26s - Times executed: 32 ]
[ Application: psql - Total duration: 2h26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-05 09:17:22 Duration: 12m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-05 07:16:08 Duration: 11m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-05 20:14:30 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
3 23m46s 1,641 150ms 8s436ms 869ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 05 07 88 1m17s 882ms 08 202 2m21s 698ms 09 153 2m41s 1s53ms 10 187 2m28s 792ms 11 202 2m33s 759ms 12 53 28s876ms 544ms 13 110 1m21s 740ms 14 269 4m33s 1s16ms 15 314 4m56s 944ms 16 35 41s551ms 1s187ms 17 28 22s993ms 821ms [ User: intelifix - Total duration: 23m46s - Times executed: 1641 ]
[ Application: [unknown] - Total duration: 23m46s - Times executed: 1641 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40239, 413, '246329668092', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-05 08:54:44 Duration: 8s436ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249667, 450, '255100117482026,216539329401,216605273233,216530367078,216890530209,216823652840,216847518692,216830665656,216362380606,216565131527,216855008100,216827099607,216441392638,216843677588,216687570222,216338688204,216783432136,216803781518,216525833550,216828954962,216842853535,216539002445,216886030118,216448908690,216526341838,216605926787,216853207676,216472346264,216895683753,216542542532,216683944446,216895263353,216528844562,216882619616,216810990415,216568438000,216855480425,216805358911,216850208507,216901269416,216822531530', '',064,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-05 15:29:25 Duration: 6s386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248831, 450, 'CP240932MWG,08C7F52E85E8,544D424200785C95,08C7F52E85EB$CP232232328,D4925EB34B03,544D4242006B98CB,D4925EB34B06$CP2239323HZ,A0B53CC09F33,544D4242005E7C18,A0B53CC09F36$CP240432HVA,08C7F52799DA,544D42420077629B,08C7F52799DD$CP234232NQK,D4925EF8DEA3,544D424200724208,D4925EF8DEA6$CP23253226Z,D4925EC9667F,544D4242006D0359,D4925EC96682$CP23423257C,D4925EF63FE4,544D42420071F781,D4925EF63FE7$CP24113237C,08C7F52FFBCB,544D424200788620,08C7F52FFBCE$CP240432685,08C7F525DC24,544D424200773115,08C7F525DC27$CP234532ET9,08C7F5040A6A,544D42420073710F,08C7F5040A6D$CP2319327R4,D4925EA0ADD6,544D42420069A9B0,D4925EA0ADD9$CP230232HE5,D4925E08BC0D,544D42420061E02A,D4925E08BC10$CP2319328LK,D4925EA0CED9,544D42420069AD5B,D4925EA0CEDC$CP232232CKY,D4925EBD5129,544D4242006BC15C,D4925EBD512C$CP234532EHY,08C7F503FF96,544D424200736FDB,08C7F503FF99$CP240332FA3,08C7F5231831,544D42420076E26E,08C7F5231834$CP230232PV9,D4925E09B34E,544D42420061FBA3,D4925E09B351$CP23013208A,D4925E016CAF,544D4242006110F6,D4925E016CB2$CP230232PWW,D4925E09B534,544D42420061FBD9,D4925E09B537$CP2319327MT,D4925EA0AA01,544D42420069A943,D4925EA0AA04$CP2319327SV,D4925EA0AFE0,544D42420069A9EA,D4925EA0AFE3$CP24043214P,08C7F52518B5,544D424200771B5E,08C7F52518B8$CP234532FT6,08C7F5043098,544D42420073754D,08C7F504309B$CP232032JMT,D4925EA64D9F,544D42420069FF8D,D4925EA64DA2$CP2320327BY,D4925EA49D06,544D42420069CF7C,D4925EA49D09$CP2319327QK,D4925EA0AD34,544D42420069A99E,D4925EA0AD37$CP240432HA3,08C7F5278390,544D424200776021,08C7F5278393$CP2250321MD,A0B53CF9643A,544D42420060AEF0,A0B53CF9643D$CP2409325LV,08C7F52C1633,544D424200781748,08C7F52C1636$CP230232L49,D4925E092372,544D42420061EBA7,D4925E092375$CP230132V3J,D4925E05BDB7,544D424200618BBE,D4925E05BDBA$CP232232CHK,D4925EBD4E6B,544D4242006BC10E,D4925EBD4E6E$CP24043273S,08C7F525FD5D,544D4242007734C6,08C7F525FD60$CP232532D9W,D4925ECCA54B,544D4242006D4BE9,D4925ECCA54E$CP233032F19,D4925EE41534,544D4242006E8985,D4925EE41537$CP2301327JQ,D4925E0284BD,544D424200613014,D4925E0284C0$CP2302323KA,D4925E06AA09,544D42420061A546,D4925E06AA0C$CP23223225M,D4925EB328AA,544D4242006B94FA,D4925EB328AD$CP23203221C,D4925EA3D154,544D42420069B8DA,D4925EA3D157$CP2407321KS,08C7F52966FB,544D42420077D3BC,08C7F52966FE', '',0298,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-05 10:37:16 Duration: 6s128ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 17m12s 103 8s114ms 12s25ms 10s20ms create table temp0000281731 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 05 07 16 2m33s 9s595ms 08 25 4m13s 10s122ms 09 13 2m12s 10s196ms 10 16 2m40s 10s12ms 11 9 1m30s 10s15ms 13 18 2m59s 9s992ms 14 6 1m2s 10s468ms [ User: intelifix - Total duration: 17m12s - Times executed: 103 ]
[ Application: [unknown] - Total duration: 17m12s - Times executed: 103 ]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 11:24:18 Duration: 12s25ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:19:50 Duration: 11s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 10:35:04 Duration: 11s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 12m38s 31 435ms 1m21s 24s478ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 05 07 2 1m23s 41s520ms 08 2 1m 30s323ms 09 2 1m8s 34s104ms 10 2 38s904ms 19s452ms 11 2 1m2s 31s223ms 12 2 38s147ms 19s73ms 13 2 27s740ms 13s870ms 14 2 1m5s 32s897ms 15 2 1m4s 32s208ms 16 2 30s157ms 15s78ms 17 2 30s709ms 15s354ms 18 2 26s843ms 13s421ms 19 2 30s95ms 15s47ms 20 1 1m7s 1m7s 21 2 31s310ms 15s655ms 22 2 32s450ms 16s225ms [ User: intelifix - Total duration: 12m38s - Times executed: 31 ]
[ Application: psql - Total duration: 12m38s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-05 07:17:29 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-05 20:15:38 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-05 09:18:28 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
6 11m23s 1,119 153ms 3s437ms 610ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 05 07 83 56s581ms 681ms 08 192 2m20s 733ms 09 143 1m22s 576ms 10 154 1m37s 631ms 11 177 1m35s 540ms 13 146 1m30s 622ms 14 206 1m49s 530ms 15 18 10s410ms 578ms [ User: intelifix - Total duration: 11m23s - Times executed: 1119 ]
[ Application: [unknown] - Total duration: 11m23s - Times executed: 1119 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "320", "itens" : "241593995873,241617949715,241594016683,241621255054,241593082238,230049209617,241622827272,241605991736,241601488691,241616049204,230047889094,230049080110,241622843032,230043673353,241607805066,241621173453,241622818709,241596111434,241615916587,230048003854,241607071729,241595813346,241614918903,241607811835,241631329517,241617564245,241620307172,230049033943,241610124866,241617504363,241596221826", "usuario" : "405", "caixa" : "1220100", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-05 08:34:19 Duration: 3s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249428", "modelo" : "464", "itens" : "241767700829,241746477892,241744867084,241760066379,241767691737,241764853042,241767403650,241770110110,241770102028,241764831020,241770095057,241745542639,241745328498,241777683340,241767688099,241747708911,241738452340,241747561927,241742641739,241770155568,241738389606,241767538993,241770182642,241760221625,241764874862,241738388696,241742591330,241688044558,241763304866,241745746777,241747509294,241747516265,241761424660,241747109705,241760173943,241761497697,241767467292,241742562438,241767431835,241767786167,241747510407,241747503840,241747504345,241747504143,241767539802,241747718484,241767412338,241746146973,241745623859,241747664563,241767394255,241742548799,241767480022,241747658198,241767473152,241767700526,241746146064,241747323845,241767492828,241767798390,241777787693,241738354148,241745584057,241746129395,241767737475,241767696484,241770179611,241767477798,241746149397,241746177380,241767536973,241745571733,241764653247,241764887893,241745474854,241767488608,241745636082,241761229714,241687963338,241761136068,241764869306,241767472243,241777713646,241767516769,241770170520,241745315972,241770099097,241738445975,241763322343,241747554350", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-05 10:09:27 Duration: 3s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249164", "modelo" : "320", "itens" : "835209931000147,241639105270,834121918001659,835045907000661,835162924005788,835164924000596,835146922003269,835135920002791,834144921000371,836016903003982,834232934000851,835226933004838,835140921000489,835083913002207,836038906004135,835245936001506,835071911003830,834352951001697,835051908001633,835216932002808,835197929000578,835176926002407,835077912002007,835233934003606,834295943001126,835234934000411,241709658092,835153923000889,836061910000321,835093914000323,835098915001615,834075911003388,835231934005175,835098915002611,835098915003678,834325947001070,836041907002066,834325947001906,835045907000584,835132920002829,835157923002587,836061910000366,835247936002206,835076912002797,834164924001557,834256937000112,834205930000865,835203930002845", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-05 08:29:33 Duration: 3s95ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10m30s 2 2m4s 8m25s 5m15s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 05 05 2 10m30s 5m15s [ User: intelifix - Total duration: 10m30s - Times executed: 2 ]
[ Application: psql - Total duration: 10m30s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-05 05:08:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-05 05:10:31 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql
8 9m55s 137 2s468ms 1m5s 4s343ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 05 00 6 34s82ms 5s680ms 01 6 17s34ms 2s839ms 02 6 16s711ms 2s785ms 03 5 15s522ms 3s104ms 04 6 17s13ms 2s835ms 05 6 18s665ms 3s110ms 06 6 15s818ms 2s636ms 07 6 19s954ms 3s325ms 08 6 35s603ms 5s933ms 09 6 36s432ms 6s72ms 10 6 1m14s 12s496ms 11 6 19s91ms 3s181ms 12 6 17s921ms 2s986ms 13 6 1m22s 13s718ms 14 6 21s76ms 3s512ms 15 6 21s560ms 3s593ms 16 6 17s679ms 2s946ms 17 6 16s560ms 2s760ms 18 6 17s934ms 2s989ms 19 6 18s99ms 3s16ms 20 6 24s75ms 4s12ms 21 6 17s15ms 2s835ms 22 6 19s873ms 3s312ms [ User: intelifix - Total duration: 9m55s - Times executed: 137 ]
[ Application: psql - Total duration: 9m55s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 13:36:12 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 10:26:11 Duration: 58s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 00:05:21 Duration: 19s190ms Database: rio User: intelifix Remote: [local] Application: psql
9 9m47s 55 8s77ms 46s599ms 10s685ms create table temp0000281715 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 05 07 15 2m57s 11s829ms 08 1 10s649ms 10s649ms 09 12 2m11s 10s939ms 10 18 2m59s 9s959ms 11 9 1m29s 9s895ms [ User: intelifix - Total duration: 9m47s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 55 ]
-
CREATE TABLE temp0000281715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 07:07:31 Duration: 46s599ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 09:27:58 Duration: 13s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 09:09:40 Duration: 12s373ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m54s 28 15s947ms 25s251ms 19s95ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 05 08 2 42s975ms 21s487ms 09 4 1m12s 18s164ms 10 3 56s932ms 18s977ms 11 2 35s393ms 17s696ms 13 3 1m1s 20s412ms 14 13 4m4s 18s831ms 15 1 20s660ms 20s660ms [ User: intelifix - Total duration: 8m54s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 28 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-05', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-05 08:07:29 Duration: 25s251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-05', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-05 13:16:01 Duration: 21s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-05', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-05 14:22:03 Duration: 20s866ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8m18s 57 155ms 20s59ms 8s745ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 05 07 6 1m7s 11s296ms 08 7 1m27s 12s554ms 09 6 1m14s 12s364ms 10 5 57s882ms 11s576ms 11 6 1m9s 11s509ms 12 2 8s330ms 4s165ms 13 6 46s164ms 7s694ms 14 6 57s194ms 9s532ms 15 2 10s696ms 5s348ms 21 5 10s514ms 2s102ms 22 6 8s788ms 1s464ms [ User: intelifix - Total duration: 8m18s - Times executed: 57 ]
[ Application: psql - Total duration: 8m18s - Times executed: 57 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-05 08:45:21 Duration: 20s59ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-05 07:25:20 Duration: 18s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-05 09:15:18 Duration: 17s619ms Database: rio User: intelifix Remote: [local] Application: psql
12 5m13s 76 305ms 1m14s 4s122ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 05 07 11 1m36s 8s805ms 08 10 9s340ms 934ms 09 9 11s947ms 1s327ms 10 11 21s569ms 1s960ms 11 7 51s105ms 7s300ms 12 2 41s286ms 20s643ms 13 10 12s774ms 1s277ms 14 11 47s361ms 4s305ms 15 3 15s363ms 5s121ms 16 2 5s704ms 2s852ms [ User: intelifix - Total duration: 5m13s - Times executed: 76 ]
[ Application: psql - Total duration: 5m13s - Times executed: 76 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025163);
Date: 2026-06-05 07:13:10 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025211);
Date: 2026-06-05 12:15:49 Duration: 40s322ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025208);
Date: 2026-06-05 11:42:39 Duration: 38s12ms Database: rio User: intelifix Remote: [local] Application: psql
13 4m49s 28 8s952ms 12s480ms 10s342ms create table temp0000281825 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 05 14 27 4m39s 10s344ms 15 1 10s293ms 10s293ms [ User: intelifix - Total duration: 4m49s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 4m49s - Times executed: 28 ]
-
CREATE TABLE temp0000281825 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:16:54 Duration: 12s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281825 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:07:09 Duration: 12s82ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281825 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:17:14 Duration: 11s471ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m59s 2 1m25s 1m33s 1m29s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 05 20 1 1m25s 1m25s 23 1 1m33s 1m33s [ User: intelifix - Total duration: 2m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-05 23:39:44 Duration: 1m33s 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-05 20:08:19 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
15 2m32s 15 8s889ms 12s300ms 10s167ms create table temp0000281821 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 05 13 3 28s668ms 9s556ms 14 6 1m1s 10s305ms 15 6 1m2s 10s335ms [ User: intelifix - Total duration: 2m32s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 15 ]
-
CREATE TABLE temp0000281821 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 15:04:48 Duration: 12s300ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281821 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:03:05 Duration: 11s316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281821 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 15:07:37 Duration: 10s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m32s 26 3s72ms 30s277ms 5s863ms create table temp0000281731 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 05 07 10 35s394ms 3s539ms 08 8 33s464ms 4s183ms 09 1 30s277ms 30s277ms 10 5 24s124ms 4s824ms 11 2 29s181ms 14s590ms [ User: intelifix - Total duration: 2m32s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 26 ]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 09:59:51 Duration: 30s277ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 11:30:55 Duration: 23s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 11:54:34 Duration: 5s933ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m17s 2 25s595ms 1m51s 1m8s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 05 23 2 2m17s 1m8s [ User: intelifix - Total duration: 2m17s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m17s - 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-05 23:14:50 Duration: 1m51s 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-05 23:41:21 Duration: 25s595ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 2m4s 50 165ms 23s667ms 2s489ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 05 07 7 41s138ms 5s876ms 08 5 10s999ms 2s199ms 09 6 17s932ms 2s988ms 10 9 12s891ms 1s432ms 11 6 9s966ms 1s661ms 12 2 5s178ms 2s589ms 13 5 7s696ms 1s539ms 14 6 12s567ms 2s94ms 15 1 3s124ms 3s124ms 16 3 2s977ms 992ms [ User: intelifix - Total duration: 2m4s - Times executed: 50 ]
[ Application: psql - Total duration: 2m4s - Times executed: 50 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025162);
Date: 2026-06-05 07:10:07 Duration: 23s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025186);
Date: 2026-06-05 09:35:36 Duration: 11s710ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025163);
Date: 2026-06-05 07:13:20 Duration: 9s908ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m59s 2 22s762ms 1m36s 59s815ms 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 #19
Day Hour Count Duration Avg duration Jun 05 23 2 1m59s 59s815ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - 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-05 23:11:40 Duration: 1m36s 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-05 23:40:36 Duration: 22s762ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1m56s 2 57s351ms 59s337ms 58s344ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 05 20 1 59s337ms 59s337ms 23 1 57s351ms 57s351ms [ User: intelifix - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-05 20:05:22 Duration: 59s337ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-05 23:18:33 Duration: 57s351ms Database: rio 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,641 23m46s 150ms 8s436ms 869ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 05 07 88 1m17s 882ms 08 202 2m21s 698ms 09 153 2m41s 1s53ms 10 187 2m28s 792ms 11 202 2m33s 759ms 12 53 28s876ms 544ms 13 110 1m21s 740ms 14 269 4m33s 1s16ms 15 314 4m56s 944ms 16 35 41s551ms 1s187ms 17 28 22s993ms 821ms [ User: intelifix - Total duration: 23m46s - Times executed: 1641 ]
[ Application: [unknown] - Total duration: 23m46s - Times executed: 1641 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40239, 413, '246329668092', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-05 08:54:44 Duration: 8s436ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249667, 450, '255100117482026,216539329401,216605273233,216530367078,216890530209,216823652840,216847518692,216830665656,216362380606,216565131527,216855008100,216827099607,216441392638,216843677588,216687570222,216338688204,216783432136,216803781518,216525833550,216828954962,216842853535,216539002445,216886030118,216448908690,216526341838,216605926787,216853207676,216472346264,216895683753,216542542532,216683944446,216895263353,216528844562,216882619616,216810990415,216568438000,216855480425,216805358911,216850208507,216901269416,216822531530', '',064,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-05 15:29:25 Duration: 6s386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248831, 450, 'CP240932MWG,08C7F52E85E8,544D424200785C95,08C7F52E85EB$CP232232328,D4925EB34B03,544D4242006B98CB,D4925EB34B06$CP2239323HZ,A0B53CC09F33,544D4242005E7C18,A0B53CC09F36$CP240432HVA,08C7F52799DA,544D42420077629B,08C7F52799DD$CP234232NQK,D4925EF8DEA3,544D424200724208,D4925EF8DEA6$CP23253226Z,D4925EC9667F,544D4242006D0359,D4925EC96682$CP23423257C,D4925EF63FE4,544D42420071F781,D4925EF63FE7$CP24113237C,08C7F52FFBCB,544D424200788620,08C7F52FFBCE$CP240432685,08C7F525DC24,544D424200773115,08C7F525DC27$CP234532ET9,08C7F5040A6A,544D42420073710F,08C7F5040A6D$CP2319327R4,D4925EA0ADD6,544D42420069A9B0,D4925EA0ADD9$CP230232HE5,D4925E08BC0D,544D42420061E02A,D4925E08BC10$CP2319328LK,D4925EA0CED9,544D42420069AD5B,D4925EA0CEDC$CP232232CKY,D4925EBD5129,544D4242006BC15C,D4925EBD512C$CP234532EHY,08C7F503FF96,544D424200736FDB,08C7F503FF99$CP240332FA3,08C7F5231831,544D42420076E26E,08C7F5231834$CP230232PV9,D4925E09B34E,544D42420061FBA3,D4925E09B351$CP23013208A,D4925E016CAF,544D4242006110F6,D4925E016CB2$CP230232PWW,D4925E09B534,544D42420061FBD9,D4925E09B537$CP2319327MT,D4925EA0AA01,544D42420069A943,D4925EA0AA04$CP2319327SV,D4925EA0AFE0,544D42420069A9EA,D4925EA0AFE3$CP24043214P,08C7F52518B5,544D424200771B5E,08C7F52518B8$CP234532FT6,08C7F5043098,544D42420073754D,08C7F504309B$CP232032JMT,D4925EA64D9F,544D42420069FF8D,D4925EA64DA2$CP2320327BY,D4925EA49D06,544D42420069CF7C,D4925EA49D09$CP2319327QK,D4925EA0AD34,544D42420069A99E,D4925EA0AD37$CP240432HA3,08C7F5278390,544D424200776021,08C7F5278393$CP2250321MD,A0B53CF9643A,544D42420060AEF0,A0B53CF9643D$CP2409325LV,08C7F52C1633,544D424200781748,08C7F52C1636$CP230232L49,D4925E092372,544D42420061EBA7,D4925E092375$CP230132V3J,D4925E05BDB7,544D424200618BBE,D4925E05BDBA$CP232232CHK,D4925EBD4E6B,544D4242006BC10E,D4925EBD4E6E$CP24043273S,08C7F525FD5D,544D4242007734C6,08C7F525FD60$CP232532D9W,D4925ECCA54B,544D4242006D4BE9,D4925ECCA54E$CP233032F19,D4925EE41534,544D4242006E8985,D4925EE41537$CP2301327JQ,D4925E0284BD,544D424200613014,D4925E0284C0$CP2302323KA,D4925E06AA09,544D42420061A546,D4925E06AA0C$CP23223225M,D4925EB328AA,544D4242006B94FA,D4925EB328AD$CP23203221C,D4925EA3D154,544D42420069B8DA,D4925EA3D157$CP2407321KS,08C7F52966FB,544D42420077D3BC,08C7F52966FE', '',0298,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-05 10:37:16 Duration: 6s128ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,119 11m23s 153ms 3s437ms 610ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 05 07 83 56s581ms 681ms 08 192 2m20s 733ms 09 143 1m22s 576ms 10 154 1m37s 631ms 11 177 1m35s 540ms 13 146 1m30s 622ms 14 206 1m49s 530ms 15 18 10s410ms 578ms [ User: intelifix - Total duration: 11m23s - Times executed: 1119 ]
[ Application: [unknown] - Total duration: 11m23s - Times executed: 1119 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "320", "itens" : "241593995873,241617949715,241594016683,241621255054,241593082238,230049209617,241622827272,241605991736,241601488691,241616049204,230047889094,230049080110,241622843032,230043673353,241607805066,241621173453,241622818709,241596111434,241615916587,230048003854,241607071729,241595813346,241614918903,241607811835,241631329517,241617564245,241620307172,230049033943,241610124866,241617504363,241596221826", "usuario" : "405", "caixa" : "1220100", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-05 08:34:19 Duration: 3s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249428", "modelo" : "464", "itens" : "241767700829,241746477892,241744867084,241760066379,241767691737,241764853042,241767403650,241770110110,241770102028,241764831020,241770095057,241745542639,241745328498,241777683340,241767688099,241747708911,241738452340,241747561927,241742641739,241770155568,241738389606,241767538993,241770182642,241760221625,241764874862,241738388696,241742591330,241688044558,241763304866,241745746777,241747509294,241747516265,241761424660,241747109705,241760173943,241761497697,241767467292,241742562438,241767431835,241767786167,241747510407,241747503840,241747504345,241747504143,241767539802,241747718484,241767412338,241746146973,241745623859,241747664563,241767394255,241742548799,241767480022,241747658198,241767473152,241767700526,241746146064,241747323845,241767492828,241767798390,241777787693,241738354148,241745584057,241746129395,241767737475,241767696484,241770179611,241767477798,241746149397,241746177380,241767536973,241745571733,241764653247,241764887893,241745474854,241767488608,241745636082,241761229714,241687963338,241761136068,241764869306,241767472243,241777713646,241767516769,241770170520,241745315972,241770099097,241738445975,241763322343,241747554350", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-05 10:09:27 Duration: 3s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249164", "modelo" : "320", "itens" : "835209931000147,241639105270,834121918001659,835045907000661,835162924005788,835164924000596,835146922003269,835135920002791,834144921000371,836016903003982,834232934000851,835226933004838,835140921000489,835083913002207,836038906004135,835245936001506,835071911003830,834352951001697,835051908001633,835216932002808,835197929000578,835176926002407,835077912002007,835233934003606,834295943001126,835234934000411,241709658092,835153923000889,836061910000321,835093914000323,835098915001615,834075911003388,835231934005175,835098915002611,835098915003678,834325947001070,836041907002066,834325947001906,835045907000584,835132920002829,835157923002587,836061910000366,835247936002206,835076912002797,834164924001557,834256937000112,834205930000865,835203930002845", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-05 08:29:33 Duration: 3s95ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 249 2h4m59s 154ms 5m42s 30s119ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 05 07 30 18m53s 37s792ms 08 37 14m16s 23s146ms 09 23 18m 46s975ms 10 28 14m33s 31s205ms 11 39 18m41s 28s762ms 12 8 3m21s 25s207ms 13 29 16m13s 33s558ms 14 39 14m15s 21s926ms 15 9 4m44s 31s571ms 16 6 1m57s 19s633ms 17 1 1s604ms 1s604ms [ User: intelifix - Total duration: 2h4m59s - Times executed: 249 ]
[ Application: [unknown] - Total duration: 2h4m59s - Times executed: 249 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025162, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 07:15:50 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025180, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 08:47:21 Duration: 5m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025186, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 09:40:19 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 218 40s955ms 150ms 615ms 187ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 05 07 4 898ms 224ms 08 9 3s503ms 389ms 09 3 489ms 163ms 10 7 1s257ms 179ms 11 21 3s920ms 186ms 12 3 583ms 194ms 13 29 5s138ms 177ms 14 93 16s225ms 174ms 15 42 7s644ms 182ms 16 7 1s294ms 184ms [ User: intelifix - Total duration: 40s955ms - Times executed: 218 ]
[ Application: [unknown] - Total duration: 40s955ms - Times executed: 218 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-06-03", "data-ate" : "2026-06-03", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-05 08:05:52 Duration: 615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-06-03", "data-ate" : "2026-06-03", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-05 08:12:09 Duration: 565ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-06-03", "data-ate" : "2026-06-03", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-05 08:06:50 Duration: 462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 187 50s828ms 150ms 704ms 271ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 05 07 35 11s385ms 325ms 08 36 9s671ms 268ms 09 23 5s774ms 251ms 10 21 5s539ms 263ms 11 19 5s48ms 265ms 13 22 5s136ms 233ms 14 31 8s272ms 266ms [ User: intelifix - Total duration: 50s828ms - Times executed: 187 ]
[ Application: [unknown] - Total duration: 50s828ms - Times executed: 187 ]
-
SELECT * FROM RS_TRIAGEM (402, 5, '113', 3, '229669260707,229750861129,229674036986,229806968905,229689118491,229736621535,229811948593,229784956464,229741922748,229933318788,229747079805', NULL, NULL, 0141, 00);
Date: 2026-06-05 07:21:19 Duration: 704ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229675365062,216924098691,229801302224,229640226582,229800280217,229778646982,229707991221,229711961833', NULL, NULL, 0137, 00);
Date: 2026-06-05 07:04:34 Duration: 699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (402, 5, '113', 3, '216626581935,216867401229,216834048298,184332088100,216410842541,184268569005,216910088289,216508983544,216861005172,216548146782', NULL, NULL, 062, 00);
Date: 2026-06-05 09:34:06 Duration: 620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 137 9m55s 2s468ms 1m5s 4s343ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 05 00 6 34s82ms 5s680ms 01 6 17s34ms 2s839ms 02 6 16s711ms 2s785ms 03 5 15s522ms 3s104ms 04 6 17s13ms 2s835ms 05 6 18s665ms 3s110ms 06 6 15s818ms 2s636ms 07 6 19s954ms 3s325ms 08 6 35s603ms 5s933ms 09 6 36s432ms 6s72ms 10 6 1m14s 12s496ms 11 6 19s91ms 3s181ms 12 6 17s921ms 2s986ms 13 6 1m22s 13s718ms 14 6 21s76ms 3s512ms 15 6 21s560ms 3s593ms 16 6 17s679ms 2s946ms 17 6 16s560ms 2s760ms 18 6 17s934ms 2s989ms 19 6 18s99ms 3s16ms 20 6 24s75ms 4s12ms 21 6 17s15ms 2s835ms 22 6 19s873ms 3s312ms [ User: intelifix - Total duration: 9m55s - Times executed: 137 ]
[ Application: psql - Total duration: 9m55s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 13:36:12 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 10:26:11 Duration: 58s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 00:05:21 Duration: 19s190ms Database: rio User: intelifix Remote: [local] Application: psql
7 129 1m21s 153ms 2s392ms 635ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 05 07 21 13s260ms 631ms 08 33 19s443ms 589ms 09 12 7s587ms 632ms 10 8 5s918ms 739ms 11 14 13s46ms 931ms 13 17 10s425ms 613ms 14 24 12s250ms 510ms [ User: intelifix - Total duration: 1m21s - Times executed: 129 ]
[ Application: [unknown] - Total duration: 1m21s - Times executed: 129 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0248898) LIMIT 1;
Date: 2026-06-05 07:38:28 Duration: 2s392ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249158) LIMIT 1;
Date: 2026-06-05 11:05:43 Duration: 2s267ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0248981) LIMIT 1;
Date: 2026-06-05 07:39:42 Duration: 2s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 107 17s85ms 150ms 217ms 159ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 05 07 5 804ms 160ms 08 12 1s897ms 158ms 09 20 3s168ms 158ms 10 17 2s669ms 157ms 11 24 3s912ms 163ms 13 9 1s434ms 159ms 14 20 3s198ms 159ms [ User: intelifix - Total duration: 17s85ms - Times executed: 107 ]
[ Application: [unknown] - Total duration: 17s85ms - Times executed: 107 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-06-05 11:08:49 Duration: 217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-06-05 13:15:42 Duration: 189ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-06-05 09:47:36 Duration: 182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 103 17m12s 8s114ms 12s25ms 10s20ms create table temp0000281731 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 05 07 16 2m33s 9s595ms 08 25 4m13s 10s122ms 09 13 2m12s 10s196ms 10 16 2m40s 10s12ms 11 9 1m30s 10s15ms 13 18 2m59s 9s992ms 14 6 1m2s 10s468ms [ User: intelifix - Total duration: 17m12s - Times executed: 103 ]
[ Application: [unknown] - Total duration: 17m12s - Times executed: 103 ]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 11:24:18 Duration: 12s25ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:19:50 Duration: 11s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 10:35:04 Duration: 11s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 103 44s140ms 154ms 3s545ms 428ms create table temp0000281745 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 05 07 8 4s832ms 604ms 08 16 5s161ms 322ms 09 12 4s84ms 340ms 10 24 9s396ms 391ms 11 6 2s392ms 398ms 12 12 4s786ms 398ms 13 19 8s262ms 434ms 14 3 1s279ms 426ms 15 3 3s944ms 1s314ms [ User: intelifix - Total duration: 44s140ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 44s140ms - Times executed: 103 ]
-
CREATE TABLE temp0000281745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"1084", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 15:57:47 Duration: 3s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 07:16:44 Duration: 2s839ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"79037", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 12:14:13 Duration: 730ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 81 29s999ms 271ms 553ms 370ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 05 07 9 3s186ms 354ms 08 7 2s548ms 364ms 09 8 3s262ms 407ms 10 10 3s994ms 399ms 11 10 3s848ms 384ms 12 5 1s811ms 362ms 13 8 2s837ms 354ms 14 16 5s851ms 365ms 15 6 2s31ms 338ms 16 2 626ms 313ms [ User: intelifix - Total duration: 29s999ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 29s999ms - Times executed: 81 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-05 10:32:18 Duration: 553ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-05 09:08:22 Duration: 539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-05 11:33:24 Duration: 518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 79 1m 218ms 31s221ms 760ms create table temp0000281719 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 05 06 1 31s221ms 31s221ms 07 6 1s599ms 266ms 08 13 3s849ms 296ms 09 7 2s277ms 325ms 10 20 8s128ms 406ms 11 21 8s313ms 395ms 12 11 4s704ms 427ms [ User: intelifix - Total duration: 1m - Times executed: 79 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 79 ]
-
CREATE TABLE temp0000281719 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 06:59:40 Duration: 31s221ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281719 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"79037", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 10:48:18 Duration: 710ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281719 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"79037", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 12:10:15 Duration: 667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 76 5m13s 305ms 1m14s 4s122ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 05 07 11 1m36s 8s805ms 08 10 9s340ms 934ms 09 9 11s947ms 1s327ms 10 11 21s569ms 1s960ms 11 7 51s105ms 7s300ms 12 2 41s286ms 20s643ms 13 10 12s774ms 1s277ms 14 11 47s361ms 4s305ms 15 3 15s363ms 5s121ms 16 2 5s704ms 2s852ms [ User: intelifix - Total duration: 5m13s - Times executed: 76 ]
[ Application: psql - Total duration: 5m13s - Times executed: 76 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025163);
Date: 2026-06-05 07:13:10 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025211);
Date: 2026-06-05 12:15:49 Duration: 40s322ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025208);
Date: 2026-06-05 11:42:39 Duration: 38s12ms Database: rio User: intelifix Remote: [local] Application: psql
14 73 32s96ms 264ms 721ms 439ms 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 05 06 2 815ms 407ms 07 7 2s658ms 379ms 08 7 3s345ms 477ms 09 8 3s244ms 405ms 10 7 3s80ms 440ms 11 9 3s802ms 422ms 12 2 789ms 394ms 13 10 4s931ms 493ms 14 9 4s510ms 501ms 15 4 1s652ms 413ms 16 4 1s684ms 421ms 17 2 720ms 360ms 21 2 859ms 429ms [ User: lenon - Total duration: 32s96ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 32s96ms - Times executed: 73 ]
-
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-05 14:05:12 Duration: 721ms 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-05 10:07:03 Duration: 706ms 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-05 13:05:21 Duration: 691ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
15 73 28s768ms 151ms 1s363ms 394ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 05 07 4 969ms 242ms 08 15 8s223ms 548ms 09 10 3s135ms 313ms 10 8 5s256ms 657ms 11 9 3s529ms 392ms 13 8 1s859ms 232ms 14 16 5s35ms 314ms 15 3 758ms 252ms [ User: intelifix - Total duration: 28s768ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 28s768ms - Times executed: 73 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2694885 ORDER BY A.CAI_ORDEM;
Date: 2026-06-05 08:43:15 Duration: 1s363ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3022821 ORDER BY A.CAI_ORDEM;
Date: 2026-06-05 10:44:10 Duration: 1s248ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 1220100 ORDER BY A.CAI_ORDEM;
Date: 2026-06-05 08:33:44 Duration: 1s2ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 72 25s119ms 152ms 721ms 348ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 05 07 1 300ms 300ms 08 40 15s913ms 397ms 09 22 7s232ms 328ms 14 9 1s673ms 185ms [ User: intelifix - Total duration: 25s119ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 25s119ms - Times executed: 72 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-06-05 08:33:25 Duration: 721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-06-05 08:33:01 Duration: 717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-06-05 08:33:13 Duration: 700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 69 27s153ms 151ms 4s675ms 393ms create table temp0000281747 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 05 07 7 6s438ms 919ms 08 19 6s385ms 336ms 09 20 6s649ms 332ms 10 18 6s898ms 383ms 11 5 781ms 156ms [ User: intelifix - Total duration: 27s153ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 27s153ms - Times executed: 69 ]
-
CREATE TABLE temp0000281747 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 07:29:05 Duration: 4s675ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281747 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"79037", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 10:03:09 Duration: 541ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281747 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"79037", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 08:45:57 Duration: 515ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 68 36s929ms 324ms 815ms 543ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 05 06 1 501ms 501ms 07 6 2s926ms 487ms 08 7 4s160ms 594ms 09 7 3s575ms 510ms 10 7 3s786ms 540ms 11 8 4s29ms 503ms 12 2 1s18ms 509ms 13 10 5s856ms 585ms 14 9 5s462ms 606ms 15 4 1s980ms 495ms 16 4 2s253ms 563ms 17 2 932ms 466ms 21 1 446ms 446ms [ User: intelifix - Total duration: 36s929ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 36s929ms - Times executed: 68 ]
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-06-05 14:57:07 Duration: 815ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-06-05 08:51:33 Duration: 796ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-06-05 10:07:03 Duration: 795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 59 48s879ms 246ms 5s656ms 828ms create table temp0000281739 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 05 07 3 4s421ms 1s473ms 08 8 2s487ms 310ms 09 8 14s75ms 1s759ms 10 1 395ms 395ms 13 2 10s535ms 5s267ms 14 1 363ms 363ms 15 35 16s33ms 458ms 16 1 567ms 567ms [ User: intelifix - Total duration: 48s879ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 48s879ms - Times executed: 59 ]
-
CREATE TABLE temp0000281739 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 13:42:05 Duration: 5s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281739 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 13:41:32 Duration: 4s878ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281739 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 09:02:20 Duration: 4s609ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 59 30s443ms 319ms 2s324ms 515ms create table temp0000226340 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 05 10 47 24s195ms 514ms 11 12 6s248ms 520ms [ User: intelifix - Total duration: 30s443ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 30s443ms - Times executed: 59 ]
-
CREATE TABLE temp0000226340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-06-05 10:24:07 Duration: 2s324ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-06-05 10:55:37 Duration: 768ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226340 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-06-05 11:08:36 Duration: 763ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m4s 8m25s 5m15s 2 10m30s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 05 05 2 10m30s 5m15s [ User: intelifix - Total duration: 10m30s - Times executed: 2 ]
[ Application: psql - Total duration: 10m30s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-05 05:08:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-05 05:10:31 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql
2 983ms 12m21s 3m45s 32 2h26s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 05 07 2 11m11s 5m35s 08 2 7m56s 3m58s 09 2 12m25s 6m12s 10 2 6m49s 3m24s 11 2 9m16s 4m38s 12 2 5m41s 2m50s 13 2 5m32s 2m46s 14 2 9m15s 4m37s 15 2 8m48s 4m24s 16 2 6m14s 3m7s 17 2 5m56s 2m58s 18 2 5m10s 2m35s 19 2 5m26s 2m43s 20 2 9m31s 4m45s 21 2 5m31s 2m45s 22 2 5m38s 2m49s [ User: intelifix - Total duration: 2h26s - Times executed: 32 ]
[ Application: psql - Total duration: 2h26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-05 09:17:22 Duration: 12m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-05 07:16:08 Duration: 11m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-05 20:14:30 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
3 1m25s 1m33s 1m29s 2 2m59s 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 05 20 1 1m25s 1m25s 23 1 1m33s 1m33s [ User: intelifix - Total duration: 2m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-05 23:39:44 Duration: 1m33s 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-05 20:08:19 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 25s595ms 1m51s 1m8s 2 2m17s 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 05 23 2 2m17s 1m8s [ User: intelifix - Total duration: 2m17s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m17s - 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-05 23:14:50 Duration: 1m51s 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-05 23:41:21 Duration: 25s595ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 22s762ms 1m36s 59s815ms 2 1m59s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 05 23 2 1m59s 59s815ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - 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-05 23:11:40 Duration: 1m36s 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-05 23:40:36 Duration: 22s762ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 57s351ms 59s337ms 58s344ms 2 1m56s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 05 20 1 59s337ms 59s337ms 23 1 57s351ms 57s351ms [ User: intelifix - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-05 20:05:22 Duration: 59s337ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-05 23:18:33 Duration: 57s351ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 154ms 5m42s 30s119ms 249 2h4m59s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 05 07 30 18m53s 37s792ms 08 37 14m16s 23s146ms 09 23 18m 46s975ms 10 28 14m33s 31s205ms 11 39 18m41s 28s762ms 12 8 3m21s 25s207ms 13 29 16m13s 33s558ms 14 39 14m15s 21s926ms 15 9 4m44s 31s571ms 16 6 1m57s 19s633ms 17 1 1s604ms 1s604ms [ User: intelifix - Total duration: 2h4m59s - Times executed: 249 ]
[ Application: [unknown] - Total duration: 2h4m59s - Times executed: 249 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025162, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 07:15:50 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025180, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 08:47:21 Duration: 5m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025186, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-05 09:40:19 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 435ms 1m21s 24s478ms 31 12m38s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 05 07 2 1m23s 41s520ms 08 2 1m 30s323ms 09 2 1m8s 34s104ms 10 2 38s904ms 19s452ms 11 2 1m2s 31s223ms 12 2 38s147ms 19s73ms 13 2 27s740ms 13s870ms 14 2 1m5s 32s897ms 15 2 1m4s 32s208ms 16 2 30s157ms 15s78ms 17 2 30s709ms 15s354ms 18 2 26s843ms 13s421ms 19 2 30s95ms 15s47ms 20 1 1m7s 1m7s 21 2 31s310ms 15s655ms 22 2 32s450ms 16s225ms [ User: intelifix - Total duration: 12m38s - Times executed: 31 ]
[ Application: psql - Total duration: 12m38s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-05 07:17:29 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-05 20:15:38 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-05 09:18:28 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
9 15s947ms 25s251ms 19s95ms 28 8m54s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 05 08 2 42s975ms 21s487ms 09 4 1m12s 18s164ms 10 3 56s932ms 18s977ms 11 2 35s393ms 17s696ms 13 3 1m1s 20s412ms 14 13 4m4s 18s831ms 15 1 20s660ms 20s660ms [ User: intelifix - Total duration: 8m54s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 28 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-05', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-05 08:07:29 Duration: 25s251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-05', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-05 13:16:01 Duration: 21s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-05', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-05 14:22:03 Duration: 20s866ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s77ms 46s599ms 10s685ms 55 9m47s create table temp0000281715 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 05 07 15 2m57s 11s829ms 08 1 10s649ms 10s649ms 09 12 2m11s 10s939ms 10 18 2m59s 9s959ms 11 9 1m29s 9s895ms [ User: intelifix - Total duration: 9m47s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 55 ]
-
CREATE TABLE temp0000281715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 07:07:31 Duration: 46s599ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 09:27:58 Duration: 13s41ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 09:09:40 Duration: 12s373ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s952ms 12s480ms 10s342ms 28 4m49s create table temp0000281825 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 05 14 27 4m39s 10s344ms 15 1 10s293ms 10s293ms [ User: intelifix - Total duration: 4m49s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 4m49s - Times executed: 28 ]
-
CREATE TABLE temp0000281825 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:16:54 Duration: 12s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281825 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:07:09 Duration: 12s82ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281825 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:17:14 Duration: 11s471ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s889ms 12s300ms 10s167ms 15 2m32s create table temp0000281821 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 05 13 3 28s668ms 9s556ms 14 6 1m1s 10s305ms 15 6 1m2s 10s335ms [ User: intelifix - Total duration: 2m32s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 15 ]
-
CREATE TABLE temp0000281821 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 15:04:48 Duration: 12s300ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281821 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:03:05 Duration: 11s316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281821 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 15:07:37 Duration: 10s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s114ms 12s25ms 10s20ms 103 17m12s create table temp0000281731 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 05 07 16 2m33s 9s595ms 08 25 4m13s 10s122ms 09 13 2m12s 10s196ms 10 16 2m40s 10s12ms 11 9 1m30s 10s15ms 13 18 2m59s 9s992ms 14 6 1m2s 10s468ms [ User: intelifix - Total duration: 17m12s - Times executed: 103 ]
[ Application: [unknown] - Total duration: 17m12s - Times executed: 103 ]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 11:24:18 Duration: 12s25ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 14:19:50 Duration: 11s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-05 10:35:04 Duration: 11s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 155ms 20s59ms 8s745ms 57 8m18s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 05 07 6 1m7s 11s296ms 08 7 1m27s 12s554ms 09 6 1m14s 12s364ms 10 5 57s882ms 11s576ms 11 6 1m9s 11s509ms 12 2 8s330ms 4s165ms 13 6 46s164ms 7s694ms 14 6 57s194ms 9s532ms 15 2 10s696ms 5s348ms 21 5 10s514ms 2s102ms 22 6 8s788ms 1s464ms [ User: intelifix - Total duration: 8m18s - Times executed: 57 ]
[ Application: psql - Total duration: 8m18s - Times executed: 57 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-05 08:45:21 Duration: 20s59ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-05 07:25:20 Duration: 18s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-05 09:15:18 Duration: 17s619ms Database: rio User: intelifix Remote: [local] Application: psql
15 3s72ms 30s277ms 5s863ms 26 2m32s create table temp0000281731 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 05 07 10 35s394ms 3s539ms 08 8 33s464ms 4s183ms 09 1 30s277ms 30s277ms 10 5 24s124ms 4s824ms 11 2 29s181ms 14s590ms [ User: intelifix - Total duration: 2m32s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 26 ]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 09:59:51 Duration: 30s277ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 11:30:55 Duration: 23s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281731 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 11:54:34 Duration: 5s933ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2s468ms 1m5s 4s343ms 137 9m55s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 05 00 6 34s82ms 5s680ms 01 6 17s34ms 2s839ms 02 6 16s711ms 2s785ms 03 5 15s522ms 3s104ms 04 6 17s13ms 2s835ms 05 6 18s665ms 3s110ms 06 6 15s818ms 2s636ms 07 6 19s954ms 3s325ms 08 6 35s603ms 5s933ms 09 6 36s432ms 6s72ms 10 6 1m14s 12s496ms 11 6 19s91ms 3s181ms 12 6 17s921ms 2s986ms 13 6 1m22s 13s718ms 14 6 21s76ms 3s512ms 15 6 21s560ms 3s593ms 16 6 17s679ms 2s946ms 17 6 16s560ms 2s760ms 18 6 17s934ms 2s989ms 19 6 18s99ms 3s16ms 20 6 24s75ms 4s12ms 21 6 17s15ms 2s835ms 22 6 19s873ms 3s312ms [ User: intelifix - Total duration: 9m55s - Times executed: 137 ]
[ Application: psql - Total duration: 9m55s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 13:36:12 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 10:26:11 Duration: 58s42ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-05 00:05:21 Duration: 19s190ms Database: rio User: intelifix Remote: [local] Application: psql
17 305ms 1m14s 4s122ms 76 5m13s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 05 07 11 1m36s 8s805ms 08 10 9s340ms 934ms 09 9 11s947ms 1s327ms 10 11 21s569ms 1s960ms 11 7 51s105ms 7s300ms 12 2 41s286ms 20s643ms 13 10 12s774ms 1s277ms 14 11 47s361ms 4s305ms 15 3 15s363ms 5s121ms 16 2 5s704ms 2s852ms [ User: intelifix - Total duration: 5m13s - Times executed: 76 ]
[ Application: psql - Total duration: 5m13s - Times executed: 76 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025163);
Date: 2026-06-05 07:13:10 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025211);
Date: 2026-06-05 12:15:49 Duration: 40s322ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025208);
Date: 2026-06-05 11:42:39 Duration: 38s12ms Database: rio User: intelifix Remote: [local] Application: psql
18 165ms 23s667ms 2s489ms 50 2m4s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 05 07 7 41s138ms 5s876ms 08 5 10s999ms 2s199ms 09 6 17s932ms 2s988ms 10 9 12s891ms 1s432ms 11 6 9s966ms 1s661ms 12 2 5s178ms 2s589ms 13 5 7s696ms 1s539ms 14 6 12s567ms 2s94ms 15 1 3s124ms 3s124ms 16 3 2s977ms 992ms [ User: intelifix - Total duration: 2m4s - Times executed: 50 ]
[ Application: psql - Total duration: 2m4s - Times executed: 50 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025162);
Date: 2026-06-05 07:10:07 Duration: 23s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025186);
Date: 2026-06-05 09:35:36 Duration: 11s710ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025163);
Date: 2026-06-05 07:13:20 Duration: 9s908ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 8s436ms 869ms 1,641 23m46s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 05 07 88 1m17s 882ms 08 202 2m21s 698ms 09 153 2m41s 1s53ms 10 187 2m28s 792ms 11 202 2m33s 759ms 12 53 28s876ms 544ms 13 110 1m21s 740ms 14 269 4m33s 1s16ms 15 314 4m56s 944ms 16 35 41s551ms 1s187ms 17 28 22s993ms 821ms [ User: intelifix - Total duration: 23m46s - Times executed: 1641 ]
[ Application: [unknown] - Total duration: 23m46s - Times executed: 1641 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40239, 413, '246329668092', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-05 08:54:44 Duration: 8s436ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249667, 450, '255100117482026,216539329401,216605273233,216530367078,216890530209,216823652840,216847518692,216830665656,216362380606,216565131527,216855008100,216827099607,216441392638,216843677588,216687570222,216338688204,216783432136,216803781518,216525833550,216828954962,216842853535,216539002445,216886030118,216448908690,216526341838,216605926787,216853207676,216472346264,216895683753,216542542532,216683944446,216895263353,216528844562,216882619616,216810990415,216568438000,216855480425,216805358911,216850208507,216901269416,216822531530', '',064,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-05 15:29:25 Duration: 6s386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (248831, 450, 'CP240932MWG,08C7F52E85E8,544D424200785C95,08C7F52E85EB$CP232232328,D4925EB34B03,544D4242006B98CB,D4925EB34B06$CP2239323HZ,A0B53CC09F33,544D4242005E7C18,A0B53CC09F36$CP240432HVA,08C7F52799DA,544D42420077629B,08C7F52799DD$CP234232NQK,D4925EF8DEA3,544D424200724208,D4925EF8DEA6$CP23253226Z,D4925EC9667F,544D4242006D0359,D4925EC96682$CP23423257C,D4925EF63FE4,544D42420071F781,D4925EF63FE7$CP24113237C,08C7F52FFBCB,544D424200788620,08C7F52FFBCE$CP240432685,08C7F525DC24,544D424200773115,08C7F525DC27$CP234532ET9,08C7F5040A6A,544D42420073710F,08C7F5040A6D$CP2319327R4,D4925EA0ADD6,544D42420069A9B0,D4925EA0ADD9$CP230232HE5,D4925E08BC0D,544D42420061E02A,D4925E08BC10$CP2319328LK,D4925EA0CED9,544D42420069AD5B,D4925EA0CEDC$CP232232CKY,D4925EBD5129,544D4242006BC15C,D4925EBD512C$CP234532EHY,08C7F503FF96,544D424200736FDB,08C7F503FF99$CP240332FA3,08C7F5231831,544D42420076E26E,08C7F5231834$CP230232PV9,D4925E09B34E,544D42420061FBA3,D4925E09B351$CP23013208A,D4925E016CAF,544D4242006110F6,D4925E016CB2$CP230232PWW,D4925E09B534,544D42420061FBD9,D4925E09B537$CP2319327MT,D4925EA0AA01,544D42420069A943,D4925EA0AA04$CP2319327SV,D4925EA0AFE0,544D42420069A9EA,D4925EA0AFE3$CP24043214P,08C7F52518B5,544D424200771B5E,08C7F52518B8$CP234532FT6,08C7F5043098,544D42420073754D,08C7F504309B$CP232032JMT,D4925EA64D9F,544D42420069FF8D,D4925EA64DA2$CP2320327BY,D4925EA49D06,544D42420069CF7C,D4925EA49D09$CP2319327QK,D4925EA0AD34,544D42420069A99E,D4925EA0AD37$CP240432HA3,08C7F5278390,544D424200776021,08C7F5278393$CP2250321MD,A0B53CF9643A,544D42420060AEF0,A0B53CF9643D$CP2409325LV,08C7F52C1633,544D424200781748,08C7F52C1636$CP230232L49,D4925E092372,544D42420061EBA7,D4925E092375$CP230132V3J,D4925E05BDB7,544D424200618BBE,D4925E05BDBA$CP232232CHK,D4925EBD4E6B,544D4242006BC10E,D4925EBD4E6E$CP24043273S,08C7F525FD5D,544D4242007734C6,08C7F525FD60$CP232532D9W,D4925ECCA54B,544D4242006D4BE9,D4925ECCA54E$CP233032F19,D4925EE41534,544D4242006E8985,D4925EE41537$CP2301327JQ,D4925E0284BD,544D424200613014,D4925E0284C0$CP2302323KA,D4925E06AA09,544D42420061A546,D4925E06AA0C$CP23223225M,D4925EB328AA,544D4242006B94FA,D4925EB328AD$CP23203221C,D4925EA3D154,544D42420069B8DA,D4925EA3D157$CP2407321KS,08C7F52966FB,544D42420077D3BC,08C7F52966FE', '',0298,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-05 10:37:16 Duration: 6s128ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 246ms 5s656ms 828ms 59 48s879ms create table temp0000281739 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 05 07 3 4s421ms 1s473ms 08 8 2s487ms 310ms 09 8 14s75ms 1s759ms 10 1 395ms 395ms 13 2 10s535ms 5s267ms 14 1 363ms 363ms 15 35 16s33ms 458ms 16 1 567ms 567ms [ User: intelifix - Total duration: 48s879ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 48s879ms - Times executed: 59 ]
-
CREATE TABLE temp0000281739 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 13:42:05 Duration: 5s656ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281739 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 13:41:32 Duration: 4s878ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281739 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-05-2026", "ate" :"05-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-05 09:02:20 Duration: 4s609ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 05 11 1 0ms 0ms [ User: intelifix - Total duration: 564ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 564ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: [unknown]
-
Events
Log levels
Key values
- 14,949 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 415 FATAL entries
- 1799 ERROR entries
- 0 WARNING entries
- 22 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,732 Max number of times the same event was reported
- 2,236 Total events found
Rank Times reported Error 1 1,732 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 05 07 63 08 207 09 288 10 255 11 174 12 1 13 292 14 316 15 87 16 21 17 28 - ERROR: prepared statement "_PLAN0000000029BAA110" does not exist
- ERROR: prepared statement "_PLAN000000003303EC20" does not exist
- ERROR: prepared statement "_PLAN0000000033A121D0" does not exist
Statement: DEALLOCATE "_PLAN0000000029BAA110"
Date: 2026-06-05 07:06:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003303EC20"
Date: 2026-06-05 07:11:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000033A121D0"
Date: 2026-06-05 07:15:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 401 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 05 00 16 01 14 02 14 03 13 04 15 05 19 06 16 07 16 08 19 09 19 10 19 11 18 12 19 13 18 14 18 15 19 16 19 17 19 18 17 19 16 20 18 21 20 22 19 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-05 00:02:06 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-05 00:02:07 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-05 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 05 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 46119: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-05 08:00:39 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-05 08:20:08 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 46119: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-05 08:40:24 Database: rio Application: psql User: intelifix Remote: [local]
4 11 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 05 08 2 09 3 10 3 13 3 - LOG: process 2227665 still waiting for ShareLock on transaction 627227 after 1000.116 ms
- LOG: process 2227665 still waiting for ShareLock on transaction 627227 after 7563.035 ms
- LOG: process 2294645 still waiting for ShareLock on transaction 633742 after 1000.094 ms
Detail: Process holding the lock: 2227657. Wait queue: 2227665.
Context: while updating tuple (69333,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-05 08:05:16 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2227657. Wait queue: 2227665.
Context: while updating tuple (69333,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-05 08:05:22 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2322010. Wait queue: 2294645.
Context: while updating tuple (69339,37) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-05 09:05:17 Database: rio Application: psql User: intelifix Remote: [local]
5 9 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 05 13 9 - ERROR: process 2547271 detected deadlock while waiting for ShareLock on transaction 656663 after 1000.225 ms
- ERROR: process 2547271 detected deadlock while waiting for ShareLock on transaction 656663 after 1000.174 ms
- ERROR: process 2547271 detected deadlock while waiting for ShareLock on transaction 656663 after 1000.149 ms
Detail: Process holding the lock: 2540897. Wait queue: .
Context: while updating tuple (18738,84) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025215, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-06-05 13:35:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2540897. Wait queue: .
Context: while updating tuple (69425,18) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025215, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-06-05 13:35:18 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2540897. Wait queue: .
Context: while updating tuple (18738,84) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025215, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-06-05 13:35:20 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 8 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 05 18 3 19 3 20 2 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-06-05 18:00:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-05 18:15:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-05 18:55:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 6 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 05 10 2 13 2 15 2 - ERROR: trailing junk after numeric literal at or near "8C444F99934E" at character 27
- ERROR: trailing junk after numeric literal at or near "8C444F99934E" at character 27
- ERROR: trailing junk after numeric literal at or near "802D1A01A400" at character 32
Statement: SELECT * FROM RS_ETIQUETA(8C444F99934E)
Date: 2026-06-05 10:26:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(8C444F99934E)
Date: 2026-06-05 10:26:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''802D1A01A400' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''802D1A01A400' )
Date: 2026-06-05 13:16:09 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 05 08 2 10 2 11 2 - ERROR: syntax error at or near "diagnostics" at character 42
- ERROR: syntax error at or near "diagnostics" at character 42
- ERROR: syntax error at or near "C0B101EA8FF8" at character 46
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-06-05 08:58:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-06-05 08:58:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0271, ''C0B101EA8FF8' )
Date: 2026-06-05 10:20:50 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 3 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 05 16 3 - ERROR: duplicate key value violates unique constraint "tecnologias_pkey"
- ERROR: duplicate key value violates unique constraint "tecnologias_pkey"
- ERROR: duplicate key value violates unique constraint "tecnologias_pkey"
Detail: Key (tcn_id)=(1) already exists.
Context: SQL statement "INSERT INTO TECNOLOGIAS ( TCN_ID, TCN_NOME, TCN_NFGVT, TCN_TRIAGEM, TCN_VALORADO, TCN_HOMOLOGADA, TCN_ORDEM, GRU_ID, TCN_ATIVA, TIPO, TIPO_EQUIP ) VALUES ( cDados.TCN_ID, cDados.TCN_NOME, cDados.TCN_NFGVT, cDados.TCN_TRIAGEM, cDados.TCN_VALORADO, cDados.TCN_HOMOLOGADA, cDados.TCN_ORDEM, cDados.GRU_ID, cDados.TCN_ATIVA, cDados.TIPO, cDados.TIPO_EQUIP )" PL/pgSQL function rs_tecnologia_manutencao(character varying) line 102 at SQL statement
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0", "nome" :"GPON WIFI6", "usuario" :"80", "grupo" :"2", "triagem" :"S", "nfgvt" :"S", "valorado" :"N", "homologada" :"S", "ordem" :"100", "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], "ativa" :"S"}' )Date: 2026-06-05 16:19:49 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Key (tcn_id)=(2) already exists.
Context: SQL statement "INSERT INTO TECNOLOGIAS ( TCN_ID, TCN_NOME, TCN_NFGVT, TCN_TRIAGEM, TCN_VALORADO, TCN_HOMOLOGADA, TCN_ORDEM, GRU_ID, TCN_ATIVA, TIPO, TIPO_EQUIP ) VALUES ( cDados.TCN_ID, cDados.TCN_NOME, cDados.TCN_NFGVT, cDados.TCN_TRIAGEM, cDados.TCN_VALORADO, cDados.TCN_HOMOLOGADA, cDados.TCN_ORDEM, cDados.GRU_ID, cDados.TCN_ATIVA, cDados.TIPO, cDados.TIPO_EQUIP )" PL/pgSQL function rs_tecnologia_manutencao(character varying) line 102 at SQL statement
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0", "nome" :"GPON WIFI6", "usuario" :"80", "grupo" :"2", "triagem" :"S", "nfgvt" :"S", "valorado" :"N", "homologada" :"N", "ordem" :"100", "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], "ativa" :"S"}' ) /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-05 16:20:02 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Key (tcn_id)=(3) already exists.
Context: SQL statement "INSERT INTO TECNOLOGIAS ( TCN_ID, TCN_NOME, TCN_NFGVT, TCN_TRIAGEM, TCN_VALORADO, TCN_HOMOLOGADA, TCN_ORDEM, GRU_ID, TCN_ATIVA, TIPO, TIPO_EQUIP ) VALUES ( cDados.TCN_ID, cDados.TCN_NOME, cDados.TCN_NFGVT, cDados.TCN_TRIAGEM, cDados.TCN_VALORADO, cDados.TCN_HOMOLOGADA, cDados.TCN_ORDEM, cDados.GRU_ID, cDados.TCN_ATIVA, cDados.TIPO, cDados.TIPO_EQUIP )" PL/pgSQL function rs_tecnologia_manutencao(character varying) line 102 at SQL statement
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0", "nome" :"GPON WIFI6", "usuario" :"80", "grupo" :"2", "triagem" :"N", "nfgvt" :"S", "valorado" :"N", "homologada" :"N", "ordem" :"100", "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], "ativa" :"S"}' )Date: 2026-06-05 16:20:27 Database: contagem Application: [unknown] User: intelifix Remote: [local]
10 3 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 05 03 3 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command at character 35 2026-06-05 03:05:01 -03 [1816854]: [5-1] user=intelifix,db=rio,app=psql,client=[local] QUERY: SELECT PAR_VALOR FROM PARAMETROS WHERE PAR_NOME = cParam
Date: 2026-06-05 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL expression "RS_FORMATO_DATA_HORA() || ':SS'" PL/pgSQL function rs_giga_triagem(character varying) line 26 during statement block local variable initialization
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-05 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Context: PL/pgSQL function rs_parametro(character varying) line 20 at SQL statement PL/pgSQL function rs_giga_tecnicos() line 16 during statement block local variable initialization
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-05 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
11 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 05 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-05 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-05 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
12 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 05 12 2 - ERROR: unterminated quoted string at or near "''' )" at character 42
- ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''' )
Date: 2026-06-05 12:01:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-06-05 12:01:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 2 FATAL: database "..." does not exist NOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 05 10 1 13 1 - FATAL: database "brasilia" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
- FATAL: database "brasilia" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-06-05 10:20:18 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-05 13:45:11 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
14 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 05 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-05 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-06-05 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
15 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 05 03 1 - FATAL: the database system is shutting down
Date: 2026-06-05 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
16 1 ERROR: spiexceptions.ExternalRoutineException: error fetching next item from iterator
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 05 15 1 - ERROR: spiexceptions.ExternalRoutineException: error fetching next item from iterator
Detail: EOFError:
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: 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-05 15:04:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 05 10 1 - LOG: skipping analyze of "temp0000281731" --- lock not available
Date: 2026-06-05 10:21:53
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 05 03 1 - LOG: database system was shut down at 2026-06-05 03:05:01 -03
Date: 2026-06-05 03:05:02