explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qLiF

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

Sort (cost=259,968.60..260,032.30 rows=25,478 width=952) (actual rows= loops=)

  • Sort Key: b.cv_bic
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=246,189.83..247,478.00 rows=25,478 width=952) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=246,189.42..246,191.42 rows=200 width=8) (actual rows= loops=)

  • Group Key: (SubPlan 1)
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,084.68..246,158.98 rows=2,435 width=18) (actual rows= loops=)

  • Group Key: b_1.cv_bic
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=12.26..7,957.29 rows=50,957 width=10) (actual rows= loops=)

  • Hash Cond: (b_1.ck_load_id = lb.ck_id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on t_bank_cbr b_1 (cost=0.00..7,800.57 rows=50,957 width=18) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=11.69..11.69 rows=46 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on t_load_bank_cbr lb (cost=0.00..11.69 rows=46 width=8) (actual rows= loops=)

  • Filter: (cl_valid AND (cd_business_day <= now()))
9.          

SubPlan (for HashAggregate)

10. 0.000 0.000 ↓ 0.0

Limit (cost=97.76..97.76 rows=1 width=28) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Sort (cost=97.76..97.81 rows=21 width=28) (actual rows= loops=)

  • Sort Key: lb1.cd_business_day DESC, lb1.cn_version DESC, lb1.ct_loaded_at DESC
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=16.72..97.65 rows=21 width=28) (actual rows= loops=)

  • Hash Cond: (b1.ck_load_id = lb1.ck_id)
13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on t_bank_cbr b1 (cost=4.45..85.33 rows=21 width=16) (actual rows= loops=)

  • Recheck Cond: ((cv_bic)::text = (b_1.cv_bic)::text)
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t_bank_cbr_cv_bic_idx (cost=0.00..4.45 rows=21 width=0) (actual rows= loops=)

  • Index Cond: ((cv_bic)::text = (b_1.cv_bic)::text)
15. 0.000 0.000 ↓ 0.0

Hash (cost=11.69..11.69 rows=46 width=28) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on t_load_bank_cbr lb1 (cost=0.00..11.69 rows=46 width=28) (actual rows= loops=)

  • Filter: (cl_valid AND (cd_business_day <= now()))
17. 0.000 0.000 ↓ 0.0

Index Scan using t_bank_cbr_pkey on t_bank_cbr b (cost=0.41..7.63 rows=1 width=952) (actual rows= loops=)

  • Index Cond: (ck_id = ((SubPlan 1)))