explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vB4b

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,606.022 ↓ 0.0 0 1

Limit (cost=1.41..3,409.50 rows=1 width=20) (actual time=2,606.022..2,606.022 rows=0 loops=1)

2. 0.000 2,606.021 ↓ 0.0 0 1

Nested Loop (cost=1.41..23,858.04 rows=7 width=20) (actual time=2,606.021..2,606.021 rows=0 loops=1)

3. 0.001 2,606.021 ↓ 0.0 0 1

Nested Loop (cost=0.99..23,822.97 rows=7 width=24) (actual time=2,606.021..2,606.021 rows=0 loops=1)

4. 0.000 2,606.020 ↓ 0.0 0 1

Nested Loop (cost=0.71..23,820.80 rows=7 width=28) (actual time=2,606.020..2,606.020 rows=0 loops=1)

5. 0.001 2,606.020 ↓ 0.0 0 1

Nested Loop (cost=0.42..23,762.68 rows=7 width=28) (actual time=2,606.020..2,606.020 rows=0 loops=1)

  • Join Filter: ((pip.insurance_co)::text = (icm.insurance_co_id)::text)
6. 2,606.019 2,606.019 ↓ 0.0 0 1

Index Scan using patient_insurance_plans_priority on patient_insurance_plans pip (cost=0.42..23,723.19 rows=7 width=46) (actual time=2,606.018..2,606.019 rows=0 loops=1)

  • Filter: ((plan_id IS NOT NULL) AND ((patient_id)::text <> 'A36O19100000843'::text) AND ((mr_no)::text = 'UA3600000028911'::text))
  • Rows Removed by Filter: 470275
7. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..8.53 rows=302 width=8) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_company_master icm (cost=0.00..7.02 rows=302 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using insurance_plan_main_pkey on insurance_plan_main ipm (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (plan_id = pip.plan_id)
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using insurance_category_master_pkey on insurance_category_master icam (cost=0.28..0.31 rows=1 width=4) (never executed)

  • Index Cond: (category_id = ipm.category_id)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using patient_policy_details_patient_policy_id_key on patient_policy_details ppd (cost=0.42..5.01 rows=1 width=4) (never executed)

  • Index Cond: (patient_policy_id = pip.patient_policy_id)
  • Heap Fetches: 0
Planning time : 61.422 ms
Execution time : 2,606.077 ms