reports:prune:orphaned taking a lot of time

[bigon]

Hi,

I think that the queries in the "reports:prune:orphaned" target are not really optimized.

On my PE setup (using postgresql), the following query is now running for more than an hour just to do a count

SELECT COUNT(*) FROM "metrics"  WHERE (report_id not in (select id from reports))