Horton

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

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Cc: Tatsuya Kawata <kawatatatsuya0913@gmail.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2026-06-29T04:52:54Z
Lists: pgsql-hackers 
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.  FWIW,
that does not bother me much.  It's just more important to me to apply
the same formulas across the board.
--
Michael

Commits

  1. Change stat_lock.wait_time to double precision