Take the guesswork out of debugging slow performing queries.
2ndQuadrant take a multifaceted approach to debugging your individually under-performing SQL queries, and can help you fix problems pro-actively by introducing a query analysis routine. Does the apparently isolated issue with this query betray a deeper if intermittent problem? Just why has the planner incorrectly reached the conclusion that the plan it generated is optimal? Perhaps most importantly, what can be done about it, and what lessons have been learned that can be applied going forward?
2ndQuadrant clients can call upon the expertise of CTO Simon Riggs in the event of an exceptionally difficult problem with poorly planned queries - Simon is one of only a handful of individuals who has contributed code to the PostgreSQL planner.