January 13th, 2010 by depesz | Tags: , , , | 6 comments »
Did it help? If yes - maybe you can help me?

I just checked, and apparently explain.depesz.com is online for over a year now. First plans was added on 2008-12-04 13:20:43+01.

Since then there have been 3602 plans added, 770 of them were set to be private (not displayed on previous explains page.

Longest plan has 2267194 characters (yes, 2.2 megabytes of explain analyze output!), but it's not public, so I can't tell you the url. Longest public plan is this monstrosity, which (while being only explain output, not explain analyze) has 503585 characters.

During this time, there have been 61 days that nobody added any plan on (perhaps problems with software?).

The most heavily used day was 23rd of June 2009, when 71 new plans have been added (4 private).

Thank you all for using it. I hope you find it useful, and I promise, that one day, I will finally sit down, and add all long-due features (like work with new explain formats, fixing some output glitches, stats of used objects per plan).

If you'd like to take a peek at how it works – source of explain.depesz.com is always available.

  1. 6 comments

  2. # Screwtape
    Jan 14, 2010

    I’ve often thought I should write some code that takes the output of EXPLAIN ANALYZE and turns it into a GraphViz file, to visualise the flow of information through all the rows, much like SQL Server’s Query Analyzer:

    http://windowsitpro.com/Files/3757/Screen_03.GIF

    Bonus points if the width of each arrow is based on the number of rows returned from that node, or the cumulative time taken to process it and all its children.

  3. # Lafriks
    Jan 14, 2010

    Screwtape: pgAdmin3 has also quite good at visualising the flow:

    http://www.postgresonline.com/images/journal/explain_plan_5.png

  4. # Konstantin
    Jan 14, 2010

    There is 404 currently

  5. Jan 14, 2010

    Konstantin – sorry – server migration gone bad. should be back in 10 minutes – dns refresh

  6. # yourpage
    Feb 23, 2010

    Your explain.depesz.com page is showing “Bad Gateway” at the moment.

  7. Feb 23, 2010

    @yourpage:
    sorry – had technical difficulties on the server. it should be fixed now.

Leave a comment