Query should use context with a strict timeout

[film42]

I don't have hard data to show that this is happening, but we have seen steep resource accumulation when the database is running hot. I wonder if this is a result of long query processing. I think it would be good to limit connect times and query times with a deadline context. Most (if not all) existing query points have a context variant.