Re: How to find the table which is not used in recent 3 month?
| От | Fabio Pardi |
|---|---|
| Тема | Re: How to find the table which is not used in recent 3 month? |
| Дата | |
| Msg-id | e673369c-defb-d136-330e-9af50cb79d02@portavita.eu обсуждение исходный текст |
| Ответ на | How to find the table which is not used in recent 3 month? (Frantz Song <frantz.song@gmail.com>) |
| Список | pgsql-admin |
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
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.Fabio Pardi <f.pardi@portavita.eu> 于2018年12月31日周一 下午5:22写道：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 pardiOn 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.
В списке pgsql-admin по дате отправления: