Just pushed some new changes to expain.depesz.com and it’s underlying parsing library. The changes are: If you upload plan in JSON/YAML/XML format, and then you’ll look at “TEXT” tab, you will see explain in text format, generated using data from JSON. This explain had slight error in number formatting (3 decimal digits for estimated costs, … Continue reading “Changes on explain.depesz.com”
Couple of days ago RhodiumToad reported, on irc, a bug in explain.depesz.com. Specifically – if explain was done using JSON/XML/YAML formats, and node type was Aggregate, the site didn’t extract full info.
Just now pushed new version of Pg::Explain Perl library that is handling parsing for explain.depesz.com. There have been many changes, but the short summary is: Fix display of heap fetches from json (https://gitlab.com/depesz/explain.depesz.com/issues/15) Move global data (planning/execution/total time, trigger info) from top_node to explain object itself Add method to easily get real total, wall-clock, runtime … Continue reading “New Pg::Explain and explain.depesz.com”
On 16th of September 2019, Alexander Korotkov committed two patches: First patch: Support for SSSSS datetime format pattern SQL Standard 2016 defines SSSSS format pattern for seconds past midnight in jsonpath .datetime() method and CAST (… FORMAT …) SQL clause. In our datetime parsing engine we currently support it with SSSS name. This … Continue reading “Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns”
On 8th of March, Alvaro Herrera committed patch: XMLTABLE is defined by the SQL/XML standard as a feature that allows turning XML-formatted data into relational form, so that it can be used as a <table primary> in the FROM clause of a query. This new construct provides significant simplicity and performance benefit for XML … Continue reading “Waiting for PostgreSQL 10 – Support XMLTABLE query expression”
During my time with PostgreSQL I found some things that I love. I found some things that I hate (very little of them). And some things that I would like to get, but, so far, I don’t have them. Of course, PostgreSQL being Open Source, I could add it myself, if only I would know … Continue reading “My personal PostgreSQL Wish List”
There are some cases where you might want to get your own copy of explain.depesz.com. You might not trust me with your explains. You might want to use it without internet access. Or you just want to play with it, and have total control over the site. Installing, while obvious to me, and recently described … Continue reading “How to install your own copy of explain.depesz.com”
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 way (object).
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 gets the basic structure in place. Robert Haas