explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iuOy

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.040 ↑ 1,200.0 1 1

Hash Join (cost=22.60..47.77 rows=1,200 width=140) (actual time=0.031..0.040 rows=1 loops=1)

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

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

3. 0.003 0.008 ↑ 560.0 1 1

Hash (cost=15.60..15.60 rows=560 width=116) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.005 0.005 ↑ 560.0 1 1

Seq Scan on users (cost=0.00..15.60 rows=560 width=116) (actual time=0.005..0.005 rows=1 loops=1)

Planning time : 0.130 ms
Execution time : 0.067 ms