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@xxxxxxxxx> wrote: > > Hello, > Some examples of the "bad" sql text should be interesting ... > Regards > > De: "Harish Harish" <hpt3009@xxxxxxxxx> > À: "undefined" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> > 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
