# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 21.437 | 139.715 | ↑ 1.0 | 50 | 1 |
→
Limit (cost=1,001.14..148,145.12 rows=50 width=68) (actual time=6.339..139.715 rows=50 loops=1)
|
2. | 0.000 | 118.278 | ↑ 10.7 | 50 | 1 |
→
Nested Loop (cost=1,001.14..1,578,384.68 rows=536 width=68) (actual time=6.338..118.278 rows=50 loops=1)
|
3. | 0.000 | 138.469 | ↑ 31.9 | 9 | 1 |
→
Gather Merge (cost=1,000.58..1,015,792.24 rows=287 width=147) (actual time=6.282..138.469 rows=9 loops=1)
|
4. | 286.668 | 286.668 | ↑ 24.0 | 5 | 3 |
→
Parallel Index Scan using article_pkey on wholesale_articles.wholesale_config config1_ (cost=0.55..1,014,759.09 rows=120 width=147) (actual time=0.251..95.556 rows=5 loops=3)
|
5. | 0.156 | 1.206 | ↑ 1.0 | 6 | 9 |
→
Index Scan using simple_ws_config_id on wholesale_articles.wholesale_simple simple0_ (cost=0.56..1,960.19 rows=6 width=299) (actual time=0.042..0.134 rows=6 loops=9)
|
6. |
SubPlan (for Index Scan) |
|||||
7. | 0.100 | 1.050 | ↑ 1.0 | 1 | 50 |
→
Aggregate (cost=81.03..81.04 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=50)
|
8. | 0.950 | 0.950 | ↑ 1.5 | 12 | 50 |
→
Index Scan using external_article_reference_by_simple_id on wholesale_articles.external_article_reference externalar95_ (cost=0.56..80.99 rows=18 width=11) (actual time=0.011..0.019 rows=12 loops=50)
|
Planning time | : | 0.460 ms |
---|---|---|
Execution time | : | 139.765 ms |