explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EFKS

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 384.143 ↑ 3.0 1 1

Nested Loop (cost=1,636.62..53,371.11 rows=3 width=1,190) (actual time=48.036..384.143 rows=1 loops=1)

2. 0.008 384.088 ↑ 3.0 1 1

Nested Loop (cost=1,636.20..53,347.38 rows=3 width=90) (actual time=47.981..384.088 rows=1 loops=1)

3. 0.394 0.394 ↑ 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.394 rows=1 loops=1)

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

Bitmap Heap Scan on article_dosage_attr_value adav (cost=1,636.20..53,344.27 rows=3 width=26) (actual time=47.960..383.686 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. 37.914 37.914 ↓ 3.2 280,508 1

Bitmap Index Scan on idx_adav (cost=0.00..1,636.20 rows=88,502 width=0) (actual time=37.913..37.914 rows=280,508 loops=1)

  • Index Cond: (attribute_id = ada.id)
6. 0.044 0.044 ↑ 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.044..0.044 rows=1 loops=1)

  • Index Cond: (id = adav.article_dosage_id)