explain.depesz.com – now with HINTS!

I just pushed change to explain.depesz.com that allows for processing and displaying hints for plans.

For example, take a look at this plan, and check if you'll notice subtle “HINTS" tab.

In there you will see example hints – one about sort and memory, and the other about missing index.

It is not much, but it's a step in (hopefully) right direction, when the explain tool will also provide, automatically, some ideas on what to do to make the thing faster.

Hope you'll find it useful.

3 thoughts on “explain.depesz.com – now with HINTS!”

  1. This “Hints” is super helpful but I tried several different queries and explain plans on the page and none of them gave “hints”. Is there something that has to be done to enable the hints?

  2. @Joshua:
    No. Currently there are only two types of hints displayed:
    1. when there is disk based sorting
    2. where there is seq scan with simple condition on single column, and it is possible that it would be sped up by index.

    So, very, very limited number of hints.

    I plan on expanding it, in the future, but for now, it is what it is.

Leave a Reply

Your email address will not be published.

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