interpolated_duration_in()

warning

Experimental features could have bugs. They might not be backwards compatible, and could be removed in future releases. Use these features at your own risk, and do not use any experimental features in production.

You can query this table for the time spent in the running state, like this:

If you prefer to see the result in seconds, EXTRACT the epoch from the returned result.