explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ami5

Settings
# exclusive inclusive rows x rows loops node
1. 3.356 68,311.002 ↑ 1.0 1 1

Aggregate (cost=190,392,413.71..190,392,413.72 rows=1 width=8) (actual time=68,311.000..68,311.002 rows=1 loops=1)

2. 1,036.741 68,307.646 ↑ 166.1 1,504 1

Seq Scan on version_bom_component vbc (cost=0.00..190,391,789.23 rows=249,792 width=16) (actual time=6,020.784..68,307.646 rows=1,504 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 496,799
3.          

SubPlan (for Seq Scan)

4. 1,065.956 67,270.905 ↓ 0.0 0 498,303

Nested Loop (cost=0.71..381.05 rows=1 width=0) (actual time=0.135..0.135 rows=0 loops=498,303)

5. 1,494.909 1,494.909 ↑ 1.0 1 498,303

Index Scan using version_bom_pkey on version_bom vb (cost=0.28..8.42 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=498,303)

  • Index Cond: (id = vbc.version_bom_id)
  • Filter: (project_id = ANY ('{39d77f77-921d-4162-8f8c-d23e5f6ac507,e918db1e-5ced-4b41-a66d-174e038d4f00,dba52322-92cf-4faf-b862-abc8c7acf1e9,22b44399-19d9-4429-aa16-abdcddd0b2cf,6148e4c3-8ec0-4095-b9c8-3f4ae4374563,e7144a71-0f3b-4780-8ec1-4597c55e79dd,3776fa6e-4a3a-46d7-98b3-4839683a814b,b518ce30-0c4b-4ad9-a89c-46c88fa4525a,f234ba08-7ecb-41c8-8530-bb25ba3d6106,ce05075a-bef5-4626-be92-6cfed51286e7,9decd56d44428,42bbbb65-2a62-4b63-a4b8-7340f509a636,1091a7d2-a808-4311-848d-ada7a44fdb26,a7a18def-e311-4d25-883b-e294c1967562,058fd299-bcbf-4201-813a-43cf13508629,a47508df-6664-49aa-a32a-6746ece961c5,96a5f936-6e97-4037-8bf4-f04d47749fd4,f8ac22ae-a507-4545-b5be-a1078d98354a,a8ae6cf7-b31c-4096-a622-e0e1929123af,951da7be-4298-4b3e-ad72-1fb1844e35a7,9cb06c7c-46ba-4756-930a-487558363646,9fc020ef-0820-43ce-95e3-a42dfaee6dce,50a54248-86fc-40e2-8ef4-a5d33af21316,89d7573a-90d4-4f6b-98e0-a62f45b6261e,bb03821a-0243-4c2f-8379-fa2e582ada3e,3bac5d96-17f9-4278-a75d-5aed3fd8a1ee,7b081106-afbd-427a-a459-e5a5f79adfef,7dac051b-705b-4173-8f3a-169b4712616d,2661e89e-0e97-4cfa-aff2-19010ca2c082,c5479ee3-36e5-496c-b7f1-d322a8813c34,4da6391f-0a34-48ba-b977-e2a7f54fe4e3,19f6fd32-8241-44dc-8799-6fdf9951e102,c0932169-241e-4590-88ef-7041ae5d24ca,e34c6485-062b-4da0-bec2-9be27197d8a4,d61a61b3-844a-4cde-9107-fbcaf65bd3f9,0951cf7a-a899-4c83-9959-2e3e43cdc6ce,bd3e4754-9d0f-4dae-8bb8-6f31d0e6c4f2,c623350a-8dcd-41e1-8659-b0337f5c4065,dc9f2484-6184-4e21-8d71-566c4299b06c,03e5224e-d8b9-4ea3-89be-8f56ff00ca01,45709117-a5fd-4e1a-afb7-e3eb89d7a451,f7734004-cbdf-4670-9892-41c7d74f4c9e,e16d9c50-e38e-4a5e-9ac1-e2ef2c9a4604,e6df3fd5-d425-4f7e-ac8c-25a366966fb6,0f10bd9b-791c-43ad-8f6c-0b6600b952e9,d3288846-aa07-43da-93a4-791a921bd077,41fecbfe-eac8-4d57-b1c0-d6fa4f88314e,3395002f-da22-42d6-9365-3156982fdd35,a3328479-842b-4056-8f39-7d53b70de038,25037111-2346-4f0d-a669-5d638471ef48,f37afffb-76cf-47f9-a094-944c64954f91,5b621221-afe6-492f-956f-3a48c7f1252c,d919f79d-1604-47b8-8a70-e21fbaba279b,7643bae8-6cc8-4831-9fc5-69f92a567242,84acdbfd-1159-43bd-9938-e11521061ae4,a84ece5f-b6d4-4e2d-87c9-a58959e4f537,649ae663-8c69-4ecf-a18f-f3f41a-a798-0b5880d2dae5,1f031a4d-5dad-4ffe-a5fe-a12b6819eb52,bb0aeb2e-a929-45bd-bb70-254dfe1bf412,bba7bdf1-83ec-425c-b8ce-91830622e601,d7031456-6f8d-4a27-827a-55de8d202cf7,aacfcbd6-3625-4f3b-ba93-d1da3047d186,95e61306-1e9c-49be-8d59-8481907400fe,8dda85c2-9862-404a-8291-e5cccdee1211,0e0ef8f6-4441-4bd7-ac10-7d2b5c6a22ab,02990079-ffda-4749-8d0a-6bcf5e8de4ae,c59057ca-6f0b-40e9-a9c3-22c7f6f566d2,ad4f66bf-45ef-47ef-a95a-9d029360d855,7c5f94e7-e936-4fbb-995f-4d82f3adebe5,88ab4508-6869-4372-b20b-5f9deb84140e,67f8372a-6145-4b9f-ac9b-1a9bd55be7e2,026115eb-4af1-484c-9f15-097bf5485aa0,8a20ec36-0ef6-4674-82a0-b02b4a28b081,781b194e-6d24-4b88-b0a9-f028b6325bfd,5f612061-83e3-44ae-8b46-567dafed4421,642513e7-9d0d-41a7-805e-5e88a81bdb1e,5f2dddde-3c8f-435c-9239-1e294205af8b,e515dcd5-e5fa-434a-b636-c77bd5a7bb24,00aeae3b-722b-40d0-8478-dd39a088bf66,698afd90-411d-4765-b0fc-5f2ede2a9d5b,e40d5901-a9dd-4a88-9f7d-778e70790a16,df0daac9-f8e7-4355-ab04-b1b556b8b8b9,66569424-a4d7-4c0e-9570-fccca467d5b6,d3e81dc2-2aa9-4ed9-9042-d28c09efd3bc,c9d30f3d-cc63-4404-aeb1-0bb316972dd5,5e771e89-ad28-4891-914c-8ea031f08990,84c0fd38-b237-496c-b57e-7308ead532cc,3ca030e6-7310-46c2-beb9-c892b0673516,beab55a0-626d-4fb0-b79a-ff2752ea6057,09a350ae-44b4-4db0-bfe1-442ba3837297,a22b80a8-4c75-446f-81f7-739304bb809e,0a0632e2-9ab3-42a5-9072-fb597060e762,cca27110-4ed4-4832-b147-c30b304a1bb1}'::uuid[]))
  • Rows Removed by Filter: 0
6. 64,710.040 64,710.040 ↓ 0.0 0 349,784

Index Scan using idx_version_bom_risk_warning_version_bom_component_id on version_bom_risk_warning vbrw (cost=0.43..372.62 rows=1 width=0) (actual time=0.185..0.185 rows=0 loops=349,784)

  • Index Cond: (vbc.id = version_bom_component_id)
  • Filter: ((NOT ignored) AND (priority > 0) AND (created_at > '2020-07-23 12:50:43.074+00'::timestamp with time zone) AND (category = 'VULNERABILITY'::text))
  • Rows Removed by Filter: 23
Planning time : 0.742 ms
Execution time : 68,311.073 ms