EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Reference User Guides Quick Start
  • Product
    EDB Backup and Recovery Tool EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Connectors EDB Postgres Containers EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Data Adapter EDB Postgres JDBC Connector EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres .NET Connector EDB Postgres OCL Connector EDB Postgres PgBouncer EDB Postgres Replication Server PostgreSQL pgAdmin 4

EDB Postgres Enterprise Manager → 6.0.1 → Installation & Getting Started → Installation Guide
Other versions of this page: 7.8 · 7.7 · 7.6 · 7.5 · 7.4 · 7.3 · 7.2 · 7.1 · 7.0 · 6.0.2 · 6.0.1

Other Resources

  •  Download Postgres
  •  Free Postgres Training
  •  Webinar: Managing Postgres at Scale

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

 Try it Now Free

Table of Contents Previous Next


5 Installing the SQL Profiler Plugin

5 Installing the SQL Profiler Plugin
The SQL Profiler Plugin allows you to profile a server's workload. You must install the plugin on each server on which you wish to use SQL Profiler (since it is a plugin to the database server, you must install a copy of the plugin for each Postgres instance you wish to profile on each host you wish to profile). For example, if you have a host running PostgreSQL 9.2 and PostgreSQL 9.5, you must install two versions of the plugin, one for each server.
SQL Profiler for Postgres Enterprise Manager™ is officially supported only on the EnterpriseDB distributions of PostgreSQL version 9.1 (and above) and Advanced Server version 9.1 (and above). The plugin is distributed via StackBuilder, or is available from the EnterpriseDB website at:
http://www.enterprisedb.com/download-postgres-enterprise-manager
The plugin is also distributed and installed with the server component of the Advanced Server 9.1 (and above) installer.
The SQL Profiler plugin may be installed on servers with or without a PEM agent, however traces can only be run in ad-hoc mode on unmanaged servers, and may only be scheduled on managed servers.
Follow the installation steps listed below to install the plugin for PostgreSQL before continuing to the Configuration section. If you are using Advanced Server 9.1 or above, skip ahead to the Configuration section.

5 Installing the SQL Profiler Plugin

Table of Contents Previous Next
© 2019 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks