Finding and fixing slow queries
Hans-Jürgen Schönig has been in professional PostgreSQL for over 17 years now and has dealt with customers around the globe. His company Cybertec Schönig & Schönig GmbH offers professional services for PostgreSQL, which includes training, 24x7 support, as well as consulting.
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.
- 2019 September 18 13:00
- 3 h
- Winchester (2)
- Silicon Valley 2019
- Ops and Administration