explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SP1j

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.328 ↑ 1.0 1 1

Aggregate (cost=1,169.63..1,169.64 rows=1 width=40) (actual time=0.328..0.328 rows=1 loops=1)

2. 0.000 0.312 ↓ 1.4 7 1

Nested Loop (cost=0.85..1,169.62 rows=5 width=4) (actual time=0.238..0.312 rows=7 loops=1)

3. 0.231 0.231 ↑ 2.2 28 1

Index Scan using ix_outcomes_outcometype on "Outcomes" o (cost=0.42..646.03 rows=62 width=4) (actual time=0.036..0.231 rows=28 loops=1)

  • Index Cond: (("OutcomeType")::text = 'open'::text)
  • 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) AND ("OnboardingTemplateId" = 33))
  • Rows Removed by Filter: 135
4. 0.084 0.084 ↓ 0.0 0 28

Index Scan using "PK_OnboardingActionId" on "OnboardingActions" a (cost=0.42..8.45 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=28)

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