Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

User Interface (v1.6)

Alena Rybakina edited this pageFeb 7, 2023 ·2 revisions

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 foraqo_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.
Clone this wiki locally

[8]ページ先頭

©2009-2025 Movatter.jp