explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PR6T

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.026 ↓ 0.0 0 1

Hash Join (cost=23.05..48.22 rows=1,200 width=136) (actual time=0.026..0.026 rows=0 loops=1)

  • Hash Cond: (purchases.user_handle = users.user_handle)
2. 0.023 0.023 ↓ 0.0 0 1

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

3. 0.000 0.000 ↓ 0.0 0

Hash (cost=15.80..15.80 rows=580 width=112) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on users (cost=0.00..15.80 rows=580 width=112) (never executed)

Planning time : 4.441 ms
Execution time : 0.754 ms