Re: Record last SELECT on a row? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Record last SELECT on a row?
Date
Msg-id CAKAnmmLLzi4eSRhj-g8JO8RFUrWwMaSmtrBSNtvqMOHCHquR+g@mail.gmail.com
Whole thread Raw
In response to Re: Record last SELECT on a row?  (Ron Johnson <ronljohnsonjr@gmail.com>)
List 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

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Record last SELECT on a row?
Next
From: Thiemo Kellner
Date:
Subject: Record last SELECT on a row?