How to find out if the sql_last_value is correctly interpreted?

Elastic Stack Logstash
1

I have created the following logstash config script:
SELECT a, b, c, last_updated FROM tablex where cast(last_updated AS TIMESTAMP) >=:sql_last_value
How can I find out what the sql_last_value is ? i.e. is there a log level that echoes the actual sql executed with the parameter value? like

SELECT a, b, c, last_updated FROM tablex where cast(last_updated AS TIMESTAMP) >='19-JUL-16 12.01.01.000000000 AM'
Any feedback would be appreciated.

Btw last_updated is a DATE type field.

2

Well, it's not Logstash that produces such a query by interpreting the parameter so it can't possibly produce that kind of log message. However, it should be able to display the queries made and any parameters passed to it. Try starting Logstash with --verbose or --debug and see what happens.