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 ...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 prerequisites to be done Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...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 ...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) ...Permissions required for Non-Admin user to monitor Microsoft Monitors
1) To enable WMI permissions for the non admin account follow the steps mentioned in the below link. https://pitstop.manageengine.com/portal/en/kb/articles/configuring-non-admin-user-account-for-wmi-monitoring As an alternative to Steps 1-6 in the ...