Skip to content

Instantly share code, notes, and snippets.

@jesuino
Created January 15, 2021 15:52
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
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