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 e673369c-defb-d136-330e-9af50cb79d02@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,

please keep the list posted.

If you need also to track the reads, then I would follow Prince Pathria's suggestion about pg_stat_statements.

There are indeed also alternatives, but much depends on the setup, the workload, the real final goal..


good luck,

fabio pardi


On 31/12/2018 14:31, Frantz Song wrote:
Hi Fabio, 

thank you!

How about "read"? 
because i need also need clean the insert task if the table no one read. 


Fabio Pardi <f.pardi@portavita.eu> 于2018年12月31日周一 下午5:22写道:
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.



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

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

Предыдущее
От: Fabio Pardi
Дата:
Сообщение: Re: How to find the table which is not used in recent 3 month?
Следующее
От: rajan
Дата:
Сообщение: Is there any way that one of the Postgres Background/Utilityprocess may go down?