explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X0OR

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 43,125.310 ↑ 1.6 5 1

Finalize GroupAggregate (cost=1,195,105.40..1,195,105.54 rows=8 width=17) (actual time=43,125.306..43,125.310 rows=5 loops=1)

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

Sort (cost=1,195,105.40..1,195,105.42 rows=8 width=17) (actual time=43,125.301..43,125.301 rows=10 loops=1)

  • Sort Key: "OutcomeType
  • Sort Method: quicksort Memory: 25kB
3. 118.216 43,183.628 ↓ 1.2 10 1

Gather (cost=1,195,104.40..1,195,105.28 rows=8 width=17) (actual time=43,124.841..43,183.628 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 249.817 43,065.412 ↑ 1.6 5 2

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

  • Group Key: "OutcomeType
5. 42,796.460 42,815.595 ↓ 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=25.437..42,815.595 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=124027
6. 19.135 19.135 ↓ 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=19.135..19.135 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 : 1.597 ms