#0
BHS |
tilemap |
piechart
Bitmap Heap Scan on sales (actual time=0.128..0.373 rows=341 loops=1) Recheck Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box) Heap Blocks: exact=338 Buffers: shared hit=357 -> Bitmap Index Scan on sales_point_spgist (actual time=0.091..0.091 rows=341 loops=1) Index Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box) Buffers: shared hit=19
Scan Table sales
"Bitmap Heap Scan on sales (actual time=0.128..0.373 rows=341 loops=1)" " Recheck Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box)" " Heap Blocks: exact=338" " Buffers: shared hit=357" " -> Bitmap Index Scan on sales_point_spgist (actual time=0.091..0.091 rows=341 loops=1)" " Index Cond: (point(date_part('epoch'::text, (dt)::timestamp without time zone), (sum)::double precision) <@ '(1703980800,20000),(1701388800,10000)'::box)" " Buffers: shared hit=19"