explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gAAj : Optimization for: plan #6JdN

Settings

Optimization path:

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

XN Unique (cost=481,383.72..34,347,351.75 rows=9 width=456) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=481,383.72..34,347,350.44 rows=9 width=456) (actual rows= loops=)

  • Hash Cond: ("outer".god_id = "inner".id)
3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=481,382.45..34,347,348.44 rows=9 width=381) (actual rows= loops=)

  • Hash Cond: ("outer".player_id = ("inner".player_id)::bigint)
4. 0.000 0.000 ↓ 0.0

XN Seq Scan on core_player p (cost=0.00..7,989.51 rows=798,951 width=22) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Hash (cost=481,382.42..481,382.42 rows=9 width=367) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_DIST_NONE (cost=231.43..481,382.42 rows=9 width=367) (actual rows= loops=)

  • Hash Cond: (("outer".player_id = "inner".player_id) AND ("outer".match_id = "inner".match_id))
7. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=0.02..481,149.16 rows=9 width=202) (actual rows= loops=)

  • Hash Cond: (("outer".match_id)::bigint = "inner".match_id)
8. 0.000 0.000 ↓ 0.0

XN Seq Scan on smite_player_match pm (cost=0.00..1,148.94 rows=9 width=164) (actual rows= loops=)

  • Filter: (match_id = 125245)
9. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.01..0.01 rows=1 width=38) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on core_match m (cost=0.00..0.01 rows=1 width=38) (actual rows= loops=)

  • Filter: (match_id = 125245)
11. 0.000 0.000 ↓ 0.0

XN Hash (cost=231.36..231.36 rows=10 width=177) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on calc_smite_gyo_match gm (cost=0.00..231.36 rows=10 width=177) (actual rows= loops=)

  • Filter: (match_id = 125245)
13. 0.000 0.000 ↓ 0.0

XN Hash (cost=1.03..1.03 rows=99 width=83) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Seq Scan on smite_core_god c (cost=0.00..1.03 rows=99 width=83) (actual rows= loops=)

  • Filter: (id IS NOT NULL)