effectiveness tool - Mailing list pgsql-sql

Hello everybody!!
  I just want to know if there be some tool to analize the performance 
of a query, I mean to qualify the effectiveness, speed, if I have the 
correct indexes.
  Hope somebody can help me....
 Thanks in advanced!!