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?
Related Articles
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 ...Mail Server Monitor - Troubleshooting
Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...While trying to monitor servers, I get a "No data Available" error for CPU Core Utilization.
The data for CPU Core utilization may not be shown due to problem in executing and getting the output of CPU command on the server. For different modes of monitoring (WMI/Telnet/SSH/SNMP) we use different methods to collect data. Find the steps below ...How to configure Output Settings for Script Monitor?
Below are the details on how to configure Script Monitor Output Settings and expected output format, Output Configuration: Expected Output File Format: In the output file, Scalar data should be separated by scalar delimiter, here name, cpu, javaHeap ...DNS Monitor - Troubleshooting
Common DNS Monitor Errors and Troubleshooting Guide 1. Host Not Found Description: The DNS server was unable to locate the requested lookup address. Possible Causes: This may happen if the hostname is incorrect, the domain does not exist, or there is ...