Introduction to query debugging and optimization in Postgres

Husband and father to four wonderful girls. Justin has been working professionally as either a DevOps or Developer for over 10 years. He has been writing Erlang both as a hobby and professionally since about 2012 and started with Elixir for personal use around 2014 and professionally since 2015.

When it comes to performance, it is better to be proactive and constantly looking for potential issues instead of waiting for them to appear by having our customers complain about them or worse by silently leaving our platforms because of them. This talk will give you some tools and tips to be proactive with Postgres performance in order to debug and optimize queries before they become an actual issue. Some of this knowledge should also be transferable to other database solutions.