Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAEUi-00EUH9-SX for pgsql-announce@arkaria.postgresql.org; Sun, 10 Nov 2024 20:25:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tAEUf-008pSO-DN for pgsql-announce@arkaria.postgresql.org; Sun, 10 Nov 2024 20:25:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAEUe-008pRx-FW for pgsql-announce@lists.postgresql.org; Sun, 10 Nov 2024 20:25:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAEUa-001FJX-Na for pgsql-announce@lists.postgresql.org; Sun, 10 Nov 2024 20:25:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=nZ1ICTTFAV9FoX1jEKq3vLZX+E/Ftz9HQoLvGIZoDWQ=; b=LB3tKgNDEht8tfSuzb/INLiGOw vAs+F1Yex6NAHTq/4ivHz8llxSY65klB1KH5WCMQaleeJEvUXivcGMfSBqiwYkEwhisou5dRQin4N StpGToZLdR0FQOsCzqYgernRURn5h7VOVYfCplNP4LAM2PwJbS0hQGMx4/NOci2O6K014YFZa9+kZ /EhbbE3cba8HY8mTkvIEM4YW3EBGrwsWrFW5mxFGER1QHAwy2ETzJdITPW+/DcUYEMGMxITpI8mBW Bi24S9Sp/Egf/mj5NIZnrTv7Qz3VF8kEdVoRoeBSLueEHdFTctQ712TE+HMYqQCzdDwt9BSX5Srjd AAhEsK4w==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAEUZ-003dtG-60 for pgsql-announce@lists.postgresql.org; Sun, 10 Nov 2024 20:25:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tAEUX-005EWn-LY for pgsql-announce@lists.postgresql.org; Sun, 10 Nov 2024 20:25:02 +0000 Content-Type: multipart/mixed; boundary="===============5324016094927480359==" MIME-Version: 1.0 Subject: PoWA 5 is out! To: PostgreSQL Announce From: PoWA via PostgreSQL Announce Reply-To: rjuju123@gmail.com Date: Sun, 10 Nov 2024 20:24:14 +0000 Message-ID: <173127025422.709.10517821233387892586@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: c43508d2061d45548603966573cd982af3705dab845eb5c0ed832d5f9d8ac5f5 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5324016094927480359== Content-Type: multipart/alternative; boundary="===============1617314842516477666==" MIME-Version: 1.0 --===============1617314842516477666== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Taipei, Taiwan - November 10th, 2024 The PoWA team is proud to announce the release of PoWA 5.0.0. # PoWA 5 is out PoWA (PostgreSQL Workload Analyzer) is a performance tool, compatible with = all supported PostgreSQL versions. It allows to collect and aggregate metrics gathered from multiple PostgreSQL instances using various extensions coveri= ng all parts of PostgreSQL and provides real-time charts and graphs to help monitor and tune your servers. It also suggest optimizations, like global = or per-query index suggestions, to easily improve performances. ## What's new The version 5 is a new major version. It comes with a brand new version of [powa-web](https://github.com/powa-team/powa-web), the dedicated UI, with an improved looks and user experience. This new version also allows you to dynamically perform actions, such as performing a metrics snapshots on a specific server or refreshing the catalog copies. It also brings a lot of new datasources, for general and performance monito= ring such as: - replication and replication slots stat views - background writer and checkpointer stat views - new IO stat view (pg16+) - SLRU and WAL stat views - and a lot more And introduce snapshot of per-database metrics, such as: - historical copies of various catalogs - tables and indexes statistics - user function statistics ## Credits Thank to the users who reported bugs or submitted patches, they are all cit= ed in the CHANGELOG files of [powa-archivist](https://github.com/powa-team/powa-archivist/blob/master/CH= ANGELOG.md) and [powa-web](https://github.com/powa-team/powa-web/blob/master/CHANGELOG) projects. PoWA is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches following the documentation at [powa.readthedocs.io/en/latest/contributing.html](https://powa.readthedocs.= io/en/latest/contributing.html). ## Links For [powa-archivist](https://github.com/powa-team/powa-archivist), the core= extension: - Documentation: [powa.readthedocs.io](https://powa.readthedocs.io/en/lates= t/) - Container images: [hub.docker.com/u/powateam](https://hub.docker.com/u/po= wateam) - Archive download: [github.com/powa-team/powa-archivist/releases](https://= github.com/powa-team/powa-archivist/releases) - Bug tracker: [github.com/powa-team/powa-archivist/issues](https://github.= com/powa-team/powa-archivist/issues) For [powa-web](https://github.com/powa-team/powa-web), the dedicated UI: - Documentation: [powa.readthedocs.io/en/latest/components/powa-web/index.h= tml](https://powa.readthedocs.io/en/latest/components/powa-web/index.html) - Container images: [https://hub.docker.com/r/powateam/powa-web](https://hu= b.docker.com/u/powateam/powa-web) - Archive download: [github.com/powa-team/powa-web/releases](https://github= .com/powa-team/powa-web/releases) - Bug tracker: [github.com/powa-team/powa-web/issues](https://github.com/po= wa-team/powa-web/issues) --===============1617314842516477666== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable PoWA 5 is out!
 

PoWA 5 is out!

Taipei, Taiwan - November 10th, 2024

The PoWA team is proud to announce the rele= ase of PoWA 5.0.0.

PoWA 5 is out

PoWA (PostgreSQL Workload Analyzer) is a pe= rformance tool, compatible with all supported PostgreSQL versions. It allows to collect and aggregate metrics gathered from multiple PostgreSQL instances using various extensions coveri= ng all parts of PostgreSQL and provides real-time charts and graphs to help monitor and tune your servers. It also suggest optimizations, like global = or per-query index suggestions, to easily improve performances.

What's new

The version 5 is a new major version. It c= omes with a brand new version of powa-web, the dedicated UI, with an improved looks and user experience. This new version also allows you to dynamically perform actions, such as performing a metrics snapshots on a specific server or refreshing the catalog copies.

It also brings a lot of new datasources, fo= r general and performance monitoring such as:

  • replication and= replication slots stat views
  • background writ= er and checkpointer stat views
  • new IO stat vie= w (pg16+)
  • SLRU and WAL st= at views
  • and a lot more<= /li>

And introduce snapshot of per-database metr= ics, such as:

  • historical copi= es of various catalogs
  • tables and inde= xes statistics
  • user function s= tatistics

Credits

Thank to the users who reported bugs or sub= mitted patches, they are all cited in the CHANGELOG files of powa-archivist and powa-web projects.

PoWA is an open project. Any contribution t= o build a better tool is welcome. You just have to send your ideas, features requests or patches following the documentation at powa.readthedocs.io/en/late= st/contributing.html.

Links

For powa-= archivist, the core extension:

For powa-web, the dedicated UI:
This email was sent to you from PoWA. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to PoWA.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============1617314842516477666==-- --===============5324016094927480359==--