From: | Prince Pathria <prince(dot)pathria(at)goevive(dot)com> |
---|---|
To: | Frantz Song <frantz(dot)song(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to find the table which is not used in recent 3 month? |
Date: | 2018-12-31 06:52:34 |
Message-ID: | CAON0Daz4qZCaoYZOm66e4NxZp0=yPxJdbEu8+e5eRXZ4G9j1dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)song(at)gmail(dot)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.*
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sylvain Fauvel | 2018-12-31 08:49:07 | Re: How to find the table which is not used in recent 3 month? |
Previous Message | Adarsh Sharma | 2018-12-31 06:50:35 | Re: How to find the table which is not used in recent 3 month? |