Horton

Display length and bounds histograms in pg_stats

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: bc3c8db8ae2f899cfd65edce99fe9cf65caf1ed7
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2023-11-26T23:32:17Z
Releases: 17.0 
Display length and bounds histograms in pg_stats

Values corresponding to STATISTIC_KIND_RANGE_LENGTH_HISTOGRAM and
STATISTIC_KIND_BOUNDS_HISTOGRAM were not exposed to pg_stats when these
slot kinds were introduced in 918eee0c49.

This commit adds the missing fields to pg_stats.

Catversion is bumped.

Discussion: https://postgr.es/m/flat/b67d8b57-9357-7e82-a2e7-f6ce6eaeec67@postgrespro.ru
Author: Egor Rogov, Soumyadeep Chakraborty
Reviewed-by: Tomas Vondra, Justin Pryzby, Jian He

Files

PathChange+/−
doc/src/sgml/system-views.sgml modified +39 −0
src/backend/catalog/system_views.sql modified +22 −1
src/include/catalog/catversion.h modified +1 −1
src/test/regress/expected/rules.out modified +25 −1

Documentation touched

Discussion

Cited messages not in the archive: flat/b67d8b57-9357-7e82-a2e7-f6ce6eaeec67@postgrespro.ru