Obrigado pela ajuda. 2008/7/1 jota. comm <[EMAIL PROTECTED]>:
> Ola, Guilherme > > Aqui está: > http://www.postgresql.org/docs/8.3/interactive/using-explain.html > > []s > > 2008/7/1 Guilherme Carvalho <[EMAIL PROTECTED]>: > >> Alguém poderia me indicar um material para me ajuda a interpretar o >> resultado do comando EXPLAIN? É que estou fazendo uns testes de comparação >> entre consultas com INNER/LEFT JOIN e Subquery (Cláusula IN) >> >> Obrigado. >> >> P.S Exemplo do resultado do EXPLAIN: >> >> QUERY >> PLAN >> >> Nested Loop (cost=19.33..46.85 rows=4 >> width=68) >> -> Nested Loop (cost=19.33..45.60 rows=4 >> width=72) >> -> Hash Join (cost=15.01..30.65 rows=1 >> width=72) >> Hash Cond: (pr.idprocesso = >> adv.fkprocesso) >> >> -> Seq Scan on processo pr (cost=0.00..15.63 rows=2 >> width=68) >> Filter: (situacao = >> 0) >> >> -> Hash (cost=14.88..14.88 rows=10 >> width=4) >> -> Bitmap Heap Scan on advogado_processo adv (cost=4.33..14.88 rows=10 >> width=4) >> Recheck Cond: (fkadvogado = >> 2) >> >> -> Bitmap Index Scan on fkadvogado_processo (cost=0.00..4.33 rows=10 >> width=0) >> Index Cond: (fkadvogado = >> 2) >> >> -> Bitmap Heap Scan on contrario_processo cp (cost=4.32..14.84 rows=9 >> width=8) >> Recheck Cond: (pr.idprocesso = >> cp.fkprocesso) >> -> Bitmap Index Scan on fkcontrarioprocesso_processo (cost=0.00..4.32 >> rows=9 width=0) >> Index Cond: (pr.idprocesso = >> cp.fkprocesso) >> >> -> Index Scan using pk_contrario_idcontrario on contrario ct >> (cost=0.00..0.30 rows=1 width=4) >> Index Cond: (ct.idcontrario = >> cp.fkcontrario) >> Filter: (lower((nome)::text) ~~ '%a%'::text) >> >> -- >> Guilherme de Carvalho Carneiro >> guilherme.carvalho[a]advogaweb.com.br >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > -- > João Paulo > www.dextra.com.br/postgres > PostgreSQL > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Guilherme de Carvalho Carneiro guilherme.carvalho[a]advogaweb.com.br
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
