Re: Findout long unused tables in database

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Findout long unused tables in database
Дата
Msg-id bf5d2650-53b4-0908-40ed-2d26024bc712@a-kretschmer.de
обсуждение исходный текст
Ответ на Findout long unused tables in database  (Andreas Fröde <psql@andreas.spider-net.de>)
Ответы Re: Findout long unused tables in database  (Andreas Fröde <andreas@spider-net.de>)
Re: Findout long unused tables in database  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения 

Am 26.09.22 um 14:05 schrieb Andreas Fröde:
> Hello,
> I am looking for a way to find out when a table was last used for 
> reading. (Without writing every statement in the logfile or putting a 
> trigger on it). Is there such a thing?
>

no really what you are looking for, i know, but we have 
pg_stat_user_tables. There can you find how often the table was queried 
in the past. Take the data, wait some time, take it again and compare.



Regards, Andreas

-- 
Andreas Kretschmer
Technical Account Manager (TAM)
www.enterprisedb.com

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

Предыдущее
От: Andreas Fröde
Дата:
Сообщение: Re: Findout long unused tables in database
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Limiting the operations that client-side code can perform upon its database backend's artifacts