Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Database Administrator
/
Questions
/
Query Planning
Database Administrator
Query Planning questions
9 questions on Query Planning for database administrators, easiest first.
Medium
7
Planner ignores a good index
medium
Seeing the plan of a slow query in prod
medium
Planner prefers seq scans on NVMe
medium
Reading type=ALL in MySQL EXPLAIN
medium
Big aggregate uses one CPU
medium
CTE acts as an optimisation fence
medium
Bad estimates on a skewed column
medium
Hard
2
Slow query over postgres_fdw
hard
Reading EXPLAIN BUFFERS output
hard
