2025-04-09 12:50:48.608
65bcf0f6-099c-6e61-fd54-31e450913cad
 0.557 ms
сообщить о проблеме
tilemap |  piechart
timetilemap
#
node, ms
tree, ms
rows
RRbF
node
273.49062′449272′778
итоговые результаты (26MB = rows=62′449 x width=431)
0
23.707
273.490
62′449
▲
Hash Semi Join
1
115.222
122.601
62′449
▼
136′389
68.6%
  ->  Bitmap Heap Scan on dash_org_elements elm
2
7.379
198′838
       ->  Bitmap Index Scan on dash_org_elements_struct_id_idx
3
11.533
127.182
62′449
  ->  Hash
4
115.649
62′449
136′389
68.6%
       ->  Seq Scan on "tmp$dash_org_elements" tmp
.475
 
Planning Time
3.954
277.444
Execution Time
 
Hash Semi Join  (cost=16′910.70..55′110.38 rows=11′607 width=431) (actual time=137.167..273.490 rows=62′449 loops=1)
  Hash Cond: (elm.id = tmp.id)
  ->  Bitmap Heap Scan on dash_org_elements elm  (cost=1′859.22..39′639.47 rows=110′591 width=431) (actual time=9.918..122.601 rows=62′449 loops=1)
        Recheck Cond: (struct_id = '3874'::text)
        Filter: is_active
        Rows Removed by Filter: 136′389
        Heap Blocks: exact=12′893
        ->  Bitmap Index Scan on dash_org_elements_struct_id_idx  (cost=0.00..1′831.57 rows=198′820 width=0) (actual time=7.379..7.379 rows=198′838 loops=1)
              Index Cond: (struct_id = '3874'::text)
  ->  Hash  (cost=14′269.38..14′269.38 rows=62′568 width=16) (actual time=127.181..127.182 rows=62′449 loops=1)
        Buckets: 65′536  Batches: 1  Memory Usage: 3440kB
        ->  Seq Scan on "tmp$dash_org_elements" tmp  (cost=0.00..14′269.38 rows=62′568 width=16) (actual time=0.023..115.649 rows=62′449 loops=1)
              Filter: is_active
              Rows Removed by Filter: 136′389
Planning Time: 0.475 ms
Execution Time: 277.444 ms
      
      
-- struct_id :: text(=)
CREATE INDEX CONCURRENTLY "~dash_org_elements-ea80c6ad"
  ON dash_org_elements(struct_id)
  WHERE
    is_active;
 1
# 1 Bitmap Heap Scan on dash_org_elements elm
Execution115.222ms42.1%: rows=62′449 RRbF=136′389, loops=1
Cost39639.47: rows=110591 width=431
Bitmap Heap Scan on dash_org_elements elm  (cost=1′859.22..39′639.47 rows=110′591 width=431) (actual time=9.918..122.601 rows=62′449 loops=1)
  Recheck Cond: (struct_id = '3874'::text)
  Filter: is_active
  Rows Removed by Filter: 136′389
  Heap Blocks: exact=12′893
-- struct_id :: text(=)
CREATE INDEX CONCURRENTLY "~dash_org_elements-ea80c6ad"
  ON dash_org_elements(struct_id)
  WHERE
    is_active;
время % rows RRbF % тип узла таблица индекс узлы
115.649
42.3
62′449
136′389
68.6
Seq Scan
tmp$dash_org_elements

                          4
                        
                  
                        

                    
115.222

                  		
                
42.1

              		
                      
62′449

                  		
                  
136′389

                
68.6
Bitmap Heap Scan
dash_org_elements

                          1
                        
                  
                        

                    
23.707

                  		
                
8.7

              		
                      
62′449

                  
Hash Semi Join

                          0
                        
                  
                        

                    
11.533

                  		
                
4.2

              		
                      
62′449

                  
Hash

                          3
                        
                  
                        

                    
7.379

                  		
                
2.7

              		
                      
198′838

                  
Bitmap Index Scan
dash_org_elements
dash_org_elements_struct_id_idx

                          2
                        
                  
                        

          

        

      

      

        
      

    

  

  
  

  
  
  
  
  
  
  
  
  
  
  
  
  
  
    
tooltip