explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xFl9

Settings
# exclusive inclusive rows x rows loops node
1. 53.288 2,313.459 ↑ 1.0 1 1

Aggregate (cost=980,284.59..980,284.60 rows=1 width=8) (actual time=2,313.459..2,313.459 rows=1 loops=1)

2. 1,245.803 2,260.171 ↓ 2.2 658,190 1

Bitmap Heap Scan on "Outcomes" o (cost=60,481.02..979,548.79 rows=294,318 width=0) (actual time=1,103.018..2,260.171 rows=658,190 loops=1)

  • Recheck Cond: (("CreationDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("CreationDate" <= '2019-08-10 23:59:59'::timestamp without time zone) AND ("OnboardingTemplateId" = 20))
  • Rows Removed by Index Recheck: 6893
  • Heap Blocks: lossy=110848
3. 10.587 1,014.368 ↓ 0.0 0 1

BitmapAnd (cost=60,481.02..60,481.02 rows=499,622 width=0) (actual time=1,014.368..1,014.368 rows=0 loops=1)

4. 12.317 12.317 ↓ 1.1 1,276,160 1

Bitmap Index Scan on ix_outcomes_creationdate (cost=0.00..182.56 rows=1,145,748 width=0) (actual time=12.317..12.317 rows=1,276,160 loops=1)

  • Index Cond: (("CreationDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("CreationDate" <= '2019-08-10 23:59:59'::timestamp without time zone))
5. 991.464 991.464 ↓ 1.0 3,316,986 1

Bitmap Index Scan on ix_outcomes_onboardingtemplateid (cost=0.00..60,151.06 rows=3,253,150 width=0) (actual time=991.464..991.464 rows=3,316,986 loops=1)

  • Index Cond: ("OnboardingTemplateId" = 20)
Planning time : 0.281 ms