DEV Community

Dmitry Romanoff
Dmitry Romanoff

Posted on

Video of a conference talk about the most useful SQL queries to investigate high CPU utilization, delivered at Citus Con 2023

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.

https://www.youtube.com/watch?v=GXvX_PclthI

Top comments (0)