Re: Repeating autovacuum

From: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Repeating autovacuum
Date: 2017-04-08 17:34:48
Message-ID: 00bd01d2b08e$6cba50c0$462ef240$@1nar.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of David G. Johnston
> Sent: Saturday, April 8, 2017 1:53 AM
> To: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Repeating autovacuum
>
>
> It would be interesting to see the timestamps on those log entries...
>
> David J.

Below is a cropped log with timestamps

-----
2017-04-08 15:52:34 +03LOG: database system was shut down at 2017-04-08 15:52:32 +03
2017-04-08 15:52:34 +03DEBUG: checkpoint record is at 0/176E540
2017-04-08 15:52:34 +03DEBUG: redo record is at 0/176E540; shutdown TRUE
2017-04-08 15:52:34 +03DEBUG: next transaction ID: 0:702; next OID: 16888
2017-04-08 15:52:34 +03DEBUG: next MultiXactId: 1; next MultiXactOffset: 0
2017-04-08 15:52:34 +03DEBUG: oldest unfrozen transaction ID: 536, in database 12401
2017-04-08 15:52:34 +03DEBUG: oldest MultiXactId: 1, in database 16526
2017-04-08 15:52:34 +03DEBUG: commit timestamp Xid oldest/newest: 0/0
2017-04-08 15:52:34 +03DEBUG: transaction ID wrap limit is 2147484183, limited by database with OID 12401
2017-04-08 15:52:34 +03DEBUG: MultiXactId wrap limit is 2147483648, limited by database with OID 16526
2017-04-08 15:52:34 +03DEBUG: starting up replication slots
2017-04-08 15:52:34 +03DEBUG: MultiXactId wrap limit is 2147483648, limited by database with OID 16526
2017-04-08 15:52:34 +03LOG: MultiXact member wraparound protections are now enabled
2017-04-08 15:52:34 +03DEBUG: MultiXact member stop limit is now 4294914944 based on MultiXact 1
2017-04-08 15:52:34 +03LOG: database system is ready to accept connections
2017-04-08 15:52:34 +03DEBUG: checkpointer updated shared memory configuration values
2017-04-08 15:52:34 +03LOG: autovacuum launcher started
2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/db_12401.stat"
2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/db_1.stat"
2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/db_16526.stat"
2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/db_16461.stat"
2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/db_0.stat"
2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/global.stat"
2017-04-08 15:52:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:52:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:52:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:52:34 +03DEBUG: forked new backend, pid=7048 socket=5072
2017-04-08 15:52:34 +03LOG: connection received: host=::1 port=58851
2017-04-08 15:52:34 +03LOG: connection authorized: user=DESKTOP-L63HSP2$ database=postgres
2017-04-08 15:52:35 +03DEBUG: server process (PID 7048) exited with exit code 0
2017-04-08 15:52:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:52:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:52:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:52:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:52:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:52:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:52:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:52:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:52:49 +03DEBUG: server process (PID 2724) exited with exit code 0
2017-04-08 15:53:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:53:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:53:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:53:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:53:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:04 +03DEBUG: server process (PID 18440) exited with exit code 0
2017-04-08 15:53:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:53:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:53:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:53:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:53:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:19 +03DEBUG: server process (PID 12944) exited with exit code 0
2017-04-08 15:53:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:53:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:53:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:53:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:53:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:34 +03DEBUG: server process (PID 18672) exited with exit code 0
2017-04-08 15:53:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:53:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:53:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:53:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:53:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:53:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:53:49 +03DEBUG: server process (PID 8352) exited with exit code 0
2017-04-08 15:54:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:54:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:54:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:54:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:54:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:04 +03DEBUG: server process (PID 18548) exited with exit code 0
2017-04-08 15:54:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:54:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:54:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:54:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:54:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:19 +03DEBUG: server process (PID 14840) exited with exit code 0
2017-04-08 15:54:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:54:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:54:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:54:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:54:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:34 +03DEBUG: server process (PID 19172) exited with exit code 0
2017-04-08 15:54:44 +03DEBUG: forked new backend, pid=19448 socket=5024
2017-04-08 15:54:44 +03LOG: connection received: host=::1 port=58984
2017-04-08 15:54:44 +03LOG: connection authorized: user=postgres database=tracker
2017-04-08 15:54:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:54:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:54:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:54:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:54:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:54:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:54:49 +03DEBUG: server process (PID 12448) exited with exit code 0
2017-04-08 15:54:54 +03DEBUG: forked new backend, pid=18744 socket=5032
2017-04-08 15:54:54 +03LOG: connection received: host=::1 port=58994
2017-04-08 15:54:54 +03LOG: connection authorized: user=postgres database=tracker
2017-04-08 15:55:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:55:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:55:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:55:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:55:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:04 +03DEBUG: server process (PID 4500) exited with exit code 0
2017-04-08 15:55:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:55:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:55:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:55:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:55:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:19 +03DEBUG: server process (PID 11156) exited with exit code 0
2017-04-08 15:55:19 +03DEBUG: server process (PID 18744) exited with exit code 0
2017-04-08 15:55:27 +03DEBUG: forked new backend, pid=14356 socket=5032
2017-04-08 15:55:27 +03LOG: connection received: host=::1 port=59027
2017-04-08 15:55:27 +03LOG: connection authorized: user=postgres database=tracker
2017-04-08 15:55:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:55:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:55:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:55:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:55:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:34 +03DEBUG: server process (PID 11412) exited with exit code 0
2017-04-08 15:55:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:55:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:55:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:55:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:55:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:55:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:55:49 +03DEBUG: server process (PID 13888) exited with exit code 0
2017-04-08 15:56:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:56:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:56:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:56:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:56:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:04 +03DEBUG: server process (PID 10268) exited with exit code 0
2017-04-08 15:56:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:56:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:56:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:56:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:56:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:19 +03DEBUG: server process (PID 7676) exited with exit code 0
2017-04-08 15:56:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:56:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:56:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:56:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:56:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:34 +03DEBUG: server process (PID 18516) exited with exit code 0
2017-04-08 15:56:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:56:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:56:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:56:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:56:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:56:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:56:49 +03DEBUG: server process (PID 10112) exited with exit code 0
2017-04-08 15:57:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:57:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:57:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:57:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:57:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:04 +03DEBUG: server process (PID 12396) exited with exit code 0
2017-04-08 15:57:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:57:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:57:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:57:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:57:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:19 +03DEBUG: server process (PID 12048) exited with exit code 0
2017-04-08 15:57:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:57:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:57:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:57:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:57:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:34 +03DEBUG: server process (PID 2188) exited with exit code 0
2017-04-08 15:57:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:57:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:57:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:57:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:57:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:57:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:57:49 +03DEBUG: server process (PID 9560) exited with exit code 0
2017-04-08 15:58:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:58:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:58:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:58:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:58:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:04 +03DEBUG: server process (PID 8704) exited with exit code 0
2017-04-08 15:58:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:58:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:58:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:58:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:58:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:19 +03DEBUG: server process (PID 10236) exited with exit code 0
2017-04-08 15:58:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:58:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:58:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:58:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:58:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:34 +03DEBUG: server process (PID 12848) exited with exit code 0
2017-04-08 15:58:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:58:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:58:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:58:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:58:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:58:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:58:49 +03DEBUG: server process (PID 2484) exited with exit code 0
2017-04-08 15:59:04 +03DEBUG: received inquiry for database 0
2017-04-08 15:59:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:04 +03DEBUG: autovacuum: processing database "spanc"
2017-04-08 15:59:04 +03DEBUG: received inquiry for database 16461
2017-04-08 15:59:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:04 +03DEBUG: writing stats file "pg_stat_tmp/db_16461.stat"
2017-04-08 15:59:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:04 +03DEBUG: server process (PID 1168) exited with exit code 0
2017-04-08 15:59:19 +03DEBUG: received inquiry for database 0
2017-04-08 15:59:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:19 +03DEBUG: autovacuum: processing database "template1"
2017-04-08 15:59:19 +03DEBUG: received inquiry for database 1
2017-04-08 15:59:19 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:19 +03DEBUG: writing stats file "pg_stat_tmp/db_1.stat"
2017-04-08 15:59:19 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:19 +03DEBUG: server process (PID 19000) exited with exit code 0
2017-04-08 15:59:34 +03DEBUG: received inquiry for database 0
2017-04-08 15:59:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:34 +03DEBUG: autovacuum: processing database "postgres"
2017-04-08 15:59:34 +03DEBUG: received inquiry for database 12401
2017-04-08 15:59:34 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:34 +03DEBUG: writing stats file "pg_stat_tmp/db_12401.stat"
2017-04-08 15:59:34 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:34 +03DEBUG: server process (PID 572) exited with exit code 0
2017-04-08 15:59:40 +03DEBUG: server process (PID 14356) exited with exit code 0
2017-04-08 15:59:40 +03DEBUG: server process (PID 19448) exited with exit code 0
2017-04-08 15:59:49 +03DEBUG: received inquiry for database 0
2017-04-08 15:59:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:49 +03DEBUG: autovacuum: processing database "tracker"
2017-04-08 15:59:49 +03DEBUG: received inquiry for database 16526
2017-04-08 15:59:49 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 15:59:49 +03DEBUG: writing stats file "pg_stat_tmp/db_16526.stat"
2017-04-08 15:59:49 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
2017-04-08 15:59:49 +03DEBUG: server process (PID 2172) exited with exit code 0
2017-04-08 16:00:04 +03DEBUG: received inquiry for database 0
2017-04-08 16:00:04 +03DEBUG: writing stats file "pg_stat_tmp/global.stat"
2017-04-08 16:00:04 +03DEBUG: writing stats file "pg_stat_tmp/db_0.stat"
-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Günce Kaya 2017-04-10 07:19:16 Re: [GENERAL] calculating table and index size
Previous Message Thorsten Schöning 2017-04-08 11:31:18 Re: pg_dump with custom format without compression