explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hbY4

Settings
# exclusive inclusive rows x rows loops node
1. 1,542.344 2,709.921 ↑ 1.0 323,188 1

Hash Join (cost=11,512.73..135,892.91 rows=323,188 width=362) (actual time=459.405..2,709.921 rows=323,188 loops=1)

  • Hash Cond: (w.work_id = o.work_id)
2. 741.294 741.294 ↑ 1.0 4,791,959 1

Seq Scan on work w (cost=0.00..103,178.22 rows=4,792,022 width=159) (actual time=0.020..741.294 rows=4,791,959 loops=1)

3. 279.044 426.283 ↑ 1.0 323,188 1

Hash (cost=7,472.88..7,472.88 rows=323,188 width=203) (actual time=426.283..426.283 rows=323,188 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 38873kB
4. 147.239 147.239 ↑ 1.0 323,188 1

Seq Scan on origin o (cost=0.00..7,472.88 rows=323,188 width=203) (actual time=0.015..147.239 rows=323,188 loops=1)