Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
     
 
Keep TACKtech.com free by purchasing something from our sponsors.
Make a financial contribution
  Technical Updates @ TACKtech Corp.  

10.23.2012 - Are your SQL statements becoming expensive? Get a better view with pg_stat_plans!



View PostgreSQL-Press related news.

2ndQuadrant is pleased to announce the release of pg[HTML_REMOVED]stat_plans 1.0 beta, an enhanced SQL monitoring and tuning open source tool.

The tool is a further improvement of the pg[HTML_REMOVED]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.

pg[HTML_REMOVED]stat_plans allows you to view the most frequent and expensive SQL statements in your applications, just as many other tools allow. The tool is unique in its ability to offer an SQL query that can be EXPLAINed to view the actual plan, rather than merely a similar plan.

pg[HTML_REMOVED]stat[HTML_REMOVED]plans lists SQL statements by plan, not just by query, which allows it to diagnose even complex cases where a single SQL statement returns multiple plans when different parameters are utilised. pg[HTML_REMOVED]stat[HTML_REMOVED]plans is a variant of the standard Postgres contrib module pg[HTML_REMOVED]stat[HTML_REMOVED]statements.

With this release, the module works only with 9.2. In response to strong demand from 2ndQuadrant customers, an explicit goal of pg[HTML_REMOVED]stat_plans is to support Postgres 9.0 and 9.1.

Please visit the official pg_stat_plans page for more information and to download the beta: http://www.2ndQuadrant.com/en/pg[HTML_REMOVED]stat_plans



- Download PostgreSQL
- View Press Release
- Visit PostgreSQL

NID: 43841 / Submitted by: The Zilla of Zuron
Categories: Server Applications, Open Source, Press Release
Most recent PostgreSQL-Press related news.
FOSDEM PGDay 2017 & FOSDEM Devroom Call for Papers
DbWrench Database Design 4.0 Released
Launch of the Israel PostgreSQL Community Website
E-Maj 2.0.0 released
Amazon RDS now supports PostgreSQL 9.6.1
View archive of PostgreSQL-Press related news.

Visit the TACKtech Shop
  Popular Tech News  
  Most Viewed News  
  Top Affiliates  
........