explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hDP

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 68.011 ↓ 0.0 0 1

GroupAggregate (cost=19,311.90..19,312.18 rows=14 width=114) (actual time=68.011..68.011 rows=0 loops=1)

  • Group Key: a."OutcomeType
2. 0.008 68.010 ↓ 0.0 0 1

Sort (cost=19,311.90..19,311.93 rows=14 width=90) (actual time=68.010..68.010 rows=0 loops=1)

  • Sort Key: a."OutcomeType
  • Sort Method: quicksort Memory: 25kB
3. 0.000 68.002 ↓ 0.0 0 1

Subquery Scan on a (cost=19,311.21..19,311.63 rows=14 width=90) (actual time=68.002..68.002 rows=0 loops=1)

4. 0.002 68.002 ↓ 0.0 0 1

GroupAggregate (cost=19,311.21..19,311.49 rows=14 width=95) (actual time=68.002..68.002 rows=0 loops=1)

  • Group Key: o."OnboardingActionId", o."Url
5. 0.000 68.000 ↓ 0.0 0 1

Sort (cost=19,311.21..19,311.25 rows=14 width=9) (actual time=68.000..68.000 rows=0 loops=1)

  • Sort Key: o."OnboardingActionId", o."Url
  • Sort Method: quicksort Memory: 25kB
6. 55.977 72.804 ↓ 0.0 0 1

Gather (cost=1,489.25..19,310.95 rows=14 width=9) (actual time=67.994..72.804 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
7. 0.002 16.827 ↓ 0.0 0 2

Nested Loop (cost=489.25..18,309.55 rows=8 width=9) (actual time=16.826..16.827 rows=0 loops=2)

8. 0.000 16.825 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on "Outcomes" o (cost=488.82..13,809.19 rows=538 width=9) (actual time=16.825..16.825 rows=0 loops=2)

  • 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 (("OutcomeType")::text = 'click'::text))
  • Rows Removed by Index Recheck: 10
  • Filter: (("BankId" >= 1) AND (("ChannelType")::text = 'Email'::text) AND ("OnboardingTemplateId" = 20))
  • Rows Removed by Filter: 2
  • Heap Blocks: lossy=4
9. 15.883 33.423 ↓ 0.0 0 1

BitmapAnd (cost=488.82..488.82 rows=3,464 width=0) (actual time=33.423..33.423 rows=0 loops=1)

10. 16.874 16.874 ↓ 1.1 2,448,640 1

Bitmap Index Scan on ix_outcomes_creationdate (cost=0.00..227.03 rows=2,267,263 width=0) (actual time=16.874..16.874 rows=2,448,640 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))
11. 0.666 0.666 ↑ 2.1 5,335 1

Bitmap Index Scan on ix_outcomes_outcometype (cost=0.00..261.09 rows=11,287 width=0) (actual time=0.666..0.666 rows=5,335 loops=1)

  • Index Cond: (("OutcomeType")::text = 'click'::text)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_OnboardingActionId" on "OnboardingActions" a_1 (cost=0.43..8.36 rows=1 width=4) (never executed)

  • Index Cond: ("OnboardingActionId" = o."OnboardingActionId")
  • Filter: ("CampaignId" = 137)
Planning time : 1.099 ms