explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8HOZ

Settings
# 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)

  • Filter: (((SubPlan 1))::text = '5256632'::text)
  • Rows Removed by Filter: 280227
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)

  • Sort Key: adav.valid_from DESC
  • Sort Method: quicksort Memory: 25kB
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)

  • Filter: ((name)::text = 'article.dosage.sdu'::text)
  • Rows Removed by Filter: 85
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)

  • Index Cond: ((article_dosage_id = ad.id) AND (attribute_id = ada.id) AND (valid_from < now()))