explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1a14

Settings
# exclusive inclusive rows x rows loops node
1. 151.976 960.674 ↓ 1.1 864,845 1

Hash Join (cost=31,907.02..99,572.88 rows=796,998 width=34) (actual time=217.424..960.674 rows=864,845 loops=1)

  • Hash Cond: (ua.universe_id = u.id)
2. 389.205 808.586 ↓ 1.1 864,845 1

Hash Join (cost=31,811.26..97,350.37 rows=796,998 width=20) (actual time=217.296..808.586 rows=864,845 loops=1)

  • Hash Cond: (ua.asset_id = a.id)
3. 206.019 206.019 ↓ 1.0 1,273,688 1

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

4. 105.289 213.362 ↓ 1.0 535,467 1

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

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 33,293kB
5. 108.073 108.073 ↓ 1.0 535,467 1

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

  • Filter: (discovery_status = 200)
  • Rows Removed by Filter: 261,446
6. 0.027 0.112 ↑ 1.9 133 1

Hash (cost=92.56..92.56 rows=256 width=22) (actual time=0.112..0.112 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
7. 0.085 0.085 ↑ 1.9 133 1

Seq Scan on universes u (cost=0.00..92.56 rows=256 width=22) (actual time=0.005..0.085 rows=133 loops=1)