TUNING_RECOMMENDATIONS

Returns tuning recommendation results from the last call to ANALYZE_WORKLOAD.

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 to 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