[Solved] What will be the result of this query if the GIN index exists?EXPLAIN SELECT * FROM docs WHERE to_tsvector('english', text) @@ to_tsquery('english', 'search'); | PostgreSQL

PostgreSQL - Full-Text Search

What will be the result of this query if the GIN index exists?

EXPLAIN SELECT * FROM docs WHERE to_tsvector('english', text) @@ to_tsquery('english', 'search');

AQuery plan shows sequential scan only

BQuery plan shows use of GIN index scan

CQuery returns an error about missing index

DQuery plan shows hash index scan

Step-by-Step Solution

Solution:

Step 1: Understand EXPLAIN output with GIN index
When a GIN index exists, EXPLAIN shows an Index Scan using GIN.
Step 2: Recognize scan types
Sequential scan means no index used; hash index is not used for full-text search.
Final Answer:
Query plan shows use of GIN index scan -> Option B
Quick Check:
EXPLAIN with GIN index = Index Scan [OK]

Quick Trick: EXPLAIN shows GIN index scan if index is used [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the result of this query if the GIN index exists?