What are the prerequisites required to monitor 'Top 10 Queries By CPU' in PostgreSQL monitor?

What are the prerequisites required to monitor 'Top 10 Queries By CPU' in PostgreSQL monitor?

    1. Include the below lines in postgrsql.conf file located in <Data DIRECTORY>:

shared_preload_libraries = 'pg_stat_statements'

pg_stat_statements.track = all

    2. Execute the below commands in psql shell:

CREATE EXTENSION pg_stat_statements;

    3. Restart the PostgreSQL server.

After the PostgreSQL monitor gets added in Applications Manager, poll the monitor to obtain the data for 'Top Query By CPU' table.



                  New to ADSelfService Plus?