clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2043125 fiddles created (16620 in the last week).

create table foo as select bar::integer, lpad('',1000,'A') baz from generate_series(1,1e4) bar order by bar;
10000 rows affected
 hidden batch(es)


create index foo_brin on foo using brin(bar);
 hidden batch(es)


vacuum analyze;
 hidden batch(es)


explain analyze select * from foo where bar between 1 and 100;
QUERY PLAN
Bitmap Heap Scan on foo (cost=13.01..323.85 rows=99 width=1008) (actual time=0.059..1.182 rows=100 loops=1)
Recheck Cond: ((bar >= 1) AND (bar <= 100))
Rows Removed by Index Recheck: 796
Heap Blocks: lossy=128
-> Bitmap Index Scan on foo_brin (cost=0.00..12.99 rows=99 width=0) (actual time=0.042..0.043 rows=1280 loops=1)
Index Cond: ((bar >= 1) AND (bar <= 100))
Planning time: 0.124 ms
Execution time: 1.210 ms
 hidden batch(es)