查看执行计划。
使用explain语句可对“CREATE MODEL”和“PREDICT BY”的模型训练或预测过程中的执行计划进行分析。Explain关键字后可直接拼接CREATE MODEL/ PREDICT BY语句(子句),也可接可选的参数,支持的参数如下:
表 4 EXPLAIN支持的参数
示例:
openGauss=# Explain CREATE MODEL patient_logisitic_regression USING logistic_regression FEATURES second_attack, treatment TARGET trait_anxiety > 50 FROM patients WITH batch_size=10, learning_rate = 0.05;
NOTICE: Hyperparameter batch_size takes value 10
NOTICE: Hyperparameter decay takes value DEFAULT (0.950000)
NOTICE: Hyperparameter learning_rate takes value 0.050000
NOTICE: Hyperparameter max_iterations takes value DEFAULT (100)
NOTICE: Hyperparameter max_seconds takes value DEFAULT (0)
NOTICE: Hyperparameter optimizer takes value DEFAULT (gd)
NOTICE: Hyperparameter tolerance takes value DEFAULT (0.000500)
NOTICE: Hyperparameter seed takes value DEFAULT (0)
NOTICE: Hyperparameter verbose takes value DEFAULT (FALSE)
NOTICE: GD shuffle cache size 212369
QUERY PLAN
-------------------------------------------------------------------
Gradient Descent (cost=0.00..0.00 rows=0 width=0)
-> Seq Scan on patients (cost=0.00..32.20 rows=1776 width=12)
(2 rows)
详情查看:https://opengauss.org
详情查看:https://docs-opengauss.osinfra.cn