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./