On Friday, Zr40 reported on irc that explain.depesz.com doesn't show table/index names for Parallel Seq Scan nodes. Checked it and found couple of other omissions of the same kind with other Parallel* scans. Fixed (I hope) all of them in: Pg::Explain plan parsing ...

Bricklen Anderson reported a problem with explains that were using parallel processing. TL;DR: in case of parallel plans make "inclusive" and "exclusive" be wall-clock times, and not "how much time CPU did spend on it".

June 22nd, 2017 by depesz | Tags: , , , | Comments Off on explain.depesz.com, paste.depesz.com – TOR announcement and some updates

I assume that you're familiar with explain.depesz.com and paste.depesz.com services. From today they are also available as services in TOR, using respectively: explain4pg4j5wbw.onion and paste4sql64vzyry.onion (of course you need to have TOR Browser or some other way to browse darknet). Why I ...

May 19th, 2017 by depesz | Tags: , , , | Comments Off on New change on explain.depesz.com

Some (long) time ago, someone on irc suggested that I add option to keep track of optimizations of queries. Sorry, I forgot your name, and the mails disappeared in some crash. Anyway - right now, when you are on some plan page, ...

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 ...

April 5th, 2016 by depesz | Tags: , , | Comments Off on Change on explain.depesz.com

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 ...

February 8th, 2016 by depesz | Tags: , , | Comments Off on explain.depesz.com – new change and some stats

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 ...

October 13th, 2015 by depesz | Tags: , , , | Comments Off on explain.depesz.com changes and new stats

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, ...

January 8th, 2015 by depesz | Tags: , , , | Comments Off on Changes in explain.depesz.com

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. ...