Long time ago I wrote first version of explain.depesz.com. Since then I gradually improve it. But, what was lacking was a way to paste queries too - explain.depesz.com handles explains, but not plain queries. Now this has changed. I created new ...

As of now, main table that stores explain.depesz.com plans is partitioned. This shouldn't be, at all, visible for users of the site, but if it would, please let me know (on irc, or via email). In case you're wondering why, after all ...

Quite a long time ago (in October), Oskar Liljeblad reported a bug in anonymization. Namely - group keys were not anonymized. You can see example of such plan here. I finally got to it, fixed the bug, pushed new version to live ...

Some time ago I was contacted by Adam Smith - he pointed out that subquery names in "Subquery Scan" nodes were not properly anonymized. Now, they are, which you can see in here: normal version anonymized version While working on it, I also added ...

Some time ago Karl Bartel asked me to add ability to parse plans that were done using "ANALYZE ON, TIMING OFF". Initially I didn't see the point, but he said that explain.depesz.com allows him to hide parts of the tree, ...

This time the changes do not modify how the website works. But they make it simpler to deploy clone of explain.depesz.com on your own server. Thanks to Petr A. Korobeinikov I got full automation for setting test/development/internal clones of the site. ...

There are some cases where you might want to get your own copy of explain.depesz.com. You might not trust me with your explains. You might want to use it without internet access. Or you just want to play with it, ...

Uploaded new version to the server - straight from GitHub. There are two changes - one visible, and one not really. The invisible change, first, is one for people hosting explain.depesz.com on their own. As you perhaps know you can get ...

A colleague recently let me know that anonymization in explain.depesz.com doesn't handle CTE names. For example, in plan: ...

I just updated explain.depesz.com - my tool for analysis of explain analyze plans. New feature is: you can now create accounts.