Here's a sample query to pull the number of rows, indexes, and some info about those indexes for each table. Ditch the pg_size_pretty if you’re on an ancient (<= 8.2) version)
SELECTpg_class.relname,pg_size_pretty(pg_class.reltuples::bigint) AS rows_in_bytes,pg_class.reltuples AS num_rows,count(indexname) AS number_of_indexes,CASE WHEN x.is_unique = 1 THEN 'Y'ELSE 'N'END AS UNIQUE,SUM(case WHEN number_of_columns = 1 THEN 1ELSE 0END) AS single_column,SUM(case WHEN number_of_columns IS NULL THEN 0WHEN number_of_columns = 1 THEN 0ELSE 1END) AS multi_columnFROM pg_namespaceLEFT OUTER JOIN pg_class ON pg_namespace.oid = pg_class.relnamespaceLEFT OUTER JOIN(SELECT indrelid,max(CAST(indisunique AS integer)) AS is_uniqueFROM pg_indexGROUP BY indrelid) xON pg_class.oid = x.indrelidLEFT OUTER JOIN( SELECT c.relname AS ctablename, ipg.relname AS indexname, x.indnatts AS number_of_columns FROM pg_index xJOIN pg_class c ON c.oid = x.indrelidJOIN pg_class ipg ON ipg.oid = x.indexrelid )AS fooON pg_class.relname = foo.ctablenameWHEREpg_namespace.nspname='public'AND pg_class.relkind = 'r'GROUP BY pg_class.relname, pg_class.reltuples, x.is_uniqueORDER BY 2;