musicbrainz_db_raw_rc1=> analyze edit;
ANALYZE
musicbrainz_db_raw_rc1=> explain select * from edit where status = 1;
                                  QUERY PLAN
-------------------------------------------------------------------------------
 Index Scan using edit_status_open on edit  (cost=0.00..8.27 rows=1 width=381)
(1 row)

musicbrainz_db_raw_rc1=> select * from pg_stats where tablename = 'edit' AND attname = 'status';
    schemaname    | tablename | attname | inherited | null_frac | avg_width | n_distinct | most_common_vals |                            most_common_freqs                             | histogram_bounds | correlation
------------------+-----------+---------+-----------+-----------+-----------+------------+------------------+--------------------------------------------------------------------------+------------------+-------------
 musicbrainz_bork | edit      | status  | f         |         0 |         2 |          7 | {2,3,9,6,4,5,7}  | {0.967533,0.0131667,0.0127333,0.00386667,0.0021,0.000466667,0.000133333} |                  |    0.911556
 musicbrainz      | edit      | status  | f         |         0 |         2 |          7 | {2,9,3,6,4,5,7}  | {0.96887,0.0129333,0.0127,0.00343,0.00177667,0.000243333,4.66667e-05}    |                  |    0.916126
 musicbrainz_test | edit      | status  | f         |         0 |         2 |  -0.166667 | {2,1}            | {0.666667,0.333333}                                                      |                  |    0.832168
(3 rows)

musicbrainz_db_raw_rc1=>