Hey folks 👋 My team is triaging an issue with high DB CPU utilization on a SpiceDB query.

UPDATE relation_tuple SET deleted_xid = $1 WHERE deleted_xid = $2 AND namespace = $3 AND object_id = $4 AND relation = $5 AND userset_namespace = $6 AND userset_object_id = $7

According to performance insights it appears this query is taking around 1.6s on average to return on our

m7g.large

RDS instance with very limited limited load ~6 request-per-second across all queries (.5 requests per second on this query alone) Just curious if you folks might have any leads before we start digging into this. Happy to provide any additional info you might need. edit: confirmed that query is indexed properly via explain, investigating serialization errors