• Tomas Vondra's avatar
    Add pg_stats_ext view for extended statistics · aa087ec6
    Tomas Vondra authored
    Regular per-column statistics are stored in pg_statistics catalog, which
    is however rather difficult to read, so we also have pg_stats view with
    a human-reablable version of the data.
    
    For extended statistic the catalog was fairly easy to read, so we did
    not have such human-readable view so far.  Commit 9b6babfa2d however did
    split the catalog into two, which makes querying harder.  Furthermore,
    we want to show the multi-column MCV list in a way similar to per-column
    stats (and not as a bytea value).
    
    This commit introduces pg_stats_ext view, joining the two catalogs and
    massaging the data to produce human-readable output similar to pg_stats.
    It also considers RLS and access privileges - the data is shown only when
    the user has access to all columns the extended statistic is defined on.
    
    Bumped CATVERSION due to adding new system view.
    
    Author: Dean Rasheed, with improvements by me
    Reviewed-by: Dean Rasheed, John Naylor
    Discussion: https://postgr.es/m/CAEZATCUhT9rt7Ui%3DVdx4N%3D%3DVV5XOK5dsXfnGgVOz_JhAicB%3DZA%40mail.gmail.com
    aa087ec6
catalogs.sgml 385 KB