Canvas sql query for last 30 seconds

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.

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

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

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