Buffer pool statistics in Explain Analyze

From: "Vladimir Sitnikov" <sitnikov(dot)vladimir(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Buffer pool statistics in Explain Analyze
Date: 2008-10-11 23:24:39
Message-ID: 1d709ecc0810111624i7419b179v1789b2ca681987c0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I believe it makes sense adding some more details to explain analyze output
like the number of pages read/written.
This will allow one to understand the workload the query puts on the server
making it easier to tune queries, choose the best indices, etc.

As far as I understand, this patch is rather trivial as
backend\storage\buffer collects the required information. The only thing is
to add several fields to the struct Instrumentation
(include\executor\instrument.h), fill them in during Instr* calls in
(backend\executor\instrument.c) and update backend\commands\explain.c to
report the collected data.

I think think this change is going to split page access statistics by each
and every execution node (much like 'actual time' is split now).

Will this patch ever be accepted?

Regards,
Vladimir Sitnikov

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2008-10-11 23:52:13 Version Number Function?
Previous Message Tom Lane 2008-10-11 23:03:48 Re: recursive query crash