Kousik

Kousik

  • NA
  • 56
  • 13k

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

Apr 4 2021 8:25 AM
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)