Re: Record last SELECT on a row?

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-12-17T17:13:33Z
Lists: pgsql-general
On Wed, Dec 17, 2025 at 10:24 AM Ron Johnson <ronljohnsonjr@gmail.com>
wrote:

> 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 would only give you table-level information, unless it was a
dirt-simple query with no joins and an easy to parse where clause.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support