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
