we're seeing a spicedb query that was taking 15min at worst in our testing environment:

sql
SELECT namespace, object_id, relation, userset_namespace, userset_object_id, userset_relation, caveat_name, caveat_context 
FROM relation_tuple 
WHERE pg_visible_in_snapshot ( created_xid, ? ) = ? AND pg_visible_in_snapshot ( deleted_xid, ? ) = ? AND namespace = ? AND relation = ? AND object_id IN ( ? ) AND ( ( userset_namespace = ? AND userset_object_id IN ( ? ) AND userset_relation = ? ) ) 
LIMIT ?

what operation is that associated with? (note that this is probably a problem with our configuration - we're just trying to debug)