Re: WIP: log query in auto-explain

Itagaki Takahiro wrote:
> Andrew Dunstan <andrew@dunslane.net> wrote:
>
>   
>> Basically it includes the text of the query being explained in the 
>> explain output.
>>     
>
> I expected the query text is printed in "STATEMENT" section.
> Do you mean the query should be merged into "LOG" section?
> Are there any situation where "STATEMENT" section does not work?
>   


I mean it should be in the Explain output:

    <explain xmlns="http://www.postgresql.org/2009/explain">
      <Query-Text>SELECT '' AS zero, BOOLTBL1.*
       FROM BOOLTBL1
       WHERE booleq(bool 'false', f1);</Query-Text>
      <Plan>
        <Node-Type>Seq Scan</Node-Type>
        <Relation-Name>booltbl1</Relation-Name>
        <Alias>booltbl1</Alias>
        <Startup-Cost>0.00</Startup-Cost>
        <Total-Cost>42.88</Total-Cost>
        <Plan-Rows>877</Plan-Rows>
        <Plan-Width>1</Plan-Width>
        <Filter>booleq(false, f1)</Filter>
      </Plan>
    </explain>

This is especially important for structured output like XML and/or JSON. 
A number of users (including me) badly want to be able to extract the 
explain output from the log files with the query text included.

cheers

andrew


>