explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UAct

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 2,261.028 ↑ 1.6 5 1

Finalize GroupAggregate (cost=805,828.39..805,828.53 rows=8 width=17) (actual time=2,261.024..2,261.028 rows=5 loops=1)

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

Sort (cost=805,828.39..805,828.41 rows=8 width=17) (actual time=2,261.016..2,261.016 rows=10 loops=1)

  • Sort Key: "OutcomeType
  • Sort Method: quicksort Memory: 25kB
3. 110.341 2,329.771 ↓ 1.2 10 1

Gather (cost=805,827.39..805,828.27 rows=8 width=17) (actual time=2,258.107..2,329.771 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 114.740 2,219.430 ↑ 1.6 5 2

Partial HashAggregate (cost=804,827.39..804,827.47 rows=8 width=17) (actual time=2,219.429..2,219.430 rows=5 loops=2)

  • Group Key: "OutcomeType
5. 1,104.177 2,104.690 ↓ 1.9 329,095 2

Parallel Bitmap Heap Scan on "Outcomes" o (cost=127,703.71..803,963.02 rows=172,874 width=13) (actual time=1,014.734..2,104.690 rows=329,095 loops=2)

  • Recheck Cond: (("OnboardingTemplateId" = 20) AND ("BankId" = 1) AND ("CreationDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("CreationDate" <= '2019-08-10 23:59:59'::timestamp without time zone) AND (("ChannelType")::text = 'Email'::text))
  • Heap Blocks: exact=63861
6. 1,000.513 1,000.513 ↓ 2.2 658,190 1

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..127,630.24 rows=293,886 width=0) (actual time=1,000.513..1,000.513 rows=658,190 loops=1)

  • Index Cond: (("OnboardingTemplateId" = 20) AND ("BankId" = 1) AND ("CreationDate" >= '2019-08-01 00:00:00'::timestamp without time zone) AND ("CreationDate" <= '2019-08-10 23:59:59'::timestamp without time zone))
Planning time : 0.915 ms