explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h6kK : Optimization for: plan #KQBa

Settings

Optimization path:

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

Sort (cost=215.91..216.16 rows=100 width=16) (actual rows= loops=)

  • Sort Key: guilds.last_creation
2. 0.000 0.000 ↓ 0.0

Subquery Scan on guilds (cost=207.84..212.59 rows=100 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=207.84..211.59 rows=100 width=40) (actual rows= loops=)

  • Group Key: g.id
  • Filter: (count(e.guild) FILTER (WHERE e.animated) < 50)
4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.75..165.78 rows=5,609 width=25) (actual rows= loops=)

  • Hash Cond: (e.guild = g.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on emotes e (cost=0.00..142.09 rows=5,609 width=17) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=5.00..5.00 rows=300 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on _guilds g (cost=0.00..5.00 rows=300 width=8) (actual rows= loops=)