Skip to content

Postgresql Performance Tuning vs SQL Window Functions Cheatsheet

Compare these two topics side by side to decide which to study first — or tackle both!

📚

Postgresql Performance Tuning

Databases

103

Cards

~52m

Study time

Advanced

Difficulty

Sample questions

  • ▸How do you find the slowest queries in Postgres?
  • ▸How do you read an EXPLAIN plan?
  • ▸Difference between EXPLAIN, EXPLAIN ANALYZE, EXPLAIN (BUFFERS, ANALYZE)?
  • ▸Why is a Seq Scan faster than an Index Scan sometimes?
  • ▸Function used to add a B-tree index for equality + range queries?
Study Postgresql Performance Tuning →
📚

SQL Window Functions Cheatsheet

Databases

223

Cards

~112m

Study time

Advanced

Difficulty

Sample questions

  • ▸Running total of <i>amount</i> by <i>user_id</i> ordered by <i>ts</i>?
  • ▸Difference between ROW_NUMBER, RANK, DENSE_RANK?
  • ▸Top N rows per group?
  • ▸Previous row's value in same partition?
  • ▸Next row's value?
Study SQL Window Functions Cheatsheet →

🤔 Which should you study first?

Both topics are in the Databases category, so they complement each other well. We suggest starting with the smaller deck to build momentum:

Postgresql Performance Tuning

103 cards · ~52 min · Advanced

⭐ Quicker to complete

SQL Window Functions Cheatsheet

223 cards · ~112 min · Advanced