kibana 开发工具介绍

kibana上查看es集群节点信息

get /_cat/nodes?v 
 
ip        heap.percent ram.percent cpu load_1m load_5m load_15m node.role master name
127.0.0.1           23          97   1    0.07    0.04     0.05 mdi       *      ES

　　查看kibana_sample_data_ecommerce索引的相关信息

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

GET kibana_sample_data_ecommerce
 
 
{
  "kibana_sample_data_ecommerce" : {
    "aliases" : { },
    "mappings" : {
      "properties" : {
        "category" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword"
            }
          }
        },
        "currency" : {
          "type" : "keyword"
        },
        "customer_birth_date" : {
          "type" : "date"
        },
        "customer_first_name" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "customer_full_name" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "customer_gender" : {
          "type" : "keyword"
        },
        "customer_id" : {
          "type" : "keyword"
        },
        "customer_last_name" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "customer_phone" : {
          "type" : "keyword"
        },
        "day_of_week" : {
          "type" : "keyword"
        },
        "day_of_week_i" : {
          "type" : "integer"
        },
        "email" : {
          "type" : "keyword"
        },
        "geoip" : {
          "properties" : {
            "city_name" : {
              "type" : "keyword"
            },
            "continent_name" : {
              "type" : "keyword"
            },
            "country_iso_code" : {
              "type" : "keyword"
            },
            "location" : {
              "type" : "geo_point"
            },
            "region_name" : {
              "type" : "keyword"
            }
          }
        },
        "manufacturer" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword"
            }
          }
        },
        "order_date" : {
          "type" : "date"
        },
        "order_id" : {
          "type" : "keyword"
        },
        "products" : {
          "properties" : {
            "_id" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            },
            "base_price" : {
              "type" : "half_float"
            },
            "base_unit_price" : {
              "type" : "half_float"
            },
            "category" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword"
                }
              }
            },
            "created_on" : {
              "type" : "date"
            },
            "discount_amount" : {
              "type" : "half_float"
            },
            "discount_percentage" : {
              "type" : "half_float"
            },
            "manufacturer" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword"
                }
              }
            },
            "min_price" : {
              "type" : "half_float"
            },
            "price" : {
              "type" : "half_float"
            },
            "product_id" : {
              "type" : "long"
            },
            "product_name" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword"
                }
              },
              "analyzer" : "english"
            },
            "quantity" : {
              "type" : "integer"
            },
            "sku" : {
              "type" : "keyword"
            },
            "tax_amount" : {
              "type" : "half_float"
            },
            "taxful_price" : {
              "type" : "half_float"
            },
            "taxless_price" : {
              "type" : "half_float"
            },
            "unit_discount_amount" : {
              "type" : "half_float"
            }
          }
        },
        "sku" : {
          "type" : "keyword"
        },
        "taxful_total_price" : {
          "type" : "half_float"
        },
        "taxless_total_price" : {
          "type" : "half_float"
        },
        "total_quantity" : {
          "type" : "integer"
        },
        "total_unique_products" : {
          "type" : "integer"
        },
        "type" : {
          "type" : "keyword"
        },
        "user" : {
          "type" : "keyword"
        }
      }
    },
    "settings" : {
      "index" : {
        "number_of_shards" : "1",
        "auto_expand_replicas" : "0-1",
        "provided_name" : "kibana_sample_data_ecommerce",
        "creation_date" : "1573016765747",
        "number_of_replicas" : "0",
        "uuid" : "O7wX0YeWRxuniFTLuDWJfA",
        "version" : {
          "created" : "7010099"
        }
      }
    }
  }
}

　　查看kibana_sample_data_ecommerce索引文档总数

GET kibana_sample_data_ecommerce/_count
 
{
  "count" : 4675,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
   
}

　　查看kibana_sample_data_ecommerce索引的前10条文档；了解文档格式

1	`GET kibana_sample_data_ecommerce/_search`

　　对索引名字（kibana）进行通配符的查询

GET /_cat/indices/kibana*?v&s=index
 
 
health status index                        uuid                   pri rep docs.count docs.deleted store.size pri.store.size
green  open   kibana_sample_data_ecommerce O7wX0YeWRxuniFTLuDWJfA   1   0       475            0      5.1mb          5.1mb
green  open   kibana_sample_data_flights   YnASLIEoROG6b7mFnnx2DQ   1   0      13059            0      6.3mb          6.3mb
green  open   kibana_sample_data_logs      TUmwnhpKSkSAKfXptgNY4A   1   0      14005            0     11.2mb         11.2mb

　　查看状态为绿色的索引

GET /_cat/indices?v&health=green
 
 
health status index                        uuid                   pri rep docs.count docs.deleted store.size pri.store.size
green  open   .kibana_task_manager         urh_dFyVTnuweARB0GvYdw   1   0          2            9     25.1kb         25.1kb
green  open   kibana_sample_data_logs      TUmwnhpKSkSAKfXptgNY4A   1   0      14005            0     11.2mb         11.2mb
green  open   .kibana_1                    lIWHe_2HT3ujqHcWG-Vt3w   1   0        140            0        1mb            1mb
green  open   kibana_sample_data_ecommerce O7wX0YeWRxuniFTLuDWJfA   1   0       4675            0      5.1mb          5.1mb
green  open   kibana_sample_data_flights   YnASLIEoROG6b7mFnnx2DQ   1   0      13059            0      6.3mb          6.3mb

　　按照文档的个数进行索引排序

GET /_cat/indices?v&s=docs.count:desc
 
 
 
 
health status index                        uuid                   pri rep docs.count docs.deleted store.size pri.store.size
green  open   kibana_sample_data_logs      TUmwnhpKSkSAKfXptgNY4A   1   0      14005            0     11.2mb         11.2mb
green  open   kibana_sample_data_flights   YnASLIEoROG6b7mFnnx2DQ   1   0      13059            0      6.3mb          6.3mb
yellow open   movies                       _S2PT287T_aP0QN1S1GvAw   1   1       9743            0      1.3mb          1.3mb
green  open   kibana_sample_data_ecommerce O7wX0YeWRxuniFTLuDWJfA   1   0       4675            0      5.1mb          5.1mb
green  open   .kibana_1                    lIWHe_2HT3ujqHcWG-Vt3w   1   0        140            0        1mb            1mb
green  open   .kibana_task_manager         urh_dFyVTnuweARB0GvYdw   1   0          2            9     25.1kb         25.1kb

　　查看以kibana开头索引的health,index,pri,rep,docs,count,mt字段

GET /_cat/indices/kibana*?pri&v&h=health,index,pri,rep,docs,count,mt
 
 
health index                        pri rep mt pri.mt
green  kibana_sample_data_flights     1   0  1      1
green  kibana_sample_data_ecommerce   1   0  0      0
green  kibana_sample_data_logs        1   0  1      1

　　查看每条索引占得空间

GET /_cat/indices?v&h=i,tm&s=tm:desc
 
i                                 tm
kibana_sample_data_ecommerce 161.8kb
kibana_sample_data_logs       54.6kb
.kibana_1                     47.5kb
kibana_sample_data_flights    37.7kb
movies                        25.1kb
.kibana_task_manager           4.4kb

　　查看集群状态

GET /_cluster/health
 
 
{
  "cluster_name" : "elasticsearch",
  "status" : "yellow",
  "timed_out" : false,
  "number_of_nodes" : 1,
  "number_of_data_nodes" : 1,
  "active_primary_shards" : 6,
  "active_shards" : 6,
  "relocating_shards" : 0,
  "initializing_shards" : 0,
  "unassigned_shards" : 1,
  "delayed_unassigned_shards" : 0,
  "number_of_pending_tasks" : 0,
  "number_of_in_flight_fetch" : 0,
  "task_max_waiting_in_queue_millis" : 0,
  "active_shards_percent_as_number" : 85.71428571428571
}

　　查看集群分片信息

GET /_cat/shards
 
 
 
.kibana_task_manager         0 p STARTED        2 25.1kb 127.0.0.1 ES
movies                       0 p STARTED     9743  1.3mb 127.0.0.1 ES
movies                       0 r UNASSIGNED                        
kibana_sample_data_ecommerce 0 p STARTED     4675  5.1mb 127.0.0.1 ES
.kibana_1                    0 p STARTED      140    1mb 127.0.0.1 ES
kibana_sample_data_flights   0 p STARTED    13059  6.3mb 127.0.0.1 ES
kibana_sample_data_logs      0 p STARTED    14005 11.2mb 127.0.0.1 ES

　　自动生成文档的ID

POST chenxij/_doc
{
  "user":"kk",
    "data":"902",
    "message":"tgfd"
}
 
 
{
  "_index" : "chenxi",
  "_type" : "_doc",
  "_id" : "UnaqP24B9uEN4vPi-rFS",
  "_version" : 1,
  "result" : "created",
  "_shards" : {
    "total" : 2,
    "successful" : 1,
    "failed" : 0
  },
  "_seq_no" : 3,
  "_primary_term" : 1
}

　　指定ID如果ID存在就报错

POST cx/_doc/1?op_type=create
{
  "trc":"kk",
    "hjj":"665",
    "qwsx":"ugfd"
}
 
 
 
{
  "error": {
    "root_cause": [
      {
        "type": "version_conflict_engine_exception",
        "reason": "[1]: version conflict, document already exists (current version [1])",
        "index_uuid": "g-E8rbQoSomDGTtk3uYbmw",
        "shard": "0",
        "index": "cx"
      }
    ],
    "type": "version_conflict_engine_exception",
    "reason": "[1]: version conflict, document already exists (current version [1])",
    "index_uuid": "g-E8rbQoSomDGTtk3uYbmw",
    "shard": "0",
    "index": "cx"
  },
  "status": 409
}

　　查看文档

GET chenxi/_doc/1
 
 
 
{
  "_index" : "chenxi",
  "_type" : "_doc",
  "_id" : "1",
  "found" : false
}

　　更新文档添加字段

POST cx/_update/1/
{
  "doc":{
       "cgfd":"tgfgygy",
       "ertyui":"rtyu"
    }
}
 
 
{
  "_index" : "cx",
  "_type" : "_doc",
  "_id" : "1",
  "_version" : 2,
  "result" : "noop",
  "_shards" : {
    "total" : 0,
    "successful" : 0,
    "failed" : 0
  }
}

　　查看更新后的文档

GET cx/_doc/1
 
 
 
 
{
  "_index" : "cx",
  "_type" : "_doc",
  "_id" : "1",
  "_version" : 2,
  "_seq_no" : 4,
  "_primary_term" : 1,
  "found" : true,
  "_source" : {
    "trc" : "kk",
    "hjj" : "665",
    "qwsx" : "ugfd",
    "ertyui" : "rtyu",
    "cgfd" : "tgfgygy"
  }
}