2020-11-06 17:53:50.218
bd308855d5c36b17a8371d3a544eb0a3
 0.472 ms
сообщить о проблеме
tilemap |  piechart
time | bufferstilemap
#
node, ms
tree, ms
rows
RRbF
node
sh.ht
10.9245′01494′986
итоговые результаты
1′082
0
10.924
5′014
94′986
95.0%
Seq Scan on ranges
1′082
.103
 
Planning Time
.174
11.098
Execution Time
 
Seq Scan on ranges (actual time=0.539..10.924 rows=5′014 loops=1)
  Filter: (('2020-01-01'::date >= dtb) AND ('2020-01-01'::date <= dte))
  Rows Removed by Filter: 94′986
  Buffers: shared hit=1′082
Planning Time: 0.103 ms
Execution Time: 11.098 ms
      
      
-- daterange(dtb, dte, '[]') :: daterange(@>)
CREATE INDEX CONCURRENTLY "~ranges-e4d96e07"
  ON ranges USING gist(daterange(dtb, dte, '[]'));
 0
# 0 Seq Scan on ranges
Execution10.924ms100.0%: rows=5′014 RRbF=94′986, loops=1
Buffers1′082100.0%: hit=1′082
Seq Scan on ranges (actual time=0.539..10.924 rows=5′014 loops=1)
  Filter: (('2020-01-01'::date >= dtb) AND ('2020-01-01'::date <= dte))
  Rows Removed by Filter: 94′986
  Buffers: shared hit=1′082
-- daterange(dtb, dte, '[]') :: daterange(@>)
CREATE INDEX CONCURRENTLY "~ranges-e4d96e07"
  ON ranges USING gist(daterange(dtb, dte, '[]'));
время % rows RRbF % тип узла таблица индекс узлы sh.ht
10.924
100.0
5′014
94′986
95.0
Seq Scan
ranges

                          0
                        
                  
                        
                  
 1′082

                

          

        

      

      

        
      

    

  

  
  

  
  
  
  
  
  
  
  
  
  
  
  
  
  
    
tooltip