[PATCH] Change wait_time column of pg_stat_lock to double precision

From: Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>
To: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] Change wait_time column of pg_stat_lock to double precision
Date: 2026-06-15 06:54:24
Message-ID: CAHza6qerEiQehrbW5xaXyxvR0qJe3KBX1R4kocDz1+7Ygu8x-g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
v1-0001-Change-wait_time-column-of-pg_stat_lock-to-double.patch application/octet-stream 5.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ZizhuanLiu X-MAN 2026-06-15 07:18:43 Re: Return value of XLogInsertRecord() for XLOG_SWITCH record
Previous Message jian he 2026-06-15 06:43:36 Re: Fix SET EXPRESSION for virtual columns with whole-row dependencies