explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9uqq

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.118 ↓ 2.0 2 1

HashAggregate (cost=22.95..22.96 rows=1 width=25) (actual time=0.118..0.118 rows=2 loops=1)

  • Group Key: c.id, c.name
2. 0.008 0.109 ↓ 3.0 3 1

Nested Loop (cost=17.07..22.95 rows=1 width=25) (actual time=0.084..0.109 rows=3 loops=1)

3. 0.039 0.095 ↓ 3.0 3 1

Hash Join (cost=16.92..22.61 rows=1 width=16) (actual time=0.078..0.095 rows=3 loops=1)

  • Hash Cond: (cm.user_id = u.id)
4. 0.036 0.036 ↓ 1.0 196 1

Seq Scan on clan_members cm (cost=0.00..4.95 rows=195 width=32) (actual time=0.010..0.036 rows=196 loops=1)

5. 0.006 0.020 ↑ 1.0 3 1

Hash (cost=16.89..16.89 rows=3 width=16) (actual time=0.020..0.020 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.014 0.014 ↑ 1.0 3 1

Index Only Scan using users_pkey on users u (cost=0.28..16.89 rows=3 width=16) (actual time=0.008..0.014 rows=3 loops=1)

  • Index Cond: (id = ANY ('{8d49a777-bcb9-46cf-9dcd-ba850ef3313c,3309139e-e625-4bc7-b389-0d3dd941410a,6d681eaf-58a0-4e6e-836b-551d8a4e8150}'::uuid[]))
  • Heap Fetches: 0
7. 0.006 0.006 ↑ 1.0 1 3

Index Scan using clans_pkey on clans c (cost=0.14..0.32 rows=1 width=25) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = cm.clan_id)