3
Answers

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

Photo of Kousik

Kousik

4y
501
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)