explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zA1W

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 334,650.157 ↓ 0.0 0 1

Nested Loop Left Join (cost=15,021,370.18..15,021,385.33 rows=3 width=388) (actual time=334,650.157..334,650.157 rows=0 loops=1)

  • -> GroupAggregate (cost=15021369.48..15021369.54 rows=1 width=345) (actual time=334650.156..334650.156 rows=0 loops=1) |
  • Group Key: a.campaign, (replace((a.campaign)::text, ' '::text, ''::text)), a.campaign_id, a.ma_id, a.event_id, a.subs_id, a.msisdn, a.error_cd, a.error_msg, uc18_offer_matrix.nf_id, uc18_offer_matrix.nf_denom, fu.fulfill_channel_status, ((a.respon
2. 0.033 334,650.155 ↓ 0.0 0 1

Sort (cost=15,021,369.48..15,021,369.49 rows=1 width=209) (actual time=334,650.155..334,650.155 rows=0 loops=1)

  • Sort Key: a.campaign, (replace((a.campaign)::text, ' '::text, ''::text)), a.campaign_id, a.ma_id, a.event_id, a.subs_id, a.msisdn, a.error_cd, a.error_msg, uc18_offer_matrix.nf_id, uc18_offer_matrix.nf_denom, fu.fulfill_channel_status, ((a.r Sort Method: quicksort Memory: 25kB
3. 334,650.122 334,650.122 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,026,260.65..15,021,369.47 rows=1 width=209) (actual time=334,650.122..334,650.122 rows=0 loops=1)

  • Join Filter: ((a.event_id)::text = (fu.event_id)::text) |
  • -> Nested Loop Left Join (cost=0.56..13995099.64 rows=1 width=170) (actual time=334650.121..334650.121 rows=0 loops=1) |
  • Join Filter: ((a.ma_id)::text = (uc18_offer_matrix.ma_id)::text) |
  • -> Nested Loop Left Join (cost=0.56..13994965.99 rows=1 width=162) (actual time=334650.121..334650.121 rows=0 loops=1) |
  • Filter: (r.fulfill_channel_status IS NULL) |
  • -> Seq Scan on campaign_reporting a (cost=0.00..13650070.08 rows=44655 width=162) (actual time=334650.120..334650.120 rows=0 loops=1) |
  • Filter: ((contact_dttm IS NOT NULL) AND (response_dttm IS NOT NULL) AND (((treatment_desc)::text = ANY ('{Invite,Fulfillment}'::text[])) OR (error_cd IS NOT NULL)) AND (control_grp_tag = 0) AND ((response_dttm)::date |
  • Rows Removed by Filter: 195961286 |
  • -> Index Scan using msisdn_idx on event_fulfill r (cost=0.56..7.71 rows=1 width=28) (never executed) |
  • Index Cond: ((a.msisdn)::text = (msisdn)::text) |
  • Filter: (((event_id)::text ~~ 'RP_%'::text) AND ((fulfill_channel_status)::text = 'SUCCESS'::text) AND (fulfill_dttm >= a.response_dttm) AND ((fulfill_dttm)::date >= '2019-08-15'::date) AND (fulfill_dttm <= (a.respons|
  • -> Append (cost=0.00..126.62 rows=562 width=45) (never executed) |
  • -> Seq Scan on uc18_offer_matrix (cost=0.00..9.40 rows=40 width=53) (never executed) |
  • -> Seq Scan on uc9_offer_matrix (cost=0.00..52.16 rows=216 width=51) (never executed) |
  • -> Seq Scan on uc25_offer_matrix (cost=0.00..34.31 rows=131 width=26) (never executed) |
  • -> Seq Scan on uc21_offer_matrix (cost=0.00..19.18 rows=118 width=37) (never executed) |
  • -> Seq Scan on uc27_offer_matrix (cost=0.00..1.02 rows=2 width=294) (never executed) |
  • -> Seq Scan on uc20_offer_matrix (cost=0.00..1.03 rows=3 width=294) (never executed) |
  • -> Seq Scan on uc19_offer_matrix (cost=0.00..1.02 rows=2 width=294) (never executed) |
  • -> Seq Scan on uc22_offer_matrix (cost=0.00..4.22 rows=22 width=43) (never executed) |
  • -> Seq Scan on uc28_offer_matrix (cost=0.00..4.28 rows=28 width=43) (never executed) |
  • -> GroupAggregate (cost=1026260.09..1026265.22 rows=205 width=53) (never executed) |
  • Group Key: fu.msisdn, fu.event_id, fu.fulfill_channel_status |
  • -> Sort (cost=1026260.09..1026260.60 rows=205 width=57) (never executed) |
  • Sort Key: fu.msisdn, fu.event_id, fu.fulfill_channel_status
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on event_fulfill fu (cost=0.00..1,026,252.22 rows=205 width=57) (never executed)

  • Filter: (((fulfill_channel_status)::text <> 'SUCCESS'::text) AND ((fulfill_dttm)::date >= '2019-09-01'::date)) |
5. 0.000 0.000 ↓ 0.0 0

Index Scan using event_id_event_offer_idx on event_offer o (cost=0.70..15.75 rows=3 width=100) (never executed)

  • Index Cond: ((a.event_id)::text = (event_id)::text)