Re: Missing indexes

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(dot)pozzi(at)izzop(dot)net> wrote:
>
> Hello,
> Some examples of the "bad" sql text should be interesting ...
> Regards
>
> De: "Harish Harish" <hpt3009(at)gmail(dot)com>
> À: "undefined" <pgsql-admin(at)lists(dot)postgresql(dot)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