Virtualize PostgreSQL: the Full Picture

by bluemedora_editor on August 25, 2016

The Blue Medora VMware vRealize Operations Management Pack for PostgreSQL provides rich, detailed metrics about your PostgreSQL database environment within a few clicks. Database visibility is one of the most common reasons customers look to Blue Medora for monitoring solutions, so we’ll explore this information, as well as take a look at the features that make this Management Pack such a valuable monitoring tool.

 

Metrics and Resource Kinds

Using a JDBC connection, the PostgreSQL Extension connects directly to your database to retrieve data. The data the Extension collects includes metrics, relationships, and events for each of the resource kinds provided.

These PostgreSQL resource kinds include:

  • Adapter Instance
  • Instance
  • Database
  • Table
  • Function
  • Query

The integrated relationship mapping makes it easy to view and drill down to related PostgreSQL and VM resources, effectively bridging the gap between each, giving you an insightful and powerful look into the Management Pack’s unique relationship to the virtualization layer.

 

image03

 

PostgreSQL Dashboards

The PostgreSQL Management Pack includes several out-of-the-box dashboards designed to give you a quick look at the status of your environment, and makes it easy to identify and view key performance indicators (KPIs) as soon as the Extension is configured and collecting data.

 

image02

 

The 5 Instantly Available Dashboards Include:

PostgreSQL Overview Provides an overall health display of the PostgreSQL database environment using easy to read heat maps to simplify identifying problematic resource kinds.

PostgreSQL on OS Allows user to view key performance metrics (KPIs) for the selected PostgreSQL database and related operating system.

PostgreSQL on VM Allows user to view key performance indicators for the selected PostgreSQL database and related virtual machine or machines.

PostgreSQL IOPS Allows user to view IO stats for the selected PostgreSQL database, virtual machine, and datastore.

PostgreSQL Top-N Queries  Allows user to view a ranking of the Top 10 slowest queries for the selected PostgreSQL database. The dashboard view also enables the user to select individual queries and view the metrics for the selected query on a heat map, as can be seen in the screenshot below.

 

image01

 

Alerts

PostgreSQL database health indicators are pulled by the vROps Management Pack for PostgreSQL and displayed in vRealize Operations as alerts. Based on various symptoms that it detects in the environment, alerts are generated and the critical levels of each alert are closely mapped from PostgreSQL to vROps.

 

Reports

Several preconfigured reports are included with the PostgreSQL Management Pack, providing instant value to the user. These reports can be exported and shared with key stakeholders throughout the user’s organization.

 

image00

 

The Instance Overview and Throughput reports are two incredibly useful reports for a user. The PostgreSQL Instance Overview provides an overview of the instance performance metrics, and the Throughput report provides a list of throughput metrics.

If you are interested in taking a firsthand look into how the Management Pack for PostgreSQL can help provide a deep insight into your PostgreSQL database environment, you can visit the product page where you will find overview videos and presentations. Additionally, you can request a free trial to start monitoring your PostgreSQL environment today!

Get started

Try BindPlane for free. No credit card required.

Sign up
True Visibility
BindPlane for VMware vRealize Operations

True Visibility allows cloud management teams to use VMware vRealize’s powerful machine learning and capacity planning engine across their entire hybrid cloud environment.

Azure Monitor...everything
BindPlane for Microsoft Azure Monitor

Make Azure Monitor your first-pane-of-glass across your entire multi-cloud, multi-database or hybrid platform environment.

Thank you for contacting us. Your information was received. We'll be in touch shortly.