From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Shikha, Kumari - Dell Team" <Kumari.Shikha@dellteam.com>
cc: pgsql-bugs@lists.postgresql.org,
        "Alampalli, Kishore" <Kishoreravishankar.Alampalli@dellteam.com>,
        "Kishore, Nanda - Dell Team" <Nanda.Kishore@Dellteam.com>,
        "Maind,
    Saurabh - Dell Team" <Saurabh.Maind@Dellteam.com>,
        "Sardar,
    Mansingh - Dell Team" <M.Sardar@Dellteam.com>
Subject: Re: Need assistance in performance tuning of a particular query
In-reply-to: 
 <BY5PR19MB4034C6F9A2CA15755EBA10629E969@BY5PR19MB4034.namprd19.prod.outlook.com>
References: <168088399043.1074.17126982733110935657@malur.postgresql.org>
 <BY5PR19MB40341216DE1F02AC760287E19E969@BY5PR19MB4034.namprd19.prod.outlook.com>
 <BY5PR19MB4034C6F9A2CA15755EBA10629E969@BY5PR19MB4034.namprd19.prod.outlook.com>
Comments: In-reply-to "Shikha,
 Kumari - Dell Team" <Kumari.Shikha@dellteam.com>
	message dated "Fri, 07 Apr 2023 16:46:34 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3049455.1680888983.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 07 Apr 2023 13:36:23 -0400
Message-ID: <3049456.1680888983@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3049456.1680888983%40sss.pgh.pa.us>
Precedence: bulk

"Shikha, Kumari - Dell Team" <Kumari.Shikha@dellteam.com> writes:
> I am writing to seek guidance regarding an issue that we have been facin=
g recently. We have an escalation that after migrating to PG13 from PG10, =
a particular DB query is taking huge amount of time to fetch the results. =
 It=E2=80=99s taking hours together to fetch the data while it used to run=
 smoothly and fetched data within minutes on PG10.   =


This is not a bug report; please do not use the -bugs list for it.
pgsql-performance would be an appropriate venue.

Please see

https://wiki.postgresql.org/wiki/Slow_Query_Questions

for some guidance about asking performance questions.

			regards, tom lane