explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7TXw

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

Aggregate (cost=246,548.19..246,548.45 rows=1 width=437) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=246,548.19..246,548.2 rows=1 width=437) (never executed)

  • Sort Key: f_sum.mon_account_id_nk, f_sum.d_calc_rate_schedule_id, fca_rs_validation_work_active.bucket_num, fca_rs_validation_work_active.service_year_begin, f_sum.d_type_of_calc_id, f_sum.d_is_survivor_yn_id, f_sum.d_calc_payer_rank_id, f_sum.d_calc_payer_id, f_sum.d_is_charge_or_837_id, f_sum.d_is_current_yn_id, f_sum.mon_account_payer_id_nk, f_sum.mon_payer_id_nk
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,438.57..246,548.18 rows=1 width=437) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,438.29..246,547.79 rows=1 width=434) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,437.86..246,547.26 rows=1 width=432) (never executed)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,437.44..246,546.73 rows=1 width=430) (never executed)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,437.02..246,546.16 rows=1 width=429) (never executed)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,436.6..246,545.62 rows=1 width=427) (never executed)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,436.18..246,545.1 rows=1 width=376) (never executed)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,435.76..246,544.57 rows=1 width=325) (never executed)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=19,435.33..226,631.16 rows=8,334 width=317) (never executed)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,825.09..208,378.44 rows=60,206 width=299) (never executed)

13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fca_rs_validation_work_active fca_rs_validation_work_active (cost=1,824.66..11,920.82 rows=80,803 width=17) (never executed)

14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fca_rs_validation_work_mon_account_id_nk_buck_num_srv_yr_idx (cost=0..1,804.45 rows=80,803 width=0) (never executed)

  • Index Cond: ((bucket_num = 6) AND (service_year_begin = '2016'::text))
15. 0.000 0.000 ↓ 0.0

Index Scan using f_csc_mon_acc_is_curr_yn_idx_active_2016 on f_calc_summary_consolidated_active_2016 f_sum (cost=0.43..2.38 rows=1 width=282) (never executed)

  • Index Cond: ((mon_account_id_nk = fca_rs_validation_work_active.mon_account_id) AND (d_is_current_yn_id = 1010))
16. 0.000 0.000 ↓ 0.0

Hash (cost=15,294.15..15,294.15 rows=44,116 width=22) (never executed)

17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_code d_code (cost=695.77..15,294.15 rows=44,116 width=22) (never executed)

18. 0.000 0.000 ↓ 0.0

BitmapOr (cost=695.77..695.77 rows=44,116 width=0) (never executed)

19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_code_type_cat_idx (cost=0..671.28 rows=44,115 width=0) (never executed)

  • Index Cond: ((code_type_category)::text = 'DRG'::text)
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_code_id_code_idx (cost=0..2.43 rows=1 width=0) (never executed)

  • Index Cond: (id = 0)
21. 0.000 0.000 ↓ 0.0

Index Scan using f_calc_svccons_accountid_idx_active_2016 on f_calc_service_consolidated_active_2016 f_srv (cost=0.43..2.34 rows=1 width=40) (never executed)

  • Index Cond: (mon_account_id_nk = f_sum.mon_account_id_nk)
  • Filter: (f_sum.mon_acct_payer_calc_sum_id_nk = mon_acct_payer_calc_sum_id_nk)
22. 0.000 0.000 ↓ 0.0

Index Only Scan using d_service_id_name_idx on d_service dstop (cost=0.42..0.48 rows=1 width=67) (never executed)

  • Index Cond: (id = f_sum.d_stoploss_id)
23. 0.000 0.000 ↓ 0.0

Index Only Scan using d_service_id_name_idx on d_service srv (cost=0.42..0.48 rows=1 width=67) (never executed)

  • Index Cond: (id = f_srv.d_service_id)
24. 0.000 0.000 ↓ 0.0

Index Only Scan using d_code_id_code_idx on d_code dpat (cost=0.42..0.48 rows=1 width=14) (never executed)

  • Index Cond: (id = f_sum.d_patient_status_id)
25. 0.000 0.000 ↓ 0.0

Index Scan using d_code_pkey on d_code d_calc_pat_type (cost=0.42..0.52 rows=1 width=13) (never executed)

  • Index Cond: (id = f_sum.d_calc_patient_type_id)
26. 0.000 0.000 ↓ 0.0

Index Only Scan using d_code_id_code_idx on d_code srv_rev_code (cost=0.42..0.48 rows=1 width=14) (never executed)

  • Index Cond: (id = f_srv.d_rev_code_id)
27. 0.000 0.000 ↓ 0.0

Index Only Scan using d_code_id_code_idx on d_code srv_proc_code (cost=0.42..0.48 rows=1 width=14) (never executed)

  • Index Cond: (id = f_srv.d_proc_code_id)
28. 0.000 0.000 ↓ 0.0

Index Scan using d_modifier_pkey on d_modifier mod (cost=0.29..0.35 rows=1 width=19) (never executed)

  • Index Cond: (id = f_srv.d_modifier_id)