2 ms·
I guess what I'm getting at is questioning why you need to look at the database logs (beyond what your APM system can pull from the DB's metrics). What are you
by theptip 6y ago
I guess what I'm getting at is questioning why you need to look at the database logs (beyond what your APM system can pull from the DB's metrics).
What are you getting from the DB logs that you can't get elsewhere?
- sa46 6y agoSure, off the top of my head: - Explain plans for slow queries, via auto_explain in Postgres. You could get really fancy here and convert the pieces of an explain plan (Aggregate, ModifyTable, FullTableScan) into proper distributed traces. Hard to tell, but it looks like GCP might offer that. - Various errors logs associated with queries that require more detail than a SQL state code. For example, lock timeouts. - Debugging, especially root cause analysis when you're trying to figure out why something broke. The trace IDs help build up context.