Re: pg_stats explained ... ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stats explained ... ?
Date: 2002-02-13 16:06:40
Message-ID: 28939.1013616400@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
> n_distinct, I'm taking it, of -1 means its a UNIQUE INDEX, and the
> positive numbers are exact #'s ... but, -0.976321? :)

"Almost unique", evidently. See stadistinct at
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/catalog-pg-statistic.html

> Also, how is the avg_width interpreted?

Just what you'd expect: average stored width, in bytes, of non-NULL
entries in the column.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-02-13 16:11:07 Re: "Bug" in statistics for v7.2?
Previous Message Tom Lane 2002-02-13 15:57:27 Re: alter table drop column status