Re: Vacuumdb on a table

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Vacuumdb on a table
Дата
Msg-id 656F86ED-DB7D-4D9D-A94E-FC20C84B53EA@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Vacuumdb on a table  (Keith <keith@keithf4.com>)
Список pgsql-admin
> On Oct 18, 2023, at 10:31 PM, Keith <keith@keithf4.com> wrote:
>
> Check pg_stat_activity or pg_locks to see if there are any open transactions or locks on the table in question.

pg_stat_statements is good too

write a couple of queries to find:

- queries run most often
- queries that are slowest
- queries that are most executions x time

the first one is good for finding badly-behaved applications or scripts; the others can point out need for indexes




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

Предыдущее
От: Rajesh Kumar
Дата:
Сообщение: Cluster creation in Openshift container
Следующее
От: Tomek
Дата:
Сообщение: Re: Vacuumdb on a table