HashAggregate  (cost=7324.22..7327.22 rows=200 width=64)
  Output: ((':'::text || current_keyword.v)), (count(current_ref.v))::text
  Group Key: ((':'::text || current_keyword.v))
  ->  HashAggregate  (cost=7072.08..7252.18 rows=14408 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)
        ->  Merge Join  (cost=0.84..6784.77 rows=56866 width=40)
              Output: (':'::text || current_keyword.v), current_ref.v
              Merge Cond: (current_keyword.e = current_ref.e)
              ->  Index Only Scan using idx_current_keyword_aev on mentat.current_keyword  (cost=0.42..2146.42 rows=65005 width=22)
                    Output: current_keyword.store_id, current_keyword.a, current_keyword.e, current_keyword.v, current_keyword.tx
                    Index Cond: ((current_keyword.store_id = '0'::bigint) AND (current_keyword.a = $0))
              ->  Index Only Scan using idx_current_ref_aev on mentat.current_ref  (cost=0.42..3480.68 rows=113733 width=16)
                    Output: current_ref.store_id, current_ref.a, current_ref.e, current_ref.v, current_ref.tx
                    Index Cond: ((current_ref.store_id = '0'::bigint) AND (current_ref.a = $1))
Query Identifier: 4852971314928700961
