show命令
命令功能
展示已有的调优数据，提供整体和指定轮次数据的显示，并可以对参数重要性进行分析。
命令格式
1 | show [-h] {round,top,importance,diff,suggestion} ... |
参数说明
参数 |
参数选项 |
说明 |
|---|---|---|
-h/--help |
- |
可选参数，获取show子命令的帮助信息。 |
round |
- |
可选参数，展示指定对应轮次的信息。 |
top |
- |
可选参数，展示以性能降序排列的前N个轮次的性能数据。 |
importance |
- |
可选参数，全局参数重要性分析。 说明：
多轮次调优时若需了解哪些参数对性能提升有效果，可指定该参数。回显信息中“importance(%)”列的比值越高，该参数对于调优的相关性越高。 |
diff |
- |
可选参数，展示参数不同轮次的对比变化。 说明：
若有效训练轮次为1，使用diff参数，“Parameter diff”回显信息中将只展示这一轮的有效内容。 |
suggestion |
- |
可选参数，针对部分应用场景的不同层级参数进行内部测试评估，提供具备一定普适性的参数调优建议。 |
使用示例
- 查看全量调优结果。
1show
返回信息如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
[2025-07-22 02:07:16 UTC] [KAT] [message] - ============================== Auto Tuning Report ============================== [2025-07-22 02:07:16 UTC] [KAT] [message] - Total round : 5 [2025-07-22 02:07:16 UTC] [KAT] [message] - Total run : 6 [2025-07-22 02:07:16 UTC] [KAT] [message] - Fail times : 0 [2025-07-22 02:07:16 UTC] [KAT] [message] - Tuning direction : high [2025-07-22 02:07:16 UTC] [KAT] [message] - Algorithm : HPO [2025-07-22 02:07:16 UTC] [KAT] [message] - Performance description : tpmC, transactions per minute [2025-07-22 02:07:16 UTC] [KAT] [message] - Parameter groups : PostgreSQL [2025-07-22 02:07:16 UTC] [KAT] [message] - Baseline performance : 85.610 [2025-07-22 02:07:16 UTC] [KAT] [message] - Top 10 performance : [2025-07-22 02:07:16 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:07:16 UTC] [KAT] [message] - | Rank | Round | Performance | Improvement (%) | [2025-07-22 02:07:16 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:07:16 UTC] [KAT] [message] - | 1 | round 1 | 115.750 | 35.21 | [2025-07-22 02:07:16 UTC] [KAT] [message] - | 2 | round 2 | 103.820 | 21.27 | [2025-07-22 02:07:16 UTC] [KAT] [message] - | 3 | round 3 | 91.310 | 6.66 | [2025-07-22 02:07:16 UTC] [KAT] [message] - | 4 | round 4 | 87.040 | 1.67 | [2025-07-22 02:07:16 UTC] [KAT] [message] - | 5 | round 5 | 86.970 | 1.59 | [2025-07-22 02:07:16 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:07:16 UTC] [KAT] [message] - Note: [2025-07-22 02:07:16 UTC] [KAT] [message] - The performance value is the return value of the run test step, [2025-07-22 02:07:16 UTC] [KAT] [message] - Performance improvement (%) = [2025-07-22 02:07:16 UTC] [KAT] [message] - (round performance - baseline performance) / baseline performance * 100 [2025-07-22 02:07:16 UTC] [KAT] [message] - Case package locate: /home/template/train/train-20250722-095736 [2025-07-22 02:07:16 UTC] [KAT] [message] - ================================================================================
- 查看指定轮次（第一轮次）数据。
1show round 1
返回信息片段如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
[2025-07-22 02:08:38 UTC] [KAT] [message] - ======================== info of Round 1 =================================== [2025-07-22 02:08:38 UTC] [KAT] [message] - # Performance: 115.75 [2025-07-22 02:08:38 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:08:38 UTC] [KAT] [message] - ---------------------- Params --------------------------------- [2025-07-22 02:08:38 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:08:38 UTC] [KAT] [message] - PostgreSQL: [2025-07-22 02:08:38 UTC] [KAT] [message] - autovacuum_vacuum_cost_delay = 78 [2025-07-22 02:08:38 UTC] [KAT] [message] - effective_io_concurrency = 458 [2025-07-22 02:08:38 UTC] [KAT] [message] - maintenance_work_mem = 21 ... ... ... [2025-07-22 02:08:38 UTC] [KAT] [message] - jit_above_cost = 30568.774866116233 [2025-07-22 02:08:38 UTC] [KAT] [message] - jit_inline_above_cost = 4537448.678787686 [2025-07-22 02:08:38 UTC] [KAT] [message] - jit_optimize_above_cost = 2357403.7780118138 [2025-07-22 02:08:38 UTC] [KAT] [message] - parallel_leader_participation = on [2025-07-22 02:08:38 UTC] [KAT] [message] - vacuum_cleanup_index_scale_factor = 0.8512653270736337 [2025-07-22 02:08:38 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:08:38 UTC] [KAT] [message] - ---------------------- Run Info -------------------------------- [2025-07-22 02:08:38 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:08:38 UTC] [KAT] [message] - Run record: 1 [2025-07-22 02:08:38 UTC] [KAT] [message] - Result: success [2025-07-22 02:08:38 UTC] [KAT] [message] - Performance: 115.75 [2025-07-22 02:08:38 UTC] [KAT] [message] - Run time: 2025-07-22 01:57:42.474749 [2025-07-22 02:08:38 UTC] [KAT] [message] - Finish time: 2025-07-22 01:57:42.474757 [2025-07-22 02:08:38 UTC] [KAT] [message] - [2025-07-22 02:08:38 UTC] [KAT] [message] - ================================================================================
包含指定调优轮次使用全部参数详情。
- 查看性能前五的数据。
1show top 5
返回信息如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
[2025-07-22 02:10:22 UTC] [KAT] [message] - ============================== Auto Tuning Report ============================== [2025-07-22 02:10:22 UTC] [KAT] [message] - Total round : 5 [2025-07-22 02:10:22 UTC] [KAT] [message] - Total run : 6 [2025-07-22 02:10:22 UTC] [KAT] [message] - Fail times : 0 [2025-07-22 02:10:22 UTC] [KAT] [message] - Tuning direction : high [2025-07-22 02:10:22 UTC] [KAT] [message] - Algorithm : HPO [2025-07-22 02:10:22 UTC] [KAT] [message] - Performance description : tpmC, transactions per minute [2025-07-22 02:10:22 UTC] [KAT] [message] - Parameter groups : PostgreSQL [2025-07-22 02:10:22 UTC] [KAT] [message] - Baseline performance : 85.610 [2025-07-22 02:10:22 UTC] [KAT] [message] - Top 5 performance : [2025-07-22 02:10:22 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:10:22 UTC] [KAT] [message] - | Rank | Round | Performance | Improvement (%) | [2025-07-22 02:10:22 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:10:22 UTC] [KAT] [message] - | 1 | round 1 | 115.750 | 35.21 | [2025-07-22 02:10:22 UTC] [KAT] [message] - | 2 | round 2 | 103.820 | 21.27 | [2025-07-22 02:10:22 UTC] [KAT] [message] - | 3 | round 3 | 91.310 | 6.66 | [2025-07-22 02:10:22 UTC] [KAT] [message] - | 4 | round 4 | 87.040 | 1.67 | [2025-07-22 02:10:22 UTC] [KAT] [message] - | 5 | round 5 | 86.970 | 1.59 | [2025-07-22 02:10:22 UTC] [KAT] [message] - -------------------------------------------------------------------------------- [2025-07-22 02:10:22 UTC] [KAT] [message] - Note: [2025-07-22 02:10:22 UTC] [KAT] [message] - The performance value is the return value of the run test step, [2025-07-22 02:10:22 UTC] [KAT] [message] - Performance improvement (%) = [2025-07-22 02:10:22 UTC] [KAT] [message] - (round performance - baseline performance) / baseline performance * 100 [2025-07-22 02:10:22 UTC] [KAT] [message] - Case package locate: /home/template/train/train-20250722-095736 [2025-07-22 02:10:22 UTC] [KAT] [message] - ================================================================================
- 查看参数重要性分析。
1show importance返回信息片段如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Param Group | Parameter | importance(%) | bound | Top 5 ------------------------------------------------------------------------------------------------------------- PostgreSQL | wal_buffers | 4.79% | [-1, 262144] |[127736, 133040, 147579, 20905 | | | | 2, 209052] ------------------------------------------------------------------------------------------------------------- PostgreSQL |wal_receiver_timeout| 4.57% | [0, 12000] |[5948, 6361, 9023, 10236, 1058 | | | | 0] ------------------------------------------------------------------------------------------------------------- PostgreSQL |autovacuum_analyze_s| 4.44% | [0.001, 0.5] |[0.3773385945195332, 0.1809016 | cale_factor | | |030090553, 0.16607785774301737 | | | |, 0.42596502659681407, 0.42596 | | | | 502659681407] ------------------------------------------------------------------------------------------------------------- PostgreSQL |backend_flush_after | 4.30% | [0, 256] | [190, 125, 89, 89, 97] ------------------------------------------------------------------------------------------------------------- ... ... ... ------------------------------------------------------------------------------------------------------------- PostgreSQL |vacuum_cost_page_dir| 0.00% | [0, 10000] | [9756, 9756, 9313, 680, 315] | ty | | | ------------------------------------------------------------------------------------------------------------- PostgreSQL |vacuum_cost_page_hit| 0.00% | [0, 10000] |[9029, 9595, 9595, 9200, 1672] ------------------------------------------------------------------------------------------------------------- PostgreSQL | wal_writer_delay | 0.00% | [10, 10000] |[5461, 5461, 3997, 6774, 6609] ------------------------------------------------------------------------------------------------------------- PostgreSQL |wal_writer_flush_aft| 0.00% | [0, 2147483647] |[1657993843, 1102934406, 11029 | er | | |34406, 623272542, 1923260545] -------------------------------------------------------------------------------------------------------------
- 查看第一轮次和第三轮次的参数对比变化。
1show diff 1 3
- “Round info diff”回显信息中可以查看第一轮次（115.750）、第三轮次（91.310）的性能值，以及之间的性能值差异（24.440）和差异比（26.77%）。
- “Parameter diff”回显信息中按照参数重要性排序，展示第一轮次、第三轮次之间参数值的差别。
返回信息片段如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
================================================== Round info diff =================================================== Metric |Tune_direction| Round_1_performance | Round_3_performance | Difference (Round1 - Round3) |Difference (%) ---------------------------------------------------------------------------------------------------------------------- tpmC, tran| maximize | 115.750 | 91.310 | 24.440 | 26.77 sactions p| | | | | er minute | | | | | ---------------------------------------------------------------------------------------------------------------------- =================================================== Parameter diff =================================================== Param Group | Parameter | Round_1_value | Round_3_value | Importance(%) | Bound ---------------------------------------------------------------------------------------------------------------------- PostgreSQL | wal_buffers | 127736 | 209052 | 4.79% | [-1, 262144] ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |wal_receiver_timeout| 5948 | 10236 | 4.57% | [0, 12000] ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |autovacuum_analyze_s|0.3773385945195332 |0.42596502659681407| 4.44% | [0.001, 0.5] | cale_factor | | | | ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |backend_flush_after | 190 | 89 | 4.30% | [0, 256] ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |maintenance_work_mem| 21 | 6 | 4.15% | [1, 64] ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |max_pred_locks_per_t| 123 | 18 | 4.15% | [10, 128] | ransaction | | | | ---------------------------------------------------------------------------------------------------------------------- ... ... ... ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |vacuum_cost_page_dir| 680 | 9756 | 0.00% | [0, 10000] | ty | | | | ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |vacuum_cost_page_hit| 1672 | 9595 | 0.00% | [0, 10000] ---------------------------------------------------------------------------------------------------------------------- PostgreSQL | wal_writer_delay | 3997 | 5461 | 0.00% | [10, 10000] ---------------------------------------------------------------------------------------------------------------------- PostgreSQL |wal_writer_flush_aft| 1923260545 | 1102934406 | 0.00% | [0, 2147483647] | er | | | | ----------------------------------------------------------------------------------------------------------------------
父主题： 调优结果处理