4 ms·
A better query to see how indexes are used to avoid division by zero errors. SELECT relname, CASE WHEN seq_scan = 0 THEN 0 ELSE 100 *
by Axsuul 14y ago
A better query to see how indexes are used to avoid division by zero errors.
SELECT
relname,
CASE
WHEN seq_scan = 0 THEN 0
ELSE 100 * idx_scan / (seq_scan + idx_scan)
END AS percent_of_times_index_used,
n_live_tup rows_in_table
FROM
pg_stat_user_tables
ORDER BY
n_live_tup DESC;