You can now add query to your plan on explain.depesz.com

Quite a lot of people have been bugging me about it, and finally got some time, and worked on it.

Long story short – it works.

You can add your query below plan (in separate text area), and then it will be displayed as one of tabs

For example, check this plan.

It also works sensibly-ish, if you want to obfuscate your plans, as you can see here.

In case you're interested in technical details …

Whole work is in three commits:

  1. initial commit adding support for obfuscation of queries in Pg::Explain library
  2. bugfix for missing whitespace in queries after obfuscation
  3. site changes, including:
    • db schema change
    • support for adding queries
    • support for display of queries

Hope you'll find it useful.

Leave a Reply

Your email address will not be published.

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