Thread: stxkind only explain two elements. left two unexplained.
stxkind : An array containing codes for the enabled statistics kinds; valid values are:dfor n-distinct statistics,ffor 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.
On Tuesday, April 5, 2022, Jian He <hejian.mark@gmail.com> wrote:
stxkind : An array containing codes for the enabled statistics kinds; valid values are:dfor n-distinct statistics,ffor functional dependency statistics
Read the current version of the docs.
David J.