Video of a conference talk about the most useful SQL queries that can be run on PostgreSQL to investigate high CPU utilization, delivered at Citus Con: An Event for Postgres 2023 by Dmitry Romanoff. Checking CPU utilization allows you to understand if your PostgreSQL database is experiencing performance issues like inefficient SQL queries, lack of indexes, and contention. After seeing a high CPU of the PostgreSQL DB instance, it’s essential to find the root cause of the issue. Queries can be poorly written, too frequent, or heavy. This talk will also help you understand what’s running in the database instance that impacts CPU usage.
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)