# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 231.404 | 7,797.560 | ↑ 1,401.0 | 1 | 1 |
→
Seq Scan on article_dosage ad (cost=0.00..3,285,987.46 rows=1,401 width=1,100) (actual time=6,746.922..7,797.560 rows=1 loops=1)
|
2. |
SubPlan (forSeq Scan) |
|||||
3. | 280.228 | 7,566.156 | ↑ 1.0 | 1 | 280,228 |
→
Limit (cost=11.68..11.68 rows=1 width=13) (actual time=0.026..0.027 rows=1 loops=280,228) |
4. | 1,681.368 | 7,285.928 | ↑ 1.0 | 1 | 280,228 |
→
Sort (cost=11.68..11.68 rows=1 width=13) (actual time=0.026..0.026 rows=1 loops=280,228)
|
5. | 280.228 | 5,604.560 | ↑ 1.0 | 1 | 280,228 |
→
Nested Loop (cost=0.56..11.67 rows=1 width=13) (actual time=0.017..0.020 rows=1 loops=280,228) |
6. | 2,802.280 | 2,802.280 | ↑ 1.0 | 1 | 280,228 |
→
Seq Scan on article_dosage_attribute ada (cost=0.00..3.08 rows=1 width=7) (actual time=0.007..0.010 rows=1 loops=280,228)
|
7. | 2,522.052 | 2,522.052 | ↑ 1.0 | 1 | 280,228 |
→
Index Scan using pk_article_dosage_attr_value on article_dosage_attr_value adav (cost=0.56..8.58 rows=1 width=20) (actual time=0.008..0.009 rows=1 loops=280,228)
|