Hi, On Mon, Jun 15, 2026 at 04:39:22PM +0900, Kyotaro Horiguchi wrote: > Hello. > > At Mon, 15 Jun 2026 15:54:24 +0900, Tatsuya Kawata > <[email protected]> wrote in > > 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. > > It seems to me that this was intentional. As described in the > documentation, since wait_time is only accumulated for waits longer > than deadlock_timeout, sub-millisecond precision was probably not > considered particularly useful.
Yeah that was intentional (and for the reason you described above). Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
