explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PkiL

Settings
# exclusive inclusive rows x rows loops node
1. 0.057 0.191 ↑ 1.5 2 1

Hash Semi Join (cost=22.52..29.91 rows=3 width=25) (actual time=0.166..0.191 rows=2 loops=1)

  • Hash Cond: (clans.id = clan_members.clan_id)
2. 0.023 0.023 ↑ 1.0 107 1

Seq Scan on clans (cost=0.00..7.07 rows=107 width=25) (actual time=0.009..0.023 rows=107 loops=1)

3. 0.005 0.111 ↑ 1.5 2 1

Hash (cost=22.49..22.49 rows=3 width=16) (actual time=0.111..0.111 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.005 0.106 ↑ 1.5 2 1

HashAggregate (cost=22.43..22.46 rows=3 width=16) (actual time=0.106..0.106 rows=2 loops=1)

  • Group Key: clan_members.clan_id
5. 0.045 0.101 ↑ 1.0 3 1

Hash Semi Join (cost=16.92..22.42 rows=3 width=16) (actual time=0.085..0.101 rows=3 loops=1)

  • Hash Cond: (clan_members.user_id = users.id)
6. 0.029 0.029 ↓ 1.0 196 1

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

7. 0.007 0.027 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.020 0.020 ↑ 1.0 3 1

Index Only Scan using users_pkey on users (cost=0.28..16.89 rows=3 width=16) (actual time=0.011..0.020 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