| From: | Jian He <hejian(dot)mark(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | stxkind only explain two elements. left two unexplained. |
| Date: | 2022-04-06 05:01:55 |
| Message-ID: | CAMV54g1+xGwtFHTtnXOJW_Lc4+i1tfReBY_ZkRgkXQqM8wGXJA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-04-06 05:03:46 | Re: stxkind only explain two elements. left two unexplained. |
| Previous Message | Bruce Momjian | 2022-04-05 18:59:53 | Re: Improve documentation for pg_upgrade, standbys and rsync |