Horton

[PATCH] Change wait_time column of pg_stat_lock to double precision

Tatsuya Kawata <kawatatatsuya0913@gmail.com>

View thread View on postgr.es
From: Tatsuya Kawata <kawatatatsuya0913@gmail.com>
To: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-15T06:54:24Z
Lists: pgsql-hackers

Attachments

Hi,

While looking at the lock-related code, I noticed that pg_stat_lock
is the only statistics view whose timing column (wait_time) uses
bigint.  Every other statistics view uses double precision for
measured-time columns.  I do not see a reason for pg_stat_lock to
differ.

The attached patch changes the column to double precision.

Regards,
Tatsuya Kawata

Commits

  1. Change stat_lock.wait_time to double precision