Re: Missing indexes

On 2024-03-01 17:37 +0100, Harish Harish wrote:
> I need help. We are on Postgres 10.

General advice: Upgrade to a supported version because support for pg10
ended in November 2022.

> and have a feeling there are some indexes missing wich is causing
> performance issue

Are the table statistics up to date?  Run ANALYZE on the relevant tables
to be sure.

> Please help me find the missing index within  PostgreSQl 10.

You need to provide the queries in question and their execution plans[1]
with EXPLAIN (ANALYZE, BUFFERS).  Table definitions (including indexes)
are also helpful.

Also good to know: Is it a performance regression caused by recent
changes to those queries?  That may already give you hints on possibly
missing indexes.

[1] https://www.postgresql.org/docs/10/sql-explain.html

-- 
Erik