explain.depesz.com

PostgreSQL's explain analyze made readable

Result: imrL

Settings
# exclusive inclusive rows x rows loops node
1. 86.035 110,341.766 ↑ 1.4 342 1

Nested Loop Left Join (cost=322,150.11..29,266,300.23 rows=491 width=335) (actual time=592.479..110,341.766 rows=342 loops=1)

  • Join Filter: (articletre4_.origin_article_tree_node_id = mainarticl0_.id)
  • Rows Removed by Join Filter: 99522
2.          

CTE articletreestartnodecte

3. 0.544 0.544 ↓ 1.0 491 1

Values Scan on "*VALUES*" (cost=0.00..6.14 rows=489 width=16) (actual time=0.007..0.544 rows=491 loops=1)

  • Filter: (column1 IS NOT NULL)
4.          

CTE articletreenodecte

5. 12.351 152.565 ↑ 28.4 1,738 1

Recursive Union (cost=0.42..322,140.58 rows=49,389 width=89) (actual time=0.777..152.565 rows=1,738 loops=1)

6. 1.157 109.374 ↑ 1.0 489 1

Nested Loop (cost=0.42..4,003.05 rows=489 width=89) (actual time=0.754..109.374 rows=489 loops=1)

7. 1.179 1.179 ↓ 1.0 491 1

CTE Scan on articletreestartnodecte articletre0_ (cost=0.00..9.78 rows=489 width=16) (actual time=0.008..1.179 rows=491 loops=1)

8. 107.038 107.038 ↑ 1.0 1 491

Index Scan using pk_article_tree_node on article_tree_node articletre1_ (cost=0.42..8.16 rows=1 width=69) (actual time=0.215..0.218 rows=1 loops=491)

  • Index Cond: (id = articletre0_.article_tree_node_id)
9. 12.326 30.840 ↑ 20.3 241 6

Nested Loop (cost=0.42..31,714.97 rows=4,890 width=84) (actual time=0.104..5.140 rows=241 loops=6)

10. 1.134 1.134 ↑ 16.9 290 6

WorkTable Scan on articletreenodecte articletre0__1 (cost=0.00..97.80 rows=4,890 width=68) (actual time=0.001..0.189 rows=290 loops=6)

11. 17.380 17.380 ↑ 1.0 1 1,738

Index Scan using pk_article_tree_node on article_tree_node articletre1__1 (cost=0.42..6.45 rows=1 width=69) (actual time=0.008..0.010 rows=1 loops=1,738)

  • Index Cond: (id = articletre0__1.parent_id)
12. 2.448 2,184.757 ↑ 1.4 342 1

Nested Loop Left Join (cost=3.39..44,805.19 rows=491 width=241) (actual time=4.878..2,184.757 rows=342 loops=1)

13. 2.259 2,176.837 ↑ 1.4 342 1

Nested Loop Left Join (cost=2.96..44,527.40 rows=491 width=188) (actual time=4.540..2,176.837 rows=342 loops=1)

14. 2.350 2,026.774 ↑ 1.4 339 1

Nested Loop Left Join (cost=2.54..41,300.90 rows=491 width=167) (actual time=4.278..2,026.774 rows=339 loops=1)

15. 2.273 1,754.919 ↑ 1.4 339 1

Nested Loop Left Join (cost=2.12..41,064.80 rows=491 width=151) (actual time=1.854..1,754.919 rows=339 loops=1)

16. 1.678 1,362.796 ↑ 1.4 339 1

Nested Loop Left Join (cost=1.70..40,822.62 rows=491 width=148) (actual time=0.985..1,362.796 rows=339 loops=1)

17. 2.739 1,093.938 ↑ 1.7 292 1

Nested Loop (cost=1.27..8,095.26 rows=491 width=128) (actual time=0.700..1,093.938 rows=292 loops=1)

  • Join Filter: (mainarticl0_.id = mainarticl0_2_.id)
18. 2.709 1,083.315 ↑ 1.7 292 1

Nested Loop (cost=0.85..7,816.00 rows=491 width=33) (actual time=0.670..1,083.315 rows=292 loops=1)

19. 822.186 822.186 ↑ 1.7 292 1

Index Only Scan using pk_main_article on main_article mainarticl0_ (cost=0.42..3,865.83 rows=491 width=16) (actual time=0.383..822.186 rows=292 loops=1)

  • Index Cond: (id = ANY ('{83fee25b-4605-447c-a418-02f3a73bbea7,83fee25b-4605-447c-a418-02f3a73bbea7,826f2427-d47e-4e57-8b34-5ca0a359d6dd,826f2427-d47e-4e57-8b34-5ca0a359d6dd,7ac8e44d-053d-4ba1-882c-4c8155b6f840,7ac8e44d-053d-4ba1-882c-4c8155b6f840,77935ff1-5bab-4b79-b495-9f17fe1cf1b1,77935ff1-5bab-4b79-b495-9f17fe1cf1b1,766ef05c-fedc-4adb-b4c7-c89b65576e1a,734ecfef-5a94-40c8-a9e0-544255c40241,72903bfe-5d16-4a84-919b-22cf07cf4f49,72903bfe-5d16-4a84-919b-22cf07cf4f49,71c7555b-fa77-478f-86eb-5571a84c0bdc,71c7555b-fa77-478f-86eb-5571a84c0bdc,6f78a4c9-fadd-49f9-a640-028ff1202dd2,6f78a4c9-fadd-49f9-a640-028ff1202dd2,6a7d35de-80f1-40e5-96fe-ce48310e1acd,6a7d35de-80f1-40e5-96fe-ce48310e1acd,6864eeb0-7dd4-4a37-b78a-d316350c886c,616284d7-678c-41f6-a93d-bed15d7228c7,605c0c38-6eb1-4ca3-943c-3eefd6eac449,605c0c38-6eb1-4ca3-943c-3eefd6eac449,5f538030-ffca-4680-bc22-17ca4535ca70,5f538030-ffca-4680-bc22-17ca4535ca70,5dcf3b86-2bd4-4f10-8c31-dcbc77de76de,5dcf3b86-2bd4-4f10-8c31-dcbc77de76de,5d310571-a5c9-4a58-8452-d8d8bd42c635,5d310571-a5c9-4a58-8452-d8d8bd42c635,5942ba94-d443-47dd-b3cd-036c5cde803b,57c3c9ed-db67-4572-b1a3-743015848801,57c3c9ed-db67-4572-b1a3-743015848801,5720e984-ca94-4cea-953a-f85bd58c067d,5720e984-ca94-4cea-953a-f85bd58c067d,5490d8ca-f3c0-4af4-9230-b2aba18b3e6a,5490d8ca-f3c0-4af4-9230-b2aba18b3e6a,541fbbdf-daa8-4433-83c8-78f7082e4af2,541fbbdf-daa8-4433-83c8-78f7082e4af2,52cbeb54-41e6-4258-b5d0-84c4dd7d6f1a,5187a11f-46e8-41a2-9ff7-349d5b381fd0,50965720-ca0c-4a43-8351-85d68b8af099,50965720-ca0c-4a43-8351-85d68b8af099,46d21383-9d78-4c36-b8c7-f985fd6828a6,46d21383-9d78-4c36-b8c7-f985fd6828a6,464ed6d5-589d-4614-8a3f-203d35e522b5,464ed6d5-589d-4614-8a3f-203d35e522b5,4281e29f-c9e6-4d8d-bd47-95f51b0913df,4281e29f-c9e6-4d8d-bd47-95f51b0913df,3bbebac7-19a1-4556-8835-adad630b9852,3a96bad1-59d8-43b9-9d4c-9a48947a5b9b,35b1f36a-7a79-4351-a57c-5b7570c5a37e,35b1f36a-7a79-4351-a57c-5b7570c5a37e,35676ac1-73ef-49e5-955c-b3cced886aa2,35676ac1-73ef-49e5-955c-b3cced886aa2,3529b1a8-0e52-40fb-afcc-5c5658274808,3529b1a8-0e52-40fb-afcc-5c5658274808,34bb5d67-e52b-433a-af25-4f73db461e47,34bb5d67-e52b-433a-af25-4f73db461e47,33c2d79c-127d-4274-adbc-85b81efcce67,337cb0c9-c6d0-40a8-8914-aca35b2f5260,3315f007-963a-421d-9f14-97537a292612,3315f007-963a-421d-9f14-97537a292612,32fcfedf-fc01-4972-ad5a-58b45471f244,32fcfedf-fc01-4972-ad5a-58b45471f244,32e1ef92-fa81-449a-8bae-1341ee960dde,32e1ef92-fa81-449a-8bae-1341ee960dde,311eda6c-8cb1-404b-ae53-8fe1c7e6dc1d,311eda6c-8cb1-404b-ae53-8fe1c7e6dc1d,2efc0824-20df-46a0-b9e4-7d7f1ffa4a5b,24e7457d-035e-408e-886b-c255b0b44409,24e7457d-035e-408e-886b-c255b0b44409,224fc0c0-3d33-4eee-9ea9-bc9ab0b3b2f5,224fc0c0-3d33-4eee-9ea9-bc9ab0b3b2f5,224619c7-019a-47ac-9ca3-7ad5e0d70ef4,224619c7-019a-47ac-9ca3-7ad5e0d70ef4,1fdff865-664a-4f91-aba0-534175dfe2ab,1cd04ef8-2dea-4e7c-8f02-825d06dab01c,1b91cc5a-a9eb-451c-a7f4-c2fd3f92cdd1,1b91cc5a-a9eb-451c-a7f4-c2fd3f92cdd1,17411640-76d6-11e9-9742-0a75340ab8c4,17411640-76d6-11e9-9742-0a75340ab8c4,173fd17c-76d6-11e9-9485-0a75340ab8c4,173fd17c-76d6-11e9-9485-0a75340ab8c4,173ec606-76d6-11e9-be6a-0a75340ab8c4,173ec606-76d6-11e9-be6a-0a75340ab8c4,173a88f2-76d6-11e9-b43c-0a75340ab8c4,17398d94-76d6-11e9-b0c6-0a75340ab8c4,17398d94-76d6-11e9-b0c6-0a75340ab8c4,1736e8fa-76d6-11e9-a575-0a75340ab8c4,1736e800-76d6-11e9-a56e-0a75340ab8c4,1736d590-76d6-11e9-a507-0a75340ab8c4,1736d590-76d6-11e9-a507-0a75340ab8c4,1736753c-76d6-11e9-a358-0a75340ab8c4,1736753c-76d6-11e9-a358-0a75340ab8c4,17366d9e-76d6-11e9-a33a-0a75340ab8c4,17366d9e-76d6-11e9-a33a-0a75340ab8c4,17342fa2-76d6-11e9-9e72-0a75340ab8c4,1733794a-76d6-11e9-9bc4-0a75340ab8c4,1733794a-76d6-11e9-9bc4-0a75340ab8c4,1732ba32-76d6-11e9-9910-0a75340ab8c4,1732ba32-76d6-11e9-9910-0a75340ab8c4,17324e8a-76d6-11e9-96dd-0a75340ab8c4,173182e8-76d6-11e9-92f1-0a75340ab8c4,173182e8-76d6-11e9-92f1-0a75340ab8c4,17315d7c-76d6-11e9-923f-0a75340ab8c4,17315d7c-76d6-11e9-923f-0a75340ab8c4,173106ec-76d6-11e9-90db-0a75340ab8c4,173106ec-76d6-11e9-90db-0a75340ab8c4,17310516-76d6-11e9-90d1-0a75340ab8c4,1730e7a2-76d6-11e9-906b-0a75340ab8c4,1730e784-76d6-11e9-906a-0a75340ab8c4,1730e784-76d6-11e9-906a-0a75340ab8c4,1730c740-76d6-11e9-8fff-0a75340ab8c4,1730c740-76d6-11e9-8fff-0a75340ab8c4,172e5118-76d6-11e9-8aa3-0a75340ab8c4,172e5118-76d6-11e9-8aa3-0a75340ab8c4,172d07ea-76d6-11e9-8630-0a75340ab8c4,172d07ea-76d6-11e9-8630-0a75340ab8c4,172c958a-76d6-11e9-843b-0a75340ab8c4,172c958a-76d6-11e9-843b-0a75340ab8c4,172c2cf8-76d6-11e9-bf43-0a75340ab8c4,172c2cf8-76d6-11e9-bf43-0a75340ab8c4,172b9fae-76d6-11e9-bcae-0a75340ab8c4,172b9fae-76d6-11e9-bcae-0a75340ab8c4,172b8d7a-76d6-11e9-bc56-0a75340ab8c4,172b0e86-76d6-11e9-ba76-0a75340ab8c4,172af766-76d6-11e9-ba33-0a75340ab8c4,172af766-76d6-11e9-ba33-0a75340ab8c4,172aefa0-76d6-11e9-ba0f-0a75340ab8c4,172aefa0-76d6-11e9-ba0f-0a75340ab8c4,172ae7b2-76d6-11e9-b9f3-0a75340ab8c4,172ae7b2-76d6-11e9-b9f3-0a75340ab8c4,172a9bc2-76d6-11e9-b919-0a75340ab8c4,172a9bc2-76d6-11e9-b919-0a75340ab8c4,1726003a-76d6-11e9-b5e4-0a75340ab8c4,1726003a-76d6-11e9-b5e4-0a75340ab8c4,17256f6c-76d6-11e9-b361-0a75340ab8c4,17256f6c-76d6-11e9-b361-0a75340ab8c4,17250b80-76d6-11e9-b146-0a75340ab8c4,17250b80-76d6-11e9-b146-0a75340ab8c4,1724ef06-76d6-11e9-b0ab-0a75340ab8c4,1724ec40-76d6-11e9-b09f-0a75340ab8c4,1724e434-76d6-11e9-b07e-0a75340ab8c4,1724e434-76d6-11e9-b07e-0a75340ab8c4,1724d3cc-76d6-11e9-b036-0a75340ab8c4,1724d3cc-76d6-11e9-b036-0a75340ab8c4,1724a58c-76d6-11e9-af79-0a75340ab8c4,1724a58c-76d6-11e9-af79-0a75340ab8c4,17225192-76d6-11e9-ab46-0a75340ab8c4,1721cbaa-76d6-11e9-a925-0a75340ab8c4,17213cbc-76d6-11e9-a6fd-0a75340ab8c4,17213cbc-76d6-11e9-a6fd-0a75340ab8c4,17212704-76d6-11e9-a6bc-0a75340ab8c4,17212704-76d6-11e9-a6bc-0a75340ab8c4,171f3124-76d6-11e9-b6f4-0a75340ab8c4,171f3124-76d6-11e9-b6f4-0a75340ab8c4,171f0f1e-76d6-11e9-b649-0a75340ab8c4,171f0f1e-76d6-11e9-b649-0a75340ab8c4,171edfda-76d6-11e9-b577-0a75340ab8c4,171eb9ec-76d6-11e9-b4d3-0a75340ab8c4,171c648a-76d6-11e9-afa0-0a75340ab8c4,171c648a-76d6-11e9-afa0-0a75340ab8c4,171c0f6c-76d6-11e9-ae5d-0a75340ab8c4,171c0f6c-76d6-11e9-ae5d-0a75340ab8c4,171b4410-76d6-11e9-ac07-0a75340ab8c4,171af5c8-76d6-11e9-aaa7-0a75340ab8c4,171a896c-76d6-11e9-a893-0a75340ab8c4,171a896c-76d6-11e9-a893-0a75340ab8c4,171a631a-76d6-11e9-a7c0-0a75340ab8c4,171a631a-76d6-11e9-a7c0-0a75340ab8c4,1719cd56-76d6-11e9-a4f7-0a75340ab8c4,1719cd56-76d6-11e9-a4f7-0a75340ab8c4,1716dfce-76d6-11e9-a088-0a75340ab8c4,1716dfce-76d6-11e9-a088-0a75340ab8c4,16fb2996-76d6-11e9-9483-0a75340ab8c4,16fb2964-76d6-11e9-9482-0a75340ab8c4,16f7abc2-76d6-11e9-9187-0a75340ab8c4,16f7abc2-76d6-11e9-9187-0a75340ab8c4,16f5c1d6-76d6-11e9-903b-0a75340ab8c4,16f5c1d6-76d6-11e9-903b-0a75340ab8c4,16f3e956-76d6-11e9-8f4a-0a75340ab8c4,16f3e956-76d6-11e9-8f4a-0a75340ab8c4,13e15212-838d-4513-91f8-7223a3727668,11ee5dcc-dea8-440b-9cd4-17e92b1bbcd2,1090b8e2-86e1-4f77-9bd2-7f66fdfe3b27,1090b8e2-86e1-4f77-9bd2-7f66fdfe3b27,0f5d46df-97bf-452c-a552-d28e75d6753c,0f5d46df-97bf-452c-a552-d28e75d6753c,0e9a805b-395d-406b-96df-f85ad2be5a57,0e9a805b-395d-406b-96df-f85ad2be5a57,0b86af29-0674-4880-b631-f6613d70e1d3,0b86af29-0674-4880-b631-f6613d70e1d3,0a00ddfb-bac1-40c5-951e-6e972221dce5,06b58312-1342-4621-8435-15c87c39931c,05a881e8-b569-422a-8121-87214d16be10,05a881e8-b569-422a-8121-87214d16be10,04c0e050-a56d-4ae5-b60e-8ee55267645d,04c0e050-a56d-4ae5-b60e-8ee55267645d,0002eab3-1dee-4cfe-a986-419a0f48c9f4,0002eab3-1dee-4cfe-a986-419a0f48c9f4,fe88fec4-d217-4e86-a441-323a9501c94c,fe88fec4-d217-4e86-a441-323a9501c94c,fc0c7131-2857-461f-96ba-f50ffcbcbc8a,f68ce139-b34b-4d3a-976b-910ef5406b29,f68ce139-b34b-4d3a-976b-910ef5406b29,e9d828b0-43fb-4b38-a2b6-c5e946fe99e4,e9d828b0-43fb-4b38-a2b6-c5e946fe99e4,e81afbba-9bc5-4689-bfcb-221d1f721f99,e81afbba-9bc5-4689-bfcb-221d1f721f99,dcfb4e5d-0f4c-4dbe-a976-a28d6cb898a6,d82be947-4cf0-4537-8930-f2b6caa758a6,d82be947-4cf0-4537-8930-f2b6caa758a6,d72b8138-ee49-4aab-95a6-9ae7b7dc893c,d72b8138-ee49-4aab-95a6-9ae7b7dc893c,d32b0be7-c308-4e02-8841-7eeb061392d6,d32b0be7-c308-4e02-8841-7eeb061392d6,d29f3efd-2838-4143-a2b4-31fb7672408a,d29f3efd-2838-4143-a2b4-31fb7672408a,cef0b417-1380-4068-bc86-7dcc11f06bc0,cde3f85e-631c-423c-803a-bfce773ed497,ccec7daf-5607-4083-b9ed-5c4621f29ac9,ccec7daf-5607-4083-b9ed-5c4621f29ac9,ccd6fea9-4410-44cf-bd84-12bdd7bc7f9b,ccd6fea9-4410-44cf-bd84-12bdd7bc7f9b,cb3fec8a-9aab-4a09-a971-be9ff972e192,cb3fec8a-9aab-4a09-a971-be9ff972e192,c8b5511a-4b14-46eb-91b9-52157ad0d3ea,c635b5b5-dad6-425e-8a8b-148155d83c84,c4d9f99a-6975-4c65-ae4a-6daeac5a2184,c4d9f99a-6975-4c65-ae4a-6daeac5a2184,c3e94b2d-ba26-4178-9d4f-69b87512496c,c3e94b2d-ba26-4178-9d4f-69b87512496c,c1dc5377-de8b-43c4-a638-1e00602642ab,c1dc5377-de8b-43c4-a638-1e00602642ab,c102247f-a832-4e57-9e2c-147f1d18a791,c102247f-a832-4e57-9e2c-147f1d18a791,be4fc517-570c-414c-9752-c8369b5434ba,bb699eb3-8d01-4d14-aadb-be26883b13b4,b9dadc7b-03cb-448d-9cfe-58d0742b2a15,b9dadc7b-03cb-448d-9cfe-58d0742b2a15,b9bd6d1d-208c-4f60-82b2-abd71e908c94,b9bd6d1d-208c-4f60-82b2-abd71e908c94,b997de7e-ecc0-42eb-b3ca-037524ae10b7,b997de7e-ecc0-42eb-b3ca-037524ae10b7,b67246e3-90db-485d-b4a1-fc4cddb19272,b64a9bde-76b8-409a-ada5-269bc0bdc5df,b2b29fbe-6a0c-4655-b814-5ad73b7f94c4,b2b29fbe-6a0c-4655-b814-5ad73b7f94c4,aea956c5-ef48-451b-a875-7066d74fafb9,aea956c5-ef48-451b-a875-7066d74fafb9,ac614210-7271-49d2-8f8c-97e869e26650,ac614210-7271-49d2-8f8c-97e869e26650,a83e79cc-985f-4442-8e0f-fc7eb77a4fba,a76ae414-fbc5-43d2-ae77-e5137ffba93d,98c933d9-ca0f-4265-8a13-3501493e4251,98c933d9-ca0f-4265-8a13-3501493e4251,932fe3b5-0a39-4499-be77-e5db981ad007,932fe3b5-0a39-4499-be77-e5db981ad007,927d7125-f85f-4e28-8dd5-e4505d71d6a2,927d7125-f85f-4e28-8dd5-e4505d71d6a2,86aa3adb-7625-45d2-8755-3a6205589468,86aa3adb-7625-45d2-8755-3a6205589468,84ddb2fa-1e84-407b-b9b8-ceb3243639cb,815cbe6c-b9d9-4a67-9e7e-30d793b1e439,80fe4fa0-40a0-431c-b086-bb9d343706fc,80fe4fa0-40a0-431c-b086-bb9d343706fc,807baa78-402f-4dba-90d1-3eaca865d3c4,807baa78-402f-4dba-90d1-3eaca865d3c4,7f582b2c-35f8-425d-8cba-c66efcf13d3a,7f582b2c-35f8-425d-8cba-c66efcf13d3a,7b38fe01-83e2-4425-9b85-d244266f586f,7b38fe01-83e2-4425-9b85-d244266f586f,79dada32-433f-4f74-99e6-5892603ffb7e,741c1346-7157-4922-954d-b879fa8ddc18,741c1346-7157-4922-954d-b879fa8ddc18,73ee5ecc-edb5-4980-8a7a-125ada5194f4,73ee5ecc-edb5-4980-8a7a-125ada5194f4,7375221b-609b-4d1a-8408-2e09cdfb643c,7375221b-609b-4d1a-8408-2e09cdfb643c,71057ac8-bd8d-4c75-aa39-d6eb1135ce6c,70a6b4b1-db3e-4217-9fab-5ea5f0416fda,683e578f-b55f-4a6a-abb5-ce19c3132b73,683e578f-b55f-4a6a-abb5-ce19c3132b73,64593098-380f-4e9c-a6ee-0c0e1a37629c,64593098-380f-4e9c-a6ee-0c0e1a37629c,5d84c1c7-4d89-4948-aba6-6b7f46ad3642,5d84c1c7-4d89-4948-aba6-6b7f46ad3642,5a115863-0142-4c51-bfb3-76e16bf79a9a,5a115863-0142-4c51-bfb3-76e16bf79a9a,58c12740-c2af-46a5-9598-a976d2f54380,564f724b-1527-4c18-a4af-51454722c9f7,5563fc80-c5e0-46e5-8392-0f14a1138d0f,5563fc80-c5e0-46e5-8392-0f14a1138d0f,51f07dab-e2f4-4669-ba05-bc9c3e8144fd,51f07dab-e2f4-4669-ba05-bc9c3e8144fd,5132f947-41be-4c8a-99e3-05796725b703,5132f947-41be-4c8a-99e3-05796725b703,415f3e66-0fbf-48c9-89a2-4e6d78325e31,415f3e66-0fbf-48c9-89a2-4e6d78325e31,3ea5f9a2-7146-40e8-ae25-116d8200a60b,3d99e0d4-67de-43b9-8a44-49f2cbaa53ee,381ad0ea-928c-4a69-8114-1a5363409aa9,381ad0ea-928c-4a69-8114-1a5363409aa9,2ca038e7-278b-4a5a-9c84-4921571f9785,2ca038e7-278b-4a5a-9c84-4921571f9785,20253d22-9596-48ce-962d-c7a36cc4111f,20253d22-9596-48ce-962d-c7a36cc4111f,1ebcfd83-4131-428b-99f4-20be35457778,1ebcfd83-4131-428b-99f4-20be35457778,19a3961b-80fe-476d-87b5-02b2a5d17275,179a35d3-62c8-40de-b0a2-713122be5e35,1754550c-76d6-11e9-a494-0a75340ab8c4,1754550c-76d6-11e9-a494-0a75340ab8c4,17543d10-76d6-11e9-a41a-0a75340ab8c4,17543d10-76d6-11e9-a41a-0a75340ab8c4,1754125e-76d6-11e9-a384-0a75340ab8c4,1754125e-76d6-11e9-a384-0a75340ab8c4,17540ffc-76d6-11e9-a373-0a75340ab8c4,17540ffc-76d6-11e9-a373-0a75340ab8c4,17540cdc-76d6-11e9-a367-0a75340ab8c4,1753fcf6-76d6-11e9-a316-0a75340ab8c4,1753dd84-76d6-11e9-a27b-0a75340ab8c4,1753dd84-76d6-11e9-a27b-0a75340ab8c4,1753b516-76d6-11e9-a1de-0a75340ab8c4,1753b516-76d6-11e9-a1de-0a75340ab8c4,17535710-76d6-11e9-a04f-0a75340ab8c4,17535710-76d6-11e9-a04f-0a75340ab8c4,175348ba-76d6-11e9-a002-0a75340ab8c4,17534478-76d6-11e9-9feb-0a75340ab8c4,1752e6d6-76d6-11e9-9e59-0a75340ab8c4,1752e6d6-76d6-11e9-9e59-0a75340ab8c4,1752c3f4-76d6-11e9-9dda-0a75340ab8c4,1752c3f4-76d6-11e9-9dda-0a75340ab8c4,1752bdd2-76d6-11e9-9db0-0a75340ab8c4,1752bdd2-76d6-11e9-9db0-0a75340ab8c4,17527cb4-76d6-11e9-9c9f-0a75340ab8c4,17527cb4-76d6-11e9-9c9f-0a75340ab8c4,173e0720-76d6-11e9-be49-0a75340ab8c4,173d0f6e-76d6-11e9-b9a3-0a75340ab8c4,17384cc2-76d6-11e9-ac91-0a75340ab8c4,17384cc2-76d6-11e9-ac91-0a75340ab8c4,1736d1f8-76d6-11e9-a4f4-0a75340ab8c4,1736d1f8-76d6-11e9-a4f4-0a75340ab8c4,17368978-76d6-11e9-a3ba-0a75340ab8c4,17368978-76d6-11e9-a3ba-0a75340ab8c4,17315a52-76d6-11e9-9233-0a75340ab8c4,17315a52-76d6-11e9-9233-0a75340ab8c4,172e2f6c-76d6-11e9-8a06-0a75340ab8c4,172b8794-76d6-11e9-bc37-0a75340ab8c4,172b5288-76d6-11e9-bb74-0a75340ab8c4,172b5288-76d6-11e9-bb74-0a75340ab8c4,17247c1a-76d6-11e9-aed0-0a75340ab8c4,17247c1a-76d6-11e9-aed0-0a75340ab8c4,17205554-76d6-11e9-bd18-0a75340ab8c4,17205554-76d6-11e9-bd18-0a75340ab8c4,171f9704-76d6-11e9-b924-0a75340ab8c4,171f7f3a-76d6-11e9-b8a0-0a75340ab8c4,171ec72a-76d6-11e9-b50c-0a75340ab8c4,171ec72a-76d6-11e9-b50c-0a75340ab8c4,171b84e8-76d6-11e9-acc4-0a75340ab8c4,171b84e8-76d6-11e9-acc4-0a75340ab8c4,16f7ac94-76d6-11e9-9188-0a75340ab8c4,1479c172-ed5d-403e-9c46-b11f642a6cb8,1326cd45-9fde-4144-a66f-e88df1cb9e1a,1326cd45-9fde-4144-a66f-e88df1cb9e1a,110df957-3976-4415-90c9-5b8033a76c78,110df957-3976-4415-90c9-5b8033a76c78,0fbd903d-d8cf-40c2-a2bc-c12f818ab49a,0fbd903d-d8cf-40c2-a2bc-c12f818ab49a,09d08da5-55d8-4e9d-a047-c8153b648715,09d08da5-55d8-4e9d-a047-c8153b648715,02ce3a3d-0e61-4e5a-a30e-672e92f7c35a,ad15d32c-a860-40de-b437-abe0ee6625ca,ad15d32c-a860-40de-b437-abe0ee6625ca,97260a68-ae3c-4e3d-b42e-28b2f43b9685,97260a68-ae3c-4e3d-b42e-28b2f43b9685,95342c00-6653-4a7f-b31f-498a17a8faee,95342c00-6653-4a7f-b31f-498a17a8faee,822fe50d-267b-4489-a91d-4332ad7a9b49,822fe50d-267b-4489-a91d-4332ad7a9b49,7853a415-90a1-42c1-982d-ac81ccaa0952,6cbe6bed-7977-4b07-ae64-f744383c9ac4,174c50dc-76d6-11e9-b76f-0a75340ab8c4,174c50dc-76d6-11e9-b76f-0a75340ab8c4,174c3250-76d6-11e9-b6dd-0a75340ab8c4,174c3250-76d6-11e9-b6dd-0a75340ab8c4,174acd8e-76d6-11e9-b0ee-0a75340ab8c4,174acd8e-76d6-11e9-b0ee-0a75340ab8c4,174a9b34-76d6-11e9-affc-0a75340ab8c4,174a9b34-76d6-11e9-affc-0a75340ab8c4,174a65d8-76d6-11e9-af24-0a75340ab8c4,1749bce6-76d6-11e9-ad9f-0a75340ab8c4,1737cf9a-76d6-11e9-aa8b-0a75340ab8c4,1737cf9a-76d6-11e9-aa8b-0a75340ab8c4,0882fba7-465b-4a98-b186-fad5d8e49593,0882fba7-465b-4a98-b186-fad5d8e49593,964d0b85-bac4-4ee3-98f4-e61c39bc8913,964d0b85-bac4-4ee3-98f4-e61c39bc8913,1eb6f568-355d-45a8-85c2-b833c5a90f10,1eb6f568-355d-45a8-85c2-b833c5a90f10,ddfef172-a335-40a7-b0e0-044528b6f594,171a7c88-76d6-11e9-a84b-0a75340ab8c4,17014aa6-76d6-11e9-9924-0a75340ab8c4,17014aa6-76d6-11e9-9924-0a75340ab8c4,fe293dc5-08a0-4917-8dd2-67c94fd63245,fe293dc5-08a0-4917-8dd2-67c94fd63245,fcfd5bc1-697a-4a8d-a8fc-6a7c2d8c8c98,fcfd5bc1-697a-4a8d-a8fc-6a7c2d8c8c98,f65ac862-58b1-4708-9fa6-ba43f143396e,f65ac862-58b1-4708-9fa6-ba43f143396e,ec8144a1-8599-4e18-88c1-02173ad9c3b7,e6b745f9-5dc5-4bab-91a0-24a2269d64f3,e6b745f9-5dc5-4bab-91a0-24a2269d64f3,deb9fd59-e6dc-4b31-a1a5-7bb1e8f11879,deb9fd59-e6dc-4b31-a1a5-7bb1e8f11879,deab2e63-fc16-4c1a-8c09-0d4057d0519d,deab2e63-fc16-4c1a-8c09-0d4057d0519d,ce2527ff-abe7-4a02-915a-fa7c56ab203f,ce2527ff-abe7-4a02-915a-fa7c56ab203f,cb2fc025-ad09-4498-8230-1ee6791bc263,cadef88e-aff1-417e-8826-c50a5ff34849,c3c36c0f-bd01-4120-b16d-49a66301512c,c3c36c0f-bd01-4120-b16d-49a66301512c,b60d2463-6240-4016-8bda-f26b1cf3f953,b60d2463-6240-4016-8bda-f26b1cf3f953,ab9ee9c9-3cd4-4b40-b7e4-85c5ed28c8d9,ab9ee9c9-3cd4-4b40-b7e4-85c5ed28c8d9,a819b327-ae87-42e7-af34-e25be01553d0,a819b327-ae87-42e7-af34-e25be01553d0,99ea9720-cc26-4966-8921-b5abf20458be,99ea9720-cc26-4966-8921-b5abf20458be,93928e72-3c5f-4a4b-9796-07ed4b087dcd,93928e72-3c5f-4a4b-9796-07ed4b087dcd,92d4b72d-cfb2-4b59-92b1-beb0d8c95045,8fabbfab-e50e-47c5-837e-087fa5a5393f,8c00a179-2d72-45d9-b9cf-2c2bad34fdf2,8c00a179-2d72-45d9-b9cf-2c2bad34fdf2,7ea3d969-31d6-4585-8432-7d3a658f03f6,7ea3d969-31d6-4585-8432-7d3a658f03f6,7a7b2d44-3faf-4dbe-a3de-668eb5aa96f6,7a7b2d44-3faf-4dbe-a3de-668eb5aa96f6,7676dc1c-03a4-4952-95c6-31bcdf5f8181,7676dc1c-03a4-4952-95c6-31bcdf5f8181,75d00082-eb11-4c48-9da0-342644fb0d90,6caeb8d4-df4f-4ed6-ac51-979a942aef1a,6caeb8d4-df4f-4ed6-ac51-979a942aef1a,69e129d9-f954-450f-ba38-204da95ed503,69e129d9-f954-450f-ba38-204da95ed503,61871316-0cc4-4ded-9ea6-11487e0ce98d,61871316-0cc4-4ded-9ea6-11487e0ce98d,537cf5aa-e0e1-435c-ba71-164eca1b4769,52286aa5-785e-4e24-a47f-818af30903f5,51470221-1c23-4137-b8fa-adddd88122b7,51470221-1c23-4137-b8fa-adddd88122b7,505f5cf1-a61d-4d4c-807c-e383952fc5d1,505f5cf1-a61d-4d4c-807c-e383952fc5d1,4858883a-06fc-42b1-b2d3-b3db3f141943,45270692-0c68-42a3-b8fd-5adae98801b9,3ad62c68-0673-435a-8823-bc7e7d59ec6e,3ad62c68-0673-435a-8823-bc7e7d59ec6e,33f578b1-ba72-40c0-a706-aec6c8a1eae9,33f578b1-ba72-40c0-a706-aec6c8a1eae9,28bdf57a-3fb4-4111-a543-c849897c6c67,28bdf57a-3fb4-4111-a543-c849897c6c67,1d6632b0-f2c5-4c6b-a996-4ccc0c1652d5,1831476e-ca37-4fc3-a934-e7577c85afca,18117265-ea6e-4047-a200-182927fcff20,18117265-ea6e-4047-a200-182927fcff20,17485496-76d6-11e9-ab59-0a75340ab8c4,17485496-76d6-11e9-ab59-0a75340ab8c4,1747fb68-76d6-11e9-a9f1-0a75340ab8c4,1747fb68-76d6-11e9-a9f1-0a75340ab8c4,17479a60-76d6-11e9-a849-0a75340ab8c4,17479a60-76d6-11e9-a849-0a75340ab8c4,1746fbd2-76d6-11e9-a577-0a75340ab8c4,1746b7b2-76d6-11e9-a454-0a75340ab8c4,1746b410-76d6-11e9-a439-0a75340ab8c4,1746b410-76d6-11e9-a439-0a75340ab8c4,17469cdc-76d6-11e9-a3d3-0a75340ab8c4,17469cdc-76d6-11e9-a3d3-0a75340ab8c4,17462554-76d6-11e9-a27e-0a75340ab8c4,17462554-76d6-11e9-a27e-0a75340ab8c4,173e1f1c-76d6-11e9-beb2-0a75340ab8c4,173e1f1c-76d6-11e9-beb2-0a75340ab8c4,173c5b1e-76d6-11e9-b65f-0a75340ab8c4,1731747e-76d6-11e9-92a2-0a75340ab8c4,172539ca-76d6-11e9-b23c-0a75340ab8c4,172539ca-76d6-11e9-b23c-0a75340ab8c4,1724f898-76d6-11e9-b0d9-0a75340ab8c4,1724f898-76d6-11e9-b0d9-0a75340ab8c4,1720bc2e-76d6-11e9-bec6-0a75340ab8c4,1720bc2e-76d6-11e9-bec6-0a75340ab8c4}'::uuid[]))
  • Heap Fetches: 292
20. 258.420 258.420 ↑ 1.0 1 292

Index Scan using pk_selectable_article on selectable_article mainarticl0_1_ (cost=0.42..8.04 rows=1 width=17) (actual time=0.875..0.885 rows=1 loops=292)

  • Index Cond: (id = mainarticl0_.id)
21. 7.884 7.884 ↑ 1.0 1 292

Index Scan using pk_article_tree_node on article_tree_node mainarticl0_2_ (cost=0.42..0.56 rows=1 width=127) (actual time=0.025..0.027 rows=1 loops=292)

  • Index Cond: (id = mainarticl0_1_.id)
22. 267.180 267.180 ↑ 19.0 1 292

Index Scan using ix_article_tree_node_parent_id on article_tree_node children1_ (cost=0.42..66.46 rows=19 width=36) (actual time=0.605..0.915 rows=1 loops=292)

  • Index Cond: (mainarticl0_.id = parent_id)
23. 389.850 389.850 ↑ 1.0 1 339

Index Scan using pk_selectable_article on selectable_article children1_1_ (cost=0.42..0.48 rows=1 width=19) (actual time=1.109..1.150 rows=1 loops=339)

  • Index Cond: (children1_.id = id)
24. 269.505 269.505 ↑ 1.0 1 339

Index Scan using pk_vendor_article on vendor_article children1_2_ (cost=0.42..0.47 rows=1 width=32) (actual time=0.793..0.795 rows=1 loops=339)

  • Index Cond: (children1_.id = id)
25. 147.804 147.804 ↑ 1.0 1 339

Index Scan using main_article_normalized_price_pkey on main_article_normalized_price normalized2_ (cost=0.42..6.56 rows=1 width=37) (actual time=0.425..0.436 rows=1 loops=339)

  • Index Cond: (mainarticl0_.id = main_article_id)
26. 5.472 5.472 ↑ 1.0 1 342

Index Scan using pk_article_tree_node on article_tree_node articletre3_ (cost=0.42..0.56 rows=1 width=69) (actual time=0.012..0.016 rows=1 loops=342)

  • Index Cond: (mainarticl0_2_.parent_id = id)
27. 2,016.774 107,819.262 ↑ 84.6 292 342

CTE Scan on articletreenodecte articletre4_ (cost=0.00..27,458,184.97 rows=24,694 width=48) (actual time=214.609..315.261 rows=292 loops=342)

  • Filter: (SubPlan 5)
  • Rows Removed by Filter: 1446
28.          

SubPlan (forCTE Scan)

29. 105,802.488 105,802.488 ↑ 61.8 4 594,396

CTE Scan on articletreenodecte articletre5_ (cost=0.00..1,111.25 rows=247 width=4) (actual time=0.022..0.178 rows=4 loops=594,396)

  • Filter: (origin_article_tree_node_id = articletre4_.origin_article_tree_node_id)
  • Rows Removed by Filter: 1133
30.          

SubPlan (forNested Loop Left Join)

31. 5.130 127.224 ↑ 1.0 1 342

Aggregate (cost=1,235.34..1,235.35 rows=1 width=32) (actual time=0.371..0.372 rows=1 loops=342)

32. 122.094 122.094 ↑ 61.5 4 342

CTE Scan on articletreenodecte articletre6_ (cost=0.00..1,234.73 rows=246 width=16) (actual time=0.085..0.357 rows=4 loops=342)

  • Filter: ((parent_id <> articletre3_.id) AND (origin_article_tree_node_id = mainarticl0_.id))
  • Rows Removed by Filter: 1734
33. 5.130 124.488 ↑ 1.0 1 342

Aggregate (cost=1,144.67..1,144.68 rows=1 width=32) (actual time=0.364..0.364 rows=1 loops=342)

34. 8.367 119.358 ↑ 25.2 16 342

Hash Join (cost=18.49..1,143.66 rows=404 width=16) (actual time=0.135..0.349 rows=16 loops=342)

  • Hash Cond: (definedatt8_.attribute = articleatt9_.id)
35. 6.502 110.808 ↑ 25.2 16 342

Hash Join (cost=11.91..1,131.53 rows=404 width=16) (actual time=0.131..0.324 rows=16 loops=342)

  • Hash Cond: (articletre7_.article_tree_node_id = definedatt8_.node_id)
36. 103.626 103.626 ↑ 41.2 6 342

CTE Scan on articletreenodecte articletre7_ (cost=0.00..1,111.25 rows=247 width=16) (actual time=0.025..0.303 rows=6 loops=342)

  • Filter: (origin_article_tree_node_id = mainarticl0_.id)
  • Rows Removed by Filter: 1732
37. 0.418 0.680 ↑ 1.0 396 1

Hash (cost=6.96..6.96 rows=396 width=32) (actual time=0.680..0.680 rows=396 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
38. 0.262 0.262 ↑ 1.0 396 1

Seq Scan on article_tree_node_attribute definedatt8_ (cost=0.00..6.96 rows=396 width=32) (actual time=0.006..0.262 rows=396 loops=1)

39. 0.092 0.183 ↑ 1.0 159 1

Hash (cost=4.59..4.59 rows=159 width=16) (actual time=0.183..0.183 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
40. 0.091 0.091 ↑ 1.0 159 1

Seq Scan on article_attribute articleatt9_ (cost=0.00..4.59 rows=159 width=16) (actual time=0.019..0.091 rows=159 loops=1)

Planning time : 15.185 ms
Execution time : 110,343.335 ms