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