explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SMPA : user slug

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.289 ↓ 4.0 4 1

Nested Loop (cost=47.04..134.15 rows=1 width=4,219) (actual time=0.171..0.289 rows=4 loops=1)

2. 0.001 0.259 ↓ 4.0 4 1

Nested Loop (cost=46.89..125.96 rows=1 width=4,169) (actual time=0.152..0.259 rows=4 loops=1)

3. 0.004 0.254 ↓ 4.0 4 1

Nested Loop (cost=46.75..125.63 rows=1 width=3,625) (actual time=0.15..0.254 rows=4 loops=1)

4. 0.003 0.246 ↓ 4.0 4 1

Nested Loop (cost=46.61..125.29 rows=1 width=2,007) (actual time=0.148..0.246 rows=4 loops=1)

5. 0.004 0.239 ↓ 4.0 4 1

Nested Loop (cost=46.46..117.12 rows=1 width=1,971) (actual time=0.146..0.239 rows=4 loops=1)

6. 0.029 0.235 ↓ 4.0 4 1

Nested Loop (cost=46.32..115.49 rows=1 width=1,279) (actual time=0.143..0.235 rows=4 loops=1)

7. 0.015 0.190 ↓ 4.0 4 1

Nested Loop (cost=46.32..113.75 rows=1 width=1,220) (actual time=0.127..0.19 rows=4 loops=1)

8. 0.006 0.155 ↓ 4.0 4 1

Nested Loop (cost=46.32..112.59 rows=1 width=520) (actual time=0.116..0.155 rows=4 loops=1)

9. 0.001 0.141 ↓ 4.0 4 1

Nested Loop (cost=46.18..112.24 rows=1 width=532) (actual time=0.107..0.141 rows=4 loops=1)

10. 0.015 0.128 ↓ 4.0 4 1

Nested Loop (cost=46.03..104.07 rows=1 width=524) (actual time=0.102..0.128 rows=4 loops=1)

11. 0.011 0.011 ↓ 6.0 6 1

Seq Scan on project_types project_types (cost=0..1.15 rows=1 width=184) (actual time=0.008..0.011 rows=6 loops=1)

  • Filter: ((vault_type)::text = 'PROJECTS'::text)
12. 0.035 0.102 ↑ 1.5 4 6

Hash Join (cost=46.03..102.84 rows=6 width=520) (actual time=0.014..0.017 rows=4 loops=6)

13. 0.000 0.000 ↓ 0.0 0 6

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

14. 0.000 0.000 ↓ 0.0 0 6

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

15. 0.000 0.000 ↓ 0.0 0 0

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

16. 0.000 0.000 ↓ 0.0 0 0

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

17. 0.012 0.067 ↓ 4.0 4 1

Hash (cost=21.17..21.17 rows=1 width=426) (actual time=0.067..0.067 rows=4 loops=1)

18. 0.013 0.055 ↓ 4.0 4 1

Bitmap Heap Scan on projects projects (cost=17.14..21.17 rows=1 width=426) (actual time=0.05..0.055 rows=4 loops=1)

  • Filter: (state = ANY ('{CREATING,READY,MARKED_FOR_DELETION}'::project_states[]))
  • Heap Blocks: exact=3
19. 0.002 0.042 ↓ 0.0 0 1

BitmapOr (cost=17.14..17.14 rows=1 width=0) (actual time=0.042..0.042 rows=0 loops=1)

20. 0.008 0.008 ↑ 1.0 1 1

Bitmap Index Scan on uq_projects_owner_canonical (cost=0..4.29 rows=1 width=0) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (((owner_canonical)::text = 'nemanja_boskovic'::text) AND ((slug)::text = 'step-various-visit'::text) AND ((parent_type)::text = 'PROJECTS'::text))
21. 0.003 0.003 ↑ 1.0 1 1

Bitmap Index Scan on uq_projects_owner_canonical (cost=0..4.29 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (((owner_canonical)::text = 'nemanja_boskovic'::text) AND ((slug)::text = 'believe-population'::text) AND ((parent_type)::text = 'PROJECTS'::text))
22. 0.007 0.007 ↑ 1.0 1 1

Bitmap Index Scan on uq_projects_owner_canonical (cost=0..4.29 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (((owner_canonical)::text = 'nemanja_boskovic'::text) AND ((slug)::text = 'check-need-thousand'::text) AND ((parent_type)::text = 'PROJECTS'::text))
23. 0.022 0.022 ↑ 1.0 1 1

Bitmap Index Scan on uq_projects_owner_canonical (cost=0..4.29 rows=1 width=0) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (((owner_canonical)::text = 'nemanja_boskovic'::text) AND ((slug)::text = 'only-mother-effort'::text) AND ((parent_type)::text = 'PROJECTS'::text))
24. 0.012 0.012 ↑ 1.0 1 4

Index Scan using ix_project_members_project_id on project_members project_members (cost=0.15..8.17 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=4)

  • Index Cond: (project_id = projects.id)
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.001..0.002 rows=1 loops=4)

  • Index Cond: (id = project_members.user_id)
26. 0.020 0.020 ↓ 6.0 6 4

Seq Scan on project_types project_types_1 (cost=0..1.15 rows=1 width=700) (actual time=0.003..0.005 rows=6 loops=4)

  • Filter: ((vault_type)::text = 'PROJECTS'::text)
27. 0.016 0.016 ↓ 1.1 35 4

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

28. 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)
29. 0.004 0.004 ↑ 1.0 1 4

Index Scan using ix_project_members_project_id on project_members project_members_1 (cost=0.15..8.17 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=4)

  • Index Cond: (projects.id = project_id)
30. 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)
31. 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)
32. 0.008 0.008 ↑ 1.0 1 4

Index Scan using ix_project_settings_project_id on project_settings project_settings_1 (cost=0.15..8.17 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (projects.id = project_id)
Planning time : 2.257 ms
Execution time : 0.577 ms