explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uFH1

Settings
# exclusive inclusive rows x rows loops node
1. 128.400 3,450.042 ↑ 1.0 1 1

Aggregate (cost=1,098,276.44..1,098,276.45 rows=1 width=8) (actual time=3,450.041..3,450.042 rows=1 loops=1)

2. 2,615.137 3,321.642 ↓ 2.2 1,362,538 1

Bitmap Heap Scan on "Outcomes" o (cost=71,863.49..1,096,701.19 rows=630,101 width=0) (actual time=764.015..3,321.642 rows=1,362,538 loops=1)

  • 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 (("ChannelType")::text = 'Email'::text) AND ("OnboardingTemplateId" = 20) AND ("BankId" >= 1))
  • Rows Removed by Index Recheck: 207
  • Heap Blocks: exact=119804 lossy=107357
3. 706.505 706.505 ↓ 2.2 1,362,538 1

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..71,705.96 rows=630,101 width=0) (actual time=706.504..706.505 rows=1,362,538 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) AND (("ChannelType")::text = 'Email'::text) AND ("OnboardingTemplateId" = 20) AND ("BankId" >= 1))
Planning time : 0.299 ms