Horton

Rework EXPLAIN format for incremental sort

Tomas Vondra <tomas.vondra@postgresql.org>

View on postgr.es
Commit: 6a918c3ac8a6b1d8b53cead6fcb7cbd84eee5750
Author: Tomas Vondra <tomas.vondra@postgresql.org>
Date: 2020-05-12T18:04:39Z
Releases: 13.0 
Rework EXPLAIN format for incremental sort

The explain format used by incremental sort was somewhat inconsistent
with other nodes, making it harder to parse and understand. This commit
addresses that by

 - adding an extra space to better separate groups of values

 - using colons instead of equal signs to separate key/value

 - properly capitalizing first letter of a key

 - using separate lines for full and pre-sorted groups

These changes were proposed by Justin Pryzby and mostly copy the final
explain format used to report WAL usage.

Author: Justin Pryzby
Reviewed-by: James Coleman
Discussion: https://postgr.es/m/20200419023625.GP26953@telsasoft.com

Files

PathChange+/−
src/backend/commands/explain.c modified +9 −12
src/test/regress/expected/incremental_sort.out modified +11 −10
src/test/regress/sql/incremental_sort.sql modified +2 −2

Discussion