new-postgresql-database-support-in-performance-analyzer

We’re more than happy to announce a new database integration in Performance Analyzer: PostgreSQL

As we already have support for Microsoft SQL server and Oracle for quite some time, we noticed a great interest from our customer base to add PostgreSQL as well.

PostgreSQL

When running Performance Analyzer 6, you need to make sure to install the 6.2.5 patch and the PostgreSQL license to have the options available to add the database servers.

Please have your PostgreSQL server network dns or ip address ready and a database user that can access the database metrics.

Adding the database server including all databases to the data (metrics) collector is as simple as always using Performance Analyzer, just click add.

PostgreSQL integration

Next thing you can see is a new dashboard and the data flowing into:

PostgreSQL dashboard

The header section allows you to select between the database servers and databases.

We don’t just collect the server settings, all kinds of metrics and counters, we also show sessions, the queries and their runtime.

Postgre Sessions

Collector information:

  • starting time
  • cpu usage
  • memory usage

Settings:

  • Shared Buffers
  • Effective Cache
  • Maintenance Work Mem
  • Work Mem
  • Max WAL Size
  • Random Page Cost
  • Sequential Page Cost
  • Max Worker Processes
  • Max Parallel Workers

General Counters:

  • Version
  • Max Connections
  • fetched tuples
  • inserted tuples
  • update tuples
  • deleted tuples 

PostgreSQL database stats

Database Stats:

  • Used connections
  • Transactions /sec
  • Cache Hit Rate
  • Tuple Insert /sec
  • Tuples Fetch /sec
  • Tuples Returned /sec
  • Tuples Delete /sec
  • Temp File (Bytes)
  • Buffers (bgwriter)
  • Lock Tables
  • Conflicts
  • Deadlocks
  • Idle sessions
  • Active sessions
  • Checkpoint stats

Please contact us if you want to integrate your PostgreSQL database server as well. Its a great addition to our already existing VMware vSphere support, Linux, Docker, Kubernetes aso.

RELATED ARTICLES

Save energy without reducing VM performance in your VMware vSphere cluster
16 August 2022
Over the last couple of decades energy consumption went up massively in every data center and while the…
Dennis
Metrics & Logs support for IoT - Bringing Secure Monitoring and Logging to the Edge
7 July 2022
Simple uptime monitoring for Internet-of-Things (IoT) is well-known and requires knowing if the devices are up and running.…
Dennis
Monitoring Azure SQL Managed Instance with Opvizor Metrics & Logs
17 January 2022
When you have critical applications and business processes that rely on Azure resources, it's critical to keep an…
Dennis

White Paper — Registration

You will receive the research paper by mail.

Codenotary — Webinar

White Paper — Registration

Please let us know where we can send the whitepaper on Codenotary Trusted Software Supply Chain. 

Become a partner

Start Your Trial

Please enter contact information to receive an email with the virtual appliance download instructions.

Start Free Trial

Please enter contact information to receive an email with the free trial details.

Subscribe to our newsletter