public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Laurenz Albe <laurenz.albe@cybertec.at>
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Slowness
Date: Tue, 14 Apr 2026 07:33:30 +0200
Message-ID: <1ce81f428a5e42bc263f7fece688b084a46f28af.camel@cybertec.at> (raw)
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>
On Mon, 2026-04-13 at 23:13 +0530, Raj wrote:
> If I start with normal health check top, free -h, patronictl list, and all status
> of components such as etcd, haproxy etcd pgnouncer , then stat user tables,
> 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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, rajeshkumar.dba09@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Slowness
In-Reply-To: <1ce81f428a5e42bc263f7fece688b084a46f28af.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox