Tune queries in Azure Database for PostgreSQL

Intermediate
Database Administrator
Azure Database for PostgreSQL

Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It is important to understand how performance tuning works and how you can assess performance metrics.

Learning objectives

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

  • Describe statistics in Azure Database for PostgreSQL.
  • Assess query performance with the Query Store.

Prerequisites

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.