Skip to content

Modify list errors and get errors query to move filtering inside subqueries

Arun Sori requested to merge arun/modify-list-errors into main
  • Modify list errors query to move filter in sub-queries. This improves index usage and reduces the number of rows scanned for filling in left joins. Also supply additional settings to make sure concurrent reads are performed since number of granules generally is quite low with indexes.
  • Modify list events query to fetch specific columns.
  • Logs list errors query if it takes longer than 1 second. Over current observability doesn't allow me to look into specific of which project it takes longer for. Our tracing API calls are a WIP with #2774 so currently it doesn't load when filtered with service names.
  • Tested on devvm.

Related to #2551

Edited by Arun Sori

Merge request reports