pgBadger-
Global information
- Generated on Mon Jan 9 15:43:56 2023
- Log file: postgresql-2023-01-09_131507.log, ..., postgresql-2023-01-09_153516.log
- Parsed 2,943,010 log entries in 5m29s
- Log start from 2023-01-09 15:21:23 to 2023-01-09 15:40:42
-
Overview
Global Stats
- 13 Number of unique normalized queries
- 1,016,159 Number of queries
- 21m50s Total query duration
- 2023-01-09 15:21:25 First query
- 2023-01-09 15:35:20 Last query
- 14,456 queries/s at 2023-01-09 15:34:22 Query peak
- 21m50s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 21m50s Execute total duration
- 4 Number of events
- 4 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 10 Total number of automatic vacuums
- 12 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 27 Total number of sessions
- 1 sessions at 2023-01-09 15:36:25 Session peak
- 24m23s Total duration of sessions
- 54s205ms Average duration of sessions
- 37,635 Average queries per session
- 48s519ms Average queries duration per session
- 5s685ms Average idle time per session
- 29 Total number of connections
- 17 connections/s at 2023-01-09 15:34:20 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 14,456 queries/s Query Peak
- 2023-01-09 15:34:22 Date
SELECT Traffic
Key values
- 2,065 queries/s Query Peak
- 2023-01-09 15:34:22 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 12,391 queries/s Query Peak
- 2023-01-09 15:34:22 Date
Queries duration
Key values
- 21m50s 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) Jan 09 15 1,016,159 0ms 170ms 1ms 9m54s 9m54s 9m54s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 09 15 145,169 0 0ms 6s216ms 7s637ms 7s637ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 09 15 145,164 435,492 0 0 2ms 2m51s 4m44s 9m22s Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 09 15 0 0 0.00 0.00% Day Hour Count Average / Second Jan 09 15 29 0.01/s Day Hour Count Average Duration Average idle time Jan 09 15 27 54s205ms 5s685ms -
Connections
Established Connections
Key values
- 17 connections Connection Peak
- 2023-01-09 15:34:20 Date
Connections per database
Key values
- bench Main Database
- 29 connections Total
Connections per user
Key values
- xxx Main User
- 29 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2023-01-09 15:36:25 Date
Histogram of session times
Key values
- 19 30000-60000ms duration
Sessions per database
Key values
- bench Main Database
- 27 sessions Total
Sessions per user
Key values
- xxx Main User
- 27 sessions Total
Sessions per host
Key values
- [local] Main Host
- 27 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,591 buffers Checkpoint Peak
- 2023-01-09 15:40:42 Date
- 257.268 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2023-01-09 15:30:35 Date
Checkpoints distance
Key values
- 119.93 Mo Distance Peak
- 2023-01-09 15:40:42 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 09 15 5,108 506.945s 0.004s 507.306s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 09 15 0 8 0 45 0.002s 0.002s Day Hour Count Avg time (sec) Jan 09 15 0 0s Day Hour Mean distance Mean estimate Jan 09 15 58,831.50 kB 58,831.50 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 09 15 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.pgbench_accounts (3) Main table analyzed (database bench)
- 12 analyzes Total
Vacuums per table
Key values
- public.pgbench_branches (4) Main table vacuumed on database bench
- 10 vacuums Total
Tuples removed per table
Key values
- public.pgbench_branches (2429) Main table with removed tuples on database bench
- 4455 tuples Total removed
Pages removed per table
Key values
- public.pgbench_branches (37) Main table with removed pages on database bench
- 37 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 09 15 10 12 - 0 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
- 145,169 Total read queries
- 870,986 Total write queries
Queries by database
Key values
- bench Main database
- 1,016,158 Requests
- 21m50s (bench)
- Main time consuming database
Queries by user
Key values
- xxx Main user
- 1,016,159 Requests
User Request type Count Duration xxx Total 1,016,159 21m50s ddl 2 7ms insert 145,164 19s801ms others 4 108ms select 145,169 24s20ms tcl 290,328 52s579ms update 435,492 20m13s Duration by user
Key values
- 21m50s (xxx) Main time consuming user
User Request type Count Duration xxx Total 1,016,159 21m50s ddl 2 7ms insert 145,164 19s801ms others 4 108ms select 145,169 24s20ms tcl 290,328 52s579ms update 435,492 20m13s Queries by host
Key values
- [local] Main host
- 1,016,158 Requests
- 21m50s ([local])
- Main time consuming host
Queries by application
Key values
- pgbench Main application
- 1,016,158 Requests
- 21m50s (pgbench)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-01-09 15:24:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 816,788 0-1ms duration
Slowest individual queries
Rank Duration Query 1 170ms UPDATE pgbench_tellers SET tbalance = tbalance + 1177 WHERE tid = 7;[ Date: 2023-01-09 15:34:48 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
2 164ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1840 WHERE tid = 5;[ Date: 2023-01-09 15:35:02 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
3 147ms UPDATE pgbench_tellers SET tbalance = tbalance + - 4892 WHERE tid = 9;[ Date: 2023-01-09 15:34:50 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
4 141ms UPDATE pgbench_tellers SET tbalance = tbalance + 3499 WHERE tid = 6;[ Date: 2023-01-09 15:35:08 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
5 129ms UPDATE pgbench_tellers SET tbalance = tbalance + - 303 WHERE tid = 6;[ Date: 2023-01-09 15:35:19 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
6 127ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1336 WHERE tid = 10;[ Date: 2023-01-09 15:35:10 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
7 125ms UPDATE pgbench_tellers SET tbalance = tbalance + - 3095 WHERE tid = 1;[ Date: 2023-01-09 15:35:04 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
8 124ms UPDATE pgbench_tellers SET tbalance = tbalance + 4652 WHERE tid = 10;[ Date: 2023-01-09 15:35:10 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
9 123ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2898 WHERE tid = 10;[ Date: 2023-01-09 15:35:09 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
10 117ms UPDATE pgbench_tellers SET tbalance = tbalance + 1890 WHERE tid = 3;[ Date: 2023-01-09 15:34:33 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
11 117ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1544 WHERE tid = 4;[ Date: 2023-01-09 15:34:56 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
12 114ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2007 WHERE tid = 8;[ Date: 2023-01-09 15:35:03 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
13 113ms UPDATE pgbench_tellers SET tbalance = tbalance + - 671 WHERE tid = 10;[ Date: 2023-01-09 15:35:11 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
14 112ms UPDATE pgbench_tellers SET tbalance = tbalance + - 3979 WHERE tid = 2;[ Date: 2023-01-09 15:35:01 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
15 112ms UPDATE pgbench_tellers SET tbalance = tbalance + - 4584 WHERE tid = 8;[ Date: 2023-01-09 15:34:59 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
16 112ms UPDATE pgbench_tellers SET tbalance = tbalance + - 1668 WHERE tid = 6;[ Date: 2023-01-09 15:35:08 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
17 112ms UPDATE pgbench_tellers SET tbalance = tbalance + 3296 WHERE tid = 2;[ Date: 2023-01-09 15:35:13 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
18 110ms UPDATE pgbench_tellers SET tbalance = tbalance + 844 WHERE tid = 6;[ Date: 2023-01-09 15:35:12 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
19 109ms UPDATE pgbench_tellers SET tbalance = tbalance + - 4974 WHERE tid = 10;[ Date: 2023-01-09 15:35:09 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
20 109ms UPDATE pgbench_tellers SET tbalance = tbalance + - 2681 WHERE tid = 10;[ Date: 2023-01-09 15:34:49 - Database: bench - User: xxx - Remote: [local] - Application: pgbench ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10m40s 145,164 0ms 170ms 4ms update pgbench_tellers set tbalance = tbalance + ? where tid = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 09 15 145,164 10m40s 4ms [ User: xxx - Total duration: 10m40s - Times executed: 145164 ]
[ Application: pgbench - Total duration: 10m40s - Times executed: 145164 ]
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1177 WHERE tid = 7;
Date: 2023-01-09 15:34:48 Duration: 170ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 1840 WHERE tid = 5;
Date: 2023-01-09 15:35:02 Duration: 164ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 4892 WHERE tid = 9;
Date: 2023-01-09 15:34:50 Duration: 147ms Database: bench User: meo Remote: [local] Application: pgbench
2 9m 145,164 0ms 69ms 3ms update pgbench_branches set bbalance = bbalance + ? where bid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 09 15 145,164 9m 3ms [ User: xxx - Total duration: 9m - Times executed: 145164 ]
[ Application: pgbench - Total duration: 9m - Times executed: 145164 ]
-
UPDATE pgbench_branches SET bbalance = bbalance + 1630 WHERE bid = 1;
Date: 2023-01-09 15:24:17 Duration: 69ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_branches SET bbalance = bbalance + - 74 WHERE bid = 1;
Date: 2023-01-09 15:35:04 Duration: 60ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_branches SET bbalance = bbalance + 2472 WHERE bid = 1;
Date: 2023-01-09 15:24:17 Duration: 55ms Database: bench User: meo Remote: [local] Application: pgbench
3 48s543ms 145,164 0ms 30ms 0ms end;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 09 15 145,164 48s543ms 0ms [ User: xxx - Total duration: 48s543ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 48s543ms - Times executed: 145164 ]
-
END;
Date: 2023-01-09 15:35:01 Duration: 30ms Database: bench User: meo Remote: [local] Application: pgbench
-
END;
Date: 2023-01-09 15:24:07 Duration: 28ms Database: bench User: meo Remote: [local] Application: pgbench
-
END;
Date: 2023-01-09 15:24:22 Duration: 28ms Database: bench User: meo Remote: [local] Application: pgbench
4 32s875ms 145,164 0ms 38ms 0ms update pgbench_accounts set abalance = abalance + ? where aid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 09 15 145,164 32s875ms 0ms [ User: xxx - Total duration: 32s875ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 32s875ms - Times executed: 145164 ]
-
UPDATE pgbench_accounts SET abalance = abalance + - 1629 WHERE aid = 24810;
Date: 2023-01-09 15:24:17 Duration: 38ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_accounts SET abalance = abalance + - 1015 WHERE aid = 14116;
Date: 2023-01-09 15:34:52 Duration: 21ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_accounts SET abalance = abalance + - 4931 WHERE aid = 24763;
Date: 2023-01-09 15:35:10 Duration: 10ms Database: bench User: meo Remote: [local] Application: pgbench
5 23s964ms 145,164 0ms 27ms 0ms select abalance from pgbench_accounts where aid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 09 15 145,164 23s964ms 0ms [ User: xxx - Total duration: 23s964ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 23s964ms - Times executed: 145164 ]
-
SELECT abalance FROM pgbench_accounts WHERE aid = 86631;
Date: 2023-01-09 15:24:07 Duration: 27ms Database: bench User: meo Remote: [local] Application: pgbench
-
SELECT abalance FROM pgbench_accounts WHERE aid = 51978;
Date: 2023-01-09 15:34:50 Duration: 2ms Database: bench User: meo Remote: [local] Application: pgbench
-
SELECT abalance FROM pgbench_accounts WHERE aid = 23632;
Date: 2023-01-09 15:24:17 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
6 19s801ms 145,164 0ms 1ms 0ms insert into pgbench_history (tid, bid, aid, delta, mtime) values (?, ?, ?, ?, current_timestamp);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 09 15 145,164 19s801ms 0ms [ User: xxx - Total duration: 19s801ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 19s801ms - Times executed: 145164 ]
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (1, 1, 99426, - 288, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:24:08 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (2, 1, 36241, - 1655, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:23:57 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (10, 1, 50928, - 1710, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:24:17 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
7 4s36ms 145,164 0ms 1ms 0ms begin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 09 15 145,164 4s36ms 0ms [ User: xxx - Total duration: 4s36ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 4s36ms - Times executed: 145164 ]
-
BEGIN;
Date: 2023-01-09 15:34:59 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
BEGIN;
Date: 2023-01-09 15:24:07 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
BEGIN;
Date: 2023-01-09 15:24:13 Duration: 0ms Database: bench User: meo Remote: [local] Application: pgbench
8 102ms 2 48ms 53ms 51ms vacuum pgbench_branches;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 09 15 2 102ms 51ms [ User: xxx - Total duration: 102ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 102ms - Times executed: 2 ]
-
vacuum pgbench_branches;
Date: 2023-01-09 15:23:28 Duration: 53ms Database: bench User: meo Remote: [local] Application: pgbench
-
vacuum pgbench_branches;
Date: 2023-01-09 15:34:20 Duration: 48ms Database: bench User: meo Remote: [local] Application: pgbench
9 24ms 2 3ms 20ms 12ms select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = ? and o.n is not null group by ?, ? order by ? asc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 09 15 2 24ms 12ms [ User: xxx - Total duration: 24ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 24ms - Times executed: 2 ]
-
select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = 'pgbench_accounts' and o.n is not null group by 1, 2 order by 1 asc limit 1;
Date: 2023-01-09 15:23:28 Duration: 20ms Database: bench User: meo Remote: [local] Application: pgbench
-
select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = 'pgbench_accounts' and o.n is not null group by 1, 2 order by 1 asc limit 1;
Date: 2023-01-09 15:34:20 Duration: 3ms Database: bench User: meo Remote: [local] Application: pgbench
10 22ms 2 1ms 20ms 11ms select count(*) from pgbench_branches;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 09 15 2 22ms 11ms [ User: xxx - Total duration: 22ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 22ms - Times executed: 2 ]
-
select count(*) from pgbench_branches;
Date: 2023-01-09 15:23:28 Duration: 20ms Database: bench User: meo Remote: [local] Application: pgbench
-
select count(*) from pgbench_branches;
Date: 2023-01-09 15:34:20 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
11 9ms 1 9ms 9ms 9ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 09 15 1 9ms 9ms [ User: xxx - Total duration: 9ms - Times executed: 1 ]
[ Application: my_sub - Total duration: 9ms - Times executed: 1 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2023-01-09 15:21:25 Duration: 9ms Database: exercises User: meo Remote: ::1 Application: my_sub
12 7ms 2 2ms 4ms 3ms truncate pgbench_history;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 09 15 2 7ms 3ms [ User: xxx - Total duration: 7ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 7ms - Times executed: 2 ]
-
truncate pgbench_history;
Date: 2023-01-09 15:23:28 Duration: 4ms Database: bench User: meo Remote: [local] Application: pgbench
-
truncate pgbench_history;
Date: 2023-01-09 15:34:20 Duration: 2ms Database: bench User: meo Remote: [local] Application: pgbench
13 5ms 2 0ms 4ms 2ms vacuum pgbench_tellers;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 09 15 2 5ms 2ms [ User: xxx - Total duration: 5ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 5ms - Times executed: 2 ]
-
vacuum pgbench_tellers;
Date: 2023-01-09 15:23:28 Duration: 4ms Database: bench User: meo Remote: [local] Application: pgbench
-
vacuum pgbench_tellers;
Date: 2023-01-09 15:34:20 Duration: 0ms Database: bench User: meo Remote: [local] Application: pgbench
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 145,164 10m40s 0ms 170ms 4ms update pgbench_tellers set tbalance = tbalance + ? where tid = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 09 15 145,164 10m40s 4ms [ User: xxx - Total duration: 10m40s - Times executed: 145164 ]
[ Application: pgbench - Total duration: 10m40s - Times executed: 145164 ]
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1177 WHERE tid = 7;
Date: 2023-01-09 15:34:48 Duration: 170ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 1840 WHERE tid = 5;
Date: 2023-01-09 15:35:02 Duration: 164ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 4892 WHERE tid = 9;
Date: 2023-01-09 15:34:50 Duration: 147ms Database: bench User: meo Remote: [local] Application: pgbench
2 145,164 9m 0ms 69ms 3ms update pgbench_branches set bbalance = bbalance + ? where bid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 09 15 145,164 9m 3ms [ User: xxx - Total duration: 9m - Times executed: 145164 ]
[ Application: pgbench - Total duration: 9m - Times executed: 145164 ]
-
UPDATE pgbench_branches SET bbalance = bbalance + 1630 WHERE bid = 1;
Date: 2023-01-09 15:24:17 Duration: 69ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_branches SET bbalance = bbalance + - 74 WHERE bid = 1;
Date: 2023-01-09 15:35:04 Duration: 60ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_branches SET bbalance = bbalance + 2472 WHERE bid = 1;
Date: 2023-01-09 15:24:17 Duration: 55ms Database: bench User: meo Remote: [local] Application: pgbench
3 145,164 48s543ms 0ms 30ms 0ms end;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 09 15 145,164 48s543ms 0ms [ User: xxx - Total duration: 48s543ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 48s543ms - Times executed: 145164 ]
-
END;
Date: 2023-01-09 15:35:01 Duration: 30ms Database: bench User: meo Remote: [local] Application: pgbench
-
END;
Date: 2023-01-09 15:24:07 Duration: 28ms Database: bench User: meo Remote: [local] Application: pgbench
-
END;
Date: 2023-01-09 15:24:22 Duration: 28ms Database: bench User: meo Remote: [local] Application: pgbench
4 145,164 32s875ms 0ms 38ms 0ms update pgbench_accounts set abalance = abalance + ? where aid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 09 15 145,164 32s875ms 0ms [ User: xxx - Total duration: 32s875ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 32s875ms - Times executed: 145164 ]
-
UPDATE pgbench_accounts SET abalance = abalance + - 1629 WHERE aid = 24810;
Date: 2023-01-09 15:24:17 Duration: 38ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_accounts SET abalance = abalance + - 1015 WHERE aid = 14116;
Date: 2023-01-09 15:34:52 Duration: 21ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_accounts SET abalance = abalance + - 4931 WHERE aid = 24763;
Date: 2023-01-09 15:35:10 Duration: 10ms Database: bench User: meo Remote: [local] Application: pgbench
5 145,164 23s964ms 0ms 27ms 0ms select abalance from pgbench_accounts where aid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 09 15 145,164 23s964ms 0ms [ User: xxx - Total duration: 23s964ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 23s964ms - Times executed: 145164 ]
-
SELECT abalance FROM pgbench_accounts WHERE aid = 86631;
Date: 2023-01-09 15:24:07 Duration: 27ms Database: bench User: meo Remote: [local] Application: pgbench
-
SELECT abalance FROM pgbench_accounts WHERE aid = 51978;
Date: 2023-01-09 15:34:50 Duration: 2ms Database: bench User: meo Remote: [local] Application: pgbench
-
SELECT abalance FROM pgbench_accounts WHERE aid = 23632;
Date: 2023-01-09 15:24:17 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
6 145,164 19s801ms 0ms 1ms 0ms insert into pgbench_history (tid, bid, aid, delta, mtime) values (?, ?, ?, ?, current_timestamp);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 09 15 145,164 19s801ms 0ms [ User: xxx - Total duration: 19s801ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 19s801ms - Times executed: 145164 ]
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (1, 1, 99426, - 288, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:24:08 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (2, 1, 36241, - 1655, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:23:57 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (10, 1, 50928, - 1710, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:24:17 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
7 145,164 4s36ms 0ms 1ms 0ms begin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 09 15 145,164 4s36ms 0ms [ User: xxx - Total duration: 4s36ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 4s36ms - Times executed: 145164 ]
-
BEGIN;
Date: 2023-01-09 15:34:59 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
BEGIN;
Date: 2023-01-09 15:24:07 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
BEGIN;
Date: 2023-01-09 15:24:13 Duration: 0ms Database: bench User: meo Remote: [local] Application: pgbench
8 2 102ms 48ms 53ms 51ms vacuum pgbench_branches;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 09 15 2 102ms 51ms [ User: xxx - Total duration: 102ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 102ms - Times executed: 2 ]
-
vacuum pgbench_branches;
Date: 2023-01-09 15:23:28 Duration: 53ms Database: bench User: meo Remote: [local] Application: pgbench
-
vacuum pgbench_branches;
Date: 2023-01-09 15:34:20 Duration: 48ms Database: bench User: meo Remote: [local] Application: pgbench
9 2 24ms 3ms 20ms 12ms select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = ? and o.n is not null group by ?, ? order by ? asc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 09 15 2 24ms 12ms [ User: xxx - Total duration: 24ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 24ms - Times executed: 2 ]
-
select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = 'pgbench_accounts' and o.n is not null group by 1, 2 order by 1 asc limit 1;
Date: 2023-01-09 15:23:28 Duration: 20ms Database: bench User: meo Remote: [local] Application: pgbench
-
select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = 'pgbench_accounts' and o.n is not null group by 1, 2 order by 1 asc limit 1;
Date: 2023-01-09 15:34:20 Duration: 3ms Database: bench User: meo Remote: [local] Application: pgbench
10 2 22ms 1ms 20ms 11ms select count(*) from pgbench_branches;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 09 15 2 22ms 11ms [ User: xxx - Total duration: 22ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 22ms - Times executed: 2 ]
-
select count(*) from pgbench_branches;
Date: 2023-01-09 15:23:28 Duration: 20ms Database: bench User: meo Remote: [local] Application: pgbench
-
select count(*) from pgbench_branches;
Date: 2023-01-09 15:34:20 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
11 2 7ms 2ms 4ms 3ms truncate pgbench_history;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 09 15 2 7ms 3ms [ User: xxx - Total duration: 7ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 7ms - Times executed: 2 ]
-
truncate pgbench_history;
Date: 2023-01-09 15:23:28 Duration: 4ms Database: bench User: meo Remote: [local] Application: pgbench
-
truncate pgbench_history;
Date: 2023-01-09 15:34:20 Duration: 2ms Database: bench User: meo Remote: [local] Application: pgbench
12 2 5ms 0ms 4ms 2ms vacuum pgbench_tellers;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 09 15 2 5ms 2ms [ User: xxx - Total duration: 5ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 5ms - Times executed: 2 ]
-
vacuum pgbench_tellers;
Date: 2023-01-09 15:23:28 Duration: 4ms Database: bench User: meo Remote: [local] Application: pgbench
-
vacuum pgbench_tellers;
Date: 2023-01-09 15:34:20 Duration: 0ms Database: bench User: meo Remote: [local] Application: pgbench
13 1 9ms 9ms 9ms 9ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 09 15 1 9ms 9ms [ User: xxx - Total duration: 9ms - Times executed: 1 ]
[ Application: my_sub - Total duration: 9ms - Times executed: 1 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2023-01-09 15:21:25 Duration: 9ms Database: exercises User: meo Remote: ::1 Application: my_sub
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 48ms 53ms 51ms 2 102ms vacuum pgbench_branches;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 09 15 2 102ms 51ms [ User: xxx - Total duration: 102ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 102ms - Times executed: 2 ]
-
vacuum pgbench_branches;
Date: 2023-01-09 15:23:28 Duration: 53ms Database: bench User: meo Remote: [local] Application: pgbench
-
vacuum pgbench_branches;
Date: 2023-01-09 15:34:20 Duration: 48ms Database: bench User: meo Remote: [local] Application: pgbench
2 3ms 20ms 12ms 2 24ms select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = ? and o.n is not null group by ?, ? order by ? asc limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 09 15 2 24ms 12ms [ User: xxx - Total duration: 24ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 24ms - Times executed: 2 ]
-
select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = 'pgbench_accounts' and o.n is not null group by 1, 2 order by 1 asc limit 1;
Date: 2023-01-09 15:23:28 Duration: 20ms Database: bench User: meo Remote: [local] Application: pgbench
-
select o.n, p.partstrat, pg_catalog.count(i.inhparent) from pg_catalog.pg_class as c join pg_catalog.pg_namespace as n on (n.oid = c.relnamespace) cross join lateral ( select pg_catalog.array_position(pg_catalog.current_schemas(true), n.nspname)) as o (n) left join pg_catalog.pg_partitioned_table as p on (p.partrelid = c.oid) left join pg_catalog.pg_inherits as i on (c.oid = i.inhparent) where c.relname = 'pgbench_accounts' and o.n is not null group by 1, 2 order by 1 asc limit 1;
Date: 2023-01-09 15:34:20 Duration: 3ms Database: bench User: meo Remote: [local] Application: pgbench
3 1ms 20ms 11ms 2 22ms select count(*) from pgbench_branches;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 09 15 2 22ms 11ms [ User: xxx - Total duration: 22ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 22ms - Times executed: 2 ]
-
select count(*) from pgbench_branches;
Date: 2023-01-09 15:23:28 Duration: 20ms Database: bench User: meo Remote: [local] Application: pgbench
-
select count(*) from pgbench_branches;
Date: 2023-01-09 15:34:20 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
4 9ms 9ms 9ms 1 9ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 09 15 1 9ms 9ms [ User: xxx - Total duration: 9ms - Times executed: 1 ]
[ Application: my_sub - Total duration: 9ms - Times executed: 1 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2023-01-09 15:21:25 Duration: 9ms Database: exercises User: meo Remote: ::1 Application: my_sub
5 0ms 170ms 4ms 145,164 10m40s update pgbench_tellers set tbalance = tbalance + ? where tid = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 09 15 145,164 10m40s 4ms [ User: xxx - Total duration: 10m40s - Times executed: 145164 ]
[ Application: pgbench - Total duration: 10m40s - Times executed: 145164 ]
-
UPDATE pgbench_tellers SET tbalance = tbalance + 1177 WHERE tid = 7;
Date: 2023-01-09 15:34:48 Duration: 170ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 1840 WHERE tid = 5;
Date: 2023-01-09 15:35:02 Duration: 164ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_tellers SET tbalance = tbalance + - 4892 WHERE tid = 9;
Date: 2023-01-09 15:34:50 Duration: 147ms Database: bench User: meo Remote: [local] Application: pgbench
6 0ms 69ms 3ms 145,164 9m update pgbench_branches set bbalance = bbalance + ? where bid = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 09 15 145,164 9m 3ms [ User: xxx - Total duration: 9m - Times executed: 145164 ]
[ Application: pgbench - Total duration: 9m - Times executed: 145164 ]
-
UPDATE pgbench_branches SET bbalance = bbalance + 1630 WHERE bid = 1;
Date: 2023-01-09 15:24:17 Duration: 69ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_branches SET bbalance = bbalance + - 74 WHERE bid = 1;
Date: 2023-01-09 15:35:04 Duration: 60ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_branches SET bbalance = bbalance + 2472 WHERE bid = 1;
Date: 2023-01-09 15:24:17 Duration: 55ms Database: bench User: meo Remote: [local] Application: pgbench
7 2ms 4ms 3ms 2 7ms truncate pgbench_history;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 09 15 2 7ms 3ms [ User: xxx - Total duration: 7ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 7ms - Times executed: 2 ]
-
truncate pgbench_history;
Date: 2023-01-09 15:23:28 Duration: 4ms Database: bench User: meo Remote: [local] Application: pgbench
-
truncate pgbench_history;
Date: 2023-01-09 15:34:20 Duration: 2ms Database: bench User: meo Remote: [local] Application: pgbench
8 0ms 4ms 2ms 2 5ms vacuum pgbench_tellers;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 09 15 2 5ms 2ms [ User: xxx - Total duration: 5ms - Times executed: 2 ]
[ Application: pgbench - Total duration: 5ms - Times executed: 2 ]
-
vacuum pgbench_tellers;
Date: 2023-01-09 15:23:28 Duration: 4ms Database: bench User: meo Remote: [local] Application: pgbench
-
vacuum pgbench_tellers;
Date: 2023-01-09 15:34:20 Duration: 0ms Database: bench User: meo Remote: [local] Application: pgbench
9 0ms 30ms 0ms 145,164 48s543ms end;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 09 15 145,164 48s543ms 0ms [ User: xxx - Total duration: 48s543ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 48s543ms - Times executed: 145164 ]
-
END;
Date: 2023-01-09 15:35:01 Duration: 30ms Database: bench User: meo Remote: [local] Application: pgbench
-
END;
Date: 2023-01-09 15:24:07 Duration: 28ms Database: bench User: meo Remote: [local] Application: pgbench
-
END;
Date: 2023-01-09 15:24:22 Duration: 28ms Database: bench User: meo Remote: [local] Application: pgbench
10 0ms 38ms 0ms 145,164 32s875ms update pgbench_accounts set abalance = abalance + ? where aid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 09 15 145,164 32s875ms 0ms [ User: xxx - Total duration: 32s875ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 32s875ms - Times executed: 145164 ]
-
UPDATE pgbench_accounts SET abalance = abalance + - 1629 WHERE aid = 24810;
Date: 2023-01-09 15:24:17 Duration: 38ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_accounts SET abalance = abalance + - 1015 WHERE aid = 14116;
Date: 2023-01-09 15:34:52 Duration: 21ms Database: bench User: meo Remote: [local] Application: pgbench
-
UPDATE pgbench_accounts SET abalance = abalance + - 4931 WHERE aid = 24763;
Date: 2023-01-09 15:35:10 Duration: 10ms Database: bench User: meo Remote: [local] Application: pgbench
11 0ms 27ms 0ms 145,164 23s964ms select abalance from pgbench_accounts where aid = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 09 15 145,164 23s964ms 0ms [ User: xxx - Total duration: 23s964ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 23s964ms - Times executed: 145164 ]
-
SELECT abalance FROM pgbench_accounts WHERE aid = 86631;
Date: 2023-01-09 15:24:07 Duration: 27ms Database: bench User: meo Remote: [local] Application: pgbench
-
SELECT abalance FROM pgbench_accounts WHERE aid = 51978;
Date: 2023-01-09 15:34:50 Duration: 2ms Database: bench User: meo Remote: [local] Application: pgbench
-
SELECT abalance FROM pgbench_accounts WHERE aid = 23632;
Date: 2023-01-09 15:24:17 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
12 0ms 1ms 0ms 145,164 19s801ms insert into pgbench_history (tid, bid, aid, delta, mtime) values (?, ?, ?, ?, current_timestamp);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 09 15 145,164 19s801ms 0ms [ User: xxx - Total duration: 19s801ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 19s801ms - Times executed: 145164 ]
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (1, 1, 99426, - 288, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:24:08 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (2, 1, 36241, - 1655, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:23:57 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (10, 1, 50928, - 1710, CURRENT_TIMESTAMP);
Date: 2023-01-09 15:24:17 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
13 0ms 1ms 0ms 145,164 4s36ms begin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 09 15 145,164 4s36ms 0ms [ User: xxx - Total duration: 4s36ms - Times executed: 145164 ]
[ Application: pgbench - Total duration: 4s36ms - Times executed: 145164 ]
-
BEGIN;
Date: 2023-01-09 15:34:59 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
BEGIN;
Date: 2023-01-09 15:24:07 Duration: 1ms Database: bench User: meo Remote: [local] Application: pgbench
-
BEGIN;
Date: 2023-01-09 15:24:13 Duration: 0ms Database: bench User: meo Remote: [local] Application: pgbench
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 NO DATASET
-
Events
Log levels
Key values
- 1,016,293 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 2 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 4 Total events found
Rank Times reported Error 1 1 FATAL: terminating logical replication worker due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 09 15 1 - FATAL: terminating logical replication worker due to administrator command
Date: 2023-01-09 15:21:23
2 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 09 15 1 - ERROR: relation "dualipa" does not exist at character 15
Statement: select * from dualipa;
Date: 2023-01-09 15:36:38 Database: meo Application: psql User: meo Remote: [local]
3 1 FATAL: role "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 09 15 1 - FATAL: role "bad_user" does not exist
Date: 2023-01-09 15:36:13 Database: bad_user Application: [unknown] User: bad_user Remote: [local]
4 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 09 15 1 - LOG: database system was shut down at 2023-01-09 15:21:23 CET
Date: 2023-01-09 15:21:25