PostgreSQL has been growing in popularity for the last few years, partly because its performance continues to be excellent as it scales. But this doesn’t mean that PostgreSQL scales magically or automatically, or that we don’t need to worry about which queries are consuming the greatest resources. pg_stat_statements is a PostgreSQL extension that lets you track query performance over time. In this talk, Lukas Fittl describes some advanced ways in which you can use pg_stat_statements to understand, and then improve, your PostgreSQL database performance.