pev2 icon indicating copy to clipboard operation
pev2 copied to clipboard

Shared blocks stats query summary

Open danydev opened this issue 2 years ago • 2 comments

In order to tell at first glance the magnitude of the IO produced by a query, would be great to have a summary of the shared blocks stats, like "total read" and "total hit" (both blocks number and Mb)

Maybe the best place would be under Plan section, when viewing the "buffers" tree

danydev avatar Nov 11 '22 11:11 danydev

Same suggestion.

I'm currently comparing a lot of plans before and after an optimization, and the cumulated values of Hit/Read/IO Time are the 1st thing that I would like to see.

Rights of "Planning time" , at the bottom of the left panel or in the Stats tab ?

Krysztophe avatar Jun 01 '23 12:06 Krysztophe

I'm just doing this (IO optimization), and the Stats tab is definitely the first place to add this information.

And a sum of shared hits at the bottom of the new Grid tab would be nice.

Krysztophe avatar Apr 18 '24 12:04 Krysztophe