explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oWch

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

GroupAggregate (cost=477,044.41..582,559.06 rows=40,000 width=166) (actual rows= loops=)

  • Group Key: res.asset_id, res.name
2. 0.000 0.000 ↓ 0.0

Incremental Sort (cost=477,044.41..576,205.37 rows=780,492 width=352) (actual rows= loops=)

  • Sort Key: res.asset_id, res.name
  • Presorted Key: res.asset_id
3. 0.000 0.000 ↓ 0.0

Subquery Scan on res (cost=476,600.07..492,209.91 rows=780,492 width=352) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Unique (cost=476,600.07..484,404.99 rows=780,492 width=352) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=476,600.07..478,551.30 rows=780,492 width=352) (actual rows= loops=)

  • Sort Key: ua.asset_id, u.organization, u.name
6. 0.000 0.000 ↓ 0.0

Append (cost=26,173.53..149,445.22 rows=780,492 width=352) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=26,173.53..55,101.34 rows=377,510 width=34) (actual rows= loops=)

  • Hash Cond: (ua.universe_id = u.id)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=26,168.94..54,069.27 rows=377,510 width=20) (actual rows= loops=)

  • Hash Cond: (ua.asset_id = a.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on universe_assets ua (cost=0.00..16,598.69 rows=651,669 width=20) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=19,218.60..19,218.60 rows=399,787 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on assets a (cost=0.00..19,218.60 rows=399,787 width=16) (actual rows= loops=)

  • Filter: (discovery_status = 200)
12. 0.000 0.000 ↓ 0.0

Hash (cost=3.15..3.15 rows=115 width=22) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on universes u (cost=0.00..3.15 rows=115 width=22) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=46,946.95..82,636.50 rows=402,982 width=34) (actual rows= loops=)

  • Hash Cond: (ua_1.universe_id = u_1.id)
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=46,942.36..81,535.10 rows=402,982 width=20) (actual rows= loops=)

  • Hash Cond: (ur.parent_id = ua_1.asset_id)
16. 0.000 0.000 ↓ 0.0

Gather (cost=18,378.81..30,807.87 rows=65,458 width=32) (actual rows= loops=)

  • Workers Planned: 2
17. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=17,378.81..23,262.07 rows=27,274 width=32) (actual rows= loops=)

  • Hash Cond: (ur.child_id = a_1.id)
18. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using underlying_relationships_pkey on underlying_relationships ur (cost=0.42..4,347.35 rows=44,315 width=32) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=14,482.17..14,482.17 rows=166,578 width=16) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on assets a_1 (cost=0.00..14,482.17 rows=166,578 width=16) (actual rows= loops=)

  • Filter: (discovery_status = 200)
21. 0.000 0.000 ↓ 0.0

Hash (cost=16,598.69..16,598.69 rows=651,669 width=20) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on universe_assets ua_1 (cost=0.00..16,598.69 rows=651,669 width=20) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=3.15..3.15 rows=115 width=22) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on universes u_1 (cost=0.00..3.15 rows=115 width=22) (actual rows= loops=)