2022-05-11 15:09:18.717
ce619d06cdba9e083b706efc85094e39
 0.791 ms
сообщить о проблеме
SR#1
#0 D |
#1 SS |
tilemap |  piechart
time | bufferstilemap
#
node, ms
tree, ms
rows
RRbF
Delete on tblfkSeq Scan on tblfk
sh.ht
sh.dr
264.757998′497
итоговые результаты
6′252
1′279
0
120.955
264.757
Delete on tblfk
1′827
812
1
143.802
1′016
998′497
99.9%
SR
  ->  Seq Scan on tblfk
4′425
467
по затраченному времени | по использованию данныхtblfktblfkDeletetblfkDeletetblfk
Delete on tblfk  (cost=0.00..16′925.00 rows=996 width=6) (actual time=264.757..264.757 rows=0 loops=1)
  Buffers: shared hit=6′252 dirtied=1′279
  ->  Seq Scan on tblfk  (cost=0.00..16′925.00 rows=996 width=6) (actual time=0.181..143.802 rows=1′016 loops=1)
        Filter: (999 = k)
        Rows Removed by Filter: 998′497
        Buffers: shared hit=4′425 dirtied=467

Delete tblfk
  ->  Scan Table tblfk
  Query Text: DELETE FROM ONLY "public"."tblfk" WHERE $1 OPERATOR(pg_catalog.=) "k"
  Delete on tblfk  (cost=0.00..16925.00 rows=996 width=6) (actual time=264.757..264.757 rows=0 loops=1)
    Buffers: shared hit=6252 dirtied=1279
    ->  Seq Scan on tblfk  (cost=0.00..16925.00 rows=996 width=6) (actual time=0.181..143.802 rows=1016 loops=1)
          Filter: (999 = k)
          Rows Removed by Filter: 998497
          Buffers: shared hit=4425 dirtied=467
-- k :: integer(=)
CREATE INDEX CONCURRENTLY "~tblfk-67ed26fd"
  ON tblfk(k);
 1
# 1 Seq Scan on tblfk
Execution143.802ms54.3%: rows=1′016 RRbF=998′497, loops=1
Buffers4′89265.0%: hit=4′425, dirtied=467
Cost16925.00: rows=996 width=6
Seq Scan on tblfk  (cost=0.00..16′925.00 rows=996 width=6) (actual time=0.181..143.802 rows=1′016 loops=1)
  Filter: (999 = k)
  Rows Removed by Filter: 998′497
  Buffers: shared hit=4′425 dirtied=467
-- k :: integer(=)
CREATE INDEX CONCURRENTLY "~tblfk-67ed26fd"
  ON tblfk(k);
# 1 Seq Scan on tblfk SR
Execution143.802ms54.3%: rows=1′016 RRbF=998′497, loops=1
Buffers4′89265.0%: hit=4′425, dirtied=467
Cost16925.00: rows=996 width=6
Seq Scan on tblfk  (cost=0.00..16′925.00 rows=996 width=6) (actual time=0.181..143.802 rows=1′016 loops=1)
  Filter: (999 = k)
  Rows Removed by Filter: 998′497
  Buffers: shared hit=4′425 dirtied=467
SR
->  Seq Scan on tblfk
    rows=1016, RRbF=998497, ratio=982.8
Рекомендации [подробнее] [возможные индексы]:
- создайте индекс, обеспечивающий эффективную фильтрацию по условию
Рекомендации :
- создайте индекс, обеспечивающий эффективную фильтрацию по условию
#1
->  Seq Scan on tblfk
    rows=1016, RRbF=998497, ratio=982.8
время % rows RRbF % тип узла таблица индекс узлы sh.ht sh.dr
143.802
54.3
1′016
998′497
99.9
Seq Scan
tblfk

                          1
                        
                  
                        
                  
 4′425

                		
                  
 467

                

                    
120.955

                  		
                
45.7

              
Delete
tblfk

                          0
                        
                  
                        
                  
 1′827

                		
                  
 812

                

          

        

      

      

        
      

    

  

  
  

  
  
  
  
  
  
  
  
  
  
  
  
  
  
    
tooltip