#	exclusive	inclusive	rows x	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 = 14,543)
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 = 14,543)
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 = 14,543))
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 = 14,543))
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)

Limit  (cost=33.71..248929.64 rows=21 width=182)
   InitPlan 1 (returns $1)
     ->  Limit  (cost=16.62..16.64 rows=1 width=12)
           ->  GroupAggregate  (cost=16.62..16.64 rows=1 width=12)
                 Group Key: u0.id
                 ->  Sort  (cost=16.62..16.63 rows=1 width=4)
                       Sort Key: u0.id
                       ->  Nested Loop  (cost=0.57..16.61 rows=1 width=4)
                             ->  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)
                                   Index Cond: (student_group_id = 14543)
                             ->  Index Only Scan using signup_field_option_pkey on signup_field_option u0  (cost=0.29..8.30 rows=1 width=4)
                                   Index Cond: (id = u1.signup_field_option_id)
   InitPlan 3 (returns $7)
     ->  Limit  (cost=16.62..16.64 rows=1 width=12)
           ->  GroupAggregate  (cost=16.62..16.64 rows=1 width=12)
                 Group Key: u0_2.id
                 ->  Sort  (cost=16.62..16.63 rows=1 width=4)
                       Sort Key: u0_2.id
                       ->  Nested Loop  (cost=0.57..16.61 rows=1 width=4)
                             ->  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)
                                   Index Cond: (student_group_id = 14543)
                             ->  Index Only Scan using signup_field_option_pkey on signup_field_option u0_2  (cost=0.29..8.30 rows=1 width=4)
                                   Index Cond: (id = u1_2.signup_field_option_id)
   ->  Index Scan using auth_user_26b2345e on auth_user  (cost=0.43..14352999.23 rows=1211 width=182)
         Index Cond: (organization_id = 465)
         Filter: ($7 = (SubPlan 4))
         SubPlan 2
           ->  Limit  (cost=58.04..58.06 rows=1 width=12)
                 ->  GroupAggregate  (cost=58.04..58.06 rows=1 width=12)
                       Group Key: u0_1.id
                       ->  Sort  (cost=58.04..58.04 rows=1 width=4)
                             Sort Key: u0_1.id
                             ->  Nested Loop  (cost=1.43..58.03 rows=1 width=4)
                                   ->  Nested Loop  (cost=1.14..57.71 rows=1 width=8)
                                         ->  Nested Loop  (cost=0.86..57.09 rows=2 width=4)
                                               ->  Index Scan using domain_membership_user_id on domain_membership u2  (cost=0.43..8.45 rows=1 width=4)
                                                     Index Cond: (user_id = auth_user.id)
                                               ->  Index Scan using signup_info_domain_membership_id on signup_info u1_1  (cost=0.43..48.54 rows=11 width=8)
                                                     Index Cond: (domain_membership_id = u2.id)
                                         ->  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)
                                               Index Cond: ((signup_field_option_id = u1_1.option_id) AND (student_group_id = 14543))
                                   ->  Index Only Scan using signup_field_option_pkey on signup_field_option u0_1  (cost=0.29..0.30 rows=1 width=4)
                                         Index Cond: (id = u1_1.option_id)
         SubPlan 4
           ->  Limit  (cost=58.04..58.06 rows=1 width=12)
                 ->  GroupAggregate  (cost=58.04..58.06 rows=1 width=12)
                       Group Key: u0_3.id
                       ->  Sort  (cost=58.04..58.04 rows=1 width=4)
                             Sort Key: u0_3.id
                             ->  Nested Loop  (cost=1.43..58.03 rows=1 width=4)
                                   ->  Nested Loop  (cost=1.14..57.71 rows=1 width=8)
                                         ->  Nested Loop  (cost=0.86..57.09 rows=2 width=4)
                                               ->  Index Scan using domain_membership_user_id on domain_membership u2_1  (cost=0.43..8.45 rows=1 width=4)
                                                     Index Cond: (user_id = auth_user.id)
                                               ->  Index Scan using signup_info_domain_membership_id on signup_info u1_3  (cost=0.43..48.54 rows=11 width=8)
                                                     Index Cond: (domain_membership_id = u2_1.id)
                                         ->  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)
                                               Index Cond: ((signup_field_option_id = u1_3.option_id) AND (student_group_id = 14543))
                                   ->  Index Only Scan using signup_field_option_pkey on signup_field_option u0_3  (cost=0.29..0.30 rows=1 width=4)
                                         Index Cond: (id = u1_3.option_id)

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	4	0.000 ms	0.0 %
Index Only Scan	6	0.000 ms	0.0 %
Index Scan	7	0.000 ms	0.0 %
Limit	5	0.000 ms	0.0 %
Nested Loop	8	0.000 ms	0.0 %
Sort	4	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
auth_user	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
domain_membership	2	0.000 ms	0.0 %
Index Scan	2	0.000 ms	0.0 %
signup_field_option	4	0.000 ms	0.0 %
Index Only Scan	4	0.000 ms	0.0 %
signup_info	2	0.000 ms	0.0 %
Index Scan	2	0.000 ms	0.0 %
student_group_signup_field_option_link	4	0.000 ms	0.0 %
Index Only Scan	2	0.000 ms	0.0 %
Index Scan	2	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 91Wu

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats