Comment 10 for bug 618406

Revision history for this message
Robert Collins (lifeless) wrote :

candidate missing indices (first one will replace bugtask__product__heat__idx)

CREATE INDEX bugtask__product__heat__id__idx ON bugtask USING btree (product, heat desc, id) WHERE product IS NOT NULL;
CREATE INDEX bugtask__distribution__head__id__idx ON bugtask USING btree(distribution, heat desc, id) WHERE bugtask IS NOT NULL;