Create view for registrations monitoring

[sfauvel]

Content

Create a view replacing the complex SQL query for aggregated registrations

This PR includes the view creation and the runbook update

Pre-submit checklist

• Branch
  • [x] Tests are provided (if possible)
  • [x] Crates versions are updated (if relevant)
  • [ ] CHANGELOG file is updated (if relevant)
  • [x] Commit sequence broadly makes sense
  • [x] Key commits have useful messages
• PR
  • [x] No clippy warnings in the CI
  • [x] Self-reviewed the diff
  • [x] Useful pull request description
  • [x] Reviewer requested
• Documentation
  • [ ] Update README file (if relevant)
  • [ ] Update documentation website (if relevant)
  • [ ] Add dev blog post (if relevant)

Comments

Issue(s)

Closes #2067

[github-actions[bot]]

Test Results

    4 files  ±0     51 suites  ±0   10m 32s ⏱️ +2s 1 423 tests +5  1 423 ✅ +5  0 💤 ±0  0 ❌ ±0  1 634 runs  +5  1 634 ✅ +5  0 💤 ±0  0 ❌ ±0 

Results for commit b4908699. ± Comparison against base commit f67adf11.

:recycle: This comment has been updated with latest results.