Skip to content

Instantly share code, notes, and snippets.

View unStatiK's full-sized avatar
🇪🇹

Steven Vch. unStatiK

🇪🇹
6 followers · 1 following
View GitHub Profile
@hgmnz
hgmnz / query_planner.markdown
Created March 23, 2011 14:14
PostgreSQL query plan and SQL performance notes

Types of index scans

Indexes

Sequential Scan:

  • Read every row in the table
  • No reading of index. Reading from indexes is also expensive.