pgBadger-
Global information
- Generated on Mon Jun 15 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,327 log entries in 7s
- Log start from 2026-06-15 00:02:01 to 2026-06-15 23:45:12
-
Overview
Global Stats
- 302 Number of unique normalized queries
- 6,249 Number of queries
- 7h41m44s Total query duration
- 2026-06-15 00:02:13 First query
- 2026-06-15 23:41:45 Last query
- 5 queries/s at 2026-06-15 11:51:00 Query peak
- 7h41m44s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h41m44s Execute total duration
- 2,920 Number of events
- 23 Number of unique normalized events
- 2,403 Max number of times the same event was reported
- 0 Number of cancellation
- 456 Total number of automatic vacuums
- 925 Total number of automatic analyzes
- 17 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 256 Total number of sessions
- 7 sessions at 2026-06-15 07:01:15 Session peak
- 9d12h2m57s Total duration of sessions
- 53m26s Average duration of sessions
- 24 Average queries per session
- 1m48s Average queries duration per session
- 51m38s Average idle time per session
- 268 Total number of connections
- 5 connections/s at 2026-06-15 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-15 11:51:00 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-15 11:51:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-15 23:41:35 Date
Queries duration
Key values
- 7h41m44s 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 15 00 13 0ms 22s336ms 6s551ms 59s622ms 59s622ms 59s622ms 01 6 0ms 2s750ms 2s523ms 2s750ms 2s750ms 2s750ms 02 6 0ms 2s982ms 2s607ms 2s982ms 2s982ms 2s982ms 03 7 0ms 3s519ms 2s609ms 3s519ms 3s519ms 3s519ms 04 6 0ms 2s830ms 2s685ms 2s830ms 2s830ms 2s830ms 05 9 0ms 8m25s 1m13s 2m19s 8m26s 8m26s 06 27 0ms 1m 6s4ms 46s996ms 1m 1m 07 167 0ms 12m10s 14s683ms 1m44s 3m51s 12m10s 08 751 150ms 6m36s 2s612ms 50s715ms 3m57s 6m38s 09 583 150ms 10m33s 4s589ms 1m7s 5m22s 10m48s 10 698 150ms 9m44s 2s876ms 49s555ms 4m19s 10m1s 11 653 150ms 7m7s 3s338ms 1m5s 4m23s 8m7s 12 151 0ms 8m15s 9s14ms 27s504ms 3m34s 8m15s 13 463 0ms 5m40s 2s448ms 37s147ms 1m32s 5m40s 14 701 150ms 10m11s 3s662ms 1m4s 5m36s 10m28s 15 679 150ms 11m30s 4s549ms 1m33s 5m8s 12m10s 16 674 150ms 7m3s 2s58ms 29s257ms 58s203ms 7m55s 17 300 0ms 6m27s 4s564ms 1m6s 1m26s 6m29s 18 11 0ms 5m43s 35s916ms 32s308ms 5m43s 5m43s 19 10 0ms 5m38s 39s18ms 33s305ms 5m38s 5m38s 20 71 0ms 9m3s 15s391ms 1m30s 9m3s 9m3s 21 24 0ms 5m17s 15s768ms 5s338ms 5m49s 5m49s 22 18 0ms 5m35s 21s822ms 30s865ms 5m35s 5m35s 23 221 0ms 1m50s 8s579ms 1m13s 1m50s 2m12s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 15 00 2 0 6s529ms 0ms 13s59ms 13s59ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 16 0 7s821ms 1s268ms 46s996ms 1m 07 113 0 17s842ms 4s589ms 1m44s 6m29s 08 588 0 2s367ms 11s149ms 26s694ms 3m56s 09 474 0 4s424ms 15s182ms 1m7s 4m53s 10 588 0 3s69ms 15s500ms 24s919ms 5m50s 11 527 0 3s422ms 16s330ms 1m5s 4m28s 12 108 0 10s806ms 3s175ms 13s956ms 5m3s 13 364 0 2s403ms 11s726ms 32s550ms 1m20s 14 591 0 3s858ms 19s957ms 42s122ms 6m38s 15 555 0 4s440ms 24s906ms 1m23s 4m57s 16 530 0 2s212ms 10s428ms 23s335ms 4m3s 17 240 0 4s521ms 25s455ms 55s881ms 1m27s 18 5 0 1m15s 0ms 32s308ms 5m43s 19 4 0 1m33s 0ms 33s305ms 5m38s 20 9 55 16s697ms 1m18s 1m22s 9m3s 21 12 0 29s358ms 338ms 1s230ms 5m49s 22 6 0 1m1s 1s81ms 30s865ms 5m35s 23 4 217 8s579ms 1m10s 1m13s 2m11s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 15 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 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 8 8.00 0.00% 08 0 9 9.00 0.00% 09 0 8 8.00 0.00% 10 0 9 9.00 0.00% 11 0 8 8.00 0.00% 12 0 5 5.00 0.00% 13 0 8 8.00 0.00% 14 0 7 7.00 0.00% 15 0 10 10.00 0.00% 16 0 7 7.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 15 00 12 0.00/s 01 5 0.00/s 02 4 0.00/s 03 10 0.00/s 04 5 0.00/s 05 7 0.00/s 06 11 0.00/s 07 17 0.00/s 08 16 0.00/s 09 18 0.01/s 10 18 0.01/s 11 13 0.00/s 12 12 0.00/s 13 20 0.01/s 14 17 0.00/s 15 19 0.01/s 16 14 0.00/s 17 11 0.00/s 18 7 0.00/s 19 4 0.00/s 20 9 0.00/s 21 6 0.00/s 22 7 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Jun 15 00 1 10m 8m35s 01 10 1h1m12s 1h1m10s 02 5 1h36s 1h32s 03 10 26m6s 26m4s 04 4 1h 59m56s 05 7 48m17s 46m43s 06 5 1h 59m27s 07 12 50m24s 47m 08 16 1h13s 58m10s 09 18 53m10s 50m41s 10 17 54m27s 52m29s 11 18 56m21s 54m20s 12 13 54m38s 52m53s 13 12 42m41s 41m6s 14 16 1h10s 57m30s 15 17 57m48s 54m46s 16 17 58m37s 57m15s 17 15 53m2s 51m31s 18 11 56m22s 55m46s 19 6 1h56s 59m51s 20 7 36m39s 34m3s 21 5 1h1m3s 59m48s 22 7 53m17s 52m21s 23 7 38m49s 34m18s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-15 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 268 connections Total
Connections per user
Key values
- intelifix Main User
- 268 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-15 07:01:15 Date
Histogram of session times
Key values
- 205 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 256 sessions Total
Sessions per user
Key values
- intelifix Main User
- 256 sessions Total
Sessions per host
Key values
- [local] Main Host
- 256 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,285 buffers Checkpoint Peak
- 2026-06-15 14:59:37 Date
- 270.035 seconds Highest write time
- 0.149 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-06-15 14:04:37 Date
Checkpoints distance
Key values
- 345.00 Mo Distance Peak
- 2026-06-15 14:04:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 15 00 4,436 269.254s 0.002s 269.262s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 6,975 0.39s 0.004s 0.405s 04 0 0s 0s 0s 05 4,462 446.82s 0.008s 446.848s 06 3,245 325.433s 0.011s 325.473s 07 42,390 2,574.825s 0.081s 2,574.987s 08 57,001 3,205.301s 0.234s 3,205.698s 09 69,224 3,239.428s 0.194s 3,239.752s 10 61,338 3,239.273s 0.241s 3,239.678s 11 78,714 3,239.177s 0.367s 3,239.705s 12 34,233 2,371.928s 0.101s 2,372.112s 13 25,244 2,087.38s 0.121s 2,087.62s 14 92,002 3,163.312s 0.223s 3,163.688s 15 81,522 3,224.274s 0.243s 3,224.7s 16 54,129 3,100.081s 0.235s 3,100.483s 17 25,498 2,359.515s 0.131s 2,359.746s 18 694 69.786s 0.015s 69.833s 19 33 3.337s 0.002s 3.343s 20 1,802 264.586s 0.009s 264.612s 21 2,418 242.662s 0.02s 242.72s 22 1,989 199.527s 0.021s 199.575s 23 553 55.565s 0.013s 55.608s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 15 00 0 0 1 22 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 24 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 88 0.002s 0.004s 06 0 0 0 169 0.002s 0.004s 07 0 0 29 2,536 0.006s 0.012s 08 0 0 44 5,346 0.003s 0.012s 09 0 0 37 5,714 0.004s 0.012s 10 0 0 26 6,037 0.004s 0.012s 11 0 0 45 5,888 0.128s 0.012s 12 0 0 20 2,345 0.003s 0.012s 13 0 0 18 3,805 0.004s 0.012s 14 0 0 49 5,439 0.008s 0.012s 15 0 0 51 5,636 0.004s 0.012s 16 0 0 29 5,226 0.004s 0.012s 17 0 0 28 3,735 0.003s 0.01s 18 0 0 0 155 0.004s 0.008s 19 0 0 0 7 0.001s 0.001s 20 0 0 1 65 0.003s 0.004s 21 0 0 1 405 0.003s 0.008s 22 0 0 0 429 0.003s 0.007s 23 0 0 3 40 0.004s 0.005s Day Hour Count Avg time (sec) Jun 15 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 15 00 22,986.00 kB 22,986.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 22,081.50 kB 22,081.50 kB 04 0.00 kB 0.00 kB 05 7,783.25 kB 10,602.50 kB 06 2,434.00 kB 13,383.75 kB 07 39,424.83 kB 74,777.42 kB 08 60,503.08 kB 83,056.42 kB 09 50,063.75 kB 88,290.83 kB 10 34,812.33 kB 70,441.33 kB 11 62,108.08 kB 97,920.50 kB 12 27,570.33 kB 72,429.00 kB 13 24,044.50 kB 59,283.25 kB 14 66,723.75 kB 126,914.58 kB 15 69,760.50 kB 133,835.58 kB 16 39,501.67 kB 92,490.67 kB 17 45,678.10 kB 71,678.10 kB 18 572.00 kB 50,119.00 kB 19 189.00 kB 34,188.00 kB 20 4,008.75 kB 27,774.50 kB 21 1,887.57 kB 16,386.71 kB 22 1,525.86 kB 8,789.57 kB 23 9,301.80 kB 22,969.60 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-15 15:33:25 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-15 16:18:35 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 15 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 0 0 0 09 2 208.00 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 1 104.00 MiB 104.00 MiB 13 1 104.00 MiB 104.00 MiB 14 1 104.00 MiB 104.00 MiB 15 4 416.00 MiB 104.00 MiB 16 1 104.00 MiB 104.00 MiB 17 5 520.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.63 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025617, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-15 14:56:28 Duration: 10m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025573, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 07:13:52 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025616, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 14:38:13 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;-
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') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-15 17:19:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 15:33:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 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') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;[ Date: 2026-06-15 17:19:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 17:27:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 11:20:51 - 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-15 13:56:15 - 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-15 14:44:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 15:40:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 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-15 15:00:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 17:33:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 16:18:35 - 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-15 09:03:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 17:14:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,317,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 15:52:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-15 17:40:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 09:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 12:04:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-15 10:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 13.48 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-15 11:19:45 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 13.48 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-15 11:19:45 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (142) Main table analyzed (database rio)
- 925 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 142 rio.pg_catalog.pg_class 72 rio.pg_catalog.pg_type 65 contagem.pg_catalog.pg_attribute 46 rio.public.usuarios 46 rio.pg_catalog.pg_index 43 rio.public.temp0000282493 37 rio.public.temp0000282577 32 rio.public.temp0000282499 31 rio.pg_catalog.pg_depend 31 contagem.public.usuarios 29 contagem.pg_catalog.pg_class 28 rio.public.temp0000282591 28 rio.public.temp0000282533 23 contagem.pg_catalog.pg_type 22 rio.public.temp0000282491 22 rio.public.temp0000282515 20 contagem.public.temp0000226398 20 rio.public.temp0000282529 17 rio.public.temp0000282497 17 rio.public.temp0000282495 17 contagem.pg_catalog.pg_index 14 contagem.pg_catalog.pg_depend 10 rio.public.temp0000282551 10 rio.public.temp0000282517 8 rio.public.temp0000282501 8 rio.public.temp0000282507 8 rio.pg_catalog.pg_shdepend 7 rio.public.temp0000282509 7 rio.public.temp0000282541 5 postgres.pg_catalog.pg_shdepend 5 rio.public.temp0000282535 4 rio.public.tmp_drill_0175 4 contagem.public.temp0000226404 4 rio.public.tmp_drill_0302 4 brasilia.pg_catalog.pg_shdepend 3 contagem.public.temp0000226406 3 contagem.public.temp0000226372 3 rio.public.temp0000282511 2 rio.public.temp0000282547 2 contagem.public.temp0000226396 2 rio.public.temp0000282553 2 rio.public.temp0000282589 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000282583 1 contagem.public.temp0000226388 1 contagem.public.temp0000226402 1 contagem.public.temp0000226400 1 rio.public.temp0000282527 1 rio.public.temp0000282595 1 rio.public.temp0000282523 1 rio.public.temp0000282537 1 rio.public.temp0000282585 1 contagem.public.parametros 1 rio.public.temp0000282513 1 rio.public.temp0000282487 1 rio.public.temp0000282575 1 contagem.public.nf_entrada 1 rio.public.temp0000282543 1 contagem.public.temp0000226392 1 rio.public.temp0000282611 1 rio.public.temp0000282519 1 Total 925 Vacuums per table
Key values
- pg_catalog.pg_attribute (73) Main table vacuumed on database rio
- 456 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 73 54 0 0 0 0 0 29,259 8,091 11,609,017 509 12,351 rio.pg_catalog.pg_class 47 32 0 0 0 0 0 6,110 1,867 2,732,876 108 414 rio.public.temp0000282493 38 0 0 0 0 0 0 39,837 3,296 6,372,348 0 0 rio.pg_catalog.pg_type 34 26 0 0 0 0 0 2,447 696 873,799 74 258 contagem.public.usuarios 29 0 0 0 0 0 0 130 98 57,071 1 1 rio.public.temp0000282591 27 0 0 0 0 0 0 34,677 4,816 8,063,025 0 0 rio.pg_catalog.pg_index 21 18 0 0 0 0 0 1,098 293 247,099 58 110 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 8,871 2,795 4,722,077 36 898 rio.public.temp0000282529 14 0 0 0 0 0 0 760 177 234,902 0 0 rio.pg_catalog.pg_depend 14 14 0 0 0 0 0 4,336 1,511 2,289,971 55 435 rio.public.temp0000282515 11 0 0 0 0 0 0 5,310 59 322,212 0 0 rio.public.temp0000282577 10 0 0 0 0 0 0 5,231 50 316,525 0 0 rio.public.temp0000282551 9 0 0 0 0 0 0 4,745 31 285,906 0 0 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,237 378 558,523 11 32 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,467 2,407 11,119,354 997 4,205 rio.public.temp0000282517 8 0 0 0 0 0 0 699 47 48,551 0 0 rio.public.temp0000282509 7 0 0 0 0 0 0 481 38 34,414 0 0 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 597 200 298,582 8 16 rio.public.usuarios 5 4 0 0 0 0 0 115 33 45,791 5 6 contagem.public.temp0000226398 5 0 0 0 0 0 0 642 171 201,141 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,292 523 2,949,303 139 536 rio.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 567 188 233,581 28 57 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,055 358 725,864 4 24 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 191 68 49,054 3 3 rio.public.tmp_drill_0302 4 4 0 0 0 0 0 1,190 23 218,698 0 0 rio.public.temp0000282535 4 0 0 0 0 0 0 1,666 16 100,881 0 0 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 846 12 152,578 0 0 rio.public.temp0000282533 3 0 0 0 0 0 0 4,723 13 282,530 0 0 rio.public.temp0000282511 2 0 0 0 0 0 0 12 8 1,957 0 0 rio.public.temp0000282547 2 0 0 0 0 0 0 1,577 7 94,184 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 283 66 254,865 23 55 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,985 567 2,115,987 442 3,103 rio.public.temp0000282589 2 0 0 0 0 0 0 1,669 10 100,004 0 0 rio.public.temp0000282553 2 0 0 0 0 0 0 103 98 157,530 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 317 94 112,266 5 8 rio.public.temp0000282527 1 0 0 0 0 0 0 8 5 1,298 0 0 rio.public.notas_fiscais 1 0 0 0 0 0 0 16 14 40,041 1 185 rio.public.temp0000282523 1 0 0 0 0 0 0 84 6 5,861 0 0 rio.public.temp0000282583 1 0 0 0 0 0 0 94 6 6,471 0 0 contagem.public.temp0000226400 1 0 0 0 0 0 0 95 6 6,536 0 0 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 153 43 54,505 16 25 rio.public.temp0000282541 1 0 0 0 0 0 0 8 5 1,303 0 0 rio.public.temp0000282585 1 0 0 0 0 0 0 94 6 6,471 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 79 2 7,511 0 0 rio.public.temp0000282575 1 0 0 0 0 0 0 92 6 6,349 0 0 rio.public.temp0000282487 1 0 0 0 0 0 0 1,574 4 93,469 0 0 rio.public.temp0000282513 1 0 0 0 0 0 0 8 5 1,301 0 0 rio.public.temp0000282537 1 0 0 0 0 0 0 123 6 8,234 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 105 70 231,393 9 1,665 contagem.pg_toast.pg_toast_371967 1 0 0 0 0 0 0 474 162 74,298 156 987 rio.public.temp0000282543 1 0 0 0 0 0 0 84 6 5,864 0 0 contagem.public.temp0000226372 1 0 0 0 0 0 0 47 6 3,605 0 0 contagem.public.temp0000226392 1 0 0 0 0 0 0 94 6 6,477 0 0 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 81,771 37,754 49,009,893 21,429 404,352 rio.public.temp0000282611 1 0 0 0 0 0 0 123 6 8,233 0 0 Total 456 219 0 0 0 0 0 261,651 67,229 107,561,579 24,117 429,726 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (13.48) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.42 rio.pg_catalog.pg_class 0 0 0.8 rio.public.temp0000282493 0 0 1.52 rio.pg_catalog.pg_type 0 0 0.37 contagem.public.usuarios 0 0 0 rio.public.temp0000282591 0 0 1.47 rio.pg_catalog.pg_index 0 0 0.2 contagem.pg_catalog.pg_attribute 0 0 1.29 rio.public.temp0000282529 0 0 0.14 rio.pg_catalog.pg_depend 0 0 0.8 rio.public.temp0000282515 0 0 0.21 rio.public.temp0000282577 0 0 0.26 rio.public.temp0000282551 0 0 0.41 contagem.pg_catalog.pg_class 0 0 0.32 rio.pg_catalog.pg_statistic 0 0 1.18 rio.public.temp0000282517 0 0 0.1 rio.public.temp0000282509 0 0 0.07 contagem.pg_catalog.pg_type 0 0 0.13 rio.public.usuarios 0 0 0 contagem.public.temp0000226398 0 0 0.09 rio.pg_toast.pg_toast_2619 0 0 0.28 rio.pg_catalog.pg_shdepend 0 0 0.15 contagem.pg_catalog.pg_depend 0 0 0.24 contagem.pg_catalog.pg_index 0 0 0.07 rio.public.tmp_drill_0302 0 0 0.04 rio.public.temp0000282535 0 0 0.16 rio.public.tmp_drill_0175 0 0 0.03 rio.public.temp0000282533 0 0 0.16 rio.public.temp0000282511 0 0 0.01 rio.public.temp0000282547 0 0 0.08 contagem.pg_toast.pg_toast_2619 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.2 rio.public.temp0000282589 0 0 0.06 rio.public.temp0000282553 0 0 0.03 postgres.pg_catalog.pg_shdepend 0 0 0.13 rio.public.temp0000282527 0 0 0.01 rio.public.notas_fiscais 0 0 0.02 rio.public.temp0000282523 0 0 0.01 rio.public.temp0000282583 0 0 0 contagem.public.temp0000226400 0 0 0.01 brasilia.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000282541 0 0 0.01 rio.public.temp0000282585 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0 rio.public.temp0000282575 0 0 0.01 rio.public.temp0000282487 0 0 0.05 rio.public.temp0000282513 0 0 0.01 rio.public.temp0000282537 0 0 0.02 rio.public.equipamentos_referencia 0 0 0.03 contagem.pg_toast.pg_toast_371967 0 0 0.07 rio.public.temp0000282543 0 0 0.01 contagem.public.temp0000226372 0 0 0.01 contagem.public.temp0000226392 0 0 0.01 rio.auditor.auditor_2026_06 0 0 13.48 rio.public.temp0000282611 0 0 0.01 Total 0 0 29.23 Tuples removed per table
Key values
- pg_catalog.pg_attribute (227583) Main table with removed tuples on database rio
- 380124 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 73 54 227,583 1,923,564 194,013 164 46,432 contagem.pg_catalog.pg_attribute 16 16 54,103 382,756 320 124 8,540 rio.public.tmp_drill_0302 4 4 16,885 17,428 0 0 441 rio.pg_catalog.pg_statistic 8 8 14,423 66,051 83 0 10,288 rio.public.tmp_drill_0175 4 4 11,713 12,256 0 0 311 rio.pg_catalog.pg_depend 14 14 10,261 272,725 4,346 13 2,509 rio.pg_catalog.pg_type 34 26 10,212 85,836 8,414 23 2,468 rio.pg_catalog.pg_index 21 18 5,605 42,602 2,087 0 1,218 contagem.pg_catalog.pg_statistic 2 2 5,268 15,008 0 0 2,022 rio.pg_catalog.pg_class 47 32 4,799 191,258 26,522 35 6,163 rio.pg_catalog.pg_shdepend 4 4 4,421 33,994 85 0 404 contagem.pg_catalog.pg_depend 4 4 2,941 75,372 0 0 704 postgres.pg_catalog.pg_shdepend 2 2 1,878 16,980 23 0 202 contagem.public.usuarios 29 0 1,748 667 0 0 58 rio.auditor.auditor_2026_06 1 0 1,672 11,144,239 0 0 519,745 brasilia.pg_catalog.pg_shdepend 1 1 1,316 8,500 0 0 101 contagem.pg_catalog.pg_class 8 8 1,274 27,771 0 0 1,022 contagem.pg_catalog.pg_type 7 7 1,261 15,753 0 10 432 rio.pg_toast.pg_toast_2619 4 4 1,217 3,190 0 0 1,060 contagem.pg_catalog.pg_index 4 4 871 7,590 0 0 212 rio.public.usuarios 5 4 314 3,210 675 0 80 brasilia.pg_catalog.pg_statistic 1 1 188 449 0 0 36 contagem.pg_toast.pg_toast_2619 2 2 171 238 0 0 106 rio.public.temp0000282527 1 0 0 1,492 0 52 76 rio.public.temp0000282533 3 0 0 66,456 0 0 4,800 rio.public.temp0000282515 11 0 0 81,003 0 378 5,382 rio.public.notas_fiscais 1 0 0 164,799 0 0 892 rio.public.temp0000282577 10 0 0 105,153 0 195 6,973 rio.public.temp0000282523 1 0 0 1,493 0 52 76 rio.public.temp0000282583 1 0 0 1,644 0 42 86 rio.public.temp0000282511 2 0 0 3,641 0 19 77 rio.public.temp0000282547 2 0 0 44,257 0 0 3,200 contagem.public.temp0000226400 1 0 0 1,128 0 41 87 rio.public.temp0000282541 1 0 0 1,526 0 50 78 rio.public.temp0000282529 14 0 0 44,202 0 223 993 rio.public.temp0000282585 1 0 0 1,644 0 42 86 rio.public.temp0000282575 1 0 0 1,634 0 44 84 rio.public.temp0000282487 1 0 0 22,142 0 0 1,600 rio.public.temp0000282551 9 0 0 199,241 0 0 14,400 rio.public.temp0000282513 1 0 0 1,492 0 52 76 rio.public.temp0000282537 1 0 0 5,096 0 13 115 rio.public.equipamentos_referencia 1 0 0 5,063,740 0 0 27,373 rio.public.temp0000282493 38 0 0 718,049 0 266 51,702 rio.public.temp0000282589 2 0 0 23,798 0 42 1,686 rio.public.temp0000282517 8 0 0 32,881 0 289 735 rio.public.temp0000282509 7 0 0 27,890 0 138 630 contagem.pg_toast.pg_toast_371967 1 0 0 1,002 0 0 159 rio.public.temp0000282553 2 0 0 5,206 0 44 116 rio.public.temp0000282591 27 0 0 598,316 0 0 43,200 rio.public.temp0000282543 1 0 0 1,494 0 52 76 rio.public.temp0000282535 4 0 0 67,936 0 52 4,876 contagem.public.temp0000226372 1 0 0 1,015 0 25 39 contagem.public.temp0000226398 5 0 0 5,055 0 230 602 contagem.public.temp0000226392 1 0 0 1,126 0 42 86 rio.public.temp0000282611 1 0 0 5,095 0 13 115 Total 456 219 380,124 21,648,083 236,568 2,765 775,030 Pages removed per table
Key values
- public.temp0000282515 (378) Main table with removed pages on database rio
- 2765 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282515 11 0 0 378 rio.public.temp0000282517 8 0 0 289 rio.public.temp0000282493 38 0 0 266 contagem.public.temp0000226398 5 0 0 230 rio.public.temp0000282529 14 0 0 223 rio.public.temp0000282577 10 0 0 195 rio.pg_catalog.pg_attribute 73 54 227583 164 rio.public.temp0000282509 7 0 0 138 contagem.pg_catalog.pg_attribute 16 16 54103 124 rio.public.temp0000282527 1 0 0 52 rio.public.temp0000282523 1 0 0 52 rio.public.temp0000282513 1 0 0 52 rio.public.temp0000282543 1 0 0 52 rio.public.temp0000282535 4 0 0 52 rio.public.temp0000282541 1 0 0 50 rio.public.temp0000282575 1 0 0 44 rio.public.temp0000282553 2 0 0 44 rio.public.temp0000282583 1 0 0 42 rio.public.temp0000282585 1 0 0 42 rio.public.temp0000282589 2 0 0 42 contagem.public.temp0000226392 1 0 0 42 contagem.public.temp0000226400 1 0 0 41 rio.pg_catalog.pg_class 47 32 4799 35 contagem.public.temp0000226372 1 0 0 25 rio.pg_catalog.pg_type 34 26 10212 23 rio.public.temp0000282511 2 0 0 19 rio.public.temp0000282537 1 0 0 13 rio.pg_catalog.pg_depend 14 14 10261 13 rio.public.temp0000282611 1 0 0 13 contagem.pg_catalog.pg_type 7 7 1261 10 rio.public.temp0000282533 3 0 0 0 contagem.pg_catalog.pg_class 8 8 1274 0 rio.pg_toast.pg_toast_2619 4 4 1217 0 contagem.public.usuarios 29 0 1748 0 rio.public.notas_fiscais 1 0 0 0 rio.pg_catalog.pg_shdepend 4 4 4421 0 rio.public.temp0000282547 2 0 0 0 contagem.pg_catalog.pg_depend 4 4 2941 0 brasilia.pg_catalog.pg_shdepend 1 1 1316 0 contagem.pg_toast.pg_toast_2619 2 2 171 0 contagem.pg_catalog.pg_index 4 4 871 0 brasilia.pg_catalog.pg_statistic 1 1 188 0 rio.public.temp0000282487 1 0 0 0 rio.public.temp0000282551 9 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5268 0 rio.public.equipamentos_referencia 1 0 0 0 rio.pg_catalog.pg_statistic 8 8 14423 0 contagem.pg_toast.pg_toast_371967 1 0 0 0 rio.public.temp0000282591 27 0 0 0 rio.public.usuarios 5 4 314 0 rio.public.tmp_drill_0302 4 4 16885 0 postgres.pg_catalog.pg_shdepend 2 2 1878 0 rio.auditor.auditor_2026_06 1 0 1672 0 rio.public.tmp_drill_0175 4 4 11713 0 rio.pg_catalog.pg_index 21 18 5605 0 Total 456 219 380,124 2,765 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 5 0 06 0 0 07 11 23 08 51 114 09 70 95 10 44 104 11 45 114 12 9 33 13 42 77 14 31 96 15 68 108 16 39 98 17 40 62 18 0 0 19 0 0 20 0 0 21 1 1 22 0 0 23 0 0 - 13.48 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 6m 2m7s 3m53s 3m call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 09:19:10 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 15:37:17 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 00:05:19 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000282577;-
DROP TABLE IF EXISTS temp0000282577;
Date: 2026-06-15 13:23:34 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282577;
Date: 2026-06-15 13:23:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s 1s 1s 1s drop table if exists temp0000282493;-
DROP TABLE IF EXISTS temp0000282493;
Date: 2026-06-15 16:14:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000282493;
Date: 2026-06-15 09:12:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 3m53s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-15 09:19:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m7s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-15 15:37:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000282577;[ Date: 2026-06-15 13:23:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000282493;[ Date: 2026-06-15 16:14:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,736 Total read queries
- 1,293 Total write queries
Queries by database
Key values
- rio Main database
- 5,349 Requests
- 7h24m53s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,156 Requests
User Request type Count Duration etiquetas Total 9 2s205ms select 9 2s205ms intelifix Total 6,156 7h40m39s copy to 272 38m56s ddl 1,021 49m47s others 220 33m7s select 4,643 5h38m49s lenon Total 84 1m2s select 84 1m2s Duration by user
Key values
- 7h40m39s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 9 2s205ms select 9 2s205ms intelifix Total 6,156 7h40m39s copy to 272 38m56s ddl 1,021 49m47s others 220 33m7s select 4,643 5h38m49s lenon Total 84 1m2s select 84 1m2s Queries by host
Key values
- [local] Main host
- 6,249 Requests
- 7h41m44s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,561 Requests
- 4h6m5s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-15 10:34:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,327 100-500ms duration
Slowest individual queries
Rank Duration Query 1 12m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 07:17:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 15:16:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 09:15:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025617, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-06-15 14:56:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 9m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 10:14:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 20:14:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m25s analyze verbose;[ Date: 2026-06-15 05:08:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 12:13:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 11:12:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 16:12:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 14:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 08:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025573, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-15 07:13:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 17:11:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 18:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 13:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 19:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-15 22:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025616, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-15 14:38:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-15'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-15 10:07:01 - 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 2h17m35s 254 155ms 10m11s 32s502ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 15 06 2 1m47s 53s740ms 07 10 18m19s 1m49s 08 31 8m5s 15s654ms 09 13 16m19s 1m15s 10 15 11m6s 44s446ms 11 19 15m17s 48s269ms 12 6 8m37s 1m26s 13 32 2m14s 4s209ms 14 19 22m7s 1m9s 15 34 20m44s 36s590ms 16 38 5m26s 8s595ms 17 35 7m30s 12s866ms [ User: intelifix - Total duration: 2h17m35s - Times executed: 254 ]
[ Application: [unknown] - Total duration: 2h17m35s - Times executed: 254 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025617, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-15 14:56:28 Duration: 10m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025573, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 07:13:52 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025616, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 14:38:13 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h3m44s 32 995ms 12m10s 3m52s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 15 07 2 12m12s 6m6s 08 2 6m37s 3m18s 09 2 10m37s 5m18s 10 2 9m46s 4m53s 11 2 7m9s 3m34s 12 2 8m17s 4m8s 13 2 5m41s 2m50s 14 2 6m37s 3m18s 15 2 11m34s 5m47s 16 2 7m13s 3m36s 17 2 6m28s 3m14s 18 2 5m45s 2m52s 19 2 5m39s 2m49s 20 2 9m6s 4m33s 21 2 5m19s 2m39s 22 2 5m36s 2m48s [ User: intelifix - Total duration: 2h3m44s - Times executed: 32 ]
[ Application: psql - Total duration: 2h3m44s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-15 07:17:11 Duration: 12m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-15 15:16:31 Duration: 11m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-15 09:15:34 Duration: 10m33s Database: rio User: intelifix Remote: [local] Application: psql
3 27m36s 1,622 150ms 6s535ms 1s21ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 15 07 9 6s220ms 691ms 08 206 3m32s 1s32ms 09 164 3m18s 1s211ms 10 240 4m9s 1s39ms 11 169 2m28s 877ms 12 44 48s732ms 1s107ms 13 104 1m35s 919ms 14 204 3m32s 1s43ms 15 196 3m29s 1s70ms 16 194 3m7s 964ms 17 92 1m26s 945ms [ User: intelifix - Total duration: 27m36s - Times executed: 1622 ]
[ Application: [unknown] - Total duration: 27m36s - Times executed: 1622 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251286, 450, 'CP2228320FH,A0B53C65ECB0,544D4242005A2E58,A0B53C65ECB3$CP2310322MD,D4925E33D240,544D42420065BB1A,D4925E33D243$CP2303326KE,D4925E14917A,544D42420062CF3B,D4925E14917D$CP240932MFR,08C7F52E74D2,544D424200785AAF,08C7F52E74D5$CP2404327M1,08C7F526115E,544D4242007736FF,08C7F5261161$CP230232HJH,D4925E08C11D,544D42420061E0BA,D4925E08C120$CP23303254K,D4925EE29A5C,544D4242006E5F6D,D4925EE29A5F$CP233032FWU,D4925EE43796,544D4242006E8D57,D4925EE43799$CP230532656,D4925E197603,544D424200639186,D4925E197606$CP240932UDZ,08C7F52F7EBE,544D42420078783B,08C7F52F7EC1$CP22283218W,A0B53C660B4F,544D4242005A31BF,A0B53C660B52$CP233032FJV,D4925EE429B3,544D4242006E8BCC,D4925EE429B6$CP233032G8D,D4925EE443E4,544D4242006E8EB5,D4925EE443E7$CP232232D7D,D4925EBD68E4,544D4242006BC3FF,D4925EBD68E7$CP2404326QT,08C7F525EF7A,544D42420077333B,08C7F525EF7D$CP2404323Q8,08C7F5257BF4,544D424200772665,08C7F5257BF7$CP2305327PY,D4925E19B206,544D424200639831,D4925E19B209$CP22393239G,A0B53CC0955B,544D4242005E7B00,A0B53CC0955E$CP232032FUC,D4925EA5E280,544D42420069F3A6,D4925EA5E283$CP2411322W5,08C7F52FEFF2,544D4242007884CF,08C7F52FEFF5$CP234232N01,D4925EF8C220,544D424200723EDD,D4925EF8C223$CP234232QEY,D4925EF91FF5,544D42420072494A,D4925EF91FF8$CP2409324TK,08C7F52BF7AF,544D4242007813E4,08C7F52BF7B2$CP234532G3T,08C7F5043BC6,544D42420073768B,08C7F5043BC9$CP232032TV3,D4925EA7AEA0,544D4242006A26C6,D4925EA7AEA3$CP2319322H2,D4925E9FE518,544D424200699362,D4925E9FE51B$CP2319327NU,D4925EA0AB33,544D42420069A965,D4925EA0AB36$CP2250324VJ,A0B53CF9E0F6,544D42420060BCCC,A0B53CF9E0F9$CP240932NVQ,08C7F52EAB50,544D4242007860BD,08C7F52EAB53$CP230232Q0M,D4925E09B85E,544D42420061FC33,D4925E09B861$CP2409324ET,08C7F52BE8E2,544D42420078123F,08C7F52BE8E5$CP234532L44,08C7F504D544,544D424200738799,08C7F504D547$CP2409324B8,08C7F52BE4BC,544D4242007811C9,08C7F52BE4BF$CP240932JNM,08C7F52E09F2,544D424200784ECF,08C7F52E09F5$CP2301329G1,D4925E02CE2E,544D42420061383D,D4925E02CE31$CP2302322PG,D4925E06889A,544D42420061A18F,D4925E06889D$CP2301329FL,D4925E02CDB0,544D42420061382F,D4925E02CDB3$CP240932GD2,08C7F52DB244,544D424200784511,08C7F52DB247$CP2217320S3,A0B53C3FE94D,544D424200583387,A0B53C3FE950$CP2404325TD,08C7F525CC2E,544D424200772F4F,08C7F525CC31', '',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-15 11:35:54 Duration: 6s535ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (253438, 304, 'F200012003B0FBF,84011295822D$F20001019114BA6,743AEF74E74B$F200010321B62EB,743AEFDA0F59$F200011280B807D,8401125F6FFC$F200011328B54C0,8401128377CB$F200011208B4511,840112070451$F200010290BB563,743AEFAF07A7$F2000101831547F,743AEF745206$F200011216B3FDA,84011227CBE8$F200011152B9160,9877E7BCFE9F$F200011242B10C5,8401122A9134$F20001018411F42,743AEF746B51$F200011302B0979,8401128008D4$F200011193B3956,8401120407F3$F200011070B3110,9877E7492E89$F200011050E1695,9877E70C62E9$F200010284B7E3C,743AEFAD8A19$F20001019212377,743AEF75083E$F200010276B528D,743AEF9D2D56$F20001015614CEC,743AEF5BADB2$F200010293B8CC3,743AEFAF4891$F2000101901246A,743AEF74AD30$F200011131B1135,9877E7B99884$F200011106BE645,9877E77D002F$F200012015B9C0F,840112984924$F200010254E2434,743AEF9A2D39$F200010330E5138,743AEFDC6246$F200011008BB078,9877E707B2AF$F200010301E4674,743AEFC53685$F200010339B6493,9877E7015CD2', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-15 09:22:52 Duration: 6s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251280, 450, '2102313BFARYMC925679,04E7959B2BC5,4857544387C64EA8,04E7959B2BC8BFARYMA941566,C40D969D2DA4,48575443E1225DA7,C40D969D2DA7BFARYM3904684,80E1BF0A980D,48575443B5A8A5A5,80E1BF0A9810BFARYM9910701,C0F6C271DFEC,48575443258CAAA7,C0F6C271DFEFBFARYM7933175,30C50FB7D89C,48575443CED688A6,30C50FB7D89FBFARYM9918674,00E40608E046,485754433A662AA7,00E40608E049BFARYM9912706,00E406078ECC,485754433A5250A7,00E406078ECFBFARYM7932026,30C50FB6D182,48575443CEC70EA6,30C50FB6D185BFARYM9912022,00E40607765C,485754433A50E0A7,00E40607765FBFARYN7913992,6CE87456C067,48575443AA763AAA,6CE87456C06ABFARYM4932929,D44649B60692,48575443DD0B38A5,D44649B60695BFARYN2943929,A4178B5D9767,48575443F04162A8,A4178B5D976ABFARYN2913622,88892F8933A0,48575443E546A6A8,88892F8933A3BFARYMC929706,04E7959B4AB7,4857544387C83BA8,04E7959B4ABABFARYN2907158,88892F89C90A,48575443E54F70A8,88892F89C90DBFARYMB906516,F82E3F6E47D0,48575443455102A8,F82E3F6E47D3BFARYM6911707,CCD73C76DAFD,485754436377C2A6,CCD73C76DB00BFARYN7912289,6CE874564F50,48575443AA6F93AA,6CE874564F53BFARYM3910591,80E1BF0BF01F,48575443B5C87DA5,80E1BF0BF022BFARYM7927852,30C50FB821FD,48575443CEDAD9A6,30C50FB82200BFARYM8912129,1C3D2F47E312,48575443D53F94A6,1C3D2F47E315BFARYMB906128,F82E3F768A98,48575443468C04A8,F82E3F768A9BBFARYN1918339,C4FBAAFBD0BC,48575443D3DAFFA8,C4FBAAFBD0BFBFARYMA943136,C40D96A1F82E,48575443E1A70AA7,C40D96A1F831BFARYN7911526,6CE874561DA4,48575443AA6CA7AA,6CE874561DA7BFARYMC928097,04E79599A294,4857544387AE29A8,04E79599A297BFARYM4917303,482CD08F47C0,48575443CB7D5CA5,482CD08F47C3BFARYM7928363,30C50FB6C6D1,48575443CEC66DA6,30C50FB6C6D4BFARYN2942323,A4178B5FF8E3,48575443F0574AA8,A4178B5FF8E6BFARYM7925926,30C50FB60242,48575443CEBAE2A6,30C50FB60245BFARYM9910576,C0F6C271F40B,48575443258E00A7,C0F6C271F40E', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-15 10:16:26 Duration: 5s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m26s 106 7s887ms 47s640ms 10s435ms create table temp0000282493 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 15 07 26 4m52s 11s248ms 08 10 1m41s 10s109ms 09 14 2m36s 11s198ms 10 5 52s61ms 10s412ms 11 10 1m50s 11s6ms 12 8 1m10s 8s768ms 14 12 1m55s 9s647ms 15 17 2m49s 9s961ms 16 4 38s406ms 9s601ms [ User: intelifix - Total duration: 18m26s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 18m26s - Times executed: 106 ]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 07:05:18 Duration: 47s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:13:33 Duration: 13s951ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:12:57 Duration: 13s577ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 13m33s 138 2s189ms 3m56s 5s898ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 15 00 6 30s88ms 5s14ms 01 6 15s139ms 2s523ms 02 6 15s646ms 2s607ms 03 6 17s851ms 2s975ms 04 6 16s111ms 2s685ms 05 6 15s917ms 2s652ms 06 6 15s568ms 2s594ms 07 6 20s40ms 3s340ms 08 6 19s788ms 3s298ms 09 6 4m14s 42s401ms 10 6 20s464ms 3s410ms 11 6 20s185ms 3s364ms 12 6 22s363ms 3s727ms 13 6 18s598ms 3s99ms 14 6 21s727ms 3s621ms 15 6 2m34s 25s696ms 16 6 21s631ms 3s605ms 17 6 19s203ms 3s200ms 18 6 18s134ms 3s22ms 19 6 17s900ms 2s983ms 20 6 23s859ms 3s976ms 21 6 17s865ms 2s977ms 22 6 17s258ms 2s876ms [ User: intelifix - Total duration: 13m33s - Times executed: 138 ]
[ Application: psql - Total duration: 13m33s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 09:19:10 Duration: 3m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 15:37:17 Duration: 2m12s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 00:05:19 Duration: 17s602ms Database: rio User: intelifix Remote: [local] Application: psql
6 12m32s 31 432ms 1m40s 24s274ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 15 07 2 1m41s 50s971ms 08 2 33s224ms 16s612ms 09 2 53s367ms 26s683ms 10 2 1m7s 33s906ms 11 2 37s442ms 18s721ms 12 2 1m14s 37s211ms 13 2 30s341ms 15s170ms 14 2 33s882ms 16s941ms 15 2 49s741ms 24s870ms 16 2 35s108ms 17s554ms 17 2 33s247ms 16s623ms 18 2 30s495ms 15s247ms 19 2 32s289ms 16s144ms 20 1 1m19s 1m19s 21 2 30s189ms 15s94ms 22 2 29s784ms 14s892ms [ User: intelifix - Total duration: 12m32s - Times executed: 31 ]
[ Application: psql - Total duration: 12m32s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-15 07:18:51 Duration: 1m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-15 20:15:24 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-15 12:14:30 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
7 10m53s 37 13s246ms 51s801ms 17s659ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 15 08 1 51s801ms 51s801ms 09 5 1m25s 17s131ms 10 4 58s314ms 14s578ms 11 6 1m34s 15s666ms 13 2 34s610ms 17s305ms 14 7 1m57s 16s808ms 15 5 1m21s 16s261ms 16 4 1m11s 17s944ms 17 3 58s252ms 19s417ms [ User: intelifix - Total duration: 10m53s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 10m53s - Times executed: 37 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-15', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-15 08:45:36 Duration: 51s801ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-15', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-15 14:18:12 Duration: 22s971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-15', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-15 17:03:07 Duration: 20s146ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m45s 3 689ms 8m25s 3m35s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 15 05 3 10m45s 3m35s [ User: intelifix - Total duration: 10m45s - Times executed: 3 ]
[ Application: psql - Total duration: 10m45s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-15 05:08:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-15 05:10:47 Duration: 2m19s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-15 05:08:28 Duration: 689ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 10m28s 1,046 150ms 11s586ms 600ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 15 07 1 1s216ms 1s216ms 08 128 1m55s 904ms 09 123 1m12s 586ms 10 157 1m35s 609ms 11 148 1m27s 590ms 13 108 56s298ms 521ms 14 134 1m12s 537ms 15 140 1m11s 507ms 16 105 55s553ms 529ms 17 2 869ms 434ms [ User: intelifix - Total duration: 10m28s - Times executed: 1046 ]
[ Application: [unknown] - Total duration: 10m28s - Times executed: 1046 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "320", "itens" : "241656343350,241725887678,241715603746,241665736881,241647296271,241727444262,241635003759,241665666874,241620248503,241637697388,241677661323,241712056385,241669569500,241692991214,241595280208,241661565363,241698491717,241651296280,241607177799,241712108185,241674572222,241689941130,241647236669,241674486074,241699193839,241693724753,241604610524,241619773754,241607958088,241651287390,241665670209,241607158808,241655320411,241600996769,241677712944,241677389196,241655634459,241637479915,241713012225,241661331727,241622657278,241704165166,241680310426,241599501428,230055013842,241713987078,241670324254", "usuario" : "405", "caixa" : "2879093", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 08:03:43 Duration: 11s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "253755", "modelo" : "454", "itens" : "241625400409,241625381619,241614281636,241613846284,230056850509,241612006082,241632975760,241613378708,241626546266,241613299710,241627175374,241641039701,241613303448,241633168204,241624686971,241624444647,241611919609,241632646783,241611830308,241624321729,241614425263,241632744548,241625553252,241642245969,241613404142,241614429102,241625252639,241643686379,241600558892,241644849108,241632638196,241632433452,241624630828,241613913844,241612424765,241642218693,241632711717,241626501919,241600654761,241600653953,241625356060,241600348591,241642474757,241633658890,241612445474,241625082746,241626609707,241627141634", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 10:42:32 Duration: 3s837ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "253181", "modelo" : "320", "itens" : "241672205369,241707283742,241678246890,835036906001681,241730914264,834232934000413,835204930000847,835066910000381,834200929003018,241604328598,241698738283,835197929005337,834117917003052,834186927002013,835112917004450,834257937001715,241617544142,241708777490,835016903001813,834075911003110,241614480320,230048492039,241664775160,241695541418,241704290611,241614527697,241704373447,241594652436,835035906000437,241691547795,241594983153,241680482642,241622592929,241622647479,241708932736,836051908001102,241727009416,834075911003386,834186927001615,835090914001481,834233934000907,834148922001231,241630173254,834319946002101,835073911000556,835016903000150,835036906002276,835212931003565", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 08:00:55 Duration: 3s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m47s 72 221ms 14s572ms 6s488ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 15 00 1 470ms 470ms 06 1 2s4ms 2s4ms 07 6 58s701ms 9s783ms 08 6 1m8s 11s450ms 09 6 55s581ms 9s263ms 10 6 47s853ms 7s975ms 11 6 55s808ms 9s301ms 12 6 44s877ms 7s479ms 13 5 9s241ms 1s848ms 14 6 39s341ms 6s556ms 15 6 38s810ms 6s468ms 16 5 29s338ms 5s867ms 20 1 280ms 280ms 21 5 8s120ms 1s624ms 22 6 8s29ms 1s338ms [ User: intelifix - Total duration: 7m47s - Times executed: 72 ]
[ Application: psql - Total duration: 7m47s - Times executed: 72 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 07:45:16 Duration: 14s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 08:15:15 Duration: 13s629ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 08:55:14 Duration: 13s414ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m35s 45 7s993ms 13s140ms 10s128ms create table temp0000282591 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 15 13 5 47s880ms 9s576ms 14 5 49s580ms 9s916ms 15 15 2m34s 10s272ms 16 3 33s169ms 11s56ms 17 17 2m51s 10s62ms [ User: intelifix - Total duration: 7m35s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 7m35s - Times executed: 45 ]
-
CREATE TABLE temp0000282591 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 17:20:21 Duration: 13s140ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282591 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 15:02:54 Duration: 12s524ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282591 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 16:26:35 Duration: 12s176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m42s 68 190ms 54s910ms 3s276ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 15 07 10 8s126ms 812ms 08 8 17s483ms 2s185ms 09 7 8s328ms 1s189ms 10 3 11s778ms 3s926ms 11 6 21s560ms 3s593ms 12 4 11s195ms 2s798ms 13 4 55s571ms 13s892ms 14 5 38s288ms 7s657ms 15 10 25s559ms 2s555ms 16 4 3s901ms 975ms 17 7 21s12ms 3s1ms [ User: intelifix - Total duration: 3m42s - Times executed: 68 ]
[ Application: psql - Total duration: 3m42s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025614);
Date: 2026-06-15 13:57:44 Duration: 54s910ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025617);
Date: 2026-06-15 14:45:26 Duration: 35s969ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025605);
Date: 2026-06-15 11:50:17 Duration: 15s126ms Database: rio User: intelifix Remote: [local] Application: psql
13 2m47s 47 442ms 35s579ms 3s568ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 15 07 4 41s611ms 10s402ms 08 7 11s254ms 1s607ms 09 6 17s896ms 2s982ms 10 3 16s871ms 5s623ms 11 4 12s93ms 3s23ms 12 3 5s751ms 1s917ms 13 3 8s131ms 2s710ms 14 2 22s206ms 11s103ms 15 6 15s404ms 2s567ms 16 2 2s887ms 1s443ms 17 7 13s622ms 1s946ms [ User: intelifix - Total duration: 2m47s - Times executed: 47 ]
[ Application: psql - Total duration: 2m47s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025573);
Date: 2026-06-15 07:07:31 Duration: 35s579ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025616);
Date: 2026-06-15 14:32:24 Duration: 16s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025596);
Date: 2026-06-15 09:48:38 Duration: 9s311ms Database: rio User: intelifix Remote: [local] Application: psql
14 2m47s 2 1m21s 1m25s 1m23s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 15 20 1 1m21s 1m21s 23 1 1m25s 1m25s [ User: intelifix - Total duration: 2m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m47s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-15 23:39:07 Duration: 1m25s 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-15 20:08:34 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
15 2m44s 15 8s566ms 15s37ms 10s988ms create table temp0000282551 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 15 09 6 1m12s 12s26ms 10 3 28s947ms 9s649ms 11 3 35s720ms 11s906ms 12 3 27s993ms 9s331ms [ User: intelifix - Total duration: 2m44s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 15 ]
-
CREATE TABLE temp0000282551 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:10:54 Duration: 15s37ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282551 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 11:22:29 Duration: 13s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282551 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:06:54 Duration: 12s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m34s 152 150ms 20s684ms 1s13ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 15 08 21 12s476ms 594ms 09 5 2s106ms 421ms 10 6 2s533ms 422ms 11 13 5s870ms 451ms 13 27 1m16s 2s846ms 14 12 4s940ms 411ms 15 13 18s331ms 1s410ms 16 35 20s500ms 585ms 17 20 10s492ms 524ms [ User: intelifix - Total duration: 2m34s - Times executed: 152 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 152 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-15 13:15:13 Duration: 20s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-15 13:16:55 Duration: 13s293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-15 13:13:33 Duration: 7s981ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 2m12s 2 22s100ms 1m50s 1m6s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 15 23 2 2m12s 1m6s [ User: intelifix - Total duration: 2m12s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m12s - 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-15 23:14:42 Duration: 1m50s 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-15 23:40:37 Duration: 22s100ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1m57s 12 8s511ms 11s358ms 9s779ms create table temp0000282515 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 15 08 12 1m57s 9s779ms [ User: intelifix - Total duration: 1m57s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 1m57s - Times executed: 12 ]
-
CREATE TABLE temp0000282515 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 08:15:09 Duration: 11s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282515 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 08:17:47 Duration: 11s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282515 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 08:19:01 Duration: 10s893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m56s 2 20s126ms 1m36s 58s128ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 15 23 2 1m56s 58s128ms [ User: intelifix - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-15 23:11:39 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-15 23:39:57 Duration: 20s126ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1m53s 38 1s282ms 23s540ms 2s987ms create table temp0000282507 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 15 07 7 35s892ms 5s127ms 08 23 48s400ms 2s104ms 10 2 10s8ms 5s4ms 13 1 4s426ms 4s426ms 14 4 10s936ms 2s734ms 16 1 3s876ms 3s876ms [ User: intelifix - Total duration: 1m53s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 38 ]
-
CREATE TABLE temp0000282507 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "10-06-2026", "data-ate" : "15-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-15 07:58:36 Duration: 23s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282507 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "10-06-2026", "data-ate" : "15-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-15 10:11:03 Duration: 7s950ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282507 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "10-06-2026", "data-ate" : "15-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-15 13:11:27 Duration: 4s426ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,622 27m36s 150ms 6s535ms 1s21ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 15 07 9 6s220ms 691ms 08 206 3m32s 1s32ms 09 164 3m18s 1s211ms 10 240 4m9s 1s39ms 11 169 2m28s 877ms 12 44 48s732ms 1s107ms 13 104 1m35s 919ms 14 204 3m32s 1s43ms 15 196 3m29s 1s70ms 16 194 3m7s 964ms 17 92 1m26s 945ms [ User: intelifix - Total duration: 27m36s - Times executed: 1622 ]
[ Application: [unknown] - Total duration: 27m36s - Times executed: 1622 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251286, 450, 'CP2228320FH,A0B53C65ECB0,544D4242005A2E58,A0B53C65ECB3$CP2310322MD,D4925E33D240,544D42420065BB1A,D4925E33D243$CP2303326KE,D4925E14917A,544D42420062CF3B,D4925E14917D$CP240932MFR,08C7F52E74D2,544D424200785AAF,08C7F52E74D5$CP2404327M1,08C7F526115E,544D4242007736FF,08C7F5261161$CP230232HJH,D4925E08C11D,544D42420061E0BA,D4925E08C120$CP23303254K,D4925EE29A5C,544D4242006E5F6D,D4925EE29A5F$CP233032FWU,D4925EE43796,544D4242006E8D57,D4925EE43799$CP230532656,D4925E197603,544D424200639186,D4925E197606$CP240932UDZ,08C7F52F7EBE,544D42420078783B,08C7F52F7EC1$CP22283218W,A0B53C660B4F,544D4242005A31BF,A0B53C660B52$CP233032FJV,D4925EE429B3,544D4242006E8BCC,D4925EE429B6$CP233032G8D,D4925EE443E4,544D4242006E8EB5,D4925EE443E7$CP232232D7D,D4925EBD68E4,544D4242006BC3FF,D4925EBD68E7$CP2404326QT,08C7F525EF7A,544D42420077333B,08C7F525EF7D$CP2404323Q8,08C7F5257BF4,544D424200772665,08C7F5257BF7$CP2305327PY,D4925E19B206,544D424200639831,D4925E19B209$CP22393239G,A0B53CC0955B,544D4242005E7B00,A0B53CC0955E$CP232032FUC,D4925EA5E280,544D42420069F3A6,D4925EA5E283$CP2411322W5,08C7F52FEFF2,544D4242007884CF,08C7F52FEFF5$CP234232N01,D4925EF8C220,544D424200723EDD,D4925EF8C223$CP234232QEY,D4925EF91FF5,544D42420072494A,D4925EF91FF8$CP2409324TK,08C7F52BF7AF,544D4242007813E4,08C7F52BF7B2$CP234532G3T,08C7F5043BC6,544D42420073768B,08C7F5043BC9$CP232032TV3,D4925EA7AEA0,544D4242006A26C6,D4925EA7AEA3$CP2319322H2,D4925E9FE518,544D424200699362,D4925E9FE51B$CP2319327NU,D4925EA0AB33,544D42420069A965,D4925EA0AB36$CP2250324VJ,A0B53CF9E0F6,544D42420060BCCC,A0B53CF9E0F9$CP240932NVQ,08C7F52EAB50,544D4242007860BD,08C7F52EAB53$CP230232Q0M,D4925E09B85E,544D42420061FC33,D4925E09B861$CP2409324ET,08C7F52BE8E2,544D42420078123F,08C7F52BE8E5$CP234532L44,08C7F504D544,544D424200738799,08C7F504D547$CP2409324B8,08C7F52BE4BC,544D4242007811C9,08C7F52BE4BF$CP240932JNM,08C7F52E09F2,544D424200784ECF,08C7F52E09F5$CP2301329G1,D4925E02CE2E,544D42420061383D,D4925E02CE31$CP2302322PG,D4925E06889A,544D42420061A18F,D4925E06889D$CP2301329FL,D4925E02CDB0,544D42420061382F,D4925E02CDB3$CP240932GD2,08C7F52DB244,544D424200784511,08C7F52DB247$CP2217320S3,A0B53C3FE94D,544D424200583387,A0B53C3FE950$CP2404325TD,08C7F525CC2E,544D424200772F4F,08C7F525CC31', '',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-15 11:35:54 Duration: 6s535ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (253438, 304, 'F200012003B0FBF,84011295822D$F20001019114BA6,743AEF74E74B$F200010321B62EB,743AEFDA0F59$F200011280B807D,8401125F6FFC$F200011328B54C0,8401128377CB$F200011208B4511,840112070451$F200010290BB563,743AEFAF07A7$F2000101831547F,743AEF745206$F200011216B3FDA,84011227CBE8$F200011152B9160,9877E7BCFE9F$F200011242B10C5,8401122A9134$F20001018411F42,743AEF746B51$F200011302B0979,8401128008D4$F200011193B3956,8401120407F3$F200011070B3110,9877E7492E89$F200011050E1695,9877E70C62E9$F200010284B7E3C,743AEFAD8A19$F20001019212377,743AEF75083E$F200010276B528D,743AEF9D2D56$F20001015614CEC,743AEF5BADB2$F200010293B8CC3,743AEFAF4891$F2000101901246A,743AEF74AD30$F200011131B1135,9877E7B99884$F200011106BE645,9877E77D002F$F200012015B9C0F,840112984924$F200010254E2434,743AEF9A2D39$F200010330E5138,743AEFDC6246$F200011008BB078,9877E707B2AF$F200010301E4674,743AEFC53685$F200010339B6493,9877E7015CD2', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-15 09:22:52 Duration: 6s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251280, 450, '2102313BFARYMC925679,04E7959B2BC5,4857544387C64EA8,04E7959B2BC8BFARYMA941566,C40D969D2DA4,48575443E1225DA7,C40D969D2DA7BFARYM3904684,80E1BF0A980D,48575443B5A8A5A5,80E1BF0A9810BFARYM9910701,C0F6C271DFEC,48575443258CAAA7,C0F6C271DFEFBFARYM7933175,30C50FB7D89C,48575443CED688A6,30C50FB7D89FBFARYM9918674,00E40608E046,485754433A662AA7,00E40608E049BFARYM9912706,00E406078ECC,485754433A5250A7,00E406078ECFBFARYM7932026,30C50FB6D182,48575443CEC70EA6,30C50FB6D185BFARYM9912022,00E40607765C,485754433A50E0A7,00E40607765FBFARYN7913992,6CE87456C067,48575443AA763AAA,6CE87456C06ABFARYM4932929,D44649B60692,48575443DD0B38A5,D44649B60695BFARYN2943929,A4178B5D9767,48575443F04162A8,A4178B5D976ABFARYN2913622,88892F8933A0,48575443E546A6A8,88892F8933A3BFARYMC929706,04E7959B4AB7,4857544387C83BA8,04E7959B4ABABFARYN2907158,88892F89C90A,48575443E54F70A8,88892F89C90DBFARYMB906516,F82E3F6E47D0,48575443455102A8,F82E3F6E47D3BFARYM6911707,CCD73C76DAFD,485754436377C2A6,CCD73C76DB00BFARYN7912289,6CE874564F50,48575443AA6F93AA,6CE874564F53BFARYM3910591,80E1BF0BF01F,48575443B5C87DA5,80E1BF0BF022BFARYM7927852,30C50FB821FD,48575443CEDAD9A6,30C50FB82200BFARYM8912129,1C3D2F47E312,48575443D53F94A6,1C3D2F47E315BFARYMB906128,F82E3F768A98,48575443468C04A8,F82E3F768A9BBFARYN1918339,C4FBAAFBD0BC,48575443D3DAFFA8,C4FBAAFBD0BFBFARYMA943136,C40D96A1F82E,48575443E1A70AA7,C40D96A1F831BFARYN7911526,6CE874561DA4,48575443AA6CA7AA,6CE874561DA7BFARYMC928097,04E79599A294,4857544387AE29A8,04E79599A297BFARYM4917303,482CD08F47C0,48575443CB7D5CA5,482CD08F47C3BFARYM7928363,30C50FB6C6D1,48575443CEC66DA6,30C50FB6C6D4BFARYN2942323,A4178B5FF8E3,48575443F0574AA8,A4178B5FF8E6BFARYM7925926,30C50FB60242,48575443CEBAE2A6,30C50FB60245BFARYM9910576,C0F6C271F40B,48575443258E00A7,C0F6C271F40E', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-15 10:16:26 Duration: 5s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,046 10m28s 150ms 11s586ms 600ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 15 07 1 1s216ms 1s216ms 08 128 1m55s 904ms 09 123 1m12s 586ms 10 157 1m35s 609ms 11 148 1m27s 590ms 13 108 56s298ms 521ms 14 134 1m12s 537ms 15 140 1m11s 507ms 16 105 55s553ms 529ms 17 2 869ms 434ms [ User: intelifix - Total duration: 10m28s - Times executed: 1046 ]
[ Application: [unknown] - Total duration: 10m28s - Times executed: 1046 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "320", "itens" : "241656343350,241725887678,241715603746,241665736881,241647296271,241727444262,241635003759,241665666874,241620248503,241637697388,241677661323,241712056385,241669569500,241692991214,241595280208,241661565363,241698491717,241651296280,241607177799,241712108185,241674572222,241689941130,241647236669,241674486074,241699193839,241693724753,241604610524,241619773754,241607958088,241651287390,241665670209,241607158808,241655320411,241600996769,241677712944,241677389196,241655634459,241637479915,241713012225,241661331727,241622657278,241704165166,241680310426,241599501428,230055013842,241713987078,241670324254", "usuario" : "405", "caixa" : "2879093", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 08:03:43 Duration: 11s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "253755", "modelo" : "454", "itens" : "241625400409,241625381619,241614281636,241613846284,230056850509,241612006082,241632975760,241613378708,241626546266,241613299710,241627175374,241641039701,241613303448,241633168204,241624686971,241624444647,241611919609,241632646783,241611830308,241624321729,241614425263,241632744548,241625553252,241642245969,241613404142,241614429102,241625252639,241643686379,241600558892,241644849108,241632638196,241632433452,241624630828,241613913844,241612424765,241642218693,241632711717,241626501919,241600654761,241600653953,241625356060,241600348591,241642474757,241633658890,241612445474,241625082746,241626609707,241627141634", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 10:42:32 Duration: 3s837ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "253181", "modelo" : "320", "itens" : "241672205369,241707283742,241678246890,835036906001681,241730914264,834232934000413,835204930000847,835066910000381,834200929003018,241604328598,241698738283,835197929005337,834117917003052,834186927002013,835112917004450,834257937001715,241617544142,241708777490,835016903001813,834075911003110,241614480320,230048492039,241664775160,241695541418,241704290611,241614527697,241704373447,241594652436,835035906000437,241691547795,241594983153,241680482642,241622592929,241622647479,241708932736,836051908001102,241727009416,834075911003386,834186927001615,835090914001481,834233934000907,834148922001231,241630173254,834319946002101,835073911000556,835016903000150,835036906002276,835212931003565", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 08:00:55 Duration: 3s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 254 2h17m35s 155ms 10m11s 32s502ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 15 06 2 1m47s 53s740ms 07 10 18m19s 1m49s 08 31 8m5s 15s654ms 09 13 16m19s 1m15s 10 15 11m6s 44s446ms 11 19 15m17s 48s269ms 12 6 8m37s 1m26s 13 32 2m14s 4s209ms 14 19 22m7s 1m9s 15 34 20m44s 36s590ms 16 38 5m26s 8s595ms 17 35 7m30s 12s866ms [ User: intelifix - Total duration: 2h17m35s - Times executed: 254 ]
[ Application: [unknown] - Total duration: 2h17m35s - Times executed: 254 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025617, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-15 14:56:28 Duration: 10m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025573, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 07:13:52 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025616, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 14:38:13 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 193 51s210ms 151ms 875ms 265ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 15 07 23 7s175ms 311ms 08 26 7s118ms 273ms 09 19 6s35ms 317ms 10 23 6s335ms 275ms 11 23 5s634ms 244ms 12 21 4s227ms 201ms 14 19 5s526ms 290ms 15 30 6s948ms 231ms 16 9 2s210ms 245ms [ User: intelifix - Total duration: 51s210ms - Times executed: 193 ]
[ Application: [unknown] - Total duration: 51s210ms - Times executed: 193 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216397667988,216879296878,216871390002,216800871021,216546319309,216554342236,216359604667,216801107788,216633172331,216627714357,216406520627', NULL, NULL, 062, 00);
Date: 2026-06-15 07:06:14 Duration: 875ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216880701326,216538996181,216841744448,216889648999,216844091726,216673580708,216797138994,216882149009,216416841634,216648659409,216767422526,216890848499,216646477781,216660895878,216605577785,216827776373,216890742227', NULL, NULL, 064, 00);
Date: 2026-06-15 11:12:06 Duration: 750ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230008024161,230023820720,230032975260,230032398908,230029312636,230010893038,229978474958,230044014149,229963200101,230027598204,229989826481', NULL, NULL, 0295, 00);
Date: 2026-06-15 09:50:13 Duration: 586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 166 26s832ms 150ms 208ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 15 07 4 637ms 159ms 08 24 3s935ms 163ms 09 19 3s36ms 159ms 10 26 4s124ms 158ms 11 18 2s864ms 159ms 12 3 480ms 160ms 13 15 2s359ms 157ms 14 24 3s948ms 164ms 15 20 3s369ms 168ms 16 12 1s924ms 160ms 17 1 151ms 151ms [ User: intelifix - Total duration: 26s832ms - Times executed: 166 ]
[ Application: [unknown] - Total duration: 26s832ms - Times executed: 166 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-06-15 15:05:29 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 050;
Date: 2026-06-15 08:46:26 Duration: 205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-06-15 15:07:10 Duration: 199ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 154 31s171ms 150ms 1s72ms 202ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 15 07 4 691ms 172ms 10 2 307ms 153ms 11 8 1s297ms 162ms 12 5 898ms 179ms 13 8 1s454ms 181ms 14 14 2s873ms 205ms 15 33 7s882ms 238ms 16 53 10s270ms 193ms 17 27 5s494ms 203ms [ User: intelifix - Total duration: 31s171ms - Times executed: 154 ]
[ Application: [unknown] - Total duration: 31s171ms - Times executed: 154 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "305", "data-de" : "2026-06-15", "data-ate" : "2026-06-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 317 }');
Date: 2026-06-15 15:36:49 Duration: 1s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-06-15", "data-ate" : "2026-06-15", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-06-15 15:04:33 Duration: 665ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-06-15", "data-ate" : "2026-06-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-06-15 14:27:19 Duration: 611ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 152 2m34s 150ms 20s684ms 1s13ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 15 08 21 12s476ms 594ms 09 5 2s106ms 421ms 10 6 2s533ms 422ms 11 13 5s870ms 451ms 13 27 1m16s 2s846ms 14 12 4s940ms 411ms 15 13 18s331ms 1s410ms 16 35 20s500ms 585ms 17 20 10s492ms 524ms [ User: intelifix - Total duration: 2m34s - Times executed: 152 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 152 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-15 13:15:13 Duration: 20s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-15 13:16:55 Duration: 13s293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-15 13:13:33 Duration: 7s981ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 138 13m33s 2s189ms 3m56s 5s898ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 15 00 6 30s88ms 5s14ms 01 6 15s139ms 2s523ms 02 6 15s646ms 2s607ms 03 6 17s851ms 2s975ms 04 6 16s111ms 2s685ms 05 6 15s917ms 2s652ms 06 6 15s568ms 2s594ms 07 6 20s40ms 3s340ms 08 6 19s788ms 3s298ms 09 6 4m14s 42s401ms 10 6 20s464ms 3s410ms 11 6 20s185ms 3s364ms 12 6 22s363ms 3s727ms 13 6 18s598ms 3s99ms 14 6 21s727ms 3s621ms 15 6 2m34s 25s696ms 16 6 21s631ms 3s605ms 17 6 19s203ms 3s200ms 18 6 18s134ms 3s22ms 19 6 17s900ms 2s983ms 20 6 23s859ms 3s976ms 21 6 17s865ms 2s977ms 22 6 17s258ms 2s876ms [ User: intelifix - Total duration: 13m33s - Times executed: 138 ]
[ Application: psql - Total duration: 13m33s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 09:19:10 Duration: 3m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 15:37:17 Duration: 2m12s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 00:05:19 Duration: 17s602ms Database: rio User: intelifix Remote: [local] Application: psql
9 106 18m26s 7s887ms 47s640ms 10s435ms create table temp0000282493 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 15 07 26 4m52s 11s248ms 08 10 1m41s 10s109ms 09 14 2m36s 11s198ms 10 5 52s61ms 10s412ms 11 10 1m50s 11s6ms 12 8 1m10s 8s768ms 14 12 1m55s 9s647ms 15 17 2m49s 9s961ms 16 4 38s406ms 9s601ms [ User: intelifix - Total duration: 18m26s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 18m26s - Times executed: 106 ]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 07:05:18 Duration: 47s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:13:33 Duration: 13s951ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:12:57 Duration: 13s577ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 98 25s919ms 151ms 714ms 264ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 15 11 14 4s989ms 356ms 14 84 20s929ms 249ms [ User: intelifix - Total duration: 25s919ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 25s919ms - Times executed: 98 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"41964","seriais":"4883C79B93E1,","usuario":"406","observacao":""}');
Date: 2026-06-15 11:00:56 Duration: 714ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"40355","seriais":"9877E7492B10,","usuario":"406","observacao":""}');
Date: 2026-06-15 11:16:31 Duration: 534ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"42044","seriais":"D8CF6162927C,20354353FB17,647B1EEC29CF,2035435A0E44","usuario":"406","observacao":""}');
Date: 2026-06-15 14:26:33 Duration: 501ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 90 21s697ms 151ms 3s257ms 241ms create table temp0000282533 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 15 08 5 3s945ms 789ms 09 9 1s594ms 177ms 10 8 1s519ms 189ms 11 9 1s840ms 204ms 12 1 177ms 177ms 13 7 1s412ms 201ms 14 8 1s642ms 205ms 15 11 2s258ms 205ms 16 31 7s71ms 228ms 17 1 234ms 234ms [ User: intelifix - Total duration: 21s697ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 21s697ms - Times executed: 90 ]
-
CREATE TABLE temp0000282533 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-06-2026", "ate" :"15-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-15 08:19:12 Duration: 3s257ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282533 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-06-2026", "ate" :"15-06-2026", "nota-fiscal":"102", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-15 16:25:28 Duration: 304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282533 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-06-2026", "ate" :"15-06-2026", "nota-fiscal":"102", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-15 16:06:31 Duration: 288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 88 15s840ms 150ms 771ms 180ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 15 06 7 1s980ms 282ms 07 2 402ms 201ms 08 17 2s937ms 172ms 09 14 2s358ms 168ms 10 7 1s132ms 161ms 11 6 996ms 166ms 12 1 155ms 155ms 13 2 356ms 178ms 14 9 1s476ms 164ms 15 9 1s552ms 172ms 16 7 1s262ms 180ms 17 5 854ms 170ms 21 2 376ms 188ms [ User: intelifix - Total duration: 15s840ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 15s840ms - Times executed: 88 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('943C96AD5C53');
Date: 2026-06-15 06:44:28 Duration: 771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('A8705D806FF5');
Date: 2026-06-15 16:23:36 Duration: 262ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('D4925E9FE39E');
Date: 2026-06-15 06:53:52 Duration: 251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 80 35s958ms 271ms 719ms 449ms 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 15 06 1 372ms 372ms 07 7 2s957ms 422ms 08 9 4s320ms 480ms 09 8 3s882ms 485ms 10 8 3s500ms 437ms 11 6 2s908ms 484ms 12 4 1s652ms 413ms 13 8 3s499ms 437ms 14 7 2s925ms 417ms 15 8 3s903ms 487ms 16 6 2s652ms 442ms 17 5 2s1ms 400ms 21 2 905ms 452ms 22 1 475ms 475ms [ User: lenon - Total duration: 35s958ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 35s958ms - Times executed: 80 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-15 09:12:56 Duration: 719ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-15 08:41:36 Duration: 716ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-15 11:05:11 Duration: 689ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
14 76 15s69ms 152ms 532ms 198ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 15 07 7 1s545ms 220ms 08 14 3s42ms 217ms 09 18 3s147ms 174ms 10 17 3s161ms 185ms 11 14 2s549ms 182ms 13 2 465ms 232ms 15 1 238ms 238ms 16 1 298ms 298ms 17 2 621ms 310ms [ User: intelifix - Total duration: 15s69ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 15s69ms - Times executed: 76 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"155", "usuario" :"184", "tipo" :"N", "itens" :"01", "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-15 08:14:08 Duration: 532ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"298", "usuario" :"417", "tipo" :"N", "itens" :"002", "nota-fiscal" :"10272", "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-15 07:11:42 Duration: 532ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"336", "usuario" :"407", "tipo" :"N", "itens" :"001", "nota-fiscal" :"266", "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-15 17:04:18 Duration: 373ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 72 7m47s 221ms 14s572ms 6s488ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 15 00 1 470ms 470ms 06 1 2s4ms 2s4ms 07 6 58s701ms 9s783ms 08 6 1m8s 11s450ms 09 6 55s581ms 9s263ms 10 6 47s853ms 7s975ms 11 6 55s808ms 9s301ms 12 6 44s877ms 7s479ms 13 5 9s241ms 1s848ms 14 6 39s341ms 6s556ms 15 6 38s810ms 6s468ms 16 5 29s338ms 5s867ms 20 1 280ms 280ms 21 5 8s120ms 1s624ms 22 6 8s29ms 1s338ms [ User: intelifix - Total duration: 7m47s - Times executed: 72 ]
[ Application: psql - Total duration: 7m47s - Times executed: 72 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 07:45:16 Duration: 14s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 08:15:15 Duration: 13s629ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 08:55:14 Duration: 13s414ms Database: rio User: intelifix Remote: [local] Application: psql
16 72 39s814ms 359ms 820ms 552ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 15 07 4 1s924ms 481ms 08 9 5s168ms 574ms 09 7 4s69ms 581ms 10 8 4s216ms 527ms 11 6 3s597ms 599ms 12 4 1s971ms 492ms 13 7 3s777ms 539ms 14 7 3s727ms 532ms 15 8 4s697ms 587ms 16 6 3s386ms 564ms 17 4 2s75ms 518ms 21 1 594ms 594ms 22 1 606ms 606ms [ User: intelifix - Total duration: 39s814ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 39s814ms - Times executed: 72 ]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-06-15 09:12:56 Duration: 820ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 5, 1);
Date: 2026-06-15 08:41:36 Duration: 800ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-06-15 11:05:11 Duration: 768ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 72 27s310ms 230ms 689ms 379ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 15 06 2 708ms 354ms 07 5 1s730ms 346ms 08 10 3s369ms 336ms 09 5 2s13ms 402ms 10 7 3s65ms 437ms 11 5 1s985ms 397ms 12 4 1s393ms 348ms 13 2 742ms 371ms 14 10 3s902ms 390ms 15 9 3s953ms 439ms 16 5 2s35ms 407ms 17 8 2s409ms 301ms [ User: intelifix - Total duration: 27s310ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 27s310ms - Times executed: 72 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-15 09:02:43 Duration: 689ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-15 15:05:25 Duration: 622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-15 14:42:15 Duration: 597ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 70 29s629ms 151ms 1s389ms 423ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 15 07 3 1s408ms 469ms 08 11 3s99ms 281ms 09 16 8s389ms 524ms 10 9 4s411ms 490ms 11 10 5s256ms 525ms 13 8 2s572ms 321ms 16 4 1s766ms 441ms 17 9 2s725ms 302ms [ User: intelifix - Total duration: 29s629ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 29s629ms - Times executed: 70 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241691572748,241691448088,241715518686,241649098388,241595346375,241658639309,241689939210,230048002339,241629141829,241706943653,241630488895,241607942128,241671973349,241621816478,241632348493,241599274458,241649410519,241677676879,230040207694,241689196174,241638414765,241677362225,241666331923,241630020512,241664840622,241665254859,241599551635,241607827997,241700909203,241712651629,241710865977,241622829393,241716428911,241715642033,241706947996,241672304245,241614913549,241668309411,241594127075,241726254157,230048512142,241666367582,241658000527,241638396076,241593455259,241664611531,241599579819,241653211720,241689921835,241658847488,241659882124,241599583860,241630885152,241696954754', '','DEFAULT',051,0320,'', '','', 00);
Date: 2026-06-15 11:00:11 Duration: 1s389ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '230000981420,230052375571,229988663450,230030098807,230028600513,230035313143,230052019497,229982652740,230028113035,229990409400,230010377274,230053989006,230052183555,230047202530,230033802446,230030348506,229975279809,230051372432,230054035172,230033390509,229972134160,230053315472,230053717183,230014590515,229963752635,229972414041,230030001828,230030096483,229975301832,230043082431,230009952127,230010244456,229977407996,230042130509,229976056080,229962457491,229988696180,230051915874,229971406176,230026489700,230029384461,230034438399,229981167274,230014462646,230020156276,229980552232,230028816975,229980234950,230005527474,229976025269,229971183450,229989878709,229981600101,230029405574', '','DEFAULT',051,0295,'', '','', 00);
Date: 2026-06-15 09:52:30 Duration: 1s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (430, 5, 2, 28, '216872382433,216834920618,216632047888,216834940014,216697104956,216832050708,216397024862,184269377478,216612652629,216801179715,216633170008,216515532848,216505924547,216503673441,216817965270,216687748094,184268064354,184268489603,216908023139,216360985677,216512384549,216549063651,216816385677,216361396783,216633992950,216799333553,216814915567,216819500314,216756528196,184268860931,216552633337,216360502746,216411270114,216355535863,216547853241,216837343839,216508052331,216630606872,216559463555,184269775778,216802316380,216819697380,184267074448,216819699603,216501864454,216553782024,216634149912,216799683643,216550394858,216347747280,216519984045,216725569394,216630682133', '','DEFAULT',00,062,'', '','', 00);
Date: 2026-06-15 09:23:25 Duration: 1s255ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 68 3m42s 190ms 54s910ms 3s276ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 15 07 10 8s126ms 812ms 08 8 17s483ms 2s185ms 09 7 8s328ms 1s189ms 10 3 11s778ms 3s926ms 11 6 21s560ms 3s593ms 12 4 11s195ms 2s798ms 13 4 55s571ms 13s892ms 14 5 38s288ms 7s657ms 15 10 25s559ms 2s555ms 16 4 3s901ms 975ms 17 7 21s12ms 3s1ms [ User: intelifix - Total duration: 3m42s - Times executed: 68 ]
[ Application: psql - Total duration: 3m42s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025614);
Date: 2026-06-15 13:57:44 Duration: 54s910ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025617);
Date: 2026-06-15 14:45:26 Duration: 35s969ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025605);
Date: 2026-06-15 11:50:17 Duration: 15s126ms Database: rio User: intelifix Remote: [local] Application: psql
20 64 37s47ms 155ms 23s491ms 578ms create table temp0000282513 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 15 08 13 25s881ms 1s990ms 09 13 2s730ms 210ms 10 19 4s163ms 219ms 11 14 3s144ms 224ms 12 5 1s128ms 225ms [ User: intelifix - Total duration: 37s47ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 37s47ms - Times executed: 64 ]
-
CREATE TABLE temp0000282513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-06-2026", "ate" :"15-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-15 08:03:13 Duration: 23s491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-06-2026", "ate" :"15-06-2026", "nota-fiscal":"2115", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-15 10:17:36 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-06-2026", "ate" :"15-06-2026", "nota-fiscal":"2115", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-15 11:09:07 Duration: 286ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 995ms 12m10s 3m52s 32 2h3m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 15 07 2 12m12s 6m6s 08 2 6m37s 3m18s 09 2 10m37s 5m18s 10 2 9m46s 4m53s 11 2 7m9s 3m34s 12 2 8m17s 4m8s 13 2 5m41s 2m50s 14 2 6m37s 3m18s 15 2 11m34s 5m47s 16 2 7m13s 3m36s 17 2 6m28s 3m14s 18 2 5m45s 2m52s 19 2 5m39s 2m49s 20 2 9m6s 4m33s 21 2 5m19s 2m39s 22 2 5m36s 2m48s [ User: intelifix - Total duration: 2h3m44s - Times executed: 32 ]
[ Application: psql - Total duration: 2h3m44s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-15 07:17:11 Duration: 12m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-15 15:16:31 Duration: 11m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-15 09:15:34 Duration: 10m33s Database: rio User: intelifix Remote: [local] Application: psql
2 689ms 8m25s 3m35s 3 10m45s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 15 05 3 10m45s 3m35s [ User: intelifix - Total duration: 10m45s - Times executed: 3 ]
[ Application: psql - Total duration: 10m45s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-15 05:08:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-15 05:10:47 Duration: 2m19s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-15 05:08:28 Duration: 689ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 1m21s 1m25s 1m23s 2 2m47s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 15 20 1 1m21s 1m21s 23 1 1m25s 1m25s [ User: intelifix - Total duration: 2m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m47s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-15 23:39:07 Duration: 1m25s 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-15 20:08:34 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 22s100ms 1m50s 1m6s 2 2m12s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 15 23 2 2m12s 1m6s [ User: intelifix - Total duration: 2m12s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m12s - 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-15 23:14:42 Duration: 1m50s 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-15 23:40:37 Duration: 22s100ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 20s126ms 1m36s 58s128ms 2 1m56s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 15 23 2 1m56s 58s128ms [ User: intelifix - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-15 23:11:39 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-15 23:39:57 Duration: 20s126ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 155ms 10m11s 32s502ms 254 2h17m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 15 06 2 1m47s 53s740ms 07 10 18m19s 1m49s 08 31 8m5s 15s654ms 09 13 16m19s 1m15s 10 15 11m6s 44s446ms 11 19 15m17s 48s269ms 12 6 8m37s 1m26s 13 32 2m14s 4s209ms 14 19 22m7s 1m9s 15 34 20m44s 36s590ms 16 38 5m26s 8s595ms 17 35 7m30s 12s866ms [ User: intelifix - Total duration: 2h17m35s - Times executed: 254 ]
[ Application: [unknown] - Total duration: 2h17m35s - Times executed: 254 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025617, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-15 14:56:28 Duration: 10m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025573, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 07:13:52 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025616, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-15 14:38:13 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 432ms 1m40s 24s274ms 31 12m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 15 07 2 1m41s 50s971ms 08 2 33s224ms 16s612ms 09 2 53s367ms 26s683ms 10 2 1m7s 33s906ms 11 2 37s442ms 18s721ms 12 2 1m14s 37s211ms 13 2 30s341ms 15s170ms 14 2 33s882ms 16s941ms 15 2 49s741ms 24s870ms 16 2 35s108ms 17s554ms 17 2 33s247ms 16s623ms 18 2 30s495ms 15s247ms 19 2 32s289ms 16s144ms 20 1 1m19s 1m19s 21 2 30s189ms 15s94ms 22 2 29s784ms 14s892ms [ User: intelifix - Total duration: 12m32s - Times executed: 31 ]
[ Application: psql - Total duration: 12m32s - Times executed: 31 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-15 07:18:51 Duration: 1m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-15 20:15:24 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-15 12:14:30 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
8 13s246ms 51s801ms 17s659ms 37 10m53s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 15 08 1 51s801ms 51s801ms 09 5 1m25s 17s131ms 10 4 58s314ms 14s578ms 11 6 1m34s 15s666ms 13 2 34s610ms 17s305ms 14 7 1m57s 16s808ms 15 5 1m21s 16s261ms 16 4 1m11s 17s944ms 17 3 58s252ms 19s417ms [ User: intelifix - Total duration: 10m53s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 10m53s - Times executed: 37 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-15', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-15 08:45:36 Duration: 51s801ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-15', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-15 14:18:12 Duration: 22s971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-15', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-15 17:03:07 Duration: 20s146ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8s566ms 15s37ms 10s988ms 15 2m44s create table temp0000282551 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 15 09 6 1m12s 12s26ms 10 3 28s947ms 9s649ms 11 3 35s720ms 11s906ms 12 3 27s993ms 9s331ms [ User: intelifix - Total duration: 2m44s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 15 ]
-
CREATE TABLE temp0000282551 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:10:54 Duration: 15s37ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282551 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 11:22:29 Duration: 13s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282551 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:06:54 Duration: 12s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7s887ms 47s640ms 10s435ms 106 18m26s create table temp0000282493 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 15 07 26 4m52s 11s248ms 08 10 1m41s 10s109ms 09 14 2m36s 11s198ms 10 5 52s61ms 10s412ms 11 10 1m50s 11s6ms 12 8 1m10s 8s768ms 14 12 1m55s 9s647ms 15 17 2m49s 9s961ms 16 4 38s406ms 9s601ms [ User: intelifix - Total duration: 18m26s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 18m26s - Times executed: 106 ]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 07:05:18 Duration: 47s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:13:33 Duration: 13s951ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282493 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 09:12:57 Duration: 13s577ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7s993ms 13s140ms 10s128ms 45 7m35s create table temp0000282591 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 15 13 5 47s880ms 9s576ms 14 5 49s580ms 9s916ms 15 15 2m34s 10s272ms 16 3 33s169ms 11s56ms 17 17 2m51s 10s62ms [ User: intelifix - Total duration: 7m35s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 7m35s - Times executed: 45 ]
-
CREATE TABLE temp0000282591 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 17:20:21 Duration: 13s140ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282591 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 15:02:54 Duration: 12s524ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282591 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 16:26:35 Duration: 12s176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s511ms 11s358ms 9s779ms 12 1m57s create table temp0000282515 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 15 08 12 1m57s 9s779ms [ User: intelifix - Total duration: 1m57s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 1m57s - Times executed: 12 ]
-
CREATE TABLE temp0000282515 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 08:15:09 Duration: 11s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282515 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 08:17:47 Duration: 11s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282515 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-15 08:19:01 Duration: 10s893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 221ms 14s572ms 6s488ms 72 7m47s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 15 00 1 470ms 470ms 06 1 2s4ms 2s4ms 07 6 58s701ms 9s783ms 08 6 1m8s 11s450ms 09 6 55s581ms 9s263ms 10 6 47s853ms 7s975ms 11 6 55s808ms 9s301ms 12 6 44s877ms 7s479ms 13 5 9s241ms 1s848ms 14 6 39s341ms 6s556ms 15 6 38s810ms 6s468ms 16 5 29s338ms 5s867ms 20 1 280ms 280ms 21 5 8s120ms 1s624ms 22 6 8s29ms 1s338ms [ User: intelifix - Total duration: 7m47s - Times executed: 72 ]
[ Application: psql - Total duration: 7m47s - Times executed: 72 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 07:45:16 Duration: 14s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 08:15:15 Duration: 13s629ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-15 08:55:14 Duration: 13s414ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s189ms 3m56s 5s898ms 138 13m33s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 15 00 6 30s88ms 5s14ms 01 6 15s139ms 2s523ms 02 6 15s646ms 2s607ms 03 6 17s851ms 2s975ms 04 6 16s111ms 2s685ms 05 6 15s917ms 2s652ms 06 6 15s568ms 2s594ms 07 6 20s40ms 3s340ms 08 6 19s788ms 3s298ms 09 6 4m14s 42s401ms 10 6 20s464ms 3s410ms 11 6 20s185ms 3s364ms 12 6 22s363ms 3s727ms 13 6 18s598ms 3s99ms 14 6 21s727ms 3s621ms 15 6 2m34s 25s696ms 16 6 21s631ms 3s605ms 17 6 19s203ms 3s200ms 18 6 18s134ms 3s22ms 19 6 17s900ms 2s983ms 20 6 23s859ms 3s976ms 21 6 17s865ms 2s977ms 22 6 17s258ms 2s876ms [ User: intelifix - Total duration: 13m33s - Times executed: 138 ]
[ Application: psql - Total duration: 13m33s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 09:19:10 Duration: 3m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 15:37:17 Duration: 2m12s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-15 00:05:19 Duration: 17s602ms Database: rio User: intelifix Remote: [local] Application: psql
15 442ms 35s579ms 3s568ms 47 2m47s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 15 07 4 41s611ms 10s402ms 08 7 11s254ms 1s607ms 09 6 17s896ms 2s982ms 10 3 16s871ms 5s623ms 11 4 12s93ms 3s23ms 12 3 5s751ms 1s917ms 13 3 8s131ms 2s710ms 14 2 22s206ms 11s103ms 15 6 15s404ms 2s567ms 16 2 2s887ms 1s443ms 17 7 13s622ms 1s946ms [ User: intelifix - Total duration: 2m47s - Times executed: 47 ]
[ Application: psql - Total duration: 2m47s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025573);
Date: 2026-06-15 07:07:31 Duration: 35s579ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025616);
Date: 2026-06-15 14:32:24 Duration: 16s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025596);
Date: 2026-06-15 09:48:38 Duration: 9s311ms Database: rio User: intelifix Remote: [local] Application: psql
16 190ms 54s910ms 3s276ms 68 3m42s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 15 07 10 8s126ms 812ms 08 8 17s483ms 2s185ms 09 7 8s328ms 1s189ms 10 3 11s778ms 3s926ms 11 6 21s560ms 3s593ms 12 4 11s195ms 2s798ms 13 4 55s571ms 13s892ms 14 5 38s288ms 7s657ms 15 10 25s559ms 2s555ms 16 4 3s901ms 975ms 17 7 21s12ms 3s1ms [ User: intelifix - Total duration: 3m42s - Times executed: 68 ]
[ Application: psql - Total duration: 3m42s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025614);
Date: 2026-06-15 13:57:44 Duration: 54s910ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025617);
Date: 2026-06-15 14:45:26 Duration: 35s969ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025605);
Date: 2026-06-15 11:50:17 Duration: 15s126ms Database: rio User: intelifix Remote: [local] Application: psql
17 1s282ms 23s540ms 2s987ms 38 1m53s create table temp0000282507 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 15 07 7 35s892ms 5s127ms 08 23 48s400ms 2s104ms 10 2 10s8ms 5s4ms 13 1 4s426ms 4s426ms 14 4 10s936ms 2s734ms 16 1 3s876ms 3s876ms [ User: intelifix - Total duration: 1m53s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 38 ]
-
CREATE TABLE temp0000282507 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "10-06-2026", "data-ate" : "15-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-15 07:58:36 Duration: 23s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282507 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "10-06-2026", "data-ate" : "15-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-15 10:11:03 Duration: 7s950ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282507 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "10-06-2026", "data-ate" : "15-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-15 13:11:27 Duration: 4s426ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 150ms 6s535ms 1s21ms 1,622 27m36s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 15 07 9 6s220ms 691ms 08 206 3m32s 1s32ms 09 164 3m18s 1s211ms 10 240 4m9s 1s39ms 11 169 2m28s 877ms 12 44 48s732ms 1s107ms 13 104 1m35s 919ms 14 204 3m32s 1s43ms 15 196 3m29s 1s70ms 16 194 3m7s 964ms 17 92 1m26s 945ms [ User: intelifix - Total duration: 27m36s - Times executed: 1622 ]
[ Application: [unknown] - Total duration: 27m36s - Times executed: 1622 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251286, 450, 'CP2228320FH,A0B53C65ECB0,544D4242005A2E58,A0B53C65ECB3$CP2310322MD,D4925E33D240,544D42420065BB1A,D4925E33D243$CP2303326KE,D4925E14917A,544D42420062CF3B,D4925E14917D$CP240932MFR,08C7F52E74D2,544D424200785AAF,08C7F52E74D5$CP2404327M1,08C7F526115E,544D4242007736FF,08C7F5261161$CP230232HJH,D4925E08C11D,544D42420061E0BA,D4925E08C120$CP23303254K,D4925EE29A5C,544D4242006E5F6D,D4925EE29A5F$CP233032FWU,D4925EE43796,544D4242006E8D57,D4925EE43799$CP230532656,D4925E197603,544D424200639186,D4925E197606$CP240932UDZ,08C7F52F7EBE,544D42420078783B,08C7F52F7EC1$CP22283218W,A0B53C660B4F,544D4242005A31BF,A0B53C660B52$CP233032FJV,D4925EE429B3,544D4242006E8BCC,D4925EE429B6$CP233032G8D,D4925EE443E4,544D4242006E8EB5,D4925EE443E7$CP232232D7D,D4925EBD68E4,544D4242006BC3FF,D4925EBD68E7$CP2404326QT,08C7F525EF7A,544D42420077333B,08C7F525EF7D$CP2404323Q8,08C7F5257BF4,544D424200772665,08C7F5257BF7$CP2305327PY,D4925E19B206,544D424200639831,D4925E19B209$CP22393239G,A0B53CC0955B,544D4242005E7B00,A0B53CC0955E$CP232032FUC,D4925EA5E280,544D42420069F3A6,D4925EA5E283$CP2411322W5,08C7F52FEFF2,544D4242007884CF,08C7F52FEFF5$CP234232N01,D4925EF8C220,544D424200723EDD,D4925EF8C223$CP234232QEY,D4925EF91FF5,544D42420072494A,D4925EF91FF8$CP2409324TK,08C7F52BF7AF,544D4242007813E4,08C7F52BF7B2$CP234532G3T,08C7F5043BC6,544D42420073768B,08C7F5043BC9$CP232032TV3,D4925EA7AEA0,544D4242006A26C6,D4925EA7AEA3$CP2319322H2,D4925E9FE518,544D424200699362,D4925E9FE51B$CP2319327NU,D4925EA0AB33,544D42420069A965,D4925EA0AB36$CP2250324VJ,A0B53CF9E0F6,544D42420060BCCC,A0B53CF9E0F9$CP240932NVQ,08C7F52EAB50,544D4242007860BD,08C7F52EAB53$CP230232Q0M,D4925E09B85E,544D42420061FC33,D4925E09B861$CP2409324ET,08C7F52BE8E2,544D42420078123F,08C7F52BE8E5$CP234532L44,08C7F504D544,544D424200738799,08C7F504D547$CP2409324B8,08C7F52BE4BC,544D4242007811C9,08C7F52BE4BF$CP240932JNM,08C7F52E09F2,544D424200784ECF,08C7F52E09F5$CP2301329G1,D4925E02CE2E,544D42420061383D,D4925E02CE31$CP2302322PG,D4925E06889A,544D42420061A18F,D4925E06889D$CP2301329FL,D4925E02CDB0,544D42420061382F,D4925E02CDB3$CP240932GD2,08C7F52DB244,544D424200784511,08C7F52DB247$CP2217320S3,A0B53C3FE94D,544D424200583387,A0B53C3FE950$CP2404325TD,08C7F525CC2E,544D424200772F4F,08C7F525CC31', '',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-15 11:35:54 Duration: 6s535ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (253438, 304, 'F200012003B0FBF,84011295822D$F20001019114BA6,743AEF74E74B$F200010321B62EB,743AEFDA0F59$F200011280B807D,8401125F6FFC$F200011328B54C0,8401128377CB$F200011208B4511,840112070451$F200010290BB563,743AEFAF07A7$F2000101831547F,743AEF745206$F200011216B3FDA,84011227CBE8$F200011152B9160,9877E7BCFE9F$F200011242B10C5,8401122A9134$F20001018411F42,743AEF746B51$F200011302B0979,8401128008D4$F200011193B3956,8401120407F3$F200011070B3110,9877E7492E89$F200011050E1695,9877E70C62E9$F200010284B7E3C,743AEFAD8A19$F20001019212377,743AEF75083E$F200010276B528D,743AEF9D2D56$F20001015614CEC,743AEF5BADB2$F200010293B8CC3,743AEFAF4891$F2000101901246A,743AEF74AD30$F200011131B1135,9877E7B99884$F200011106BE645,9877E77D002F$F200012015B9C0F,840112984924$F200010254E2434,743AEF9A2D39$F200010330E5138,743AEFDC6246$F200011008BB078,9877E707B2AF$F200010301E4674,743AEFC53685$F200010339B6493,9877E7015CD2', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-15 09:22:52 Duration: 6s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (251280, 450, '2102313BFARYMC925679,04E7959B2BC5,4857544387C64EA8,04E7959B2BC8BFARYMA941566,C40D969D2DA4,48575443E1225DA7,C40D969D2DA7BFARYM3904684,80E1BF0A980D,48575443B5A8A5A5,80E1BF0A9810BFARYM9910701,C0F6C271DFEC,48575443258CAAA7,C0F6C271DFEFBFARYM7933175,30C50FB7D89C,48575443CED688A6,30C50FB7D89FBFARYM9918674,00E40608E046,485754433A662AA7,00E40608E049BFARYM9912706,00E406078ECC,485754433A5250A7,00E406078ECFBFARYM7932026,30C50FB6D182,48575443CEC70EA6,30C50FB6D185BFARYM9912022,00E40607765C,485754433A50E0A7,00E40607765FBFARYN7913992,6CE87456C067,48575443AA763AAA,6CE87456C06ABFARYM4932929,D44649B60692,48575443DD0B38A5,D44649B60695BFARYN2943929,A4178B5D9767,48575443F04162A8,A4178B5D976ABFARYN2913622,88892F8933A0,48575443E546A6A8,88892F8933A3BFARYMC929706,04E7959B4AB7,4857544387C83BA8,04E7959B4ABABFARYN2907158,88892F89C90A,48575443E54F70A8,88892F89C90DBFARYMB906516,F82E3F6E47D0,48575443455102A8,F82E3F6E47D3BFARYM6911707,CCD73C76DAFD,485754436377C2A6,CCD73C76DB00BFARYN7912289,6CE874564F50,48575443AA6F93AA,6CE874564F53BFARYM3910591,80E1BF0BF01F,48575443B5C87DA5,80E1BF0BF022BFARYM7927852,30C50FB821FD,48575443CEDAD9A6,30C50FB82200BFARYM8912129,1C3D2F47E312,48575443D53F94A6,1C3D2F47E315BFARYMB906128,F82E3F768A98,48575443468C04A8,F82E3F768A9BBFARYN1918339,C4FBAAFBD0BC,48575443D3DAFFA8,C4FBAAFBD0BFBFARYMA943136,C40D96A1F82E,48575443E1A70AA7,C40D96A1F831BFARYN7911526,6CE874561DA4,48575443AA6CA7AA,6CE874561DA7BFARYMC928097,04E79599A294,4857544387AE29A8,04E79599A297BFARYM4917303,482CD08F47C0,48575443CB7D5CA5,482CD08F47C3BFARYM7928363,30C50FB6C6D1,48575443CEC66DA6,30C50FB6C6D4BFARYN2942323,A4178B5FF8E3,48575443F0574AA8,A4178B5FF8E6BFARYM7925926,30C50FB60242,48575443CEBAE2A6,30C50FB60245BFARYM9910576,C0F6C271F40B,48575443258E00A7,C0F6C271F40E', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-15 10:16:26 Duration: 5s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 150ms 20s684ms 1s13ms 152 2m34s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 15 08 21 12s476ms 594ms 09 5 2s106ms 421ms 10 6 2s533ms 422ms 11 13 5s870ms 451ms 13 27 1m16s 2s846ms 14 12 4s940ms 411ms 15 13 18s331ms 1s410ms 16 35 20s500ms 585ms 17 20 10s492ms 524ms [ User: intelifix - Total duration: 2m34s - Times executed: 152 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 152 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040999) LIMIT 1;
Date: 2026-06-15 13:15:13 Duration: 20s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (040355) LIMIT 1;
Date: 2026-06-15 13:16:55 Duration: 13s293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (041164) LIMIT 1;
Date: 2026-06-15 13:13:33 Duration: 7s981ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 150ms 11s586ms 600ms 1,046 10m28s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 15 07 1 1s216ms 1s216ms 08 128 1m55s 904ms 09 123 1m12s 586ms 10 157 1m35s 609ms 11 148 1m27s 590ms 13 108 56s298ms 521ms 14 134 1m12s 537ms 15 140 1m11s 507ms 16 105 55s553ms 529ms 17 2 869ms 434ms [ User: intelifix - Total duration: 10m28s - Times executed: 1046 ]
[ Application: [unknown] - Total duration: 10m28s - Times executed: 1046 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "320", "itens" : "241656343350,241725887678,241715603746,241665736881,241647296271,241727444262,241635003759,241665666874,241620248503,241637697388,241677661323,241712056385,241669569500,241692991214,241595280208,241661565363,241698491717,241651296280,241607177799,241712108185,241674572222,241689941130,241647236669,241674486074,241699193839,241693724753,241604610524,241619773754,241607958088,241651287390,241665670209,241607158808,241655320411,241600996769,241677712944,241677389196,241655634459,241637479915,241713012225,241661331727,241622657278,241704165166,241680310426,241599501428,230055013842,241713987078,241670324254", "usuario" : "405", "caixa" : "2879093", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 08:03:43 Duration: 11s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "253755", "modelo" : "454", "itens" : "241625400409,241625381619,241614281636,241613846284,230056850509,241612006082,241632975760,241613378708,241626546266,241613299710,241627175374,241641039701,241613303448,241633168204,241624686971,241624444647,241611919609,241632646783,241611830308,241624321729,241614425263,241632744548,241625553252,241642245969,241613404142,241614429102,241625252639,241643686379,241600558892,241644849108,241632638196,241632433452,241624630828,241613913844,241612424765,241642218693,241632711717,241626501919,241600654761,241600653953,241625356060,241600348591,241642474757,241633658890,241612445474,241625082746,241626609707,241627141634", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 10:42:32 Duration: 3s837ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "253181", "modelo" : "320", "itens" : "241672205369,241707283742,241678246890,835036906001681,241730914264,834232934000413,835204930000847,835066910000381,834200929003018,241604328598,241698738283,835197929005337,834117917003052,834186927002013,835112917004450,834257937001715,241617544142,241708777490,835016903001813,834075911003110,241614480320,230048492039,241664775160,241695541418,241704290611,241614527697,241704373447,241594652436,835035906000437,241691547795,241594983153,241680482642,241622592929,241622647479,241708932736,836051908001102,241727009416,834075911003386,834186927001615,835090914001481,834233934000907,834148922001231,241630173254,834319946002101,835073911000556,835016903000150,835036906002276,835212931003565", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-15 08:00:55 Duration: 3s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 15,541 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 2885 ERROR entries
- 0 WARNING entries
- 20 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,403 Max number of times the same event was reported
- 2,920 Total events found
Rank Times reported Error 1 2,403 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 15 07 220 08 219 09 218 10 274 11 297 12 197 13 118 14 265 15 282 16 266 17 47 - ERROR: prepared statement "_PLAN0000000035A8B310" does not exist
- ERROR: prepared statement "_PLAN000000003190E9B0" does not exist
- ERROR: prepared statement "_PLAN0000000031B3DFA0" does not exist
Statement: DEALLOCATE "_PLAN0000000035A8B310"
Date: 2026-06-15 07:01:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003190E9B0"
Date: 2026-06-15 07:01:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000031B3DFA0"
Date: 2026-06-15 07:02:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 15 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-15 00:05:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-15 00:15:03 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-15 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
3 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 15 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-15 00:05:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-15 00:15:03 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-15 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 15 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-15 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-15 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-15 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 15 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-15 08:01:09 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-15 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-15 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
6 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 15 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-15 08:01:08 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-15 08:20:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-15 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 15 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-15 07:18:51 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-15 08:12:10 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-15 09:16:27 Database: brasilia Application: psql User: intelifix Remote: [local]
8 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 15 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-15 07:18:51 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-15 08:12:10 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-15 09:16:27 Database: brasilia Application: psql User: intelifix Remote: [local]
9 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 15 10 3 14 2 16 7 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 71
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"252095","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-06-15 10:58:42 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"252095","seriais":[{"serial":"'"},{"serial":"216405726171"}]}')
Date: 2026-06-15 10:58:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"62","seriais":[{"serial":"'"},{"serial":"216405726171"}]}');
Date: 2026-06-15 10:58:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 11 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 15 11 4 12 6 16 1 - ERROR: column "c4a4023ede26" does not exist at character 27
- ERROR: column "c4a4023ede26" does not exist at character 27
- ERROR: column "c4a4023ede26" does not exist at character 27
Statement: select * from rs_caixa_qr(C4A4023EDE26)
Date: 2026-06-15 11:31:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(C4A4023EDE26)
Date: 2026-06-15 11:31:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(C4A4023EDE26)
Date: 2026-06-15 11:31:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
11 11 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 15 09 1 15 10 - ERROR: process 1614712 detected deadlock while waiting for ShareLock on transaction 1049280 after 1000.268 ms
- ERROR: process 1922814 detected deadlock while waiting for ShareLock on transaction 1076981 after 1000.173 ms
- ERROR: process 1922814 detected deadlock while waiting for ShareLock on transaction 1076981 after 1000.167 ms
Detail: Process holding the lock: 1565133. Wait queue: .
Context: while updating tuple (70377,37) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025594, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-15 09:16:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1894608. Wait queue: .
Context: while updating tuple (18716,27) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025624, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-15 15:35:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1894608. Wait queue: .
Context: while updating tuple (18716,27) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 025624, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-15 15:35:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 15 00 1 06 1 12 2 13 1 15 1 20 1 23 2 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-15 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-15 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-15 12:09:56 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
13 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 15 05 8 - ERROR: relation "public.equipamentos" does not exist at character 49
- ERROR: relation "public.equipamentos" does not exist
- ERROR: relation "public.codigos_barra" does not exist at character 70
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, mod_id FROM public.equipamentos
Date: 2026-06-15 05:30:02 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-15 05:30:02 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-15 05:30:02 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
14 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 15 09 3 15 3 - LOG: process 1565133 still waiting for ShareLock on transaction 1048992 after 1000.094 ms
- LOG: process 1565133 still waiting for ShareLock on transaction 1048992 after 6764.050 ms
- LOG: process 1565133 still waiting for ShareLock on transaction 1048992 after 38291.971 ms
Detail: Process holding the lock: 1614712. Wait queue: 1565133.
Context: while updating tuple (70377,35) 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-15 09:15:18 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1614712. Wait queue: 1565133.
Context: while updating tuple (70377,35) 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-15 09:15:23 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1614712. Wait queue: 1565133.
Context: while updating tuple (70377,35) 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-15 09:15:55 Database: rio Application: psql User: intelifix Remote: [local]
15 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 15 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-15 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-15 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-15 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
16 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 15 13 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000282577"
Date: 2026-06-15 13:23:33
Context: automatic vacuum of table "rio.public.temp0000282493"
Date: 2026-06-15 16:14:36
17 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 15 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-15 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-15 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
18 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 15 13 1 16 1 - LOG: process 1810527 still waiting for AccessExclusiveLock on relation 1134124 of database 358220 after 1000.264 ms
- LOG: process 1944862 still waiting for AccessExclusiveLock on relation 1150522 of database 358220 after 1000.092 ms
Detail: Process holding the lock: 1812306. Wait queue: 1810527.
Statement: DROP TABLE IF EXISTS temp0000282577;Date: 2026-06-15 13:23:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1980077. Wait queue: 1944862.
Statement: DROP TABLE IF EXISTS temp0000282493;Date: 2026-06-15 16:14:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
19 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 15 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-15 00:05:23 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-15 06:05:11 Database: brasilia Application: psql User: intelifix Remote: [local]
20 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 15 18 1 - ERROR: function rs_lote_entrada_fechar_automatico() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_ENTRADA_FECHAR_AUTOMATICO() /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(Date: 2026-06-15 18:00:02 Database: brasilia Application: psql User: intelifix Remote: [local]
21 1 ERROR: trailing junk after parameter at or near "..."
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 15 10 1 - ERROR: trailing junk after parameter at or near "N_CAIXA" at character 27
Statement: select * from rs_caixa_qr($1N_CAIXA)
Date: 2026-06-15 10:23:27 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
22 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #22
Day Hour Count Jun 15 03 1 - LOG: database system was shut down at 2026-06-15 03:05:01 -03
Date: 2026-06-15 03:05:02
23 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #23
Day Hour Count Jun 15 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-15 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]