Home > mailing lists

Re: pg_stats avg_width and null_frac - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: pg_stats avg_width and null_frac
Date	June 6, 2018 07:04:39
Msg-id	CAKFQuwbxXumnVw7Njb07-PO8v9U4SkocwqUL5SN9VacwDJCgCQ@mail.gmail.com Whole thread Raw
In response to	pg_stats avg_width and null_frac (Paul McGarry <paul@paulmcgarry.com>)
List	pgsql-general

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

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

Yes.

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

David J.

From: Paul McGarry
Date: 06 June 2018, 06:49:28
Subject: pg_stats avg_width and null_frac

From: Alexandre Arruda
Date: 06 June 2018, 07:42:02
Subject: Re: ERROR: found multixact from before relminmxid