pgBadger-
Global information
- Generated on Thu Jun 11 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 33,299 log entries in 7s
- Log start from 2026-06-11 00:02:01 to 2026-06-11 23:44:41
-
Overview
Global Stats
- 320 Number of unique normalized queries
- 6,002 Number of queries
- 6h14m26s Total query duration
- 2026-06-11 00:02:10 First query
- 2026-06-11 23:39:38 Last query
- 5 queries/s at 2026-06-11 10:48:23 Query peak
- 6h14m26s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h14m26s Execute total duration
- 2,018 Number of events
- 20 Number of unique normalized events
- 1,506 Max number of times the same event was reported
- 0 Number of cancellation
- 448 Total number of automatic vacuums
- 953 Total number of automatic analyzes
- 16 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 242 Total number of sessions
- 6 sessions at 2026-06-11 08:29:51 Session peak
- 9d30m7s Total duration of sessions
- 53m40s Average duration of sessions
- 24 Average queries per session
- 1m32s Average queries duration per session
- 52m7s Average idle time per session
- 248 Total number of connections
- 5 connections/s at 2026-06-11 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-11 10:48:23 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-11 10:48:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-11 23:39:25 Date
Queries duration
Key values
- 6h14m26s 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 11 00 18 0ms 18s902ms 4s736ms 9s934ms 57s342ms 57s342ms 01 12 0ms 2s938ms 1s926ms 4s727ms 4s727ms 4s727ms 02 12 359ms 2s911ms 1s621ms 3s850ms 3s850ms 3s850ms 03 11 0ms 3s772ms 1s751ms 5s269ms 5s269ms 5s269ms 04 40 0ms 3s63ms 815ms 4s22ms 4s585ms 5s934ms 05 20 0ms 8m6s 32s569ms 8s314ms 2m14s 8m6s 06 17 0ms 8s866ms 3s11ms 9s774ms 19s367ms 19s367ms 07 125 0ms 8m55s 11s91ms 53s275ms 3m34s 8m55s 08 538 0ms 5m58s 2s933ms 39s302ms 4m 7m2s 09 718 150ms 7m21s 3s173ms 1m23s 3m57s 7m43s 10 543 150ms 7m2s 3s683ms 1m19s 3m49s 7m47s 11 675 150ms 7m15s 2s895ms 40s865ms 3m55s 8m 12 129 0ms 6m16s 9s335ms 50s309ms 3m24s 7m15s 13 554 0ms 5m32s 1s446ms 24s5ms 33s959ms 5m32s 14 749 150ms 6m16s 2s241ms 53s319ms 1m15s 7m2s 15 625 150ms 6m 3s640ms 3m36s 4m17s 6m54s 16 529 150ms 7m25s 2s340ms 38s54ms 53s776ms 7m27s 17 342 0ms 5m58s 3s84ms 36s711ms 48s239ms 6m3s 18 12 0ms 5m41s 32s711ms 34s611ms 5m41s 5m41s 19 10 0ms 5m35s 37s870ms 29s747ms 5m35s 5m35s 20 67 0ms 5m45s 12s309ms 2m1s 5m45s 5m45s 21 17 0ms 5m22s 22s355ms 6s42ms 5m55s 5m55s 22 16 0ms 5m33s 24s226ms 31s955ms 5m33s 5m33s 23 223 0ms 1m33s 7s936ms 1m12s 1m31s 2m17s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 11 00 3 0 3s374ms 0ms 190ms 9s934ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 27 0 323ms 479ms 1s84ms 1s721ms 05 7 0 289ms 208ms 212ms 992ms 06 4 0 2s652ms 0ms 835ms 9s774ms 07 77 0 14s496ms 3s821ms 15s5ms 8m55s 08 407 0 2s980ms 8s249ms 27s981ms 4m3s 09 548 0 3s101ms 18s369ms 58s310ms 4m5s 10 435 0 3s710ms 18s915ms 58s892ms 3m49s 11 560 0 2s707ms 7s80ms 23s913ms 4m21s 12 94 0 11s189ms 2s103ms 50s309ms 3m34s 13 470 0 1s353ms 6s330ms 8s951ms 1m1s 14 626 0 2s134ms 14s707ms 51s301ms 4m13s 15 555 0 3s593ms 9s986ms 3m35s 4m42s 16 438 0 2s136ms 8s158ms 23s882ms 1m7s 17 242 0 2s774ms 6s862ms 22s519ms 52s53ms 18 6 0 1m2s 0ms 34s611ms 5m41s 19 4 0 1m31s 0ms 29s747ms 5m35s 20 6 55 13s252ms 57s797ms 2m 5m45s 21 7 0 51s 272ms 1s35ms 5m55s 22 4 0 1m31s 0ms 31s955ms 5m33s 23 5 218 7s936ms 1m5s 1m12s 2m17s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 11 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 11 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 4 4.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 6 6.00 0.00% 08 0 11 11.00 0.00% 09 0 9 9.00 0.00% 10 0 6 6.00 0.00% 11 0 7 7.00 0.00% 12 0 3 3.00 0.00% 13 0 8 8.00 0.00% 14 0 6 6.00 0.00% 15 0 8 8.00 0.00% 16 0 6 6.00 0.00% 17 0 3 3.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 11 00 12 0.00/s 01 5 0.00/s 02 5 0.00/s 03 7 0.00/s 04 7 0.00/s 05 7 0.00/s 06 10 0.00/s 07 11 0.00/s 08 17 0.00/s 09 17 0.00/s 10 16 0.00/s 11 17 0.00/s 12 9 0.00/s 13 17 0.00/s 14 15 0.00/s 15 18 0.01/s 16 15 0.00/s 17 8 0.00/s 18 6 0.00/s 19 3 0.00/s 20 8 0.00/s 21 7 0.00/s 22 5 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Jun 11 00 2 35m 34m17s 01 10 1h54s 1h51s 02 4 1h 59m55s 03 8 29m22s 29m20s 04 4 1h45s 1h37s 05 8 55m34s 54m12s 06 6 1h30s 1h22s 07 10 50m44s 48m26s 08 12 50m24s 48m13s 09 16 58m25s 56m2s 10 18 54m7s 52m16s 11 17 50m56s 49m1s 12 14 58m41s 57m15s 13 10 55m33s 54m13s 14 17 57m23s 55m44s 15 17 51m54s 49m41s 16 15 1h1s 58m38s 17 15 57m51s 56m40s 18 9 54m26s 53m43s 19 5 52m 50m44s 20 6 32m9s 29m51s 21 5 1h1m4s 59m48s 22 7 53m18s 52m22s 23 7 38m56s 34m44s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-11 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 248 connections Total
Connections per user
Key values
- intelifix Main User
- 248 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-11 08:29:51 Date
Histogram of session times
Key values
- 193 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 242 sessions Total
Sessions per user
Key values
- intelifix Main User
- 242 sessions Total
Sessions per host
Key values
- [local] Main Host
- 242 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 17,333 buffers Checkpoint Peak
- 2026-06-11 10:19:34 Date
- 270.035 seconds Highest write time
- 0.054 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-06-11 10:19:34 Date
Checkpoints distance
Key values
- 333.25 Mo Distance Peak
- 2026-06-11 10:19:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 11 00 13,404 633.293s 0.024s 633.351s 01 1,562 156.767s 0.018s 156.812s 02 1,065 107.017s 0.026s 107.07s 03 1,333 133.811s 0.023s 133.87s 04 3,697 370.896s 0.034s 370.973s 05 8,555 801.048s 0.024s 801.149s 06 6,433 489.406s 0.014s 489.447s 07 25,928 1,748.154s 0.07s 1,748.291s 08 55,013 3,037.31s 0.197s 3,037.641s 09 71,981 3,239.277s 0.231s 3,239.665s 10 72,055 3,202.611s 0.267s 3,203.027s 11 60,456 3,205.921s 0.205s 3,206.278s 12 28,355 2,149.19s 0.055s 2,149.318s 13 34,084 2,658.209s 0.183s 2,658.497s 14 69,823 3,239.332s 0.226s 3,239.709s 15 68,721 3,233.321s 0.208s 3,233.678s 16 49,280 3,126.703s 0.187s 3,127.037s 17 26,372 2,274.91s 0.112s 2,275.117s 18 3,555 318.654s 0.013s 318.699s 19 51 5.145s 0.002s 5.152s 20 1,212 271.657s 0.007s 271.671s 21 2,202 220.91s 0.022s 220.977s 22 1,867 187.485s 0.032s 187.557s 23 6,867 569.135s 0.007s 569.156s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 11 00 0 0 5 427 0.003s 0.007s 01 0 0 0 390 0.003s 0.006s 02 0 0 0 390 0.003s 0.006s 03 0 0 1 341 0.004s 0.006s 04 0 0 1 718 0.003s 0.01s 05 0 0 4 764 0.002s 0.009s 06 0 0 1 347 0.003s 0.006s 07 0 0 17 1,738 0.006s 0.011s 08 0 0 32 4,700 0.005s 0.012s 09 0 0 57 5,477 0.006s 0.012s 10 0 0 46 5,750 0.018s 0.012s 11 0 0 44 5,285 0.007s 0.012s 12 0 0 19 2,084 0.003s 0.011s 13 0 0 16 4,557 0.004s 0.011s 14 0 0 42 6,087 0.006s 0.012s 15 0 0 39 5,294 0.006s 0.012s 16 0 0 26 4,712 0.004s 0.012s 17 0 0 33 3,324 0.003s 0.01s 18 0 0 4 296 0.002s 0.007s 19 0 0 0 16 0.001s 0.001s 20 0 0 1 61 0.003s 0.002s 21 0 0 1 361 0.003s 0.007s 22 0 0 0 428 0.010s 0.013s 23 0 0 1 34 0.003s 0.003s Day Hour Count Avg time (sec) Jun 11 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 11 00 11,441.57 kB 30,870.57 kB 01 1,377.00 kB 16,344.67 kB 02 846.50 kB 9,158.50 kB 03 961.86 kB 2,026.43 kB 04 1,870.00 kB 2,224.90 kB 05 7,062.22 kB 20,564.00 kB 06 3,293.50 kB 13,770.00 kB 07 25,647.36 kB 54,392.18 kB 08 43,196.92 kB 98,593.58 kB 09 77,739.83 kB 114,020.75 kB 10 63,059.67 kB 127,883.42 kB 11 59,297.67 kB 89,894.17 kB 12 28,663.18 kB 73,450.00 kB 13 24,667.73 kB 50,131.36 kB 14 56,694.50 kB 95,877.25 kB 15 53,781.92 kB 83,583.00 kB 16 35,438.83 kB 95,234.67 kB 17 53,909.30 kB 91,595.70 kB 18 10,319.83 kB 56,889.00 kB 19 254.00 kB 38,836.00 kB 20 7,890.50 kB 34,490.50 kB 21 1,654.14 kB 22,596.57 kB 22 1,254.88 kB 11,082.75 kB 23 3,837.67 kB 7,185.67 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-11 14:22:35 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-11 16:47:56 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 11 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 103.99 MiB 103.99 MiB 09 1 104.00 MiB 104.00 MiB 10 5 519.98 MiB 104.00 MiB 11 0 0 0 12 3 311.99 MiB 104.00 MiB 13 1 104.00 MiB 104.00 MiB 14 2 207.99 MiB 104.00 MiB 15 0 0 0 16 2 207.99 MiB 104.00 MiB 17 1 103.99 MiB 103.99 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 16 1.62 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( 025484, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 11:55:51 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025502, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:58:47 Duration: 4m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:42:03 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-11 14:22:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-11 10:59:41 - 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-11 10:13:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 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-11 13:59:03 - 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-11 14:13:05 - 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-11 12:29:05 - 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-11 12:01:59 - 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-11 09:49:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 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-11 16:33:19 - 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-11 12:10:47 - 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-11 10:44:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-11 10:20:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-11 16:47:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 103.99 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-11 10:01:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 103.99 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-11 17:12:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 103.99 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-11 08:30:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 12.08 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-11 16:46:22 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 12.08 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-11 16:46:22 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 953 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.public.temp0000282275 65 rio.pg_catalog.pg_class 63 rio.pg_catalog.pg_type 51 rio.public.usuarios 48 contagem.pg_catalog.pg_attribute 45 rio.public.temp0000282313 39 rio.pg_catalog.pg_index 36 rio.public.temp0000282135 35 contagem.public.temp0000226364 35 contagem.pg_catalog.pg_class 34 contagem.pg_catalog.pg_type 29 rio.public.temp0000282381 28 rio.pg_catalog.pg_depend 27 contagem.public.usuarios 23 rio.public.temp0000282323 21 rio.public.temp0000282293 20 contagem.pg_catalog.pg_index 19 rio.public.temp0000282279 18 contagem.pg_catalog.pg_depend 16 rio.public.temp0000282297 16 rio.public.temp0000282363 13 rio.public.temp0000282271 10 rio.public.temp0000282347 10 contagem.public.temp0000226374 9 rio.public.temp0000281897 9 rio.public.temp0000282319 9 contagem.public.nf_entrada 8 rio.public.temp0000282335 8 brasilia.pg_catalog.pg_shdepend 7 contagem.pg_catalog.pg_shdepend 5 contagem.public.temp0000226360 5 rio.public.temp0000282141 5 rio.public.temp0000282341 5 rio.public.temp0000282325 5 rio.public.tmp_drill_0175 4 rio.public.temp0000282287 4 rio.public.temp0000282377 4 rio.public.temp0000281335 3 rio.public.temp0000282291 3 rio.public.temp0000282261 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000282295 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000282269 2 rio.public.temp0000282307 2 rio.public.temp0000282361 2 rio.public.tmp_drill_0302 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000282349 1 rio.public.temp0000282267 1 rio.public.temp0000282263 1 contagem.auditor.auditor_2026_06 1 contagem.public.temp0000226372 1 rio.public.temp0000282357 1 rio.public.temp0000282359 1 rio.public.temp0000282339 1 contagem.public.parametros 1 contagem.public.temp0000226368 1 rio.public.temp0000282355 1 rio.public.temp0000282387 1 rio.public.temp0000282371 1 rio.public.temp0000282253 1 rio.public.temp0000282353 1 rio.public.temp0000282301 1 rio.public.temp0000282283 1 rio.public.temp0000282277 1 contagem.public.temp0000226370 1 rio.public.temp0000282369 1 Total 953 Vacuums per table
Key values
- public.temp0000282275 (65) Main table vacuumed on database rio
- 448 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.temp0000282275 65 0 0 0 0 0 0 43,887 8,828 14,000,340 0 0 rio.pg_catalog.pg_attribute 46 43 0 0 0 0 0 24,116 7,536 10,308,989 480 12,233 rio.pg_catalog.pg_class 24 23 0 0 0 0 0 4,793 1,807 2,599,916 121 561 contagem.public.usuarios 23 0 0 0 0 0 0 112 77 49,776 0 0 rio.public.temp0000282313 22 0 0 0 0 0 0 9,007 541 1,406,827 0 0 rio.pg_catalog.pg_type 21 20 0 0 0 0 0 1,936 623 791,512 101 381 rio.public.temp0000282381 20 0 0 0 0 0 0 16,933 3,233 5,002,246 0 0 contagem.pg_catalog.pg_attribute 20 20 0 0 0 0 0 12,801 2,817 5,405,008 29 845 rio.public.temp0000282297 16 0 0 0 0 0 0 20,370 4,749 7,178,314 0 0 rio.public.temp0000282279 15 0 0 0 0 0 0 1,182 183 264,893 0 0 rio.pg_catalog.pg_index 15 14 0 0 0 0 0 942 279 226,213 70 156 rio.public.temp0000282363 13 0 0 0 0 0 0 15,694 4,742 6,906,888 0 0 contagem.pg_catalog.pg_class 12 12 0 0 0 0 0 2,522 527 828,213 9 25 contagem.pg_catalog.pg_type 11 11 0 0 0 0 0 1,169 268 422,984 5 10 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,537 1,370 1,849,597 93 1,001 rio.public.temp0000282319 9 0 0 0 0 0 0 876 211 343,163 0 0 contagem.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,317 563 1,159,324 10 48 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 411 128 114,063 9 9 rio.public.temp0000282335 8 0 0 0 0 0 0 7,955 35 476,719 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 11,469 2,776 12,944,666 1,299 5,693 brasilia.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,043 307 376,572 63 119 rio.public.temp0000281897 6 0 0 0 0 0 0 545 337 566,417 0 0 rio.public.tmp_drill_0175 5 4 0 0 0 0 0 110 12 24,319 0 0 rio.public.temp0000282341 5 0 0 0 0 0 0 4,709 1,582 2,272,000 0 0 rio.public.temp0000282141 4 0 0 0 0 0 0 32 20 4,709 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,861 386 2,462,156 126 530 rio.public.usuarios 3 3 0 0 0 0 0 85 30 46,073 6 17 contagem.public.nf_entrada 3 3 0 0 0 0 0 233 80 208,689 8 14 rio.public.temp0000281335 3 0 0 0 0 0 0 288 134 225,382 0 0 rio.public.temp0000282347 2 0 0 0 0 0 0 1,664 10 99,692 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,243 852 2,995,545 651 4,458 rio.public.temp0000282287 2 0 0 0 0 0 0 190 12 13,073 0 0 contagem.public.temp0000226374 2 0 0 0 0 0 0 355 12 23,141 0 0 rio.public.temp0000282361 2 0 0 0 0 0 0 216 113 221,184 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 54 6 11,670 0 0 rio.public.temp0000282307 2 0 0 0 0 0 0 104 11 7,942 0 0 rio.auditor.auditor_2026_06 2 0 0 0 0 0 0 156,212 66,436 89,041,074 44,450 903,958 contagem.public.temp0000226368 1 0 0 0 0 0 0 94 6 6,477 0 0 rio.public.temp0000282387 1 0 0 0 0 0 0 1,568 4 93,115 0 0 rio.public.temp0000282355 1 0 0 0 0 0 0 63 6 4,581 0 0 rio.public.temp0000282359 1 0 0 0 0 0 0 108 6 7,331 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 162 39 99,796 4 8 rio.public.temp0000282357 1 0 0 0 0 0 0 63 6 4,583 0 0 contagem.public.temp0000226372 1 0 0 0 0 0 0 49 6 3,733 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 96 2 8,438 0 0 rio.public.temp0000282349 1 0 0 0 0 0 0 63 62 71,946 0 0 rio.public.logs 1 0 0 0 0 0 0 795 550 676,223 113 2,825 rio.public.temp0000282283 1 0 0 0 0 0 0 96 6 6,596 0 0 rio.public.temp0000282301 1 0 0 0 0 0 0 95 93 183,433 0 0 contagem.public.temp0000226370 1 0 0 0 0 0 0 94 6 6,475 0 0 rio.public.temp0000282353 1 0 0 0 0 0 0 63 6 4,583 0 0 rio.public.temp0000282371 1 0 0 0 0 0 0 65 7 5,739 0 0 rio.public.temp0000282377 1 0 0 0 0 0 0 121 120 209,594 0 0 Total 448 206 0 0 0 0 0 356,568 112,558 172,271,932 47,647 932,891 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (23.35) 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.temp0000282275 0 0 2 rio.pg_catalog.pg_attribute 0 0 3.04 rio.pg_catalog.pg_class 0 0 0.65 contagem.public.usuarios 0 0 0 rio.public.temp0000282313 0 0 0.43 rio.pg_catalog.pg_type 0 0 0.21 rio.public.temp0000282381 0 0 0.73 contagem.pg_catalog.pg_attribute 0 0 1.38 rio.public.temp0000282297 0 0 0.87 rio.public.temp0000282279 0 0 0.11 rio.pg_catalog.pg_index 0 0 0.03 rio.public.temp0000282363 0 0 0.7 contagem.pg_catalog.pg_class 0 0 0.26 contagem.pg_catalog.pg_type 0 0 0.13 rio.pg_catalog.pg_depend 0 0 0.59 rio.public.temp0000282319 0 0 0.06 contagem.pg_catalog.pg_depend 0 0 0.31 contagem.pg_catalog.pg_index 0 0 0.04 rio.public.temp0000282335 0 0 0.34 rio.pg_catalog.pg_statistic 0 0 1.21 brasilia.pg_catalog.pg_shdepend 0 0 0.14 rio.public.temp0000281897 0 0 0.08 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000282341 0 0 0.3 rio.public.temp0000282141 0 0 0.05 rio.pg_toast.pg_toast_2619 0 0 0.22 rio.public.usuarios 0 0 0 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000281335 0 0 0.03 rio.public.temp0000282347 0 0 0.06 contagem.pg_catalog.pg_statistic 0 0 0.26 rio.public.temp0000282287 0 0 0.02 contagem.public.temp0000226374 0 0 0.03 rio.public.temp0000282361 0 0 0.03 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000282307 0 0 0.03 rio.auditor.auditor_2026_06 0 0 23.35 contagem.public.temp0000226368 0 0 0.02 rio.public.temp0000282387 0 0 0.05 rio.public.temp0000282355 0 0 0.01 rio.public.temp0000282359 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000282357 0 0 0.01 contagem.public.temp0000226372 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0 rio.public.temp0000282349 0 0 0.02 rio.public.logs 0 0 0.22 rio.public.temp0000282283 0 0 0.01 rio.public.temp0000282301 0 0 0.01 contagem.public.temp0000226370 0 0 0.01 rio.public.temp0000282353 0 0 0.01 rio.public.temp0000282371 0 0 0.01 rio.public.temp0000282377 0 0 0.01 Total 0 0 38.13 Tuples removed per table
Key values
- pg_catalog.pg_attribute (173543) Main table with removed tuples on database rio
- 331411 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 46 43 173,543 1,219,114 49,189 281 29,989 contagem.pg_catalog.pg_attribute 20 20 81,316 509,328 0 145 11,595 rio.pg_catalog.pg_statistic 8 8 14,339 69,209 293 0 10,288 rio.pg_catalog.pg_depend 11 11 9,660 213,764 2,976 0 2,024 rio.pg_catalog.pg_type 21 20 7,661 50,215 1,950 27 1,528 contagem.pg_catalog.pg_depend 9 9 7,268 169,680 0 0 1,584 brasilia.pg_catalog.pg_shdepend 7 7 7,042 59,446 5 0 707 contagem.pg_catalog.pg_statistic 2 2 5,601 14,917 0 0 2,022 contagem.pg_catalog.pg_type 11 11 4,570 24,755 0 18 753 contagem.pg_catalog.pg_class 12 12 4,211 42,151 0 27 1,516 rio.pg_catalog.pg_class 24 23 4,078 93,923 5,661 62 3,140 rio.pg_catalog.pg_index 15 14 4,046 29,961 938 0 873 contagem.pg_catalog.pg_index 8 8 2,178 15,182 0 4 419 contagem.public.nf_entrada 3 3 1,535 4,237 0 0 207 contagem.public.usuarios 23 0 1,389 529 0 0 46 rio.auditor.auditor_2026_06 2 0 1,074 18,599,636 0 0 867,099 rio.pg_toast.pg_toast_2619 4 4 1,047 2,708 1 136 663 rio.public.tmp_drill_0175 5 4 386 1,398 232 0 35 rio.public.usuarios 3 3 231 1,817 296 0 48 contagem.pg_toast.pg_toast_2619 1 1 123 116 0 0 64 brasilia.pg_catalog.pg_statistic 1 1 113 449 0 0 36 contagem.public.temp0000226368 1 0 0 1,125 0 42 86 rio.public.temp0000282387 1 0 0 22,065 0 0 1,600 rio.public.temp0000282355 1 0 0 1,037 0 9 55 rio.public.temp0000282363 13 0 0 286,800 0 0 20,800 rio.public.temp0000282359 1 0 0 1,819 0 28 100 rio.public.temp0000282141 4 0 0 7,923 0 91 165 rio.public.temp0000282275 65 0 0 722,790 0 1,087 51,393 rio.public.temp0000282347 2 0 0 25,937 0 40 1,688 rio.public.temp0000282357 1 0 0 1,037 0 9 55 rio.public.temp0000282287 2 0 0 3,189 0 82 174 contagem.public.temp0000226372 1 0 0 1,135 0 23 41 contagem.public.temp0000226374 2 0 0 2,386 0 45 339 rio.public.temp0000282381 20 0 0 251,909 0 310 17,162 rio.public.temp0000282349 1 0 0 1,037 0 9 55 rio.public.temp0000282313 22 0 0 147,040 0 610 9,374 rio.public.temp0000282279 15 0 0 57,500 0 347 1,317 rio.public.temp0000281335 3 0 0 11,733 0 56 264 rio.public.temp0000282297 16 0 0 352,550 0 0 25,600 rio.public.logs 1 0 0 15,859,187 0 0 633,555 rio.public.temp0000282319 9 0 0 38,526 0 139 885 rio.public.temp0000282341 5 0 0 110,256 0 0 8,000 rio.public.temp0000282361 2 0 0 3,638 0 56 200 rio.public.temp0000282283 1 0 0 1,596 0 40 88 rio.public.temp0000282301 1 0 0 1,593 0 41 87 contagem.public.temp0000226370 1 0 0 1,115 0 42 86 rio.public.tmp_drill_0302 2 2 0 472 0 0 14 rio.public.temp0000282335 8 0 0 135,899 0 65 9,791 rio.public.temp0000282307 2 0 0 3,354 0 70 186 rio.public.temp0000281897 6 0 0 21,998 0 143 497 rio.public.temp0000282353 1 0 0 1,035 0 9 55 rio.public.temp0000282371 1 0 0 1,077 0 7 57 rio.public.temp0000282377 1 0 0 5,008 0 15 113 Total 448 206 331,411 39,206,301 61,541 4,115 1,718,518 Pages removed per table
Key values
- public.temp0000282275 (1087) Main table with removed pages on database rio
- 4115 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282275 65 0 0 1087 rio.public.temp0000282313 22 0 0 610 rio.public.temp0000282279 15 0 0 347 rio.public.temp0000282381 20 0 0 310 rio.pg_catalog.pg_attribute 46 43 173543 281 contagem.pg_catalog.pg_attribute 20 20 81316 145 rio.public.temp0000281897 6 0 0 143 rio.public.temp0000282319 9 0 0 139 rio.pg_toast.pg_toast_2619 4 4 1047 136 rio.public.temp0000282141 4 0 0 91 rio.public.temp0000282287 2 0 0 82 rio.public.temp0000282307 2 0 0 70 rio.public.temp0000282335 8 0 0 65 rio.pg_catalog.pg_class 24 23 4078 62 rio.public.temp0000281335 3 0 0 56 rio.public.temp0000282361 2 0 0 56 contagem.public.temp0000226374 2 0 0 45 contagem.public.temp0000226368 1 0 0 42 contagem.public.temp0000226370 1 0 0 42 rio.public.temp0000282301 1 0 0 41 rio.public.temp0000282347 2 0 0 40 rio.public.temp0000282283 1 0 0 40 rio.public.temp0000282359 1 0 0 28 rio.pg_catalog.pg_type 21 20 7661 27 contagem.pg_catalog.pg_class 12 12 4211 27 contagem.public.temp0000226372 1 0 0 23 contagem.pg_catalog.pg_type 11 11 4570 18 rio.public.temp0000282377 1 0 0 15 rio.public.temp0000282355 1 0 0 9 rio.public.temp0000282357 1 0 0 9 rio.public.temp0000282349 1 0 0 9 rio.public.temp0000282353 1 0 0 9 rio.public.temp0000282371 1 0 0 7 contagem.pg_catalog.pg_index 8 8 2178 4 rio.public.temp0000282387 1 0 0 0 rio.public.temp0000282363 13 0 0 0 rio.public.usuarios 3 3 231 0 rio.public.tmp_drill_0175 5 4 386 0 contagem.pg_toast.pg_toast_2619 1 1 123 0 contagem.pg_catalog.pg_statistic 2 2 5601 0 brasilia.pg_catalog.pg_statistic 1 1 113 0 contagem.public.nf_entrada 3 3 1535 0 rio.public.temp0000282297 16 0 0 0 rio.public.logs 1 0 0 0 rio.public.temp0000282341 5 0 0 0 brasilia.pg_catalog.pg_shdepend 7 7 7042 0 rio.public.tmp_drill_0302 2 2 0 0 contagem.pg_catalog.pg_depend 9 9 7268 0 rio.pg_catalog.pg_statistic 8 8 14339 0 rio.auditor.auditor_2026_06 2 0 1074 0 rio.pg_catalog.pg_depend 11 11 9660 0 rio.pg_catalog.pg_index 15 14 4046 0 contagem.public.usuarios 23 0 1389 0 Total 448 206 331,411 4,115 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 2 05 5 1 06 0 0 07 11 25 08 41 86 09 60 110 10 49 112 11 59 119 12 21 49 13 39 90 14 61 124 15 35 89 16 34 82 17 33 60 18 0 0 19 0 0 20 0 0 21 0 4 22 0 0 23 0 0 - 12.08 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 19s57ms 19s57ms 19s57ms 19s57ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:35:27 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:25:25 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 00:05:21 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 19s57ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-11 08:35:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,525 Total read queries
- 1,227 Total write queries
Queries by database
Key values
- rio Main database
- 4,859 Requests
- 5h59m31s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,918 Requests
User Request type Count Duration etiquetas Total 1 162ms select 1 162ms intelifix Total 5,918 6h13m31s copy to 273 36m31s ddl 954 54m29s others 250 22m16s select 4,441 4h20m14s lenon Total 83 54s861ms select 83 54s861ms Duration by user
Key values
- 6h13m31s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 1 162ms select 1 162ms intelifix Total 5,918 6h13m31s copy to 273 36m31s ddl 954 54m29s others 250 22m16s select 4,441 4h20m14s lenon Total 83 54s861ms select 83 54s861ms Queries by host
Key values
- [local] Main host
- 6,002 Requests
- 6h14m26s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,264 Requests
- 3h18m25s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-11 09:51:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,531 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 07:13:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m6s analyze verbose;[ Date: 2026-06-11 05:08:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 16:12:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 09:12:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 11:12:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 10:12:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;[ Date: 2026-06-11 12:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 14:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 15:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 17:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 08:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 20:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 18:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 19:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 22:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 13:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-11 21:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025484, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-11 11:55:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025502, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-11 15:58:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-11 15:42:03 - 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 1h40m29s 279 150ms 4m17s 21s610ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 11 07 5 7m58s 1m35s 08 16 9m33s 35s855ms 09 27 13m5s 29s99ms 10 31 14m17s 27s651ms 11 38 12m47s 20s187ms 12 12 9m49s 49s123ms 13 17 1m18s 4s628ms 14 35 8m12s 14s65ms 15 44 20m2s 27s337ms 16 33 2m20s 4s252ms 17 21 1m3s 3s26ms [ User: intelifix - Total duration: 1h40m29s - Times executed: 279 ]
[ Application: [unknown] - Total duration: 1h40m29s - Times executed: 279 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025484, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 11:55:51 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025502, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:58:47 Duration: 4m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:42:03 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h36m13s 31 824ms 8m55s 3m6s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 11 07 2 8m57s 4m28s 08 2 5m59s 2m59s 09 2 7m25s 3m42s 10 2 7m3s 3m31s 11 2 7m17s 3m38s 12 1 1s73ms 1s73ms 13 2 5m33s 2m46s 14 2 6m20s 3m10s 15 2 6m3s 3m1s 16 2 7m27s 3m43s 17 2 5m59s 2m59s 18 2 5m43s 2m51s 19 2 5m36s 2m48s 20 2 5m46s 2m53s 21 2 5m23s 2m41s 22 2 5m34s 2m47s [ User: intelifix - Total duration: 1h36m13s - Times executed: 31 ]
[ Application: psql - Total duration: 1h36m13s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-11 07:13:56 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-11 16:12:27 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-11 09:12:23 Duration: 7m21s Database: rio User: intelifix Remote: [local] Application: psql
3 18m54s 1,604 150ms 4s331ms 707ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 11 07 13 6s964ms 535ms 08 153 1m47s 702ms 09 215 2m40s 747ms 10 146 1m39s 682ms 11 225 2m10s 580ms 12 37 22s294ms 602ms 13 80 52s361ms 654ms 14 243 3m25s 844ms 15 210 2m21s 675ms 16 200 2m29s 749ms 17 82 58s396ms 712ms [ User: intelifix - Total duration: 18m54s - Times executed: 1604 ]
[ Application: [unknown] - Total duration: 18m54s - Times executed: 1604 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252234, 450, 'CP2317320NE,D4925E947864,544D424200681BA6,D4925E947867$CP2228321R0,A0B53C661DFA,544D4242005A33D2,A0B53C661DFD$CP2411322S3,08C7F52FEB3C,544D424200788449,08C7F52FEB3F$CP230132WRJ,D4925E05FDB3,544D4242006192DA,D4925E05FDB6$CP230132W57,D4925E05E5D4,544D424200619033,D4925E05E5D7$CP230232QEE,D4925E09C85D,544D42420061FDFA,D4925E09C860$CP240432CJP,08C7F526CE16,544D424200774BF7,08C7F526CE19$CP2233325SC,A0B53C9727E0,544D4242005C3157,A0B53C9727E3$CP240932R1N,08C7F52EFD9D,544D4242007869E2,08C7F52EFDA0$CP2330329LT,D4925EE34622,544D4242006E7283,D4925EE34625$CP2301323LG,D4925E01EDB5,544D424200611F4C,D4925E01EDB8$CP234532DVE,08C7F503E6A0,544D424200736D15,08C7F503E6A3$CP2302323FB,D4925E06A56E,544D42420061A4C3,D4925E06A571$CP240332FAE,08C7F5231894,544D42420076E279,08C7F5231897$CP230132T5G,D4925E057389,544D424200618380,D4925E05738C$CP23423253K,D4925EF63B7F,544D42420071F704,D4925EF63B82$CP230232QCJ,D4925E09C62F,544D42420061FDBC,D4925E09C632$CP240932L9W,08C7F52E47C0,544D4242007855AD,08C7F52E47C3$CP2320327PK,D4925EA4AA86,544D42420069D0FC,D4925EA4AA89$CP23273229F,D4925ED4F396,544D4242006DA793,D4925ED4F399$CP2409329AV,08C7F52CA3BD,544D424200782702,08C7F52CA3C0$CP234532BWH,08C7F5039B52,544D4242007364B7,08C7F5039B55$CP234232Q6R,D4925EF91677,544D42420072483C,D4925EF9167A$CP234232LD9,D4925EF884E2,544D42420072380F,D4925EF884E5$CP230232KDN,D4925E09080F,544D42420061E89C,D4925E090812$CP232032D82,D4925EA57E45,544D42420069E883,D4925EA57E48$CP2346320Y2,08C7F506F043,544D42420073BACE,08C7F506F046$CP230232E9W,D4925E084446,544D42420061D2DB,D4925E084449$CP240932H7Y,08C7F52DD29C,544D4242007848A9,08C7F52DD29F$CP234232R43,D4925EF939A8,544D424200724C25,D4925EF939AB$CP234532DKG,08C7F503DB18,544D424200736BCD,08C7F503DB1B$CP2411324YQ,08C7F5303E58,544D424200788D85,08C7F5303E5B$CP2320325P1,D4925EA45D52,544D42420069C868,D4925EA45D55$CP230132RUE,D4925E054179,544D424200617DF0,D4925E05417C$CP234532NLC,08C7F50534AE,544D424200739233,08C7F50534B1$CP2322323F4,D4925EB359F4,544D4242006B9A74,D4925EB359F7$CP240932KL0,08C7F52E2D2C,544D4242007852B9,08C7F52E2D2F$CP2322321PR,D4925EB31767,544D4242006B930F,D4925EB3176A$CP232232BU5,D4925EBD3467,544D4242006BBE2A,D4925EBD346A$CP23033229R,D4925E13ED16,544D42420062BCF7,D4925E13ED19', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 09:34:55 Duration: 4s331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252229, 504, '2102313BFARYN2911647,88892F8A8BAD,48575443E55AE5A8,88892F8A8BB0BFARYMA925214,C0BC9A493A78,48575443B8EF72A7,C0BC9A493A7BBFARYN2953574,B85FB005D25E,48575443F9B20BA8,B85FB005D261BFARYMB900935,BC76C5B59BF8,4857544317A644A8,BC76C5B59BFBBFARYN1911156,C4FBAAFB33F3,48575443D3D1C6A8,C4FBAAFB33F6BFARYN1915585,C4FBAAFB8095,48575443D3D648A8,C4FBAAFB8098BFARYM7920338,345840E9B1E4,4857544391EBCCA6,345840E9B1E7BFARYM8960918,2868D2380F6D,48575443FB643DA6,2868D2380F70BFARYMA950188,C40D96A85C45,48575443E292FCA7,C40D96A85C48BFARYMA961768,C40D96AF152B,48575443E2F6BFA7,C40D96AF152EBFARYM7901117,F09BB8C41508,485754437D5DB2A6,F09BB8C4150BBFARYM7923018,5C647AE00FC8,48575443BA7334A6,5C647AE00FCBBFARYN4908506,0893561C3A71,485754434B3299A9,0893561C3A74BFARYMA900633,CCB1827F631B,485754438081D9A7,CCB1827F631EBFARYN1900044,645E10FAEF23,48575443C2A997A8,645E10FAEF26BFARYN7911069,6CE87455FEB2,48575443AA6AD5AA,6CE87455FEB5BFARYM6925811,B0761BBEEEBC,48575443714D82A6,B0761BBEEEBFBFARYN7909710,6CE874010C26,48575443A6EAEFAA,6CE874010C29BFARYM4916177,482CD09007B0,48575443CB8AFEA5,482CD09007B3BFARYN2916737,88892F898DAC,48575443E54BF2A8,88892F898DAFBFARYM4935924,D44649B83F4A,48575443DD2BFCA5,D44649B83F4DBFARYN1910550,C4FBAAFC7F0D,48575443D3E540A8,C4FBAAFC7F10BFARYMC902409,04E7953BB5A9,485754437459DDA8,04E7953BB5ACBFARYM8909802,1C3D2F4C7F75,48575443D564DAA6,1C3D2F4C7F78BFARYN2917749,88892F8A8030,48575443E55A38A8,88892F8A8033BFARYMA910409,6C442A90C6C4,485754439F1358A7,6C442A90C6C7BFARYM9915991,00E4060B4FC7,485754433A89F6A7,00E4060B4FCABFARYM7929738,30C50FB6906E,48575443CEC33AA6,30C50FB69071BFARYMA906247,CCB182ACAC80,485754438561F2A7,CCB182ACAC83BFARYMB904254,F82E3F6DB98C,48575443452F5EA8,F82E3F6DB98FBFARYM8951301,2868D2160569,48575443FA8C63A6,2868D216056CBFARYMB900244,BC76C5B474B6,48575443179477A8,BC76C5B474B9BFARYM7921811,5C647ADF8BA2,48575443BA6A91A6,5C647ADF8BA5BFARYMA962316,C40D96A45BC2,48575443E20545A7,C40D96A45BC5BFARYM8952943,2868D2171577,48575443FA9C39A6,2868D217157ABFARYMA963789,C40D96A3DF0C,48575443E1EDAAA7,C40D96A3DF0FBFARYM8947847,E8136E941531,48575443F31F0FA6,E8136E941534', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 15:26:42 Duration: 4s22ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252226, 504, '921501047581,345D9EBE1472,D0CF0EFDCD0D,ACD75BB5762B,C4EB429FF9FE,D833B7CA5AF7,5CFA25AC9531,209A7DB393D9,D06DC964F712,D0CF0EFE1598,209A7DB7413D,64FD96564297,186A81D5B412,345D9EB46926,D833B7CA304F,D0CF0EFDF895,943C96AB55AB,64FD965E0897,C03C0480DF00,209A7DBBB45D,8CC5B4ED311F,841EA3699C5D,186A81D57CC1,D0CF0EFE02AC,5CFA259C02A0,B0BBE549BE3F,E4C0E240594E,186A81D5B6AB,C4EB42A00121,5CFA2580A1D9,94988F316EB8,506F0C3CA8E9,841EA39870A2,841EA38D4B9E,44D454C3137C', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 11:37:00 Duration: 3s752ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 15m16s 90 8s75ms 13s348ms 10s182ms create table temp0000282275 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 11 07 11 1m39s 9s40ms 08 11 1m48s 9s828ms 09 17 3m1s 10s648ms 10 10 1m41s 10s191ms 11 15 2m41s 10s758ms 12 4 35s836ms 8s959ms 14 6 1m5s 10s927ms 15 16 2m43s 10s193ms [ User: intelifix - Total duration: 15m16s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 15m16s - Times executed: 90 ]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:50:56 Duration: 13s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:51:16 Duration: 12s862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:13:05 Duration: 12s425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 10m21s 3 342ms 8m6s 3m27s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 11 05 3 10m21s 3m27s [ User: intelifix - Total duration: 10m21s - Times executed: 3 ]
[ Application: psql - Total duration: 10m21s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-11 05:08:07 Duration: 8m6s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-11 05:10:22 Duration: 2m14s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-11 05:08:08 Duration: 342ms Database: brasilia User: intelifix Remote: [local] Application: psql
6 9m55s 32 14s397ms 26s368ms 18s600ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 11 08 1 26s368ms 26s368ms 09 6 1m45s 17s544ms 10 2 31s569ms 15s784ms 11 1 19s824ms 19s824ms 14 4 1m9s 17s438ms 15 8 2m36s 19s585ms 16 5 1m37s 19s579ms 17 5 1m27s 17s569ms [ User: intelifix - Total duration: 9m55s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 9m55s - Times executed: 32 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-11', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-11 08:59:41 Duration: 26s368ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-11', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-11 15:57:35 Duration: 25s173ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-11', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-11 15:58:58 Duration: 24s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9m53s 32 418ms 1m1s 18s538ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 11 07 2 58s880ms 29s440ms 08 2 29s591ms 14s795ms 09 2 1m2s 31s459ms 10 2 36s182ms 18s91ms 11 2 36s861ms 18s430ms 12 2 32s918ms 16s459ms 13 2 30s895ms 15s447ms 14 2 41s233ms 20s616ms 15 2 30s464ms 15s232ms 16 2 37s135ms 18s567ms 17 2 32s275ms 16s137ms 18 2 33s159ms 16s579ms 19 2 28s605ms 14s302ms 20 2 38s938ms 19s469ms 21 2 32s221ms 16s110ms 22 2 30s942ms 15s471ms [ User: intelifix - Total duration: 9m53s - Times executed: 32 ]
[ Application: psql - Total duration: 9m53s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-11 09:13:24 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-11 07:14:54 Duration: 57s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-11 14:11:57 Duration: 39s689ms Database: rio User: intelifix Remote: [local] Application: psql
8 6m55s 137 2s60ms 22s29ms 3s32ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 11 00 6 21s513ms 3s585ms 01 6 16s194ms 2s699ms 02 6 15s188ms 2s531ms 03 5 13s985ms 2s797ms 04 6 17s1ms 2s833ms 05 6 17s58ms 2s843ms 06 6 17s94ms 2s849ms 07 6 16s942ms 2s823ms 08 6 53s940ms 8s990ms 09 6 18s214ms 3s35ms 10 6 17s186ms 2s864ms 11 6 17s218ms 2s869ms 12 6 14s663ms 2s443ms 13 6 16s272ms 2s712ms 14 6 17s597ms 2s932ms 15 6 14s755ms 2s459ms 16 6 18s973ms 3s162ms 17 6 15s827ms 2s637ms 18 6 14s853ms 2s475ms 19 6 13s460ms 2s243ms 20 6 16s359ms 2s726ms 21 6 16s459ms 2s743ms 22 6 14s621ms 2s436ms [ User: intelifix - Total duration: 6m55s - Times executed: 137 ]
[ Application: psql - Total duration: 6m55s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:35:27 Duration: 22s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:25:25 Duration: 20s9ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 00:05:21 Duration: 8s419ms Database: rio User: intelifix Remote: [local] Application: psql
9 6m31s 895 150ms 3s780ms 437ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 11 07 9 9s323ms 1s35ms 08 83 46s750ms 563ms 09 154 1m9s 450ms 10 131 55s422ms 423ms 11 147 1m7s 459ms 13 102 38s112ms 373ms 14 110 44s150ms 401ms 15 117 43s869ms 374ms 16 40 16s371ms 409ms 17 2 500ms 250ms [ User: intelifix - Total duration: 6m31s - Times executed: 895 ]
[ Application: [unknown] - Total duration: 6m31s - Times executed: 895 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241701742730,241694955266,241654845358,241699259198,241593254454,230049304250,241695625264,241674513552,241695118693,241654561717,241661060915,241607167899,241714693141,241610896871,241622637074,241617367985,241713020307,241614465267,241708964355,241704364456,241622631014,241670390928,241622440008,241652290306,241704161227,241620778183,241610084357,241663175868,241622485466,241657626168,241714943850,241622543856,241656698086,241629127483,241680303556,241646268910,241726632836,241678325865,241689391626,241658760006,241658797685,241700690417,241694493852,241615859107,241666320306,241660090910", "usuario" : "405", "caixa" : "2756724", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-11 08:07:12 Duration: 3s780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252817", "modelo" : "320", "itens" : "241658850116,241713857795,230048392635,241663298911,241667895072,241694217079,241699814057,241639362142,241716624968,241635923153,241703439809,241637577073,241604949905,241714764966,241639307792,241645535471,241629384860,241629412439,241694622933,241714783857,241693118599,241699414040,241603330511,241699417474,241716738188,241706839905,241706732746,241608733148,241691289712,241716545162,241700607377,241654299918,241597861728,241598106274,241661066874,241677550123,241706520930,241709097981,241650348702,241609240830,241629379506,241711026273,241715687693,241694406065,241674124344,241728514052,241619539309,241660379096", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-11 14:25:12 Duration: 2s296ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252138", "modelo" : "454", "itens" : "241613687581,241613343553,241624035258,241611587881,241640055172,241626289091,241611035370,854362000001380,854303000001674,854274000001200,854226000001952,854158000002166,854267000000303,241611247893,854323000000526,854303000001094,854265000001558,854270000001969,854307000000900,241613742234,854221000000019,854248000001616,854267000000869,854157000001485,854269000001864,854352000000881,854204000001120,854192000000225,854307000000361,854274000001470,854200000001164,854327000002667,854303000001692,854267000000326,854197000000163,854327000002454,854305000001384,854157000001158,854327000001254,854274000001204,854200000000193,854222000001131,854200000000874,854282000000206,854326000001673,854283000002184,854326000001076,854206000000462", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-11 08:01:32 Duration: 2s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m16s 1 6m16s 6m16s 6m16s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 11 12 1 6m16s 6m16s [ User: intelifix - Total duration: 6m16s - Times executed: 1 ]
[ Application: psql - Total duration: 6m16s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-11 12:11:18 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
11 4m56s 60 3s329ms 10s337ms 4s949ms create table temp0000282275 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 11 07 10 43s902ms 4s390ms 08 2 8s715ms 4s357ms 09 10 52s261ms 5s226ms 10 6 25s645ms 4s274ms 11 9 43s524ms 4s836ms 14 12 1m1s 5s136ms 15 3 15s884ms 5s294ms 16 8 45s367ms 5s670ms [ User: intelifix - Total duration: 4m56s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 4m56s - Times executed: 60 ]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 07:34:28 Duration: 10s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 09:21:28 Duration: 9s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 16:07:21 Duration: 6s382ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m50s 27 8s894ms 13s119ms 10s758ms create table temp0000282313 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 11 09 15 2m48s 11s203ms 10 6 1m1s 10s272ms 11 6 1m 10s132ms [ User: intelifix - Total duration: 4m50s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 27 ]
-
CREATE TABLE temp0000282313 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:53:28 Duration: 13s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282313 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:35:14 Duration: 12s402ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282313 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:53:58 Duration: 12s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m5s 24 8s948ms 12s829ms 10s227ms create table temp0000282297 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 11 08 5 52s992ms 10s598ms 09 3 29s513ms 9s837ms 10 12 2m2s 10s224ms 11 4 40s268ms 10s67ms [ User: intelifix - Total duration: 4m5s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4m5s - Times executed: 24 ]
-
CREATE TABLE temp0000282297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 08:55:13 Duration: 12s829ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 10:05:10 Duration: 12s86ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:05:10 Duration: 11s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m5s 105 196ms 11s313ms 2s336ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 11 00 6 16s5ms 2s667ms 01 6 6s926ms 1s154ms 02 6 4s269ms 711ms 03 6 5s281ms 880ms 04 6 6s717ms 1s119ms 05 4 10s947ms 2s736ms 06 5 6s494ms 1s298ms 07 6 35s250ms 5s875ms 08 6 23s523ms 3s920ms 09 6 16s623ms 2s770ms 10 5 4s269ms 853ms 11 5 4s551ms 910ms 12 6 7s827ms 1s304ms 13 6 20s591ms 3s431ms 14 6 27s657ms 4s609ms 15 6 19s298ms 3s216ms 16 4 15s425ms 3s856ms 21 4 6s579ms 1s644ms 22 6 7s72ms 1s178ms [ User: intelifix - Total duration: 4m5s - Times executed: 105 ]
[ Application: psql - Total duration: 4m5s - Times executed: 105 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 00:05:12 Duration: 11s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 07:35:10 Duration: 8s359ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 07:15:09 Duration: 7s850ms Database: rio User: intelifix Remote: [local] Application: psql
15 4m3s 25 8s329ms 10s916ms 9s723ms create table temp0000282381 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 11 16 3 29s314ms 9s771ms 17 22 3m33s 9s717ms [ User: intelifix - Total duration: 4m3s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 25 ]
-
CREATE TABLE temp0000282381 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 17:36:48 Duration: 10s916ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282381 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 17:02:06 Duration: 10s849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282381 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 17:25:12 Duration: 10s823ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m53s 23 8s920ms 11s527ms 10s134ms create table temp0000282363 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 11 13 2 20s362ms 10s181ms 14 11 1m51s 10s106ms 16 6 1m2s 10s387ms 17 4 39s228ms 9s807ms [ User: intelifix - Total duration: 3m53s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 3m53s - Times executed: 23 ]
-
CREATE TABLE temp0000282363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 16:33:48 Duration: 11s527ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 16:34:54 Duration: 11s324ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 14:25:49 Duration: 10s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m54s 2 1m21s 1m33s 1m27s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 11 20 1 1m21s 1m21s 23 1 1m33s 1m33s [ User: intelifix - Total duration: 2m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m54s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-11 23:37:05 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-11 20:08:15 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
18 2m19s 78 175ms 38s918ms 1s786ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 11 07 4 2s93ms 523ms 08 6 14s103ms 2s350ms 09 14 6s22ms 430ms 10 11 1m7s 6s138ms 11 10 7s883ms 788ms 12 4 9s980ms 2s495ms 13 2 3s106ms 1s553ms 14 5 16s319ms 3s263ms 15 6 2s977ms 496ms 16 4 6s295ms 1s573ms 17 12 3s5ms 250ms [ User: intelifix - Total duration: 2m19s - Times executed: 78 ]
[ Application: psql - Total duration: 2m19s - Times executed: 78 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025467);
Date: 2026-06-11 10:14:35 Duration: 38s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025470);
Date: 2026-06-11 10:22:24 Duration: 20s802ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025445);
Date: 2026-06-11 08:25:04 Duration: 11s248ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m55s 2 23s806ms 1m31s 57s552ms 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 #19
Day Hour Count Duration Avg duration Jun 11 23 2 1m55s 57s552ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - 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-11 23:13:59 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-11 23:38:34 Duration: 23s806ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1m54s 2 53s539ms 1m 57s75ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 11 20 1 1m 1m 23 1 53s539ms 53s539ms [ User: intelifix - Total duration: 1m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-11 20:05:21 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-11 23:17:43 Duration: 53s539ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,604 18m54s 150ms 4s331ms 707ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 11 07 13 6s964ms 535ms 08 153 1m47s 702ms 09 215 2m40s 747ms 10 146 1m39s 682ms 11 225 2m10s 580ms 12 37 22s294ms 602ms 13 80 52s361ms 654ms 14 243 3m25s 844ms 15 210 2m21s 675ms 16 200 2m29s 749ms 17 82 58s396ms 712ms [ User: intelifix - Total duration: 18m54s - Times executed: 1604 ]
[ Application: [unknown] - Total duration: 18m54s - Times executed: 1604 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252234, 450, 'CP2317320NE,D4925E947864,544D424200681BA6,D4925E947867$CP2228321R0,A0B53C661DFA,544D4242005A33D2,A0B53C661DFD$CP2411322S3,08C7F52FEB3C,544D424200788449,08C7F52FEB3F$CP230132WRJ,D4925E05FDB3,544D4242006192DA,D4925E05FDB6$CP230132W57,D4925E05E5D4,544D424200619033,D4925E05E5D7$CP230232QEE,D4925E09C85D,544D42420061FDFA,D4925E09C860$CP240432CJP,08C7F526CE16,544D424200774BF7,08C7F526CE19$CP2233325SC,A0B53C9727E0,544D4242005C3157,A0B53C9727E3$CP240932R1N,08C7F52EFD9D,544D4242007869E2,08C7F52EFDA0$CP2330329LT,D4925EE34622,544D4242006E7283,D4925EE34625$CP2301323LG,D4925E01EDB5,544D424200611F4C,D4925E01EDB8$CP234532DVE,08C7F503E6A0,544D424200736D15,08C7F503E6A3$CP2302323FB,D4925E06A56E,544D42420061A4C3,D4925E06A571$CP240332FAE,08C7F5231894,544D42420076E279,08C7F5231897$CP230132T5G,D4925E057389,544D424200618380,D4925E05738C$CP23423253K,D4925EF63B7F,544D42420071F704,D4925EF63B82$CP230232QCJ,D4925E09C62F,544D42420061FDBC,D4925E09C632$CP240932L9W,08C7F52E47C0,544D4242007855AD,08C7F52E47C3$CP2320327PK,D4925EA4AA86,544D42420069D0FC,D4925EA4AA89$CP23273229F,D4925ED4F396,544D4242006DA793,D4925ED4F399$CP2409329AV,08C7F52CA3BD,544D424200782702,08C7F52CA3C0$CP234532BWH,08C7F5039B52,544D4242007364B7,08C7F5039B55$CP234232Q6R,D4925EF91677,544D42420072483C,D4925EF9167A$CP234232LD9,D4925EF884E2,544D42420072380F,D4925EF884E5$CP230232KDN,D4925E09080F,544D42420061E89C,D4925E090812$CP232032D82,D4925EA57E45,544D42420069E883,D4925EA57E48$CP2346320Y2,08C7F506F043,544D42420073BACE,08C7F506F046$CP230232E9W,D4925E084446,544D42420061D2DB,D4925E084449$CP240932H7Y,08C7F52DD29C,544D4242007848A9,08C7F52DD29F$CP234232R43,D4925EF939A8,544D424200724C25,D4925EF939AB$CP234532DKG,08C7F503DB18,544D424200736BCD,08C7F503DB1B$CP2411324YQ,08C7F5303E58,544D424200788D85,08C7F5303E5B$CP2320325P1,D4925EA45D52,544D42420069C868,D4925EA45D55$CP230132RUE,D4925E054179,544D424200617DF0,D4925E05417C$CP234532NLC,08C7F50534AE,544D424200739233,08C7F50534B1$CP2322323F4,D4925EB359F4,544D4242006B9A74,D4925EB359F7$CP240932KL0,08C7F52E2D2C,544D4242007852B9,08C7F52E2D2F$CP2322321PR,D4925EB31767,544D4242006B930F,D4925EB3176A$CP232232BU5,D4925EBD3467,544D4242006BBE2A,D4925EBD346A$CP23033229R,D4925E13ED16,544D42420062BCF7,D4925E13ED19', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 09:34:55 Duration: 4s331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252229, 504, '2102313BFARYN2911647,88892F8A8BAD,48575443E55AE5A8,88892F8A8BB0BFARYMA925214,C0BC9A493A78,48575443B8EF72A7,C0BC9A493A7BBFARYN2953574,B85FB005D25E,48575443F9B20BA8,B85FB005D261BFARYMB900935,BC76C5B59BF8,4857544317A644A8,BC76C5B59BFBBFARYN1911156,C4FBAAFB33F3,48575443D3D1C6A8,C4FBAAFB33F6BFARYN1915585,C4FBAAFB8095,48575443D3D648A8,C4FBAAFB8098BFARYM7920338,345840E9B1E4,4857544391EBCCA6,345840E9B1E7BFARYM8960918,2868D2380F6D,48575443FB643DA6,2868D2380F70BFARYMA950188,C40D96A85C45,48575443E292FCA7,C40D96A85C48BFARYMA961768,C40D96AF152B,48575443E2F6BFA7,C40D96AF152EBFARYM7901117,F09BB8C41508,485754437D5DB2A6,F09BB8C4150BBFARYM7923018,5C647AE00FC8,48575443BA7334A6,5C647AE00FCBBFARYN4908506,0893561C3A71,485754434B3299A9,0893561C3A74BFARYMA900633,CCB1827F631B,485754438081D9A7,CCB1827F631EBFARYN1900044,645E10FAEF23,48575443C2A997A8,645E10FAEF26BFARYN7911069,6CE87455FEB2,48575443AA6AD5AA,6CE87455FEB5BFARYM6925811,B0761BBEEEBC,48575443714D82A6,B0761BBEEEBFBFARYN7909710,6CE874010C26,48575443A6EAEFAA,6CE874010C29BFARYM4916177,482CD09007B0,48575443CB8AFEA5,482CD09007B3BFARYN2916737,88892F898DAC,48575443E54BF2A8,88892F898DAFBFARYM4935924,D44649B83F4A,48575443DD2BFCA5,D44649B83F4DBFARYN1910550,C4FBAAFC7F0D,48575443D3E540A8,C4FBAAFC7F10BFARYMC902409,04E7953BB5A9,485754437459DDA8,04E7953BB5ACBFARYM8909802,1C3D2F4C7F75,48575443D564DAA6,1C3D2F4C7F78BFARYN2917749,88892F8A8030,48575443E55A38A8,88892F8A8033BFARYMA910409,6C442A90C6C4,485754439F1358A7,6C442A90C6C7BFARYM9915991,00E4060B4FC7,485754433A89F6A7,00E4060B4FCABFARYM7929738,30C50FB6906E,48575443CEC33AA6,30C50FB69071BFARYMA906247,CCB182ACAC80,485754438561F2A7,CCB182ACAC83BFARYMB904254,F82E3F6DB98C,48575443452F5EA8,F82E3F6DB98FBFARYM8951301,2868D2160569,48575443FA8C63A6,2868D216056CBFARYMB900244,BC76C5B474B6,48575443179477A8,BC76C5B474B9BFARYM7921811,5C647ADF8BA2,48575443BA6A91A6,5C647ADF8BA5BFARYMA962316,C40D96A45BC2,48575443E20545A7,C40D96A45BC5BFARYM8952943,2868D2171577,48575443FA9C39A6,2868D217157ABFARYMA963789,C40D96A3DF0C,48575443E1EDAAA7,C40D96A3DF0FBFARYM8947847,E8136E941531,48575443F31F0FA6,E8136E941534', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 15:26:42 Duration: 4s22ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252226, 504, '921501047581,345D9EBE1472,D0CF0EFDCD0D,ACD75BB5762B,C4EB429FF9FE,D833B7CA5AF7,5CFA25AC9531,209A7DB393D9,D06DC964F712,D0CF0EFE1598,209A7DB7413D,64FD96564297,186A81D5B412,345D9EB46926,D833B7CA304F,D0CF0EFDF895,943C96AB55AB,64FD965E0897,C03C0480DF00,209A7DBBB45D,8CC5B4ED311F,841EA3699C5D,186A81D57CC1,D0CF0EFE02AC,5CFA259C02A0,B0BBE549BE3F,E4C0E240594E,186A81D5B6AB,C4EB42A00121,5CFA2580A1D9,94988F316EB8,506F0C3CA8E9,841EA39870A2,841EA38D4B9E,44D454C3137C', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 11:37:00 Duration: 3s752ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 895 6m31s 150ms 3s780ms 437ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 11 07 9 9s323ms 1s35ms 08 83 46s750ms 563ms 09 154 1m9s 450ms 10 131 55s422ms 423ms 11 147 1m7s 459ms 13 102 38s112ms 373ms 14 110 44s150ms 401ms 15 117 43s869ms 374ms 16 40 16s371ms 409ms 17 2 500ms 250ms [ User: intelifix - Total duration: 6m31s - Times executed: 895 ]
[ Application: [unknown] - Total duration: 6m31s - Times executed: 895 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241701742730,241694955266,241654845358,241699259198,241593254454,230049304250,241695625264,241674513552,241695118693,241654561717,241661060915,241607167899,241714693141,241610896871,241622637074,241617367985,241713020307,241614465267,241708964355,241704364456,241622631014,241670390928,241622440008,241652290306,241704161227,241620778183,241610084357,241663175868,241622485466,241657626168,241714943850,241622543856,241656698086,241629127483,241680303556,241646268910,241726632836,241678325865,241689391626,241658760006,241658797685,241700690417,241694493852,241615859107,241666320306,241660090910", "usuario" : "405", "caixa" : "2756724", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-11 08:07:12 Duration: 3s780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252817", "modelo" : "320", "itens" : "241658850116,241713857795,230048392635,241663298911,241667895072,241694217079,241699814057,241639362142,241716624968,241635923153,241703439809,241637577073,241604949905,241714764966,241639307792,241645535471,241629384860,241629412439,241694622933,241714783857,241693118599,241699414040,241603330511,241699417474,241716738188,241706839905,241706732746,241608733148,241691289712,241716545162,241700607377,241654299918,241597861728,241598106274,241661066874,241677550123,241706520930,241709097981,241650348702,241609240830,241629379506,241711026273,241715687693,241694406065,241674124344,241728514052,241619539309,241660379096", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-11 14:25:12 Duration: 2s296ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "252138", "modelo" : "454", "itens" : "241613687581,241613343553,241624035258,241611587881,241640055172,241626289091,241611035370,854362000001380,854303000001674,854274000001200,854226000001952,854158000002166,854267000000303,241611247893,854323000000526,854303000001094,854265000001558,854270000001969,854307000000900,241613742234,854221000000019,854248000001616,854267000000869,854157000001485,854269000001864,854352000000881,854204000001120,854192000000225,854307000000361,854274000001470,854200000001164,854327000002667,854303000001692,854267000000326,854197000000163,854327000002454,854305000001384,854157000001158,854327000001254,854274000001204,854200000000193,854222000001131,854200000000874,854282000000206,854326000001673,854283000002184,854326000001076,854206000000462", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-11 08:01:32 Duration: 2s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 385 1m38s 150ms 926ms 256ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 11 13 171 45s382ms 265ms 14 113 25s546ms 226ms 15 43 8s520ms 198ms 16 4 834ms 208ms 17 54 18s288ms 338ms [ User: intelifix - Total duration: 1m38s - Times executed: 385 ]
[ Application: [unknown] - Total duration: 1m38s - Times executed: 385 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40999","seriais":"229639394447,229793712325,229698719596,229792452741,229775047900,229729975173,216924339298,229778167182,229766628592,229644853454,229704481215,229710866383,229730191839,229639516176,216922091527,216929850713,229642373638,216924403245,229774208894,229766446981,229822772939,216930437694,229702960012,229766869199,229833844154,229639319311,229825999707,229642805678,216930323239,229705548603,229702268697,229823826868","usuario":"409","observacao":""}');
Date: 2026-06-11 17:32:27 Duration: 926ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40998","seriais":"226293550000,226394613544,226008522946,226209798605,226398836683,246298130616,246231810204,246231814244,246238839206,226021210829,226128950311,226012547479,246293716267,246292326266,246317718801,246255445473,226313958602,246206048485,246166336877,226166706980,246291575273,246287380622,226137214854,246233686166,246139165864,226300764149,226115611321,226202212444,226282437792,246089356884","usuario":"416","observacao":""}');
Date: 2026-06-11 17:37:11 Duration: 807ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"41164","seriais":"3CF9F0AC4E90,843C9921FBC9,F4E84F80C9F0,3CF9F0A94578,C4EBFF8B20DE,3CF9F0AC528C,4896D951B5BE,C4EBFF8B4022,14CA56CE2E23,D89A0D851D33,F4E84F80C58E,843C9920FCC9,3CF9F0A8F1C0,3CF9F0A8AFA8,C4EBFF8B84E0,F4E84F82DCF6,4896D95406AA,C4EBFF8B104C,3891484A49F1,843C992EB365,F4E84F83BCB8,48D68235B3FC,843C992C29A9,D89A0DA4634D,3891484A7A5D,C4EBFF890D5A","usuario":"416","observacao":""}');
Date: 2026-06-11 13:56:20 Duration: 804ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 279 1h40m29s 150ms 4m17s 21s610ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 11 07 5 7m58s 1m35s 08 16 9m33s 35s855ms 09 27 13m5s 29s99ms 10 31 14m17s 27s651ms 11 38 12m47s 20s187ms 12 12 9m49s 49s123ms 13 17 1m18s 4s628ms 14 35 8m12s 14s65ms 15 44 20m2s 27s337ms 16 33 2m20s 4s252ms 17 21 1m3s 3s26ms [ User: intelifix - Total duration: 1h40m29s - Times executed: 279 ]
[ Application: [unknown] - Total duration: 1h40m29s - Times executed: 279 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025484, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 11:55:51 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025502, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:58:47 Duration: 4m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:42:03 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 137 6m55s 2s60ms 22s29ms 3s32ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 11 00 6 21s513ms 3s585ms 01 6 16s194ms 2s699ms 02 6 15s188ms 2s531ms 03 5 13s985ms 2s797ms 04 6 17s1ms 2s833ms 05 6 17s58ms 2s843ms 06 6 17s94ms 2s849ms 07 6 16s942ms 2s823ms 08 6 53s940ms 8s990ms 09 6 18s214ms 3s35ms 10 6 17s186ms 2s864ms 11 6 17s218ms 2s869ms 12 6 14s663ms 2s443ms 13 6 16s272ms 2s712ms 14 6 17s597ms 2s932ms 15 6 14s755ms 2s459ms 16 6 18s973ms 3s162ms 17 6 15s827ms 2s637ms 18 6 14s853ms 2s475ms 19 6 13s460ms 2s243ms 20 6 16s359ms 2s726ms 21 6 16s459ms 2s743ms 22 6 14s621ms 2s436ms [ User: intelifix - Total duration: 6m55s - Times executed: 137 ]
[ Application: psql - Total duration: 6m55s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:35:27 Duration: 22s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:25:25 Duration: 20s9ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 00:05:21 Duration: 8s419ms Database: rio User: intelifix Remote: [local] Application: psql
6 124 19s957ms 150ms 190ms 160ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 11 07 1 151ms 151ms 08 5 805ms 161ms 09 19 3s16ms 158ms 10 15 2s439ms 162ms 11 19 3s28ms 159ms 12 3 485ms 161ms 13 11 1s734ms 157ms 14 15 2s476ms 165ms 15 12 1s899ms 158ms 16 24 3s919ms 163ms [ User: intelifix - Total duration: 19s957ms - Times executed: 124 ]
[ Application: [unknown] - Total duration: 19s957ms - Times executed: 124 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-11 14:55:01 Duration: 190ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-06-11 14:41:36 Duration: 189ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0457;
Date: 2026-06-11 11:47:06 Duration: 184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 117 1m1s 151ms 12s265ms 526ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 11 08 2 767ms 383ms 09 3 1s336ms 445ms 10 8 3s826ms 478ms 11 23 8s617ms 374ms 13 9 16s437ms 1s826ms 14 17 11s512ms 677ms 15 26 11s71ms 425ms 16 29 8s47ms 277ms [ User: intelifix - Total duration: 1m1s - Times executed: 117 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 117 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-11 13:44:23 Duration: 12s265ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-11 14:56:00 Duration: 5s132ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0252620) LIMIT 1;
Date: 2026-06-11 15:34:54 Duration: 1s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 105 4m5s 196ms 11s313ms 2s336ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 11 00 6 16s5ms 2s667ms 01 6 6s926ms 1s154ms 02 6 4s269ms 711ms 03 6 5s281ms 880ms 04 6 6s717ms 1s119ms 05 4 10s947ms 2s736ms 06 5 6s494ms 1s298ms 07 6 35s250ms 5s875ms 08 6 23s523ms 3s920ms 09 6 16s623ms 2s770ms 10 5 4s269ms 853ms 11 5 4s551ms 910ms 12 6 7s827ms 1s304ms 13 6 20s591ms 3s431ms 14 6 27s657ms 4s609ms 15 6 19s298ms 3s216ms 16 4 15s425ms 3s856ms 21 4 6s579ms 1s644ms 22 6 7s72ms 1s178ms [ User: intelifix - Total duration: 4m5s - Times executed: 105 ]
[ Application: psql - Total duration: 4m5s - Times executed: 105 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 00:05:12 Duration: 11s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 07:35:10 Duration: 8s359ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 07:15:09 Duration: 7s850ms Database: rio User: intelifix Remote: [local] Application: psql
9 105 20s177ms 150ms 356ms 192ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 11 07 5 1s154ms 230ms 08 7 1s339ms 191ms 09 9 2s131ms 236ms 10 13 2s319ms 178ms 11 14 2s638ms 188ms 13 21 3s832ms 182ms 14 17 3s26ms 178ms 15 13 2s338ms 179ms 16 4 959ms 239ms 17 2 436ms 218ms [ User: intelifix - Total duration: 20s177ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 20s177ms - Times executed: 105 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"002", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-11 16:07:14 Duration: 356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"313", "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-11 07:34:42 Duration: 291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"464", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1564", "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-11 09:39:20 Duration: 282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 100 20s126ms 151ms 325ms 201ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 11 04 18 4s471ms 248ms 05 5 1s36ms 207ms 07 8 1s626ms 203ms 08 7 1s307ms 186ms 09 12 2s177ms 181ms 10 13 2s578ms 198ms 11 9 1s753ms 194ms 12 7 1s380ms 197ms 14 8 1s407ms 175ms 15 11 1s965ms 178ms 16 2 422ms 211ms [ User: intelifix - Total duration: 20s126ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 20s126ms - Times executed: 100 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241617458398,241603092934,241703869402,241608886978,241677855965,241728319510,241636002936,241667036671,241665708090,241731395960,241677288200,241714230616,241671594748,241703553535,241667092637,241645491326,241614613037,241602994563,241688810122,241621165472,241593833860,241649313842,241707274448', NULL, NULL, 0320, 00);
Date: 2026-06-11 04:48:19 Duration: 325ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241647262632,241601689800,241713025256,241664824357,241730918305,241727042831,241663850211,241729909710,241729502039,241708871619,230043545360,241674102850,230057069698,241639203742,241667139813,241670215960,241654505269,241654504057,241627947278,241617469511,241604774254,241618238788', NULL, NULL, 0320, 00);
Date: 2026-06-11 04:46:04 Duration: 317ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241689375361,230048486078,230048485876,241595001920,241663104346,241646332328,241714939708,241668229807,241727893655,241619930313,241614589701,241689845261,241730512631,241695288283,241691739509,241631538808', NULL, NULL, 0320, 00);
Date: 2026-06-11 04:51:55 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 95 16s328ms 150ms 322ms 171ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 11 04 1 153ms 153ms 07 2 482ms 241ms 08 1 170ms 170ms 09 1 154ms 154ms 10 3 470ms 156ms 11 3 461ms 153ms 12 2 329ms 164ms 13 7 1s159ms 165ms 14 13 2s210ms 170ms 15 23 3s817ms 165ms 16 29 5s94ms 175ms 17 10 1s823ms 182ms [ User: intelifix - Total duration: 16s328ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 16s328ms - Times executed: 95 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-10", "data-ate" : "2026-06-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-11 07:52:49 Duration: 322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-11", "data-ate" : "2026-06-11", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-11 16:06:46 Duration: 281ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-06-11", "data-ate" : "2026-06-11", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-06-11 17:03:06 Duration: 245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 90 15m16s 8s75ms 13s348ms 10s182ms create table temp0000282275 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 11 07 11 1m39s 9s40ms 08 11 1m48s 9s828ms 09 17 3m1s 10s648ms 10 10 1m41s 10s191ms 11 15 2m41s 10s758ms 12 4 35s836ms 8s959ms 14 6 1m5s 10s927ms 15 16 2m43s 10s193ms [ User: intelifix - Total duration: 15m16s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 15m16s - Times executed: 90 ]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:50:56 Duration: 13s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:51:16 Duration: 12s862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:13:05 Duration: 12s425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 79 35s153ms 292ms 735ms 444ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 11 04 4 1s851ms 462ms 05 1 424ms 424ms 06 1 337ms 337ms 07 6 2s114ms 352ms 08 11 5s105ms 464ms 09 8 3s535ms 441ms 10 6 2s658ms 443ms 11 7 2s836ms 405ms 12 3 1s514ms 504ms 13 8 3s661ms 457ms 14 6 2s816ms 469ms 15 8 3s579ms 447ms 16 6 2s943ms 490ms 17 3 1s368ms 456ms 21 1 405ms 405ms [ User: lenon - Total duration: 35s153ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 35s153ms - Times executed: 79 ]
-
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-11 12:05:04 Duration: 735ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-11 14:50:45 Duration: 697ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-11 09:59:23 Duration: 648ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
14 79 29s725ms 186ms 666ms 376ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 11 07 3 1s324ms 441ms 08 9 3s64ms 340ms 09 9 3s476ms 386ms 10 15 5s337ms 355ms 11 9 3s498ms 388ms 12 7 2s846ms 406ms 13 2 809ms 404ms 14 5 2s103ms 420ms 15 6 2s182ms 363ms 16 4 1s633ms 408ms 17 10 3s447ms 344ms [ User: intelifix - Total duration: 29s725ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 29s725ms - Times executed: 79 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-11 12:20:14 Duration: 666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-11 07:06:48 Duration: 660ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-11 14:47:28 Duration: 614ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 78 2m19s 175ms 38s918ms 1s786ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 11 07 4 2s93ms 523ms 08 6 14s103ms 2s350ms 09 14 6s22ms 430ms 10 11 1m7s 6s138ms 11 10 7s883ms 788ms 12 4 9s980ms 2s495ms 13 2 3s106ms 1s553ms 14 5 16s319ms 3s263ms 15 6 2s977ms 496ms 16 4 6s295ms 1s573ms 17 12 3s5ms 250ms [ User: intelifix - Total duration: 2m19s - Times executed: 78 ]
[ Application: psql - Total duration: 2m19s - Times executed: 78 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025467);
Date: 2026-06-11 10:14:35 Duration: 38s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025470);
Date: 2026-06-11 10:22:24 Duration: 20s802ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025445);
Date: 2026-06-11 08:25:04 Duration: 11s248ms Database: rio User: intelifix Remote: [local] Application: psql
16 76 41s962ms 351ms 824ms 552ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 11 04 4 2s259ms 564ms 05 1 568ms 568ms 07 5 2s121ms 424ms 08 11 6s109ms 555ms 09 8 4s444ms 555ms 10 6 3s312ms 552ms 11 7 3s630ms 518ms 12 3 1s816ms 605ms 13 8 4s547ms 568ms 14 6 3s499ms 583ms 15 8 4s292ms 536ms 16 6 3s713ms 618ms 17 3 1s647ms 549ms [ User: intelifix - Total duration: 41s962ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 41s962ms - Times executed: 76 ]
-
select * from rs_menu_grants (416, 19, 1);
Date: 2026-06-11 14:50:45 Duration: 824ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (434, 72, 1);
Date: 2026-06-11 12:05:04 Duration: 822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-06-11 09:59:23 Duration: 728ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 60 4m56s 3s329ms 10s337ms 4s949ms create table temp0000282275 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 11 07 10 43s902ms 4s390ms 08 2 8s715ms 4s357ms 09 10 52s261ms 5s226ms 10 6 25s645ms 4s274ms 11 9 43s524ms 4s836ms 14 12 1m1s 5s136ms 15 3 15s884ms 5s294ms 16 8 45s367ms 5s670ms [ User: intelifix - Total duration: 4m56s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 4m56s - Times executed: 60 ]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 07:34:28 Duration: 10s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 09:21:28 Duration: 9s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 16:07:21 Duration: 6s382ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 50 15s138ms 194ms 436ms 302ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 11 08 50 15s138ms 302ms [ User: intelifix - Total duration: 15s138ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 15s138ms - Times executed: 50 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (230007);
Date: 2026-06-11 08:06:47 Duration: 436ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-06-11 08:09:23 Duration: 426ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (230007);
Date: 2026-06-11 08:16:34 Duration: 411ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 49 11s259ms 151ms 416ms 229ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 11 07 4 812ms 203ms 08 2 487ms 243ms 09 12 2s485ms 207ms 10 3 598ms 199ms 11 1 170ms 170ms 15 2 546ms 273ms 16 18 4s540ms 252ms 17 7 1s616ms 230ms [ User: intelifix - Total duration: 11s259ms - Times executed: 49 ]
[ Application: [unknown] - Total duration: 11s259ms - Times executed: 49 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '229850256081,229811222732,216942462527,229755615464,216943899097,229779275865,229782172142,229737031530,229686523031,216943929404,229685118102,229813847791,229690431415,229665495973,229740098810,229747585163,229783385256,229814425659,229672427895,229738414358', '113;1', 'DEFAULT', 00, 0141, '','', '', 00);
Date: 2026-06-11 16:27:31 Duration: 416ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '229735399305,229738064952,229816754652,229747822336,229737652028,229741334250,229865637593,229672385871,216942184262,229809346970,229812229811,229741673352,229859119505,229734913646,229746971232,229662785877,229747338494,229746818286,229750103748', '113;1', 'DEFAULT', 00, 0141, '','', '', 00);
Date: 2026-06-11 16:49:44 Duration: 363ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (430, 5, 2, 28, '743AEFD99581,84011280922D,840112EC75A5,743AEFD9C792,8401120429BF,9877E7071719,9877E74DB28C,9877E70C8A50,9877E7BE7E4F,743AEF715E76,840112053DE4,9877E7B9DC15,84011295E29E,743AEF320243,743AEF34E97E,84011229A254,9877E74EC5DF,840112822421,743AEF3385B2,1834AF285AAC,1834AF614CCA,84011203BE96,1834AF2956DD,8401127F75D4,743AEFDD1AE6,84011281ECD0', '','DEFAULT',00,0153,'', '','', 00);
Date: 2026-06-11 15:17:11 Duration: 340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 46 1m28s 151ms 8s185ms 1s916ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 11 07 2 9s714ms 4s857ms 08 3 3s971ms 1s323ms 09 7 14s271ms 2s38ms 10 7 11s127ms 1s589ms 11 7 10s90ms 1s441ms 12 2 3s348ms 1s674ms 13 4 2s438ms 609ms 14 3 8s477ms 2s825ms 15 4 9s961ms 2s490ms 16 2 2s942ms 1s471ms 17 5 11s797ms 2s359ms [ User: intelifix - Total duration: 1m28s - Times executed: 46 ]
[ Application: psql - Total duration: 1m28s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025440);
Date: 2026-06-11 07:21:21 Duration: 8s185ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025494);
Date: 2026-06-11 14:20:18 Duration: 7s174ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025512);
Date: 2026-06-11 17:25:40 Duration: 3s928ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 6m16s 6m16s 6m16s 1 6m16s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 11 12 1 6m16s 6m16s [ User: intelifix - Total duration: 6m16s - Times executed: 1 ]
[ Application: psql - Total duration: 6m16s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-11 12:11:18 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: psql
2 342ms 8m6s 3m27s 3 10m21s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 11 05 3 10m21s 3m27s [ User: intelifix - Total duration: 10m21s - Times executed: 3 ]
[ Application: psql - Total duration: 10m21s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-11 05:08:07 Duration: 8m6s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-11 05:10:22 Duration: 2m14s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-11 05:08:08 Duration: 342ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 824ms 8m55s 3m6s 31 1h36m13s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 11 07 2 8m57s 4m28s 08 2 5m59s 2m59s 09 2 7m25s 3m42s 10 2 7m3s 3m31s 11 2 7m17s 3m38s 12 1 1s73ms 1s73ms 13 2 5m33s 2m46s 14 2 6m20s 3m10s 15 2 6m3s 3m1s 16 2 7m27s 3m43s 17 2 5m59s 2m59s 18 2 5m43s 2m51s 19 2 5m36s 2m48s 20 2 5m46s 2m53s 21 2 5m23s 2m41s 22 2 5m34s 2m47s [ User: intelifix - Total duration: 1h36m13s - Times executed: 31 ]
[ Application: psql - Total duration: 1h36m13s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-11 07:13:56 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-11 16:12:27 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-11 09:12:23 Duration: 7m21s Database: rio User: intelifix Remote: [local] Application: psql
4 1m21s 1m33s 1m27s 2 2m54s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 11 20 1 1m21s 1m21s 23 1 1m33s 1m33s [ User: intelifix - Total duration: 2m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m54s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-11 23:37:05 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-11 20:08:15 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
5 23s806ms 1m31s 57s552ms 2 1m55s 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 11 23 2 1m55s 57s552ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - 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-11 23:13:59 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-11 23:38:34 Duration: 23s806ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 53s539ms 1m 57s75ms 2 1m54s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 11 20 1 1m 1m 23 1 53s539ms 53s539ms [ User: intelifix - Total duration: 1m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-11 20:05:21 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-11 23:17:43 Duration: 53s539ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 150ms 4m17s 21s610ms 279 1h40m29s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 11 07 5 7m58s 1m35s 08 16 9m33s 35s855ms 09 27 13m5s 29s99ms 10 31 14m17s 27s651ms 11 38 12m47s 20s187ms 12 12 9m49s 49s123ms 13 17 1m18s 4s628ms 14 35 8m12s 14s65ms 15 44 20m2s 27s337ms 16 33 2m20s 4s252ms 17 21 1m3s 3s26ms [ User: intelifix - Total duration: 1h40m29s - Times executed: 279 ]
[ Application: [unknown] - Total duration: 1h40m29s - Times executed: 279 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025484, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 11:55:51 Duration: 4m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025502, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:58:47 Duration: 4m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-11 15:42:03 Duration: 4m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 14s397ms 26s368ms 18s600ms 32 9m55s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 11 08 1 26s368ms 26s368ms 09 6 1m45s 17s544ms 10 2 31s569ms 15s784ms 11 1 19s824ms 19s824ms 14 4 1m9s 17s438ms 15 8 2m36s 19s585ms 16 5 1m37s 19s579ms 17 5 1m27s 17s569ms [ User: intelifix - Total duration: 9m55s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 9m55s - Times executed: 32 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-11', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-11 08:59:41 Duration: 26s368ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-11', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-11 15:57:35 Duration: 25s173ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-11', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-11 15:58:58 Duration: 24s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 418ms 1m1s 18s538ms 32 9m53s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 11 07 2 58s880ms 29s440ms 08 2 29s591ms 14s795ms 09 2 1m2s 31s459ms 10 2 36s182ms 18s91ms 11 2 36s861ms 18s430ms 12 2 32s918ms 16s459ms 13 2 30s895ms 15s447ms 14 2 41s233ms 20s616ms 15 2 30s464ms 15s232ms 16 2 37s135ms 18s567ms 17 2 32s275ms 16s137ms 18 2 33s159ms 16s579ms 19 2 28s605ms 14s302ms 20 2 38s938ms 19s469ms 21 2 32s221ms 16s110ms 22 2 30s942ms 15s471ms [ User: intelifix - Total duration: 9m53s - Times executed: 32 ]
[ Application: psql - Total duration: 9m53s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-11 09:13:24 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-11 07:14:54 Duration: 57s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-11 14:11:57 Duration: 39s689ms Database: rio User: intelifix Remote: [local] Application: psql
10 8s894ms 13s119ms 10s758ms 27 4m50s create table temp0000282313 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 11 09 15 2m48s 11s203ms 10 6 1m1s 10s272ms 11 6 1m 10s132ms [ User: intelifix - Total duration: 4m50s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 27 ]
-
CREATE TABLE temp0000282313 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:53:28 Duration: 13s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282313 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:35:14 Duration: 12s402ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282313 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:53:58 Duration: 12s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s948ms 12s829ms 10s227ms 24 4m5s create table temp0000282297 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 11 08 5 52s992ms 10s598ms 09 3 29s513ms 9s837ms 10 12 2m2s 10s224ms 11 4 40s268ms 10s67ms [ User: intelifix - Total duration: 4m5s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4m5s - Times executed: 24 ]
-
CREATE TABLE temp0000282297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 08:55:13 Duration: 12s829ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 10:05:10 Duration: 12s86ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:05:10 Duration: 11s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s75ms 13s348ms 10s182ms 90 15m16s create table temp0000282275 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 11 07 11 1m39s 9s40ms 08 11 1m48s 9s828ms 09 17 3m1s 10s648ms 10 10 1m41s 10s191ms 11 15 2m41s 10s758ms 12 4 35s836ms 8s959ms 14 6 1m5s 10s927ms 15 16 2m43s 10s193ms [ User: intelifix - Total duration: 15m16s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 15m16s - Times executed: 90 ]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:50:56 Duration: 13s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 11:51:16 Duration: 12s862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 09:13:05 Duration: 12s425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s920ms 11s527ms 10s134ms 23 3m53s create table temp0000282363 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 11 13 2 20s362ms 10s181ms 14 11 1m51s 10s106ms 16 6 1m2s 10s387ms 17 4 39s228ms 9s807ms [ User: intelifix - Total duration: 3m53s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 3m53s - Times executed: 23 ]
-
CREATE TABLE temp0000282363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 16:33:48 Duration: 11s527ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 16:34:54 Duration: 11s324ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 14:25:49 Duration: 10s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 8s329ms 10s916ms 9s723ms 25 4m3s create table temp0000282381 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 11 16 3 29s314ms 9s771ms 17 22 3m33s 9s717ms [ User: intelifix - Total duration: 4m3s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 25 ]
-
CREATE TABLE temp0000282381 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 17:36:48 Duration: 10s916ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282381 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 17:02:06 Duration: 10s849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282381 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-11 17:25:12 Duration: 10s823ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3s329ms 10s337ms 4s949ms 60 4m56s create table temp0000282275 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 11 07 10 43s902ms 4s390ms 08 2 8s715ms 4s357ms 09 10 52s261ms 5s226ms 10 6 25s645ms 4s274ms 11 9 43s524ms 4s836ms 14 12 1m1s 5s136ms 15 3 15s884ms 5s294ms 16 8 45s367ms 5s670ms [ User: intelifix - Total duration: 4m56s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 4m56s - Times executed: 60 ]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 07:34:28 Duration: 10s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 09:21:28 Duration: 9s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282275 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"06-06-2026", "ate" :"11-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-11 16:07:21 Duration: 6s382ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2s60ms 22s29ms 3s32ms 137 6m55s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 11 00 6 21s513ms 3s585ms 01 6 16s194ms 2s699ms 02 6 15s188ms 2s531ms 03 5 13s985ms 2s797ms 04 6 17s1ms 2s833ms 05 6 17s58ms 2s843ms 06 6 17s94ms 2s849ms 07 6 16s942ms 2s823ms 08 6 53s940ms 8s990ms 09 6 18s214ms 3s35ms 10 6 17s186ms 2s864ms 11 6 17s218ms 2s869ms 12 6 14s663ms 2s443ms 13 6 16s272ms 2s712ms 14 6 17s597ms 2s932ms 15 6 14s755ms 2s459ms 16 6 18s973ms 3s162ms 17 6 15s827ms 2s637ms 18 6 14s853ms 2s475ms 19 6 13s460ms 2s243ms 20 6 16s359ms 2s726ms 21 6 16s459ms 2s743ms 22 6 14s621ms 2s436ms [ User: intelifix - Total duration: 6m55s - Times executed: 137 ]
[ Application: psql - Total duration: 6m55s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:35:27 Duration: 22s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 08:25:25 Duration: 20s9ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-11 00:05:21 Duration: 8s419ms Database: rio User: intelifix Remote: [local] Application: psql
17 196ms 11s313ms 2s336ms 105 4m5s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 11 00 6 16s5ms 2s667ms 01 6 6s926ms 1s154ms 02 6 4s269ms 711ms 03 6 5s281ms 880ms 04 6 6s717ms 1s119ms 05 4 10s947ms 2s736ms 06 5 6s494ms 1s298ms 07 6 35s250ms 5s875ms 08 6 23s523ms 3s920ms 09 6 16s623ms 2s770ms 10 5 4s269ms 853ms 11 5 4s551ms 910ms 12 6 7s827ms 1s304ms 13 6 20s591ms 3s431ms 14 6 27s657ms 4s609ms 15 6 19s298ms 3s216ms 16 4 15s425ms 3s856ms 21 4 6s579ms 1s644ms 22 6 7s72ms 1s178ms [ User: intelifix - Total duration: 4m5s - Times executed: 105 ]
[ Application: psql - Total duration: 4m5s - Times executed: 105 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 00:05:12 Duration: 11s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 07:35:10 Duration: 8s359ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-11 07:15:09 Duration: 7s850ms Database: rio User: intelifix Remote: [local] Application: psql
18 151ms 8s185ms 1s916ms 46 1m28s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 11 07 2 9s714ms 4s857ms 08 3 3s971ms 1s323ms 09 7 14s271ms 2s38ms 10 7 11s127ms 1s589ms 11 7 10s90ms 1s441ms 12 2 3s348ms 1s674ms 13 4 2s438ms 609ms 14 3 8s477ms 2s825ms 15 4 9s961ms 2s490ms 16 2 2s942ms 1s471ms 17 5 11s797ms 2s359ms [ User: intelifix - Total duration: 1m28s - Times executed: 46 ]
[ Application: psql - Total duration: 1m28s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025440);
Date: 2026-06-11 07:21:21 Duration: 8s185ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025494);
Date: 2026-06-11 14:20:18 Duration: 7s174ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025512);
Date: 2026-06-11 17:25:40 Duration: 3s928ms Database: rio User: intelifix Remote: [local] Application: psql
19 175ms 38s918ms 1s786ms 78 2m19s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 11 07 4 2s93ms 523ms 08 6 14s103ms 2s350ms 09 14 6s22ms 430ms 10 11 1m7s 6s138ms 11 10 7s883ms 788ms 12 4 9s980ms 2s495ms 13 2 3s106ms 1s553ms 14 5 16s319ms 3s263ms 15 6 2s977ms 496ms 16 4 6s295ms 1s573ms 17 12 3s5ms 250ms [ User: intelifix - Total duration: 2m19s - Times executed: 78 ]
[ Application: psql - Total duration: 2m19s - Times executed: 78 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025467);
Date: 2026-06-11 10:14:35 Duration: 38s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025470);
Date: 2026-06-11 10:22:24 Duration: 20s802ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025445);
Date: 2026-06-11 08:25:04 Duration: 11s248ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 4s331ms 707ms 1,604 18m54s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 11 07 13 6s964ms 535ms 08 153 1m47s 702ms 09 215 2m40s 747ms 10 146 1m39s 682ms 11 225 2m10s 580ms 12 37 22s294ms 602ms 13 80 52s361ms 654ms 14 243 3m25s 844ms 15 210 2m21s 675ms 16 200 2m29s 749ms 17 82 58s396ms 712ms [ User: intelifix - Total duration: 18m54s - Times executed: 1604 ]
[ Application: [unknown] - Total duration: 18m54s - Times executed: 1604 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252234, 450, 'CP2317320NE,D4925E947864,544D424200681BA6,D4925E947867$CP2228321R0,A0B53C661DFA,544D4242005A33D2,A0B53C661DFD$CP2411322S3,08C7F52FEB3C,544D424200788449,08C7F52FEB3F$CP230132WRJ,D4925E05FDB3,544D4242006192DA,D4925E05FDB6$CP230132W57,D4925E05E5D4,544D424200619033,D4925E05E5D7$CP230232QEE,D4925E09C85D,544D42420061FDFA,D4925E09C860$CP240432CJP,08C7F526CE16,544D424200774BF7,08C7F526CE19$CP2233325SC,A0B53C9727E0,544D4242005C3157,A0B53C9727E3$CP240932R1N,08C7F52EFD9D,544D4242007869E2,08C7F52EFDA0$CP2330329LT,D4925EE34622,544D4242006E7283,D4925EE34625$CP2301323LG,D4925E01EDB5,544D424200611F4C,D4925E01EDB8$CP234532DVE,08C7F503E6A0,544D424200736D15,08C7F503E6A3$CP2302323FB,D4925E06A56E,544D42420061A4C3,D4925E06A571$CP240332FAE,08C7F5231894,544D42420076E279,08C7F5231897$CP230132T5G,D4925E057389,544D424200618380,D4925E05738C$CP23423253K,D4925EF63B7F,544D42420071F704,D4925EF63B82$CP230232QCJ,D4925E09C62F,544D42420061FDBC,D4925E09C632$CP240932L9W,08C7F52E47C0,544D4242007855AD,08C7F52E47C3$CP2320327PK,D4925EA4AA86,544D42420069D0FC,D4925EA4AA89$CP23273229F,D4925ED4F396,544D4242006DA793,D4925ED4F399$CP2409329AV,08C7F52CA3BD,544D424200782702,08C7F52CA3C0$CP234532BWH,08C7F5039B52,544D4242007364B7,08C7F5039B55$CP234232Q6R,D4925EF91677,544D42420072483C,D4925EF9167A$CP234232LD9,D4925EF884E2,544D42420072380F,D4925EF884E5$CP230232KDN,D4925E09080F,544D42420061E89C,D4925E090812$CP232032D82,D4925EA57E45,544D42420069E883,D4925EA57E48$CP2346320Y2,08C7F506F043,544D42420073BACE,08C7F506F046$CP230232E9W,D4925E084446,544D42420061D2DB,D4925E084449$CP240932H7Y,08C7F52DD29C,544D4242007848A9,08C7F52DD29F$CP234232R43,D4925EF939A8,544D424200724C25,D4925EF939AB$CP234532DKG,08C7F503DB18,544D424200736BCD,08C7F503DB1B$CP2411324YQ,08C7F5303E58,544D424200788D85,08C7F5303E5B$CP2320325P1,D4925EA45D52,544D42420069C868,D4925EA45D55$CP230132RUE,D4925E054179,544D424200617DF0,D4925E05417C$CP234532NLC,08C7F50534AE,544D424200739233,08C7F50534B1$CP2322323F4,D4925EB359F4,544D4242006B9A74,D4925EB359F7$CP240932KL0,08C7F52E2D2C,544D4242007852B9,08C7F52E2D2F$CP2322321PR,D4925EB31767,544D4242006B930F,D4925EB3176A$CP232232BU5,D4925EBD3467,544D4242006BBE2A,D4925EBD346A$CP23033229R,D4925E13ED16,544D42420062BCF7,D4925E13ED19', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 09:34:55 Duration: 4s331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252229, 504, '2102313BFARYN2911647,88892F8A8BAD,48575443E55AE5A8,88892F8A8BB0BFARYMA925214,C0BC9A493A78,48575443B8EF72A7,C0BC9A493A7BBFARYN2953574,B85FB005D25E,48575443F9B20BA8,B85FB005D261BFARYMB900935,BC76C5B59BF8,4857544317A644A8,BC76C5B59BFBBFARYN1911156,C4FBAAFB33F3,48575443D3D1C6A8,C4FBAAFB33F6BFARYN1915585,C4FBAAFB8095,48575443D3D648A8,C4FBAAFB8098BFARYM7920338,345840E9B1E4,4857544391EBCCA6,345840E9B1E7BFARYM8960918,2868D2380F6D,48575443FB643DA6,2868D2380F70BFARYMA950188,C40D96A85C45,48575443E292FCA7,C40D96A85C48BFARYMA961768,C40D96AF152B,48575443E2F6BFA7,C40D96AF152EBFARYM7901117,F09BB8C41508,485754437D5DB2A6,F09BB8C4150BBFARYM7923018,5C647AE00FC8,48575443BA7334A6,5C647AE00FCBBFARYN4908506,0893561C3A71,485754434B3299A9,0893561C3A74BFARYMA900633,CCB1827F631B,485754438081D9A7,CCB1827F631EBFARYN1900044,645E10FAEF23,48575443C2A997A8,645E10FAEF26BFARYN7911069,6CE87455FEB2,48575443AA6AD5AA,6CE87455FEB5BFARYM6925811,B0761BBEEEBC,48575443714D82A6,B0761BBEEEBFBFARYN7909710,6CE874010C26,48575443A6EAEFAA,6CE874010C29BFARYM4916177,482CD09007B0,48575443CB8AFEA5,482CD09007B3BFARYN2916737,88892F898DAC,48575443E54BF2A8,88892F898DAFBFARYM4935924,D44649B83F4A,48575443DD2BFCA5,D44649B83F4DBFARYN1910550,C4FBAAFC7F0D,48575443D3E540A8,C4FBAAFC7F10BFARYMC902409,04E7953BB5A9,485754437459DDA8,04E7953BB5ACBFARYM8909802,1C3D2F4C7F75,48575443D564DAA6,1C3D2F4C7F78BFARYN2917749,88892F8A8030,48575443E55A38A8,88892F8A8033BFARYMA910409,6C442A90C6C4,485754439F1358A7,6C442A90C6C7BFARYM9915991,00E4060B4FC7,485754433A89F6A7,00E4060B4FCABFARYM7929738,30C50FB6906E,48575443CEC33AA6,30C50FB69071BFARYMA906247,CCB182ACAC80,485754438561F2A7,CCB182ACAC83BFARYMB904254,F82E3F6DB98C,48575443452F5EA8,F82E3F6DB98FBFARYM8951301,2868D2160569,48575443FA8C63A6,2868D216056CBFARYMB900244,BC76C5B474B6,48575443179477A8,BC76C5B474B9BFARYM7921811,5C647ADF8BA2,48575443BA6A91A6,5C647ADF8BA5BFARYMA962316,C40D96A45BC2,48575443E20545A7,C40D96A45BC5BFARYM8952943,2868D2171577,48575443FA9C39A6,2868D217157ABFARYMA963789,C40D96A3DF0C,48575443E1EDAAA7,C40D96A3DF0FBFARYM8947847,E8136E941531,48575443F31F0FA6,E8136E941534', '',0189,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 15:26:42 Duration: 4s22ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (252226, 504, '921501047581,345D9EBE1472,D0CF0EFDCD0D,ACD75BB5762B,C4EB429FF9FE,D833B7CA5AF7,5CFA25AC9531,209A7DB393D9,D06DC964F712,D0CF0EFE1598,209A7DB7413D,64FD96564297,186A81D5B412,345D9EB46926,D833B7CA304F,D0CF0EFDF895,943C96AB55AB,64FD965E0897,C03C0480DF00,209A7DBBB45D,8CC5B4ED311F,841EA3699C5D,186A81D57CC1,D0CF0EFE02AC,5CFA259C02A0,B0BBE549BE3F,E4C0E240594E,186A81D5B6AB,C4EB42A00121,5CFA2580A1D9,94988F316EB8,506F0C3CA8E9,841EA39870A2,841EA38D4B9E,44D454C3137C', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-11 11:37:00 Duration: 3s752ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 11 18 1 0ms 0ms 19 1 0ms 0ms [ User: intelifix - Total duration: 5m38s - Times executed: 2 ]
[ Application: psql - Total duration: 5m38s - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 13,461 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 13 FATAL entries
- 2003 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,506 Max number of times the same event was reported
- 2,018 Total events found
Rank Times reported Error 1 1,506 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 11 07 17 08 157 09 293 10 205 11 190 12 24 13 117 14 147 15 188 16 124 17 44 - ERROR: prepared statement "_PLAN0000000040B522C0" does not exist
- ERROR: prepared statement "_PLAN0000000040B53E20" does not exist
- ERROR: prepared statement "_PLAN0000000040B53E20" does not exist
Statement: DEALLOCATE "_PLAN0000000040B522C0"
Date: 2026-06-11 07:51:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000040B53E20"
Date: 2026-06-11 07:51:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000040B53E20"
Date: 2026-06-11 07:52:44 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 137 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 11 00 6 01 6 02 6 03 5 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-11 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-11 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-11 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
3 137 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 11 00 6 01 6 02 6 03 5 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-11 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-11 00:15:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-11 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
4 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 11 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-11 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-11 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-11 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 11 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-11 08:00:26 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-11 08:20:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-11 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
6 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 11 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 2 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-11 08:00:26 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-11 08:20:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 46101: "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-11 08:40:06 Database: rio Application: psql User: intelifix Remote: [local]
7 37 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 11 15 34 16 3 - ERROR: syntax error at or near "F200010279BA1AF" at character 32
- ERROR: syntax error at or near "F200010279BA1AF" at character 81
- ERROR: syntax error at or near "F200010279BA1AF" at character 72
Statement: SELECT RS_SERIAL_TEMPORARIO( ''F200010279BA1AF' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''F200010279BA1AF' )
Date: 2026-06-11 15:51:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"252525","seriais":[{"serial":"'F200010279BA1AF"},{"serial":"743AEFABFBC8"}]}')
Date: 2026-06-11 15:51:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"153","seriais":[{"serial":"'F200010279BA1AF"},{"serial":"743AEFABFBC8"}]}');
Date: 2026-06-11 15:51:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 11 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-11 07:14:54 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-11 08:11:29 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-11 09:13:24 Database: brasilia Application: psql User: intelifix Remote: [local]
9 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 11 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-11 07:14:54 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-11 08:11:29 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-11 09:13:24 Database: brasilia Application: psql User: intelifix Remote: [local]
10 9 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 11 05 8 08 1 - ERROR: relation "public.equipamentos" does not exist at character 49
- ERROR: relation "public.equipamentos" does not exist
- ERROR: relation "public.codigos_barra" does not exist at character 70
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, mod_id FROM public.equipamentos
Date: 2026-06-11 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
Context: remote SQL command: SELECT eq_id, mod_id FROM public.equipamentos
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-11 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, eq_seq, eq_codigo, eq_extra FROM public.codigos_barra
Date: 2026-06-11 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
11 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 11 00 1 01 1 06 1 21 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-06-11 00:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-11 01:36:13 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-11 06:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
12 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 11 07 3 09 2 - ERROR: trailing junk after numeric literal at or near "88ç0fça2ça1çebç4b" at character 27
- ERROR: trailing junk after numeric literal at or near "88ç0fça2ça1çebç4b" at character 27
- ERROR: trailing junk after numeric literal at or near "88ç0fça2ça1çebç4b" at character 27
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2ça1çebç4b)
Date: 2026-06-11 07:55:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2ça1çebç4b)
Date: 2026-06-11 07:55:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2ça1çebç4b)
Date: 2026-06-11 07:55:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
13 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 11 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-11 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-11 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-11 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
14 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 11 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-11 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-11 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-11 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 11 00 1 06 1 - ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-11 00:05:20 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-11 06:05:09 Database: brasilia Application: psql User: intelifix Remote: [local]
16 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 11 21 1 - ERROR: function rs_del_temporario() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_DEL_TEMPORARIO()Date: 2026-06-11 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]
17 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 11 18 1 - ERROR: function rs_lote_entrada_fechar_automatico() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_ENTRADA_FECHAR_AUTOMATICO()Date: 2026-06-11 18:00:02 Database: brasilia Application: psql User: intelifix Remote: [local]
18 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 11 08 1 - LOG: process 2944364 still waiting for ShareLock on transaction 907009 after 1000.142 ms
Detail: Process holding the lock: 2942818. Wait queue: 2944364.
Context: while updating tuple (70083,15) 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-11 08:35:09 Database: rio Application: psql User: intelifix Remote: [local]
19 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 11 03 1 - LOG: database system was shut down at 2026-06-11 03:05:01 -03
Date: 2026-06-11 03:05:02
20 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 11 18 1 - ERROR: invalid input syntax for type json 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
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-11 18:00:06 Database: rio Application: psql User: intelifix Remote: [local]