--- title: show命令 description: "展示已有的调优数据，提供整体和指定轮次数据的显示，并可以对参数重要性进行分析。" url: https://www.hikunpeng.com/document/detail/zh/kunpengdevps/profiler/tuning/KunpengDevKitCli_0163.html sourcePath: /source/zh/kunpengdevps/profiler/tuning/KunpengDevKitCli_0163.html indexId: 8c4779b485377c7ac1bbccbb48462ba38d76f835871beb4acafaf6da255e231c66 --- # show命令 #### 命令功能 展示已有的调优数据，提供整体和指定轮次数据的显示，并可以对参数重要性进行分析。 #### 命令格式 ``` show [-h] {round,top,importance,diff,suggestion} ... ``` #### 参数说明 **表1 show命令参数说明** | 参数 | 参数选项 | 说明 | | --- | --- | --- | | \-h/\-\-help | \- | 可选参数，获取show子命令的帮助信息。 | | round | \- | 可选参数，展示指定对应轮次的信息。 | | top | \- | 可选参数，展示以性能降序排列的前N个轮次的性能数据。 | | importance | \- | 可选参数，全局参数重要性分析。 说明： 多轮次调优时若需了解哪些参数对性能提升有效果，可指定该参数。回显信息中“importance(%)”列的比值越高，该参数对于调优的相关性越高。 | | diff | \- | 可选参数，展示参数不同轮次的对比变化。 说明： 若有效训练轮次为1，使用diff参数，“Parameter diff”回显信息中将只展示这一轮的有效内容。 | | suggestion | \- | 可选参数，针对部分应用场景的不同层级参数进行内部测试评估，提供具备一定普适性的参数调优建议。 | #### 使用示例 - 查看全量调优结果。 1 show 返回信息如下： 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: /opt/template/train/train-20250722-095736 [2025-07-22 02:07:16 UTC] [KAT] [message] - ================================================================================ - 查看指定轮次（第一轮次）数据。 1 show 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] - ================================================================================ 包含指定调优轮次使用全部参数详情。 - 查看性能前五的数据。 1 show 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: /opt/template/train/train-20250722-095736 [2025-07-22 02:10:22 UTC] [KAT] [message] - ================================================================================ - 查看参数重要性分析。 1 show 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] ------------------------------------------------------------------------------------------------------------- - 查看第一轮次和第三轮次的参数对比变化。 ``` show diff 1 3 ``` - “Round info diff”回显信息中可以查看第一轮次（115.750）、第三轮次（91.310）的性能值，以及之间的性能值差异（24.440）和差异比（26.77%）。 - “Parameter diff”回显信息中按照参数重要性排序，展示第一轮次、第三轮次之间参数值的差别。 show diff支持基线（Baseline）与训练轮次进行对比，例如“show diff 0 3”，表示查看基线参数值和第三轮次的参数值对比变化。 - 回显信息中基线参数值显示为“--”表示未获取到数据，可能是应用本身不支持获取基线参数值，或者查询命令填写有误导致的。 - 某些应用查询后基线参数的返回值为default或，在回显信息中会直接展示default或。 返回信息片段如下： ``` ================================================== 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(%) | Range ---------------------------------------------------------------------------------------------------------------------- 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 | | | | ---------------------------------------------------------------------------------------------------------------------- ```