This repository has been archived by the owner on Mar 26, 2024. It is now read-only.

reports:prune:orphaned taking a lot of time #324

Open

bigon opened this issue Jun 24, 2015 · 0 comments

Labels

Bug

Milestone

bigon commented Jun 24, 2015

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))

swoopla mentioned this issue

Add optimize/orphaned for postgresql database & append many modification for debian #333

Closed

ZeroPointEnergy added this to the Release 3.2 milestone

ZeroPointEnergy added the Bug label

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.