explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EEsR

Settings
# exclusive inclusive rows x rows loops node
1. 0.689 1.201 ↑ 1.0 10 1

HashAggregate (cost=24.29..24.39 rows=10 width=21) (actual time=1.197..1.201 rows=10 loops=1)

  • Group Key: a.id, a.email
2. 0.370 0.512 ↓ 1.1 1,054 1

Hash Join (cost=3.54..19.29 rows=1,000 width=21) (actual time=0.114..0.512 rows=1,054 loops=1)

  • Hash Cond: (c.user_id = a.id)
3. 0.051 0.051 ↑ 1.0 200 1

Seq Scan on comments c (cost=0.00..4.00 rows=200 width=4) (actual time=0.014..0.051 rows=200 loops=1)

4. 0.025 0.091 ↑ 1.0 50 1

Hash (cost=2.91..2.91 rows=50 width=25) (actual time=0.091..0.091 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
5. 0.038 0.066 ↑ 1.0 50 1

Hash Join (cost=1.23..2.91 rows=50 width=25) (actual time=0.027..0.066 rows=50 loops=1)

  • Hash Cond: (b.user_id = a.id)
6. 0.015 0.015 ↑ 1.0 50 1

Seq Scan on posts b (cost=0.00..1.50 rows=50 width=4) (actual time=0.007..0.015 rows=50 loops=1)

7. 0.007 0.013 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=21) (actual time=0.013..0.013 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.006 0.006 ↑ 1.0 10 1

Seq Scan on users a (cost=0.00..1.10 rows=10 width=21) (actual time=0.005..0.006 rows=10 loops=1)