REAL-TIME MONITORING AND ANALYSIS OF QUERY EXECUTION

摘要

Example embodiments relate to providing real-time monitoring and analysis of query execution. In example embodiments, a query plan is obtained for a database query that is scheduled for execution in a database. A query tree is then generated based on the query plan, where the query tree includes operator nodes that are associated corresponding operators in the query plan. At this stage, performance metrics are collected from the database during the execution of the database query. Next, the query tree is displayed with the performance metrics, where a related portion of the performance metrics are displayed in each of the operator nodes.

主权项

1. A system for providing real-time monitoring and analysis of query execution, the system comprising of:
a processor to:
obtain a query plan for a database query that is scheduled for execution in a database;generate a query tree based on the query plan, wherein the query tree comprises a plurality of operator nodes each of which is associated with a corresponding operator in the query plan;collect performance metrics from the database during the execution of the database query;display the query tree with the performance metrics, wherein a related portion of the performance metrics are displayed in each of the plurality of operator nodes; andin response to receiving updated performance metrics from the database, update the related portion displayed in each of the plurality of operator nodes based on the updated performance metrics.