I try to at least have the slow query log on and monitored in staging. It's pretty easy to forget an index and not notice in a dev environment.