explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q43Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2,955.095 ↑ 1.6 5 1

Finalize GroupAggregate (cost=1,195,105.40..1,195,105.54 rows=8 width=17) (actual time=2,955.092..2,955.095 rows=5 loops=1)

  • Group Key: "OutcomeType
2. 0.000 2,955.086 ↓ 1.2 10 1

Sort (cost=1,195,105.40..1,195,105.42 rows=8 width=17) (actual time=2,955.085..2,955.086 rows=10 loops=1)

  • Sort Key: "OutcomeType
  • Sort Method: quicksort Memory: 25kB
3. 258.122 3,018.863 ↓ 1.2 10 1

Gather (cost=1,195,104.40..1,195,105.28 rows=8 width=17) (actual time=2,954.503..3,018.863 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 277.652 2,760.741 ↑ 1.6 5 2

Partial HashAggregate (cost=1,194,104.40..1,194,104.48 rows=8 width=17) (actual time=2,760.739..2,760.741 rows=5 loops=2)

  • Group Key: "OutcomeType
5. 2,462.356 2,483.089 ↓ 1.9 681,269 2

Parallel Bitmap Heap Scan on "Outcomes" o (cost=386.15..1,192,280.55 rows=364,771 width=9) (actual time=10.990..2,483.089 rows=681,269 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))
  • Rows Removed by Index Recheck: 52920
  • Filter: (("BankId" >= 1) AND ("OnboardingTemplateId" = 20) AND (("ChannelType")::text = 'Email'::text))
  • Rows Removed by Filter: 22
  • Heap Blocks: lossy=158584
6. 20.733 20.733 ↓ 1.0 2,448,640 1

Bitmap Index Scan on ix_outcomes_creationdate (cost=0.00..231.12 rows=2,384,563 width=0) (actual time=20.733..20.733 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))
Planning time : 0.621 ms