explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6EDm

Settings
# exclusive inclusive rows x rows loops node
1. 2.954 2.954 ↑ 70.5 126 1

CTE Scan on recursetree (cost=870.92..1,048.68 rows=8,888 width=1,144) (actual time=0.038..2.954 rows=126 loops=1)

2.          

CTE recursetree

3. 0.650 2.774 ↑ 70.5 126 1

Recursive Union (cost=0.00..870.92 rows=8,888 width=449) (actual time=0.035..2.774 rows=126 loops=1)

4. 1.116 1.116 ↑ 1.0 88 1

Seq Scan on financial_structure_financialunit initial (cost=0.00..84.16 rows=88 width=449) (actual time=0.025..1.116 rows=88 loops=1)

  • Filter: (uid = ANY ('{016d06e4-3c0b-7096-7cc3-dcbec09f3c7b,016d05f7-dcb7-5512-52c5-397d8f32c210,016d05ed-1ff2-f4e8-eda0-d3affdf8bc91,016d05eb-8058-2531-0602-92c77fdf0675,016d05eb-2148-bd08-74cd-d911587859bc,016d05ea-d423-4413-29c6-bb84960912a2,016d05ea-7e74-eaa5-fa8a-d67a0262a5fe,016d05ea-2be7-494e-2b5d-25cff5cc7441,016d05e9-e61a-a717-8531-bede69bc8e85,016d05e9-89b4-3e7d-d955-db00c5887704,016d05e9-3e5b-058a-01c0-aefcf26aada8,016d05e8-f906-d101-32e7-95e7c09ce3e0,016d05e8-b3ff-5f10-c17b-eea222474e3f,016d05e7-eb45-ae9e-c4af-a95cda9709dc,016d05e7-936e-c934-b0da-8f1ad8ca3e1c,016d05e7-189e-7de8-30bc-c90db3b5960a,016d05e6-8e75-5cd9-df3b-dc114b97d8d4,016d05e5-c4aa-64f8-2e35-1f9c280c88b5,016d05e5-0e6f-1c60-2d59-0b655055b6c4,016d05e3-c4fd-8b21-a93e-68d7097f237a,016d05e3-1258-dec8-90b3-5f0d479e5b21,016d05e0-3818-5c38-bacc-c3dfc1c3aefc,016d05df-ea4e-11d8-52b6-b85fd3141f7f,016d05df-7743-9d0f-1a55-33a378a790b1,016d05df-3262-2b48-ec5b-afb247d51c40,016d05de-d603-7195-d3a5-fefe4ff62dfa,016d05de-645c-43fe-7a14-fbb216817a9d,016d05dd-d009-9f81-034c-e1e2d5f82cf3,016d05ce-40ac-8031-3407-50a88b744051,016d05cd-e561-2670-489e-f97bc1f18e7a,016d05cd-3de6-6e64-ebd2-9da80aeddfe9,016d05cb-8e6b-b99a-f94c-fef562a1dfc9,016d05cb-4ec6-772e-c379-63d6419bc083,016d05cb-0951-a008-d286-a38fe9bc48f5,016d05ca-c9ea-d53e-fca4-0787b9f8ec63,016d05ca-8bf0-8156-2fd3-cf8159812d98,016d05ca-48bb-d38e-701b-f1d5773a0fa5,016d05ca-010a-d874-61c4-4990fdaf4994,016d05c9-bda3-cffa-2fda-2afc770c3f3a,016d05c9-7a0a-9f7e-693d-6631c183ab42,016d05c9-2d37-8ab9-20ce-29918396f9ca,016d05c8-da83-b215-4a84-fed25f8fd80b,016d05c8-902e-3829-000d-f6210fda5809,016d05c8-4735-b0d3-864a-d58d9b1ce61e,016d05a1-4c6a-a7d1-ca35-eee28f8c52b8,016d05a1-0122-7223-15c1-892b9bb6a13a,016d05a0-bae8-c258-0670-3ca0604d82fe,016d05a0-6f4c-0028-4935-18b3030e15ad,016d059c-a32f-405e-042e-b0a4bcb5f548,016d059b-ee90-63c1-c4fc-a97b11662c08,016d059b-6ed4-2d14-c616-d9b18af089f2,016d0599-d12c-bd68-851e-bb977c93064c,016d0599-04d9-b422-3a34-eb57db3b49b9,016d0597-8ed9-8405-914f-0ae5d4191dd1,016d0597-29f1-e5d6-8e29-7365e2939498,016d0596-bb05-00a4-cc4c-a20a7541a90b,016d0596-55eb-1b59-7293-825850b32ea7,016d0595-8e72-fb31-7e7c-1bb841eef513,016d0595-2de9-a862-9259-e88340447310,016d0594-c8cc-4d44-99ea-3483d1f9b718,016d0594-4c2e-3cb3-18b3-7574aa64e1e4,016d0593-57a3-6839-e96f-76a992fb1713,016d0592-f3a2-0a58-1756-a2891fc4f02c,016d0592-424b-6e5a-8e01-952d1f119e68,016d0591-e057-9d59-8a5b-82ca7849adbd,016d0591-67ff-0947-e67a-cb500e9e9249,016d0590-ed44-0bd3-cba1-5f4d714e20eb,016d058f-cca0-394f-9cb0-1f275eb59010,016d058e-ac05-ec6b-e678-c62e6ded7399,016d058d-bc62-1bee-6ac1-d4c6b862b931,016d058c-6d04-ce0e-d61f-a88c32c5a3df,016d058b-88e3-9823-480d-e40286c23b52,016d058b-1781-c78f-2215-9b6c92f20909,016d058a-322f-aa0b-a124-3aac65d46654,016d0589-aee7-bad2-b9c0-e0dd06bb78af,016d0589-04ab-9c17-7471-affa55e34f1f,016d0587-cc7f-eace-9b7f-608570025c89,016d0586-f5e0-18d3-757e-8e035a70c31d,016d0579-b774-393c-6ffd-8f9b2e906c26,016d0575-f075-0a1f-6bab-dbdc49651e0c,016d056c-317d-6127-b170-45789bf56cba,016d056a-f6b9-86d2-98cb-67746e8b1cda,016d0123-95f0-858b-17da-85e21bfa1dfe,016cfc12-1075-41b5-a5e4-e1c5dc81d19a,016cfc11-3ae7-2dcf-11b5-f60ad6e5e8af,016cfc0e-906d-a57c-5b50-b8ec360e1cd4,016cfc0d-5330-5090-f191-b5864d4e6b80,016cfbfd-1d12-fc8b-273b-bdefb4a8c978}'::uuid[]))
  • Rows Removed by Filter: 355
5. 0.171 1.008 ↑ 21.0 42 3

Hash Join (cost=40.97..60.90 rows=880 width=449) (actual time=0.282..0.336 rows=42 loops=3)

  • Hash Cond: (rt.leader_id = t1.uid)
6. 0.015 0.015 ↑ 21.0 42 3

WorkTable Scan on recursetree rt (cost=0.00..17.60 rows=880 width=16) (actual time=0.000..0.005 rows=42 loops=3)

7. 0.489 0.822 ↑ 1.0 443 1

Hash (cost=35.43..35.43 rows=443 width=449) (actual time=0.822..0.822 rows=443 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 211kB
8. 0.333 0.333 ↑ 1.0 443 1

Seq Scan on financial_structure_financialunit t1 (cost=0.00..35.43 rows=443 width=449) (actual time=0.008..0.333 rows=443 loops=1)

Planning time : 0.736 ms
Execution time : 3.117 ms