AI Feature Functions
- gs_index_advise(text)
Description: Recommends an index for a single query statement.
Parameter: SQL statement string
Return type: record
- hypopg_create_index(text)
Description: Creates a virtual index.
Parameter: character string of the statement for creating an index
Return type: record
- hypopg_display_index()
Description: Displays information about all created virtual indexes.
Parameter: none
Return type: record
- hypopg_drop_index(oid)
Description: Deletes a specified virtual index.
Parameter: OID of the index
Return type: Boolean
- hypopg_reset_index()
Description: Clears all virtual indexes.
Parameter: none
Return type: none
- hypopg_estimate_size(oid)
Description: Estimates the space required for creating a specified index.
Parameter: OID of the index
Return type: int8
- check_engine_status(ip text, port text)
Description: Tests whether a predictor engine provides services on a specified IP address and port.
Parameter: IP address and port number of the predictor engine.
Return type: text
This function is unavailable in the current version.
- encode_plan_node(optname text, orientation text, strategy text, options text, dop int8, quals text, projection text)
Description: Encodes the plan operator information in the input parameters.
Parameter: plan operator information
Return type: text
This function is an internal function. You are advised not to use it directly.
- model_train_opt(template text, model text)
Description: Trains a given query performance prediction model.
Parameters: template name and model name of the performance prediction model
Return type: startup_time_accuracy FLOAT8, total_time_accuracy FLOAT8, rows_accuracy FLOAT8, peak_memory_accuracy FLOAT8
This function is unavailable in the current version.
- track_model_train_opt(ip text, port text)
Description: Returns the training log address of the specified IP address and port predictor engine.
Parameter: IP address and port number of the predictor engine
Return type: text
This function is unavailable in the current version.
- encode_feature_perf_hist(datname text)
Description: Encodes historical plan operators collected in the target database.
Parameter: database name
Return type: queryid bigint, plan_node_id int, parent_node_id int, left_child_id int, right_child_id int, encode text, startup_time bigint, total_time bigint, rows bigint, and peak_memory int
- gather_encoding_info(datname text)
Description: Calls encode_feature_perf_hist to save the encoded data persistently.
Parameter: database name
Return type: int
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot