Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
select
processid,
nodeid as "NodeId",
DATEDIFF('SECOND', DATE '1970-01-01', log_date) AS "sec",
count(nodeid) as "total"
from
NodeInstanceLog
where
datediff('SECOND', log_date, current_timestamp) < 60
group by
processid,
nodeid,
DATEDIFF('SECOND', DATE '1970-01-01', log_date)
order by
DATEDIFF('SECOND', DATE '1970-01-01', log_date)
DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment