explain.depesz.com

PostgreSQL's explain analyze made readable

Result: igGo

Settings
# exclusive inclusive rows x rows loops node
1. 1.332 13,338.235 ↓ 16.0 16 1

Unique (cost=814.97..814.98 rows=1 width=258) (actual time=13,336.632..13,338.235 rows=16 loops=1)

2. 48.330 13,336.903 ↓ 6,637.0 6,637 1

Sort (cost=814.97..814.97 rows=1 width=258) (actual time=13,336.630..13,336.903 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. 12.776 13,288.573 ↓ 6,637.0 6,637 1

Nested Loop (cost=1.12..814.96 rows=1 width=258) (actual time=0.746..13,288.573 rows=6,637 loops=1)

4. 16.250 16.250 ↓ 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.116..16.250 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 = false))
  • Filter: (is_all_day IS FALSE)
5. 13,259.547 13,259.547 ↓ 0.0 1 5,243

Index Only Scan using events_to_attendees_dtimes_pkey on events_to_attendees_dtimes events_to_attendees_dtimes_1 (cost=0.56..244.48 rows=1width=34) (cost=0..0 rows=0 width=0) (actual time=1.113..2.529 rows=1 loops=5,243)

  • Index Cond: ((company_id = '\x4d48e1fb58f9e3d5fb5a6ba2'::bytea) AND (end_dtime <= '2020-03-20 17:30:11.707151+00'::timestamp with time zone) AND (eta_id = events_to_attendees_1.id))
  • Heap Fetches: 0
Planning time : 0.693 ms
Execution time : 13,340.949 ms