Date: Fri, 20 Feb 2026 17:26:37 +0000
From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Michael Paquier <michael@paquier.xyz>, Jeff Davis <pgsql@j-davis.com>,
	Greg Sabino Mullane <htamfids@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: Adding locks statistics
Message-ID: <aZiZTX1l5pX+BOXn@ip-10-97-1-34.eu-west-3.compute.internal>
References: <aY7UmTIiBScP4rAq@paquier.xyz>
 <aY779Gu3rQwJ4Erq@ip-10-97-1-34.eu-west-3.compute.internal>
 <aY-MRFnzTDJO265s@alap3.anarazel.de>
 <aZLtDbGEqSN2MuRb@ip-10-97-1-34.eu-west-3.compute.internal>
 <otjn7ykaezlueayyp7fppggkldw23ykh3i6ite2rqq4xh7dwvl@w5dvqqgvqf25>
 <aZSYcsRmqh7grqJb@ip-10-97-1-34.eu-west-3.compute.internal>
 <aZaMXK90sRjSQBJP@paquier.xyz>
 <v76tz252usppu2turrn6wxiyyxmybzxhqck5b3amtsbzrc6yto@n26qnwvpkxqw>
 <aZgBTyzxWmPJL0Tt@ip-10-97-1-34.eu-west-3.compute.internal>
 <isi5wszczhusgjetxwe6khxa5mbm5jms3msmbhwl73jktxw7ic@3mympoumua76>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <isi5wszczhusgjetxwe6khxa5mbm5jms3msmbhwl73jktxw7ic@3mympoumua76>
Archived-At: <https://www.postgresql.org/message-id/aZiZTX1l5pX%2BBOXn%40ip-10-97-1-34.eu-west-3.compute.internal>
Precedence: bulk

Hi,

On Fri, Feb 20, 2026 at 11:02:49AM -0500, Andres Freund wrote:
> Hi,
> 
> On 2026-02-20 06:38:07 +0000, Bertrand Drouvot wrote:
> > > If the delay is very
> > > short it's probably also not that interesting to track, but I guess that's
> > > debatable.
> > 
> > v6 was introducing timed_waits so that we have:
> > 
> > waits
> > timed_waits
> > wait_time
> > fastpath_exceeded
> > 
> > timed_waits and wait_time were incremented together and waits was incremented
> > unconditionally. I like the idea of being able to track the numbers of waits
> > whatever the value of log_lock_waits (or the new track_lock_timing) is. Also
> > one could compare waits vs timed_waits.
> 
> How could a user benefit from that split? To me this is pointless number
> gathering that wastes resources and confuses users.

I was thinking that could be useful to know the distribution between "long" waits
(greater than the deadlock timeout) among all the waits.

If the vast majority are long waits that may indicate that the application is
misbehaving (as opposed to a tiny percentage of long waits).

I was also thinking to bring those stats per-backend (as a next step) and that
could also probably be more useful (distribution per host for example, thanks to
joining with pg_stat_activity).

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com