Re: [ADMIN] Repeating autovacuum

Поиск
Список
Период
Сортировка
От Ertan Küçükoğlu
Тема Re: [ADMIN] Repeating autovacuum
Дата
Msg-id 00bd01d2b08e$6cba50c0$462ef240$@1nar.com.tr
обсуждение исходный текст
Ответ на Re: [ADMIN] Repeating autovacuum  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of David G. Johnston
> Sent: Saturday, April 8, 2017 1:53 AM
> To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
> Cc: pgsql-admin@postgresql.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"
-----



В списке pgsql-admin по дате отправления:

Предыдущее
От: Thorsten Schöning
Дата:
Сообщение: Re: [ADMIN] pg_dump with custom format without compression
Следующее
От: Günce Kaya
Дата:
Сообщение: Re: [GENERAL] [ADMIN] calculating table and index size