Share via

How to monitor Postgressql db data from azure monitoring

Kranthi Gurajapu 1 Reputation point
2020-08-11T18:15:56.063+00:00

Need to setup monitoring for the data in postgreSql DB from Azure monitoring, has anyone done this kind of monitoring ?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,323 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. tbgangav-MSFT 10,416 Reputation points
    2020-08-12T03:40:22.24+00:00

    Hi @Kranthi Gurajapu ,

    If it’s PostgreSQL on VM then you would have to configure monitoring by leveraging data sources in Azure Monitor. I see CollectD PostgreSQL plugin as the suitable data source in case it is Linux machine. Check this document for details regarding CollectD configuration. On the other hand, you can also accomplish up to some extend by configuring using Azure Monitor with the HTTP Data Collector API / Azure Monitor Custom Logs.

    If it’s Azure Database for PostgreSQL then it is recommended way and is directly supported by Azure Monitor. You can Monitor and tune Azure Database for PostgreSQL - Single Server and Monitor and tune Azure Database for PostgreSQL - Hyperscale (Citus). You may also find the list of metrics supported here.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.