【kibana】kibana访问ES常用命令

戒掉贪嗔痴(薛双奇)

于 2024-06-29 15:57:06 发布

阅读量124

点赞数

分类专栏：数据库运维-ElasticSearch-LK 文章标签： elasticsearch 大数据搜索引擎

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

版权

数据库运维-ElasticSearch-LK 专栏收录该内容

53 篇文章 0 订阅

订阅专栏

1.插入数据

curl -XPOST http://192.168.1.7:9201/myindex4/_doc/1 -H 'Content-Type: application/json' -d '
{
"id" : "1",
"name" : "sspuxsq001",
"city" : "深圳",
"course" : "oracle",
"teacher" : "da哥",
"pxdate": "20240629"
}'

2.使用Kibana 访问ES

--查询数据分布。
get /_cat/allocation
30  10.5mb 21.8gb 28.1gb 49.9gb 43 192.168.1.7 192.168.1.7 esdb-node-2
30 631.5kb 21.8gb 28.1gb 49.9gb 43 192.168.1.7 192.168.1.7 esdb-node-1
31    11mb 21.8gb 28.1gb 49.9gb 43 192.168.1.7 192.168.1.7 esdb-node-3
--查询分片
get /_cat/shards
xsq3                           3 p STARTED  2   6.8kb 192.168.1.7 esdb-node-2
xsq3                           3 r STARTED  2   6.8kb 192.168.1.7 esdb-node-1
xsq3                           4 p STARTED  1   6.5kb 192.168.1.7 esdb-node-3
xsq3                           4 r STARTED  1   6.5kb 192.168.1.7 esdb-node-2
xsq3                           1 r STARTED  1   6.6kb 192.168.1.7 esdb-node-2
xsq3                           1 p STARTED  1   6.6kb 192.168.1.7 esdb-node-1
xsq3                           2 p STARTED  1   6.7kb 192.168.1.7 esdb-node-3
xsq3                           2 r STARTED  1   6.7kb 192.168.1.7 esdb-node-2
xsq3                           0 r STARTED  3  12.5kb 192.168.1.7 esdb-node-3
xsq3                           0 p STARTED  3  12.5kb 192.168.1.7 esdb-node-1
--查询具体数据库的分片
get /_cat/shards/xsq3
xsq3 3 p STARTED 2  6.8kb 192.168.1.7 esdb-node-2
xsq3 3 r STARTED 2  6.8kb 192.168.1.7 esdb-node-1
xsq3 4 p STARTED 1  6.5kb 192.168.1.7 esdb-node-3
xsq3 4 r STARTED 1  6.5kb 192.168.1.7 esdb-node-2
xsq3 1 r STARTED 1  6.6kb 192.168.1.7 esdb-node-2
xsq3 1 p STARTED 1  6.6kb 192.168.1.7 esdb-node-1
xsq3 2 p STARTED 1  6.7kb 192.168.1.7 esdb-node-3
xsq3 2 r STARTED 1  6.7kb 192.168.1.7 esdb-node-2
xsq3 0 r STARTED 3 12.5kb 192.168.1.7 esdb-node-3
xsq3 0 p STARTED 3 12.5kb 192.168.1.7 esdb-node-1
--查询主节点
get /_cat/master
1M-5yVJyRHakKuwSYpXeNQ 192.168.1.7 192.168.1.7 esdb-node-3
--查询节点
get /_cat/nodes
192.168.1.7 49 64 15 0.63 0.94 0.53 dilmt - esdb-node-2
192.168.1.7 63 64 24 0.63 0.94 0.53 dilmt - esdb-node-1
192.168.1.7 46 64 28 0.63 0.94 0.53 dilmt * esdb-node-3

--查看所有数据库的状态，大小，分片。
get /_cat/indices
green open myindex10                      ADx7MMZYQDaVc5XX7LLgnA 3 2  0  0   1.8kb    624b
green open .kibana-event-log-7.9.2-000001 Cc8ZQFD1TSm4_MqVZMfw6w 1 1  1  0  11.2kb   5.6kb
green open xsq1                           QMMGLwzsTJ2kdPc6QGmPmQ 5 1  2  0  24.2kb  12.1kb
green open xsq3                           m_cSWmZaSaCErrrMBsNlHg 5 1  8  3  78.6kb  39.3kb
green open .apm-agent-configuration       igmjyuW5Q_mbop6YWvtQGg 1 1  0  0    416b    208b
green open sspuuser                       SuCFW8I7RfWDPtD0xhsXJQ 3 1 11  0  42.7kb  21.3kb
green open myindex14                      M3aWJAjGTSKR080PQW3fGA 1 1  0  0    462b    231b
green open .kibana_1                      oY_UDLIQT1a5FaqtpBwIoA 1 1 59  7  20.8mb  10.4mb
green open myindex15                      EJwz5QEyQqatU34YmfHDtQ 1 1  4  0  48.2kb  24.1kb
green open myindex2                       dZZjanvHSgCxlK_0k_ZWIQ 1 2  4  0  59.5kb  19.8kb
green open myindex3                       oq87SwCrSySVGiK4pKs2Ug 1 1  6  0  14.5kb   7.2kb
green open myindex4                       VleCrjTfQBOVdOU7Lp4MEw 1 1  1  0  13.5kb   6.7kb
green open sspu                           LSTmGxfsRSK7ZK2CJSEnRA 3 1  0  0   1.2kb    624b
green open myindex5                       _EGl89OrTLeTHE7gW4haAw 1 1  4  0  25.2kb  12.6kb
green open .apm-custom-link               1T8drih6SnC3JCnwzykKAw 1 1  0  0    416b    208b
green open .kibana_task_manager_1         sw3RTWrfTkqiknwApCDiQw 1 1  6 17 987.1kb 464.6kb
green open test_index2                    wkQWx7CbTuW_O65lS4dj3Q 1 1  1  3  16.6kb   8.3kb
green open myindex1                       -dECtDmXSe-y2rhAPFzqzA 1 1 11  0    17kb   8.5kb
green open xs1                            i9cWE3uXQkCjEFuIvnticw 1 1  1  0  11.3kb   5.6kb
green open shanghai                       yZayWlW2Q96v44FjNdv-dg 3 1  0  0   1.2kb    624b
green open test_index                     CLhMlvA_Qa60QHgjjsjnEg 1 1  1  0    12kb     6kb
green open mydb1                          oAAy6ofKS02WnVq2pwyzgw 3 2  1  0  18.6kb   6.2kb
green open itpuxuser                      WOwS2TvoQF63lK0LXBNGAQ 1 1  1  0  38.9kb  19.4kb

--查看具体某个数据库的大小，状态，分片。
get /_cat/indices/myindex4
green open myindex4 VleCrjTfQBOVdOU7Lp4MEw 1 1 1 0 13.5kb 6.7kb
--查询所有数据库的段。
get /_cat/segments
xsq1                           4 p 192.168.1.7 _0      0  1    0   5.3kb 2900 true  true  8.6.2 true
xsq1                           4 p 192.168.1.7 _1      1  1    0   5.3kb 2900 true  true  8.6.2 true
xsq1                           4 r 192.168.1.7 _0      0  1    0   5.3kb 2900 true  true  8.6.2 true
xsq1                           4 r 192.168.1.7 _1      1  1    0   5.3kb 2900 true  true  8.6.2 true
xsq3                           0 r 192.168.1.7 _0      0  3    1   9.1kb 3700 true  true  8.6.2 true
xsq3                           0 r 192.168.1.7 _1      1  0    1   2.9kb    0 true  false 8.6.2 true
xsq3                           0 p 192.168.1.7 _0      0  3    1   9.1kb 3700 true  true  8.6.2 true
xsq3                           0 p 192.168.1.7 _1      1  0    1   2.9kb    0 true  false 8.6.2 true
xsq3                           1 r 192.168.1.7 _0      0  1    0   6.2kb 3412 true  true  8.6.2 true
xsq3                           1 p 192.168.1.7 _0      0  1    0   6.2kb 3412 true  true  8.6.2 true
xsq3                           2 p 192.168.1.7 _2      2  1    2   6.4kb 3452 true  true  8.6.2 false
xsq3                           2 r 192.168.1.7 _2      2  1    2   6.4kb 3452 true  true  8.6.2 false
xsq3                           3 p 192.168.1.7 _0      0  2    0   6.4kb 3412 true  true  8.6.2 true
xsq3                           3 r 192.168.1.7 _0      0  2    0   6.4kb 3412 true  true  8.6.2 true
xsq3                           4 p 192.168.1.7 _0      0  1    0   6.1kb 3412 true  true  8.6.2 true
xsq3                           4 r 192.168.1.7 _0      0  1    0   6.1kb 3412 true  true  8.6.2 true
--查看某个数据库的段情况
get /_cat/segments/xsq3
xsq3 0 r 192.168.1.7 _0 0 3 1 9.1kb 3700 true true  8.6.2 true
xsq3 0 r 192.168.1.7 _1 1 0 1 2.9kb    0 true false 8.6.2 true
xsq3 0 p 192.168.1.7 _0 0 3 1 9.1kb 3700 true true  8.6.2 true
xsq3 0 p 192.168.1.7 _1 1 0 1 2.9kb    0 true false 8.6.2 true
xsq3 1 r 192.168.1.7 _0 0 1 0 6.2kb 3412 true true  8.6.2 true
xsq3 1 p 192.168.1.7 _0 0 1 0 6.2kb 3412 true true  8.6.2 true
xsq3 2 p 192.168.1.7 _2 2 1 2 6.4kb 3452 true true  8.6.2 false
xsq3 2 r 192.168.1.7 _2 2 1 2 6.4kb 3452 true true  8.6.2 false
xsq3 3 p 192.168.1.7 _0 0 2 0 6.4kb 3412 true true  8.6.2 true
xsq3 3 r 192.168.1.7 _0 0 2 0 6.4kb 3412 true true  8.6.2 true
xsq3 4 p 192.168.1.7 _0 0 1 0 6.1kb 3412 true true  8.6.2 true
xsq3 4 r 192.168.1.7 _0 0 1 0 6.1kb 3412 true true  8.6.2 true
--所有文档的条数
get /_cat/count
1719646485 07:34:45 122
--某个数据库文档的条数
get /_cat/count/xsq3
1719646525 07:35:25 8
--整个数据库的恢复状态。
get /_cat/recovery
xsq1 0 250ms peer           done 192.168.1.7 esdb-node-1 192.168.1.7 esdb-node-3 n/a n/a 1  1  100.0% 1  261      261      100.0% 261      0    0    100.0%
xsq1 0 173ms existing_store done n/a         n/a         192.168.1.7 esdb-node-1 n/a n/a 0  0  100.0% 1  0        0        100.0% 261      0    0    100.0%
xsq1 1 336ms peer           done 192.168.1.7 esdb-node-1 192.168.1.7 esdb-node-2 n/a n/a 1  1  100.0% 1  261      261      100.0% 261      0    0    100.0%
xsq1 1 117ms existing_store done n/a         n/a         192.168.1.7 esdb-node-1 n/a n/a 0  0  100.0% 1  0        0        100.0% 261      0    0    100.0%
xsq1 2 153ms existing_store done n/a         n/a         192.168.1.7 esdb-node-3 n/a n/a 0  0  100.0% 1  0        0        100.0% 261      0    0    100.0%
xsq1 2 833ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 1  1  100.0% 1  261      261      100.0% 261      0    0    100.0%
xsq1 3 770ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 1  1  100.0% 1  261      261      100.0% 261      0    0    100.0%
xsq1 3 709ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-1 n/a n/a 0  0  0.0%   0  0        0        0.0%   0        0    0    100.0%
xsq1 4 159ms existing_store done n/a         n/a         192.168.1.7 esdb-node-3 n/a n/a 0  0  100.0% 7  0        0        100.0% 11383    0    0    100.0%
xsq1 4 862ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 7  7  100.0% 7  11383    11383    100.0% 11383    0    0    100.0%
xsq3 0 664ms peer           done 192.168.1.7 esdb-node-1 192.168.1.7 esdb-node-3 n/a n/a 10 10 100.0% 10 12877    12877    100.0% 12877    0    0    100.0%
xsq3 0 167ms existing_store done n/a         n/a         192.168.1.7 esdb-node-1 n/a n/a 0  0  100.0% 10 0        0        100.0% 12877    0    0    100.0%
xsq3 1 231ms peer           done 192.168.1.7 esdb-node-1 192.168.1.7 esdb-node-2 n/a n/a 4  4  100.0% 4  6781     6781     100.0% 6781     0    0    100.0%
xsq3 1 97ms  existing_store done n/a         n/a         192.168.1.7 esdb-node-1 n/a n/a 0  0  100.0% 4  0        0        100.0% 6781     0    0    100.0%
xsq3 2 150ms existing_store done n/a         n/a         192.168.1.7 esdb-node-3 n/a n/a 0  0  100.0% 18 0        0        100.0% 6918     0    0    100.0%
xsq3 2 924ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 18 18 100.0% 18 6918     6918     100.0% 6918     0    0    100.0%
xsq3 3 298ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 4  4  100.0% 4  6979     6979     100.0% 6979     0    0    100.0%
xsq3 3 133ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-1 n/a n/a 0  0  0.0%   0  0        0        0.0%   0        0    0    100.0%
xsq3 4 147ms existing_store done n/a         n/a         192.168.1.7 esdb-node-3 n/a n/a 0  0  100.0% 4  0        0        100.0% 6689     0    0    100.0%
xsq3 4 739ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 4  4  100.0% 4  6689     6689     100.0% 6689     0    0    100.0%

--某个数据库具体的恢复状态。
get /_cat/recovery/xsq3
xsq3 0 664ms peer           done 192.168.1.7 esdb-node-1 192.168.1.7 esdb-node-3 n/a n/a 10 10 100.0% 10 12877 12877 100.0% 12877 0 0 100.0%
xsq3 0 167ms existing_store done n/a         n/a         192.168.1.7 esdb-node-1 n/a n/a 0  0  100.0% 10 0     0     100.0% 12877 0 0 100.0%
xsq3 1 231ms peer           done 192.168.1.7 esdb-node-1 192.168.1.7 esdb-node-2 n/a n/a 4  4  100.0% 4  6781  6781  100.0% 6781  0 0 100.0%
xsq3 1 97ms  existing_store done n/a         n/a         192.168.1.7 esdb-node-1 n/a n/a 0  0  100.0% 4  0     0     100.0% 6781  0 0 100.0%
xsq3 2 150ms existing_store done n/a         n/a         192.168.1.7 esdb-node-3 n/a n/a 0  0  100.0% 18 0     0     100.0% 6918  0 0 100.0%
xsq3 2 924ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 18 18 100.0% 18 6918  6918  100.0% 6918  0 0 100.0%
xsq3 3 298ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 4  4  100.0% 4  6979  6979  100.0% 6979  0 0 100.0%
xsq3 3 133ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-1 n/a n/a 0  0  0.0%   0  0     0     0.0%   0     0 0 100.0%
xsq3 4 147ms existing_store done n/a         n/a         192.168.1.7 esdb-node-3 n/a n/a 0  0  100.0% 4  0     0     100.0% 6689  0 0 100.0%
xsq3 4 739ms peer           done 192.168.1.7 esdb-node-3 192.168.1.7 esdb-node-2 n/a n/a 4  4  100.0% 4  6689  6689  100.0% 6689  0 0 100.0%
--健康状态查询
get /_cat/health
1719646664 07:37:44 escluster1 green 3 3 91 42 0 0 0 0 - 100.0%
--查询是否有任务。
get /_cat/pending_tasks 

--查看数据库别名
get /_cat/aliases
.kibana-event-log-7.9.2 .kibana-event-log-7.9.2-000001 - - - true
.kibana_task_manager    .kibana_task_manager_1         - - - -
.kibana                 .kibana_1                      - - - -
ilm-history-2           ilm-history-2-000001           - - - true

--查看某个数据库别名
get /_cat/aliases/.kibana
.kibana .kibana_1 - - - -
--查看线程池
get /_cat/thread_pool
esdb-node-2 analyze             0 0 0
esdb-node-2 ccr                 0 0 0
esdb-node-2 fetch_shard_started 0 0 0
esdb-node-2 fetch_shard_store   0 0 0
esdb-node-2 flush               0 0 0
esdb-node-2 force_merge         0 0 0
esdb-node-2 generic             0 0 0
esdb-node-2 get                 0 0 0
esdb-node-2 listener            0 0 0
esdb-node-2 management          1 0 0
esdb-node-2 ml_datafeed         0 0 0
esdb-node-2 ml_job_comms        0 0 0
esdb-node-2 ml_utility          0 0 0
esdb-node-2 refresh             0 0 0
esdb-node-2 rollup_indexing     0 0 0
esdb-node-2 search              0 0 0
esdb-node-2 search_throttled    0 0 0
esdb-node-2 security-crypto     0 0 0
esdb-node-2 security-token-key  0 0 0
esdb-node-2 snapshot            0 0 0
esdb-node-2 transform_indexing  0 0 0
esdb-node-2 warmer              0 0 0
esdb-node-2 watcher             0 0 0
esdb-node-2 write               0 0 0
esdb-node-1 analyze             0 0 0
esdb-node-1 ccr                 0 0 0
esdb-node-1 fetch_shard_started 0 0 0
esdb-node-1 fetch_shard_store   0 0 0
esdb-node-1 flush               0 0 0
esdb-node-1 force_merge         0 0 0
esdb-node-1 generic             0 0 0
esdb-node-1 get                 0 0 0
esdb-node-1 listener            0 0 0
esdb-node-1 management          1 0 0
esdb-node-1 ml_datafeed         0 0 0
esdb-node-1 ml_job_comms        0 0 0
esdb-node-1 ml_utility          0 0 0
esdb-node-1 refresh             0 0 0
esdb-node-1 rollup_indexing     0 0 0
esdb-node-1 search              0 0 0
esdb-node-1 search_throttled    0 0 0
esdb-node-1 security-crypto     0 0 0
esdb-node-1 security-token-key  0 0 0
esdb-node-1 snapshot            0 0 0
esdb-node-1 transform_indexing  0 0 0
esdb-node-1 warmer              0 0 0
esdb-node-1 watcher             0 0 0
esdb-node-1 write               0 0 0
esdb-node-3 analyze             0 0 0
esdb-node-3 ccr                 0 0 0
esdb-node-3 fetch_shard_started 0 0 0
esdb-node-3 fetch_shard_store   0 0 0
esdb-node-3 flush               0 0 0
esdb-node-3 force_merge         0 0 0
esdb-node-3 generic             0 0 0
esdb-node-3 get                 0 0 0
esdb-node-3 listener            0 0 0
esdb-node-3 management          1 0 0
esdb-node-3 ml_datafeed         0 0 0
esdb-node-3 ml_job_comms        0 0 0
esdb-node-3 ml_utility          0 0 0
esdb-node-3 refresh             0 0 0
esdb-node-3 rollup_indexing     0 0 0
esdb-node-3 search              0 0 0
esdb-node-3 search_throttled    0 0 0
esdb-node-3 security-crypto     0 0 0
esdb-node-3 security-token-key  0 0 0
esdb-node-3 snapshot            0 0 0
esdb-node-3 transform_indexing  0 0 0
esdb-node-3 warmer              0 0 0
esdb-node-3 watcher             0 0 0
esdb-node-3 write               0 0 0

--查看插件
get /_cat/plugins
--查看字段信息
get /_cat/fielddata
--查看某个具体的字段。
get /_cat/fielddata/{fields}