pgBadger-
Global information
- Generated on Mon Oct 5 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 42,223 log entries in 10s
- Log start from 2026-10-05 00:00:46 to 2026-10-05 23:49:37
-
Overview
Global Stats
- 373 Number of unique normalized queries
- 4,964 Number of queries
- 8h7m30s Total query duration
- 2026-10-05 00:02:04 First query
- 2026-10-05 23:43:02 Last query
- 5 queries/s at 2026-10-05 16:26:55 Query peak
- 8h7m30s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h7m30s Execute total duration
- 5,290 Number of events
- 13 Number of unique normalized events
- 5,203 Max number of times the same event was reported
- 0 Number of cancellation
- 375 Total number of automatic vacuums
- 816 Total number of automatic analyzes
- 22 Number temporary file
- 248.84 MiB Max size of temporary file
- 71.02 MiB Average size of temporary file
- 414 Total number of sessions
- 10 sessions at 2026-10-05 15:31:03 Session peak
- 13d20h33m42s Total duration of sessions
- 48m11s Average duration of sessions
- 11 Average queries per session
- 1m10s Average queries duration per session
- 47m1s Average idle time per session
- 422 Total number of connections
- 7 connections/s at 2026-10-05 03:05:17 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-05 16:26:55 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-05 16:26:55 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-05 23:42:39 Date
Queries duration
Key values
- 8h7m30s 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) Oct 05 00 23 0ms 18s807ms 3s719ms 3s114ms 3s273ms 1m4s 01 12 0ms 3s369ms 1s669ms 3s112ms 3s301ms 3s620ms 02 12 0ms 3s274ms 1s647ms 3s87ms 3s300ms 3s498ms 03 15 0ms 3s203ms 1s335ms 3s38ms 3s190ms 4s394ms 04 12 0ms 3s236ms 1s603ms 3s82ms 3s179ms 3s461ms 05 17 0ms 10m21s 1m20s 3s392ms 2m53s 10m21s 06 26 0ms 41s393ms 4s807ms 3s537ms 26s623ms 41s549ms 07 175 0ms 9m25s 11s792ms 1m9s 4m1s 12m10s 08 319 0ms 5m59s 5s893ms 1m4s 6m6s 6m32s 09 473 150ms 6m10s 4s963ms 1m19s 6m12s 7m4s 10 505 152ms 6m27s 4s37ms 1m17s 4m9s 6m44s 11 515 151ms 6m12s 3s278ms 1m2s 1m37s 9m26s 12 184 0ms 34m51s 27s943ms 20s195ms 5m54s 1h4m30s 13 337 0ms 5m42s 2s821ms 17s109ms 55s689ms 5m42s 14 540 150ms 6m26s 3s295ms 42s595ms 4m14s 7m 15 619 0ms 6m22s 2s962ms 39s726ms 3m55s 7m8s 16 385 151ms 6m22s 2s808ms 19s457ms 48s76ms 7m2s 17 224 0ms 5m56s 4s67ms 29s666ms 1m5s 5m56s 18 35 0ms 5m31s 18s698ms 4s755ms 47s266ms 5m31s 19 24 0ms 5m27s 25s360ms 3s220ms 15s181ms 5m57s 20 121 0ms 7m4s 11s218ms 1m8s 1m43s 7m4s 21 34 0ms 6m14s 19s611ms 4s342ms 15s501ms 6m44s 22 30 0ms 5m19s 20s398ms 4s900ms 15s442ms 5m49s 23 327 0ms 1m2s 6s29ms 1m4s 1m7s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 05 00 4 0 1s352ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 186ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 9 0 630ms 0ms 0ms 890ms 07 100 0 15s776ms 2s381ms 8s743ms 8m28s 08 235 0 6s912ms 7s190ms 50s926ms 6m1s 09 371 0 4s972ms 11s720ms 44s829ms 6m12s 10 392 0 4s172ms 14s301ms 1m1s 5m54s 11 439 0 3s218ms 14s378ms 30s357ms 3m56s 12 139 0 35s996ms 4s515ms 17s267ms 6m28s 13 240 0 3s564ms 7s984ms 16s420ms 3m41s 14 435 0 3s412ms 12s63ms 19s240ms 6m37s 15 511 0 3s22ms 12s914ms 28s287ms 6m15s 16 327 0 2s935ms 7s780ms 13s234ms 3m48s 17 165 0 4s913ms 3s955ms 19s357ms 3m52s 18 15 0 40s295ms 0ms 721ms 3m38s 19 6 0 1m37s 0ms 0ms 3m31s 20 19 83 12s891ms 42s735ms 1m5s 3m46s 21 11 0 57s339ms 0ms 282ms 3m29s 22 6 0 1m36s 0ms 0ms 3m32s 23 7 320 6s29ms 1m2s 1m4s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.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 1 1.00 0.00% 07 0 18 18.00 0.00% 08 0 18 18.00 0.00% 09 0 12 12.00 0.00% 10 0 12 12.00 0.00% 11 0 13 13.00 0.00% 12 0 6 6.00 0.00% 13 0 14 14.00 0.00% 14 0 11 11.00 0.00% 15 0 17 17.00 0.00% 16 0 9 9.00 0.00% 17 0 6 6.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Oct 05 00 16 0.00/s 01 7 0.00/s 02 8 0.00/s 03 17 0.00/s 04 7 0.00/s 05 10 0.00/s 06 16 0.00/s 07 18 0.01/s 08 28 0.01/s 09 22 0.01/s 10 22 0.01/s 11 26 0.01/s 12 13 0.00/s 13 20 0.01/s 14 33 0.01/s 15 37 0.01/s 16 34 0.01/s 17 19 0.01/s 18 12 0.00/s 19 10 0.00/s 20 14 0.00/s 21 11 0.00/s 22 9 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Oct 05 00 6 51m40s 51m25s 01 16 1h2m48s 1h2m47s 02 7 1h 59m57s 03 16 22m53s 22m52s 04 8 1h2m15s 1h2m13s 05 7 1h3s 56m47s 06 10 57m36s 57m23s 07 18 54m27s 52m33s 08 20 46m24s 44m50s 09 25 50m56s 49m22s 10 20 55m32s 53m50s 11 20 55m26s 54m1s 12 25 56m15s 52m49s 13 12 52m30s 51m11s 14 32 40m26s 39m30s 15 39 24m2s 23m15s 16 33 38m27s 37m54s 17 22 53m53s 53m11s 18 16 1h29s 59m48s 19 12 1h42s 59m51s 20 13 47m36s 45m52s 21 10 1h12s 59m5s 22 12 1h1m56s 1h1m5s 23 15 38m12s 36m -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-10-05 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 422 connections Total
Connections per user
Key values
- intelifix Main User
- 422 connections Total
-
Sessions
Simultaneous sessions
Key values
- 10 sessions Session Peak
- 2026-10-05 15:31:03 Date
Histogram of session times
Key values
- 287 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 414 sessions Total
Sessions per user
Key values
- intelifix Main User
- 414 sessions Total
Sessions per host
Key values
- [local] Main Host
- 414 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 414 sessions Total
Application Count Total Duration Average Duration [unknown] 352 12d20h9m7s 52m31s pgAdmin 4 - CONN:1658183 2 4s484ms 2s242ms pgAdmin 4 - CONN:2966675 3 5s269ms 1s756ms pgAdmin 4 - CONN:3060719 2 28s682ms 14s341ms pgAdmin 4 - CONN:3874972 2 1m32s 46s142ms pgAdmin 4 - CONN:5981881 2 6s60ms 3s30ms pgAdmin 4 - CONN:6029926 1 1m55s 1m55s pgAdmin 4 - CONN:644335 3 1m52s 37s462ms pgAdmin 4 - CONN:6881772 1 14m17s 14m17s pgAdmin 4 - CONN:7788518 2 4s339ms 2s169ms pgAdmin 4 - DB:brasilia 4 3m48s 57s52ms pgAdmin 4 - DB:contagem 3 16m56s 5m38s pgAdmin 4 - DB:postgres 3 49m25s 16m28s pgAdmin 4 - DB:rio 3 51s747ms 17s249ms pg_dump 9 42m28s 4m43s postgres_fdw 1 35m2s 35m2s psql 21 21h35m35s 1h1m41s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 23,327 buffers Checkpoint Peak
- 2026-10-05 11:29:36 Date
- 270.045 seconds Highest write time
- 0.037 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-10-05 11:29:36 Date
Checkpoints distance
Key values
- 404.16 Mo Distance Peak
- 2026-10-05 11:29:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 05 00 6,361 269.648s 0.002s 269.654s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 8,624 0.201s 0.011s 0.22s 04 0 0s 0s 0s 05 6,924 692.462s 0.018s 692.503s 06 3,020 302.819s 0.003s 302.829s 07 15,288 1,397.501s 0.043s 1,397.586s 08 43,042 3,077.461s 0.091s 3,077.607s 09 62,776 3,239.489s 0.159s 3,239.725s 10 52,920 3,239.503s 0.146s 3,239.729s 11 117,267 3,239.416s 0.271s 3,239.774s 12 44,889 2,248.424s 0.068s 2,248.558s 13 28,045 2,211.982s 0.1s 2,212.145s 14 60,282 3,239.429s 0.172s 3,239.694s 15 69,138 2,733.744s 0.2s 2,734.022s 16 49,579 3,239.438s 0.156s 3,239.658s 17 22,943 2,075.874s 0.094s 2,076.021s 18 2,415 241.921s 0.017s 241.953s 19 29 2.92s 0.003s 2.928s 20 408 194.027s 0.007s 194.042s 21 2,838 284.114s 0.017s 284.161s 22 2,193 219.687s 0.015s 219.719s 23 197 19.772s 0.006s 19.788s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 05 00 0 0 3 32 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 27 0.009s 0.002s 04 0 0 0 0 0s 0s 05 0 0 3 149 0.006s 0.007s 06 0 0 1 66 0.001s 0.002s 07 0 0 12 2,119 0.003s 0.012s 08 0 0 25 4,727 0.003s 0.012s 09 0 0 45 6,536 0.004s 0.012s 10 0 0 37 6,642 0.003s 0.012s 11 0 0 52 6,578 0.006s 0.012s 12 0 0 19 3,142 0.003s 0.012s 13 0 0 9 5,053 0.003s 0.012s 14 0 0 32 6,796 0.004s 0.012s 15 0 0 35 6,920 0.012s 0.012s 16 0 0 17 5,808 0.004s 0.012s 17 0 0 16 4,629 0.003s 0.012s 18 0 0 0 443 0.002s 0.006s 19 0 0 0 9 0.001s 0.002s 20 0 0 1 89 0.002s 0.003s 21 0 0 1 408 0.002s 0.009s 22 0 0 1 443 0.002s 0.007s 23 0 0 0 38 0.001s 0.005s Day Hour Count Avg time (sec) Oct 05 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Oct 05 00 34,969.00 kB 34,969.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 26,957.00 kB 26,957.00 kB 04 0.00 kB 0.00 kB 05 7,493.14 kB 10,577.71 kB 06 6,770.00 kB 11,536.00 kB 07 16,311.00 kB 31,107.75 kB 08 33,928.75 kB 56,705.08 kB 09 61,542.42 kB 113,227.83 kB 10 50,505.42 kB 104,318.17 kB 11 71,186.67 kB 141,236.83 kB 12 26,021.75 kB 102,014.67 kB 13 12,787.50 kB 36,144.50 kB 14 43,084.00 kB 72,609.75 kB 15 47,718.42 kB 83,364.58 kB 16 22,872.33 kB 73,865.67 kB 17 21,826.50 kB 59,969.33 kB 18 2,281.50 kB 36,583.00 kB 19 103.50 kB 23,920.00 kB 20 5,523.33 kB 19,799.67 kB 21 1,543.89 kB 11,536.78 kB 22 1,557.71 kB 5,823.29 kB 23 164.60 kB 3,440.60 kB -
Temporary Files
Size of temporary files
Key values
- 497.67 MiB Temp Files size Peak
- 2026-10-05 05:31:58 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-05 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.72 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 104.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 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.02 GiB 37.11 MiB 248.84 MiB 65.32 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-05 05:32:06 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-05 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 309.30 MiB 57.48 MiB 94.60 MiB 77.33 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-05 05:30:42 Duration: 40s340ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-05 05:30:38 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( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:38 Duration: 34m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:49 Duration: 21m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030729, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-05 07:48:49 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 248.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 248.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:31:58 - 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-10-05 11:22:25 - 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-10-05 10:47:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 94.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-05 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 94.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-05 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 62.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-05 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 57.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-05 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.14 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-05 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.85 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-05 14:26:44 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 5.85 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-05 14:26:44 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (111) Main table analyzed (database rio)
- 816 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 111 rio.pg_catalog.pg_class 55 rio.public.usuarios 48 rio.pg_catalog.pg_type 47 brasilia.pg_catalog.pg_attribute 43 rio.public.temp0000293304 33 rio.public.temp0000293306 32 rio.public.temp0000292986 29 rio.pg_catalog.pg_index 28 brasilia.pg_catalog.pg_class 23 rio.pg_catalog.pg_depend 22 brasilia.pg_catalog.pg_type 20 contagem.public.usuarios 16 rio.public.temp0000293000 16 rio.public.temp0000293422 15 contagem.pg_catalog.pg_attribute 14 rio.public.temp0000293326 14 rio.public.temp0000292760 14 brasilia.pg_catalog.pg_index 12 brasilia.public.temp0000241578 11 brasilia.pg_catalog.pg_depend 11 rio.public.temp0000293396 10 rio.public.temp0000293298 8 brasilia.public.usuarios 8 rio.public.temp0000293448 7 brasilia.public.temp0000241576 7 rio.public.temp0000293120 7 contagem.pg_catalog.pg_class 6 rio.public.temp0000293296 6 rio.public.temp0000293402 5 contagem.pg_catalog.pg_type 5 rio.public.temp0000293362 5 rio.public.temp0000292754 5 brasilia.public.temp0000241612 5 rio.public.temp0000293428 5 contagem.pg_catalog.pg_index 4 brasilia.public.temp0000241526 4 rio.public.temp0000293364 4 rio.auditor.auditor_2026_10 4 contagem.public.temp0000227426 4 rio.public.temp0000293314 3 contagem.public.temp0000227440 3 rio.public.temp0000293302 3 brasilia.public.nf_entrada 3 brasilia.auditor.auditor_2026_10 3 rio.public.temp0000293308 3 rio.public.temp0000293330 3 contagem.pg_catalog.pg_depend 3 brasilia.public.temp0000241610 2 contagem.public.nf_entrada 2 rio.public.temp0000293312 2 rio.public.temp0000293380 2 brasilia.public.temp0000241528 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000293430 2 brasilia.public.temp0000241592 2 contagem.public.temp0000227436 2 rio.public.tmp_drill_0320 2 brasilia.public.temp0000241566 2 brasilia.public.temp0000241530 2 brasilia.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241554 2 brasilia.public.temp0000241590 2 brasilia.public.temp0000241600 2 brasilia.public.temp0000241550 2 template1.pg_catalog.pg_shdepend 1 rio.public.temp0000293410 1 brasilia.public.temp0000241586 1 rio.public.temp0000293294 1 brasilia.public.temp0000241558 1 rio.public.temp0000293292 1 rio.public.temp0000293434 1 brasilia.public.temp0000241538 1 brasilia.public.temp0000241582 1 rio.public.temp0000293372 1 brasilia.public.temp0000241588 1 rio.public.temp0000293416 1 brasilia.public.temp0000241540 1 contagem.public.temp0000227422 1 rio.public.temp0000293340 1 rio.public.tmp_drill_0302 1 rio.public.temp0000293356 1 rio.public.temp0000293374 1 rio.public.temp0000293316 1 brasilia.public.temp0000241542 1 testes.pg_catalog.pg_shdepend 1 rio.public.temp0000293320 1 brasilia.public.temp0000241614 1 rio.public.temp0000293388 1 rio.public.temp0000293358 1 contagem.auditor.auditor_2026_10 1 brasilia.public.temp0000241534 1 brasilia.public.temp0000241604 1 rio.public.temp0000293424 1 brasilia.public.temp0000241570 1 contagem.pg_catalog.pg_shdepend 1 contagem.public.temp0000227446 1 rio.public.temp0000293454 1 Total 816 Vacuums per table
Key values
- pg_catalog.pg_attribute (51) Main table vacuumed on database rio
- 375 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 51 36 0 0 0 0 0 20,995 6,045 8,900,375 299 7,668 rio.public.usuarios 32 6 0 0 0 0 0 206 85 179,293 26 47 rio.public.temp0000293306 27 0 0 0 0 0 0 15,587 1,967 3,323,049 0 0 rio.pg_catalog.pg_class 21 19 0 0 0 0 0 3,763 1,386 1,949,624 90 356 rio.pg_catalog.pg_type 17 17 0 0 0 0 0 1,917 632 925,173 59 192 contagem.public.usuarios 16 0 0 0 0 0 0 60 45 29,718 0 0 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 9,087 1,829 3,462,033 81 2,077 rio.public.temp0000293000 13 0 0 0 0 0 0 979 67 67,901 0 0 rio.pg_catalog.pg_index 11 11 0 0 0 0 0 624 194 208,376 28 67 rio.public.temp0000292760 11 0 0 0 0 0 0 972 58 66,188 0 0 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 1,025 186 337,482 9 36 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 2,017 394 750,037 21 108 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 3,226 1,325 1,894,322 85 662 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 356 85 96,401 14 30 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,384 2,711 11,053,459 1,521 7,360 rio.public.temp0000293120 7 0 0 0 0 0 0 5,552 24 331,529 0 0 rio.public.temp0000293422 6 0 0 0 0 0 0 494 36 34,498 0 0 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,780 995 1,744,417 11 386 postgres.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 1,561 577 1,258,409 78 152 rio.public.temp0000293396 5 0 0 0 0 0 0 339 84 131,221 0 0 brasilia.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,670 470 948,388 19 212 rio.public.temp0000293428 5 0 0 0 0 0 0 2,109 20 127,443 0 0 rio.public.temp0000293362 5 0 0 0 0 0 0 116 26 10,802 0 0 brasilia.public.temp0000241612 4 0 0 0 0 0 0 778 15 48,249 0 0 rio.public.temp0000293364 4 0 0 0 0 0 0 3,702 15 222,634 0 0 rio.public.temp0000293326 4 0 0 0 0 0 0 3,787 20 226,303 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 721 115 205,544 7 55 rio.auditor.auditor_2026_10 3 0 0 0 0 0 0 108,363 45,719 60,943,719 31,209 594,738 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 267 51 97,875 0 0 contagem.public.temp0000227440 3 0 0 0 0 0 0 355 18 23,874 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,314 911 3,779,500 658 4,070 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,668 450 2,296,110 176 481 rio.public.temp0000292754 3 0 0 0 0 0 0 111 13 8,579 0 0 rio.public.temp0000292986 3 0 0 0 0 0 0 166 17 12,313 0 0 contagem.auditor.auditor_2026_10 2 0 0 0 0 0 0 10,180 6,099 8,284,408 1,963 40,052 rio.public.temp0000293448 2 0 0 0 0 0 0 214 12 14,487 0 0 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 49 14 14,646 0 0 brasilia.auditor.auditor_2026_10 2 0 0 0 0 0 0 12,717 7,881 10,049,950 2,097 37,965 rio.public.temp0000293380 2 0 0 0 0 0 0 1,850 7 110,291 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 325 76 331,342 29 75 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 550 163 370,035 3 14 brasilia.public.temp0000241590 2 0 0 0 0 0 0 515 8 31,591 0 0 rio.public.temp0000293430 2 0 0 0 0 0 0 3,693 8 219,093 0 0 rio.public.temp0000293388 1 0 0 0 0 0 0 66 6 4,766 0 0 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 54 11 17,521 0 0 brasilia.public.temp0000241582 1 0 0 0 0 0 0 257 4 15,766 0 0 brasilia.public.temp0000241534 1 0 0 0 0 0 0 257 4 15,766 0 0 rio.public.temp0000293434 1 0 0 0 0 0 0 65 4 4,438 0 0 brasilia.public.temp0000241604 1 0 0 0 0 0 0 216 6 13,917 0 0 rio.public.temp0000293410 1 0 0 0 0 0 0 65 4 4,438 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 244 73 159,459 6 16 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 107 32 91,561 4 5 brasilia.public.temp0000241554 1 0 0 0 0 0 0 257 4 15,766 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 296 134 252,602 9 13 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 38 3 8,276 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,278 574 1,943,773 545 3,923 rio.public.temp0000293454 1 0 0 0 0 0 0 68 4 4,615 0 0 rio.public.temp0000293374 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000241588 1 0 0 0 0 0 0 257 4 15,766 0 0 brasilia.public.temp0000241576 1 0 0 0 0 0 0 258 4 15,825 0 0 rio.public.temp0000293416 1 0 0 0 0 0 0 66 6 4,767 0 0 contagem.public.temp0000227426 1 0 0 0 0 0 0 118 6 7,941 0 0 brasilia.public.temp0000241540 1 0 0 0 0 0 0 257 4 15,766 0 0 Total 375 187 0 0 0 0 0 244,372 81,743 127,734,184 39,047 700,760 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (14.84) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.76 rio.public.usuarios 0 0 0.01 rio.public.temp0000293306 0 0 0.64 rio.pg_catalog.pg_class 0 0 0.77 rio.pg_catalog.pg_type 0 0 0.25 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 1.6 rio.public.temp0000293000 0 0 0.02 rio.pg_catalog.pg_index 0 0 0.3 rio.public.temp0000292760 0 0 0.01 brasilia.pg_catalog.pg_type 0 0 0.54 brasilia.pg_catalog.pg_class 0 0 0.63 rio.pg_catalog.pg_depend 0 0 0.62 brasilia.pg_catalog.pg_index 0 0 0.28 rio.pg_catalog.pg_statistic 0 0 1.4 rio.public.temp0000293120 0 0 0.29 rio.public.temp0000293422 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.06 postgres.pg_catalog.pg_shdepend 0 0 0.68 rio.public.temp0000293396 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.79 rio.public.temp0000293428 0 0 0.04 rio.public.temp0000293362 0 0 0 brasilia.public.temp0000241612 0 0 0 rio.public.temp0000293364 0 0 0.18 rio.public.temp0000293326 0 0 0.08 contagem.pg_catalog.pg_class 0 0 0.47 rio.auditor.auditor_2026_10 0 0 14.84 contagem.pg_catalog.pg_type 0 0 0.22 contagem.public.temp0000227440 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.58 rio.pg_toast.pg_toast_2619 0 0 0.28 rio.public.temp0000292754 0 0 0 rio.public.temp0000292986 0 0 0.01 contagem.auditor.auditor_2026_10 0 0 2.12 rio.public.temp0000293448 0 0 0.02 rio.public.tmp_drill_0320 0 0 0 brasilia.auditor.auditor_2026_10 0 0 2.62 rio.public.temp0000293380 0 0 0.09 brasilia.pg_toast.pg_toast_2619 0 0 0.04 contagem.pg_catalog.pg_depend 0 0 0.37 brasilia.public.temp0000241590 0 0 0 rio.public.temp0000293430 0 0 0.09 rio.public.temp0000293388 0 0 0 contagem.pg_catalog.pg_index 0 0 0.01 brasilia.public.temp0000241582 0 0 0 brasilia.public.temp0000241534 0 0 0 rio.public.temp0000293434 0 0 0 brasilia.public.temp0000241604 0 0 0.01 rio.public.temp0000293410 0 0 0 contagem.public.nf_entrada 0 0 0.08 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000241554 0 0 0 brasilia.public.nf_entrada 0 0 0.14 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.09 rio.public.temp0000293454 0 0 0 rio.public.temp0000293374 0 0 0.04 brasilia.public.temp0000241588 0 0 0 brasilia.public.temp0000241576 0 0 0 rio.public.temp0000293416 0 0 0 contagem.public.temp0000227426 0 0 0 brasilia.public.temp0000241540 0 0 0 Total 0 0 35.07 Tuples removed per table
Key values
- pg_catalog.pg_attribute (136578) Main table with removed tuples on database rio
- 309246 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 51 36 136,578 1,281,577 115,131 142 30,365 brasilia.pg_catalog.pg_attribute 15 15 75,292 340,313 710 217 8,731 contagem.pg_catalog.pg_attribute 6 6 24,023 145,079 0 0 3,294 rio.pg_catalog.pg_statistic 7 7 11,816 58,010 867 0 9,002 rio.pg_catalog.pg_depend 9 9 6,498 173,693 2,753 0 1,692 brasilia.pg_catalog.pg_statistic 3 3 6,283 23,471 0 0 3,213 postgres.pg_catalog.pg_shdepend 6 6 5,446 108,624 354 0 900 rio.pg_catalog.pg_type 17 17 5,054 39,097 536 4 1,206 brasilia.pg_catalog.pg_depend 5 5 4,484 90,703 42 15 899 contagem.pg_catalog.pg_statistic 1 1 4,237 7,274 0 0 1,011 brasilia.pg_catalog.pg_type 9 9 3,829 20,099 0 26 626 contagem.pg_catalog.pg_depend 2 2 3,040 38,435 0 0 339 rio.pg_catalog.pg_class 21 19 3,003 76,855 3,844 24 2,572 contagem.public.nf_entrada 1 1 2,947 1,107 0 0 87 rio.auditor.auditor_2026_10 3 0 2,170 6,258,795 0 0 298,855 brasilia.pg_catalog.pg_class 9 9 2,075 31,532 0 38 1,192 contagem.pg_catalog.pg_class 4 4 2,027 14,358 0 40 551 brasilia.pg_catalog.pg_index 7 7 1,703 13,260 0 12 364 rio.pg_catalog.pg_index 11 11 1,669 21,292 226 4 584 brasilia.auditor.auditor_2026_10 2 0 1,613 1,279,567 0 0 55,979 contagem.pg_catalog.pg_type 3 3 1,319 6,773 16 0 203 rio.public.usuarios 32 6 973 23,115 6,827 0 608 rio.pg_toast.pg_toast_2619 3 3 954 2,083 0 0 768 contagem.public.usuarios 16 0 944 384 0 0 32 brasilia.public.nf_entrada 1 1 650 3,326 0 0 152 contagem.pg_catalog.pg_index 1 1 347 1,901 0 0 52 brasilia.pg_toast.pg_toast_2619 2 2 182 276 0 0 120 contagem.pg_toast.pg_toast_2619 1 1 90 111 0 0 50 rio.public.temp0000293388 1 0 0 1,082 0 6 58 contagem.public.temp0000227440 3 0 0 4,218 0 54 330 brasilia.public.temp0000241612 4 0 0 13,534 0 0 1,024 contagem.auditor.auditor_2026_10 2 0 0 966,581 0 0 41,422 brasilia.public.temp0000241582 1 0 0 3,375 0 0 256 rio.public.temp0000293422 6 0 0 19,908 0 322 446 brasilia.public.temp0000241534 1 0 0 3,374 0 0 256 rio.public.temp0000293448 2 0 0 8,797 0 58 198 rio.public.temp0000293434 1 0 0 1,133 0 0 64 brasilia.public.temp0000241604 1 0 0 3,462 0 48 208 rio.public.temp0000293306 27 0 0 380,217 0 129 26,687 rio.public.temp0000293410 1 0 0 1,132 0 0 64 rio.public.temp0000292754 3 0 0 7,952 0 46 178 rio.public.temp0000293364 4 0 0 104,768 0 0 7,424 rio.public.temp0000293326 4 0 0 54,639 0 17 3,791 rio.public.tmp_drill_0320 2 2 0 397 0 0 11 rio.public.temp0000293380 2 0 0 52,387 0 0 3,712 brasilia.public.temp0000241590 2 0 0 6,759 0 0 512 brasilia.public.temp0000241554 1 0 0 3,374 0 0 256 rio.public.temp0000293396 5 0 0 14,247 0 0 320 rio.public.tmp_drill_0302 1 1 0 497 0 0 14 rio.public.temp0000293454 1 0 0 1,161 0 0 64 rio.public.temp0000293374 1 0 0 26,193 0 0 1,856 rio.public.temp0000292986 3 0 0 8,284 0 135 185 rio.public.temp0000293000 13 0 0 43,856 0 294 986 brasilia.public.temp0000241588 1 0 0 3,375 0 0 256 brasilia.public.temp0000241576 1 0 0 3,384 0 0 256 rio.public.temp0000293120 7 0 0 183,291 0 0 12,992 rio.public.temp0000293428 5 0 0 30,784 0 0 2,112 rio.public.temp0000293416 1 0 0 1,091 0 6 58 rio.public.temp0000292760 11 0 0 40,125 0 251 901 contagem.public.temp0000227426 1 0 0 1,405 0 18 110 brasilia.public.temp0000241540 1 0 0 3,374 0 0 256 rio.public.temp0000293430 2 0 0 52,396 0 0 3,712 rio.public.temp0000293362 5 0 0 12,830 0 161 287 Total 375 187 309,246 12,124,492 131,306 2,067 534,709 Pages removed per table
Key values
- public.temp0000293422 (322) Main table with removed pages on database rio
- 2067 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293422 6 0 0 322 rio.public.temp0000293000 13 0 0 294 rio.public.temp0000292760 11 0 0 251 brasilia.pg_catalog.pg_attribute 15 15 75292 217 rio.public.temp0000293362 5 0 0 161 rio.pg_catalog.pg_attribute 51 36 136578 142 rio.public.temp0000292986 3 0 0 135 rio.public.temp0000293306 27 0 0 129 rio.public.temp0000293448 2 0 0 58 contagem.public.temp0000227440 3 0 0 54 brasilia.public.temp0000241604 1 0 0 48 rio.public.temp0000292754 3 0 0 46 contagem.pg_catalog.pg_class 4 4 2027 40 brasilia.pg_catalog.pg_class 9 9 2075 38 brasilia.pg_catalog.pg_type 9 9 3829 26 rio.pg_catalog.pg_class 21 19 3003 24 contagem.public.temp0000227426 1 0 0 18 rio.public.temp0000293326 4 0 0 17 brasilia.pg_catalog.pg_depend 5 5 4484 15 brasilia.pg_catalog.pg_index 7 7 1703 12 rio.public.temp0000293388 1 0 0 6 rio.public.temp0000293416 1 0 0 6 rio.pg_catalog.pg_index 11 11 1669 4 rio.pg_catalog.pg_type 17 17 5054 4 rio.auditor.auditor_2026_10 3 0 2170 0 contagem.pg_catalog.pg_type 3 3 1319 0 contagem.pg_catalog.pg_index 1 1 347 0 brasilia.pg_catalog.pg_statistic 3 3 6283 0 brasilia.public.temp0000241612 4 0 0 0 contagem.auditor.auditor_2026_10 2 0 0 0 brasilia.public.temp0000241582 1 0 0 0 brasilia.public.temp0000241534 1 0 0 0 rio.public.temp0000293434 1 0 0 0 rio.pg_toast.pg_toast_2619 3 3 954 0 rio.public.temp0000293410 1 0 0 0 contagem.pg_catalog.pg_attribute 6 6 24023 0 rio.public.usuarios 32 6 973 0 rio.public.temp0000293364 4 0 0 0 contagem.public.nf_entrada 1 1 2947 0 rio.public.tmp_drill_0320 2 2 0 0 brasilia.auditor.auditor_2026_10 2 0 1613 0 contagem.public.usuarios 16 0 944 0 contagem.pg_toast.pg_toast_2619 1 1 90 0 rio.public.temp0000293380 2 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 182 0 contagem.pg_catalog.pg_depend 2 2 3040 0 brasilia.public.temp0000241590 2 0 0 0 rio.pg_catalog.pg_statistic 7 7 11816 0 brasilia.public.temp0000241554 1 0 0 0 brasilia.public.nf_entrada 1 1 650 0 rio.public.temp0000293396 5 0 0 0 rio.public.tmp_drill_0302 1 1 0 0 contagem.pg_catalog.pg_statistic 1 1 4237 0 rio.pg_catalog.pg_depend 9 9 6498 0 rio.public.temp0000293454 1 0 0 0 rio.public.temp0000293374 1 0 0 0 brasilia.public.temp0000241588 1 0 0 0 brasilia.public.temp0000241576 1 0 0 0 rio.public.temp0000293120 7 0 0 0 rio.public.temp0000293428 5 0 0 0 postgres.pg_catalog.pg_shdepend 6 6 5446 0 brasilia.public.temp0000241540 1 0 0 0 rio.public.temp0000293430 2 0 0 0 Total 375 187 309,246 2,067 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 1 07 5 18 08 20 58 09 35 82 10 39 95 11 61 83 12 10 17 13 27 77 14 45 122 15 69 118 16 21 65 17 32 76 18 3 3 19 0 0 20 0 0 21 2 1 22 0 0 23 0 0 - 5.85 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 29m5s 11s147ms 21m19s 9m41s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:49 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030729, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-05 07:48:49 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 3m36s 3m36s 3m36s 3m36s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 07:48:49 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 00:05:21 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 20:05:13 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 21m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-05 12:01:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 7m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-05 12:01:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 3m36s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-10-05 07:48:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 11s147ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-05 12:01:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,433 Total read queries
- 1,018 Total write queries
Queries by database
Key values
- rio Main database
- 3,140 Requests
- 6h11m39s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,372 1h44m54s copy to 140 10m58s ddl 158 3m5s others 252 11m28s select 822 1h19m21s contagem Total 447 10m55s copy to 115 1m24s ddl 24 31s157ms others 6 3m14s select 302 5m45s rio Total 3,140 6h11m39s copy to 148 29m42s ddl 433 26m57s others 255 34m45s select 2,304 4h40m13s testes Total 5 1s535ms select 5 1s535ms Queries by user
Key values
- intelifix Main user
- 4,806 Requests
User Request type Count Duration etiquetas Total 46 12s553ms select 46 12s553ms intelifix Total 4,806 8h6m32s copy to 403 42m5s ddl 615 30m33s others 513 49m28s select 3,275 6h4m24s lenon Total 112 45s72ms select 112 45s72ms Duration by user
Key values
- 8h6m32s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 46 12s553ms select 46 12s553ms intelifix Total 4,806 8h6m32s copy to 403 42m5s ddl 615 30m33s others 513 49m28s select 3,275 6h4m24s lenon Total 112 45s72ms select 112 45s72ms Queries by host
Key values
- [local] Main host
- 4,961 Requests
- 8h7m27s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,855 Requests
- 3h54m17s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 3,855 3h31m1s ddl 615 30m33s select 3,240 3h27s pgAdmin 4 - CONN:6029926 Total 1 169ms select 1 169ms pgAdmin 4 - CONN:6881772 Total 2 2s591ms select 2 2s591ms pg_dump Total 414 42m8s copy to 403 42m5s select 11 2s760ms psql Total 692 3h54m17s others 513 49m28s select 179 3h4m49s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-05 20:42:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,117 100-500ms duration
Slowest individual queries
Rank Duration Query 1 34m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-05 12:01:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 21m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-05 12:01:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 10m21s analyze verbose;[ Date: 2026-10-05 05:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 07:14:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030729, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 07:48:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 7m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-05 12:01:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 7m13s analyze verbose;[ Date: 2026-10-05 05:17:36 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
8 7m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 20:12:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030757, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 12:02:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 6m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030753, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 10:35:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 6m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030760, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 14:30:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 15:11:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 16:11:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 21:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 11:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030741, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 09:46:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030736, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 09:16:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030762, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-05 15:46:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 09:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-05 14:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h18m11s 213 153ms 34m51s 38s925ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 05 07 16 8m37s 32s314ms 08 11 12m59s 1m10s 09 22 13m4s 35s677ms 10 33 10m35s 19s251ms 11 28 5m23s 11s546ms 12 14 1h11m9s 5m4s 13 8 48s410ms 6s51ms 14 27 7m5s 15s763ms 15 23 6m48s 17s782ms 16 17 49s839ms 2s931ms 17 11 43s240ms 3s930ms 18 3 5s695ms 1s898ms [ User: intelifix - Total duration: 2h18m11s - Times executed: 213 ]
[ Application: [unknown] - Total duration: 2h18m11s - Times executed: 213 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:38 Duration: 34m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:49 Duration: 21m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030729, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-05 07:48:49 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h44m50s 48 2s337ms 9m25s 2m11s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 05 07 3 10m7s 3m22s 08 3 6m7s 2m2s 09 3 6m20s 2m6s 10 3 6m12s 2m4s 11 3 6m33s 2m11s 12 3 6m8s 2m2s 13 3 6m 2m 14 3 6m20s 2m6s 15 3 6m41s 2m13s 16 3 6m41s 2m13s 17 3 6m20s 2m6s 18 3 5m50s 1m56s 19 3 5m45s 1m55s 20 3 7m32s 2m30s 21 3 6m31s 2m10s 22 3 5m36s 1m52s [ User: intelifix - Total duration: 1h44m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 07:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 20:12:06 Duration: 7m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 15:11:23 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: psql
3 1h9m58s 48 239ms 3m54s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 05 07 3 5m35s 1m51s 08 3 4m21s 1m27s 09 3 4m12s 1m24s 10 3 4m16s 1m25s 11 3 4m21s 1m27s 12 3 4m20s 1m26s 13 3 4m11s 1m23s 14 3 4m33s 1m31s 15 3 4m24s 1m28s 16 3 4m19s 1m26s 17 3 4m16s 1m25s 18 3 4m5s 1m21s 19 3 3m59s 1m19s 20 3 5m2s 1m40s 21 3 3m57s 1m19s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h9m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 14:15:52 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 08:15:22 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 07:20:31 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
4 20m28s 3 2m53s 10m21s 6m49s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 05 05 3 20m28s 6m49s [ User: intelifix - Total duration: 20m28s - Times executed: 3 ]
[ Application: psql - Total duration: 20m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-05 05:10:22 Duration: 10m21s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-05 05:17:36 Duration: 7m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-05 05:20:30 Duration: 2m53s Database: contagem User: intelifix Remote: [local] Application: psql
5 18m45s 1,237 152ms 8s701ms 909ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 05 07 6 6s955ms 1s159ms 08 46 50s579ms 1s99ms 09 132 2m5s 947ms 10 149 2m17s 921ms 11 125 2m 964ms 12 38 35s191ms 926ms 13 100 1m38s 985ms 14 198 3m11s 965ms 15 198 2m48s 851ms 16 192 2m35s 811ms 17 52 34s351ms 660ms 18 1 1s25ms 1s25ms [ User: intelifix - Total duration: 18m45s - Times executed: 1237 ]
[ Application: [unknown] - Total duration: 18m45s - Times executed: 1237 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293511, 317, '835169925005603,241691395659,241620596875,241646306971,241631546990,241604354763,241731663237,241602979410,241727529095,241678278587,241700796363,241607662123,241680272240,241731658892,241713835167,241689524646,241699056373', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-05 16:22:50 Duration: 8s701ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293448, 503, '2102312JCYRYK9910310,D0C65B2FA777,485754438C55149FJCYRYL3903276,541310DD8B16,485754430E335BA2JCYRYL2900036,AC8D34A176AB,48575443158EFAA1JCYRYL3001007,541310DC4E61,485754430E213AA2JCYRYL2001380,AC8D34A08B46,4857544315812DA1JCYRYK1017710,2841C6885AF7,485754434190F79E', '',0147,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-05 11:24:49 Duration: 6s880ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293450, 433, '722153037657,B4F267211FB9,6802B8648E94,6802B814EEE2,6802B85266CA,B4F267579565,6802B8F853BB,6802B8DB7F1F,6802B8A43812,6802B8F0120B,6802B8F03BC6,6802B86329F1,6802B8AC60A7,B4F2675DF51F,6802B8ACBE91,6802B814C4F7,B4F26758C1B3,B4F2673358F1,6802B8A1DB4A,6802B8DE520D,B4F267577C27,6802B8AC51BC,B4F2673350CF,6802B8F8D71C,6802B8CA3542,6802B85B62A2,6802B8ACB513,6802B86267AE,6802B86304B0,B4F2672043A5,6802B8AC87C2,6802B8A3BE0E,B4F267575DC7,6802B8A2DE4F,B4F2670BFFE5,6802B8CAA340,6802B8F0334D,6802B8526A66,6802B8241020,6802B85B9731,B4F2675817A6', '',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-10-05 10:03:52 Duration: 4s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 12m38s 276 194ms 3m39s 2s746ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 05 00 12 38s585ms 3s215ms 01 12 20s34ms 1s669ms 02 12 19s771ms 1s647ms 03 12 19s139ms 1s594ms 04 12 19s245ms 1s603ms 05 12 18s920ms 1s576ms 06 12 20s191ms 1s682ms 07 12 3m55s 19s650ms 08 12 30s16ms 2s501ms 09 12 25s416ms 2s118ms 10 12 28s63ms 2s338ms 11 12 23s690ms 1s974ms 12 12 26s317ms 2s193ms 13 12 21s11ms 1s750ms 14 12 28s4ms 2s333ms 15 12 27s846ms 2s320ms 16 12 20s112ms 1s676ms 17 12 20s700ms 1s725ms 18 12 19s823ms 1s651ms 19 12 19s593ms 1s632ms 20 12 36s986ms 3s82ms 21 12 19s413ms 1s617ms 22 12 19s444ms 1s620ms [ User: intelifix - Total duration: 12m38s - Times executed: 276 ]
[ Application: psql - Total duration: 12m38s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 07:48:49 Duration: 3m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 00:05:21 Duration: 18s807ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 20:05:13 Duration: 12s217ms Database: rio User: intelifix Remote: [local] Application: psql
7 11m5s 51 10s676ms 45s708ms 13s41ms create table temp0000293306 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 05 07 9 2m14s 14s933ms 08 8 1m29s 11s197ms 09 11 2m38s 14s395ms 10 14 2m49s 12s90ms 11 3 36s386ms 12s128ms 14 6 1m17s 12s850ms [ User: intelifix - Total duration: 11m5s - Times executed: 51 ]
[ Application: [unknown] - Total duration: 11m5s - Times executed: 51 ]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 07:38:09 Duration: 45s708ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:26:01 Duration: 28s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:09:28 Duration: 23s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m41s 714 150ms 11s737ms 814ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 05 07 5 5s427ms 1s85ms 08 76 1m5s 865ms 09 79 1m4s 821ms 10 77 1m7s 881ms 11 111 1m35s 856ms 12 23 18s875ms 820ms 13 72 52s836ms 733ms 14 88 1m16s 864ms 15 81 1m2s 772ms 16 55 49s258ms 895ms 17 47 22s824ms 485ms [ User: intelifix - Total duration: 9m41s - Times executed: 714 ]
[ Application: [unknown] - Total duration: 9m41s - Times executed: 714 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293682", "modelo" : "189", "itens" : "20AB48B95683,04E79596EC1F,C4A4023F2EF7,F09BB8C4242C,,88892FFEFB6B,5C647AE002D5,FC73FBBDD3DD,C0BC9A4B8C92,B85FB005B6AD,E8136E93EB39,C0BC9A48CDC4,1C3D2F48E1F0,80E1BFFF59E5,C40D969C5A13,00E406F14F11,C40D969710C9", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-05 16:41:53 Duration: 11s737ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293587", "modelo" : "464", "itens" : "241767153850,241770648501,241772684861,241759535160,241816976467,241759972229,241776767279,241743222839,241744268686,241740198390,241775246278,241778727594,241771138908,241776643654,241776635168,241763966883,241777781734,241777916774,241759457475,241779211840,241779198808,241738490122,241765459801,241759526876,241813274546,241744371829,241814232429,241776508892,241778755476,241778832431,241769558709,241742939196,241818752444,241773521924,241770743942,241766946882,241772636472,241747991116,241741166173,241777862628,241775667587,241772354952,241738498708,241745470006,241742300415,241768744555,241772671325,241768794661,241764008605,241772740625,241772614349,241771238288,241761343339,241769251025,241761110915,241742804863,241739558294,241762629716,241778685873,241764411024", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-05 14:30:46 Duration: 3s477ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293328", "modelo" : "46", "itens" : "1062D0C8E166,14B7F88E33EE,A456CCE3DEC5,A456CCE0DB44,383FB3A467A6,B42A0EDBE494,54A65C110D93,54A65C106C7E,946A772769AD,383FB3A3BDDF,946A7727C992,14B7F88EA713,54A65C8F1C65,10C25A3B71CA,5C769593675A,10C25A108E8D", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-05 08:13:05 Duration: 3s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m21s 132 180ms 15s27ms 4s256ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 05 00 1 585ms 585ms 07 12 1m4s 5s407ms 08 13 53s153ms 4s88ms 09 11 57s739ms 5s249ms 10 12 55s401ms 4s616ms 11 12 1m5s 5s458ms 12 12 1m14s 6s246ms 13 8 8s648ms 1s81ms 14 11 50s53ms 4s550ms 15 12 1m1s 5s150ms 16 10 36s662ms 3s666ms 17 6 10s102ms 1s683ms 20 1 180ms 180ms 21 5 11s703ms 2s340ms 22 6 10s503ms 1s750ms [ User: intelifix - Total duration: 9m21s - Times executed: 132 ]
[ Application: psql - Total duration: 9m21s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 15:25:16 Duration: 15s27ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 09:45:14 Duration: 13s728ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 14:35:15 Duration: 13s25ms Database: rio User: intelifix Remote: [local] Application: psql
10 4m57s 56 1s70ms 40s779ms 5s320ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 05 08 1 10s975ms 10s975ms 09 8 1m5s 8s241ms 10 5 17s414ms 3s482ms 11 3 21s180ms 7s60ms 12 3 19s806ms 6s602ms 13 8 27s625ms 3s453ms 14 5 29s533ms 5s906ms 15 11 56s698ms 5s154ms 16 3 13s7ms 4s335ms 17 9 35s775ms 3s975ms [ User: intelifix - Total duration: 4m57s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 4m57s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0302, '', '', 0, 6, '2026-10-02');
Date: 2026-10-05 09:04:11 Duration: 40s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-05 12:14:44 Duration: 14s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-05 14:45:28 Duration: 12s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m17s 29 156ms 1m24s 8s863ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 05 07 3 1s485ms 495ms 08 4 32s790ms 8s197ms 09 8 1m 7s560ms 10 6 38s46ms 6s341ms 11 2 1m25s 42s596ms 14 4 31s253ms 7s813ms 15 2 7s786ms 3s893ms [ User: intelifix - Total duration: 4m17s - Times executed: 29 ]
[ Application: psql - Total duration: 4m17s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030756);
Date: 2026-10-05 11:24:49 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030754);
Date: 2026-10-05 10:48:37 Duration: 36s769ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030738);
Date: 2026-10-05 09:27:23 Duration: 35s738ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m3s 29 270ms 1m5s 8s404ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 05 07 2 1m9s 34s930ms 08 3 25s316ms 8s438ms 09 6 1m 10s82ms 10 3 19s94ms 6s364ms 11 2 19s33ms 9s516ms 14 6 24s842ms 4s140ms 15 7 25s87ms 3s583ms [ User: intelifix - Total duration: 4m3s - Times executed: 29 ]
[ Application: psql - Total duration: 4m3s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030729);
Date: 2026-10-05 07:40:55 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030742);
Date: 2026-10-05 09:47:16 Duration: 28s826ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030732);
Date: 2026-10-05 08:25:53 Duration: 16s893ms Database: rio User: intelifix Remote: [local] Application: psql
13 2m39s 9 10s990ms 38s965ms 17s712ms create table temp0000293120 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 05 08 2 22s970ms 11s485ms 09 3 1m3s 21s194ms 14 3 1m1s 20s365ms 15 1 11s762ms 11s762ms [ User: intelifix - Total duration: 2m39s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 9 ]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:05:37 Duration: 38s965ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 14:08:59 Duration: 34s989ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 14:43:14 Duration: 13s83ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m39s 107 157ms 6s376ms 1s487ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 05 07 17 19s172ms 1s127ms 09 3 11s312ms 3s770ms 10 20 58s303ms 2s915ms 11 12 19s340ms 1s611ms 12 7 11s99ms 1s585ms 14 18 13s302ms 739ms 15 17 15s377ms 904ms 16 12 5s958ms 496ms 17 1 5s253ms 5s253ms [ User: intelifix - Total duration: 2m39s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137930) LIMIT 1;
Date: 2026-10-05 10:51:07 Duration: 6s376ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139218) LIMIT 1;
Date: 2026-10-05 09:19:44 Duration: 6s1ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137352) LIMIT 1;
Date: 2026-10-05 10:52:05 Duration: 5s873ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 2m15s 4 4s376ms 1m4s 33s860ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 05 20 2 1m8s 34s258ms 23 2 1m6s 33s462ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-05 20:08:44 Duration: 1m4s 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-10-05 23:16:40 Duration: 1m2s 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-10-05 20:10:46 Duration: 4s402ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 2m6s 36 583ms 9s156ms 3s523ms 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 #16
Day Hour Count Duration Avg duration Oct 05 08 3 6s825ms 2s275ms 09 2 10s716ms 5s358ms 10 3 18s877ms 6s292ms 11 3 20s404ms 6s801ms 12 3 8s497ms 2s832ms 13 2 10s957ms 5s478ms 14 2 9s769ms 4s884ms 15 1 5s142ms 5s142ms 16 3 12s410ms 4s136ms 17 3 14s589ms 4s863ms 18 2 1s696ms 848ms 19 3 2s434ms 811ms 20 2 1s458ms 729ms 21 2 1s617ms 808ms 22 2 1s462ms 731ms [ User: intelifix - Total duration: 2m6s - Times executed: 36 ]
[ Application: psql - Total duration: 2m6s - Times executed: 36 ]
-
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-10-05 17:00:10 Duration: 9s156ms 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-10-05 09:40:10 Duration: 8s660ms 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-10-05 13:40:09 Duration: 8s644ms Database: rio User: intelifix Remote: [local] Application: psql
17 1m58s 8 11s610ms 34s61ms 14s781ms create table temp0000293364 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 05 10 4 46s788ms 11s697ms 11 4 1m11s 17s865ms [ User: intelifix - Total duration: 1m58s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1m58s - Times executed: 8 ]
-
CREATE TABLE temp0000293364 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 11:23:05 Duration: 34s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293364 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 11:25:20 Duration: 12s862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293364 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 11:23:38 Duration: 12s305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m48s 6 3s273ms 40s291ms 18s19ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 05 20 3 54s73ms 18s24ms 23 3 54s40ms 18s13ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-05 23:14:27 Duration: 40s291ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-05 20:06:29 Duration: 40s197ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-05 20:10:22 Duration: 10s602ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m47s 9 11s591ms 12s674ms 11s983ms create table temp0000293326 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 05 09 9 1m47s 11s983ms [ User: intelifix - Total duration: 1m47s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m47s - Times executed: 9 ]
-
CREATE TABLE temp0000293326 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:49:18 Duration: 12s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293326 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:46:59 Duration: 12s174ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293326 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:48:29 Duration: 12s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m47s 4 349ms 53s437ms 26s888ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 05 20 2 53s752ms 26s876ms 23 2 53s800ms 26s900ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-05 23:13:44 Duration: 53s437ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-05 20:05:46 Duration: 53s402ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-05 23:33:26 Duration: 363ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,237 18m45s 152ms 8s701ms 909ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 05 07 6 6s955ms 1s159ms 08 46 50s579ms 1s99ms 09 132 2m5s 947ms 10 149 2m17s 921ms 11 125 2m 964ms 12 38 35s191ms 926ms 13 100 1m38s 985ms 14 198 3m11s 965ms 15 198 2m48s 851ms 16 192 2m35s 811ms 17 52 34s351ms 660ms 18 1 1s25ms 1s25ms [ User: intelifix - Total duration: 18m45s - Times executed: 1237 ]
[ Application: [unknown] - Total duration: 18m45s - Times executed: 1237 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293511, 317, '835169925005603,241691395659,241620596875,241646306971,241631546990,241604354763,241731663237,241602979410,241727529095,241678278587,241700796363,241607662123,241680272240,241731658892,241713835167,241689524646,241699056373', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-05 16:22:50 Duration: 8s701ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293448, 503, '2102312JCYRYK9910310,D0C65B2FA777,485754438C55149FJCYRYL3903276,541310DD8B16,485754430E335BA2JCYRYL2900036,AC8D34A176AB,48575443158EFAA1JCYRYL3001007,541310DC4E61,485754430E213AA2JCYRYL2001380,AC8D34A08B46,4857544315812DA1JCYRYK1017710,2841C6885AF7,485754434190F79E', '',0147,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-05 11:24:49 Duration: 6s880ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293450, 433, '722153037657,B4F267211FB9,6802B8648E94,6802B814EEE2,6802B85266CA,B4F267579565,6802B8F853BB,6802B8DB7F1F,6802B8A43812,6802B8F0120B,6802B8F03BC6,6802B86329F1,6802B8AC60A7,B4F2675DF51F,6802B8ACBE91,6802B814C4F7,B4F26758C1B3,B4F2673358F1,6802B8A1DB4A,6802B8DE520D,B4F267577C27,6802B8AC51BC,B4F2673350CF,6802B8F8D71C,6802B8CA3542,6802B85B62A2,6802B8ACB513,6802B86267AE,6802B86304B0,B4F2672043A5,6802B8AC87C2,6802B8A3BE0E,B4F267575DC7,6802B8A2DE4F,B4F2670BFFE5,6802B8CAA340,6802B8F0334D,6802B8526A66,6802B8241020,6802B85B9731,B4F2675817A6', '',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-10-05 10:03:52 Duration: 4s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 714 9m41s 150ms 11s737ms 814ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 05 07 5 5s427ms 1s85ms 08 76 1m5s 865ms 09 79 1m4s 821ms 10 77 1m7s 881ms 11 111 1m35s 856ms 12 23 18s875ms 820ms 13 72 52s836ms 733ms 14 88 1m16s 864ms 15 81 1m2s 772ms 16 55 49s258ms 895ms 17 47 22s824ms 485ms [ User: intelifix - Total duration: 9m41s - Times executed: 714 ]
[ Application: [unknown] - Total duration: 9m41s - Times executed: 714 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293682", "modelo" : "189", "itens" : "20AB48B95683,04E79596EC1F,C4A4023F2EF7,F09BB8C4242C,,88892FFEFB6B,5C647AE002D5,FC73FBBDD3DD,C0BC9A4B8C92,B85FB005B6AD,E8136E93EB39,C0BC9A48CDC4,1C3D2F48E1F0,80E1BFFF59E5,C40D969C5A13,00E406F14F11,C40D969710C9", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-05 16:41:53 Duration: 11s737ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293587", "modelo" : "464", "itens" : "241767153850,241770648501,241772684861,241759535160,241816976467,241759972229,241776767279,241743222839,241744268686,241740198390,241775246278,241778727594,241771138908,241776643654,241776635168,241763966883,241777781734,241777916774,241759457475,241779211840,241779198808,241738490122,241765459801,241759526876,241813274546,241744371829,241814232429,241776508892,241778755476,241778832431,241769558709,241742939196,241818752444,241773521924,241770743942,241766946882,241772636472,241747991116,241741166173,241777862628,241775667587,241772354952,241738498708,241745470006,241742300415,241768744555,241772671325,241768794661,241764008605,241772740625,241772614349,241771238288,241761343339,241769251025,241761110915,241742804863,241739558294,241762629716,241778685873,241764411024", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-05 14:30:46 Duration: 3s477ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293328", "modelo" : "46", "itens" : "1062D0C8E166,14B7F88E33EE,A456CCE3DEC5,A456CCE0DB44,383FB3A467A6,B42A0EDBE494,54A65C110D93,54A65C106C7E,946A772769AD,383FB3A3BDDF,946A7727C992,14B7F88EA713,54A65C8F1C65,10C25A3B71CA,5C769593675A,10C25A108E8D", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-05 08:13:05 Duration: 3s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 276 12m38s 194ms 3m39s 2s746ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 05 00 12 38s585ms 3s215ms 01 12 20s34ms 1s669ms 02 12 19s771ms 1s647ms 03 12 19s139ms 1s594ms 04 12 19s245ms 1s603ms 05 12 18s920ms 1s576ms 06 12 20s191ms 1s682ms 07 12 3m55s 19s650ms 08 12 30s16ms 2s501ms 09 12 25s416ms 2s118ms 10 12 28s63ms 2s338ms 11 12 23s690ms 1s974ms 12 12 26s317ms 2s193ms 13 12 21s11ms 1s750ms 14 12 28s4ms 2s333ms 15 12 27s846ms 2s320ms 16 12 20s112ms 1s676ms 17 12 20s700ms 1s725ms 18 12 19s823ms 1s651ms 19 12 19s593ms 1s632ms 20 12 36s986ms 3s82ms 21 12 19s413ms 1s617ms 22 12 19s444ms 1s620ms [ User: intelifix - Total duration: 12m38s - Times executed: 276 ]
[ Application: psql - Total duration: 12m38s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 07:48:49 Duration: 3m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 00:05:21 Duration: 18s807ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 20:05:13 Duration: 12s217ms Database: rio User: intelifix Remote: [local] Application: psql
4 213 2h18m11s 153ms 34m51s 38s925ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 05 07 16 8m37s 32s314ms 08 11 12m59s 1m10s 09 22 13m4s 35s677ms 10 33 10m35s 19s251ms 11 28 5m23s 11s546ms 12 14 1h11m9s 5m4s 13 8 48s410ms 6s51ms 14 27 7m5s 15s763ms 15 23 6m48s 17s782ms 16 17 49s839ms 2s931ms 17 11 43s240ms 3s930ms 18 3 5s695ms 1s898ms [ User: intelifix - Total duration: 2h18m11s - Times executed: 213 ]
[ Application: [unknown] - Total duration: 2h18m11s - Times executed: 213 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:38 Duration: 34m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:49 Duration: 21m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030729, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-05 07:48:49 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 132 9m21s 180ms 15s27ms 4s256ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 05 00 1 585ms 585ms 07 12 1m4s 5s407ms 08 13 53s153ms 4s88ms 09 11 57s739ms 5s249ms 10 12 55s401ms 4s616ms 11 12 1m5s 5s458ms 12 12 1m14s 6s246ms 13 8 8s648ms 1s81ms 14 11 50s53ms 4s550ms 15 12 1m1s 5s150ms 16 10 36s662ms 3s666ms 17 6 10s102ms 1s683ms 20 1 180ms 180ms 21 5 11s703ms 2s340ms 22 6 10s503ms 1s750ms [ User: intelifix - Total duration: 9m21s - Times executed: 132 ]
[ Application: psql - Total duration: 9m21s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 15:25:16 Duration: 15s27ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 09:45:14 Duration: 13s728ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 14:35:15 Duration: 13s25ms Database: rio User: intelifix Remote: [local] Application: psql
6 107 2m39s 157ms 6s376ms 1s487ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 05 07 17 19s172ms 1s127ms 09 3 11s312ms 3s770ms 10 20 58s303ms 2s915ms 11 12 19s340ms 1s611ms 12 7 11s99ms 1s585ms 14 18 13s302ms 739ms 15 17 15s377ms 904ms 16 12 5s958ms 496ms 17 1 5s253ms 5s253ms [ User: intelifix - Total duration: 2m39s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137930) LIMIT 1;
Date: 2026-10-05 10:51:07 Duration: 6s376ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139218) LIMIT 1;
Date: 2026-10-05 09:19:44 Duration: 6s1ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137352) LIMIT 1;
Date: 2026-10-05 10:52:05 Duration: 5s873ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 102 34s100ms 150ms 775ms 334ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 05 07 8 3s368ms 421ms 08 14 4s863ms 347ms 09 15 5s2ms 333ms 10 13 4s269ms 328ms 11 13 3s617ms 278ms 12 11 3s874ms 352ms 13 1 186ms 186ms 14 12 4s612ms 384ms 15 14 4s10ms 286ms 16 1 294ms 294ms [ User: intelifix - Total duration: 34s100ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 34s100ms - Times executed: 102 ]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229792191829,229857532033,229820634245,229848662323,229789706075,229769366065,229788792036,229770448001,229863845757,229789824448', NULL, NULL, 0145, 00);
Date: 2026-10-05 14:44:09 Duration: 775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229805166181,229803084463,229789619501,229867298888,229802874162,229788674448,229857523850,229804598998,229903982234,229819759502', NULL, NULL, 0145, 00);
Date: 2026-10-05 08:10:24 Duration: 742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229788851840,229770648200,229791674954,229849653138,229820807696,229770530916,229820978599,229857959403,229725136081,229904531940', NULL, NULL, 0145, 00);
Date: 2026-10-05 08:09:01 Duration: 726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 101 33s115ms 296ms 469ms 327ms 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 Oct 05 06 1 309ms 309ms 07 7 2s253ms 321ms 08 12 3s751ms 312ms 09 9 2s994ms 332ms 10 10 3s362ms 336ms 11 12 3s974ms 331ms 12 3 956ms 318ms 13 10 3s232ms 323ms 14 8 2s642ms 330ms 15 12 3s929ms 327ms 16 8 2s692ms 336ms 17 6 2s97ms 349ms 18 1 303ms 303ms 20 1 305ms 305ms 21 1 308ms 308ms [ User: lenon - Total duration: 33s115ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 33s115ms - Times executed: 101 ]
-
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-10-05 10:13:02 Duration: 469ms 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-10-05 17:12:18 Duration: 407ms 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-10-05 16:24:52 Duration: 402ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 98 19s515ms 150ms 443ms 199ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 05 07 1 161ms 161ms 08 3 572ms 190ms 09 14 3s2ms 214ms 10 12 2s261ms 188ms 11 7 1s404ms 200ms 12 8 1s743ms 217ms 13 1 161ms 161ms 14 1 215ms 215ms 15 41 7s900ms 192ms 16 7 1s321ms 188ms 17 1 220ms 220ms 20 2 549ms 274ms [ User: intelifix - Total duration: 19s515ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 19s515ms - Times executed: 98 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('946A7727208F');
Date: 2026-10-05 09:15:06 Duration: 443ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('ZTE3ANNQ9J19689');
Date: 2026-10-05 20:57:17 Duration: 353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229872958195');
Date: 2026-10-05 09:38:02 Duration: 330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 95 34s625ms 153ms 1s197ms 364ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 05 07 1 1s117ms 1s117ms 08 17 8s161ms 480ms 09 5 1s336ms 267ms 10 10 3s245ms 324ms 11 17 5s923ms 348ms 12 6 1s378ms 229ms 13 2 1s661ms 830ms 14 18 5s457ms 303ms 15 9 3s203ms 355ms 16 5 1s241ms 248ms 17 5 1s899ms 379ms [ User: intelifix - Total duration: 34s625ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 34s625ms - Times executed: 95 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, 'BC9B6897A295,D4B92F264F3A,54A65C91835B,10C25A15790C,1062D0132B3D,383FB3A51350,B42A0E9ADD15,10C25A10FFF2,383FB3A6587C,087E648335E6,B42A0E19A24A,10C25A16BA17,905851A6B6AC,14B7F88D2786,5C76959335C7,D4B92F2DC5A7,48003303AD0C,BC9B68977412,D4B92F275B2B,A456CCE49C90,D4B92F28A6AF,1062D09EB154,905851AD00CF,D4B92F2CC881,383FB3A336BD,A456CCE54ACC,90585144AE13,383FB3A4FCF2,1062D0C5AA61,1062D012312E,14B7F88E0024,905851A7D2F0,BC9B6895C863,54A65C8AE5E7,54A65C904F8C,70037E9F2D7F,70037E9C8376', '','DEFAULT',056,046,'', '','', 00);
Date: 2026-10-05 13:58:45 Duration: 1s197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '14200454E386,E44E12AF7B09,7C7D21F0F4DF,DC5193DBFDB2,7C7D21F1D323,7C7D21ECEF07,E44E1291C1DB,7C7D21EEEC4B,7C7D21ED64AB,DC5193DA895E,DC5193D8C1CA,DC5193DAEE5A,14200455D25E,DC5193D8BF1E,14200452E4E6,7C7D21EFFFCF,7C7D21EB670B,DC5193DAEE1A', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-10-05 15:14:16 Duration: 1s165ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '3CF9F0AC377A,689E29BD9411,C4EBFF8AB8E0,D89A0DA474FF,689E29FD3443,4896D9503FD8,5872C98F730B,6C11BA6321B1,843C992FBA0F,6C11BA68A969,C4EBFF8A08AC,843C992FBCA3,4896D950154E,3891484B0F07,F4E84F82FB6E,F4E84F88AD1A,D83139932348,D831391E62EE,D89A0DA69B25,D83139243B8E', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-05 07:56:57 Duration: 1s117ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 93 36s746ms 339ms 560ms 395ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 05 07 5 1s857ms 371ms 08 11 4s177ms 379ms 09 8 3s307ms 413ms 10 10 3s973ms 397ms 11 12 4s694ms 391ms 12 3 1s229ms 409ms 13 10 3s770ms 377ms 14 7 2s883ms 411ms 15 12 4s791ms 399ms 16 8 3s149ms 393ms 17 6 2s542ms 423ms 18 1 368ms 368ms [ User: intelifix - Total duration: 36s746ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 36s746ms - Times executed: 93 ]
-
select * from rs_menu_grants (398, 53, 1);
Date: 2026-10-05 15:03:53 Duration: 560ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-10-05 17:07:23 Duration: 540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-10-05 14:24:14 Duration: 533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 92 27s483ms 260ms 378ms 298ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 05 07 2 560ms 280ms 08 6 1s765ms 294ms 09 16 4s970ms 310ms 10 12 3s597ms 299ms 11 8 2s345ms 293ms 12 2 588ms 294ms 13 5 1s438ms 287ms 14 6 1s857ms 309ms 15 26 7s704ms 296ms 16 3 959ms 319ms 17 5 1s403ms 280ms 18 1 293ms 293ms [ User: intelifix - Total duration: 27s483ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 27s483ms - Times executed: 92 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-10-05 15:24:05 Duration: 378ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-10-05 15:47:52 Duration: 351ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-10-05 09:42:51 Duration: 349ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 56 4m57s 1s70ms 40s779ms 5s320ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 05 08 1 10s975ms 10s975ms 09 8 1m5s 8s241ms 10 5 17s414ms 3s482ms 11 3 21s180ms 7s60ms 12 3 19s806ms 6s602ms 13 8 27s625ms 3s453ms 14 5 29s533ms 5s906ms 15 11 56s698ms 5s154ms 16 3 13s7ms 4s335ms 17 9 35s775ms 3s975ms [ User: intelifix - Total duration: 4m57s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 4m57s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0302, '', '', 0, 6, '2026-10-02');
Date: 2026-10-05 09:04:11 Duration: 40s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-05 12:14:44 Duration: 14s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-05 14:45:28 Duration: 12s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 53 1m33s 573ms 19s226ms 1s766ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 05 08 3 2s617ms 872ms 09 4 6s887ms 1s721ms 10 3 2s188ms 729ms 11 3 2s456ms 818ms 12 3 2s463ms 821ms 13 3 4s772ms 1s590ms 14 4 6s466ms 1s616ms 15 5 21s354ms 4s270ms 16 3 2s252ms 750ms 17 3 2s745ms 915ms 18 4 26s424ms 6s606ms 19 3 2s264ms 754ms 20 4 3s956ms 989ms 21 4 3s329ms 832ms 22 4 3s463ms 865ms [ User: intelifix - Total duration: 1m33s - Times executed: 53 ]
[ Application: psql - Total duration: 1m33s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-05 18:00:21 Duration: 19s226ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-05 15:00:12 Duration: 11s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-05 15:20:08 Duration: 7s856ms Database: rio User: intelifix Remote: [local] Application: psql
15 53 36s640ms 151ms 1s542ms 691ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 05 11 53 36s640ms 691ms [ User: intelifix - Total duration: 36s640ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 36s640ms - Times executed: 53 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60204","seriais":"A8705D864DCB,A8705D739FAF,A8705D815D66,A8705D759CBF,A8705D7A831F,F820D207ACDE,A8705D866338,A8705D839BB7,F8790A70F1D3,A8705D72E2A4,A8705D836A16,A8705D733A5B","usuario":"416","observacao":""}');
Date: 2026-10-05 11:29:17 Duration: 1s542ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60204","seriais":"484BD4B16CBC,4075C3995358,B85E71E18534,B85E71E2D718,B85E7110B958,C4509CAB4A34,C4509CEB1354,80DAC2CCF438,B85E710EC508,484BD4A598E4,484BD4AD3B1C,8C6A8DC2F6DC,C4509CB059A4,B85E710FA748,3C82C08B7968,C4509CBC9F1C","usuario":"416","observacao":""}');
Date: 2026-10-05 11:29:23 Duration: 1s291ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60204","seriais":"B4F2670C1194,6802B8648BF7,6802B8F098C0,6802B8ACB2B5,6802B8F0088D,6802B862C604,6802B8F8A3B0,B4F2674E82E0,B4F2673348A1,B4F2670BE6DD,B4F2674E4AD0,6802B8AB1E09,6802B823CCA0,6802B8CF1E60,6802B8CF053A,6802B8F82613,6802B8622D7C","usuario":"416","observacao":""}');
Date: 2026-10-05 11:30:36 Duration: 1s277ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 51 11m5s 10s676ms 45s708ms 13s41ms create table temp0000293306 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 05 07 9 2m14s 14s933ms 08 8 1m29s 11s197ms 09 11 2m38s 14s395ms 10 14 2m49s 12s90ms 11 3 36s386ms 12s128ms 14 6 1m17s 12s850ms [ User: intelifix - Total duration: 11m5s - Times executed: 51 ]
[ Application: [unknown] - Total duration: 11m5s - Times executed: 51 ]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 07:38:09 Duration: 45s708ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:26:01 Duration: 28s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:09:28 Duration: 23s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 48 1h44m50s 2s337ms 9m25s 2m11s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 05 07 3 10m7s 3m22s 08 3 6m7s 2m2s 09 3 6m20s 2m6s 10 3 6m12s 2m4s 11 3 6m33s 2m11s 12 3 6m8s 2m2s 13 3 6m 2m 14 3 6m20s 2m6s 15 3 6m41s 2m13s 16 3 6m41s 2m13s 17 3 6m20s 2m6s 18 3 5m50s 1m56s 19 3 5m45s 1m55s 20 3 7m32s 2m30s 21 3 6m31s 2m10s 22 3 5m36s 1m52s [ User: intelifix - Total duration: 1h44m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 07:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 20:12:06 Duration: 7m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 15:11:23 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: psql
18 48 1h9m58s 239ms 3m54s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 05 07 3 5m35s 1m51s 08 3 4m21s 1m27s 09 3 4m12s 1m24s 10 3 4m16s 1m25s 11 3 4m21s 1m27s 12 3 4m20s 1m26s 13 3 4m11s 1m23s 14 3 4m33s 1m31s 15 3 4m24s 1m28s 16 3 4m19s 1m26s 17 3 4m16s 1m25s 18 3 4m5s 1m21s 19 3 3m59s 1m19s 20 3 5m2s 1m40s 21 3 3m57s 1m19s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h9m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 14:15:52 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 08:15:22 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 07:20:31 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
19 48 42s895ms 157ms 10s1ms 893ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 05 08 2 321ms 160ms 09 5 3s86ms 617ms 10 4 2s975ms 743ms 11 6 4s935ms 822ms 12 8 7s50ms 881ms 13 3 1s34ms 344ms 14 7 4s662ms 666ms 15 7 5s462ms 780ms 16 4 12s616ms 3s154ms 17 2 750ms 375ms [ User: intelifix - Total duration: 42s895ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 42s895ms - Times executed: 48 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-10-05", "data-ate" : "2026-10-05", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-10-05 16:24:53 Duration: 10s1ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-10-05", "data-ate" : "2026-10-05", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-10-05 15:30:25 Duration: 1s814ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-10-05", "data-ate" : "2026-10-05", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-10-05 15:48:19 Duration: 1s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 47 14s549ms 151ms 1s970ms 309ms create table temp0000292986 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 05 11 5 1s185ms 237ms 13 28 9s667ms 345ms 14 9 2s65ms 229ms 16 2 513ms 256ms 17 3 1s116ms 372ms [ User: intelifix - Total duration: 14s549ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 14s549ms - Times executed: 47 ]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, 'ZTEGDC6250DA', '2026-10-03', '2026-10-05');
Date: 2026-10-05 13:45:26 Duration: 1s970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, 'ZTEGDB07D520', '2026-10-03', '2026-10-05');
Date: 2026-10-05 13:48:29 Duration: 1s146ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, 'ZTEGD7B9FE4F', '2026-10-03', '2026-10-05');
Date: 2026-10-05 13:39:41 Duration: 488ms 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 2m53s 10m21s 6m49s 3 20m28s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 05 05 3 20m28s 6m49s [ User: intelifix - Total duration: 20m28s - Times executed: 3 ]
[ Application: psql - Total duration: 20m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-05 05:10:22 Duration: 10m21s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-05 05:17:36 Duration: 7m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-05 05:20:30 Duration: 2m53s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s337ms 9m25s 2m11s 48 1h44m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 05 07 3 10m7s 3m22s 08 3 6m7s 2m2s 09 3 6m20s 2m6s 10 3 6m12s 2m4s 11 3 6m33s 2m11s 12 3 6m8s 2m2s 13 3 6m 2m 14 3 6m20s 2m6s 15 3 6m41s 2m13s 16 3 6m41s 2m13s 17 3 6m20s 2m6s 18 3 5m50s 1m56s 19 3 5m45s 1m55s 20 3 7m32s 2m30s 21 3 6m31s 2m10s 22 3 5m36s 1m52s [ User: intelifix - Total duration: 1h44m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 07:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 20:12:06 Duration: 7m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-05 15:11:23 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: psql
3 239ms 3m54s 1m27s 48 1h9m58s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 05 07 3 5m35s 1m51s 08 3 4m21s 1m27s 09 3 4m12s 1m24s 10 3 4m16s 1m25s 11 3 4m21s 1m27s 12 3 4m20s 1m26s 13 3 4m11s 1m23s 14 3 4m33s 1m31s 15 3 4m24s 1m28s 16 3 4m19s 1m26s 17 3 4m16s 1m25s 18 3 4m5s 1m21s 19 3 3m59s 1m19s 20 3 5m2s 1m40s 21 3 3m57s 1m19s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h9m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 14:15:52 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 08:15:22 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-05 07:20:31 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
4 153ms 34m51s 38s925ms 213 2h18m11s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 05 07 16 8m37s 32s314ms 08 11 12m59s 1m10s 09 22 13m4s 35s677ms 10 33 10m35s 19s251ms 11 28 5m23s 11s546ms 12 14 1h11m9s 5m4s 13 8 48s410ms 6s51ms 14 27 7m5s 15s763ms 15 23 6m48s 17s782ms 16 17 49s839ms 2s931ms 17 11 43s240ms 3s930ms 18 3 5s695ms 1s898ms [ User: intelifix - Total duration: 2h18m11s - Times executed: 213 ]
[ Application: [unknown] - Total duration: 2h18m11s - Times executed: 213 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:38 Duration: 34m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-05 12:01:49 Duration: 21m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030729, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-05 07:48:49 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 4s376ms 1m4s 33s860ms 4 2m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 05 20 2 1m8s 34s258ms 23 2 1m6s 33s462ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-05 20:08:44 Duration: 1m4s 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-10-05 23:16:40 Duration: 1m2s 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-10-05 20:10:46 Duration: 4s402ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 349ms 53s437ms 26s888ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 05 20 2 53s752ms 26s876ms 23 2 53s800ms 26s900ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-05 23:13:44 Duration: 53s437ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-05 20:05:46 Duration: 53s402ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-05 23:33:26 Duration: 363ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s273ms 40s291ms 18s19ms 6 1m48s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 05 20 3 54s73ms 18s24ms 23 3 54s40ms 18s13ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-05 23:14:27 Duration: 40s291ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-05 20:06:29 Duration: 40s197ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-05 20:10:22 Duration: 10s602ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s990ms 38s965ms 17s712ms 9 2m39s create table temp0000293120 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 05 08 2 22s970ms 11s485ms 09 3 1m3s 21s194ms 14 3 1m1s 20s365ms 15 1 11s762ms 11s762ms [ User: intelifix - Total duration: 2m39s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 9 ]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:05:37 Duration: 38s965ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 14:08:59 Duration: 34s989ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 14:43:14 Duration: 13s83ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s610ms 34s61ms 14s781ms 8 1m58s create table temp0000293364 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 05 10 4 46s788ms 11s697ms 11 4 1m11s 17s865ms [ User: intelifix - Total duration: 1m58s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1m58s - Times executed: 8 ]
-
CREATE TABLE temp0000293364 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 11:23:05 Duration: 34s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293364 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 11:25:20 Duration: 12s862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293364 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 11:23:38 Duration: 12s305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s676ms 45s708ms 13s41ms 51 11m5s create table temp0000293306 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 05 07 9 2m14s 14s933ms 08 8 1m29s 11s197ms 09 11 2m38s 14s395ms 10 14 2m49s 12s90ms 11 3 36s386ms 12s128ms 14 6 1m17s 12s850ms [ User: intelifix - Total duration: 11m5s - Times executed: 51 ]
[ Application: [unknown] - Total duration: 11m5s - Times executed: 51 ]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 07:38:09 Duration: 45s708ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:26:01 Duration: 28s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293306 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:09:28 Duration: 23s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 11s591ms 12s674ms 11s983ms 9 1m47s create table temp0000293326 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 05 09 9 1m47s 11s983ms [ User: intelifix - Total duration: 1m47s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m47s - Times executed: 9 ]
-
CREATE TABLE temp0000293326 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:49:18 Duration: 12s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293326 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:46:59 Duration: 12s174ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293326 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-05 09:48:29 Duration: 12s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 156ms 1m24s 8s863ms 29 4m17s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 05 07 3 1s485ms 495ms 08 4 32s790ms 8s197ms 09 8 1m 7s560ms 10 6 38s46ms 6s341ms 11 2 1m25s 42s596ms 14 4 31s253ms 7s813ms 15 2 7s786ms 3s893ms [ User: intelifix - Total duration: 4m17s - Times executed: 29 ]
[ Application: psql - Total duration: 4m17s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030756);
Date: 2026-10-05 11:24:49 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030754);
Date: 2026-10-05 10:48:37 Duration: 36s769ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030738);
Date: 2026-10-05 09:27:23 Duration: 35s738ms Database: rio User: intelifix Remote: [local] Application: psql
13 270ms 1m5s 8s404ms 29 4m3s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 05 07 2 1m9s 34s930ms 08 3 25s316ms 8s438ms 09 6 1m 10s82ms 10 3 19s94ms 6s364ms 11 2 19s33ms 9s516ms 14 6 24s842ms 4s140ms 15 7 25s87ms 3s583ms [ User: intelifix - Total duration: 4m3s - Times executed: 29 ]
[ Application: psql - Total duration: 4m3s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030729);
Date: 2026-10-05 07:40:55 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030742);
Date: 2026-10-05 09:47:16 Duration: 28s826ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030732);
Date: 2026-10-05 08:25:53 Duration: 16s893ms Database: rio User: intelifix Remote: [local] Application: psql
14 1s70ms 40s779ms 5s320ms 56 4m57s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 05 08 1 10s975ms 10s975ms 09 8 1m5s 8s241ms 10 5 17s414ms 3s482ms 11 3 21s180ms 7s60ms 12 3 19s806ms 6s602ms 13 8 27s625ms 3s453ms 14 5 29s533ms 5s906ms 15 11 56s698ms 5s154ms 16 3 13s7ms 4s335ms 17 9 35s775ms 3s975ms [ User: intelifix - Total duration: 4m57s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 4m57s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0302, '', '', 0, 6, '2026-10-02');
Date: 2026-10-05 09:04:11 Duration: 40s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-05 12:14:44 Duration: 14s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-05 14:45:28 Duration: 12s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 180ms 15s27ms 4s256ms 132 9m21s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 05 00 1 585ms 585ms 07 12 1m4s 5s407ms 08 13 53s153ms 4s88ms 09 11 57s739ms 5s249ms 10 12 55s401ms 4s616ms 11 12 1m5s 5s458ms 12 12 1m14s 6s246ms 13 8 8s648ms 1s81ms 14 11 50s53ms 4s550ms 15 12 1m1s 5s150ms 16 10 36s662ms 3s666ms 17 6 10s102ms 1s683ms 20 1 180ms 180ms 21 5 11s703ms 2s340ms 22 6 10s503ms 1s750ms [ User: intelifix - Total duration: 9m21s - Times executed: 132 ]
[ Application: psql - Total duration: 9m21s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 15:25:16 Duration: 15s27ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 09:45:14 Duration: 13s728ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-05 14:35:15 Duration: 13s25ms Database: rio User: intelifix Remote: [local] Application: psql
16 583ms 9s156ms 3s523ms 36 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 #16
Day Hour Count Duration Avg duration Oct 05 08 3 6s825ms 2s275ms 09 2 10s716ms 5s358ms 10 3 18s877ms 6s292ms 11 3 20s404ms 6s801ms 12 3 8s497ms 2s832ms 13 2 10s957ms 5s478ms 14 2 9s769ms 4s884ms 15 1 5s142ms 5s142ms 16 3 12s410ms 4s136ms 17 3 14s589ms 4s863ms 18 2 1s696ms 848ms 19 3 2s434ms 811ms 20 2 1s458ms 729ms 21 2 1s617ms 808ms 22 2 1s462ms 731ms [ User: intelifix - Total duration: 2m6s - Times executed: 36 ]
[ Application: psql - Total duration: 2m6s - Times executed: 36 ]
-
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-10-05 17:00:10 Duration: 9s156ms 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-10-05 09:40:10 Duration: 8s660ms 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-10-05 13:40:09 Duration: 8s644ms Database: rio User: intelifix Remote: [local] Application: psql
17 194ms 3m39s 2s746ms 276 12m38s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 05 00 12 38s585ms 3s215ms 01 12 20s34ms 1s669ms 02 12 19s771ms 1s647ms 03 12 19s139ms 1s594ms 04 12 19s245ms 1s603ms 05 12 18s920ms 1s576ms 06 12 20s191ms 1s682ms 07 12 3m55s 19s650ms 08 12 30s16ms 2s501ms 09 12 25s416ms 2s118ms 10 12 28s63ms 2s338ms 11 12 23s690ms 1s974ms 12 12 26s317ms 2s193ms 13 12 21s11ms 1s750ms 14 12 28s4ms 2s333ms 15 12 27s846ms 2s320ms 16 12 20s112ms 1s676ms 17 12 20s700ms 1s725ms 18 12 19s823ms 1s651ms 19 12 19s593ms 1s632ms 20 12 36s986ms 3s82ms 21 12 19s413ms 1s617ms 22 12 19s444ms 1s620ms [ User: intelifix - Total duration: 12m38s - Times executed: 276 ]
[ Application: psql - Total duration: 12m38s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 07:48:49 Duration: 3m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 00:05:21 Duration: 18s807ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-05 20:05:13 Duration: 12s217ms Database: rio User: intelifix Remote: [local] Application: psql
18 573ms 19s226ms 1s766ms 53 1m33s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 05 08 3 2s617ms 872ms 09 4 6s887ms 1s721ms 10 3 2s188ms 729ms 11 3 2s456ms 818ms 12 3 2s463ms 821ms 13 3 4s772ms 1s590ms 14 4 6s466ms 1s616ms 15 5 21s354ms 4s270ms 16 3 2s252ms 750ms 17 3 2s745ms 915ms 18 4 26s424ms 6s606ms 19 3 2s264ms 754ms 20 4 3s956ms 989ms 21 4 3s329ms 832ms 22 4 3s463ms 865ms [ User: intelifix - Total duration: 1m33s - Times executed: 53 ]
[ Application: psql - Total duration: 1m33s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-05 18:00:21 Duration: 19s226ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-05 15:00:12 Duration: 11s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-05 15:20:08 Duration: 7s856ms Database: rio User: intelifix Remote: [local] Application: psql
19 157ms 6s376ms 1s487ms 107 2m39s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 05 07 17 19s172ms 1s127ms 09 3 11s312ms 3s770ms 10 20 58s303ms 2s915ms 11 12 19s340ms 1s611ms 12 7 11s99ms 1s585ms 14 18 13s302ms 739ms 15 17 15s377ms 904ms 16 12 5s958ms 496ms 17 1 5s253ms 5s253ms [ User: intelifix - Total duration: 2m39s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137930) LIMIT 1;
Date: 2026-10-05 10:51:07 Duration: 6s376ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139218) LIMIT 1;
Date: 2026-10-05 09:19:44 Duration: 6s1ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137352) LIMIT 1;
Date: 2026-10-05 10:52:05 Duration: 5s873ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 152ms 8s701ms 909ms 1,237 18m45s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 05 07 6 6s955ms 1s159ms 08 46 50s579ms 1s99ms 09 132 2m5s 947ms 10 149 2m17s 921ms 11 125 2m 964ms 12 38 35s191ms 926ms 13 100 1m38s 985ms 14 198 3m11s 965ms 15 198 2m48s 851ms 16 192 2m35s 811ms 17 52 34s351ms 660ms 18 1 1s25ms 1s25ms [ User: intelifix - Total duration: 18m45s - Times executed: 1237 ]
[ Application: [unknown] - Total duration: 18m45s - Times executed: 1237 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293511, 317, '835169925005603,241691395659,241620596875,241646306971,241631546990,241604354763,241731663237,241602979410,241727529095,241678278587,241700796363,241607662123,241680272240,241731658892,241713835167,241689524646,241699056373', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-05 16:22:50 Duration: 8s701ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293448, 503, '2102312JCYRYK9910310,D0C65B2FA777,485754438C55149FJCYRYL3903276,541310DD8B16,485754430E335BA2JCYRYL2900036,AC8D34A176AB,48575443158EFAA1JCYRYL3001007,541310DC4E61,485754430E213AA2JCYRYL2001380,AC8D34A08B46,4857544315812DA1JCYRYK1017710,2841C6885AF7,485754434190F79E', '',0147,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-05 11:24:49 Duration: 6s880ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293450, 433, '722153037657,B4F267211FB9,6802B8648E94,6802B814EEE2,6802B85266CA,B4F267579565,6802B8F853BB,6802B8DB7F1F,6802B8A43812,6802B8F0120B,6802B8F03BC6,6802B86329F1,6802B8AC60A7,B4F2675DF51F,6802B8ACBE91,6802B814C4F7,B4F26758C1B3,B4F2673358F1,6802B8A1DB4A,6802B8DE520D,B4F267577C27,6802B8AC51BC,B4F2673350CF,6802B8F8D71C,6802B8CA3542,6802B85B62A2,6802B8ACB513,6802B86267AE,6802B86304B0,B4F2672043A5,6802B8AC87C2,6802B8A3BE0E,B4F267575DC7,6802B8A2DE4F,B4F2670BFFE5,6802B8CAA340,6802B8F0334D,6802B8526A66,6802B8241020,6802B85B9731,B4F2675817A6', '',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-10-05 10:03:52 Duration: 4s385ms 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 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 05 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 941ms - Times executed: 3 ]
[ Application: psql - Total duration: 941ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,953 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 42 FATAL entries
- 5238 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,203 Max number of times the same event was reported
- 5,290 Total events found
Rank Times reported Error 1 5,203 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 05 00 118 01 120 02 120 03 116 04 120 05 119 06 118 07 249 08 414 09 445 10 388 11 420 12 201 13 268 14 389 15 391 16 236 17 189 18 175 19 155 20 118 21 116 22 118 23 100 - ERROR: prepared statement "_PLAN0000000029EF0BD0" does not exist
- ERROR: prepared statement "_PLAN0000000029B616D0" does not exist
- ERROR: prepared statement "_PLAN0000000029EEC2D0" does not exist
Statement: DEALLOCATE "_PLAN0000000029EF0BD0"
Date: 2026-10-05 00:00:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B616D0"
Date: 2026-10-05 00:00:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029EEC2D0"
Date: 2026-10-05 00:01:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 30 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 05 03 8 15 22 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-05 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-05 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-05 03:05:01 Database: testes Application: [unknown] User: intelifix Remote: [local]
3 20 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 05 07 1 12 16 14 1 16 2 - ERROR: syntax error at or near "diagnostics" at character 42
- ERROR: syntax error at or near "ZTEYH7VP7M11724" at character 32
- ERROR: syntax error at or near "ZTEYH7VP7M11724" at character 81
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-10-05 07:57:05 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''ZTEYH7VP7M11724' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''ZTEYH7VP7M11724' )
Date: 2026-10-05 12:03:29 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"139374","seriais":[{"serial":"'ZTEYH7VP7M11724"},{"serial":""}]}')
Date: 2026-10-05 12:03:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 05 00 1 03 1 06 1 07 1 09 1 11 1 16 2 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-05 00:12:25 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-05 03:52:42 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-05 06:42:33 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 05 07 1 11 3 12 1 - LOG: process 808919 still waiting for ShareLock on transaction 7230668 after 1000.123 ms
- LOG: process 1003548 still waiting for ShareLock on transaction 7247086 after 1000.155 ms
- LOG: process 1003548 still waiting for ShareLock on transaction 7247086 after 9376.613 ms
Detail: Process holding the lock: 803984. Wait queue: 808919.
Context: while updating tuple (81781,24) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-10-05 07:45:14 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 958921. Wait queue: 1003548.
Context: while updating tuple (81867,74) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-05 11:40:20 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 958921. Wait queue: 1003548.
Context: while updating tuple (81867,74) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-05 11:40:28 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 5 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 05 08 4 14 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, numeric) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, numeric) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139364,399,'721271106658,6802B8DEC49D$722118126952,B4F2670BE3AD$720357077554,6802B862F331$721258024159,6802B8DBBE43$721253275051,6802B8DB9332$720281000758,6802B85C060D$722329133152,B4F267578D64$722056027755,B4F2670BB1BE$722213000553,B4F2673421B5$722335048150,B4F267580F5A','',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',042670E3);Date: 2026-10-05 08:53:28 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139364,399,'721271106658,6802B8DEC49D$722118126952,B4F2670BE3AD$720357077554,6802B862F331$721258024159,6802B8DBBE43$721253275051,6802B8DB9332$720281000758,6802B85C060D$722329133152,B4F267578D64$722056027755,B4F2670BB1BE$722213000553,B4F2673421B5$722335048150,B4F267580F5A','',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',042670E3);Date: 2026-10-05 08:53:34 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139364,399,'720196032752,6802B8154BB5$720365005051,6802B8634368$720195013158,6802B8153E2C$720155034056,6802B8140662$722312105951,B4F2674E3420$721060079958,6802B8A49EF9$722119111759,B4F2670BF9D9$721272022254,6802B8DECC11$721299070054,6802B8F0434F$721257049955,6802B8DBBABF','',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',068028153E2);Date: 2026-10-05 08:58:57 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 05 09 2 12 2 - ERROR: trailing junk after numeric literal at or near "2426D601888C" at character 27
- ERROR: trailing junk after numeric literal at or near "2426D601888C" at character 27
- ERROR: trailing junk after numeric literal at or near "9C24722F5650" at character 27
Statement: select * from rs_caixa_qr(2426D601888C)
Date: 2026-10-05 09:06:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(2426D601888C)
Date: 2026-10-05 09:06:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(9C24722F5650)
Date: 2026-10-05 12:19:32 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 05 03 3 15 1 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-05 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-05 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-05 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 05 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-10-05 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-05 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-05 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local]
10 3 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 05 11 3 - LOG: process 1028866 still waiting for ExclusiveLock on tuple (81867,74) of relation 363850 of database 358220 after 1000.088 ms
- LOG: process 1028866 still waiting for ExclusiveLock on tuple (81867,74) of relation 363850 of database 358220 after 9152.653 ms
- LOG: process 1028866 still waiting for ExclusiveLock on tuple (81867,74) of relation 363850 of database 358220 after 88283.606 ms
Detail: Process holding the lock: 1003548. Wait queue: 1028866.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-05 11:54:03 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1003548. Wait queue: 1028866.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-05 11:54:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1003548. Wait queue: 1028866.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 030756, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-05 11:55:31 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 05 03 1 15 1 - LOG: database system was shut down at 2026-10-05 03:05:02 -03
- LOG: database system was shut down at 2026-10-05 15:01:37 -03
Date: 2026-10-05 03:05:02
Date: 2026-10-05 15:01:38
12 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 05 14 1 - ERROR: column c.mo_id does not exist at character 36
Hint: Perhaps you meant to reference the column "c.mod_id".
Statement: SELECT b.eq_id,B.LI_ID,I.NEM_ID,C.MO_ID,J.MOD_ID FROM LOTES A INNER JOIN LOTE_ITENS B ON B.LOT_ID = A.LOT_ID INNER JOIN EQUIPAMENTOS C ON C.EQ_ID = B.EQ_ID INNER JOIN MODELOS D ON D.MOD_ID = C.MOD_ID INNER JOIN CLIENTES E ON E.CLI_ID = A.CLI_ID LEFT JOIN FLUXOS F ON F.FLU_ID = B.FLU_ID LEFT JOIN TECNICOS G ON G.TEC_ID = F.TEC_ID LEFT JOIN USUARIOS H ON H.USU_ID = G.USU_ID LEFT JOIN NF_ENTRADA_ITENS I ON I.LI_ID = B.LI_ID LEFT JOIN NF_ENTRADA_MODELOS J ON J.NEM_ID = I.NEM_ID AND COALESCE( J.MOD_ID , 0 ) = C.MOD_ID LEFT JOIN NF_ENTRADA K ON K.NF_ID = J.NF_ID LEFT JOIN ACESSORIOS L ON L.ACE_ID = B.ACE_ID INNER JOIN USUARIOS M ON M.USU_ID = B.USU_ID WHERE a.lot_id=59979Date: 2026-10-05 14:52:08 Database: contagem Application: pgAdmin 4 - CONN:6881772 User: lenon Remote: 172.20.0.3
13 1 ERROR: function rs_grupos_comob(...) does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 05 16 1 - ERROR: function rs_grupos_comob(integer, unknown) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_grupos_comob(0,'')Date: 2026-10-05 16:25:13 Database: brasilia Application: pgAdmin 4 - CONN:3874972 User: lenon Remote: 172.20.0.3