clickhouse 查询优化_clickhouse查询耗时30多秒还有优化的地方？

@kikanjuu [CLICK_DB_AGGR_NEW_APP_IP_TCP]=

{

.time_interval = 3600 * 24,

.data_save_time = 3600 * 24 * 90,

.table_name = “aggr_log_app_ip_tcp”,

.create_db_table = “create table if not exists aggr_log_app_ip_tcp(

link_id UInt8,

vlink_id UInt8,

src_ip UInt32,

dst_ip UInt32,

byte_up UInt64,

byte_down UInt64,

pkt_up UInt64,

pkt_down UInt64,

multicast_pkt_num UInt64,

broadcast_pkt_num UInt64,

tcp_syn_num UInt64,

tcp_syn_ack_num UInt64,

ave_rtt_up Double,

ave_rtt_down Double,

tcp_rst_up UInt64,

tcp_rst_down UInt64,

tcp_retrans_up UInt64,

tcp_retrans_down UInt64,

tcp_0win_up UInt64,

tcp_0win_down UInt64,

app_delay Double,

session_num UInt64,

start_time UInt32,

create_time