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:
- initial commit adding support for obfuscation of queries in Pg::Explain library
- bugfix for missing whitespace in queries after obfuscation
- site changes, including:
- db schema change
- support for adding queries
- support for display of queries
Hope you'll find it useful.