Postgres Pro
Downloads
Home   >   mailing lists

Re: Findout long unused tables in database - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Findout long unused tables in database
Date
Msg-id bf5d2650-53b4-0908-40ed-2d26024bc712@a-kretschmer.de
Whole thread Raw
In response to Findout long unused tables in database  (Andreas Fröde <psql@andreas.spider-net.de>)
Responses Re: Findout long unused tables in database
Re: Findout long unused tables in database
List pgsql-general
Tree view 

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.



Regards, Andreas

-- 
Andreas Kretschmer
Technical Account Manager (TAM)
www.enterprisedb.com

pgsql-general by date:

Previous
From: Andreas Fröde
Date:
Subject: Re: Findout long unused tables in database
Next
From: Julien Rouhaud
Date:
Subject: Re: Limiting the operations that client-side code can perform upon its database backend's artifacts