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

Responder a