grahamc/hydra2 - Change QMC6IMJQ3CTMLLEERF5YT7JS3RJW4UJ2BKEJA43WRQ5OL72G6ZMAC

Split timeSpent query into 2 separate queries, as postgresql isn't able to figure out a decent query plan. With 120k jobs in queue, this makes some queries go from 100s to 1-2s.

Created by Eelco Dolstra on May 1, 2015

QMC6IMJQ3CTMLLEERF5YT7JS3RJW4UJ2BKEJA43WRQ5OL72G6ZMAC

Dependencies

In channels

main

Change contents

Replacement in src/script/hydra-queue-runner at line 151 [3.7823]

B:BD[2.335] → [2.335:446]

                            { where => \ ("(finished = 0 or (me.stoptime >= " . (time() - $windowSize) . "))")

[2.335]

[2.446]

                            { where => \ ("(finished = 0)")
                            , join => 'buildsteps'
                            , select => \ "sum(coalesce(buildsteps.stoptime, ${\time}) - buildsteps.starttime)"
                            , as => "sum" })->single->get_column("sum") // 0;
                        $timeSpent += $jobset->builds->search(
                            { },
                            { where => \ ("(me.stoptime >= " . (time() - $windowSize) . ")")