April 16th, 2012, 06:33 PM
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..
April 17th, 2012, 01:58 AM
So why are you asking in the PostgreSQL forum?
Originally Posted by mestre_leo
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.
April 19th, 2012, 08:10 PM
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..