Resolve "ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout"
What does this MR do?
Uses a PostgreSQL CTE to optimize querying/deleting Todos, which was timing out.
What are the relevant issue numbers?
Closes #50359 (closed)
Does this MR meet the acceptance criteria?
-
Changelog entry added, if necessary [ ] Documentation created/updated-
Tests added for this feature/bug -
Conforms to the code review guidelines -
Conforms to the merge request performance guidelines -
Conforms to the style guides -
Conforms to the database guides
Edited by Brett Walker