explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cu6O

Settings
# exclusive inclusive rows x rows loops node
1. 1.613 91.471 ↓ 16.0 16 1

Unique (cost=1,118.22..1,118.23 rows=1 width=258) (actual time=89.541..91.471 rows=16 loops=1)

  • = false))
2. 51.567 89.858 ↓ 6,637.0 6,637 1

Sort (cost=1,118.22..1,118.23 rows=1 width=258) (actual time=89.538..89.858 rows=6,637 loops=1)

  • Sort Key: events_to_attendees_dtimes_1.user_id DESC, events_to_attendees_1.attendee_id DESC, events_to_attendees_dtimes_1.end_dtime DESC
  • Sort Method: quicksort Memory: 3615kB
3. 6.362 38.291 ↓ 6,637.0 6,637 1

Hash Join (cost=82.10..1,118.21 rows=1 width=258) (actual time=25.260..38.291 rows=6,637 loops=1)

  • Hash Cond: (events_to_attendees_dtimes_1.eta_id = events_to_attendees_1.id)
4. 6.718 6.718 ↓ 3.0 18,255 1

Index Only Scan using events_to_attendees_dtimes_pkey on events_to_attendees_dtimes events_to_attendees_dtimes_1 (cost=0.56..1,020.88 rows=6,019 width=34) (actual time=0.025..6.718 rows=18,255 loops=1)

  • Index Cond: ((company_id = '\x4d48e1fb58f9e3d5fb5a6ba2'::bytea) AND (end_dtime <= '2020-03-20 17:30:11.707151+00'::timestamp with time zone))
  • Heap Fetches: 0
5. 4.583 25.211 ↓ 1,747.7 5,243 1

Hash (cost=81.50..81.50 rows=3 width=250) (actual time=25.210..25.211 rows=5,243 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2123kB
6. 20.628 20.628 ↓ 1,747.7 5,243 1

Index Scan using ix_company_id_attendee_id_is_all_day on events_to_attendees events_to_attendees_1 (cost=0.56..81.50 rows=3 width=250) (actual time=0.151..20.628 rows=5,243 loops=1)

  • Index Cond: ((company_id = '\x4d48e1fb58f9e3d5fb5a6ba2'::bytea) AND (attendee_id = ANY ('{sandeepk@innovaconsulting.com,jdonovan@itagroup.com,"michael corbin",michael@command-app.com,michael@command-app.com,mcorbin@innovaconsulting.com,michaeldcorbin@gmail.com,"ex:/o=exchangelabs/ou=exchange administrative group /cn=recipients/cn=9ee37a86e2034d2dbe6be77258509adb-ealejos","eric alejos","ex:/o=exchangelabs/ou=exchange administrative group /cn=recipients/cn=8174288006b544be9d4851c0b6071146-anshu",ealejos@innovaconsulting.com,"holly blaich","ex:/o=exchangelabs/ou=exchange administrative group /cn=recipients/cn=1403254aa3674e8fbd9b695fb0ec1ce1-bscott","ex:/o=exchangelabs/ou=exchange administrative group /cn=recipients/cn=8a95d236b1014e23b646c1802a552573-sandeep",anshus@innovaconsulting.com,sandeepk@innovaconsulting.com,sandeepk@innovaconsulting.com,andrew.victor@kintut.com,bscott@innovaconsulting.com,bruce.scott@analyticmarketinginnovations.com,bscott@innovaconsulting.com,bruces@innovaconsulting.com,bruce@regenesiscore.com,brucescott1111@gmail.com,bruce.scott@analyticmarketinginnovations.com,"bruce scott",5c476bffeb0f6223af4cf915,5c476c14eb0f6223af4d011d,5c476c1aeb0f6223af4d033a,5c476c62eb0f6256e94d01b7}'::text[])) AND (is_all_day
  • Filter: (is_all_day IS FALSE)
Planning time : 0.920 ms
Execution time : 93.971 ms