Message-ID: <3c797d81-49e6-e8a2-b1b0-b63cb25901e5@jakobs.com>
Date: Thu, 11 May 2023 17:11:07 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.10.0
Subject: Re: Related To Query Optimization
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CAKDb7aG9od8XB=3YCDe61JPTqjC0BD71usWN-sr5DAMJZPhH1w@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAKDb7aG9od8XB=3YCDe61JPTqjC0BD71usWN-sr5DAMJZPhH1w@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------gty27WW9BPqnCFVEAE7P96Ha"
Archived-At: 
 <https://www.postgresql.org/message-id/3c797d81-49e6-e8a2-b1b0-b63cb25901e5%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------gty27WW9BPqnCFVEAE7P96Ha
Content-Type: multipart/mixed; boundary="------------GN5mjXvpRSW008gQeEBNgpTK";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <3c797d81-49e6-e8a2-b1b0-b63cb25901e5@jakobs.com>
Subject: Re: Related To Query Optimization
References: <CAKDb7aG9od8XB=3YCDe61JPTqjC0BD71usWN-sr5DAMJZPhH1w@mail.gmail.com>
In-Reply-To: <CAKDb7aG9od8XB=3YCDe61JPTqjC0BD71usWN-sr5DAMJZPhH1w@mail.gmail.com>

--------------GN5mjXvpRSW008gQeEBNgpTK
Content-Type: multipart/alternative;
 boundary="------------aFX9ymWuDlnsGiwWSaWlvCid"

--------------aFX9ymWuDlnsGiwWSaWlvCid
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMTEuMDUuMjMgdW0gMTY6NTAgc2NocmllYiBST0hJVCBTQUNIREVWQToNCj4NCj4gSGkg
VGVhbSwNCj4NCj4gwqBJIGFtIGZhY2luZyBhbiBpc3N1ZSB3aGVyZSBvbmUgb2YgdGhlIHF1
ZXJpZXMgaXMgdGFraW5nIHRpbWUgaW4gDQo+IHByb2R1Y3Rpb24uDQo+IFdoZW4gSSBwdXQg
dGhhdCBxdWVyeSBpbiBleHBsYWluLCBJIGZvdW5kIG1hbnkgbmVzdGVkIGxvb3AgY29uZGl0
aW9ucyANCj4gd2VyZSBiZWluZyB1c2VkLCBzbyBqdXN0IGZvciB0ZXN0aW5nLCBJIGRpc2Fi
bGVkIHRoZSBlbmFibGVfbmVzdGxvb3AgDQo+IGZsYWcgZm9yIGEgc2Vzc2lvbiwgYW5kIG5v
dyB0aGUgcXVlcnkgaXMgcnVubmluZyBmYXN0Lg0KPiBJIGFsc28gcmFuIGFuIGFuYWx5emUg
b24gZXZlcnkgdGFibGUgb2YgdGhhdCBxdWVyeSBhbmQgYWxzbyBpbmRleGluZyANCj4gaXMg
dGhlcmUgb24gcmVxdWlyZWQgY29sdW1ucy4NCj4NCj4gwqBUZWxsIG1lIHdoZXJlIGkgYW0g
d3JvbmcgYW5kIHdoYXQgY2FuIGJlIGRvbmUsIGFzIGkgZG9uJ3Qgd2FudCB0byANCj4gZGlz
YWJsZSBpdCBiZWNhdXNlLCBhY2NvcmRpbmcgdG8gbWUsIGl0J3Mgbm90IGEgZ29vZCBwcmFj
dGlzZS4NCj4NCj4NCj4gLS0NCj4gSGF2ZSBhIEdvb2QgZGF5ICEhIQ0KPg0KPiBSZWdhcmRz
DQo+IFJvaGl0IFNhY2hkZXZhDQoNCkkgdGhpbmsgaXQncyB0b3RhbGx5IGltcG9zc2libGUg
dG8gdGVsbCB3aXRob3V0IGtub3dpbmcgbW9yZSBkZXRhaWxzLg0KDQpQbGVhc2UgcG9zdCB0
aGUgQ1JFQVRFIFRBQkxFIGNvbW1hbmRzLCB0aGUgbnVtYmVyIG9mIHJvd3MgaW4gdGhlIHRh
YmxlcywgDQp0aGUgU0VMRUNUIGNvbW1hbmQgYW5kIHRoZSBvdXRwdXQgb2YgRVhQTEFJTi4N
Cg0KS2luZCBSZWdhcmRzLA0KDQpIb2xnZXINCg0KDQo+IC0tIA0KDQpIb2xnZXIgSmFrb2Jz
LCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K
--------------aFX9ymWuDlnsGiwWSaWlvCid
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 11.05.23 um 16:50 schrieb ROHIT
      SACHDEVA:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAKDb7aG9od8XB=3D3YCDe61JPTqjC0BD71usWN-sr5DAMJZPhH1w@mail.gm=
ail.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr"><br clear=3D"all">
        <div>Hi Team,
          <div><br>
          </div>
          <div>=C2=A0I am facing an issue where one of the queries is tak=
ing
            time in production.<br style=3D"color:rgb(37,37,37)">
            When I put that query in explain, I found many nested loop
            conditions were being used, so just for testing, I disabled
            the enable_nestloop flag for a session, and now the query is
            running fast.<br style=3D"color:rgb(37,37,37)">
            I also ran an analyze on every table of that query and also
            indexing is there on required columns.<br>
          </div>
          <div><br>
          </div>
          <div>=C2=A0Tell me where i am wrong and what can be done, as i
            don't want to disable it because, according to me, it's not
            a good practise.=C2=A0=C2=A0<br>
          </div>
          <div><br>
          </div>
          <div><br>
          </div>
          <div>--<br>
          </div>
          <div>
            <div dir=3D"ltr">Have a Good day !!!<br>
              <br>
              Regards<font color=3D"#888888"><br>
                Rohit Sachdeva</font></div>
          </div>
        </div>
        <span class=3D"gmail_signature_prefix"></span></div>
    </blockquote>
    <p>I think it's totally impossible to tell without knowing more
      details.</p>
    <p>Please post the CREATE TABLE commands, the number of rows in the
      tables, the SELECT command and the output of EXPLAIN.</p>
    <p>Kind Regards,</p>
    <p>Holger<br>
    </p>
    <p><br>
    </p>
    <blockquote type=3D"cite"
cite=3D"mid:CAKDb7aG9od8XB=3D3YCDe61JPTqjC0BD71usWN-sr5DAMJZPhH1w@mail.gm=
ail.com">
      <div dir=3D"ltr">-- </div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">Holger Jakobs, Bergisch Glad=
bach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------aFX9ymWuDlnsGiwWSaWlvCid--

--------------GN5mjXvpRSW008gQeEBNgpTK--

--------------gty27WW9BPqnCFVEAE7P96Ha
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZF0FiwUDAAAAAAAKCRCKV5yTsxlhuq4y
AJ9pzTsrXfuzAp1rjAm9n0HgvqNJEgCgvily5PpjOLId7ldi4FbwJ8YGhVk=
=2xnB
-----END PGP SIGNATURE-----

--------------gty27WW9BPqnCFVEAE7P96Ha--