pev2
pev2 copied to clipboard
Shared blocks stats query summary
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
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 ?
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.