Finding and fixing slow queries
Presented by:
Hans-Jürgen Schönig
Hans-Jürgen Schönig has been a PostgreSQL expert and database specialist since the 90s. He is CEO and technical lead of CYBERTEC, which is one of the database market leaders worldwide and has served countless customers around the globe since the year 2000.As CEO of CYBERTEC, Hans-Jürgen Schönig regularly advises customers in database services and creates individual concepts tailored to each client’s needs. Additionally, he regularly gives training on PostgreSQL Advanced Optimization & Performance Tuning, PostgreSQL for Business Intelligence and Mass Data Analysis, PostgreSQL Replication Professional and Linux for PostgreSQL DBAs - just to name a few.
No video of the event yet, sorry!
Your database is performing badly but you got no idea why. Fortunately PostgreSQL has all the means to figure out what is really going on inside your database. You just have to find the right modules and use the right tools and understand what PostgreSQL is really trying to tell you. This talk will show you how to track down slow queries using pg_stat_statement, work with "explain analyze" and fix bad performance using simple query rewrites.
- Date:
- 2019 October 9 09:00 SAST
- Duration:
- 4 h
- Room:
- Ballroom
- Conference:
- South Africa 2019
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 45/60)