Check the query.log that specified at log location https://developer.couchbase.com/documentation/server/current/clustersetup/ui-logs.html Also try this index
CREATE INDEX idx_card_board_join_2 ON default(owner,name,_id) WHERE ((type = “board”) and (deleted_at is null));
idx_card_board_join_2
default
owner
type
deleted_at
Can you try 5.1.0
The index you provided worked! Awesome. I didn’t realize I could place the keys of the SELECT inside the index (if I wasn’t WHERE-ing them). Is that recommended for 5.x?
Making query covered to avoid fetch. Whenever possible you should use covering index to avoid fetch