explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qTQX

Settings
# exclusive inclusive rows x rows loops node
1. 48.990 3,840.851 ↑ 2.2 4 1

GroupAggregate (cost=1,317,697.97..1,317,766.26 rows=9 width=17) (actual time=3,791.529..3,840.851 rows=4 loops=1)

  • Group Key: o."OutcomeType
2. 177.543 3,791.861 ↓ 25.0 226,993 1

Sort (cost=1,317,697.97..1,317,720.70 rows=9,094 width=13) (actual time=3,751.100..3,791.861 rows=226,993 loops=1)

  • Sort Key: o."OutcomeType
  • Sort Method: external merge Disk: 5776kB
3. 423.827 3,614.318 ↓ 25.0 226,993 1

Hash Join (cost=313,074.09..1,317,100.00 rows=9,094 width=13) (actual time=740.636..3,614.318 rows=226,993 loops=1)

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

Bitmap Heap Scan on "Outcomes" o (cost=22,596.01..1,025,051.44 rows=598,279 width=17) (actual time=588.002..3,038.496 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. 548.704 548.704 ↓ 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=548.704..548.704 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. 29.474 151.995 ↓ 1.0 115,207 1

Hash (cost=289,083.29..289,083.29 rows=111,583 width=4) (actual time=151.995..151.995 rows=115,207 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5075kB
7. 112.562 122.521 ↓ 1.0 115,207 1

Bitmap Heap Scan on "OnboardingActions" a (cost=2,113.20..289,083.29 rows=111,583 width=4) (actual time=12.136..122.521 rows=115,207 loops=1)

  • Recheck Cond: ("CampaignId" = 137)
  • Heap Blocks: exact=11011
8. 9.959 9.959 ↓ 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=9.959..9.959 rows=115,207 loops=1)

  • Index Cond: ("CampaignId" = 137)
Planning time : 1.111 ms