Project branches API endpoint results in 504 for larger returns

[Venefilyn]

What happened? What is the problem?

Checking the Gateway Timeout for my project results in a 504 gateway error. Seems like a sub-optimal SQL query is being executed and with the large amount of data returned it simply times out

What did you expect to happen?

It loads the endpoint and the data in a timely manner

Example URL(s)

https://prod.packit.dev/api/projects/github.com/oamg/convert2rhel/branches - 504 gateway timeout https://prod.packit.dev/api/projects/github.com/packit/packit/branches - loads successfully but takes a long time

Steps to reproduce

1. Go to API for oamg/convert2rhel
2. Wait
3. See 504 Gateway Timeout

What is the impacted category (job)?

General

Workaround

• [ ] There is an existing workaround that can be used until this issue is fixed.

Participation

• [ ] I am willing to submit a pull request for this issue. (Packit team is happy to help!)