Count documents in indexes
Counts documents across one or more indexes or aliases using the Elasticsearch query DSL. Use the Index parameter to target a single index or alias, multiple indexes/aliases, or all indexes (with *). Optionally supply a query expression to count only matching documents; see the Elasticsearch query DSL documentation for query syntax.
SELECT * FROM count WITH(Index='MyIndexOrAliasName') -- get count of documents in index / alias named MyIndexOrAliasName
SELECT * FROM count WITH(Index='*') -- get count of documents in all indices (total distinct _id found across all indices + alias)
SELECT * FROM count WITH(Index='MyIndex1,MyIndex2,MyAlias1,MyAlias2') -- get count of documents in indices named MyIndex1, MyIndex2 and alias named MyAlias1, MyAlias2
SELECT * FROM count WITH(Index='MyIndexOrAliasName', Query='{"match": { "comment" : "TV" } }') -- get count of documents in MyIndex where comment field contains word "TV"