[Solved] Given a table logs with a BRIN index on log_time, what will the following query most likely do?EXPLAIN ANALYZE SELECT * FROM logs WHERE log_time BETWEEN '2024-01-01' AND '2024-01-31'; | PostgreSQL

PostgreSQL - Indexing Strategies

Given a table logs with a BRIN index on log_time, what will the following query most likely do?

EXPLAIN ANALYZE SELECT * FROM logs WHERE log_time BETWEEN '2024-01-01' AND '2024-01-31';

AUse a bitmap index scan instead of BRIN.

BPerform a full sequential scan ignoring the BRIN index.

CThrow a syntax error because BRIN indexes cannot be used in WHERE clauses.

DUse the BRIN index to quickly scan only relevant block ranges.

Step-by-Step Solution

Solution:

Step 1: Understand BRIN index behavior on range queries
BRIN indexes speed up range queries by scanning only relevant block ranges.
Step 2: Analyze query and options
The query filters by a range on log_time, so the BRIN index will be used to limit scanned blocks.
Final Answer:
Use the BRIN index to quickly scan only relevant block ranges. -> Option D
Quick Check:
BRIN helps range scans by block filtering [OK]

Quick Trick: BRIN speeds up range scans by filtering block ranges [OK]

Common Mistakes:

Master "Indexing Strategies" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given a table logs with a BRIN index on log_time, what will the following query most likely do?