explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yh7A

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

Nested Loop (cost=3,628.13..3,771.18 rows=93 width=72) (actual time=0.028..0.028 rows=0 loops=1)

2. 0.001 0.027 ↓ 0.0 0 1

Nested Loop (cost=0.29..39.36 rows=1 width=72) (actual time=0.027..0.027 rows=0 loops=1)

3. 0.026 0.026 ↓ 0.0 0 1

Index Scan using test on person_preflop_start_stats_average_per_person ip (cost=0.29..8.30 rows=1 width=84) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (id_player = 861573)
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

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
6. 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
7. 0.000 0.000 ↓ 0.0 0

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

8. 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))
9. 0.000 0.000 ↓ 0.0 0

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

10. 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)
11. 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))
12. 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)