On 22nd of September, Tom Lane committed patch: Make EXPLAIN ANALYZE report the numbers of rows rejected by filter steps. This provides information about the numbers of tuples that were visited but not returned by table scans, as well as the numbers of ...
Just updated explain.depesz.com site with new functionality - when showing parsed plan, there is new tab "stats". In there you can see some basic statistics of the query, used types of nodes, and tables that were used by it. There are ...
First of all, as of today, I added new feature, called anonymization. It is for all of the people who are afraid that their plans contain information that they don't want to (or can't) share on the internet. It works like this:
Today, I released 2 new versions (new features in 0.5, and then quick bugfix in 0.51) of Pg::Explain Perl library. This is the base of explain.depesz.com - the code that does heavy lifting of parsing plans, and providing them in uniform ...
Thanks to enormous work done by Łukasz 'metys' Lewandowski, explain.depesz.com page is no longer "desiged by depesz" (which is a code for "ugly as hell"), but is nice, and good looking. If you like it, please do send some thank you ...
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 ...
This question (and its variants) show quite often on #postgresql on IRC. People get sequential scans, and are worried that it's slow and bad. So, I hope that this blogpost will shed some light on the subject why indexes are being ...
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 ...
