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