es-03 优化

来源：互联网发布：微信公众平台跳转淘宝编辑：程序博客网时间：2024/05/22 01:28

优化1-filter

GET /xxxx/_search{  "size":0,  "query": {    "bool": {      "filter": {        "term": {          "beat.hostname": "supervisor42"        }      },       "should": [        {          "bool": {          "filter": {            "term": {              "metricset.name": "cpu"            }          }        }        },{          "bool": {          "filter": {            "term": {              "metricset.name": "memory"            }          }        }        }      ]    }  },  "aggs": {      "time":{       "date_histogram":{          "field":"@timestamp",          "interval":"60s"        },        "aggs": {          "avg_cpu": {            "avg": {"field": "system.cpu.idle.pct"}          },"avg_mem": {            "avg": {"field": "system.memory.free"}          }        }      }    }}

GET /xxxx/_search{  "size":0,  "query": {    "bool": {      "filter": {        "bool": {          "must":[{             "term": {                "beat.hostname": "supervisor42"              }          }],          "should": [{                "term": {                  "metricset.name": "cpu"                }            },{                "term": {                  "metricset.name": "memory"                }            }]        }      }    }  },  "aggs": {      "time":{       "date_histogram":{          "field":"@timestamp",          "interval":"60s"        },        "aggs": {          "avg_cpu": {            "avg": {"field": "system.cpu.idle.pct"}          },"avg_mem": {            "avg": {"field": "system.memory.free"}          }        }      }    }}

阅读全文

0 0