explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BaUe

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

Sort (cost=230,622.42..230,623.92 rows=600 width=53) (actual rows= loops=)

  • Sort Key: ua.asset_id
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=230,587.24..230,594.74 rows=600 width=53) (actual rows= loops=)

  • Group Key: ua.asset_id, u.name
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=31,902.48..221,676.53 rows=1,188,094 width=34) (actual rows= loops=)

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

Hash Join (cost=91.22..185,258.75 rows=1,754,856 width=34) (actual rows= loops=)

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

Append (cost=0.00..178,040.09 rows=2,658,872 width=20) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on universe_assets ua (cost=0.00..62,198.41 rows=1,272,641 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Merge Join (cost=28.30..101,979.37 rows=1,386,231 width=20) (actual rows= loops=)

  • Merge Cond: (ur.parent_id = ua_1.asset_id)
8. 0.000 0.000 ↓ 0.0

Index Only Scan using underlying_relationships_pkey on underlying_relationships ur (cost=0.42..5,098.31 rows=196,054 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..85,613.78 rows=1,272,641 width=20) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using idx_universe_assets_assetid on universe_assets ua_1 (cost=0.43..82,432.18 rows=1,272,641 width=20) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=89.57..89.57 rows=132 width=22) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using universes_pkey on universes u (cost=0.14..89.57 rows=132 width=22) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=25,139.06..25,139.06 rows=533,776 width=16) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on assets a (cost=0.00..25,139.06 rows=533,776 width=16) (actual rows= loops=)

  • Filter: (discovery_status = 200)