Wouldn’t it be amazing to have a I/O page visualizer for all that B+Tree output? omg that would be so good.
Conversation
Hmm no I don’t think so. I think a block visualizer or tree visualizer or something might be better? Like a heat map even?
2
I wrote a gnarly SQL query that does this: wiki.postgresql.org/wiki/Index_Mai. Also, you can use the similar GraphViz query here to get an SVG: github.com/petergeoghegan. The same idea is implemented another way here: github.com/louiseGrandjon.
I imagine that you could get an I/O latency heatmap using some generic mechanism. Not sure how you'd layer that on top of any of this stuff, though.