From: Alex Balashov <abalashov@evaristesys.com>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.400.31\))
Subject: Re: Missing indexes
Date: Fri, 1 Mar 2024 12:42:11 -0500
References: 
 <CANc-nPuFe-HmHCfwQfgcvbrSbmgcxmT2Q0H4nUqqZNuy2tFRdw@mail.gmail.com>
 <1883261458.1984.1709314823544.JavaMail.zextras@jpp.fr>
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
In-Reply-To: <1883261458.1984.1709314823544.JavaMail.zextras@jpp.fr>
Message-Id: <8C52F074-25E7-4AA7-93C0-7606A1BA6F58@evaristesys.com>
Archived-At: 
 <https://www.postgresql.org/message-id/8C52F074-25E7-4AA7-93C0-7606A1BA6F58%40evaristesys.com>
Precedence: bulk

Well, you've come to the right place. This list loves "feelings-based" =
diagnoses. :)=20

Two suggestions:

1) Turn on your "slow query log":

ALTER SYSTEM SET log_min_duration_statement =3D 50;
SELECT pg_reload_conf();

Then look at the Postgres log and see which statements may be running =
slowly.

2) Have a look at `SELECT * FROM pg_stat_activity` and get your =
bearings.

-- Alex

> On 1 Mar 2024, at 12:40, Jean-Paul POZZI <jp.pozzi@izzop.net> wrote:
>=20
> Hello,
>   Some examples of the "bad" sql text should be interesting ...
>  Regards
>=20
> De: "Harish Harish" <hpt3009@gmail.com>=20
> =C3=80: "undefined" <pgsql-admin@lists.postgresql.org>=20
> Envoy=C3=A9: vendredi 1 mars 2024 17:39=20
> Objet: Missing indexes=20
>=20
> Dear Admins,=20
>   I need help. We are on Postgres 10. and have a feeling there are =
some indexes missing wich is causing performance issue
>   Please help me find the missing index within  PostgreSQl 10.
>   Your timely help and support is much appreciated.
>   Best Regards,
> Hari

--=20
Alex Balashov
Principal Consultant
Evariste Systems LLC
Web: https://evaristesys.com
Tel: +1-706-510-6800