explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0zxIS

Settings
# exclusive inclusive rows x rows loops node
1. 58.466 31,618.835 ↑ 2.0 4 1

GroupAggregate (cost=1,410,954.30..1,411,020.77 rows=8 width=17) (actual time=31,574.141..31,618.835 rows=4 loops=1)

  • Group Key: o."OutcomeType
2. 254.823 31,560.369 ↓ 25.6 226,993 1

Sort (cost=1,410,954.30..1,410,976.43 rows=8,851 width=13) (actual time=31,503.789..31,560.369 rows=226,993 loops=1)

  • Sort Key: o."OutcomeType
  • Sort Method: external merge Disk: 5776kB
3. 539.436 31,305.546 ↓ 25.6 226,993 1

Hash Join (cost=418,253.90..1,410,374.05 rows=8,851 width=13) (actual time=2,584.152..31,305.546 rows=226,993 loops=1)

  • Hash Cond: (o."OnboardingActionId" = a."OnboardingActionId")
4. 28,221.553 29,241.953 ↓ 2.3 1,362,538 1

Bitmap Heap Scan on "Outcomes" o (cost=127,775.82..1,118,367.38 rows=582,320 width=17) (actual time=1,059.353..29,241.953 rows=1,362,538 loops=1)

  • Recheck Cond: (("OnboardingTemplateId" = 20) 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) AND (("ChannelType")::text = 'Email'::text))
  • Rows Removed by Index Recheck: 5
  • Heap Blocks: exact=119813 lossy=107348
5. 1,020.400 1,020.400 ↓ 2.3 1,362,538 1

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..127,630.24 rows=582,320 width=0) (actual time=1,020.400..1,020.400 rows=1,362,538 loops=1)

  • Index Cond: (("OnboardingTemplateId" = 20) 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. 33.416 1,524.157 ↓ 1.0 115,207 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 5075kB
7. 1,457.738 1,490.741 ↓ 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=35.101..1,490.741 rows=115,207 loops=1)

  • Recheck Cond: ("CampaignId" = 137)
  • Heap Blocks: exact=11011
8. 33.003 33.003 ↓ 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=33.003..33.003 rows=115,207 loops=1)

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