From: Laurenz Albe <laurenz.albe@cybertec.at>
To: M Sarwar <sarwarmd02@outlook.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How to tune SQL performance of function based columns of a view
Date: Mon, 08 Apr 2024 11:56:45 +0200
Message-ID: <8afe1155bcc48e2491a1fef8e5af2f5d7d195fb6.camel@cybertec.at> (raw)
In-Reply-To: <DM4PR19MB597881373C3C734258573A11D3022@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <PH2P110MB0922A59A7B8B36839227589CFF02A@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
<DM4PR19MB597881373C3C734258573A11D3022@DM4PR19MB5978.namprd19.prod.outlook.com>
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.
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, sarwarmd02@outlook.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to tune SQL performance of function based columns of a view
In-Reply-To: <8afe1155bcc48e2491a1fef8e5af2f5d7d195fb6.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox