Re: Record last SELECT on a row?

Matthias Leisi <matthias@leisi.net>

From: Matthias Leisi <matthias@leisi.net>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-12-17T16:25:10Z
Lists: pgsql-general
> pgaudit might satisfy your needs, since it would only log SELECT statements on that one table.  You'd still have to grep the log file, so the information wouldn't be real-time, but that's probably not important.

That’s a viable suggestion, thanks a lot. Real-time is indeed not necessary, a daily (or even a weekly) cleaning of unused data is sufficient. pgaudit was anyway on the table for some other use cases, so that would fit in nicely.

Thanks,
— Matthias