explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8SQh

Settings

Optimization(s) for this plan:

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

Unique (cost=10,758,938.14..13,289,220.03 rows=24,249,583 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=10,758,938.14..13,228,596.07 rows=24,249,583 width=4) (actual rows= loops=)

  • Merge Cond: (b0.irecipientid = r1.irecipientid)
3. 0.000 0.000 ↓ 0.0

Sort (cost=10,737,903.49..10,798,527.45 rows=24,249,583 width=4) (actual rows= loops=)

  • Sort Key: b0.irecipientid
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=47,901.81..7,100,440.52 rows=24,249,583 width=4) (actual rows= loops=)

  • Hash Cond: (b0.ideliveryid = d2.ideliveryid)
5. 0.000 0.000 ↓ 0.0

Seq Scan on nmsbroadlogrcp b0 (cost=0.00..6,111,541.96 rows=186,266,912 width=8) (actual rows= loops=)

  • Filter: ((tslastmodified >= '2018-08-18 04:00:00+00'::timestamp with time zone) AND ((ibroadlogid > 0) OR (ibroadlogid < 0)))
6. 0.000 0.000 ↓ 0.0

Hash (cost=47,750.01..47,750.01 rows=12,144 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on nmsdelivery d2 (cost=0.00..47,750.01 rows=12,144 width=4) (actual rows= loops=)

  • Filter: ((slabel)::text ~~ '%5%'::text)
8. 0.000 0.000 ↓ 0.0

Index Only Scan using nmsrecipient_id on nmsrecipient r1 (cost=0.56..1,993,016.70 rows=53,942,676 width=4) (actual rows= loops=)