TUNING_RECOMMENDATIONS

Returns tuning recommendation results from the last call to ANALYZE_WORKLOAD. This information is useful for building filters on the Workload Analyzer result set.

Column Name Data Type Description
observation_count

INTEGER

Integer for the total number of events observed for this tuning recommendation. For example, if you see a return value of 1, Workload Analyzer is making its first tuning recommendation for the event in 'scope'.

first_observation_time

TIMESTAMPTZ

Timestamp when the event first occurred. If this column returns a null value, the tuning recommendation is from the current status of the system instead of from any prior event.

last_observation_time

TIMESTAMPTZ

Timestamp when the event last occurred. If this column returns a null value, the tuning recommendation is from the current status of the system instead of from any prior event.

tuning_parameter

VARCHAR

Objects on which you should perform a tuning action. For example, a return value of:

  • public.t informs the DBA to run Database Designer on table t in the public schema
  • bsmith notifies a DBA to set a password for user bsmith
tuning_description

VARCHAR

Textual description of the tuning recommendation to perform on the tuning_parameter object. For example:

  • Run database designer on table schema.table
  • Create replicated projection for table schema.table
  • Consider incremental design on query
  • Re-segment projection projection-name on high-cardinality column(s)
  • Drop the projection projection-name
  • Alter a table's partition expression
  • Reorganize data in partitioned table
  • Decrease the MoveOutInterval configuration parameter setting
tuning_command

VARCHAR

Command string if tuning action is a SQL command. For example:

Update statistics on a particular schema's table.column:

SELECT ANALYZE_STATISTICS('public.table.column');

Resolve mismatched configuration parameter LockTimeout:

                                    SELECT * FROM CONFIGURATION_PARAMETERS WHERE parameter_name = 'LockTimeout';

Set the password for user bsmith:

ALTER USER (bsmith) IDENTIFIED BY ('new_password');
tuning_cost

VARCHAR

Cost is based on the type of tuning recommendation and is one of:

  • LOW: minimal impact on resources from running the tuning command
  • MEDIUM: moderate impact on resources from running the tuning command
  • HIGH: maximum impact on resources from running the tuning command

Depending on the size of your database or table, consider running high-cost operations after hours instead of during peak load times.

Privileges

Superuser

Examples

See ANALYZE_WORKLOAD.

See Also

In the Administrator's Guide: