explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 91Wu

Settings

Optimization(s) for this plan:

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

Limit (cost=33.71..248,929.64 rows=21 width=182) (actual rows= loops=)

2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0

Limit (cost=16.62..16.64 rows=1 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=16.62..16.64 rows=1 width=12) (actual rows= loops=)

  • Group Key: u0.id
5. 0.000 0.000 ↓ 0.0

Sort (cost=16.62..16.63 rows=1 width=4) (actual rows= loops=)

  • Sort Key: u0.id
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..16.61 rows=1 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using student_group_signup_field_option_link_student_group_id on student_group_signup_field_option_link u1 (cost=0.28..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (student_group_id = 14543)
8. 0.000 0.000 ↓ 0.0

Index Only Scan using signup_field_option_pkey on signup_field_option u0 (cost=0.29..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = u1.signup_field_option_id)
9. 0.000 0.000 ↓ 0.0

Limit (cost=16.62..16.64 rows=1 width=12) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=16.62..16.64 rows=1 width=12) (actual rows= loops=)

  • Group Key: u0_2.id
11. 0.000 0.000 ↓ 0.0

Sort (cost=16.62..16.63 rows=1 width=4) (actual rows= loops=)

  • Sort Key: u0_2.id
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..16.61 rows=1 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using student_group_signup_field_option_link_student_group_id on student_group_signup_field_option_link u1_2 (cost=0.28..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (student_group_id = 14543)
14. 0.000 0.000 ↓ 0.0

Index Only Scan using signup_field_option_pkey on signup_field_option u0_2 (cost=0.29..8.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = u1_2.signup_field_option_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using auth_user_26b2345e on auth_user (cost=0.43..14,352,999.23 rows=1,211 width=182) (actual rows= loops=)

  • Index Cond: (organization_id = 465)
  • Filter: ($7 = (SubPlan 4))
16.          

SubPlan (for Index Scan)

17. 0.000 0.000 ↓ 0.0

Limit (cost=58.04..58.06 rows=1 width=12) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=58.04..58.06 rows=1 width=12) (actual rows= loops=)

  • Group Key: u0_1.id
19. 0.000 0.000 ↓ 0.0

Sort (cost=58.04..58.04 rows=1 width=4) (actual rows= loops=)

  • Sort Key: u0_1.id
20. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.43..58.03 rows=1 width=4) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..57.71 rows=1 width=8) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..57.09 rows=2 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using domain_membership_user_id on domain_membership u2 (cost=0.43..8.45 rows=1 width=4) (actual rows= loops=)

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

Index Scan using signup_info_domain_membership_id on signup_info u1_1 (cost=0.43..48.54 rows=11 width=8) (actual rows= loops=)

  • Index Cond: (domain_membership_id = u2.id)
25. 0.000 0.000 ↓ 0.0

Index Only Scan using student_group_signup_field_op_signup_field_option_id_studen_key on student_group_signup_field_option_link u4 (cost=0.28..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((signup_field_option_id = u1_1.option_id) AND (student_group_id = 14543))
26. 0.000 0.000 ↓ 0.0

Index Only Scan using signup_field_option_pkey on signup_field_option u0_1 (cost=0.29..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = u1_1.option_id)
27. 0.000 0.000 ↓ 0.0

Limit (cost=58.04..58.06 rows=1 width=12) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=58.04..58.06 rows=1 width=12) (actual rows= loops=)

  • Group Key: u0_3.id
29. 0.000 0.000 ↓ 0.0

Sort (cost=58.04..58.04 rows=1 width=4) (actual rows= loops=)

  • Sort Key: u0_3.id
30. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.43..58.03 rows=1 width=4) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..57.71 rows=1 width=8) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..57.09 rows=2 width=4) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Index Scan using domain_membership_user_id on domain_membership u2_1 (cost=0.43..8.45 rows=1 width=4) (actual rows= loops=)

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

Index Scan using signup_info_domain_membership_id on signup_info u1_3 (cost=0.43..48.54 rows=11 width=8) (actual rows= loops=)

  • Index Cond: (domain_membership_id = u2_1.id)
35. 0.000 0.000 ↓ 0.0

Index Only Scan using student_group_signup_field_op_signup_field_option_id_studen_key on student_group_signup_field_option_link u4_1 (cost=0.28..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((signup_field_option_id = u1_3.option_id) AND (student_group_id = 14543))
36. 0.000 0.000 ↓ 0.0

Index Only Scan using signup_field_option_pkey on signup_field_option u0_3 (cost=0.29..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = u1_3.option_id)