Tuning SQL

Hey guys,

I'm doing a final paper of college and this is about tuning of sql.
I'm using the package DBMS_SQLTUNE of Oracle Database to take some recommendations of a particular sql statement. And i want to know if somebody knows some command in PostgreSQL that do something like that..

And also i'm accessing this table 'V$SQLAREA' of Oracle Database to take some informations about every sql that is runing on database.. And i want to know the same thing.. if exist some command in PostgreSQL that do something like that..

Thanks a lot for your help..
Att.

So why are you asking in the PostgreSQL forum?

But no, neither MySQL nor PostgreSQL have someting similar to DBMS_SQLTUNE.

The closest thing to V$SQLAREA in PostgreSQL is probably pg_stat_activity, but that's more like V$SESSION as it only shows the current statements, not the parsed ones.

I have no idea about MySQL as I don't use it.

Sorry my mistake,
i was asking about PostgreSQL..

I read about pg_stat_activity and i ended finding the pg_stat_statements, that is what i really need.. I will try to use here!
Are you sure that doens't exist anything that can return recommendations about the SQL statement, like what we need to do reduce the execution time of the SQL.
For example, create a index in some column, etc..

thanks for
your help