3
Answers

i am trying to get all the tables that the seq scan happens more than

Kousik

Kousik

3y
469
1
select relname, seq_scan , idx_scan from pg_stat_user_tables where seq_scan > idx_scan order by 2 desc limit 10 ; i am trying to get all the tables that the seq scan happens more than the index scan - is this query correct?
Answers (3)