tables_with_index_usage_counts.sql

-- https://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/
SELECT
    relname,
    100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used,
    n_live_tup rows_in_table
FROM
    pg_stat_user_tables
WHERE
    seq_scan + idx_scan > 0
ORDER BY
    n_live_tup DESC;