Maybe I just don't understand, but I'm pretty sure ANALYZE does not derive index stats from column stats. It actually builds them from the row sample.
That is correct, my error.
> * now support extended statistics except for MCV, which is currently > serialized as an difficult-to-decompose bytea field.
Doesn't pg_mcv_list_items() already do all the heavy work?
Thanks! I'll look into that.
The comment below in mcv.c made me think there was no easy way to get output.
/* * pg_mcv_list_out - output routine for type pg_mcv_list. * * MCV lists are serialized into a bytea value, so we simply call byteaout() * to serialize the value into text. But it'd be nice to serialize that into * a meaningful representation (e.g. for inspection by people). * * XXX This should probably return something meaningful, similar to what * pg_dependencies_out does. Not sure how to deal with the deduplicated * values, though - do we want to expand that or not? */
