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

From: Adarsh Sharma <eddy(dot)adarsh(at)gmail(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:50:35
Message-ID: CAGx-QqLL+uK_1-GzdCtgaT6DS6iooQr_sWCMq96zhDne5X1bWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

If you are keeping the pg_log files, may be using grep for the respective
tables will help.

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Prince Pathria 2018-12-31 06:52:34 Re: How to find the table which is not used in recent 3 month?
Previous Message Frantz Song 2018-12-31 06:30:17 How to find the table which is not used in recent 3 month?