Re: determining which table is being vacuumed by autovacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: determining which table is being vacuumed by autovacuum
Дата
Msg-id 16624.1187842205@sss.pgh.pa.us
обсуждение исходный текст
Ответ на determining which table is being vacuumed by autovacuum  (Kevin Kempter <kevin@kevinkempterllc.com>)
Ответы Re: determining which table is being vacuumed by autovacuum (SOLVED)  (Kevin Kempter <kevin@kevinkempterllc.com>)
Список pgsql-admin
Kevin Kempter <kevin@kevinkempterllc.com> writes:
> Then I ran this:

> postgres=# select relation from pg_locks where pid = 9902;
>  relation
> -----------
>   82097999
>  143763216
>  143763215
>  143763193
>  143763193
>  143763217
> (7 rows)

> However none of these seem to have a corresponding pg_class oid, see
> the below queries:

This most likely means that the vacuum is happening in a different
database than you are looking in.  Did you check
pg_stat_activity.datname?

            regards, tom lane

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

Предыдущее
От: "Tena Sakai"
Дата:
Сообщение: Re: tar, but not gnu tar
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: tar, but not gnu tar