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.96) (envelope-from ) id 1vrvOB-00DC4P-27 for pgsql-announce@arkaria.postgresql.org; Mon, 16 Feb 2026 09:59:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrvNB-000heH-0R for pgsql-announce@arkaria.postgresql.org; Mon, 16 Feb 2026 09:58:33 +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.96) (envelope-from ) id 1vrvN9-000hdy-2u for pgsql-announce@lists.postgresql.org; Mon, 16 Feb 2026 09:58:32 +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.98.2) (envelope-from ) id 1vrvN7-00000000zo2-11Up for pgsql-announce@lists.postgresql.org; Mon, 16 Feb 2026 09:58:31 +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=PgBB1dyZ8v5KkBz5530Q1coxvjV3RS9RuOwqcxJYTM0=; b=3oWeImM7qClmMT/g7v1GaRVaJX gqntzovLiocv4yRwRKdx2LFj7rtr0FjNn5+WP49ItJdcgW2g5237rUZvOLvPKbivg3zUNfvb46C8N /uhZqb8dyLTJCIdMWXi54/VGayatWWAkd3OfTiULUDa5grWzC1utopYtudkus9LfLph8x6gAveiyr kanCrCfiqgs/unKJz7+Pg/MPwpiInNSTn+/Tset8cZCRuA0pg5OuUykLITHJ0p0i7G7zfhzA/MBsZ uTsw59WGyszbsH25A38rAOTbmv3iOQEA7s+p1elCoo9tl5Jco/Nd9U5lfZmTj2deWjlWdG+0Z0WI1 s07DBh6Q==; 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.96) (envelope-from ) id 1vrvN6-002uQi-00 for pgsql-announce@lists.postgresql.org; Mon, 16 Feb 2026 09:58:28 +0000 Received: from [127.0.0.1] (helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vruAL-0006Hs-2n for pgsql-announce@lists.postgresql.org; Mon, 16 Feb 2026 08:41:13 +0000 Content-Type: multipart/alternative; boundary="===============1055191979929136971==" MIME-Version: 1.0 Subject: =?utf-8?q?postgres=5Fdba_7=2E0_=E2=80=94_34_diagnostic_reports_for_psql?= To: PostgreSQL Announce From: PostgresAI via PostgreSQL Announce Reply-To: nik@postgres.ai Date: Mon, 16 Feb 2026 08:39:29 +0000 Message-ID: <177123116953.791.8112454806305459990@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: dd68c70671aceaff4cf2b5fba88801318afe1affe5b149a4cb7334328ffe78f8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1055191979929136971== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [postgres_dba](https://github.com/NikolayS/postgres_dba) 7.0 is a major upd= ate to the interactive psql-based diagnostic toolkit for Postgres. No exten= sions required =E2=80=94 just `\i start.psql` and explore 34 reports coveri= ng: - **Bloat & vacuum analysis** (v1, v2) =E2=80=94 activity, progress, autova= cuum queue - **Table & index health** (i1=E2=80=93i3) =E2=80=94 unused indexes, redund= ant indexes, non-indexed FKs - **Query analysis** (s1=E2=80=93s3) =E2=80=94 pg_stat_statements top queri= es and workload profile - **Tuning** (t1, t2) =E2=80=94 storage parameters, config recommendations - **Table/index size estimation** (b1=E2=80=93b6) =E2=80=94 alignment paddi= ng, bloat, buffer cache - **Lock trees** (l1) =E2=80=94 who's blocking whom - **Corruption checks** (c1=E2=80=93c4) =E2=80=94 4-level amcheck suite fro= m quick scans to full heap verification - **Memory analysis** (m1) =E2=80=94 buffer cache contents by relation **What's new in 7.0:** - 7 new reports: b6 (buffer cache analysis), s3 (workload profile), c1=E2= =80=93c4 (amcheck corruption detection), m1 (buffer cache) - WAL and replication info added to the system overview (report 0) - CI on Postgres 13=E2=80=9318 - PG17 compatibility fixes for pg_stat_statements column renames - Modernized README with badges, per-report descriptions, and optional exte= nsion table Works on Postgres 13=E2=80=9318. Just clone the repo and run. Links: - Repository: [github.com/NikolayS/postgres_dba](https://github.com/Nikolay= S/postgres_dba) - Release notes: [RELEASE_NOTES.md](https://github.com/NikolayS/postgres_db= a/blob/master/RELEASE_NOTES.md) --===============1055191979929136971== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable postgres_dba 7.0 =E2=80=94 34 diagnostic reports for psql
 

postgres_dba 7.0 =E2=80=94 34 diagnostic reports for psql

postgres_dba= 7.0 is a major update to the interactive psql-based diagnostic toolkit= for Postgres. No extensions required =E2=80=94 just \i start.psql and explore 34 reports covering:

  • Bloat &= amp; vacuum analysis (v1, v2) =E2=80=94 activity, progress, autova= cuum queue
  • Table &= amp; index health (i1=E2=80=93i3) =E2=80=94 unused indexes, redund= ant indexes, non-indexed FKs
  • Query a= nalysis (s1=E2=80=93s3) =E2=80=94 pg_stat_statements top queries a= nd workload profile
  • Tuning<= /strong> (t1, t2) =E2=80=94 storage parameters, config recommendations
  • Table/i= ndex size estimation (b1=E2=80=93b6) =E2=80=94 alignment padding, = bloat, buffer cache
  • Lock tr= ees (l1) =E2=80=94 who's blocking whom
  • Corrupt= ion checks (c1=E2=80=93c4) =E2=80=94 4-level amcheck suite from qu= ick scans to full heap verification
  • Memory = analysis (m1) =E2=80=94 buffer cache contents by relation

What's new in 7.0:

  • 7 new reports: = b6 (buffer cache analysis), s3 (workload profile), c1=E2=80=93c4 (amcheck c= orruption detection), m1 (buffer cache)
  • WAL and replica= tion info added to the system overview (report 0)
  • CI on Postgres = 13=E2=80=9318
  • PG17 compatibil= ity fixes for pg_stat_statements column renames
  • Modernized READ= ME with badges, per-report descriptions, and optional extension table

Works on Postgres 13=E2=80=9318. Just clone= the repo and run.

Links:
This email was sent to you from PostgresAI. It was delivered on their behal= f by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to PostgresAI.

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/.
 
--===============1055191979929136971==--