Postgres Pro
Downloads
Home   >   mailing lists

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

From Frantz Song
Subject How to find the table which is not used in recent 3 month?
Date
Msg-id CAKikDv2isFcJs3r53=gsjh81j18uSTFUVxLdC36mHzv+sa-_tg@mail.gmail.com
Whole thread Raw
Responses Re: How to find the table which is not used in recent 3 month?  (Adarsh Sharma <eddy.adarsh@gmail.com>)
Re: How to find the table which is not used in recent 3 month?  (Prince Pathria <prince.pathria@goevive.com>)
Re: How to find the table which is not used in recent 3 month?  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: How to find the table which is not used in recent 3 month?  (Fabio Pardi <f.pardi@portavita.eu>)
List pgsql-admin
Tree view
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: ZongtianHou
Date:
Subject: Re: Schema and Namespace Oid confusion
Next
From: Adarsh Sharma
Date:
Subject: Re: How to find the table which is not used in recent 3 month?