Start your 14-day free trial today & Get 20% Off All Annual Managed ELK Plans
No Credit Card Required
Try Logit.io FreeAlready have an account? Sign In
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.
Step 1 - Install Metricbeat
deb (Debian/Ubuntu/Mint)
curl -L -O https://artifacts.elastic.co/downloads/beats//-oss-7.15.1-amd64.deb
sudo dpkg -i -oss-7.15.1-amd64.deb
rpm (CentOS/RHEL/Fedora)
curl -L -O https://artifacts.elastic.co/downloads/beats//-oss-7.15.1-x86_64.rpm
sudo rpm -vi -oss-7.15.1-x86_64.rpm
macOS
curl -L -O https://artifacts.elastic.co/downloads/beats//-oss-7.15.1-darwin-x86_64.tar.gz
tar xzvf -oss-7.15.1-darwin-x86_64.tar.gz
Windows
- Download the Windows zip file from the official downloads page.
- Extract the contents of the zip file into C:\Program Files.
- Rename the
-<version>-windows
directory to ``. - Open a PowerShell prompt as an Administrator (right-click the PowerShell icon and select Run As Administrator). If you are running Windows XP, you may need to download and install PowerShell.
- Run the following commands to install as a Windows service:
cd 'C:\Program Files\'
.\install-service-.ps1
PowerShell.exe -ExecutionPolicy UnRestricted -File .\install-service-.ps1
.
Step 2 - Locate configuration file
deb/rpm /etc/metricbeat/metricbeat.yml
mac/win <EXTRACTED_ARCHIVE>/metricbeat.yml
Step 3 - Configure output
We'll be shipping to Logstash so that we have the option to run filters before the data is indexed.
Comment out the elasticsearch output block.
## Comment out elasticsearch output
#output.elasticsearch:
# hosts: ["localhost:9200"]
Step 4 - Validate configuration
Let's check the configuration file is syntactically correct by running directly inside the terminal.
If the file is invalid, will print an error loading config file
error message with details on how to correct the problem.
deb/rpm
sudo -e -c /etc//.yml
macOS
cd <EXTRACTED_ARCHIVE>
./ -e -c .yml
Windows
cd <EXTRACTED_ARCHIVE>
.\.exe -e -c .yml
Step 5 - 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 6 - 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 7 - Start Metricbeat
Ok, time to start gathering metrics!
deb/rpm
sudo systemctl enable metricbeat
sudo systemctl start metricbeat
macOS
./metricbeat
Windows
PS C:\Program Files\Metricbeat> Start-Service metricbeat
Step 8 - 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.