Troubleshooting High CPU Utilization in PostgreSQL Databases | Citus Con: An Event for Postgres 2023

From the creator

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. Dmitry Romanoff is an experienced DevOps Data Lead, Cloud Architect, and DBA who works at JFrog. He has extensive experience in the design, development, implementation, and management of large and complex cloud-based solutions. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 02:36 DB connections ⏩ 06:42 Distribution of non-idle connections per database and per query ⏩ 09:21 The PostgreSQL parameter statement_timeout ⏩ 11:31 Running frequent SQL queries ⏩ 14:04 The PostgreSQL parameter random_page_cost ⏩ 18:52 PostgreSQL DB bloat ✅ Learn more: Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon, https://twitter.com/CitusCon #CitusCon #PostgreSQL #Database

Published 2023-04-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.