explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yvfV

Settings
# exclusive inclusive rows x rows loops node
1. 0.091 0.516 ↑ 36.4 33 1

Hash Join (cost=17.25..42.42 rows=1,200 width=77) (actual time=0.486..0.516 rows=33 loops=1)

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

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

3. 0.245 0.404 ↑ 1.0 500 1

Hash (cost=11.00..11.00 rows=500 width=53) (actual time=0.404..0.404 rows=500 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
4. 0.159 0.159 ↑ 1.0 500 1

Seq Scan on users (cost=0.00..11.00 rows=500 width=53) (actual time=0.011..0.159 rows=500 loops=1)

Planning time : 1.411 ms
Execution time : 0.571 ms