Postgres Pro
Downloads
Home   >   mailing lists

Query optimization - Mailing list pgsql-general

From Durgamahesh Manne
Subject Query optimization
Date
Msg-id CAJCZkoL+DHs0H9enQEg8JXZw=7032zrmFKG8Vx0fup6_wqNpnQ@mail.gmail.com
Whole thread Raw
Responses Re: Query optimization
Re: Query optimization
List pgsql-general
Tree view
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 

pgsql-general by date:

Previous
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: hide data from admins
Next
From: Greg Sabino Mullane
Date:
Subject: Re: hide data from admins