User Interface (v1.6)

GUCs

• aqo.min_neighbors_for_predicting - minimum number of neighbors is used for cardinality prediction: if there are fewer of them, AQO won't make prediction.
• aqo.predict_with_few_neighbors - enable to make predictions with fewer neighbors than were found.
• aqo.statement_timeout - the initial value of smart statement timeout is for manual training of AQO on complex queries.

Functions

Storage management

• aqo_query_texts_update(queryid, query_text) - update or insert an aqo_query_texts record for given 'queryid'.
• aqo_query_stat_update(queryid, execution_time_with_aqo, execution_time_without_aqo, planning_time_with_aqo, planning_time_without_aqo, cardinality_error_with_aqo, cardinality_error_without_aqo, executions_with_aqo, executions_without_aqo) - update or insert an aqo_query_stat record for given 'queryid'.
• aqo_data_update(fs, fss, nfeatures, features, targets, reliability, oids) - update or insert an aqo_data record for given 'fs' & 'fss'.

Memory management.

• aqo_memory_usage - used to display sizes of aqo's memory contexts and hash tables.

AQO VIEWs

Add extension columns for aqo_queries, which present smart_statement_timeout and count_increase_timeout values.

• smart_statement_timeout - value of smart_statement_timeout for this query class.
• count_increase_timeout - how many times have been increased smart_statement_timeout value for this query class.