Blueprints main page times out

[Cristian Gonzalez]

Accessing the Blueprints main page at https://blueprints.launchpad.net/ leads to a time out error.

See the OOPS link here
https://oops.canonical.com/oops/?oopsid=OOPS-863b6064e82db633aabf181eccfb2c92

And the related query explain extracted from staging here:
https://pastebin.canonical.com/p/sf8Zd8VTf8/

A potential fix for it would be adding the following index:
CREATE INDEX specification__date_completed__id__idx ON specification (date_completed, id DESC);