Understand PostgreSQL query processing

Intermediate
Database Administrator
Azure Database for PostgreSQL

The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible.

Learning objectives

After completing this module, you'll be able to:

  • Identify the query processing components.

  • Understand EXPLAIN.

Prerequisites

  • Demonstrate an understanding of relational databases.

  • Demonstrate an understanding of basic SQL.