PostgreSQL is a pretty solid platform for, and you can reason about it much like any piece of complex-but-coherent software. In practice, we debug and diagnose it right along with 3rd party extensions. Think about it like debugging a kernel with apps running. You don't get a "clean" case, you have to make it work for all cases cleanly.