# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.011 | 3.801 | ↑ 1.0 | 19 | 1 |
→
Merge Right Join (cost=6,484.27..6,486.62 rows=19 width=1,205) (actual time=3.709..3.801 rows=19 loops=1)
|
2. | 0.007 | 1.189 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=1,577.06..1,577.13 rows=30 width=52) (actual time=1.189..1.189 rows=0 loops=1)
|
3. | 0.955 | 1.182 | ↓ 0.0 | 0 | 1 |
→
Bitmap Heap Scan on ir_translation (cost=103.79..1,576.32 rows=30 width=52) (actual time=1.182..1.182 rows=0 loops=1)
|
4. | 0.227 | 0.227 | ↓ 1.0 | 3,186 | 1 |
→
Bitmap Index Scan on ir_translation_name_index (cost=0.00..103.79 rows=3,116 width=0) (actual time=0.227..0.227 rows=3,186 loops=1)
|
5. | 0.028 | 2.601 | ↑ 1.0 | 19 | 1 |
→
Materialize (cost=4,907.20..4,909.06 rows=19 width=1,699) (actual time=2.517..2.601 rows=19 loops=1) |
6. | 0.007 | 2.573 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=4,907.20..4,909.01 rows=19 width=1,699) (actual time=2.510..2.573 rows=19 loops=1)
|
7. | 0.008 | 2.528 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=4,865.28..4,867.02 rows=19 width=1,655) (actual time=2.471..2.528 rows=19 loops=1)
|
8. | 0.006 | 1.602 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=3,298.42..3,299.62 rows=19 width=1,611) (actual time=1.551..1.602 rows=19 loops=1)
|
9. | 0.006 | 1.564 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=3,256.51..3,257.63 rows=19 width=1,567) (actual time=1.519..1.564 rows=19 loops=1)
|
10. | 0.455 | 1.531 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=3,214.59..3,215.64 rows=19 width=1,523) (actual time=1.492..1.531 rows=19 loops=1)
|
11. | 0.032 | 1.035 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=1,780.38..1,781.19 rows=19 width=1,479) (actual time=1.002..1.035 rows=19 loops=1)
|
12. | 0.047 | 1.003 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=1,738.46..1,739.20 rows=19 width=1,435) (actual time=0.976..1.003 rows=19 loops=1)
|
13. | 0.006 | 0.956 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=1,696.55..1,697.20 rows=19 width=1,391) (actual time=0.935..0.956 rows=19 loops=1)
|
14. | 0.018 | 0.185 | ↑ 1.0 | 19 | 1 |
→
Merge Left Join (cost=130.21..130.34 rows=19 width=1,347) (actual time=0.169..0.185 rows=19 loops=1)
|
15. | 0.041 | 0.135 | ↑ 1.0 | 19 | 1 |
→
Sort (cost=88.30..88.34 rows=19 width=1,303) (actual time=0.133..0.135 rows=19 loops=1)
|
16. | 0.069 | 0.094 | ↑ 1.0 | 19 | 1 |
→
Bitmap Heap Scan on product_template (cost=29.42..87.89 rows=19 width=1,303) (actual time=0.029..0.094 rows=19 loops=1)
|
17. | 0.025 | 0.025 | ↑ 1.0 | 19 | 1 |
→
Bitmap Index Scan on product_template_pkey (cost=0.00..29.41 rows=19 width=0) (actual time=0.024..0.025 rows=19 loops=1)
|
18. | 0.002 | 0.032 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.032..0.032 rows=0 loops=1) |
19. | 0.009 | 0.030 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.030..0.030 rows=0 loops=1)
|
20. | 0.021 | 0.021 | ↓ 0.0 | 0 | 1 |
→
Index Scan using ir_translation_name_index on ir_translation ir_translation_1 (cost=0.41..41.91 rows=1 width=52) (actual time=0.021..0.021 rows=0 loops=1)
|
21. | 0.004 | 0.765 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=1,566.32..1,566.74 rows=28 width=48) (actual time=0.765..0.765 rows=0 loops=1) |
22. | 0.006 | 0.761 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=1,566.32..1,566.39 rows=28 width=52) (actual time=0.761..0.761 rows=0 loops=1)
|
23. | 0.578 | 0.755 | ↓ 0.0 | 0 | 1 |
→
Bitmap Heap Scan on ir_translation ir_translation_2 (cost=97.79..1,565.65 rows=28 width=52) (actual time=0.755..0.755 rows=0 loops=1)
|
24. | 0.177 | 0.177 | ↑ 1.0 | 2,790 | 1 |
→
Bitmap Index Scan on ir_translation_name_index (cost=0.00..97.78 rows=2,849 width=0) (actual time=0.177..0.177 rows=2,790 loops=1)
|
25. | 0.000 | 0.041 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.040..0.041 rows=0 loops=1) |
26. | 0.009 | 0.038 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.038..0.038 rows=0 loops=1)
|
27. | 0.029 | 0.029 | ↓ 0.0 | 0 | 1 |
→
Index Scan using ir_translation_name_index on ir_translation ir_translation_3 (cost=0.41..41.91 rows=1 width=52) (actual time=0.029..0.029 rows=0 loops=1)
|
28. | 0.003 | 0.025 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.025..0.025 rows=0 loops=1) |
29. | 0.004 | 0.022 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.022..0.022 rows=0 loops=1)
|
30. | 0.018 | 0.018 | ↓ 0.0 | 0 | 1 |
→
Index Scan using ir_translation_name_index on ir_translation ir_translation_4 (cost=0.41..41.91 rows=1 width=52) (actual time=0.018..0.018 rows=0 loops=1)
|
31. | 0.002 | 0.489 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=1,434.21..1,434.36 rows=10 width=48) (actual time=0.489..0.489 rows=0 loops=1) |
32. | 0.004 | 0.487 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=1,434.21..1,434.24 rows=10 width=52) (actual time=0.487..0.487 rows=0 loops=1)
|
33. | 0.407 | 0.483 | ↓ 0.0 | 0 | 1 |
→
Bitmap Heap Scan on ir_translation ir_translation_5 (cost=36.37..1,434.05 rows=10 width=52) (actual time=0.483..0.483 rows=0 loops=1)
|
34. | 0.076 | 0.076 | ↑ 1.0 | 1,049 | 1 |
→
Bitmap Index Scan on ir_translation_name_index (cost=0.00..36.37 rows=1,060 width=0) (actual time=0.076..0.076 rows=1,049 loops=1)
|
35. | 0.003 | 0.027 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.027..0.027 rows=0 loops=1) |
36. | 0.006 | 0.024 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.024..0.024 rows=0 loops=1)
|
37. | 0.018 | 0.018 | ↓ 0.0 | 0 | 1 |
→
Index Scan using ir_translation_name_index on ir_translation ir_translation_6 (cost=0.41..41.91 rows=1 width=52) (actual time=0.018..0.018 rows=0 loops=1)
|
38. | 0.003 | 0.032 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.031..0.032 rows=0 loops=1) |
39. | 0.004 | 0.029 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.029..0.029 rows=0 loops=1)
|
40. | 0.025 | 0.025 | ↓ 0.0 | 0 | 1 |
→
Index Scan using ir_translation_name_index on ir_translation ir_translation_7 (cost=0.41..41.91 rows=1 width=52) (actual time=0.025..0.025 rows=0 loops=1)
|
41. | 0.002 | 0.918 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=1,566.85..1,567.27 rows=28 width=48) (actual time=0.918..0.918 rows=0 loops=1) |
42. | 0.004 | 0.916 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=1,566.85..1,566.92 rows=28 width=52) (actual time=0.916..0.916 rows=0 loops=1)
|
43. | 0.723 | 0.912 | ↓ 0.0 | 0 | 1 |
→
Bitmap Heap Scan on ir_translation ir_translation_8 (cost=97.95..1,566.17 rows=28 width=52) (actual time=0.911..0.912 rows=0 loops=1)
|
44. | 0.189 | 0.189 | ↑ 1.0 | 2,834 | 1 |
→
Bitmap Index Scan on ir_translation_name_index (cost=0.00..97.94 rows=2,870 width=0) (actual time=0.189..0.189 rows=2,834 loops=1)
|
45. | 0.004 | 0.038 | ↓ 0.0 | 0 | 1 |
→
Materialize (cost=41.92..41.93 rows=1 width=48) (actual time=0.038..0.038 rows=0 loops=1) |
46. | 0.005 | 0.034 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=41.92..41.92 rows=1 width=52) (actual time=0.034..0.034 rows=0 loops=1)
|
47. | 0.029 | 0.029 | ↓ 0.0 | 0 | 1 |
→
Index Scan using ir_translation_name_index on ir_translation ir_translation_9 (cost=0.41..41.91 rows=1 width=52) (actual time=0.028..0.029 rows=0 loops=1)
|