explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jj3t : cons_fran

Settings
# exclusive inclusive rows x rows loops node
1. 4,327.484 11,479.338 ↑ 2.6 236,390 1

Merge Right Join (cost=8,491.67..172,287.43 rows=605,886 width=1,152) (actual time=1,267.004..11,479.338 rows=236,390 loops=1)

  • Output: s.data, nc.descricao, ((((CASE WHEN (ge.id IS NULL) THEN ''::character varying ELSE ge.descricao END)::text || CASE WHEN (me.id IS NULL) THEN ''::text ELSE ((' ('::text || (me.descricao)::text) || ')'::text) END) || CASE WHEN ((ge.id IS NOT NULL) OR (me.id IS NOT NULL)) THEN ' - '::text ELSE ''::text END) || CASE WHEN (acon.quantidade_minima = '1'::numeric) THEN CASE WHEN (acon.quantidade_minima = acon.quantidade_maxima) THEN ((btrim(to_char((acon.quantidade_minima)::real, '99999990D00'::text), ' '::text) || ' '::text) || upper((medida.simbolo)::text)) ELSE ((((btrim(to_char((acon.quantidade_minima)::real, '99999990D00'::text), '
  • '::text) || ' - '::text) || btrim(to_char((acon.quantidade_maxima)::real, '99999990D00'::text), ' '::text)) || ' '::text) || upper((medida.simbolo)::text)) END ELSE upper((medida.simbolo)::text) END), s.id, nc.id, um.id, mun.nome, CASE WHEN (produto.nome IS NOT NULL) THEN produto.nome ELSE produto_pgpm.nome END, s.situacao, consulta_tipificacao.tipificacao, s.unidade_federacao_fk, p.data_final
  • Merge Cond: (p.serie_fk = s.id)
  • Buffers: shared hit=2,989,233, temp read=181 written=261
2.          

CTE consulta_tipificacao

3. 73.303 1,055.321 ↑ 1.0 12,806 1

Hash Left Join (cost=916.68..4,417.73 rows=12,806 width=40) (actual time=56.555..1,055.321 rows=12,806 loops=1)

  • Output: abstractcl6_.id, replace((((((((((((((((((((((((((((((((COALESCE((','::text || (concentrac17_.descricao)::text), ''::text) || COALESCE((', '::text || (ingredient18_.descricao)::text), ''::text)) || COALESCE((', '::text || (tracaoimpl20_.descricao)::text), ''::text)) || COALESCE((', '::text || (marcaimpl21_.descricao)::text), ''::text)) || COALESCE((', '::text || (modeloimpl22_.descricao)::text), ''::text)) || COALESCE((', '::text || (grupoquimi19_.descricao)::text), ''::text)) || COALESCE((', '::text || (classeimpl12_.descricao)::text), ''::text)) || COALESCE((', '::text || (cultivoimp14_.descricao)::text), ''::text)) || COALESCE((', '::text || (estadofisi24_.descricao)::text), ''::text)) || COALESCE((', '::text || (gramaturai25_.descricao)::text), ''::text)) || COALESCE((', '::text || (origemprod13_.descricao)::text), ''::text)) || COALESCE((', '::text || (tipificaca16_.descricao)::text), ''::text)) || COALESCE((', '::text || (potenciaim15_.descricao)::text), ''::text)) || COALESCE((', '::text || (corimpl23_.descricao)::text), ''::text)) || COALESCE((', '::text || (grupoimpl32_.descricao)::text), ''::text)) || COALESCE((', '::text || (subgrupoim28_.descricao)::text), ''::text)) || COALESCE((', '::text || (classeimpl30_.descricao)::text), ''::text)) || COALESCE((', '::text || (subclassei29_.descricao)::text), ''::text)) || COALESCE((', '::text || (tipoimpl31_.descricao)::text), ''::text)) || COALESCE((', '::text || (residuoben35_.descricao)::text), ''::text)) || COALESCE((', '::text || (residuofia43_.descricao)::text), ''::text)) || COALESCE((', '::text || (corimpl37_.descricao)::text), ''::text)) || COALESCE((', '::text || (formaapres42_.descricao)::text), ''::text)) || COALESCE((', '::text || (categoriai27_.descricao)::text), ''::text)) || COALESCE((', '::text || (subcategor36_.descricao)::text), ''::text)) || COALESCE((', '::text || (graufolhai33_.descricao)::text), ''::text)) || COALESCE((', '::text || (compriment34_.descricao)::text), ''::text)) || COALESCE((', '::text || (graosintei40_.descricao)::text), ''::text)) || COALESCE((', '::text || (micronaire38_.descricao)::text), ''::text)) || COALESCE((', '::text || (resistenci39_.descricao)::text), ''::text)) || COALESCE((', '::text || (gramaturai41_.descricao)::text), ''::text)) || CASE WHEN ((classeimpl12_.descricao IS NULL) AND (origemprod13_.descricao IS NULL) AND (cultivoimp14_.descricao IS NULL) AND (potenciaim15_.descricao IS NULL) AND (tipificaca16_.descricao IS NULL) AND (concentrac17_.descricao IS NULL) AND (ingredient18_.descricao IS NULL) AND (grupoquimi19_.descricao IS NULL) AND (tracaoimpl20_.descricao IS NULL) AND (marcaimpl21_.descricao IS NULL) AND (modeloimpl22_.descricao IS NULL) AND (corimpl23_.descricao IS NULL) AND (estadofisi24_.descricao IS NULL) AND (gramaturai25_.descricao IS NULL) AND (categoriai27_.descricao IS NULL) AND (subgrupoim28_.descricao IS NULL) AND (subclassei29_.descricao IS NULL) AND (classeimpl30_.descricao IS NULL) AND (grupoimpl32_.descricao IS NULL) AND (graufolhai33_.descricao IS NULL) AND (compriment34_.descricao IS NULL) AND (residuoben35_.descricao IS NULL) AND (subcategor36_.descricao IS NULL) AND (corimpl37_.descricao IS NULL) AND (micronaire38_.descricao IS NULL) AND (resistenci39_.descricao IS NULL) AND (graosintei40_.descricao IS NULL) AND (gramaturai41_.descricao IS NULL) AND (formaapres42_.descricao IS NULL) AND (residuofia43_.descricao IS NULL) AND (tipoimpl31_.descricao IS NULL)) THEN '(Classificação sem características)'::text ELSE ''::text END), ' , '::text, ' '::text)
  • Inner Unique: true
  • Hash Cond: (classifica26_.forma_apresentacao_fk = formaapres42_.id)
  • Buffers: shared hit=357
4. 26.689 982.013 ↑ 1.0 12,806 1

Hash Left Join (cost=903.53..2,354.02 rows=12,806 width=9,459) (actual time=56.526..982.013 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao, tipoimpl31_.descricao, graufolhai33_.descricao, residuoben35_.descricao, subgrupoim28_.descricao, gramaturai41_.descricao, residuofia43_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.residuo_fiacao_fk = residuofia43_.id)
  • Buffers: shared hit=357
5. 26.819 955.315 ↑ 1.0 12,806 1

Hash Left Join (cost=890.38..2,307.25 rows=12,806 width=8,951) (actual time=56.509..955.315 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao, tipoimpl31_.descricao, graufolhai33_.descricao, residuoben35_.descricao, subgrupoim28_.descricao, gramaturai41_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.gramatura_fk = gramaturai41_.id)
  • Buffers: shared hit=357
6. 26.368 928.436 ↑ 1.0 12,806 1

Hash Left Join (cost=888.75..2,271.93 rows=12,806 width=8,443) (actual time=56.442..928.436 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao, tipoimpl31_.descricao, graufolhai33_.descricao, residuoben35_.descricao, subgrupoim28_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.sub_grupo_fk = subgrupoim28_.id)
  • Buffers: shared hit=356
7. 27.003 901.971 ↑ 1.0 12,806 1

Hash Left Join (cost=886.67..2,235.23 rows=12,806 width=7,935) (actual time=56.337..901.971 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao, tipoimpl31_.descricao, graufolhai33_.descricao, residuoben35_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.residuo_beneficiamento_fk = residuoben35_.id)
  • Buffers: shared hit=355
8. 26.483 874.963 ↑ 1.0 12,806 1

Hash Left Join (cost=873.52..2,188.47 rows=12,806 width=7,427) (actual time=56.323..874.963 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao, tipoimpl31_.descricao, graufolhai33_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.grau_folha_fk = graufolhai33_.id)
  • Buffers: shared hit=355
9. 27.254 848.457 ↑ 1.0 12,806 1

Hash Left Join (cost=872.36..2,144.98 rows=12,806 width=6,919) (actual time=56.292..848.457 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao, tipoimpl31_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.tipo_fk = tipoimpl31_.id)
  • Buffers: shared hit=354
10. 27.145 820.999 ↑ 1.0 12,806 1

Hash Left Join (cost=869.11..2,106.70 rows=12,806 width=6,917) (actual time=56.077..820.999 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao, subclassei29_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.sub_classe_fk = subclassei29_.id)
  • Buffers: shared hit=353
11. 27.192 793.805 ↑ 1.0 12,806 1

Hash Left Join (cost=867.73..2,070.57 rows=12,806 width=6,409) (actual time=56.017..793.805 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao, compriment34_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.comprimento_fibra_fk = compriment34_.id)
  • Buffers: shared hit=352
12. 27.128 766.600 ↑ 1.0 12,806 1

Hash Left Join (cost=866.66..2,015.56 rows=12,806 width=5,901) (actual time=55.996..766.600 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao, grupoimpl32_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.grupo_fk = grupoimpl32_.id)
  • Buffers: shared hit=351
13. 27.062 739.347 ↑ 1.0 12,806 1

Hash Left Join (cost=864.20..1,978.40 rows=12,806 width=5,898) (actual time=55.863..739.347 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao, resistenci39_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.resistencia_fk = resistenci39_.id)
  • Buffers: shared hit=350
14. 26.948 712.269 ↑ 1.0 12,806 1

Hash Left Join (cost=863.13..1,923.40 rows=12,806 width=5,390) (actual time=55.837..712.269 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao, micronaire38_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.micronaire_fk = micronaire38_.id)
  • Buffers: shared hit=349
15. 27.220 685.301 ↑ 1.0 12,806 1

Hash Left Join (cost=862.07..1,868.39 rows=12,806 width=4,882) (actual time=55.805..685.301 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao, classeimpl30_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.classe_fk = classeimpl30_.id)
  • Buffers: shared hit=348
16. 26.745 657.060 ↑ 1.0 12,806 1

Hash Left Join (cost=845.76..1,818.33 rows=12,806 width=4,876) (actual time=54.777..657.060 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao, categoriai27_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.categoria_fk = categoriai27_.id)
  • Buffers: shared hit=344
17. 27.420 630.292 ↑ 1.0 12,806 1

Hash Left Join (cost=844.58..1,783.49 rows=12,806 width=4,368) (actual time=54.746..630.292 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.categoria_fk, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao, corimpl37_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.cor_fk = corimpl37_.id)
  • Buffers: shared hit=343
18. 26.552 602.837 ↑ 1.0 12,806 1

Hash Left Join (cost=843.24..1,744.34 rows=12,806 width=3,860) (actual time=54.703..602.837 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.cor_fk, classifica26_.categoria_fk, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao, graosintei40_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.grao_inteiro_fk = graosintei40_.id)
  • Buffers: shared hit=342
19. 27.292 576.241 ↑ 1.0 12,806 1

Hash Left Join (cost=841.79..1,709.12 rows=12,806 width=3,352) (actual time=54.651..576.241 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.grao_inteiro_fk, classifica26_.cor_fk, classifica26_.categoria_fk, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk, subcategor36_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica26_.sub_categoria_fk = subcategor36_.id)
  • Buffers: shared hit=341
20. 29.790 548.927 ↑ 1.0 12,806 1

Hash Left Join (cost=840.66..1,674.32 rows=12,806 width=2,844) (actual time=54.618..548.927 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, estadofisi24_.descricao, classifica26_.sub_categoria_fk, classifica26_.grao_inteiro_fk, classifica26_.cor_fk, classifica26_.categoria_fk, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk
  • Inner Unique: true
  • Hash Cond: (abstractcl6_2.classificacao_caracteristica_pauta_pgpm_fk = classifica26_.id)
  • Buffers: shared hit=340
21. 25.894 509.801 ↑ 1.0 12,806 1

Hash Left Join (cost=704.99..1,505.00 rows=12,806 width=2,716) (actual time=45.267..509.801 rows=12,806 loops=1)

  • Output: abstractcl6_.id, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, abstractcl6_2.classificacao_caracteristica_pauta_pgpm_fk, estadofisi24_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.estado_fisico_fk = estadofisi24_.id)
  • Buffers: shared hit=298
22. 28.553 483.760 ↑ 1.0 12,806 1

Hash Left Join (cost=702.55..1,468.83 rows=12,806 width=2,713) (actual time=45.109..483.760 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao, abstractcl6_2.classificacao_caracteristica_pauta_pgpm_fk
  • Inner Unique: true
  • Hash Cond: (abstractcl6_.id = abstractcl6_2.id)
  • Buffers: shared hit=297
23. 25.462 446.686 ↑ 1.0 12,806 1

Hash Left Join (cost=564.44..1,297.09 rows=12,806 width=2,705) (actual time=36.573..446.686 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao, gramaturai25_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.gramatura_fk = gramaturai25_.id)
  • Buffers: shared hit=256
24. 25.049 421.154 ↑ 1.0 12,806 1

Hash Left Join (cost=562.81..1,261.84 rows=12,806 width=2,197) (actual time=36.495..421.154 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao, corimpl23_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.cor_fk = corimpl23_.id)
  • Buffers: shared hit=255
25. 25.862 396.067 ↑ 1.0 12,806 1

Hash Left Join (cost=561.47..1,226.82 rows=12,806 width=1,689) (actual time=36.449..396.067 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao, marcaimpl21_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.marca_fk = marcaimpl21_.id)
  • Buffers: shared hit=254
26. 25.403 369.605 ↑ 1.0 12,806 1

Hash Left Join (cost=551.43..1,183.04 rows=12,806 width=1,680) (actual time=35.841..369.605 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao, cultivoimp14_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.cultivo_fk = cultivoimp14_.id)
  • Buffers: shared hit=251
27. 25.581 344.095 ↑ 1.0 12,806 1

Hash Left Join (cost=549.35..1,147.27 rows=12,806 width=1,172) (actual time=35.724..344.095 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao, ingredient18_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.ingrediente_ativo_fk = ingredient18_.id)
  • Buffers: shared hit=250
28. 26.038 317.928 ↑ 1.0 12,806 1

Hash Left Join (cost=539.64..1,103.90 rows=12,806 width=1,162) (actual time=35.129..317.928 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao, classeimpl12_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.classe_fk = classeimpl12_.id)
  • Buffers: shared hit=247
29. 25.203 290.820 ↑ 1.0 12,806 1

Hash Left Join (cost=523.34..1,053.92 rows=12,806 width=1,156) (actual time=34.050..290.820 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao, potenciaim15_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.potencia_fk = potenciaim15_.id)
  • Buffers: shared hit=243
30. 26.775 265.374 ↑ 1.0 12,806 1

Hash Left Join (cost=519.41..1,016.25 rows=12,806 width=1,160) (actual time=33.797..265.374 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao, tipificaca16_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.tipificacao_fk = tipificaca16_.id)
  • Buffers: shared hit=242
31. 25.461 234.053 ↑ 1.0 12,806 1

Hash Left Join (cost=449.56..912.73 rows=12,806 width=1,153) (actual time=29.240..234.053 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao, tracaoimpl20_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.tracao_fk = tracaoimpl20_.id)
  • Buffers: shared hit=225
32. 25.829 208.571 ↑ 1.0 12,806 1

Hash Left Join (cost=448.40..877.04 rows=12,806 width=645) (actual time=29.212..208.571 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao, concentrac17_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.concentracao_fk = concentrac17_.id)
  • Buffers: shared hit=224
33. 26.219 182.359 ↑ 1.0 12,806 1

Hash Left Join (cost=441.72..836.66 rows=12,806 width=643) (actual time=28.820..182.359 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.concentracao_fk, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao, grupoquimi19_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.grupo_quimico_fk = grupoquimi19_.id)
  • Buffers: shared hit=222
34. 26.222 155.833 ↑ 1.0 12,806 1

Hash Left Join (cost=436.32..797.56 rows=12,806 width=629) (actual time=28.504..155.833 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.grupo_quimico_fk, classifica11_.concentracao_fk, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao, modeloimpl22_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.modelo_fk = modeloimpl22_.id)
  • Buffers: shared hit=220
35. 25.330 128.648 ↑ 1.0 12,806 1

Hash Left Join (cost=420.76..748.33 rows=12,806 width=628) (actual time=27.533..128.648 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.modelo_fk, classifica11_.grupo_quimico_fk, classifica11_.concentracao_fk, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk, origemprod13_.descricao
  • Inner Unique: true
  • Hash Cond: (classifica11_.origem_producao_fk = origemprod13_.id)
  • Buffers: shared hit=216
36. 28.673 103.258 ↑ 1.0 12,806 1

Hash Left Join (cost=419.15..712.49 rows=12,806 width=120) (actual time=27.463..103.258 rows=12,806 loops=1)

  • Output: abstractcl6_.id, classifica11_.origem_producao_fk, classifica11_.modelo_fk, classifica11_.grupo_quimico_fk, classifica11_.concentracao_fk, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk
  • Inner Unique: true
  • Hash Cond: (abstractcl6_1.classificacao_caracteristica_fk = classifica11_.id)
  • Buffers: shared hit=215
37. 32.355 63.913 ↑ 1.0 12,806 1

Hash Left Join (cost=270.98..530.67 rows=12,806 width=16) (actual time=16.771..63.913 rows=12,806 loops=1)

  • Output: abstractcl6_.id, abstractcl6_1.classificacao_caracteristica_fk
  • Inner Unique: true
  • Hash Cond: (abstractcl6_.id = abstractcl6_1.id)
  • Buffers: shared hit=178
38. 14.823 14.823 ↑ 1.0 12,806 1

Seq Scan on public.tb_abstract_classificacao abstractcl6_ (cost=0.00..226.06 rows=12,806 width=8) (actual time=0.010..14.823 rows=12,806 loops=1)

  • Output: abstractcl6_.id, abstractcl6_.codigo_produto, abstractcl6_.codigo_caracteristica, abstractcl6_.descontinuada, abstractcl6_.ncm_fk
  • Buffers: shared hit=98
39. 8.390 16.735 ↑ 1.0 8,488 1

Hash (cost=164.88..164.88 rows=8,488 width=24) (actual time=16.734..16.735 rows=8,488 loops=1)

  • Output: abstractcl6_1.id, abstractcl6_1.classificacao_produto_fk, abstractcl6_1.classificacao_caracteristica_fk
  • Buckets: 16,384 Batches: 1 Memory Usage: 593kB
  • Buffers: shared hit=80
40. 8.345 8.345 ↑ 1.0 8,488 1

Seq Scan on public.tb_classificacao abstractcl6_1 (cost=0.00..164.88 rows=8,488 width=24) (actual time=0.011..8.345 rows=8,488 loops=1)

  • Output: abstractcl6_1.id, abstractcl6_1.classificacao_produto_fk, abstractcl6_1.classificacao_caracteristica_fk
  • Buffers: shared hit=80
41. 5.314 10.672 ↑ 1.0 4,941 1

Hash (cost=86.41..86.41 rows=4,941 width=120) (actual time=10.671..10.672 rows=4,941 loops=1)

  • Output: classifica11_.id, classifica11_.origem_producao_fk, classifica11_.modelo_fk, classifica11_.grupo_quimico_fk, classifica11_.concentracao_fk, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk
  • Buckets: 8,192 Batches: 1 Memory Usage: 372kB
  • Buffers: shared hit=37
42. 5.358 5.358 ↑ 1.0 4,941 1

Seq Scan on public.tb_classificacao_caracteristica classifica11_ (cost=0.00..86.41 rows=4,941 width=120) (actual time=0.014..5.358 rows=4,941 loops=1)

  • Output: classifica11_.id, classifica11_.origem_producao_fk, classifica11_.modelo_fk, classifica11_.grupo_quimico_fk, classifica11_.concentracao_fk, classifica11_.tracao_fk, classifica11_.tipificacao_fk, classifica11_.potencia_fk, classifica11_.classe_fk, classifica11_.ingrediente_ativo_fk, classifica11_.cultivo_fk, classifica11_.marca_fk, classifica11_.cor_fk, classifica11_.gramatura_fk, classifica11_.estado_fisico_fk
  • Buffers: shared hit=37
43. 0.028 0.060 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=524) (actual time=0.059..0.060 rows=27 loops=1)

  • Output: origemprod13_.descricao, origemprod13_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
44. 0.032 0.032 ↑ 1.0 27 1

Seq Scan on public.tb_origem_producao origemprod13_ (cost=0.00..1.27 rows=27 width=524) (actual time=0.008..0.032 rows=27 loops=1)

  • Output: origemprod13_.descricao, origemprod13_.id
  • Buffers: shared hit=1
45. 0.489 0.963 ↑ 1.0 514 1

Hash (cost=9.14..9.14 rows=514 width=17) (actual time=0.962..0.963 rows=514 loops=1)

  • Output: modeloimpl22_.descricao, modeloimpl22_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 35kB
  • Buffers: shared hit=4
46. 0.474 0.474 ↑ 1.0 514 1

Seq Scan on public.tb_modelo modeloimpl22_ (cost=0.00..9.14 rows=514 width=17) (actual time=0.010..0.474 rows=514 loops=1)

  • Output: modeloimpl22_.descricao, modeloimpl22_.id
  • Buffers: shared hit=4
47. 0.154 0.307 ↑ 1.0 151 1

Hash (cost=3.51..3.51 rows=151 width=30) (actual time=0.306..0.307 rows=151 loops=1)

  • Output: grupoquimi19_.descricao, grupoquimi19_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=2
48. 0.153 0.153 ↑ 1.0 151 1

Seq Scan on public.tb_grupo_quimico grupoquimi19_ (cost=0.00..3.51 rows=151 width=30) (actual time=0.010..0.153 rows=151 loops=1)

  • Output: grupoquimi19_.descricao, grupoquimi19_.id
  • Buffers: shared hit=2
49. 0.192 0.383 ↑ 1.0 208 1

Hash (cost=4.08..4.08 rows=208 width=18) (actual time=0.382..0.383 rows=208 loops=1)

  • Output: concentrac17_.descricao, concentrac17_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=2
50. 0.191 0.191 ↑ 1.0 208 1

Seq Scan on public.tb_concentracao concentrac17_ (cost=0.00..4.08 rows=208 width=18) (actual time=0.012..0.191 rows=208 loops=1)

  • Output: concentrac17_.descricao, concentrac17_.id
  • Buffers: shared hit=2
51. 0.009 0.021 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=524) (actual time=0.020..0.021 rows=7 loops=1)

  • Output: tracaoimpl20_.descricao, tracaoimpl20_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
52. 0.012 0.012 ↑ 1.0 7 1

Seq Scan on public.tb_tracao tracaoimpl20_ (cost=0.00..1.07 rows=7 width=524) (actual time=0.005..0.012 rows=7 loops=1)

  • Output: tracaoimpl20_.descricao, tracaoimpl20_.id
  • Buffers: shared hit=1
53. 2.316 4.546 ↑ 1.0 2,349 1

Hash (cost=40.49..40.49 rows=2,349 width=23) (actual time=4.545..4.546 rows=2,349 loops=1)

  • Output: tipificaca16_.descricao, tipificaca16_.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 168kB
  • Buffers: shared hit=17
54. 2.230 2.230 ↑ 1.0 2,349 1

Seq Scan on public.tb_tipificacao tipificaca16_ (cost=0.00..40.49 rows=2,349 width=23) (actual time=0.009..2.230 rows=2,349 loops=1)

  • Output: tipificaca16_.descricao, tipificaca16_.id
  • Buffers: shared hit=17
55. 0.122 0.243 ↑ 1.0 130 1

Hash (cost=2.30..2.30 rows=130 width=12) (actual time=0.243..0.243 rows=130 loops=1)

  • Output: potenciaim15_.descricao, potenciaim15_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=1
56. 0.121 0.121 ↑ 1.0 130 1

Seq Scan on public.tb_potencia potenciaim15_ (cost=0.00..2.30 rows=130 width=12) (actual time=0.010..0.121 rows=130 loops=1)

  • Output: potenciaim15_.descricao, potenciaim15_.id
  • Buffers: shared hit=1
57. 0.536 1.070 ↑ 1.0 547 1

Hash (cost=9.47..9.47 rows=547 width=22) (actual time=1.069..1.070 rows=547 loops=1)

  • Output: classeimpl12_.descricao, classeimpl12_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=4
58. 0.534 0.534 ↑ 1.0 547 1

Seq Scan on public.tb_classe classeimpl12_ (cost=0.00..9.47 rows=547 width=22) (actual time=0.009..0.534 rows=547 loops=1)

  • Output: classeimpl12_.descricao, classeimpl12_.id
  • Buffers: shared hit=4
59. 0.296 0.586 ↑ 1.0 298 1

Hash (cost=5.98..5.98 rows=298 width=26) (actual time=0.585..0.586 rows=298 loops=1)

  • Output: ingredient18_.descricao, ingredient18_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
  • Buffers: shared hit=3
60. 0.290 0.290 ↑ 1.0 298 1

Seq Scan on public.tb_ingrediente_ativo ingredient18_ (cost=0.00..5.98 rows=298 width=26) (actual time=0.011..0.290 rows=298 loops=1)

  • Output: ingredient18_.descricao, ingredient18_.id
  • Buffers: shared hit=3
61. 0.054 0.107 ↑ 1.0 48 1

Hash (cost=1.48..1.48 rows=48 width=524) (actual time=0.106..0.107 rows=48 loops=1)

  • Output: cultivoimp14_.descricao, cultivoimp14_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
62. 0.053 0.053 ↑ 1.0 48 1

Seq Scan on public.tb_cultivo cultivoimp14_ (cost=0.00..1.48 rows=48 width=524) (actual time=0.011..0.053 rows=48 loops=1)

  • Output: cultivoimp14_.descricao, cultivoimp14_.id
  • Buffers: shared hit=1
63. 0.303 0.600 ↑ 1.0 313 1

Hash (cost=6.13..6.13 rows=313 width=25) (actual time=0.599..0.600 rows=313 loops=1)

  • Output: marcaimpl21_.descricao, marcaimpl21_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
  • Buffers: shared hit=3
64. 0.297 0.297 ↑ 1.0 313 1

Seq Scan on public.tb_marca marcaimpl21_ (cost=0.00..6.13 rows=313 width=25) (actual time=0.009..0.297 rows=313 loops=1)

  • Output: marcaimpl21_.descricao, marcaimpl21_.id
  • Buffers: shared hit=3
65. 0.017 0.038 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=524) (actual time=0.037..0.038 rows=15 loops=1)

  • Output: corimpl23_.descricao, corimpl23_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
66. 0.021 0.021 ↑ 1.0 15 1

Seq Scan on public.tb_cor corimpl23_ (cost=0.00..1.15 rows=15 width=524) (actual time=0.007..0.021 rows=15 loops=1)

  • Output: corimpl23_.descricao, corimpl23_.id
  • Buffers: shared hit=1
67. 0.035 0.070 ↑ 1.0 28 1

Hash (cost=1.28..1.28 rows=28 width=524) (actual time=0.069..0.070 rows=28 loops=1)

  • Output: gramaturai25_.descricao, gramaturai25_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
68. 0.035 0.035 ↑ 1.0 28 1

Seq Scan on public.tb_gramatura gramaturai25_ (cost=0.00..1.28 rows=28 width=524) (actual time=0.006..0.035 rows=28 loops=1)

  • Output: gramaturai25_.descricao, gramaturai25_.id
  • Buffers: shared hit=1
69. 4.296 8.521 ↑ 1.0 4,316 1

Hash (cost=84.16..84.16 rows=4,316 width=24) (actual time=8.520..8.521 rows=4,316 loops=1)

  • Output: abstractcl6_2.id, abstractcl6_2.produto_fk, abstractcl6_2.classificacao_caracteristica_pauta_pgpm_fk
  • Buckets: 8,192 Batches: 1 Memory Usage: 301kB
  • Buffers: shared hit=41
70. 4.225 4.225 ↑ 1.0 4,316 1

Seq Scan on public.tb_classificacao_pauta_pgpm abstractcl6_2 (cost=0.00..84.16 rows=4,316 width=24) (actual time=0.010..4.225 rows=4,316 loops=1)

  • Output: abstractcl6_2.id, abstractcl6_2.produto_fk, abstractcl6_2.classificacao_caracteristica_pauta_pgpm_fk
  • Buffers: shared hit=41
71. 0.073 0.147 ↑ 1.0 64 1

Hash (cost=1.64..1.64 rows=64 width=19) (actual time=0.146..0.147 rows=64 loops=1)

  • Output: estadofisi24_.descricao, estadofisi24_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1
72. 0.074 0.074 ↑ 1.0 64 1

Seq Scan on public.tb_estado_fisico estadofisi24_ (cost=0.00..1.64 rows=64 width=19) (actual time=0.011..0.074 rows=64 loops=1)

  • Output: estadofisi24_.descricao, estadofisi24_.id
  • Buffers: shared hit=1
73. 4.558 9.336 ↑ 1.0 4,163 1

Hash (cost=83.63..83.63 rows=4,163 width=144) (actual time=9.335..9.336 rows=4,163 loops=1)

  • Output: classifica26_.id, classifica26_.sub_categoria_fk, classifica26_.grao_inteiro_fk, classifica26_.cor_fk, classifica26_.categoria_fk, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk
  • Buckets: 8,192 Batches: 1 Memory Usage: 411kB
  • Buffers: shared hit=42
74. 4.778 4.778 ↑ 1.0 4,163 1

Seq Scan on public.tb_classificacao_caracteristica_pauta_pgpm classifica26_ (cost=0.00..83.63 rows=4,163 width=144) (actual time=0.011..4.778 rows=4,163 loops=1)

  • Output: classifica26_.id, classifica26_.sub_categoria_fk, classifica26_.grao_inteiro_fk, classifica26_.cor_fk, classifica26_.categoria_fk, classifica26_.classe_fk, classifica26_.micronaire_fk, classifica26_.resistencia_fk, classifica26_.grupo_fk, classifica26_.comprimento_fibra_fk, classifica26_.sub_classe_fk, classifica26_.tipo_fk, classifica26_.grau_folha_fk, classifica26_.residuo_beneficiamento_fk, classifica26_.sub_grupo_fk, classifica26_.gramatura_fk, classifica26_.residuo_fiacao_fk, classifica26_.forma_apresentacao_fk
  • Buffers: shared hit=42
75. 0.009 0.022 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=524) (actual time=0.021..0.022 rows=6 loops=1)

  • Output: subcategor36_.descricao, subcategor36_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
76. 0.013 0.013 ↑ 1.0 6 1

Seq Scan on public.tb_sub_categoria subcategor36_ (cost=0.00..1.06 rows=6 width=524) (actual time=0.007..0.013 rows=6 loops=1)

  • Output: subcategor36_.descricao, subcategor36_.id
  • Buffers: shared hit=1
77. 0.021 0.044 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=524) (actual time=0.043..0.044 rows=20 loops=1)

  • Output: graosintei40_.descricao, graosintei40_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
78. 0.023 0.023 ↑ 1.0 20 1

Seq Scan on public.tb_grao_inteiro graosintei40_ (cost=0.00..1.20 rows=20 width=524) (actual time=0.005..0.023 rows=20 loops=1)

  • Output: graosintei40_.descricao, graosintei40_.id
  • Buffers: shared hit=1
79. 0.017 0.035 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=524) (actual time=0.034..0.035 rows=15 loops=1)

  • Output: corimpl37_.descricao, corimpl37_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
80. 0.018 0.018 ↑ 1.0 15 1

Seq Scan on public.tb_cor corimpl37_ (cost=0.00..1.15 rows=15 width=524) (actual time=0.004..0.018 rows=15 loops=1)

  • Output: corimpl37_.descricao, corimpl37_.id
  • Buffers: shared hit=1
81. 0.010 0.023 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=524) (actual time=0.022..0.023 rows=8 loops=1)

  • Output: categoriai27_.descricao, categoriai27_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
82. 0.013 0.013 ↑ 1.0 8 1

Seq Scan on public.tb_categoria categoriai27_ (cost=0.00..1.08 rows=8 width=524) (actual time=0.005..0.013 rows=8 loops=1)

  • Output: categoriai27_.descricao, categoriai27_.id
  • Buffers: shared hit=1
83. 0.520 1.021 ↑ 1.0 547 1

Hash (cost=9.47..9.47 rows=547 width=22) (actual time=1.020..1.021 rows=547 loops=1)

  • Output: classeimpl30_.descricao, classeimpl30_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=4
84. 0.501 0.501 ↑ 1.0 547 1

Seq Scan on public.tb_classe classeimpl30_ (cost=0.00..9.47 rows=547 width=22) (actual time=0.007..0.501 rows=547 loops=1)

  • Output: classeimpl30_.descricao, classeimpl30_.id
  • Buffers: shared hit=4
85. 0.007 0.020 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=524) (actual time=0.020..0.020 rows=3 loops=1)

  • Output: micronaire38_.descricao, micronaire38_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
86. 0.013 0.013 ↑ 1.0 3 1

Seq Scan on public.tb_micronaire micronaire38_ (cost=0.00..1.03 rows=3 width=524) (actual time=0.008..0.013 rows=3 loops=1)

  • Output: micronaire38_.descricao, micronaire38_.id
  • Buffers: shared hit=1
87. 0.005 0.016 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=524) (actual time=0.016..0.016 rows=3 loops=1)

  • Output: resistenci39_.descricao, resistenci39_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
88. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on public.tb_resistencia resistenci39_ (cost=0.00..1.03 rows=3 width=524) (actual time=0.007..0.011 rows=3 loops=1)

  • Output: resistenci39_.descricao, resistenci39_.id
  • Buffers: shared hit=1
89. 0.062 0.125 ↑ 1.0 65 1

Hash (cost=1.65..1.65 rows=65 width=19) (actual time=0.125..0.125 rows=65 loops=1)

  • Output: grupoimpl32_.descricao, grupoimpl32_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1
90. 0.063 0.063 ↑ 1.0 65 1

Seq Scan on public.tb_grupo grupoimpl32_ (cost=0.00..1.65 rows=65 width=19) (actual time=0.007..0.063 rows=65 loops=1)

  • Output: grupoimpl32_.descricao, grupoimpl32_.id
  • Buffers: shared hit=1
91. 0.005 0.013 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=524) (actual time=0.012..0.013 rows=3 loops=1)

  • Output: compriment34_.descricao, compriment34_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
92. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on public.tb_comprimento_fibra compriment34_ (cost=0.00..1.03 rows=3 width=524) (actual time=0.004..0.008 rows=3 loops=1)

  • Output: compriment34_.descricao, compriment34_.id
  • Buffers: shared hit=1
93. 0.023 0.049 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=524) (actual time=0.048..0.049 rows=17 loops=1)

  • Output: subclassei29_.descricao, subclassei29_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
94. 0.026 0.026 ↑ 1.0 17 1

Seq Scan on public.tb_sub_classe subclassei29_ (cost=0.00..1.17 rows=17 width=524) (actual time=0.008..0.026 rows=17 loops=1)

  • Output: subclassei29_.descricao, subclassei29_.id
  • Buffers: shared hit=1
95. 0.101 0.204 ↑ 1.0 100 1

Hash (cost=2.00..2.00 rows=100 width=18) (actual time=0.203..0.204 rows=100 loops=1)

  • Output: tipoimpl31_.descricao, tipoimpl31_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=1
96. 0.103 0.103 ↑ 1.0 100 1

Seq Scan on public.tb_tipo tipoimpl31_ (cost=0.00..2.00 rows=100 width=18) (actual time=0.012..0.103 rows=100 loops=1)

  • Output: tipoimpl31_.descricao, tipoimpl31_.id
  • Buffers: shared hit=1
97. 0.010 0.023 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=524) (actual time=0.022..0.023 rows=7 loops=1)

  • Output: graufolhai33_.descricao, graufolhai33_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
98. 0.013 0.013 ↑ 1.0 7 1

Seq Scan on public.tb_grau_folha graufolhai33_ (cost=0.00..1.07 rows=7 width=524) (actual time=0.007..0.013 rows=7 loops=1)

  • Output: graufolhai33_.descricao, graufolhai33_.id
  • Buffers: shared hit=1
99. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: residuoben35_.descricao, residuoben35_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
100. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on public.tb_residuo_beneficiamento residuoben35_ (cost=0.00..11.40 rows=140 width=524) (actual time=0.003..0.004 rows=0 loops=1)

  • Output: residuoben35_.descricao, residuoben35_.id
101. 0.049 0.097 ↑ 1.0 48 1

Hash (cost=1.48..1.48 rows=48 width=524) (actual time=0.096..0.097 rows=48 loops=1)

  • Output: subgrupoim28_.descricao, subgrupoim28_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
102. 0.048 0.048 ↑ 1.0 48 1

Seq Scan on public.tb_sub_grupo subgrupoim28_ (cost=0.00..1.48 rows=48 width=524) (actual time=0.006..0.048 rows=48 loops=1)

  • Output: subgrupoim28_.descricao, subgrupoim28_.id
  • Buffers: shared hit=1
103. 0.030 0.060 ↑ 1.0 28 1

Hash (cost=1.28..1.28 rows=28 width=524) (actual time=0.059..0.060 rows=28 loops=1)

  • Output: gramaturai41_.descricao, gramaturai41_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
104. 0.030 0.030 ↑ 1.0 28 1

Seq Scan on public.tb_gramatura gramaturai41_ (cost=0.00..1.28 rows=28 width=524) (actual time=0.005..0.030 rows=28 loops=1)

  • Output: gramaturai41_.descricao, gramaturai41_.id
  • Buffers: shared hit=1
105. 0.002 0.009 ↓ 0.0 0 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.008..0.009 rows=0 loops=1)

  • Output: residuofia43_.descricao, residuofia43_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
106. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on public.tb_residuo_fiacao residuofia43_ (cost=0.00..11.40 rows=140 width=524) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: residuofia43_.descricao, residuofia43_.id
107. 0.002 0.005 ↓ 0.0 0 1

Hash (cost=11.40..11.40 rows=140 width=524) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: formaapres42_.descricao, formaapres42_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
108. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on public.tb_forma_apresentacao formaapres42_ (cost=0.00..11.40 rows=140 width=524) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: formaapres42_.descricao, formaapres42_.id
109. 5,701.587 5,701.587 ↑ 1.0 3,613,502 1

Index Scan using ix_tb_preco_serie_fk on public.tb_preco p (cost=0.43..107,790.63 rows=3,616,072 width=12) (actual time=0.013..5,701.587 rows=3,613,502 loops=1)

  • Output: p.id, p.valor, p.data_inicial, p.data_final, p.tipo_periodo, p.motivo, p.serie_fk, p.ts_atualizacao, p.observacao, p.motivo_padrao_preco_acima_limiar_fk
  • Buffers: shared hit=2,988,315
110. 207.956 1,450.267 ↓ 64.2 236,364 1

Materialize (cost=4,073.51..4,091.93 rows=3,684 width=1,181) (actual time=1,240.819..1,450.267 rows=236,364 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, produto.nome, produto_pgpm.nome
  • Buffers: shared hit=918, temp read=181 written=261
111. 4.155 1,242.311 ↑ 3.1 1,171 1

Sort (cost=4,073.51..4,082.72 rows=3,684 width=1,181) (actual time=1,240.814..1,242.311 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, produto.nome, produto_pgpm.nome
  • Sort Key: s.id
  • Sort Method: quicksort Memory: 357kB
  • Buffers: shared hit=918, temp read=181 written=261
112. 2.387 1,238.156 ↑ 3.1 1,171 1

Hash Left Join (cost=2,563.95..2,740.09 rows=3,684 width=1,181) (actual time=1,193.399..1,238.156 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, produto.nome, produto_pgpm.nome
  • Inner Unique: true
  • Hash Cond: (classificacao_pgpm.produto_fk = produto_pgpm.id)
  • Buffers: shared hit=918, temp read=181 written=261
113. 2.299 1,230.035 ↑ 3.1 1,171 1

Hash Left Join (cost=2,481.30..2,647.75 rows=3,684 width=1,175) (actual time=1,187.613..1,230.035 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, produto.nome, classificacao_pgpm.produto_fk
  • Inner Unique: true
  • Hash Cond: (s.abstract_classificacao_fk = classificacao_pgpm.id)
  • Buffers: shared hit=899, temp read=181 written=261
114. 2.451 1,219.084 ↑ 3.1 1,171 1

Hash Left Join (cost=2,343.19..2,499.96 rows=3,684 width=1,175) (actual time=1,178.944..1,219.084 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, produto.nome
  • Inner Unique: true
  • Hash Cond: (cp.produto_fk = produto.id)
  • Buffers: shared hit=858, temp read=181 written=261
115. 2.473 1,211.180 ↑ 3.1 1,171 1

Hash Left Join (cost=2,260.54..2,407.63 rows=3,684 width=1,169) (actual time=1,173.479..1,211.180 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, cp.produto_fk
  • Inner Unique: true
  • Hash Cond: (classificacao.classificacao_produto_fk = cp.id)
  • Buffers: shared hit=839, temp read=181 written=261
116. 2.603 1,202.882 ↑ 3.1 1,171 1

Hash Left Join (cost=2,172.91..2,310.32 rows=3,684 width=1,169) (actual time=1,167.640..1,202.882 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao, classificacao.classificacao_produto_fk
  • Inner Unique: true
  • Hash Cond: (s.abstract_classificacao_fk = classificacao.id)
  • Buffers: shared hit=815, temp read=181 written=261
117. 2.222 1,183.480 ↑ 3.1 1,171 1

Hash Left Join (cost=1,901.93..2,029.66 rows=3,684 width=1,161) (actual time=1,150.825..1,183.480 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, me.id, me.descricao, ge.id, ge.descricao
  • Inner Unique: true
  • Hash Cond: (e.grupo_fk = ge.id)
  • Buffers: shared hit=735, temp read=181 written=261
118. 2.341 1,181.139 ↑ 3.1 1,171 1

Hash Left Join (cost=1,899.67..2,017.00 rows=3,684 width=1,153) (actual time=1,150.698..1,181.139 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, e.grupo_fk, me.id, me.descricao
  • Inner Unique: true
  • Hash Cond: (e.material_fk = me.id)
  • Buffers: shared hit=734, temp read=181 written=261
119. 14.562 1,178.695 ↑ 3.1 1,171 1

Merge Join (cost=1,897.68..2,004.40 rows=3,684 width=637) (actual time=1,150.582..1,178.695 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, consulta_tipificacao.tipificacao, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, e.material_fk, e.grupo_fk
  • Merge Cond: (s.abstract_classificacao_fk = consulta_tipificacao.id_abstract_classificacao)
  • Buffers: shared hit=733, temp read=181 written=261
120. 2.775 30.279 ↑ 1.0 1,171 1

Sort (cost=767.90..770.83 rows=1,171 width=605) (actual time=29.185..30.279 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, e.material_fk, e.grupo_fk
  • Sort Key: s.abstract_classificacao_fk
  • Sort Method: quicksort Memory: 334kB
  • Buffers: shared hit=376
121. 2.153 27.504 ↑ 1.0 1,171 1

Hash Left Join (cost=258.94..708.22 rows=1,171 width=605) (actual time=12.309..27.504 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, medida.simbolo, e.material_fk, e.grupo_fk
  • Inner Unique: true
  • Hash Cond: (acon.embalagem_fk = e.id)
  • Buffers: shared hit=376
122. 2.234 25.290 ↑ 1.0 1,171 1

Hash Join (cost=257.28..703.18 rows=1,171 width=597) (actual time=12.240..25.290 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, acon.embalagem_fk, medida.simbolo
  • Inner Unique: true
  • Hash Cond: (acon.unidade_medida_fk = medida.id)
  • Buffers: shared hit=375
123. 2.309 22.892 ↑ 1.0 1,171 1

Hash Join (cost=254.46..697.13 rows=1,171 width=602) (actual time=12.068..22.892 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, nc.descricao, nc.id, mun.nome, um.id, acon.quantidade_minima, acon.quantidade_maxima, acon.unidade_medida_fk, acon.embalagem_fk
  • Inner Unique: true
  • Hash Cond: (um.unidade_comercializacao_fk = acon.id)
  • Buffers: shared hit=374
124. 2.241 20.162 ↑ 1.0 1,171 1

Hash Join (cost=247.62..687.16 rows=1,171 width=584) (actual time=11.641..20.162 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, nc.descricao, nc.id, mun.nome, um.id, um.unidade_comercializacao_fk
  • Inner Unique: true
  • Hash Cond: (s.unidade_comercializacao_conab_fk = um.id)
  • Buffers: shared hit=372
125. 2.200 17.473 ↑ 1.0 1,171 1

Hash Left Join (cost=240.58..676.99 rows=1,171 width=576) (actual time=11.184..17.473 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, s.unidade_comercializacao_conab_fk, nc.descricao, nc.id, mun.nome
  • Inner Unique: true
  • Hash Cond: (s.municipio_fk = mun.id)
  • Buffers: shared hit=370
126. 2.526 4.335 ↑ 1.0 1,171 1

Hash Join (cost=15.24..448.57 rows=1,171 width=572) (actual time=0.230..4.335 rows=1,171 loops=1)

  • Output: s.data, s.id, s.situacao, s.unidade_federacao_fk, s.abstract_classificacao_fk, s.municipio_fk, s.unidade_comercializacao_conab_fk, nc.descricao, nc.id
  • Inner Unique: true
  • Hash Cond: (s.nivel_comercializacao_fk = nc.id)
  • Buffers: shared hit=270
127. 1.625 1.761 ↑ 1.0 1,171 1

Bitmap Heap Scan on public.tb_serie s (cost=13.76..443.40 rows=1,171 width=56) (actual time=0.171..1.761 rows=1,171 loops=1)

  • Output: s.id, s.id_serie, s.versao, s.data, s.motivo, s.mercado, s.moeda_fk, s.nivel_comercializacao_fk, s.praca_internacional_fk, s.formula_fk, s.abstract_classificacao_fk, s.municipio_fk, s.unidade_federacao_fk, s.micro_regiao_fk, s.meso_regiao_fk, s.zoneamento_fk, s.unidade_comercializacao_conab_fk, s.agente_fk, s.ts_atualizacao, s.situacao, s.observacao
  • Recheck Cond: ((s.unidade_federacao_fk)::text = 'GO'::text)
  • Heap Blocks: exact=264
  • Buffers: shared hit=269
128. 0.136 0.136 ↑ 1.0 1,171 1

Bitmap Index Scan on ix_tb_serie_unidade_federacao_fk (cost=0.00..13.47 rows=1,171 width=0) (actual time=0.135..0.136 rows=1,171 loops=1)

  • Index Cond: ((s.unidade_federacao_fk)::text = 'GO'::text)
  • Buffers: shared hit=5
129. 0.023 0.048 ↑ 1.0 21 1

Hash (cost=1.21..1.21 rows=21 width=524) (actual time=0.047..0.048 rows=21 loops=1)

  • Output: nc.descricao, nc.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
130. 0.025 0.025 ↑ 1.0 21 1

Seq Scan on public.tb_nivel_comercializacao nc (cost=0.00..1.21 rows=21 width=524) (actual time=0.007..0.025 rows=21 loops=1)

  • Output: nc.descricao, nc.id
  • Buffers: shared hit=1
131. 5.514 10.938 ↑ 1.0 5,571 1

Hash (cost=155.71..155.71 rows=5,571 width=20) (actual time=10.937..10.938 rows=5,571 loops=1)

  • Output: mun.nome, mun.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 369kB
  • Buffers: shared hit=100
132. 5.424 5.424 ↑ 1.0 5,571 1

Seq Scan on public.tb_municipio mun (cost=0.00..155.71 rows=5,571 width=20) (actual time=0.007..5.424 rows=5,571 loops=1)

  • Output: mun.nome, mun.id
  • Buffers: shared hit=100
133. 0.224 0.448 ↑ 1.0 224 1

Hash (cost=4.24..4.24 rows=224 width=16) (actual time=0.447..0.448 rows=224 loops=1)

  • Output: um.id, um.unidade_comercializacao_fk
  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=2
134. 0.224 0.224 ↑ 1.0 224 1

Seq Scan on public.tb_unidade_comercializacao_conab um (cost=0.00..4.24 rows=224 width=16) (actual time=0.013..0.224 rows=224 loops=1)

  • Output: um.id, um.unidade_comercializacao_fk
  • Buffers: shared hit=2
135. 0.211 0.421 ↑ 1.0 215 1

Hash (cost=4.15..4.15 rows=215 width=34) (actual time=0.420..0.421 rows=215 loops=1)

  • Output: acon.quantidade_minima, acon.quantidade_maxima, acon.id, acon.unidade_medida_fk, acon.embalagem_fk
  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=2
136. 0.210 0.210 ↑ 1.0 215 1

Seq Scan on public.tb_acondicionamento_conab acon (cost=0.00..4.15 rows=215 width=34) (actual time=0.007..0.210 rows=215 loops=1)

  • Output: acon.quantidade_minima, acon.quantidade_maxima, acon.id, acon.unidade_medida_fk, acon.embalagem_fk
  • Buffers: shared hit=2
137. 0.082 0.164 ↑ 1.0 81 1

Hash (cost=1.81..1.81 rows=81 width=11) (actual time=0.163..0.164 rows=81 loops=1)

  • Output: medida.simbolo, medida.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1
138. 0.082 0.082 ↑ 1.0 81 1

Seq Scan on public.tb_unidade_medida_conab medida (cost=0.00..1.81 rows=81 width=11) (actual time=0.009..0.082 rows=81 loops=1)

  • Output: medida.simbolo, medida.id
  • Buffers: shared hit=1
139. 0.029 0.061 ↑ 1.0 29 1

Hash (cost=1.29..1.29 rows=29 width=24) (actual time=0.060..0.061 rows=29 loops=1)

  • Output: e.id, e.material_fk, e.grupo_fk
  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
140. 0.032 0.032 ↑ 1.0 29 1

Seq Scan on public.tb_embalagem e (cost=0.00..1.29 rows=29 width=24) (actual time=0.006..0.032 rows=29 loops=1)

  • Output: e.id, e.material_fk, e.grupo_fk
  • Buffers: shared hit=1
141. 38.715 1,133.854 ↑ 1.0 12,784 1

Sort (cost=1,129.78..1,161.79 rows=12,806 width=40) (actual time=1,121.067..1,133.854 rows=12,784 loops=1)

  • Output: consulta_tipificacao.tipificacao, consulta_tipificacao.id_abstract_classificacao
  • Sort Key: consulta_tipificacao.id_abstract_classificacao
  • Sort Method: external sort Disk: 728kB
  • Buffers: shared hit=357, temp read=180 written=261
142. 1,095.139 1,095.139 ↑ 1.0 12,806 1

CTE Scan on consulta_tipificacao (cost=0.00..256.12 rows=12,806 width=40) (actual time=56.560..1,095.139 rows=12,806 loops=1)

  • Output: consulta_tipificacao.tipificacao, consulta_tipificacao.id_abstract_classificacao
  • Buffers: shared hit=357, temp written=78
143. 0.049 0.103 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=524) (actual time=0.102..0.103 rows=44 loops=1)

  • Output: me.id, me.descricao
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
144. 0.054 0.054 ↑ 1.0 44 1

Seq Scan on public.tb_material_embalagem me (cost=0.00..1.44 rows=44 width=524) (actual time=0.011..0.054 rows=44 loops=1)

  • Output: me.id, me.descricao
  • Buffers: shared hit=1
145. 0.059 0.119 ↑ 1.0 56 1

Hash (cost=1.56..1.56 rows=56 width=16) (actual time=0.119..0.119 rows=56 loops=1)

  • Output: ge.id, ge.descricao
  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
146. 0.060 0.060 ↑ 1.0 56 1

Seq Scan on public.tb_grupo_embalagem ge (cost=0.00..1.56 rows=56 width=16) (actual time=0.008..0.060 rows=56 loops=1)

  • Output: ge.id, ge.descricao
  • Buffers: shared hit=1
147. 8.290 16.799 ↑ 1.0 8,488 1

Hash (cost=164.88..164.88 rows=8,488 width=16) (actual time=16.798..16.799 rows=8,488 loops=1)

  • Output: classificacao.id, classificacao.classificacao_produto_fk
  • Buckets: 16,384 Batches: 1 Memory Usage: 526kB
  • Buffers: shared hit=80
148. 8.509 8.509 ↑ 1.0 8,488 1

Seq Scan on public.tb_classificacao classificacao (cost=0.00..164.88 rows=8,488 width=16) (actual time=0.010..8.509 rows=8,488 loops=1)

  • Output: classificacao.id, classificacao.classificacao_produto_fk
  • Buffers: shared hit=80
149. 2.920 5.825 ↑ 1.0 2,828 1

Hash (cost=52.28..52.28 rows=2,828 width=16) (actual time=5.824..5.825 rows=2,828 loops=1)

  • Output: cp.id, cp.produto_fk
  • Buckets: 4,096 Batches: 1 Memory Usage: 165kB
  • Buffers: shared hit=24
150. 2.905 2.905 ↑ 1.0 2,828 1

Seq Scan on public.tb_classificacao_produto cp (cost=0.00..52.28 rows=2,828 width=16) (actual time=0.011..2.905 rows=2,828 loops=1)

  • Output: cp.id, cp.produto_fk
  • Buffers: shared hit=24
151. 2.763 5.453 ↑ 1.0 2,829 1

Hash (cost=47.29..47.29 rows=2,829 width=22) (actual time=5.452..5.453 rows=2,829 loops=1)

  • Output: produto.nome, produto.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 193kB
  • Buffers: shared hit=19
152. 2.690 2.690 ↑ 1.0 2,829 1

Seq Scan on public.tb_produto produto (cost=0.00..47.29 rows=2,829 width=22) (actual time=0.012..2.690 rows=2,829 loops=1)

  • Output: produto.nome, produto.id
  • Buffers: shared hit=19
153. 4.410 8.652 ↑ 1.0 4,316 1

Hash (cost=84.16..84.16 rows=4,316 width=16) (actual time=8.651..8.652 rows=4,316 loops=1)

  • Output: classificacao_pgpm.id, classificacao_pgpm.produto_fk
  • Buckets: 8,192 Batches: 1 Memory Usage: 267kB
  • Buffers: shared hit=41
154. 4.242 4.242 ↑ 1.0 4,316 1

Seq Scan on public.tb_classificacao_pauta_pgpm classificacao_pgpm (cost=0.00..84.16 rows=4,316 width=16) (actual time=0.010..4.242 rows=4,316 loops=1)

  • Output: classificacao_pgpm.id, classificacao_pgpm.produto_fk
  • Buffers: shared hit=41
155. 3.036 5.734 ↑ 1.0 2,829 1

Hash (cost=47.29..47.29 rows=2,829 width=22) (actual time=5.733..5.734 rows=2,829 loops=1)

  • Output: produto_pgpm.nome, produto_pgpm.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 193kB
  • Buffers: shared hit=19
156. 2.698 2.698 ↑ 1.0 2,829 1

Seq Scan on public.tb_produto produto_pgpm (cost=0.00..47.29 rows=2,829 width=22) (actual time=0.010..2.698 rows=2,829 loops=1)

  • Output: produto_pgpm.nome, produto_pgpm.id
  • Buffers: shared hit=19
Planning time : 28.452 ms
Execution time : 11,687.713 ms