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
