explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FQ9u : Fixed by id

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.410 ↑ 1.5 4 1

Nested Loop (cost=136.03..164.74 rows=6 width=4,219) (actual time=0.374..0.41 rows=4 loops=1)

2. 0.002 0.388 ↑ 1.5 4 1

Nested Loop (cost=135.88..162.69 rows=6 width=3,675) (actual time=0.359..0.388 rows=4 loops=1)

3. 0.002 0.382 ↑ 1.5 4 1

Nested Loop (cost=135.74..160.67 rows=6 width=2,057) (actual time=0.358..0.382 rows=4 loops=1)

4. 0.031 0.380 ↑ 1.5 4 1

Hash Join (cost=135.6..150.92 rows=6 width=1,365) (actual time=0.356..0.38 rows=4 loops=1)

5. 0.041 0.041 ↓ 1.0 285 1

Seq Scan on project_members project_members_1 (cost=0..13.84 rows=284 width=36) (actual time=0.002..0.041 rows=285 loops=1)

6. 0.008 0.308 ↑ 1.5 4 1

Hash (cost=135.53..135.53 rows=6 width=1,329) (actual time=0.308..0.308 rows=4 loops=1)

7. 0.030 0.300 ↑ 1.5 4 1

Hash Join (cost=127.24..135.53 rows=6 width=1,329) (actual time=0.279..0.3 rows=4 loops=1)

8. 0.048 0.048 ↓ 1.0 283 1

Seq Scan on project_settings project_settings_1 (cost=0..6.82 rows=282 width=50) (actual time=0.003..0.048 rows=283 loops=1)

9. 0.006 0.222 ↑ 1.5 4 1

Hash (cost=127.16..127.16 rows=6 width=1,279) (actual time=0.222..0.222 rows=4 loops=1)

10. 0.012 0.216 ↑ 1.5 4 1

Nested Loop (cost=68.97..127.16 rows=6 width=1,279) (actual time=0.203..0.216 rows=4 loops=1)

11. 0.009 0.192 ↑ 1.5 4 1

Hash Join (cost=68.97..125.78 rows=6 width=579) (actual time=0.191..0.192 rows=4 loops=1)

12. 0.000 0.000 ↓ 0.0 0 1

Hash Join (cost=24.85..75.22 rows=1,700 width=110) (actual time=0..0 rows=0 loops=1)

13. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on project_tags project_tags_1 (cost=0..27 rows=1,700 width=20) (actual time=0..0 rows=0 loops=1)

14. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=16.6..16.6 rows=660 width=94) (never executed)

15. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on tags tags_1 (cost=0..16.6 rows=660 width=94) (never executed)

16. 0.006 0.183 ↓ 4.0 4 1

Hash (cost=44.11..44.11 rows=1 width=485) (actual time=0.183..0.183 rows=4 loops=1)

17. 0.019 0.177 ↓ 4.0 4 1

Nested Loop (cost=26.5..44.11 rows=1 width=485) (actual time=0.124..0.177 rows=4 loops=1)

18. 0.013 0.146 ↓ 4.0 4 1

Hash Join (cost=26.5..42.36 rows=1 width=426) (actual time=0.113..0.146 rows=4 loops=1)

19. 0.003 0.115 ↓ 1.3 4 1

Nested Loop (cost=25..40.81 rows=3 width=446) (actual time=0.084..0.115 rows=4 loops=1)

20. 0.028 0.104 ↓ 1.3 4 1

Hash Join (cost=24.86..39.8 rows=3 width=434) (actual time=0.078..0.104 rows=4 loops=1)

21. 0.050 0.050 ↓ 1.0 285 1

Seq Scan on project_members project_members (cost=0..13.84 rows=284 width=24) (actual time=0.004..0.05 rows=285 loops=1)

22. 0.007 0.026 ↓ 1.3 4 1

Hash (cost=24.82..24.82 rows=3 width=426) (actual time=0.026..0.026 rows=4 loops=1)

23. 0.011 0.019 ↓ 1.3 4 1

Bitmap Heap Scan on projects projects (cost=13.12..24.82 rows=3 width=426) (actual time=0.017..0.019 rows=4 loops=1)

  • Filter: (((parent_type)::text = 'PROJECTS'::text) AND (state = ANY ('{CREATING,READY,MARKED_FOR_DELETION}'::project_states[])))
  • Heap Blocks: exact=1
24. 0.008 0.008 ↑ 1.0 4 1

Bitmap Index Scan on ix_projects_id (cost=0..13.12 rows=4 width=0) (actual time=0.008..0.008 rows=4 loops=1)

  • Index Cond: (id = ANY ('{2215f637-4976-434a-a553-ea89bb9b91f1,6a491cad-6f22-44e7-83c6-c83dadb2c277,f666bdea-a3c8-4a0b-a66e-6c9ae9e09012,7ed0266c-63ce-4da6-a3c9-0a3fb9e4f685}'::uuid[]))
25. 0.008 0.008 ↑ 1.0 1 4

Index Scan using pk_users on users users (cost=0.14..0.33 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (id = project_members.user_id)
26. 0.012 0.018 ↑ 1.0 22 1

Hash (cost=1.22..1.22 rows=22 width=94) (actual time=0.018..0.018 rows=22 loops=1)

27. 0.006 0.006 ↑ 1.0 22 1

Seq Scan on project_types project_types (cost=0..1.22 rows=22 width=94) (actual time=0.006..0.006 rows=22 loops=1)

28. 0.012 0.012 ↓ 1.1 35 4

Seq Scan on project_attributes project_attributes_1 (cost=0..1.33 rows=33 width=59) (actual time=0.001..0.003 rows=35 loops=4)

29. 0.005 0.012 ↓ 6.0 6 4

Materialize (cost=0..1.28 rows=1 width=700) (actual time=0.002..0.003 rows=6 loops=4)

30. 0.007 0.007 ↓ 6.0 6 1

Seq Scan on project_types project_types_1 (cost=0..1.27 rows=1 width=700) (actual time=0.004..0.007 rows=6 loops=1)

  • Filter: ((vault_type)::text = 'PROJECTS'::text)
31. 0.000 0.000 ↓ 0.0 0 4

Index Scan using pk_attributes on attributes attributes_1 (cost=0.14..1.61 rows=1 width=692) (actual time=0..0 rows=0 loops=4)

  • Index Cond: (id = project_attributes_1.attribute_id)
32. 0.004 0.004 ↑ 1.0 1 4

Index Scan using pk_users on users users_1 (cost=0.14..0.33 rows=1 width=1,618) (actual time=0.001..0.001 rows=1 loops=4)

  • Index Cond: (id = project_members_1.user_id)
33. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk_membership_request on membership_request membership_request_1 (cost=0.14..0.32 rows=1 width=544) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (project_members_1.id = member_id)
Planning time : 2.679 ms
Execution time : 0.731 ms