Debugging Postgres CPU issues

Jump to bottom

Danny Zaken edited this page Jul 14, 2022 · 6 revisions

Using `pg_stat_statements` to get the top CPU\time consuming queries

connect to the DB pod and run psql
```
oc rsh noobaa-db-pg-0
$ psql -d nbcore
```