explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VkAq

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

CTE Scan on p1 p1_1 (cost=0.00..169.83 rows=7,548 width=44) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=22.28..944.98 rows=11,470 width=69) (actual rows= loops=)

  • Hash Cond: (om.organization_id = s.organization_id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.33..628.33 rows=14,800 width=42) (actual rows= loops=)

  • Hash Cond: (om.parent_organization_id = op.id)
4. 0.000 0.000 ↓ 0.0

CTE Scan on organization_mapping om (cost=0.00..400.00 rows=20,000 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=3.48..3.48 rows=148 width=34) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on organizations op (cost=0.00..3.48 rows=148 width=34) (actual rows= loops=)

  • Filter: (name IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Hash (cost=15.01..15.01 rows=155 width=51) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.33..15.01 rows=155 width=51) (actual rows= loops=)

  • Hash Cond: (s.organization_id = o.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on sites s (cost=0.00..7.55 rows=155 width=43) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=3.48..3.48 rows=148 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on organizations o (cost=0.00..3.48 rows=148 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5.33..15.01 rows=155 width=69) (actual rows= loops=)

  • Hash Cond: (s_1.organization_id = o_1.id)
13. 0.000 0.000 ↓ 0.0

Seq Scan on sites s_1 (cost=0.00..7.55 rows=155 width=43) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=3.48..3.48 rows=148 width=34) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on organizations o_1 (cost=0.00..3.48 rows=148 width=34) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=3.48..3.48 rows=148 width=34) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on organizations op (cost=0.00..3.48 rows=148 width=34) (actual rows= loops=)

  • Filter: (name IS NOT NULL)
18. 0.000 0.000 ↓ 0.0

Hash (cost=15.01..15.01 rows=155 width=51) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.33..15.01 rows=155 width=51) (actual rows= loops=)

  • Hash Cond: (s.organization_id = o.id)
20. 0.000 0.000 ↓ 0.0

Seq Scan on sites s (cost=0.00..7.55 rows=155 width=43) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=3.48..3.48 rows=148 width=8) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on organizations o (cost=0.00..3.48 rows=148 width=8) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5.33..15.01 rows=155 width=69) (actual rows= loops=)

  • Hash Cond: (s_1.organization_id = o_1.id)
24. 0.000 0.000 ↓ 0.0

Seq Scan on sites s_1 (cost=0.00..7.55 rows=155 width=43) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash (cost=3.48..3.48 rows=148 width=34) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on organizations o_1 (cost=0.00..3.48 rows=148 width=34) (actual rows= loops=)