Implementing Search Functionality

SELECT id, title FROM articles
WHERE title ILIKE '%' || :q || '%'
   OR body  ILIKE '%' || :q || '%'
LIMIT 50;

ALTER TABLE articles ADD COLUMN tsv tsvector
  GENERATED ALWAYS AS (
    setweight(to_tsvector('english', title), 'A') ||
    setweight(to_tsvector('english', body),  'B')
  ) STORED;
CREATE INDEX articles_tsv_idx ON articles USING GIN(tsv);

SELECT id, title, ts_rank(tsv, q) AS rank
FROM articles, plainto_tsquery('english', :q) q
WHERE tsv @@ q
ORDER BY rank DESC LIMIT 20;

{
  "query": { "match": { "title": "laptop" } },
  "aggs": {
    "brand":    { "terms": { "field": "brand.keyword", "size": 20 } },
    "price":    { "histogram": { "field": "price", "interval": 100 } },
    "in_stock": { "filter": { "term": { "in_stock": true } } }
  }
}

{
  "query": { "match": { "body": "performance" } },
  "highlight": {
    "fields": { "body": { "fragment_size": 120, "number_of_fragments": 2 } },
    "pre_tags":  ["<mark>"],
    "post_tags": ["</mark>"]
  }
}