Re: [PATCH] Add features to pg_stat_statements - Mailing list pgsql-hackers

From Katsuragi Yuta
Subject Re: [PATCH] Add features to pg_stat_statements
Date
Msg-id 8ad65061e81ad622cb4a4b6fbbe25646@oss.nttdata.com
Whole thread Raw
In response to Re: [PATCH] Add features to pg_stat_statements  (Julien Rouhaud <rjuju123@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: OpenSSL 3.0.0 compatibility
Next
From: Michael Paquier
Date:
Subject: Re: OpenSSL 3.0.0 compatibility