RE: Planning counters in pg_stat_statements (using pgss_store) - Mailing list pgsql-hackers

From legrand legrand
Subject RE: Planning counters in pg_stat_statements (using pgss_store)
Date
Msg-id DB6PR0301MB2135811EFF4391A031339D5690560@DB6PR0301MB2135.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: Planning counters in pg_stat_statements (using pgss_store)  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Planning counters in pg_stat_statements (using pgss_store)
List pgsql-hackers
Hi,

>>
>> case  avg_tps   pct_diff
>> 0        89 278   --
>> 1        88 745   0,6%
>> 2        88 282   1,1%
>> 3        86 660   2,9%
>>
>> This means that even in this extrem test case, the worst degradation is less
>> than 3%
>> (this overhead can be removed using pg_stat_statements.track_planning guc)

> Is the difference between 2 and 3 the extraneous pgss_store call to
> always store the query text if planner hook doesn't have access to the
> query text?

Yes it is,
but I agree it seems a big gap (1,8%) compared to the difference between 1 and 2 (0,5%).
Maybe this is just mesure "noise" ...

Regards
PAscal

pgsql-hackers by date:

Previous
From: Darafei Praliaskouski
Date:
Subject: Re: New vacuum option to do only freezing
Next
From: "Jamison, Kirk"
Date:
Subject: RE: Transaction commits VS Transaction commits (with parallel) VSquery mean time