# Log queries from elasticsearch output

**URL:** <https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882>\
**Category:** Logstash\
**Created:** [August 21, 2020, 8:53am UTC](https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882 "2020-08-21T08:53:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SpaceRaven](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spaceraven/32/74300_2.png) [@SpaceRaven](https://discuss.elastic.co/u/SpaceRaven)\
**Post date:** [August 21, 2020, 8:53am UTC](https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882/1 "2020-08-21T08:53:17Z")

</div>

Hi, Is there any way to log somehow queries from elasticsearch output plugin for es updates? i mean i want to inspect json queris which will go es cluster for update/delete/insert.

Thanks

---

<div class="post-metadata">

**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\
**Post date:** [August 21, 2020, 9:02am UTC](https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882/2 "2020-08-21T09:02:13Z")

</div>

You can enable that at the level of logging

```
logger.elasticsearchoutput.name = logstash.outputs.elasticsearch
logger.elasticsearchoutput.level = debug

```

May be this [link](https://www.elastic.co/guide/en/logstash/current/logging.html) can help

---

<div class="post-metadata">

**Author:** ![SpaceRaven](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spaceraven/32/74300_2.png) [@SpaceRaven](https://discuss.elastic.co/u/SpaceRaven)\
**Post date:** [August 21, 2020, 9:13am UTC](https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882/3 "2020-08-21T09:13:57Z")

</div>

First set loglevels:

```auto
$ curl -XPUT 'localhost:9600/_node/logging?pretty' -H 'Content-Type: application/json' -d '{"logger.logstash.inputs.jdbc" : "WARN"}'
$ curl -XPUT 'localhost:9600/_node/logging?pretty' -H 'Content-Type: application/json' -d '{"logger.org.logstash" : "TRACE"}'
$ curl -XPUT 'localhost:9600/_node/logging?pretty' -H 'Content-Type: application/json' -d '{"logger.logstash" : "TRACE"}'

```

Here is actual config for logging:

```auto
$ curl 'localhost:9600/_node/logging?pretty'
{
  "host" : "localhost",
  "version" : "6.4.0",
  "http_address" : "127.0.0.1:9600",
  "id" : "id",
  "name" : "name",
  "loggers" : {
    "logstash.agent" : "TRACE",
    "logstash.api.service" : "TRACE",
    "logstash.codecs.plain" : "TRACE",
    "logstash.config.source.local.configpathloader" : "TRACE",
    "logstash.config.source.multilocal" : "TRACE",
    "logstash.config.sourceloader" : "TRACE",
    "logstash.configmanagement.extension" : "TRACE",
    "logstash.filters.json" : "TRACE",
    "logstash.inputs.jdbc" : "WARN",
    "logstash.instrument.periodicpoller.deadletterqueue" : "TRACE",
    "logstash.instrument.periodicpoller.jvm" : "TRACE",
    "logstash.instrument.periodicpoller.os" : "TRACE",
    "logstash.instrument.periodicpoller.persistentqueue" : "TRACE",
    "logstash.modules.scaffold" : "TRACE",
    "logstash.modules.xpackscaffold" : "TRACE",
    "logstash.monitoringextension" : "TRACE",
    "logstash.monitoringextension.pipelineregisterhook" : "TRACE",
    "logstash.outputs.elasticsearch" : "TRACE",
    "logstash.pipeline" : "TRACE",
    "logstash.plugins.registry" : "TRACE",
    "logstash.runner" : "TRACE",
    "org.logstash.FieldReference" : "TRACE",
    "org.logstash.Logstash" : "TRACE",
    "org.logstash.execution.AbstractPipelineExt" : "TRACE",
    "org.logstash.execution.ShutdownWatcherExt" : "TRACE",
    "org.logstash.instrument.metrics.gauge.LazyDelegatingGauge" : "TRACE",
    "org.logstash.plugins.pipeline.PipelineBus" : "TRACE",
    "org.logstash.secret.store.SecretStoreFactory" : "TRACE",
    "org.logstash.secret.store.backend.JavaKeyStore" : "TRACE",
    "slowlog.logstash.codecs.plain" : "INFO",
    "slowlog.logstash.filters.json" : "INFO",
    "slowlog.logstash.inputs.jdbc" : "INFO",
    "slowlog.logstash.outputs.elasticsearch" : "INFO"
  }
}

```

But there is no anything from elasticsearch output plugin. With debug level of logging es output plugin dump its initialization steps

Thanks

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 21, 2020, 3:32pm UTC](https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882/4 "2020-08-21T15:32:16Z")

</div>

Partial answer [here](https://discuss.elastic.co/t/logger-logstash-outputs-elasticsearch-not-printing-enough-logs/243420/11).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 18, 2020, 3:32pm UTC](https://discuss.elastic.co/t/log-queries-from-elasticsearch-output/245882/5 "2020-09-18T15:32:36Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.