Engineering topic

Query performance.

Learn how query plans, indexes, statistics, and access patterns affect performance.

Put it into practice.

Guides & tutorials

Engineering guide3 min read

Follow the work through a query plan, compare estimates with actual rows, and learn what to investigate before adding another index.

Intermediate

Tutorial3 min read

Build an index around a real access pattern, then use EXPLAIN to understand what it helps—and what it doesn't.

Intermediate

Engineering guide3 min read

A managed database does not remove connection limits. Coordinate application pools, scaling, and authentication before traffic grows.

Intermediate

Tutorial3 min read

Use explicit columns and partition filters to reduce unnecessary work, then validate the bytes your query will process.

Beginner