{"push_id":1482013835,"size":2,"distinct_size":0,"ref":"refs/heads/deployed-to-integration","head":"4b57f69ee7801e25ceaffca579db454a51ebaf16","before":"0dc321d01d4a9a3c8cce170d66241c7dada5c68f","commits":[{"sha":"937e3110b83841ea0054b5b64068b88794151f82","author":{"name":"Daniel Roseman","email":"089695ef89e29ac9b397d8b0ec4b8817c89b02f0@digital.cabinet-office.gov.uk"},"message":"Fix slow query in lookup_previous_item.\n\nRails adds an `ORDER BY id` when you call `first` if there's no other\nordering on the query; this was causing Postgres to choose an expensive\nscan on the id index, rather than using the content_id/locale/state\nindex. Explicitly ordering by content_id allows it to choose the\nright idnex.","distinct":false,"url":"https://api.github.com/repos/alphagov/publishing-api/commits/937e3110b83841ea0054b5b64068b88794151f82"},{"sha":"4b57f69ee7801e25ceaffca579db454a51ebaf16","author":{"name":"Daniel Roseman","email":"4b94a04674ad2c69d990e94ab196ac3f8e9e03d4@roseman.org.uk"},"message":"Merge pull request #701 from alphagov/fix-slow-previous-query\n\nFix slow query in lookup_previous_item.","distinct":false,"url":"https://api.github.com/repos/alphagov/publishing-api/commits/4b57f69ee7801e25ceaffca579db454a51ebaf16"}]}
{"actor":{"display_login":"govuk-ci"}}