# | 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 | |||
5. | 0.000 | 0.000 | ↓ 0.0 | |||
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=)
|
||
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=)
|
||
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 | |||
11. | 0.000 | 0.000 | ↓ 0.0 | |||
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=)
|
||
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=)
|
||
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=)
|
||
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 | |||
19. | 0.000 | 0.000 | ↓ 0.0 | |||
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=)
|
||
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=)
|
||
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=)
|
||
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=)
|
||
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 | |||
29. | 0.000 | 0.000 | ↓ 0.0 | |||
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=)
|
||
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=)
|
||
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=)
|
||
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=)
|