grahamc/hydra - Change E46TNJK6LJK5GSNQM63D647NXTAKXZNG6N6O6B3ETOMDKPGCD6KQC

Use faster query to determine number of running builds

The previous query

select count(*) from builds b left join buildsteps s on s.build = b.id where busy = 1 and finished = 0

is suddenly taking several minutes. Probably PostgreSQL decided to use a suboptimal query plan.

Created by Eelco Dolstra on March 16, 2016

E46TNJK6LJK5GSNQM63D647NXTAKXZNG6N6O6B3ETOMDKPGCD6KQC

Dependencies

[2] TPNHTE5VJ36IPKMFENDERDBFBHLYFXOVNDLV2QSC4G5STPPMBLMAC
[3] K42RSSSITOALPCQVUO7YUAFPI5QWKZOI4ITZSZ4DVGK3Y76AXN7QC
[4] J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC
[5] CQTN62OHT4DY35E2MJEG7GFTVNEE5KRDMV6ASBQLBHN7BUDK7WHAC

In channels

main

upstream

Change contents

Replacement in src/lib/Hydra/Controller/Root.pm at line 48 [4.804]

B:BD[3.54] → [2.851:1059]

        $c->stash->{nrRunningBuilds} = $c->model('DB::Builds')->search(
            { finished => 0, 'buildsteps.busy' => 1 },
            { join => 'buildsteps', select => ["id"], distinct => 1 })->count();

[3.54]

[5.2622]

        $c->stash->{nrRunningBuilds} = $c->model('DB')->schema->storage->dbh->selectrow_array(
            "select count(distinct build) from buildsteps where busy = 1");