Re: How to find the table which is not used in recent 3 month?

Hi all,

maybe a tool such as pgbadger help getting stats from logs ?

Kind regards

Sylvain

Le lun. 31 déc. 2018 à 07:52, Prince Pathria <prince(dot)pathria(at)goevive(dot)com> a
écrit :

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