pgBadger-
Global information
- Generated on Sun Sep 20 23:50:17 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 7,429 log entries in 15s
- Log start from 2026-09-20 00:00:57 to 2026-09-20 23:43:10
-
Overview
Global Stats
- 150 Number of unique normalized queries
- 818 Number of queries
- 4h2m28s Total query duration
- 2026-09-20 00:02:23 First query
- 2026-09-20 23:43:10 Last query
- 5 queries/s at 2026-09-20 23:42:47 Query peak
- 4h2m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h2m28s Execute total duration
- 1,062 Number of events
- 7 Number of unique normalized events
- 1,023 Max number of times the same event was reported
- 0 Number of cancellation
- 8 Total number of automatic vacuums
- 2 Total number of automatic analyzes
- 20 Number temporary file
- 246.58 MiB Max size of temporary file
- 67.12 MiB Average size of temporary file
- 194 Total number of sessions
- 6 sessions at 2026-09-20 01:02:33 Session peak
- 7d7h28m11s Total duration of sessions
- 54m16s Average duration of sessions
- 4 Average queries per session
- 1m14s Average queries duration per session
- 53m1s Average idle time per session
- 211 Total number of connections
- 4 connections/s at 2026-09-20 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-20 23:42:47 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-20 23:10:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-20 23:42:47 Date
Queries duration
Key values
- 4h2m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 20 00 17 0ms 20s150ms 5s838ms 1s832ms 2s384ms 1m1s 01 6 0ms 1s955ms 1s836ms 1s746ms 1s857ms 1s955ms 02 6 0ms 2s127ms 1s900ms 1s678ms 1s941ms 2s127ms 03 7 0ms 2s176ms 1s742ms 1s832ms 2s106ms 2s313ms 04 6 0ms 2s103ms 1s855ms 1s757ms 1s826ms 2s103ms 05 11 0ms 11m47s 2m16s 6s52ms 3m7s 11m47s 06 12 0ms 18s69ms 4s555ms 1s705ms 1s837ms 24s403ms 07 25 0ms 11m11s 47s673ms 2s95ms 2m1s 11m11s 08 18 0ms 5m 32s93ms 2s49ms 8s275ms 5m43s 09 18 0ms 5m10s 32s836ms 1s870ms 2s665ms 5m56s 10 18 0ms 4m56s 31s409ms 1s800ms 44s91ms 4m56s 11 21 0ms 4m55s 27s28ms 2s749ms 43s503ms 4m55s 12 18 0ms 4m57s 31s520ms 1s779ms 43s200ms 4m57s 13 18 0ms 4m51s 31s213ms 1s952ms 43s495ms 4m51s 14 18 0ms 4m55s 31s403ms 1s879ms 44s711ms 4m55s 15 18 0ms 4m58s 32s307ms 1s903ms 3s823ms 5m44s 16 19 0ms 4m57s 29s932ms 1s813ms 45s643ms 4m57s 17 18 0ms 5m3s 31s819ms 2s106ms 3m30s 5m47s 18 21 0ms 5m11s 28s159ms 3m30s 5m41s 5m41s 19 18 282ms 5m3s 31s958ms 3m33s 5m45s 5m45s 20 120 152ms 9m24s 13s68ms 2m15s 3m50s 9m24s 21 20 0ms 6m27s 32s818ms 3m29s 6m56s 6m56s 22 18 0ms 4m54s 31s755ms 3m36s 4m54s 4m54s 23 347 0ms 1m3s 5s692ms 1m5s 1m7s 1m7s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 20 00 3 0 9s227ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 178ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 8s134ms 0ms 0ms 0ms 07 18 0 1m2s 0ms 663ms 4m28s 08 6 0 1m32s 0ms 0ms 3m29s 09 6 0 1m35s 0ms 0ms 3m37s 10 6 0 1m31s 0ms 0ms 3m29s 11 8 0 1m8s 0ms 0ms 3m26s 12 6 0 1m32s 0ms 0ms 3m31s 13 6 0 1m30s 0ms 0ms 3m29s 14 6 0 1m31s 0ms 0ms 3m29s 15 6 0 1m33s 0ms 0ms 3m38s 16 6 0 1m32s 0ms 0ms 3m29s 17 6 0 1m32s 0ms 0ms 5m47s 18 9 0 1m3s 16s766ms 3m30s 5m41s 19 6 0 1m33s 0ms 3m33s 5m45s 20 20 79 15s348ms 1m6s 2m15s 9m24s 21 8 0 1m19s 14s888ms 3m27s 6m56s 22 6 0 1m32s 44s892ms 3m36s 4m54s 23 23 324 5s692ms 1m3s 1m5s 1m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 20 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 20 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 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.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 0 0.00 0.00% Day Hour Count Average / Second Sep 20 00 13 0.00/s 01 7 0.00/s 02 7 0.00/s 03 13 0.00/s 04 7 0.00/s 05 8 0.00/s 06 15 0.00/s 07 12 0.00/s 08 8 0.00/s 09 6 0.00/s 10 9 0.00/s 11 10 0.00/s 12 8 0.00/s 13 11 0.00/s 14 8 0.00/s 15 8 0.00/s 16 7 0.00/s 17 12 0.00/s 18 9 0.00/s 19 5 0.00/s 20 9 0.00/s 21 6 0.00/s 22 7 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Sep 20 00 8 57m38s 57m25s 01 12 1h45s 1h44s 02 7 1h 59m58s 03 13 13m25s 13m24s 04 7 1h3m 1h2m58s 05 7 1h33s 56m59s 06 8 58m30s 58m23s 07 13 1h55s 59m24s 08 9 1h20s 59m16s 09 7 59m17s 57m52s 10 6 1h49s 59m15s 11 9 54m28s 53m25s 12 9 57m46s 56m43s 13 7 1h1m12s 59m52s 14 7 1h42s 59m21s 15 8 1h22s 59m10s 16 8 1h38s 59m27s 17 7 1h 58m38s 18 6 1h52s 59m13s 19 5 1h42s 58m47s 20 8 39m12s 35m56s 21 6 1h 58m10s 22 6 1h1m19s 59m43s 23 11 30m17s 27m17s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-20 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 211 connections Total
Connections per user
Key values
- intelifix Main User
- 211 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-09-20 01:02:33 Date
Histogram of session times
Key values
- 167 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 194 sessions Total
Sessions per user
Key values
- intelifix Main User
- 194 sessions Total
Sessions per host
Key values
- [local] Main Host
- 194 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 17,765 buffers Checkpoint Peak
- 2026-09-20 00:10:59 Date
- 269.595 seconds Highest write time
- 0.085 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-09-20 00:10:59 Date
Checkpoints distance
Key values
- 183.28 Mo Distance Peak
- 2026-09-20 00:10:59 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 20 00 17,765 269.595s 0.003s 269.605s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.018s 0.003s 0.049s 04 0 0s 0s 0s 05 7,333 733.572s 0.192s 733.827s 06 2,518 252.387s 0.003s 252.395s 07 1,419 142.153s 0.082s 142.251s 08 24 2.42s 0.072s 2.499s 09 23 2.314s 0.003s 2.32s 10 25 2.522s 0.012s 2.541s 11 152 15.259s 0.017s 15.286s 12 24 2.419s 0.006s 2.432s 13 24 2.42s 0.005s 2.431s 14 24 2.419s 0.019s 2.505s 15 24 2.42s 0.018s 2.446s 16 25 2.52s 0.006s 2.531s 17 24 2.42s 0.007s 2.432s 18 786 78.809s 0.111s 78.935s 19 24 2.421s 0.015s 2.446s 20 26 2.633s 0.008s 2.655s 21 54 5.426s 0.005s 5.436s 22 24 2.419s 0.015s 2.441s 23 45 4.521s 0.006s 4.553s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 20 00 0 0 6 38 0.003s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.002s 0.001s 04 0 0 0 0 0s 0s 05 0 0 3 171 0.062s 0.016s 06 0 0 0 10 0.002s 0.001s 07 0 0 1 70 0.060s 0.015s 08 0 0 0 5 0.061s 0.026s 09 0 0 0 3 0.003s 0.001s 10 0 0 0 5 0.009s 0.006s 11 0 0 0 49 0.010s 0.007s 12 0 0 0 5 0.003s 0.003s 13 0 0 0 5 0.002s 0.003s 14 0 0 0 5 0.015s 0.01s 15 0 0 0 5 0.009s 0.008s 16 0 0 0 5 0.002s 0.003s 17 0 0 0 5 0.003s 0.004s 18 0 0 0 76 0.076s 0.022s 19 0 0 0 5 0.010s 0.007s 20 0 0 0 17 0.002s 0.004s 21 0 0 0 12 0.002s 0.002s 22 0 0 0 5 0.012s 0.008s 23 0 0 0 12 0.004s 0.003s Day Hour Count Avg time (sec) Sep 20 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 20 00 93,837.00 kB 93,837.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 42,226.50 kB 04 0.00 kB 0.00 kB 05 6,038.12 kB 9,964.88 kB 06 4,167.00 kB 9,567.00 kB 07 1,506.40 kB 7,614.60 kB 08 97.00 kB 5,289.50 kB 09 192.00 kB 4,536.00 kB 10 96.50 kB 3,892.00 kB 11 315.33 kB 3,042.67 kB 12 97.00 kB 2,394.00 kB 13 97.00 kB 1,959.50 kB 14 97.00 kB 1,605.00 kB 15 97.00 kB 1,317.00 kB 16 96.50 kB 1,086.50 kB 17 97.00 kB 897.00 kB 18 707.75 kB 2,202.75 kB 19 97.00 kB 1,628.50 kB 20 205.25 kB 1,242.00 kB 21 165.50 kB 954.00 kB 22 97.00 kB 796.50 kB 23 69.50 kB 656.50 kB -
Temporary Files
Size of temporary files
Key values
- 493.16 MiB Temp Files size Peak
- 2026-09-20 05:31:58 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-20 05:32:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.12 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.77 MiB 246.58 MiB 64.72 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:32:07 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.78 MiB 57.02 MiB 93.83 MiB 76.69 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-20 05:30:43 Duration: 40s781ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-20 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 246.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 246.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-20 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-20 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-20 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-20 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-20 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.35 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-20 05:12:24 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.35 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-20 05:12:24 Date
Analyzes per table
Key values
- public.temp0000291917 (1) Main table analyzed (database rio)
- 2 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database rio
- 8 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 854 173 1,086,700 133 419 rio.public.temp0000291919 1 0 0 0 0 0 0 80 6 5,621 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 126 12 48,475 3 13 rio.public.temp0000291917 1 0 0 0 0 0 0 80 6 5,621 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 189 29 163,806 18 51 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,126 6 158,401 2 19 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,448 159 815,228 143 994 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,329 629 2,797,278 590 3,743 Total 8 6 0 0 0 0 0 9,232 1,020 5,081,130 889 5,239 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.35) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_toast.pg_toast_2619 0 0 0.08 rio.public.temp0000291919 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000291917 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.06 brasilia.pg_catalog.pg_statistic 0 0 0.17 rio.pg_catalog.pg_statistic 0 0 0.35 Total 0 0 0.7 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4616) Main table with removed tuples on database rio
- 13998 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,616 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,526 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 4,073 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 574 677 0 18 249 brasilia.pg_toast.pg_toast_2619 1 1 119 135 0 16 53 contagem.pg_toast.pg_toast_2619 1 1 90 116 0 32 27 rio.public.temp0000291919 1 0 0 1,231 0 56 72 rio.public.temp0000291917 1 0 0 1,231 0 56 72 Total 8 6 13,998 25,488 0 178 3,842 Pages removed per table
Key values
- public.temp0000291919 (56) Main table with removed pages on database rio
- 178 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291919 1 0 0 56 rio.public.temp0000291917 1 0 0 56 contagem.pg_toast.pg_toast_2619 1 1 90 32 rio.pg_toast.pg_toast_2619 1 1 574 18 brasilia.pg_toast.pg_toast_2619 1 1 119 16 contagem.pg_catalog.pg_statistic 1 1 4526 0 brasilia.pg_catalog.pg_statistic 1 1 4073 0 rio.pg_catalog.pg_statistic 1 1 4616 0 Total 8 6 13,998 178 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 20 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 1 1 08 0 0 09 0 0 10 0 0 11 1 1 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.35 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
- 159 Total read queries
- 405 Total write queries
Queries by database
Key values
- rio Main database
- 405 Requests
- 2h34m44s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,643 Requests
User Request type Count Duration etiquetas Total 11 8s709ms select 11 8s709ms intelifix Total 1,643 8h4m57s copy to 804 1h24m21s ddl 5 1m6s others 528 1h8m25s select 306 5h31m5s lenon Total 22 2m1s select 22 2m1s Duration by user
Key values
- 8h4m57s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 11 8s709ms select 11 8s709ms intelifix Total 1,643 8h4m57s copy to 804 1h24m21s ddl 5 1m6s others 528 1h8m25s select 306 5h31m5s lenon Total 22 2m1s select 22 2m1s Queries by host
Key values
- [local] Main host
- 1,676 Requests
- 8h7m7s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 440 Requests
- 3h19m10s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-20 01:02:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 345 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 11m47s analyze verbose;[ Date: 2026-09-20 05:11:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 07:16:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 20:14:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m44s analyze verbose;[ Date: 2026-09-20 05:19:33 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 21:11:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 18:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 09:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 17:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 19:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 08:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 4m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 15:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 4m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 16:09:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 4m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 12:09:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 4m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 10:09:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 14:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 11:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 22:09:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-20 13:09:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m17s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-20 07:23:26 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m46s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-20 20:20:57 - 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 1h36m59s 47 1s419ms 11m11s 2m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 20 07 3 12m13s 4m4s 08 3 5m16s 1m45s 09 3 5m27s 1m49s 10 3 5m13s 1m44s 11 3 5m11s 1m43s 12 3 5m13s 1m44s 13 3 5m8s 1m42s 14 3 5m11s 1m43s 15 3 5m15s 1m45s 16 3 5m14s 1m44s 17 3 5m19s 1m46s 18 3 5m30s 1m50s 19 3 5m19s 1m46s 20 2 9m31s 4m45s 21 3 6m44s 2m14s 22 3 5m9s 1m43s [ User: intelifix - Total duration: 1h36m59s - Times executed: 47 ]
[ Application: psql - Total duration: 1h36m59s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 07:16:13 Duration: 11m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 20:14:25 Duration: 9m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 21:11:29 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1h8m18s 48 211ms 4m17s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 20 07 3 6m22s 2m7s 08 3 3m57s 1m19s 09 3 4m6s 1m22s 10 3 3m56s 1m18s 11 3 3m53s 1m17s 12 3 3m58s 1m19s 13 3 3m57s 1m19s 14 3 3m57s 1m19s 15 3 4m7s 1m22s 16 3 3m58s 1m19s 17 3 3m57s 1m19s 18 3 3m58s 1m19s 19 3 4m 1m20s 20 3 6m5s 2m1s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h8m18s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 07:23:26 Duration: 4m17s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 20:20:57 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 15:14:23 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 22m40s 3 3m7s 11m47s 7m33s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 20 05 3 22m40s 7m33s [ User: intelifix - Total duration: 22m40s - Times executed: 3 ]
[ Application: psql - Total duration: 22m40s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-20 05:11:48 Duration: 11m47s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-09-20 05:19:33 Duration: 7m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-09-20 05:22:41 Duration: 3m7s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 4m50s 135 155ms 17s178ms 2s153ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 20 00 7 29s723ms 4s246ms 01 6 11s21ms 1s836ms 02 6 11s402ms 1s900ms 03 6 12s22ms 2s3ms 04 6 11s132ms 1s855ms 05 6 15s82ms 2s513ms 06 6 10s499ms 1s749ms 07 6 11s325ms 1s887ms 08 6 11s40ms 1s840ms 09 6 10s932ms 1s822ms 10 6 10s778ms 1s796ms 11 6 11s442ms 1s907ms 12 6 10s699ms 1s783ms 13 6 10s759ms 1s793ms 14 6 10s921ms 1s820ms 15 6 11s343ms 1s890ms 16 7 10s812ms 1s544ms 17 5 9s78ms 1s815ms 18 5 9s250ms 1s850ms 19 4 7s139ms 1s784ms 20 7 35s923ms 5s131ms 21 4 6s996ms 1s749ms 22 6 11s437ms 1s906ms [ User: intelifix - Total duration: 4m50s - Times executed: 135 ]
[ Application: psql - Total duration: 4m50s - Times executed: 135 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 00:05:19 Duration: 17s178ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 20:05:16 Duration: 15s91ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 20:15:14 Duration: 12s713ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 2m18s 4 4s997ms 1m4s 34s648ms 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 Sep 20 20 2 1m10s 35s4ms 23 2 1m8s 34s292ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-20 20:08:44 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-20 23:16:49 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-20 20:10:45 Duration: 5s107ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 1m48s 4 357ms 54s620ms 27s91ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 20 20 2 53s386ms 26s693ms 23 2 54s978ms 27s489ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-20 23:13:49 Duration: 54s620ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-20 20:05:44 Duration: 53s25ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-20 20:10:10 Duration: 360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 1m47s 6 3s112ms 39s814ms 17s917ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 20 20 3 53s100ms 17s700ms 23 3 54s404ms 18s134ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-09-20 23:14:33 Duration: 39s814ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:06:28 Duration: 39s541ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:33:42 Duration: 10s804ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 20 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:32:07 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m22s 6 2s291ms 31s487ms 13s741ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 20 20 3 41s67ms 13s689ms 23 3 41s379ms 13s793ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 23:15:08 Duration: 31s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 20:07:02 Duration: 31s107ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 20:10:29 Duration: 7s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 1m22s 6 3s86ms 31s887ms 13s714ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 20 20 3 41s470ms 13s823ms 23 3 40s815ms 13s605ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-09-20 20:09:16 Duration: 31s887ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:17:20 Duration: 31s302ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:10:52 Duration: 6s496ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 1m10s 6 2s265ms 24s337ms 11s810ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 20 20 3 35s228ms 11s742ms 23 3 35s633ms 11s877ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 23:11:31 Duration: 24s337ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:03:30 Duration: 23s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:09:49 Duration: 9s172ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 1m10s 6 2s427ms 23s513ms 11s803ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 20 20 3 35s265ms 11s755ms 23 3 35s557ms 11s852ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 23:10:49 Duration: 23s513ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:02:49 Duration: 23s155ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:09:38 Duration: 9s682ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 1m4s 6 1s669ms 25s654ms 10s829ms 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 #13
Day Hour Count Duration Avg duration Sep 20 20 3 32s184ms 10s728ms 23 3 32s791ms 10s930ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-20 23:12:31 Duration: 25s654ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:04:28 Duration: 25s213ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:10:05 Duration: 5s301ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 1m1s 1 1m1s 1m1s 1m1s create table temp0000291917 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 20 07 1 1m1s 1m1s [ User: intelifix - Total duration: 1m1s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 1 ]
-
CREATE TABLE temp0000291917 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-09-2026", "ate" :"20-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-20 07:33:13 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 1m 56 571ms 7s138ms 1s79ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 20 08 4 10s686ms 2s671ms 09 3 2s416ms 805ms 10 4 2s846ms 711ms 11 4 5s13ms 1s253ms 12 3 2s287ms 762ms 13 3 2s354ms 784ms 14 3 2s431ms 810ms 15 4 4s975ms 1s243ms 16 4 3s193ms 798ms 17 4 3s84ms 771ms 18 5 7s962ms 1s592ms 19 4 3s393ms 848ms 20 3 2s350ms 783ms 21 4 4s430ms 1s107ms 22 4 3s28ms 757ms [ User: intelifix - Total duration: 1m - Times executed: 56 ]
[ Application: psql - Total duration: 1m - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-20 08:00:08 Duration: 7s138ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-20 18:20:07 Duration: 3s862ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-20 15:20:04 Duration: 2s916ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 59s296ms 6 6s362ms 14s731ms 9s882ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 20 00 3 39s530ms 13s176ms 06 3 19s765ms 6s588ms [ User: intelifix - Total duration: 59s296ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s296ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:16 Duration: 14s731ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:41 Duration: 12s464ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:28 Duration: 12s335ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 55s642ms 4 4s141ms 24s118ms 13s910ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 20 20 2 27s382ms 13s691ms 23 2 28s259ms 14s129ms [ User: intelifix - Total duration: 55s642ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s642ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-20 23:12:55 Duration: 24s118ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-20 20:04:51 Duration: 23s107ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-20 20:10:09 Duration: 4s275ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 52s87ms 6 2s396ms 20s150ms 8s681ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 20 00 3 27s683ms 9s227ms 06 3 24s403ms 8s134ms [ User: lenon - Total duration: 52s87ms - Times executed: 6 ]
[ Application: psql - Total duration: 52s87ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 00:02:23 Duration: 20s150ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 06:02:20 Duration: 18s69ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 06:02:26 Duration: 3s936ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 51s303ms 6 1s787ms 16s982ms 8s550ms 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 #19
Day Hour Count Duration Avg duration Sep 20 20 3 25s355ms 8s451ms 23 3 25s947ms 8s649ms [ User: intelifix - Total duration: 51s303ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s303ms - 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-09-20 23:11:48 Duration: 16s982ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:03:46 Duration: 16s404ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:09:57 Duration: 7s163ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 40s984ms 6 1s87ms 16s983ms 6s830ms 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 #20
Day Hour Count Duration Avg duration Sep 20 20 3 20s358ms 6s786ms 23 3 20s626ms 6s875ms [ User: intelifix - Total duration: 40s984ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s984ms - 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-09-20 23:11:06 Duration: 16s983ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:03:06 Duration: 16s710ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:09:40 Duration: 2s559ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 135 4m50s 155ms 17s178ms 2s153ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 20 00 7 29s723ms 4s246ms 01 6 11s21ms 1s836ms 02 6 11s402ms 1s900ms 03 6 12s22ms 2s3ms 04 6 11s132ms 1s855ms 05 6 15s82ms 2s513ms 06 6 10s499ms 1s749ms 07 6 11s325ms 1s887ms 08 6 11s40ms 1s840ms 09 6 10s932ms 1s822ms 10 6 10s778ms 1s796ms 11 6 11s442ms 1s907ms 12 6 10s699ms 1s783ms 13 6 10s759ms 1s793ms 14 6 10s921ms 1s820ms 15 6 11s343ms 1s890ms 16 7 10s812ms 1s544ms 17 5 9s78ms 1s815ms 18 5 9s250ms 1s850ms 19 4 7s139ms 1s784ms 20 7 35s923ms 5s131ms 21 4 6s996ms 1s749ms 22 6 11s437ms 1s906ms [ User: intelifix - Total duration: 4m50s - Times executed: 135 ]
[ Application: psql - Total duration: 4m50s - Times executed: 135 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 00:05:19 Duration: 17s178ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 20:05:16 Duration: 15s91ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 20:15:14 Duration: 12s713ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 56 1m 571ms 7s138ms 1s79ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 20 08 4 10s686ms 2s671ms 09 3 2s416ms 805ms 10 4 2s846ms 711ms 11 4 5s13ms 1s253ms 12 3 2s287ms 762ms 13 3 2s354ms 784ms 14 3 2s431ms 810ms 15 4 4s975ms 1s243ms 16 4 3s193ms 798ms 17 4 3s84ms 771ms 18 5 7s962ms 1s592ms 19 4 3s393ms 848ms 20 3 2s350ms 783ms 21 4 4s430ms 1s107ms 22 4 3s28ms 757ms [ User: intelifix - Total duration: 1m - Times executed: 56 ]
[ Application: psql - Total duration: 1m - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-20 08:00:08 Duration: 7s138ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-20 18:20:07 Duration: 3s862ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-20 15:20:04 Duration: 2s916ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 48 1h8m18s 211ms 4m17s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 20 07 3 6m22s 2m7s 08 3 3m57s 1m19s 09 3 4m6s 1m22s 10 3 3m56s 1m18s 11 3 3m53s 1m17s 12 3 3m58s 1m19s 13 3 3m57s 1m19s 14 3 3m57s 1m19s 15 3 4m7s 1m22s 16 3 3m58s 1m19s 17 3 3m57s 1m19s 18 3 3m58s 1m19s 19 3 4m 1m20s 20 3 6m5s 2m1s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h8m18s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 07:23:26 Duration: 4m17s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 20:20:57 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 15:14:23 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 47 1h36m59s 1s419ms 11m11s 2m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 20 07 3 12m13s 4m4s 08 3 5m16s 1m45s 09 3 5m27s 1m49s 10 3 5m13s 1m44s 11 3 5m11s 1m43s 12 3 5m13s 1m44s 13 3 5m8s 1m42s 14 3 5m11s 1m43s 15 3 5m15s 1m45s 16 3 5m14s 1m44s 17 3 5m19s 1m46s 18 3 5m30s 1m50s 19 3 5m19s 1m46s 20 2 9m31s 4m45s 21 3 6m44s 2m14s 22 3 5m9s 1m43s [ User: intelifix - Total duration: 1h36m59s - Times executed: 47 ]
[ Application: psql - Total duration: 1h36m59s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 07:16:13 Duration: 11m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 20:14:25 Duration: 9m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 21:11:29 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 34 33s618ms 594ms 3s20ms 988ms 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 Sep 20 08 2 2s875ms 1s437ms 09 3 3s473ms 1s157ms 10 2 1s775ms 887ms 11 2 2s726ms 1s363ms 12 3 2s313ms 771ms 13 3 3s471ms 1s157ms 14 3 2s224ms 741ms 15 2 1s781ms 890ms 16 2 1s520ms 760ms 17 2 1s481ms 740ms 18 1 751ms 751ms 19 2 1s657ms 828ms 20 3 4s557ms 1s519ms 21 2 1s564ms 782ms 22 2 1s441ms 720ms [ User: intelifix - Total duration: 33s618ms - Times executed: 34 ]
[ Application: psql - Total duration: 33s618ms - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 20:20:04 Duration: 3s20ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 11:40:03 Duration: 1s984ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 08:20:03 Duration: 1s932ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 8 14s170ms 1s639ms 1s961ms 1s771ms call rs_giga_triagem (?) / 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 #6
Day Hour Count Duration Avg duration Sep 20 17 1 1s893ms 1s893ms 18 1 1s747ms 1s747ms 19 2 3s526ms 1s763ms 20 2 3s604ms 1s802ms 21 2 3s398ms 1s699ms [ User: intelifix - Total duration: 14s170ms - Times executed: 8 ]
[ Application: psql - Total duration: 14s170ms - Times executed: 8 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 20:35:03 Duration: 1s961ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 17:55:03 Duration: 1s893ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 19:55:03 Duration: 1s794ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 7 3s70ms 340ms 555ms 438ms 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 Sep 20 20 3 1s310ms 436ms 23 4 1s759ms 439ms [ User: intelifix - Total duration: 3s70ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s70ms - 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-09-20 20:02:03 Duration: 555ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:10:03 Duration: 501ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:17:22 Duration: 462ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 7 3s45ms 170ms 1s138ms 435ms call rs_giga_tecnicos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 20 00 3 2s130ms 710ms 20 4 914ms 228ms [ User: intelifix - Total duration: 3s45ms - Times executed: 7 ]
[ Application: psql - Total duration: 3s45ms - Times executed: 7 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-20 00:05:03 Duration: 1s138ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-20 00:05:02 Duration: 791ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-20 20:05:01 Duration: 287ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 7 2s107ms 206ms 364ms 301ms 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 #9
Day Hour Count Duration Avg duration Sep 20 20 3 781ms 260ms 23 4 1s326ms 331ms [ User: intelifix - Total duration: 2s107ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s107ms - 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-09-20 23:32:39 Duration: 364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:10:02 Duration: 362ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:17:22 Duration: 314ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 7 1s445ms 159ms 359ms 206ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 20 07 7 1s445ms 206ms [ User: intelifix - Total duration: 1s445ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1s445ms - Times executed: 7 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229854899496');
Date: 2026-09-20 07:21:32 Duration: 359ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229894694346');
Date: 2026-09-20 07:28:13 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229840748396');
Date: 2026-09-20 07:21:49 Duration: 194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 6 1m47s 3s112ms 39s814ms 17s917ms 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 #11
Day Hour Count Duration Avg duration Sep 20 20 3 53s100ms 17s700ms 23 3 54s404ms 18s134ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-09-20 23:14:33 Duration: 39s814ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:06:28 Duration: 39s541ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:33:42 Duration: 10s804ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 6 1m22s 2s291ms 31s487ms 13s741ms 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 Sep 20 20 3 41s67ms 13s689ms 23 3 41s379ms 13s793ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 23:15:08 Duration: 31s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 20:07:02 Duration: 31s107ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 20:10:29 Duration: 7s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 6 1m22s 3s86ms 31s887ms 13s714ms 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 Sep 20 20 3 41s470ms 13s823ms 23 3 40s815ms 13s605ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-09-20 20:09:16 Duration: 31s887ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:17:20 Duration: 31s302ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:10:52 Duration: 6s496ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 6 1m10s 2s265ms 24s337ms 11s810ms 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 Sep 20 20 3 35s228ms 11s742ms 23 3 35s633ms 11s877ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 23:11:31 Duration: 24s337ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:03:30 Duration: 23s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:09:49 Duration: 9s172ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 6 1m10s 2s427ms 23s513ms 11s803ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 20 20 3 35s265ms 11s755ms 23 3 35s557ms 11s852ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 23:10:49 Duration: 23s513ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:02:49 Duration: 23s155ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:09:38 Duration: 9s682ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 6 1m4s 1s669ms 25s654ms 10s829ms 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 Sep 20 20 3 32s184ms 10s728ms 23 3 32s791ms 10s930ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-20 23:12:31 Duration: 25s654ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:04:28 Duration: 25s213ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:10:05 Duration: 5s301ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 6 59s296ms 6s362ms 14s731ms 9s882ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 20 00 3 39s530ms 13s176ms 06 3 19s765ms 6s588ms [ User: intelifix - Total duration: 59s296ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s296ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:16 Duration: 14s731ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:41 Duration: 12s464ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:28 Duration: 12s335ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 6 52s87ms 2s396ms 20s150ms 8s681ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 20 00 3 27s683ms 9s227ms 06 3 24s403ms 8s134ms [ User: lenon - Total duration: 52s87ms - Times executed: 6 ]
[ Application: psql - Total duration: 52s87ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 00:02:23 Duration: 20s150ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 06:02:20 Duration: 18s69ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 06:02:26 Duration: 3s936ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 6 51s303ms 1s787ms 16s982ms 8s550ms 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 #19
Day Hour Count Duration Avg duration Sep 20 20 3 25s355ms 8s451ms 23 3 25s947ms 8s649ms [ User: intelifix - Total duration: 51s303ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s303ms - 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-09-20 23:11:48 Duration: 16s982ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:03:46 Duration: 16s404ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:09:57 Duration: 7s163ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 6 40s984ms 1s87ms 16s983ms 6s830ms 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 #20
Day Hour Count Duration Avg duration Sep 20 20 3 20s358ms 6s786ms 23 3 20s626ms 6s875ms [ User: intelifix - Total duration: 40s984ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s984ms - 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-09-20 23:11:06 Duration: 16s983ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:03:06 Duration: 16s710ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:09:40 Duration: 2s559ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m7s 11m47s 7m33s 3 22m40s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 20 05 3 22m40s 7m33s [ User: intelifix - Total duration: 22m40s - Times executed: 3 ]
[ Application: psql - Total duration: 22m40s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-20 05:11:48 Duration: 11m47s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-09-20 05:19:33 Duration: 7m44s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-09-20 05:22:41 Duration: 3m7s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1s419ms 11m11s 2m3s 47 1h36m59s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 20 07 3 12m13s 4m4s 08 3 5m16s 1m45s 09 3 5m27s 1m49s 10 3 5m13s 1m44s 11 3 5m11s 1m43s 12 3 5m13s 1m44s 13 3 5m8s 1m42s 14 3 5m11s 1m43s 15 3 5m15s 1m45s 16 3 5m14s 1m44s 17 3 5m19s 1m46s 18 3 5m30s 1m50s 19 3 5m19s 1m46s 20 2 9m31s 4m45s 21 3 6m44s 2m14s 22 3 5m9s 1m43s [ User: intelifix - Total duration: 1h36m59s - Times executed: 47 ]
[ Application: psql - Total duration: 1h36m59s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 07:16:13 Duration: 11m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 20:14:25 Duration: 9m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-20 21:11:29 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 211ms 4m17s 1m25s 48 1h8m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 20 07 3 6m22s 2m7s 08 3 3m57s 1m19s 09 3 4m6s 1m22s 10 3 3m56s 1m18s 11 3 3m53s 1m17s 12 3 3m58s 1m19s 13 3 3m57s 1m19s 14 3 3m57s 1m19s 15 3 4m7s 1m22s 16 3 3m58s 1m19s 17 3 3m57s 1m19s 18 3 3m58s 1m19s 19 3 4m 1m20s 20 3 6m5s 2m1s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h8m18s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 07:23:26 Duration: 4m17s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 20:20:57 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-20 15:14:23 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 20 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:32:07 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 1m1s 1m1s 1m1s 1 1m1s create table temp0000291917 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 20 07 1 1m1s 1m1s [ User: intelifix - Total duration: 1m1s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 1 ]
-
CREATE TABLE temp0000291917 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-09-2026", "ate" :"20-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-20 07:33:13 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 4s997ms 1m4s 34s648ms 4 2m18s 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 Sep 20 20 2 1m10s 35s4ms 23 2 1m8s 34s292ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-20 20:08:44 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-20 23:16:49 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-20 20:10:45 Duration: 5s107ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 357ms 54s620ms 27s91ms 4 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 20 20 2 53s386ms 26s693ms 23 2 54s978ms 27s489ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-20 23:13:49 Duration: 54s620ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-20 20:05:44 Duration: 53s25ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-20 20:10:10 Duration: 360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 3s112ms 39s814ms 17s917ms 6 1m47s 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 Sep 20 20 3 53s100ms 17s700ms 23 3 54s404ms 18s134ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-09-20 23:14:33 Duration: 39s814ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:06:28 Duration: 39s541ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:33:42 Duration: 10s804ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 4s141ms 24s118ms 13s910ms 4 55s642ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 20 20 2 27s382ms 13s691ms 23 2 28s259ms 14s129ms [ User: intelifix - Total duration: 55s642ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s642ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-20 23:12:55 Duration: 24s118ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-20 20:04:51 Duration: 23s107ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-20 20:10:09 Duration: 4s275ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 2s291ms 31s487ms 13s741ms 6 1m22s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 20 20 3 41s67ms 13s689ms 23 3 41s379ms 13s793ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 23:15:08 Duration: 31s487ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 20:07:02 Duration: 31s107ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-20 20:10:29 Duration: 7s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 3s86ms 31s887ms 13s714ms 6 1m22s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 20 20 3 41s470ms 13s823ms 23 3 40s815ms 13s605ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-09-20 20:09:16 Duration: 31s887ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 23:17:20 Duration: 31s302ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:10:52 Duration: 6s496ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 2s265ms 24s337ms 11s810ms 6 1m10s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 20 20 3 35s228ms 11s742ms 23 3 35s633ms 11s877ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 23:11:31 Duration: 24s337ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:03:30 Duration: 23s786ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:09:49 Duration: 9s172ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 2s427ms 23s513ms 11s803ms 6 1m10s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 20 20 3 35s265ms 11s755ms 23 3 35s557ms 11s852ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 23:10:49 Duration: 23s513ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:02:49 Duration: 23s155ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-20 20:09:38 Duration: 9s682ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 1s669ms 25s654ms 10s829ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 20 20 3 32s184ms 10s728ms 23 3 32s791ms 10s930ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-20 23:12:31 Duration: 25s654ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:04:28 Duration: 25s213ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:10:05 Duration: 5s301ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 6s362ms 14s731ms 9s882ms 6 59s296ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 20 00 3 39s530ms 13s176ms 06 3 19s765ms 6s588ms [ User: intelifix - Total duration: 59s296ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s296ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:16 Duration: 14s731ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:41 Duration: 12s464ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-20 00:05:28 Duration: 12s335ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 2s396ms 20s150ms 8s681ms 6 52s87ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 20 00 3 27s683ms 9s227ms 06 3 24s403ms 8s134ms [ User: lenon - Total duration: 52s87ms - Times executed: 6 ]
[ Application: psql - Total duration: 52s87ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 00:02:23 Duration: 20s150ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 06:02:20 Duration: 18s69ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-20 06:02:26 Duration: 3s936ms Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 1s787ms 16s982ms 8s550ms 6 51s303ms 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 Sep 20 20 3 25s355ms 8s451ms 23 3 25s947ms 8s649ms [ User: intelifix - Total duration: 51s303ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s303ms - 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-09-20 23:11:48 Duration: 16s982ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:03:46 Duration: 16s404ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:09:57 Duration: 7s163ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 1s87ms 16s983ms 6s830ms 6 40s984ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 20 20 3 20s358ms 6s786ms 23 3 20s626ms 6s875ms [ User: intelifix - Total duration: 40s984ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 40s984ms - 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-09-20 23:11:06 Duration: 16s983ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:03:06 Duration: 16s710ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.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-09-20 20:09:40 Duration: 2s559ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 155ms 17s178ms 2s153ms 135 4m50s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 20 00 7 29s723ms 4s246ms 01 6 11s21ms 1s836ms 02 6 11s402ms 1s900ms 03 6 12s22ms 2s3ms 04 6 11s132ms 1s855ms 05 6 15s82ms 2s513ms 06 6 10s499ms 1s749ms 07 6 11s325ms 1s887ms 08 6 11s40ms 1s840ms 09 6 10s932ms 1s822ms 10 6 10s778ms 1s796ms 11 6 11s442ms 1s907ms 12 6 10s699ms 1s783ms 13 6 10s759ms 1s793ms 14 6 10s921ms 1s820ms 15 6 11s343ms 1s890ms 16 7 10s812ms 1s544ms 17 5 9s78ms 1s815ms 18 5 9s250ms 1s850ms 19 4 7s139ms 1s784ms 20 7 35s923ms 5s131ms 21 4 6s996ms 1s749ms 22 6 11s437ms 1s906ms [ User: intelifix - Total duration: 4m50s - Times executed: 135 ]
[ Application: psql - Total duration: 4m50s - Times executed: 135 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 00:05:19 Duration: 17s178ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 20:05:16 Duration: 15s91ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-20 20:15:14 Duration: 12s713ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 1s639ms 1s961ms 1s771ms 8 14s170ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 20 17 1 1s893ms 1s893ms 18 1 1s747ms 1s747ms 19 2 3s526ms 1s763ms 20 2 3s604ms 1s802ms 21 2 3s398ms 1s699ms [ User: intelifix - Total duration: 14s170ms - Times executed: 8 ]
[ Application: psql - Total duration: 14s170ms - Times executed: 8 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 20:35:03 Duration: 1s961ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 17:55:03 Duration: 1s893ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-20 19:55:03 Duration: 1s794ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.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 16 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 19 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms Sep 20 10 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms [ User: intelifix - Total duration: 23m52s - Times executed: 16 ]
[ Application: psql - Total duration: 23m52s - Times executed: 16 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 3,929 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 34 FATAL entries
- 1027 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,023 Max number of times the same event was reported
- 1,062 Total events found
Rank Times reported Error 1 1,023 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 20 00 59 01 59 02 60 03 59 04 60 05 59 06 59 07 60 08 59 09 59 10 60 11 59 12 60 13 59 14 60 15 59 16 59 17 14 - ERROR: prepared statement "_PLAN0000000029BDC040" does not exist
- ERROR: prepared statement "_PLAN0000000029DE7FE0" does not exist
- ERROR: prepared statement "_PLAN0000000029DEBB30" does not exist
Statement: DEALLOCATE "_PLAN0000000029BDC040"
Date: 2026-09-20 00:00:57 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: DEALLOCATE "_PLAN0000000029DE7FE0"
Date: 2026-09-20 00:01:57 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: DEALLOCATE "_PLAN0000000029DEBB30"
Date: 2026-09-20 00:02:58 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 23 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 20 00 1 06 2 07 3 08 1 10 1 12 1 13 4 17 6 18 3 22 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-20 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-09-20 06:02:26 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-09-20 06:27:10 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 20 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-09-20 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-09-20 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-09-20 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 20 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-20 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-20 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-20 05:32:07 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 2 FATAL: database "..." does not exist /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(
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 20 18 1 22 1 - FATAL: database "jaboatao" does not exist /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(
- FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-09-20 18:59:14 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-09-20 22:38:32 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 20 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-20 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-09-20 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 20 03 1 - LOG: database system was shut down at 2026-09-20 03:05:01 -03
Date: 2026-09-20 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-20.log