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



 The console will display the error message as below if you do not meet the 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: