pgBadger-
Global information
- Generated on Mon Aug 24 23:50:17 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,217 log entries in 14s
- Log start from 2026-08-23 00:00:06 to 2026-08-23 23:59:37
-
Overview
Global Stats
- 151 Number of unique normalized queries
- 951 Number of queries
- 4h42m Total query duration
- 2026-08-23 00:02:41 First query
- 2026-08-23 23:52:38 Last query
- 5 queries/s at 2026-08-23 23:52:06 Query peak
- 4h42m Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h42m Execute total duration
- 1,454 Number of events
- 6 Number of unique normalized events
- 1,427 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 12 Number temporary file
- 242.37 MiB Max size of temporary file
- 103.63 MiB Average size of temporary file
- 211 Total number of sessions
- 6 sessions at 2026-08-23 13:05:07 Session peak
- 7d19h37m18s Total duration of sessions
- 53m21s Average duration of sessions
- 4 Average queries per session
- 1m20s Average queries duration per session
- 52m Average idle time per session
- 229 Total number of connections
- 4 connections/s at 2026-08-23 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-23 23:52:06 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-23 20:11:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-23 23:52:06 Date
Queries duration
Key values
- 4h42m 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) Aug 23 00 22 0ms 37s657ms 7s201ms 4s772ms 20s456ms 1m1s 01 12 0ms 5s234ms 2s455ms 4s294ms 4s820ms 5s570ms 02 12 0ms 5s853ms 2s573ms 4s132ms 5s99ms 6s452ms 03 12 0ms 5s660ms 2s759ms 4s324ms 5s575ms 6s406ms 04 12 0ms 5s649ms 2s429ms 4s388ms 4s772ms 5s953ms 05 17 0ms 10m45s 1m24s 5s862ms 3m16s 10m45s 06 22 0ms 30s646ms 5s985ms 4s862ms 28s648ms 42s711ms 07 18 0ms 10m52s 1m2s 5s282ms 1m35s 10m57s 08 24 0ms 6m13s 29s544ms 7s810ms 20s315ms 6m49s 09 26 0ms 6m17s 26s833ms 7s55ms 16s671ms 6m50s 10 24 0ms 5m53s 27s502ms 7s124ms 50s215ms 5m53s 11 24 0ms 6m16s 29s674ms 7s2ms 19s349ms 6m52s 12 24 0ms 6m27s 29s866ms 7s405ms 56s557ms 6m27s 13 24 0ms 6m20s 29s327ms 6s642ms 17s798ms 6m53s 14 24 0ms 5m51s 27s148ms 7s84ms 49s227ms 5m51s 15 24 0ms 5m48s 27s453ms 6s447ms 53s994ms 5m48s 16 24 0ms 5m56s 28s157ms 6s921ms 52s27ms 5m56s 17 24 0ms 5m52s 27s731ms 6s695ms 50s604ms 5m52s 18 26 0ms 6m8s 26s274ms 6s636ms 16s650ms 6m42s 19 24 0ms 6m14s 28s678ms 6s312ms 17s561ms 6m48s 20 126 0ms 10m9s 13s400ms 1m8s 2m22s 10m25s 21 26 0ms 8m53s 32s739ms 7s310ms 47s825ms 8m53s 22 25 0ms 5m59s 26s590ms 4s937ms 8s416ms 6m48s 23 355 0ms 1m44s 7s68ms 1m5s 1m11s 2m28s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 23 00 3 0 17s142ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 6 0 7s399ms 0ms 0ms 1s688ms 07 6 0 3m3s 0ms 0ms 5m3s 08 6 0 1m48s 0ms 0ms 3m41s 09 8 0 1m20s 0ms 0ms 3m33s 10 6 0 1m41s 0ms 0ms 3m22s 11 6 0 1m49s 0ms 0ms 3m44s 12 6 0 1m50s 0ms 0ms 3m40s 13 6 0 1m48s 0ms 0ms 3m42s 14 6 0 1m40s 0ms 0ms 3m20s 15 6 0 1m41s 0ms 0ms 3m28s 16 6 0 1m44s 0ms 0ms 3m35s 17 6 0 1m42s 0ms 0ms 3m31s 18 9 0 1m10s 0ms 0ms 3m29s 19 6 0 1m46s 0ms 0ms 3m33s 20 20 84 15s457ms 39s587ms 1m7s 4m48s 21 8 0 1m39s 0ms 0ms 3m36s 22 6 0 1m42s 0ms 0ms 3m24s 23 31 324 7s68ms 1m3s 1m4s 1m58s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 23 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.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 0 0.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 Aug 23 00 16 0.00/s 01 9 0.00/s 02 8 0.00/s 03 16 0.00/s 04 7 0.00/s 05 10 0.00/s 06 15 0.00/s 07 7 0.00/s 08 7 0.00/s 09 9 0.00/s 10 7 0.00/s 11 9 0.00/s 12 6 0.00/s 13 9 0.00/s 14 9 0.00/s 15 7 0.00/s 16 7 0.00/s 17 8 0.00/s 18 10 0.00/s 19 10 0.00/s 20 12 0.00/s 21 9 0.00/s 22 10 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Aug 23 00 3 43m20s 42m27s 01 14 1h1m17s 1h1m15s 02 8 1h1s 59m57s 03 15 20m52s 20m50s 04 7 1h3m 1h2m56s 05 8 54m8s 51m8s 06 9 59m28s 59m13s 07 13 1h41s 59m15s 08 7 1h25s 58m44s 09 8 53m45s 52m18s 10 8 57m53s 56m31s 11 8 53m45s 52m16s 12 8 1h1m11s 59m42s 13 7 52m52s 51m12s 14 8 1h44s 59m22s 15 8 1h1m6s 59m44s 16 7 1h2s 58m25s 17 7 1h4s 58m29s 18 9 54m46s 53m30s 19 8 1h 58m34s 20 12 42m29s 40m9s 21 7 1h 57m58s 22 9 54m26s 53m13s 23 13 35m35s 32m22s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-08-23 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 229 connections Total
Connections per user
Key values
- intelifix Main User
- 229 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-08-23 13:05:07 Date
Histogram of session times
Key values
- 176 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 211 sessions Total
Sessions per user
Key values
- intelifix Main User
- 211 sessions Total
Sessions per host
Key values
- [local] Main Host
- 211 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 90,686 buffers Checkpoint Peak
- 2026-08-23 00:11:08 Date
- 269.779 seconds Highest write time
- 0.221 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-08-23 00:11:08 Date
Checkpoints distance
Key values
- 346.23 Mo Distance Peak
- 2026-08-23 00:11:08 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 23 00 90,686 269.779s 0.014s 269.83s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.028s 0.004s 0.059s 04 0 0s 0s 0s 05 7,711 772.425s 0.394s 772.905s 06 2,713 269.108s 0.065s 269.187s 07 1,890 189.79s 0.008s 189.875s 08 23 2.326s 0.007s 2.34s 09 34 3.451s 0.013s 3.478s 10 23 2.325s 0.007s 2.347s 11 23 2.324s 0.006s 2.337s 12 23 2.324s 0.005s 2.337s 13 23 2.325s 0.005s 2.349s 14 24 2.429s 0.004s 2.442s 15 23 2.326s 0.062s 2.396s 16 23 2.324s 0.006s 2.342s 17 23 2.323s 0.005s 2.333s 18 940 94.268s 0.091s 94.397s 19 24 2.425s 0.067s 2.499s 20 24 2.459s 0.079s 2.56s 21 42 4.266s 0.016s 4.304s 22 23 2.325s 0.015s 2.355s 23 69 6.945s 0.006s 6.967s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 23 00 0 0 11 40 0.011s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.003s 0.001s 04 0 0 0 0 0s 0s 05 0 0 4 219 0.091s 0.019s 06 0 0 0 10 0.062s 0.007s 07 0 0 1 63 0.003s 0.003s 08 0 0 0 3 0.004s 0.003s 09 0 0 0 14 0.005s 0.003s 10 0 0 0 3 0.004s 0.003s 11 0 0 0 3 0.004s 0.002s 12 0 0 0 3 0.003s 0.002s 13 0 0 0 3 0.003s 0.002s 14 0 0 0 3 0.002s 0.002s 15 0 0 0 3 0.060s 0.021s 16 0 0 0 3 0.003s 0.002s 17 0 0 0 3 0.003s 0.002s 18 0 0 0 76 0.062s 0.029s 19 0 0 0 3 0.061s 0.023s 20 0 0 0 14 0.066s 0.027s 21 0 0 0 19 0.005s 0.004s 22 0 0 0 3 0.010s 0.005s 23 0 0 0 5 0.004s 0.003s Day Hour Count Avg time (sec) Aug 23 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 23 00 177,268.00 kB 177,268.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 79,770.50 kB 04 0.00 kB 0.00 kB 05 8,610.57 kB 12,801.00 kB 06 6,136.00 kB 13,500.00 kB 07 5,262.00 kB 12,534.00 kB 08 186.00 kB 10,714.00 kB 09 106.50 kB 9,173.00 kB 10 186.00 kB 7,848.00 kB 11 186.00 kB 7,082.00 kB 12 186.00 kB 6,393.00 kB 13 186.00 kB 5,772.00 kB 14 186.00 kB 5,213.00 kB 15 186.00 kB 4,711.00 kB 16 186.00 kB 4,258.00 kB 17 185.00 kB 3,851.00 kB 18 735.80 kB 3,124.20 kB 19 187.00 kB 2,290.00 kB 20 204.00 kB 1,815.50 kB 21 79.33 kB 1,299.33 kB 22 186.00 kB 1,069.00 kB 23 40.00 kB 918.50 kB -
Temporary Files
Size of temporary files
Key values
- 484.73 MiB Temp Files size Peak
- 2026-08-23 05:32:13 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-23 05:30:42 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.21 GiB 103.63 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 8 941.46 MiB 72.29 MiB 242.37 MiB 117.68 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:21 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:13 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 302.04 MiB 56.15 MiB 92.40 MiB 75.51 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:30:46 Duration: 43s831ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 242.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 242.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-23 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-23 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-23 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-23 05:30:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-23 05:30:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.36 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-23 05:11:25 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.36 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-23 05:11:25 Date
Analyzes per table
Key values
- public.temp0000289354 (1) Main table analyzed (database rio)
- 1 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 7 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 190 41 132,405 19 32 rio.public.temp0000289354 1 0 0 0 0 0 0 88 6 6,109 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 795 228 1,176,371 121 325 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,724 347 1,459,954 315 2,232 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,418 244 956,781 215 1,708 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 164 29 95,130 16 39 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,867 997 4,016,210 927 5,656 Total 7 6 0 0 0 0 0 10,246 1,892 7,842,960 1,613 9,992 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.36) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000289354 0 0 0.02 rio.pg_toast.pg_toast_2619 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.23 contagem.pg_catalog.pg_statistic 0 0 0.15 contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_catalog.pg_statistic 0 0 0.36 Total 0 0 0.84 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4436) Main table with removed tuples on database rio
- 13637 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,436 7,472 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,310 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,981 7,346 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 622 677 0 20 260 brasilia.pg_toast.pg_toast_2619 1 1 148 139 0 0 71 contagem.pg_toast.pg_toast_2619 1 1 140 114 0 0 60 rio.public.temp0000289354 1 0 0 1,486 0 48 80 Total 7 6 13,637 24,508 0 68 3,840 Pages removed per table
Key values
- public.temp0000289354 (48) Main table with removed pages on database rio
- 68 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000289354 1 0 0 48 rio.pg_toast.pg_toast_2619 1 1 622 20 brasilia.pg_toast.pg_toast_2619 1 1 148 0 brasilia.pg_catalog.pg_statistic 1 1 3981 0 contagem.pg_catalog.pg_statistic 1 1 4310 0 contagem.pg_toast.pg_toast_2619 1 1 140 0 rio.pg_catalog.pg_statistic 1 1 4436 0 Total 7 6 13,637 68 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 23 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 1 1 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.36 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
- 157 Total read queries
- 409 Total write queries
Queries by database
Key values
- rio Main database
- 401 Requests
- 3h6m6s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 939 Requests
User Request type Count Duration etiquetas Total 4 1s935ms select 4 1s935ms intelifix Total 939 4h40m23s copy to 408 51m7s ddl 1 26s960ms others 385 42m53s select 145 3h5m56s lenon Total 8 1m35s select 8 1m35s Duration by user
Key values
- 4h40m23s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 4 1s935ms select 4 1s935ms intelifix Total 939 4h40m23s copy to 408 51m7s ddl 1 26s960ms others 385 42m53s select 145 3h5m56s lenon Total 8 1m35s select 8 1m35s Queries by host
Key values
- [local] Main host
- 951 Requests
- 4h42m ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 492 Requests
- 3h50m10s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-23 05:35:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 410 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 07:15:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m45s analyze verbose;[ Date: 2026-08-23 05:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 20:15:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 21:13:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m11s analyze verbose;[ Date: 2026-08-23 05:17:58 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 12:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 13:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 09:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 11:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 19:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 08:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 18:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 22:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 16:10:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 10:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 17:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 14:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-23 15:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m53s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-23 07:23:09 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m39s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-23 20:22:08 - 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 1h55m28s 48 1s423ms 10m52s 2m24s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 23 07 3 11m47s 3m55s 08 3 6m35s 2m11s 09 3 6m36s 2m12s 10 3 6m12s 2m4s 11 3 6m37s 2m12s 12 3 6m49s 2m16s 13 3 6m40s 2m13s 14 3 6m11s 2m3s 15 3 6m7s 2m2s 16 3 6m15s 2m5s 17 3 6m10s 2m3s 18 3 6m26s 2m8s 19 3 6m33s 2m11s 20 3 10m54s 3m38s 21 3 9m12s 3m4s 22 3 6m18s 2m6s [ User: intelifix - Total duration: 1h55m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h55m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 07:15:53 Duration: 10m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 20:15:11 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 21:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
2 1h10m12s 48 219ms 4m53s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 23 07 3 6m31s 2m10s 08 3 4m15s 1m25s 09 3 4m4s 1m21s 10 3 3m53s 1m17s 11 3 4m21s 1m27s 12 3 4m14s 1m24s 13 3 4m12s 1m24s 14 3 3m50s 1m16s 15 3 4m3s 1m21s 16 3 4m8s 1m22s 17 3 4m4s 1m21s 18 3 4m2s 1m20s 19 3 4m5s 1m21s 20 3 6m21s 2m7s 21 3 4m6s 1m22s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h10m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 07:23:09 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 20:22:08 Duration: 4m39s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 11:15:58 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
3 21m13s 3 3m16s 10m45s 7m4s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 23 05 3 21m13s 7m4s [ User: intelifix - Total duration: 21m13s - Times executed: 3 ]
[ Application: psql - Total duration: 21m13s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-23 05:10:47 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
analyze verbose;
Date: 2026-08-23 05:17:58 Duration: 7m11s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
analyze verbose;
Date: 2026-08-23 05:21:15 Duration: 3m16s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
4 11m53s 275 151ms 16s719ms 2s593ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 23 00 12 44s15ms 3s667ms 01 12 29s469ms 2s455ms 02 12 30s883ms 2s573ms 03 12 33s111ms 2s759ms 04 12 29s151ms 2s429ms 05 12 31s38ms 2s586ms 06 12 29s721ms 2s476ms 07 12 29s522ms 2s460ms 08 12 28s506ms 2s375ms 09 12 28s783ms 2s398ms 10 12 27s353ms 2s279ms 11 12 29s908ms 2s492ms 12 12 30s46ms 2s503ms 13 12 30s514ms 2s542ms 14 12 28s60ms 2s338ms 15 12 26s863ms 2s238ms 16 12 28s546ms 2s378ms 17 12 29s297ms 2s441ms 18 11 28s473ms 2s588ms 19 12 27s794ms 2s316ms 20 12 55s854ms 4s654ms 21 12 28s937ms 2s411ms 22 12 27s321ms 2s276ms [ User: intelifix - Total duration: 11m53s - Times executed: 275 ]
[ Application: psql - Total duration: 11m53s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-23 00:05:18 Duration: 16s719ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-23 20:05:17 Duration: 15s626ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-23 20:15:15 Duration: 14s142ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
5 3m33s 53 2s963ms 8s445ms 4s23ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 23 08 4 21s137ms 5s284ms 09 4 20s455ms 5s113ms 10 4 19s569ms 4s892ms 11 3 11s89ms 3s696ms 12 3 10s231ms 3s410ms 13 4 13s385ms 3s346ms 14 4 14s376ms 3s594ms 15 4 14s454ms 3s613ms 16 3 11s782ms 3s927ms 17 3 10s602ms 3s534ms 18 3 13s12ms 4s337ms 19 4 13s944ms 3s486ms 20 3 12s454ms 4s151ms 21 3 11s49ms 3s683ms 22 4 15s676ms 3s919ms [ User: intelifix - Total duration: 3m33s - Times executed: 53 ]
[ Application: psql - Total duration: 3m33s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-23 10:40:13 Duration: 8s445ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-23 09:40:14 Duration: 8s370ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-23 08:20:12 Duration: 8s284ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
6 3m31s 4 5s302ms 1m44s 52s968ms 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 Aug 23 20 2 1m42s 51s111ms 23 2 1m49s 54s824ms [ User: intelifix - Total duration: 3m31s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m31s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-23 23:18:05 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-23 20:09:06 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-23 20:11:03 Duration: 5s536ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
7 2m19s 37 2s999ms 5s326ms 3s767ms 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 #7
Day Hour Count Duration Avg duration Aug 23 08 2 8s735ms 4s367ms 09 2 6s818ms 3s409ms 10 2 6s762ms 3s381ms 11 3 12s89ms 4s29ms 12 3 12s277ms 4s92ms 13 2 7s10ms 3s505ms 14 2 7s610ms 3s805ms 15 2 6s391ms 3s195ms 16 3 11s45ms 3s681ms 17 3 11s169ms 3s723ms 18 3 10s879ms 3s626ms 19 2 7s231ms 3s615ms 20 3 11s64ms 3s688ms 21 3 12s226ms 4s75ms 22 2 8s77ms 4s38ms [ User: intelifix - Total duration: 2m19s - Times executed: 37 ]
[ Application: psql - Total duration: 2m19s - 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-08-23 08:00:07 Duration: 5s326ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 17:20:05 Duration: 4s298ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 11:20:05 Duration: 4s244ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
8 2m18s 4 511ms 1m13s 34s535ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 23 20 2 1m3s 31s894ms 23 2 1m14s 37s177ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-23 23:14:11 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-23 20:05:40 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-23 23:40:00 Duration: 782ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
9 1m37s 6 2s761ms 36s967ms 16s182ms 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 #9
Day Hour Count Duration Avg duration Aug 23 20 3 45s384ms 15s128ms 23 3 51s707ms 17s235ms [ User: intelifix - Total duration: 1m37s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m37s - 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-08-23 23:14:51 Duration: 36s967ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:06:15 Duration: 32s983ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:40:12 Duration: 11s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
10 1m34s 1 1m34s 1m34s 1m34s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 23 05 1 1m34s 1m34s [ User: intelifix - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:21 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:13 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m34s 6 5s150ms 37s657ms 15s689ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 23 00 3 51s427ms 17s142ms 06 3 42s711ms 14s237ms [ User: lenon - Total duration: 1m34s - Times executed: 6 ]
[ Application: psql - Total duration: 1m34s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 00:02:41 Duration: 37s657ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 06:02:32 Duration: 30s646ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 00:02:49 Duration: 7s977ms Database: brasilia User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
12 1m31s 6 9s122ms 23s105ms 15s310ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 23 00 3 1m1s 20s421ms 06 3 30s594ms 10s198ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: psql - Total duration: 1m31s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:05:24 Duration: 23s105ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:06:03 Duration: 20s456ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:05:42 Duration: 17s703ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
13 1m21s 6 1s848ms 35s26ms 13s587ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 23 20 3 38s174ms 12s724ms 23 3 43s349ms 14s449ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 23:15:31 Duration: 35s26ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 20:06:49 Duration: 29s652ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 23:40:19 Duration: 6s475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
14 1m13s 6 2s963ms 28s566ms 12s241ms 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 #14
Day Hour Count Duration Avg duration Aug 23 20 3 35s524ms 11s841ms 23 3 37s927ms 12s642ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-08-23 23:18:34 Duration: 28s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:33 Duration: 26s623ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:11:09 Duration: 5s937ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
15 1m3s 6 1s799ms 21s676ms 10s606ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 23 20 3 30s935ms 10s311ms 23 3 32s701ms 10s900ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:11:29 Duration: 21s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 20:03:20 Duration: 20s555ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:39:39 Duration: 8s867ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
16 1m1s 6 1s680ms 26s192ms 10s324ms 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 #16
Day Hour Count Duration Avg duration Aug 23 20 3 28s190ms 9s396ms 23 3 33s757ms 11s252ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - 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-08-23 23:12:35 Duration: 26s192ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:04:17 Duration: 22s432ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:39:55 Duration: 5s333ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
17 1m1s 6 2s29ms 20s470ms 10s324ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 23 20 3 29s212ms 9s737ms 23 3 32s731ms 10s910ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:10:51 Duration: 20s470ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 20:02:45 Duration: 19s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:39:28 Duration: 10s133ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
18 52s154ms 6 1s551ms 17s911ms 8s692ms 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 #18
Day Hour Count Duration Avg duration Aug 23 20 3 25s430ms 8s476ms 23 3 26s724ms 8s908ms [ User: intelifix - Total duration: 52s154ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s154ms - 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-08-23 23:11:47 Duration: 17s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:03:36 Duration: 16s218ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:10:13 Duration: 7s609ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
19 49s553ms 4 3s583ms 21s943ms 12s388ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 23 20 2 23s549ms 11s774ms 23 2 26s3ms 13s1ms [ User: intelifix - Total duration: 49s553ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 49s553ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-23 23:12:57 Duration: 21s943ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-23 20:04:37 Duration: 19s966ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-23 23:39:59 Duration: 4s59ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
20 43s831ms 1 43s831ms 43s831ms 43s831ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 23 05 1 43s831ms 43s831ms [ User: intelifix - Total duration: 43s831ms - Times executed: 1 ]
[ Application: psql - Total duration: 43s831ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:30:46 Duration: 43s831ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:30:42 Duration: 0ms 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 275 11m53s 151ms 16s719ms 2s593ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 23 00 12 44s15ms 3s667ms 01 12 29s469ms 2s455ms 02 12 30s883ms 2s573ms 03 12 33s111ms 2s759ms 04 12 29s151ms 2s429ms 05 12 31s38ms 2s586ms 06 12 29s721ms 2s476ms 07 12 29s522ms 2s460ms 08 12 28s506ms 2s375ms 09 12 28s783ms 2s398ms 10 12 27s353ms 2s279ms 11 12 29s908ms 2s492ms 12 12 30s46ms 2s503ms 13 12 30s514ms 2s542ms 14 12 28s60ms 2s338ms 15 12 26s863ms 2s238ms 16 12 28s546ms 2s378ms 17 12 29s297ms 2s441ms 18 11 28s473ms 2s588ms 19 12 27s794ms 2s316ms 20 12 55s854ms 4s654ms 21 12 28s937ms 2s411ms 22 12 27s321ms 2s276ms [ User: intelifix - Total duration: 11m53s - Times executed: 275 ]
[ Application: psql - Total duration: 11m53s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-23 00:05:18 Duration: 16s719ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-23 20:05:17 Duration: 15s626ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-23 20:15:15 Duration: 14s142ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
2 53 3m33s 2s963ms 8s445ms 4s23ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 23 08 4 21s137ms 5s284ms 09 4 20s455ms 5s113ms 10 4 19s569ms 4s892ms 11 3 11s89ms 3s696ms 12 3 10s231ms 3s410ms 13 4 13s385ms 3s346ms 14 4 14s376ms 3s594ms 15 4 14s454ms 3s613ms 16 3 11s782ms 3s927ms 17 3 10s602ms 3s534ms 18 3 13s12ms 4s337ms 19 4 13s944ms 3s486ms 20 3 12s454ms 4s151ms 21 3 11s49ms 3s683ms 22 4 15s676ms 3s919ms [ User: intelifix - Total duration: 3m33s - Times executed: 53 ]
[ Application: psql - Total duration: 3m33s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-23 10:40:13 Duration: 8s445ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-23 09:40:14 Duration: 8s370ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-23 08:20:12 Duration: 8s284ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
3 48 1h55m28s 1s423ms 10m52s 2m24s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 23 07 3 11m47s 3m55s 08 3 6m35s 2m11s 09 3 6m36s 2m12s 10 3 6m12s 2m4s 11 3 6m37s 2m12s 12 3 6m49s 2m16s 13 3 6m40s 2m13s 14 3 6m11s 2m3s 15 3 6m7s 2m2s 16 3 6m15s 2m5s 17 3 6m10s 2m3s 18 3 6m26s 2m8s 19 3 6m33s 2m11s 20 3 10m54s 3m38s 21 3 9m12s 3m4s 22 3 6m18s 2m6s [ User: intelifix - Total duration: 1h55m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h55m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 07:15:53 Duration: 10m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 20:15:11 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 21:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
4 48 1h10m12s 219ms 4m53s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 23 07 3 6m31s 2m10s 08 3 4m15s 1m25s 09 3 4m4s 1m21s 10 3 3m53s 1m17s 11 3 4m21s 1m27s 12 3 4m14s 1m24s 13 3 4m12s 1m24s 14 3 3m50s 1m16s 15 3 4m3s 1m21s 16 3 4m8s 1m22s 17 3 4m4s 1m21s 18 3 4m2s 1m20s 19 3 4m5s 1m21s 20 3 6m21s 2m7s 21 3 4m6s 1m22s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h10m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 07:23:09 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 20:22:08 Duration: 4m39s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 11:15:58 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
5 37 2m19s 2s999ms 5s326ms 3s767ms 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 Aug 23 08 2 8s735ms 4s367ms 09 2 6s818ms 3s409ms 10 2 6s762ms 3s381ms 11 3 12s89ms 4s29ms 12 3 12s277ms 4s92ms 13 2 7s10ms 3s505ms 14 2 7s610ms 3s805ms 15 2 6s391ms 3s195ms 16 3 11s45ms 3s681ms 17 3 11s169ms 3s723ms 18 3 10s879ms 3s626ms 19 2 7s231ms 3s615ms 20 3 11s64ms 3s688ms 21 3 12s226ms 4s75ms 22 2 8s77ms 4s38ms [ User: intelifix - Total duration: 2m19s - Times executed: 37 ]
[ Application: psql - Total duration: 2m19s - 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-08-23 08:00:07 Duration: 5s326ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 17:20:05 Duration: 4s298ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 11:20:05 Duration: 4s244ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
6 7 2s782ms 214ms 619ms 397ms call rs_giga_tecnicos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 23 00 3 1s382ms 460ms 20 3 1s123ms 374ms 22 1 275ms 275ms [ User: intelifix - Total duration: 2s782ms - Times executed: 7 ]
[ Application: psql - Total duration: 2s782ms - Times executed: 7 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-08-23 00:05:02 Duration: 619ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-08-23 20:05:02 Duration: 560ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-08-23 00:05:01 Duration: 540ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
7 7 2s775ms 249ms 570ms 396ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 23 20 3 846ms 282ms 23 4 1s929ms 482ms [ User: intelifix - Total duration: 2s775ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s775ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-23 23:39:05 Duration: 570ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-23 23:18:35 Duration: 491ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-23 23:10:02 Duration: 435ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
8 7 2s203ms 225ms 450ms 314ms 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 #8
Day Hour Count Duration Avg duration Aug 23 20 3 859ms 286ms 23 4 1s343ms 335ms [ User: intelifix - Total duration: 2s203ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s203ms - 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-08-23 23:39:04 Duration: 450ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:35 Duration: 338ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:10:02 Duration: 325ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
9 6 1m37s 2s761ms 36s967ms 16s182ms 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 #9
Day Hour Count Duration Avg duration Aug 23 20 3 45s384ms 15s128ms 23 3 51s707ms 17s235ms [ User: intelifix - Total duration: 1m37s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m37s - 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-08-23 23:14:51 Duration: 36s967ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:06:15 Duration: 32s983ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:40:12 Duration: 11s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
10 6 1m34s 5s150ms 37s657ms 15s689ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 23 00 3 51s427ms 17s142ms 06 3 42s711ms 14s237ms [ User: lenon - Total duration: 1m34s - Times executed: 6 ]
[ Application: psql - Total duration: 1m34s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 00:02:41 Duration: 37s657ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 06:02:32 Duration: 30s646ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 00:02:49 Duration: 7s977ms Database: brasilia User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
11 6 1m31s 9s122ms 23s105ms 15s310ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 23 00 3 1m1s 20s421ms 06 3 30s594ms 10s198ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: psql - Total duration: 1m31s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:05:24 Duration: 23s105ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:06:03 Duration: 20s456ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:05:42 Duration: 17s703ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
12 6 1m21s 1s848ms 35s26ms 13s587ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 23 20 3 38s174ms 12s724ms 23 3 43s349ms 14s449ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 23:15:31 Duration: 35s26ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 20:06:49 Duration: 29s652ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 23:40:19 Duration: 6s475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
13 6 1m13s 2s963ms 28s566ms 12s241ms 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 #13
Day Hour Count Duration Avg duration Aug 23 20 3 35s524ms 11s841ms 23 3 37s927ms 12s642ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-08-23 23:18:34 Duration: 28s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:33 Duration: 26s623ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:11:09 Duration: 5s937ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
14 6 1m3s 1s799ms 21s676ms 10s606ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 23 20 3 30s935ms 10s311ms 23 3 32s701ms 10s900ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:11:29 Duration: 21s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 20:03:20 Duration: 20s555ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:39:39 Duration: 8s867ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
15 6 1m1s 1s680ms 26s192ms 10s324ms 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 Aug 23 20 3 28s190ms 9s396ms 23 3 33s757ms 11s252ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - 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-08-23 23:12:35 Duration: 26s192ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:04:17 Duration: 22s432ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:39:55 Duration: 5s333ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
16 6 1m1s 2s29ms 20s470ms 10s324ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 23 20 3 29s212ms 9s737ms 23 3 32s731ms 10s910ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:10:51 Duration: 20s470ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 20:02:45 Duration: 19s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:39:28 Duration: 10s133ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
17 6 52s154ms 1s551ms 17s911ms 8s692ms 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 #17
Day Hour Count Duration Avg duration Aug 23 20 3 25s430ms 8s476ms 23 3 26s724ms 8s908ms [ User: intelifix - Total duration: 52s154ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s154ms - 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-08-23 23:11:47 Duration: 17s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:03:36 Duration: 16s218ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:10:13 Duration: 7s609ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
18 6 43s276ms 3s733ms 10s485ms 7s212ms 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 #18
Day Hour Count Duration Avg duration Aug 23 20 3 20s896ms 6s965ms 23 3 22s379ms 7s459ms [ User: intelifix - Total duration: 43s276ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s276ms - 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-08-23 23:16:05 Duration: 10s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-23 20:10:55 Duration: 9s136ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-23 23:40:33 Duration: 8s160ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
19 6 37s740ms 979ms 16s828ms 6s290ms 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 #19
Day Hour Count Duration Avg duration Aug 23 20 3 17s557ms 5s852ms 23 3 20s182ms 6s727ms [ User: intelifix - Total duration: 37s740ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 37s740ms - 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-08-23 23:11:08 Duration: 16s828ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:03:00 Duration: 14s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:57 Duration: 2s511ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
20 6 34s392ms 1s131ms 15s119ms 5s732ms 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 #20
Day Hour Count Duration Avg duration Aug 23 20 3 15s180ms 5s60ms 23 3 19s211ms 6s403ms [ User: intelifix - Total duration: 34s392ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s392ms - 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-08-23 23:10:26 Duration: 15s119ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:02:22 Duration: 10s739ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:46 Duration: 3s108ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m16s 10m45s 7m4s 3 21m13s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 23 05 3 21m13s 7m4s [ User: intelifix - Total duration: 21m13s - Times executed: 3 ]
[ Application: psql - Total duration: 21m13s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-23 05:10:47 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
analyze verbose;
Date: 2026-08-23 05:17:58 Duration: 7m11s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
analyze verbose;
Date: 2026-08-23 05:21:15 Duration: 3m16s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
2 1s423ms 10m52s 2m24s 48 1h55m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 23 07 3 11m47s 3m55s 08 3 6m35s 2m11s 09 3 6m36s 2m12s 10 3 6m12s 2m4s 11 3 6m37s 2m12s 12 3 6m49s 2m16s 13 3 6m40s 2m13s 14 3 6m11s 2m3s 15 3 6m7s 2m2s 16 3 6m15s 2m5s 17 3 6m10s 2m3s 18 3 6m26s 2m8s 19 3 6m33s 2m11s 20 3 10m54s 3m38s 21 3 9m12s 3m4s 22 3 6m18s 2m6s [ User: intelifix - Total duration: 1h55m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h55m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 07:15:53 Duration: 10m52s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 20:15:11 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-23 21:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
3 1m34s 1m34s 1m34s 1 1m34s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 23 05 1 1m34s 1m34s [ User: intelifix - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:21 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:13 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 219ms 4m53s 1m27s 48 1h10m12s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 23 07 3 6m31s 2m10s 08 3 4m15s 1m25s 09 3 4m4s 1m21s 10 3 3m53s 1m17s 11 3 4m21s 1m27s 12 3 4m14s 1m24s 13 3 4m12s 1m24s 14 3 3m50s 1m16s 15 3 4m3s 1m21s 16 3 4m8s 1m22s 17 3 4m4s 1m21s 18 3 4m2s 1m20s 19 3 4m5s 1m21s 20 3 6m21s 2m7s 21 3 4m6s 1m22s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h10m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 07:23:09 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 20:22:08 Duration: 4m39s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-23 11:15:58 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
5 5s302ms 1m44s 52s968ms 4 3m31s 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 Aug 23 20 2 1m42s 51s111ms 23 2 1m49s 54s824ms [ User: intelifix - Total duration: 3m31s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m31s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-23 23:18:05 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-23 20:09:06 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-23 20:11:03 Duration: 5s536ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
6 43s831ms 43s831ms 43s831ms 1 43s831ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 23 05 1 43s831ms 43s831ms [ User: intelifix - Total duration: 43s831ms - Times executed: 1 ]
[ Application: psql - Total duration: 43s831ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:30:46 Duration: 43s831ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 511ms 1m13s 34s535ms 4 2m18s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 23 20 2 1m3s 31s894ms 23 2 1m14s 37s177ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-23 23:14:11 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-23 20:05:40 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-23 23:40:00 Duration: 782ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
8 2s761ms 36s967ms 16s182ms 6 1m37s 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 Aug 23 20 3 45s384ms 15s128ms 23 3 51s707ms 17s235ms [ User: intelifix - Total duration: 1m37s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m37s - 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-08-23 23:14:51 Duration: 36s967ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:06:15 Duration: 32s983ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:40:12 Duration: 11s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
9 5s150ms 37s657ms 15s689ms 6 1m34s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 23 00 3 51s427ms 17s142ms 06 3 42s711ms 14s237ms [ User: lenon - Total duration: 1m34s - Times executed: 6 ]
[ Application: psql - Total duration: 1m34s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 00:02:41 Duration: 37s657ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 06:02:32 Duration: 30s646ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-23 00:02:49 Duration: 7s977ms Database: brasilia User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
10 9s122ms 23s105ms 15s310ms 6 1m31s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 23 00 3 1m1s 20s421ms 06 3 30s594ms 10s198ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: psql - Total duration: 1m31s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:05:24 Duration: 23s105ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:06:03 Duration: 20s456ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-23 00:05:42 Duration: 17s703ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-23.log
11 1s848ms 35s26ms 13s587ms 6 1m21s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 23 20 3 38s174ms 12s724ms 23 3 43s349ms 14s449ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 23:15:31 Duration: 35s26ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 20:06:49 Duration: 29s652ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-23 23:40:19 Duration: 6s475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
12 3s583ms 21s943ms 12s388ms 4 49s553ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 23 20 2 23s549ms 11s774ms 23 2 26s3ms 13s1ms [ User: intelifix - Total duration: 49s553ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 49s553ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-23 23:12:57 Duration: 21s943ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-23 20:04:37 Duration: 19s966ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-23 23:39:59 Duration: 4s59ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
13 2s963ms 28s566ms 12s241ms 6 1m13s 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 #13
Day Hour Count Duration Avg duration Aug 23 20 3 35s524ms 11s841ms 23 3 37s927ms 12s642ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-08-23 23:18:34 Duration: 28s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:33 Duration: 26s623ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:11:09 Duration: 5s937ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
14 1s799ms 21s676ms 10s606ms 6 1m3s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 23 20 3 30s935ms 10s311ms 23 3 32s701ms 10s900ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:11:29 Duration: 21s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 20:03:20 Duration: 20s555ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:39:39 Duration: 8s867ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
15 1s680ms 26s192ms 10s324ms 6 1m1s 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 Aug 23 20 3 28s190ms 9s396ms 23 3 33s757ms 11s252ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - 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-08-23 23:12:35 Duration: 26s192ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:04:17 Duration: 22s432ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 23:39:55 Duration: 5s333ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
16 2s29ms 20s470ms 10s324ms 6 1m1s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 23 20 3 29s212ms 9s737ms 23 3 32s731ms 10s910ms [ User: intelifix - Total duration: 1m1s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:10:51 Duration: 20s470ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 20:02:45 Duration: 19s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-23 23:39:28 Duration: 10s133ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
17 1s551ms 17s911ms 8s692ms 6 52s154ms 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 #17
Day Hour Count Duration Avg duration Aug 23 20 3 25s430ms 8s476ms 23 3 26s724ms 8s908ms [ User: intelifix - Total duration: 52s154ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 52s154ms - 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-08-23 23:11:47 Duration: 17s911ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:03:36 Duration: 16s218ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:10:13 Duration: 7s609ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
18 3s733ms 10s485ms 7s212ms 6 43s276ms 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 #18
Day Hour Count Duration Avg duration Aug 23 20 3 20s896ms 6s965ms 23 3 22s379ms 7s459ms [ User: intelifix - Total duration: 43s276ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s276ms - 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-08-23 23:16:05 Duration: 10s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-23 20:10:55 Duration: 9s136ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-23 23:40:33 Duration: 8s160ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
19 979ms 16s828ms 6s290ms 6 37s740ms 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 #19
Day Hour Count Duration Avg duration Aug 23 20 3 17s557ms 5s852ms 23 3 20s182ms 6s727ms [ User: intelifix - Total duration: 37s740ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 37s740ms - 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-08-23 23:11:08 Duration: 16s828ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:03:00 Duration: 14s30ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:57 Duration: 2s511ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
20 1s131ms 15s119ms 5s732ms 6 34s392ms 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 #20
Day Hour Count Duration Avg duration Aug 23 20 3 15s180ms 5s60ms 23 3 19s211ms 6s403ms [ User: intelifix - Total duration: 34s392ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s392ms - 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-08-23 23:10:26 Duration: 15s119ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:02:22 Duration: 10s739ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
-
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-08-23 20:09:46 Duration: 3s108ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-23.log
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 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 23 08 1 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 13 2 0ms 0ms 16 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 10m33s - Times executed: 10 ]
[ Application: psql - Total duration: 10m33s - Times executed: 10 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,871 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 22 FATAL entries
- 1431 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,427 Max number of times the same event was reported
- 1,454 Total events found
Rank Times reported Error 1 1,427 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 23 00 60 01 59 02 59 03 60 04 59 05 59 06 60 07 59 08 59 09 60 10 59 11 60 12 59 13 60 14 60 15 59 16 60 17 60 18 59 19 60 20 59 21 60 22 59 23 59 - ERROR: prepared statement "_PLAN0000000029A0CEB0" does not exist
- ERROR: prepared statement "_PLAN0000000029A0EEA0" does not exist
- ERROR: prepared statement "_PLAN0000000029A08ED0" does not exist
Statement: DEALLOCATE "_PLAN0000000029A0CEB0"
Date: 2026-08-23 00:00:06 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Statement: DEALLOCATE "_PLAN0000000029A0EEA0"
Date: 2026-08-23 00:01:06 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Statement: DEALLOCATE "_PLAN0000000029A08ED0"
Date: 2026-08-23 00:02:07 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
2 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 23 00 1 01 1 02 1 03 1 06 2 14 1 18 1 19 2 20 1 21 1 22 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-23 00:02:55 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Date: 2026-08-23 01:42:21 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Date: 2026-08-23 02:05:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 23 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-08-23 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Date: 2026-08-23 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Date: 2026-08-23 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 23 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:32:21 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-23 05:32:21 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-23 05:32:21 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
5 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 23 03 1 - FATAL: the database system is shutting down
Date: 2026-08-23 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-23.log
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 23 03 1 - LOG: database system was shut down at 2026-08-23 03:05:02 -03
Date: 2026-08-23 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-23.log