explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eieg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=26.45..46.97 rows=200 width=361) (actual rows= loops=)

  • Hash Cond: (u.id = p.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on users u (cost=0.00..16.20 rows=620 width=102) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=23.95..23.95 rows=200 width=259) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.20..23.95 rows=200 width=259) (actual rows= loops=)

  • Hash Cond: (c.user_id = p.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on comments c (cost=0.00..4.00 rows=200 width=33) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=226) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on posts p (cost=0.00..13.20 rows=320 width=226) (actual rows= loops=)