# Logstash Logs output for jdbc
**URL:** https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826
**Category:** Logstash
**Created:** [August 28, 2023, 4:48pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826 "2023-08-28T16:48:08Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@nbrenke](https://discuss.elastic.co/u/nbrenke)
#### Post date: [August 28, 2023, 4:48pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826/1 "2023-08-28T16:48:08Z")
I have a silly question::
I have several jdbc pipelines setup that pull data directly from a sql database. Short of the following that shows up in my logs
[2022-10-28T18:40:00,344][INFO][logstash.inputs.jdbc] (0.029206s) SELECT
How can I actually track the start time, Stop Time, records transferred, and maybe errors on a single pipeline run? I do not see a stopped time. I do know if I stop logstash and restart the service that it writes to the logs "started" but that isnt the actual start time of the ingest.
I've looked out using outputs but again nothing seems to be working as expected for some reason.
Any thoughts would be greatly appreciated.
---
### Author:  [@Rios](https://discuss.elastic.co/u/Rios)
#### Post date: [August 28, 2023, 5:28pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826/2 "2023-08-28T17:28:22Z")
Can you provide few (different) lines of messages to see which columns do you have?
---
### Author:  [@nbrenke](https://discuss.elastic.co/u/nbrenke)
#### Post date: [August 28, 2023, 6:12pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826/3 "2023-08-28T18:12:52Z")
This is the only log that I see coming out that makes sense. The others are started and shut down. Which I believe are both related to starting / stopping the logstash service
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [August 28, 2023, 6:53pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826/4 "2023-08-28T18:53:16Z")
> [@nbrenke](#):
>
> How can I actually track the start time, Stop Time, records transferred, and maybe errors on a single pipeline run?
logstash does not log that.
The [monitoring API](https://www.elastic.co/guide/en/logstash/current/node-stats-api.html#pipeline-stats) allows you to see how many events an input has generated. Depending on how often you sample the data that might allow you to infer start/stop times and event counts. You can use metricbeat to collect that data and Kibana to visualise it.
---
### Author:  [@Rios](https://discuss.elastic.co/u/Rios)
#### Post date: [August 28, 2023, 8:12pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826/5 "2023-08-28T20:12:08Z")
Ah you want LS monitoring. As Badger said, [URL](https://localhost:9600/_node/stats/pipelines?pretty) will provide LS pipeline monitoring. Check [this](https://www.elastic.co/guide/en/logstash/8.9/configuring-logstash.html) how to set the monitoring.
Also you can track the monitoring in Kibana-\>Stack Monitoring-\>Logstash. It will be easier to track if you set plugin's [IDs](https://www.elastic.co/guide/en/logstash/current/plugins-filters-grok.html#plugins-filters-grok-id)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 25, 2023, 8:12pm UTC](https://discuss.elastic.co/t/logstash-logs-output-for-jdbc/341826/6 "2023-09-25T20:12:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.