Use the statement_statistics to identify queries that are most affected by garbage... The statement below could be used.
select
cast(statistics->'execution_statistics'->'mvccIteratorStats'->'pointCount'->'mean' as INTEGER) as pointCount,
cast(statistics->'execution_statistics'->'mvccIteratorStats'->'seekCount'->'mean' as INTEGER) as seekCount
from crdb_internal.statement_statistics
where fingerprint_id='\x9b1ad34c7012c1fb';
pointcount | seekcount
-------------+------------
5 | 2
4980000 | 2
Use the
statement_statisticsto identify queries that are most affected by garbage... The statement below could be used.