explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dPiX

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

Nested Loop (cost=8.33..13.36 rows=1 width=361) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.18..12.94 rows=1 width=135) (actual rows= loops=)

  • Hash Cond: (c.user_id = u.id)
3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

Hash (cost=8.17..8.17 rows=1 width=102) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using users_email_key on users u (cost=0.15..8.17 rows=1 width=102) (actual rows= loops=)

  • Index Cond: ((email)::text = 'user_1@hotmail.com'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using posts_pkey on posts p (cost=0.15..0.41 rows=1 width=226) (actual rows= loops=)

  • Index Cond: (id = c.user_id)