explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OEV4 : consulta_ajustada

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

Merge Right Join (cost=8,427.64..172,223.40 rows=605,886 width=1,152) (actual time=1,331.677..11,874.362 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. 65.693 1,097.080 ↑ 1.0 12,806 1

Hash Left Join (cost=916.68..4,353.70 rows=12,806 width=40) (actual time=66.577..1,097.080 rows=12,806 loops=1)

  • Output: abstractcl6_.id, 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 ((((((((((((((((((((((((((((((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)) END
  • Inner Unique: true
  • Hash Cond: (classifica26_.forma_apresentacao_fk = formaapres42_.id)
  • Buffers: shared hit=357
4. 27.860 1,031.378 ↑ 1.0 12,806 1

Hash Left Join (cost=903.53..2,354.02 rows=12,806 width=9,459) (actual time=66.504..1,031.378 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. 27.338 1,003.505 ↑ 1.0 12,806 1

Hash Left Join (cost=890.38..2,307.25 rows=12,806 width=8,951) (actual time=66.430..1,003.505 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. 28.146 976.071 ↑ 1.0 12,806 1

Hash Left Join (cost=888.75..2,271.93 rows=12,806 width=8,443) (actual time=66.288..976.071 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. 28.157 947.741 ↑ 1.0 12,806 1

Hash Left Join (cost=886.67..2,235.23 rows=12,806 width=7,935) (actual time=66.059..947.741 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. 28.935 919.575 ↑ 1.0 12,806 1

Hash Left Join (cost=873.52..2,188.47 rows=12,806 width=7,427) (actual time=66.002..919.575 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. 28.247 890.585 ↑ 1.0 12,806 1

Hash Left Join (cost=872.36..2,144.98 rows=12,806 width=6,919) (actual time=65.892..890.585 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.644 862.090 ↑ 1.0 12,806 1

Hash Left Join (cost=869.11..2,106.70 rows=12,806 width=6,917) (actual time=65.609..862.090 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.972 834.371 ↑ 1.0 12,806 1

Hash Left Join (cost=867.73..2,070.57 rows=12,806 width=6,409) (actual time=65.496..834.371 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. 28.320 806.370 ↑ 1.0 12,806 1

Hash Left Join (cost=866.66..2,015.56 rows=12,806 width=5,901) (actual time=65.414..806.370 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.840 777.850 ↑ 1.0 12,806 1

Hash Left Join (cost=864.20..1,978.40 rows=12,806 width=5,898) (actual time=65.173..777.850 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. 27.890 749.977 ↑ 1.0 12,806 1

Hash Left Join (cost=863.13..1,923.40 rows=12,806 width=5,390) (actual time=65.090..749.977 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. 28.336 722.052 ↑ 1.0 12,806 1

Hash Left Join (cost=862.07..1,868.39 rows=12,806 width=4,882) (actual time=64.997..722.052 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. 27.743 692.497 ↑ 1.0 12,806 1

Hash Left Join (cost=845.76..1,818.33 rows=12,806 width=4,876) (actual time=63.739..692.497 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. 28.015 664.711 ↑ 1.0 12,806 1

Hash Left Join (cost=844.58..1,783.49 rows=12,806 width=4,368) (actual time=63.647..664.711 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. 28.032 636.604 ↑ 1.0 12,806 1

Hash Left Join (cost=843.24..1,744.34 rows=12,806 width=3,860) (actual time=63.505..636.604 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.780 608.498 ↑ 1.0 12,806 1

Hash Left Join (cost=841.79..1,709.12 rows=12,806 width=3,352) (actual time=63.395..608.498 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. 30.420 580.678 ↑ 1.0 12,806 1

Hash Left Join (cost=840.66..1,674.32 rows=12,806 width=2,844) (actual time=63.293..580.678 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. 26.635 539.672 ↑ 1.0 12,806 1

Hash Left Join (cost=704.99..1,505.00 rows=12,806 width=2,716) (actual time=52.599..539.672 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. 30.532 512.858 ↑ 1.0 12,806 1

Hash Left Join (cost=702.55..1,468.83 rows=12,806 width=2,713) (actual time=52.379..512.858 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. 26.733 472.985 ↑ 1.0 12,806 1

Hash Left Join (cost=564.44..1,297.09 rows=12,806 width=2,705) (actual time=42.946..472.985 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. 26.151 446.183 ↑ 1.0 12,806 1

Hash Left Join (cost=562.81..1,261.84 rows=12,806 width=2,197) (actual time=42.840..446.183 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. 26.928 419.983 ↑ 1.0 12,806 1

Hash Left Join (cost=561.47..1,226.82 rows=12,806 width=1,689) (actual time=42.746..419.983 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. 26.202 392.346 ↑ 1.0 12,806 1

Hash Left Join (cost=551.43..1,183.04 rows=12,806 width=1,680) (actual time=42.000..392.346 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. 26.976 366.024 ↑ 1.0 12,806 1

Hash Left Join (cost=549.35..1,147.27 rows=12,806 width=1,172) (actual time=41.830..366.024 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.681 338.369 ↑ 1.0 12,806 1

Hash Left Join (cost=539.64..1,103.90 rows=12,806 width=1,162) (actual time=41.107..338.369 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. 26.305 310.495 ↑ 1.0 12,806 1

Hash Left Join (cost=523.34..1,053.92 rows=12,806 width=1,156) (actual time=39.874..310.495 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. 27.997 283.909 ↑ 1.0 12,806 1

Hash Left Join (cost=519.41..1,016.25 rows=12,806 width=1,160) (actual time=39.535..283.909 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. 26.480 250.724 ↑ 1.0 12,806 1

Hash Left Join (cost=449.56..912.73 rows=12,806 width=1,153) (actual time=34.296..250.724 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. 26.436 224.214 ↑ 1.0 12,806 1

Hash Left Join (cost=448.40..877.04 rows=12,806 width=645) (actual time=34.227..224.214 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. 27.046 197.348 ↑ 1.0 12,806 1

Hash Left Join (cost=441.72..836.66 rows=12,806 width=643) (actual time=33.753..197.348 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.952 169.954 ↑ 1.0 12,806 1

Hash Left Join (cost=436.32..797.56 rows=12,806 width=629) (actual time=33.338..169.954 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. 26.767 141.846 ↑ 1.0 12,806 1

Hash Left Join (cost=420.76..748.33 rows=12,806 width=628) (actual time=32.131..141.846 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. 30.973 114.962 ↑ 1.0 12,806 1

Hash Left Join (cost=419.15..712.49 rows=12,806 width=120) (actual time=31.963..114.962 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. 35.956 71.834 ↑ 1.0 12,806 1

Hash Left Join (cost=270.98..530.67 rows=12,806 width=16) (actual time=19.705..71.834 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. 16.376 16.376 ↑ 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.020..16.376 rows=12,806 loops=1)

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

Hash (cost=164.88..164.88 rows=8,488 width=24) (actual time=19.501..19.502 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. 9.184 9.184 ↑ 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.016..9.184 rows=8,488 loops=1)

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

Hash (cost=86.41..86.41 rows=4,941 width=120) (actual time=12.154..12.155 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.887 5.887 ↑ 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.019..5.887 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.043 0.117 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=524) (actual time=0.116..0.117 rows=27 loops=1)

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

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

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

Hash (cost=9.14..9.14 rows=514 width=17) (actual time=1.155..1.156 rows=514 loops=1)

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

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

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

Hash (cost=3.51..3.51 rows=151 width=30) (actual time=0.347..0.348 rows=151 loops=1)

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

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

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

Hash (cost=4.08..4.08 rows=208 width=18) (actual time=0.429..0.430 rows=208 loops=1)

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

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

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

Hash (cost=1.07..1.07 rows=7 width=524) (actual time=0.029..0.030 rows=7 loops=1)

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

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

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

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

  • Output: tipificaca16_.descricao, tipificaca16_.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 168kB
  • Buffers: shared hit=17
54. 2.486 2.486 ↑ 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.021..2.486 rows=2,349 loops=1)

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

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

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

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

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

Hash (cost=9.47..9.47 rows=547 width=22) (actual time=1.192..1.193 rows=547 loops=1)

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

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

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

Hash (cost=5.98..5.98 rows=298 width=26) (actual time=0.678..0.679 rows=298 loops=1)

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

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

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

Hash (cost=1.48..1.48 rows=48 width=524) (actual time=0.119..0.120 rows=48 loops=1)

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

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

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

Hash (cost=6.13..6.13 rows=313 width=25) (actual time=0.708..0.709 rows=313 loops=1)

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

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

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

Hash (cost=1.15..1.15 rows=15 width=524) (actual time=0.047..0.049 rows=15 loops=1)

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

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

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

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

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

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

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

Hash (cost=84.16..84.16 rows=4,316 width=24) (actual time=9.340..9.341 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.455 4.455 ↑ 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.011..4.455 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.093 0.179 ↑ 1.0 64 1

Hash (cost=1.64..1.64 rows=64 width=19) (actual time=0.178..0.179 rows=64 loops=1)

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

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

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

Hash (cost=83.63..83.63 rows=4,163 width=144) (actual time=10.586..10.586 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. 5.086 5.086 ↑ 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.038..5.086 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.018 0.040 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=524) (actual time=0.039..0.040 rows=6 loops=1)

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

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

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

Hash (cost=1.20..1.20 rows=20 width=524) (actual time=0.073..0.074 rows=20 loops=1)

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

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

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

Hash (cost=1.15..1.15 rows=15 width=524) (actual time=0.091..0.092 rows=15 loops=1)

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

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

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

Hash (cost=1.08..1.08 rows=8 width=524) (actual time=0.042..0.043 rows=8 loops=1)

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

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

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

Hash (cost=9.47..9.47 rows=547 width=22) (actual time=1.218..1.219 rows=547 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hash (cost=1.17..1.17 rows=17 width=524) (actual time=0.074..0.075 rows=17 loops=1)

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

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

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

Hash (cost=2.00..2.00 rows=100 width=18) (actual time=0.247..0.248 rows=100 loops=1)

  • Output: tipoimpl31_.descricao, tipoimpl31_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=1
96. 0.115 0.115 ↑ 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.115 rows=100 loops=1)

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

Hash (cost=1.07..1.07 rows=7 width=524) (actual time=0.054..0.055 rows=7 loops=1)

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

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

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

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

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

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

  • Output: residuoben35_.descricao, residuoben35_.id
101. 0.076 0.184 ↑ 1.0 48 1

Hash (cost=1.48..1.48 rows=48 width=524) (actual time=0.183..0.184 rows=48 loops=1)

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

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

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

Hash (cost=1.28..1.28 rows=28 width=524) (actual time=0.095..0.096 rows=28 loops=1)

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

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

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

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

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

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

  • Output: residuofia43_.descricao, residuofia43_.id
107. 0.003 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: formaapres42_.descricao, formaapres42_.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
108. 0.006 0.006 ↓ 0.0 0 1

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

  • Output: formaapres42_.descricao, formaapres42_.id
109. 5,940.415 5,940.415 ↑ 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.043..5,940.415 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. 213.621 1,517.739 ↓ 64.2 236,364 1

Materialize (cost=4,073.51..4,091.93 rows=3,684 width=1,181) (actual time=1,302.563..1,517.739 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.320 1,304.118 ↑ 3.1 1,171 1

Sort (cost=4,073.51..4,082.72 rows=3,684 width=1,181) (actual time=1,302.537..1,304.118 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.440 1,299.798 ↑ 3.1 1,171 1

Hash Left Join (cost=2,563.95..2,740.09 rows=3,684 width=1,181) (actual time=1,254.078..1,299.798 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.395 1,290.894 ↑ 3.1 1,171 1

Hash Left Join (cost=2,481.30..2,647.75 rows=3,684 width=1,175) (actual time=1,247.534..1,290.894 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.511 1,278.751 ↑ 3.1 1,171 1

Hash Left Join (cost=2,343.19..2,499.96 rows=3,684 width=1,175) (actual time=1,237.732..1,278.751 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.540 1,270.643 ↑ 3.1 1,171 1

Hash Left Join (cost=2,260.54..2,407.63 rows=3,684 width=1,169) (actual time=1,232.121..1,270.643 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.681 1,262.759 ↑ 3.1 1,171 1

Hash Left Join (cost=2,172.91..2,310.32 rows=3,684 width=1,169) (actual time=1,226.759..1,262.759 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.262 1,242.539 ↑ 3.1 1,171 1

Hash Left Join (cost=1,901.93..2,029.66 rows=3,684 width=1,161) (actual time=1,209.199..1,242.539 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.382 1,240.154 ↑ 3.1 1,171 1

Hash Left Join (cost=1,899.67..2,017.00 rows=3,684 width=1,153) (actual time=1,209.067..1,240.154 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.897 1,237.662 ↑ 3.1 1,171 1

Merge Join (cost=1,897.68..2,004.40 rows=3,684 width=637) (actual time=1,208.942..1,237.662 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. 3.935 38.837 ↑ 1.0 1,171 1

Sort (cost=767.90..770.83 rows=1,171 width=605) (actual time=37.708..38.837 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.931 34.902 ↑ 1.0 1,171 1

Hash Left Join (cost=258.94..708.22 rows=1,171 width=605) (actual time=15.743..34.902 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.816 31.877 ↑ 1.0 1,171 1

Hash Join (cost=257.28..703.18 rows=1,171 width=597) (actual time=15.607..31.877 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.929 28.856 ↑ 1.0 1,171 1

Hash Join (cost=254.46..697.13 rows=1,171 width=602) (actual time=15.367..28.856 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.801 25.449 ↑ 1.0 1,171 1

Hash Join (cost=247.62..687.16 rows=1,171 width=584) (actual time=14.841..25.449 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.765 22.156 ↑ 1.0 1,171 1

Hash Left Join (cost=240.58..676.99 rows=1,171 width=576) (actual time=14.315..22.156 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. 3.190 5.515 ↑ 1.0 1,171 1

Hash Join (cost=15.24..448.57 rows=1,171 width=572) (actual time=0.334..5.515 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. 2.079 2.268 ↑ 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.228..2.268 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.189 0.189 ↑ 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.188..0.189 rows=1,171 loops=1)

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

Hash (cost=1.21..1.21 rows=21 width=524) (actual time=0.056..0.057 rows=21 loops=1)

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

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

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

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

  • Output: mun.nome, mun.id
  • Buckets: 8,192 Batches: 1 Memory Usage: 369kB
  • Buffers: shared hit=100
132. 6.577 6.577 ↑ 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.015..6.577 rows=5,571 loops=1)

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

Hash (cost=4.24..4.24 rows=224 width=16) (actual time=0.491..0.492 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.236 0.236 ↑ 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.012..0.236 rows=224 loops=1)

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

Hash (cost=4.15..4.15 rows=215 width=34) (actual time=0.477..0.478 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.228 0.228 ↑ 1.0 215 1

Seq Scan on public.tb_acondicionamento_conab acon (cost=0.00..4.15 rows=215 width=34) (actual time=0.015..0.228 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.107 0.205 ↑ 1.0 81 1

Hash (cost=1.81..1.81 rows=81 width=11) (actual time=0.204..0.205 rows=81 loops=1)

  • Output: medida.simbolo, medida.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=1
138. 0.098 0.098 ↑ 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.014..0.098 rows=81 loops=1)

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

Hash (cost=1.29..1.29 rows=29 width=24) (actual time=0.093..0.094 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.046 0.046 ↑ 1.0 29 1

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

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

Sort (cost=1,129.78..1,161.79 rows=12,806 width=40) (actual time=1,170.882..1,183.928 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,141.924 1,141.924 ↑ 1.0 12,806 1

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

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

Hash (cost=1.44..1.44 rows=44 width=524) (actual time=0.109..0.110 rows=44 loops=1)

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

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

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

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

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

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

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

Hash (cost=164.88..164.88 rows=8,488 width=16) (actual time=17.538..17.539 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.821 8.821 ↑ 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.020..8.821 rows=8,488 loops=1)

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

Hash (cost=52.28..52.28 rows=2,828 width=16) (actual time=5.344..5.344 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.687 2.687 ↑ 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.015..2.687 rows=2,828 loops=1)

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

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

  • Output: produto.nome, produto.id
  • Buckets: 4,096 Batches: 1 Memory Usage: 193kB
  • Buffers: shared hit=19
152. 2.748 2.748 ↑ 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.011..2.748 rows=2,829 loops=1)

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

Hash (cost=84.16..84.16 rows=4,316 width=16) (actual time=9.747..9.748 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.757 4.757 ↑ 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.015..4.757 rows=4,316 loops=1)

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

Hash (cost=47.29..47.29 rows=2,829 width=22) (actual time=6.463..6.464 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. 3.058 3.058 ↑ 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.023..3.058 rows=2,829 loops=1)

  • Output: produto_pgpm.nome, produto_pgpm.id
  • Buffers: shared hit=19
Planning time : 42.281 ms
Execution time : 12,091.745 ms