Add index to WebHooks on project based hooks
What does this MR do and why?
Based on the `GET /api/:version/projects/:id/hooks` can be slow (#364446) and Andy's comment, we're adding a new index that might bring us some improvements.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Screenshots or screen recordings
Without Index | With new Index |
---|---|
https://console.postgres.ai/shared/ea6394f8-2c4a-4923-a212-95cda0f0cda2 | https://console.postgres.ai/shared/451629a4-8783-49a1-aa0e-b7ce42451cca |
How to set up and validate locally
N/A