explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Sps

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.711 ↓ 0.0 0 1

Nested Loop (cost=3,639.99..4,101.68 rows=93 width=72) (actual time=1.711..1.711 rows=0 loops=1)

2. 0.001 1.710 ↓ 0.0 0 1

Nested Loop (cost=0.00..365.66 rows=1 width=72) (actual time=1.710..1.710 rows=0 loops=1)

3. 1.709 1.709 ↓ 0.0 0 1

Seq Scan on person_preflop_start_stats_average_per_person ip (cost=0.00..334.60 rows=1 width=84) (actual time=1.709..1.709 rows=0 loops=1)

  • Filter: (id_player = 861573)
  • Rows Removed by Filter: 11328
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_preflop_start_stats_average ia (cost=0.00..29.05 rows=1 width=36) (never executed)

  • Filter: (("position" = 0) AND (cnt_players = 6))
5. 0.000 0.000 ↓ 0.0 0

Sort (cost=3,639.99..3,640.22 rows=93 width=104) (never executed)

  • Sort Key: foo.player_name
6. 0.000 0.000 ↓ 0.0 0

Subquery Scan on foo (cost=3,627.85..3,636.95 rows=93 width=104) (never executed)

7. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=3,627.85..3,632.30 rows=93 width=114) (never executed)

  • Group Key: l.cnt_players, l."position", p.player_name, s.id_player
8. 0.000 0.000 ↓ 0.0 0

Sort (cost=3,627.85..3,628.08 rows=94 width=25) (never executed)

  • Sort Key: p.player_name
9. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=27.69..3,624.77 rows=94 width=25) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on lookup_positions l (cost=0.00..2.04 rows=1 width=4) (never executed)

  • Filter: (("position" = 0) AND (cnt_players = 6))
11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=27.69..3,621.79 rows=94 width=25) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using player_primary_key on player p (cost=0.29..8.30 rows=1 width=14) (never executed)

  • Index Cond: (id_player = 861573)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cash_hand_player_statistics s (cost=27.40..3,612.55 rows=94 width=15) (never executed)

  • Recheck Cond: (id_player = 861573)
  • Filter: ((NOT flg_hero) AND ("position" = 0) AND (cnt_players = 6))
14. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on "chps:idx2-id_player" (cost=0.00..27.38 rows=926 width=0) (never executed)

  • Index Cond: (id_player = 861573)