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.

• What’s New
• 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
• 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
  • Customizing Probes
    • Creating a Custom Probe
    • Deleting a Probe
    • Copying a Probe
  • Alerting
    • Using the Alerts Dashboard
    • Using the Manage Alerts Tab
      • Creating a Custom Alert Template
      • Creating a New Alert
      • Modifying or Deleting an Alert
      • Copying an Alert
      • Audit Log Alerting
      • Creating an Email Group
      • Creating Webhook
      • Defining a Webhook SSL configurations
      • Deleting a Webhook
      • Schedule Alert Blackout
    • Using PEM with Nagios
      • Enabling Nagios Notification for an Alert
      • Configuring Nagios-related behavior of the PEM Server
      • Creating the hosts.cfg and services.cfg File
      • Modifying the Nagios Configuration File
• 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
• Conclusion