cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Diagnostic dashboard in PEM

 

Issue: PEM web console display below error when open Performance Diagnostic dashboard.

 

Error: This tool can be run only if user is superuser,edb_wait_states plugin is loaded and its respective functions are present in the maintenance database

 

PEM Diagnostics.png

 

Solution:

 The console will display the error message as below if you do not meet the prerequisites.

 

Prerequisites

 

  • You must have superuser privileges to access the Performance Diagnostic dashboard.
  • You must ensure that the EDB Wait States module is installed. Modify thepostgresql.conffile, adding theedb_wait_stateslibrary to the list of libraries in theshared_preload_librariesparameter.

Steps to resolve:

 

Step 1: edb_wait_statesis installed with the edb-asxx-server-edb-modules RPM package (where xx is the Advanced Server version number).

 

Step 2: To launch the worker, it must be registered in thepostgresql.conf file using theshared_preload_librariesparameter:

 

shared_preload_libraries = '$libdir/edb_wait_states'

Step 3: Restart the database server. After a successful restart, the background worker begins collecting data.

 

Step 4: To review the data, create the following extension:

 

CREATE EXTENSION edb_wait_states;

Step 5: To terminate theedb_wait_statesworker, remove$libdir/edb_wait_statesfrom theshared_preload_librariesparameter and restart the database server.

Version history
Revision #:
7 of 7
Last update:
‎07-09-2019 06:30 PM
Updated by: