Re: pg_stats and range statistics - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: pg_stats and range statistics
Date
Msg-id 55c8ecd4-57d0-5c63-6fe3-1b81e8caea9d@enterprisedb.com
Whole thread Raw
In response to pg_stats and range statistics  (Egor Rogov <e.rogov@postgrespro.ru>)
Responses Re: pg_stats and range statistics
List pgsql-hackers
On 6/18/21 6:22 PM, Egor Rogov wrote:
> Hi,
> 
> Statistics for range types are not currently exposed in pg_stats view 
> (i.e. STATISTIC_KIND_RANGE_LENGTH_HISTOGRAM and 
> STATISTIC_KIND_BOUNDS_HISTOGRAM).
> 
> Shouldn't they? If so, here is a patch for adding them.
> 

I think they should be exposed - I don't see why not to do that. I 
noticed this when working on the count-min sketch experiment too, so 
thanks for this patch.

FWIW I've added the patch to the next CF:

https://commitfest.postgresql.org/33/3184/


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: PoC: Using Count-Min Sketch for join cardinality estimation
Next
From: Álvaro Herrera
Date:
Subject: Re: Race condition in InvalidateObsoleteReplicationSlots()