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!
--
PHelp save trees...please don't print this e-mail unless you really need to.
--
PHelp save trees...please don't print this e-mail unless you really need to.