PEM Enterprise Features Guide

This guide will acquaint you with the tools and wizards that are built into the Postgres Enterprise Manager (PEM) web interface that make it easier for you to monitor and manage your system.

This guide is not a comprehensive resource; rather, it is meant to serve as an aid to help you evaluate the tool and bring you up to speed with the basics of how to use the product. For more detailed information about using PEM’s functionality, please see the online help made available by the PEM client.

This document uses Postgres to mean either the PostgreSQL or EDB Postgres Advanced Server database or EDB Postgres Extended (formerly known as 2ndQPostgres).

• The PEM Query Tool
  • The SQL Editor Panel
  • The Data Output Panel
    • Data Output Tab
    • Explain Tab
    • Graphical Tab
    • Analysis Tab
    • Statistics Tab
    • Messages Tab
    • Notifications Tab
  • Query History Panel
  • Connection Status
  • Macros
• The PEM Schema Diff Tool
  • The Schema Diff Object Comparison Panel
  • Schema Diff DDL Comparison Panel
• The ERD Tool
  • Toolbar
  • File Options
  • Export Options
  • Editing Options
  • Table Relationship Options
  • Utility Options
  • Zoom Options
  • Table Dialog
  • Table Node
  • The One to Many Link Dialog
  • The Many to Many Link Dialog
  • The Table Link
  • The Table Notes
• Performance Monitoring and Management
  • Using Dashboards to View Performance Information
  • Managing Custom Dashboards
    • Creating a Custom Dashboard
    • Creating an Ops Dashboard
  • Using the Manage Charts tab
    • Creating a Custom Chart
    • Importing a Capacity Manager Template
  • Probes
    • System Probes
    • BDR Probes
    • Customizing Probes
  • Alerting
    • Viewing the Alerts via Global Dashboard
    • Viewing the Alerts via Alerts Dashboard
    • Managing Alerts
  • Notifications
    • SMTP
    • Webhook
    • SNMP
    • Using PEM with Nagios
• Capacity Manager
  • Capacity Manager Templates
• Audit Manager
  • Setting the Advanced Server Instance Service ID
  • Setting the EDB Audit Configuration Probe
  • Configuring Audit Logging with the Audit Manager
  • Viewing the Log with the Audit Log Dashboard
• Log Manager
  • Reviewing the Server Log Analysis Dashboard
  • Postgres Log Analysis Expert
  • Reviewing the Postgres Log Analysis Expert Report
• SQL Profiling and Analysis
  • Creating a New SQL Trace
    • Creating a Trace
    • Opening an Existing Trace
    • Filtering a Trace
    • Deleting a Trace
    • Viewing Scheduled Traces
  • Using the Index Advisor
• Tuning Wizard
• Postgres Expert - Best Practice Enforcement
  • Using the Postgres Expert Wizard
  • Reviewing Postgres Expert Recommendations
• Reports
  • System Configuration Report
  • Core Usage Report
• Monitoring Failover Manager
  • Replacing a Primary Node
  • Switchover EFM Cluster
• Monitoring an xDB Replication Cluster
• Performance Diagnostic
• Reference
  • PEM Server Configuration Parameters - Reference
  • Capacity Manager Metrics - Reference
  • PEM Probes – Reference
  • PEM Pre-defined Alert Templates – Reference
    • Templates applicable on Agent
    • Templates applicable on Server
    • Templates applicable on Database
    • Templates applicable on Schema
    • Templates applicable on Table
    • Global Templates
• Monitoring BDR Nodes