ReferencePDF version

Analytic Database Server Metrics

Lists the Workload XM metrics collected from the Analytic Database (ADB) Server.

Table 1. Workload XM Analytic Database server metrics
Metric Name Description Type Unit
wxm_adb_service_heap_used The amount of JVM heap memory that is used on this server Memory bytes
wxm_adb_service_heap_max The maximum amount of JVM heap memory that is used on this server Memory bytes
wxm_adb_service_gc_ps_scavenge_collection_time The time taken to free up memory on this server by the PS Scavenge garbage collector Garbage Collection milliseconds
wxm_adb_service_gc_ps_marksweep_collection_time The time taken to free up memory on this server by the PS MarkSweep garbage collector Garbage Collection milliseconds
wxm_adb_service_aqe_executed The total number of jobs received Counter: AQE counts
wxm_adb_service_aqe_throttled_count The total number of jobs that failed Counter: AQE counts
wxm_adb_service_total_impala_queries The total number of Impala queries received Counter: Imapla Query counts
wxm_adb_service_failed_impala_queries The total number of Impala queries that failed Counter: Imapla Query counts
wxm_adb_service_total_pse_root The total number of PSE Root records Counter: PSE Root counts
wxm_adb_service_failed_pse_root The total number of PSE Root records that failed Counter: PSE Root counts
wxm_adb_service_impala_query_processing_timer_count The number of calls used to calculate the processing timer metric Processing Timer: Impala Query calls
wxm_adb_service_impala_query_processing_timer_max The maximum time taken by a call for processing Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_avg The average time taken by a call for processing Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_min The minimum time taken by a call for processing Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_50th_percentile The time in which 50% of the calls are processed Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_75th_percentile The time in which 75% of the calls are processed Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_95th_percentile The time in which 95% of the calls are processed Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_98th_percentile The time in which 98% of the calls are processed Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_99th_percentile The time in which 99% of the calls are processed Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_999th_percentile The time in which 99.9% of the calls are processed Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_stddev The standard deviation of the Impala processing timer metric Processing Timer: Impala Query seconds
wxm_adb_service_impala_query_processing_timer_15min_rate The rate of incoming calls during the last 15 minutes Processing Timer: Impala Query calls/seconds
wxm_adb_service_impala_query_processing_timer_1min_rate The rate of incoming calls during the last minute Processing Timer: Impala Query calls/seconds
wxm_adb_service_impala_query_processing_timer_5min_rate The rate of incoming calls during the last 5 minutes Processing Timer: Impala Query calls/seconds
wxm_adb_service_impala_query_processing_timer_mean_rate The average rate of incoming calls Processing Timer: Impala Query calls/seconds
wxm_adb_service_impala_query_profile_payload_size_histogram_count The number of calls used to calculate the payload metrics Payload Size: Impala Query calls
wxm_adb_service_impala_query_profile_payload_size_histogram_max The maximum payload size Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_avg The average payload size Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_min The minimum payload size Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_50th_percentile The payload size when 50% of the calls are less than this metric's threshold value Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_75th_percentile The payload size when 75% of the calls are less than this metric's threshold value Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_95th_percentile The payload size when 95% of the calls are less than this metric's threshold value Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_98th_percentile The payload size when 98% of the calls are less than this metric's threshold value Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_99th_percentile The payload size when 99% of the calls are less than this metric's threshold value Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_999th_percentile The payload size when 99.9% of the calls are less than this metric's threshold value Payload Size: Impala Query bytes
wxm_adb_service_impala_query_profile_payload_size_histogram_stddev The standard deviation of the Impala payload size metric Payload Size: Impala Query bytes

We want your opinion

How can we improve this page?

What kind of feedback do you have?