PostgreSQL Metrics

Collect and ship PostgreSQL metrics to Logstash and Elasticsearch

Metricbeat is a lightweight shipper that helps you monitor your PostgreSQL database servers by collecting metrics running on the PostgreSQL server. Configure Metricbeat using the pre-defined examples below to collect and ship PostgreSQL database server metrics and statistics to Logstash or Elasticsearch.

Install Integration

Please click on the Install Integration button to configure your stack for this source.

Install Metricbeat

To get started first follow the steps below:

Older versions can be found here: metricbeat 7 (opens in a new tab), metricbeat 6 (opens in a new tab), metricbeat 5 (opens in a new tab)

Copy Configuration File

The configuration file below is pre-configured to send data to your Logit.io Stack via Logstash.

Copy the configuration file below and overwrite the contents of metricbeat.yml.

###################### Logit.io Metricbeat Configuration #######################
# =========================== Modules configuration ============================
 
metricbeat.config.modules:
  # Glob pattern for configuration loading
  path: ${path.config}/modules.d/*.yml
 
  # Set to true to enable config reloading
  reload.enabled: false
 
  # Period on which files under path should be checked for changes
  #reload.period: 10s
# ======================= Elasticsearch template setting =======================
setup.template.settings:
  index.number_of_shards: 1
  index.codec: best_compression
  #_source.enabled: false
 
# ================================== Outputs ===================================
# ------------------------------ Logstash Output -------------------------------
⚠️

No input available! Your stack is missing the required input for this data source

Talk to support to add the input

Enable Module

There are several built-in metricbeat modules you can use. To enable the PostgreSQL module, run the following:

metricbeat modules list
metricbeat modules enable @module

Configure Module

Each module has its own configuration file where different metricsets can be enabled / disabled. Locate the configuration file for the PostgreSQL module.

/etc/metricbeat/modules.d/@module.yml

By default the following metricsets are disabled. To enable or disable a metric simply comment or uncomment the line out.

- module: postgresql
  metricsets:
    - database
    - bgwriter
    - activity
  period: 10s
  hosts: ["postgres://localhost:5432"]
  username:
  password:

Start Metricbeat

Start or restart Metricbeat (opens in a new tab) to apply the configuration changes.

Check Logit.io for your logs

Data should now have been sent to your Stack.

View My Data

If you don't see take a look at How to diagnose no data in Stack below for how to diagnose common issues.

How to diagnose no data in Stack

If you don't see data appearing in your stack after following this integration, take a look at the troubleshooting guide for steps to diagnose and resolve the problem or contact our support team and we'll be happy to assist.

Compatibility

The PostgreSQL module was tested with PostgreSQL 9.5.3 and is expected to work with all versions >= 9.

PostgreSQL Overview

PostgreSQL, often referred to as Postgres, is a powerful open-source relational database management system (RDBMS) renowned for its robustness, flexibility, and extensibility. It was initially developed at the University of California, Berkeley, in the 1980s and has since evolved into one of the most popular and trusted database solutions worldwide.

PostgreSQL excels in handling complex data structures, supporting various data types, including JSON, XML, and geospatial data, making it suitable for a wide range of applications. Its support for ACID (Atomicity, Consistency, Isolation, Durability) compliance ensures data integrity and reliability.

When it comes to collecting and shipping PostgreSQL metrics, administrators and developers can tap into a plethora of built-in monitoring tools and extensions. PostgreSQL provides a comprehensive set of metrics, ranging from query performance and resource utilization to transaction statistics and replication status.

Administrators can access these metrics via system views and functions or employ third-party tools and extensions for more advanced monitoring. To effectively collect and ship PostgreSQL metrics, various solutions and integrations are available, including monitoring agents, log analyzers (such as the one provided by Logit.io), and cloud-based services.

These tools enable organizations to gain insights into their PostgreSQL database's performance, identify bottlenecks, and proactively address issues to ensure optimal database operation.

If you need any further assistance with migrating your data to Logit.io we're here to help you get started. Feel free to get in contact with our support team by sending us a message via live chat and we'll be happy to assist.