Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find the table which is not used in recent 3 month? - Mailing list pgsql-admin

From Prince Pathria
Subject Re: How to find the table which is not used in recent 3 month?
Date
Msg-id CAON0Daz4qZCaoYZOm66e4NxZp0=yPxJdbEu8+e5eRXZ4G9j1dw@mail.gmail.com
Whole thread Raw
In response to How to find the table which is not used in recent 3 month?  (Frantz Song <frantz.song@gmail.com>)
Responses Re: How to find the table which is not used in recent 3 month?  (Sylvain Fauvel <sylvain.fauvel@gmail.com>)
List pgsql-admin
Tree view
Hi Frantz,

For the same thing we have enabled "pg_stat_statements" on postgresql.conf. 
If you are not using "pg_stat_statements" as of now, sadly you're left with 2 options
1. Slow logs with lower response time, if you have enabled them, though not much trustworthy.
2. Grep in application logs of all apps using postgres as database backend.

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


On Mon, Dec 31, 2018 at 11:59 AM Frantz Song <frantz.song@gmail.com> 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.

pgsql-admin by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: How to find the table which is not used in recent 3 month?
Next
From: Sylvain Fauvel
Date:
Subject: Re: How to find the table which is not used in recent 3 month?