Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting?

Поиск
Список
Период
Сортировка
От raghu ram
Тема Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting?
Дата
Msg-id BANLkTimeo-P+=fxKzui1Md2Siq_YJ7ASug@mail.gmail.com
обсуждение исходный текст
Ответ на since when has pg_stat_user_indexes.idx_scan been counting?  (Willy-Bas Loos <willybas@gmail.com>)
Список pgsql-performance
Дерево обсуждения


On Thu, May 12, 2011 at 9:09 PM, Willy-Bas Loos <willybas@gmail.com> wrote:
Hi,

We have some indexes that don't seem to be used at all.
I'd like to know since when they have not been used.
That is, the time when postgres started counting to reach the number that is in pg_stat_user_indexes.idx_scan

Is there a way to retrieve that from the database ?


"Analyze" activity will update the statistics of each catalog table.

pg_postmaster_start_time --> Retrieves the Postmaster [ PostgreSQL Instance] start time

postgres=# select pg_postmaster_start_time();

--Raghu Ram

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

Предыдущее
От: Lucas Madar
Дата:
Сообщение: Re: Poor performance when joining against inherited tables
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting?