explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f3Fl

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 13.908 ↓ 0.0 0 1

Nested Loop Left Join (cost=453.16..5,046.35 rows=2 width=77) (actual time=13.907..13.908 rows=0 loops=1)

2. 0.001 13.904 ↓ 0.0 0 1

Nested Loop Left Join (cost=452.88..5,029.74 rows=2 width=81) (actual time=13.904..13.904 rows=0 loops=1)

  • Join Filter: ((e.system_code_value_desc)::text = (a.preference_action)::text)
3. 0.002 13.903 ↓ 0.0 0 1

Nested Loop Left Join (cost=448.57..5,015.75 rows=2 width=91) (actual time=13.902..13.903 rows=0 loops=1)

  • Join Filter: ((a.facility_id)::text = (facility_d.facility_id)::text)
4. 0.002 13.901 ↓ 0.0 0 1

Hash Left Join (cost=448.30..5,007.41 rows=2 width=94) (actual time=13.900..13.901 rows=0 loops=1)

  • Hash Cond: ((a.provider_id)::text = ((pd.provider_id)::character varying(40))::text)
5. 13.899 13.899 ↓ 0.0 0 1

Seq Scan on provider_preferences a (cost=0.00..4,556.53 rows=2 width=192) (actual time=13.898..13.899 rows=0 loops=1)

  • Filter: (((facility_id)::text = '303'::text) AND (eff_end_ts > now()))
  • Rows Removed by Filter: 57916
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=384.30..384.30 rows=5,120 width=4) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=310.91..384.30 rows=5,120 width=4) (never executed)

  • Hash Cond: ((system_code_detail.system_code_value)::text = COALESCE((pd.gender)::text, 'U'::text))
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on system_code_detail (cost=4.71..46.33 rows=24 width=4) (never executed)

  • Recheck Cond: (((system_code_id)::text = '200'::text) AND ((system_code_type)::text = '01'::text) AND (eff_end_ts > now()))
  • Filter: (is_active = 'Y'::bpchar)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on system_code_detail_pkey (cost=0.00..4.71 rows=30 width=0) (never executed)

  • Index Cond: (((system_code_id)::text = '200'::text) AND ((system_code_type)::text = '01'::text) AND (eff_end_ts > now()))
10. 0.000 0.000 ↓ 0.0 0

Hash (cost=242.20..242.20 rows=5,120 width=6) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on provider pd (cost=0.00..242.20 rows=5,120 width=6) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.28..8.31 rows=1 width=3) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using facility_d_pkey on facility_d (cost=0.28..8.30 rows=1 width=3) (never executed)

  • Index Cond: (((facility_id)::text = '303'::text) AND (now() <= eff_end_ts))
  • Filter: (now() >= eff_bgn_ts)
14. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.31..13.96 rows=1 width=14) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on system_code_detail e (cost=4.31..13.96 rows=1 width=14) (never executed)

  • Recheck Cond: (((system_code_id)::text = '200'::text) AND ((system_code_type)::text = '16'::text))
  • Filter: (flag1 = 1)
16. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on system_code_detail_pkey (cost=0.00..4.31 rows=3 width=0) (never executed)

  • Index Cond: (((system_code_id)::text = '200'::text) AND ((system_code_type)::text = '16'::text))
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using rule_d_pkey on rule_d g (cost=0.28..8.29 rows=1 width=4) (never executed)

  • Index Cond: ((rule_id = a.rule_id) AND (eff_end_ts > now()))
  • Heap Fetches: 0