explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zOn : Optimization for: plan #oPYi

Settings

Optimization path:

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

Hash Join (cost=321.48..602.33 rows=43 width=101) (actual rows= loops=)

  • Hash Cond: (ps.id = (max(players_stats.id)))
2. 0.000 0.000 ↓ 0.0

Seq Scan on players_stats ps (cost=0.00..245.42 rows=9,333 width=77) (actual rows= loops=)

  • Filter: active
3. 0.000 0.000 ↓ 0.0

Hash (cost=320.90..320.90 rows=46 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=319.99..320.44 rows=46 width=24) (actual rows= loops=)

  • Group Key: players_stats.player_id
5. 0.000 0.000 ↓ 0.0

Seq Scan on players_stats (cost=0.00..245.42 rows=9,942 width=24) (actual rows= loops=)