Installing the SQL Profiler extension v9

You must install and enable the SQL Profiler extension on each server on which you want to use it. For example, if you have a host running PostgreSQL 14 and PostgreSQL 15, you must enable the extension on each server.

SQL Profiler is supported on the same platforms as the Postgres distribution you're using. Support for the SQL Profiler extension starts with version 11 for PostgreSQL and EDB Postgres Advanced Server and version 12 for EDB Postgres Extended. See:

• EDB Postgres Advanced Server Product Compatibility

• PostgreSQL Product Compatibility

• EDB Postgres Extended Server Product Compatibility

Installing the package

Prerequisites

Before you begin the installation process:

• Install Postgres. See:

  • Installing EDB Postgres Advanced Server

  • Installing PostgreSQL

  • Installing EDB Postgres Extended Server

• Set up the repository.

  Setting up the repository is a one-time task. If you have already set up your repository, you don't need to perform this step.

  To set up the repository, go to EDB repositories and follow the instructions provided there.

Install the package

The syntax for the install command is:

sudo <package-manager> -y install edb-<postgres><postgres_version>-server-sqlprofiler

Where:

• <package-manager>is the package manager used with your operating system:

  Package manager	Operating system
  dnf	RHEL 8 and derivatives
  zypper	SLES
  apt-get	Debian and derivatives

• <postgres> is the distribution of Postgres you're using:

  Postgres distribution	Value
  PostgreSQL	pg
  EDB Postgres Advanced Server	as
  EDB Postgres Extended	postgresextended

• <postgres_version> is the version of Postgres you're using.

For example, to install the latest version of SQL Profiler for EDB Postgres Advanced Server 15 on a RHEL 8 platform:

sudo dnf -y install edb-as15-server-sqlprofiler

Enabling the extension

To enable the extension:

1. Edit the postgresql.conf file on the server you want to profile, modifying the shared_preload_libraries parameter:

   → WrapCopy

   shared_preload_libraries = '$libdir/sql-profiler'

2. Restart the Postgres server.

3. Create the SQL Profiler extension in your maintenance database with the following command:

   → WrapCopy

   # Connect to your maintenance database using psql
   psql -d postgres -U enterprisedb
   # Create the extension
   CREATE EXTENSION sql_profiler;

After enabling the extension, SQL Profiler is ready to use with all databases that reside on the server.