Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

show

Command Function

Displays the existing tuning data, which can be overall data or data of a specified round, and analyzes parameter importance.

Syntax

1
show [-h] {round,top,importance,diff,suggestion} ...

Parameter Description

Table 1 show subcommand parameters

Parameter

Option

Description

-h/--help

-

Displays the help information about the show subcommand. This parameter is optional.

round

-

Displays information about a specified round. This parameter is optional.

top

-

Displays the performance data of the first N rounds in descending order. This parameter is optional.

importance

-

Analyzes the importance of global parameters. This parameter is optional.

NOTE:

You can set this parameter to find what parameters can improve performance during multiple rounds of tuning. In the command output, a higher value in the importance(%) column indicates stronger correlation between the parameter and the tuning effect.

diff

-

Displays the changes of parameters in different rounds. This parameter is optional.

NOTE:

If there is only one valid training round and the diff parameter is used, the Parameter diff command output shows only the valid content from that round.

suggestion

-

Performs internal tests and evaluation on parameters at different levels in some application scenarios and provides universal parameter tuning suggestions. This parameter is optional.

Example

  • Displaying the full tuning result
    1
    show

    Command output:

     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] - ================================================================================
  • Displaying the data of a specified round (the first round).
    1
    show round 1

    Command output:

     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] - ================================================================================

    The command output contains details about all parameters used in a specified tuning round.

  • Displaying the data of the top five rounds by performance
    1
    show top 5

    Command output:

     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] - ================================================================================
  • Displaying the parameter importance analysis information
    1
    show importance

    Command output:

     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] 
-------------------------------------------------------------------------------------------------------------
  • Displaying the parameter comparison between the first and third rounds
    1
    show diff 1 3
    • In the Round info diff command output, you can view the performance values of the first round (115.750) and third round (91.310), the performance value difference (24.440), and the difference ratio (26.77%).
    • In the Parameter diff command output, parameters are sorted by importance. You can view the parameter value differences between the first and third rounds.

    show diff supports comparison between the baseline and the training rounds. For example, show diff 0 3 compares the baseline parameter values with those from the third training round.

    • If the baseline parameter value in the command output is --, no data has been collected. This may be because the application does not support obtaining the baseline parameter or the command was entered incorrectly.
    • For some applications, the baseline parameter may return default or <undefined>. The value is displayed directly in the command output.

    Command output:

     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(%) |       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         |                   |                   |               |                    
----------------------------------------------------------------------------------------------------------------------