There is an extensive array of performance metrics. This includes:

  • Cluster status summary with thread counts, CPU utilization, interconnect traffic, clean and dirty cache pages, virtual memory swapping warning, etc. This is either a cluster total or a total with breakdown per cluster node.

  • Disk access, lock contention, general concurrency, and access count per index

  • Statistics on memory usage for disk caching index-by-index, cache replacement statistics, disk random and sequential read times

  • Count of random, sequential index access, disk access, lock contention, cluster interconnect traffic per query/client

  • Detailed query-execution plans are available through the explain function