2020-10-06 15:57:13.099
fc324748fb6ad18d659217b41bb167b5
 1.429 ms
сообщить о проблеме
CS#1
#2 FS |
tilemap |  piechart
timetilemap
#
node, ms
tree, ms
rows
RRbF
Function Scan on generate_series i
801.1664′761995′239
итоговые результаты
0
1.771
801.166
4′761
Sort
1
3.243
799.395
4′761
CS
  ->  Sort
2
796.152
4′761
995′239
99.5%
       ->  Function Scan on generate_series i
.135
 
Planning Time
13.464
814.630
Execution Time
generate_series igenerate_series iSortSortSortSort
Sort (actual time=800.900..801.166 rows=4′761 loops=1)
  Sort Key: i.i
  Sort Method: quicksort  Memory: 416kB
  ->  Sort (actual time=799.058..799.395 rows=4′761 loops=1)
        Sort Key: i.i DESC
        Sort Method: quicksort  Memory: 416kB
        ->  Function Scan on generate_series i (actual time=193.445..796.152 rows=4′761 loops=1)
              Filter: (((i % '2'::numeric) = '1'::numeric) AND ((i % '3'::numeric) = '2'::numeric) AND ((i % '5'::numeric) = '4'::numeric) AND ((i % '7'::numeric) = '6'::numeric))
              Rows Removed by Filter: 995′239
Planning Time: 0.135 ms
Execution Time: 814.630 ms
Process
  ->  Scan Function generate_series
"Sort (actual time=800.900..801.166 rows=4761 loops=1)"
"  Sort Key: i.i"
"  Sort Method: quicksort  Memory: 416kB"
"  ->  Sort (actual time=799.058..799.395 rows=4761 loops=1)"
"        Sort Key: i.i DESC"
"        Sort Method: quicksort  Memory: 416kB"
"        ->  Function Scan on generate_series i (actual time=193.445..796.152 rows=4761 loops=1)"
"              Filter: (((i % '2'::numeric) = '1'::numeric) AND ((i % '3'::numeric) = '2'::numeric) AND ((i % '5'::numeric) = '4'::numeric) AND ((i % '7'::numeric) = '6'::numeric))"
"              Rows Removed by Filter: 995239"
"Planning Time: 0.135 ms"
"Execution Time: 814.630 ms"
# 1 Sort CS
Execution3.243ms0.4%: rows=4′761, loops=1
Sort (actual time=799.058..799.395 rows=4′761 loops=1)
  Sort Key: i.i DESC
  Sort Method: quicksort  Memory: 416kB
CS
->  Sort
    i.i
    ->  Sort
        i.i DESC
Рекомендации [подробнее]:
- избыточная внутренняя сортировка
Рекомендации :
- избыточная внутренняя сортировка
#1
->  Sort
    i.i
    ->  Sort
        i.i DESC
время % rows RRbF % loops тип узла таблица индекс узлы
796.152
99.4
4′761
995′239
99.5
Function Scan
generate_series

                          2
                        
                  
                        

                    
5.014

                  		
                
0.6

              		
                      
9′522

                  		 
                  
2

                
Sort

                          0 1
                        
                  
2

                        

          

        

      

      

        
      

    

  

  
  

  
  
  
  
  
  
  
  
  
  
  
  
  
  
    
tooltip