Introduction
In this module, you learn how to monitor query performance in Azure Database for PostgreSQL to best support your users and developers.
Relational databases store many different types of data for many different types of applications. Some databases have thousands of users and some have just one user. Some tables have tens of rows while others have millions of rows. Some data is unique while other data is duplicated. All of these variables mean that database management systems (DBMSs) need systems to understand the data and the queries that are running against this data to ensure optimum performance. When you tune a database, it's important to understand how performance tuning works and how you can assess performance metrics.
In this module, we look at different methods of assessing query performance in Azure Database for PostgreSQL.
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.