explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8I4i

Settings
# exclusive inclusive rows x rows loops node
1. 183.249 246,525.514 ↓ 1,001.0 43,042 1

Gather (cost=162,602.64..325,453.25 rows=43 width=140) (actual time=33,401.617..246,525.514 rows=43,042 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 5.282 246,342.265 ↓ 797.1 14,347 3 / 3

Nested Loop Left Join (cost=161,602.64..324,448.76 rows=18 width=140) (actual time=33,978.816..246,342.265 rows=14,347 loops=3)

3. 243,028.296 245,389.165 ↓ 16.9 305 3 / 3

Parallel Bitmap Heap Scan on system_emails se (cost=161,602.07..324,364.97 rows=18 width=80) (actual time=33,977.072..245,389.165 rows=305 loops=3)

  • Recheck Cond: ((property_id = ANY ('{218059,218060,218061,218062,218063,218064,218065,218066,218067,218068,218069,218070,218071,218072,218073,218074,218075,218076,218077,218078,218079,218080,218081,218082,218083,218084,218085,218087,218088,218089,218090,218092,218093,218094,218095,218096,218097,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218118,218119,218120,218121,218122,218123,218124,218126,218127,218128,218129,218130,227292,227294,227295,241633,252494,252495,252496,260128,261521,334998,348949,507160,518395,525519,526083,536150,536151,536152,553957,570963,761510,843826,843827,886853,908584,960652}'::integer[])) AND (cid = 12,859))
  • Rows Removed by Index Recheck: 6,904,381
  • Filter: (((sent_on)::date >= '2019-12-30'::date) AND ((sent_on)::date <= '2020-01-05'::date) AND ((system_email_type_id = 102) OR ((system_email_type_id = 62) AND (scheduled_email_id IS NOT NULL))))
  • Rows Removed by Filter: 1,052,155
  • Heap Blocks: exact=323,475 lossy=272,281
4. 42.743 2,360.869 ↓ 0.0 0 1 / 3

BitmapAnd (cost=161,602.07..161,602.07 rows=82,176 width=0) (actual time=7,082.607..7,082.607 rows=0 loops=1)

5. 2,091.269 2,091.269 ↑ 1.5 3,182,981 1 / 3

Bitmap Index Scan on idx_system_emails_property_id (cost=0.00..66,526.39 rows=4,776,585 width=0) (actual time=6,273.806..6,273.806 rows=3,182,981 loops=1)

  • Index Cond: (property_id = ANY ('{218059,218060,218061,218062,218063,218064,218065,218066,218067,218068,218069,218070,218071,218072,218073,218074,218075,218076,218077,218078,218079,218080,218081,218082,218083,218084,218085,218087,218088,218089,218090,218092,218093,218094,218095,218096,218097,218098,218099,218100,218101,218102,218103,218104,218105,218106,218107,218108,218109,218110,218111,218112,218113,218114,218115,218116,218118,218119,218120,218121,218122,218123,218124,218126,218127,218128,218129,218130,227292,227294,227295,241633,252494,252495,252496,260128,261521,334998,348949,507160,518395,525519,526083,536150,536151,536152,553957,570963,761510,843826,843827,886853,908584,960652}'::integer[]))
6. 226.857 226.857 ↑ 2.1 3,234,219 1 / 3

Bitmap Index Scan on idx_system_emails_cid (cost=0.00..95,075.40 rows=6,839,311 width=0) (actual time=680.572..680.572 rows=3,234,219 loops=1)

  • Index Cond: (cid = 12,859)
7. 947.818 947.818 ↓ 47.0 47 914 / 3

Index Scan using idx_email_events_system_email_id on email_events ee (cost=0.57..4.62 rows=1 width=72) (actual time=0.821..3.111 rows=47 loops=914)

  • Index Cond: (system_email_id = se.id)
  • Filter: ((cid = 12,859) AND (cid = se.cid))