explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lEPj

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

Index Scan using index_entity_mappings_on_parent_id on entity_mappings (cost=0.43..254,878,736,347.12 rows=690,961 width=8) (actual rows= loops=)

  • Index Cond: (parent_id IS NOT NULL)
  • Filter: (NOT (SubPlan 1))
2.          

SubPlan (forIndex Scan)

3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..358,709.05 rows=4,066,070 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on entity_mappings entity_mappings_1 (cost=0.00..322,494.70 rows=4,066,070 width=8) (actual rows= loops=)