explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ut90

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

Nested Loop Left Join (cost=3.24..38.01 rows=1 width=1,583) (actual time=0.080..0.080 rows=0 loops=1)

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

Nested Loop Left Join (cost=3.24..36.77 rows=1 width=1,223) (actual time=0.079..0.079 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.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.24..35.50 rows=1 width=1,219) (actual time=0.079..0.079 rows=0 loops=1)

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

Nested Loop Left Join (cost=3.24..34.43 rows=1 width=985) (actual time=0.079..0.079 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.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.24..33.14 rows=1 width=983) (actual time=0.079..0.079 rows=0 loops=1)

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

Nested Loop Left Join (cost=3.24..29.47 rows=1 width=865) (actual time=0.079..0.079 rows=0 loops=1)

7. 0.001 0.079 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.96..21.16 rows=1 width=834) (actual time=0.078..0.079 rows=0 loops=1)

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

Nested Loop Left Join (cost=2.96..16.86 rows=1 width=819) (actual time=0.078..0.078 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.077 0.077 ↓ 0.0 0 1

Seq Scan on registration_draft a (cost=0.00..9.87 rows=1 width=780) (actual time=0.077..0.077 rows=0 loops=1)

  • Filter: ((in_agency <> 2) AND (agency_apps_id = 10) AND ((new_ic_no)::text = '891205025036'::text) AND (((user_id)::text = 'NURULSHAZANI'::text) OR ((form_status_map)::text = 'DE'::text)))
  • Rows Removed by Filter: 83
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.27 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)

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

Seq Scan on mrg_business_type j (cost=0.00..1.11 rows=11 width=240) (never executed)