explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IT7J

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

Nested Loop (cost=0.29..4,290.55 rows=1 width=319) (actual rows= loops=)

  • Join Filter: (student_student.unit_id = unit_unit.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..4,280.36 rows=1 width=323) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..4,275.66 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (group_groupstudent.student_id = student_student.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on student_student (cost=0.00..2,938.00 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on group_groupstudent (cost=0.00..1,334.62 rows=243 width=8) (actual rows= loops=)

  • Filter: ((date_end <= '2019-05-15'::date) AND (date_end >= '2018-08-01'::date) AND (date_end <= '2019-08-31'::date))
6. 0.000 0.000 ↓ 0.0

Index Scan using alumni_alumni_group_student_id_key on alumni_alumni (cost=0.29..4.70 rows=1 width=319) (actual rows= loops=)

  • Index Cond: (group_student_id = group_groupstudent.id)
7. 0.000 0.000 ↓ 0.0

Seq Scan on unit_unit (cost=0.00..10.18 rows=1 width=4) (actual rows= loops=)

  • Filter: ((lft >= 6) AND (rght <= 9) AND (tree_id = 5))