explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7H4H

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 47,484.343 ↑ 1.8 5 1

Finalize GroupAggregate (cost=1,144,427.10..1,144,427.25 rows=9 width=17) (actual time=47,484.340..47,484.343 rows=5 loops=1)

  • Group Key: "OutcomeType
2. 0.000 47,484.333 ↓ 1.1 10 1

Sort (cost=1,144,427.10..1,144,427.12 rows=9 width=17) (actual time=47,484.333..47,484.333 rows=10 loops=1)

  • Sort Key: "OutcomeType
  • Sort Method: quicksort Memory: 25kB
3. 124.741 47,573.690 ↓ 1.1 10 1

Gather (cost=1,144,425.96..1,144,426.95 rows=9 width=17) (actual time=47,480.750..47,573.690 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 274.002 47,448.949 ↑ 1.8 5 2

Partial HashAggregate (cost=1,143,425.96..1,143,426.05 rows=9 width=17) (actual time=47,448.948..47,448.949 rows=5 loops=2)

  • Group Key: "OutcomeType
5. 45,628.060 47,174.947 ↓ 1.8 681,269 2

Parallel Bitmap Heap Scan on "Outcomes" o (cost=124,708.94..1,141,582.05 rows=368,783 width=13) (actual time=1,555.249..47,174.947 rows=681,269 loops=2)

  • Recheck Cond: (("OnboardingTemplateId" = 20) AND (("ChannelType")::text = 'Email'::text) AND ("BankId" >= 1) AND ("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: 104
  • Heap Blocks: exact=62731 lossy=55908
6. 1,546.887 1,546.887 ↓ 2.2 1,362,538 1

Bitmap Index Scan on ix_outcomes_outbound_communication_status (cost=0.00..124,552.20 rows=626,931 width=0) (actual time=1,546.887..1,546.887 rows=1,362,538 loops=1)

  • Index Cond: (("OnboardingTemplateId" = 20) AND (("ChannelType")::text = 'Email'::text) AND ("BankId" >= 1) AND ("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 : 2.124 ms