station_data=# SELECT relname, relkind, reltuples, relpages FROM pg_class WHERE relname LIKE 'speed%'; relname | relkind | reltuples | relpages ------------------+---------+-------------------+---------- speed | r | 1.39002e+07 | 68138 speed_pkey | i | 1000 | 1 station_data=# SELECT attname, n_distinct, most_common_freqs, correlation FROM pg_stats WHERE tablename='speed'; attname | n_distinct | most_common_freqs | correlation ------------------+--------------+-------------------------------------------------------------------------------+------------- set_id | 13 | | 1 rec_time | 931519| {0.001,0.000666667,0.000666667,0.000666667} | 0.0737221 wind_speed | 136 | {0.0293333,0.0246667,0.0223333,0.021,0.0206667,0.0203333,0.0203333,0.02,0.02,0.02} | 0.0712318