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 to perform a tuning action. For example, a return value of:
|
TUNING_DESCRIPTION |
VARCHAR |
Textual description of the tuning recommendation to perform on the
|
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 SELECT * FROM CONFIGURATION_PARAMETERS WHERE parameter_name = 'LockTimeout'; Set the password for user ALTER USER (bsmith) IDENTIFIED BY ('new_password'); |
TUNING_COST |
VARCHAR |
Cost is based on the type of tuning recommendation and is one of:
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
.