Conference Schedule - PGConf.EU 2012Back
Beyond Query Logging
Date: Oct. 26, 2012
Queries were slow; you turned on query logging. Now you have at least two more new problems. Just collecting that data and analyzing it hasn't been easy until now. Those problems are significantly improved with the new pg_stat_statements available in PostgreSQL 9.2. Even with that in place, collecting query logs or even first level summaries of them isn't good enough to deal with the hardest workload problems.
Query logging, saving information about the statements that take a long time to execute, is a useful way to look at small amounts of data about your server's workload. Workload analysis is a more formal approach that takes that data and builds a larger picture about your server's health from it. PostgreSQL 9.2 makes it easier than ever to collect slow query information, but you can start formal workload analysis in any version. Learning good Workload Analysis techniques lets you better understand just where server resources go, both for short-term tuning and long-term planning. Topics covered will include: