Use sp_metrics ‘flush’ to flush all aggregated metrics in memory to the system catalog.The aggregated metrics for all statements in memory are set to zero.
sp_metrics ‘drop’, ‘@gid’ [, ‘@id'
To remove one entry, use:
sp_metrics ‘drop’, ‘<gid>’, ‘<id>’
You can also use filter to remove QP metrics from the system catalog, based on some metrics conditions:
sp_metrics ‘filter’, ‘@gid’, [, ‘@predicate’]
This example deletes all QP metrics in group 1 where lio_max < 100:
sp_metrics ‘filter’,’1’,’lio_max < 100'
