# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.256 | 1,280.086 | ↑ 1.0 | 76 | 1 |
→
Merge Left Join (cost=218,000.82..221,716.33 rows=76 width=55) (actual time=1,108.800..1,280.086 rows=76 loops=1)
|
2. | 0.036 | 0.297 | ↑ 1.0 | 76 | 1 |
→
Sort (cost=660.58..660.77 rows=76 width=86) (actual time=0.290..0.297 rows=76 loops=1)
|
3. | 0.038 | 0.261 | ↑ 1.0 | 76 | 1 |
→
Nested Loop (cost=0.57..658.21 rows=76 width=86) (actual time=0.035..0.261 rows=76 loops=1) |
4. | 0.147 | 0.147 | ↑ 1.0 | 76 | 1 |
→
Index Scan using product_product_pkey on product_product (cost=0.29..307.41 rows=76 width=23) (actual time=0.030..0.147 rows=76 loops=1)
|
5. | 0.076 | 0.076 | ↑ 1.0 | 1 | 76 |
→
Index Scan using product_template_pkey on product_template product_product__product_tmpl_id (cost=0.28..4.62 rows=1 width=63) (actual time=0.001..0.001 rows=1 loops=76)
|
6. | 49.863 | 1,279.533 | ↓ 1.4 | 3,205 | 1 |
→
Unique (cost=217,340.24..221,025.38 rows=2,371 width=77) (actual time=1,108.062..1,279.533 rows=3,205 loops=1) |
7. | 887.611 | 1,229.670 | ↓ 1.0 | 757,820 | 1 |
→
Sort (cost=217,340.24..219,182.81 rows=737,027 width=77) (actual time=1,108.061..1,229.670 rows=757,820 loops=1)
|
8. | 342.059 | 342.059 | ↓ 1.0 | 758,004 | 1 |
→
Seq Scan on ir_translation (cost=0.00..80,012.96 rows=737,027 width=77) (actual time=0.681..342.059 rows=758,004 loops=1)
|