Help with indexes

Hi,

I need some help with this query, which is currently taking minutes to run
(it needs to be seconds!).

SELECTUPPER(teams.team_name),players.first_name,players.last_name,NULL,teams.id,brackets.court,teams.team_number
FROMteams JOINplayers ON (teams.id = players.team) JOINbrackets ON (teams.id = brackets.team)
WHEREplayers.player_number = 1 ANDteams.complete ANDbrackets.court = 580
ORDER BYbrackets.game_order,teams.team_name
;

When I run it with EXPLAIN I get ...


Sort  (cost=3.15..3.15 rows=1 width=60) ->  Nested Loop  (cost=0.00..3.14 rows=1 width=60)       ->  Nested Loop
(cost=0.00..2.12rows=1 width=48)             ->  Seq Scan on players  (cost=0.00..1.05 rows=1 width=28)             ->
SeqScan on teams  (cost=0.00..1.04 rows=2 width=20)       ->  Seq Scan on brackets  (cost=0.00..1.01 rows=1 width=12)
 

Now the indexes I have are:
On table players  - unique btree on id                 - unique btree on team, player_number
On table teams    - unique btree on id
On table brackets - btree on court                 - btree on team                 - unique btree on court, team

This is on version 7.1.3.  Would upgrading to 7.2 make it faster?

- James