Re: [PATCH] Change wait_time column of pg_stat_lock to double precision

On Mon, Jun 29, 2026 at 04:56:11AM +0000, Bertrand Drouvot wrote:
> Hi,
>
> On Mon, Jun 29, 2026 at 01:52:54PM +0900, Michael Paquier wrote:
> > On Mon, Jun 29, 2026 at 04:27:55AM +0000, Bertrand Drouvot wrote:
> > > postgres=# select read_time from pg_stat_io where read_time > 0;
> > > read_time
> > > ---------------------
> > > 2.2640000000000002
> > > 0.08700000000000001
> > >
> > > Maybe it should be changed to?
> >
> > pg_stat_io with track_io_timing enabled shows the same thing.
>
> Yeah, I agree, my query above is querying pg_stat_io. I agree that it makes
> sense to have both using pg_stat_us_to_ms(), I'm just wondering if pg_stat_us_to_ms()
> should be changed as I did propose.

FWIW, I just created a dedicated thread [1] for this (to not deviate from the
original purpose of this one).

[1]: https://postgr.es/m/akIYkMK4bHe9qX/N%40bdtpg

Regards,

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