explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oXyx

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 731.629 ↑ 4.7 780 1

Subquery Scan on pcs (cost=136,179.33..136,224.96 rows=3,650 width=0) (actual time=731.562..731.629 rows=780 loops=1)

2. 0.238 731.588 ↑ 4.7 780 1

Sort (cost=136,179.33..136,188.46 rows=3,650 width=30) (actual time=731.562..731.588 rows=780 loops=1)

  • Sort Key: (COALESCE((sum(c.hands))::real, '0'::real)) DESC
  • Sort Method: quicksort Memory: 85kB
3. 3.308 731.350 ↑ 4.7 780 1

HashAggregate (cost=135,917.74..135,963.37 rows=3,650 width=30) (actual time=731.232..731.350 rows=780 loops=1)

  • Group Key: c.season, u.id
4. 580.480 728.042 ↑ 17.8 14,649 1

Nested Loop Left Join (cost=0.00..133,957.18 rows=261,409 width=24) (actual time=0.058..728.042 rows=14,649 loops=1)

  • Join Filter: (c.pokerrr_id = ANY (u.pokerrr_ids))
  • Rows Removed by Join Filter: 5332236
5. 1.072 1.072 ↑ 1.0 14,649 1

Seq Scan on cash_games_players c (cost=0.00..271.49 rows=14,649 width=15) (actual time=0.010..1.072 rows=14,649 loops=1)

6. 146.437 146.490 ↑ 1.0 365 14,649

Materialize (cost=0.00..14.47 rows=365 width=50) (actual time=0.000..0.010 rows=365 loops=14,649)

7. 0.053 0.053 ↑ 1.0 365 1

Seq Scan on users u (cost=0.00..12.65 rows=365 width=50) (actual time=0.005..0.053 rows=365 loops=1)

Planning time : 0.101 ms
Execution time : 731.719 ms