2ndQuadrant are pleased to announce the release of pg_stat_plans 1.0
beta, an enhanced SQL monitoring and tuning tool.
pg_stat_plans allows you to view the most frequent and expensive SQL
statements in your applications, just as many other tools allow.
However, pg_stat_plans is unique in its ability to offer an SQL query
than can be EXPLAINed to view the actual plan, rather than merely a
similar plan.
pg_stat_plans lists SQL statements by plan, not just by query, and as
such can diagnose even complex cases where a single SQL statement
returns multiple plans when different parameters are utilised.
pg_stat_plans is a variant of the standard Postgres contrib module
pg_stat_statements.
The tool is a further improvement of the pg_stat_statements module
that is distributed with Postgres 9.2, a release in which the module
was heavily improved by 2ndQuadrant to make it usable by applications
that do not use prepared statements (in practice, the large majority).
Unfortunately that module works only with 9.2. In response to strong
demand from 2ndQuadrant customers, an explicit goal of pg_stat_plans
is to support Postgres 9.0 and 9.1.
Official pg_stat_plans page: http://www.2ndQuadrant.com/en/pg_stat_plans
===============================================
pg_stat_plans is release now as an open source tool to solve real
world performance problems.
Support is included as part of 2ndQuadrant's 24x7 Production Support
package, priced at $3000 per server, or $40,000 for unlimited server
licences.
