explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hpME

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

Index Scan Backward using t_load_bank_cbr_pkey on t_load_bank_cbr c (cost=0.14..364,820.08 rows=46 width=53) (actual rows= loops=)

2.          

SubPlan (for Index Scan Backward)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=7,930.36..7,930.38 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on t_bank_cbr b (cost=0.00..7,927.96 rows=961 width=0) (actual rows= loops=)

  • Filter: (ck_load_id = c.ck_id)