explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pf6E : Optimization for: plan #chnG

Settings

Optimization path:

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

Result (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Redistribute Motion 288:288 (slice2; segments: 288) (cost=0.00..4,478,153.93 rows=3,940,049 width=284) (actual rows= loops=)

  • Hash Key: cnsmpn_tel_test3.cmpgn_uid, cnsmpn_tel_test3.trgt_uid, cnsmpn_tel_test3.identity_uid
3. 0.000 0.000 ↓ 0.0

Result (cost=0.00..42,047.71 rows=3,940,049 width=288) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..40,912.98 rows=3,940,049 width=1,482) (actual rows= loops=)

  • Hash Cond: cnsmpn_tel_test3.cmpgn_uid = cnsmpn_tel_cmpgn_dim.cmpgn_uid
5. 0.000 0.000 ↓ 0.0

Redistribute Motion 288:288 (slice1; segments: 288) (cost=0.00..17,478.09 rows=3,940,049 width=778) (actual rows= loops=)

  • Hash Key: cnsmpn_tel_test3.cmpgn_uid
6. 0.000 0.000 ↓ 0.0

Table Scan on cnsmpn_tel_test3 (cost=0.00..2,181.96 rows=3,940,049 width=778) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=431.41..431.41 rows=846 width=712) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Table Scan on cnsmpn_tel_cmpgn_dim (cost=0.00..431.41 rows=846 width=712) (actual rows= loops=)