tilemap |
piechart
#
|
node, ms
|
tree, ms
|
rows
|
|
|||||
---|---|---|---|---|---|---|---|---|---|
3.169 | 5′014 | 700
| |||||||
0 | 1.501
| 3.169
| 5′014
|
|
541
| ||||
1 | 1.668
| 5′014
|
|
159
| |||||
.144 |
| ||||||||
.203 | 3.372 |
|
Bitmap Heap Scan on ranges (actual time=1.728..3.169 rows=5′014 loops=1) Recheck Cond: ('2020-01-01'::date <@ daterange(dtb, dte, '[]'::text)) Heap Blocks: exact=541 Buffers: shared hit=700 -> Bitmap Index Scan on ranges_daterange_idx (actual time=1.668..1.668 rows=5′014 loops=1) Index Cond: (daterange(dtb, dte, '[]'::text) @> '2020-01-01'::date) Buffers: shared hit=159 Planning Time: 0.144 ms Execution Time: 3.372 ms