explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1lbd

Settings
# exclusive inclusive rows x rows loops node
1. 159.405 3,425.340 ↑ 9.0 1 1

GroupAggregate (cost=75,782.68..753,155.81 rows=9 width=17) (actual time=3,425.340..3,425.340 rows=1 loops=1)

  • Group Key: "OutcomeType
2. 2,343.705 3,265.935 ↓ 2.3 677,549 1

Bitmap Heap Scan on "Outcomes" o (cost=75,782.68..751,698.96 rows=291,353 width=9) (actual time=968.030..3,265.935 rows=677,549 loops=1)

  • Recheck Cond: (("OnboardingTemplateId" = 20) AND (("OutcomeType")::text = 'delivered'::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) AND (("ChannelType")::text = 'Email'::text))
  • Rows Removed by Index Recheck: 323617
  • Heap Blocks: exact=119613 lossy=107332
3. 922.230 922.230 ↓ 2.3 677,549 1

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..75,709.84 rows=291,353 width=0) (actual time=922.230..922.230 rows=677,549 loops=1)

  • Index Cond: (("OnboardingTemplateId" = 20) AND (("OutcomeType")::text = 'delivered'::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.351 ms