So, I made some changes to explain.depesz.com, and while informing about it, I'd like to brag a bit about numbers, again 🙂

First, the changes:

About two weeks ago xocolatl found a bug in anonymization code:

16:46 < xocolatl> there's a bug in the anonymization at line 12
16:47 < xocolatl> depesz: look at line 12 of https://explain.depesz.com/s/gcR  it's not anonymized

It took me a while to get to it, but finally today, I released new version of Pg::Explain perl library (this is what does parsing/anonymization of plans).

The change is very simple, this is how anonymized plan looked using old, 0.65, version, and this is how it looks like in newest, 0.66.

Second change is more visible. From now on, every plan can be deleted. When you create a plan, you will be given link, in form of https://explain.depesz.com/d/PLAN-ID/LONG-STRING

This link will be visible only once. If you'd enter the page with this link – plan you just created will be deleted. By deleted I mean: it's title, and plan itself will be removed, but the record in database will be left in place – to avoid reuse of plan ID.

So, if you're putting some very sensitive plans, you can afterwards delete them (of course if you trust me that explain.depesz.com does what I say it does).

Now, for the bragging part.

This is how number of plans in the database looks like:

The numbers don't sum up, because plan can be either public or private, anonymized or not. Still – it looks quite nicely like exponential growth.

Full table with lots of numbers below, but before that, I would like to thank you all that use explain.depesz.com – you made it possible. Thanks.

And the table with lots of numbers: