Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find the table which is not used in recent 3 month? - Mailing list pgsql-admin

From Fabio Pardi
Subject Re: How to find the table which is not used in recent 3 month?
Date
Msg-id e8f169bf-ee3a-6eed-1622-a1fd7b853c26@portavita.eu
Whole thread Raw
In response to How to find the table which is not used in recent 3 month?  (Frantz Song <frantz.song@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: How to find the table which is not used in recent 3 month?
Next
From: Fabio Pardi
Date:
Subject: Re: How to find the table which is not used in recent 3 month?