Horton

Re: [PATCH] Add features to pg_stat_statements

btkatsuragiyu <btkatsuragiyu@oss.nttdata.com>

View thread View on postgr.es
From: Katsuragi Yuta <btkatsuragiyu@oss.nttdata.com>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, legrand legrand <legrand_legrand@hotmail.com>
Date: 2020-09-23T08:17:04Z
Lists: pgsql-hackers 
On 2020-09-23 16:01, Julien Rouhaud wrote:
>> Not only providing a view but also logging evictions
>> along with the number of evicted entries might be a choice.
>> This idea is from legrand legrand [1].
> 
> +1.  I'm wondering if logging each evicted entry, with its queryid,
> would help to estimate the actual size of the normalised queries set.

I agree with the estimation of the actual size of the
query set is important.
It looks difficult to estimate the actual size of the
query set from queryid because queryid is a 64bit hash value.

Regards,
Katsuragi Yuta

Commits

  1. pg_stat_statements: Track number of times pgss entries were deallocated.