• Fujii Masao's avatar
    Rework EXPLAIN for planner's buffer usage. · 9d701e62
    Fujii Masao authored
    Commit ce77abe6 allowed EXPLAIN (BUFFERS) to report the information
    on buffer usage during planning phase. However three issues were
    reported regarding this feature.
    
    (1) Previously, EXPLAIN option BUFFERS required ANALYZE. So the query
        had to be actually executed by specifying ANALYZE even when we
        want to see only the planner's buffer usage. This was inconvenient
        especially when the query was write one like DELETE.
    
    (2) EXPLAIN included the planner's buffer usage in summary
        information. So SUMMARY option had to be enabled to report that.
        Also this format was confusing.
    
    (3) The output structure for planning information was not consistent
        between TEXT format and the others. For example, "Planning" tag
        was output in JSON format, but not in TEXT format.
    
    For (1), this commit allows us to perform EXPLAIN (BUFFERS) without
    ANALYZE to report the planner's buffer usage.
    
    For (2), this commit changed EXPLAIN output so that the planner's
    buffer usage is reported before summary information.
    
    For (3), this commit made the output structure for planning
    information more consistent between the formats.
    
    Back-patch to v13 where the planner's buffer usage was allowed to
    be reported in EXPLAIN.
    
    Reported-by: Pierre Giraud, David Rowley
    Author: Fujii Masao
    Reviewed-by: David Rowley, Julien Rouhaud, Pierre Giraud
    Discussion: https://postgr.es/m/07b226e6-fa49-687f-b110-b7c37572f69e@dalibo.com
    9d701e62
explain.sql 3.71 KB