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?
Related Articles
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 ...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 ...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 ...Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the steps below for troubleshooting: Step 1: Check the RUM Agent configuration Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...Self monitor Applications Manager using Real User Monitoring
We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...