DEV Community

Dmitry Romanoff
Dmitry Romanoff

Posted on

1

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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay