explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FuYn

Settings
# exclusive inclusive rows x rows loops node
1. 0.372 29.075 ↓ 26.0 26 1

Unique (cost=260.67..260.68 rows=1 width=260) (actual time=28.628..29.075 rows=26 loops=1)

  • time=0.006..0.007 rows=1 loops=1631)
2. 9.649 28.703 ↓ 1,648.0 1,648 1

Sort (cost=260.67..260.68 rows=1 width=260) (actual time=28.626..28.703 rows=1,648 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: 898kB
3. 11.944 19.054 ↓ 1,648.0 1,648 1

Nested Loop (cost=1.12..260.66 rows=1 width=260) (actual time=0.115..19.054 rows=1,648 loops=1)

  • -> Index Scan using ix_eta_id_end_dtime on events_to_attendees_dtimes events_to_attendees_dtimes_1 (cost=0.56..238.06 rows=1 width=34) (actual
4. 7.110 7.110 ↓ 1,631.0 1,631 1

Index Scan using ix_company_id_attendee_id_is_all_day on events_to_attendees events_to_attendees_1 (cost=0.56..22.59 rows=1 width=252) (actual time=0.088..7.110 rows=1,631 loops=1)

  • Index Cond: ((company_id = '\x552d6fe8fbbfe1235bc90dac'::bytea) AND (attendee_id = ANY ('{nick@triplestitch.com,sstrange@odysseygroup.com,stefani@triplestitch.com,stefani@triplestitch.com,5dcb6f9ddbf3ecd8239c503f,5d79d834b504f5dabd06f8d3,5d79d83bebad6415f5b6b34a,5d79da08b504f5dacb06f7e3}'::text[])) AND (is_all_day = false))
  • Filter: (is_all_day IS FALSE)
  • Index Cond: ((eta_id = events_to_attendees_1.id) AND (end_dtime <= '2020-03-25 17:11:47.910714+00'::timestamp with time zone))
  • Filter: (company_id = '\x552d6fe8fbbfe1235bc90dac'::bytea)
Planning time : 12.804 ms
Execution time : 29.508 ms