2020-11-06 17:56:39.857
697ae8e8f2c5baf8dbe14ec2ee6e91b4
 0.584 ms
tilemap |  piechart
time | bufferstilemap
#
node, ms
tree, ms
rows
node
sh.ht
3.1695014
итоговые результаты
700
0
1.501
3.169
5014
Bitmap Heap Scan on ranges
541
1
1.668
5014
  ->  Bitmap Index Scan on ranges_daterange_idx
159
.144
 
Planning Time
.203
3.372
Execution Time
Bitmap Heap Scan on ranges (actual time=1.728..3.169 rows=5014 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=5014 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
      
время % rows тип узла таблица индекс узлы sh.ht
1.668
52.6
5014
Bitmap Index Scan
ranges
ranges_daterange_idx
1
159
1.501
47.4
5014
Bitmap Heap Scan
ranges
0
541
tooltip