Quick Links

Findout long unused tables in database

From:	Andreas Fröde <psql(at)andreas(dot)spider-net(dot)de>
To:	pgsql-general(at)lists(dot)postgresql(dot)org
Subject:	Findout long unused tables in database
Date:	2022-09-26 12:05:55
Message-ID:	3d837584-aca0-a8c1-a78b-442071ec723f@andreas.spider-net.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

CIAO
andreas

Responses

Re: Findout long unused tables in database at 2022-09-27 04:25:13 from Laurenz Albe
Re: Findout long unused tables in database at 2022-09-27 06:35:39 from Andreas Kretschmer

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bryn Llewellyn	2022-09-26 18:18:34	Limiting the operations that client-side code can perform upon its database backend's artifacts
Previous Message	Laurenz Albe	2022-09-26 10:49:15	Re: Support functions for range types