3113245 add index build(package.id)

Authored and Committed by msuchy 5 years ago
    add index build(package.id)
    
    This address:
    coprdb=# explain analyze SELECT package.id AS package_id, package.source_json AS source_json, build.pkg_version AS pkg_version, package.copr_id AS copr_id
    coprdb-#                 FROM package
    coprdb-#                 LEFT OUTER JOIN build ON build.package_id = package.id
    coprdb-#                 WHERE package.source_type = 5 AND
    coprdb-#                       package.source_json ~* '()' AND
    coprdb-#                       package.webhook_rebuild = true AND
    coprdb-#                       (build.id is NULL OR build.id = (SELECT MAX(build.id) FROM build WHERE build.package_id = package.id));
    
    before
     Planning time: 26.548 ms
     Execution time: 61695.949 ms
    after
     Planning time: 1.708 ms
     Execution time: 726.944 ms