First of all – just today I committed patch for Pg::Explain – which is the workhorse behind explain.depesz.com.

This patch fixes calculation of exclusive time for explain nodes, and the best thing about it is – I didn't write it. It's full patch provided by someone else – Filip Rembiałkowski – my former colleague, friend, and PostgreSQL DBA (not olny PG!).

This is (as far as I recall) first patch that was provided to me for this library, and I'm really grateful for the contribution.

New version of Pg::Explain will hit CPAN mirrors shortly (it's already uploaded, now we're waiting for CPAN mirrors to get it).

When I was updating it, I checked state of database. And I learned that explain.depesz.com is over 2 years now! Some stats follow.

First explain was uploaded on 2008-12-04 13:20:43+01.

Up to this moment ( now() == 2010-12-18 19:49:39.675522+01 ) there is 10532 plans (yes, over 10K!!!). Out of this 3386 plans are not public – i.e. you can't see them on previous explain page.

As you can see, there is nice increase of new plans in 2010.

At the end of May 2009, I added non-public plans. Since then the number of “secret" plans per month is quite stable:

All in all – it seems to be used, and I've heard of at least two cases when people said that they will setup their own copies of explain.depesz.com for internal purposes (in case your plans can contain sensitive information).

In case you don't know – both explain parsing library and application code for the site are freely available under the same terms as Perl itself.

Finally – thanks for using the tool – it's really cool feeling to know that it's useful, and thanks again, Filip, for your contribution.