pg_stats explained ... ? - Mailing list pgsql-hackers

From Marc G. Fournier
Subject pg_stats explained ... ?
Date
Msg-id 20020213092905.A19107-100000@mail1.hub.org
Whole thread Raw
Responses Re: pg_stats explained ... ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Morning all ...
Can someone explain to me how I should read this:
       tablename        |          attname           | avg_width | n_distinct
-------------------------+----------------------------+-----------+------------iwantu_pro_week         | uid
           |         8 |         -1iwantu_pro_week         | pro_week_agent             |         9 |
9iwantu_pro_week        | pro_week_time              |         8 |  -0.976321iwantu_pro_week         | pro_week_post
         |         5 |          2iwantu_pro_week         | pro_week_club              |         2 |          1
 

n_distinct, I'm taking it, of -1 means its a UNIQUE INDEX, and the
positive numbers are exact #'s ... but, -0.976321? :)

Also, how is the avg_width interpreted?



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Optimizer(?) off by factor of 3 ... ?
Next
From: mlw
Date:
Subject: Re: benchmarking postgres