explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jk0f : Optimization for: plan #eOyv

Settings

Optimization path:

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

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

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=549.67..2,990,882.69 rows=23,918,012 width=4,480) (actual rows= loops=)

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

Seq Scan on re_mch_data a (cost=0.00..543.49 rows=1,525 width=4,080) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=352.95..352.95 rows=1,574 width=400) (actual rows= loops=)

5. 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