[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Findout long unused tables in database
From:       Laurenz Albe <laurenz.albe () cybertec ! at>
Date:       2022-09-27 15:59:35
Message-ID: c71834dd9bad099909be176c0ad0bec70ca01e60.camel () cybertec ! at
[Download RAW message or body]

On Tue, 2022-09-27 at 08:35 +0200, Andreas Kretschmer wrote:
> 
> 
> Am 26.09.22 um 14:05 schrieb Andreas Fröde:
> > Hello,
> > I am looking for a way to find out when a table was last used for 
> > reading. (Without writing every statement in the logfile or putting a 
> > trigger on it). Is there such a thing?
> > 
> 
> no really what you are looking for, i know, but we have 
> pg_stat_user_tables. There can you find how often the table was queried 
> in the past. Take the data, wait some time, take it again and compare.

Ah, that is the best solution.  I should have thought of that.

Yours,
Laurenz Albe


[prev in list] [next in list] [prev in thread] [next in thread]