explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ctdL

Settings
# exclusive inclusive rows x rows loops node
1. 0.696 64.753 ↑ 1.8 197 1

Nested Loop Left Join (cost=5,719.49..18,316.67 rows=361 width=73) (actual time=33.956..64.753 rows=197 loops=1)

2.          

CTE hiddenbaseproductcte

3. 0.838 32.689 ↓ 1.5 303 1

Recursive Union (cost=795.52..4,923.41 rows=202 width=33) (actual time=0.440..32.689 rows=303 loops=1)

4. 0.412 16.633 ↓ 50.0 100 1

Nested Loop Left Join (cost=795.52..3,105.42 rows=2 width=33) (actual time=0.435..16.633 rows=100 loops=1)

5. 0.328 15.521 ↓ 50.0 100 1

Nested Loop (cost=795.10..3,104.25 rows=2 width=36) (actual time=0.408..15.521 rows=100 loops=1)

  • Join Filter: (mainarticl0__1.id = mainarticl0_1__1.id)
6. 0.283 3.993 ↓ 50.0 100 1

Nested Loop (cost=794.67..3,103.26 rows=2 width=68) (actual time=0.392..3.993 rows=100 loops=1)

7. 0.329 2.910 ↓ 11.1 100 1

Nested Loop (cost=794.25..3,098.05 rows=9 width=68) (actual time=0.383..2.910 rows=100 loops=1)

8. 0.315 2.081 ↑ 2.0 100 1

Nested Loop (cost=793.97..3,036.47 rows=200 width=48) (actual time=0.370..2.081 rows=100 loops=1)

9. 0.114 0.466 ↑ 2.0 100 1

Bitmap Heap Scan on main_article mainarticl0__1 (cost=793.55..1,390.47 rows=200 width=16) (actual time=0.359..0.466 rows=100 loops=1)

  • Recheck Cond: (id = ANY ('{d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043}'::uuid[]))
  • Heap Blocks: exact=4
10. 0.352 0.352 ↑ 2.0 100 1

Bitmap Index Scan on pk_main_article (cost=0.00..793.50 rows=200 width=0) (actual time=0.351..0.352 rows=100 loops=1)

  • Index Cond: (id = ANY ('{d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043}'::uuid[]))
11. 1.300 1.300 ↑ 1.0 1 100

Index Scan using pk_article_tree_node on article_tree_node mainarticl0_2__1 (cost=0.42..8.22 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=100)

  • Index Cond: (id = mainarticl0__1.id)
12. 0.500 0.500 ↑ 1.0 1 100

Index Scan using pk_base_product on base_product articletre1_1_ (cost=0.28..0.30 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (id = mainarticl0_2__1.parent_id)
13. 0.800 0.800 ↑ 1.0 1 100

Index Scan using pk_article_tree_node on article_tree_node articletre1_ (cost=0.42..0.57 rows=1 width=32) (actual time=0.007..0.008 rows=1 loops=100)

  • Index Cond: (id = mainarticl0_2__1.parent_id)
14. 11.200 11.200 ↑ 1.0 1 100

Index Only Scan using pk_selectable_article on selectable_article mainarticl0_1__1 (cost=0.42..0.48 rows=1 width=16) (actual time=0.112..0.112 rows=1 loops=100)

  • Index Cond: (id = mainarticl0_2__1.id)
  • Heap Fetches: 100
15. 0.700 0.700 ↑ 1.0 1 100

Index Only Scan using pk_article_tree_node on article_tree_node articletre2_ (cost=0.42..0.57 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=100)

  • Index Cond: (id = articletre1_.parent_id)
  • Heap Fetches: 100
16. 0.833 15.218 ↓ 1.8 35 7

Nested Loop Left Join (cost=1.50..181.39 rows=20 width=33) (actual time=0.136..2.174 rows=35 loops=7)

17. 0.826 13.405 ↓ 1.8 35 7

Nested Loop (cost=1.07..169.61 rows=20 width=36) (actual time=0.127..1.915 rows=35 loops=7)

  • Join Filter: (hiddenbase0_.parent_id = category1_1_.id)
18. 9.735 11.109 ↓ 1.8 35 7

Hash Join (cost=0.65..6.05 rows=20 width=52) (actual time=0.110..1.587 rows=35 loops=7)

  • Hash Cond: (category1_.id = hiddenbase0_.parent_id)
19. 0.912 0.912 ↑ 1.0 233 6

Seq Scan on category category1_ (cost=0.00..4.33 rows=233 width=20) (actual time=0.012..0.152 rows=233 loops=6)

20. 0.259 0.462 ↓ 1.8 35 7

Hash (cost=0.40..0.40 rows=20 width=32) (actual time=0.066..0.066 rows=35 loops=7)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
21. 0.203 0.203 ↓ 2.1 43 7

WorkTable Scan on hiddenbaseproductcte hiddenbase0_ (cost=0.00..0.40 rows=20 width=32) (actual time=0.002..0.029 rows=43 loops=7)

22. 1.470 1.470 ↑ 1.0 1 245

Index Scan using pk_article_tree_node on article_tree_node category1_1_ (cost=0.42..8.17 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=245)

  • Index Cond: (id = category1_.id)
23. 0.980 0.980 ↑ 1.0 1 245

Index Only Scan using pk_article_tree_node on article_tree_node articletre2__1 (cost=0.42..0.57 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=245)

  • Index Cond: (id = category1_1_.parent_id)
  • Heap Fetches: 187
24. 0.515 29.592 ↑ 1.8 197 1

Nested Loop Left Join (cost=795.65..11,541.61 rows=361 width=74) (actual time=0.832..29.592 rows=197 loops=1)

25. 0.436 18.979 ↑ 1.9 187 1

Nested Loop Left Join (cost=795.24..8,796.21 rows=361 width=53) (actual time=0.820..18.979 rows=187 loops=1)

26. 0.408 15.738 ↑ 1.9 187 1

Nested Loop Left Join (cost=794.82..8,605.52 rows=361 width=53) (actual time=0.816..15.738 rows=187 loops=1)

27. 0.411 13.330 ↑ 2.0 100 1

Nested Loop (cost=794.39..3,129.02 rows=200 width=37) (actual time=0.795..13.330 rows=100 loops=1)

  • Join Filter: (mainarticl0_.id = mainarticl0_2_.id)
28. 0.348 2.419 ↑ 2.0 100 1

Nested Loop (cost=793.97..3,012.47 rows=200 width=37) (actual time=0.774..2.419 rows=100 loops=1)

29. 0.140 0.871 ↑ 2.0 100 1

Bitmap Heap Scan on main_article mainarticl0_ (cost=793.55..1,390.47 rows=200 width=16) (actual time=0.753..0.871 rows=100 loops=1)

  • Recheck Cond: (id = ANY ('{d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043}'::uuid[]))
  • Heap Blocks: exact=4
30. 0.731 0.731 ↑ 2.0 100 1

Bitmap Index Scan on pk_main_article (cost=0.00..793.50 rows=200 width=0) (actual time=0.731..0.731 rows=100 loops=1)

  • Index Cond: (id = ANY ('{d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,d959c166-1713-4d08-bbfe-3f87dc2d9e12,e55c7bd9-d69b-461d-af9c-0efb56abcd5f,3a88ca40-d604-46ca-b738-8efe995e5c1c,4d934274-7979-4c51-bfa1-b7d6bf8b31ab,454c3e2b-5634-4526-8c4e-57572dabf698,3c752907-a569-47ce-8117-91d3df7530ee,5409e85f-5446-41fa-984d-614880791cc9,705b4d43-95f2-408f-a67c-cdfb6ce6439d,03f9012b-e2c2-4170-a5d1-43c6252986ef,cc5d10ec-4ecc-4d4b-968c-9f29a666446a,8964f496-0e06-4b20-8c87-a0e12c6908ac,c4d345ab-572f-49bb-9c44-6c836bccc46a,25b07cb3-fea2-4e54-9380-2b5c319388d2,2fd76004-7a35-4265-821a-34ca359ce8cb,c95c497c-7010-4700-bb16-c76e4df72abc,e9cf3dde-c230-45f2-9118-49d58bc46454,e36ec256-bcfb-4108-a603-d4f56e4a9039,4971f3a0-24ad-437f-a9d2-eed54cb9da9c,3ff07da6-ef33-4dfb-beb3-6938708affb5,afdabcdd-fda2-44f2-85d6-5a06f00ff138,09c080ec-8978-46c9-ade6-9346079b6732,cc1b93f4-8f63-4b18-ae43-47c9198b9f84,cfa7785f-875b-4dc6-b1a7-72a333e499d7,d8c6f471-e89d-4f10-a930-0c4c50971ad1,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043,dc86a621-731f-425d-b7f4-d05364879cf0,cabcb570-f12a-42ae-b7c4-a32d8bf24709,58f97e6b-3b36-4037-92c2-0d1764cb4aaf,c81d31b5-a7f2-4457-924a-e830c3b2c7be,ed035369-f6c5-4a8d-8507-6c88ca02c1a9,34762482-2245-4882-a15e-48205cc13bcd,2ca474ce-c657-4911-baee-ff72fcd3f202,118934d2-cfc1-497f-943a-55cf28251e14,1cfdcd28-9c94-44ed-a910-4dc8b070915b,c6dc1d99-3486-4981-b331-23a64aa744df,43717dd9-7c3e-48b0-9e42-df5a8e0d21bd,190aeb69-f2fa-4d1d-b8e9-64f80d5aec5b,800ed2e3-9880-4547-8876-1cfa3b5e7477,5e79f749-ecec-4cf6-aa01-96f1d2df071b,3b758009-b31b-4e8b-8e2c-a1fc02f147ef,ac94dc71-2196-412c-ba0a-ab9b0d5ebcd9,71d7b743-37fc-4455-8a61-10d91f7aece1,477e1295-acba-4c06-96b6-170ffaa08e07,aa663294-2e9a-4a93-b4ed-5d932b88fe68,59d164e3-ab5c-430d-aa41-c79138535c4e,026d2213-1abb-4d57-be14-8a1625238ac9,7c4f048e-4200-450b-ac8b-0849029cfdd7,80b2f973-390f-4af5-8f78-aa01d1a3eacb,65428370-edbd-4d3f-97fc-000f0bf5a23f,f6ce7013-3e28-41ce-a5c1-46908ee50813,ac47928d-39cf-4c85-a9d4-02d9e6119a87,ba1c8b90-e5da-469a-9528-7d615a386caa,bff50357-9038-49d1-b1ce-bf4a00528bf3,d7cb9953-b2bb-4421-97b3-9e8f3faef61a,e0e01d36-3fc2-4877-a1fe-9df9d253581a,ab829773-b058-40ff-b02b-e13a3cea5db3,b34eef50-7c03-4652-b2dc-bc737435c474,7dbb989b-528a-4152-bf58-e23eeb7868b2,a404f1ee-3ca8-4de5-8d83-e625a24dfdd2,d6300a84-46ee-4d32-ac11-73ec00378809,3d23635d-ef78-4cd8-8a74-c832e1fdc239,90674732-f093-46bb-923a-968cedc774a1,8ffd6ca4-5f12-4df6-a99c-c452375aa75e,20c5a001-36b7-4ba8-a917-30094bf5abb9,d25e0bfe-f22f-4a5e-92e7-a3019ef192a2,2f40aad2-07fb-4cdd-93de-d2075aa7a5d4,eeb4aed0-07dc-4500-9835-a40c77302101,97f4cd1d-4d63-4d72-a671-30348dcb89f7,e841faa3-12e6-4824-8e4a-a6df9665064f,7acb2c05-4ba1-4df1-9ff4-b10c28c7c221,19250819-26cf-4f18-9956-49bc1af392db,36c43c2d-00d8-4cdf-bbcb-543acffd324f,e13c6ca0-c64e-4b79-a68a-8f019f011292,13b82664-fb37-4f20-9f67-c6c7f5333577,c4132a9a-c3be-4241-bca2-9543bd2dcfd1,61341ac7-f509-4499-9ccc-ab1ec72baaf4,0837b103-84b2-4f13-9863-c8377c317a90,a39444f7-032b-4a32-a444-b3ac28ba9941,0ff52831-a1b9-4116-9eae-ebf1bb318121,f39a35bd-2218-4408-b9af-946bf8730d82,683aac43-cc70-4e70-aaf5-afb8b95c7ac2,6cb1324f-fade-47d2-a76d-a9f402951355,ed3daf88-1673-4b0c-8741-f48f43d67ba1,290981d2-2f2c-4b7a-8adb-fd1b7abe1940,3f9cbad0-b7d0-4862-ac12-b5a941565692,ef653059-5c80-4479-bbd0-122ac78f258e,3fb73197-9151-43d2-9229-3fbe8bddf6e3,cdbac1c0-9041-46c3-848b-7a51acc5dc8c,4149fe5a-86ed-4d03-85e2-78d115cd88a3,35f88fcf-54df-4df5-807e-2676529bc3e6,e6aa30e3-1b68-4b9b-8ee1-5a9591aea33b,3d7650a5-8588-4165-993d-2e25df29b52b,5a38fc4a-fb39-4ce7-9de4-5d4891fb88b6,f477787a-416b-4672-ad0c-010a82a11128,2783b6a0-36ba-44d2-9299-d24735b18ea9,e3118a08-3a6d-4db8-97e0-d8155ca29d9d,df58e89e-6d4b-4547-a9da-bd91936c785b,04525039-0304-417f-ad8e-20cefc333350,443eece0-3671-4282-80b1-e59a27f07ebf,f66ac95f-f6fb-4d06-a804-4bdd9617bd31,6204e0ad-c56f-4209-880b-358898455043}'::uuid[]))
31. 1.200 1.200 ↑ 1.0 1 100

Index Scan using pk_selectable_article on selectable_article mainarticl0_1_ (cost=0.42..8.10 rows=1 width=21) (actual time=0.012..0.012 rows=1 loops=100)

  • Index Cond: (id = mainarticl0_.id)
32. 10.500 10.500 ↑ 1.0 1 100

Index Scan using pk_article_tree_node on article_tree_node mainarticl0_2_ (cost=0.42..0.57 rows=1 width=32) (actual time=0.104..0.105 rows=1 loops=100)

  • Index Cond: (id = mainarticl0_1_.id)
33. 2.000 2.000 ↑ 3.0 2 100

Index Only Scan using ix_article_tree_node_parent_id on article_tree_node children1_ (cost=0.42..27.32 rows=6 width=32) (actual time=0.015..0.020 rows=2 loops=100)

  • Index Cond: (parent_id = mainarticl0_.id)
  • Heap Fetches: 179
34. 2.805 2.805 ↑ 1.0 1 187

Index Scan using pk_vendor_article on vendor_article children1_5_ (cost=0.42..0.52 rows=1 width=32) (actual time=0.014..0.015 rows=1 loops=187)

  • Index Cond: (children1_.id = id)
35. 10.098 10.098 ↑ 1.0 1 187

Index Scan using main_article_normalized_price_pkey on main_article_normalized_price normalized2_ (cost=0.42..7.60 rows=1 width=37) (actual time=0.053..0.054 rows=1 loops=187)

  • Index Cond: (mainarticl0_.id = main_article_id)
36. 1.379 1.379 ↑ 1.0 1 197

Index Only Scan using pk_article_tree_node on article_tree_node articletre3_ (cost=0.42..0.57 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=197)

  • Index Cond: (id = mainarticl0_2_.parent_id)
  • Heap Fetches: 197
37.          

SubPlan (for Nested Loop Left Join)

38. 0.000 0.000 ↓ 0.0 0

CTE Scan on hiddenbaseproductcte hiddenbase4_ (cost=0.00..4.54 rows=1 width=0) (never executed)

  • Filter: (hidden AND (article_tree_node_id = articletre3_.id))
39. 33.086 33.086 ↑ 101.0 1 1

CTE Scan on hiddenbaseproductcte hiddenbase4__1 (cost=0.00..4.04 rows=101 width=16) (actual time=0.528..33.086 rows=1 loops=1)

  • Filter: hidden
  • Rows Removed by Filter: 302
Planning time : 14.888 ms
Execution time : 65.413 ms