IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
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;" } }