explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M6KW : test1

Settings
# exclusive inclusive rows x rows loops node
1. 624.432 666.723 ↓ 4.3 411,232 1

Nested Loop (cost=118.4..7,049.28 rows=95,416 width=4,219) (actual time=0.541..666.723 rows=411,232 loops=1)

2. 1.588 2.251 ↓ 3.2 3,080 1

Nested Loop (cost=118.4..150.69 rows=960 width=4,239) (actual time=0.25..2.251 rows=3,080 loops=1)

3. 0.033 0.033 ↑ 1.1 35 1

Seq Scan on users users (cost=0..10.4 rows=40 width=16) (actual time=0.003..0.033 rows=35 loops=1)

4. 0.300 0.630 ↓ 3.7 88 35

Materialize (cost=118.4..128.35 rows=24 width=4,223) (actual time=0.007..0.018 rows=88 loops=35)

5. 0.051 0.330 ↓ 3.7 88 1

Nested Loop (cost=118.4..128.23 rows=24 width=4,223) (actual time=0.241..0.33 rows=88 loops=1)

6. 0.015 0.015 ↓ 1.8 22 1

Seq Scan on project_types project_types (cost=0..1.12 rows=12 width=4) (actual time=0.007..0.015 rows=22 loops=1)

7. 0.007 0.264 ↓ 2.0 4 22

Materialize (cost=118.4..126.82 rows=2 width=4,219) (actual time=0.011..0.012 rows=4 loops=22)

8. 0.000 0.257 ↓ 2.0 4 1

Nested Loop (cost=118.4..126.81 rows=2 width=4,219) (actual time=0.231..0.257 rows=4 loops=1)

9. 0.047 0.253 ↓ 2.0 4 1

Hash Join (cost=118.25..126.15 rows=2 width=3,675) (actual time=0.229..0.253 rows=4 loops=1)

10. 0.043 0.043 ↑ 1.0 282 1

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

11. 0.005 0.163 ↓ 2.0 4 1

Hash (cost=118.23..118.23 rows=2 width=3,625) (actual time=0.163..0.163 rows=4 loops=1)

12. 0.012 0.158 ↓ 2.0 4 1

Hash Join (cost=61.42..118.23 rows=2 width=3,625) (actual time=0.155..0.158 rows=4 loops=1)

13. 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)

14. 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)

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.025 0.146 ↓ 4.0 4 1

Hash (cost=36.56..36.56 rows=1 width=3,531) (actual time=0.146..0.146 rows=4 loops=1)

18. 0.003 0.121 ↓ 4.0 4 1

Nested Loop (cost=13.55..36.56 rows=1 width=3,531) (actual time=0.054..0.121 rows=4 loops=1)

19. 0.004 0.114 ↓ 4.0 4 1

Nested Loop (cost=13.41..36.22 rows=1 width=1,913) (actual time=0.051..0.114 rows=4 loops=1)

20. 0.005 0.102 ↓ 4.0 4 1

Nested Loop (cost=13.26..29.38 rows=1 width=1,877) (actual time=0.048..0.102 rows=4 loops=1)

21. 0.017 0.097 ↓ 4.0 4 1

Nested Loop (cost=13.12..27.75 rows=1 width=1,185) (actual time=0.045..0.097 rows=4 loops=1)

22. 0.025 0.064 ↓ 4.0 4 1

Nested Loop (cost=13.12..26.01 rows=1 width=1,126) (actual time=0.033..0.064 rows=4 loops=1)

23. 0.009 0.009 ↓ 6.0 6 1

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

  • Filter: ((vault_type)::text = 'PROJECTS'::text)
24. 0.012 0.030 ↓ 1.3 4 6

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

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

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

  • Index Cond: (id = ANY ('{f666bdea-a3c8-4a0b-a66e-6c9ae9e09012,7ed0266c-63ce-4da6-a3c9-0a3fb9e4f685,aab84ef1-982a-4d9e-87a3-4f606ef0699b,ae90fb79-7e33-468f-a0aa-16d0b5830e05}'::uuid[]))
26. 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)

27. 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)
28. 0.008 0.008 ↑ 1.0 1 4

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

  • Index Cond: (project_id = projects.id)
29. 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)
30. 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)
31. 39.987 40.040 ↑ 1.0 284 3,080

Materialize (cost=0..15.26 rows=284 width=4) (actual time=0..0.013 rows=284 loops=3,080)

32. 0.053 0.053 ↑ 1.0 284 1

Seq Scan on project_members project_members (cost=0..13.84 rows=284 width=4) (actual time=0.008..0.053 rows=284 loops=1)

Planning time : 2.85 ms
Execution time : 681.987 ms