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