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 [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
