SQL query metricset
editSQL query metricset
editThe sql query metricset collects rows returned by a query.
Field names (columns) are returned as lowercase strings. Values are returned as numeric or string.
For a description of each field in the metricset, see the exported fields section.
Here is an example document generated by this metricset:
{
"@timestamp": "2017-10-12T08:05:34.853Z",
"event": {
"dataset": "sql.query",
"duration": 115000,
"module": "sql"
},
"metricset": {
"name": "query",
"period": 10000
},
"service": {
"address": "localhost:65194",
"type": "sql"
},
"sql": {
"driver": "mysql",
"metrics": {
"engine": "InnoDB",
"table_name": "db",
"table_rows": 2,
"table_schema": "mysql"
},
"query": "select table_schema, table_name, engine, table_rows from information_schema.tables where table_rows \u003e 0;"
}
}