explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fsd6

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 90.758 ↑ 1.0 1 1

Aggregate (cost=184,945.80..184,945.81 rows=1 width=40) (actual time=90.757..90.758 rows=1 loops=1)

2. 0.004 90.746 ↑ 48.9 9 1

Nested Loop (cost=18,648.94..184,944.70 rows=440 width=4) (actual time=90.697..90.746 rows=9 loops=1)

3. 0.037 90.676 ↑ 704.7 22 1

Bitmap Heap Scan on "Outcomes" o (cost=18,648.51..80,533.32 rows=15,503 width=4) (actual time=90.654..90.676 rows=22 loops=1)

  • Recheck Cond: ((("OutcomeType")::text = 'open'::text) AND ("OnboardingTemplateId" = 13))
  • Rows Removed by Index Recheck: 4
  • Filter: (("BankId" >= 1) AND ("CreationDate" >= '2018-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))
  • Heap Blocks: exact=20
4. 0.274 90.639 ↓ 0.0 0 1

BitmapAnd (cost=18,648.51..18,648.51 rows=17,966 width=0) (actual time=90.639..90.639 rows=0 loops=1)

5. 5.130 5.130 ↓ 1.1 81,570 1

Bitmap Index Scan on ix_outcomes_outcometype (cost=0.00..1,768.38 rows=77,327 width=0) (actual time=5.130..5.130 rows=81,570 loops=1)

  • Index Cond: (("OutcomeType")::text = 'open'::text)
6. 85.235 85.235 ↓ 1.0 919,035 1

Bitmap Index Scan on ix_outcomes_onboardingtemplateid (cost=0.00..16,872.13 rows=911,960 width=0) (actual time=85.235..85.235 rows=919,035 loops=1)

  • Index Cond: ("OnboardingTemplateId" = 13)
7. 0.066 0.066 ↓ 0.0 0 22

Index Scan using "PK_OnboardingActionId" on "OnboardingActions" a (cost=0.43..6.72 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=22)

  • Index Cond: ("OnboardingActionId" = o."OnboardingActionId")
  • Filter: ("CampaignId" = 92)
  • Rows Removed by Filter: 1
Planning time : 0.286 ms
Execution time : 90.822 ms