explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sdt5p

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

Explicit Redistribute Motion 10:10 (slice2; segments: 10) (cost=286.07..9,579,014.71 rows=7,981,790 width=4,132) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=286.07..9,579,014.71 rows=7,981,790 width=4,132) (actual rows= loops=)

  • Hash Cond: re_mch_data.id::text = re_account_adj.mch_id::text
3. 0.000 0.000 ↓ 0.0

Seq Scan on re_mch_data (cost=0.00..543.49 rows=1,525 width=3,957) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=220.50..220.50 rows=525 width=184) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Redistribute Motion 10:10 (slice1; segments: 10) (cost=0.00..220.50 rows=525 width=184) (actual rows= loops=)

  • Hash Key: re_account_adj.mch_id::text
6. 0.000 0.000 ↓ 0.0

Seq Scan on re_account_adj (cost=0.00..115.58 rows=525 width=184) (actual rows= loops=)

  • Filter: month::text = '202002'::textOptimizer status: legacy query optimizer