function statistics PostgreSQL provides a function to inspect complex statistics defined using the CREATE STATISTICS command. pg_mcv_list_items pg_mcv_list_items ( pg_mcv_list ) setof record pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns: Name Type Description index integer index of the item in the MCV list values text[] values stored in the MCV item nulls boolean[] flags identifying NULL values frequency double precision frequency of this MCV item base_frequency double precision base frequency of this MCV item The pg_mcv_list_items function can be used like this: SELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid), pg_mcv_list_items(stxdmcv) m WHERE stxname = 'stts'; Values of the pg_mcv_list type can be obtained only from the pg_statistic_ext_data.stxdmcv column.