What is the criteria for a sprite being "idle"? Is it no network activity or is it cpu based?

It stays awake if you have an open connection (like sprite console) or an exec session if running and producing stdout.

You can specify a max exec time for a process when you launch it via the API.

Looks like it's no network activity for 30 seconds.