pgBadger-
Global information
- Generated on Tue May 26 23:50:04 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 3,324 log entries in 3s
- Log start from 2026-05-26 00:02:01 to 2026-05-26 23:46:05
-
Overview
Global Stats
- 137 Number of unique normalized queries
- 761 Number of queries
- 3h58m6s Total query duration
- 2026-05-26 00:02:06 First query
- 2026-05-26 23:46:05 Last query
- 5 queries/s at 2026-05-26 23:45:42 Query peak
- 3h58m6s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h58m6s Execute total duration
- 16 Number of events
- 5 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 11 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 10 Number temporary file
- 224.91 MiB Max size of temporary file
- 104.63 MiB Average size of temporary file
- 151 Total number of sessions
- 7 sessions at 2026-05-26 06:05:05 Session peak
- 5d14h1m1s Total duration of sessions
- 53m15s Average duration of sessions
- 5 Average queries per session
- 1m34s Average queries duration per session
- 51m40s Average idle time per session
- 155 Total number of connections
- 4 connections/s at 2026-05-26 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-26 23:45:42 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-26 12:15:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-26 23:45:42 Date
Queries duration
Key values
- 3h58m6s 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) May 26 00 17 0ms 15s577ms 4s192ms 53s59ms 53s59ms 53s59ms 01 6 0ms 2s382ms 2s181ms 2s382ms 2s382ms 2s382ms 02 6 2s43ms 2s346ms 2s208ms 2s346ms 2s346ms 2s346ms 03 8 0ms 2s662ms 1s651ms 3s247ms 3s247ms 3s247ms 04 6 0ms 2s225ms 2s62ms 2s225ms 2s225ms 2s225ms 05 11 0ms 8m 1m30s 4m14s 8m 8m 06 12 0ms 9s402ms 3s467ms 23s926ms 23s926ms 23s926ms 07 12 0ms 8m25s 1m9s 3m47s 8m25s 8m25s 08 18 0ms 6m1s 35s377ms 3m28s 6m49s 6m49s 09 18 534ms 6m9s 36s517ms 6m56s 6m56s 6m56s 10 18 0ms 6m13s 36s376ms 3m35s 6m46s 6m46s 11 18 0ms 5m59s 35s841ms 3m39s 6m49s 6m49s 12 18 0ms 5m55s 34s909ms 3m28s 5m55s 5m55s 13 18 0ms 5m53s 35s164ms 3m27s 5m53s 5m53s 14 18 539ms 5m54s 34s659ms 3m26s 5m54s 5m54s 15 18 0ms 5m54s 34s866ms 3m30s 5m54s 5m54s 16 18 544ms 6m15s 36s43ms 3m29s 6m47s 6m47s 17 18 0ms 5m53s 35s52ms 3m31s 5m53s 5m53s 18 19 0ms 6m10s 33s743ms 3m25s 6m42s 6m42s 19 18 510ms 5m52s 34s532ms 3m26s 5m52s 5m52s 20 95 0ms 6m54s 12s751ms 3m37s 6m54s 6m54s 21 20 0ms 6m14s 32s234ms 3m25s 6m46s 6m46s 22 18 0ms 5m54s 35s228ms 3m37s 5m54s 5m54s 23 333 0ms 1m15s 6s465ms 1m15s 1m44s 1m44s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 26 00 3 0 2s350ms 0ms 7s52ms 7s52ms 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 2s197ms 0ms 6s591ms 6s591ms 07 6 0 2m17s 1m31s 3m47s 8m25s 08 6 0 1m42s 0ms 3m26s 6m49s 09 6 0 1m46s 3m43s 6m56s 6m56s 10 6 0 1m46s 16s209ms 3m33s 6m46s 11 6 0 1m44s 0ms 3m37s 6m49s 12 6 0 1m41s 48s48ms 3m26s 5m55s 13 6 0 1m40s 47s279ms 3m25s 5m53s 14 6 0 1m40s 46s673ms 3m24s 5m54s 15 6 0 1m41s 47s265ms 3m28s 5m54s 16 6 0 1m45s 15s966ms 3m27s 6m47s 17 6 0 1m41s 48s380ms 3m29s 5m53s 18 7 0 1m29s 16s18ms 3m23s 6m42s 19 6 0 1m40s 47s178ms 3m24s 5m52s 20 7 75 14s447ms 1m24s 3m37s 6m54s 21 7 0 1m29s 15s367ms 3m23s 6m46s 22 6 0 1m42s 46s876ms 3m35s 5m54s 23 7 326 6s465ms 1m4s 1m15s 1m44s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 26 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 May 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 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 0 0.00 0.00% Day Hour Count Average / Second May 26 00 11 0.00/s 01 4 0.00/s 02 5 0.00/s 03 11 0.00/s 04 5 0.00/s 05 7 0.00/s 06 11 0.00/s 07 7 0.00/s 08 6 0.00/s 09 5 0.00/s 10 6 0.00/s 11 5 0.00/s 12 5 0.00/s 13 6 0.00/s 14 7 0.00/s 15 4 0.00/s 16 6 0.00/s 17 5 0.00/s 18 5 0.00/s 19 6 0.00/s 20 9 0.00/s 21 5 0.00/s 22 5 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time May 26 00 5 54m36s 54m21s 01 10 1h54s 1h53s 02 4 1h 59m56s 03 11 19m7s 19m6s 04 5 1h1m12s 1h1m9s 05 6 51m40s 48m54s 06 6 57m30s 57m23s 07 11 56m16s 55m 08 6 58m50s 57m4s 09 6 56m51s 55m1s 10 6 51m33s 49m43s 11 5 1h1m48s 59m39s 12 5 1h1m46s 59m40s 13 5 1h1m11s 59m4s 14 6 51m40s 49m56s 15 6 1h1m 59m15s 16 5 50m 47m50s 17 5 1h1m47s 59m40s 18 5 56m 53m52s 19 5 1h1m50s 59m46s 20 9 40m59s 38m44s 21 6 1h1m26s 59m39s 22 5 1h2s 57m55s 23 8 42m23s 37m54s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-05-26 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 155 connections Total
Connections per user
Key values
- intelifix Main User
- 155 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-05-26 06:05:05 Date
Histogram of session times
Key values
- 124 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 151 sessions Total
Sessions per user
Key values
- intelifix Main User
- 151 sessions Total
Sessions per host
Key values
- [local] Main Host
- 151 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,238 buffers Checkpoint Peak
- 2026-05-26 00:09:57 Date
- 269.651 seconds Highest write time
- 0.037 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-26 20:05:24 Date
Checkpoints distance
Key values
- 117.26 Mo Distance Peak
- 2026-05-26 00:09:57 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 26 00 10,238 269.651s 0.002s 269.66s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 7,424 0.217s 0.039s 0.269s 04 0 0s 0s 0s 05 5,838 584.512s 0.017s 584.547s 06 1,051 105.102s 0.002s 105.119s 07 1,245 124.504s 0.001s 124.507s 08 20 2.015s 0.002s 2.021s 09 20 2.018s 0.005s 2.028s 10 112 11.235s 0.002s 11.239s 11 20 2.016s 0.002s 2.022s 12 20 2.016s 0.003s 2.021s 13 20 2.016s 0.005s 2.024s 14 20 2.016s 0.002s 2.024s 15 20 2.015s 0.003s 2.021s 16 114 11.437s 0.002s 11.441s 17 23 2.317s 0.002s 2.322s 18 537 53.783s 0.008s 53.804s 19 20 2.015s 0.002s 2.02s 20 151 15.166s 0.004s 15.177s 21 20 2.016s 0.003s 2.021s 22 114 11.438s 0.002s 11.443s 23 88 8.843s 0.006s 8.854s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 26 00 0 3 0 40 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 3 0 29 0.028s 0.003s 04 0 0 0 0 0s 0s 05 0 3 0 143 0.003s 0.006s 06 0 0 0 8 0.002s 0.001s 07 0 0 0 14 0.001s 0.001s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.004s 0.002s 10 0 0 0 5 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 3 0.003s 0.002s 14 0 1 0 3 0.002s 0.001s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 5 0.002s 0.001s 17 0 0 0 4 0.001s 0.001s 18 0 0 0 33 0.002s 0.004s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 28 0.001s 0.003s 21 0 0 0 3 0.002s 0.001s 22 0 0 0 5 0.001s 0.001s 23 0 0 0 66 0.003s 0.004s Day Hour Count Avg time (sec) May 26 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 May 26 00 60,035.00 kB 60,035.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 23,354.50 kB 29,351.00 kB 04 0.00 kB 0.00 kB 05 6,757.50 kB 11,427.17 kB 06 3,174.00 kB 12,356.00 kB 07 7,730.00 kB 11,894.00 kB 08 158.00 kB 10,720.00 kB 09 158.00 kB 9,664.00 kB 10 278.00 kB 8,725.00 kB 11 158.00 kB 7,869.00 kB 12 158.00 kB 7,097.00 kB 13 158.00 kB 6,404.00 kB 14 158.00 kB 5,779.00 kB 15 158.00 kB 5,217.00 kB 16 284.00 kB 4,724.00 kB 17 159.00 kB 4,267.00 kB 18 501.75 kB 3,459.50 kB 19 158.00 kB 2,673.00 kB 20 180.67 kB 2,205.33 kB 21 158.00 kB 1,814.00 kB 22 275.00 kB 1,660.00 kB 23 392.50 kB 1,474.50 kB -
Temporary Files
Size of temporary files
Key values
- 449.83 MiB Temp Files size Peak
- 2026-05-26 05:31:53 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-05-26 05:30:36 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.02 GiB 104.63 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 873.95 MiB 67.09 MiB 224.91 MiB 109.24 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:32:01 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:31:53 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 172.39 MiB 86.20 MiB 86.20 MiB 86.20 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-26 05:30:39 Duration: 37s785ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-26 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 224.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:31:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 224.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:31:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 86.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-26 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 86.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-05-26 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 74.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 74.25 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 74.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 67.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 67.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 67.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-05-26 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.31 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-26 00:06:16 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.31 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_05
Database rio - 2026-05-26 00:06:16 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- public.logs (3) Main table vacuumed on database rio
- 11 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.logs 3 0 0 0 0 0 0 694 280 366,301 180 4,497 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 113 2 9,396 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 778 145 938,119 82 388 rio.auditor.auditor_2026_05 1 0 0 0 0 0 0 1,399 1,400 1,792,771 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,552 2 173,802 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,477 483 2,482,956 430 3,108 brasilia.auditor.auditor_2026_05 1 0 0 0 0 0 0 907 515 744,246 127 4,444 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,031 309 1,568,867 288 2,137 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 137 31 95,631 2 2 Total 11 6 0 0 0 0 0 13,088 3,167 8,172,089 1,109 14,576 Vacuum throughput per table
Key values
- auditor.auditor_2026_05 (0.31) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.logs 0 0 0.24 contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.04 rio.auditor.auditor_2026_05 0 0 0.31 contagem.pg_catalog.pg_statistic 0 0 0.03 rio.pg_catalog.pg_statistic 0 0 0.16 brasilia.auditor.auditor_2026_05 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.13 brasilia.pg_toast.pg_toast_2619 0 0 0.01 Total 0 0 0.99 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4043) Main table with removed tuples on database contagem
- 12603 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_statistic 1 1 4,043 7,274 0 0 996 brasilia.pg_catalog.pg_statistic 1 1 3,887 7,360 0 0 1,077 rio.pg_catalog.pg_statistic 1 1 3,860 7,458 0 0 1,162 rio.pg_toast.pg_toast_2619 1 1 609 677 0 0 267 brasilia.pg_toast.pg_toast_2619 1 1 107 143 0 4 63 contagem.pg_toast.pg_toast_2619 1 1 97 120 0 0 54 rio.auditor.auditor_2026_05 1 0 0 18,581,371 0 0 814,933 brasilia.auditor.auditor_2026_05 1 0 0 3,782,543 0 0 161,564 rio.public.logs 3 0 0 47,228,319 0 0 1,886,630 Total 11 6 12,603 69,615,265 0 4 2,866,746 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (4) Main table with removed pages on database brasilia
- 4 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_toast.pg_toast_2619 1 1 107 4 contagem.pg_toast.pg_toast_2619 1 1 97 0 rio.pg_toast.pg_toast_2619 1 1 609 0 rio.auditor.auditor_2026_05 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4043 0 rio.pg_catalog.pg_statistic 1 1 3860 0 brasilia.auditor.auditor_2026_05 1 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3887 0 rio.public.logs 3 0 0 0 Total 11 6 12,603 4 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 26 00 2 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 1 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 1 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 1 0 23 0 0 - 0.31 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
- 112 Total read queries
- 401 Total write queries
Queries by database
Key values
- rio Main database
- 375 Requests
- 2h36m36s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 755 Requests
User Request type Count Duration intelifix Total 755 3h57m52s copy to 401 43m31s others 248 24m6s select 106 2h50m14s lenon Total 6 13s643ms select 6 13s643ms Duration by user
Key values
- 3h57m52s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 755 3h57m52s copy to 401 43m31s others 248 24m6s select 106 2h50m14s lenon Total 6 13s643ms select 6 13s643ms Queries by host
Key values
- [local] Main host
- 761 Requests
- 3h58m6s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 406 Requests
- 3h14m33s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-26 13:10:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 329 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 8m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 07:13:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m analyze verbose;[ Date: 2026-05-26 05:08:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 20:11:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 16:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 21:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 10:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 18:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 09:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 08:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 11:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 12:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 22:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 14:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 15:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 17:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 13:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-26 19:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m14s analyze verbose;[ Date: 2026-05-26 05:12:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 3m42s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-26 07:18:42 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m41s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-26 09:15:39 - 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 1h44m32s 48 773ms 8m25s 2m10s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 26 07 3 8m57s 2m59s 08 3 6m18s 2m6s 09 3 6m25s 2m8s 10 3 6m31s 2m10s 11 3 6m16s 2m5s 12 3 6m11s 2m3s 13 3 6m9s 2m3s 14 3 6m10s 2m3s 15 3 6m10s 2m3s 16 3 6m32s 2m10s 17 3 6m10s 2m3s 18 3 6m27s 2m9s 19 3 6m9s 2m3s 20 3 7m18s 2m26s 21 3 6m31s 2m10s 22 3 6m10s 2m3s [ User: intelifix - Total duration: 1h44m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 07:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 20:11:55 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 16:11:16 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m35s 44 494ms 3m42s 1m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 26 07 3 4m47s 1m35s 08 3 3m58s 1m19s 09 2 4m13s 2m6s 10 3 4m5s 1m21s 11 3 4m10s 1m23s 12 3 3m58s 1m19s 13 3 3m56s 1m18s 14 3 3m54s 1m18s 15 3 3m59s 1m19s 16 2 3m58s 1m59s 17 3 4m1s 1m20s 18 2 3m53s 1m56s 19 3 3m54s 1m18s 20 2 4m43s 2m21s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h5m35s - Times executed: 44 ]
[ Application: psql - Total duration: 1h5m35s - Times executed: 44 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 07:18:42 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 09:15:39 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 11:15:26 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
3 14m20s 3 2m5s 8m 4m46s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 26 05 3 14m20s 4m46s [ User: intelifix - Total duration: 14m20s - Times executed: 3 ]
[ Application: psql - Total duration: 14m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-05-26 05:08:01 Duration: 8m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-26 05:12:16 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-26 05:14:21 Duration: 2m5s Database: contagem User: intelifix Remote: [local] Application: psql
4 4m23s 115 562ms 13s182ms 2s290ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 26 00 7 25s393ms 3s627ms 01 6 13s90ms 2s181ms 02 6 13s252ms 2s208ms 03 6 12s631ms 2s105ms 04 6 12s375ms 2s62ms 05 6 12s440ms 2s73ms 06 6 13s232ms 2s205ms 07 5 10s520ms 2s104ms 08 5 11s429ms 2s285ms 09 5 10s827ms 2s165ms 10 4 9s51ms 2s262ms 11 4 9s10ms 2s252ms 12 4 8s543ms 2s135ms 13 4 8s689ms 2s172ms 14 5 10s808ms 2s161ms 15 5 10s197ms 2s39ms 16 5 10s615ms 2s123ms 17 4 8s547ms 2s136ms 18 4 8s150ms 2s37ms 19 4 8s461ms 2s115ms 20 5 16s173ms 3s234ms 21 4 9s597ms 2s399ms 22 5 10s390ms 2s78ms [ User: intelifix - Total duration: 4m23s - Times executed: 115 ]
[ Application: psql - Total duration: 4m23s - Times executed: 115 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-26 00:05:14 Duration: 13s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-26 20:15:10 Duration: 9s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-26 21:05:04 Duration: 3s230ms Database: rio User: intelifix Remote: [local] Application: psql
5 1m59s 4 2s551ms 57s428ms 29s826ms 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 May 26 20 2 59s980ms 29s990ms 23 2 59s324ms 29s662ms [ User: intelifix - Total duration: 1m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-26 20:07:43 Duration: 57s428ms 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-05-26 23:34:07 Duration: 56s716ms 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-05-26 23:44:11 Duration: 2s607ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m54s 3 16s601ms 1m15s 38s249ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 26 23 3 1m54s 38s249ms [ User: intelifix - Total duration: 1m54s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:12:11 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:35:20 Duration: 23s92ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:44:50 Duration: 16s601ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m38s 4 356ms 48s875ms 24s589ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 26 20 2 49s231ms 24s615ms 23 2 49s126ms 24s563ms [ User: intelifix - Total duration: 1m38s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-26 20:05:11 Duration: 48s875ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-26 23:17:28 Duration: 48s765ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-26 23:36:35 Duration: 361ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m35s 3 13s861ms 1m6s 31s807ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 26 23 3 1m35s 31s807ms [ User: intelifix - Total duration: 1m35s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:14:17 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:35:55 Duration: 15s325ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:45:19 Duration: 13s861ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m33s 3 15s222ms 59s518ms 31s246ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 26 23 3 1m33s 31s246ms [ User: intelifix - Total duration: 1m33s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:13:11 Duration: 59s518ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:35:39 Duration: 18s999ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:45:06 Duration: 15s222ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m28s 3 13s742ms 53s210ms 29s468ms copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 26 23 3 1m28s 29s468ms [ User: intelifix - Total duration: 1m28s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m28s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:10:56 Duration: 53s210ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:34:57 Duration: 21s451ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:44:34 Duration: 13s742ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m25s 6 2s142ms 32s338ms 14s247ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 26 20 3 43s221ms 14s407ms 23 3 42s262ms 14s87ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - 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-05-26 20:05:45 Duration: 32s338ms 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-05-26 23:18:01 Duration: 31s455ms 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-05-26 23:36:44 Duration: 8s663ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m21s 1 1m21s 1m21s 1m21s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 26 05 1 1m21s 1m21s [ User: intelifix - Total duration: 1m21s - Times executed: 1 ]
[ Application: psql - Total duration: 1m21s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:32:01 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:31:53 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m9s 6 1s617ms 26s738ms 11s525ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 26 20 3 34s445ms 11s481ms 23 3 34s707ms 11s569ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-26 23:18:30 Duration: 26s738ms 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-05-26 20:06:13 Duration: 26s401ms 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-05-26 20:09:08 Duration: 6s366ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m8s 6 2s834ms 26s264ms 11s442ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 26 20 3 34s507ms 11s502ms 23 3 34s150ms 11s383ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-05-26 20:08:09 Duration: 26s264ms 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-05-26 23:34:33 Duration: 26s187ms 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-05-26 20:09:25 Duration: 5s284ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 59s317ms 6 1s668ms 19s956ms 9s886ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 26 20 3 29s505ms 9s835ms 23 3 29s811ms 9s937ms [ User: intelifix - Total duration: 59s317ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s317ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-26 23:14:56 Duration: 19s956ms 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-05-26 20:02:40 Duration: 19s526ms 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-05-26 20:08:26 Duration: 8s221ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 59s311ms 6 5s239ms 15s577ms 9s885ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 26 00 3 37s519ms 12s506ms 06 3 21s792ms 7s264ms [ User: intelifix - Total duration: 59s311ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s311ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:17 Duration: 15s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:29 Duration: 12s104ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:39 Duration: 9s837ms Database: contagem User: intelifix Remote: [local] Application: psql
17 58s130ms 6 1s465ms 20s108ms 9s688ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 26 20 3 28s881ms 9s627ms 23 3 29s248ms 9s749ms [ User: intelifix - Total duration: 58s130ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s130ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-26 23:15:30 Duration: 20s108ms 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-05-26 20:03:14 Duration: 19s597ms 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-05-26 20:08:36 Duration: 7s755ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 53s368ms 58 572ms 4s710ms 920ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 26 08 4 3s227ms 806ms 09 4 3s396ms 849ms 10 3 2s244ms 748ms 11 4 3s194ms 798ms 12 4 3s196ms 799ms 13 4 7s430ms 1s857ms 14 3 2s803ms 934ms 15 4 3s455ms 863ms 16 4 3s329ms 832ms 17 4 3s457ms 864ms 18 4 3s317ms 829ms 19 4 3s212ms 803ms 20 4 4s616ms 1s154ms 21 4 3s387ms 846ms 22 4 3s99ms 774ms [ User: intelifix - Total duration: 53s368ms - Times executed: 58 ]
[ Application: psql - Total duration: 53s368ms - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-26 13:20:11 Duration: 4s710ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-26 20:20:03 Duration: 2s328ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-26 14:00:03 Duration: 1s90ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 51s679ms 6 1s222ms 20s843ms 8s613ms 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 #19
Day Hour Count Duration Avg duration May 26 20 3 25s625ms 8s541ms 23 3 26s53ms 8s684ms [ User: intelifix - Total duration: 51s679ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s679ms - 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-05-26 23:16:20 Duration: 20s843ms 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-05-26 20:04:03 Duration: 20s539ms 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-05-26 23:36:31 Duration: 3s987ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 50s833ms 24 1s960ms 2s297ms 2s118ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 26 07 1 2s132ms 2s132ms 08 1 2s140ms 2s140ms 09 1 2s 2s 10 2 4s289ms 2s144ms 11 2 4s371ms 2s185ms 12 2 4s339ms 2s169ms 13 1 2s8ms 2s8ms 14 1 2s132ms 2s132ms 15 1 2s81ms 2s81ms 16 1 2s113ms 2s113ms 17 2 4s340ms 2s170ms 18 2 4s274ms 2s137ms 19 2 4s122ms 2s61ms 20 2 4s259ms 2s129ms 21 2 4s25ms 2s12ms 22 1 2s199ms 2s199ms [ User: intelifix - Total duration: 50s833ms - Times executed: 24 ]
[ Application: psql - Total duration: 50s833ms - Times executed: 24 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 12:35:04 Duration: 2s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 17:35:03 Duration: 2s243ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 10:35:03 Duration: 2s228ms 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 115 4m23s 562ms 13s182ms 2s290ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 26 00 7 25s393ms 3s627ms 01 6 13s90ms 2s181ms 02 6 13s252ms 2s208ms 03 6 12s631ms 2s105ms 04 6 12s375ms 2s62ms 05 6 12s440ms 2s73ms 06 6 13s232ms 2s205ms 07 5 10s520ms 2s104ms 08 5 11s429ms 2s285ms 09 5 10s827ms 2s165ms 10 4 9s51ms 2s262ms 11 4 9s10ms 2s252ms 12 4 8s543ms 2s135ms 13 4 8s689ms 2s172ms 14 5 10s808ms 2s161ms 15 5 10s197ms 2s39ms 16 5 10s615ms 2s123ms 17 4 8s547ms 2s136ms 18 4 8s150ms 2s37ms 19 4 8s461ms 2s115ms 20 5 16s173ms 3s234ms 21 4 9s597ms 2s399ms 22 5 10s390ms 2s78ms [ User: intelifix - Total duration: 4m23s - Times executed: 115 ]
[ Application: psql - Total duration: 4m23s - Times executed: 115 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-26 00:05:14 Duration: 13s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-26 20:15:10 Duration: 9s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-26 21:05:04 Duration: 3s230ms Database: rio User: intelifix Remote: [local] Application: psql
2 58 53s368ms 572ms 4s710ms 920ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 26 08 4 3s227ms 806ms 09 4 3s396ms 849ms 10 3 2s244ms 748ms 11 4 3s194ms 798ms 12 4 3s196ms 799ms 13 4 7s430ms 1s857ms 14 3 2s803ms 934ms 15 4 3s455ms 863ms 16 4 3s329ms 832ms 17 4 3s457ms 864ms 18 4 3s317ms 829ms 19 4 3s212ms 803ms 20 4 4s616ms 1s154ms 21 4 3s387ms 846ms 22 4 3s99ms 774ms [ User: intelifix - Total duration: 53s368ms - Times executed: 58 ]
[ Application: psql - Total duration: 53s368ms - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-26 13:20:11 Duration: 4s710ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-26 20:20:03 Duration: 2s328ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-26 14:00:03 Duration: 1s90ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h44m32s 773ms 8m25s 2m10s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 26 07 3 8m57s 2m59s 08 3 6m18s 2m6s 09 3 6m25s 2m8s 10 3 6m31s 2m10s 11 3 6m16s 2m5s 12 3 6m11s 2m3s 13 3 6m9s 2m3s 14 3 6m10s 2m3s 15 3 6m10s 2m3s 16 3 6m32s 2m10s 17 3 6m10s 2m3s 18 3 6m27s 2m9s 19 3 6m9s 2m3s 20 3 7m18s 2m26s 21 3 6m31s 2m10s 22 3 6m10s 2m3s [ User: intelifix - Total duration: 1h44m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 07:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 20:11:55 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 16:11:16 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
4 44 1h5m35s 494ms 3m42s 1m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 26 07 3 4m47s 1m35s 08 3 3m58s 1m19s 09 2 4m13s 2m6s 10 3 4m5s 1m21s 11 3 4m10s 1m23s 12 3 3m58s 1m19s 13 3 3m56s 1m18s 14 3 3m54s 1m18s 15 3 3m59s 1m19s 16 2 3m58s 1m59s 17 3 4m1s 1m20s 18 2 3m53s 1m56s 19 3 3m54s 1m18s 20 2 4m43s 2m21s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h5m35s - Times executed: 44 ]
[ Application: psql - Total duration: 1h5m35s - Times executed: 44 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 07:18:42 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 09:15:39 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 11:15:26 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
5 32 35s269ms 604ms 5s797ms 1s102ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 26 08 2 3s568ms 1s784ms 09 2 1s592ms 796ms 10 3 2s534ms 844ms 11 2 1s783ms 891ms 12 2 1s841ms 920ms 13 2 6s779ms 3s389ms 14 3 2s580ms 860ms 15 2 1s695ms 847ms 16 2 1s666ms 833ms 17 2 2s801ms 1s400ms 18 2 1s687ms 843ms 19 2 1s643ms 821ms 20 2 1s639ms 819ms 21 2 1s729ms 864ms 22 2 1s726ms 863ms [ User: intelifix - Total duration: 35s269ms - Times executed: 32 ]
[ Application: psql - Total duration: 35s269ms - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 13:20:06 Duration: 5s797ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 08:00:04 Duration: 2s669ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 17:20:03 Duration: 1s911ms Database: rio User: intelifix Remote: [local] Application: psql
6 24 50s833ms 1s960ms 2s297ms 2s118ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 26 07 1 2s132ms 2s132ms 08 1 2s140ms 2s140ms 09 1 2s 2s 10 2 4s289ms 2s144ms 11 2 4s371ms 2s185ms 12 2 4s339ms 2s169ms 13 1 2s8ms 2s8ms 14 1 2s132ms 2s132ms 15 1 2s81ms 2s81ms 16 1 2s113ms 2s113ms 17 2 4s340ms 2s170ms 18 2 4s274ms 2s137ms 19 2 4s122ms 2s61ms 20 2 4s259ms 2s129ms 21 2 4s25ms 2s12ms 22 1 2s199ms 2s199ms [ User: intelifix - Total duration: 50s833ms - Times executed: 24 ]
[ Application: psql - Total duration: 50s833ms - Times executed: 24 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 12:35:04 Duration: 2s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 17:35:03 Duration: 2s243ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-05-26 10:35:03 Duration: 2s228ms Database: rio User: intelifix Remote: [local] Application: psql
7 6 1m25s 2s142ms 32s338ms 14s247ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 26 20 3 43s221ms 14s407ms 23 3 42s262ms 14s87ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - 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-05-26 20:05:45 Duration: 32s338ms 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-05-26 23:18:01 Duration: 31s455ms 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-05-26 23:36:44 Duration: 8s663ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 6 1m9s 1s617ms 26s738ms 11s525ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 26 20 3 34s445ms 11s481ms 23 3 34s707ms 11s569ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-26 23:18:30 Duration: 26s738ms 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-05-26 20:06:13 Duration: 26s401ms 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-05-26 20:09:08 Duration: 6s366ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 6 1m8s 2s834ms 26s264ms 11s442ms 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 #9
Day Hour Count Duration Avg duration May 26 20 3 34s507ms 11s502ms 23 3 34s150ms 11s383ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-05-26 20:08:09 Duration: 26s264ms 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-05-26 23:34:33 Duration: 26s187ms 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-05-26 20:09:25 Duration: 5s284ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 59s317ms 1s668ms 19s956ms 9s886ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 26 20 3 29s505ms 9s835ms 23 3 29s811ms 9s937ms [ User: intelifix - Total duration: 59s317ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s317ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-26 23:14:56 Duration: 19s956ms 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-05-26 20:02:40 Duration: 19s526ms 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-05-26 20:08:26 Duration: 8s221ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 59s311ms 5s239ms 15s577ms 9s885ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 26 00 3 37s519ms 12s506ms 06 3 21s792ms 7s264ms [ User: intelifix - Total duration: 59s311ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s311ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:17 Duration: 15s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:29 Duration: 12s104ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:39 Duration: 9s837ms Database: contagem User: intelifix Remote: [local] Application: psql
12 6 58s130ms 1s465ms 20s108ms 9s688ms 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 May 26 20 3 28s881ms 9s627ms 23 3 29s248ms 9s749ms [ User: intelifix - Total duration: 58s130ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s130ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-26 23:15:30 Duration: 20s108ms 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-05-26 20:03:14 Duration: 19s597ms 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-05-26 20:08:36 Duration: 7s755ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 51s679ms 1s222ms 20s843ms 8s613ms 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 May 26 20 3 25s625ms 8s541ms 23 3 26s53ms 8s684ms [ User: intelifix - Total duration: 51s679ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s679ms - 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-05-26 23:16:20 Duration: 20s843ms 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-05-26 20:04:03 Duration: 20s539ms 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-05-26 23:36:31 Duration: 3s987ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 41s973ms 1s186ms 13s722ms 6s995ms 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 May 26 20 3 20s983ms 6s994ms 23 3 20s990ms 6s996ms [ User: intelifix - Total duration: 41s973ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s973ms - 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-05-26 23:15:44 Duration: 13s722ms 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-05-26 20:03:28 Duration: 13s467ms 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-05-26 20:08:42 Duration: 6s293ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 33s988ms 687ms 14s481ms 5s664ms 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 #15
Day Hour Count Duration Avg duration May 26 20 3 16s862ms 5s620ms 23 3 17s125ms 5s708ms [ User: intelifix - Total duration: 33s988ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 33s988ms - 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-05-26 23:15:10 Duration: 14s481ms 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-05-26 20:02:55 Duration: 14s186ms 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-05-26 20:08:28 Duration: 1s963ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 24s670ms 591ms 11s233ms 4s111ms 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 #16
Day Hour Count Duration Avg duration May 26 20 3 12s498ms 4s166ms 23 3 12s172ms 4s57ms [ User: intelifix - Total duration: 24s670ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 24s670ms - 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-05-26 20:03:43 Duration: 11s233ms 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-05-26 23:15:59 Duration: 10s953ms 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-05-26 20:09:39 Duration: 635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 6 23s844ms 707ms 9s506ms 3s974ms 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 #17
Day Hour Count Duration Avg duration May 26 20 3 11s800ms 3s933ms 23 3 12s44ms 4s14ms [ User: intelifix - Total duration: 23s844ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 23s844ms - 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-05-26 23:14:32 Duration: 9s506ms 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-05-26 20:02:17 Duration: 9s199ms 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-05-26 20:08:18 Duration: 1s886ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 22s586ms 2s37ms 4s821ms 3s764ms 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 May 26 20 3 11s369ms 3s789ms 23 3 11s217ms 3s739ms [ User: intelifix - Total duration: 22s586ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 22s586ms - 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-05-26 20:06:34 Duration: 4s821ms 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-05-26 23:32:59 Duration: 4s720ms 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-05-26 23:44:07 Duration: 4s459ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 15s146ms 2s453ms 2s578ms 2s524ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 26 20 3 7s632ms 2s544ms 23 3 7s514ms 2s504ms [ User: intelifix - Total duration: 15s146ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s146ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-26 20:09:32 Duration: 2s578ms 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-05-26 20:02:07 Duration: 2s573ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-26 23:14:21 Duration: 2s540ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 6 13s643ms 839ms 5s275ms 2s273ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 26 00 3 7s52ms 2s350ms 06 3 6s591ms 2s197ms [ User: lenon - Total duration: 13s643ms - Times executed: 6 ]
[ Application: psql - Total duration: 13s643ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-26 00:02:06 Duration: 5s275ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-26 06:02:06 Duration: 4s770ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-26 06:02:08 Duration: 981ms Database: contagem User: lenon Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m5s 8m 4m46s 3 14m20s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 26 05 3 14m20s 4m46s [ User: intelifix - Total duration: 14m20s - Times executed: 3 ]
[ Application: psql - Total duration: 14m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-05-26 05:08:01 Duration: 8m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-26 05:12:16 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-26 05:14:21 Duration: 2m5s Database: contagem User: intelifix Remote: [local] Application: psql
2 773ms 8m25s 2m10s 48 1h44m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 26 07 3 8m57s 2m59s 08 3 6m18s 2m6s 09 3 6m25s 2m8s 10 3 6m31s 2m10s 11 3 6m16s 2m5s 12 3 6m11s 2m3s 13 3 6m9s 2m3s 14 3 6m10s 2m3s 15 3 6m10s 2m3s 16 3 6m32s 2m10s 17 3 6m10s 2m3s 18 3 6m27s 2m9s 19 3 6m9s 2m3s 20 3 7m18s 2m26s 21 3 6m31s 2m10s 22 3 6m10s 2m3s [ User: intelifix - Total duration: 1h44m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h44m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 07:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 20:11:55 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-26 16:11:16 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
3 494ms 3m42s 1m29s 44 1h5m35s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 26 07 3 4m47s 1m35s 08 3 3m58s 1m19s 09 2 4m13s 2m6s 10 3 4m5s 1m21s 11 3 4m10s 1m23s 12 3 3m58s 1m19s 13 3 3m56s 1m18s 14 3 3m54s 1m18s 15 3 3m59s 1m19s 16 2 3m58s 1m59s 17 3 4m1s 1m20s 18 2 3m53s 1m56s 19 3 3m54s 1m18s 20 2 4m43s 2m21s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h5m35s - Times executed: 44 ]
[ Application: psql - Total duration: 1h5m35s - Times executed: 44 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 07:18:42 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 09:15:39 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-26 11:15:26 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m21s 1m21s 1m21s 1 1m21s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 26 05 1 1m21s 1m21s [ User: intelifix - Total duration: 1m21s - Times executed: 1 ]
[ Application: psql - Total duration: 1m21s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:32:01 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:31:53 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 16s601ms 1m15s 38s249ms 3 1m54s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 26 23 3 1m54s 38s249ms [ User: intelifix - Total duration: 1m54s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:12:11 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:35:20 Duration: 23s92ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:44:50 Duration: 16s601ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 13s861ms 1m6s 31s807ms 3 1m35s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 26 23 3 1m35s 31s807ms [ User: intelifix - Total duration: 1m35s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:14:17 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:35:55 Duration: 15s325ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:45:19 Duration: 13s861ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 15s222ms 59s518ms 31s246ms 3 1m33s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 26 23 3 1m33s 31s246ms [ User: intelifix - Total duration: 1m33s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:13:11 Duration: 59s518ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:35:39 Duration: 18s999ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:45:06 Duration: 15s222ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 2s551ms 57s428ms 29s826ms 4 1m59s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 26 20 2 59s980ms 29s990ms 23 2 59s324ms 29s662ms [ User: intelifix - Total duration: 1m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-26 20:07:43 Duration: 57s428ms 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-05-26 23:34:07 Duration: 56s716ms 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-05-26 23:44:11 Duration: 2s607ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 13s742ms 53s210ms 29s468ms 3 1m28s copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 26 23 3 1m28s 29s468ms [ User: intelifix - Total duration: 1m28s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m28s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:10:56 Duration: 53s210ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:34:57 Duration: 21s451ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-26 23:44:34 Duration: 13s742ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 356ms 48s875ms 24s589ms 4 1m38s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 26 20 2 49s231ms 24s615ms 23 2 49s126ms 24s563ms [ User: intelifix - Total duration: 1m38s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-26 20:05:11 Duration: 48s875ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-26 23:17:28 Duration: 48s765ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-26 23:36:35 Duration: 361ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s142ms 32s338ms 14s247ms 6 1m25s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 26 20 3 43s221ms 14s407ms 23 3 42s262ms 14s87ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - 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-05-26 20:05:45 Duration: 32s338ms 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-05-26 23:18:01 Duration: 31s455ms 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-05-26 23:36:44 Duration: 8s663ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1s617ms 26s738ms 11s525ms 6 1m9s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 26 20 3 34s445ms 11s481ms 23 3 34s707ms 11s569ms [ User: intelifix - Total duration: 1m9s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m9s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-26 23:18:30 Duration: 26s738ms 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-05-26 20:06:13 Duration: 26s401ms 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-05-26 20:09:08 Duration: 6s366ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s834ms 26s264ms 11s442ms 6 1m8s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 26 20 3 34s507ms 11s502ms 23 3 34s150ms 11s383ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-05-26 20:08:09 Duration: 26s264ms 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-05-26 23:34:33 Duration: 26s187ms 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-05-26 20:09:25 Duration: 5s284ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s668ms 19s956ms 9s886ms 6 59s317ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 26 20 3 29s505ms 9s835ms 23 3 29s811ms 9s937ms [ User: intelifix - Total duration: 59s317ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s317ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-26 23:14:56 Duration: 19s956ms 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-05-26 20:02:40 Duration: 19s526ms 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-05-26 20:08:26 Duration: 8s221ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 5s239ms 15s577ms 9s885ms 6 59s311ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 26 00 3 37s519ms 12s506ms 06 3 21s792ms 7s264ms [ User: intelifix - Total duration: 59s311ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s311ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:17 Duration: 15s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:29 Duration: 12s104ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-26 00:05:39 Duration: 9s837ms Database: contagem User: intelifix Remote: [local] Application: psql
16 1s465ms 20s108ms 9s688ms 6 58s130ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 26 20 3 28s881ms 9s627ms 23 3 29s248ms 9s749ms [ User: intelifix - Total duration: 58s130ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s130ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-26 23:15:30 Duration: 20s108ms 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-05-26 20:03:14 Duration: 19s597ms 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-05-26 20:08:36 Duration: 7s755ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s222ms 20s843ms 8s613ms 6 51s679ms 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 #17
Day Hour Count Duration Avg duration May 26 20 3 25s625ms 8s541ms 23 3 26s53ms 8s684ms [ User: intelifix - Total duration: 51s679ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s679ms - 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-05-26 23:16:20 Duration: 20s843ms 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-05-26 20:04:03 Duration: 20s539ms 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-05-26 23:36:31 Duration: 3s987ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1s186ms 13s722ms 6s995ms 6 41s973ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 26 20 3 20s983ms 6s994ms 23 3 20s990ms 6s996ms [ User: intelifix - Total duration: 41s973ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s973ms - 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-05-26 23:15:44 Duration: 13s722ms 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-05-26 20:03:28 Duration: 13s467ms 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-05-26 20:08:42 Duration: 6s293ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 687ms 14s481ms 5s664ms 6 33s988ms 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 May 26 20 3 16s862ms 5s620ms 23 3 17s125ms 5s708ms [ User: intelifix - Total duration: 33s988ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 33s988ms - 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-05-26 23:15:10 Duration: 14s481ms 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-05-26 20:02:55 Duration: 14s186ms 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-05-26 20:08:28 Duration: 1s963ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 591ms 11s233ms 4s111ms 6 24s670ms 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 #20
Day Hour Count Duration Avg duration May 26 20 3 12s498ms 4s166ms 23 3 12s172ms 4s57ms [ User: intelifix - Total duration: 24s670ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 24s670ms - 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-05-26 20:03:43 Duration: 11s233ms 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-05-26 23:15:59 Duration: 10s953ms 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-05-26 20:09:39 Duration: 635ms Database: contagem 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 11 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 26 09 1 0ms 0ms 13 2 0ms 0ms 14 1 0ms 0ms 15 2 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 6m41s - Times executed: 11 ]
[ Application: psql - Total duration: 6m41s - Times executed: 11 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 1,518 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 11 FATAL entries
- 4 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 16 Total events found
Rank Times reported Error 1 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count May 26 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command at character 89 2026-05-26 03:05:01 -03 [972865]: [5-1] user=intelifix,db=rio,app=psql,client=[local] QUERY: SELECT A.USU_CHAVE AS CHAVE, A.USU_NOME AS TECNICO, C.DEP_NOME AS DEPARTAMENTO FROM USUARIOS A INNER JOIN TECNICOS B ON B.USU_ID = A.USU_ID AND B.TEC_STATUS = 0 INNER JOIN DEPARTAMENTOS C ON C.DEP_ID = B.DEP_ID WHERE A.USU_ATIVO = 'S' AND A.OFI_ID = nOficina ORDER BY 2
Date: 2026-05-26 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-26 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_giga_tecnicos() line 26 at FOR over SELECT rows
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-26 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
2 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 26 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-05-26 05:32:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-26 05:32:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-26 05:32:01 Database: contagem Application: psql User: intelifix Remote: [local]
3 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count May 26 00 1 06 1 13 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-05-26 00:02:08 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-26 06:02:08 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-26 13:19:25 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #4
Day Hour Count May 26 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-05-26 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-26 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #5
Day Hour Count May 26 03 1 - LOG: database system was shut down at 2026-05-26 03:05:02 -03
Date: 2026-05-26 03:05:02