since when has pg_stat_user_indexes.idx_scan been counting?
От
Willy-Bas Loos
Тема
since when has pg_stat_user_indexes.idx_scan been counting?
Дата
Msg-id
BANLkTikhNLPhCjE819=RFG-+CB6UV4GbUA@mail.gmail.com
Список
Дерево обсуждения
since when has pg_stat_user_indexes.idx_scan been counting? Willy-Bas Loos <willybas@gmail.com>
Re: since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra <tv@fuzzy.cz>
Re: since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra <tv@fuzzy.cz>
Re: since when has pg_stat_user_indexes.idx_scan been counting? Greg Smith <greg@2ndquadrant.com>
Re: since when has pg_stat_user_indexes.idx_scan been counting? Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan
been counting? raghu ram <raghuchennuru@gmail.com>
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan
been counting? Willy-Bas Loos <willybas@gmail.com>
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan
been counting? Tomas Vondra <tv@fuzzy.cz>
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan
been counting? Greg Smith <greg@2ndquadrant.com>
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 ?
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
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 ?
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
В списке pgsql-performance по дате отправления
