You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
422 B
19 lines
422 B
|
|
SELECT |
|
schemaname||'.'||relname, |
|
n_live_tup, |
|
seq_scan, |
|
seq_tup_read, |
|
(coalesce(n_tup_ins,0)+coalesce(n_tup_upd,0)+coalesce(n_tup_del,0)) as write_activity, |
|
(SELECT count(*) FROM pg_index WHERE pg_index.indrelid=pg_stat_all_tables.relid) AS index_count, |
|
idx_scan, |
|
idx_tup_fetch |
|
FROM pg_stat_all_tables |
|
WHERE |
|
seq_scan>0 |
|
AND seq_tup_read>100000 |
|
AND schemaname<>'pg_catalog' |
|
ORDER BY |
|
seq_tup_read DESC |
|
LIMIT 20; |
|
|
|
|