Subject: Re: Planning counters in pg_stat_statements (using pgss_store)
To: legrand legrand <legrand_legrand@hotmail.com>,
 pgsql-hackers@postgresql.org
References: <20200331060307.e7kypfynz7jous62@nol>
 <ac44fd08-5923-c0f7-742d-952a6f5a14a3@oss.nttdata.com>
 <20200331073321.bhnx2p63gp5px37f@nol>
 <f2b4e098-1b96-e1a8-f601-a0908c9ff8c4@oss.nttdata.com>
 <20200331184217.tf3x534uz4vusgmp@nol>
 <bd27f039-5285-1fb7-5ed4-57f870c8a5a4@oss.nttdata.com>
 <13923268-bad9-80f9-2542-5fd5e8b8c500@oss.nttdata.com>
 <1585857868967-0.post@n3.nabble.com> <20200403072628.GB95652@nol>
 <5c9e0ca4-c378-57aa-1b08-49c83a41d5ec@oss.nttdata.com>
 <1586349174047-0.post@n3.nabble.com>
From: Fujii Masao <masao.fujii@oss.nttdata.com>
Message-ID: <11032f50-104f-843b-715c-d83df9158aaf@oss.nttdata.com>
Date: Thu, 9 Apr 2020 13:00:03 +0900
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0)
 Gecko/20100101 Thunderbird/68.6.0
MIME-Version: 1.0
In-Reply-To: <1586349174047-0.post@n3.nabble.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk


On 2020/04/08 21:32, legrand legrand wrote:
> Fujii Masao-4 wrote
>> On 2020/04/03 16:26
>> [...]
>>>
>>> "Note that planning and execution statistics are updated only at their
>>> respective end phase, and only for successful operations.
>>> For example the execution counters of a long running query
>>> will only be updated at the execution end, without showing any progress
>>> report before that.
>>
>> Probably since this is not the example for explaining the relationship of
>> planning and execution stats, it's better to explain this separately or
>> just
>> drop it?
>>
>> What about the attached patch based on your proposals?
> 
> +1
> Your patch is perfect ;^>

Thanks!

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION