Message-ID: <1ce81f428a5e42bc263f7fece688b084a46f28af.camel@cybertec.at>
Subject: Re: Slowness
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Tue, 14 Apr 2026 07:33:30 +0200
In-Reply-To: 
 <CAJk5AtZ1-N4hs=6D1NtnNNt116e9kjEhpFdakrkJUJtgaL_xKQ@mail.gmail.com>
References: 
	<CAJk5AtZvkEdQsGLOEBAXuFv085End7H2T7SGkaEfTO1+QEARPw@mail.gmail.com>
	 <2fd0442020d5b23609873f999b7d374875875689.camel@cybertec.at>
	 <CAJk5AtZ_7nKTLpVvduJCeVD=qMD=A9nVia=UmCWGo6JkbRMoRQ@mail.gmail.com>
	 <efb70f15e61eaa95bcfa6039f6dd086481fc4bdb.camel@cybertec.at>
	 <CAJk5AtZ1-N4hs=6D1NtnNNt116e9kjEhpFdakrkJUJtgaL_xKQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/1ce81f428a5e42bc263f7fece688b084a46f28af.camel%40cybertec.at>
Precedence: bulk

On Mon, 2026-04-13 at 23:13 +0530, Raj wrote:
> If I start with normal health check top, free -h, patronictl list, and al=
l status
> of components such as etcd, haproxy etcd pgnouncer , then stat user table=
s,
> pgstatactivity, pgstatstatements and error log. Apart from this, what dba=
 should do?

I'm not sure what a "normal health check" is.

I thought your problem was that the some statements are too slow.
That is not directly connected to the health of the database.

To deal with slow statements, you first have to find them.
Tools are log_min_duration_statement and pg_stat_statements.

Then you have to make the statements faster.  The tool here is
EXPLAIN (ANALYZE, BUFFERS).  But you need some experience to be
able to read execution plans, figure out where the problem is
and fix that problem.

Yours,
Laurenz Albe