-- Hypothetical BRIN index tests CREATE TABLE hypo_brin (id integer); INSERT INTO hypo_brin SELECT generate_series(1, 10000); ANALYZE hypo_brin; SELECT COUNT(*) AS nb FROM public.hypopg_create_index('CREATE INDEX ON hypo_brin USING brin (id);'); nb ---- 1 (1 row) -- Should use hypothetical index SET enable_seqscan = 0; SELECT COUNT(*) FROM do_explain('SELECT * FROM hypo_brin WHERE id = 1') e WHERE e ~ 'Bitmap Index Scan.*<\d+>brin_hypo_brin.*'; count ------- 1 (1 row) DROP TABLE hypo_brin;