pgBadger-
Global information
- Generated on Wed Sep 23 23:50:15 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 41,974 log entries in 13s
- Log start from 2026-09-23 00:00:21 to 2026-09-23 23:49:42
-
Overview
Global Stats
- 396 Number of unique normalized queries
- 5,041 Number of queries
- 7h11m14s Total query duration
- 2026-09-23 00:02:21 First query
- 2026-09-23 23:42:38 Last query
- 6 queries/s at 2026-09-23 08:30:56 Query peak
- 7h11m14s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h11m14s Execute total duration
- 4,591 Number of events
- 16 Number of unique normalized events
- 4,440 Max number of times the same event was reported
- 0 Number of cancellation
- 411 Total number of automatic vacuums
- 1,067 Total number of automatic analyzes
- 22 Number temporary file
- 247.09 MiB Max size of temporary file
- 70.58 MiB Average size of temporary file
- 385 Total number of sessions
- 9 sessions at 2026-09-23 01:05:02 Session peak
- 13d10h54m Total duration of sessions
- 50m19s Average duration of sessions
- 13 Average queries per session
- 1m7s Average queries duration per session
- 49m12s Average idle time per session
- 393 Total number of connections
- 7 connections/s at 2026-09-23 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-23 08:30:56 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-23 15:48:53 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-23 23:42:18 Date
Queries duration
Key values
- 7h11m14s 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) Sep 23 00 22 0ms 35s888ms 6s14ms 5s401ms 8s669ms 1m12s 01 12 0ms 6s553ms 3s998ms 6s926ms 7s897ms 9s246ms 02 15 0ms 8s365ms 2s714ms 3s459ms 6s381ms 11s497ms 03 15 0ms 6s52ms 2s839ms 3s817ms 8s120ms 8s827ms 04 12 0ms 7s198ms 3s785ms 4s616ms 7s936ms 10s189ms 05 19 0ms 11m26s 1m18s 15s274ms 3m4s 11m26s 06 22 0ms 16s880ms 2s998ms 3s641ms 4s362ms 24s453ms 07 142 0ms 8m52s 14s174ms 56s422ms 5m25s 8m52s 08 375 0ms 5m35s 3s957ms 52s917ms 3m38s 5m40s 09 518 150ms 6m40s 4s574ms 1m33s 5m51s 6m46s 10 605 0ms 6m31s 3s813ms 1m23s 1m28s 10m36s 11 494 150ms 6m23s 2s881ms 57s690ms 1m18s 6m26s 12 253 0ms 5m39s 5s49ms 30s792ms 3m49s 5m42s 13 202 0ms 5m1s 3s764ms 15s650ms 19s140ms 5m49s 14 519 150ms 5m23s 4s564ms 1m16s 5m30s 5m58s 15 489 150ms 5m18s 2s811ms 30s971ms 3m28s 5m56s 16 512 151ms 5m24s 4s221ms 1m1s 5m31s 8m50s 17 266 0ms 5m9s 4s75ms 26s750ms 1m37s 6m7s 18 21 0ms 4m56s 28s125ms 3s166ms 44s702ms 4m56s 19 18 0ms 4m53s 30s972ms 2s878ms 42s963ms 4m53s 20 119 0ms 5m3s 9s449ms 1m1s 1m19s 6m46s 21 26 0ms 4m53s 22s145ms 5s755ms 44s920ms 4m53s 22 24 0ms 4m55s 24s52ms 4s967ms 44s367ms 4m55s 23 341 0ms 1m3s 5s716ms 1m8s 1m12s 1m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 3 0 8s880ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 3 0 493ms 0ms 0ms 0ms 03 3 0 316ms 0ms 0ms 228ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 9 0 2s966ms 0ms 0ms 1s327ms 07 107 0 16s588ms 4s61ms 49s152ms 6m47s 08 275 0 4s455ms 6s729ms 39s28ms 5m 09 437 0 4s613ms 16s983ms 1m30s 5m56s 10 475 0 3s914ms 24s561ms 1m1s 6m35s 11 373 0 2s972ms 12s870ms 23s740ms 3m42s 12 187 0 5s790ms 4s285ms 8s663ms 5m30s 13 162 0 4s351ms 4s297ms 11s803ms 3m20s 14 392 0 4s464ms 22s281ms 40s809ms 5m32s 15 420 0 2s761ms 7s118ms 9s897ms 5m23s 16 426 0 4s371ms 19s238ms 58s491ms 5m59s 17 211 0 4s481ms 8s608ms 18s188ms 3m25s 18 9 0 1m 0ms 0ms 3m14s 19 6 0 1m29s 0ms 0ms 3m19s 20 20 81 10s848ms 16s938ms 1m1s 3m20s 21 9 0 59s694ms 0ms 0ms 3m17s 22 6 0 1m30s 0ms 0ms 3m22s 23 21 320 5s716ms 1m3s 1m8s 1m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 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 Sep 23 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 10 10.00 0.00% 08 0 15 15.00 0.00% 09 0 22 22.00 0.00% 10 0 9 9.00 0.00% 11 0 14 14.00 0.00% 12 0 9 9.00 0.00% 13 0 8 8.00 0.00% 14 0 10 10.00 0.00% 15 0 13 13.00 0.00% 16 0 10 10.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Sep 23 00 18 0.01/s 01 7 0.00/s 02 11 0.00/s 03 18 0.01/s 04 6 0.00/s 05 9 0.00/s 06 15 0.00/s 07 16 0.00/s 08 20 0.01/s 09 28 0.01/s 10 34 0.01/s 11 30 0.01/s 12 16 0.00/s 13 17 0.00/s 14 24 0.01/s 15 24 0.01/s 16 20 0.01/s 17 17 0.00/s 18 10 0.00/s 19 8 0.00/s 20 14 0.00/s 21 10 0.00/s 22 10 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Sep 23 00 7 53m17s 52m58s 01 16 1h1m7s 1h1m4s 02 7 1h1s 59m55s 03 20 23m25s 23m23s 04 9 1h2m20s 1h2m15s 05 7 52m51s 49m17s 06 8 58m8s 57m59s 07 14 57m17s 54m53s 08 15 1h1m12s 59m33s 09 22 55m35s 53m47s 10 36 34m58s 33m54s 11 33 37m27s 36m44s 12 20 53m30s 52m26s 13 12 59m28s 58m25s 14 20 55m27s 53m28s 15 26 49m48s 48m55s 16 21 57m37s 55m54s 17 20 54m2s 53m8s 18 15 1h12s 59m32s 19 10 1h30s 59m34s 20 11 41m46s 40m4s 21 10 1h47s 59m50s 22 11 1h33s 59m40s 23 15 38m34s 36m24s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-09-23 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 393 connections Total
Connections per user
Key values
- intelifix Main User
- 393 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-09-23 01:05:02 Date
Histogram of session times
Key values
- 295 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 385 sessions Total
Sessions per user
Key values
- intelifix Main User
- 385 sessions Total
Sessions per host
Key values
- [local] Main Host
- 385 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 385 sessions Total
Application Count Total Duration Average Duration [unknown] 325 12d5h20m40s 54m9s pgAdmin 4 - CONN:2011992 2 34s696ms 17s348ms pgAdmin 4 - CONN:2589577 2 36s385ms 18s192ms pgAdmin 4 - CONN:3014750 2 9m49s 4m54s pgAdmin 4 - CONN:6983121 2 21m57s 10m58s pgAdmin 4 - CONN:763741 2 6s621ms 3s310ms pgAdmin 4 - CONN:8067844 2 1m43s 51s722ms pgAdmin 4 - CONN:8298376 2 12s702ms 6s351ms pgAdmin 4 - DB:brasilia 2 2m28s 1m14s pgAdmin 4 - DB:contagem 2 12m6s 6m3s pgAdmin 4 - DB:postgres 3 36m46s 12m15s pgAdmin 4 - DB:rio 3 22m56s 7m38s pg_dump 9 41m52s 4m39s postgres_fdw 1 45m 45m psql 26 1d2h17m8s 1h39s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 49,746 buffers Checkpoint Peak
- 2026-09-23 00:09:48 Date
- 270.054 seconds Highest write time
- 0.106 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-09-23 14:34:36 Date
Checkpoints distance
Key values
- 365.91 Mo Distance Peak
- 2026-09-23 14:34:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 23 00 79,954 678.43s 0.032s 678.491s 01 2,723 272.667s 0.129s 272.877s 02 2,357 236.289s 0.023s 236.394s 03 2,185 217.485s 0.235s 217.761s 04 3,288 329.416s 0.073s 329.513s 05 11,328 1,121.089s 0.305s 1,121.431s 06 7,510 476.231s 0.193s 476.442s 07 19,558 1,702.882s 0.206s 1,703.141s 08 44,301 2,878.164s 0.375s 2,878.618s 09 55,693 3,239.126s 0.495s 3,239.738s 10 79,473 3,239.266s 0.339s 3,239.765s 11 44,519 3,239.161s 0.513s 3,239.768s 12 32,286 2,627.92s 0.272s 2,628.321s 13 19,170 1,777.509s 0.168s 1,777.794s 14 62,431 3,231.688s 0.399s 3,232.215s 15 54,611 3,239.162s 0.42s 3,239.671s 16 66,429 3,229.324s 0.337s 3,229.755s 17 23,847 2,118.689s 0.179s 2,118.936s 18 2,598 260.579s 0.136s 260.741s 19 35 3.522s 0.005s 3.54s 20 1,546 214.387s 0.009s 214.414s 21 3,137 314.052s 0.082s 314.23s 22 1,722 172.59s 0.223s 172.9s 23 297 29.795s 0.018s 29.833s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 23 00 0 0 13 515 0.015s 0.006s 01 0 0 1 404 0.092s 0.007s 02 0 0 1 426 0.005s 0.006s 03 0 0 0 448 0.063s 0.011s 04 0 0 2 481 0.028s 0.006s 05 0 0 4 794 0.063s 0.009s 06 0 0 2 275 0.062s 0.006s 07 0 0 16 1,844 0.062s 0.012s 08 0 0 21 5,907 0.054s 0.012s 09 0 0 34 7,258 0.062s 0.012s 10 0 0 59 7,863 0.029s 0.012s 11 0 0 29 7,361 0.062s 0.012s 12 0 0 22 4,204 0.038s 0.012s 13 0 0 7 4,686 0.061s 0.012s 14 0 0 68 7,427 0.055s 0.012s 15 0 0 29 6,622 0.062s 0.012s 16 0 0 41 7,003 0.063s 0.012s 17 0 0 24 5,217 0.062s 0.011s 18 0 0 1 349 0.062s 0.005s 19 0 0 0 13 0.003s 0.002s 20 0 0 1 100 0.003s 0.003s 21 0 0 1 444 0.062s 0.013s 22 0 0 0 472 0.063s 0.024s 23 0 0 0 37 0.007s 0.006s Day Hour Count Avg time (sec) Sep 23 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 Sep 23 00 34,177.17 kB 91,873.83 kB 01 2,424.00 kB 50,699.17 kB 02 2,021.00 kB 27,958.67 kB 03 1,403.33 kB 5,890.33 kB 04 3,215.83 kB 3,615.67 kB 05 8,717.67 kB 13,739.33 kB 06 4,075.60 kB 10,750.00 kB 07 21,882.25 kB 42,724.33 kB 08 29,121.58 kB 80,261.83 kB 09 46,121.00 kB 98,894.75 kB 10 81,226.00 kB 122,152.67 kB 11 39,947.83 kB 89,113.75 kB 12 29,207.50 kB 82,720.92 kB 13 10,076.83 kB 34,592.08 kB 14 92,049.83 kB 118,231.67 kB 15 39,387.50 kB 101,131.33 kB 16 56,154.25 kB 99,538.00 kB 17 36,397.36 kB 98,663.82 kB 18 2,411.20 kB 48,578.40 kB 19 109.50 kB 33,409.50 kB 20 5,315.00 kB 27,066.67 kB 21 1,638.75 kB 16,150.38 kB 22 1,059.38 kB 7,739.00 kB 23 166.60 kB 4,151.20 kB -
Temporary Files
Size of temporary files
Key values
- 494.17 MiB Temp Files size Peak
- 2026-09-23 05:31:57 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-23 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.23 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 2 207.99 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.85 MiB 247.09 MiB 64.84 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-23 05:32:06 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-23 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 307.27 MiB 57.12 MiB 94.00 MiB 76.82 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-23 05:30:43 Duration: 39s265ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-23 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 207.99 MiB 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( 030224, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 07:28:04 Duration: 6m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030232, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:48:25 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030230, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:08:48 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 247.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 247.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-23 16:22:37 - 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-09-23 16:56:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 94.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-23 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 94.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-23 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 62.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-23 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 57.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-23 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 40.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 40.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-23 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.86 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database contagem - 2026-09-23 00:06:07 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 5.86 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database contagem - 2026-09-23 00:06:07 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 1,067 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.pg_catalog.pg_class 63 rio.pg_catalog.pg_type 55 rio.public.usuarios 47 contagem.pg_catalog.pg_attribute 44 brasilia.pg_catalog.pg_attribute 39 rio.public.temp0000292268 37 rio.pg_catalog.pg_index 35 rio.pg_catalog.pg_depend 30 contagem.public.temp0000227266 29 contagem.public.usuarios 28 contagem.pg_catalog.pg_class 25 rio.public.temp0000292230 25 rio.public.temp0000292212 23 rio.public.temp0000292192 21 contagem.pg_catalog.pg_type 21 rio.public.temp0000292298 17 brasilia.public.temp0000240734 17 rio.public.temp0000292198 17 brasilia.pg_catalog.pg_class 17 rio.public.temp0000292282 16 rio.public.temp0000291977 15 brasilia.pg_catalog.pg_type 14 brasilia.public.temp0000240764 14 rio.public.temp0000292228 12 rio.public.temp0000292258 12 rio.public.temp0000292222 12 brasilia.public.temp0000240724 12 contagem.pg_catalog.pg_index 12 rio.public.temp0000292056 11 brasilia.public.usuarios 10 rio.public.temp0000290026 10 rio.public.temp0000292204 10 brasilia.public.temp0000240716 10 rio.public.temp0000292220 9 contagem.pg_catalog.pg_depend 9 brasilia.public.temp0000240772 8 rio.public.temp0000292190 8 brasilia.pg_catalog.pg_index 8 rio.public.temp0000292314 7 rio.public.temp0000292266 7 brasilia.public.temp0000240800 7 brasilia.pg_catalog.pg_depend 6 contagem.public.temp0000227268 6 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000292278 5 postgres.pg_catalog.pg_shdepend 5 rio.public.temp0000292232 4 rio.public.temp0000292292 4 rio.public.temp0000292318 4 rio.public.temp0000292206 4 contagem.public.temp0000227272 4 contagem.public.temp0000227280 4 contagem.public.temp0000227236 4 brasilia.public.temp0000240780 3 brasilia.public.temp0000240792 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000240750 3 rio.public.tmp_drill_0320 3 rio.public.temp0000292256 3 rio.public.temp0000292302 2 rio.public.temp0000290230 2 contagem.public.temp0000227284 2 brasilia.public.temp0000240760 2 contagem.public.temp0000227276 2 brasilia.public.temp0000240774 2 contagem.public.nf_entrada 2 brasilia.public.temp0000240790 2 rio.public.tmp_drill_0302 2 brasilia.public.temp0000240742 2 brasilia.public.temp0000240730 2 rio.public.temp0000292296 2 rio.public.temp0000292194 2 contagem.public.temp0000227256 2 contagem.public.temp0000227278 1 rio.public.temp0000292210 1 brasilia.public.temp0000240748 1 brasilia.public.temp0000240802 1 brasilia.public.nf_entrada 1 rio.public.temp0000292214 1 rio.public.temp0000292224 1 rio.public.temp0000292240 1 brasilia.public.temp0000240806 1 brasilia.public.temp0000240786 1 rio.public.temp0000292186 1 brasilia.public.temp0000240758 1 brasilia.public.temp0000240752 1 brasilia.public.temp0000240722 1 brasilia.public.temp0000240736 1 brasilia.public.temp0000240796 1 rio.public.temp0000292284 1 rio.public.temp0000292180 1 brasilia.public.temp0000240718 1 rio.public.temp0000292244 1 rio.public.temp0000292288 1 brasilia.public.temp0000240726 1 Total 1,067 Vacuums per table
Key values
- pg_catalog.pg_attribute (46) Main table vacuumed on database rio
- 411 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 46 42 0 0 0 0 0 25,339 6,274 9,343,833 391 10,179 rio.public.temp0000292268 37 0 0 0 0 0 0 30,494 3,809 6,524,412 0 0 contagem.public.usuarios 28 0 0 0 0 0 0 123 85 49,537 0 0 rio.pg_catalog.pg_class 27 24 0 0 0 0 0 5,380 1,471 2,247,999 82 308 rio.pg_catalog.pg_type 23 20 0 0 0 0 0 2,204 599 906,638 56 219 rio.pg_catalog.pg_index 14 14 0 0 0 0 0 836 215 250,424 30 61 contagem.pg_catalog.pg_attribute 14 14 0 0 0 0 0 8,294 2,288 4,009,414 39 1,119 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 4,231 1,325 2,220,214 75 858 rio.public.temp0000292192 12 0 0 0 0 0 0 18,252 1,862 3,432,279 0 0 rio.public.temp0000291977 12 0 0 0 0 0 0 4,188 61 256,394 0 0 rio.public.temp0000292056 11 0 0 0 0 0 0 718 63 52,057 0 0 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,290 1,616 2,492,944 54 1,284 rio.public.temp0000290026 10 0 0 0 0 0 0 663 58 47,832 0 0 rio.public.temp0000292228 10 0 0 0 0 0 0 9,114 35 543,431 0 0 rio.public.temp0000292298 9 0 0 0 0 0 0 797 165 255,526 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,843 2,430 10,673,122 1,264 5,721 rio.public.temp0000292212 8 0 0 0 0 0 0 280 45 23,042 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,358 377 550,311 15 44 brasilia.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,353 432 790,846 54 157 rio.public.temp0000292314 7 0 0 0 0 0 0 12,744 1,845 3,106,602 0 0 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 624 168 268,750 8 16 rio.public.temp0000292266 6 0 0 0 0 0 0 10,914 24 647,544 0 0 rio.public.usuarios 6 4 0 0 0 0 0 153 72 179,886 23 65 brasilia.pg_catalog.pg_class 5 5 0 0 0 0 0 940 358 590,432 24 89 brasilia.pg_catalog.pg_statistic 5 5 0 0 0 0 0 5,517 1,914 7,348,670 1,466 8,334 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 202 66 74,681 5 7 brasilia.pg_catalog.pg_type 4 4 0 0 0 0 0 365 140 199,455 11 42 rio.public.temp0000292198 4 0 0 0 0 0 0 175 23 13,633 0 0 rio.public.temp0000292292 4 0 0 0 0 0 0 5,464 15 324,723 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,158 498 2,951,791 156 537 brasilia.public.temp0000240792 3 0 0 0 0 0 0 515 11 32,138 0 0 brasilia.public.temp0000240780 3 0 0 0 0 0 0 765 264 439,157 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,437 424 1,679,587 265 1,804 rio.public.tmp_drill_0320 3 3 0 0 0 0 0 1,929 9 322,298 0 0 brasilia.public.temp0000240750 3 0 0 0 0 0 0 765 264 440,142 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,040 280 623,295 9 58 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 1,723 6 289,633 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 223 29 133,484 11 20 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 610 229 332,861 20 498 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 104 30 23,954 4 12 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 384 115 558,528 45 113 contagem.public.temp0000227280 2 0 0 0 0 0 0 232 12 15,630 0 0 rio.public.temp0000292296 2 0 0 0 0 0 0 1,905 10 113,911 0 0 contagem.public.temp0000227276 2 0 0 0 0 0 0 233 12 15,686 0 0 rio.public.temp0000292258 2 0 0 0 0 0 0 156 12 10,982 0 0 brasilia.public.temp0000240736 1 0 0 0 0 0 0 256 4 15,700 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 30,281 29,501 36,541,220 0 0 rio.public.temp0000292230 1 0 0 0 0 0 0 93 92 184,886 0 0 brasilia.public.temp0000240758 1 0 0 0 0 0 0 255 4 15,648 0 0 brasilia.public.temp0000240790 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000292288 1 0 0 0 0 0 0 82 81 161,058 0 0 rio.public.temp0000292282 1 0 0 0 0 0 0 82 6 5,740 0 0 brasilia.public.temp0000240774 1 0 0 0 0 0 0 255 4 15,648 0 0 brasilia.public.temp0000240806 1 0 0 0 0 0 0 255 4 15,648 0 0 rio.public.temp0000292318 1 0 0 0 0 0 0 90 6 6,232 0 0 brasilia.public.temp0000240760 1 0 0 0 0 0 0 255 4 15,648 0 0 rio.public.temp0000290230 1 0 0 0 0 0 0 77 6 5,419 0 0 brasilia.public.temp0000240748 1 0 0 0 0 0 0 255 4 15,648 0 0 rio.public.temp0000292284 1 0 0 0 0 0 0 8 5 1,292 0 0 Total 411 210 0 0 0 0 0 214,282 59,764 102,408,269 4,107 31,545 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (5.86) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.23 rio.public.temp0000292268 0 0 0.92 contagem.public.usuarios 0 0 0.04 rio.pg_catalog.pg_class 0 0 0.91 rio.pg_catalog.pg_type 0 0 0.54 rio.pg_catalog.pg_index 0 0 0.47 contagem.pg_catalog.pg_attribute 0 0 1.58 rio.pg_catalog.pg_depend 0 0 0.93 rio.public.temp0000292192 0 0 0.52 rio.public.temp0000291977 0 0 0.1 rio.public.temp0000292056 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 1.11 rio.public.temp0000290026 0 0 0 rio.public.temp0000292228 0 0 0.42 rio.public.temp0000292298 0 0 0.01 rio.pg_catalog.pg_statistic 0 0 1.22 rio.public.temp0000292212 0 0 0.02 contagem.pg_catalog.pg_class 0 0 1.11 brasilia.pg_catalog.pg_shdepend 0 0 0.25 rio.public.temp0000292314 0 0 0.68 contagem.pg_catalog.pg_type 0 0 0.35 rio.public.temp0000292266 0 0 0.26 rio.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_class 0 0 0.56 brasilia.pg_catalog.pg_statistic 0 0 0.67 contagem.pg_catalog.pg_index 0 0 0.08 brasilia.pg_catalog.pg_type 0 0 0.58 rio.public.temp0000292198 0 0 0 rio.public.temp0000292292 0 0 0.18 rio.pg_toast.pg_toast_2619 0 0 0.39 brasilia.public.temp0000240792 0 0 0 brasilia.public.temp0000240780 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.27 rio.public.tmp_drill_0320 0 0 0.05 brasilia.public.temp0000240750 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.44 rio.public.tmp_drill_0302 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_catalog.pg_depend 0 0 0.46 brasilia.pg_catalog.pg_index 0 0 0.39 brasilia.pg_toast.pg_toast_2619 0 0 0.09 contagem.public.temp0000227280 0 0 0 rio.public.temp0000292296 0 0 0.05 contagem.public.temp0000227276 0 0 0 rio.public.temp0000292258 0 0 0 brasilia.public.temp0000240736 0 0 0 contagem.auditor.auditor_2026_09 0 0 5.86 rio.public.temp0000292230 0 0 0.01 brasilia.public.temp0000240758 0 0 0 brasilia.public.temp0000240790 0 0 0 rio.public.temp0000292288 0 0 0.01 rio.public.temp0000292282 0 0 0 brasilia.public.temp0000240774 0 0 0 brasilia.public.temp0000240806 0 0 0 rio.public.temp0000292318 0 0 0.01 brasilia.public.temp0000240760 0 0 0 rio.public.temp0000290230 0 0 0 brasilia.public.temp0000240748 0 0 0 rio.public.temp0000292284 0 0 0 Total 0 0 24.83 Tuples removed per table
Key values
- pg_catalog.pg_attribute (190550) Main table with removed tuples on database rio
- 410316 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 46 42 190,550 1,143,166 38,006 381 27,997 contagem.pg_catalog.pg_attribute 14 14 54,177 340,457 256 475 7,452 brasilia.pg_catalog.pg_attribute 11 11 39,975 242,151 724 68 6,188 rio.public.tmp_drill_0320 3 3 28,734 29,324 0 0 739 rio.public.tmp_drill_0302 2 2 25,748 26,313 0 0 662 rio.pg_catalog.pg_statistic 8 8 14,339 65,634 0 0 10,288 rio.pg_catalog.pg_depend 12 12 8,972 228,160 18 0 2,244 rio.pg_catalog.pg_type 23 20 7,951 54,781 2,486 28 1,686 brasilia.pg_catalog.pg_statistic 5 5 7,315 42,058 0 0 5,360 brasilia.pg_catalog.pg_shdepend 7 7 6,496 95,511 302 0 875 contagem.pg_catalog.pg_statistic 3 3 6,289 22,820 0 0 3,033 rio.pg_catalog.pg_class 27 24 3,513 101,344 5,878 75 3,458 rio.pg_catalog.pg_index 14 14 3,275 27,189 297 13 766 contagem.pg_catalog.pg_type 6 6 2,231 13,542 0 42 372 contagem.public.usuarios 28 0 1,722 672 0 0 56 rio.pg_toast.pg_toast_2619 4 4 1,226 2,975 7 0 1,080 contagem.pg_catalog.pg_depend 3 3 1,157 56,775 0 34 514 brasilia.pg_catalog.pg_depend 2 2 1,117 35,479 0 31 340 contagem.pg_catalog.pg_class 7 7 1,072 25,852 0 37 1,097 brasilia.pg_catalog.pg_class 5 5 1,059 18,149 0 1 749 brasilia.pg_catalog.pg_type 4 4 949 8,846 0 23 250 contagem.pg_catalog.pg_index 4 4 920 7,606 0 25 190 rio.public.usuarios 6 4 744 3,215 161 0 114 brasilia.pg_catalog.pg_index 2 2 393 3,771 0 12 104 brasilia.pg_toast.pg_toast_2619 2 2 203 282 0 10 122 contagem.pg_toast.pg_toast_2619 2 2 189 224 0 0 120 brasilia.public.temp0000240736 1 0 0 3,340 0 0 256 contagem.auditor.auditor_2026_09 1 0 0 2,801,638 0 0 125,764 brasilia.public.temp0000240792 3 0 0 10,023 0 0 768 rio.public.temp0000292230 1 0 0 1,448 0 43 85 rio.public.temp0000290026 10 0 0 33,072 0 221 739 brasilia.public.temp0000240758 1 0 0 3,341 0 0 256 brasilia.public.temp0000240780 3 0 0 10,023 0 0 768 rio.public.temp0000292056 11 0 0 40,191 0 314 902 rio.public.temp0000292192 12 0 0 284,183 0 0 20,480 brasilia.public.temp0000240790 1 0 0 3,341 0 0 256 rio.public.temp0000292268 37 0 0 538,147 0 874 38,422 rio.public.temp0000292288 1 0 0 1,281 0 54 74 rio.public.temp0000292266 6 0 0 154,566 0 0 11,136 rio.public.temp0000292282 1 0 0 1,281 0 54 74 brasilia.public.temp0000240774 1 0 0 3,341 0 0 256 rio.public.temp0000292198 4 0 0 8,657 0 64 192 brasilia.public.temp0000240806 1 0 0 3,341 0 0 256 rio.public.temp0000292318 1 0 0 1,406 0 46 82 contagem.public.temp0000227280 2 0 0 2,777 0 40 216 rio.public.temp0000292296 2 0 0 27,116 0 51 1,933 rio.public.temp0000292298 9 0 0 30,017 0 339 813 contagem.public.temp0000227276 2 0 0 2,776 0 40 216 brasilia.public.temp0000240760 1 0 0 3,341 0 0 256 rio.public.temp0000290230 1 0 0 3,077 0 59 69 rio.public.temp0000292292 4 0 0 103,060 0 0 7,424 rio.public.temp0000292258 2 0 0 4,310 0 116 140 rio.public.temp0000291977 12 0 0 81,253 0 187 4,421 rio.public.temp0000292314 7 0 0 180,490 0 0 12,992 brasilia.public.temp0000240750 3 0 0 10,023 0 0 768 brasilia.public.temp0000240748 1 0 0 3,340 0 0 256 rio.public.temp0000292212 8 0 0 15,533 0 190 386 rio.public.temp0000292284 1 0 0 1,281 0 54 74 rio.public.temp0000292228 10 0 0 257,546 0 0 18,560 Total 411 210 410,316 7,224,856 48,135 4,001 325,146 Pages removed per table
Key values
- public.temp0000292268 (874) Main table with removed pages on database rio
- 4001 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292268 37 0 0 874 contagem.pg_catalog.pg_attribute 14 14 54177 475 rio.pg_catalog.pg_attribute 46 42 190550 381 rio.public.temp0000292298 9 0 0 339 rio.public.temp0000292056 11 0 0 314 rio.public.temp0000290026 10 0 0 221 rio.public.temp0000292212 8 0 0 190 rio.public.temp0000291977 12 0 0 187 rio.public.temp0000292258 2 0 0 116 rio.pg_catalog.pg_class 27 24 3513 75 brasilia.pg_catalog.pg_attribute 11 11 39975 68 rio.public.temp0000292198 4 0 0 64 rio.public.temp0000290230 1 0 0 59 rio.public.temp0000292288 1 0 0 54 rio.public.temp0000292282 1 0 0 54 rio.public.temp0000292284 1 0 0 54 rio.public.temp0000292296 2 0 0 51 rio.public.temp0000292318 1 0 0 46 rio.public.temp0000292230 1 0 0 43 contagem.pg_catalog.pg_type 6 6 2231 42 contagem.public.temp0000227280 2 0 0 40 contagem.public.temp0000227276 2 0 0 40 contagem.pg_catalog.pg_class 7 7 1072 37 contagem.pg_catalog.pg_depend 3 3 1157 34 brasilia.pg_catalog.pg_depend 2 2 1117 31 rio.pg_catalog.pg_type 23 20 7951 28 contagem.pg_catalog.pg_index 4 4 920 25 brasilia.pg_catalog.pg_type 4 4 949 23 rio.pg_catalog.pg_index 14 14 3275 13 brasilia.pg_catalog.pg_index 2 2 393 12 brasilia.pg_toast.pg_toast_2619 2 2 203 10 brasilia.pg_catalog.pg_class 5 5 1059 1 brasilia.public.temp0000240736 1 0 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 brasilia.public.temp0000240792 3 0 0 0 rio.public.tmp_drill_0302 2 2 25748 0 contagem.pg_toast.pg_toast_2619 2 2 189 0 brasilia.public.temp0000240758 1 0 0 0 rio.pg_catalog.pg_statistic 8 8 14339 0 rio.pg_catalog.pg_depend 12 12 8972 0 brasilia.public.temp0000240780 3 0 0 0 rio.public.temp0000292192 12 0 0 0 brasilia.public.temp0000240790 1 0 0 0 rio.public.temp0000292266 6 0 0 0 brasilia.public.temp0000240774 1 0 0 0 contagem.pg_catalog.pg_statistic 3 3 6289 0 brasilia.public.temp0000240806 1 0 0 0 rio.public.usuarios 6 4 744 0 brasilia.public.temp0000240760 1 0 0 0 rio.public.tmp_drill_0320 3 3 28734 0 rio.public.temp0000292292 4 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1226 0 brasilia.pg_catalog.pg_shdepend 7 7 6496 0 brasilia.pg_catalog.pg_statistic 5 5 7315 0 rio.public.temp0000292314 7 0 0 0 brasilia.public.temp0000240750 3 0 0 0 brasilia.public.temp0000240748 1 0 0 0 contagem.public.usuarios 28 0 1722 0 rio.public.temp0000292228 10 0 0 0 Total 411 210 410,316 4,001 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 23 00 1 0 01 0 0 02 0 0 03 0 1 04 0 0 05 6 0 06 0 0 07 7 14 08 26 105 09 28 117 10 87 160 11 38 138 12 15 59 13 19 47 14 56 131 15 31 80 16 56 124 17 33 86 18 1 0 19 0 0 20 0 0 21 6 5 22 1 0 23 0 0 - 5.86 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 3,554 Total read queries
- 1,064 Total write queries
Queries by database
Key values
- rio Main database
- 3,127 Requests
- 5h16m50s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,890 Requests
User Request type Count Duration etiquetas Total 44 16s402ms others 1 154ms select 43 16s248ms intelifix Total 4,890 7h9m32s copy to 401 41m22s ddl 661 40m36s others 422 44m50s select 3,406 5h2m43s lenon Total 107 1m25s ddl 2 652ms select 105 1m24s Duration by user
Key values
- 7h9m32s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 44 16s402ms others 1 154ms select 43 16s248ms intelifix Total 4,890 7h9m32s copy to 401 41m22s ddl 661 40m36s others 422 44m50s select 3,406 5h2m43s lenon Total 107 1m25s ddl 2 652ms select 105 1m24s Queries by host
Key values
- [local] Main host
- 5,036 Requests
- 7h11m10s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,003 Requests
- 3h36m42s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 4,003 2h53m ddl 661 40m36s others 1 154ms select 3,341 2h12m23s pgAdmin 4 - CONN:2011992 Total 1 262ms select 1 262ms pgAdmin 4 - CONN:3014750 Total 1 605ms select 1 605ms pgAdmin 4 - CONN:6983121 Total 3 3s414ms ddl 2 652ms select 1 2s762ms pg_dump Total 423 41m27s copy to 401 41m22s select 22 5s274ms psql Total 610 3h36m42s others 422 44m50s select 188 2h51m52s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-23 12:54:32 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,157 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m26s analyze verbose;[ Date: 2026-09-23 05:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-23 07:13:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m38s analyze verbose;[ Date: 2026-09-23 05:19:06 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030224, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 07:28:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-23 09:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-23 10:11:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-23 11:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030232, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 09:48:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030230, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 09:08:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-23 12:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030235, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 10:16:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030228, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 08:42:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030253, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 12:18:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030226, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 07:59:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-23 16:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030270, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 14:57:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030275, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 16:14:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030256, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 14:23:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030278, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 16:45:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030273, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-23 15:36:54 - 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 1h36m32s 48 2s162ms 8m52s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 07 3 9m51s 3m17s 08 3 5m20s 1m46s 09 3 7m34s 2m31s 10 3 7m1s 2m20s 11 3 7m14s 2m24s 12 3 6m2s 2m 13 3 5m20s 1m46s 14 3 5m22s 1m47s 15 3 5m27s 1m49s 16 3 5m41s 1m53s 17 3 5m28s 1m49s 18 3 5m14s 1m44s 19 3 5m10s 1m43s 20 3 5m21s 1m47s 21 3 5m9s 1m43s 22 3 5m12s 1m44s [ User: intelifix - Total duration: 1h36m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 07:13:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 09:11:41 Duration: 6m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 10:11:32 Duration: 6m31s Database: rio User: intelifix Remote: [local] Application: psql
2 1h24m34s 226 153ms 6m47s 22s453ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 07 19 12m30s 39s502ms 08 15 7m52s 31s500ms 09 20 12m38s 37s911ms 10 40 7m50s 11s758ms 11 22 1m15s 3s447ms 12 5 5m34s 1m6s 13 15 11s970ms 798ms 14 26 14m9s 32s659ms 15 22 5m27s 14s877ms 16 23 14m41s 38s315ms 17 19 2m23s 7s538ms [ User: intelifix - Total duration: 1h24m34s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h24m34s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030224, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 07:28:04 Duration: 6m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030232, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:48:25 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030230, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:08:48 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h7m 48 248ms 4m3s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 07 3 5m41s 1m53s 08 3 3m59s 1m19s 09 3 5m22s 1m47s 10 3 4m37s 1m32s 11 3 4m55s 1m38s 12 3 4m9s 1m23s 13 3 3m46s 1m15s 14 3 3m59s 1m19s 15 3 3m50s 1m16s 16 3 3m51s 1m17s 17 3 3m49s 1m16s 18 3 3m44s 1m14s 19 3 3m45s 1m15s 20 3 3m49s 1m16s 21 3 3m46s 1m15s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h7m - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 07:20:18 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 09:17:45 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 10:16:30 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
4 22m9s 3 3m4s 11m26s 7m23s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 05 3 22m9s 7m23s [ User: intelifix - Total duration: 22m9s - Times executed: 3 ]
[ Application: psql - Total duration: 22m9s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-23 05:11:27 Duration: 11m26s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-23 05:19:06 Duration: 7m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-23 05:22:10 Duration: 3m4s Database: contagem User: intelifix Remote: [local] Application: psql
5 17m28s 1,349 150ms 6s153ms 776ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 08 86 1m17s 898ms 09 180 2m49s 939ms 10 168 2m44s 978ms 11 167 1m51s 670ms 12 69 1m2s 899ms 13 41 25s540ms 622ms 14 175 2m8s 736ms 15 183 2m7s 697ms 16 198 2m10s 661ms 17 82 50s436ms 615ms [ User: intelifix - Total duration: 17m28s - Times executed: 1349 ]
[ Application: [unknown] - Total duration: 17m28s - Times executed: 1349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289631, 504, 'ZTE3ANNQ6M07887,C4EBFF891AAA,C4EBFF891AAB,ZTEGD709FFDD$ZTE3ANNR3J16120,F4E84F87C830,F4E84F87C831,ZTEGD97BA0C2$ZTE3ANNR3J30112,F4E84F891020,F4E84F891021,ZTEGD97BD76A$ZTE3ANNRCP61752,6C11BA6ED21F,6C11BA6ED220,ZTEGDC7031CB$ZTE3ANNQ7507178,C4EBFF8B9B78,C4EBFF8B9B79,ZTEGD70A6AAA$ZTE3ANNR1Y03471,14CA56CCFBD5,14CA56CCFBD6,ZTEGD97083EA$ZTE3ANNRAD30576,D89A0DB0A703,D89A0DB0A704,ZTEGDB17737B$ZTE3ANNR6R28194,48D68238198E,48D68238198F,ZTEGDB0198F5$ZTE3ANNR3Y03657,4896D950166E,4896D950166F,ZTEGD97E3EFE$ZTE3ANNR8C28476,38914851226F,389148512270,ZTEGDB08EFAC$ZTE3ANNR3Y51281,4896D954729E,4896D954729F,ZTEGD97EF906$ZTE3ANNQ7L04889,C4EBFF8DF73E,C4EBFF8DF73F,ZTEGD70ACF4B$ZTE3ANNR7B49250,3891484D6EF3,3891484D6EF4,ZTEGDB0851C2$ZTE3ANNRAD22214,D89A0DAFE307,D89A0DAFE308,ZTEGDB1752D1$ZTE3ANNQ4414801,3CF9F0ACB9C4,3CF9F0ACB9C5,ZTEGD641B454$ZTE3ANNQ7L04952,C4EBFF8DF8B8,C4EBFF8DF8B9,ZTEGD70ACF8A$ZTE3ANNR3Y51207,4896D95470E2,4896D95470E3,ZTEGD97EF8BC$ZTE3ANNT4P37099,F00C514F0C20,F00C514F0C21,ZTEGDE348781$ZTE3ANNR3J06202,F4E84F86DFBC,F4E84F86DFBD,ZTEGD97B7A04', '',0318,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-23 10:31:40 Duration: 6s153ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58943, 406, '835163924001114,241689192841,241676740313,241646412639,241607267886,230043554452,230043628601,241593401113,241659794663,241620902439,241698742224,241674457384,241614467691,241676736069,241622550625,241692230119,241708983549,241732164655,241704693860,241638230808,241673330317,241728705866,241728707280,241679337187,241698744850,241680362428,241783840002,241618648403,241659754558,241727443656,241659524659,241698668198,241668316886,241637700824,241647341630,241695563137,241713843552,241593342847,241646262041,241703980626,241650545365,241654562828,241727442646,241652392538,241691527591,241655922950,241727022223,230015833453,241593423640,241783851417,241727473232', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-23 10:52:19 Duration: 4s146ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289570, 450, '720196045257,6802B8154D35,B4F26757BB06,6802B8A56175,B4F2674EA7D0,6802B8F05E37,B4F267340AE4,6802B8F08F57,6802B8F8597C,6802B8A4E4EC,6802B86331FE,B4F2674E2BA7,6802B8F7DC36,6802B852335E,B4F2674E4E87,6802B8AC6B60,6802B8BF018A,6802B864C47F,6802B862EF26,6802B8632619,B4F26733E37E,B4F2670C150C,6802B8E03513,B4F2674E03FC,6802B823BD1C,6802B863AADC,B4F2674F6E93,B4F2670C2865,6802B8A0EEAD,B4F2675F3A4B,6802B8DEB750,B4F26757B929,6802B8DF5473,6802B8A2AD6B,6802B8F70D0C,6802B8A3BBF8,B4F2674DE87E,B4F2670C061E,6802B8DB7736,B4F2670BB46A,6802B8A0F306', '',0156,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-09-23 08:24:42 Duration: 3s767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 14m 103 1s356ms 1m26s 8s161ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 09 6 2m22s 23s759ms 10 6 2m9s 21s512ms 11 11 1m35s 8s638ms 12 5 10s56ms 2s11ms 13 5 58s114ms 11s622ms 14 10 59s742ms 5s974ms 15 8 45s764ms 5s720ms 16 21 2m34s 7s373ms 17 31 2m25s 4s693ms [ User: intelifix - Total duration: 14m - Times executed: 103 ]
[ Application: [unknown] - Total duration: 14m - Times executed: 103 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-23 09:20:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-23 10:24:40 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 0404, '', '', 0, 7, '2026-09-01');
Date: 2026-09-23 09:38:13 Duration: 20s977ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 9m3s 165 161ms 35s888ms 3s296ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 00 6 56s100ms 9s350ms 01 6 31s926ms 5s321ms 02 6 22s392ms 3s732ms 03 5 23s947ms 4s789ms 04 6 28s615ms 4s769ms 05 7 31s420ms 4s488ms 06 4 4s778ms 1s194ms 07 12 32s371ms 2s697ms 08 12 38s750ms 3s229ms 09 12 44s534ms 3s711ms 10 12 34s951ms 2s912ms 11 12 35s298ms 2s941ms 12 9 21s238ms 2s359ms 13 6 6s457ms 1s76ms 14 10 28s587ms 2s858ms 15 12 38s829ms 3s235ms 16 10 29s558ms 2s955ms 17 5 4s737ms 947ms 20 2 783ms 391ms 21 5 15s929ms 3s185ms 22 6 12s780ms 2s130ms [ User: intelifix - Total duration: 9m3s - Times executed: 165 ]
[ Application: psql - Total duration: 9m3s - Times executed: 165 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 00:05:37 Duration: 35s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 05:15:13 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 14:45:10 Duration: 9s560ms Database: rio User: intelifix Remote: [local] Application: psql
8 7m55s 753 150ms 4s557ms 631ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 07 4 5s585ms 1s396ms 08 86 59s216ms 688ms 09 103 1m11s 694ms 10 110 1m13s 670ms 11 68 48s872ms 718ms 12 37 22s505ms 608ms 13 59 33s477ms 567ms 14 76 51s259ms 674ms 15 103 56s979ms 553ms 16 85 40s742ms 479ms 17 22 11s425ms 519ms [ User: intelifix - Total duration: 7m55s - Times executed: 753 ]
[ Application: [unknown] - Total duration: 7m55s - Times executed: 753 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290037", "modelo" : "141", "itens" : "229688738601,229739933541,216944911633,229879898199,229809833438,229785222024,229779974452,229689232140,229808178103,229736579813,229663080710,229859361527,229674251228,229749990808,229752014361,229737954055,229805439192,229685126890,229780601113,229933607481,229782147896,229749188394,229670566580,216941616978,229740673950,229865212850,229687097385,229743395461", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246260153643,226330815858,226354873246,246652123143,246620891835,246599074868,246562355257,246518688088,246581684753,246476718101,246223755354,246056957695,246056480725,246532328500,226315890912,246527841519,246598196263,246498959205,246585471936,246501735974,246583785665,246548329095,246516701431,246530724157,246152824964,246649648401,246518780725,246526254248,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-23 11:08:10 Duration: 4s557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289722", "modelo" : "463", "itens" : "241757673340,241725761730,241794220510,241737880713,241782689091,241753677495,241720736480,241751083247,241722939703,241750308389,241780476777,241724129909,241750166176,241755993838,241748471320,241723107676,241794181920,241755819297,241749095151,241757883338,241719270816,241725784560,241753702122,241794388809,241794131635,241748196769,241784072325,241737926979,241718937191,241752109597,241720391419,241720912940,241757277487,241758302930,241755040525,241736892244,241750597284,241737900917,241758897286,241735040425,241722581027,241758236582,241724328895,241755621221,241780567493,241779547584,241750275558,241783254355,241721342129,241735318284,241721260606,241750123748,241720824547,241723989312,241754284659,241722929398,241758204862,241791348501,241754222431,241758234865", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-23 14:13:21 Duration: 4s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289737", "modelo" : "454", "itens" : "241625121313,241625086079,241632750812,241624617694,241626674158,241611087799,241640784951,241633167698,241600637991,241624604663,241625382225,241614252643,241625081938,241614440922,241611914255,241614416070,241614338991,241624685254,241612420018,241625500823,241625070826,241624955157,241633730111,241613731425,241625505065,241614428192,241612429614,241624608906,241625055470,241626673855,241626662743,241626621931,241612464466,241600432035,241625071129,241613240008,241634174856,241600692139,241614271029", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-23 07:58:07 Duration: 3s689ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7m39s 41 10s229ms 18s50ms 11s196ms create table temp0000292268 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 12 8 1m32s 11s590ms 14 16 2m53s 10s866ms 15 6 1m10s 11s686ms 16 11 2m2s 11s121ms [ User: intelifix - Total duration: 7m39s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 7m39s - Times executed: 41 ]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 12:11:56 Duration: 18s50ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 15:29:14 Duration: 15s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:15:32 Duration: 12s434ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m7s 34 8s450ms 56s422ms 12s562ms create table temp0000292192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 07 11 2m24s 13s122ms 08 6 1m3s 10s517ms 09 11 2m29s 13s635ms 10 6 1m9s 11s612ms [ User: intelifix - Total duration: 7m7s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 7m7s - Times executed: 34 ]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 07:17:46 Duration: 56s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 09:40:33 Duration: 55s345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:09:14 Duration: 22s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m57s 146 214ms 7s347ms 2s857ms call rs_giga_triagem (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 00 7 20s760ms 2s965ms 01 6 16s58ms 2s676ms 02 6 16s848ms 2s808ms 03 6 17s37ms 2s839ms 04 6 16s809ms 2s801ms 05 6 16s228ms 2s704ms 06 6 16s883ms 2s813ms 07 6 17s575ms 2s929ms 08 7 20s515ms 2s930ms 09 9 24s920ms 2s768ms 10 8 23s391ms 2s923ms 11 6 18s57ms 3s9ms 12 6 16s84ms 2s680ms 13 6 17s10ms 2s835ms 14 6 17s509ms 2s918ms 15 6 16s981ms 2s830ms 16 6 17s726ms 2s954ms 17 6 17s774ms 2s962ms 18 6 17s384ms 2s897ms 19 6 17s65ms 2s844ms 20 7 21s175ms 3s25ms 21 6 16s707ms 2s784ms 22 6 16s695ms 2s782ms [ User: intelifix - Total duration: 6m57s - Times executed: 146 ]
[ Application: psql - Total duration: 6m57s - Times executed: 146 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 10:15:14 Duration: 7s347ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 00:05:44 Duration: 7s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 09:25:12 Duration: 5s864ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m12s 33 179ms 39s572ms 7s645ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 07 2 35s795ms 17s897ms 08 1 27s124ms 27s124ms 09 2 51s231ms 25s615ms 10 13 1m22s 6s382ms 11 2 8s858ms 4s429ms 12 2 15s780ms 7s890ms 13 1 2s340ms 2s340ms 14 4 12s729ms 3s182ms 15 1 3s982ms 3s982ms 16 2 8s741ms 4s370ms 17 3 2s747ms 915ms [ User: intelifix - Total duration: 4m12s - Times executed: 33 ]
[ Application: psql - Total duration: 4m12s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030232);
Date: 2026-09-23 09:42:43 Duration: 39s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030224);
Date: 2026-09-23 07:21:22 Duration: 32s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030228);
Date: 2026-09-23 08:36:47 Duration: 27s124ms Database: rio User: intelifix Remote: [local] Application: psql
13 2m53s 16 10s310ms 11s183ms 10s830ms create table temp0000292298 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 14 16 2m53s 10s830ms [ User: intelifix - Total duration: 2m53s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 16 ]
-
CREATE TABLE temp0000292298 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:41:05 Duration: 11s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292298 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:38:18 Duration: 11s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292298 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:37:55 Duration: 11s110ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m51s 118 156ms 13s617ms 1s456ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 07 24 27s92ms 1s128ms 08 2 471ms 235ms 09 4 5s96ms 1s274ms 10 21 55s395ms 2s637ms 11 14 11s225ms 801ms 13 7 9s253ms 1s321ms 14 6 35s884ms 5s980ms 15 18 11s55ms 614ms 16 8 9s753ms 1s219ms 17 14 6s642ms 474ms [ User: intelifix - Total duration: 2m51s - Times executed: 118 ]
[ Application: [unknown] - Total duration: 2m51s - Times executed: 118 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-23 14:30:15 Duration: 13s617ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-23 10:19:52 Duration: 12s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-23 14:29:39 Duration: 12s553ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 2m46s 44 160ms 47s860ms 3s779ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 07 4 3s22ms 755ms 08 2 1s117ms 558ms 09 4 1s406ms 351ms 10 11 2m2s 11s154ms 11 3 3s49ms 1s16ms 12 3 1s28ms 342ms 14 8 22s744ms 2s843ms 15 2 660ms 330ms 16 5 8s697ms 1s739ms 17 2 1s858ms 929ms [ User: intelifix - Total duration: 2m46s - Times executed: 44 ]
[ Application: psql - Total duration: 2m46s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030237);
Date: 2026-09-23 10:18:30 Duration: 47s860ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030242);
Date: 2026-09-23 10:30:51 Duration: 26s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030244);
Date: 2026-09-23 10:38:47 Duration: 19s512ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m44s 11 10s724ms 53s595ms 14s971ms create table temp0000292266 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 11 11 2m44s 14s971ms [ User: intelifix - Total duration: 2m44s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 11 ]
-
CREATE TABLE temp0000292266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 11:41:39 Duration: 53s595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 11:42:53 Duration: 11s612ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 11:43:12 Duration: 11s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m16s 4 4s810ms 1m3s 34s185ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 20 2 1m7s 33s996ms 23 2 1m8s 34s375ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-23 23:16:33 Duration: 1m3s 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-09-23 20:08:36 Duration: 1m3s 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-09-23 23:33:36 Duration: 5s15ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m6s 32 588ms 11s282ms 3s950ms call rs_tcia_processa_lotes () / 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 (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 3 20s213ms 6s737ms 09 1 11s282ms 11s282ms 10 2 13s765ms 6s882ms 11 3 13s105ms 4s368ms 12 2 5s589ms 2s794ms 13 3 6s293ms 2s97ms 14 2 9s51ms 4s525ms 15 2 11s647ms 5s823ms 16 3 19s484ms 6s494ms 17 2 7s340ms 3s670ms 18 1 731ms 731ms 19 2 1s576ms 788ms 20 2 2s291ms 1s145ms 21 2 2s546ms 1s273ms 22 2 1s480ms 740ms [ User: intelifix - Total duration: 2m6s - Times executed: 32 ]
[ Application: psql - Total duration: 2m6s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-09-23 09:40:12 Duration: 11s282ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-09-23 16:40:12 Duration: 10s265ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-09-23 08:40:10 Duration: 8s819ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m52s 23 2s629ms 27s267ms 4s889ms create table temp0000292192 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 08 6 16s479ms 2s746ms 09 3 48s369ms 16s123ms 10 14 47s610ms 3s400ms [ User: intelifix - Total duration: 1m52s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 23 ]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-09-2026", "ate" :"23-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-23 09:19:00 Duration: 27s267ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-09-2026", "ate" :"23-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-23 09:59:51 Duration: 18s319ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-09-2026", "ate" :"23-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-23 10:17:19 Duration: 8s817ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m52s 12 8s631ms 11s254ms 9s367ms create table temp0000292228 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 10 12 1m52s 9s367ms [ User: intelifix - Total duration: 1m52s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 12 ]
-
CREATE TABLE temp0000292228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:58:02 Duration: 11s254ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:13:53 Duration: 10s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:30:34 Duration: 10s10ms 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,349 17m28s 150ms 6s153ms 776ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 86 1m17s 898ms 09 180 2m49s 939ms 10 168 2m44s 978ms 11 167 1m51s 670ms 12 69 1m2s 899ms 13 41 25s540ms 622ms 14 175 2m8s 736ms 15 183 2m7s 697ms 16 198 2m10s 661ms 17 82 50s436ms 615ms [ User: intelifix - Total duration: 17m28s - Times executed: 1349 ]
[ Application: [unknown] - Total duration: 17m28s - Times executed: 1349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289631, 504, 'ZTE3ANNQ6M07887,C4EBFF891AAA,C4EBFF891AAB,ZTEGD709FFDD$ZTE3ANNR3J16120,F4E84F87C830,F4E84F87C831,ZTEGD97BA0C2$ZTE3ANNR3J30112,F4E84F891020,F4E84F891021,ZTEGD97BD76A$ZTE3ANNRCP61752,6C11BA6ED21F,6C11BA6ED220,ZTEGDC7031CB$ZTE3ANNQ7507178,C4EBFF8B9B78,C4EBFF8B9B79,ZTEGD70A6AAA$ZTE3ANNR1Y03471,14CA56CCFBD5,14CA56CCFBD6,ZTEGD97083EA$ZTE3ANNRAD30576,D89A0DB0A703,D89A0DB0A704,ZTEGDB17737B$ZTE3ANNR6R28194,48D68238198E,48D68238198F,ZTEGDB0198F5$ZTE3ANNR3Y03657,4896D950166E,4896D950166F,ZTEGD97E3EFE$ZTE3ANNR8C28476,38914851226F,389148512270,ZTEGDB08EFAC$ZTE3ANNR3Y51281,4896D954729E,4896D954729F,ZTEGD97EF906$ZTE3ANNQ7L04889,C4EBFF8DF73E,C4EBFF8DF73F,ZTEGD70ACF4B$ZTE3ANNR7B49250,3891484D6EF3,3891484D6EF4,ZTEGDB0851C2$ZTE3ANNRAD22214,D89A0DAFE307,D89A0DAFE308,ZTEGDB1752D1$ZTE3ANNQ4414801,3CF9F0ACB9C4,3CF9F0ACB9C5,ZTEGD641B454$ZTE3ANNQ7L04952,C4EBFF8DF8B8,C4EBFF8DF8B9,ZTEGD70ACF8A$ZTE3ANNR3Y51207,4896D95470E2,4896D95470E3,ZTEGD97EF8BC$ZTE3ANNT4P37099,F00C514F0C20,F00C514F0C21,ZTEGDE348781$ZTE3ANNR3J06202,F4E84F86DFBC,F4E84F86DFBD,ZTEGD97B7A04', '',0318,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-23 10:31:40 Duration: 6s153ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58943, 406, '835163924001114,241689192841,241676740313,241646412639,241607267886,230043554452,230043628601,241593401113,241659794663,241620902439,241698742224,241674457384,241614467691,241676736069,241622550625,241692230119,241708983549,241732164655,241704693860,241638230808,241673330317,241728705866,241728707280,241679337187,241698744850,241680362428,241783840002,241618648403,241659754558,241727443656,241659524659,241698668198,241668316886,241637700824,241647341630,241695563137,241713843552,241593342847,241646262041,241703980626,241650545365,241654562828,241727442646,241652392538,241691527591,241655922950,241727022223,230015833453,241593423640,241783851417,241727473232', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-23 10:52:19 Duration: 4s146ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289570, 450, '720196045257,6802B8154D35,B4F26757BB06,6802B8A56175,B4F2674EA7D0,6802B8F05E37,B4F267340AE4,6802B8F08F57,6802B8F8597C,6802B8A4E4EC,6802B86331FE,B4F2674E2BA7,6802B8F7DC36,6802B852335E,B4F2674E4E87,6802B8AC6B60,6802B8BF018A,6802B864C47F,6802B862EF26,6802B8632619,B4F26733E37E,B4F2670C150C,6802B8E03513,B4F2674E03FC,6802B823BD1C,6802B863AADC,B4F2674F6E93,B4F2670C2865,6802B8A0EEAD,B4F2675F3A4B,6802B8DEB750,B4F26757B929,6802B8DF5473,6802B8A2AD6B,6802B8F70D0C,6802B8A3BBF8,B4F2674DE87E,B4F2670C061E,6802B8DB7736,B4F2670BB46A,6802B8A0F306', '',0156,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-09-23 08:24:42 Duration: 3s767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 753 7m55s 150ms 4s557ms 631ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 07 4 5s585ms 1s396ms 08 86 59s216ms 688ms 09 103 1m11s 694ms 10 110 1m13s 670ms 11 68 48s872ms 718ms 12 37 22s505ms 608ms 13 59 33s477ms 567ms 14 76 51s259ms 674ms 15 103 56s979ms 553ms 16 85 40s742ms 479ms 17 22 11s425ms 519ms [ User: intelifix - Total duration: 7m55s - Times executed: 753 ]
[ Application: [unknown] - Total duration: 7m55s - Times executed: 753 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290037", "modelo" : "141", "itens" : "229688738601,229739933541,216944911633,229879898199,229809833438,229785222024,229779974452,229689232140,229808178103,229736579813,229663080710,229859361527,229674251228,229749990808,229752014361,229737954055,229805439192,229685126890,229780601113,229933607481,229782147896,229749188394,229670566580,216941616978,229740673950,229865212850,229687097385,229743395461", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246260153643,226330815858,226354873246,246652123143,246620891835,246599074868,246562355257,246518688088,246581684753,246476718101,246223755354,246056957695,246056480725,246532328500,226315890912,246527841519,246598196263,246498959205,246585471936,246501735974,246583785665,246548329095,246516701431,246530724157,246152824964,246649648401,246518780725,246526254248,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-23 11:08:10 Duration: 4s557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289722", "modelo" : "463", "itens" : "241757673340,241725761730,241794220510,241737880713,241782689091,241753677495,241720736480,241751083247,241722939703,241750308389,241780476777,241724129909,241750166176,241755993838,241748471320,241723107676,241794181920,241755819297,241749095151,241757883338,241719270816,241725784560,241753702122,241794388809,241794131635,241748196769,241784072325,241737926979,241718937191,241752109597,241720391419,241720912940,241757277487,241758302930,241755040525,241736892244,241750597284,241737900917,241758897286,241735040425,241722581027,241758236582,241724328895,241755621221,241780567493,241779547584,241750275558,241783254355,241721342129,241735318284,241721260606,241750123748,241720824547,241723989312,241754284659,241722929398,241758204862,241791348501,241754222431,241758234865", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-23 14:13:21 Duration: 4s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289737", "modelo" : "454", "itens" : "241625121313,241625086079,241632750812,241624617694,241626674158,241611087799,241640784951,241633167698,241600637991,241624604663,241625382225,241614252643,241625081938,241614440922,241611914255,241614416070,241614338991,241624685254,241612420018,241625500823,241625070826,241624955157,241633730111,241613731425,241625505065,241614428192,241612429614,241624608906,241625055470,241626673855,241626662743,241626621931,241612464466,241600432035,241625071129,241613240008,241634174856,241600692139,241614271029", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-23 07:58:07 Duration: 3s689ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 226 1h24m34s 153ms 6m47s 22s453ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 07 19 12m30s 39s502ms 08 15 7m52s 31s500ms 09 20 12m38s 37s911ms 10 40 7m50s 11s758ms 11 22 1m15s 3s447ms 12 5 5m34s 1m6s 13 15 11s970ms 798ms 14 26 14m9s 32s659ms 15 22 5m27s 14s877ms 16 23 14m41s 38s315ms 17 19 2m23s 7s538ms [ User: intelifix - Total duration: 1h24m34s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h24m34s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030224, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 07:28:04 Duration: 6m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030232, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:48:25 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030230, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:08:48 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 165 9m3s 161ms 35s888ms 3s296ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 00 6 56s100ms 9s350ms 01 6 31s926ms 5s321ms 02 6 22s392ms 3s732ms 03 5 23s947ms 4s789ms 04 6 28s615ms 4s769ms 05 7 31s420ms 4s488ms 06 4 4s778ms 1s194ms 07 12 32s371ms 2s697ms 08 12 38s750ms 3s229ms 09 12 44s534ms 3s711ms 10 12 34s951ms 2s912ms 11 12 35s298ms 2s941ms 12 9 21s238ms 2s359ms 13 6 6s457ms 1s76ms 14 10 28s587ms 2s858ms 15 12 38s829ms 3s235ms 16 10 29s558ms 2s955ms 17 5 4s737ms 947ms 20 2 783ms 391ms 21 5 15s929ms 3s185ms 22 6 12s780ms 2s130ms [ User: intelifix - Total duration: 9m3s - Times executed: 165 ]
[ Application: psql - Total duration: 9m3s - Times executed: 165 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 00:05:37 Duration: 35s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 05:15:13 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 14:45:10 Duration: 9s560ms Database: rio User: intelifix Remote: [local] Application: psql
5 146 6m57s 214ms 7s347ms 2s857ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 00 7 20s760ms 2s965ms 01 6 16s58ms 2s676ms 02 6 16s848ms 2s808ms 03 6 17s37ms 2s839ms 04 6 16s809ms 2s801ms 05 6 16s228ms 2s704ms 06 6 16s883ms 2s813ms 07 6 17s575ms 2s929ms 08 7 20s515ms 2s930ms 09 9 24s920ms 2s768ms 10 8 23s391ms 2s923ms 11 6 18s57ms 3s9ms 12 6 16s84ms 2s680ms 13 6 17s10ms 2s835ms 14 6 17s509ms 2s918ms 15 6 16s981ms 2s830ms 16 6 17s726ms 2s954ms 17 6 17s774ms 2s962ms 18 6 17s384ms 2s897ms 19 6 17s65ms 2s844ms 20 7 21s175ms 3s25ms 21 6 16s707ms 2s784ms 22 6 16s695ms 2s782ms [ User: intelifix - Total duration: 6m57s - Times executed: 146 ]
[ Application: psql - Total duration: 6m57s - Times executed: 146 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 10:15:14 Duration: 7s347ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 00:05:44 Duration: 7s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 09:25:12 Duration: 5s864ms Database: rio User: intelifix Remote: [local] Application: psql
6 118 2m51s 156ms 13s617ms 1s456ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 07 24 27s92ms 1s128ms 08 2 471ms 235ms 09 4 5s96ms 1s274ms 10 21 55s395ms 2s637ms 11 14 11s225ms 801ms 13 7 9s253ms 1s321ms 14 6 35s884ms 5s980ms 15 18 11s55ms 614ms 16 8 9s753ms 1s219ms 17 14 6s642ms 474ms [ User: intelifix - Total duration: 2m51s - Times executed: 118 ]
[ Application: [unknown] - Total duration: 2m51s - Times executed: 118 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-23 14:30:15 Duration: 13s617ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-23 10:19:52 Duration: 12s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-23 14:29:39 Duration: 12s553ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 103 14m 1s356ms 1m26s 8s161ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 09 6 2m22s 23s759ms 10 6 2m9s 21s512ms 11 11 1m35s 8s638ms 12 5 10s56ms 2s11ms 13 5 58s114ms 11s622ms 14 10 59s742ms 5s974ms 15 8 45s764ms 5s720ms 16 21 2m34s 7s373ms 17 31 2m25s 4s693ms [ User: intelifix - Total duration: 14m - Times executed: 103 ]
[ Application: [unknown] - Total duration: 14m - Times executed: 103 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-23 09:20:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-23 10:24:40 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 0404, '', '', 0, 7, '2026-09-01');
Date: 2026-09-23 09:38:13 Duration: 20s977ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
8 96 30s57ms 296ms 390ms 313ms 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 #8
Day Hour Count Duration Avg duration Sep 23 02 1 318ms 318ms 03 1 325ms 325ms 06 2 601ms 300ms 07 6 1s891ms 315ms 08 10 3s246ms 324ms 09 11 3s435ms 312ms 10 7 2s199ms 314ms 11 9 2s826ms 314ms 12 7 2s177ms 311ms 13 7 2s150ms 307ms 14 8 2s520ms 315ms 15 11 3s403ms 309ms 16 8 2s478ms 309ms 17 7 2s170ms 310ms 20 1 310ms 310ms [ User: lenon - Total duration: 30s57ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 30s57ms - Times executed: 96 ]
-
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-09-23 08:39:12 Duration: 390ms 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-09-23 07:05:09 Duration: 357ms Database: brasilia 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-09-23 14:07:13 Duration: 357ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 88 34s598ms 328ms 771ms 393ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 03 1 394ms 394ms 06 1 460ms 460ms 07 4 1s529ms 382ms 08 8 3s359ms 419ms 09 11 4s773ms 433ms 10 7 2s933ms 419ms 11 9 3s292ms 365ms 12 7 2s584ms 369ms 13 7 2s913ms 416ms 14 8 3s25ms 378ms 15 11 3s950ms 359ms 16 8 3s156ms 394ms 17 6 2s224ms 370ms [ User: intelifix - Total duration: 34s598ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 34s598ms - Times executed: 88 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-09-23 13:03:13 Duration: 771ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-09-23 08:17:55 Duration: 731ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (184, 20, 1);
Date: 2026-09-23 09:56:10 Duration: 669ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 84 26s884ms 198ms 1s559ms 320ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 07 2 537ms 268ms 08 7 3s112ms 444ms 09 6 2s917ms 486ms 10 19 6s497ms 341ms 11 12 3s379ms 281ms 12 6 1s690ms 281ms 13 4 1s64ms 266ms 14 11 3s59ms 278ms 15 5 1s328ms 265ms 16 10 2s777ms 277ms 17 2 518ms 259ms [ User: intelifix - Total duration: 26s884ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 26s884ms - Times executed: 84 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-23 10:07:13 Duration: 1s559ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-23 09:38:44 Duration: 1s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-09-23 08:23:09 Duration: 1s498ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 81 24s20ms 152ms 784ms 296ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 07 2 754ms 377ms 08 10 3s17ms 301ms 09 14 4s513ms 322ms 10 12 3s141ms 261ms 11 9 2s903ms 322ms 12 9 3s381ms 375ms 13 1 317ms 317ms 14 16 4s262ms 266ms 15 6 1s300ms 216ms 16 2 429ms 214ms [ User: intelifix - Total duration: 24s20ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 24s20ms - Times executed: 81 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D89A0DA64FE3,D831399033C8,D831399BA674,3CF9F0ADABF8,6C11BA6C4C3B,D8313996869C,843C9933D32B,F4E84F844F10,F00C514D4348,D831399348D4,C4EBFF8C66D6,48D68237F060,689E29BD8301,D83139933950,3CF9F0ABDBB2,14CA56CE6747,843C992D8D71,3891484AA5C5,4896D95574F2,843C992C61B3,3891484B1D4D,689E29BD70B3,843C992C0777,843C991FBE93,D89A0D8509CB,D89A0DACB3D9,38914851BB09,6C11BA6BF3D3,D89A0DACA00B,5872C98F962D,843C9932E6A9,843C991FC391,3891484B1105,14CA56CD77E9,14CA56D01CF3,5872C993804B,3891484A8F15,F00C514F0488,6C11BA6BF4A5,843C99337307', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-23 12:28:43 Duration: 784ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (430, 5, 2, 28, '743AEF739005,840112E14D4D,743AEFC4C225,743AEFDC35EC,840112E15D14,840112E1174C,9877E7BBFE54,840112982B48,9877E700B3EB,1834AF253440,840112296204,743AEFC4FDDD,9877E77DD9A6,9877E7B8FFC6,8401129846BC,9877E7BC09F3,840112BFE542,840112961B5B,8401122990CD,84011229154A,9877E7BE8667,9877E70ADCD3,743AEF30D122,840112DD0F5F,84011293A037,743AEF963707,9877E77C43E5,1834AF25A72D,743AEFDBCBD4,9877E7094BF7,840112604800,743AEF740C84,743AEF9A69E6,1834AF254A82,743AEF6018FD,1834AF248ED9,743AEF70FD64,840112605FA0,743AEF6004BE,840112291BDA,840112BEFFFB,1834AF9BB39B,9877E70316F8,9877E709CC7B,1834AF257696,840112C2221C,840112982686,743AEFAF39F0', '','DEFAULT',00,0153,'', '','', 00);
Date: 2026-09-23 11:42:03 Duration: 699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'E44E12B25C31,14200452FC46,E44E12B20E31,14200452D88A,DC5193D9D9BA,7C7D21F0BE97,E44E12B294A5,7C7D21F0A893,DC5193DA899E,DC5193DA205A,14200454F7E6,142004570722,DC5193DBFD26,DC5193D95FDE,38165A47E39C,DC5193DAEAD6,7C7D21F1FF8B,E44E12937AC3,DC5193DAA1AA', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-09-23 14:38:36 Duration: 612ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 80 19s468ms 150ms 2s10ms 243ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 02 1 508ms 508ms 03 1 228ms 228ms 06 1 566ms 566ms 07 10 1s956ms 195ms 08 9 1s877ms 208ms 09 12 2s511ms 209ms 10 20 4s390ms 219ms 11 1 301ms 301ms 12 1 277ms 277ms 14 7 1s181ms 168ms 15 9 1s734ms 192ms 16 4 870ms 217ms 17 2 414ms 207ms 21 1 639ms 639ms 23 1 2s10ms 2s10ms [ User: intelifix - Total duration: 19s468ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 19s468ms - Times executed: 80 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241682379617');
Date: 2026-09-23 23:15:53 Duration: 2s10ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241711579616');
Date: 2026-09-23 21:02:08 Duration: 639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('175118942036');
Date: 2026-09-23 10:06:10 Duration: 597ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 69 19s274ms 150ms 1s95ms 279ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 07 6 1s455ms 242ms 08 7 1s279ms 182ms 09 10 2s198ms 219ms 10 3 1s602ms 534ms 11 11 3s718ms 338ms 12 7 2s26ms 289ms 14 3 713ms 237ms 15 11 3s418ms 310ms 16 11 2s861ms 260ms [ User: intelifix - Total duration: 19s274ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 19s274ms - Times executed: 69 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '87', 2, '743AEF5FD606,9877E74B40D0,1834AF99620E,9877E70C81C1,743AEFDA1C95,743AEF5FC1CA,743AEFDC41AE,743AEFAEDDFB,840112DD81D5,743AEFD95DC0,743AEF9C06FB,1834AF249AEF,9877E7BD452B,840112829D43,840112DD44F0,1834AF25B891,9877E707CE7E,8401129471DC', NULL, NULL, 0153, 00);
Date: 2026-09-23 10:14:14 Duration: 1s95ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'B85E71E2F1BC,08A7C04DA4EC,8C6A8DC0B4E4,08A7C077EC7C,ECA81F1FA564,08A7C07B98E4,484BD4B4968C,B85E71C25010,B85E710D6A28,E4BFFAF43934,08A7C078FE9C,C4509CE87564,B85E710CCC80,B85E71C731C0,B85E71E180D4,08A7C07A31A4', NULL, NULL, 0185, 00);
Date: 2026-09-23 11:56:13 Duration: 908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '241607911923,241614796870,241636006976,241700886978,241629418297,241663199305,241691240213,241652143344,230049039498,241629197894,241629810817,241635183855', NULL, NULL, 0320, 00);
Date: 2026-09-23 16:19:45 Duration: 708ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 56 1m34s 567ms 28s81ms 1s695ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 3 2s418ms 806ms 09 5 5s709ms 1s141ms 10 4 6s397ms 1s599ms 11 3 9s199ms 3s66ms 12 4 4s597ms 1s149ms 13 3 2s101ms 700ms 14 4 6s228ms 1s557ms 15 3 5s260ms 1s753ms 16 3 2s256ms 752ms 17 4 6s588ms 1s647ms 18 4 30s241ms 7s560ms 19 4 3s202ms 800ms 20 4 3s220ms 805ms 21 4 3s335ms 833ms 22 4 4s210ms 1s52ms [ User: intelifix - Total duration: 1m34s - Times executed: 56 ]
[ Application: psql - Total duration: 1m34s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-23 18:00:30 Duration: 28s81ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-23 11:00:11 Duration: 7s817ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-23 17:00:05 Duration: 4s431ms Database: rio User: intelifix Remote: [local] Application: psql
15 48 1h36m32s 2s162ms 8m52s 2m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 07 3 9m51s 3m17s 08 3 5m20s 1m46s 09 3 7m34s 2m31s 10 3 7m1s 2m20s 11 3 7m14s 2m24s 12 3 6m2s 2m 13 3 5m20s 1m46s 14 3 5m22s 1m47s 15 3 5m27s 1m49s 16 3 5m41s 1m53s 17 3 5m28s 1m49s 18 3 5m14s 1m44s 19 3 5m10s 1m43s 20 3 5m21s 1m47s 21 3 5m9s 1m43s 22 3 5m12s 1m44s [ User: intelifix - Total duration: 1h36m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 07:13:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 09:11:41 Duration: 6m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 10:11:32 Duration: 6m31s Database: rio User: intelifix Remote: [local] Application: psql
16 48 1h7m 248ms 4m3s 1m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 07 3 5m41s 1m53s 08 3 3m59s 1m19s 09 3 5m22s 1m47s 10 3 4m37s 1m32s 11 3 4m55s 1m38s 12 3 4m9s 1m23s 13 3 3m46s 1m15s 14 3 3m59s 1m19s 15 3 3m50s 1m16s 16 3 3m51s 1m17s 17 3 3m49s 1m16s 18 3 3m44s 1m14s 19 3 3m45s 1m15s 20 3 3m49s 1m16s 21 3 3m46s 1m15s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h7m - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 07:20:18 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 09:17:45 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 10:16:30 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
17 44 2m46s 160ms 47s860ms 3s779ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 07 4 3s22ms 755ms 08 2 1s117ms 558ms 09 4 1s406ms 351ms 10 11 2m2s 11s154ms 11 3 3s49ms 1s16ms 12 3 1s28ms 342ms 14 8 22s744ms 2s843ms 15 2 660ms 330ms 16 5 8s697ms 1s739ms 17 2 1s858ms 929ms [ User: intelifix - Total duration: 2m46s - Times executed: 44 ]
[ Application: psql - Total duration: 2m46s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030237);
Date: 2026-09-23 10:18:30 Duration: 47s860ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030242);
Date: 2026-09-23 10:30:51 Duration: 26s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030244);
Date: 2026-09-23 10:38:47 Duration: 19s512ms Database: rio User: intelifix Remote: [local] Application: psql
18 44 18s173ms 150ms 2s518ms 413ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 07 1 308ms 308ms 09 6 3s76ms 512ms 10 2 2s668ms 1s334ms 11 1 340ms 340ms 12 10 4s611ms 461ms 13 2 484ms 242ms 14 3 694ms 231ms 15 3 714ms 238ms 16 13 4s635ms 356ms 17 3 639ms 213ms [ User: intelifix - Total duration: 18s173ms - Times executed: 44 ]
[ Application: [unknown] - Total duration: 18s173ms - Times executed: 44 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-09-23", "data-ate" : "2026-09-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-09-23 10:07:05 Duration: 2s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-09-22", "data-ate" : "2026-09-22", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-09-23 09:54:48 Duration: 1s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-09-23", "data-ate" : "2026-09-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-09-23 12:16:40 Duration: 806ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 41 7m39s 10s229ms 18s50ms 11s196ms create table temp0000292268 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 12 8 1m32s 11s590ms 14 16 2m53s 10s866ms 15 6 1m10s 11s686ms 16 11 2m2s 11s121ms [ User: intelifix - Total duration: 7m39s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 7m39s - Times executed: 41 ]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 12:11:56 Duration: 18s50ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 15:29:14 Duration: 15s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:15:32 Duration: 12s434ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 34 7m7s 8s450ms 56s422ms 12s562ms create table temp0000292192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 07 11 2m24s 13s122ms 08 6 1m3s 10s517ms 09 11 2m29s 13s635ms 10 6 1m9s 11s612ms [ User: intelifix - Total duration: 7m7s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 7m7s - Times executed: 34 ]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 07:17:46 Duration: 56s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 09:40:33 Duration: 55s345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:09:14 Duration: 22s803ms 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 3m4s 11m26s 7m23s 3 22m9s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 05 3 22m9s 7m23s [ User: intelifix - Total duration: 22m9s - Times executed: 3 ]
[ Application: psql - Total duration: 22m9s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-23 05:11:27 Duration: 11m26s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-23 05:19:06 Duration: 7m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-23 05:22:10 Duration: 3m4s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s162ms 8m52s 2m 48 1h36m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 07 3 9m51s 3m17s 08 3 5m20s 1m46s 09 3 7m34s 2m31s 10 3 7m1s 2m20s 11 3 7m14s 2m24s 12 3 6m2s 2m 13 3 5m20s 1m46s 14 3 5m22s 1m47s 15 3 5m27s 1m49s 16 3 5m41s 1m53s 17 3 5m28s 1m49s 18 3 5m14s 1m44s 19 3 5m10s 1m43s 20 3 5m21s 1m47s 21 3 5m9s 1m43s 22 3 5m12s 1m44s [ User: intelifix - Total duration: 1h36m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 07:13:54 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 09:11:41 Duration: 6m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-23 10:11:32 Duration: 6m31s Database: rio User: intelifix Remote: [local] Application: psql
3 248ms 4m3s 1m23s 48 1h7m select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 07 3 5m41s 1m53s 08 3 3m59s 1m19s 09 3 5m22s 1m47s 10 3 4m37s 1m32s 11 3 4m55s 1m38s 12 3 4m9s 1m23s 13 3 3m46s 1m15s 14 3 3m59s 1m19s 15 3 3m50s 1m16s 16 3 3m51s 1m17s 17 3 3m49s 1m16s 18 3 3m44s 1m14s 19 3 3m45s 1m15s 20 3 3m49s 1m16s 21 3 3m46s 1m15s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h7m - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 07:20:18 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 09:17:45 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-23 10:16:30 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s810ms 1m3s 34s185ms 4 2m16s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 20 2 1m7s 33s996ms 23 2 1m8s 34s375ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-23 23:16:33 Duration: 1m3s 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-09-23 20:08:36 Duration: 1m3s 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-09-23 23:33:36 Duration: 5s15ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 153ms 6m47s 22s453ms 226 1h24m34s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 07 19 12m30s 39s502ms 08 15 7m52s 31s500ms 09 20 12m38s 37s911ms 10 40 7m50s 11s758ms 11 22 1m15s 3s447ms 12 5 5m34s 1m6s 13 15 11s970ms 798ms 14 26 14m9s 32s659ms 15 22 5m27s 14s877ms 16 23 14m41s 38s315ms 17 19 2m23s 7s538ms [ User: intelifix - Total duration: 1h24m34s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h24m34s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030224, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 07:28:04 Duration: 6m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030232, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:48:25 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030230, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-23 09:08:48 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10s724ms 53s595ms 14s971ms 11 2m44s create table temp0000292266 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 11 11 2m44s 14s971ms [ User: intelifix - Total duration: 2m44s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 11 ]
-
CREATE TABLE temp0000292266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 11:41:39 Duration: 53s595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 11:42:53 Duration: 11s612ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 11:43:12 Duration: 11s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 8s450ms 56s422ms 12s562ms 34 7m7s create table temp0000292192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 07 11 2m24s 13s122ms 08 6 1m3s 10s517ms 09 11 2m29s 13s635ms 10 6 1m9s 11s612ms [ User: intelifix - Total duration: 7m7s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 7m7s - Times executed: 34 ]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 07:17:46 Duration: 56s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 09:40:33 Duration: 55s345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:09:14 Duration: 22s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s229ms 18s50ms 11s196ms 41 7m39s create table temp0000292268 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 12 8 1m32s 11s590ms 14 16 2m53s 10s866ms 15 6 1m10s 11s686ms 16 11 2m2s 11s121ms [ User: intelifix - Total duration: 7m39s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 7m39s - Times executed: 41 ]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 12:11:56 Duration: 18s50ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 15:29:14 Duration: 15s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:15:32 Duration: 12s434ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s310ms 11s183ms 10s830ms 16 2m53s create table temp0000292298 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 14 16 2m53s 10s830ms [ User: intelifix - Total duration: 2m53s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 16 ]
-
CREATE TABLE temp0000292298 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:41:05 Duration: 11s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292298 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:38:18 Duration: 11s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292298 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 14:37:55 Duration: 11s110ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s631ms 11s254ms 9s367ms 12 1m52s create table temp0000292228 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 10 12 1m52s 9s367ms [ User: intelifix - Total duration: 1m52s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 12 ]
-
CREATE TABLE temp0000292228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:58:02 Duration: 11s254ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:13:53 Duration: 10s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-23 10:30:34 Duration: 10s10ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 1s356ms 1m26s 8s161ms 103 14m select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 09 6 2m22s 23s759ms 10 6 2m9s 21s512ms 11 11 1m35s 8s638ms 12 5 10s56ms 2s11ms 13 5 58s114ms 11s622ms 14 10 59s742ms 5s974ms 15 8 45s764ms 5s720ms 16 21 2m34s 7s373ms 17 31 2m25s 4s693ms [ User: intelifix - Total duration: 14m - Times executed: 103 ]
[ Application: [unknown] - Total duration: 14m - Times executed: 103 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-23 09:20:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-23 10:24:40 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 0404, '', '', 0, 7, '2026-09-01');
Date: 2026-09-23 09:38:13 Duration: 20s977ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 179ms 39s572ms 7s645ms 33 4m12s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 07 2 35s795ms 17s897ms 08 1 27s124ms 27s124ms 09 2 51s231ms 25s615ms 10 13 1m22s 6s382ms 11 2 8s858ms 4s429ms 12 2 15s780ms 7s890ms 13 1 2s340ms 2s340ms 14 4 12s729ms 3s182ms 15 1 3s982ms 3s982ms 16 2 8s741ms 4s370ms 17 3 2s747ms 915ms [ User: intelifix - Total duration: 4m12s - Times executed: 33 ]
[ Application: psql - Total duration: 4m12s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030232);
Date: 2026-09-23 09:42:43 Duration: 39s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030224);
Date: 2026-09-23 07:21:22 Duration: 32s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030228);
Date: 2026-09-23 08:36:47 Duration: 27s124ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s629ms 27s267ms 4s889ms 23 1m52s create table temp0000292192 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 6 16s479ms 2s746ms 09 3 48s369ms 16s123ms 10 14 47s610ms 3s400ms [ User: intelifix - Total duration: 1m52s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 23 ]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-09-2026", "ate" :"23-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-23 09:19:00 Duration: 27s267ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-09-2026", "ate" :"23-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-23 09:59:51 Duration: 18s319ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292192 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-09-2026", "ate" :"23-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-23 10:17:19 Duration: 8s817ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 588ms 11s282ms 3s950ms 32 2m6s call rs_tcia_processa_lotes () / 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 (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 3 20s213ms 6s737ms 09 1 11s282ms 11s282ms 10 2 13s765ms 6s882ms 11 3 13s105ms 4s368ms 12 2 5s589ms 2s794ms 13 3 6s293ms 2s97ms 14 2 9s51ms 4s525ms 15 2 11s647ms 5s823ms 16 3 19s484ms 6s494ms 17 2 7s340ms 3s670ms 18 1 731ms 731ms 19 2 1s576ms 788ms 20 2 2s291ms 1s145ms 21 2 2s546ms 1s273ms 22 2 1s480ms 740ms [ User: intelifix - Total duration: 2m6s - Times executed: 32 ]
[ Application: psql - Total duration: 2m6s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-09-23 09:40:12 Duration: 11s282ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-09-23 16:40:12 Duration: 10s265ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-09-23 08:40:10 Duration: 8s819ms Database: rio User: intelifix Remote: [local] Application: psql
15 160ms 47s860ms 3s779ms 44 2m46s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 07 4 3s22ms 755ms 08 2 1s117ms 558ms 09 4 1s406ms 351ms 10 11 2m2s 11s154ms 11 3 3s49ms 1s16ms 12 3 1s28ms 342ms 14 8 22s744ms 2s843ms 15 2 660ms 330ms 16 5 8s697ms 1s739ms 17 2 1s858ms 929ms [ User: intelifix - Total duration: 2m46s - Times executed: 44 ]
[ Application: psql - Total duration: 2m46s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030237);
Date: 2026-09-23 10:18:30 Duration: 47s860ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030242);
Date: 2026-09-23 10:30:51 Duration: 26s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030244);
Date: 2026-09-23 10:38:47 Duration: 19s512ms Database: rio User: intelifix Remote: [local] Application: psql
16 161ms 35s888ms 3s296ms 165 9m3s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 00 6 56s100ms 9s350ms 01 6 31s926ms 5s321ms 02 6 22s392ms 3s732ms 03 5 23s947ms 4s789ms 04 6 28s615ms 4s769ms 05 7 31s420ms 4s488ms 06 4 4s778ms 1s194ms 07 12 32s371ms 2s697ms 08 12 38s750ms 3s229ms 09 12 44s534ms 3s711ms 10 12 34s951ms 2s912ms 11 12 35s298ms 2s941ms 12 9 21s238ms 2s359ms 13 6 6s457ms 1s76ms 14 10 28s587ms 2s858ms 15 12 38s829ms 3s235ms 16 10 29s558ms 2s955ms 17 5 4s737ms 947ms 20 2 783ms 391ms 21 5 15s929ms 3s185ms 22 6 12s780ms 2s130ms [ User: intelifix - Total duration: 9m3s - Times executed: 165 ]
[ Application: psql - Total duration: 9m3s - Times executed: 165 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 00:05:37 Duration: 35s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 05:15:13 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-23 14:45:10 Duration: 9s560ms Database: rio User: intelifix Remote: [local] Application: psql
17 214ms 7s347ms 2s857ms 146 6m57s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 00 7 20s760ms 2s965ms 01 6 16s58ms 2s676ms 02 6 16s848ms 2s808ms 03 6 17s37ms 2s839ms 04 6 16s809ms 2s801ms 05 6 16s228ms 2s704ms 06 6 16s883ms 2s813ms 07 6 17s575ms 2s929ms 08 7 20s515ms 2s930ms 09 9 24s920ms 2s768ms 10 8 23s391ms 2s923ms 11 6 18s57ms 3s9ms 12 6 16s84ms 2s680ms 13 6 17s10ms 2s835ms 14 6 17s509ms 2s918ms 15 6 16s981ms 2s830ms 16 6 17s726ms 2s954ms 17 6 17s774ms 2s962ms 18 6 17s384ms 2s897ms 19 6 17s65ms 2s844ms 20 7 21s175ms 3s25ms 21 6 16s707ms 2s784ms 22 6 16s695ms 2s782ms [ User: intelifix - Total duration: 6m57s - Times executed: 146 ]
[ Application: psql - Total duration: 6m57s - Times executed: 146 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 10:15:14 Duration: 7s347ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 00:05:44 Duration: 7s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-23 09:25:12 Duration: 5s864ms Database: rio User: intelifix Remote: [local] Application: psql
18 567ms 28s81ms 1s695ms 56 1m34s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 3 2s418ms 806ms 09 5 5s709ms 1s141ms 10 4 6s397ms 1s599ms 11 3 9s199ms 3s66ms 12 4 4s597ms 1s149ms 13 3 2s101ms 700ms 14 4 6s228ms 1s557ms 15 3 5s260ms 1s753ms 16 3 2s256ms 752ms 17 4 6s588ms 1s647ms 18 4 30s241ms 7s560ms 19 4 3s202ms 800ms 20 4 3s220ms 805ms 21 4 3s335ms 833ms 22 4 4s210ms 1s52ms [ User: intelifix - Total duration: 1m34s - Times executed: 56 ]
[ Application: psql - Total duration: 1m34s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-23 18:00:30 Duration: 28s81ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-23 11:00:11 Duration: 7s817ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-23 17:00:05 Duration: 4s431ms Database: rio User: intelifix Remote: [local] Application: psql
19 156ms 13s617ms 1s456ms 118 2m51s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 07 24 27s92ms 1s128ms 08 2 471ms 235ms 09 4 5s96ms 1s274ms 10 21 55s395ms 2s637ms 11 14 11s225ms 801ms 13 7 9s253ms 1s321ms 14 6 35s884ms 5s980ms 15 18 11s55ms 614ms 16 8 9s753ms 1s219ms 17 14 6s642ms 474ms [ User: intelifix - Total duration: 2m51s - Times executed: 118 ]
[ Application: [unknown] - Total duration: 2m51s - Times executed: 118 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-23 14:30:15 Duration: 13s617ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-23 10:19:52 Duration: 12s684ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-23 14:29:39 Duration: 12s553ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 150ms 6s153ms 776ms 1,349 17m28s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 86 1m17s 898ms 09 180 2m49s 939ms 10 168 2m44s 978ms 11 167 1m51s 670ms 12 69 1m2s 899ms 13 41 25s540ms 622ms 14 175 2m8s 736ms 15 183 2m7s 697ms 16 198 2m10s 661ms 17 82 50s436ms 615ms [ User: intelifix - Total duration: 17m28s - Times executed: 1349 ]
[ Application: [unknown] - Total duration: 17m28s - Times executed: 1349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289631, 504, 'ZTE3ANNQ6M07887,C4EBFF891AAA,C4EBFF891AAB,ZTEGD709FFDD$ZTE3ANNR3J16120,F4E84F87C830,F4E84F87C831,ZTEGD97BA0C2$ZTE3ANNR3J30112,F4E84F891020,F4E84F891021,ZTEGD97BD76A$ZTE3ANNRCP61752,6C11BA6ED21F,6C11BA6ED220,ZTEGDC7031CB$ZTE3ANNQ7507178,C4EBFF8B9B78,C4EBFF8B9B79,ZTEGD70A6AAA$ZTE3ANNR1Y03471,14CA56CCFBD5,14CA56CCFBD6,ZTEGD97083EA$ZTE3ANNRAD30576,D89A0DB0A703,D89A0DB0A704,ZTEGDB17737B$ZTE3ANNR6R28194,48D68238198E,48D68238198F,ZTEGDB0198F5$ZTE3ANNR3Y03657,4896D950166E,4896D950166F,ZTEGD97E3EFE$ZTE3ANNR8C28476,38914851226F,389148512270,ZTEGDB08EFAC$ZTE3ANNR3Y51281,4896D954729E,4896D954729F,ZTEGD97EF906$ZTE3ANNQ7L04889,C4EBFF8DF73E,C4EBFF8DF73F,ZTEGD70ACF4B$ZTE3ANNR7B49250,3891484D6EF3,3891484D6EF4,ZTEGDB0851C2$ZTE3ANNRAD22214,D89A0DAFE307,D89A0DAFE308,ZTEGDB1752D1$ZTE3ANNQ4414801,3CF9F0ACB9C4,3CF9F0ACB9C5,ZTEGD641B454$ZTE3ANNQ7L04952,C4EBFF8DF8B8,C4EBFF8DF8B9,ZTEGD70ACF8A$ZTE3ANNR3Y51207,4896D95470E2,4896D95470E3,ZTEGD97EF8BC$ZTE3ANNT4P37099,F00C514F0C20,F00C514F0C21,ZTEGDE348781$ZTE3ANNR3J06202,F4E84F86DFBC,F4E84F86DFBD,ZTEGD97B7A04', '',0318,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-23 10:31:40 Duration: 6s153ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58943, 406, '835163924001114,241689192841,241676740313,241646412639,241607267886,230043554452,230043628601,241593401113,241659794663,241620902439,241698742224,241674457384,241614467691,241676736069,241622550625,241692230119,241708983549,241732164655,241704693860,241638230808,241673330317,241728705866,241728707280,241679337187,241698744850,241680362428,241783840002,241618648403,241659754558,241727443656,241659524659,241698668198,241668316886,241637700824,241647341630,241695563137,241713843552,241593342847,241646262041,241703980626,241650545365,241654562828,241727442646,241652392538,241691527591,241655922950,241727022223,230015833453,241593423640,241783851417,241727473232', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-23 10:52:19 Duration: 4s146ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289570, 450, '720196045257,6802B8154D35,B4F26757BB06,6802B8A56175,B4F2674EA7D0,6802B8F05E37,B4F267340AE4,6802B8F08F57,6802B8F8597C,6802B8A4E4EC,6802B86331FE,B4F2674E2BA7,6802B8F7DC36,6802B852335E,B4F2674E4E87,6802B8AC6B60,6802B8BF018A,6802B864C47F,6802B862EF26,6802B8632619,B4F26733E37E,B4F2670C150C,6802B8E03513,B4F2674E03FC,6802B823BD1C,6802B863AADC,B4F2674F6E93,B4F2670C2865,6802B8A0EEAD,B4F2675F3A4B,6802B8DEB750,B4F26757B929,6802B8DF5473,6802B8A2AD6B,6802B8F70D0C,6802B8A3BBF8,B4F2674DE87E,B4F2670C061E,6802B8DB7736,B4F2670BB46A,6802B8A0F306', '',0156,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-09-23 08:24:42 Duration: 3s767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 23 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 6m37s - Times executed: 4 ]
[ Application: psql - Total duration: 6m37s - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,949 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 22 FATAL entries
- 4568 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,440 Max number of times the same event was reported
- 4,591 Total events found
Rank Times reported Error 1 4,440 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 23 00 60 01 59 02 60 03 54 04 60 05 60 06 61 07 243 08 371 09 435 10 576 11 363 12 188 13 186 14 381 15 427 16 330 17 179 18 59 19 60 20 60 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029AE7560" does not exist
- ERROR: prepared statement "_PLAN0000000029AE7560" does not exist
- ERROR: prepared statement "_PLAN0000000029BCD480" does not exist
Statement: DEALLOCATE "_PLAN0000000029AE7560"
Date: 2026-09-23 00:00:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029AE7560"
Date: 2026-09-23 00:01:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029BCD480"
Date: 2026-09-23 00:02:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 103 ERROR: cache lookup failed for type 359009
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 23 10 103 - ERROR: cache lookup failed for type 359009
- ERROR: cache lookup failed for type 359009
- ERROR: cache lookup failed for type 359009
Context: PL/pgSQL assignment "cSenha := RS_EQUIPAMENTO_SENHA( cBarra )" PL/pgSQL function rs_etiqueta(character varying,integer,boolean) line 164 at assignment PL/pgSQL function rs_etiqueta(character varying) line 36 at FOR over SELECT rows
Statement: SELECT * FROM RS_ETIQUETA('E8D2FF966310')Date: 2026-09-23 10:00:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Context: PL/pgSQL assignment "cSenha := RS_EQUIPAMENTO_SENHA( cBarra )" PL/pgSQL function rs_etiqueta(character varying,integer,boolean) line 164 at assignment PL/pgSQL function rs_etiqueta(character varying) line 36 at FOR over SELECT rows
Statement: SELECT * FROM RS_ETIQUETA('E8D2FF966310')Date: 2026-09-23 10:00:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Context: PL/pgSQL assignment "cSenha := RS_EQUIPAMENTO_SENHA( cBarra )" PL/pgSQL function rs_etiqueta(character varying,integer,boolean) line 164 at assignment PL/pgSQL function rs_etiqueta(character varying) line 36 at FOR over SELECT rows
Statement: SELECT * FROM RS_ETIQUETA('E8D2FF966310')Date: 2026-09-23 10:00:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
3 11 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 23 03 11 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-23 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-23 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-23 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 23 00 1 06 2 08 1 09 2 10 1 16 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-23 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-23 06:02:26 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-23 06:53:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 5 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 23 07 1 11 1 14 1 17 2 - ERROR: syntax error at or near "E44E12937F67" at character 41
- ERROR: syntax error at or near "-" at character 1440
- ERROR: syntax error at or near ""},{"" at character 81
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''E44E12937F67');
Date: 2026-09-23 07:26:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: CREATE OR REPLACE FUNCTION RS_PARAMETROS_LISTA( cNome VARCHAR, nUser INTEGER DEFAULT NULL ) RETURNS SETOF RS_T_PARAMETRO AS $BODY$ /* ==================================================================================================== ROTINA : RS_PARAMETROS_LISTA AUTOR : LENILDO BARBOZA DATA : 11/MAR/2012 OBJETIVO : LISTA OS PARÂMETROS DO SISTEMA ==================================================================================================== DATA USUARIO ALTERAÇÃO ----------- --------------- ---------- 11/MAR/2012 LENILDO BARBOZA IMPLANTAÇÃO 24/JAN/2022 LENILDO BARBOZA SELEÇÃO DE PARÂMETROS DE ACORDO COM USU_PARAMETROS ==================================================================================================== */ DECLARE cRoutine VARCHAR := 'RS_PARAMETROS_LISTA'; cLine VARCHAR := LPAD('',100,'=') || E'\n'; cVersion VARCHAR := 'V 1.0 (c) 11/MAR/2012'; cRet RS_T_PARAMETRO; -- RETORNO DA FUNÇÃO. REC RECORD; cComm VARCHAR; -- SQL Command!! aParam VARCHAR[]; cAux VARCHAR; cMaster VARCHAR = ' FALSE '; BEGIN -- DEFINE SE USUÁRIOS TEM LIMITE DE PARÂMETROS -- SE NÃO HÁ LIMITES, ELE PODE ATUALIZAR TODOS. SELECT USU_PARAMETROS INTO cAux FROM USUARIOS WHERE USU_ID = nUser; cAux := REPLACE( cAux , ' ', '' ); cAux := REPLACE( cAux , '|MODELOS|', '' ); -aParam := RS_ARRAY_STRING( UPPER( cAux ) , FALSE ); IF nUser = 1 THEN cMaster := ' TRUE '; END IF; -- MONTA COMANDO SQL cComm := ' SELECT A.PAR_NOME,A.PAR_VALOR,A.PAR_FUNCAO, A.PAR_MASTER FROM PARAMETROS A WHERE ( A.PAR_MASTER <> ''S'' OR ' || cMaster || ') '; IF aParam[ 1 ] IS NOT NULL THEN cComm := cComm || ' AND PAR_NOME = ANY(' || RS_ARRAY_TO_STRING( aParam ) || ') '; END IF; -- SE NOME FAZ PARTE DA CHAVE IF COALESCE( TRIM( cNome ) , '' ) <> '' THEN cComm := cComm || ' AND A.PAR_NOME LIKE ''%' || UPPER( cNome ) || '%'' '; END IF; cComm := cComm || ' ORDER BY PAR_NOME'; FOR REC IN EXECUTE cComm LOOP cRet.PAR_NOME := REC.PAR_NOME; cRet.PAR_VALOR := REC.PAR_VALOR; cRet.PAR_FUNCAO := REC.PAR_FUNCAO; cRet.PAR_MASTER := REC.PAR_MASTER; RETURN NEXT cRet; END LOOP; END; $BODY$ LANGUAGE plpgsql STABLE;
Date: 2026-09-23 11:13:55 Database: contagem Application: pgAdmin 4 - CONN:3014750 User: lenon Remote: 172.20.0.3
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"290176","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-09-23 14:28:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 23 09 2 16 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-09-23 09:16:40 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-09-23 09:16:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-09-23 16:15:42 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 23 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-23 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-23 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-23 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local]
8 4 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 23 13 4 - ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 323 ));Date: 2026-09-23 13:39:24 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 323 ));Date: 2026-09-23 13:39:26 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 323 ));Date: 2026-09-23 13:39:27 Database: contagem Application: [unknown] User: intelifix Remote: [local]
9 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 23 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-23 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-23 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-23 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 3 ERROR: syntax error at end of input
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 23 08 3 - ERROR: syntax error at end of input at character 33
- ERROR: syntax error at end of input at character 33
- ERROR: syntax error at end of input at character 33
Statement: select * from rs_caixa_qr(httpsÇ
Date: 2026-09-23 08:47:59 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(httpsÇ
Date: 2026-09-23 08:47:59 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(httpsÇ
Date: 2026-09-23 08:48:05 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
11 1 ERROR: function rs_tem_letra(...) does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 23 09 1 - ERROR: function rs_tem_letra(unknown) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select rs_tem_letra('fsdfds')Date: 2026-09-23 09:56:08 Database: rio Application: pgAdmin 4 - CONN:6983121 User: lenon Remote: 172.20.0.3
12 1 ERROR: function rs_tem_legtra(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 23 09 1 - ERROR: function rs_tem_legtra(unknown) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select rs_tem_legtra('fsdfds')Date: 2026-09-23 09:56:03 Database: rio Application: pgAdmin 4 - CONN:6983121 User: lenon Remote: 172.20.0.3
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 23 03 1 - LOG: database system was shut down at 2026-09-23 03:05:01 -03
Date: 2026-09-23 03:05:02
14 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 23 11 1 - ERROR: unterminated quoted identifier at or near ""}')" at character 73
Statement: SELECT * FROM RS_NOME_DEFEITO('{"oficina":"6","modelo":"302","codigo":"'"}')
Date: 2026-09-23 11:57:09 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 ERROR: function rs_fluxos_lista(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 23 14 1 - ERROR: function rs_fluxos_lista(integer, integer, integer, unknown, unknown, bigint, unknown, integer) does not exist at character 46
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: CREATE TABLE temp0000292286 AS SELECT * FROM RS_FLUXOS_LISTA(06,00,00,'23-09-2026','23-09-2026',025114000401,'',00);Date: 2026-09-23 14:31:27 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 23 10 1 - ERROR: unterminated quoted string at or near "'9C635B8BEF7C'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('9C635B8BEF7C'');
Date: 2026-09-23 10:42:05 Database: rio Application: [unknown] User: intelifix Remote: [local]