explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cBSI

Settings
# exclusive inclusive rows x rows loops node
1. 176.790 3,383.535 ↓ 486.5 291,906 1

Sort (cost=230,622.42..230,623.92 rows=600 width=53) (actual time=3,342.262..3,383.535 rows=291,906 loops=1)

  • Sort Key: ua.asset_id
  • Sort Method: quicksort Memory: 52,284kB
2. 750.019 3,206.745 ↓ 486.5 291,906 1

HashAggregate (cost=230,587.24..230,594.74 rows=600 width=53) (actual time=3,083.273..3,206.745 rows=291,906 loops=1)

  • Group Key: ua.asset_id, u.name
3. 502.763 2,456.726 ↑ 1.2 1,011,186 1

Hash Join (cost=31,902.48..221,676.53 rows=1,188,094 width=34) (actual time=219.973..2,456.726 rows=1,011,186 loops=1)

  • Hash Cond: (ua.asset_id = a.id)
4. 259.921 1,738.013 ↑ 1.2 1,420,099 1

Hash Join (cost=91.22..185,258.75 rows=1,754,856 width=34) (actual time=0.104..1,738.013 rows=1,420,099 loops=1)

  • Hash Cond: (ua.universe_id = u.id)
5. 101.350 1,478.009 ↑ 1.9 1,420,099 1

Append (cost=0.00..178,040.09 rows=2,658,872 width=20) (actual time=0.005..1,478.009 rows=1,420,099 loops=1)

6. 234.428 234.428 ↓ 1.0 1,273,625 1

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

7. 130.321 1,142.231 ↑ 9.5 146,474 1

Merge Join (cost=28.30..101,979.37 rows=1,386,231 width=20) (actual time=0.067..1,142.231 rows=146,474 loops=1)

  • Merge Cond: (ur.parent_id = ua_1.asset_id)
8. 31.298 31.298 ↑ 1.0 196,032 1

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

  • Heap Fetches: 43,771
9. 168.616 980.612 ↑ 1.0 1,248,446 1

Materialize (cost=0.43..85,613.78 rows=1,272,641 width=20) (actual time=0.014..980.612 rows=1,248,446 loops=1)

10. 811.996 811.996 ↑ 1.1 1,179,432 1

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 time=0.008..811.996 rows=1,179,432 loops=1)

11. 0.030 0.083 ↑ 1.0 132 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
12. 0.053 0.053 ↑ 1.0 132 1

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

13. 107.327 215.950 ↓ 1.0 535,396 1

Hash (cost=25,139.06..25,139.06 rows=533,776 width=16) (actual time=215.950..215.950 rows=535,396 loops=1)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 33,289kB
14. 108.623 108.623 ↓ 1.0 535,396 1

Seq Scan on assets a (cost=0.00..25,139.06 rows=533,776 width=16) (actual time=0.006..108.623 rows=535,396 loops=1)

  • Filter: (discovery_status = 200)
  • Rows Removed by Filter: 261,463