explain.depesz.com – update

I just updated explain.depesz.com with 2 new interface features:

  • When you put mouse cursor over node, it will mark direct child nodes with
  • When you click on node, all child nodes (even indirect) will be hidden, and the node you clicked on will be marked with

Both features are directed towards people who analyze longer plans – ability to hide parts or just visually see what the Nested Loop is calling in 2nd stage greatly helps me see the flow of query – you can test it, for example, here.

By the way – BIG THANK YOU for Metys for help on it (well, actually, for doing it).

4 thoughts on “explain.depesz.com – update”

  1. Sorry for the OT, bbut your blog is somehow spammed (I assume you didn’t do that), take a look at the source of the page. I’ve noticed that while viewing in rss reader.

  2. I heard about this already, but there is no such spam on blog. I think it’s an issue with feedburner. I will turn it off, but not in the next 2 weeks.

  3. Take a look at the source I see it starting just after div id=”page” class=”clearfix”
    (feel free to remove those comments, as they doesn’t have much to do with posts itself)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.