Buffer pool statistics in Explain Analyze

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Buffer pool statistics in Explain Analyze
Дата
Msg-id 1d709ecc0810111624i7419b179v1789b2ca681987c0@mail.gmail.com
обсуждение исходный текст
Ответы Re: Buffer pool statistics in Explain Analyze  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
<div dir="ltr">Hi,<br /><br />I believe it makes sense adding some more details to explain analyze output like the
numberof pages read/written.<br />This will allow one to understand the workload the query puts on the server making it
easierto tune queries, choose the best indices, etc.<br /><br />As far as I understand, this patch is rather trivial as
backend\storage\buffercollects 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
updatebackend\commands\explain.c to report the collected data.<br /><div dir="ltr"><br />I think think this change is
goingto split page access statistics by each and every execution node (much like 'actual time' is split now).<br /><br
/>Willthis patch ever be accepted?<br /><br /><br />Regards,<br />Vladimir Sitnikov</div></div> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: recursive query crash
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Version Number Function?