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

From Matthias Leisi
Subject Re: Record last SELECT on a row?
Date
Msg-id E680D170-8CDB-47B6-9354-2DF8FF7CB1ED@leisi.net
Whole thread Raw
In response to Re: Record last SELECT on a row?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Record last SELECT on a row?
List 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

pgsql-general by date:

Previous
From: "Colin 't Hart"
Date:
Subject: Re: wal segment size
Next
From: Adrian Klaver
Date:
Subject: Re: wal segment size