Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsnzD-005ik1-5S for pgsql-general@arkaria.postgresql.org; Thu, 13 Mar 2025 19:12:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tsnzA-003Q8M-Jk for pgsql-general@arkaria.postgresql.org; Thu, 13 Mar 2025 19:12:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsnzA-003Q1Z-6i for pgsql-general@lists.postgresql.org; Thu, 13 Mar 2025 19:12:52 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tsnz6-002hWH-2A for pgsql-general@lists.postgresql.org; Thu, 13 Mar 2025 19:12:51 +0000 Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-5e61da95244so2357455a12.2 for ; Thu, 13 Mar 2025 12:12:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741893168; x=1742497968; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=NmQneS1ZtuBS3q+sSrWUokIRR1KQEt8/x8yd9r8C73A=; b=KgJQSxmpJzq7Vhi87zJdklR6uG5Hkkf6nS2mU4Krd+Le1r1+XS17aPZ2yQxV84x5os jDTjjA4PnfPnesuHXDPefPwqt7CVxRrrYQs2ewXRYEmzGUYKFgKBUB4AgiMJCOI7UX4g ORJlgG4v6lYkiQXFZ+8s1aq/ifk2QpcQg2pNGZSaxQBwW1cg2FgE2daNgYqrt1yPsGRd ZI1bhpRbL8Yf33NcEZA6kqJRbN6a3Z0my2hyz3K4D0+NAg1cVoPkoJ6lgIGYDNjHnKAN Z0sARRkkVXWbNzskTF0jx/quwO+Qn5lVRaRlxiaWu/ETMavDySyCu4bBgWDEG9f0eFRn Xv2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741893168; x=1742497968; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=NmQneS1ZtuBS3q+sSrWUokIRR1KQEt8/x8yd9r8C73A=; b=muviPr0/31GOnZT16Z+A5oOG2r+dgoexaCgL1lZMB7dU7hsZ9oVBYBZQhm+9nlFJSx 2L03KsHJ4WLdRrRfcpn9r3+IJ76OgbpEpGdxwDQbkQLxaafc/0utqOZNr02xS4JMsK0X AJewQcHL1XmX4BokuBJU/qE3nnLOIrwRAxvh6yiWfMrPKjGLnwzWzc+DBiSTRvSBq8x5 XruYo/JtPSx+SP2LjsV5huYZPK/YRCJ/a47kwVpdKrUFElrJG5k2VjWN7nXaq9DTNzny aXUS1BbdS0y0FTd4eqfKkY2ox+mgoQzymWxDidf5UiZT8xrr5bFzO0rAkWJ5OdcuR/qo UA+w== X-Gm-Message-State: AOJu0Yw6OQXXPTHnpYLIUBRBgMR5Lvr4inJS9Hc2NXIvEyf36i+Kwa6+ 6r460K4v12SeYOZInVucUvUAW5ZDOKBhgdzdnGPvKGxvCXfMLVfBse/nf87eNvFs3WrPRE0ZzmO 6rA6GtO45I11ORf+0/9Uml8hw0+9ZlA== X-Gm-Gg: ASbGnctpb6WBAi3Ngv3BI/nzztDz5JDEuFxs7O45Tp0S+iZcscmrZfI+PpnicUN095j mueqjV7ouICqkB3XknL8wo9qsgZIDsSV12qQciKCOzgYxFIy2KCshLdzV/GcH2Bq9hWfL4sWaMG uoOjg52OVejSpjIHXn1poP8UmUOY2GO/hgbeiS X-Google-Smtp-Source: AGHT+IEfaG3M8Nypa9GHGq6UeoZgyxOLmoqRfxl3aXVNEKMFNJhH6em2mca9y1qWJrrbPh0vNorgQkzAgXJ/oJGl7tg= X-Received: by 2002:a17:907:2ce3:b0:abf:4da0:28e8 with SMTP id a640c23a62f3a-ac328fbcb73mr75152066b.17.1741893168168; Thu, 13 Mar 2025 12:12:48 -0700 (PDT) MIME-Version: 1.0 From: Durgamahesh Manne Date: Fri, 14 Mar 2025 00:42:36 +0530 X-Gm-Features: AQ5f1JoXL4TzIQlc33_KbihekcaFfHp0VMxlOv4e__WlU874bbziyBkGOi2d6Bk Message-ID: Subject: Query optimization To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000868c3006303e1b44" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000868c3006303e1b44 Content-Type: text/plain; charset="UTF-8" Hi Team This query takes more time than usual for execution How to optimize it in best possible way Columns used in this query >> composite index eventhough not running optimally SELECT EXISTS (SELECT Key FROM CACHEKEYS WHERE CacheType = $1 AND TrsId = $2 AND BrandId = $3 AND SportId = $4 AND CompetitionId = $5 AND EventId = $6 AND MarketId = $7 LIMIT ?) Regards Durga Mahesh --000000000000868c3006303e1b44 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Team

This query takes more=C2=A0time than usual for executio= n=C2=A0

How to optimize = it in best possible way

= Columns used in this query >> composite index eventhough not running = optimally=C2=A0



SELECT EXISTS (SELECT Key FROM CACHEKEYS WHER= E CacheType =3D $1 AND TrsId =3D $2 AND BrandId =3D $3 AND SportId =3D $4 A= ND CompetitionId =3D $5 AND EventId =3D $6 AND MarketId =3D $7 LIMIT ?)
Regards=C2=A0
Durga Mahesh=C2=A0
--000000000000868c3006303e1b44--