I thought that I have tried this option but I am try this option another time.
Thanks,
Sarwar
From: Laurenz Albe <laurenz.albe@cybertec.at> Sent: Monday, April 8, 2024 5:56 AM To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> Subject: Re: How to tune SQL performance of function based columns of a view
On Sat, 2024-04-06 at 04:33 +0000, M Sarwar wrote: > I am working on SQL performance issue. > > After analyzing the results from the file, Explain-Analyze-Net-Temps-Slow-Response-Bao.xlsx, > I tried to create several indexes one by one based on the possibility from Explain analyze > results and none of them are helping in improving the performance of SQL. > I am just trying to know what are the other approaches which I can use to resolve this performance issue.
According to my reading of the execution plan, the following index should help a lot:
CREATE INDEX ON test_part_details_all_mcm_mid (serial_number, stage, temperature);
There might be more gains in rewriting whatever caused this subquery.