explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CXHE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,415.46..924,131.62 rows=22,277,156 width=28) (actual rows= loops=)

  • Hash Cond: (d_e.drug_concept_id = ca.descendant_concept_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on drug_exposure d_e (cost=0.00..721,966.56 rows=22,277,156 width=28) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=6,394.62..6,394.62 rows=1,667 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on concept_ancestor ca (cost=33.49..6,394.62 rows=1,667 width=4) (actual rows= loops=)

  • Recheck Cond: (ancestor_concept_id = 40,239,216)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_concept_ancestor_id_1 (cost=0.00..33.07 rows=1,667 width=0) (actual rows= loops=)

  • Index Cond: (ancestor_concept_id = 40,239,216)