PostgreSQL Database Monitoring

Log in to Applicare controller and navigate to the Server Analyzer menu to view the details.

Dashboard

Database performance metrics assist in monitoring and optimize your database's performance in your business. The metrics are calculated for the entire server, not limited to the database specified in the JDBC URL.

Screenshot 1 — PostgreSQL Database Monitoring

SQL

SQL Statement Profiling provides the performance statistics of database queries. It helps you identify which statements are the most time and quickly diagnose performance issues SQL/s. Additionally, It provides detailed stats, including information on the database, query count, average execution time and various percentiles.

Screenshot 2 — PostgreSQL Database Monitoring

OS

This view offers a quick and convenient overview of your physical server's/VM's performance including details on the number of processes, context switches, CPU Usage, memory, storage performance and more.

Screenshot 3 — PostgreSQL Database Monitoring

CPU CORE Analyzer

This view presents an overview of the overall CPU as well as detailed information about each individual CPU core.

Screenshot 4 — PostgreSQL Database Monitoring

Processes

This view offers organized performance stats for CPU, memory and running processes. It includes historical snapshots of various processes, showing their resources consumption at specific times. By default, Applicare captures these snapshots every 10 minutes but you can adjust by changing the interval as needed.

Screenshot 5 — PostgreSQL Database Monitoring

Disk

This view displays the disk usage for each individual process.

Screenshot 6 — PostgreSQL Database Monitoring

Network Connections

This view offers detailed information on TCP, UDP, RAW, and UNIX connection.

Screenshot 7 — PostgreSQL Database Monitoring

SQL Report

You can download SQL statements as a report by clicking the print icon on the SQL Screen within the Server Analyzer menu.

Screenshot 8 — PostgreSQL Database Monitoring

Screenshot 9 — PostgreSQL Database Monitoring

Screenshot 10 — PostgreSQL Database Monitoring

Configuration

PostgreSQL Database Setup

Monitoring with Applicare

Was this article helpful?

Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.

Opens Zendesk · needs internet and sign-in

Still stuck? Contact support