#2
FS |
tilemap |
piechart
#
|
node, ms
|
tree, ms
|
rows
|
RRbF
|
|
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
801.166 | 4′761 | 995′239 | |||||||||||||||
0 | 1.771
| 801.166
| 4′761
|
| |||||||||||||
1 | 3.243
| 799.395
| 4′761
| CS
|
| ||||||||||||
2 | 796.152
| 4′761
| 995′239
| 99.5% |
| ||||||||||||
.135 |
| ||||||||||||||||
13.464 | 814.630 |
| |||||||||||||||
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"
| |||||||||
| |||||||||
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 |