Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
4.1K views 2 years ago #PostgreSQL #Database #CitusCon
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 Distribu …...more
...more
Troubleshooting High CPU Utilization in PostgreSQL Databases | Citus Con: An Event for Postgres 2023
53Likes
4,150Views
2023Apr 18
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,   / cituscon   #CitusCon #PostgreSQL #Database

Follow along using the transcript.

Microsoft Developer

588K subscribers