explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W6NV : Optimization for: ///4; plan #F5GF

Settings

Optimization path:

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

Sort (cost=83.67..83.68 rows=5 width=636) (actual rows= loops=)

  • Sort Key: csc.id, cd.policy_type, cd.name
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=46.09..83.61 rows=5 width=636) (actual rows= loops=)

  • Join Filter: (mc.conf_concept_id = cc.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=45.94..82.57 rows=5 width=636) (actual rows= loops=)

  • Hash Cond: (csc.id = cd.conf_sub_concept_id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=33.24..69.50 rows=83 width=16) (actual rows= loops=)

  • Hash Cond: (csc.conf_concept_id = mc.conf_concept_id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on conf_sub_concepts csc (cost=0.00..28.50 rows=1,850 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=33.12..33.12 rows=9 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on model_concepts mc (cost=0.00..33.12 rows=9 width=8) (actual rows= loops=)

  • Filter: (model_id = 1)
8. 0.000 0.000 ↓ 0.0

Hash (cost=11.20..11.20 rows=120 width=624) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on conf_details cd (cost=0.00..11.20 rows=120 width=624) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using conf_concepts_pkey on conf_concepts cc (cost=0.15..0.20 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = csc.conf_concept_id)