Calma sou novo com banco de dados Em 17/09/2016 17:10, Guimarães Faria Corcete DUTRA, Leandro escreveu:
planos de execução
"GroupAggregate (cost=77447.00..77447.10 rows=2 width=412)" " -> Sort (cost=77447.00..77447.00 rows=2 width=412)" " Sort Key: ('Saídas '::character(15)), its.codigo_empresa, ite.codigo_anterior" " -> Result (cost=38723.47..77446.99 rows=2 width=412)" " -> Append (cost=38723.47..77446.99 rows=2 width=412)" " -> HashAggregate (cost=38723.47..38723.48 rows=1 width=24)" " -> Nested Loop (cost=0.00..38716.21 rows=57 width=24)" " -> Nested Loop (cost=0.00..16.55 rows=1 width=13)" " -> Index Scan using pk_item_codigo on item ite (cost=0.00..8.27 rows=1 width=13)" " Index Cond: (codigo = 724)" " -> Index Scan using pk_unidade_codigo on unidade un (cost=0.00..8.27 rows=1 width=8)" " Index Cond: (codigo = ite.codigo_unidade)" " -> Index Scan using idx_item_mensal_datfec on item_mensal its (cost=0.00..38699.08 rows=57 width=19)" " Index Cond: ((ano_ref >= '2015-10-01'::date) AND (ano_ref <= '2016-09-30'::date) AND (codigo_item = 724))" " -> HashAggregate (cost=38723.47..38723.48 rows=1 width=23)" " -> Nested Loop (cost=0.00..38716.21 rows=57 width=23)" " -> Nested Loop (cost=0.00..16.55 rows=1 width=13)" " -> Index Scan using pk_item_codigo on item ite (cost=0.00..8.27 rows=1 width=13)" " Index Cond: (codigo = 724)" " -> Index Scan using pk_unidade_codigo on unidade un (cost=0.00..8.27 rows=1 width=8)" " Index Cond: (codigo = ite.codigo_unidade)" " -> Index Scan using idx_item_mensal_datfec on item_mensal its (cost=0.00..38699.08 rows=57 width=18)" " Index Cond: ((ano_ref >= '2015-10-01'::date) AND (ano_ref <= '2016-09-30'::date) AND (codigo_item = 724))"
<<attachment: cgcesarsoares.vcf>>
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral