explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uL4U

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.97..639.74 rows=1 width=123) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..19,164.04 rows=30 width=123) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.70..19,155.37 rows=30 width=123) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..18,808.95 rows=442 width=28) (actual rows= loops=)

  • Join Filter: (courseappo1_.id = courseappo0_.fk_course_appointment_group)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..2,235.23 rows=19 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on benefit coursebase2_ (cost=0.00..1,909.91 rows=212 width=8) (actual rows= loops=)

  • Filter: (visible_in_public_api AND ((studio_access_type = 'MAIN_STUDIO'::text) OR (studio_access_type = 'ALL_STUDIOS'::text) OR (studio_access_type = 'RESTRICTED_STUDIOS'::text)))
7. 0.000 0.000 ↓ 0.0

Index Scan using course_appointment_group_fk_benefit_idx on course_appointment_group courseappo1_ (cost=0.28..1.41 rows=12 width=16) (actual rows= loops=)

  • Index Cond: (fk_benefit = coursebase2_.id)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1,219.28 rows=54,352 width=28) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on course_appointment courseappo0_ (cost=0.00..947.52 rows=54,352 width=28) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using appointment_pkey on appointment courseappo0_1_ (cost=0.42..0.78 rows=1 width=103) (actual rows= loops=)

  • Index Cond: (id = courseappo0_.id)
  • Filter: ((start_date_time > '2020-10-16 10:33:31.859943+00'::timestamp with time zone) AND (fk_organization_unit = '1210593380'::bigint))
11. 0.000 0.000 ↓ 0.0

Materialize (cost=0.27..8.30 rows=1 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using organization_unit_pkey on organization_unit organizati3_ (cost=0.27..8.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = '1210593380'::bigint)
  • Filter: ((NOT archived) AND (NOT disabled))