pgBadger-
Global information
- Generated on Sat Oct 3 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 16,042 log entries in 8s
- Log start from 2026-10-03 00:00:15 to 2026-10-03 23:49:49
-
Overview
Global Stats
- 138 Number of unique normalized queries
- 943 Number of queries
- 3h43m5s Total query duration
- 2026-10-03 00:02:03 First query
- 2026-10-03 23:43:00 Last query
- 5 queries/s at 2026-10-03 23:42:38 Query peak
- 3h43m5s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h43m5s Execute total duration
- 3,258 Number of events
- 6 Number of unique normalized events
- 3,233 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 3 Total number of automatic analyzes
- 20 Number temporary file
- 248.84 MiB Max size of temporary file
- 67.71 MiB Average size of temporary file
- 247 Total number of sessions
- 8 sessions at 2026-10-03 01:02:38 Session peak
- 9d11h37m34s Total duration of sessions
- 55m17s Average duration of sessions
- 3 Average queries per session
- 54s192ms Average queries duration per session
- 54m23s Average idle time per session
- 252 Total number of connections
- 7 connections/s at 2026-10-03 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-03 23:42:38 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-10-03 23:42:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-03 23:42:38 Date
Queries duration
Key values
- 3h43m5s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 03 00 26 0ms 13s495ms 2s811ms 3s947ms 4s616ms 47s873ms 01 18 0ms 2s875ms 1s516ms 3s903ms 4s241ms 5s757ms 02 18 0ms 2s917ms 1s605ms 3s890ms 4s784ms 5s969ms 03 18 0ms 3s473ms 1s584ms 3s502ms 4s891ms 6s492ms 04 18 0ms 3s57ms 1s616ms 4s85ms 4s711ms 5s727ms 05 22 0ms 8m38s 53s967ms 6s176ms 2m31s 8m38s 06 18 0ms 9s31ms 2s221ms 2s895ms 2s995ms 24s52ms 07 18 0ms 5m47s 36s673ms 3s37ms 50s661ms 5m47s 08 24 0ms 5m1s 23s891ms 3s3ms 3s975ms 5m44s 09 24 0ms 5m7s 23s983ms 2s936ms 3s95ms 5m51s 10 24 0ms 5m6s 23s803ms 2s941ms 3s147ms 5m48s 11 24 0ms 5m18s 24s539ms 2s973ms 15s176ms 5m47s 12 24 0ms 5m11s 24s149ms 2s983ms 3s126ms 5m54s 13 24 0ms 5m5s 23s771ms 3s 3s134ms 5m48s 14 24 0ms 5m2s 23s790ms 2s932ms 3s62ms 5m46s 15 24 0ms 5m 23s718ms 3s55ms 3s297ms 5m42s 16 24 0ms 5m2s 23s807ms 2s980ms 3s245ms 5m45s 17 24 0ms 5m10s 24s488ms 2s995ms 3s131ms 5m57s 18 26 0ms 5m6s 22s167ms 2s960ms 3s360ms 5m49s 19 24 0ms 5m6s 24s23ms 2s909ms 3s150ms 5m49s 20 104 0ms 5m39s 11s531ms 1m2s 1m25s 6m36s 21 24 0ms 6m30s 27s507ms 2s949ms 42s973ms 6m30s 22 25 0ms 5m1s 22s797ms 2s943ms 3s19ms 5m44s 23 344 0ms 1m4s 5s727ms 1m5s 1m5s 1m8s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 03 00 5 0 615ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 371ms 0ms 0ms 0ms 07 6 0 1m47s 0ms 0ms 3m39s 08 6 0 1m31s 0ms 0ms 3m24s 09 6 0 1m32s 0ms 0ms 3m21s 10 6 0 1m31s 0ms 0ms 3m19s 11 6 0 1m34s 0ms 0ms 3m23s 12 6 0 1m32s 0ms 0ms 3m22s 13 6 0 1m31s 0ms 0ms 3m19s 14 6 0 1m31s 0ms 0ms 3m22s 15 6 0 1m30s 0ms 0ms 3m23s 16 6 0 1m31s 0ms 0ms 3m22s 17 6 0 1m34s 0ms 0ms 3m27s 18 8 0 1m9s 0ms 0ms 3m21s 19 6 0 1m32s 0ms 0ms 3m24s 20 8 78 13s562ms 35s195ms 1m2s 3m32s 21 6 0 1m46s 0ms 0ms 3m23s 22 7 0 1m18s 0ms 0ms 3m22s 23 24 320 5s727ms 1m3s 1m4s 1m8s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 03 00 0 1 1.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 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Oct 03 00 19 0.01/s 01 9 0.00/s 02 9 0.00/s 03 20 0.01/s 04 8 0.00/s 05 9 0.00/s 06 15 0.00/s 07 11 0.00/s 08 10 0.00/s 09 8 0.00/s 10 10 0.00/s 11 11 0.00/s 12 9 0.00/s 13 9 0.00/s 14 10 0.00/s 15 10 0.00/s 16 12 0.00/s 17 10 0.00/s 18 10 0.00/s 19 8 0.00/s 20 11 0.00/s 21 7 0.00/s 22 9 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Oct 03 00 6 1h 59m48s 01 18 1h1m39s 1h1m37s 02 8 1h 59m56s 03 20 27m3s 27m2s 04 8 1h2m37s 1h2m33s 05 8 1h54s 58m25s 06 9 57m13s 57m9s 07 15 1h1m47s 1h1m3s 08 11 1h1m52s 1h59s 09 10 1h18s 59m20s 10 8 1h 58m48s 11 10 55m 54m1s 12 10 57m18s 56m20s 13 9 1h35s 59m31s 14 9 1h23s 59m20s 15 10 1h40s 59m43s 16 8 53m45s 52m34s 17 10 59m18s 58m19s 18 10 1h30s 59m33s 19 9 1h 58m56s 20 11 44m59s 43m10s 21 8 1h21s 58m59s 22 7 1h 58m38s 23 15 39m12s 37m -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-10-03 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 252 connections Total
Connections per user
Key values
- intelifix Main User
- 252 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-10-03 01:02:38 Date
Histogram of session times
Key values
- 213 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 247 sessions Total
Sessions per user
Key values
- intelifix Main User
- 247 sessions Total
Sessions per host
Key values
- [local] Main Host
- 247 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 21,989 buffers Checkpoint Peak
- 2026-10-03 00:09:48 Date
- 270.045 seconds Highest write time
- 0.017 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-10-03 00:09:48 Date
Checkpoints distance
Key values
- 145.27 Mo Distance Peak
- 2026-10-03 00:09:48 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 03 00 35,416 700.203s 0.01s 700.243s 01 2,452 245.698s 0.01s 245.725s 02 2,849 285.288s 0.013s 285.316s 03 2,873 287.824s 0.024s 287.876s 04 3,201 320.588s 0.01s 320.628s 05 9,468 941.131s 0.043s 941.199s 06 2,991 269.665s 0.001s 269.669s 07 1,583 158.659s 0.006s 158.675s 08 25 2.522s 0.003s 2.53s 09 23 2.312s 0.002s 2.316s 10 23 2.311s 0.002s 2.315s 11 23 2.312s 0.002s 2.316s 12 23 2.312s 0.002s 2.316s 13 25 2.519s 0.003s 2.528s 14 24 2.42s 0.004s 2.429s 15 24 2.42s 0.004s 2.427s 16 24 2.419s 0.005s 2.427s 17 25 2.521s 0.003s 2.529s 18 695 69.572s 0.006s 69.586s 19 24 2.421s 0.004s 2.429s 20 101 10.14s 0.006s 10.152s 21 23 2.312s 0.002s 2.316s 22 24 2.419s 0.004s 2.43s 23 23 2.318s 0.003s 2.327s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 03 00 0 0 9 516 0.002s 0.006s 01 0 0 1 433 0.002s 0.006s 02 0 0 1 415 0.002s 0.006s 03 0 0 1 395 0.003s 0.007s 04 0 0 1 471 0.002s 0.006s 05 0 0 4 617 0.015s 0.008s 06 0 0 0 8 0.001s 0.001s 07 0 0 1 23 0.002s 0.004s 08 0 0 0 5 0.002s 0.002s 09 0 0 0 3 0.001s 0.001s 10 0 0 0 3 0.001s 0.001s 11 0 0 0 3 0.001s 0.001s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 5 0.001s 0.002s 14 0 0 0 5 0.002s 0.002s 15 0 0 0 5 0.002s 0.002s 16 0 0 0 5 0.002s 0.003s 17 0 0 0 5 0.001s 0.002s 18 0 0 0 54 0.002s 0.003s 19 0 0 0 5 0.001s 0.002s 20 0 0 0 17 0.002s 0.003s 21 0 0 0 3 0.002s 0.001s 22 0 0 0 5 0.001s 0.002s 23 0 0 0 2 0.002s 0.003s Day Hour Count Avg time (sec) Oct 03 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Oct 03 00 24,651.00 kB 62,855.00 kB 01 2,092.67 kB 35,001.67 kB 02 2,469.00 kB 19,711.67 kB 03 1,931.12 kB 4,428.25 kB 04 2,850.67 kB 3,754.67 kB 05 8,512.12 kB 17,117.62 kB 06 7,034.00 kB 15,224.00 kB 07 2,326.25 kB 12,550.75 kB 08 94.50 kB 9,141.00 kB 09 188.00 kB 7,821.00 kB 10 187.00 kB 7,058.00 kB 11 188.00 kB 6,371.00 kB 12 187.00 kB 5,752.00 kB 13 95.00 kB 4,928.50 kB 14 94.50 kB 4,011.50 kB 15 95.00 kB 3,268.00 kB 16 94.50 kB 2,664.50 kB 17 94.50 kB 2,174.00 kB 18 826.67 kB 2,007.67 kB 19 94.50 kB 1,565.00 kB 20 466.00 kB 1,294.00 kB 21 188.00 kB 1,111.00 kB 22 94.50 kB 964.50 kB 23 38.50 kB 788.50 kB -
Temporary Files
Size of temporary files
Key values
- 497.67 MiB Temp Files size Peak
- 2026-10-03 05:31:55 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-03 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.71 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 37.11 MiB 248.84 MiB 65.31 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-03 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-03 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 309.26 MiB 57.48 MiB 94.60 MiB 77.32 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:30:40 Duration: 38s921ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 248.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 248.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-03 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-03 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-03 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-03 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.04 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.04 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.04 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.04 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.04 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-03 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.04 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-03 00:05:44 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 1.04 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-03 00:05:44 Date
Analyzes per table
Key values
- auditor.auditor_2026_10 (1) Main table analyzed (database contagem)
- 3 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 229 28 179,929 19 59 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,632 56 359,390 43 325 rio.auditor.auditor_2026_10 1 0 0 0 0 0 0 11,263 11,266 13,936,964 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,214 316 1,439,724 284 1,721 brasilia.auditor.auditor_2026_10 1 0 0 0 0 0 0 3,590 3,299 4,031,230 39 149 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,201 13 173,556 4 37 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 888 129 845,812 92 323 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 133 8 51,961 3 11 contagem.auditor.auditor_2026_10 1 0 0 0 0 0 0 3,575 2,033 2,347,377 0 0 Total 9 6 0 0 0 0 0 27,725 17,148 23,365,943 484 2,625 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (1.04) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed brasilia.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.1 rio.auditor.auditor_2026_10 0 0 1.04 rio.pg_catalog.pg_statistic 0 0 0.2 brasilia.auditor.auditor_2026_10 0 0 0.46 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.auditor.auditor_2026_10 0 0 0.38 Total 0 0 2.28 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4557) Main table with removed tuples on database rio
- 14543 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,557 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,462 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,837 7,360 0 0 1,071 rio.pg_toast.pg_toast_2619 1 1 723 680 0 0 281 brasilia.auditor.auditor_2026_10 1 0 675 496,716 0 0 22,054 brasilia.pg_toast.pg_toast_2619 1 1 170 145 0 6 67 contagem.pg_toast.pg_toast_2619 1 1 119 116 0 0 55 rio.auditor.auditor_2026_10 1 0 0 1,511,029 0 0 73,310 contagem.auditor.auditor_2026_10 1 0 0 337,438 0 0 16,610 Total 9 6 14,543 2,368,222 0 6 115,745 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (6) Main table with removed pages on database brasilia
- 6 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 170 6 brasilia.pg_catalog.pg_statistic 1 1 3837 0 rio.auditor.auditor_2026_10 1 0 0 0 rio.pg_catalog.pg_statistic 1 1 4557 0 brasilia.auditor.auditor_2026_10 1 0 675 0 contagem.pg_catalog.pg_statistic 1 1 4462 0 rio.pg_toast.pg_toast_2619 1 1 723 0 contagem.pg_toast.pg_toast_2619 1 1 119 0 contagem.auditor.auditor_2026_10 1 0 0 0 Total 9 6 14,543 6 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 03 00 3 3 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 1.04 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
- 133 Total read queries
- 398 Total write queries
Queries by database
Key values
- rio Main database
- 415 Requests
- 2h21m42s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 928 Requests
User Request type Count Duration etiquetas Total 8 3s76ms select 8 3s76ms intelifix Total 928 3h42m58s copy to 398 41m44s others 412 29m41s select 118 2h31m31s lenon Total 7 4s37ms select 7 4s37ms Duration by user
Key values
- 3h42m58s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 8 3s76ms select 8 3s76ms intelifix Total 928 3h42m58s copy to 398 41m44s others 412 29m41s select 118 2h31m31s lenon Total 7 4s37ms select 7 4s37ms Queries by host
Key values
- [local] Main host
- 943 Requests
- 3h43m5s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 517 Requests
- 3h1m12s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-03 15:10:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 353 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 8m38s analyze verbose;[ Date: 2026-10-03 05:08:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 21:11:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m8s analyze verbose;[ Date: 2026-10-03 05:14:48 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 07:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 20:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 11:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 12:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 17:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 09:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 10:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 19:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 18:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 13:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 16:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 14:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 22:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 08:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-03 15:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m33s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-03 07:15:37 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m25s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-03 20:15:18 - 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 1h29m11s 48 2s224ms 6m30s 1m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 03 07 3 6m16s 2m5s 08 3 5m18s 1m46s 09 3 5m24s 1m48s 10 3 5m23s 1m47s 11 3 5m36s 1m52s 12 3 5m28s 1m49s 13 3 5m22s 1m47s 14 3 5m19s 1m46s 15 3 5m17s 1m45s 16 3 5m19s 1m46s 17 3 5m27s 1m49s 18 3 5m23s 1m47s 19 3 5m23s 1m47s 20 3 6m3s 2m1s 21 3 6m47s 2m15s 22 3 5m18s 1m46s [ User: intelifix - Total duration: 1h29m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 21:11:32 Duration: 6m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 07:10:48 Duration: 5m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 20:10:41 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: psql
2 1h2m13s 48 227ms 3m33s 1m17s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 03 07 3 4m25s 1m28s 08 3 3m49s 1m16s 09 3 3m48s 1m16s 10 3 3m45s 1m15s 11 3 3m49s 1m16s 12 3 3m48s 1m16s 13 3 3m44s 1m14s 14 3 3m48s 1m16s 15 3 3m48s 1m16s 16 3 3m48s 1m16s 17 3 3m57s 1m19s 18 3 3m47s 1m15s 19 3 3m51s 1m17s 20 3 4m20s 1m26s 21 3 3m49s 1m16s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h2m13s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m13s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 07:15:37 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 20:15:18 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 17:14:24 Duration: 3m24s Database: brasilia User: intelifix Remote: [local] Application: psql
3 17m18s 3 2m31s 8m38s 5m46s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 03 05 3 17m18s 5m46s [ User: intelifix - Total duration: 17m18s - Times executed: 3 ]
[ Application: psql - Total duration: 17m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-03 05:08:40 Duration: 8m38s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-03 05:14:48 Duration: 6m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-03 05:17:20 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m6s 276 190ms 7s50ms 1s543ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 03 00 12 19s623ms 1s635ms 01 12 17s863ms 1s488ms 02 12 18s372ms 1s531ms 03 12 18s325ms 1s527ms 04 12 18s186ms 1s515ms 05 12 18s19ms 1s501ms 06 12 17s837ms 1s486ms 07 12 17s862ms 1s488ms 08 12 18s178ms 1s514ms 09 12 17s856ms 1s488ms 10 12 18s53ms 1s504ms 11 12 18s14ms 1s501ms 12 12 18s41ms 1s503ms 13 12 18s51ms 1s504ms 14 12 17s899ms 1s491ms 15 12 18s517ms 1s543ms 16 12 18s422ms 1s535ms 17 12 18s194ms 1s516ms 18 12 18s321ms 1s526ms 19 12 17s792ms 1s482ms 20 12 27s244ms 2s270ms 21 12 17s615ms 1s467ms 22 12 17s716ms 1s476ms [ User: intelifix - Total duration: 7m6s - Times executed: 276 ]
[ Application: psql - Total duration: 7m6s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-03 20:05:08 Duration: 7s50ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-03 20:15:06 Duration: 5s343ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-03 00:05:18 Duration: 3s653ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m15s 4 4s147ms 1m4s 33s785ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 03 20 2 1m6s 33s265ms 23 2 1m8s 34s305ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-03 23:16:45 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-03 20:08:36 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-03 23:34:00 Duration: 4s332ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m47s 6 3s165ms 40s383ms 17s977ms 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 #6
Day Hour Count Duration Avg duration Oct 03 20 3 53s628ms 17s876ms 23 3 54s234ms 18s78ms [ 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-10-03 23:14:29 Duration: 40s383ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-03 20:06:24 Duration: 39s977ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-03 23:33:36 Duration: 10s589ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m47s 4 330ms 53s513ms 26s771ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 03 20 2 53s240ms 26s620ms 23 2 53s846ms 26s923ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-03 23:13:47 Duration: 53s513ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-03 20:05:42 Duration: 52s909ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-03 23:33:25 Duration: 333ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
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 Oct 03 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-10-03 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-03 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m23s 6 2s303ms 31s834ms 13s882ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 03 20 3 41s462ms 13s820ms 23 3 41s834ms 13s944ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 23:15:04 Duration: 31s834ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 20:06:57 Duration: 31s401ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 20:10:17 Duration: 7s722ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m22s 6 3s48ms 31s872ms 13s767ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 03 20 3 41s45ms 13s681ms 23 3 41s561ms 13s853ms [ 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-10-03 23:17:17 Duration: 31s872ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-03 20:09:07 Duration: 31s509ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-03 23:34:07 Duration: 6s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m11s 6 2s482ms 23s817ms 11s920ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 03 20 3 35s476ms 11s825ms 23 3 36s44ms 12s14ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:10:49 Duration: 23s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 20:02:46 Duration: 23s291ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:32:53 Duration: 9s743ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m11s 6 2s201ms 24s356ms 11s864ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 03 20 3 35s350ms 11s783ms 23 3 35s834ms 11s944ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:11:30 Duration: 24s356ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 20:03:27 Duration: 23s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:33:05 Duration: 9s220ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m9s 34 246ms 13s495ms 2s42ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 03 00 6 20s400ms 3s400ms 01 6 9s427ms 1s571ms 02 6 10s534ms 1s755ms 03 5 9s990ms 1s998ms 04 6 10s913ms 1s818ms 05 5 8s172ms 1s634ms [ User: intelifix - Total duration: 1m9s - Times executed: 34 ]
[ Application: psql - Total duration: 1m9s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-03 00:05:14 Duration: 13s495ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-03 03:15:05 Duration: 3s473ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-03 05:25:04 Duration: 3s273ms Database: rio User: intelifix Remote: [local] Application: psql
14 1m3s 6 1s670ms 25s372ms 10s659ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 03 20 3 31s716ms 10s572ms 23 3 32s241ms 10s747ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 23:12:29 Duration: 25s372ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 20:04:25 Duration: 25s140ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 23:33:21 Duration: 5s144ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 55s587ms 4 4s212ms 23s677ms 13s896ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 03 20 2 27s685ms 13s842ms 23 2 27s902ms 13s951ms [ User: intelifix - Total duration: 55s587ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s587ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-03 23:12:53 Duration: 23s677ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-03 20:04:49 Duration: 23s473ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-03 23:33:25 Duration: 4s224ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 51s560ms 6 1s784ms 16s801ms 8s593ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 03 20 3 25s389ms 8s463ms 23 3 26s170ms 8s723ms [ User: intelifix - Total duration: 51s560ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s560ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 23:11:47 Duration: 16s801ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 20:03:43 Duration: 16s455ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 23:33:13 Duration: 7s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 51s42ms 6 5s141ms 12s167ms 8s507ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 03 00 3 30s1ms 10s 06 3 21s40ms 7s13ms [ User: intelifix - Total duration: 51s42ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s42ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 00:05:23 Duration: 12s167ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 00:05:11 Duration: 9s698ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 06:05:18 Duration: 9s31ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 48s314ms 61 573ms 1s736ms 792ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 03 08 4 3s126ms 781ms 09 4 2s876ms 719ms 10 4 3s41ms 760ms 11 5 3s889ms 777ms 12 4 3s198ms 799ms 13 4 3s184ms 796ms 14 4 3s125ms 781ms 15 4 3s129ms 782ms 16 4 3s155ms 788ms 17 3 2s192ms 730ms 18 5 4s54ms 810ms 19 4 2s943ms 735ms 20 5 4s877ms 975ms 21 3 2s484ms 828ms 22 4 3s31ms 757ms [ User: intelifix - Total duration: 48s314ms - Times executed: 61 ]
[ Application: psql - Total duration: 48s314ms - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-03 20:20:02 Duration: 1s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-03 10:00:03 Duration: 965ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-03 20:40:02 Duration: 930ms Database: rio User: intelifix Remote: [local] Application: psql
19 41s112ms 6 1s31ms 16s990ms 6s852ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 03 20 3 20s416ms 6s805ms 23 3 20s696ms 6s898ms [ User: intelifix - Total duration: 41s112ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s112ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 23:11:06 Duration: 16s990ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 20:03:03 Duration: 16s811ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 23:32:56 Duration: 2s603ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 38s921ms 1 38s921ms 38s921ms 38s921ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 03 05 1 38s921ms 38s921ms [ User: intelifix - Total duration: 38s921ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s921ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:30:40 Duration: 38s921ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 7m6s 190ms 7s50ms 1s543ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 03 00 12 19s623ms 1s635ms 01 12 17s863ms 1s488ms 02 12 18s372ms 1s531ms 03 12 18s325ms 1s527ms 04 12 18s186ms 1s515ms 05 12 18s19ms 1s501ms 06 12 17s837ms 1s486ms 07 12 17s862ms 1s488ms 08 12 18s178ms 1s514ms 09 12 17s856ms 1s488ms 10 12 18s53ms 1s504ms 11 12 18s14ms 1s501ms 12 12 18s41ms 1s503ms 13 12 18s51ms 1s504ms 14 12 17s899ms 1s491ms 15 12 18s517ms 1s543ms 16 12 18s422ms 1s535ms 17 12 18s194ms 1s516ms 18 12 18s321ms 1s526ms 19 12 17s792ms 1s482ms 20 12 27s244ms 2s270ms 21 12 17s615ms 1s467ms 22 12 17s716ms 1s476ms [ User: intelifix - Total duration: 7m6s - Times executed: 276 ]
[ Application: psql - Total duration: 7m6s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-03 20:05:08 Duration: 7s50ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-03 20:15:06 Duration: 5s343ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-03 00:05:18 Duration: 3s653ms Database: rio User: intelifix Remote: [local] Application: psql
2 61 48s314ms 573ms 1s736ms 792ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 03 08 4 3s126ms 781ms 09 4 2s876ms 719ms 10 4 3s41ms 760ms 11 5 3s889ms 777ms 12 4 3s198ms 799ms 13 4 3s184ms 796ms 14 4 3s125ms 781ms 15 4 3s129ms 782ms 16 4 3s155ms 788ms 17 3 2s192ms 730ms 18 5 4s54ms 810ms 19 4 2s943ms 735ms 20 5 4s877ms 975ms 21 3 2s484ms 828ms 22 4 3s31ms 757ms [ User: intelifix - Total duration: 48s314ms - Times executed: 61 ]
[ Application: psql - Total duration: 48s314ms - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-03 20:20:02 Duration: 1s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-03 10:00:03 Duration: 965ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-03 20:40:02 Duration: 930ms Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h29m11s 2s224ms 6m30s 1m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 03 07 3 6m16s 2m5s 08 3 5m18s 1m46s 09 3 5m24s 1m48s 10 3 5m23s 1m47s 11 3 5m36s 1m52s 12 3 5m28s 1m49s 13 3 5m22s 1m47s 14 3 5m19s 1m46s 15 3 5m17s 1m45s 16 3 5m19s 1m46s 17 3 5m27s 1m49s 18 3 5m23s 1m47s 19 3 5m23s 1m47s 20 3 6m3s 2m1s 21 3 6m47s 2m15s 22 3 5m18s 1m46s [ User: intelifix - Total duration: 1h29m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 21:11:32 Duration: 6m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 07:10:48 Duration: 5m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 20:10:41 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h2m13s 227ms 3m33s 1m17s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 03 07 3 4m25s 1m28s 08 3 3m49s 1m16s 09 3 3m48s 1m16s 10 3 3m45s 1m15s 11 3 3m49s 1m16s 12 3 3m48s 1m16s 13 3 3m44s 1m14s 14 3 3m48s 1m16s 15 3 3m48s 1m16s 16 3 3m48s 1m16s 17 3 3m57s 1m19s 18 3 3m47s 1m15s 19 3 3m51s 1m17s 20 3 4m20s 1m26s 21 3 3m49s 1m16s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h2m13s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m13s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 07:15:37 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 20:15:18 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 17:14:24 Duration: 3m24s Database: brasilia User: intelifix Remote: [local] Application: psql
5 34 1m9s 246ms 13s495ms 2s42ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 03 00 6 20s400ms 3s400ms 01 6 9s427ms 1s571ms 02 6 10s534ms 1s755ms 03 5 9s990ms 1s998ms 04 6 10s913ms 1s818ms 05 5 8s172ms 1s634ms [ User: intelifix - Total duration: 1m9s - Times executed: 34 ]
[ Application: psql - Total duration: 1m9s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-03 00:05:14 Duration: 13s495ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-03 03:15:05 Duration: 3s473ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-03 05:25:04 Duration: 3s273ms Database: rio User: intelifix Remote: [local] Application: psql
6 29 25s886ms 702ms 3s59ms 892ms 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 #6
Day Hour Count Duration Avg duration Oct 03 08 2 3s761ms 1s880ms 09 2 1s714ms 857ms 10 2 1s768ms 884ms 11 1 834ms 834ms 12 2 1s665ms 832ms 13 2 1s608ms 804ms 14 2 1s679ms 839ms 15 2 1s619ms 809ms 16 2 1s650ms 825ms 17 3 2s341ms 780ms 18 1 947ms 947ms 19 2 1s658ms 829ms 20 1 764ms 764ms 21 3 2s382ms 794ms 22 2 1s488ms 744ms [ User: intelifix - Total duration: 25s886ms - Times executed: 29 ]
[ Application: psql - Total duration: 25s886ms - Times executed: 29 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-03 08:00:04 Duration: 3s59ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-03 18:20:02 Duration: 947ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-03 16:40:01 Duration: 936ms Database: rio User: intelifix Remote: [local] Application: psql
7 7 4s37ms 190ms 1s261ms 576ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 03 00 4 2s923ms 730ms 06 3 1s114ms 371ms [ User: lenon - Total duration: 4s37ms - Times executed: 7 ]
[ Application: psql - Total duration: 4s37ms - Times executed: 7 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-03 00:02:03 Duration: 1s261ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-03 00:02:04 Duration: 906ms Database: brasilia User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-03 06:02:02 Duration: 653ms Database: rio User: lenon Remote: [local] Application: psql
8 6 1m47s 3s165ms 40s383ms 17s977ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 03 20 3 53s628ms 17s876ms 23 3 54s234ms 18s78ms [ 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-10-03 23:14:29 Duration: 40s383ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-03 20:06:24 Duration: 39s977ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-03 23:33:36 Duration: 10s589ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m23s 2s303ms 31s834ms 13s882ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 03 20 3 41s462ms 13s820ms 23 3 41s834ms 13s944ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 23:15:04 Duration: 31s834ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 20:06:57 Duration: 31s401ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 20:10:17 Duration: 7s722ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m22s 3s48ms 31s872ms 13s767ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 03 20 3 41s45ms 13s681ms 23 3 41s561ms 13s853ms [ 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-10-03 23:17:17 Duration: 31s872ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-03 20:09:07 Duration: 31s509ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-03 23:34:07 Duration: 6s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m11s 2s482ms 23s817ms 11s920ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 03 20 3 35s476ms 11s825ms 23 3 36s44ms 12s14ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:10:49 Duration: 23s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 20:02:46 Duration: 23s291ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:32:53 Duration: 9s743ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m11s 2s201ms 24s356ms 11s864ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 03 20 3 35s350ms 11s783ms 23 3 35s834ms 11s944ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:11:30 Duration: 24s356ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 20:03:27 Duration: 23s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:33:05 Duration: 9s220ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m3s 1s670ms 25s372ms 10s659ms 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 Oct 03 20 3 31s716ms 10s572ms 23 3 32s241ms 10s747ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 23:12:29 Duration: 25s372ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 20:04:25 Duration: 25s140ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 23:33:21 Duration: 5s144ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 51s560ms 1s784ms 16s801ms 8s593ms 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 #14
Day Hour Count Duration Avg duration Oct 03 20 3 25s389ms 8s463ms 23 3 26s170ms 8s723ms [ User: intelifix - Total duration: 51s560ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s560ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 23:11:47 Duration: 16s801ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 20:03:43 Duration: 16s455ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 23:33:13 Duration: 7s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 51s42ms 5s141ms 12s167ms 8s507ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 03 00 3 30s1ms 10s 06 3 21s40ms 7s13ms [ User: intelifix - Total duration: 51s42ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s42ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 00:05:23 Duration: 12s167ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 00:05:11 Duration: 9s698ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 06:05:18 Duration: 9s31ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 6 41s112ms 1s31ms 16s990ms 6s852ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 03 20 3 20s416ms 6s805ms 23 3 20s696ms 6s898ms [ User: intelifix - Total duration: 41s112ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s112ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 23:11:06 Duration: 16s990ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 20:03:03 Duration: 16s811ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 23:32:56 Duration: 2s603ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 28s766ms 873ms 12s552ms 4s794ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 03 20 3 14s309ms 4s769ms 23 3 14s457ms 4s819ms [ User: intelifix - Total duration: 28s766ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s766ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-03 23:12:04 Duration: 12s552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-03 20:04:00 Duration: 12s469ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-03 23:33:15 Duration: 1s31ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 27s200ms 2s842ms 5s695ms 4s533ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 03 20 3 13s452ms 4s484ms 23 3 13s747ms 4s582ms [ User: intelifix - Total duration: 27s200ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s200ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-03 23:15:28 Duration: 5s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-03 20:07:21 Duration: 5s537ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-03 23:33:54 Duration: 5s209ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 27s142ms 965ms 10s525ms 4s523ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 03 20 3 13s408ms 4s469ms 23 3 13s734ms 4s578ms [ User: intelifix - Total duration: 27s142ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s142ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-03 23:10:21 Duration: 10s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-03 20:02:19 Duration: 10s238ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-03 23:32:43 Duration: 2s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 16s445ms 2s641ms 2s813ms 2s740ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 03 20 3 8s149ms 2s716ms 23 3 8s296ms 2s765ms [ User: intelifix - Total duration: 16s445ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 16s445ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-10-03 23:32:40 Duration: 2s813ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-10-03 20:10:46 Duration: 2s774ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-10-03 23:42:09 Duration: 2s750ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m31s 8m38s 5m46s 3 17m18s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 03 05 3 17m18s 5m46s [ User: intelifix - Total duration: 17m18s - Times executed: 3 ]
[ Application: psql - Total duration: 17m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-03 05:08:40 Duration: 8m38s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-03 05:14:48 Duration: 6m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-03 05:17:20 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s224ms 6m30s 1m51s 48 1h29m11s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 03 07 3 6m16s 2m5s 08 3 5m18s 1m46s 09 3 5m24s 1m48s 10 3 5m23s 1m47s 11 3 5m36s 1m52s 12 3 5m28s 1m49s 13 3 5m22s 1m47s 14 3 5m19s 1m46s 15 3 5m17s 1m45s 16 3 5m19s 1m46s 17 3 5m27s 1m49s 18 3 5m23s 1m47s 19 3 5m23s 1m47s 20 3 6m3s 2m1s 21 3 6m47s 2m15s 22 3 5m18s 1m46s [ User: intelifix - Total duration: 1h29m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h29m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 21:11:32 Duration: 6m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 07:10:48 Duration: 5m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-03 20:10:41 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: psql
3 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 03 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-10-03 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-03 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 227ms 3m33s 1m17s 48 1h2m13s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 03 07 3 4m25s 1m28s 08 3 3m49s 1m16s 09 3 3m48s 1m16s 10 3 3m45s 1m15s 11 3 3m49s 1m16s 12 3 3m48s 1m16s 13 3 3m44s 1m14s 14 3 3m48s 1m16s 15 3 3m48s 1m16s 16 3 3m48s 1m16s 17 3 3m57s 1m19s 18 3 3m47s 1m15s 19 3 3m51s 1m17s 20 3 4m20s 1m26s 21 3 3m49s 1m16s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h2m13s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m13s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 07:15:37 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 20:15:18 Duration: 3m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-03 17:14:24 Duration: 3m24s Database: brasilia User: intelifix Remote: [local] Application: psql
5 38s921ms 38s921ms 38s921ms 1 38s921ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 03 05 1 38s921ms 38s921ms [ User: intelifix - Total duration: 38s921ms - Times executed: 1 ]
[ Application: psql - Total duration: 38s921ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:30:40 Duration: 38s921ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
6 4s147ms 1m4s 33s785ms 4 2m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 03 20 2 1m6s 33s265ms 23 2 1m8s 34s305ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-03 23:16:45 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-03 20:08:36 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-03 23:34:00 Duration: 4s332ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 330ms 53s513ms 26s771ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 03 20 2 53s240ms 26s620ms 23 2 53s846ms 26s923ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-03 23:13:47 Duration: 53s513ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-03 20:05:42 Duration: 52s909ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-03 23:33:25 Duration: 333ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s165ms 40s383ms 17s977ms 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 Oct 03 20 3 53s628ms 17s876ms 23 3 54s234ms 18s78ms [ 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-10-03 23:14:29 Duration: 40s383ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-03 20:06:24 Duration: 39s977ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-03 23:33:36 Duration: 10s589ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 4s212ms 23s677ms 13s896ms 4 55s587ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 03 20 2 27s685ms 13s842ms 23 2 27s902ms 13s951ms [ User: intelifix - Total duration: 55s587ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s587ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-03 23:12:53 Duration: 23s677ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-03 20:04:49 Duration: 23s473ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-03 23:33:25 Duration: 4s224ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s303ms 31s834ms 13s882ms 6 1m23s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 03 20 3 41s462ms 13s820ms 23 3 41s834ms 13s944ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 23:15:04 Duration: 31s834ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 20:06:57 Duration: 31s401ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-03 20:10:17 Duration: 7s722ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s48ms 31s872ms 13s767ms 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 Oct 03 20 3 41s45ms 13s681ms 23 3 41s561ms 13s853ms [ 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-10-03 23:17:17 Duration: 31s872ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-03 20:09:07 Duration: 31s509ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-03 23:34:07 Duration: 6s597ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s482ms 23s817ms 11s920ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 03 20 3 35s476ms 11s825ms 23 3 36s44ms 12s14ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:10:49 Duration: 23s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 20:02:46 Duration: 23s291ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:32:53 Duration: 9s743ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s201ms 24s356ms 11s864ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 03 20 3 35s350ms 11s783ms 23 3 35s834ms 11s944ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:11:30 Duration: 24s356ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 20:03:27 Duration: 23s930ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-03 23:33:05 Duration: 9s220ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s670ms 25s372ms 10s659ms 6 1m3s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 03 20 3 31s716ms 10s572ms 23 3 32s241ms 10s747ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 23:12:29 Duration: 25s372ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 20:04:25 Duration: 25s140ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-03 23:33:21 Duration: 5s144ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s784ms 16s801ms 8s593ms 6 51s560ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 03 20 3 25s389ms 8s463ms 23 3 26s170ms 8s723ms [ User: intelifix - Total duration: 51s560ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s560ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 23:11:47 Duration: 16s801ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 20:03:43 Duration: 16s455ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-10-03 23:33:13 Duration: 7s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 5s141ms 12s167ms 8s507ms 6 51s42ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 03 00 3 30s1ms 10s 06 3 21s40ms 7s13ms [ User: intelifix - Total duration: 51s42ms - Times executed: 6 ]
[ Application: psql - Total duration: 51s42ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 00:05:23 Duration: 12s167ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 00:05:11 Duration: 9s698ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-03 06:05:18 Duration: 9s31ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 1s31ms 16s990ms 6s852ms 6 41s112ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 03 20 3 20s416ms 6s805ms 23 3 20s696ms 6s898ms [ User: intelifix - Total duration: 41s112ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s112ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 23:11:06 Duration: 16s990ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 20:03:03 Duration: 16s811ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-03 23:32:56 Duration: 2s603ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 873ms 12s552ms 4s794ms 6 28s766ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 03 20 3 14s309ms 4s769ms 23 3 14s457ms 4s819ms [ User: intelifix - Total duration: 28s766ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s766ms - Times executed: 6 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-03 23:12:04 Duration: 12s552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-03 20:04:00 Duration: 12s469ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-10-03 23:33:15 Duration: 1s31ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2s842ms 5s695ms 4s533ms 6 27s200ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 03 20 3 13s452ms 4s484ms 23 3 13s747ms 4s582ms [ User: intelifix - Total duration: 27s200ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s200ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-03 23:15:28 Duration: 5s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-03 20:07:21 Duration: 5s537ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-10-03 23:33:54 Duration: 5s209ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 965ms 10s525ms 4s523ms 6 27s142ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 03 20 3 13s408ms 4s469ms 23 3 13s734ms 4s578ms [ User: intelifix - Total duration: 27s142ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 27s142ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-03 23:10:21 Duration: 10s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-03 20:02:19 Duration: 10s238ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-10-03 23:32:43 Duration: 2s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 15 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 03 10 1 0ms 0ms 11 3 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 15 1 0ms 0ms 16 2 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 3 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 5m53s - Times executed: 15 ]
[ Application: psql - Total duration: 5m53s - Times executed: 15 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 8,677 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 3237 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,233 Max number of times the same event was reported
- 3,258 Total events found
Rank Times reported Error 1 3,233 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 03 00 120 01 118 02 120 03 110 04 118 05 120 06 118 07 164 08 176 09 179 10 176 11 179 12 174 13 141 14 118 15 120 16 164 17 122 18 120 19 118 20 120 21 118 22 120 23 100 - ERROR: prepared statement "_PLAN0000000029D73EE0" does not exist
- ERROR: prepared statement "_PLAN0000000029B66460" does not exist
- ERROR: prepared statement "_PLAN0000000029B66D80" does not exist
Statement: DEALLOCATE "_PLAN0000000029D73EE0"
Date: 2026-10-03 00:00:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B66460"
Date: 2026-10-03 00:00:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B66D80"
Date: 2026-10-03 00:01:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 03 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-03 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-03 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-03 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
3 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 03 00 1 01 1 04 1 10 1 15 3 16 1 18 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-03 00:42:42 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-03 01:22:32 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-03 04:58:04 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 03 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-03 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-03 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 03 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-03 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 03 03 1 - LOG: database system was shut down at 2026-10-03 03:05:01 -03
Date: 2026-10-03 03:05:01