On Thu, Feb 21, 2008 at 2:48 PM, Adonias Malosso <malosso@xxxxxxxxx> wrote: > Hi all, > > The following query takes about 4s to run in a 16GB ram server. Any ideas > why it doesn´t use index for the primary keys in the join conditions? > > select i.inuid, count(*) as total > from cte.instrumentounidade i > inner join cte.pontuacao p on p.inuid = i.inuid > inner join cte.acaoindicador ai on ai.ptoid = p.ptoid > inner join cte.subacaoindicador si on si.aciid = ai.aciid > where i.itrid = 2 and p.ptostatus = 'A' > group by i.inuid > having count(*) > 0 What does explain analyze say about that query? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
