explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CWPn

Settings
# exclusive inclusive rows x rows loops node
1. 29.958 23,849.290 ↑ 2.0 4 1

GroupAggregate (cost=1,441,407.03..1,441,478.68 rows=8 width=17) (actual time=23,819.438..23,849.290 rows=4 loops=1)

  • Group Key: o."OutcomeType
2. 171.676 23,819.332 ↓ 23.8 226,993 1

Sort (cost=1,441,407.03..1,441,430.89 rows=9,543 width=9) (actual time=23,782.003..23,819.332 rows=226,993 loops=1)

  • Sort Key: o."OutcomeType
  • Sort Method: external merge Disk: 4448kB
3. 427.708 23,647.656 ↓ 23.8 226,993 1

Hash Join (cost=415,850.29..1,440,776.23 rows=9,543 width=9) (actual time=2,546.620..23,647.656 rows=226,993 loops=1)

  • Hash Cond: (o."OnboardingActionId" = a."OnboardingActionId")
4. 20,720.688 21,991.488 ↓ 2.2 1,362,538 1

Bitmap Heap Scan on "Outcomes" o (cost=125,372.21..1,148,650.16 rows=627,806 width=13) (actual time=1,317.208..21,991.488 rows=1,362,538 loops=1)

  • Recheck Cond: (("OnboardingTemplateId" = 20) AND (("ChannelType")::text = 'Email'::text) AND ("BankId" >= 1) AND ("CreationDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("CreationDate" <= '2019-08-19 23:59:59'::timestamp without time zone))
  • Rows Removed by Index Recheck: 207
  • Heap Blocks: exact=119804 lossy=107357
5. 1,270.800 1,270.800 ↓ 2.2 1,362,538 1

Bitmap Index Scan on ix_outcomes_outbound_communication_status (cost=0.00..125,215.26 rows=627,806 width=0) (actual time=1,270.800..1,270.800 rows=1,362,538 loops=1)

  • Index Cond: (("OnboardingTemplateId" = 20) AND (("ChannelType")::text = 'Email'::text) AND ("BankId" >= 1) AND ("CreationDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("CreationDate" <= '2019-08-19 23:59:59'::timestamp without time zone))
6. 31.468 1,228.460 ↓ 1.0 115,207 1

Hash (cost=289,083.29..289,083.29 rows=111,583 width=4) (actual time=1,228.460..1,228.460 rows=115,207 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5075kB
7. 1,171.507 1,196.992 ↓ 1.0 115,207 1

Bitmap Heap Scan on "OnboardingActions" a (cost=2,113.20..289,083.29 rows=111,583 width=4) (actual time=29.167..1,196.992 rows=115,207 loops=1)

  • Recheck Cond: ("CampaignId" = 137)
  • Heap Blocks: exact=11011
8. 25.485 25.485 ↓ 1.0 115,207 1

Bitmap Index Scan on ix_onboardingactions_campaignid (cost=0.00..2,085.30 rows=111,583 width=0) (actual time=25.484..25.485 rows=115,207 loops=1)

  • Index Cond: ("CampaignId" = 137)
Planning time : 3.129 ms