Blog Post

Azure Database for PostgreSQL Blog
3 MIN READ

How to check logs for Azure Database for PostgreSQL

varun-dhawan's avatar
varun-dhawan
Icon for Microsoft rankMicrosoft
Sep 07, 2022
This article explains how to use Azure Portal to configure and view logs for your Azure database for PostgreSQL. Note: This blog post applies to both Single Server and Flexible Se...
Updated Feb 10, 2024
Version 17.0
Azure Database for PostgreSQL
Azure Database for PostgreSQL Flexible Server
azure monitor
flexible server
logging
observability
Postgres
PostgreSQL
uv's avatar
uv
Copper Contributor
Dec 05, 2022

Thanks Varun,  That means the azureDiagnostics table category "Querystoreruntimestatistics " and "Querystorewaitstatistics" not available now. so we can't use KQL. ok.

 

Using querystore views that you mentioned here, how to display the long running queries from this querystore to azure dashboard? Is there any standard method that we can suggest to our customers?

 

Appreciate your reply.

 

Thanks

 

Regards