From: Alex Balashov <abalashov@evaristesys.com>
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Missing indexes
Date: Fri, 1 Mar 2024 12:42:11 -0500
Message-ID: <8C52F074-25E7-4AA7-93C0-7606A1BA6F58@evaristesys.com> (raw)
In-Reply-To: <1883261458.1984.1709314823544.JavaMail.zextras@jpp.fr>
References: <CANc-nPuFe-HmHCfwQfgcvbrSbmgcxmT2Q0H4nUqqZNuy2tFRdw@mail.gmail.com>
<1883261458.1984.1709314823544.JavaMail.zextras@jpp.fr>
Well, you've come to the right place. This list loves "feelings-based" diagnoses. :)
Two suggestions:
1) Turn on your "slow query log":
ALTER SYSTEM SET log_min_duration_statement = 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:
>
> Hello,
> Some examples of the "bad" sql text should be interesting ...
> Regards
>
> De: "Harish Harish" <hpt3009@gmail.com>
> À: "undefined" <pgsql-admin@lists.postgresql.org>
> Envoyé: vendredi 1 mars 2024 17:39
> Objet: Missing indexes
>
> Dear Admins,
> 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
--
Alex Balashov
Principal Consultant
Evariste Systems LLC
Web: https://evaristesys.com
Tel: +1-706-510-6800
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: abalashov@evaristesys.com, pgsql-admin@lists.postgresql.org
Subject: Re: Missing indexes
In-Reply-To: <8C52F074-25E7-4AA7-93C0-7606A1BA6F58@evaristesys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox