Postgres Pro
Downloads
Home   >   mailing lists

Re: Tracking last scan time - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Tracking last scan time
Date
Msg-id Yw+kP+f49s/iLRR+@momjian.us
Whole thread Raw
In response to Re: Tracking last scan time  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, Aug 31, 2022 at 07:52:49PM +0200, Matthias van de Meent wrote:
> As for having a lower granularity and preventing the
> one-syscall-per-Relation issue, can't we reuse the query_start or
> state_change timestamps that appear in pg_stat_activity (potentially

Yeah, query start should be fine, but not transaction start time.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson

pgsql-hackers by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: [PATCH] Query Jumbling for CALL and SET utility statements
Next
From: Andres Freund
Date:
Subject: Re: [RFC] building postgres with meson - v12