explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NKXo

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.063 ↑ 240.0 1 1

Hash Join (cost=15.40..36.74 rows=240 width=405) (actual time=0.061..0.063 rows=1 loops=1)

  • Hash Cond: (subscriptions.id = users.id)
2. 0.016 0.016 ↑ 650.0 1 1

Seq Scan on subscriptions (cost=0.00..16.50 rows=650 width=96) (actual time=0.015..0.016 rows=1 loops=1)

3. 0.008 0.017 ↑ 240.0 1 1

Hash (cost=12.40..12.40 rows=240 width=309) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.009 0.009 ↑ 240.0 1 1

Seq Scan on users (cost=0.00..12.40 rows=240 width=309) (actual time=0.007..0.009 rows=1 loops=1)