[repository1]
dbserver01:5432
begin:
2015-03-10 00:00
end:
2015-03-11 00:00
[repository1]
dbserver01:5432
begin:
2015-03-10 00:00
end:
2015-03-11 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015-03-10 16:11:04.504+09 | 9159 | 54fe9908.23c7 | 1 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | ending log output to stderr | Future log output will go to log destination "csvlog". | |||||||||||||
| 2015-03-10 16:11:04.519+09 | 9163 | 54fe9908.23cb | 1 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | database system was shut down at 2015-03-10 16:08:20 JST | ||||||||||||||
| 2015-03-10 16:11:04.567+09 | 9159 | 54fe9908.23c7 | 2 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | database system is ready to accept connections | ||||||||||||||
| 2015-03-10 16:11:04.568+09 | 9167 | 54fe9908.23cf | 1 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | autovacuum launcher started | ||||||||||||||
| 2015-03-10 16:11:07.643+09 | statsinfo | 9182 | 127.0.0.1:40783 | 54fe990b.23de | 1 | streaming 0/79000090 | 2015-03-10 16:11:07+09 | 3/0 | 0 | LOG | 00000 | standby "sby" is now the synchronous standby with priority 1 | sby | |||||||||
| 2015-03-10 16:12:34.921+09 | 9504 | 54fe9962.2520 | 1 | 2015-03-10 16:12:34+09 | 2/23 | 2106 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:12:35.152+09 | 9504 | 54fe9962.2520 | 2 | 2015-03-10 16:12:34+09 | 2/25 | 2107 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.01 sec | |||||||||||||
| 2015-03-10 16:13:34.759+09 | 9605 | 54fe999e.2585 | 1 | 2015-03-10 16:13:34+09 | 14/107 | 2360 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:13:34.784+09 | 9605 | 54fe999e.2585 | 2 | 2015-03-10 16:13:34+09 | 14/109 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 1 pages: 0 removed, 8 remain tuples: 38 removed, 136 remain, 36 are dead but not yet removable buffer usage: 40 hits, 2 misses, 3 dirtied avg read rate: 8.538 MB/s, avg write rate: 12.807 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:13:34.795+09 | 9605 | 54fe999e.2585 | 3 | 2015-03-10 16:13:34+09 | 14/110 | 2361 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:14:10.001+09 | 9164 | 54fe9908.23cc | 1 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:14:34.767+09 | 9624 | 54fe99da.2598 | 1 | 2015-03-10 16:14:34+09 | 14/118 | 2626 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:14:34.963+09 | 9624 | 54fe99da.2598 | 2 | 2015-03-10 16:14:34+09 | 14/120 | 2627 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:15:13.633+09 | 9164 | 54fe9908.23cc | 2 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 6465 buffers (39.5%); 0 transaction log file(s) added, 0 removed, 4 recycled; write=55.597 s, sync=7.685 s, total=63.632 s; sync files=59, longest=2.870 s, average=0.130 s | ||||||||||||||
| 2015-03-10 16:15:34.795+09 | 9642 | 54fe9a16.25aa | 1 | 2015-03-10 16:15:34+09 | 14/128 | 2876 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:15:34.839+09 | 9642 | 54fe9a16.25aa | 2 | 2015-03-10 16:15:34+09 | 14/130 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 1 pages: 0 removed, 8 remain tuples: 120 removed, 117 remain, 17 are dead but not yet removable buffer usage: 42 hits, 0 misses, 4 dirtied avg read rate: 0.000 MB/s, avg write rate: 19.753 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:15:34.849+09 | 9642 | 54fe9a16.25aa | 3 | 2015-03-10 16:15:34+09 | 14/131 | 2877 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:16:00.152+09 | 9164 | 54fe9908.23cc | 3 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:16:34.813+09 | 9660 | 54fe9a52.25bc | 1 | 2015-03-10 16:16:34+09 | 14/139 | 3155 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:16:34.836+09 | 9660 | 54fe9a52.25bc | 2 | 2015-03-10 16:16:34+09 | 14/141 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 94 removed, 114 remain, 14 are dead but not yet removable buffer usage: 41 hits, 0 misses, 3 dirtied avg read rate: 0.000 MB/s, avg write rate: 14.468 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:16:34.858+09 | 9660 | 54fe9a52.25bc | 3 | 2015-03-10 16:16:34+09 | 14/142 | 3156 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:17:03.652+09 | 9164 | 54fe9908.23cc | 4 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 5633 buffers (34.4%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=53.275 s, sync=9.219 s, total=63.499 s; sync files=28, longest=1.459 s, average=0.329 s | ||||||||||||||
| 2015-03-10 16:17:34.838+09 | 9677 | 54fe9a8e.25cd | 1 | 2015-03-10 16:17:34+09 | 14/150 | 3397 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:17:34.858+09 | 9677 | 54fe9a8e.25cd | 2 | 2015-03-10 16:17:34+09 | 14/152 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 1 pages: 0 removed, 8 remain tuples: 85 removed, 106 remain, 6 are dead but not yet removable buffer usage: 41 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:17:34.868+09 | 9677 | 54fe9a8e.25cd | 3 | 2015-03-10 16:17:34+09 | 14/153 | 3398 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:17:34.949+09 | 9677 | 54fe9a8e.25cd | 4 | 2015-03-10 16:17:34+09 | 14/155 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.pg_toast.pg_toast_2619": index scans: 1 pages: 0 removed, 25 remain tuples: 46 removed, 83 remain, 6 are dead but not yet removable buffer usage: 67 hits, 5 misses, 26 dirtied avg read rate: 0.629 MB/s, avg write rate: 3.269 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.06 sec | |||||||||||||
| 2015-03-10 16:18:05.051+09 | 9164 | 54fe9908.23cc | 5 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:18:34.876+09 | 9694 | 54fe9aca.25de | 1 | 2015-03-10 16:18:34+09 | 14/163 | 3661 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:18:34.896+09 | 9694 | 54fe9aca.25de | 2 | 2015-03-10 16:18:34+09 | 14/165 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 96 removed, 109 remain, 9 are dead but not yet removable buffer usage: 41 hits, 0 misses, 6 dirtied avg read rate: 0.000 MB/s, avg write rate: 23.103 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:18:34.924+09 | 9694 | 54fe9aca.25de | 3 | 2015-03-10 16:18:34+09 | 14/166 | 3662 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.02 sec | |||||||||||||
| 2015-03-10 16:19:10.667+09 | 9164 | 54fe9908.23cc | 6 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 6002 buffers (36.6%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=55.875 s, sync=9.336 s, total=65.615 s; sync files=27, longest=2.152 s, average=0.345 s | ||||||||||||||
| 2015-03-10 16:19:35.491+09 | 9712 | 54fe9b06.25f0 | 1 | 2015-03-10 16:19:34+09 | 14/174 | 3897 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:19:35.643+09 | 9712 | 54fe9b06.25f0 | 2 | 2015-03-10 16:19:34+09 | 14/176 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 1 pages: 0 removed, 8 remain tuples: 99 removed, 107 remain, 5 are dead but not yet removable buffer usage: 41 hits, 0 misses, 0 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.10 sec | |||||||||||||
| 2015-03-10 16:19:35.805+09 | 9712 | 54fe9b06.25f0 | 3 | 2015-03-10 16:19:34+09 | 14/177 | 3899 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.02 sec | |||||||||||||
| 2015-03-10 16:20:06.515+09 | 9164 | 54fe9908.23cc | 7 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:20:36.354+09 | 9733 | 54fe9b43.2605 | 1 | 2015-03-10 16:20:35+09 | 14/185 | 4162 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:20:36.963+09 | 9733 | 54fe9b43.2605 | 2 | 2015-03-10 16:20:35+09 | 14/187 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 77 removed, 117 remain, 15 are dead but not yet removable buffer usage: 41 hits, 0 misses, 2 dirtied avg read rate: 0.000 MB/s, avg write rate: 25.912 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:20:39.68+09 | 9733 | 54fe9b43.2605 | 3 | 2015-03-10 16:20:35+09 | 14/188 | 4173 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:21:23.35+09 | 9164 | 54fe9908.23cc | 8 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 5837 buffers (35.6%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=50.976 s, sync=22.947 s, total=76.835 s; sync files=31, longest=4.692 s, average=0.740 s | ||||||||||||||
| 2015-03-10 16:21:35.005+09 | 9752 | 54fe9b7e.2618 | 1 | 2015-03-10 16:21:34+09 | 14/196 | 4393 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:21:35.023+09 | 9752 | 54fe9b7e.2618 | 2 | 2015-03-10 16:21:34+09 | 14/198 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 52 removed, 162 remain, 62 are dead but not yet removable buffer usage: 42 hits, 0 misses, 4 dirtied avg read rate: 0.000 MB/s, avg write rate: 26.129 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:21:35.031+09 | 9752 | 54fe9b7e.2618 | 3 | 2015-03-10 16:21:34+09 | 14/199 | 4394 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:22:10.874+09 | 9164 | 54fe9908.23cc | 9 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:22:36.372+09 | 9769 | 54fe9bbb.2629 | 1 | 2015-03-10 16:22:35+09 | 14/207 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 1 pages: 0 removed, 2 remain tuples: 70 removed, 16 remain, 5 are dead but not yet removable buffer usage: 44 hits, 2 misses, 6 dirtied avg read rate: 0.330 MB/s, avg write rate: 0.989 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:22:36.938+09 | 9769 | 54fe9bbb.2629 | 2 | 2015-03-10 16:22:35+09 | 14/208 | 4667 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:22:37.156+09 | 9769 | 54fe9bbb.2629 | 3 | 2015-03-10 16:22:35+09 | 14/210 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 1 pages: 0 removed, 8 remain tuples: 106 removed, 116 remain, 13 are dead but not yet removable buffer usage: 42 hits, 0 misses, 5 dirtied avg read rate: 0.000 MB/s, avg write rate: 31.784 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:22:41.708+09 | 9769 | 54fe9bbb.2629 | 4 | 2015-03-10 16:22:35+09 | 14/211 | 4677 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:23:15.411+09 | 9164 | 54fe9908.23cc | 10 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 6001 buffers (36.6%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=48.865 s, sync=14.549 s, total=64.537 s; sync files=31, longest=5.469 s, average=0.469 s | ||||||||||||||
| 2015-03-10 16:23:34.997+09 | 9787 | 54fe9bf6.263b | 1 | 2015-03-10 16:23:34+09 | 14/219 | 4898 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:23:35.032+09 | 9787 | 54fe9bf6.263b | 2 | 2015-03-10 16:23:34+09 | 14/221 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 59 removed, 125 remain, 25 are dead but not yet removable buffer usage: 41 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 7.534 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:23:35.072+09 | 9787 | 54fe9bf6.263b | 3 | 2015-03-10 16:23:34+09 | 14/222 | 4899 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:24:09.711+09 | 9164 | 54fe9908.23cc | 11 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:24:34.974+09 | 9804 | 54fe9c32.264c | 1 | 2015-03-10 16:24:34+09 | 14/230 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 51 removed, 25 remain, 15 are dead but not yet removable buffer usage: 46 hits, 0 misses, 3 dirtied avg read rate: 0.000 MB/s, avg write rate: 21.191 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:24:35.038+09 | 9804 | 54fe9c32.264c | 2 | 2015-03-10 16:24:34+09 | 14/231 | 5166 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:24:35.062+09 | 9804 | 54fe9c32.264c | 3 | 2015-03-10 16:24:34+09 | 14/233 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 93 removed, 136 remain, 35 are dead but not yet removable buffer usage: 41 hits, 0 misses, 3 dirtied avg read rate: 0.000 MB/s, avg write rate: 19.039 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:24:35.093+09 | 9804 | 54fe9c32.264c | 4 | 2015-03-10 16:24:34+09 | 14/234 | 5167 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.02 sec | |||||||||||||
| 2015-03-10 16:25:11.545+09 | 9164 | 54fe9908.23cc | 12 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 5921 buffers (36.1%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=47.646 s, sync=12.929 s, total=61.833 s; sync files=33, longest=6.149 s, average=0.391 s | ||||||||||||||
| 2015-03-10 16:25:35.27+09 | 9822 | 54fe9c6e.265e | 2 | 2015-03-10 16:25:34+09 | 14/244 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 69 removed, 131 remain, 30 are dead but not yet removable buffer usage: 41 hits, 0 misses, 2 dirtied avg read rate: 0.000 MB/s, avg write rate: 6.817 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:25:35.218+09 | 9822 | 54fe9c6e.265e | 1 | 2015-03-10 16:25:34+09 | 14/242 | 5407 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:25:35.283+09 | 9822 | 54fe9c6e.265e | 3 | 2015-03-10 16:25:34+09 | 14/245 | 5408 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:26:02.067+09 | 9164 | 54fe9908.23cc | 13 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:26:35.14+09 | 9840 | 54fe9caa.2670 | 4 | 2015-03-10 16:26:34+09 | 14/257 | 5675 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.02 sec | |||||||||||||
| 2015-03-10 16:26:35.031+09 | 9840 | 54fe9caa.2670 | 1 | 2015-03-10 16:26:34+09 | 14/253 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 45 removed, 28 remain, 18 are dead but not yet removable buffer usage: 45 hits, 1 misses, 5 dirtied avg read rate: 6.070 MB/s, avg write rate: 30.352 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:26:35.085+09 | 9840 | 54fe9caa.2670 | 2 | 2015-03-10 16:26:34+09 | 14/254 | 5674 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:26:35.105+09 | 9840 | 54fe9caa.2670 | 3 | 2015-03-10 16:26:34+09 | 14/256 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 76 removed, 127 remain, 26 are dead but not yet removable buffer usage: 41 hits, 0 misses, 2 dirtied avg read rate: 0.000 MB/s, avg write rate: 30.106 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:27:20.929+09 | 9164 | 54fe9908.23cc | 14 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 5989 buffers (36.6%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=53.844 s, sync=24.732 s, total=78.861 s; sync files=30, longest=7.321 s, average=0.824 s | ||||||||||||||
| 2015-03-10 16:27:35.12+09 | 9857 | 54fe9ce7.2681 | 2 | 2015-03-10 16:27:35+09 | 14/266 | 5865 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.05 sec | |||||||||||||
| 2015-03-10 16:27:35.048+09 | 9857 | 54fe9ce7.2681 | 1 | 2015-03-10 16:27:35+09 | 14/265 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 54 removed, 17 remain, 7 are dead but not yet removable buffer usage: 46 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 16.447 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:27:35.146+09 | 9857 | 54fe9ce7.2681 | 3 | 2015-03-10 16:27:35+09 | 14/268 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 1 pages: 0 removed, 8 remain tuples: 64 removed, 110 remain, 9 are dead but not yet removable buffer usage: 42 hits, 0 misses, 3 dirtied avg read rate: 0.000 MB/s, avg write rate: 32.283 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:27:35.189+09 | 9857 | 54fe9ce7.2681 | 4 | 2015-03-10 16:27:35+09 | 14/269 | 5867 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:28:14.086+09 | 9164 | 54fe9908.23cc | 15 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:28:35.19+09 | 9874 | 54fe9d23.2692 | 3 | 2015-03-10 16:28:35+09 | 14/280 | 6147 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.02 sec | |||||||||||||
| 2015-03-10 16:28:35.136+09 | 9874 | 54fe9d23.2692 | 1 | 2015-03-10 16:28:35+09 | 14/277 | 6146 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:28:35.154+09 | 9874 | 54fe9d23.2692 | 2 | 2015-03-10 16:28:35+09 | 14/279 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 117 removed, 121 remain, 21 are dead but not yet removable buffer usage: 41 hits, 0 misses, 7 dirtied avg read rate: 0.000 MB/s, avg write rate: 37.638 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:29:16.046+09 | 9164 | 54fe9908.23cc | 16 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 6064 buffers (37.0%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=47.661 s, sync=13.351 s, total=61.959 s; sync files=32, longest=7.613 s, average=0.417 s | ||||||||||||||
| 2015-03-10 16:29:35.106+09 | 9892 | 54fe9d5f.26a4 | 1 | 2015-03-10 16:29:35+09 | 14/288 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 73 removed, 11 remain, 1 are dead but not yet removable buffer usage: 46 hits, 0 misses, 6 dirtied avg read rate: 0.000 MB/s, avg write rate: 35.975 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:29:35.159+09 | 9892 | 54fe9d5f.26a4 | 2 | 2015-03-10 16:29:35+09 | 14/289 | 6394 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:29:35.192+09 | 9892 | 54fe9d5f.26a4 | 3 | 2015-03-10 16:29:35+09 | 14/291 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 127 removed, 101 remain, 1 are dead but not yet removable buffer usage: 41 hits, 0 misses, 2 dirtied avg read rate: 0.000 MB/s, avg write rate: 16.517 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:29:35.463+09 | 9892 | 54fe9d5f.26a4 | 4 | 2015-03-10 16:29:35+09 | 14/292 | 6397 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:29:35.627+09 | 9892 | 54fe9d5f.26a4 | 5 | 2015-03-10 16:29:35+09 | 14/294 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.pg_toast.pg_toast_2619": index scans: 1 pages: 0 removed, 27 remain tuples: 59 removed, 83 remain, 6 are dead but not yet removable buffer usage: 62 hits, 14 misses, 11 dirtied avg read rate: 1.603 MB/s, avg write rate: 1.259 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.06 sec | |||||||||||||
| 2015-03-10 16:30:05.329+09 | 9164 | 54fe9908.23cc | 17 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:30:35.124+09 | 9913 | 54fe9d9b.26b9 | 1 | 2015-03-10 16:30:35+09 | 14/302 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 64 removed, 10 remain, 0 are dead but not yet removable buffer usage: 46 hits, 0 misses, 3 dirtied avg read rate: 0.000 MB/s, avg write rate: 15.259 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:30:36.264+09 | 9913 | 54fe9d9b.26b9 | 2 | 2015-03-10 16:30:35+09 | 14/303 | 6658 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:30:36.409+09 | 9913 | 54fe9d9b.26b9 | 3 | 2015-03-10 16:30:35+09 | 14/305 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 137 removed, 103 remain, 0 are dead but not yet removable buffer usage: 41 hits, 0 misses, 2 dirtied avg read rate: 0.000 MB/s, avg write rate: 11.626 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:30:36.457+09 | 9913 | 54fe9d9b.26b9 | 4 | 2015-03-10 16:30:35+09 | 14/306 | 6659 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:31:15.854+09 | 9164 | 54fe9908.23cc | 18 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 6028 buffers (36.8%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=64.619 s, sync=5.293 s, total=70.525 s; sync files=34, longest=1.514 s, average=0.155 s | ||||||||||||||
| 2015-03-10 16:31:35.142+09 | 9931 | 54fe9dd7.26cb | 1 | 2015-03-10 16:31:35+09 | 14/314 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 41 removed, 27 remain, 16 are dead but not yet removable buffer usage: 46 hits, 0 misses, 4 dirtied avg read rate: 0.000 MB/s, avg write rate: 27.704 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:31:35.303+09 | 9931 | 54fe9dd7.26cb | 2 | 2015-03-10 16:31:35+09 | 14/315 | 6863 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.04 sec | |||||||||||||
| 2015-03-10 16:31:35.321+09 | 9931 | 54fe9dd7.26cb | 3 | 2015-03-10 16:31:35+09 | 14/317 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 85 removed, 128 remain, 28 are dead but not yet removable buffer usage: 41 hits, 0 misses, 4 dirtied avg read rate: 0.000 MB/s, avg write rate: 28.855 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:31:35.346+09 | 9931 | 54fe9dd7.26cb | 4 | 2015-03-10 16:31:35+09 | 14/318 | 6864 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.01 sec | |||||||||||||
| 2015-03-10 16:32:05.93+09 | 9164 | 54fe9908.23cc | 19 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog | ||||||||||||||
| 2015-03-10 16:32:35.888+09 | 9948 | 54fe9e13.26dc | 1 | 2015-03-10 16:32:35+09 | 14/326 | 7134 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.03 sec | |||||||||||||
| 2015-03-10 16:32:38.77+09 | 9948 | 54fe9e13.26dc | 2 | 2015-03-10 16:32:35+09 | 14/328 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 100 removed, 107 remain, 21 are dead but not yet removable buffer usage: 40 hits, 0 misses, 6 dirtied avg read rate: 0.000 MB/s, avg write rate: 0.063 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.74 sec | |||||||||||||
| 2015-03-10 16:32:38.829+09 | 9948 | 54fe9e13.26dc | 3 | 2015-03-10 16:32:35+09 | 14/329 | 7143 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.02 sec | |||||||||||||
| 2015-03-10 16:33:22.056+09 | 9164 | 54fe9908.23cc | 20 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint complete: wrote 6162 buffers (37.6%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=56.088 s, sync=19.592 s, total=76.126 s; sync files=31, longest=10.200 s, average=0.631 s | ||||||||||||||
| 2015-03-10 16:33:35.16+09 | 9966 | 54fe9e4f.26ee | 1 | 2015-03-10 16:33:35+09 | 14/337 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.warehouse": index scans: 0 pages: 0 removed, 2 remain tuples: 47 removed, 18 remain, 7 are dead but not yet removable buffer usage: 46 hits, 0 misses, 5 dirtied avg read rate: 0.000 MB/s, avg write rate: 87.193 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:33:35.334+09 | 9966 | 54fe9e4f.26ee | 2 | 2015-03-10 16:33:35+09 | 14/338 | 7345 | LOG | 00000 | automatic analyze of table "dbt2.public.warehouse" system usage: CPU 0.00s/0.00u sec elapsed 0.05 sec | |||||||||||||
| 2015-03-10 16:33:35.351+09 | 9966 | 54fe9e4f.26ee | 3 | 2015-03-10 16:33:35+09 | 14/340 | 0 | LOG | 00000 | automatic vacuum of table "dbt2.public.district": index scans: 0 pages: 0 removed, 8 remain tuples: 104 removed, 119 remain, 19 are dead but not yet removable buffer usage: 41 hits, 0 misses, 1 dirtied avg read rate: 0.000 MB/s, avg write rate: 6.005 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |||||||||||||
| 2015-03-10 16:33:35.515+09 | 9966 | 54fe9e4f.26ee | 4 | 2015-03-10 16:33:35+09 | 14/341 | 7346 | LOG | 00000 | automatic analyze of table "dbt2.public.district" system usage: CPU 0.00s/0.00u sec elapsed 0.13 sec | |||||||||||||
| 2015-03-10 16:34:10.75+09 | 9164 | 54fe9908.23cc | 21 | 2015-03-10 16:11:04+09 | 0 | LOG | 00000 | checkpoint starting: xlog |