Re: pg_stats avg_width and null_frac

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Jun 5, 2018 at 5:49 PM, Paul McGarry <paul@xxxxxxxxxxxxxxx> wrote:

Can anyone confirm that the "avg_width" reported in the pg_stats is the avg_width not including any null rows?

​Yes.

https://github.com/postgres/postgres/blob/master/src/include/catalog/pg_statistic.h#L40

It actually is documented but only on the underlying catalog, not the view.

https://www.postgresql.org/docs/10/static/catalog-pg-statistic.html

​

David J.