Additional Features of PEM over PgAdmin
Tags: apacheage, pgadmin, postgres
Published: 2023-08-26 14:02:24


Postgres Enterprise Manager (PEM), a PostgreSQL database management tool, sets itself apart from PgAdmin with a number of cutting-edge capabilities. PEM offers a complete toolkit that makes it a popular solution, from reducing log management to providing reliable capacity assessments and automated tuning recommendations. Let's look at PEM's distinguishing features that make it the go-to choice for people looking for advanced database administration solutions.

**Multiple Dashboards:**
PEM uses several dashboards to present performance statistics. Each dashboard has a number of summary views that show the information pertaining to the selected object in the form of graphs, tables, and charts.

**Monitoring:**
PEM  Monitoring feature provides thorough real-time and archival performance insights for numerous PostgreSQL clusters, their host servers, and database objects. It enables remote monitoring with PEM Agents, assuring administrators can easily maintain the security and health of their PostgreSQL setups, actively detect and address errors, and optimize query performance.

**Probes:**
A probe is a scheduled task that retrieves details about the database objects the PEM agent is tracking. PEM constructs the graphs seen on each homepage using the data gathered. You can change the frequency of data collection and how long PEM keeps the information supplied by a particular probe by using the Management > Manage Probes tab.

**Query Analysis:**
The Query tool is a robust, feature-rich environment that enables you to run any SQL command and examine the result set. Query tool makes database management simpler by enabling users to update result sets, view connection status, export data, and enhance performance through execution plan analysis.

**Audit Manager:**
Configuring audit logs for instances of EDB Postgres Advanced Server is made simpler by the PEM Audit Manager. You can configure parameters like log collection frequency, log rotation intervals, and logged activities. These audit logs cover a range of operations, including SQL operations and connections and disconnections. The Audit Log dashboard provides filtering options based on timestamps, databases, users, and command types and gives a user-friendly interface for thorough log inspection and analysis, making it simple to analyze logs after storing them on the PEM server.

**Log Manager:**
For Postgres instances, PEM Log Manager  enables simplified server log settings. It gives you complete control over crucial factors including log file locations, log write frequency, log content, log input formats, and log rotation settings. This program makes it easier to manage server logs, resulting in effective PostgreSQL instance monitoring and troubleshooting.

**Capacity Manager:**
For PostgreSQL systems, Capacity Manager  provides a potent analytics tool. It makes use of gathered statistics to present past usage data in the form of graphs or tables and even forecasts usage trends for the future. Due to its adaptability, you can fine-tune it to track and project usage statistics for certain targets, be they hosts, servers, databases, or database objects. For maximizing resource allocation and preserving peak performance in your PostgreSQL ecosystem, PEM's Capacity Manager is a useful tool.

**Tuning Wizard:**
The Tuning Wizard examines your installation of PostgreSQL or EDB Postgres Advanced Server and makes setup recommendations based on the expected workload for the installation. Benchmarking systems or the systems with a lot of work might require manual tuning to perform at their best.

**Reports:**
System Configuration and Core Usage reports can be generated for both local and remote servers utilizing PEM's reports capability. Simply go to the Management Menu and select Reports. Core Usage Reports and system configuration reports in JSON or HTML format are two options. The reports will  include information from the most recent investigation run.