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

                          0
                        
                  
                        
                  
 541

                

          

        

      

      

        
      

    

  

  
  

  
  
  
  
  
  
  
  
  
  
  
  
  
  
    
tooltip