# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Result (cost=686,927.56..686,932.02 rows=17 width=217) (actual rows= loops=) |
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=686,927.56..686,927.60 rows=17 width=189) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Left Join (cost=495,066.09..686,927.21 rows=17 width=189) (actual rows= loops=)
|
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=11,896.01..195,678.47 rows=2 width=181) (actual rows= loops=)
|
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.84..966.48 rows=1 width=451) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.42..949.81 rows=1 width=33) (actual rows= loops=) |
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on dotlrn_classes dc (cost=0.00..2.17 rows=117 width=4) (actual rows= loops=) |
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using dtlrn_com_all_com_par_id_idx on dotlrn_communities_core dcc (cost=0.42..8.10 rows=1 width=29) (actual rows= loops=)
|
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using dlrn_atts_pk on dotlrn_learn_attributes dla (cost=0.42..7.96 rows=1 width=4) (actual rows= loops=)
|
||
10. |
SubPlan (forNested Loop) |
|||||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using site_nodes_object_id_idx on site_nodes site_nodes_1 (cost=0.43..8.70 rows=1 width=32) (actual rows= loops=)
|
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=11,895.17..194,292.99 rows=18,622 width=648) (actual rows= loops=) |
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on dotlrn_terms t (cost=0.00..1.24 rows=1 width=22) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=11,895.17..32,140.68 rows=18,622 width=82) (actual rows= loops=) |
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=11,894.75..21,674.96 rows=18,622 width=69) (actual rows= loops=)
|
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on dotlrn_communities_core dcc_1 (cost=0.00..8,787.75 rows=209,110 width=46) (actual rows= loops=)
|
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=11,603.51..11,603.51 rows=23,299 width=35) (actual rows= loops=) |
||
18. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=6,082.26..11,603.51 rows=23,299 width=35) (actual rows= loops=)
|
||
19. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on groups g (cost=0.00..4,411.10 rows=233,910 width=4) (actual rows= loops=) |
||
20. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=5,791.02..5,791.02 rows=23,299 width=31) (actual rows= loops=) |
||
21. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=1,657.24..5,791.02 rows=23,299 width=31) (actual rows= loops=)
|
||
22. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on dotlrn_learn_attributes dla_1 (cost=0.00..3,587.19 rows=208,219 width=4) (actual rows= loops=) |
||
23. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=1,364.75..1,364.75 rows=23,399 width=27) (actual rows= loops=) |
||
24. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using dotlrn_class_instances_term_id_idx on dotlrn_class_instances dci (cost=0.42..1,364.75 rows=23,399 width=27) (actual rows= loops=)
|
||
25. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using dotlrn_communities_pk on dotlrn_communities_core dcc2 (cost=0.42..0.56 rows=1 width=17) (actual rows= loops=)
|
||
26. |
SubPlan (forNested Loop) |
|||||
27. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using site_nodes_object_id_idx on site_nodes (cost=0.43..8.70 rows=1 width=32) (actual rows= loops=)
|
||
28. | 0.000 | 0.000 | ↓ 0.0 |
→
Materialize (cost=483,170.09..487,017.06 rows=153,879 width=12) (actual rows= loops=) |
||
29. | 0.000 | 0.000 | ↓ 0.0 |
→
Subquery Scan on members (cost=483,170.09..486,247.67 rows=153,879 width=12) (actual rows= loops=) |
||
30. | 0.000 | 0.000 | ↓ 0.0 |
→
HashAggregate (cost=483,170.09..484,708.88 rows=153,879 width=12) (actual rows= loops=)
|
||
31. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=270,598.72..462,818.30 rows=4,070,357 width=4) (actual rows= loops=)
|
||
32. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on acs_rels (cost=0.00..107,798.72 rows=5,828,972 width=8) (actual rows= loops=) |
||
33. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=219,719.26..219,719.26 rows=4,070,357 width=8) (actual rows= loops=) |
||
34. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=114,116.50..219,719.26 rows=4,070,357 width=8) (actual rows= loops=)
|
||
35. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on membership_rels (cost=0.00..92,758.98 rows=4,892,867 width=4) (actual rows= loops=)
|
||
36. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=62,999.00..62,999.00 rows=4,089,400 width=4) (actual rows= loops=) |
||
37. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on dotlrn_member_rels (cost=0.00..62,999.00 rows=4,089,400 width=4) (actual rows= loops=) |