explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UhG5

Settings
# exclusive inclusive rows x rows loops node
1. 47.826 19,381.513 ↑ 2.0 4 1

GroupAggregate (cost=1,312,115.17..1,312,181.89 rows=8 width=17) (actual time=19,348.593..19,381.513 rows=4 loops=1)

  • Group Key: o."OutcomeType
2. 184.576 19,333.687 ↓ 25.5 226,993 1

Sort (cost=1,312,115.17..1,312,137.39 rows=8,885 width=13) (actual time=19,290.228..19,333.687 rows=226,993 loops=1)

  • Sort Key: o."OutcomeType
  • Sort Method: external merge Disk: 5776kB
3. 478.109 19,149.111 ↓ 25.5 226,993 1

Hash Join (cost=317,755.33..1,311,532.44 rows=8,885 width=13) (actual time=1,907.909..19,149.111 rows=226,993 loops=1)

  • Hash Cond: (o."OnboardingActionId" = a."OnboardingActionId")
4. 16,858.441 17,390.641 ↓ 2.3 1,362,538 1

Bitmap Heap Scan on "Outcomes" o (cost=27,277.25..1,019,520.04 rows=584,506 width=17) (actual time=626.619..17,390.641 rows=1,362,538 loops=1)

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

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..27,131.13 rows=584,506 width=0) (actual time=532.200..532.200 rows=1,362,538 loops=1)

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

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

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

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

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