A couple of views I find useful when investigating Postgres issues.