TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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?
Reply
Answers (
3
)
Does analysing a table help removing dead tuples?
how to configure LDAPS on postgresql and Active Directory? im having t