openstack team mailing list archive

[Sam Morrison <sorrison@xxxxxxxxx>]

On 26/02/2013, at 4:31 PM, Chris Behrens <cbehrens@xxxxxxxxxxxx> wrote:

> After thinking more, it does seem like we're doing something wrong if the query itself is returning 300k rows. :)  I can take a better look at it in front of the computer later if no one beats me to it.

Yeah I think it's more than a missing index :-)

The query does 2 INNER JOINS on aggregate_hosts then 2 INNER JOINS on aggregate_metadata then does a further 2 LEFT OUTER JOINS on aggregate_hosts.
Thanks for the help,
Sam