Add information about range type stats to pg_stats_ext_exprs
This commit adds three attributes to the system view pg_stats_ext_exprs,
whose data can exist when involving a range type in an expression:
range_length_histogram
range_empty_frac
range_bounds_histogram
These statistics fields exist since 918eee0c497c, and have become
viewable in pg_stats later in bc3c8db8ae2f. This puts the definition of
pg_stats_ext_exprs on par with pg_stats.
This issue has showed up during the discussion about the restore of
extended statistics for expressions, so as it becomes possible to query
the stats data to restore from the catalogs. Having access to this data
is useful on its own, without the restore part.
Some documentation and some tests are added, written by me. Corey has
authored the part in system_views.sql.
Bump catalog version.
Author: Corey Huinker <corey.huinker@gmail.com>
Co-authored-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/aYmCUx9VvrKiZQLL@paquier.xyz
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/307447e6dbc035c0e6e7a8ce9cee704a3b710ee9
Modified Files
--------------
doc/src/sgml/system-views.sgml | 39 +++++++++++++++++++++++++++++++++
src/backend/catalog/system_views.sql | 23 ++++++++++++++++++-
src/include/catalog/catversion.h | 2 +-
src/test/regress/expected/rules.out | 26 +++++++++++++++++++++-
src/test/regress/expected/stats_ext.out | 27 +++++++++++++++++++++++
src/test/regress/sql/stats_ext.sql | 18 +++++++++++++++
6 files changed, 132 insertions(+), 3 deletions(-)
