explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 94Ef

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.082 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.40..66.92 rows=1 width=617) (actual time=0.074..0.082 rows=0 loops=1)

  • Join Filter: (appointments_busy.employee_group_id = accounts_employeegroup.id)
  • Filter: (((accounts_profile.management_company_id = 18,855) AND accounts_profile.is_active) OR (accounts_employeegroup.company_id = 18,855))
2. 0.016 0.065 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.12..58.58 rows=2 width=622) (actual time=0.057..0.065 rows=0 loops=1)

3. 0.017 0.049 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.71..54.88 rows=2 width=621) (actual time=0.041..0.049 rows=0 loops=1)

4. 0.032 0.032 ↓ 0.0 0 1

Index Scan using appointments_busy_employee_group_id_604f8593 on appointments_busy (cost=0.42..46.27 rows=2 width=617) (actual time=0.024..0.032 rows=0 loops=1)

  • Index Cond: (employee_group_id = 1,187)
  • Filter: (("end" > '2020-07-14 00:00:00'::timestamp without time zone) AND (start < '2020-07-14 23:59:59.999999'::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using auth_user_pkey on auth_user (cost=0.29..4.30 rows=1 width=4) (never executed)

  • Index Cond: (id = appointments_busy.user_id)
  • Heap Fetches: 0
6. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_profile_user_id_key on accounts_profile (cost=0.41..1.85 rows=1 width=9) (never executed)

  • Index Cond: (auth_user.id = user_id)
7. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.28..8.30 rows=1 width=8) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_employeegroup_pkey on accounts_employeegroup (cost=0.28..8.29 rows=1 width=8) (never executed)

  • Index Cond: (id = 1,187)
Planning time : 1.332 ms
Execution time : 0.231 ms