Thread: Tuning SQL

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    2
    Rep Power
    0

    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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,787
    Rep Power
    349
    Originally Posted by mestre_leo
    And i want to know if somebody knows some command in Mysql that do something like that..
    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.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    2
    Rep Power
    0
    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

IMN logo majestic logo threadwatch logo seochat tools logo