explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yPBr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 39.430 ↑ 1.0 1 1

Aggregate (cost=114,004.43..114,004.44 rows=1 width=40) (actual time=39.430..39.430 rows=1 loops=1)

2. 60.672 76.230 ↑ 18.6 5 1

Gather (cost=2,970.24..114,004.20 rows=93 width=4) (actual time=36.388..76.230 rows=5 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.089 15.558 ↑ 18.3 3 2

Nested Loop (cost=1,970.24..112,994.90 rows=55 width=4) (actual time=15.442..15.558 rows=3 loops=2)

4. 0.000 15.464 ↑ 200.1 18 2

Parallel Bitmap Heap Scan on "Outcomes" o (cost=1,969.80..84,505.59 rows=3,601 width=4) (actual time=15.401..15.464 rows=18 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 = 'open'::text))
  • Rows Removed by Index Recheck: 41
  • Filter: (("BankId" >= 1) AND (("ChannelType")::text = 'Email'::text) AND ("OnboardingTemplateId" = 20))
  • Rows Removed by Filter: 16
  • Heap Blocks: lossy=30
5. 5.910 30.648 ↓ 0.0 0 1

BitmapAnd (cost=1,969.80..1,969.80 rows=23,202 width=0) (actual time=30.648..30.648 rows=0 loops=1)

6. 17.516 17.516 ↓ 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=17.516..17.516 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))
7. 7.222 7.222 ↓ 1.1 81,703 1

Bitmap Index Scan on ix_outcomes_outcometype (cost=0.00..1,739.46 rows=75,604 width=0) (actual time=7.222..7.222 rows=81,703 loops=1)

  • Index Cond: (("OutcomeType")::text = 'open'::text)
8. 0.005 0.005 ↓ 0.0 0 35

Index Scan using "PK_OnboardingActionId" on "OnboardingActions" a (cost=0.43..7.91 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=35)

  • Index Cond: ("OnboardingActionId" = o."OnboardingActionId")
  • Filter: ("CampaignId" = 137)
  • Rows Removed by Filter: 1
Planning time : 0.933 ms