Re: Findout long unused tables in database

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Findout long unused tables in database
Date: 2022-09-27 06:35:39
Message-ID: bf5d2650-53b4-0908-40ed-2d26024bc712@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

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