pgBadger-
Global information
- Generated on Mon Jun 8 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,938 log entries in 9s
- Log start from 2026-06-08 00:02:01 to 2026-06-08 23:42:53
-
Overview
Global Stats
- 326 Number of unique normalized queries
- 6,466 Number of queries
- 7h44m22s Total query duration
- 2026-06-08 00:02:09 First query
- 2026-06-08 23:37:57 Last query
- 5 queries/s at 2026-06-08 13:52:20 Query peak
- 7h44m22s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h44m22s Execute total duration
- 2,054 Number of events
- 19 Number of unique normalized events
- 1,554 Max number of times the same event was reported
- 0 Number of cancellation
- 601 Total number of automatic vacuums
- 1,191 Total number of automatic analyzes
- 24 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 221 Total number of sessions
- 6 sessions at 2026-06-08 19:05:01 Session peak
- 8d1h43m18s Total duration of sessions
- 52m35s Average duration of sessions
- 29 Average queries per session
- 2m6s Average queries duration per session
- 50m29s Average idle time per session
- 640 Total number of connections
- 4 connections/s at 2026-06-08 00:05:01 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-08 13:52:20 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-08 13:52:20 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-08 23:37:26 Date
Queries duration
Key values
- 7h44m22s 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 08 00 13 0ms 22s91ms 6s299ms 59s25ms 59s25ms 59s25ms 01 6 0ms 3s30ms 2s792ms 3s30ms 3s30ms 3s30ms 02 6 0ms 3s270ms 2s870ms 3s270ms 3s270ms 3s270ms 03 6 0ms 4s28ms 2s576ms 4s28ms 4s28ms 4s28ms 04 6 0ms 3s11ms 2s763ms 3s11ms 3s11ms 3s11ms 05 8 0ms 8m18s 1m20s 2m11s 8m18s 8m18s 06 13 0ms 11s672ms 3s532ms 8s53ms 22s817ms 22s817ms 07 152 0ms 11m43s 13s880ms 1m 3m42s 11m43s 08 601 0ms 6m13s 3s412ms 49s615ms 4m3s 7m8s 09 732 150ms 13m16s 3s889ms 1m13s 5m3s 13m39s 10 662 150ms 6m33s 2s614ms 45s95ms 4m6s 6m39s 11 657 150ms 15m31s 4s836ms 1m17s 5m5s 15m39s 12 208 0ms 9m13s 6s953ms 32s41ms 3m40s 10m16s 13 662 0ms 6m 2s25ms 33s307ms 1m57s 6m35s 14 828 150ms 6m29s 3s532ms 1m45s 5m49s 8m53s 15 778 150ms 10m33s 3s303ms 1m19s 4m17s 10m55s 16 554 0ms 7m7s 3s130ms 57s623ms 1m14s 7m52s 17 224 0ms 6m36s 3s998ms 35s692ms 1m1s 6m40s 18 11 0ms 5m29s 35s6ms 4s44ms 7s789ms 5m58s 19 10 0ms 5m29s 37s625ms 3s402ms 5m57s 5m57s 20 68 0ms 8m37s 15s97ms 2m4s 8m37s 8m37s 21 22 0ms 5m23s 17s355ms 5s244ms 5m52s 5m52s 22 16 0ms 5m1s 22s155ms 4s686ms 5m29s 5m29s 23 223 0ms 1m30s 7s480ms 1m15s 1m28s 1m30s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 08 00 2 0 4s306ms 0ms 8s613ms 8s613ms 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 5 0 1s885ms 0ms 1s372ms 8s53ms 07 97 0 17s640ms 3s503ms 28s243ms 6m11s 08 467 0 3s386ms 11s978ms 34s289ms 4m6s 09 584 0 3s933ms 19s502ms 58s641ms 5m23s 10 553 0 2s628ms 13s930ms 32s331ms 4m11s 11 504 0 5s367ms 26s667ms 1m 6m40s 12 157 0 7s915ms 3s610ms 7s799ms 4m49s 13 548 0 1s707ms 9s476ms 12s128ms 2m28s 14 689 0 3s727ms 38s155ms 1m11s 6m38s 15 625 0 3s291ms 23s201ms 1m13s 4m17s 16 435 0 3s149ms 18s680ms 56s809ms 4m19s 17 172 0 4s471ms 10s492ms 35s692ms 6m40s 18 5 0 1m13s 0ms 1s153ms 5m58s 19 4 0 1m29s 0ms 2s2ms 5m57s 20 8 53 16s341ms 1m4s 2m3s 8m37s 21 11 0 32s493ms 876ms 1s729ms 5m52s 22 4 0 1m22s 0ms 0ms 5m29s 23 5 218 7s480ms 1m8s 1m15s 1m30s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 08 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 08 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 1 1.00 0.00% 07 0 10 10.00 0.00% 08 0 11 11.00 0.00% 09 0 12 12.00 0.00% 10 0 8 8.00 0.00% 11 0 10 10.00 0.00% 12 0 6 6.00 0.00% 13 0 12 12.00 0.00% 14 0 10 10.00 0.00% 15 0 7 7.00 0.00% 16 0 8 8.00 0.00% 17 0 5 5.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 08 00 24 0.01/s 01 17 0.00/s 02 17 0.00/s 03 18 0.01/s 04 17 0.00/s 05 23 0.01/s 06 24 0.01/s 07 26 0.01/s 08 37 0.01/s 09 38 0.01/s 10 35 0.01/s 11 31 0.01/s 12 28 0.01/s 13 38 0.01/s 14 40 0.01/s 15 35 0.01/s 16 31 0.01/s 17 31 0.01/s 18 26 0.01/s 19 24 0.01/s 20 29 0.01/s 21 25 0.01/s 22 22 0.01/s 23 4 0.00/s Day Hour Count Average Duration Average idle time Jun 08 00 2 37m57s 37m16s 01 7 1h1m17s 1h1m14s 02 3 1h1m 1h54s 03 5 30m38s 30m35s 04 3 1h1m 1h54s 05 4 47m31s 44m49s 06 3 1h1s 59m45s 07 8 53m20s 48m56s 08 12 49m55s 47m4s 09 17 52m52s 50m5s 10 19 54m14s 52m43s 11 14 52m13s 48m26s 12 15 48m23s 46m46s 13 8 51m14s 48m26s 14 19 48m31s 45m57s 15 17 57m33s 55m2s 16 15 55m32s 53m37s 17 15 52m46s 51m46s 18 10 1h23s 59m45s 19 5 52m 50m45s 20 6 43m6s 40m15s 21 4 1h45s 59m9s 22 5 1h1m36s 1h25s 23 5 41m35s 36m1s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-08 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 640 connections Total
Connections per user
Key values
- intelifix Main User
- 640 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-08 19:05:01 Date
Histogram of session times
Key values
- 174 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 221 sessions Total
Sessions per user
Key values
- intelifix Main User
- 221 sessions Total
Sessions per host
Key values
- [local] Main Host
- 221 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 27,475 buffers Checkpoint Peak
- 2026-06-08 08:49:38 Date
- 270.057 seconds Highest write time
- 0.065 seconds Sync time
Checkpoints Wal files
Key values
- 19 files Wal files usage Peak
- 2026-06-08 08:49:38 Date
Checkpoints distance
Key values
- 589.55 Mo Distance Peak
- 2026-06-08 08:49:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 08 00 5,086 269.804s 0.003s 269.813s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 5,210 0.313s 0.005s 0.328s 04 0 0s 0s 0s 05 4,459 447.282s 0.012s 447.315s 06 1,460 146.205s 0.002s 146.212s 07 50,613 2,143.856s 0.064s 2,143.991s 08 73,945 3,100.872s 0.166s 3,101.176s 09 71,312 3,239.194s 0.251s 3,239.623s 10 70,618 3,192.333s 0.217s 3,192.726s 11 114,117 3,239.247s 0.293s 3,239.707s 12 33,934 2,432.316s 0.083s 2,432.486s 13 41,795 2,495.995s 0.158s 2,496.289s 14 73,146 3,220.268s 0.256s 3,220.714s 15 79,645 3,239.233s 0.3s 3,239.716s 16 57,018 3,206.421s 0.196s 3,206.767s 17 23,710 2,281.885s 0.09s 2,282.064s 18 1,546 155.147s 0.012s 155.186s 19 29 2.949s 0.005s 2.962s 20 262 291.567s 0.005s 291.582s 21 2,496 252.66s 0.022s 252.721s 22 1,960 196.695s 0.027s 196.762s 23 2,541 446.131s 0.005s 446.148s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 08 00 0 0 2 20 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 2 20 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 80 0.002s 0.004s 06 0 0 0 9 0.002s 0.001s 07 0 0 24 1,777 0.004s 0.011s 08 0 0 44 4,776 0.004s 0.012s 09 0 0 46 6,212 0.004s 0.012s 10 0 0 37 6,008 0.004s 0.012s 11 0 0 64 5,787 0.006s 0.012s 12 0 0 19 2,382 0.003s 0.012s 13 0 0 35 4,642 0.004s 0.012s 14 0 0 46 6,193 0.005s 0.012s 15 0 0 55 6,010 0.011s 0.012s 16 0 0 38 5,181 0.006s 0.012s 17 0 0 14 3,214 0.003s 0.01s 18 0 0 1 247 0.002s 0.008s 19 0 0 0 8 0.002s 0.002s 20 0 0 1 67 0.002s 0.002s 21 0 0 1 401 0.003s 0.008s 22 0 0 0 419 0.004s 0.013s 23 0 0 2 32 0.002s 0.003s Day Hour Count Avg time (sec) Jun 08 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 08 00 30,059.00 kB 30,059.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 16,665.50 kB 16,665.50 kB 04 0.00 kB 0.00 kB 05 8,034.25 kB 11,167.75 kB 06 2,861.00 kB 15,871.00 kB 07 34,702.27 kB 63,132.73 kB 08 60,038.17 kB 126,672.17 kB 09 63,901.83 kB 165,140.50 kB 10 49,380.08 kB 86,331.75 kB 11 87,571.00 kB 129,187.08 kB 12 25,705.42 kB 101,585.83 kB 13 48,244.58 kB 68,959.67 kB 14 63,310.42 kB 122,780.58 kB 15 75,102.92 kB 130,033.50 kB 16 51,856.58 kB 87,243.50 kB 17 23,022.90 kB 59,978.80 kB 18 1,323.83 kB 30,865.33 kB 19 97.00 kB 20,161.50 kB 20 8,260.00 kB 17,797.50 kB 21 2,014.43 kB 12,058.86 kB 22 1,036.50 kB 5,750.70 kB 23 7,104.67 kB 13,398.33 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-08 14:58:37 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-08 14:38:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 5 519.98 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 3 311.99 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 4 415.98 MiB 104.00 MiB 15 3 311.99 MiB 104.00 MiB 16 4 415.98 MiB 104.00 MiB 17 3 311.99 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 24 2.44 GiB 103.99 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025270, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-08 11:49:49 Duration: 15m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025239, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-08 07:17:28 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025294, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-08 14:31:21 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 14:58:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 14:38:08 - 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-08 16:00:21 - 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-08 09:47:38 - 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-08 08:39:56 - 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-08 15:36:15 - 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-08 16:36:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 11:04:32 - 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-08 14:47:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 14:51:00 - 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-08 11:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 16:29:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 17:32:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 17:04:11 - 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-08 09:32:44 - 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-08 10:46:45 - 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-08 09:40: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-08 09:07:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,309,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-08 11:39:51 - 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-08 16:45:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.73 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-08 11:26:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 7.73 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-08 11:26:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (149) Main table analyzed (database rio)
- 1,191 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 149 rio.pg_catalog.pg_class 86 rio.public.temp0000281855 80 rio.pg_catalog.pg_type 69 rio.public.usuarios 52 rio.pg_catalog.pg_index 48 rio.public.temp0000281853 45 contagem.pg_catalog.pg_attribute 40 rio.pg_catalog.pg_depend 39 rio.public.temp0000281937 37 rio.public.temp0000281849 32 rio.public.temp0000281955 29 rio.public.temp0000281893 29 contagem.public.temp0000226346 28 contagem.pg_catalog.pg_class 28 contagem.public.usuarios 28 rio.public.temp0000281859 28 rio.public.temp0000281861 25 contagem.pg_catalog.pg_type 22 rio.public.temp0000281889 19 contagem.public.temp0000226294 18 rio.public.temp0000281897 18 rio.public.temp0000281925 17 rio.public.temp0000281865 15 contagem.pg_catalog.pg_index 15 rio.public.temp0000281857 14 contagem.pg_catalog.pg_depend 11 rio.public.temp0000281851 10 rio.public.temp0000281335 10 rio.public.temp0000281979 9 rio.public.temp0000281791 9 contagem.pg_catalog.pg_shdepend 8 rio.pg_catalog.pg_shdepend 8 rio.public.temp0000281879 8 rio.public.temp0000281923 7 contagem.public.temp0000226304 7 rio.public.temp0000281881 7 rio.public.temp0000281943 6 rio.public.temp0000281867 6 rio.public.temp0000281939 5 postgres.pg_catalog.pg_shdepend 5 contagem.public.temp0000226350 5 rio.public.temp0000281769 5 rio.public.tmp_drill_0175 4 rio.public.temp0000281875 4 rio.public.temp0000281301 4 rio.public.temp0000281919 3 rio.public.temp0000281885 3 rio.public.temp0000281949 3 rio.public.temp0000281877 3 rio.public.temp0000281523 3 rio.public.temp0000281945 2 rio.public.temp0000281969 2 contagem.public.nf_entrada 2 contagem.public.temp0000226348 2 rio.public.tmp_drill_0302 2 rio.auditor.auditor_2026_06 1 contagem.public.parametros 1 rio.public.temp0000281871 1 contagem.public.temp0000226340 1 rio.public.temp0000281905 1 rio.public.temp0000281951 1 rio.public.temp0000281901 1 rio.public.temp0000281957 1 contagem.auditor.auditor_2026_06 1 rio.public.temp0000281873 1 rio.public.temp0000281967 1 rio.public.temp0000281933 1 rio.public.temp0000281883 1 rio.public.temp0000281921 1 rio.public.temp0000281891 1 rio.public.temp0000281961 1 rio.public.temp0000281869 1 rio.public.temp0000281863 1 Total 1,191 Vacuums per table
Key values
- public.temp0000281855 (80) Main table vacuumed on database rio
- 601 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000281855 80 0 0 0 0 0 0 49,508 5,121 9,074,039 0 0 rio.pg_catalog.pg_attribute 78 55 0 0 0 0 0 32,354 7,911 11,877,207 540 13,016 rio.pg_catalog.pg_class 55 34 0 0 0 0 0 7,091 2,206 3,111,061 115 483 rio.pg_catalog.pg_type 44 31 0 0 0 0 0 2,900 748 997,832 95 298 rio.public.temp0000281955 29 0 0 0 0 0 0 35,949 1,667 4,115,501 0 0 contagem.public.usuarios 28 0 0 0 0 0 0 152 126 62,174 4 4 rio.pg_catalog.pg_index 25 21 0 0 0 0 0 1,458 395 329,187 78 166 rio.public.temp0000281937 20 0 0 0 0 0 0 10,605 104 641,899 0 0 rio.public.temp0000281889 19 0 0 0 0 0 0 15,583 67 930,269 0 0 rio.public.temp0000281897 18 0 0 0 0 0 0 1,151 100 83,541 0 0 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 9,363 2,855 4,896,504 61 1,228 rio.pg_catalog.pg_depend 15 15 0 0 0 0 0 5,186 1,757 2,513,773 80 680 rio.public.usuarios 14 6 0 0 0 0 0 151 40 64,362 3 12 rio.pg_catalog.pg_statistic 11 11 0 0 0 0 0 14,126 3,352 15,291,324 1,376 5,652 template1.pg_catalog.pg_shdepend 10 10 0 0 0 0 0 1,961 624 1,068,353 156 320 rio.public.temp0000281335 10 0 0 0 0 0 0 916 58 63,321 0 0 contagem.pg_catalog.pg_class 9 9 0 0 0 0 0 1,618 459 636,092 19 45 rio.public.temp0000281925 8 0 0 0 0 0 0 1,837 42 114,921 0 0 rio.public.temp0000281923 7 0 0 0 0 0 0 722 169 283,956 0 0 rio.public.tmp_drill_0175 7 4 0 0 0 0 0 2,608 26 464,698 1 55 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 651 228 350,924 12 28 contagem.public.temp0000226346 7 0 0 0 0 0 0 645 42 44,515 0 0 rio.pg_toast.pg_toast_2619 7 7 0 0 0 0 0 2,312 538 2,720,153 125 408 rio.public.temp0000281791 6 0 0 0 0 0 0 287 36 21,656 0 0 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,331 457 849,146 10 66 rio.public.temp0000281939 5 0 0 0 0 0 0 4,686 20 279,655 0 0 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 229 103 87,725 8 10 rio.public.temp0000281875 4 0 0 0 0 0 0 235 23 17,344 0 0 rio.public.temp0000281769 4 0 0 0 0 0 0 174 21 13,373 0 0 rio.auditor.auditor_2026_06 3 0 0 0 0 0 0 146,712 59,745 80,374,119 43,000 850,466 rio.public.temp0000281979 3 0 0 0 0 0 0 456 18 29,935 0 0 rio.public.temp0000281949 3 0 0 0 0 0 0 3,117 11 185,647 0 0 rio.public.temp0000281867 3 0 0 0 0 0 0 289 93 149,931 0 0 rio.public.temp0000281523 3 0 0 0 0 0 0 100 16 8,104 0 0 rio.public.temp0000281879 3 0 0 0 0 0 0 69 16 6,415 0 0 rio.public.temp0000281919 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000281945 2 0 0 0 0 0 0 188 12 12,949 0 0 rio.public.temp0000281969 2 0 0 0 0 0 0 3,114 1,561 2,160,663 0 0 rio.public.tmp_drill_0302 2 1 0 0 0 0 0 34 5 6,954 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,242 765 2,813,111 590 4,089 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 413 181 525,568 82 3,967 rio.public.temp0000281943 1 0 0 0 0 0 0 88 6 6,107 0 0 rio.public.temp0000281871 1 0 0 0 0 0 0 8 5 1,274 0 0 rio.public.temp0000281865 1 0 0 0 0 0 0 73 6 5,194 0 0 rio.public.temp0000281877 1 0 0 0 0 0 0 8 5 1,274 0 0 rio.public.temp0000281885 1 0 0 0 0 0 0 73 6 5,196 0 0 rio.public.temp0000281951 1 0 0 0 0 0 0 1,558 4 92,525 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 81 35 116,974 14 2,590 rio.public.temp0000281901 1 0 0 0 0 0 0 1,554 4 92,289 0 0 rio.public.temp0000281893 1 0 0 0 0 0 0 8 5 1,285 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 13,132 7,685 9,722,777 2,674 48,155 rio.public.temp0000281873 1 0 0 0 0 0 0 8 5 1,274 0 0 rio.public.temp0000281957 1 0 0 0 0 0 0 90 6 6,230 0 0 rio.public.temp0000281301 1 0 0 0 0 0 0 8 5 1,214 0 0 rio.public.temp0000281967 1 0 0 0 0 0 0 100 6 6,842 0 0 rio.public.temp0000281883 1 0 0 0 0 0 0 1,558 4 92,525 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 120 30 77,842 9 17 contagem.public.temp0000226348 1 0 0 0 0 0 0 92 6 6,351 0 0 rio.public.temp0000281869 1 0 0 0 0 0 0 73 6 5,193 0 0 rio.public.temp0000281881 1 0 0 0 0 0 0 8 5 1,218 0 0 Total 601 240 0 0 0 0 0 382,171 99,558 157,523,033 49,052 931,755 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (20.46) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000281855 0 0 2.23 rio.pg_catalog.pg_attribute 0 0 4.4 rio.pg_catalog.pg_class 0 0 1.12 rio.pg_catalog.pg_type 0 0 0.52 rio.public.temp0000281955 0 0 1.42 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_index 0 0 0.27 rio.public.temp0000281937 0 0 0.46 rio.public.temp0000281889 0 0 0.86 rio.public.temp0000281897 0 0 0.16 contagem.pg_catalog.pg_attribute 0 0 1.23 rio.pg_catalog.pg_depend 0 0 0.93 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_statistic 0 0 1.6 template1.pg_catalog.pg_shdepend 0 0 0.5 rio.public.temp0000281335 0 0 0.12 contagem.pg_catalog.pg_class 0 0 0.26 rio.public.temp0000281925 0 0 0.11 rio.public.temp0000281923 0 0 0.06 rio.public.tmp_drill_0175 0 0 0.09 contagem.pg_catalog.pg_type 0 0 0.09 contagem.public.temp0000226346 0 0 0.07 rio.pg_toast.pg_toast_2619 0 0 0.15 rio.public.temp0000281791 0 0 0.07 contagem.pg_catalog.pg_depend 0 0 0.27 rio.public.temp0000281939 0 0 0.2 contagem.pg_catalog.pg_index 0 0 0.08 rio.public.temp0000281875 0 0 0.05 rio.public.temp0000281769 0 0 0.03 rio.auditor.auditor_2026_06 0 0 20.46 rio.public.temp0000281979 0 0 0.05 rio.public.temp0000281949 0 0 0.16 rio.public.temp0000281867 0 0 0.04 rio.public.temp0000281523 0 0 0.02 rio.public.temp0000281879 0 0 0.01 rio.public.temp0000281919 0 0 0.08 rio.public.temp0000281945 0 0 0.01 rio.public.temp0000281969 0 0 0.11 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.27 rio.public.nf_entrada_arquivo_erros 0 0 0.19 rio.public.temp0000281943 0 0 0.01 rio.public.temp0000281871 0 0 0.01 rio.public.temp0000281865 0 0 0.01 rio.public.temp0000281877 0 0 0.01 rio.public.temp0000281885 0 0 0.01 rio.public.temp0000281951 0 0 0.05 rio.public.equipamentos_referencia 0 0 0.01 rio.public.temp0000281901 0 0 0.04 rio.public.temp0000281893 0 0 0.01 contagem.auditor.auditor_2026_06 0 0 2.65 rio.public.temp0000281873 0 0 0.01 rio.public.temp0000281957 0 0 0.01 rio.public.temp0000281301 0 0 0 rio.public.temp0000281967 0 0 0.01 rio.public.temp0000281883 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.public.temp0000226348 0 0 0.01 rio.public.temp0000281869 0 0 0.01 rio.public.temp0000281881 0 0 0 Total 0 0 41.66 Tuples removed per table
Key values
- pg_catalog.pg_attribute (251460) Main table with removed tuples on database rio
- 426413 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 78 55 251,460 2,057,710 236,781 312 51,333 contagem.pg_catalog.pg_attribute 16 16 49,580 389,190 0 87 8,436 rio.public.tmp_drill_0175 7 4 38,449 40,213 762 0 1,006 rio.pg_catalog.pg_statistic 11 11 19,103 94,346 140 0 14,146 rio.pg_catalog.pg_depend 15 15 13,845 288,856 1,786 16 2,751 rio.pg_catalog.pg_type 44 31 11,940 112,672 11,790 49 3,192 template1.pg_catalog.pg_shdepend 10 10 8,668 93,285 556 0 1,010 rio.pg_catalog.pg_index 25 21 6,692 51,308 2,963 9 1,500 rio.pg_catalog.pg_class 55 34 5,114 245,015 37,019 112 7,862 contagem.pg_catalog.pg_statistic 2 2 4,916 14,949 0 0 2,022 contagem.pg_catalog.pg_depend 5 5 4,284 94,258 0 0 880 rio.auditor.auditor_2026_06 3 0 3,160 17,298,594 0 0 797,680 contagem.pg_catalog.pg_class 9 9 2,912 28,645 0 0 1,278 contagem.public.usuarios 28 0 1,779 644 0 0 56 contagem.pg_catalog.pg_type 7 7 1,547 15,745 0 7 447 rio.pg_toast.pg_toast_2619 7 7 1,385 3,213 0 0 1,757 contagem.pg_catalog.pg_index 5 5 773 9,691 205 5 251 rio.public.usuarios 14 6 368 9,050 1,954 0 224 rio.public.tmp_drill_0302 2 1 240 748 254 0 14 contagem.pg_toast.pg_toast_2619 1 1 104 113 0 0 51 rio.public.nf_entrada_arquivo_erros 1 0 94 8,237,200 0 0 146,719 rio.public.temp0000281943 1 0 0 1,705 0 48 80 rio.public.temp0000281919 2 0 0 43,774 0 0 3,200 rio.public.temp0000281871 1 0 0 1,473 0 63 65 rio.public.temp0000281979 3 0 0 18,934 0 144 432 rio.public.temp0000281945 2 0 0 3,625 0 84 172 rio.public.temp0000281865 1 0 0 1,471 0 63 65 rio.public.temp0000281923 7 0 0 34,092 0 179 781 rio.public.temp0000281939 5 0 0 89,399 0 48 6,480 rio.public.temp0000281889 19 0 0 415,693 0 0 30,400 rio.public.temp0000281877 1 0 0 1,473 0 63 65 rio.public.temp0000281885 1 0 0 1,474 0 63 65 rio.public.temp0000281949 3 0 0 65,716 0 0 4,800 rio.public.temp0000281951 1 0 0 21,925 0 0 1,600 rio.public.temp0000281955 29 0 0 615,724 0 33 44,895 rio.public.temp0000281867 3 0 0 11,729 0 119 265 rio.public.equipamentos_referencia 1 0 0 5,027,015 0 0 27,174 rio.public.temp0000281901 1 0 0 21,870 0 0 1,600 rio.public.temp0000281875 4 0 0 6,033 0 244 268 rio.public.temp0000281937 20 0 0 200,585 0 425 12,439 rio.public.temp0000281855 80 0 0 901,796 0 1,920 64,000 contagem.public.temp0000226346 7 0 0 7,627 0 308 588 rio.public.temp0000281893 1 0 0 1,520 0 60 68 contagem.auditor.auditor_2026_06 1 0 0 964,745 0 0 42,435 rio.public.temp0000281873 1 0 0 1,473 0 63 65 rio.public.temp0000281969 2 0 0 43,834 0 0 3,200 rio.public.temp0000281523 3 0 0 3,530 0 16 80 rio.public.temp0000281957 1 0 0 1,732 0 46 82 rio.public.temp0000281925 8 0 0 41,349 0 382 2,114 rio.public.temp0000281897 18 0 0 65,977 0 650 1,494 rio.public.temp0000281301 1 0 0 1,603 0 28 36 rio.public.temp0000281967 1 0 0 1,920 0 36 92 rio.public.temp0000281883 1 0 0 21,925 0 0 1,600 rio.public.temp0000281769 4 0 0 8,758 0 27 197 rio.public.temp0000281879 3 0 0 5,832 0 61 131 rio.public.temp0000281791 6 0 0 11,478 0 113 239 contagem.public.temp0000226348 1 0 0 1,086 0 44 84 rio.public.temp0000281335 10 0 0 46,208 0 294 1,050 rio.public.temp0000281869 1 0 0 1,472 0 63 65 rio.public.temp0000281881 1 0 0 1,644 0 27 37 Total 601 240 426,413 37,804,664 294,210 6,311 1,295,118 Pages removed per table
Key values
- public.temp0000281855 (1920) Main table with removed pages on database rio
- 6311 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000281855 80 0 0 1920 rio.public.temp0000281897 18 0 0 650 rio.public.temp0000281937 20 0 0 425 rio.public.temp0000281925 8 0 0 382 rio.pg_catalog.pg_attribute 78 55 251460 312 contagem.public.temp0000226346 7 0 0 308 rio.public.temp0000281335 10 0 0 294 rio.public.temp0000281875 4 0 0 244 rio.public.temp0000281923 7 0 0 179 rio.public.temp0000281979 3 0 0 144 rio.public.temp0000281867 3 0 0 119 rio.public.temp0000281791 6 0 0 113 rio.pg_catalog.pg_class 55 34 5114 112 contagem.pg_catalog.pg_attribute 16 16 49580 87 rio.public.temp0000281945 2 0 0 84 rio.public.temp0000281871 1 0 0 63 rio.public.temp0000281865 1 0 0 63 rio.public.temp0000281877 1 0 0 63 rio.public.temp0000281885 1 0 0 63 rio.public.temp0000281873 1 0 0 63 rio.public.temp0000281869 1 0 0 63 rio.public.temp0000281879 3 0 0 61 rio.public.temp0000281893 1 0 0 60 rio.pg_catalog.pg_type 44 31 11940 49 rio.public.temp0000281943 1 0 0 48 rio.public.temp0000281939 5 0 0 48 rio.public.temp0000281957 1 0 0 46 contagem.public.temp0000226348 1 0 0 44 rio.public.temp0000281967 1 0 0 36 rio.public.temp0000281955 29 0 0 33 rio.public.temp0000281301 1 0 0 28 rio.public.temp0000281769 4 0 0 27 rio.public.temp0000281881 1 0 0 27 rio.pg_catalog.pg_depend 15 15 13845 16 rio.public.temp0000281523 3 0 0 16 rio.pg_catalog.pg_index 25 21 6692 9 contagem.pg_catalog.pg_type 7 7 1547 7 contagem.pg_catalog.pg_index 5 5 773 5 contagem.pg_catalog.pg_depend 5 5 4284 0 rio.public.nf_entrada_arquivo_erros 1 0 94 0 rio.auditor.auditor_2026_06 3 0 3160 0 rio.public.temp0000281919 2 0 0 0 rio.public.temp0000281889 19 0 0 0 rio.public.tmp_drill_0175 7 4 38449 0 rio.public.temp0000281949 3 0 0 0 rio.pg_catalog.pg_statistic 11 11 19103 0 rio.public.temp0000281951 1 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 rio.public.temp0000281901 1 0 0 0 contagem.pg_catalog.pg_class 9 9 2912 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.public.temp0000281969 2 0 0 0 rio.pg_toast.pg_toast_2619 7 7 1385 0 template1.pg_catalog.pg_shdepend 10 10 8668 0 rio.public.temp0000281883 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 104 0 rio.public.tmp_drill_0302 2 1 240 0 rio.public.usuarios 14 6 368 0 contagem.pg_catalog.pg_statistic 2 2 4916 0 contagem.public.usuarios 28 0 1779 0 Total 601 240 426,413 6,311 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 4 0 06 0 0 07 17 27 08 46 100 09 78 153 10 51 131 11 125 142 12 13 45 13 52 111 14 70 151 15 62 157 16 54 115 17 26 58 18 0 0 19 0 0 20 0 0 21 3 1 22 0 0 23 0 0 - 7.73 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1m16s 1m16s 1m16s 1m16s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 08:46:38 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 00:05:19 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 20:15:13 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1 1s2ms 1s2ms 1s2ms 1s2ms drop table if exists temp0000281925;-
DROP TABLE IF EXISTS temp0000281925;
Date: 2026-06-08 11:53:54 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000281925;
Date: 2026-06-08 11:53:54 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 1 1s 1s 1s 1s drop table if exists temp0000281855;-
DROP TABLE IF EXISTS temp0000281855;
Date: 2026-06-08 16:05:58 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000281855;
Date: 2026-06-08 08:41:52 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000281855;
Date: 2026-06-08 09:03:53 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 1 1s 1s 1s 1s drop table if exists temp0000281937;-
DROP TABLE IF EXISTS temp0000281937;
Date: 2026-06-08 13:19:56 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000281937;
Date: 2026-06-08 13:19:56 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Queries that waited the most
Rank Wait time Query 1 1m16s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-08 08:46:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s2ms DROP TABLE IF EXISTS temp0000281925;[ Date: 2026-06-08 11:53:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000281855;[ Date: 2026-06-08 16:05:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000281937;[ Date: 2026-06-08 13:19:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,875 Total read queries
- 1,378 Total write queries
Queries by database
Key values
- rio Main database
- 5,541 Requests
- 7h29m48s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,853 Requests
User Request type Count Duration etiquetas Total 20 4s554ms select 20 4s554ms intelifix Total 6,853 10h17m10s copy to 539 1h10m16s ddl 1,107 56m26s others 359 46m14s select 4,847 7h24m13s lenon Total 90 1m8s select 90 1m8s Duration by user
Key values
- 10h17m10s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 20 4s554ms select 20 4s554ms intelifix Total 6,853 10h17m10s copy to 539 1h10m16s ddl 1,107 56m26s others 359 46m14s select 4,847 7h24m13s lenon Total 90 1m8s select 90 1m8s Queries by host
Key values
- [local] Main host
- 6,963 Requests
- 10h18m23s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,758 Requests
- 4h20m29s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-08 11:39:59 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,427 100-500ms duration
Slowest individual queries
Rank Duration Query 1 15m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025270, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-06-08 11:49:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 13m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 09:18:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 11m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 07:16:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 15:15:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 12:14:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 20:13:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m18s analyze verbose;[ Date: 2026-06-08 05:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 16:12:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 17:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 10:11:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 11:11:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 14:11:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 08:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025239, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-08 07:17:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 13:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025294, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-08 14:31:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 18:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 19:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-08 21:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025257, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-08 09:41:23 - 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 2h26m36s 293 150ms 15m31s 30s23ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 08 07 7 14m4s 2m 08 11 12m29s 1m8s 09 41 14m32s 21s276ms 10 44 10m23s 14s180ms 11 26 30m58s 1m11s 12 6 9m8s 1m31s 13 28 2m40s 5s727ms 14 47 26m8s 33s375ms 15 34 14m30s 25s599ms 16 30 8m40s 17s359ms 17 19 2m59s 9s462ms [ User: intelifix - Total duration: 2h26m36s - Times executed: 293 ]
[ Application: [unknown] - Total duration: 2h26m36s - Times executed: 293 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025270, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-08 11:49:49 Duration: 15m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025239, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-08 07:17:28 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025294, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-08 14:31:21 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 2h1m2s 32 1s41ms 13m16s 3m46s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 08 07 2 11m47s 5m53s 08 2 6m14s 3m7s 09 2 13m21s 6m40s 10 2 6m40s 3m20s 11 2 6m32s 3m16s 12 2 9m16s 4m38s 13 2 6m1s 3m 14 2 6m31s 3m15s 15 2 10m36s 5m18s 16 2 7m8s 3m34s 17 2 6m37s 3m18s 18 2 5m36s 2m48s 19 2 5m30s 2m45s 20 2 8m40s 4m20s 21 2 5m24s 2m42s 22 2 5m2s 2m31s [ User: intelifix - Total duration: 2h1m2s - Times executed: 32 ]
[ Application: psql - Total duration: 2h1m2s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-08 09:18:17 Duration: 13m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-08 07:16:45 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-08 15:15:35 Duration: 10m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 27m3s 1,510 150ms 7s615ms 1s75ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 08 07 4 1s849ms 462ms 08 133 2m18s 1s38ms 09 195 3m49s 1s176ms 10 180 3m21s 1s121ms 11 174 3m3s 1s52ms 12 61 53s338ms 874ms 13 118 2m7s 1s82ms 14 230 4m14s 1s107ms 15 186 3m22s 1s89ms 16 174 2m46s 958ms 17 55 1m3s 1s163ms [ User: intelifix - Total duration: 27m3s - Times executed: 1510 ]
[ Application: [unknown] - Total duration: 27m3s - Times executed: 1510 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249668, 450, '71616085850025101390,216698722836,184330218400,216408157272,216554216061,216613404554H011713315,216679208091,216504781316,216863277391H010993293,216618077288,216798809304,216837333535,216814866168,216515871624,216557350622H010993290,216618076985H010909800,216563683136,216905871313,216871774663,216859688892,216861107987,216695921519,216836575268,216411709808,216515477185,216514114460,216733662430,216615617878,216695843352,216353122643,216861809403,216866185969H010998824,216628065558,216701634242,216732043540,216831872228,216832954769,216734051739H010994179,216618165860,216337170110,216553469210', '',062,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-08 10:20:16 Duration: 7s615ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40769, 418, 'ZTE3ANNRCB71253,D831392454FC,D831392454FD,ZTEGDD2ACBEA$ZTE3ANNQ4A03477,3CF9F0AA49C4,3CF9F0AA49C5,ZTEGD6414C54$ZTE3ANNRAM22653,5872C9894B27,5872C9894B28,ZTEGDC60587C$ZTE3ANNR9F14566,D89A0DA43347,D89A0DA43348,ZTEGDB156031$ZTE3ANNRCB03492,D831391E20D6,D831391E20D7,ZTEGDD29C339$ZTE3ANNR3Y01825,4896D94FEB7E,4896D94FEB7F,ZTEGD97E37D6$ZTE3ANNRC501389,6C11BA624A65,6C11BA624A66,ZTEGDC6E1B2C$ZTE3ANNQ8M39558,843C9922670F,843C99226710,ZTEGD7BAE1F3$ZTE3ANNR8C27924,38914851157F,389148511580,ZTEGDB08ED84$ZTE3ANNRCP43791,6C11BA6D2D29,6C11BA6D2D2A,ZTEGDC6FEBA2$ZTE3ANNR5W07926,48D6822F3D8E,48D6822F3D8F,ZTEGDB001EF5$ZTE3ANNQ6M07032,C4EBFF8906A0,C4EBFF8906A1,ZTEGD709FC86$ZTE3ANNR7B16723,3891484A7499,3891484A749A,ZTEGDB07D2B3$ZTE3ANNR5W05785,48D6822F0B60,48D6822F0B61,ZTEGDB001698$ZTE3ANNR3Y03478,4896D950123C,4896D950123D,ZTEGD97E3E4B$ZTE3ANNR4N25361,4896D957AD7E,4896D957AD7F,ZTEGD97F82D6$ZTE3ANNR7B32923,3891484BF049,3891484BF04A,ZTEGDB0811FB$ZTE3ANNRC551424,6C11BA66DF17,6C11BA66DF18,ZTEGDC6EDE9F$ZTE3ANNR2Q31580,F4E84F839828,F4E84F839829,ZTEGD97AEE16$ZTE3ANNQ9J35674,843C992F1551,843C992F1552,ZTEGD7BB9405$ZTE3ANNR2Q37340,F4E84F841F28,F4E84F841F29,ZTEGD97B0496$ZTE3ANNR8C25630,38914850DFBB,38914850DFBC,ZTEGDB08E48E$ZTE3ANNRB721126,5872C9902855,5872C9902856,ZTEGDC617D59$ZTE3ANNQ5N08832,3CF9F0AD9476,3CF9F0AD9477,ZTEGD641D8C7$ZTE3ANNT2V71491,D83139921A6A,D83139921A6B,ZTEGDD3109C2$ZTE3ANNQ9J04919,843C992C447F,843C992C4480,ZTEGD7BB1BE2$ZTE3ANNR2Q31650,F4E84F8399CC,F4E84F8399CD,ZTEGD97AEE5C$ZTE3ANNQ4A00351,3CF9F0AA0080,3CF9F0AA0081,ZTEGD641401E$ZTE3ANNR3J06095,F4E84F86DD3A,F4E84F86DD3B,ZTEGD97B7999$ZTE3ANNR3Y22281,4896D951CAEE,4896D951CAEF,ZTEGD97E87BE$ZTE3ANNRAM61602,5872C98CDC05,5872C98CDC06,ZTEGDC60F0A1$ZTE3ANNT3H68775,D831399D0F82,D831399D0F83,ZTEGDD32DD46$ZTE3ANNQ4414402,3CF9F0ACB06A,3CF9F0ACB06B,ZTEGD641B2C5$ZTE3ANNR4N25418,4896D957AED4,4896D957AED5,ZTEGD97F830F$ZTE3ANNR8C27970,389148511693,389148511694,ZTEGDB08EDB2$ZTE3ANNRC560049,6C11BA67A93D,6C11BA67A93E,ZTEGDC6F0050$ZTE3ANNQ3R01190,3CF9F0A29BAA,3CF9F0A29BAB,ZTEGD64004A5$ZTE3ANNQ4N00773,3CF9F0A8A3CC,3CF9F0A8A3CD,ZTEGD6410600$ZTE3ANNQ8123203,689E29BDFE9D,689E29BDFE9E,ZTEGD7B79533$ZTE3ANNQ4A03777,3CF9F0AA50CC,3CF9F0AA50CD,ZTEGD6414D80$ZTE3ANNQ6M08131,C4EBFF892062,C4EBFF892063,ZTEGD70A00D1$ZTE3ANNQ8123458,689E29BE0497,689E29BE0498,ZTEGD7B79632$ZTE3ANNR2Q37331,F4E84F841EF2,F4E84F841EF3,ZTEGD97B048D', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-08 15:02:19 Duration: 6s506ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (250678, 450, '71431585850008208926,216395194358,216872271435,216753835476,216512384549,216865125877H011713256,216679202132,216870958084,216837056179,216688518507,216557520515,216336890610,216906197584,216865212126,216500875255,216520783652,216696833942,216550023554,216404032830,216872235875,216698955361,216859189595,216608814555,216738623655,216792141628,216501828793,216699475165,216333621537,216738371633,216616926480,216859513242H010925004,216607118586,216558232032,216402939198,216349690726,184329734256,216545065561,216399979000,184334760819,216688630213,216879104256', '',062,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-08 16:26:42 Duration: 6s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 18m10s 108 8s3ms 13s288ms 10s98ms create table temp0000281855 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 08 07 19 2m47s 8s831ms 08 11 1m54s 10s375ms 09 17 2m58s 10s506ms 10 7 1m11s 10s169ms 11 10 1m45s 10s518ms 12 8 1m15s 9s437ms 14 15 2m42s 10s815ms 15 15 2m37s 10s521ms 16 6 58s139ms 9s689ms [ User: intelifix - Total duration: 18m10s - Times executed: 108 ]
[ Application: [unknown] - Total duration: 18m10s - Times executed: 108 ]
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 08:41:14 Duration: 13s288ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 09:02:45 Duration: 12s778ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 11:11:04 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 11m51s 32 431ms 1m37s 22s219ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 08 07 2 1m34s 47s386ms 08 2 32s925ms 16s462ms 09 2 1m39s 49s961ms 10 2 40s308ms 20s154ms 11 2 32s873ms 16s436ms 12 2 45s513ms 22s756ms 13 2 31s843ms 15s921ms 14 2 35s96ms 17s548ms 15 2 52s707ms 26s353ms 16 2 40s296ms 20s148ms 17 2 30s155ms 15s77ms 18 2 28s901ms 14s450ms 19 2 28s223ms 14s111ms 20 2 1m1s 30s535ms 21 2 29s546ms 14s773ms 22 2 26s875ms 13s437ms [ User: intelifix - Total duration: 11m51s - Times executed: 32 ]
[ Application: psql - Total duration: 11m51s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-08 09:19:55 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-08 07:18:18 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-08 20:14:38 Duration: 59s621ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 10m57s 1,071 150ms 8s150ms 613ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 08 07 2 1s650ms 825ms 08 119 1m38s 831ms 09 132 1m21s 615ms 10 129 1m16s 596ms 11 138 1m13s 534ms 13 143 1m26s 607ms 14 133 1m21s 610ms 15 179 1m39s 557ms 16 78 47s225ms 605ms 17 18 9s933ms 551ms [ User: intelifix - Total duration: 10m57s - Times executed: 1071 ]
[ Application: [unknown] - Total duration: 10m57s - Times executed: 1071 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241638370014,241708650711,241619667581,241711645256,241703473954,241651078302,241700339898,241631610914,241619996581,241617776970,241715536163,241619541229,241628136466,241649199106,241637372228,241603733636,241620654861,241599479910,241704791120,241712817278,241630662426,241663269514,241708240615,241714244455,241677640210,241667917273,241658535965,241667766170,241712616675,241675455776,241608893141,241635170824,241599433643,241652424561,241712799599,241679386384,241672678300,241616268091,241598860019,241691733347,241658573242,241601877697,241628163035,241691523854,241694452232,241660449912,241715538890", "usuario" : "405", "caixa" : "2757616", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-08 08:23:04 Duration: 8s150ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "62", "itens" : "216819248694,216335685071,216398105764,216547428799,216697580312,216404373548,216799624546,216396778901,216634641229,216834460618,216413330113,216862335773", "usuario" : "405", "caixa" : "2727519", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-08 15:30:44 Duration: 5s477ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "240365", "modelo" : "189", "itens" : "F09BB855CEEF,A4178B0046A3,B85FB0061609,BC76C5B46F55,9C73709D2E5A,44E968005D5D,6C442A90D483,2868D21750F7,F09BB8562048,903FEA08E33B,E8136E752AEF,6C442A934131,482CD08F7B8C,FC73FBBEABEA,44E9680112C9", "usuario" : "405", "caixa" : "2857656", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-08 10:54:37 Duration: 4s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 10m30s 2 2m11s 8m18s 5m15s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 08 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-08 05:08:20 Duration: 8m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-06-08 05:10:32 Duration: 2m11s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 8m56s 136 2s506ms 1m20s 3s947ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 08 00 6 32s331ms 5s388ms 01 6 16s752ms 2s792ms 02 6 17s224ms 2s870ms 03 5 15s 3s 04 6 16s581ms 2s763ms 05 6 16s920ms 2s820ms 06 6 16s642ms 2s773ms 07 6 18s38ms 3s6ms 08 6 1m39s 16s592ms 09 6 19s981ms 3s330ms 10 6 21s983ms 3s663ms 11 6 22s112ms 3s685ms 12 5 15s696ms 3s139ms 13 6 20s468ms 3s411ms 14 6 24s197ms 4s32ms 15 6 23s763ms 3s960ms 16 6 20s108ms 3s351ms 17 6 20s373ms 3s395ms 18 6 18s82ms 3s13ms 19 6 17s157ms 2s859ms 20 6 29s471ms 4s911ms 21 6 16s701ms 2s783ms 22 6 17s772ms 2s962ms [ User: intelifix - Total duration: 8m56s - Times executed: 136 ]
[ Application: psql - Total duration: 8m56s - Times executed: 136 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 08:46:38 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 00:05:19 Duration: 18s75ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 20:15:13 Duration: 11s701ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 7m36s 66 177ms 16s106ms 6s921ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 08 00 1 411ms 411ms 07 5 53s602ms 10s720ms 08 6 1m11s 11s903ms 09 6 48s338ms 8s56ms 10 6 46s766ms 7s794ms 11 6 46s679ms 7s779ms 12 6 42s89ms 7s14ms 13 1 2s641ms 2s641ms 14 5 33s145ms 6s629ms 15 6 53s934ms 8s989ms 16 6 42s643ms 7s107ms 20 1 313ms 313ms 21 5 7s689ms 1s537ms 22 6 7s168ms 1s194ms [ User: intelifix - Total duration: 7m36s - Times executed: 66 ]
[ Application: psql - Total duration: 7m36s - Times executed: 66 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-08 08:45:17 Duration: 16s106ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-08 07:45:17 Duration: 15s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-08 08:25:16 Duration: 14s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 6m35s 39 8s491ms 12s538ms 10s135ms create table temp0000281955 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 08 14 8 1m25s 10s720ms 15 11 1m50s 10s44ms 16 13 2m12s 10s177ms 17 7 1m6s 9s530ms [ User: intelifix - Total duration: 6m35s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 6m35s - Times executed: 39 ]
-
CREATE TABLE temp0000281955 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 14:42:21 Duration: 12s538ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281955 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 14:59:28 Duration: 12s139ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281955 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 16:37:24 Duration: 11s808ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 6m27s 30 8s197ms 27s15ms 12s901ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 08 08 2 41s520ms 20s760ms 09 7 1m10s 10s55ms 11 3 46s880ms 15s626ms 12 1 12s847ms 12s847ms 13 1 10s734ms 10s734ms 14 3 38s846ms 12s948ms 15 5 1m6s 13s207ms 16 3 39s884ms 13s294ms 17 5 59s893ms 11s978ms [ User: intelifix - Total duration: 6m27s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m27s - Times executed: 30 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-08', 099, '', '', 0, 6, '2026-06-01');
Date: 2026-06-08 08:43:56 Duration: 27s15ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-08', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-08 11:50:18 Duration: 17s213ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-08', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-08 15:11:35 Duration: 17s91ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 5m32s 87 2s477ms 20s375ms 3s817ms create table temp0000281855 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 08 07 15 59s498ms 3s966ms 08 12 40s427ms 3s368ms 09 12 42s718ms 3s559ms 10 6 21s812ms 3s635ms 11 10 38s263ms 3s826ms 12 10 35s910ms 3s591ms 14 6 23s943ms 3s990ms 15 10 42s269ms 4s226ms 16 6 27s279ms 4s546ms [ User: intelifix - Total duration: 5m32s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 5m32s - Times executed: 87 ]
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 07:20:54 Duration: 20s375ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 16:18:55 Duration: 5s422ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 11:40:27 Duration: 4s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 5m5s 81 155ms 1m 3s769ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 08 07 7 7s116ms 1s16ms 08 5 10s508ms 2s101ms 09 12 34s677ms 2s889ms 10 4 3s802ms 950ms 11 12 1m 5s56ms 12 3 1s731ms 577ms 13 12 1m3s 5s293ms 14 8 51s86ms 6s385ms 15 9 20s459ms 2s273ms 16 6 47s499ms 7s916ms 17 3 4s247ms 1s415ms [ User: intelifix - Total duration: 5m5s - Times executed: 81 ]
[ Application: psql - Total duration: 5m5s - Times executed: 81 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025290);
Date: 2026-06-08 13:52:15 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025270);
Date: 2026-06-08 11:33:31 Duration: 46s800ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025296);
Date: 2026-06-08 14:42:34 Duration: 25s798ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 4m59s 29 8s737ms 12s99ms 10s321ms create table temp0000281889 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 08 08 3 33s483ms 11s161ms 09 14 2m19s 9s979ms 10 3 34s61ms 11s353ms 11 8 1m22s 10s309ms 12 1 9s593ms 9s593ms [ User: intelifix - Total duration: 4m59s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 29 ]
-
CREATE TABLE temp0000281889 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 08:40:31 Duration: 12s99ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281889 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 09:41:21 Duration: 11s576ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281889 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 10:47:40 Duration: 11s553ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 3m36s 22 7s882ms 12s61ms 9s850ms create table temp0000281937 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 08 13 22 3m36s 9s850ms [ User: intelifix - Total duration: 3m36s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 3m36s - Times executed: 22 ]
-
CREATE TABLE temp0000281937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 13:52:23 Duration: 12s61ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 13:47:55 Duration: 11s181ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 13:29:54 Duration: 10s902ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 2m49s 2 1m21s 1m28s 1m24s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 08 20 1 1m21s 1m21s 23 1 1m28s 1m28s [ User: intelifix - Total duration: 2m49s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m49s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-08 23:35:39 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-08 20:08:10 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 2m30s 59 153ms 28s243ms 2s548ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 08 07 4 32s49ms 8s12ms 08 4 5s169ms 1s292ms 09 10 29s865ms 2s986ms 10 5 9s481ms 1s896ms 11 6 10s484ms 1s747ms 12 2 2s494ms 1s247ms 13 9 18s71ms 2s7ms 14 6 15s390ms 2s565ms 15 6 7s584ms 1s264ms 16 5 18s690ms 3s738ms 17 2 1s80ms 540ms [ User: intelifix - Total duration: 2m30s - Times executed: 59 ]
[ Application: psql - Total duration: 2m30s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025239);
Date: 2026-06-08 07:11:23 Duration: 28s243ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025257);
Date: 2026-06-08 09:35:32 Duration: 8s896ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025252);
Date: 2026-06-08 09:03:49 Duration: 8s578ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 1m59s 190 151ms 4s352ms 629ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 08 08 5 2s621ms 524ms 09 23 24s908ms 1s82ms 10 39 22s881ms 586ms 11 3 899ms 299ms 13 24 12s583ms 524ms 14 33 21s203ms 642ms 15 19 11s788ms 620ms 16 29 15s449ms 532ms 17 15 7s343ms 489ms [ User: intelifix - Total duration: 1m59s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 1m59s - Times executed: 190 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249140) LIMIT 1;
Date: 2026-06-08 09:56:01 Duration: 4s352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249139) LIMIT 1;
Date: 2026-06-08 10:06:28 Duration: 3s36ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0250703) LIMIT 1;
Date: 2026-06-08 16:21:45 Duration: 2s324ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 1m51s 2 51s299ms 1m 55s853ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 08 20 1 1m 1m 23 1 51s299ms 51s299ms [ User: intelifix - Total duration: 1m51s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-08 20:05:14 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-08 23:17:16 Duration: 51s299ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 1m49s 2 18s849ms 1m30s 54s561ms 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 #20
Day Hour Count Duration Avg duration Jun 08 23 2 1m49s 54s561ms [ User: intelifix - Total duration: 1m49s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m49s - 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-08 23:13:52 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
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-08 23:37:00 Duration: 18s849ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,510 27m3s 150ms 7s615ms 1s75ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 08 07 4 1s849ms 462ms 08 133 2m18s 1s38ms 09 195 3m49s 1s176ms 10 180 3m21s 1s121ms 11 174 3m3s 1s52ms 12 61 53s338ms 874ms 13 118 2m7s 1s82ms 14 230 4m14s 1s107ms 15 186 3m22s 1s89ms 16 174 2m46s 958ms 17 55 1m3s 1s163ms [ User: intelifix - Total duration: 27m3s - Times executed: 1510 ]
[ Application: [unknown] - Total duration: 27m3s - Times executed: 1510 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249668, 450, '71616085850025101390,216698722836,184330218400,216408157272,216554216061,216613404554H011713315,216679208091,216504781316,216863277391H010993293,216618077288,216798809304,216837333535,216814866168,216515871624,216557350622H010993290,216618076985H010909800,216563683136,216905871313,216871774663,216859688892,216861107987,216695921519,216836575268,216411709808,216515477185,216514114460,216733662430,216615617878,216695843352,216353122643,216861809403,216866185969H010998824,216628065558,216701634242,216732043540,216831872228,216832954769,216734051739H010994179,216618165860,216337170110,216553469210', '',062,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-08 10:20:16 Duration: 7s615ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40769, 418, 'ZTE3ANNRCB71253,D831392454FC,D831392454FD,ZTEGDD2ACBEA$ZTE3ANNQ4A03477,3CF9F0AA49C4,3CF9F0AA49C5,ZTEGD6414C54$ZTE3ANNRAM22653,5872C9894B27,5872C9894B28,ZTEGDC60587C$ZTE3ANNR9F14566,D89A0DA43347,D89A0DA43348,ZTEGDB156031$ZTE3ANNRCB03492,D831391E20D6,D831391E20D7,ZTEGDD29C339$ZTE3ANNR3Y01825,4896D94FEB7E,4896D94FEB7F,ZTEGD97E37D6$ZTE3ANNRC501389,6C11BA624A65,6C11BA624A66,ZTEGDC6E1B2C$ZTE3ANNQ8M39558,843C9922670F,843C99226710,ZTEGD7BAE1F3$ZTE3ANNR8C27924,38914851157F,389148511580,ZTEGDB08ED84$ZTE3ANNRCP43791,6C11BA6D2D29,6C11BA6D2D2A,ZTEGDC6FEBA2$ZTE3ANNR5W07926,48D6822F3D8E,48D6822F3D8F,ZTEGDB001EF5$ZTE3ANNQ6M07032,C4EBFF8906A0,C4EBFF8906A1,ZTEGD709FC86$ZTE3ANNR7B16723,3891484A7499,3891484A749A,ZTEGDB07D2B3$ZTE3ANNR5W05785,48D6822F0B60,48D6822F0B61,ZTEGDB001698$ZTE3ANNR3Y03478,4896D950123C,4896D950123D,ZTEGD97E3E4B$ZTE3ANNR4N25361,4896D957AD7E,4896D957AD7F,ZTEGD97F82D6$ZTE3ANNR7B32923,3891484BF049,3891484BF04A,ZTEGDB0811FB$ZTE3ANNRC551424,6C11BA66DF17,6C11BA66DF18,ZTEGDC6EDE9F$ZTE3ANNR2Q31580,F4E84F839828,F4E84F839829,ZTEGD97AEE16$ZTE3ANNQ9J35674,843C992F1551,843C992F1552,ZTEGD7BB9405$ZTE3ANNR2Q37340,F4E84F841F28,F4E84F841F29,ZTEGD97B0496$ZTE3ANNR8C25630,38914850DFBB,38914850DFBC,ZTEGDB08E48E$ZTE3ANNRB721126,5872C9902855,5872C9902856,ZTEGDC617D59$ZTE3ANNQ5N08832,3CF9F0AD9476,3CF9F0AD9477,ZTEGD641D8C7$ZTE3ANNT2V71491,D83139921A6A,D83139921A6B,ZTEGDD3109C2$ZTE3ANNQ9J04919,843C992C447F,843C992C4480,ZTEGD7BB1BE2$ZTE3ANNR2Q31650,F4E84F8399CC,F4E84F8399CD,ZTEGD97AEE5C$ZTE3ANNQ4A00351,3CF9F0AA0080,3CF9F0AA0081,ZTEGD641401E$ZTE3ANNR3J06095,F4E84F86DD3A,F4E84F86DD3B,ZTEGD97B7999$ZTE3ANNR3Y22281,4896D951CAEE,4896D951CAEF,ZTEGD97E87BE$ZTE3ANNRAM61602,5872C98CDC05,5872C98CDC06,ZTEGDC60F0A1$ZTE3ANNT3H68775,D831399D0F82,D831399D0F83,ZTEGDD32DD46$ZTE3ANNQ4414402,3CF9F0ACB06A,3CF9F0ACB06B,ZTEGD641B2C5$ZTE3ANNR4N25418,4896D957AED4,4896D957AED5,ZTEGD97F830F$ZTE3ANNR8C27970,389148511693,389148511694,ZTEGDB08EDB2$ZTE3ANNRC560049,6C11BA67A93D,6C11BA67A93E,ZTEGDC6F0050$ZTE3ANNQ3R01190,3CF9F0A29BAA,3CF9F0A29BAB,ZTEGD64004A5$ZTE3ANNQ4N00773,3CF9F0A8A3CC,3CF9F0A8A3CD,ZTEGD6410600$ZTE3ANNQ8123203,689E29BDFE9D,689E29BDFE9E,ZTEGD7B79533$ZTE3ANNQ4A03777,3CF9F0AA50CC,3CF9F0AA50CD,ZTEGD6414D80$ZTE3ANNQ6M08131,C4EBFF892062,C4EBFF892063,ZTEGD70A00D1$ZTE3ANNQ8123458,689E29BE0497,689E29BE0498,ZTEGD7B79632$ZTE3ANNR2Q37331,F4E84F841EF2,F4E84F841EF3,ZTEGD97B048D', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-08 15:02:19 Duration: 6s506ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (250678, 450, '71431585850008208926,216395194358,216872271435,216753835476,216512384549,216865125877H011713256,216679202132,216870958084,216837056179,216688518507,216557520515,216336890610,216906197584,216865212126,216500875255,216520783652,216696833942,216550023554,216404032830,216872235875,216698955361,216859189595,216608814555,216738623655,216792141628,216501828793,216699475165,216333621537,216738371633,216616926480,216859513242H010925004,216607118586,216558232032,216402939198,216349690726,184329734256,216545065561,216399979000,184334760819,216688630213,216879104256', '',062,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-08 16:26:42 Duration: 6s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1,071 10m57s 150ms 8s150ms 613ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 08 07 2 1s650ms 825ms 08 119 1m38s 831ms 09 132 1m21s 615ms 10 129 1m16s 596ms 11 138 1m13s 534ms 13 143 1m26s 607ms 14 133 1m21s 610ms 15 179 1m39s 557ms 16 78 47s225ms 605ms 17 18 9s933ms 551ms [ User: intelifix - Total duration: 10m57s - Times executed: 1071 ]
[ Application: [unknown] - Total duration: 10m57s - Times executed: 1071 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241638370014,241708650711,241619667581,241711645256,241703473954,241651078302,241700339898,241631610914,241619996581,241617776970,241715536163,241619541229,241628136466,241649199106,241637372228,241603733636,241620654861,241599479910,241704791120,241712817278,241630662426,241663269514,241708240615,241714244455,241677640210,241667917273,241658535965,241667766170,241712616675,241675455776,241608893141,241635170824,241599433643,241652424561,241712799599,241679386384,241672678300,241616268091,241598860019,241691733347,241658573242,241601877697,241628163035,241691523854,241694452232,241660449912,241715538890", "usuario" : "405", "caixa" : "2757616", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-08 08:23:04 Duration: 8s150ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "62", "itens" : "216819248694,216335685071,216398105764,216547428799,216697580312,216404373548,216799624546,216396778901,216634641229,216834460618,216413330113,216862335773", "usuario" : "405", "caixa" : "2727519", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-08 15:30:44 Duration: 5s477ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "240365", "modelo" : "189", "itens" : "F09BB855CEEF,A4178B0046A3,B85FB0061609,BC76C5B46F55,9C73709D2E5A,44E968005D5D,6C442A90D483,2868D21750F7,F09BB8562048,903FEA08E33B,E8136E752AEF,6C442A934131,482CD08F7B8C,FC73FBBEABEA,44E9680112C9", "usuario" : "405", "caixa" : "2857656", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-08 10:54:37 Duration: 4s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 293 2h26m36s 150ms 15m31s 30s23ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 08 07 7 14m4s 2m 08 11 12m29s 1m8s 09 41 14m32s 21s276ms 10 44 10m23s 14s180ms 11 26 30m58s 1m11s 12 6 9m8s 1m31s 13 28 2m40s 5s727ms 14 47 26m8s 33s375ms 15 34 14m30s 25s599ms 16 30 8m40s 17s359ms 17 19 2m59s 9s462ms [ User: intelifix - Total duration: 2h26m36s - Times executed: 293 ]
[ Application: [unknown] - Total duration: 2h26m36s - Times executed: 293 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025270, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-08 11:49:49 Duration: 15m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025239, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-08 07:17:28 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025294, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-08 14:31:21 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 227 59s106ms 150ms 738ms 260ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 08 07 31 8s944ms 288ms 08 22 6s255ms 284ms 09 24 6s679ms 278ms 10 29 6s945ms 239ms 11 26 6s695ms 257ms 12 33 7s934ms 240ms 13 1 164ms 164ms 14 23 5s894ms 256ms 15 29 7s604ms 262ms 16 7 1s569ms 224ms 17 2 417ms 208ms [ User: intelifix - Total duration: 59s106ms - Times executed: 227 ]
[ Application: [unknown] - Total duration: 59s106ms - Times executed: 227 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216567572831,216794185968,216854864146,216526624446,216642533233,216647323050,216565552028,216841577383,216811272844,216854630005,216892650113', NULL, NULL, 064, 00);
Date: 2026-06-08 07:06:25 Duration: 738ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '216515059109,184270402944,216618263547,216733913240,216616296385,216616593036,216868265970,216697372940,216559505152,216832108187', NULL, NULL, 062, 00);
Date: 2026-06-08 09:53:42 Duration: 618ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '743AEF95A35F,9877E702FD52,840112806A79,743AEFAB9E36,743AEF9D32E3,9877E77C2CBC,743AEF74D82C,840112040E60,9877E70095D0,84011205AF03,9877E74E9484,9877E7BC43F9,1834AF27A172,84011295ACF1,743AEF74EFDA,9877E7BFC581,743AEFD9D70C,9877E7BFD9C4', NULL, NULL, 0153, 00);
Date: 2026-06-08 09:45:09 Duration: 599ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 190 1m59s 151ms 4s352ms 629ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 08 08 5 2s621ms 524ms 09 23 24s908ms 1s82ms 10 39 22s881ms 586ms 11 3 899ms 299ms 13 24 12s583ms 524ms 14 33 21s203ms 642ms 15 19 11s788ms 620ms 16 29 15s449ms 532ms 17 15 7s343ms 489ms [ User: intelifix - Total duration: 1m59s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 1m59s - Times executed: 190 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249140) LIMIT 1;
Date: 2026-06-08 09:56:01 Duration: 4s352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249139) LIMIT 1;
Date: 2026-06-08 10:06:28 Duration: 3s36ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0250703) LIMIT 1;
Date: 2026-06-08 16:21:45 Duration: 2s324ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 186 52s342ms 150ms 1s44ms 281ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 08 11 1 668ms 668ms 12 7 2s302ms 328ms 13 110 29s885ms 271ms 14 66 17s787ms 269ms 17 2 1s698ms 849ms [ User: intelifix - Total duration: 52s342ms - Times executed: 186 ]
[ Application: [unknown] - Total duration: 52s342ms - Times executed: 186 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40355","seriais":"6802B8F807F5,6802B8A239D0,6802B8653814,6802B8CB5584,6802B8CB46F6,6802B8DFB19D,B4F2670C3498,6802B8A3B76C,6802B85A7086,6802B85B174E,B4F26757ADA1,6802B8A4D568,B4F2670C2AB1,6802B8DE8C9F,6802B8ABE997","usuario":"406","observacao":""}');
Date: 2026-06-08 17:11:02 Duration: 1s44ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40355","seriais":"94988F93BB8E,4C195DF9E5A6,943C96AE57D5,841EA397D07B,94988F93C757,B0FC88EB7957,38A6591ABE7B,943C96AC732A","usuario":"406","observacao":""}');
Date: 2026-06-08 14:08:07 Duration: 752ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40945","seriais":"181267031527,181265076767,177109433737,184054110006","usuario":"406","observacao":""}');
Date: 2026-06-08 11:59:58 Duration: 668ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 136 8m56s 2s506ms 1m20s 3s947ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 08 00 6 32s331ms 5s388ms 01 6 16s752ms 2s792ms 02 6 17s224ms 2s870ms 03 5 15s 3s 04 6 16s581ms 2s763ms 05 6 16s920ms 2s820ms 06 6 16s642ms 2s773ms 07 6 18s38ms 3s6ms 08 6 1m39s 16s592ms 09 6 19s981ms 3s330ms 10 6 21s983ms 3s663ms 11 6 22s112ms 3s685ms 12 5 15s696ms 3s139ms 13 6 20s468ms 3s411ms 14 6 24s197ms 4s32ms 15 6 23s763ms 3s960ms 16 6 20s108ms 3s351ms 17 6 20s373ms 3s395ms 18 6 18s82ms 3s13ms 19 6 17s157ms 2s859ms 20 6 29s471ms 4s911ms 21 6 16s701ms 2s783ms 22 6 17s772ms 2s962ms [ User: intelifix - Total duration: 8m56s - Times executed: 136 ]
[ Application: psql - Total duration: 8m56s - Times executed: 136 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 08:46:38 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 00:05:19 Duration: 18s75ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 20:15:13 Duration: 11s701ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 127 20s516ms 150ms 190ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 08 07 2 337ms 168ms 08 23 3s701ms 160ms 09 17 2s784ms 163ms 10 10 1s600ms 160ms 11 16 2s580ms 161ms 12 4 637ms 159ms 13 8 1s275ms 159ms 14 16 2s577ms 161ms 15 16 2s583ms 161ms 16 8 1s306ms 163ms 17 7 1s131ms 161ms [ User: intelifix - Total duration: 20s516ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 20s516ms - Times executed: 127 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-08 15:54:38 Duration: 190ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0153;
Date: 2026-06-08 08:56:03 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-08 10:08:47 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 120 39s812ms 150ms 16s29ms 331ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 08 07 1 238ms 238ms 08 1 189ms 189ms 09 3 835ms 278ms 10 1 203ms 203ms 11 1 161ms 161ms 12 3 1s123ms 374ms 13 2 302ms 151ms 14 18 3s813ms 211ms 15 29 6s277ms 216ms 16 41 23s71ms 562ms 17 20 3s596ms 179ms [ User: intelifix - Total duration: 39s812ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 39s812ms - Times executed: 120 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-08", "data-ate" : "2026-06-08", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-06-08 16:02:18 Duration: 16s29ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-08", "data-ate" : "2026-06-08", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-08 15:17:10 Duration: 836ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-06-08", "data-ate" : "2026-06-08", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 404 }');
Date: 2026-06-08 14:54:24 Duration: 689ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 108 18m10s 8s3ms 13s288ms 10s98ms create table temp0000281855 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 08 07 19 2m47s 8s831ms 08 11 1m54s 10s375ms 09 17 2m58s 10s506ms 10 7 1m11s 10s169ms 11 10 1m45s 10s518ms 12 8 1m15s 9s437ms 14 15 2m42s 10s815ms 15 15 2m37s 10s521ms 16 6 58s139ms 9s689ms [ User: intelifix - Total duration: 18m10s - Times executed: 108 ]
[ Application: [unknown] - Total duration: 18m10s - Times executed: 108 ]
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 08:41:14 Duration: 13s288ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 09:02:45 Duration: 12s778ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 11:11:04 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 105 21s571ms 150ms 478ms 205ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 08 07 7 1s816ms 259ms 08 6 1s515ms 252ms 09 9 1s890ms 210ms 10 16 3s19ms 188ms 11 13 2s487ms 191ms 12 5 1s175ms 235ms 13 13 2s733ms 210ms 14 15 2s847ms 189ms 15 16 2s900ms 181ms 16 5 1s184ms 236ms [ User: intelifix - Total duration: 21s571ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 21s571ms - Times executed: 105 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"137", "usuario" :"320", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-08 07:21:04 Duration: 478ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"126", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-08 10:19:14 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"320", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-08 08:56:44 Duration: 292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 87 5m32s 2s477ms 20s375ms 3s817ms create table temp0000281855 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 08 07 15 59s498ms 3s966ms 08 12 40s427ms 3s368ms 09 12 42s718ms 3s559ms 10 6 21s812ms 3s635ms 11 10 38s263ms 3s826ms 12 10 35s910ms 3s591ms 14 6 23s943ms 3s990ms 15 10 42s269ms 4s226ms 16 6 27s279ms 4s546ms [ User: intelifix - Total duration: 5m32s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 5m32s - Times executed: 87 ]
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 07:20:54 Duration: 20s375ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 16:18:55 Duration: 5s422ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 11:40:27 Duration: 4s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 86 29s347ms 150ms 1s356ms 341ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 08 08 21 10s293ms 490ms 09 22 8s578ms 389ms 10 5 1s95ms 219ms 11 12 3s417ms 284ms 12 3 822ms 274ms 14 11 2s483ms 225ms 15 11 2s266ms 206ms 17 1 389ms 389ms [ User: intelifix - Total duration: 29s347ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 29s347ms - Times executed: 86 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '647B1EEE1A2E,20354318E3E3,203543143B6D,B0924A12810B,CC5830020543,CC5830FDC1D1,3817B1980107,B01FF41A6840,20354353EAF5,5447CCE3923B,20B82B25BC4E,64FA2B6370FD,5447CCCC74A9,D8CF61631592', '77;1', 'DEFAULT', 09, 0302, '','', '', 00);
Date: 2026-06-08 09:15:31 Duration: 1s356ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '743AEF950AC4,9877E70C3967,1834AF9A79D6,743AEF7696E3,840112806DDD,9877E74BD830,9877E74B8040,743AEF5C59CC,84011238488A,743AEFD95458,9877E7BD070B,1834AF2787C5', '95;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-06-08 08:28:52 Duration: 1s271ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '840112374EEB,84011228B653,840112379EA7,743AEF5DE82B,8401129862D1,1834AF9A3B38,84011260441E,9877E7490C9A,9877E708B6CE', '95;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-06-08 08:25:42 Duration: 1s138ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 82 35s634ms 264ms 767ms 434ms 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 08 06 1 405ms 405ms 07 4 1s491ms 372ms 08 7 3s228ms 461ms 09 9 3s717ms 413ms 10 8 3s667ms 458ms 11 9 3s957ms 439ms 12 5 1s983ms 396ms 13 10 4s412ms 441ms 14 9 3s735ms 415ms 15 7 3s77ms 439ms 16 6 2s830ms 471ms 17 5 2s214ms 442ms 21 2 912ms 456ms [ User: lenon - Total duration: 35s634ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 35s634ms - Times executed: 82 ]
-
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-08 08:29:07 Duration: 767ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
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-08 14:25:20 Duration: 741ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
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-08 11:08:15 Duration: 692ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 81 5m5s 155ms 1m 3s769ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 08 07 7 7s116ms 1s16ms 08 5 10s508ms 2s101ms 09 12 34s677ms 2s889ms 10 4 3s802ms 950ms 11 12 1m 5s56ms 12 3 1s731ms 577ms 13 12 1m3s 5s293ms 14 8 51s86ms 6s385ms 15 9 20s459ms 2s273ms 16 6 47s499ms 7s916ms 17 3 4s247ms 1s415ms [ User: intelifix - Total duration: 5m5s - Times executed: 81 ]
[ Application: psql - Total duration: 5m5s - Times executed: 81 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025290);
Date: 2026-06-08 13:52:15 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025270);
Date: 2026-06-08 11:33:31 Duration: 46s800ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025296);
Date: 2026-06-08 14:42:34 Duration: 25s798ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 81 25s732ms 172ms 509ms 317ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 08 08 46 15s377ms 334ms 10 16 4s756ms 297ms 11 1 437ms 437ms 12 1 290ms 290ms 15 17 4s870ms 286ms [ User: intelifix - Total duration: 25s732ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 25s732ms - Times executed: 81 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-06-08 08:25:17 Duration: 509ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (230007);
Date: 2026-06-08 08:22:24 Duration: 485ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (230007);
Date: 2026-06-08 08:27:19 Duration: 466ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 80 42s870ms 339ms 969ms 535ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 08 07 4 1s851ms 462ms 08 7 3s967ms 566ms 09 9 4s668ms 518ms 10 8 4s535ms 566ms 11 9 4s757ms 528ms 12 5 2s515ms 503ms 13 10 5s390ms 539ms 14 9 4s635ms 515ms 15 7 3s880ms 554ms 16 6 3s500ms 583ms 17 5 2s697ms 539ms 21 1 470ms 470ms [ User: intelifix - Total duration: 42s870ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 42s870ms - Times executed: 80 ]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-06-08 08:29:07 Duration: 969ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
select * from rs_menu_grants (405, 21, 1);
Date: 2026-06-08 14:25:20 Duration: 819ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-06-08 11:08:15 Duration: 761ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 79 1m6s 152ms 17s529ms 840ms create table temp0000281791 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 08 08 16 18s697ms 1s168ms 09 10 2s191ms 219ms 10 19 19s604ms 1s31ms 11 5 1s154ms 230ms 13 3 997ms 332ms 14 10 2s642ms 264ms 15 11 19s951ms 1s813ms 16 5 1s168ms 233ms [ User: intelifix - Total duration: 1m6s - Times executed: 79 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 79 ]
-
CREATE TABLE temp0000281791 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "227013", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-06-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-08 15:29:47 Duration: 17s529ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281791 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-06-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-08 08:23:55 Duration: 14s560ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281791 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "240365", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-06-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-08 10:52:39 Duration: 9s31ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 79 29s244ms 236ms 611ms 370ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 08 07 6 2s148ms 358ms 08 3 1s444ms 481ms 09 13 4s471ms 343ms 10 5 1s890ms 378ms 11 10 3s285ms 328ms 12 3 1s384ms 461ms 13 13 4s915ms 378ms 14 9 3s444ms 382ms 15 10 3s810ms 381ms 16 4 1s370ms 342ms 17 3 1s78ms 359ms [ User: intelifix - Total duration: 29s244ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 29s244ms - Times executed: 79 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-06-08 12:02:47 Duration: 611ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-08 13:39:19 Duration: 578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-08 14:46:51 Duration: 547ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 78 39s155ms 183ms 3s932ms 501ms create table temp0000281885 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 08 08 17 11s150ms 655ms 09 25 16s110ms 644ms 10 4 3s582ms 895ms 12 3 614ms 204ms 13 3 696ms 232ms 14 13 3s365ms 258ms 15 9 2s432ms 270ms 16 4 1s203ms 300ms [ User: intelifix - Total duration: 39s155ms - Times executed: 78 ]
[ Application: [unknown] - Total duration: 39s155ms - Times executed: 78 ]
-
CREATE TABLE temp0000281885 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 09:33:21 Duration: 3s932ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281885 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 08:33:07 Duration: 3s586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281885 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-06-2026", "ate" :"08-06-2026", "nota-fiscal":"1084", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 10:27:14 Duration: 2s793ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m11s 8m18s 5m15s 2 10m30s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 08 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-08 05:08:20 Duration: 8m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-06-08 05:10:32 Duration: 2m11s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1s41ms 13m16s 3m46s 32 2h1m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 08 07 2 11m47s 5m53s 08 2 6m14s 3m7s 09 2 13m21s 6m40s 10 2 6m40s 3m20s 11 2 6m32s 3m16s 12 2 9m16s 4m38s 13 2 6m1s 3m 14 2 6m31s 3m15s 15 2 10m36s 5m18s 16 2 7m8s 3m34s 17 2 6m37s 3m18s 18 2 5m36s 2m48s 19 2 5m30s 2m45s 20 2 8m40s 4m20s 21 2 5m24s 2m42s 22 2 5m2s 2m31s [ User: intelifix - Total duration: 2h1m2s - Times executed: 32 ]
[ Application: psql - Total duration: 2h1m2s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-08 09:18:17 Duration: 13m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-08 07:16:45 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-08 15:15:35 Duration: 10m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 1m21s 1m28s 1m24s 2 2m49s 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 08 20 1 1m21s 1m21s 23 1 1m28s 1m28s [ User: intelifix - Total duration: 2m49s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m49s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-08 23:35:39 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-08 20:08:10 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 51s299ms 1m 55s853ms 2 1m51s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 08 20 1 1m 1m 23 1 51s299ms 51s299ms [ User: intelifix - Total duration: 1m51s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-08 20:05:14 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-08 23:17:16 Duration: 51s299ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 18s849ms 1m30s 54s561ms 2 1m49s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 08 23 2 1m49s 54s561ms [ User: intelifix - Total duration: 1m49s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m49s - 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-08 23:13:52 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
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-08 23:37:00 Duration: 18s849ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 150ms 15m31s 30s23ms 293 2h26m36s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 08 07 7 14m4s 2m 08 11 12m29s 1m8s 09 41 14m32s 21s276ms 10 44 10m23s 14s180ms 11 26 30m58s 1m11s 12 6 9m8s 1m31s 13 28 2m40s 5s727ms 14 47 26m8s 33s375ms 15 34 14m30s 25s599ms 16 30 8m40s 17s359ms 17 19 2m59s 9s462ms [ User: intelifix - Total duration: 2h26m36s - Times executed: 293 ]
[ Application: [unknown] - Total duration: 2h26m36s - Times executed: 293 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025270, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-08 11:49:49 Duration: 15m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025239, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-08 07:17:28 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025294, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-08 14:31:21 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 431ms 1m37s 22s219ms 32 11m51s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 08 07 2 1m34s 47s386ms 08 2 32s925ms 16s462ms 09 2 1m39s 49s961ms 10 2 40s308ms 20s154ms 11 2 32s873ms 16s436ms 12 2 45s513ms 22s756ms 13 2 31s843ms 15s921ms 14 2 35s96ms 17s548ms 15 2 52s707ms 26s353ms 16 2 40s296ms 20s148ms 17 2 30s155ms 15s77ms 18 2 28s901ms 14s450ms 19 2 28s223ms 14s111ms 20 2 1m1s 30s535ms 21 2 29s546ms 14s773ms 22 2 26s875ms 13s437ms [ User: intelifix - Total duration: 11m51s - Times executed: 32 ]
[ Application: psql - Total duration: 11m51s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-08 09:19:55 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-08 07:18:18 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-08 20:14:38 Duration: 59s621ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 8s197ms 27s15ms 12s901ms 30 6m27s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 08 08 2 41s520ms 20s760ms 09 7 1m10s 10s55ms 11 3 46s880ms 15s626ms 12 1 12s847ms 12s847ms 13 1 10s734ms 10s734ms 14 3 38s846ms 12s948ms 15 5 1m6s 13s207ms 16 3 39s884ms 13s294ms 17 5 59s893ms 11s978ms [ User: intelifix - Total duration: 6m27s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m27s - Times executed: 30 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-08', 099, '', '', 0, 6, '2026-06-01');
Date: 2026-06-08 08:43:56 Duration: 27s15ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-08', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-08 11:50:18 Duration: 17s213ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-08', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-08 15:11:35 Duration: 17s91ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 8s737ms 12s99ms 10s321ms 29 4m59s create table temp0000281889 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 08 08 3 33s483ms 11s161ms 09 14 2m19s 9s979ms 10 3 34s61ms 11s353ms 11 8 1m22s 10s309ms 12 1 9s593ms 9s593ms [ User: intelifix - Total duration: 4m59s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 29 ]
-
CREATE TABLE temp0000281889 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 08:40:31 Duration: 12s99ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281889 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 09:41:21 Duration: 11s576ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281889 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 10:47:40 Duration: 11s553ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 8s491ms 12s538ms 10s135ms 39 6m35s create table temp0000281955 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 08 14 8 1m25s 10s720ms 15 11 1m50s 10s44ms 16 13 2m12s 10s177ms 17 7 1m6s 9s530ms [ User: intelifix - Total duration: 6m35s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 6m35s - Times executed: 39 ]
-
CREATE TABLE temp0000281955 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 14:42:21 Duration: 12s538ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281955 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 14:59:28 Duration: 12s139ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281955 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 16:37:24 Duration: 11s808ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 8s3ms 13s288ms 10s98ms 108 18m10s create table temp0000281855 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 08 07 19 2m47s 8s831ms 08 11 1m54s 10s375ms 09 17 2m58s 10s506ms 10 7 1m11s 10s169ms 11 10 1m45s 10s518ms 12 8 1m15s 9s437ms 14 15 2m42s 10s815ms 15 15 2m37s 10s521ms 16 6 58s139ms 9s689ms [ User: intelifix - Total duration: 18m10s - Times executed: 108 ]
[ Application: [unknown] - Total duration: 18m10s - Times executed: 108 ]
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 08:41:14 Duration: 13s288ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 09:02:45 Duration: 12s778ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 11:11:04 Duration: 12s334ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 7s882ms 12s61ms 9s850ms 22 3m36s create table temp0000281937 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 08 13 22 3m36s 9s850ms [ User: intelifix - Total duration: 3m36s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 3m36s - Times executed: 22 ]
-
CREATE TABLE temp0000281937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 13:52:23 Duration: 12s61ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 13:47:55 Duration: 11s181ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-08 13:29:54 Duration: 10s902ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 177ms 16s106ms 6s921ms 66 7m36s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 08 00 1 411ms 411ms 07 5 53s602ms 10s720ms 08 6 1m11s 11s903ms 09 6 48s338ms 8s56ms 10 6 46s766ms 7s794ms 11 6 46s679ms 7s779ms 12 6 42s89ms 7s14ms 13 1 2s641ms 2s641ms 14 5 33s145ms 6s629ms 15 6 53s934ms 8s989ms 16 6 42s643ms 7s107ms 20 1 313ms 313ms 21 5 7s689ms 1s537ms 22 6 7s168ms 1s194ms [ User: intelifix - Total duration: 7m36s - Times executed: 66 ]
[ Application: psql - Total duration: 7m36s - Times executed: 66 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-08 08:45:17 Duration: 16s106ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-08 07:45:17 Duration: 15s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-08 08:25:16 Duration: 14s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 2s506ms 1m20s 3s947ms 136 8m56s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 08 00 6 32s331ms 5s388ms 01 6 16s752ms 2s792ms 02 6 17s224ms 2s870ms 03 5 15s 3s 04 6 16s581ms 2s763ms 05 6 16s920ms 2s820ms 06 6 16s642ms 2s773ms 07 6 18s38ms 3s6ms 08 6 1m39s 16s592ms 09 6 19s981ms 3s330ms 10 6 21s983ms 3s663ms 11 6 22s112ms 3s685ms 12 5 15s696ms 3s139ms 13 6 20s468ms 3s411ms 14 6 24s197ms 4s32ms 15 6 23s763ms 3s960ms 16 6 20s108ms 3s351ms 17 6 20s373ms 3s395ms 18 6 18s82ms 3s13ms 19 6 17s157ms 2s859ms 20 6 29s471ms 4s911ms 21 6 16s701ms 2s783ms 22 6 17s772ms 2s962ms [ User: intelifix - Total duration: 8m56s - Times executed: 136 ]
[ Application: psql - Total duration: 8m56s - Times executed: 136 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 08:46:38 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 00:05:19 Duration: 18s75ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-08 20:15:13 Duration: 11s701ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 2s477ms 20s375ms 3s817ms 87 5m32s create table temp0000281855 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 08 07 15 59s498ms 3s966ms 08 12 40s427ms 3s368ms 09 12 42s718ms 3s559ms 10 6 21s812ms 3s635ms 11 10 38s263ms 3s826ms 12 10 35s910ms 3s591ms 14 6 23s943ms 3s990ms 15 10 42s269ms 4s226ms 16 6 27s279ms 4s546ms [ User: intelifix - Total duration: 5m32s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 5m32s - Times executed: 87 ]
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 07:20:54 Duration: 20s375ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 16:18:55 Duration: 5s422ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281855 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-06-2026", "ate" :"08-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-08 11:40:27 Duration: 4s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 155ms 1m 3s769ms 81 5m5s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 08 07 7 7s116ms 1s16ms 08 5 10s508ms 2s101ms 09 12 34s677ms 2s889ms 10 4 3s802ms 950ms 11 12 1m 5s56ms 12 3 1s731ms 577ms 13 12 1m3s 5s293ms 14 8 51s86ms 6s385ms 15 9 20s459ms 2s273ms 16 6 47s499ms 7s916ms 17 3 4s247ms 1s415ms [ User: intelifix - Total duration: 5m5s - Times executed: 81 ]
[ Application: psql - Total duration: 5m5s - Times executed: 81 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025290);
Date: 2026-06-08 13:52:15 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025270);
Date: 2026-06-08 11:33:31 Duration: 46s800ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025296);
Date: 2026-06-08 14:42:34 Duration: 25s798ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 153ms 28s243ms 2s548ms 59 2m30s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 08 07 4 32s49ms 8s12ms 08 4 5s169ms 1s292ms 09 10 29s865ms 2s986ms 10 5 9s481ms 1s896ms 11 6 10s484ms 1s747ms 12 2 2s494ms 1s247ms 13 9 18s71ms 2s7ms 14 6 15s390ms 2s565ms 15 6 7s584ms 1s264ms 16 5 18s690ms 3s738ms 17 2 1s80ms 540ms [ User: intelifix - Total duration: 2m30s - Times executed: 59 ]
[ Application: psql - Total duration: 2m30s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025239);
Date: 2026-06-08 07:11:23 Duration: 28s243ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025257);
Date: 2026-06-08 09:35:32 Duration: 8s896ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025252);
Date: 2026-06-08 09:03:49 Duration: 8s578ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 150ms 7s615ms 1s75ms 1,510 27m3s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 08 07 4 1s849ms 462ms 08 133 2m18s 1s38ms 09 195 3m49s 1s176ms 10 180 3m21s 1s121ms 11 174 3m3s 1s52ms 12 61 53s338ms 874ms 13 118 2m7s 1s82ms 14 230 4m14s 1s107ms 15 186 3m22s 1s89ms 16 174 2m46s 958ms 17 55 1m3s 1s163ms [ User: intelifix - Total duration: 27m3s - Times executed: 1510 ]
[ Application: [unknown] - Total duration: 27m3s - Times executed: 1510 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (249668, 450, '71616085850025101390,216698722836,184330218400,216408157272,216554216061,216613404554H011713315,216679208091,216504781316,216863277391H010993293,216618077288,216798809304,216837333535,216814866168,216515871624,216557350622H010993290,216618076985H010909800,216563683136,216905871313,216871774663,216859688892,216861107987,216695921519,216836575268,216411709808,216515477185,216514114460,216733662430,216615617878,216695843352,216353122643,216861809403,216866185969H010998824,216628065558,216701634242,216732043540,216831872228,216832954769,216734051739H010994179,216618165860,216337170110,216553469210', '',062,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-08 10:20:16 Duration: 7s615ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (40769, 418, 'ZTE3ANNRCB71253,D831392454FC,D831392454FD,ZTEGDD2ACBEA$ZTE3ANNQ4A03477,3CF9F0AA49C4,3CF9F0AA49C5,ZTEGD6414C54$ZTE3ANNRAM22653,5872C9894B27,5872C9894B28,ZTEGDC60587C$ZTE3ANNR9F14566,D89A0DA43347,D89A0DA43348,ZTEGDB156031$ZTE3ANNRCB03492,D831391E20D6,D831391E20D7,ZTEGDD29C339$ZTE3ANNR3Y01825,4896D94FEB7E,4896D94FEB7F,ZTEGD97E37D6$ZTE3ANNRC501389,6C11BA624A65,6C11BA624A66,ZTEGDC6E1B2C$ZTE3ANNQ8M39558,843C9922670F,843C99226710,ZTEGD7BAE1F3$ZTE3ANNR8C27924,38914851157F,389148511580,ZTEGDB08ED84$ZTE3ANNRCP43791,6C11BA6D2D29,6C11BA6D2D2A,ZTEGDC6FEBA2$ZTE3ANNR5W07926,48D6822F3D8E,48D6822F3D8F,ZTEGDB001EF5$ZTE3ANNQ6M07032,C4EBFF8906A0,C4EBFF8906A1,ZTEGD709FC86$ZTE3ANNR7B16723,3891484A7499,3891484A749A,ZTEGDB07D2B3$ZTE3ANNR5W05785,48D6822F0B60,48D6822F0B61,ZTEGDB001698$ZTE3ANNR3Y03478,4896D950123C,4896D950123D,ZTEGD97E3E4B$ZTE3ANNR4N25361,4896D957AD7E,4896D957AD7F,ZTEGD97F82D6$ZTE3ANNR7B32923,3891484BF049,3891484BF04A,ZTEGDB0811FB$ZTE3ANNRC551424,6C11BA66DF17,6C11BA66DF18,ZTEGDC6EDE9F$ZTE3ANNR2Q31580,F4E84F839828,F4E84F839829,ZTEGD97AEE16$ZTE3ANNQ9J35674,843C992F1551,843C992F1552,ZTEGD7BB9405$ZTE3ANNR2Q37340,F4E84F841F28,F4E84F841F29,ZTEGD97B0496$ZTE3ANNR8C25630,38914850DFBB,38914850DFBC,ZTEGDB08E48E$ZTE3ANNRB721126,5872C9902855,5872C9902856,ZTEGDC617D59$ZTE3ANNQ5N08832,3CF9F0AD9476,3CF9F0AD9477,ZTEGD641D8C7$ZTE3ANNT2V71491,D83139921A6A,D83139921A6B,ZTEGDD3109C2$ZTE3ANNQ9J04919,843C992C447F,843C992C4480,ZTEGD7BB1BE2$ZTE3ANNR2Q31650,F4E84F8399CC,F4E84F8399CD,ZTEGD97AEE5C$ZTE3ANNQ4A00351,3CF9F0AA0080,3CF9F0AA0081,ZTEGD641401E$ZTE3ANNR3J06095,F4E84F86DD3A,F4E84F86DD3B,ZTEGD97B7999$ZTE3ANNR3Y22281,4896D951CAEE,4896D951CAEF,ZTEGD97E87BE$ZTE3ANNRAM61602,5872C98CDC05,5872C98CDC06,ZTEGDC60F0A1$ZTE3ANNT3H68775,D831399D0F82,D831399D0F83,ZTEGDD32DD46$ZTE3ANNQ4414402,3CF9F0ACB06A,3CF9F0ACB06B,ZTEGD641B2C5$ZTE3ANNR4N25418,4896D957AED4,4896D957AED5,ZTEGD97F830F$ZTE3ANNR8C27970,389148511693,389148511694,ZTEGDB08EDB2$ZTE3ANNRC560049,6C11BA67A93D,6C11BA67A93E,ZTEGDC6F0050$ZTE3ANNQ3R01190,3CF9F0A29BAA,3CF9F0A29BAB,ZTEGD64004A5$ZTE3ANNQ4N00773,3CF9F0A8A3CC,3CF9F0A8A3CD,ZTEGD6410600$ZTE3ANNQ8123203,689E29BDFE9D,689E29BDFE9E,ZTEGD7B79533$ZTE3ANNQ4A03777,3CF9F0AA50CC,3CF9F0AA50CD,ZTEGD6414D80$ZTE3ANNQ6M08131,C4EBFF892062,C4EBFF892063,ZTEGD70A00D1$ZTE3ANNQ8123458,689E29BE0497,689E29BE0498,ZTEGD7B79632$ZTE3ANNR2Q37331,F4E84F841EF2,F4E84F841EF3,ZTEGD97B048D', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-08 15:02:19 Duration: 6s506ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (250678, 450, '71431585850008208926,216395194358,216872271435,216753835476,216512384549,216865125877H011713256,216679202132,216870958084,216837056179,216688518507,216557520515,216336890610,216906197584,216865212126,216500875255,216520783652,216696833942,216550023554,216404032830,216872235875,216698955361,216859189595,216608814555,216738623655,216792141628,216501828793,216699475165,216333621537,216738371633,216616926480,216859513242H010925004,216607118586,216558232032,216402939198,216349690726,184329734256,216545065561,216399979000,184334760819,216688630213,216879104256', '',062,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-08 16:26:42 Duration: 6s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 152ms 17s529ms 840ms 79 1m6s create table temp0000281791 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 08 08 16 18s697ms 1s168ms 09 10 2s191ms 219ms 10 19 19s604ms 1s31ms 11 5 1s154ms 230ms 13 3 997ms 332ms 14 10 2s642ms 264ms 15 11 19s951ms 1s813ms 16 5 1s168ms 233ms [ User: intelifix - Total duration: 1m6s - Times executed: 79 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 79 ]
-
CREATE TABLE temp0000281791 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "227013", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-06-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-08 15:29:47 Duration: 17s529ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281791 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-06-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-08 08:23:55 Duration: 14s560ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000281791 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "240365", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-06-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-08 10:52:39 Duration: 9s31ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 151ms 4s352ms 629ms 190 1m59s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 08 08 5 2s621ms 524ms 09 23 24s908ms 1s82ms 10 39 22s881ms 586ms 11 3 899ms 299ms 13 24 12s583ms 524ms 14 33 21s203ms 642ms 15 19 11s788ms 620ms 16 29 15s449ms 532ms 17 15 7s343ms 489ms [ User: intelifix - Total duration: 1m59s - Times executed: 190 ]
[ Application: [unknown] - Total duration: 1m59s - Times executed: 190 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249140) LIMIT 1;
Date: 2026-06-08 09:56:01 Duration: 4s352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0249139) LIMIT 1;
Date: 2026-06-08 10:06:28 Duration: 3s36ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0250703) LIMIT 1;
Date: 2026-06-08 16:21:45 Duration: 2s324ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 07 10 2 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 16 1 0ms 0ms [ User: intelifix - Total duration: 5m14s - Times executed: 5 ]
[ Application: psql - Total duration: 5m14s - Times executed: 5 ]
-
;
Date: Duration: 0ms Database: postgres User: contagem Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,705 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 424 FATAL entries
- 1620 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,554 Max number of times the same event was reported
- 2,054 Total events found
Rank Times reported Error 1 1,554 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 08 07 23 08 219 09 222 10 199 11 178 12 57 13 89 14 156 15 212 16 157 17 42 - ERROR: prepared statement "_PLAN000000003FB56A80" does not exist
- ERROR: prepared statement "_PLAN000000003FB50AB0" does not exist
- ERROR: prepared statement "_PLAN000000002417C9D0" does not exist
Statement: DEALLOCATE "_PLAN000000003FB56A80"
Date: 2026-06-08 07:35:41 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: DEALLOCATE "_PLAN000000003FB50AB0"
Date: 2026-06-08 07:36:35 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: DEALLOCATE "_PLAN000000002417C9D0"
Date: 2026-06-08 07:48:52 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 412 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 08 00 17 01 14 02 14 03 13 04 14 05 19 06 17 07 15 08 20 09 19 10 19 11 19 12 18 13 20 14 20 15 19 16 19 17 19 18 19 19 17 20 21 21 20 22 19 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-08 00:02:09 Database: brasilia Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-06-08 00:02:10 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-06-08 00:04:26 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 08 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-08 08:00:49 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
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-08 08:20:11 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
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-08 08:40:07 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 7 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 #4
Day Hour Count Jun 08 18 2 19 3 20 2 - FATAL: database "jaboatao" 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-08 18:38:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-06-08 18:55:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-06-08 19:15:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 4 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 08 09 2 15 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73905285850065607743)Date: 2026-06-08 09:47:50 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73905285850065607743)Date: 2026-06-08 09:47:51 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73926185850070402858)Date: 2026-06-08 15:22:36 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 08 14 2 17 2 - ERROR: syntax error at or near ":" at character 32
- ERROR: syntax error at or near ":" at character 32
- ERROR: syntax error at or near "]" at character 33
Statement: select * from rs_caixa_qr(https://a2techcon.ddns.net/recepcao_lote_carrega.php$1lote=40758&erro=&itens=0#:~:text=34%0A%2D%3E%3E%20Caixa-,106429,-Dados%20do%20Lote)
Date: 2026-06-08 14:22:12 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: select * from rs_caixa_qr(https://a2techcon.ddns.net/recepcao_lote_carrega.php$1lote=40758&erro=&itens=0#:~:text=34%0A%2D%3E%3E%20Caixa-,106429,-Dados%20do%20Lote)
Date: 2026-06-08 14:22:12 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: select * from rs_caixa_qr(106510])
Date: 2026-06-08 17:06:59 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 3 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 08 08 3 - ERROR: process 56745 detected deadlock while waiting for ShareLock on transaction 720508 after 1000.186 ms
- ERROR: process 56745 detected deadlock while waiting for ShareLock on transaction 720508 after 1000.203 ms
- ERROR: process 56745 detected deadlock while waiting for ShareLock on transaction 720508 after 1000.135 ms
Detail: Process holding the lock: 26863. Wait queue: .
Context: while updating tuple (69475,43) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment 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( 025249, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-06-08 08:46:07 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 26863. Wait queue: .
Context: while updating tuple (18718,85) 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( 025249, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-06-08 08:46:09 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 26863. Wait queue: .
Context: while updating tuple (18718,85) 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( 025249, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-06-08 08:46:11 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 08 11 1 13 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000281925"
Date: 2026-06-08 11:53:54 Log file: /usr/local/pgsql/data/log/serverlog-08.log
Context: automatic vacuum of table "rio.public.temp0000281937"
Date: 2026-06-08 13:19:56 Log file: /usr/local/pgsql/data/log/serverlog-08.log
Context: automatic vacuum of table "rio.public.temp0000281855"
Date: 2026-06-08 16:05:58 Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 3 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 08 03 3 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-08 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-06-08 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Context: PL/pgSQL expression "0" PL/pgSQL function rs_giga_triagem(character varying) line 28 during statement block local variable initialization
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-08 03:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 08 15 3 - ERROR: trailing junk after numeric literal at or near "34495B94D541" at character 27
- ERROR: trailing junk after numeric literal at or near "34495B94D541" at character 27
- ERROR: trailing junk after numeric literal at or near "34495B94D541" at character 27
Statement: SELECT * FROM RS_ETIQUETA(34495B94D541)
Date: 2026-06-08 15:46:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_ETIQUETA(34495B94D541)
Date: 2026-06-08 15:46:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_ETIQUETA(34495B94D541)
Date: 2026-06-08 15:46:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 08 08 3 - LOG: process 26863 still waiting for ShareLock on transaction 719762 after 1000.128 ms
- LOG: process 26863 still waiting for ShareLock on transaction 719762 after 5830.039 ms
- LOG: process 26863 still waiting for ShareLock on transaction 719762 after 65826.136 ms
Detail: Process holding the lock: 56745. Wait queue: 26863.
Context: while updating tuple (69475,36) 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-08 08:45:22 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 56745. Wait queue: 26863.
Context: while updating tuple (69475,36) 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-08 08:45:27 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 56745. Wait queue: 26863.
Context: while updating tuple (69475,36) 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-08 08:46:27 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 08 11 1 13 1 16 1 - LOG: process 216324 still waiting for AccessExclusiveLock on relation 861599 of database 358220 after 1000.152 ms
- LOG: process 300067 still waiting for AccessExclusiveLock on relation 863086 of database 358220 after 1000.133 ms
- LOG: process 494086 still waiting for AccessExclusiveLock on relation 886003 of database 358220 after 1000.184 ms
Detail: Process holding the lock: 274706. Wait queue: 216324.
Statement: DROP TABLE IF EXISTS temp0000281925;Date: 2026-06-08 11:53:54 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 309164. Wait queue: 300067.
Statement: DROP TABLE IF EXISTS temp0000281937;Date: 2026-06-08 13:19:56 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 499461. Wait queue: 494086.
Statement: DROP TABLE IF EXISTS temp0000281855;Date: 2026-06-08 16:05:58 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 08 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-08 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-08 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 08 11 1 14 1 - ERROR: column "cai_id" does not exist at character 39
- ERROR: column "cai_id" does not exist at character 39
Hint: Perhaps you meant to reference the column "temp0000226294.cli_id".
Statement: SELECT * FROM temp0000226294 ORDER BY CAI_ID DESCDate: 2026-06-08 11:56:02 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Hint: Perhaps you meant to reference the column "temp0000226294.cli_id".
Statement: SELECT * FROM temp0000226294 ORDER BY CAI_ID DESCDate: 2026-06-08 14:04:24 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 08 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-08 05:30:02 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
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-08 05:30:02 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 08 03 1 - LOG: database system was shut down at 2026-06-08 03:05:01 -03
Date: 2026-06-08 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 08 03 1 - FATAL: the database system is shutting down
Date: 2026-06-08 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 1 FATAL: database "..." does not exist NOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 08 07 1 - FATAL: database "brasilia" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-06-08 07:45:35 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 08 14 1 - ERROR: unterminated quoted string at or near "''''''''''''''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''''''''''''''');
Date: 2026-06-08 14:47:59 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log