tilemap |
piechart
#
|
node, ms
|
tree, ms
|
rows
|
RRbF
|
|
loops
|
|||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35′973.699 | 1 | 10′321 | |||||||||||||||||||
0 | .005
| 35′973.699
| 1
|
| |||||||||||||||||
1 |
| ||||||||||||||||||||
2 | 681.049
| 1′865.506
| 4′162′080
|
| |||||||||||||||||
3 | 5.868
| 2′080
|
| ||||||||||||||||||
4 | 1′178.589
| 4′160′079
| 2′001
| 0.0% | 2′001 |
| |||||||||||||||
5 | 7.741
| 35′973.694
| 1
|
| |||||||||||||||||
6 | 1′212.959
| 35′965.953
| 40′951
|
| |||||||||||||||||
7 | 719.460
| 34′752.994
| 4′016′720
|
| |||||||||||||||||
8 | 19′651.363
| 34′033.534
| 4′153′760
|
| |||||||||||||||||
9 | 637.674
| 14′382.171
| 4′153′760
| 8′320
| 0.2% |
| |||||||||||||||
10 | 5′187.772
| 13′744.497
| 4′162′080
|
| |||||||||||||||||
11 | 400.926
| 8′556.725
| 4′162′080
|
| |||||||||||||||||
12 | 2′356.939
| 8′155.799
| 4′162′080
|
| |||||||||||||||||
13 | 2′890.495
| 5′798.860
| 4′162′080
|
| |||||||||||||||||
14 | 1′042.859
| 2′908.365
| 4′162′080
|
| |||||||||||||||||
.296 |
| ||||||||||||||||||||
99.570 | 36′073.269 |
|
Limit (actual time=35′973.692..35′973.699 rows=1 loops=1) CTE r -> Recursive Union (actual time=5.433..1′865.506 rows=4′162′080 loops=1) -> Function Scan on regexp_matches t_2 (actual time=5.432..5.868 rows=2′080 loops=1) -> WorkTable Scan on r r_1 (actual time=0.001..0.589 rows=2′079 loops=2′001) Filter: (i < 2′000) Rows Removed by Filter: 1 -> Sort (actual time=35′973.691..35′973.694 rows=1 loops=1) Sort Key: (sum(t.price)) DESC Sort Method: top-N heapsort Memory: 25kB -> GroupAggregate (actual time=32′714.284..35′965.953 rows=40′951 loops=1) Group Key: t.seq -> Unique (actual time=32′714.241..34′752.994 rows=4′016′720 loops=1) -> Sort (actual time=32′714.240..34′033.534 rows=4′153′760 loops=1) Sort Key: t.seq, t.id, t.i Sort Method: external merge Disk: 256064kB -> Subquery Scan on t (actual time=5′241.586..14′382.171 rows=4′153′760 loops=1) Filter: (t.seq[1] IS NOT NULL) Rows Removed by Filter: 8′320 -> WindowAgg (actual time=5′241.561..13′744.497 rows=4′162′080 loops=1) -> Subquery Scan on t_1 (actual time=5′241.512..8′556.725 rows=4′162′080 loops=1) -> WindowAgg (actual time=5′241.511..8′155.799 rows=4′162′080 loops=1) -> Sort (actual time=5′241.497..5′798.860 rows=4′162′080 loops=1) Sort Key: r.id, r.i Sort Method: quicksort Memory: 260886kB -> CTE Scan on r (actual time=5.434..2′908.365 rows=4′162′080 loops=1) Planning Time: 0.296 ms Execution Time: 36′073.269 ms
время | % | rows | RRbF | % | loops | тип узла | таблица | индекс | узлы | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|
22′549.599
|
62.7
|
8′315′841
|
3
| Sort | 5 8 13 |
3
| ||||||
7′544.711
|
21.0
|
8′324′160
|
2
| WindowAgg | 10 12 |
2
| ||||||
1′212.959
|
3.4
|
40′951
| GroupAggregate | 6 | ||||||||
1′178.589
|
3.3
|
4′160′079
|
2′001
| .0 |
2′001
| WorkTable Scan | 4 | |||||
1′042.859
|
2.9
|
4′162′080
| CTE Scan | 14 | ||||||||
719.460
|
2.0
|
4′016′720
| Unique | 7 | ||||||||
681.049
|
1.9
|
4′162′080
| Recursive Union | 2 | ||||||||
637.674
|
1.8
|
4′153′760
|
8′320
| .2 | Subquery Scan | 9 | ||||||
400.926
|
1.1
|
4′162′080
| Subquery Scan | 11 | ||||||||
5.868
|
0.0
|
2′080
| Function Scan | 3 | ||||||||
.005
|
0.0
|
1
| Limit | 0 |