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:
Installing the package
Before you begin the installation process:
Install Postgres. See:
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:
<package-manager>is the package manager used with your operating system:
Package manager Operating system dnf RHEL 8 and derivatives yum RHEL 7 and derivatives, CentOS 7 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:
Enabling the extension
To enable the extension:
postgresql.conffile on the server you want to profile, modifying the
Restart the Postgres server.
Create the SQL Profiler extension in your database with the following command:
If you are connected to the PEM server with the PEM client before configuring SQL Profiler, you must disconnect and reconnect with the server to enable SQL Profiler functionality.
After enabling the extension, SQL Profiler is ready to use with all databases that reside on the server.
- On this page
- Installing the package
- Enabling the extension