explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZLtb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=327.74..372.10 rows=421 width=585)\n Hash Cond: (t8.leader_id = t9.uid)\n Join Filter: (t8.deleted IS NULL)\n -> Hash Left Join (cost=286.77..330.02 rows=421 width=569)\n Hash Cond: (t7.leader_id = t8.uid)\n Join Filter: (t7.deleted IS NULL)\n -> Hash Left Join (cost=245.81..287.93 rows=421 width=553)\n Hash Cond: (t6.leader_id = t7.uid)\n Join Filter: (t6.deleted IS NULL)\n -> Hash Left Join (cost=204.84..245.85 rows=421 width=537)\n Hash Cond: (t5.leader_id = t6.uid)\n Join Filter: (t5.deleted IS NULL)\n -> Hash Left Join (cost=163.87..203.77 rows=421 width=521)\n Hash Cond: (t4.leader_id = t5.uid)\n Join Filter: (t4.deleted IS NULL)\n -> Hash Left Join (cost=122.90..161.68 rows=421 width=505)\n Hash Cond: (t3.leader_id = t4.uid)\n Join Filter: (t3.deleted IS NULL)\n -> Hash Left Join (cost=81.94..119.60 rows=421 width=489)\n Hash Cond: (t2.leader_id = t3.uid)\n Join Filter: (t2.deleted IS NULL)\n -> Hash Left Join (cost=40.97..77.51 rows=421 width=473)\n Hash Cond: (financial_structure_financialunit.leader_id = t2.uid)\n Join Filter: (financial_structure_financialunit.deleted IS NULL)\n -> Seq Scan on financial_structure_financialunit (cost=0.00..35.43 rows=421 width=449)\n Filter: ((deleted IS NULL) AND (deleted IS NULL))\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t2 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t3 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t4 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t5 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t6 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t7 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t8 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=40)\n -> Seq Scan on financial_structure_financialunit t9 (cost=0.00..35.43 rows=443 width=40)\n -> Hash (cost=35.43..35.43 rows=443 width=32)\n -> Seq Scan on financial_structure_financialunit t10 (cost=0.00..35.43 rows=443 width=32) (actual rows= loops=)