Postgres Enterprise Manager’s (PEM) monitoring and alerting capabilities are key for successful Postgres-based digital business solutions that meet stringent SLAs and performance requirements. PEM collects performance and status data from the databases it monitors, from the operating system, and it collects data resulting from jobs it executes on the database host. Data is displayed in dashboards and analyzed for alert conditions. Alerts can be relayed to operators or to other enterprise-level management systems. PEM also allows DBAs and developers to work with the databases directly, execute DDL and DML commands, tune queries, manage indexes, run backups, and deploy software updates.
Postgres Enterprise Manager Architecture
Postgres Enterprise Manager offers SQL profiling to allow users to trace and diagnose queries that are run against a database. SQL Profiler provides details such as the query itself, the execution plan, the duration, and cache hits.
If only a particular set of queries is of interest, SQL Profiler allows to selectively filter the output. Traces can either be taken on-demand or scheduled. Scheduling allows DBAs to record queries at any point in time, night or day.
SQL Profiler helps developers to optimize slow running queries and to identify SQL statements that are issued from black box applications. Postgres Enterprise Manager’s Index Advisor is based on SQL Profiler and helps to identify and create missing indexes to improve query performance.
Postgres Enterprise Manager (PEM) provides comprehensive easy-to-read dashboards allowing DBAs and developers to check current and historic system performance and database statistics at any time from anywhere using any type of web browser.
DBAs can create custom dashboard views to display specific information relevant for their work and IT Operations can use another tailored dashboard view to display information on their monitoring screens, that is relevant to them.
PEM also allows time period zoom, drill down chart data and graphs, and cross hierarchy views to get a better understanding of database activity and to diagnose performance issues if needed.
Postgres Enterprise Manager monitors its configured databases 24/7. Should one of its more than 225 pre-configured probes fail, an alert will be triggered.
All probes have been designed based on Postgres best practices. However, if none of the pre-configured probes provides the information needed, custom probes can also be created.
Alerts can be configured to notify various e-mail distribution lists based on time of day. In addition, PEM provides SNMP traps and integrates with Nagios.
Constant monitoring and alerting give DBAs and developers peace of mind. Instead of repeatedly checking every single database, they can rely on PEM’s notifications, which allows them to focus on more meaningful work.
An IDE for Development
An IDE for Development
Postgres Enterprise Manager (PEM) makes SQL programming easier. Its capable SQL Editor provides an interface to write and execute queries against a managed database.
It offers syntax highlighting, indentation, auto completion and macros. Code can easily be found and replaced, copied from and to a local editor, or read from and written to a file. It also supports functions and EDB Postgres Advanced Server’s procedural language.
The SQL Editor works with PEM’s Graphical Query Builder. It helps to write queries and ensures that even complicated queries with multiple joins will be built correctly. Once a query has been created, it offers to analyze the query and provides a graphical explain plan.
PEM is a handy assistant for developing new SQL queries and provides immediate verification.
- Capacity Manager demo
- Architectural overview
- Installing the PEM Server
- Installing the PEM Client
- Installing the PEM Agent
- Installing the SQL Profiler Plugin