• T
    Show sort ordering options in EXPLAIN output. · 20af53d7
    Tom Lane 提交于
    Up to now, EXPLAIN has contented itself with printing the sort expressions
    in a Sort or Merge Append plan node.  This patch improves that by
    annotating the sort keys with COLLATE, DESC, USING, and/or NULLS FIRST/LAST
    whenever nondefault sort ordering options are used.  The output is now a
    reasonably close approximation of an ORDER BY clause equivalent to the
    plan's ordering.
    
    Marius Timmer, Lukas Kreft, and Arne Scheffer; reviewed by Mike Blackwell.
    Some additional hacking by me.
    20af53d7
aggregates.out 45.4 KB