# Optimize logstash configuration

**URL:** <https://discuss.elastic.co/t/optimize-logstash-configuration/239574>\
**Category:** Logstash\
**Created:** [July 2, 2020, 6:15am UTC](https://discuss.elastic.co/t/optimize-logstash-configuration/239574 "2020-07-02T06:15:18Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![ohoroyoi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ohoroyoi/32/46820_2.png) [@ohoroyoi](https://discuss.elastic.co/u/ohoroyoi)\
**Post date:** [July 2, 2020, 8:33am UTC](https://discuss.elastic.co/t/optimize-logstash-configuration/239574/3 "2020-07-02T08:33:19Z")

</div>

Hello. Thanks for the reply. If I understand you correctly...

Should I configure the statement to get only the changed ones(after fetch the entire table once and then)?

I'll ask you one more thing.  
How can `sql_last_value` be given a value?

Can you elaborate on the `last_run_metadata_path` and `sql_last_value ` parts in more detail? I don't know how to set `sql_last_value`

---

_[View the full topic](https://discuss.elastic.co/t/optimize-logstash-configuration/239574)._