The slow queries tab on YBA/ YBM shows the count of executions of a given query and the number of rows impacted. We should also show the number of live rows and tombstones read at the docdb layer as part of the query. This is useful to identify queries that might be scanning a lot more tombstones compared to useful rows.
Should this information also be part of the live queries page?
If there are other enhancements planned in this area, it would be nice to piggyback this enhancement with them.
Issue Type
kind/enhancement
Warning: Please confirm that this issue does not contain any sensitive information
[X] I confirm this issue does not contain any sensitive information.
Jira Link: DB-14181
Description
The slow queries tab on YBA/ YBM shows the count of executions of a given query and the number of rows impacted. We should also show the number of live rows and tombstones read at the docdb layer as part of the query. This is useful to identify queries that might be scanning a lot more tombstones compared to useful rows.
Should this information also be part of the live queries page?
If there are other enhancements planned in this area, it would be nice to piggyback this enhancement with them.
Issue Type
kind/enhancement
Warning: Please confirm that this issue does not contain any sensitive information