pgBadger-
Global information
- Generated on Sun Oct 4 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 13,740 log entries in 8s
- Log start from 2026-10-04 00:00:53 to 2026-10-04 23:49:42
-
Overview
Global Stats
- 142 Number of unique normalized queries
- 925 Number of queries
- 4h2m37s Total query duration
- 2026-10-04 00:02:03 First query
- 2026-10-04 23:43:23 Last query
- 5 queries/s at 2026-10-04 23:43:18 Query peak
- 4h2m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h2m37s Execute total duration
- 2,865 Number of events
- 6 Number of unique normalized events
- 2,836 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 20 Number temporary file
- 248.84 MiB Max size of temporary file
- 67.72 MiB Average size of temporary file
- 217 Total number of sessions
- 9 sessions at 2026-10-04 00:05:03 Session peak
- 8d5h52m7s Total duration of sessions
- 54m42s Average duration of sessions
- 4 Average queries per session
- 1m7s Average queries duration per session
- 53m35s Average idle time per session
- 233 Total number of connections
- 5 connections/s at 2026-10-04 06:02:03 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-04 23:43:18 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-10-04 06:02:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-04 23:43:18 Date
Queries duration
Key values
- 4h2m37s 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 04 00 23 0ms 16s833ms 3s518ms 2s981ms 3s113ms 1m1s 01 12 0ms 2s963ms 1s557ms 3s23ms 3s115ms 3s255ms 02 12 0ms 3s151ms 1s560ms 2s973ms 3s154ms 3s387ms 03 14 0ms 3s137ms 1s385ms 2s998ms 3s162ms 3s768ms 04 12 0ms 3s46ms 1s590ms 3s56ms 3s236ms 3s315ms 05 17 0ms 10m7s 1m17s 3s403ms 2m47s 10m7s 06 19 0ms 11s237ms 2s596ms 3s136ms 3s293ms 30s643ms 07 18 0ms 9m52s 56s306ms 3s424ms 1m50s 9m52s 08 25 0ms 5m18s 24s17ms 3s305ms 15s353ms 5m47s 09 24 0ms 5m25s 25s346ms 3s105ms 15s631ms 5m56s 10 24 0ms 5m22s 25s235ms 3s216ms 15s88ms 5m52s 11 24 0ms 5m15s 24s770ms 3s200ms 15s496ms 5m45s 12 24 0ms 5m23s 25s281ms 3s293ms 15s642ms 5m53s 13 24 0ms 5m16s 24s743ms 3s196ms 15s17ms 5m46s 14 24 0ms 5m13s 24s782ms 3s143ms 15s341ms 5m44s 15 24 0ms 5m23s 25s536ms 3s257ms 15s501ms 5m53s 16 24 0ms 5m19s 25s101ms 3s188ms 14s893ms 5m50s 17 24 0ms 5m19s 25s331ms 3s357ms 14s976ms 5m49s 18 27 0ms 5m21s 22s646ms 3s418ms 15s504ms 5m51s 19 24 0ms 5m18s 24s966ms 3s410ms 15s322ms 5m48s 20 115 0ms 8m15s 13s1ms 1m4s 2m39s 8m15s 21 25 0ms 6m39s 27s488ms 3s337ms 46s947ms 6m39s 22 24 0ms 5m21s 25s229ms 3s494ms 14s777ms 5m51s 23 342 0ms 1m3s 5s822ms 1m6s 1m6s 1m7s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 04 00 4 0 1s43ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 168ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 614ms 0ms 0ms 0ms 07 6 0 2m45s 0ms 0ms 4m13s 08 7 0 1m21s 0ms 0ms 3m30s 09 6 0 1m37s 0ms 0ms 3m31s 10 6 0 1m36s 0ms 0ms 3m33s 11 6 0 1m35s 0ms 0ms 3m30s 12 6 0 1m37s 0ms 0ms 3m33s 13 6 0 1m35s 0ms 0ms 3m28s 14 6 0 1m35s 0ms 0ms 3m31s 15 6 0 1m38s 0ms 0ms 3m39s 16 6 0 1m36s 0ms 0ms 3m32s 17 6 0 1m37s 0ms 0ms 3m38s 18 9 0 1m5s 0ms 0ms 3m35s 19 6 0 1m35s 0ms 0ms 3m30s 20 17 79 14s979ms 43s628ms 1m3s 3m57s 21 7 0 1m34s 0ms 0ms 3m35s 22 6 0 1m36s 0ms 0ms 3m34s 23 20 322 5s822ms 1m3s 1m6s 1m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 04 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 04 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 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Oct 04 00 22 0.01/s 01 8 0.00/s 02 7 0.00/s 03 14 0.00/s 04 7 0.00/s 05 11 0.00/s 06 15 0.00/s 07 6 0.00/s 08 9 0.00/s 09 8 0.00/s 10 8 0.00/s 11 8 0.00/s 12 9 0.00/s 13 8 0.00/s 14 9 0.00/s 15 8 0.00/s 16 8 0.00/s 17 11 0.00/s 18 8 0.00/s 19 12 0.00/s 20 12 0.00/s 21 7 0.00/s 22 9 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Oct 04 00 4 39m15s 38m54s 01 18 1h1m50s 1h1m49s 02 8 1h 59m58s 03 14 21m28s 21m27s 04 7 1h3m 1h2m57s 05 7 1h26s 57m17s 06 9 57m13s 57m8s 07 15 1h1m36s 1h28s 08 6 1h1s 58m21s 09 9 58m53s 57m45s 10 8 1h22s 59m7s 11 8 1h39s 59m25s 12 8 1h1m8s 59m52s 13 8 1h3s 58m48s 14 8 53m45s 52m31s 15 8 1h23s 59m6s 16 9 54m27s 53m20s 17 7 1h45s 59m19s 18 7 1h46s 59m19s 19 8 57m30s 56m15s 20 11 44m46s 42m30s 21 9 1h50s 59m33s 22 7 1h21s 58m54s 23 14 36m40s 34m18s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-10-04 06:02:03 Date
Connections per database
Key values
- rio Main Database
- 233 connections Total
Connections per user
Key values
- intelifix Main User
- 233 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-04 00:05:03 Date
Histogram of session times
Key values
- 186 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 217 sessions Total
Sessions per user
Key values
- intelifix Main User
- 217 sessions Total
Sessions per host
Key values
- [local] Main Host
- 217 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,895 buffers Checkpoint Peak
- 2026-10-04 00:09:52 Date
- 269.445 seconds Highest write time
- 0.070 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-10-04 03:05:02 Date
Checkpoints distance
Key values
- 92.65 Mo Distance Peak
- 2026-10-04 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 04 00 7,895 269.445s 0.002s 269.46s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 7,317 0.179s 0.072s 0.258s 04 0 0s 0s 0s 05 6,457 648.948s 0.078s 649.075s 06 2,407 241.15s 0.001s 241.154s 07 723 72.383s 0.002s 72.388s 08 23 2.312s 0.001s 2.316s 09 23 2.313s 0.001s 2.317s 10 23 2.314s 0.001s 2.317s 11 23 2.312s 0.002s 2.316s 12 23 2.313s 0.002s 2.317s 13 23 2.312s 0.002s 2.316s 14 23 2.313s 0.001s 2.316s 15 23 2.313s 0.002s 2.316s 16 23 2.312s 0.002s 2.316s 17 23 2.314s 0.002s 2.318s 18 1,419 141.956s 0.006s 141.973s 19 23 2.312s 0.002s 2.316s 20 30 3.027s 0.004s 3.038s 21 23 2.313s 0.002s 2.317s 22 23 2.312s 0.002s 2.317s 23 22 2.21s 0.002s 2.214s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 04 00 0 0 3 34 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 26 0.070s 0.005s 04 0 0 0 0 0s 0s 05 0 0 3 148 0.035s 0.008s 06 0 0 0 8 0.001s 0.001s 07 0 0 1 13 0.002s 0.001s 08 0 0 0 3 0.001s 0.001s 09 0 0 0 3 0.001s 0.001s 10 0 0 0 3 0.001s 0.001s 11 0 0 0 3 0.001s 0.001s 12 0 0 0 3 0.001s 0.001s 13 0 0 0 3 0.001s 0.001s 14 0 0 0 3 0.001s 0.001s 15 0 0 0 3 0.001s 0.001s 16 0 0 0 3 0.001s 0.001s 17 0 0 0 3 0.001s 0.001s 18 0 0 0 78 0.002s 0.004s 19 0 0 0 3 0.001s 0.001s 20 0 0 0 11 0.001s 0.003s 21 0 0 0 3 0.001s 0.001s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 1 0.001s 0.001s Day Hour Count Avg time (sec) Oct 04 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 04 00 42,126.00 kB 42,126.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 23,719.00 kB 23,719.00 kB 04 0.00 kB 0.00 kB 05 7,440.57 kB 11,268.43 kB 06 6,742.00 kB 12,279.00 kB 07 7,106.00 kB 11,762.00 kB 08 187.00 kB 10,604.00 kB 09 188.00 kB 9,562.00 kB 10 187.00 kB 8,625.00 kB 11 188.00 kB 7,781.00 kB 12 187.00 kB 7,022.00 kB 13 188.00 kB 6,338.00 kB 14 187.00 kB 5,723.00 kB 15 188.00 kB 5,170.00 kB 16 187.00 kB 4,671.00 kB 17 188.00 kB 4,223.00 kB 18 1,185.75 kB 3,747.50 kB 19 188.00 kB 2,903.00 kB 20 272.33 kB 2,401.00 kB 21 188.00 kB 1,993.00 kB 22 187.00 kB 1,812.00 kB 23 76.00 kB 1,639.00 kB -
Temporary Files
Size of temporary files
Key values
- 497.67 MiB Temp Files size Peak
- 2026-10-04 05:31:59 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-04 05:32:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 04 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 0 0 0 11 0 0 0 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-04 05:32:08 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-04 05:31:59 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-04 05:30:42 Duration: 40s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-04 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 248.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 248.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-04 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-04 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-04 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-04 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.14 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 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-04 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 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-04 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-04 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.25 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-10-04 05:10:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.25 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-10-04 05:10:34 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database rio
- 6 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_statistic 1 1 0 0 0 0 0 3,195 1,242 4,285,607 1,175 6,981 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 125 6 10,487 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 169 38 122,511 11 24 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,725 671 2,500,937 637 4,382 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,114 3 148,821 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 865 252 1,203,036 158 483 Total 6 6 0 0 0 0 0 9,193 2,212 8,271,399 1,981 11,870 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.25) 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
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4745) Main table with removed tuples on database rio
- 13814 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,745 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,298 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,890 7,360 0 0 1,071 rio.pg_toast.pg_toast_2619 1 1 656 670 0 40 241 brasilia.pg_toast.pg_toast_2619 1 1 126 134 0 10 57 contagem.pg_toast.pg_toast_2619 1 1 99 114 0 28 27 Total 6 6 13,814 23,016 0 78 3,693 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (40) Main table with removed pages on database rio
- 78 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 656 40 contagem.pg_toast.pg_toast_2619 1 1 99 28 brasilia.pg_toast.pg_toast_2619 1 1 126 10 rio.pg_catalog.pg_statistic 1 1 4745 0 brasilia.pg_catalog.pg_statistic 1 1 3890 0 contagem.pg_catalog.pg_statistic 1 1 4298 0 Total 6 6 13,814 78 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.25 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 142 Total read queries
- 401 Total write queries
Queries by database
Key values
- rio Main database
- 389 Requests
- 2h35m54s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 909 Requests
User Request type Count Duration etiquetas Total 8 3s410ms select 8 3s410ms intelifix Total 909 4h2m26s copy to 401 42m21s others 382 32m18s select 126 2h47m46s lenon Total 8 6s632ms select 8 6s632ms Duration by user
Key values
- 4h2m26s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 8 3s410ms select 8 3s410ms intelifix Total 909 4h2m26s copy to 401 42m21s others 382 32m18s select 126 2h47m46s lenon Total 8 6s632ms select 8 6s632ms Queries by host
Key values
- [local] Main host
- 925 Requests
- 4h2m37s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 490 Requests
- 3h20m3s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-04 23:30:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 331 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m7s analyze verbose;[ Date: 2026-10-04 05:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 07:14:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 20:13:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 21:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m38s analyze verbose;[ Date: 2026-10-04 05:16:47 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 09:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 15:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 12:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 10:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 22:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 18:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 17:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 16:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 19:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 08:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 13:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 11:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-04 14:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m2s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-04 07:21:24 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m46s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-04 20:19:27 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h39m36s 48 2s320ms 9m52s 2m4s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 04 07 3 10m38s 3m32s 08 3 5m35s 1m51s 09 3 5m43s 1m54s 10 3 5m40s 1m53s 11 3 5m33s 1m51s 12 3 5m41s 1m53s 13 3 5m33s 1m51s 14 3 5m31s 1m50s 15 3 5m41s 1m53s 16 3 5m36s 1m52s 17 3 5m36s 1m52s 18 3 5m39s 1m53s 19 3 5m36s 1m52s 20 3 8m50s 2m56s 21 3 6m57s 2m19s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 1h39m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h39m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 07:14:54 Duration: 9m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 20:13:17 Duration: 8m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 21:11:41 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: psql
2 1h7m55s 47 236ms 4m2s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 04 07 3 5m56s 1m58s 08 3 3m57s 1m19s 09 3 3m59s 1m19s 10 3 4m1s 1m20s 11 3 3m57s 1m19s 12 3 4m1s 1m20s 13 3 3m56s 1m18s 14 3 3m59s 1m19s 15 3 4m6s 1m22s 16 3 4m2s 1m20s 17 3 4m6s 1m22s 18 3 4m3s 1m21s 19 3 3m58s 1m19s 20 2 5m42s 2m51s 21 3 4m4s 1m21s 22 3 4m1s 1m20s [ User: intelifix - Total duration: 1h7m55s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m55s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 07:21:24 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 20:19:27 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 15:14:46 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
3 19m33s 3 2m47s 10m7s 6m31s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 04 05 3 19m33s 6m31s [ User: intelifix - Total duration: 19m33s - Times executed: 3 ]
[ Application: psql - Total duration: 19m33s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-04 05:10:08 Duration: 10m7s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-04 05:16:47 Duration: 6m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-04 05:19:35 Duration: 2m47s Database: contagem User: intelifix Remote: [local] Application: psql
4 8m13s 276 193ms 16s833ms 1s788ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 04 00 12 36s54ms 3s4ms 01 12 18s693ms 1s557ms 02 12 18s728ms 1s560ms 03 12 19s53ms 1s587ms 04 12 19s81ms 1s590ms 05 12 19s708ms 1s642ms 06 12 19s669ms 1s639ms 07 12 19s398ms 1s616ms 08 12 19s303ms 1s608ms 09 12 19s138ms 1s594ms 10 12 19s173ms 1s597ms 11 12 18s992ms 1s582ms 12 12 19s286ms 1s607ms 13 12 19s239ms 1s603ms 14 12 18s863ms 1s571ms 15 12 19s438ms 1s619ms 16 12 19s237ms 1s603ms 17 12 19s919ms 1s659ms 18 12 20s440ms 1s703ms 19 12 19s998ms 1s666ms 20 12 49s690ms 4s140ms 21 12 19s901ms 1s658ms 22 12 20s585ms 1s715ms [ User: intelifix - Total duration: 8m13s - Times executed: 276 ]
[ Application: psql - Total duration: 8m13s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-04 00:05:18 Duration: 16s833ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-04 20:05:18 Duration: 16s150ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-04 20:15:15 Duration: 13s109ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m16s 4 4s462ms 1m4s 34s141ms 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 04 20 2 1m8s 34s252ms 23 2 1m8s 34s29ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-04 20:08:52 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-04 23:16:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-04 20:10:50 Duration: 4s476ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m50s 4 329ms 57s91ms 27s711ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 04 20 2 57s421ms 28s710ms 23 2 53s422ms 26s711ms [ User: intelifix - Total duration: 1m50s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-04 20:05:52 Duration: 57s91ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-04 23:13:46 Duration: 53s70ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-04 23:33:36 Duration: 352ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m48s 6 3s159ms 40s761ms 18s49ms 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 04 20 3 54s399ms 18s133ms 23 3 53s894ms 17s964ms [ 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-04 20:06:35 Duration: 40s761ms 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-04 23:14:28 Duration: 40s98ms 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-04 23:33:47 Duration: 10s587ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m25s 1 1m25s 1m25s 1m25s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 04 05 1 1m25s 1m25s [ User: intelifix - Total duration: 1m25s - Times executed: 1 ]
[ Application: psql - Total duration: 1m25s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-04 05:32:08 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-04 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m24s 6 2s250ms 32s87ms 14s18ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 04 20 3 42s38ms 14s12ms 23 3 42s74ms 14s24ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 20:07:10 Duration: 32s87ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 23:15:03 Duration: 31s876ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 23:33:56 Duration: 7s903ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m23s 6 3s16ms 31s999ms 13s842ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 04 20 3 41s368ms 13s789ms 23 3 41s687ms 13s895ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 23:17:15 Duration: 31s999ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 20:09:24 Duration: 31s890ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 23:34:18 Duration: 6s558ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m11s 6 2s532ms 23s729ms 11s993ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 04 20 3 35s836ms 11s945ms 23 3 36s127ms 12s42ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:10:48 Duration: 23s729ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:02:48 Duration: 23s555ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:33:04 Duration: 9s826ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m11s 6 2s235ms 24s466ms 11s961ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 04 20 3 35s909ms 11s969ms 23 3 35s861ms 11s953ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:03:30 Duration: 24s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:11:30 Duration: 24s420ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:09:55 Duration: 9s208ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m5s 6 6s277ms 14s910ms 10s933ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 04 00 3 38s402ms 12s800ms 06 3 27s200ms 9s66ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: psql - Total duration: 1m5s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 00:05:30 Duration: 14s910ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 00:05:15 Duration: 13s721ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 06:05:22 Duration: 11s237ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 1m4s 6 1s695ms 25s640ms 10s825ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 04 20 3 32s334ms 10s778ms 23 3 32s615ms 10s871ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 20:04:30 Duration: 25s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 23:12:29 Duration: 25s551ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 23:33:32 Duration: 5s368ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 56s989ms 4 4s175ms 24s799ms 14s247ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 04 20 2 28s974ms 14s487ms 23 2 28s14ms 14s7ms [ User: intelifix - Total duration: 56s989ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 56s989ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-04 20:04:55 Duration: 24s799ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-04 23:12:53 Duration: 23s714ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-04 23:33:36 Duration: 4s300ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 52s70ms 6 1s815ms 17s255ms 8s678ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 04 20 3 26s236ms 8s745ms 23 3 25s833ms 8s611ms [ User: intelifix - Total duration: 52s70ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s70ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 20:03:47 Duration: 17s255ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 23:11:46 Duration: 16s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 23:33:24 Duration: 7s315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 43s874ms 53 564ms 3s716ms 827ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 04 08 4 6s187ms 1s546ms 09 4 3s256ms 814ms 10 3 2s373ms 791ms 11 3 2s254ms 751ms 12 3 2s250ms 750ms 13 4 2s854ms 713ms 14 3 2s491ms 830ms 15 4 3s89ms 772ms 16 4 2s856ms 714ms 17 3 2s353ms 784ms 18 4 3s131ms 782ms 19 3 2s249ms 749ms 20 3 2s186ms 728ms 21 4 3s159ms 789ms 22 4 3s180ms 795ms [ User: intelifix - Total duration: 43s874ms - Times executed: 53 ]
[ Application: psql - Total duration: 43s874ms - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-04 08:00:05 Duration: 3s716ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-04 15:40:03 Duration: 1s72ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-04 08:00:06 Duration: 1s48ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 41s475ms 6 1s61ms 17s267ms 6s912ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 04 20 3 20s920ms 6s973ms 23 3 20s555ms 6s851ms [ User: intelifix - Total duration: 41s475ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s475ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 20:03:06 Duration: 17s267ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 23:11:05 Duration: 16s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 23:33:07 Duration: 2s593ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 40s956ms 1 40s956ms 40s956ms 40s956ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 04 05 1 40s956ms 40s956ms [ User: intelifix - Total duration: 40s956ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s956ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-04 05:30:42 Duration: 40s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-04 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 32s463ms 37 585ms 3s22ms 877ms 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 #20
Day Hour Count Duration Avg duration Oct 04 08 2 1s659ms 829ms 09 2 2s627ms 1s313ms 10 3 2s316ms 772ms 11 3 2s360ms 786ms 12 3 2s255ms 751ms 13 2 1s611ms 805ms 14 3 2s331ms 777ms 15 2 1s665ms 832ms 16 2 1s597ms 798ms 17 3 2s462ms 820ms 18 2 1s603ms 801ms 19 3 2s130ms 710ms 20 3 4s664ms 1s554ms 21 2 1s677ms 838ms 22 2 1s498ms 749ms [ User: intelifix - Total duration: 32s463ms - Times executed: 37 ]
[ Application: psql - Total duration: 32s463ms - Times executed: 37 ]
-
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-04 20:20:04 Duration: 3s22ms 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-04 09:20:02 Duration: 1s852ms 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-04 08:40:02 Duration: 935ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 8m13s 193ms 16s833ms 1s788ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 04 00 12 36s54ms 3s4ms 01 12 18s693ms 1s557ms 02 12 18s728ms 1s560ms 03 12 19s53ms 1s587ms 04 12 19s81ms 1s590ms 05 12 19s708ms 1s642ms 06 12 19s669ms 1s639ms 07 12 19s398ms 1s616ms 08 12 19s303ms 1s608ms 09 12 19s138ms 1s594ms 10 12 19s173ms 1s597ms 11 12 18s992ms 1s582ms 12 12 19s286ms 1s607ms 13 12 19s239ms 1s603ms 14 12 18s863ms 1s571ms 15 12 19s438ms 1s619ms 16 12 19s237ms 1s603ms 17 12 19s919ms 1s659ms 18 12 20s440ms 1s703ms 19 12 19s998ms 1s666ms 20 12 49s690ms 4s140ms 21 12 19s901ms 1s658ms 22 12 20s585ms 1s715ms [ User: intelifix - Total duration: 8m13s - Times executed: 276 ]
[ Application: psql - Total duration: 8m13s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-04 00:05:18 Duration: 16s833ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-04 20:05:18 Duration: 16s150ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-04 20:15:15 Duration: 13s109ms Database: rio User: intelifix Remote: [local] Application: psql
2 53 43s874ms 564ms 3s716ms 827ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 04 08 4 6s187ms 1s546ms 09 4 3s256ms 814ms 10 3 2s373ms 791ms 11 3 2s254ms 751ms 12 3 2s250ms 750ms 13 4 2s854ms 713ms 14 3 2s491ms 830ms 15 4 3s89ms 772ms 16 4 2s856ms 714ms 17 3 2s353ms 784ms 18 4 3s131ms 782ms 19 3 2s249ms 749ms 20 3 2s186ms 728ms 21 4 3s159ms 789ms 22 4 3s180ms 795ms [ User: intelifix - Total duration: 43s874ms - Times executed: 53 ]
[ Application: psql - Total duration: 43s874ms - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-04 08:00:05 Duration: 3s716ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-04 15:40:03 Duration: 1s72ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-04 08:00:06 Duration: 1s48ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h39m36s 2s320ms 9m52s 2m4s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 04 07 3 10m38s 3m32s 08 3 5m35s 1m51s 09 3 5m43s 1m54s 10 3 5m40s 1m53s 11 3 5m33s 1m51s 12 3 5m41s 1m53s 13 3 5m33s 1m51s 14 3 5m31s 1m50s 15 3 5m41s 1m53s 16 3 5m36s 1m52s 17 3 5m36s 1m52s 18 3 5m39s 1m53s 19 3 5m36s 1m52s 20 3 8m50s 2m56s 21 3 6m57s 2m19s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 1h39m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h39m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 07:14:54 Duration: 9m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 20:13:17 Duration: 8m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 21:11:41 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: psql
4 47 1h7m55s 236ms 4m2s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 04 07 3 5m56s 1m58s 08 3 3m57s 1m19s 09 3 3m59s 1m19s 10 3 4m1s 1m20s 11 3 3m57s 1m19s 12 3 4m1s 1m20s 13 3 3m56s 1m18s 14 3 3m59s 1m19s 15 3 4m6s 1m22s 16 3 4m2s 1m20s 17 3 4m6s 1m22s 18 3 4m3s 1m21s 19 3 3m58s 1m19s 20 2 5m42s 2m51s 21 3 4m4s 1m21s 22 3 4m1s 1m20s [ User: intelifix - Total duration: 1h7m55s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m55s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 07:21:24 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 20:19:27 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 15:14:46 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
5 37 32s463ms 585ms 3s22ms 877ms 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 #5
Day Hour Count Duration Avg duration Oct 04 08 2 1s659ms 829ms 09 2 2s627ms 1s313ms 10 3 2s316ms 772ms 11 3 2s360ms 786ms 12 3 2s255ms 751ms 13 2 1s611ms 805ms 14 3 2s331ms 777ms 15 2 1s665ms 832ms 16 2 1s597ms 798ms 17 3 2s462ms 820ms 18 2 1s603ms 801ms 19 3 2s130ms 710ms 20 3 4s664ms 1s554ms 21 2 1s677ms 838ms 22 2 1s498ms 749ms [ User: intelifix - Total duration: 32s463ms - Times executed: 37 ]
[ Application: psql - Total duration: 32s463ms - Times executed: 37 ]
-
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-04 20:20:04 Duration: 3s22ms 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-04 09:20:02 Duration: 1s852ms 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-04 08:40:02 Duration: 935ms Database: rio User: intelifix Remote: [local] Application: psql
6 8 6s632ms 311ms 1s656ms 829ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 04 00 4 4s175ms 1s43ms 06 4 2s456ms 614ms [ User: lenon - Total duration: 6s632ms - Times executed: 8 ]
[ Application: psql - Total duration: 6s632ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-04 00:02:03 Duration: 1s656ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-04 06:02:03 Duration: 1s345ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-04 00:02:05 Duration: 1s283ms Database: brasilia User: lenon Remote: [local] Application: psql
7 7 2s479ms 177ms 720ms 354ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 04 20 3 700ms 233ms 23 4 1s779ms 444ms [ User: intelifix - Total duration: 2s479ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s479ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-10-04 23:32:44 Duration: 720ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-10-04 23:10:02 Duration: 377ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-10-04 23:42:23 Duration: 343ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 6 1m48s 3s159ms 40s761ms 18s49ms 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 #8
Day Hour Count Duration Avg duration Oct 04 20 3 54s399ms 18s133ms 23 3 53s894ms 17s964ms [ 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-04 20:06:35 Duration: 40s761ms 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-04 23:14:28 Duration: 40s98ms 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-04 23:33:47 Duration: 10s587ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m24s 2s250ms 32s87ms 14s18ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 04 20 3 42s38ms 14s12ms 23 3 42s74ms 14s24ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 20:07:10 Duration: 32s87ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 23:15:03 Duration: 31s876ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 23:33:56 Duration: 7s903ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m23s 3s16ms 31s999ms 13s842ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 04 20 3 41s368ms 13s789ms 23 3 41s687ms 13s895ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 23:17:15 Duration: 31s999ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 20:09:24 Duration: 31s890ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 23:34:18 Duration: 6s558ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m11s 2s532ms 23s729ms 11s993ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 04 20 3 35s836ms 11s945ms 23 3 36s127ms 12s42ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:10:48 Duration: 23s729ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:02:48 Duration: 23s555ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:33:04 Duration: 9s826ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m11s 2s235ms 24s466ms 11s961ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 04 20 3 35s909ms 11s969ms 23 3 35s861ms 11s953ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:03:30 Duration: 24s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:11:30 Duration: 24s420ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:09:55 Duration: 9s208ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m5s 6s277ms 14s910ms 10s933ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 04 00 3 38s402ms 12s800ms 06 3 27s200ms 9s66ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: psql - Total duration: 1m5s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 00:05:30 Duration: 14s910ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 00:05:15 Duration: 13s721ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 06:05:22 Duration: 11s237ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 6 1m4s 1s695ms 25s640ms 10s825ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 04 20 3 32s334ms 10s778ms 23 3 32s615ms 10s871ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 20:04:30 Duration: 25s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 23:12:29 Duration: 25s551ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 23:33:32 Duration: 5s368ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 52s70ms 1s815ms 17s255ms 8s678ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 04 20 3 26s236ms 8s745ms 23 3 25s833ms 8s611ms [ User: intelifix - Total duration: 52s70ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s70ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 20:03:47 Duration: 17s255ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 23:11:46 Duration: 16s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 23:33:24 Duration: 7s315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 41s475ms 1s61ms 17s267ms 6s912ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 04 20 3 20s920ms 6s973ms 23 3 20s555ms 6s851ms [ User: intelifix - Total duration: 41s475ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s475ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 20:03:06 Duration: 17s267ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 23:11:05 Duration: 16s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 23:33:07 Duration: 2s593ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 29s110ms 870ms 12s809ms 4s851ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 04 20 3 14s670ms 4s890ms 23 3 14s439ms 4s813ms [ User: intelifix - Total duration: 29s110ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 29s110ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-04 20:04:05 Duration: 12s809ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-04 23:12:03 Duration: 12s553ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-04 23:33:26 Duration: 1s7ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 27s707ms 990ms 10s634ms 4s617ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 04 20 3 13s783ms 4s594ms 23 3 13s923ms 4s641ms [ User: intelifix - Total duration: 27s707ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s707ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-04 23:10:21 Duration: 10s634ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-04 20:02:21 Duration: 10s533ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-04 23:32:54 Duration: 2s298ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 27s561ms 2s783ms 5s652ms 4s593ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 04 20 3 13s618ms 4s539ms 23 3 13s942ms 4s647ms [ User: intelifix - Total duration: 27s561ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s561ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-04 20:07:34 Duration: 5s652ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-04 23:15:27 Duration: 5s582ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-04 20:10:43 Duration: 5s183ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 16s522ms 2s677ms 2s851ms 2s753ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 04 20 3 8s163ms 2s721ms 23 3 8s359ms 2s786ms [ User: intelifix - Total duration: 16s522ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 16s522ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-10-04 23:32:51 Duration: 2s851ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-10-04 23:42:30 Duration: 2s766ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-10-04 20:02:08 Duration: 2s754ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m47s 10m7s 6m31s 3 19m33s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 04 05 3 19m33s 6m31s [ User: intelifix - Total duration: 19m33s - Times executed: 3 ]
[ Application: psql - Total duration: 19m33s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-04 05:10:08 Duration: 10m7s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-04 05:16:47 Duration: 6m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-04 05:19:35 Duration: 2m47s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s320ms 9m52s 2m4s 48 1h39m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 04 07 3 10m38s 3m32s 08 3 5m35s 1m51s 09 3 5m43s 1m54s 10 3 5m40s 1m53s 11 3 5m33s 1m51s 12 3 5m41s 1m53s 13 3 5m33s 1m51s 14 3 5m31s 1m50s 15 3 5m41s 1m53s 16 3 5m36s 1m52s 17 3 5m36s 1m52s 18 3 5m39s 1m53s 19 3 5m36s 1m52s 20 3 8m50s 2m56s 21 3 6m57s 2m19s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 1h39m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h39m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 07:14:54 Duration: 9m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 20:13:17 Duration: 8m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-04 21:11:41 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: psql
3 236ms 4m2s 1m26s 47 1h7m55s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 04 07 3 5m56s 1m58s 08 3 3m57s 1m19s 09 3 3m59s 1m19s 10 3 4m1s 1m20s 11 3 3m57s 1m19s 12 3 4m1s 1m20s 13 3 3m56s 1m18s 14 3 3m59s 1m19s 15 3 4m6s 1m22s 16 3 4m2s 1m20s 17 3 4m6s 1m22s 18 3 4m3s 1m21s 19 3 3m58s 1m19s 20 2 5m42s 2m51s 21 3 4m4s 1m21s 22 3 4m1s 1m20s [ User: intelifix - Total duration: 1h7m55s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m55s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 07:21:24 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 20:19:27 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-04 15:14:46 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m25s 1m25s 1m25s 1 1m25s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 04 05 1 1m25s 1m25s [ User: intelifix - Total duration: 1m25s - Times executed: 1 ]
[ Application: psql - Total duration: 1m25s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-04 05:32:08 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-04 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 40s956ms 40s956ms 40s956ms 1 40s956ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 04 05 1 40s956ms 40s956ms [ User: intelifix - Total duration: 40s956ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s956ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-04 05:30:42 Duration: 40s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-04 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s462ms 1m4s 34s141ms 4 2m16s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 04 20 2 1m8s 34s252ms 23 2 1m8s 34s29ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-04 20:08:52 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-04 23:16:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-04 20:10:50 Duration: 4s476ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 329ms 57s91ms 27s711ms 4 1m50s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 04 20 2 57s421ms 28s710ms 23 2 53s422ms 26s711ms [ User: intelifix - Total duration: 1m50s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-04 20:05:52 Duration: 57s91ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-04 23:13:46 Duration: 53s70ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-04 23:33:36 Duration: 352ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s159ms 40s761ms 18s49ms 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 #8
Day Hour Count Duration Avg duration Oct 04 20 3 54s399ms 18s133ms 23 3 53s894ms 17s964ms [ 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-04 20:06:35 Duration: 40s761ms 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-04 23:14:28 Duration: 40s98ms 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-04 23:33:47 Duration: 10s587ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 4s175ms 24s799ms 14s247ms 4 56s989ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 04 20 2 28s974ms 14s487ms 23 2 28s14ms 14s7ms [ User: intelifix - Total duration: 56s989ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 56s989ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-04 20:04:55 Duration: 24s799ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-04 23:12:53 Duration: 23s714ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-04 23:33:36 Duration: 4s300ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s250ms 32s87ms 14s18ms 6 1m24s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 04 20 3 42s38ms 14s12ms 23 3 42s74ms 14s24ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 20:07:10 Duration: 32s87ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 23:15:03 Duration: 31s876ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-04 23:33:56 Duration: 7s903ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s16ms 31s999ms 13s842ms 6 1m23s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 04 20 3 41s368ms 13s789ms 23 3 41s687ms 13s895ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 23:17:15 Duration: 31s999ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 20:09:24 Duration: 31s890ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-04 23:34:18 Duration: 6s558ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s532ms 23s729ms 11s993ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 04 20 3 35s836ms 11s945ms 23 3 36s127ms 12s42ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:10:48 Duration: 23s729ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:02:48 Duration: 23s555ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:33:04 Duration: 9s826ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s235ms 24s466ms 11s961ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 04 20 3 35s909ms 11s969ms 23 3 35s861ms 11s953ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:03:30 Duration: 24s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 23:11:30 Duration: 24s420ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-04 20:09:55 Duration: 9s208ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6s277ms 14s910ms 10s933ms 6 1m5s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 04 00 3 38s402ms 12s800ms 06 3 27s200ms 9s66ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: psql - Total duration: 1m5s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 00:05:30 Duration: 14s910ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 00:05:15 Duration: 13s721ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-04 06:05:22 Duration: 11s237ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 1s695ms 25s640ms 10s825ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 04 20 3 32s334ms 10s778ms 23 3 32s615ms 10s871ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 20:04:30 Duration: 25s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 23:12:29 Duration: 25s551ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-04 23:33:32 Duration: 5s368ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s815ms 17s255ms 8s678ms 6 52s70ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 04 20 3 26s236ms 8s745ms 23 3 25s833ms 8s611ms [ User: intelifix - Total duration: 52s70ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s70ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 20:03:47 Duration: 17s255ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 23:11:46 Duration: 16s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-04 23:33:24 Duration: 7s315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s61ms 17s267ms 6s912ms 6 41s475ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 04 20 3 20s920ms 6s973ms 23 3 20s555ms 6s851ms [ User: intelifix - Total duration: 41s475ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s475ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 20:03:06 Duration: 17s267ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 23:11:05 Duration: 16s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-04 23:33:07 Duration: 2s593ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 870ms 12s809ms 4s851ms 6 29s110ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 04 20 3 14s670ms 4s890ms 23 3 14s439ms 4s813ms [ User: intelifix - Total duration: 29s110ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 29s110ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-04 20:04:05 Duration: 12s809ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-04 23:12:03 Duration: 12s553ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-04 23:33:26 Duration: 1s7ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 990ms 10s634ms 4s617ms 6 27s707ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 04 20 3 13s783ms 4s594ms 23 3 13s923ms 4s641ms [ User: intelifix - Total duration: 27s707ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s707ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-04 23:10:21 Duration: 10s634ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-04 20:02:21 Duration: 10s533ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-04 23:32:54 Duration: 2s298ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2s783ms 5s652ms 4s593ms 6 27s561ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 04 20 3 13s618ms 4s539ms 23 3 13s942ms 4s647ms [ User: intelifix - Total duration: 27s561ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s561ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-04 20:07:34 Duration: 5s652ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-04 23:15:27 Duration: 5s582ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-04 20:10:43 Duration: 5s183ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
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 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 04 08 1 0ms 0ms 09 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 10m35s - Times executed: 7 ]
[ Application: psql - Total duration: 10m35s - Times executed: 7 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 7,694 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 24 FATAL entries
- 2840 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,836 Max number of times the same event was reported
- 2,865 Total events found
Rank Times reported Error 1 2,836 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 04 00 118 01 120 02 118 03 120 04 118 05 118 06 120 07 118 08 120 09 118 10 120 11 120 12 118 13 118 14 120 15 118 16 120 17 118 18 120 19 118 20 120 21 120 22 118 23 100 - ERROR: prepared statement "_PLAN0000000029D84B70" does not exist
- ERROR: prepared statement "_PLAN0000000029CD6F50" does not exist
- ERROR: prepared statement "_PLAN0000000029D846E0" does not exist
Statement: DEALLOCATE "_PLAN0000000029D84B70"
Date: 2026-10-04 00:00:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CD6F50"
Date: 2026-10-04 00:00:54 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D846E0"
Date: 2026-10-04 00:01:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 15 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 04 00 2 05 2 12 1 13 1 17 4 19 4 22 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-04 00:07:08 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-04 00:53:36 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-04 05:19:38 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 04 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-04 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-04 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-04 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 04 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-04 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-04 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-04 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 04 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-04 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-04 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 04 03 1 - LOG: database system was shut down at 2026-10-04 03:05:02 -03
Date: 2026-10-04 03:05:02