Re: [Proposal] Add accumulated statistics for wait event - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [Proposal] Add accumulated statistics for wait event
Date
Msg-id 20210614182721.425j3xvsiphoq6ty@alap3.anarazel.de
Whole thread Raw
In response to Re: [Proposal] Add accumulated statistics for wait event  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Responses Re: [Proposal] Add accumulated statistics for wait event
Re: [Proposal] Add accumulated statistics for wait event
List pgsql-hackers
Hi,

On 2021-06-14 16:10:32 +0200, Jehan-Guillaume de Rorthais wrote:
> In the patch in attachment, I tried to fix this by using kind of an internal
> hook for pgstat_report_wait_start and pgstat_report_wait_end. This allows to
> "instrument" wait events only when required, on the fly, dynamically.

That's *far worse*. You're adding an indirect function call. Which requires
loading a global variable and then a far call to a different function. You're
changing a path that's ~2 instructions with minimal dependencies (and no
branches (i.e. fully out of order executable) to something on the order of ~15
instructions with plenty dependencies and at least two branches (call, ret).

I doubt there's a path towards this feature without adding the necessary
infrastructure to hot-patch the code - which is obviously quite a
substantial project.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Race condition in recovery?
Next
From: Andres Freund
Date:
Subject: Re: [Proposal] Add accumulated statistics for wait event