explain.depesz.com

PostgreSQL's explain analyze made readable

Result: INTS

Settings
# exclusive inclusive rows x rows loops node
1. 148.837 3,179.472 ↑ 8.0 1 1

GroupAggregate (cost=12,970.87..717,524.47 rows=8 width=17) (actual time=3,179.471..3,179.472 rows=1 loops=1)

  • Group Key: "OutcomeType
2. 2,611.972 3,030.635 ↓ 2.2 677,549 1

Bitmap Heap Scan on "Outcomes" o (cost=12,970.87..715,975.57 rows=309,764 width=9) (actual time=464.520..3,030.635 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. 418.663 418.663 ↓ 2.2 677,549 1

Bitmap Index Scan on idx_outcomes_covering (cost=0.00..12,893.43 rows=309,764 width=0) (actual time=418.663..418.663 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.443 ms