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

Using Azure Query Store to Understand PostgreSQL Performance | POSETTE 2024

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
550 views 10 months ago #PostgreSQL #Performance #PosetteConf
Video of a conference talk about using Azure Query Store to understand PostgreSQL performance presented by Grant Fritchey at POSETTE: An Event for Postgres 2024. Capturing query metrics in Postgres can be a challenge. This is especially true because when capturing metrics, it's not enough to simply measure a query's performance. You must have multiple data points, a before and after if you will, to ensure that you know if a query is running faster, slower, or the same. Within Azure Database for PostgreSQL, there exists an extension, that measures query behaviors, and does it in a way to provides multiple data points, Query Store. This session will demonstrate why the Query Store will make it easier for you to identify the queries that need attention. Further, the Query Store gives you tools to help you with tuning those PostgreSQL queries on Azure. You no longer need to guess at which queries are the highest priority for your query tuning. Come  â€Ś...more
...more
Using Azure Query Store to Understand PostgreSQL Performance | POSETTE 2024
17Likes
550Views
Jun 132024
Video of a conference talk about using Azure Query Store to understand PostgreSQL performance presented by Grant Fritchey at POSETTE: An Event for Postgres 2024. Capturing query metrics in Postgres can be a challenge. This is especially true because when capturing metrics, it's not enough to simply measure a query's performance. You must have multiple data points, a before and after if you will, to ensure that you know if a query is running faster, slower, or the same. Within Azure Database for PostgreSQL, there exists an extension, that measures query behaviors, and does it in a way to provides multiple data points, Query Store. This session will demonstrate why the Query Store will make it easier for you to identify the queries that need attention. Further, the Query Store gives you tools to help you with tuning those PostgreSQL queries on Azure. You no longer need to guess at which queries are the highest priority for your query tuning. Come to this session to find out how. Grant is a Data Platform MVP and AWS Community Builder with over 30 years’ experience in IT, including time spent in support and development. Grant works with multiple data platforms including PostgreSQL and SQL Server, as well as multiple cloud platforms. He has also developed in Python, C#, and Java. Grant writes books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product advocate in January 2011. Chapters: 00:00 - Intro 00:49 - Query Tuning Process 06:57 - Query Metrics 08:13 - Query Store 14:12 - Demo 23:35 - More to Learn 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe #PosetteConf #PostgreSQL #Performance Presenters: Grant Fritchey, Redgate Software Connect: Grant Fritchey:   / gfritchey  ,   / grant-fritchey  

Follow along using the transcript.

Microsoft Developer

589K subscribers