Re: Use instr_time for pg_stat_database block read/write time counters

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Bernd Reiß <bd_reiss(at)gmx(dot)at>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, gouda0x(at)gmail(dot)com, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Use instr_time for pg_stat_database block read/write time counters
Date: 2026-10-01 22:57:38
Message-ID: ar7lYmpCrQGAHsCm@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 28, 2026 at 02:24:52PM +0200, Bernd Reiß wrote:
> @@ -125,7 +125,7 @@ pgstat_count_io_op_time(IOObject io_object, IOContext io_context, IOOp io_op,
> {
> if (io_op == IOOP_WRITE || io_op == IOOP_EXTEND)
> {
> - pgstat_count_buffer_write_time(INSTR_TIME_GET_MICROSEC(io_time));
> + INSTR_TIME_ADD(pgStatBlockWriteTime, io_time);
> if (io_object == IOOBJECT_RELATION)
> INSTR_TIME_ADD(pgBufferUsage.shared_blk_write_time, io_time);
> else if (io_object == IOOBJECT_TEMP_RELATION)
> @@ -133,7 +133,7 @@ pgstat_count_io_op_time(IOObject io_object, IOContext io_context, IOOp io_op,
> }
> else if (io_op == IOOP_READ)
> {
> - pgstat_count_buffer_read_time(INSTR_TIME_GET_MICROSEC(io_time));
> + INSTR_TIME_ADD(pgStatBlockReadTime, io_time);
> if (io_object == IOOBJECT_RELATION)
> INSTR_TIME_ADD(pgBufferUsage.shared_blk_read_time, io_time);
> else if (io_object == IOOBJECT_TEMP_RELATION)

Hmm. This part of the patch touches a performance-sensitive area.
This is exchanging one addition for another, which I doubt really
matters, but who knows.. Andres, any thoughts perhaps?
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-10-01 23:07:37 Re: Partial indexes on system catalogs
Previous Message Michael Paquier 2026-10-01 22:45:37 Re: Report index currently being vacuumed in pg_stat_progress_vacuum