The Query Performance Report is being updated to remove some limitations and is temporarily unavailable.
Only users having TD_SYS_CONF_REPORTS_USER role can view the system reports.
VantageCloud Lake now includes a system defined report named Query Performance Summary report. It displays widgets, such as, total number of queries, breakdown by query status, average Impact CPU, and so on. This report helps DBAs, developers, and data scientists to better understand the system performance and plan for necessary adjustments.
Data Generation
By default, no data is generated for the system report. Follow the steps to generated data for the first time.
Once the system report with data is generated, you can only refresh the data.
- Open the Reports page.
- Select the System Report row. You will see the status as Not started.
- Select and then Generate data. By default, the report generates with data for the current month.
Refreshing Data Using Timeframe Based Filters
Once the query performance report is available, you can refresh the data to evaluate the latest performance. You can apply various timeframe based filters, such as, months, weeks, and so on to generate data for the specific period.
- From the Reports page, select the Query Performance Report.
- Select the timeframe based filters, such as, Month, Week, and Custom to specify the required data range.
- Select
to refresh the report and view the widgets with latest data.