explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1nyY

Settings
# exclusive inclusive rows x rows loops node
1. 45.227 5,040.959 ↑ 2.0 4 1

GroupAggregate (cost=1,389,466.66..1,389,538.57 rows=8 width=17) (actual time=5,001.175..5,040.959 rows=4 loops=1)

  • Group Key: o."OutcomeType
2. 173.415 4,995.732 ↓ 23.7 226,993 1

Sort (cost=1,389,466.66..1,389,490.60 rows=9,578 width=13) (actual time=4,951.922..4,995.732 rows=226,993 loops=1)

  • Sort Key: o."OutcomeType
  • Sort Method: external merge Disk: 5776kB
3. 418.236 4,822.317 ↓ 23.7 226,993 1

Hash Join (cost=362,341.57..1,388,833.29 rows=9,578 width=13) (actual time=2,068.515..4,822.317 rows=226,993 loops=1)

  • Hash Cond: (o."OnboardingActionId" = a."OnboardingActionId")
4. 2,375.992 3,254.227 ↓ 2.2 1,362,538 1

Bitmap Heap Scan on "Outcomes" o (cost=71,863.49..1,096,701.19 rows=630,101 width=17) (actual time=917.432..3,254.227 rows=1,362,538 loops=1)

  • Recheck Cond: (("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) AND ("OnboardingTemplateId" = 20) AND ("BankId" >= 1))
  • Rows Removed by Index Recheck: 207
  • Heap Blocks: exact=119804 lossy=107357
5. 878.235 878.235 ↓ 2.2 1,362,538 1

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..71,705.96 rows=630,101 width=0) (actual time=878.235..878.235 rows=1,362,538 loops=1)

  • Index Cond: (("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) AND ("OnboardingTemplateId" = 20) AND ("BankId" >= 1))
6. 31.367 1,149.854 ↓ 1.0 115,207 1

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

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

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

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