Re: [PATCH] Change wait_time column of pg_stat_lock to double precision
От
Bertrand Drouvot
Тема
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision
Дата
Msg-id
akH668FoacFKlLPY@bdtpg
Ответ на
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision (Michael Paquier)
Список
Дерево обсуждения
[PATCH] Change wait_time column of pg_stat_lock to double precision Tatsuya Kawata <kawatatatsuya0913@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Tatsuya Kawata <kawatatatsuya0913@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Tatsuya Kawata <kawatatatsuya0913@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Michael Paquier <michael@paquier.xyz>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Michael Paquier <michael@paquier.xyz>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision Tatsuya Kawata <kawatatatsuya0913@gmail.com>
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. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата: