Comment 3 for bug 1848049

Executing the following:

SELECT metric.id AS metric_id, metric.archive_policy_name AS metric_archive_policy_name, metric.creator AS metric_creator, metric.resource_id AS metric_resource_id, metric.name AS metric_name, metric.unit AS metric_unit, metric.status AS metric_status, archive_policy_1.name AS archive_policy_1_name, archive_policy_1.back_window AS archive_policy_1_back_window, archive_policy_1.definition AS archive_policy_1_definition, archive_policy_1.aggregation_methods AS archive_policy_1_aggregation_methods
FROM metric LEFT OUTER JOIN archive_policy AS archive_policy_1 ON archive_policy_1.name = metric.archive_policy_name
WHERE metric.status = 'active' ORDER BY metric.id ASC;

Generated:
2482004 lines