Query Store for Azure PostgreSQL

Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018 that Query Store was available in Public Preview for PostgreSQL. How cool is that!

As Microsoft continues to expand the Azure Data Platform with including MySQL, PostgreSQL, and others, features that we know and love for Azure SQL Database are being expanded to other data platforms.

You can read more about how to setup and configure Query Store for PostgreSQL here. Some quick observations are that Query Store is a per server feature for PostgreSQL and is an opt-in only. This is different compared to SQL Server On-premises where it’s a per database feature that has to be enabled per database and for Azure SQL Database where Query Store enabled by default per database.

If you are a Azure PostgreSQL user, I strongly encourage you to start looking into Query Store to help find those high cost queries.