i am trying to get all the tables that the seq scan happens more than
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?
Rajanikant HawaldarPosted Apr 5, 2021, 6:10 AM
KousikPosted Apr 5, 2021, 4:21 AM
Rajanikant HawaldarPosted Apr 4, 2021, 10:39 AM