explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eOyv

Settings

Optimization(s) for this plan:

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

Gather Motion 10:1 (slice1; segments: 10) (cost=734.10..2,990,877.80 rows=239,180,113 width=4,480) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=734.10..2,990,877.80 rows=23,918,012 width=4,480) (actual rows= loops=)

  • Hash Cond: b.mch_id::text = a.id::text
3. 0.000 0.000 ↓ 0.0

Seq Scan on sy_re_account_adj b (cost=0.00..352.95 rows=1,574 width=400) (actual rows= loops=)

  • Filter: month::text = '202002'::text
4. 0.000 0.000 ↓ 0.0

Hash (cost=543.49..543.49 rows=1,525 width=4,080) (actual rows= loops=)

  • -> Seq Scan on re_mch_data a (cost=0.00..543.49 rows=1525 width=4080)Optimizer status: legacy query optimizer