public inbox for [email protected]
help / color / mirror / Atom feedstxkind only explain two elements. left two unexplained.
2+ messages / 2 participants
[nested] [flat]
* stxkind only explain two elements. left two unexplained.
@ 2022-04-06 05:01 Jian He <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Jian He @ 2022-04-06 05:01 UTC (permalink / raw)
To: [email protected]
PostgreSQL: Documentation: 10: 51.51. pg_statistic_ext
<https://www.postgresql.org/docs/10/catalog-pg-statistic-ext.html;
> stxkind : An array containing codes for the enabled statistics kinds;
> valid values are: d for n-distinct statistics, f for functional
> dependency statistics
select distinct stxkind from pg_statistic_ext ;
return:
stxkind
> ---------
> {d}
> {m}
> {f}
> {e}
> (4 rows)
I guess *e *for expression statistics. Since I create the following
statistics object.
create statistics flight_expr1 on(
extract
(month from scheduled_departure at time zone 'Asia/Kolkata')
) from flights;
select stxkind from pg_statistic_ext where stxname = 'flight_expr';
and it return *e.*
But I am not sure what does *m *mean?
It would be better to full explain all these four elements in the doc.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: stxkind only explain two elements. left two unexplained.
@ 2022-04-06 05:03 David G. Johnston <[email protected]>
parent: Jian He <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2022-04-06 05:03 UTC (permalink / raw)
To: Jian He <[email protected]>; +Cc: [email protected] <[email protected]>
On Tuesday, April 5, 2022, Jian He <[email protected]> wrote:
> PostgreSQL: Documentation: 10: 51.51. pg_statistic_ext
> <https://www.postgresql.org/docs/10/catalog-pg-statistic-ext.html;
>
>> stxkind : An array containing codes for the enabled statistics kinds;
>> valid values are: d for n-distinct statistics, f for functional
>> dependency statistics
>
>
Read the current version of the docs.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-04-06 05:03 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-04-06 05:01 stxkind only explain two elements. left two unexplained. Jian He <[email protected]>
2022-04-06 05:03 ` David G. Johnston <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox