# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Unique (cost=24,181.73..24,189.60 rows=225 width=122) (actual rows= loops=) |
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=24,181.73..24,182.29 rows=225 width=122) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=11,914.67..24,172.94 rows=225 width=122) (actual rows= loops=)
|
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on auth_user (cost=0.00..1,567.70 rows=16,124 width=20) (actual rows= loops=)
|
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=11,907.00..11,907.00 rows=614 width=100) (actual rows= loops=) |
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on user_profile_userprofile (cost=8,513.77..11,907.00 rows=614 width=100) (actual rows= loops=)
|
||
7. |
SubPlan (for Seq Scan) |
|||||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=15.49..3,040.91 rows=359 width=4) (actual rows= loops=) |
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on user_profile_friendship u1 (cost=15.20..946.52 rows=359 width=4) (actual rows= loops=)
|
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on friendship_person1_id_idx (cost=0.00..15.11 rows=359 width=0) (actual rows= loops=)
|
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using user_profile_userprofile_pkey on user_profile_userprofile u0 (cost=0.29..5.83 rows=1 width=4) (actual rows= loops=)
|
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=15.90..3,432.34 rows=411 width=4) (actual rows= loops=) |
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on user_profile_invitations u1_1 (cost=15.61..1,093.96 rows=411 width=4) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on invitations_top_id_idx (cost=0.00..15.50 rows=411 width=0) (actual rows= loops=)
|
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using user_profile_userprofile_pkey on user_profile_userprofile u0_1 (cost=0.29..5.69 rows=1 width=4) (actual rows= loops=)
|
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.71..387.17 rows=38 width=4) (actual rows= loops=) |
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using invitations_fromp_id_idx on user_profile_invitations u1_2 (cost=0.42..107.49 rows=38 width=4) (actual rows= loops=)
|
||
18. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using user_profile_userprofile_pkey on user_profile_userprofile u0_2 (cost=0.29..7.36 rows=1 width=4) (actual rows= loops=)
|
||
19. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.71..221.85 rows=29 width=4) (actual rows= loops=) |
||
20. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using user_profile_userprofile_blac_from_userprofile_id_to_userpr_key on user_profile_userprofile_blacklist u1_3 (cost=0.42..8.93 rows=29 width=4) (actual rows= loops=)
|
||
21. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using user_profile_userprofile_pkey on user_profile_userprofile u0_3 (cost=0.29..7.34 rows=1 width=4) (actual rows= loops=)
|
||
22. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=0.71..1,429.03 rows=151 width=4) (actual rows= loops=) |
||
23. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using user_profile_userprofile_blacklist_to_userprofile_id on user_profile_userprofile_blacklist u1_4 (cost=0.42..426.60 rows=151 width=4) (actual rows= loops=)
|
||
24. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Only Scan using user_profile_userprofile_pkey on user_profile_userprofile u0_4 (cost=0.29..6.64 rows=1 width=4) (actual rows= loops=)
|
||
25. |
SubPlan (for Hash Join) |
|||||
26. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on user_profile_invitations (cost=9.69..13.70 rows=1 width=0) (actual rows= loops=)
|
||
27. | 0.000 | 0.000 | ↓ 0.0 |
→
BitmapAnd (cost=9.69..9.69 rows=1 width=0) (actual rows= loops=) |
||
28. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on invitations_fromp_id_idx (cost=0.00..4.71 rows=38 width=0) (actual rows= loops=)
|
||
29. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on invitations_top_id_idx (cost=0.00..4.73 rows=41 width=0) (actual rows= loops=)
|
||
30. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using invitations_fromp_id_idx on user_profile_invitations user_profile_invitations_1 (cost=0.42..107.49 rows=38 width=4) (actual rows= loops=)
|
||
31. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=) |
||
32. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using devices_person_id_idx on user_profile_devices (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)
|
||
33. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=0.29..8.31 rows=1 width=1) (actual rows= loops=) |
||
34. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using user_profile_preferences_83a0eb3f on user_profile_preferences (cost=0.29..8.31 rows=1 width=1) (actual rows= loops=)
|
||
35. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=) |
||
36. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using devices_person_id_idx on user_profile_devices user_profile_devices_1 (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)
|
||
37. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=) |
||
38. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using devices_person_id_idx on user_profile_devices user_profile_devices_2 (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)
|