explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xevM : projects by id 100 ids

Settings
# exclusive inclusive rows x rows loops node
1. 0.221 1.576 ↑ 1.9 100 1

Hash Join (cost=195.45..268.74 rows=185 width=4,219) (actual time=1.181..1.576 rows=100 loops=1)

2. 0.060 1.355 ↑ 1.9 100 1

Hash Join (cost=182.3..251.21 rows=185 width=3,675) (actual time=1.157..1.355 rows=100 loops=1)

3. 0.053 1.279 ↑ 1.9 100 1

Hash Join (cost=171.4..237.77 rows=185 width=2,057) (actual time=1.13..1.279 rows=100 loops=1)

4. 0.053 1.137 ↑ 1.8 100 1

Hash Join (cost=154.01..217.61 rows=184 width=2,021) (actual time=1.031..1.137 rows=100 loops=1)

5. 0.035 0.976 ↑ 1.8 100 1

Hash Join (cost=143.66..204.74 rows=184 width=1,971) (actual time=0.913..0.976 rows=100 loops=1)

6. 0.047 0.936 ↑ 1.8 100 1

Hash Join (cost=131.19..189.74 rows=184 width=1,279) (actual time=0.901..0.936 rows=100 loops=1)

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

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

9. 0.000 0.000 ↓ 0.0 0 0

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

10. 0.000 0.000 ↓ 0.0 0 0

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

11. 0.064 0.889 ↓ 3.3 100 1

Hash (cost=105.96..105.96 rows=30 width=1,185) (actual time=0.889..0.889 rows=100 loops=1)

12. 0.028 0.825 ↓ 3.3 100 1

Hash Join (cost=85.2..105.96 rows=30 width=1,185) (actual time=0.542..0.825 rows=100 loops=1)

13. 0.161 0.780 ↓ 3.3 100 1

Nested Loop (cost=83.46..104.08 rows=30 width=1,126) (actual time=0.517..0.78 rows=100 loops=1)

14. 0.045 0.619 ↓ 3.3 100 1

Hash Join (cost=83.46..102.28 rows=30 width=426) (actual time=0.505..0.619 rows=100 loops=1)

15. 0.054 0.558 ↓ 1.1 100 1

Hash Join (cost=81.96..98.93 rows=87 width=446) (actual time=0.476..0.558 rows=100 loops=1)

16. 0.063 0.490 ↓ 1.1 100 1

Hash Join (cost=71.06..86.84 rows=87 width=434) (actual time=0.435..0.49 rows=100 loops=1)

17. 0.044 0.044 ↓ 1.0 285 1

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

18. 0.068 0.383 ↓ 1.1 100 1

Hash (cost=69.97..69.97 rows=87 width=426) (actual time=0.383..0.383 rows=100 loops=1)

19. 0.315 0.315 ↓ 1.1 100 1

Seq Scan on projects projects (cost=0..69.97 rows=87 width=426) (actual time=0.055..0.315 rows=100 loops=1)

  • Filter: (((parent_type)::text = 'PROJECTS'::text) AND (state = ANY ('{CREATING,READY,MARKED_FOR_DELETION}'::project_states[])) AND (id = ANY ('{61018300-1795-443b-a7d2-0657da7a5f8a,40708c31-f262-401a-8960-832695ab99e7,ef8dd358-418f-4fad-9ef6-9ff2ea02f2c2,880f6c79-94f9-475c-89b1-62211b38191f,a283c886-0a5e-4beb-9da2-f153d2ef63a6,7633061a-074a-4a60-9f92-0328c23b3234,309360a0-954a-4c61-8ff6-286c605e57e3,8228d0e0-a218-4300-a302-d7881707cfb9,3f04e2a5-8998-427f-bf26-e817ad8d9897,f383ea38-cf63-48fb-82e3-322922741531,77ee58bd-4b00-492c-ab8a-eb80ea095269,e351aff2-ffe7-4189-bb0d-aa8a76796593,18653227-5a98-4c1c-9828-aa1b3e277d26,094bc61c-b18a-40cd-9426-a57ec4241d3a,5105122e-6df9-4f94-9abc-c1da142b3239,fb71f737-6c5e-4efc-98bd-e19620ec1b80,3fc68a24-a0bc-416d-98d5-0702b80d514a,d9784bbb-0da3-40a1-9236-1f58b6d84451,96b6a057-14db-4916-8c4c-91fc104e2a9c,7b3e4d21-ecfd-4bd9-bd64-3b0ddb4b2248,d1b7448e-cf4c-4ec6-ae58-8d7c9f69416e,60854591-3cfc-4178-88f1-78efd1ae9344,a4c8215b-bb31-4188-a82d-0647a4fd2bb4,96c62f2f-8249-4245-b19c-a2066ae7d8c9,c858e542-3a44-48c7-b1e0-f455303b6c9d,1ef94bad-9a24-4942-8b99-05c5cd70d929,aa580b5e-7ae6-4045-bd91-a3d17af0acc7,3164f45b-f93c-44b1-998e-c886cde1fe62,95088865-5674-4102-89c9-1943737ee4d5,65e94682-7828-421a-ac3a-c5ebeb148ed8,d981b173-8b8c-4b79-998f-9dd548dc1941,63267c76-af05-402c-85a8-f051b6b3ccfb,f0624d94-73fe-469b-8095-e026fe65b949,1df89877-77de-4f34-90bb-f6909b1b4b49,fb155a20-f0f9-4537-af00-bccf1e054125,795c2766-f44a-402c-9387-5da841806b64,67c4940d-9ea3-4eee-8c86-bf0583fe52c0,1e356aa9-a46e-48a5-b99f-d16d156659ca,2cd4e906-1221-4f68-b57b-8164597027eb,51ba3351-23d8-41a8-a109-812c09b0b7c4,18d325d0-c8c9-44d2-a131-550a2fadf143,d5542902-501e-4324-b6eb-1b013cc9ab77,aa489798-37ea-419f-975c-435cb1de8ada,e9e2e65d-7cb0-43c0-836a-7412bb5bb677,a4640469-a101-4ae2-9b87-56fa840df719,390ce57b-e107-46aa-8670-7fedc51f0af0,14c07775-aa01-4355-8167-bd99bc5bf3e3,e581ee85-3650-4afd-9ab9-c8bf33747a03,eb72c3a6-0056-4ae8-85a5-59d482fb2dfe,3131706b-5f07-472d-a348-4c78b8811db0,3b3b82c5-e701-4c4e-b84a-6a343fd47bc9,fae4e29f-6e3d-4b45-a3ef-8f405d32905a,0f699093-e5a2-43b8-b2fa-02484edff061,49b4d7af-3248-4b04-8ff0-7b87c2d5de01,41adee4c-7a25-4644-b463-c9baa9282787,daac1654-6be0-43c6-9dd6-00c269f6f671,aeb941e2-f1c8-46fc-938d-f5e81c12948c,03040d44-be94-4159-8037-9f2046d1e680,588a3571-c1fd-4bb8-bc7f-e8565bb6003a,c46ca21f-b2cb-4ffc-9548-930b3d0a4ccb,cf162a65-a64a-447d-bf94-93c1457d8ca8,cf048e7d-c4fe-4707-b317-ede9dc9216e3,ed47db83-b76f-418c-9810-50bc31e4ff54,08b97cf9-59e5-47fe-9b97-748cd9673d60,f2e57d6a-fa7a-4d88-8730-34560d5308cd,d0419f2a-0d6f-4c62-b3b3-cccf8f7f1749,f1835346-5515-4eb6-b233-b02affe781df,a832f206-838c-461b-8a1e-052d1dbdeae4,2edfed4f-7a4d-45dd-8d4a-f604c490a752,0f1bbe56-7896-4788-be92-97a98fc16e7d,f38b475f-5e8d-473d-8b02-95813c7a165b,102151d1-8271-45e7-8b0d-eae2d55b8eaf,ef726ac9-6086-47f6-88ae-7f5e8f786eb4,375d0ce9-ecd9-40d0-b30b-2c1af8a6eb9e,6bd11025-8334-4057-b349-aeda4a790c48,ef69874c-ab64-473e-a81e-22b56e3bcb90,012ce76c-11bc-4b95-a1d8-03191d5430b8,8687bae4-4c05-4fcd-b743-5c8ffd37165c,c5262aa8-6b36-42e5-80be-17b699bb51f2,d462c0c4-64ae-44b8-9b7f-cddbafe4605f,37296259-b22b-481f-ba1b-e0fdd04022b1,34b34f27-811d-4986-aa05-c169b148f2db,d503b5f3-4c05-4c47-bdb5-a43e6eaee860,c47494b2-03a1-4306-9506-bbcc90806e1f,fa7f3aa1-54cb-4c65-8b34-d5bc6cea0f97,cc535990-6dde-4137-bfc7-9fae2cf7d647,4245e874-28a5-43f0-8cfd-6b5776e78ae8,16a76960-447e-4a5a-89da-401b69a23185,6a3e8379-c1a6-4a62-84a5-b2e90d929f98,40d20dda-6568-4834-8436-c4e7b179817a,f372e0fb-3498-44d3-858e-3012b4b896c4,3e6edaab-a423-4e75-9f4b-4b4614941a4b,441069f9-1c1a-4dbf-9586-ac48f625784e,d2e0a18e-111e-40c2-afb3-4563b2e0baf6,2215f637-4976-434a-a553-ea89bb9b91f1,6a491cad-6f22-44e7-83c6-c83dadb2c277,f666bdea-a3c8-4a0b-a66e-6c9ae9e09012,7ed0266c-63ce-4da6-a3c9-0a3fb9e4f685,aab84ef1-982a-4d9e-87a3-4f606ef0699b,ae90fb79-7e33-468f-a0aa-16d0b5830e05}'::uuid[])))
20. 0.007 0.014 ↑ 1.1 35 1

Hash (cost=10.4..10.4 rows=40 width=20) (actual time=0.014..0.014 rows=35 loops=1)

21. 0.007 0.007 ↑ 1.1 35 1

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

22. 0.007 0.016 ↑ 1.0 22 1

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

23. 0.009 0.009 ↑ 1.0 22 1

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

24. 0.000 0.000 ↓ 6.0 6 100

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

25. 0.009 0.009 ↓ 6.0 6 1

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

  • Filter: ((vault_type)::text = 'PROJECTS'::text)
26. 0.006 0.017 ↓ 1.1 35 1

Hash (cost=1.33..1.33 rows=33 width=59) (actual time=0.017..0.017 rows=35 loops=1)

27. 0.011 0.011 ↓ 1.1 35 1

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

28. 0.002 0.005 ↑ 27.5 4 1

Hash (cost=11.1..11.1 rows=110 width=692) (actual time=0.005..0.005 rows=4 loops=1)

29. 0.003 0.003 ↑ 27.5 4 1

Seq Scan on attributes attributes_1 (cost=0..11.1 rows=110 width=692) (actual time=0.002..0.003 rows=4 loops=1)

30. 0.063 0.108 ↓ 1.0 283 1

Hash (cost=6.82..6.82 rows=282 width=50) (actual time=0.108..0.108 rows=283 loops=1)

31. 0.045 0.045 ↓ 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.045 rows=283 loops=1)

32. 0.037 0.089 ↓ 1.0 285 1

Hash (cost=13.84..13.84 rows=284 width=36) (actual time=0.089..0.089 rows=285 loops=1)

33. 0.052 0.052 ↓ 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.052 rows=285 loops=1)

34. 0.013 0.016 ↑ 1.1 35 1

Hash (cost=10.4..10.4 rows=40 width=1,618) (actual time=0.016..0.016 rows=35 loops=1)

35. 0.003 0.003 ↑ 1.1 35 1

Seq Scan on users users_1 (cost=0..10.4 rows=40 width=1,618) (actual time=0.001..0.003 rows=35 loops=1)

36. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=11.4..11.4 rows=140 width=544) (actual time=0..0 rows=0 loops=1)

37. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on membership_request membership_request_1 (cost=0..11.4 rows=140 width=544) (actual time=0..0 rows=0 loops=1)

Planning time : 2.849 ms
Execution time : 1.881 ms