I just checked, and apparently explain.depesz.com is online for over a year now. First plans was added on 2008-12-04 13:20:43+01. Since then there have been 3602 plans added, 770 of them were set to be private (not displayed on previous explains ...

Today small, but (at least for me) really useful patch. Committed on 15th of December by Robert Haas, and written by Itagaki Takahiro, this patch does: Log Message: ----------- Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics.   This patch also removes buffer-usage statistics ...

After very long discussions, on 10th of August, Tom Lane committed patch by Robert Haas: Log Message: ----------- Extend EXPLAIN to support output in XML or JSON format.   There are probably still some adjustments to be made in the details of the output, but this ...

I just updated explain.depesz.com with bugfix, which changes the way Bitmap Index Scan and Bitmap Heap Scan are displayed. Apparently index and table names were not shown previously. Thanks go to Viktor Rosenfeld for spotting and reporting the bug.

I just updated explain.depesz.com with 2 new interface features: When you put mouse cursor over node, it will mark direct child nodes with When you click on node, all child nodes (even indirect) ...

I just modified the internals of explain.depesz.com. Now, it finally stores the plans in database (previously it stored the plans as files in dedicated directory). Effect for enduser is just that history page should load faster. But, having the data in database ...

I just updated explain.depesz.com with the newest explain-parsing library version (Pg::Explain v 0.09). This version will hit CPAN mirrors in next couple of hours. Changes: Fix exclusive time calculations Make PE::Node understand Bitmap scans (heap and index) Add proper handling of nodes that were "never ...

After nearly 3 weeks of functioning, I just uploaded update to explain.depesz.com. New things are not really spectacular - I added help with proper explanation on what each color means and contact form in case somebody had ideas on what to ...

Long time ago I wrote small program to filter EXPLAIN ANALYZE output, and add summary of time. A bit later (I guess, I don't recall exact time line, it could have been earlier) Michael Glaesemann started explain-analyze.info - cool tool for ...

On 19th of November Tom Lane committed patch by Takahiro Itagaki which does: Add auto-explain contrib module for automatic logging of the plans of slow-running queries.