Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/PostgreSQL
PostgreSQLhard

What is an index-only scan and what is the “visibility map” role?

Tags
#index-only-scan#visibility-map#index#postgres
Back to categoryPractice quiz

Answer

Index-only scan means the query can be answered from the index without reading table pages, because the index covers needed columns. Postgres still must know if rows are visible to the transaction; the visibility map tracks pages where all rows are visible, allowing the heap lookup to be skipped.

Related questions

PostgreSQL
How do `pg_stat_activity` and `pg_stat_statements` help in troubleshooting?
#postgres#monitoring#pg_stat_activity
PostgreSQL
Materialized view vs view: what’s the difference?
#postgres#views#materialized-view
PostgreSQL
LISTEN/NOTIFY: what problem does it solve?
#postgres#listen-notify#pubsub
PostgreSQL
Advisory locks: what are they and when would you use them?
#postgres#locks#advisory
PostgreSQL
BRIN index: when is it useful?
#postgres#brin#indexes
PostgreSQL
GIN vs GiST indexes: when would you use each?
#postgres#indexes#gin