explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LOBB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,669.389 ↓ 0.0 0 1

Gather Merge (cost=155,942.64..155,944.27 rows=14 width=20) (actual time=2,648.318..2,669.389 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.102 7,918.269 ↓ 0.0 0 3

Sort (cost=154,942.61..154,942.63 rows=7 width=20) (actual time=2,639.423..2,639.423 rows=0 loops=3)

  • Sort Key: pip.priority
  • Sort Method: quicksort Memory: 25kB
3. 0.000 7,918.167 ↓ 0.0 0 3

Nested Loop (cost=1.28..154,942.52 rows=7 width=20) (actual time=2,639.389..2,639.389 rows=0 loops=3)

4. 0.003 7,918.167 ↓ 0.0 0 3

Nested Loop (cost=0.85..154,918.37 rows=7 width=24) (actual time=2,639.389..2,639.389 rows=0 loops=3)

5. 0.000 7,918.164 ↓ 0.0 0 3

Nested Loop (cost=0.56..154,916.23 rows=7 width=28) (actual time=2,639.388..2,639.388 rows=0 loops=3)

6. 0.003 7,918.164 ↓ 0.0 0 3

Nested Loop (cost=0.28..154,872.08 rows=7 width=28) (actual time=2,639.387..2,639.388 rows=0 loops=3)

7. 7,918.161 7,918.161 ↓ 0.0 0 3

Parallel Seq Scan on patient_insurance_plans pip (cost=0.00..154,861.38 rows=7 width=46) (actual time=2,639.386..2,639.387 rows=0 loops=3)

  • Filter: ((plan_id IS NOT NULL) AND ((patient_id)::text <> 'A01I19110000106'::text) AND ((mr_no)::text = 'UA0100000717272'::text))
  • Rows Removed by Filter: 2376559
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using insurance_company_master_pkey on insurance_company_master icm (cost=0.28..1.53 rows=1 width=8) (never executed)

  • Index Cond: (insurance_co_id = (pip.insurance_co)::text)
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Index Scan using insurance_plan_main_pkey on insurance_plan_main ipm (cost=0.29..6.31 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.29..0.30 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.43..3.45 rows=1 width=4) (never executed)

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