2020-10-06 15:57:13.099
fc324748fb6ad18d659217b41bb167b5
 0.676 ms
CS#1
#2 FS |
tilemap |  piechart
timetilemap
#
node, ms
tree, ms
rows
RRbF
Function Scan on generate_series i
801.1664761995239
итоговые результаты
0
1.771
801.166
4761
Sort
1
3.243
799.395
4761
CS
  ->  Sort
2
796.152
4761
995239
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=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
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=4761, loops=1
Sort (actual time=799.058..799.395 rows=4761 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
4761
995239
99.5
Function Scan
generate_series
2
5.014
0.6
9522
2
Sort
0 1
2
tooltip