The pipeline charts were hitting a database timeout because the SQL
query used `ORDER BY id desc`, which caused the database to scan all
rows instead of only the rows indexed by `project_id`. To fix this
query, we create an index on (project_id, id DESC).

Closes https://gitlab.com/gitlab-org/gitlab/issues/118746