Tune queries in Azure Database for PostgreSQL

Intermediate
Database Administrator
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.
  • Visualize performance with Query Performance Insight.

Prerequisites

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