explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6qk7

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 3,440.904 ↑ 1.6 5 1

Finalize GroupAggregate (cost=1,047,775.14..1,047,775.28 rows=8 width=17) (actual time=3,440.901..3,440.904 rows=5 loops=1)

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

Sort (cost=1,047,775.14..1,047,775.16 rows=8 width=17) (actual time=3,440.874..3,440.875 rows=10 loops=1)

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

Gather (cost=1,047,774.14..1,047,775.02 rows=8 width=17) (actual time=3,436.200..3,514.613 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 243.420 3,391.085 ↑ 1.6 5 2

Partial HashAggregate (cost=1,046,774.14..1,046,774.22 rows=8 width=17) (actual time=3,391.084..3,391.085 rows=5 loops=2)

  • Group Key: "OutcomeType
5. 2,582.410 3,147.665 ↓ 1.8 681,269 2

Parallel Bitmap Heap Scan on "Outcomes" o (cost=23,758.24..1,044,911.40 rows=372,549 width=9) (actual time=559.762..3,147.665 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=63071 lossy=57885
6. 565.255 565.255 ↓ 2.2 1,362,538 1

Bitmap Index Scan on ix_outcomes_outbound_communication_status (cost=0.00..23,599.90 rows=633,334 width=0) (actual time=565.255..565.255 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 : 0.418 ms