explain.depesz.com

PostgreSQL's explain analyze made readable

Result: phmd

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 405.584 ↑ 3.0 1 1

Nested Loop (cost=1,636.68..53,370.55 rows=3 width=1,190) (actual time=48.036..405.584 rows=1 loops=1)

2. 0.006 405.531 ↑ 3.0 1 1

Nested Loop (cost=1,636.26..53,346.82 rows=3 width=90) (actual time=47.984..405.531 rows=1 loops=1)

3. 0.037 0.037 ↑ 1.0 1 1

Seq Scan on article_dosage_attribute ada (cost=0.00..3.08 rows=1 width=64) (actual time=0.015..0.037 rows=1 loops=1)

  • Filter: ((name)::text = 'article.dosage.sdu'::text)
  • Rows Removed by Filter: 85
4. 365.440 405.488 ↑ 3.0 1 1

Bitmap Heap Scan on article_dosage_attr_value adav (cost=1,636.26..53,343.72 rows=3 width=26) (actual time=47.964..405.488 rows=1 loops=1)

  • Recheck Cond: (attribute_id = ada.id)
  • Filter: (((value)::text = '5256632'::text) AND (valid_from < now()))
  • Rows Removed by Filter: 280507
  • Heap Blocks: exact=46589
5. 40.048 40.048 ↓ 3.2 280,508 1

Bitmap Index Scan on idx_adav (cost=0.00..1,636.26 rows=88,510 width=0) (actual time=40.048..40.048 rows=280,508 loops=1)

  • Index Cond: (attribute_id = ada.id)
6. 0.043 0.043 ↑ 1.0 1 1

Index Scan using pk_article_dosage on article_dosage ad (cost=0.42..7.91 rows=1 width=1,100) (actual time=0.043..0.043 rows=1 loops=1)

  • Index Cond: (id = adav.article_dosage_id)