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

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.