# Query Performance Tuning

> Query planning and execution, access methods, joins, statistics and practical query tuning.

---

LLMS index: [llms.txt](/en/llms.txt)

---

<!-- Generated by scripts/generate_skeleton.py. -->

This course keeps the official topic order and exposes the English handout as readable, native Markdown for review and future editorial work.

> **Source status:** 官方 PDF 已提取为原生 Markdown

> **Translation baseline:** English baseline. The current English archive is the working baseline; the Russian edition is retained for chapter-level cross-checking.

## Course scope

Query planning and execution, access methods, joins, statistics and practical query tuning.

## Source status

| Language | Current package | Version | Topics | Course page |
| --- | --- | --- | ---: | --- |
| English | [QPT-handouts-16-en-20251018.zip](https://edu.postgrespro.com/16/QPT-handouts-16-en-20251018.zip) | 16-20251018 | 17 | [HTTP 200](https://postgrespro.com/community/courses/QPT) |
| Русский | [QPT-handouts-16.zip](https://edu.postgrespro.ru/16/QPT-handouts-16.zip) | 16 | 17 | [HTTP 200](https://postgrespro.ru/education/courses/QPT) |

## Contents

- [00 Optimizing Queries](/en/qpt/qpt-00-introduction/)
- [01 Demo database "Air Transport"](/en/qpt/qpt-01-demodb-bookings/)
- [02 Planning and Execution](/en/qpt/qpt-02-query-query/)
- [03 Access Methods](/en/qpt/qpt-03-am-am/)
- [04 Parallel Data Access](/en/qpt/qpt-04-am-parallels/)
- [05 Index Types](/en/qpt/qpt-05-am-indexes/)
- [06 Sorting](/en/qpt/qpt-06-sort-sort/)
- [07 Grouping](/en/qpt/qpt-07-sort-group/)
- [08 Nested Loop Join](/en/qpt/qpt-08-join-nestloop/)
- [09 Hash Join](/en/qpt/qpt-09-join-hashjoin/)
- [10 Merge Join](/en/qpt/qpt-10-join-mergejoin/)
- [11 Basic Statistics](/en/qpt/qpt-11-stats-basic/)
- [12 Extended Statistics](/en/qpt/qpt-12-stats-extended/)
- [13 Profiling](/en/qpt/qpt-13-optim-profiling/)
- [14 Materialization](/en/qpt/qpt-14-optim-materialization/)
- [15 Functions](/en/qpt/qpt-15-optim-functions/)
- [16 Approaches to Configuration](/en/qpt/qpt-16-optim-tuning/)

## Supplementary materials

- `demodb.pdf`
- `qpt_new_features.pdf`
- `qpt_student_guide.pdf`

## Editorial status

The available English handout is extracted from the official PDF. Where no current English archive was found, the route remains ready for a later source edition.

- [Version matrix](/en/versions/)
- [Work checklist](/en/checklist/)
- [Sources and permissions](/en/about/)

---

Section pages:

- [Lesson 00: Optimizing Queries](/en/qpt/qpt-00-introduction/): Native Markdown source page: Optimizing Queries
- [Lesson 01: Demo database "Air Transport"](/en/qpt/qpt-01-demodb-bookings/): Native Markdown source page: Demo database "Air Transport"
- [Lesson 02: Query Execution / Planning and Execution](/en/qpt/qpt-02-query-query/): Native Markdown source page: Query Execution / Planning and Execution
- [Lesson 03: Data Access / Access Methods](/en/qpt/qpt-03-am-am/): Native Markdown source page: Data Access / Access Methods
- [Lesson 04: Data Access / Parallel Data Access](/en/qpt/qpt-04-am-parallels/): Native Markdown source page: Data Access / Parallel Data Access
- [Lesson 05: Data Access / Index Types](/en/qpt/qpt-05-am-indexes/): Native Markdown source page: Data Access / Index Types
- [Lesson 06: Sorting and Grouping / Sorting](/en/qpt/qpt-06-sort-sort/): Native Markdown source page: Sorting and Grouping / Sorting
- [Lesson 07: Sorting and Grouping / Grouping](/en/qpt/qpt-07-sort-group/): Native Markdown source page: Sorting and Grouping / Grouping
- [Lesson 08: Join Methods / Nested Loop Join](/en/qpt/qpt-08-join-nestloop/): Native Markdown source page: Join Methods / Nested Loop Join
- [Lesson 09: Join Methods / Hash Join](/en/qpt/qpt-09-join-hashjoin/): Native Markdown source page: Join Methods / Hash Join
- [Lesson 10: Join Methods / Merge Join](/en/qpt/qpt-10-join-mergejoin/): Native Markdown source page: Join Methods / Merge Join
- [Lesson 11: Statistics / Basic Statistics](/en/qpt/qpt-11-stats-basic/): Native Markdown source page: Statistics / Basic Statistics
- [Lesson 12: Statistics / Extended Statistics](/en/qpt/qpt-12-stats-extended/): Native Markdown source page: Statistics / Extended Statistics
- [Lesson 13: Query Optimization / Profiling](/en/qpt/qpt-13-optim-profiling/): Native Markdown source page: Query Optimization / Profiling
- [Lesson 14: Query Optimization / Materialization](/en/qpt/qpt-14-optim-materialization/): Native Markdown source page: Query Optimization / Materialization
- [Lesson 15: Query Optimization / Functions](/en/qpt/qpt-15-optim-functions/): Native Markdown source page: Query Optimization / Functions
- [Lesson 16: Query Optimization / Approaches to Configuration](/en/qpt/qpt-16-optim-tuning/): Native Markdown source page: Query Optimization / Approaches to Configuration