explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PHBC

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.033 ↓ 0.0 0 1

Hash Join (cost=7,790.55..9,285.68 rows=499 width=119) (actual time=0.033..0.033 rows=0 loops=1)

  • Hash Cond: ("*VALUES*".column1 = pa.has_position)
2. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=7,769.78..7,920.73 rows=499 width=185) (never executed)

  • Group Key: l.cnt_players, "*VALUES*".column1, p.player_name, s.id_player
3. 0.000 0.000 ↓ 0.0 0

Sort (cost=7,769.78..7,771.03 rows=499 width=41) (never executed)

  • Sort Key: "*VALUES*".column1, p.player_name
4. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=28.21..7,747.42 rows=499 width=41) (never executed)

  • Join Filter: (s."position" = l."position")
5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=28.21..7,685.78 rows=498 width=41) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=27.79..3,623.64 rows=497 width=43) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..8.34 rows=1 width=15) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Values Scan on "*VALUES*" (cost=0.00..0.03 rows=1 width=1) (never executed)

  • Filter: (NOT column1)
9. 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 = 877297)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on cash_hand_player_statistics s (cost=27.50..3,610.33 rows=497 width=32) (never executed)

  • Recheck Cond: (id_player = 877297)
  • Filter: ((NOT flg_hero) AND (cnt_players = 6))
11. 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 = 877297)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using cash_hand_summary_primary_key on cash_hand_summary hs (cost=0.43..8.16 rows=1 width=6) (never executed)

  • Index Cond: (id_hand = s.id_hand)
13. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.90 rows=8 width=4) (never executed)

14. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (cnt_players = 6)
15. 0.000 0.020 ↓ 0.0 0 1

Hash (cost=20.74..20.74 rows=2 width=87) (actual time=0.020..0.020 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
16. 0.001 0.020 ↓ 0.0 0 1

Subquery Scan on pa (cost=4.16..20.74 rows=2 width=87) (actual time=0.020..0.020 rows=0 loops=1)

17. 0.005 0.019 ↓ 0.0 0 1

Nested Loop (cost=4.16..20.72 rows=2 width=119) (actual time=0.019..0.019 rows=0 loops=1)

18. 0.012 0.012 ↓ 2.0 2 1

Seq Scan on person_preflop_stats_average ia (cost=0.00..1.20 rows=1 width=83) (actual time=0.011..0.012 rows=2 loops=1)

  • Filter: (cnt_players = 6)
  • Rows Removed by Filter: 14
19. 0.000 0.002 ↓ 0.0 0 2

Bitmap Heap Scan on person_preflop_stats_average_per_person ip (cost=4.16..9.50 rows=2 width=196) (actual time=0.001..0.001 rows=0 loops=2)

  • Recheck Cond: (id_player = 877297)
20. 0.002 0.002 ↓ 0.0 0 2

Bitmap Index Scan on inx_preflop_id (cost=0.00..4.16 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: (id_player = 877297)