【elasticsearch】ES的其他常见的查询项目-CSDN博客

本文链接：https://blog.csdn.net/weixin_43346403/article/details/140010409

1.查看所有的索引

curl -X GET http://192.168.1.7:9201/_cat/indices?v 
[esadmin@oracle1 translog]$ curl -X GET http://192.168.1.7:9201/_cat/indices?v 
health status index uuid                   pri rep docs.count docs.deleted store.size pri.store.size
green  open   mydb2 eks_TgK5S1-VMF6Xi7IIyw  10   2          2            0     47.4kb         15.8kb
green  open   mydb3 ExaHrWExSGOqbPFG4TaAFQ   3   1          2            0       23kb         11.5kb
green  open   mydb1 R8ovegjBS7i44hlbOA-PUQ   1   1          2            0     26.8kb         13.4kb

2.查看单个索引的分片和副本数

curl -X GET "192.168.1.7:9201/mydb1/_settings?pretty"
curl -X GET "192.168.1.7:9201/mydb2/_settings?pretty"
curl -X GET "192.168.1.7:9201/mydb3/_settings?pretty"

[esadmin@oracle1 translog]$ curl -X GET "192.168.1.7:9201/mydb1/_settings?pretty"
{
  "mydb1" : {
    "settings" : {
      "index" : {
        "creation_date" : "1719458160315",
        "number_of_shards" : "1",
        "number_of_replicas" : "1",
        "uuid" : "R8ovegjBS7i44hlbOA-PUQ",
        "version" : {
          "created" : "7090199"
        },
        "provided_name" : "mydb1"
      }
    }
  }
}
[esadmin@oracle1 translog]$ 
[esadmin@oracle1 translog]$ curl -X GET "192.168.1.7:9201/mydb2/_settings?pretty"
{
  "mydb2" : {
    "settings" : {
      "index" : {
        "creation_date" : "1719459642529",
        "number_of_shards" : "10",
        "number_of_replicas" : "2",
        "uuid" : "eks_TgK5S1-VMF6Xi7IIyw",
        "version" : {
          "created" : "7090199"
        },
        "provided_name" : "mydb2"
      }
    }
  }
}
[esadmin@oracle1 translog]$ curl -X GET "192.168.1.7:9201/mydb3/_settings?pretty"
{
  "mydb3" : {
    "settings" : {
      "index" : {
        "creation_date" : "1719460463245",
        "number_of_shards" : "3",
        "number_of_replicas" : "1",
        "uuid" : "ExaHrWExSGOqbPFG4TaAFQ",
        "version" : {
          "created" : "7090199"
        },
        "provided_name" : "mydb3"
      }
    }
  }
}

3.查看整个集群副本

curl http://192.168.1.7:9201/_cat/shards?v
[esadmin@oracle1 translog]$ curl http://192.168.1.7:9201/_cat/shards?v
index shard prirep state   docs  store ip          node
mydb2 6     r      STARTED    1  7.1kb 192.168.1.7 esdb-node-3
mydb2 6     p      STARTED    1    7kb 192.168.1.7 esdb-node-2
mydb2 6     r      STARTED    1  7.1kb 192.168.1.7 esdb-node-1
mydb2 5     r      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 5     r      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 5     p      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 2     r      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 2     r      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 2     p      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 7     p      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 7     r      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 7     r      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 3     r      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 3     p      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 3     r      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 8     r      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 8     r      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 8     p      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 1     p      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 1     r      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 1     r      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 9     r      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 9     p      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 9     r      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb2 4     p      STARTED    1    7kb 192.168.1.7 esdb-node-3
mydb2 4     r      STARTED    1    7kb 192.168.1.7 esdb-node-2
mydb2 4     r      STARTED    1    7kb 192.168.1.7 esdb-node-1
mydb2 0     r      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb2 0     p      STARTED    0   208b 192.168.1.7 esdb-node-2
mydb2 0     r      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb3 2     r      STARTED    1  5.6kb 192.168.1.7 esdb-node-2
mydb3 2     p      STARTED    1  5.6kb 192.168.1.7 esdb-node-1
mydb3 1     p      STARTED    0   208b 192.168.1.7 esdb-node-3
mydb3 1     r      STARTED    0   208b 192.168.1.7 esdb-node-1
mydb3 0     r      STARTED    1  5.6kb 192.168.1.7 esdb-node-3
mydb3 0     p      STARTED    1  5.6kb 192.168.1.7 esdb-node-2
mydb1 0     p      STARTED    2 13.4kb 192.168.1.7 esdb-node-3
mydb1 0     r      STARTED    2 13.4kb 192.168.1.7 esdb-node-1

4.查看单个数据库的分片

curl http://192.168.1.7:9201/mydb1/_search_shards?pretty
[esadmin@oracle1 translog]$ curl http://192.168.1.7:9201/mydb2/_search_shards?pretty
{
  "nodes" : {
    "1M-5yVJyRHakKuwSYpXeNQ" : {
      "name" : "esdb-node-3",
      "ephemeral_id" : "qkYJO8DqRlKGc_VW3kSouw",
      "transport_address" : "192.168.1.7:9303",
      "attributes" : {
        "ml.machine_memory" : "8181784576",
        "ml.max_open_jobs" : "20",
        "xpack.installed" : "true",
        "transform.node" : "true"
      }
    },
    "8bkDoRrrTdyikEJ6mEOKsA" : {
      "name" : "esdb-node-2",
      "ephemeral_id" : "jJyhWE4PTcWP3Nk6Ypsnxw",
      "transport_address" : "192.168.1.7:9302",
      "attributes" : {
        "ml.machine_memory" : "8181784576",
        "ml.max_open_jobs" : "20",
        "xpack.installed" : "true",
        "transform.node" : "true"
      }
    },
    "rVIh8-d2SmKscxM5zlgqfA" : {
      "name" : "esdb-node-1",
      "ephemeral_id" : "wC3Kpkk_S7-85NeWDGPihg",
      "transport_address" : "192.168.1.7:9301",
      "attributes" : {
        "ml.machine_memory" : "8181784576",
        "xpack.installed" : "true",
        "transform.node" : "true",
        "ml.max_open_jobs" : "20"
      }
    }
  },
  "indices" : {
    "mydb2" : { }
  },
  "shards" : [
    [
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 0,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "V8dDIFfGTsaU-FMYuTY3Fg"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 0,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "Nm5yksnXRkiFRGIEveCeTw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 0,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "tNmWx-1bSfyN_Kja3y6kiQ"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 1,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "rtceaoRQRM6WtsIiLYkz0A"
        }
      },
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 1,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "f2hHyL28S5K3XEgru5ydkA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 1,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "RxAeDvUgS6aVY8Z2l4VRRQ"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 2,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "ib2QnSaiTNuCLLDiFaJnTA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 2,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "BRWJToZXQ2ucYx0vIl5Clw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 2,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "WDcNOtzSSjW2iSoaJKMlgQ"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 3,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "S99FU-XJSBaDe5Q5KUY_1w"
        }
      },
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 3,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "3QgHZ6d4TZyihLFlPpBerw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 3,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "9WbB7YjWTJ-EDEhYG5XxAg"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 4,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "hxGlMIRbQqqRWgjnx857kA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 4,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "Hmhh1yKrTBGNVi8sU5H5iw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 4,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "r9k170TQQ-uWiEuHDpnRrw"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 5,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "vPczw_9iQS2HkQpacozyFw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 5,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "Rz_A63dASySQ-_B4WmGCQw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 5,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "srSrRO2jSEiQXHqwsG-0wg"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 6,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "GGhrRQ47RXaz8NCXdLNjBA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 6,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "DLI730WDQIaZugMvMFimSA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 6,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "iw-5nzo3QGW4tfhd0wVe3Q"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 7,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "5Xxjliu8QKiUqb6n-AuRLg"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 7,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "g18oAgjjQN-RsMzKyrADJA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 7,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "PCZdrbkaTA251OjESqqe0Q"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 8,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "nBsIuKNkT3Se7721Tx04Bw"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 8,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "g-ievn2_RROWKFTLNa7X8A"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 8,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "Tr4tOTGMTkGz-ycSHkBOxA"
        }
      }
    ],
    [
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "rVIh8-d2SmKscxM5zlgqfA",
        "relocating_node" : null,
        "shard" : 9,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "IjSH0BUbST-en0tCakBLVQ"
        }
      },
      {
        "state" : "STARTED",
        "primary" : false,
        "node" : "1M-5yVJyRHakKuwSYpXeNQ",
        "relocating_node" : null,
        "shard" : 9,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "ay6z-YfNQd2ekNSegqgEYA"
        }
      },
      {
        "state" : "STARTED",
        "primary" : true,
        "node" : "8bkDoRrrTdyikEJ6mEOKsA",
        "relocating_node" : null,
        "shard" : 9,
        "index" : "mydb2",
        "allocation_id" : {
          "id" : "nuO5YbJFTdKXlx0db2l_0A"
        }
      }
    ]
  ]
}

5.将数据推送到指定数据库，指定文档编号。

curl -XPOST http://192.168.1.7:9201/mydb2/_doc/6/?pretty -H 'Content-Type: application/json' -d '{
"id" : "6",
"name" : "xsq006",
"city" : "广州",
"course" : "oracle",
"teacher" : "mazi",
"pxdate": "20240627"
}'
{
  "_index" : "mydb2",
  "_type" : "_doc",
  "_id" : "6",
  "_version" : 1,
  "result" : "created",
  "_shards" : {
    "total" : 3,
    "successful" : 3,
    "failed" : 0
  },
  "_seq_no" : 0,
  "_primary_term" : 1
}

6.健康状态查看

[esadmin@oracle1 translog]$ curl http://192.168.1.7:9203/_cat/health?pretty -H 'Content-Type: application/json'
1719461975 04:19:35 escluster1 green 3 3 38 14 0 0 0 0 - 100.0%

7.es集群节点主备情况查询

[esadmin@oracle1 translog]$ curl http://192.168.1.7:9201/_cat/nodes
192.168.1.7 32 86 2 0.13 0.06 0.10 dilmt * esdb-node-1
192.168.1.7 36 86 2 0.13 0.06 0.10 dilmt - esdb-node-2
192.168.1.7 58 86 2 0.13 0.06 0.10 dilmt - esdb-node-3

8.总结

(1)查看集群健康状态
(2)主备节点观察
(3)所有的数据库的查看
(4)单个数据库的分片情况
(5)单个数据库的分片和副本情况查看
(6)所有数据库的分片和副本查看
(7)推送文档到指定数据库的指定文档ID;