Re: Is it possible to keep track of SELECTs?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is it possible to keep track of SELECTs?
Date: 2024-03-12 16:29:41
Message-ID: 202403121629.ukxkmq4vldhm@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2024-Mar-12, Dominique Devienne wrote:

> So is it possible to track the last time a SELECT was performed on some
> TABLE?

Perhaps you could use the pgAudit module for this purpose.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-03-13 02:14:08 Fwd: Receipt for PostgreSQL US Invoice #1840
Previous Message Avi Weinberg 2024-03-12 15:57:48 RE: [External] Simple way to simulate a bug in logical replication