[repository1]
dbserver01:5432
begin:
2020-12-02 00:00
end:
2020-12-03 00:00
[repository1]
dbserver01:5432
begin:
2020-12-02 00:00
end:
2020-12-03 00:00
timestamp |
username |
database |
pid |
client_addr |
session_id |
session_line_num |
ps_display |
session_start |
vxid |
xid |
elevel |
sqlstate |
message |
detail |
hint |
query |
query_pos |
context |
user_query |
user_query_pos |
location |
application_name |
backend_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020-12-02 15:19:00.268+09 | 3037877 | 5fc731d4.2e5ab5 | 1 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | ending log output to stderr | Future log output will go to log destination "csvlog". | postmaster | |||||||||||||
| 2020-12-02 15:19:00.268+09 | 3037877 | 5fc731d4.2e5ab5 | 2 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | starting PostgreSQL 13.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit | postmaster | ||||||||||||||
| 2020-12-02 15:19:00.269+09 | 3037877 | 5fc731d4.2e5ab5 | 3 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | listening on IPv4 address "0.0.0.0", port 10786 | postmaster | ||||||||||||||
| 2020-12-02 15:19:00.269+09 | 3037877 | 5fc731d4.2e5ab5 | 4 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | listening on IPv6 address "::", port 10786 | postmaster | ||||||||||||||
| 2020-12-02 15:19:00.276+09 | 3037877 | 5fc731d4.2e5ab5 | 5 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | listening on Unix socket "/tmp/.s.PGSQL.10786" | postmaster | ||||||||||||||
| 2020-12-02 15:19:00.283+09 | 3037880 | 5fc731d4.2e5ab8 | 1 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | database system was shut down at 2020-12-02 15:18:41 JST | startup | ||||||||||||||
| 2020-12-02 15:19:00.287+09 | 3037877 | 5fc731d4.2e5ab5 | 6 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | database system is ready to accept connections | postmaster | ||||||||||||||
| 2020-12-02 15:19:00.287+09 | 3037886 | 5fc731d4.2e5abe | 1 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | pg_statsinfo launcher started | pg_statsinfo launcher | ||||||||||||||
| 2020-12-02 15:19:22.175+09 | 3037881 | 5fc731d4.2e5ab9 | 1 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint starting: immediate force wait flush-all | checkpointer | ||||||||||||||
| 2020-12-02 15:19:22.212+09 | 3037881 | 5fc731d4.2e5ab9 | 2 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint complete: wrote 266 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.008 s, total=0.037 s; sync files=93, longest=0.003 s, average=0.000 s; distance=1659 kB, estimate=1659 kB | checkpointer | ||||||||||||||
| 2020-12-02 15:19:22.256+09 | 3037881 | 5fc731d4.2e5ab9 | 3 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint starting: immediate force wait | checkpointer | ||||||||||||||
| 2020-12-02 15:19:22.267+09 | 3037881 | 5fc731d4.2e5ab9 | 4 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.000 s, total=0.011 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=1493 kB | checkpointer | ||||||||||||||
| 2020-12-02 15:20:00.79+09 | 3037957 | 5fc73210.2e5b05 | 4 | 2020-12-02 15:20:00+09 | 9/9 | 28051 | LOG | 00000 | automatic analyze of table "postgres.pg_catalog.pg_constraint" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:00.715+09 | 3037957 | 5fc73210.2e5b05 | 1 | 2020-12-02 15:20:00+09 | 9/3 | 27975 | LOG | 00000 | automatic analyze of table "postgres.pg_catalog.pg_type" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:00.752+09 | 3037957 | 5fc73210.2e5b05 | 2 | 2020-12-02 15:20:00+09 | 9/5 | 28008 | LOG | 00000 | automatic analyze of table "postgres.pg_catalog.pg_attribute" system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:00.772+09 | 3037957 | 5fc73210.2e5b05 | 3 | 2020-12-02 15:20:00+09 | 9/7 | 28030 | LOG | 00000 | automatic analyze of table "postgres.pg_catalog.pg_class" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:00.803+09 | 3037957 | 5fc73210.2e5b05 | 5 | 2020-12-02 15:20:00+09 | 9/11 | 28066 | LOG | 00000 | automatic analyze of table "postgres.pg_catalog.pg_trigger" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:00.832+09 | 3037957 | 5fc73210.2e5b05 | 6 | 2020-12-02 15:20:00+09 | 9/13 | 28094 | LOG | 00000 | automatic analyze of table "postgres.pg_catalog.pg_depend" system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.01 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:30.739+09 | 3037986 | 5fc7322e.2e5b22 | 1 | 2020-12-02 15:20:30+09 | 9/17 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 1 pages: 0 removed, 6 remain, 1 skipped due to pins, 0 skipped frozen tuples: 25 removed, 18 remain, 0 are dead but not yet removable, oldest xmin: 69197 buffer usage: 65 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 28.204 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 13 records, 0 full page images, 1069 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:30.742+09 | 3037986 | 5fc7322e.2e5b22 | 2 | 2020-12-02 15:20:30+09 | 9/18 | 69205 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:30.777+09 | 3037986 | 5fc7322e.2e5b22 | 3 | 2020-12-02 15:20:30+09 | 9/20 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 439 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 68718 remain, 0 are dead but not yet removable, oldest xmin: 69218 buffer usage: 890 hits, 1 misses, 1 dirtied avg read rate: 0.336 MB/s, avg write rate: 0.336 MB/s system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s WAL usage: 437 records, 1 full page images, 34109 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:30.853+09 | 3037986 | 5fc7322e.2e5b22 | 4 | 2020-12-02 15:20:30+09 | 9/21 | 69330 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.07 s, system: 0.00 s, elapsed: 0.07 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:30.867+09 | 3037986 | 5fc7322e.2e5b22 | 5 | 2020-12-02 15:20:30+09 | 9/23 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 1 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 345 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 69344 buffer usage: 83 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 23.965 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 13 records, 0 full page images, 2703 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:20:30.867+09 | 3037986 | 5fc7322e.2e5b22 | 6 | 2020-12-02 15:20:30+09 | 9/24 | 69349 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:00.749+09 | 3038018 | 5fc7324c.2e5b42 | 1 | 2020-12-02 15:21:00+09 | 9/28 | 94824 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.column_20201202" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.095+09 | 3038048 | 5fc7326a.2e5b60 | 1 | 2020-12-02 15:21:30+09 | 9/32 | 108096 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_accounts" system usage: CPU: user: 0.13 s, system: 0.01 s, elapsed: 0.32 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.112+09 | 3038048 | 5fc7326a.2e5b60 | 2 | 2020-12-02 15:21:30+09 | 9/34 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 408 removed, 10 remain, 0 are dead but not yet removable, oldest xmin: 108099 buffer usage: 38 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 6 records, 0 full page images, 1360 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.113+09 | 3038048 | 5fc7326a.2e5b60 | 3 | 2020-12-02 15:21:30+09 | 9/35 | 108103 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.141+09 | 3038048 | 5fc7326a.2e5b60 | 4 | 2020-12-02 15:21:30+09 | 9/37 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 688 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 107391 remain, 0 are dead but not yet removable, oldest xmin: 108108 buffer usage: 519 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s WAL usage: 250 records, 0 full page images, 14879 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.224+09 | 3038048 | 5fc7326a.2e5b60 | 5 | 2020-12-02 15:21:30+09 | 9/38 | 108150 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.07 s, system: 0.00 s, elapsed: 0.08 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.241+09 | 3038048 | 5fc7326a.2e5b60 | 6 | 2020-12-02 15:21:30+09 | 9/40 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 555 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 108154 buffer usage: 76 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 8 records, 0 full page images, 2119 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:21:31.241+09 | 3038048 | 5fc7326a.2e5b60 | 7 | 2020-12-02 15:21:30+09 | 9/41 | 108158 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:22:30.797+09 | 3038196 | 5fc732a6.2e5bf4 | 1 | 2020-12-02 15:22:30+09 | 9/47 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 219 removed, 10 remain, 0 are dead but not yet removable, oldest xmin: 134093 buffer usage: 59 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 5 records, 0 full page images, 923 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:22:30.798+09 | 3038196 | 5fc732a6.2e5bf4 | 2 | 2020-12-02 15:22:30+09 | 9/48 | 134097 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:22:30.823+09 | 3038196 | 5fc732a6.2e5bf4 | 3 | 2020-12-02 15:22:30+09 | 9/50 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 853 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 133131 remain, 0 are dead but not yet removable, oldest xmin: 134103 buffer usage: 351 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 166 records, 0 full page images, 9923 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:22:30.913+09 | 3038196 | 5fc732a6.2e5bf4 | 4 | 2020-12-02 15:22:30+09 | 9/51 | 134150 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.07 s, system: 0.00 s, elapsed: 0.08 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:22:30.932+09 | 3038196 | 5fc732a6.2e5bf4 | 5 | 2020-12-02 15:22:30+09 | 9/53 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 1 skipped due to pins, 0 skipped frozen tuples: 229 removed, 83 remain, 1 are dead but not yet removable, oldest xmin: 134154 buffer usage: 75 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 0 full page images, 1253 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:22:30.933+09 | 3038196 | 5fc732a6.2e5bf4 | 6 | 2020-12-02 15:22:30+09 | 9/54 | 134159 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:23:30.96+09 | 3038278 | 5fc732e2.2e5c46 | 4 | 2020-12-02 15:23:30+09 | 9/65 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 334 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 160153 buffer usage: 75 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 0 full page images, 1424 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:23:30.96+09 | 3038278 | 5fc732e2.2e5c46 | 5 | 2020-12-02 15:23:30+09 | 9/66 | 160157 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:23:30.826+09 | 3038278 | 5fc732e2.2e5c46 | 1 | 2020-12-02 15:23:30+09 | 9/60 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 1 skipped due to pins, 0 skipped frozen tuples: 299 removed, 8 remain, 0 are dead but not yet removable, oldest xmin: 160095 buffer usage: 58 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 6 records, 0 full page images, 1131 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:23:30.827+09 | 3038278 | 5fc732e2.2e5c46 | 2 | 2020-12-02 15:23:30+09 | 9/61 | 160099 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:23:30.941+09 | 3038278 | 5fc732e2.2e5c46 | 3 | 2020-12-02 15:23:30+09 | 9/63 | 160148 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.08 s, system: 0.00 s, elapsed: 0.09 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:24:22.619+09 | 3037881 | 5fc731d4.2e5ab9 | 5 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint starting: time | checkpointer | ||||||||||||||
| 2020-12-02 15:24:30.855+09 | 3038331 | 5fc7331e.2e5c7b | 1 | 2020-12-02 15:24:30+09 | 9/72 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 454 removed, 12 remain, 2 are dead but not yet removable, oldest xmin: 185763 buffer usage: 63 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 1 full page images, 9563 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:24:30.856+09 | 3038331 | 5fc7331e.2e5c7b | 2 | 2020-12-02 15:24:30+09 | 9/73 | 185769 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:24:30.885+09 | 3038331 | 5fc7331e.2e5c7b | 3 | 2020-12-02 15:24:30+09 | 9/75 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 1184 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 184985 remain, 0 are dead but not yet removable, oldest xmin: 185772 buffer usage: 683 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.528 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s WAL usage: 332 records, 2 full page images, 30599 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:24:30.979+09 | 3038331 | 5fc7331e.2e5c7b | 4 | 2020-12-02 15:24:30+09 | 9/76 | 185817 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.07 s, system: 0.00 s, elapsed: 0.09 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:24:30.998+09 | 3038331 | 5fc7331e.2e5c7b | 5 | 2020-12-02 15:24:30+09 | 9/78 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 350 removed, 101 remain, 1 are dead but not yet removable, oldest xmin: 185820 buffer usage: 75 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 1 full page images, 9633 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:24:30.998+09 | 3038331 | 5fc7331e.2e5c7b | 6 | 2020-12-02 15:24:30+09 | 9/79 | 185825 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:25:32.029+09 | 3038800 | 5fc7335a.2e5e50 | 1 | 2020-12-02 15:25:30+09 | 9/85 | 214433 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_accounts" system usage: CPU: user: 0.14 s, system: 0.01 s, elapsed: 1.14 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:25:32.046+09 | 3038800 | 5fc7335a.2e5e50 | 2 | 2020-12-02 15:25:30+09 | 9/87 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 592 removed, 10 remain, 0 are dead but not yet removable, oldest xmin: 214439 buffer usage: 38 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 6 records, 0 full page images, 1728 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:25:32.046+09 | 3038800 | 5fc7335a.2e5e50 | 3 | 2020-12-02 15:25:30+09 | 9/88 | 214443 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:25:32.165+09 | 3038800 | 5fc7335a.2e5e50 | 4 | 2020-12-02 15:25:30+09 | 9/90 | 214509 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.08 s, system: 0.00 s, elapsed: 0.10 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:25:32.183+09 | 3038800 | 5fc7335a.2e5e50 | 5 | 2020-12-02 15:25:30+09 | 9/92 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 259 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 214516 buffer usage: 76 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 9 records, 0 full page images, 1430 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:25:32.183+09 | 3038800 | 5fc7335a.2e5e50 | 6 | 2020-12-02 15:25:30+09 | 9/93 | 214520 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:00.889+09 | 3038833 | 5fc73378.2e5e71 | 1 | 2020-12-02 15:26:00+09 | 9/97 | 228915 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.statement" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:00.905+09 | 3038833 | 5fc73378.2e5e71 | 2 | 2020-12-02 15:26:00+09 | 9/99 | 228922 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.plan" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:00.931+09 | 3038833 | 5fc73378.2e5e71 | 3 | 2020-12-02 15:26:00+09 | 9/101 | 228933 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.column_20201202" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:00.954+09 | 3038833 | 5fc73378.2e5e71 | 4 | 2020-12-02 15:26:00+09 | 9/103 | 228946 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.table_20201202" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:00.972+09 | 3038833 | 5fc73378.2e5e71 | 5 | 2020-12-02 15:26:00+09 | 9/105 | 228956 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.index_20201202" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:30.913+09 | 3038859 | 5fc73396.2e5e8b | 1 | 2020-12-02 15:26:30+09 | 9/109 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 1 skipped due to pins, 0 skipped frozen tuples: 259 removed, 10 remain, 1 are dead but not yet removable, oldest xmin: 243214 buffer usage: 58 hits, 0 misses, 4 dirtied avg read rate: 0.000 MB/s, avg write rate: 128.601 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 6 records, 0 full page images, 1055 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:30.916+09 | 3038859 | 5fc73396.2e5e8b | 2 | 2020-12-02 15:26:30+09 | 9/110 | 243221 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:30.947+09 | 3038859 | 5fc73396.2e5e8b | 3 | 2020-12-02 15:26:30+09 | 9/112 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 1548 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 242407 remain, 0 are dead but not yet removable, oldest xmin: 243226 buffer usage: 755 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s WAL usage: 368 records, 0 full page images, 21841 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:31.051+09 | 3038859 | 5fc73396.2e5e8b | 4 | 2020-12-02 15:26:30+09 | 9/113 | 243282 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.08 s, system: 0.00 s, elapsed: 0.10 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:31.066+09 | 3038859 | 5fc73396.2e5e8b | 5 | 2020-12-02 15:26:30+09 | 9/115 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 412 removed, 101 remain, 1 are dead but not yet removable, oldest xmin: 243286 buffer usage: 75 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 8 records, 0 full page images, 1607 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:31.066+09 | 3038859 | 5fc73396.2e5e8b | 6 | 2020-12-02 15:26:30+09 | 9/116 | 243291 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:26:52.674+09 | 3037881 | 5fc731d4.2e5ab9 | 6 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint complete: wrote 20903 buffers (31.9%); 0 WAL file(s) added, 0 removed, 12 recycled; write=149.435 s, sync=0.346 s, total=150.055 s; sync files=146, longest=0.014 s, average=0.002 s; distance=204786 kB, estimate=204786 kB | checkpointer | ||||||||||||||
| 2020-12-02 15:27:00.913+09 | 3038889 | 5fc733b4.2e5ea9 | 1 | 2020-12-02 15:27:00+09 | 9/120 | 0 | LOG | 00000 | automatic vacuum of table "postgres.pg_catalog.pg_statistic": index scans: 1 pages: 0 removed, 30 remain, 0 skipped due to pins, 0 skipped frozen tuples: 14 removed, 540 remain, 0 are dead but not yet removable, oldest xmin: 256553 buffer usage: 101 hits, 0 misses, 6 dirtied avg read rate: 0.000 MB/s, avg write rate: 97.656 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 35 records, 5 full page images, 32047 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:27:00.929+09 | 3038889 | 5fc733b4.2e5ea9 | 2 | 2020-12-02 15:27:00+09 | 9/122 | 256564 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.log_20201202" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:27:30.943+09 | 3038935 | 5fc733d2.2e5ed7 | 1 | 2020-12-02 15:27:30+09 | 9/126 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 331 removed, 12 remain, 2 are dead but not yet removable, oldest xmin: 269375 buffer usage: 59 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 5 records, 0 full page images, 1147 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:27:30.944+09 | 3038935 | 5fc733d2.2e5ed7 | 2 | 2020-12-02 15:27:30+09 | 9/127 | 269381 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:27:31.09+09 | 3038935 | 5fc733d2.2e5ed7 | 4 | 2020-12-02 15:27:30+09 | 9/131 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 168 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 269441 buffer usage: 75 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 35.511 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 8 records, 0 full page images, 1007 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:27:31.09+09 | 3038935 | 5fc733d2.2e5ed7 | 5 | 2020-12-02 15:27:30+09 | 9/132 | 269445 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:27:31.074+09 | 3038935 | 5fc733d2.2e5ed7 | 3 | 2020-12-02 15:27:30+09 | 9/129 | 269437 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.09 s, system: 0.00 s, elapsed: 0.11 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:28:30.99+09 | 3039177 | 5fc7340e.2e5fc9 | 4 | 2020-12-02 15:28:30+09 | 9/142 | 294884 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:28:30.971+09 | 3039177 | 5fc7340e.2e5fc9 | 1 | 2020-12-02 15:28:30+09 | 9/138 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 336 removed, 11 remain, 1 are dead but not yet removable, oldest xmin: 294868 buffer usage: 59 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 6 records, 0 full page images, 1216 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:28:30.972+09 | 3039177 | 5fc7340e.2e5fc9 | 2 | 2020-12-02 15:28:30+09 | 9/139 | 294875 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:28:30.989+09 | 3039177 | 5fc7340e.2e5fc9 | 3 | 2020-12-02 15:28:30+09 | 9/141 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 311 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 294880 buffer usage: 76 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 31.758 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 8 records, 0 full page images, 1515 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:22.774+09 | 3037881 | 5fc731d4.2e5ab9 | 7 | 2020-12-02 15:19:00+09 | 0 | LOG | 00000 | checkpoint starting: time | checkpointer | ||||||||||||||
| 2020-12-02 15:29:31.574+09 | 3039230 | 5fc7344a.2e5ffe | 1 | 2020-12-02 15:29:30+09 | 9/148 | 320460 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_accounts" system usage: CPU: user: 0.14 s, system: 0.01 s, elapsed: 0.57 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:31.594+09 | 3039230 | 5fc7344a.2e5ffe | 2 | 2020-12-02 15:29:30+09 | 9/150 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 364 removed, 10 remain, 0 are dead but not yet removable, oldest xmin: 320465 buffer usage: 37 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 5 records, 1 full page images, 9240 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:31.594+09 | 3039230 | 5fc7344a.2e5ffe | 3 | 2020-12-02 15:29:30+09 | 9/151 | 320469 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:31.634+09 | 3039230 | 5fc7344a.2e5ffe | 4 | 2020-12-02 15:29:30+09 | 9/153 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 2040 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 319430 remain, 0 are dead but not yet removable, oldest xmin: 320474 buffer usage: 1011 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.313 MB/s system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s WAL usage: 496 records, 1 full page images, 37590 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:31.746+09 | 3039230 | 5fc7344a.2e5ffe | 5 | 2020-12-02 15:29:30+09 | 9/154 | 320534 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.09 s, system: 0.00 s, elapsed: 0.11 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:31.764+09 | 3039230 | 5fc7344a.2e5ffe | 6 | 2020-12-02 15:29:30+09 | 9/156 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 373 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 320541 buffer usage: 75 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 1 full page images, 9667 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:29:31.764+09 | 3039230 | 5fc7344a.2e5ffe | 7 | 2020-12-02 15:29:30+09 | 9/157 | 320545 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:30:31.017+09 | 3039339 | 5fc73486.2e606b | 1 | 2020-12-02 15:30:30+09 | 9/163 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 479 removed, 10 remain, 0 are dead but not yet removable, oldest xmin: 345686 buffer usage: 59 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 0 full page images, 1561 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:30:31.018+09 | 3039339 | 5fc73486.2e606b | 2 | 2020-12-02 15:30:30+09 | 9/164 | 345690 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:30:31.035+09 | 3039339 | 5fc73486.2e606b | 3 | 2020-12-02 15:30:30+09 | 9/166 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_tellers": index scans: 0 pages: 0 removed, 25 remain, 0 skipped due to pins, 0 skipped frozen tuples: 274 removed, 100 remain, 0 are dead but not yet removable, oldest xmin: 345694 buffer usage: 75 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 7 records, 0 full page images, 1244 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:30:31.035+09 | 3039339 | 5fc73486.2e606b | 4 | 2020-12-02 15:30:30+09 | 9/167 | 345698 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_tellers" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:01.031+09 | 3039370 | 5fc734a5.2e608a | 1 | 2020-12-02 15:31:01+09 | 9/171 | 363697 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.setting" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:01.048+09 | 3039370 | 5fc734a5.2e608a | 2 | 2020-12-02 15:31:01+09 | 9/173 | 363712 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.function" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:01.064+09 | 3039370 | 5fc734a5.2e608a | 3 | 2020-12-02 15:31:01+09 | 9/175 | 0 | LOG | 00000 | automatic vacuum of table "postgres.statsrepo.column_20201202": index scans: 0 pages: 0 removed, 29 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 1588 remain, 0 are dead but not yet removable, oldest xmin: 363723 buffer usage: 141 hits, 2 misses, 14 dirtied avg read rate: 5.789 MB/s, avg write rate: 40.524 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 32 records, 2 full page images, 16149 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:01.076+09 | 3039370 | 5fc734a5.2e608a | 4 | 2020-12-02 15:31:01+09 | 9/176 | 363739 | LOG | 00000 | automatic analyze of table "postgres.statsrepo.column_20201202" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:31.046+09 | 3039395 | 5fc734c3.2e60a3 | 1 | 2020-12-02 15:31:31+09 | 9/180 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_branches": index scans: 0 pages: 0 removed, 6 remain, 0 skipped due to pins, 0 skipped frozen tuples: 494 removed, 10 remain, 0 are dead but not yet removable, oldest xmin: 386923 buffer usage: 59 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s WAL usage: 6 records, 0 full page images, 1532 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:31.047+09 | 3039395 | 5fc734c3.2e60a3 | 2 | 2020-12-02 15:31:31+09 | 9/181 | 386928 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:31.088+09 | 3039395 | 5fc734c3.2e60a3 | 3 | 2020-12-02 15:31:31+09 | 9/183 | 0 | LOG | 00000 | automatic vacuum of table "bench.public.pgbench_history": index scans: 0 pages: 0 removed, 2462 remain, 0 skipped due to pins, 0 skipped frozen tuples: 0 removed, 385866 remain, 0 are dead but not yet removable, oldest xmin: 386932 buffer usage: 871 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s WAL usage: 426 records, 0 full page images, 25263 bytes | autovacuum worker | |||||||||||||
| 2020-12-02 15:31:31.212+09 | 3039395 | 5fc734c3.2e60a3 | 4 | 2020-12-02 15:31:31+09 | 9/184 | 387000 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_history" system usage: CPU: user: 0.09 s, system: 0.00 s, elapsed: 0.12 s | autovacuum worker | |||||||||||||
| 2020-12-02 15:33:31.485+09 | 3039518 | 5fc7353b.2e611e | 3 | 2020-12-02 15:33:31+09 | 9/208 | 438118 | LOG | 00000 | automatic analyze of table "bench.public.pgbench_branches" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s | autovacuum worker |