Elasticsearch input plugin
Stack
- Plugin version: v5.2.0 (Other versions)
- Released on: 2025-06-06
- Changelog
For questions about the plugin, open a topic in theDiscuss forums. For bugs or feature requests, open an issue inGithub. For the list of Elastic supported plugins, please consult theElastic Support Matrix.
Read from an Elasticsearch cluster, based on search query results. This is useful for replaying test logs, reindexing, etc. You can periodically schedule ingestion using a cron syntax (seeschedule setting) or run the query one time to load data into Logstash.
Example:
input { # Read all documents from Elasticsearch matching the given query elasticsearch { hosts => "localhost" query => '{ "query": { "match": { "statuscode": 200 } }, "sort": [ "_doc" ] }' }}This would create an Elasticsearch query with the following format:
curl 'http://localhost:9200/logstash-*/_search?&scroll=1m&size=1000' -d '{ "query": { "match": { "statuscode": 200 } }, "sort": [ "_doc" ]}'Input from this plugin can be scheduled to run periodically according to a specific schedule. This scheduling syntax is powered byrufus-scheduler. The syntax is cron-like with some extensions specific to Rufus (e.g. timezone support ).
Examples:
* 5 * 1-3 * | will execute every minute of 5am every day of January through March. |
0 * * * * | will execute on the 0th minute of every hour every day. |
0 6 * * * America/Chicago | will execute at 6:00am (UTC/GMT -5) every day. |
Further documentation describing this syntax can be foundhere.
Authentication to a secure Elasticsearch cluster is possible usingone of the following options:
Authorization to a secure Elasticsearch cluster requiresread permission at index level andmonitoring permissions at cluster level. Themonitoring permission at cluster level is necessary to perform periodic connectivity checks.
When ECS compatibility is disabled,docinfo_target uses the"@metadata" field as a default, with ECS enabled the plugin uses a naming convention"[@metadata][input][elasticsearch]" as a default target for placing document information.
The plugin logs a warning when ECS is enabled andtarget isn’t set.
Set thetarget option to avoid potential schema conflicts.
When this input plugin cannot create a structuredEvent from a hit result, it will instead create anEvent that is tagged with_elasticsearch_input_failure whose[event][original] is a JSON-encoded string representation of the entire hit.
Common causes are:
- When the hit result contains top-level fields that arereserved in Logstash but do not have the expected shape. Use the
targetdirective to avoid conflicts with the top-level namespace. - When
docinfois enabled and the docinfo fields cannot be merged into the hit result. Combinetargetanddocinfo_targetto avoid conflict.
Technical Preview: Tracking a field’s value
The feature that allows tracking a field’s value across runs is inTechnical Preview. Configuration options and implementation details are subject to change in minor releases without being preceded by deprecation warnings.
Some uses cases require tracking the value of a particular field between two jobs. Examples include:
- avoiding the need to re-process the entire result set of a long query after an unplanned restart
- grabbing only new data from an index instead of processing the entire set on each job.
The Elasticsearch input plugin provides thetracking_field andtracking_field_seed options. Whentracking_field is set, the plugin records the value of that field for the last document retrieved in a run into a file. (The file location defaults tolast_run_metadata_path.)
You can then inject this value in the query using the placeholder:last_value. The value will be injected into the query before execution, and then updated after the query completes if new data was found.
This feature works best when:
- the query sorts by the tracking field,
- the timestamp field is added by Elasticsearch, and
- the field type has enough resolution so that two events are unlikely to have the same value.
Consider using a tracking field whose type isdate nanoseconds. If the tracking field is of this data type, you can use an extra placeholder called:present to inject the nano-second based value of "now-30s". This placeholder is useful as the right-hand side of a range filter, allowing the collection of new data but leaving partially-searchable bulk request data to the next scheduled job.
This section contains a series of steps to help you set up the "tailing" of data being written to a set of indices, using a date nanosecond field added by an Elasticsearch ingest pipeline and thetracking_field capability of this plugin.
Create ingest pipeline that adds Elasticsearch’s
_ingest.timestampfield to the documents asevent.ingested:PUT _ingest/pipeline/my-pipeline{ "processors": [ { "script": { "lang": "painless", "source": "ctx.putIfAbsent(\"event\", [:]); ctx.event.ingested = metadata().now.format(DateTimeFormatter.ISO_INSTANT);" } } ]}
Create an index mapping where the tracking field is of date nanosecond type and invokes the defined pipeline:
PUT /_template/my_template{ "index_patterns": ["test-*"], "settings": { "index.default_pipeline": "my-pipeline", }, "mappings": { "properties": { "event": { "properties": { "ingested": { "type": "date_nanos", "format": "strict_date_optional_time_nanos" } } } } }}
Define a query that looks at all data of the indices, sorted by the tracking field, and with a range filter since the last value seen until present:
{ "query": { "range": { "event.ingested": { "gt": ":last_value", "lt": ":present" } } }, "sort": [ { "event.ingested": { "order": "asc", "format": "strict_date_optional_time_nanos", "numeric_type": "date_nanos" } } ]}
Configure the Elasticsearch input to query the indices with the query defined above, every minute, and track the
event.ingestedfield:input { elasticsearch { id => tail_test_index hosts => [ 'https://..'] api_key => '....' index => 'test-*' query => '{ "query": { "range": { "event.ingested": { "gt": ":last_value", "lt": ":present"}}}, "sort": [ { "event.ingested": {"order": "asc", "format": "strict_date_optional_time_nanos", "numeric_type" : "date_nanos" } } ] }' tracking_field => "[event][ingested]" slices => 5 schedule => '* * * * *' schedule_overlap => false }}- optional use of slices to speed data processing, should be equal to or less than number of primary shards
- every minute
- don't accumulate jobs if one takes longer than 1 minute
With this sample setup, new documents are indexed into atest-* index. The next scheduled run:
- selects all new documents since the last observed value of the tracking field,
- usesPoint in time (PIT) +Search after to paginate through all the data, and
- updates the value of the field at the end of the pagination.
Technical Preview
The ES|QL feature that allows using ES|QL queries with this plugin is in Technical Preview. Configuration options and implementation details are subject to change in minor releases without being preceded by deprecation warnings.
Elasticsearch Query Language (ES|QL) provides a SQL-like interface for querying your Elasticsearch data.
To use ES|QL, this plugin needs to be installed in Logstash 8.17.4 or newer, and must be connected to Elasticsearch 8.11 or newer.
To configure ES|QL query in the plugin, set thequery_type toesql and provide your ES|QL query in thequery parameter.
ES|QL is evolving and may still have limitations with regard to result size or supported field types. We recommend understandingES|QL current limitations before using it in production environments.
The following is a basic scheduled ES|QL query that runs hourly:
input { elasticsearch { id => hourly_cron_job hosts => [ 'https://..'] api_key => '....' query_type => 'esql' query => ' FROM food-index | WHERE spicy_level = "hot" AND @timestamp > NOW() - 1 hour | LIMIT 500 ' schedule => '0 * * * *' }}- every hour at min 0
Setconfig.support_escapes: true inlogstash.yml if you need to escape special chars in the query.
With ES|QL query, Logstash doesn’t generateevent.original.
ES|QL returns query results in a structured tabular format, where data is organized intocolumns (fields) andvalues (entries). The plugin maps each value entry to an event, populating corresponding fields. For example, a query might produce a table like:
timestamp | user_id | action | status.code | status.desc |
|---|---|---|---|---|
| 2025-04-10T12:00:00 | 123 | login | 200 | Success |
| 2025-04-10T12:05:00 | 456 | purchase | 403 | Forbidden (unauthorized user) |
For this case, the plugin emits two events look like
[ { "timestamp": "2025-04-10T12:00:00", "user_id": 123, "action": "login", "status": { "code": 200, "desc": "Success" } }, { "timestamp": "2025-04-10T12:05:00", "user_id": 456, "action": "purchase", "status": { "code": 403, "desc": "Forbidden (unauthorized user)" } }]If your index has a mapping with sub-objects wherestatus.code andstatus.desc actually dotted fields, they appear in Logstash events as a nested structure.
ES|QL query fetches all parent and sub-fields fields if your Elasticsearch index hasmulti-fields orsubobjects. Since Logstash events cannot contain parent field’s concrete value and sub-field values together, the plugin ignores sub-fields with warning and includes parent. We recommend using theRENAME (orDROP to avoid warnings) keyword in your ES|QL query explicitly rename the fields to include sub-fields into the event.
This a common occurrence if your template or mapping follows the pattern of always indexing strings as "text" (field) + " keyword" (field.keyword) multi-field. In this case it’s recommended to doKEEP field if the string is identical and there is only one subfield as the engine will optimize and retrieve the keyword, otherwise you can doKEEP field.keyword | RENAME field.keyword as field.
To illustrate the situation with example, assuming your mapping has a timetime field withtime.min andtime.max sub-fields as following:
"properties": { "time": { "type": "long" }, "time.min": { "type": "long" }, "time.max": { "type": "long" }}The ES|QL result will contain all three fields but the plugin cannot map them into Logstash event. To avoid this, you can use theRENAME keyword to rename thetime parent field to get all three fields with unique fields.
...query => 'FROM my-index | RENAME time AS time.current'...For comprehensive ES|QL syntax reference and best practices, see theES|QL documentation.
This plugin supports these configuration options plus theCommon options described later.
As of version5.0.0 of this plugin, a number of previously deprecated settings related to SSL have been removed. Please check outElasticsearch Input Obsolete Configuration Options for details.
Also seeCommon options for a list of options supported by all input plugins.
- Value type ispassword
- There is no default value for this setting.
Authenticate using Elasticsearch API key. Note that this option also requires enabling thessl_enabled option.
Format isid:api_key whereid andapi_key are as returned by the ElasticsearchCreate API key API.
- Value type isstring, and must contain exactly 64 hexadecimal characters.
- There is no default value for this setting.
- Use of this optionrequires Logstash 8.3+
The SHA-256 fingerprint of an SSL Certificate Authority to trust, such as the autogenerated self-signed CA for an Elasticsearch cluster.
- Value type ispassword
- There is no default value for this setting.
Cloud authentication string ("<username>:<password>" format) is an alternative for theuser/password pair.
For more info, check out theLogstash-to-Cloud documentation.
- Value type isstring
- There is no default value for this setting.
Cloud ID, from the Elastic Cloud web console. If sethosts should not be used.
For more info, check out theLogstash-to-Cloud documentation.
- Value type isnumber
- Default value is
10
The maximum amount of time, in seconds, to wait while establishing a connection to Elasticsearch. Connect timeouts tend to occur when Elasticsearch or an intermediate proxy is overloaded with requests and has exhausted its connection pool.
- Value type ishash
- Default value is empty
Pass a set of key value pairs as the headers sent in each request to an elasticsearch node. The headers will be used for any kind of request. These custom headers will override any headers previously set by the plugin such as the User Agent or Authorization headers.
- Value type isboolean
- Default value is
false
If set, include Elasticsearch document information such as index, type, and the id in the event.
It might be important to note, with regards to metadata, that if you’re ingesting documents with the intent to re-index them (or just update them) that theaction option in the elasticsearch output wants to know how to handle those things. It can be dynamically assigned with a field added to the metadata.
Example
input { elasticsearch { hosts => "es.production.mysite.org" index => "mydata-2018.09.*" query => '{ "query": { "query_string": { "query": "*" } } }' size => 500 scroll => "5m" docinfo => true docinfo_target => "[@metadata][doc]" }}output { elasticsearch { index => "copy-of-production.%{[@metadata][doc][_index]}" document_type => "%{[@metadata][doc][_type]}" document_id => "%{[@metadata][doc][_id]}" }}If set, you can use metadata information in theadd_field common option.
Example
input { elasticsearch { docinfo => true docinfo_target => "[@metadata][doc]" add_field => { identifier => "%{[@metadata][doc][_index]}:%{[@metadata][doc][_type]}:%{[@metadata][doc][_id]}" } }}- Value type isarray
- Default value is
["_index", "_type", "_id"]
If document metadata storage is requested by enabling thedocinfo option, this option lists the metadata fields to save in the current event. SeeMeta-Fields in the Elasticsearch documentation for more information.
Value type isstring
Default value depends on whether
ecs_compatibilityis enabled:- ECS Compatibility disabled:
"@metadata" - ECS Compatibility enabled:
"[@metadata][input][elasticsearch]"
- ECS Compatibility disabled:
If document metadata storage is requested by enabling thedocinfo option, this option names the field under which to store the metadata fields as subfields.
Value type isstring
Supported values are:
disabled: CSV data added at root levelv1,v8: Elastic Common Schema compliant behavior
Default value depends on which version of Logstash is running:
- When Logstash provides a
pipeline.ecs_compatibilitysetting, its value is used as the default - Otherwise, the default value is
disabled
- When Logstash provides a
Controls this plugin’s compatibility with theElastic Common Schema (ECS).
- Value type isarray
- There is no default value for this setting.
List of one or more Elasticsearch hosts to use for querying. Each host can be either IP, HOST, IP:port, or HOST:port. The port defaults to 9200.
- Value type isstring
- Default value is
"logstash-*"
The index or alias to search. Check outMulti Indices documentation in the Elasticsearch documentation for info on referencing multiple indices.
- Value type isstring
- There is no default value for this setting.
The path to store the last observed value of the tracking field, when used. By default this file is stored as<path.data>/plugins/inputs/elasticsearch/<pipeline_id>/last_run_value.
This setting should point to file, not a directory, and Logstash must have read+write access to this file.
- Value type ispassword
- There is no default value for this setting.
The password to use together with the username in theuser option when authenticating to the Elasticsearch server. If set to an empty string authentication will be disabled.
- Value type isuri
- There is no default value for this setting.
Set the address of a forward HTTP proxy. An empty string is treated as if proxy was not set, this is useful when using environment variables e.g.proxy => '${LS_PROXY:}'.
- Value type isstring
- Default value is
'{ "sort": [ "_doc" ] }'
The query to be executed. Accepted query shape is DSL or ES|QL (whenquery_type => 'esql'). Read theElasticsearch query DSL documentation orES|QL documentation for more information.
Whensearch_api resolves tosearch_after and the query does not specifysort, the default sort'{ "sort": { "_shard_doc": "asc" } }' will be added to the query. Please refer to theElasticsearch search_after parameter to know more.
- Value can be
dsloresql - Default value is
dsl
Defines thequery shape. Whendsl, the query shape must be valid Elasticsearch JSON-style string. Whenesql, the query shape must be a valid ES|QL string andindex,size,slices,search_api,docinfo,docinfo_target,docinfo_fields,response_type andtracking_field parameters are not allowed.
- Value can be any of:
hits,aggregations,esql - Default value is
hits
Which part of the result to transform into Logstash events when processing the response from the query.
The defaulthits will generate one event per returned document (i.e. "hit").
When set toaggregations, a single Logstash event will be generated with the contents of theaggregations object of the query’s response. In this case thehits object will be ignored. The parametersize will be always be set to 0 regardless of the default or user-defined value set in this plugin.
- Value type isnumber
- Default value is
60
The maximum amount of time, in seconds, for a single request to Elasticsearch. Request timeouts tend to occur when an individual page of data is very large, such as when it contains large-payload documents and/or thesize has been specified as a large value.
- Value type isnumber
- Default value is
0
The number of times to re-run the query after the first failure. If the query fails after all retries, it logs an error message. The default is 0 (no retry). This value should be equal to or greater than zero.
Partial failures - such as errors in a subset of all slices - can result in the entire query being retried, which can lead to duplication of data. Avoiding this would require Logstash to store the entire result set of a query in memory which is often not possible.
- Value type isstring
- There is no default value for this setting.
Schedule of when to periodically run statement, in Cron format for example: "* * * * *" (execute query every minute, on the minute)
There is no schedule by default. If no schedule is given, then the statement is run exactly once.
- Value type isboolean
- Default value is
true
Whether to allow queuing of a scheduled run if a run is occurring. While this is ideal for ensuring a new run happens immediately after the previous on finishes if there is a lot of work to do, but given the queue is unbounded it may lead to an out of memory over long periods of time if the queue grows continuously.
When in doubt, setschedule_overlap to false (it may become the default value in the future).
- Value type isstring
- Default value is
"1m"
This parameter controls the keepalive time in seconds of the scrolling request and initiates the scrolling process. The timeout applies per round trip (i.e. between the previous scroll request, to the next).
- Value can be any of:
auto,search_after,scroll - Default value is
auto
Withauto the plugin uses thesearch_after parameter for Elasticsearch version8.0.0 or higher, otherwise thescroll API is used instead.
search_after usespoint in time and sort value to search. The query requires at least onesort field, as described in thequery parameter.
scroll usesscroll API to search, which is no longer recommended.
- Value type isnumber
- Default value is
1000
This allows you to set the maximum number of hits returned per scroll.
- Value type isnumber
- There is no default value.
- Sensible values range from 2 to about 8.
In some cases, it is possible to improve overall throughput by consuming multiple distinct slices of a query simultaneously usingsliced scrolls, especially if the pipeline is spending significant time waiting on Elasticsearch to provide results.
If set, theslices parameter tells the plugin how many slices to divide the work into, and will produce events from the slices in parallel until all of them are done scrolling.
The Elasticsearch manual indicates that there can benegative performance implications to both the query and the Elasticsearch cluster when a scrolling query uses more slices than shards in the index.
If theslices parameter is left unset, the plugin willnot inject slice instructions into the query.
- Value type ispath
- There is no default value for this setting.
SSL certificate to use to authenticate the client. This certificate should be an OpenSSL-style X.509 certificate file.
This setting can be used only ifssl_key is set.
- Value type is a list ofpath
- There is no default value for this setting
The.cer or.pem files to validate the server’s certificate.
You cannot use this setting andssl_truststore_path at the same time.
- Value type is a list ofstring
- There is no default value for this setting
The list of cipher suites to use, listed by priorities. Supported cipher suites vary depending on the Java and protocol versions.
- Value type isboolean
- There is no default value for this setting.
Enable SSL/TLS secured communication to Elasticsearch cluster. Leaving this unspecified will use whatever scheme is specified in the URLs listed inhosts or extracted from thecloud_id. If no explicit protocol is specified plain HTTP will be used.
When not explicitly set, SSL will be automatically enabled if any of the specified hosts use HTTPS.
- Value type ispath
- There is no default value for this setting.
OpenSSL-style RSA private key that corresponds to thessl_certificate.
This setting can be used only ifssl_certificate is set.
- Value type ispassword
- There is no default value for this setting.
Set the keystore password
- Value type ispath
- There is no default value for this setting.
The keystore used to present a certificate to the server. It can be either.jks or.p12
You cannot use this setting andssl_certificate at the same time.
- Value can be any of:
jks,pkcs12 - If not provided, the value will be inferred from the keystore filename.
The format of the keystore file. It must be eitherjks orpkcs12.
- Value type isstring
- Allowed values are:
'TLSv1.1','TLSv1.2','TLSv1.3' - Default depends on the JDK being used. With up-to-date Logstash, the default is
['TLSv1.2', 'TLSv1.3'].'TLSv1.1'is not considered secure and is only provided for legacy applications.
List of allowed SSL/TLS versions to use when establishing a connection to the Elasticsearch cluster.
For Java 8'TLSv1.3' is supported only since8u262 (AdoptOpenJDK), but requires that you set theLS_JAVA_OPTS="-Djdk.tls.client.protocols=TLSv1.3" system property in Logstash.
If you configure the plugin to use'TLSv1.1' on any recent JVM, such as the one packaged with Logstash, the protocol is disabled by default and needs to be enabled manually by changingjdk.tls.disabledAlgorithms in the$JDK_HOME/conf/security/java.security configuration file. That is,TLSv1.1 needs to be removed from the list.
- Value type ispassword
- There is no default value for this setting.
Set the truststore password.
- Value type ispath
- There is no default value for this setting.
The truststore to validate the server’s certificate. It can be either .jks or .p12.
You cannot use this setting andssl_certificate_authorities at the same time.
- Value can be any of:
jks,pkcs12 - If not provided, the value will be inferred from the truststore filename.
The format of the truststore file. It must be eitherjks orpkcs12.
- Value can be any of:
full,none - Default value is
full
Defines how to verify the certificates presented by another party in the TLS connection:
full validates that the server certificate has an issue date that’s within the not_before and not_after dates; chains to a trusted Certificate Authority (CA), and has a hostname or IP address that matches the names within the certificate.
none performs no certificate validation.
Setting certificate verification tonone disables many security benefits of SSL/TLS, which is very dangerous. For more information on disabling certificate verification please readhttps://www.cs.utexas.edu/~shmat/shmat_ccs12.pdf
- Value type isnumber
- Default value is
60
The maximum amount of time, in seconds, to wait on an incomplete response from Elasticsearch while no additional data has been appended. Socket timeouts usually occur while waiting for the first byte of a response, such as when executing a particularly complex query.
- Value type isfield reference
- There is no default value for this setting.
Without atarget, events are created from each hit’s_source at the root level. When thetarget is set to a field reference, the_source of the hit is placed in the target field instead.
This option can be useful to avoid populating unknown fields when a downstream schema such as ECS is enforced. It is also possible to target an entry in the event’s metadata, which will be available during event processing but not exported to your outputs (e.g.,target \=> "[@metadata][_source]").
- Value type isstring
- There is no default value for this setting.
Which field from the last event of a previous run will be used a cursor value for the following run. The value of this field is injected into each query if the query uses the placeholder:last_value. For the first query after a pipeline is started, the value used is either read fromlast_run_metadata_path file, or taken fromtracking_field_seed setting.
Note: The tracking value is updated after each page is read and at the end of each Point in Time. In case of a crash the last saved value will be used so some duplication of data can occur. For this reason the use of unique document IDs for each event is recommended in the downstream destination.
- Value type isstring
- Default value is
"1970-01-01T00:00:00.000000000Z"
The starting value for thetracking_field if there is nolast_run_metadata_path already. This field defaults to the nanosecond precision ISO8601 representation ofepoch, or "1970-01-01T00:00:00.000000000Z", given nano-second precision timestamps are the most reliable data format to use for this feature.
- Value type isstring
- There is no default value for this setting.
The username to use together with the password in thepassword option when authenticating to the Elasticsearch server. If set to an empty string authentication will be disabled.
As of version5.0.0 of this plugin, some configuration options have been replaced. The plugin will fail to start if it contains any of these obsolete options.
| Setting | Replaced by |
|---|---|
| ca_file | ssl_certificate_authorities |
| ssl | ssl_enabled |
| ssl_certificate_verification | ssl_verification_mode |
These configuration options are supported by all input plugins:
| Setting | Input type | Required |
|---|---|---|
add_field | hash | No |
codec | codec | No |
enable_metric | boolean | No |
id | string | No |
tags | array | No |
type | string | No |
- Value type ishash
- Default value is
{}
Add a field to an event
- Value type iscodec
- Default value is
"json"
The codec used for input data. Input codecs are a convenient method for decoding your data before it enters the input, without needing a separate filter in your Logstash pipeline.
- Value type isboolean
- Default value is
true
Disable or enable metric logging for this specific plugin instance by default we record all the metrics we can, but you can disable metrics collection for a specific plugin.
- Value type isstring
- There is no default value for this setting.
Add a uniqueID to the plugin configuration. If no ID is specified, Logstash will generate one. It is strongly recommended to set this ID in your configuration. This is particularly useful when you have two or more plugins of the same type, for example, if you have 2 elasticsearch inputs. Adding a named ID in this case will help in monitoring Logstash when using the monitoring APIs.
input { elasticsearch { id => "my_plugin_id" }}- Value type isarray
- There is no default value for this setting.
Add any number of arbitrary tags to your event.
This can help with processing later.
- Value type isstring
- There is no default value for this setting.
Add atype field to all events handled by this input.
Types are used mainly for filter activation.
The type is stored as part of the event itself, so you can also use the type to search for it in Kibana.
If you try to set a type on an event that already has one (for example when you send an event from a shipper to an indexer) then a new input will not override the existing type. A type set at the shipper stays with that event for its life even when sent to another Logstash server.