Canvas sql query for last 30 seconds

Elastic Stack Kibana
1

Hi all, I was wondering if its possible to do a sql query that limits to the last 30 seconds? So for example nginx access hits for last 30 seconds.

Thank You.

2

WHERE "@timestamp" > NOW() - INTERVAL 30 SECOND AND "@timestamp" <= NOW()

3

Thank you very much it works like a charm. This Elastic Stack system is incredible.