Skip to content

Add index to WebHooks on project based hooks

Bojan Marjanovic requested to merge bmarjanovic/add-index-to-web-hooks into master

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

Merge request reports