optimize db #1059

New issue

Open

opened 2012-10-02 22:18:33 +00:00 by j · 0 comments

j commented

2012-10-02 22:18:33 +00:00

Owner

from http://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 ORDER BY n_live_tup DESC;

lists some tables that could be doing a bit better

from <http://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 ORDER BY n_live_tup DESC; lists some tables that could be doing a bit better