explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pBT4

Settings
# exclusive inclusive rows x rows loops node
1. 39.449 4,619.756 ↑ 2.2 4 1

GroupAggregate (cost=1,232,895.40..1,232,921.92 rows=9 width=17) (actual time=4,584.033..4,619.756 rows=4 loops=1)

  • Group Key: o."OutcomeType
2. 188.935 4,580.307 ↓ 64.4 226,993 1

Sort (cost=1,232,895.40..1,232,904.21 rows=3,524 width=13) (actual time=4,539.921..4,580.307 rows=226,993 loops=1)

  • Sort Key: o."OutcomeType
  • Sort Method: external merge Disk: 5776kB
3. 437.022 4,391.372 ↓ 64.4 226,993 1

Hash Join (cost=228,661.86..1,232,687.78 rows=3,524 width=13) (actual time=1,532.182..4,391.372 rows=226,993 loops=1)

  • Hash Cond: (o."OnboardingActionId" = a."OnboardingActionId")
4. 2,511.877 3,231.861 ↓ 2.3 1,362,538 1

Bitmap Heap Scan on "Outcomes" o (cost=22,596.01..1,025,051.44 rows=598,279 width=25) (actual time=809.521..3,231.861 rows=1,362,538 loops=1)

  • 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: 207
  • Heap Blocks: exact=119804 lossy=107357
5. 719.984 719.984 ↓ 2.3 1,362,538 1

Bitmap Index Scan on ix_outcomes_outbound_communication_status (cost=0.00..22,446.44 rows=598,279 width=0) (actual time=719.983..719.984 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))
6. 34.041 722.489 ↓ 2.7 115,207 1

Hash (cost=205,525.34..205,525.34 rows=43,241 width=12) (actual time=722.489..722.489 rows=115,207 loops=1)

  • Buckets: 131072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 5975kB
7. 175.608 688.448 ↓ 2.7 115,207 1

Bitmap Heap Scan on "OnboardingActions" a (cost=59,840.39..205,525.34 rows=43,241 width=12) (actual time=515.408..688.448 rows=115,207 loops=1)

  • Recheck Cond: (("CampaignId" = 137) AND ("OnboardingTemplateId" = 20))
  • Filter: (("BankId" = 1) AND (("TemplateType")::text = 'Email'::text))
  • Heap Blocks: exact=11011
8. 4.076 512.840 ↓ 0.0 0 1

BitmapAnd (cost=59,840.39..59,840.39 rows=47,028 width=0) (actual time=512.840..512.840 rows=0 loops=1)

9. 12.865 12.865 ↓ 1.0 115,207 1

Bitmap Index Scan on ix_onboardingactions_campaignid (cost=0.00..2,085.30 rows=111,583 width=0) (actual time=12.865..12.865 rows=115,207 loops=1)

  • Index Cond: ("CampaignId" = 137)
10. 495.899 495.899 ↑ 1.0 3,079,750 1

Bitmap Index Scan on ix_onboardingactions_onboardingtemplateid (cost=0.00..57,733.22 rows=3,093,971 width=0) (actual time=495.899..495.899 rows=3,079,750 loops=1)

  • Index Cond: ("OnboardingTemplateId" = 20)
Planning time : 1.794 ms