slow query...

search.sql

explain analyze SELECT 
  count(1) AS count 
FROM 
  merlin.merlin_templates t 
  INNER JOIN merlin.merlin_keywords k ON t.id = k.merlin_template_id 
WHERE 
  t.enabledstatus = 1 
  AND t.disabled = 0 
  AND k.keyword @@ to_tsquery('red|blue')
  AND product_id = 1

explain analyze SELECT 
  count(1) AS count 
FROM 
  merlin.merlin_templates t 
    INNER JOIN merlin.merlin_keywords k ON t.id = k.merlin_template_id,
  to_tsquery('red|blue') query
WHERE 
  t.enabledstatus = 1 
  AND t.disabled = 0 
  AND query @@ k.tsv_keyword
  AND product_id = 1;