We currently use the performance advisor and real-time stats in production. However, we don't have visibility into the entire set of slow queries. We should turn on the profiler so that we can view the data through Cloud Manager.
We should be cautious when we do this, as there can be a performance impact.
I suggest setting a slowms relatively high, perhaps to 1000ms, and set profiling level to 1.