HashAggregate (cost=83446.11..83449.11 rows=200 width=64)
Output: ((':'::text || current_keyword.v)), (count(current_ref.v))::text
Group Key: ((':'::text || current_keyword.v))
-> HashAggregate (cost=82244.30..83102.74 rows=68675 width=40)
Output: ((':'::text || current_keyword.v)), current_ref.v
Group Key: ((':'::text || current_keyword.v)), current_ref.v
InitPlan 1 (returns $0)
-> Seq Scan on mentat.schema (cost=0.00..1.49 rows=1 width=8)
Output: schema.entid
Filter: (schema.ident = ':issue/state'::text)
InitPlan 2 (returns $1)
-> Seq Scan on mentat.schema schema_1 (cost=0.00..1.49 rows=1 width=8)
Output: schema_1.entid
Filter: (schema_1.ident = ':issue/assignee'::text)
-> Gather (cost=59750.26..81211.20 rows=206025 width=40)
Output: ((':'::text || current_keyword.v)), current_ref.v
Workers Planned: 3
Params Evaluated: $0, $1
-> HashAggregate (cost=58750.26..59608.70 rows=68675 width=40)
Output: ((':'::text || current_keyword.v)), current_ref.v
Group Key: (':'::text || current_keyword.v), current_ref.v
-> Parallel Hash Join (cost=29788.97..56914.60 rows=367133 width=40)
Output: (':'::text || current_keyword.v), current_ref.v
Hash Cond: (current_keyword.e = current_ref.e)
-> Parallel Seq Scan on mentat.current_keyword (cost=0.00..23717.37 rows=419358 width=22)
Output: current_keyword.store_id, current_keyword.e, current_keyword.a, current_keyword.v, current_keyword.tx
Filter: ((current_keyword.store_id = '0'::bigint) AND (current_keyword.a = $0))
-> Parallel Hash (cost=26232.37..26232.37 rows=284528 width=16)
Output: current_ref.v, current_ref.e
-> Parallel Index Only Scan using idx_current_ref_aev on mentat.current_ref (cost=0.56..26232.37 rows=284528 width=16)
Output: current_ref.v, current_ref.e
Index Cond: ((current_ref.store_id = '0'::bigint) AND (current_ref.a = $1))
Query Identifier: 3784283213822905812
