Re: How to find the table which is not used in recent 3 month?

Поиск
Список
Период
Сортировка
От Fabio Pardi
Тема Re: How to find the table which is not used in recent 3 month?
Дата
Msg-id e8f169bf-ee3a-6eed-1622-a1fd7b853c26@portavita.eu
обсуждение исходный текст
Ответ на How to find the table which is not used in recent 3 month?  (Frantz Song <frantz.song@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi Frantz,


If 'used' means 'written', then I think it might be an idea to look at the youngest 'xmin' in the table, to know when it was last modified together with keeping a log of what xmin is associated to each day.


regards,

fabio pardi



On 31/12/2018 07:30, Frantz Song wrote:
Dear all,

I'm use postgresql 9.6, it have 800+tables and some of them is not frequently used. 
How to find the table which is not used in recent 3 month? 

Thanks!

--
P Help save trees...please don't print this e-mail unless you really need to.

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

Предыдущее
От: Shreeyansh Dba
Дата:
Сообщение: Re: How to find the table which is not used in recent 3 month?
Следующее
От: Fabio Pardi
Дата:
Сообщение: Re: How to find the table which is not used in recent 3 month?