explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j7pc : Optimization for: 1; plan #DTLq

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.66..281,055.98 rows=11,311 width=156) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.52..278,909.03 rows=11,311 width=152) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.52..266,184.15 rows=11,311 width=124) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.52..237,256.27 rows=11,311 width=126) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using fin_bill_generate_bill_id_idx on fin_bill_generate g (cost=0.43..9,673.29 rows=11,311 width=114) (actual rows= loops=)

  • Index Cond: (bill_id = 854)
  • Filter: ((NOT is_sifted) AND ((region_data ->> 'is_tariff_service'::text))::boolean)
6. 0.000 0.000 ↓ 0.0

Limit (cost=16.09..20.10 rows=1 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on pim_org_code (cost=16.09..20.10 rows=1 width=12) (actual rows= loops=)

  • Recheck Cond: ((org_id = g.org_id) AND (type_id = 7))
8. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=16.09..16.09 rows=1 width=0) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fk_pim_org_code_to_org (cost=0.00..4.46 rows=6 width=0) (actual rows= loops=)

  • Index Cond: (org_id = g.org_id)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fkc6856cb3ec5d17fa (cost=0.00..11.37 rows=394 width=0) (actual rows= loops=)

  • Index Cond: (type_id = 7)
11. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..2.54 rows=1 width=2) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on mc_payment_method (cost=0.00..2.54 rows=1 width=2) (actual rows= loops=)

  • Filter: (id = g.payment_method_id)
13. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..1.10 rows=1 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on mc_care_regimen (cost=0.00..1.10 rows=1 width=4) (actual rows= loops=)

  • Filter: (id = g.care_regimen_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using mc_case_init_goal_pk on mc_case_init_goal i (cost=0.14..0.16 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = g.init_goal_id)