Installing EDB Stat Monitor
EDB Stat Monitor is an extension that provides query performance monitoring for EDB Postgres Advanced Server and PostgreSQL. It collects and stores statistics about query execution, allowing you to analyze and optimize query performance.
Installing EDB Stat Monitor
edb_stat_monitor
is supported on the same platforms as the Postgres distribution you're using. Support for edb_stat_monitor
starts with Postgres 15. For details, see:
- EDB Postgres Advanced Server Product Compatibility
- PostgreSQL Product Compatibility
- EDB Postgres Extended Server Product Compatibility
Installation
Before you begin the installation process:
Install Postgres. See:
Set up the repository.
Setting up the repository is a one-time task. If you've already set up your repository, you don't need to perform this step.
To set up the repository, go to downloads and repositories and follow the instructions provided there.
Install the package
The syntax for the package install command is:
# For SLES, CentOS, RHEL and its derivatives sudo <package-manager> -y install edb-<postgres><postgres_version>-stat_monitor
<package-manager>
is the package manager used with your operating system:Package manager Operating system dnf RHEL 8/9 and derivatives zypper SLES 15
<postgres>
is the distribution of Postgres you're using:Postgres distribution Value EDB Postgres Advanced Server as EDB Postgres Extended Server postgresextended PostgreSQL pg <postgres_version>
is the version of Postgres you're using.
For example, to install edb_stat_monitor for EDB Postgres Advanced Server 16 on a RHEL 8 based platform:
sudo dnf -y install edb-as16-stat_monitor
sudo apt-get -y install edb-<postgres><postgres_version>-stat-monitor
<postgres>
is the distribution of Postgres you're using:Postgres distribution Value EDB Postgres Advanced Server as EDB Postgres Extended Server postgresextended PostgreSQL pg <postgres_version>
is the version of Postgres you're using.
For example, to install edb_stat_monitor for EDB Postgres Advanced Server 16 on a Debian based platform:
sudo apt-get -y install edb-as16-stat-monitor
Now move to the Configuring EDB Stat Monitor documentation to configure the extension and start using it.
Could this page be better? Report a problem or suggest an addition!