explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OqpQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 0.295 ↑ 36.4 33 1

Hash Join (cost=22.25..47.42 rows=1,200 width=81) (actual time=0.269..0.295 rows=33 loops=1)

  • Hash Cond: (purchases.user_handle = users.user_handle)
2. 0.017 0.017 ↑ 36.4 33 1

Seq Scan on purchases (cost=0.00..22.00 rows=1,200 width=40) (actual time=0.013..0.017 rows=33 loops=1)

3. 0.155 0.242 ↑ 1.0 500 1

Hash (cost=16.00..16.00 rows=500 width=57) (actual time=0.242..0.242 rows=500 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 51kB
4. 0.087 0.087 ↑ 1.0 500 1

Seq Scan on users (cost=0.00..16.00 rows=500 width=57) (actual time=0.014..0.087 rows=500 loops=1)

Planning time : 0.160 ms
Execution time : 0.332 ms