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

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

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

shared_preload_libraries = 'sys_stat_statements'

sys_stat_statements.track = all

    2. Execute the below commands in psql shell if the extension sys_stat_statements is not available:

CREATE EXTENSION sys_stat_statements;

    3. Restart the KingbaseDB server.

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


                  New to ADSelfService Plus?