Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
Date
Msg-id 20230214002957.bfdg2we3ch6v7mqo@awork3.anarazel.de
Whole thread Raw
In response to Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS  (Andrey Borodin <amborodin86@gmail.com>)
Responses Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
List pgsql-hackers
Hi,

On 2023-02-13 16:23:30 -0800, Andrey Borodin wrote:
> But there are some caveats:
> 1. Some more increments on hot paths. We have to add this tiny toll to
> every single buffer hit, but it will be seldom of any use.

Additionally, I bet it slows down EXPLAIN (ANALYZE, BUFFERS) noticeably. It's
already quite expensive...


> All in all I do not have an opinion if this feature is a good tradeoff.
> What do you think? Does the feature look useful? Do we want a more
> polished implementation?

Unless the above issues could be avoided, I don't think so.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Add the ability to limit the amount of memory that can be allocated to backends.
Next
From: Andres Freund
Date:
Subject: Re: Make EXPLAIN generate a generic plan for a parameterized query