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

From Laurenz Albe
Subject Re: Findout long unused tables in database
Date
Msg-id fd9b5d4c8bb625f44d509eb7b9769490f2d5f368.camel@cybertec.at
Whole thread Raw
In response to Findout long unused tables in database  (Andreas Fröde <psql@andreas.spider-net.de>)
List pgsql-general
On Mon, 2022-09-26 at 14:05 +0200, Andreas Fröde wrote:
> 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, there is no way to do that short of logging all statements.

I expect that removing permissions on a table and checking whether
your application hits an error is not an option...

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



pgsql-general by date:

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