explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DDy7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.38..36.54 rows=1 width=1,583) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (i.business_type_id = j.id)
2. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.38..35.29 rows=1 width=1,223) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: ((a.agency_apps_id = i.agency_apps_id) AND ((a.registration_business_map)::text = (i.business_type_code)::text))
3. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.38..34.03 rows=1 width=1,219) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: (g.agency_apply_draft_ref_id = h.id)
4. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.38..32.96 rows=1 width=985) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: ((a.agency_apps_id = g.agency_apps_id) AND ((a.form_status_map)::text = (g.agency_apply_draft_code)::text))
5. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.38..31.50 rows=1 width=983) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: ((a.registration_map)::text = (f.agensi_map)::text)
6. 0.002 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.38..27.82 rows=1 width=865) (actual time=0.017..0.018 rows=0 loops=1)

7. 0.000 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.11..19.52 rows=1 width=834) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (a.agency_apps_id = b.id)
8. 0.001 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.11..15.21 rows=1 width=819) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: ((a.agency_apps_id = d.agency_apps_id) AND ((a.registration_type_map)::text = (d.agency_apply_type_code)::text))
9. 0.015 0.015 ↓ 0.0 0 1

Index Scan using registration_draft_new_ic_no_user_id_agency_apps_id_idx on registration_draft a (cost=0.14..8.22 rows=1 width=780) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (((new_ic_no)::text = '891205025036'::text) AND (agency_apps_id = 10))
  • Filter: ((in_agency <> 2) AND (((user_id)::text = 'NURULSHAZANI'::text) OR ((form_status_map)::text = 'DE'::text)))
10. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2.96..6.98 rows=1 width=46) (never executed)

  • Hash Cond: (e.id = d.agency_apply_type_ref_id)
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on myb_agency_apply_type_ref e (cost=0.00..3.46 rows=146 width=30) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.95..2.95 rows=1 width=22) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on myb_agency_apply_type d (cost=0.00..2.95 rows=1 width=22) (never executed)

  • Filter: (agency_apps_id = 10)
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on myb_agency_apps b (cost=0.00..4.29 rows=1 width=19) (never executed)

  • Filter: (id = 10)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using sme_agensi_pkey on agensi c (cost=0.28..8.29 rows=1 width=39) (never executed)

  • Index Cond: (b.agency_id = id)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on mrg_registration f (cost=0.00..3.30 rows=30 width=196) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on myb_agency_apply_draft g (cost=0.00..1.45 rows=1 width=64) (never executed)

  • Filter: (agency_apps_id = 10)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on myb_agency_apply_draft_ref h (cost=0.00..1.03 rows=3 width=240) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on mrg_business_agency i (cost=0.00..1.25 rows=1 width=66) (never executed)