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.
Follow this step by step guide to get 'logs' from your system to Logit.io:
Step 2 - 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 -------------------------------
<div class="sw-warning">
<div>
<img src="/images/source-wizard/warning-triangle.svg">
</div>
<div>
<b>No input available! </b> Your stack is missing the required input for this data source <a href="#" onclick="Intercom('showNewMessage')" class="btn btn-info btn-sm">Talk to support to add the input</a>
</div>
</div>
Step 3 - Enable module
There are several built in metricbeat modules you can use. To enable the PostgreSQL module, run the following:
deb/rpm
metricbeat modules list
metricbeat modules enable PostgreSQL
macOS
./metricbeat modules list
./metricbeat modules enable PostgreSQL
Windows
PS > .\metricbeat.exe modules enable PostgreSQL
Step 4 - Configure module
Each module has its own configuration file where different metricsets can be enabled / disabled. Locate the configuration file for the PostgreSQL module.
deb/rpm
/etc/metricbeat/modules.d/PostgreSQL.yml
mac/win
~/<EXTRACTED_ARCHIVE>/modules.d/PostgreSQL.yml
By default the status metricset is disabled. To enable or disable a metric simply comment or uncomment the line out. You will also need to enter the host location of the database and username and password to access it.
- module: postgresql
metricsets:
- database
- bgwriter
- activity
period: 10s
hosts: ["postgres://localhost:5432"]
username:
password:
Step 5 - Start Metricbeat
Start or restart to apply the configuration changes.
Step 6 - how to diagnose no data in Stack
If you don't see data appearing in your Stack after following the steps, visit the Help Centre guide for steps to diagnose no data appearing in your Stack or Chat to support now.
Step 7 - Compatibility
The PostgreSQL module was tested with PostgreSQL 9.5.3 and is expected to work with all versions >= 9.