From: Matthias Leisi <matthias@leisi.net>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_4AB69AE3-64D9-4ED0-8508-4AD13118C054"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.200.81.1.6\))
Subject: Re: Record last SELECT on a row?
Date: Wed, 17 Dec 2025 17:25:10 +0100
References: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net>
 <CANzqJaAAxnwa+KMiPDJsm=z=1g8HTskE2B2B-ZPG3SJ+=A4+=A@mail.gmail.com>
To: pgsql-general <pgsql-general@postgresql.org>
In-Reply-To: <CANzqJaAAxnwa+KMiPDJsm=z=1g8HTskE2B2B-ZPG3SJ+=A4+=A@mail.gmail.com>
Message-Id: <E680D170-8CDB-47B6-9354-2DF8FF7CB1ED@leisi.net>
Archived-At: <https://www.postgresql.org/message-id/E680D170-8CDB-47B6-9354-2DF8FF7CB1ED%40leisi.net>
Precedence: bulk


--Apple-Mail=_4AB69AE3-64D9-4ED0-8508-4AD13118C054
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8


> 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=E2=80=99s 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,
=E2=80=94 Matthias


--Apple-Mail=_4AB69AE3-64D9-4ED0-8508-4AD13118C054
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html aria-label=3D"message body"><head><meta http-equiv=3D"content-type" =
content=3D"text/html; charset=3Dutf-8"></head><body =
style=3D"overflow-wrap: break-word; -webkit-nbsp-mode: space; =
line-break: after-white-space;"><div><br><blockquote =
type=3D"cite"><div><div dir=3D"ltr"><div class=3D"gmail_quote =
gmail_quote_container"><div>pgaudit might satisfy your needs, since it =
would only log SELECT statements on that one table.&nbsp; You'd still =
have to grep the log file, so the information wouldn't be real-time, but =
that's <i>probably</i>&nbsp;not =
important.</div></div></div></div></blockquote><div><br></div>That=E2=80=99=
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.</div><div><br></div><div>Thanks,</div><div>=E2=80=94 =
Matthias</div><div><br></div></body></html>=

--Apple-Mail=_4AB69AE3-64D9-4ED0-8508-4AD13118C054--