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