Re: [PATCH] Add features to pg_stat_statements

From: Katsuragi Yuta <btkatsuragiyu(at)oss(dot)nttdata(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, legrand legrand <legrand_legrand(at)hotmail(dot)com>
Subject: Re: [PATCH] Add features to pg_stat_statements
Date: 2020-09-23 08:17:04
Message-ID: 8ad65061e81ad622cb4a4b6fbbe25646@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-09-23 08:19:55 Re: OpenSSL 3.0.0 compatibility
Previous Message Michael Paquier 2020-09-23 08:17:00 Re: OpenSSL 3.0.0 compatibility