explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T1ZP

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 132.800 ↑ 68.0 1 1

Unique (cost=24,862.42..24,862.76 rows=68 width=122) (actual time=132.799..132.800 rows=1 loops=1)

2. 0.029 132.798 ↑ 68.0 1 1

Sort (cost=24,862.42..24,862.59 rows=68 width=122) (actual time=132.798..132.798 rows=1 loops=1)

  • Sort Key: user_id DESC, dtime DESC
  • Sort Method: quicksort Memory: 25kB
3. 132.769 132.769 ↑ 68.0 1 1

Index Scan using ix_company_id_dtime_is_all_day_attendee_id on events_to_attendees_dtime (cost=0.56..24,860.35 rows=68 width=122) (actual time=125.453..132.769 rows=1 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (dtime <= '2020-03-20 18:55:01.680814+00'::timestamp with time zone) AND (is_all_day = false) AND (attendee_id = 'bhorowitz@homesmart.house'::text))
  • Filter: (is_all_day IS FALSE)
Planning time : 0.300 ms
Execution time : 132.846 ms