Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwuIA-0005Na-Q6 for pgsql-admin@arkaria.postgresql.org; Sat, 08 Apr 2017 17:36:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cwuI9-0006G2-EG for pgsql-admin@arkaria.postgresql.org; Sat, 08 Apr 2017 17:36:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwuGH-0002ul-G1 for pgsql-admin@postgresql.org; Sat, 08 Apr 2017 17:34:57 +0000 Received: from mta09.3.doruk.net.tr ([212.58.5.122] helo=mta09.doruk.net.tr) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwuGD-0003EJ-9m for pgsql-admin@postgresql.org; Sat, 08 Apr 2017 17:34:56 +0000 Received: from cmail19.webkontrol.doruk.net.tr ([212.58.6.99]) by mta09.doruk.net.tr with esmtp (Exim 4.86) (envelope-from ) id 1cwuFR-000GK8-Jc for pgsql-admin@postgresql.org; Sat, 08 Apr 2017 20:34:05 +0300 Received: from DESKTOPM80CG12 ([176.41.149.153]) by cmail19.webkontrol.doruk.net.tr (IceWarp 11.1.2.0) with ASMTP id 201704082037556345 for ; Sat, 08 Apr 2017 20:37:55 +0300 From: =?utf-8?B?RXJ0YW4gS8O8w6fDvGtvxJ9sdQ==?= To: References: <009201d2afef$3e9432f0$bbbc98d0$@1nar.com.tr> In-Reply-To: Subject: Re: Repeating autovacuum Date: Sat, 8 Apr 2017 20:34:48 +0300 Message-ID: <00bd01d2b08e$6cba50c0$462ef240$@1nar.com.tr> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQHT0i21qCmdfi4OTSUOdMupG+63NAJs5pd1oaYQpaA= Content-Language: tr X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgres= ql.org] On Behalf Of David G. Johnston > Sent: Saturday, April 8, 2017 1:53 AM > To: Ertan K=C3=BC=C3=A7=C3=BCko=C4=9Flu > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Repeating autovacuum > >=20 > It would be interesting to see the timestamps on those log entries... >=20 > 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 data= base 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, lim= ited by database with OID 12401 2017-04-08 15:52:34 +03DEBUG: MultiXactId wrap limit is 2147483648, limite= d 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, limite= d by database with OID 16526 2017-04-08 15:52:34 +03LOG: MultiXact member wraparound protections are no= w enabled 2017-04-08 15:52:34 +03DEBUG: MultiXact member stop limit is now 429491494= 4 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 configura= tion 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_12= 401.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_16= 526.stat" 2017-04-08 15:52:34 +03DEBUG: removing permanent stats file "pg_stat/db_16= 461.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/globa= l.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=3D7048 socket=3D5072 2017-04-08 15:52:34 +03LOG: connection received: host=3D::1 port=3D58851 2017-04-08 15:52:34 +03LOG: connection authorized: user=3DDESKTOP-L63HSP2$= database=3Dpostgres 2017-04-08 15:52:35 +03DEBUG: server process (PID 7048) exited with exit c= ode 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.sta= t" 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 c= ode 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.sta= t" 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.sta= t" 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.sta= t" 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 c= ode 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.sta= t" 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.sta= t" 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=3D19448 socket=3D5024 2017-04-08 15:54:44 +03LOG: connection received: host=3D::1 port=3D58984 2017-04-08 15:54:44 +03LOG: connection authorized: user=3Dpostgres databas= e=3Dtracker 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.sta= t" 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=3D18744 socket=3D5032 2017-04-08 15:54:54 +03LOG: connection received: host=3D::1 port=3D58994 2017-04-08 15:54:54 +03LOG: connection authorized: user=3Dpostgres databas= e=3Dtracker 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.sta= t" 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 c= ode 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=3D14356 socket=3D5032 2017-04-08 15:55:27 +03LOG: connection received: host=3D::1 port=3D59027 2017-04-08 15:55:27 +03LOG: connection authorized: user=3Dpostgres databas= e=3Dtracker 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.sta= t" 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.sta= t" 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.sta= t" 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 c= ode 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.sta= t" 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.sta= t" 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.sta= t" 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.sta= t" 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 c= ode 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.sta= t" 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 c= ode 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.sta= t" 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 c= ode 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.sta= t" 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.sta= t" 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 c= ode 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.sta= t" 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 c= ode 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.sta= t" 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 co= de 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.sta= t" 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 c= ode 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" ----- --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin