Horton
Menu

Query optimization

Durgamahesh Manne <maheshpostgres9@gmail.com>

View thread
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2025-03-13T19:12:36Z
Lists: pgsql-general 
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