Monitoring JavaMelody on _ip-10-0-6-204.ec2.internal

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean size (Kb)	Mean hits sql	Mean time sql (ms)
http global	100	13	2,964	9,767	4,456	100	50	9,314	7.69	85	0	2,899
http warning	97	4	9,377	9,767	391	52	87	21,945	0.00	237	1	9,286
http severe	0	0	-1	0	-1	0	-1	-1	0.00	0	-1	-1

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean size (Kb)	Mean hits sql	Mean time sql (ms)
/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST	97	4	9,377	9,767	391	52	87	21,945	0.00	237	1	9,286
/api/document/{cnpj}/v2/nfe-canhoto POST	1	1	590	590	0	24	160	19,585	0.00	148	2	415
/actuator/health GET	0	6	41	82	36	17	19	1,516	0.00	0	0	0
/api/document/{cnpj}/v2/nfe POST	0	1	187	187	0	4	32	3,825	0.00	9	2	138
Error404	0	1	7	7	0	0	6	801	100.00	0	0	0

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation
sql global	100	235	162	9,714	1,204
sql warning	0	0	-1	0	-1
sql severe	97	4	9,286	9,714	433

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation
SELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ?	97	4	9,286	9,714	433
select documentnf0_.cnpj_issuer as cnpj_iss1_13_, documentnf0_.type as type2_13_, documentnf0_.key as key3_13_, documentnf0_.nsu as nsu4_13_, documentnf0_.protocol as protocol5_13_, documentnf0_.addressee_name as addresse6_13_, documentnf0_.available_at as availabl7_13_, documentnf0_.canceled_at as canceled8_13_, documentnf0_.canhoto_associado_at as canhoto_9_13_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_13_, documentnf0_.canhoto_id as canhoto11_13_, documentnf0_.canhoto_numero_nota as canhoto12_13_, documentnf0_.carta_correcao as carta_c13_13_, documentnf0_.cce_events as cce_eve14_13_, documentnf0_.cfops as cfops15_13_, documentnf0_.cnpj as cnpj16_13_, documentnf0_.cnpj_addressee as cnpj_ad17_13_, documentnf0_.cnpj_carrier as cnpj_ca18_13_, documentnf0_.cte_key as cte_key19_13_, documentnf0_.data as data20_13_, documentnf0_.data_emissao as data_em21_13_, documentnf0_.duplicatas as duplica22_13_, documentnf0_.etiquetas as etiquet23_13_, documentnf0_.fatura as fatura24_13_, documentnf0_.issuer_name as issuer_25_13_, documentnf0_.manifestation as manifes26_13_, documentnf0_.name_file as name_fi27_13_, documentnf0_.nfe_number as nfe_num28_13_, documentnf0_.notas_referencia as notas_r29_13_, documentnf0_.status as status30_13_, documentnf0_.value as value31_13_ from public.document_nfe_canhoto_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.key in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_issuer, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	1	1	400	400	0
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.cnpj as cnpj12_15_, documentnf0_.cnpj_addressee as cnpj_ad13_15_, documentnf0_.cnpj_carrier as cnpj_ca14_15_, documentnf0_.cte_key as cte_key15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.key in (?)) and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.issuer_name asc limit ?	0	1	120	120	0
SET ROLE 'postgres'	0	55	1	8	0
SELECT version()	0	23	2	7	1
/NO LOAD BALANCE/ SELECT "installed_rank","version","description","type","script","checksum","installed_on","installed_by","execution_time","success" FROM "public"."flyway_schema_history" WHERE "installed_rank" > ? ORDER BY "installed_rank"	0	22	2	11	1
SELECT EXISTS ( SELECT 1 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = ? AND c.relname = ? AND c.relkind = 'r' )	0	23	1	3	0
CREATE TABLE IF NOT EXISTS nfe_cte ( chave_nfe VARCHAR(44) NOT NULL, chave_cte VARCHAR(44) NOT NULL, created_at TIMESTAMP NOT NULL, PRIMARY KEY (chave_nfe, chave_cte) )	0	1	36	36	0
CREATE OR REPLACE VIEW public.document_obrigacoes_view AS SELECT document.key, document.protocol, document.cnpj_issuer, document.nsu, document.type, document.cnpj, document.imported_at, document.name_file, (CAST((document.data -> 'header'::text) ->> 'startsDate'::text as date)) AS starts_date, (CAST((document.data -> 'header'::text) ->> 'endsDate'::text as date)) AS ends_date, (document.data -> 'header'::text) ->> 'finalType'::text AS final_type, (CAST(((document.data -> 'header'::text) ->> 'deliveryDate'::text) as timestamp)) AS delivery_date, document.data ->> 'originalFileName'::text AS original_file_name, document.data_emissao, document.inscricao_estadual, cast(document.data -> 'header' ->> 'parcial' as boolean) as parcial FROM document	0	1	23	23	0
SELECT pg_try_advisory_lock(77433833903597)	0	11	2	3	0
drop view if exists document_obrigacoes_view	0	2	11	19	11
SELECT pg_advisory_unlock(77433833903597)	0	11	2	3	0
SELECT COUNT(*) FROM pg_namespace WHERE nspname=?	0	11	1	3	0
SELECT set_config('search_path', ?, false)	0	11	1	2	0
INSERT INTO "public"."flyway_schema_history" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)	0	10	1	2	0
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE SUBSTRING(d.cnpj_addressee, 1, 8) = ? and d.type IN (?, ?, ?) and d.key in (?) and d.data_emissao between ? and ?	0	1	18	18	0
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type left join canhoto_nota cn on d.key = cn.documento_chave and d.cnpj_issuer = cn.empresa_cnpj WHERE SUBSTRING(d.cnpj_issuer, 1, 8) = ? and d.type IN (?, ?, ?) and d.key in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and d.data_emissao between ? and ?	0	1	15	15	0
DROP view IF EXISTS public.document_cte_completo_view	0	1	11	11	0
CREATE OR REPLACE VIEW public.document_cte_completo_view AS SELECT doc.key, ds.manifestation, doc.type, doc.protocol, doc.nsu, ds.status, doc.data_emissao, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'nct'::text AS numero_cte, (doc.info -> 'value'::text)::numeric AS value, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'serie'::text AS serial, doc.cnpj_issuer, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'emit'::text) ->> 'id'::text AS issuer_inscricao_estadual, doc.info ->> 'issuerName'::text AS issuer_name, doc.cnpj_addressee AS addressee_cnpj_cpf, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text AS addressee_inscricao_estadual, doc.info ->> 'addresseeName'::text AS addressee_name, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'cnpj'::text AS expedidor_cnpj, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text AS expedidor_inscricao_estadual, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xnome'::text AS expedidor_nome, COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cpf'::text) AS recebedor_cnpj_cpf, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text AS recebedor_inscricao_estadual, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xnome'::text AS recebedor_nome, COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cpf'::text) AS remetente_cnpj_cpf, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text AS remetente_inscricao_estadual, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xnome'::text AS remetente_nome, ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text AS tipo_tomador_servico, doc.cnpj_cpf_tomador AS tomador4_cnpj, CASE WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'ie'::text END AS tomador4_inscricao_estadual, CASE WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xNome'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xNome'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xNome'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN doc.info ->> 'addresseeName'::text ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'xNome'::text END AS tomador4_nome, doc.cnpj_carrier, ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'tpCTe'::text)::integer AS tipo_cte, ds.available_at, ds.canceled_at, doc.name_file, doc.cnpj_cpf_remetente, doc.schema, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'cst') AS cst, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vbc') AS vbc, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'picms') AS picms, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vicms') AS vicms FROM document doc JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text	0	1	9	9	0
SHOW search_path	0	4	2	2	0
DROP view IF EXISTS public.document_cte_view	0	2	4	6	2
CREATE OR REPLACE VIEW document_nfe_view ( key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value, issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status, name_file, carta_correcao, duplicatas, fatura, data, cfops, etiquetas, notas_referencia, cte_key ) AS SELECT doc.key, doc.type, doc.cnpj, doc.cnpj_issuer, doc.cnpj_addressee, doc.cnpj_carrier, doc.data_emissao, doc.nsu, doc.protocol, (doc.info ->> 'value')::double precision AS value, doc.info ->> 'issuerName' AS issuer_name, doc.info ->> 'addresseeName' AS addressee_name, doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number, -- Manifestação COALESCE(( SELECT CASE WHEN ds.manifestation IS NOT NULL THEN ds.manifestation WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240') THEN item.historico ->> 'eventCode' WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240') THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION','NFE_EVENT') ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.manifestation) AS manifestation, ds.cce_events, ds.available_at, -- Cancelamento COALESCE(( SELECT CASE WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at WHEN item.historico ->> 'eventCode' = '110111' THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC' WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC' END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventCode' = '110111' OR regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.canceled_at) AS canceled_at, -- Status COALESCE(( SELECT CASE WHEN item.historico ->> 'eventCode' = '110111' THEN '3' WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' THEN '3' WHEN ds.status IS NOT NULL THEN ds.status ELSE '1' END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.status) AS status, doc.name_file, -- Carta de correção ( SELECT json_agg(consulta.) FROM ( SELECT d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento, d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento FROM document d WHERE doc.key = d.key AND doc.cnpj_issuer = d.cnpj_issuer AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110' AND d.data_emissao = doc.data_emissao ) consulta ) AS carta_correcao, doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas, doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura, doc.data, -- CFOPs (SELECT string_agg(DISTINCT item.value #>> '{prod,cfop}', ',') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value) ) AS cfops, -- Etiquetas (SELECT jsonb_agg(jsonb_build_object( 'id', e.id, 'nome_etiqueta', e.nome_etiqueta, 'cor_etiqueta', e.cor_etiqueta, 'etiqueta_padrao', e.etiqueta_padrao, 'cnpj_empresa', e.cnpj_empresa)) FROM etiqueta_documento ed JOIN etiqueta e ON e.id = ed.id_etiqueta_atual WHERE ed.chave_nfe = doc.key ) AS etiquetas, -- Notas Referenciadas (SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality) ) AS notas_referencia, nct.chave_cte AS cte_key FROM document doc JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer LEFT JOIN nfe_cte nct O Details CREATE OR REPLACE VIEW document_nfe_view ( key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value, issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status, name_file, carta_correcao, duplicatas, fatura, data, cfops, etiquetas, notas_referencia, cte_key ) AS SELECT doc.key, doc.type, doc.cnpj, doc.cnpj_issuer, doc.cnpj_addressee, doc.cnpj_carrier, doc.data_emissao, doc.nsu, doc.protocol, (doc.info ->> 'value')::double precision AS value, doc.info ->> 'issuerName' AS issuer_name, doc.info ->> 'addresseeName' AS addressee_name, doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number, -- Manifestação COALESCE(( SELECT CASE WHEN ds.manifestation IS NOT NULL THEN ds.manifestation WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240') THEN item.historico ->> 'eventCode' WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240') THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION','NFE_EVENT') ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.manifestation) AS manifestation, ds.cce_events, ds.available_at, -- Cancelamento COALESCE(( SELECT CASE WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at WHEN item.historico ->> 'eventCode' = '110111' THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC' WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' THEN (item.historico ->> 'eventAt')::timestamp AT TIME ZONE 'UTC' END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventCode' = '110111' OR regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.canceled_at) AS canceled_at, -- Status COALESCE(( SELECT CASE WHEN item.historico ->> 'eventCode' = '110111' THEN '3' WHEN regexp_replace(item.historico ->> 'description','[^0-9]','','gi') = '110111' THEN '3' WHEN ds.status IS NOT NULL THEN ds.status ELSE '1' END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.status) AS status, doc.name_file, -- Carta de correção ( SELECT json_agg(consulta.) FROM ( SELECT d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento, d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento FROM document d WHERE doc.key = d.key AND doc.cnpj_issuer = d.cnpj_issuer AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110' AND d.data_emissao = doc.data_emissao ) consulta ) AS carta_correcao, doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas, doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura, doc.data, -- CFOPs (SELECT string_agg(DISTINCT item.value #>> '{prod,cfop}', ',') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value) ) AS cfops, -- Etiquetas (SELECT jsonb_agg(jsonb_build_object( 'id', e.id, 'nome_etiqueta', e.nome_etiqueta, 'cor_etiqueta', e.cor_etiqueta, 'etiqueta_padrao', e.etiqueta_padrao, 'cnpj_empresa', e.cnpj_empresa)) FROM etiqueta_documento ed JOIN etiqueta e ON e.id = ed.id_etiqueta_atual WHERE ed.chave_nfe = doc.key ) AS etiquetas, -- Notas Referenciadas (SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality) ) AS notas_referencia, nct.chave_cte AS cte_key FROM document doc JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer LEFT JOIN nfe_cte nct ON doc.key = nct.chave_nfe WHERE doc.group_type = 'NFE'	0	1	7	7	0
CREATE OR REPLACE VIEW public.document_cte_view AS SELECT doc.key, ds.manifestation, doc.type, doc.protocol, doc.nsu, ds.status, doc.data_emissao, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'nct'::text AS numero_cte, (doc.info -> 'value'::text)::numeric AS value, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'serie'::text AS serial, doc.cnpj_issuer, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'emit'::text) ->> 'id'::text AS issuer_inscricao_estadual, doc.info ->> 'issuerName'::text AS issuer_name, doc.cnpj_addressee AS addressee_cnpj_cpf, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text AS addressee_inscricao_estadual, doc.info ->> 'addresseeName'::text AS addressee_name, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'cnpj'::text AS expedidor_cnpj, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text AS expedidor_inscricao_estadual, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xnome'::text AS expedidor_nome, COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'cpf'::text) AS recebedor_cnpj_cpf, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text AS recebedor_inscricao_estadual, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xnome'::text AS recebedor_nome, COALESCE((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cnpj'::text, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'cpf'::text) AS remetente_cnpj_cpf, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text AS remetente_inscricao_estadual, (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xnome'::text AS remetente_nome, ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text AS tipo_tomador_servico, doc.cnpj_cpf_tomador AS tomador4_cnpj, CASE WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'ie'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'ie'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'ie'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'dest'::text) ->> 'ie'::text ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'ie'::text END AS tomador4_inscricao_estadual, CASE WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '0'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'rem'::text) ->> 'xNome'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '1'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'exped'::text) ->> 'xNome'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '2'::text THEN (((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'receb'::text) ->> 'xNome'::text WHEN (((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma3'::text) ->> 'toma'::text) = '3'::text THEN doc.info ->> 'addresseeName'::text ELSE ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) -> 'toma4'::text) ->> 'xNome'::text END AS tomador4_nome, doc.cnpj_carrier, ((((doc.data -> 'cte'::text) -> 'infCte'::text) -> 'ide'::text) ->> 'tpCTe'::text)::integer AS tipo_cte, ds.available_at, ds.canceled_at, doc.name_file, doc.cnpj_cpf_remetente, doc.schema, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'cst') AS cst, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vbc') AS vbc, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'picms') AS picms, (doc.data -> 'cte' -> 'infCte' -> 'imp' -> 'icms' -> 'icms00' ->> 'vicms') AS vicms FROM document doc JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text	0	1	7	7	0
CREATE OR REPLACE VIEW document_nfe_canhoto_view ( key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value, issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status, name_file, carta_correcao, duplicatas, fatura, canhoto_id, canhoto_associado_at, canhoto_numero_nota, canhoto_diferenca_dias_associacao, data, cfops, etiquetas, notas_referencia, cte_key ) AS SELECT doc.key, doc.type, doc.cnpj, doc.cnpj_issuer, doc.cnpj_addressee, doc.cnpj_carrier, doc.data_emissao, doc.nsu, doc.protocol, (doc.info ->> 'value')::double precision AS value, doc.info ->> 'issuerName' AS issuer_name, doc.info ->> 'addresseeName' AS addressee_name, doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number, -- Manifestação COALESCE(( SELECT CASE WHEN ds.manifestation IS NOT NULL THEN ds.manifestation WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240') THEN item.historico ->> 'eventCode' WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240') THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') ELSE NULL END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION', 'NFE_EVENT') ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.manifestation) AS manifestation, ds.cce_events, ds.available_at, -- Cancelamento COALESCE(( SELECT CASE WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at WHEN item.historico ->> 'eventCode' = '110111' THEN (item.historico ->> 'eventAt')::timestamp WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' THEN (item.historico ->> 'eventAt')::timestamp ELSE NULL END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventCode' = '110111' OR regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.canceled_at) AS canceled_at, -- Status COALESCE(( SELECT CASE WHEN ds.status IS NOT NULL THEN ds.status WHEN item.historico ->> 'eventCode' = '110111' THEN '3' WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' THEN '3' ELSE '1' END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.status) AS status, doc.name_file, -- Carta de Correção ( SELECT json_agg(consulta.) FROM ( SELECT d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento, d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento FROM document d WHERE doc.key = d.key AND doc.cnpj_issuer = d.cnpj_issuer AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110' ) consulta ) AS carta_correcao, doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas, doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura, cn.canhoto_importacao_id AS canhoto_id, cn.created_at AS canhoto_associado_at, cn.numero_nota AS canhoto_numero_nota, COALESCE(cn.created_at, CURRENT_TIMESTAMP)::date - doc.data_emissao::date AS canhoto_diferenca_dias_associacao, doc.data, -- CFOPs ( SELECT string_agg(DISTINCT item.value ->> 'cfop', ',') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value) ) AS cfops, -- Etiquetas ( SELECT jsonb_agg( jsonb_build_object( 'id', e.id, 'nome_etiqueta', e.nome_etiqueta, 'cor_etiqueta', e.cor_etiqueta, 'etiqueta_padrao', e.etiqueta_padrao, 'cnpj_empresa', e.cnpj_empresa ) ) FROM etiqueta_documento ed JOIN etiqueta e ON e.id = ed.id_etiqueta_atual WHERE ed.chave_nfe = doc.key ) AS etiquetas, -- Notas Referenciadas ( SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality) ) AS notas_referencia, nct.chave_cte AS cte_key FROM document doc JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer LEFT JOIN canhoto_nota cn ON doc.key = cn.documento_chave AND doc.cnpj_issuer Details CREATE OR REPLACE VIEW document_nfe_canhoto_view ( key, type, cnpj, cnpj_issuer, cnpj_addressee, cnpj_carrier, data_emissao, nsu, protocol, value, issuer_name, addressee_name, nfe_number, manifestation, cce_events, available_at, canceled_at, status, name_file, carta_correcao, duplicatas, fatura, canhoto_id, canhoto_associado_at, canhoto_numero_nota, canhoto_diferenca_dias_associacao, data, cfops, etiquetas, notas_referencia, cte_key ) AS SELECT doc.key, doc.type, doc.cnpj, doc.cnpj_issuer, doc.cnpj_addressee, doc.cnpj_carrier, doc.data_emissao, doc.nsu, doc.protocol, (doc.info ->> 'value')::double precision AS value, doc.info ->> 'issuerName' AS issuer_name, doc.info ->> 'addresseeName' AS addressee_name, doc.data #>> '{nfe,infNFe,ide,nnf}' AS nfe_number, -- Manifestação COALESCE(( SELECT CASE WHEN ds.manifestation IS NOT NULL THEN ds.manifestation WHEN item.historico ->> 'eventCode' IN ('210200','210210','210220','210240') THEN item.historico ->> 'eventCode' WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') IN ('210200','210210','210220','210240') THEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') ELSE NULL END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventType' IN ('NFE_EVENT_MANIFESTATION', 'NFE_EVENT') ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.manifestation) AS manifestation, ds.cce_events, ds.available_at, -- Cancelamento COALESCE(( SELECT CASE WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at WHEN item.historico ->> 'eventCode' = '110111' THEN (item.historico ->> 'eventAt')::timestamp WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' THEN (item.historico ->> 'eventAt')::timestamp ELSE NULL END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) WHERE item.historico ->> 'eventCode' = '110111' OR regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.canceled_at) AS canceled_at, -- Status COALESCE(( SELECT CASE WHEN ds.status IS NOT NULL THEN ds.status WHEN item.historico ->> 'eventCode' = '110111' THEN '3' WHEN regexp_replace(item.historico ->> 'description', '[^0-9]', '', 'gi') = '110111' THEN '3' ELSE '1' END FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality) ORDER BY item.historico ->> 'eventAt' DESC LIMIT 1 ), ds.status) AS status, doc.name_file, -- Carta de Correção ( SELECT json_agg(consulta.) FROM ( SELECT d.data #>> '{procEventoNFe,evento,infEvento,dhEvento}' AS data_evento, d.data #>> '{procEventoNFe,evento,infEvento,detEvento,xCorrecao}' AS correcao_evento FROM document d WHERE doc.key = d.key AND doc.cnpj_issuer = d.cnpj_issuer AND d.data #>> '{procEventoNFe,retEvento,infEvento,tpEvento}' = '110110' ) consulta ) AS carta_correcao, doc.data #> '{nfe,infNFe,cobr,dup}' AS duplicatas, doc.data #> '{nfe,infNFe,cobr,fat}' AS fatura, cn.canhoto_importacao_id AS canhoto_id, cn.created_at AS canhoto_associado_at, cn.numero_nota AS canhoto_numero_nota, COALESCE(cn.created_at, CURRENT_TIMESTAMP)::date - doc.data_emissao::date AS canhoto_diferenca_dias_associacao, doc.data, -- CFOPs ( SELECT string_agg(DISTINCT item.value ->> 'cfop', ',') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,det}') item(value) ) AS cfops, -- Etiquetas ( SELECT jsonb_agg( jsonb_build_object( 'id', e.id, 'nome_etiqueta', e.nome_etiqueta, 'cor_etiqueta', e.cor_etiqueta, 'etiqueta_padrao', e.etiqueta_padrao, 'cnpj_empresa', e.cnpj_empresa ) ) FROM etiqueta_documento ed JOIN etiqueta e ON e.id = ed.id_etiqueta_atual WHERE ed.chave_nfe = doc.key ) AS etiquetas, -- Notas Referenciadas ( SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe', ', ') FROM jsonb_array_elements(doc.data #> '{nfe,infNFe,ide,nfref}') WITH ORDINALITY nota(referencia, ordinality) ) AS notas_referencia, nct.chave_cte AS cte_key FROM document doc JOIN document_status ds ON doc.key = ds.key AND doc.cnpj_issuer = ds.cnpj_issuer LEFT JOIN canhoto_nota cn ON doc.key = cn.documento_chave AND doc.cnpj_issuer = cn.empresa_cnpj LEFT JOIN nfe_cte nct ON doc.key = nct.chave_nfe WHERE doc.group_type = 'NFE'	0	1	7	7	0
CREATE OR REPLACE VIEW public.document_cte_view AS SELECT doc.key, ds.manifestation, doc.type, doc.protocol, doc.nsu, ds.status, doc.data_emissao, doc.data #>> '{cte,infCte,ide,nct}' AS numero_cte, (doc.info #>> '{value}')::numeric AS value, doc.data #>> '{cte,infCte,ide,serie}' AS serial, doc.cnpj_issuer, doc.data #>> '{cte,infCte,emit,id}' AS issuer_inscricao_estadual, doc.info #>> '{issuerName}' AS issuer_name, doc.cnpj_addressee AS addressee_cnpj_cpf, doc.data #>> '{cte,infCte,dest,ie}' AS addressee_inscricao_estadual, doc.info #>> '{addresseeName}' AS addressee_name, doc.data #>> '{cte,infCte,exped,cnpj}' AS expedidor_cnpj, doc.data #>> '{cte,infCte,exped,ie}' AS expedidor_inscricao_estadual, doc.data #>> '{cte,infCte,exped,xnome}' AS expedidor_nome, -- Recebedor pode ser CNPJ ou CPF COALESCE( doc.data #>> '{cte,infCte,receb,cnpj}', doc.data #>> '{cte,infCte,receb,cpf}' ) AS recebedor_cnpj_cpf, doc.data #>> '{cte,infCte,receb,ie}' AS recebedor_inscricao_estadual, doc.data #>> '{cte,infCte,receb,xnome}' AS recebedor_nome, -- Remetente pode ser CNPJ ou CPF COALESCE( doc.data #>> '{cte,infCte,rem,cnpj}', doc.data #>> '{cte,infCte,rem,cpf}' ) AS remetente_cnpj_cpf, doc.data #>> '{cte,infCte,rem,ie}' AS remetente_inscricao_estadual, doc.data #>> '{cte,infCte,rem,xnome}' AS remetente_nome, doc.data #>> '{cte,infCte,ide,toma3,toma}' AS tipo_tomador_servico, doc.cnpj_cpf_tomador AS tomador4_cnpj, -- Tomador4 pode ser Remetente, Expedidor, Recebedor, Destinatário ou outro CASE WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '0' THEN doc.data #>> '{cte,infCte,rem,ie}' WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '1' THEN doc.data #>> '{cte,infCte,exped,ie}' WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '2' THEN doc.data #>> '{cte,infCte,receb,ie}' WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '3' THEN doc.data #>> '{cte,infCte,dest,ie}' ELSE doc.data #>> '{cte,infCte,ide,toma4,ie}' END AS tomador4_inscricao_estadual, -- Tomador4 pode ser Remetente, Expedidor, Recebedor, Destinatário ou outro CASE WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '0' THEN doc.data #>> '{cte,infCte,rem,xNome}' WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '1' THEN doc.data #>> '{cte,infCte,exped,xNome}' WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '2' THEN doc.data #>> '{cte,infCte,receb,xNome}' WHEN doc.data #>> '{cte,infCte,ide,toma3,toma}' = '3' THEN doc.info #>> '{addresseeName}' ELSE doc.data #>> '{cte,infCte,ide,toma4,xNome}' END AS tomador4_nome, doc.cnpj_carrier, (doc.data #>> '{cte,infCte,ide,tpCTe}')::integer AS tipo_cte, ds.available_at, ds.canceled_at, doc.name_file, doc.cnpj_cpf_remetente, doc.schema, COALESCE( doc.data #>> '{cte,infCte,imp,icms,icms00,cst}', doc.data #>> '{cte,infCte,imp,icms,icms20,cst}', doc.data #>> '{cte,infCte,imp,icms,icms45,cst}', doc.data #>> '{cte,infCte,imp,icms,icms60,cst}', doc.data #>> '{cte,infCte,imp,icms,icms90,cst}', doc.data #>> '{cte,infCte,imp,icms,icmsOutraUF,cst}', doc.data #>> '{cte,infCte,imp,icms,icmssn,cst}' ) AS cst, doc.data #>> '{cte,infCte,imp,icms,icms00,vbc}' AS vbc, doc.data #>> '{cte,infCte,imp,icms,icms00,picms}' AS picms, doc.data #>> '{cte,infCte,imp,icms,icms00,vicms}' AS vicms, ARRAY( SELECT infnfe ->> 'chave' FROM jsonb_array_elements(doc.data #> '{cte,infCte,infCTeNorm,infDoc,infNFe}') infnfe ) AS chaves_nfe_documento, nfe_assoc.chaves_nfe_associadas_sistema FROM document doc JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text LEFT JOIN LATERAL ( SELECT array_agg(chave_nfe) AS chaves_nfe_associadas_sistema FROM nfe_cte WHERE nfe_cte.chave_cte = doc.key ) nfe_assoc ON TRUE where doc.group_type = 'CTE'	0	1	6	6	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS origem_contribuicoes boolean default false not null	0	1	6	6	0
SELECT current_schema	0	3	2	2	0
alter table public.cnpj_consolidation ADD COLUMN IF NOT EXISTS versao_consolidacao integer default 1 not null	0	1	4	4	0
CREATE INDEX IF NOT EXISTS resumo_nfe_c_idx ON public.resumo_nfe USING btree (cnpj)	0	1	4	4	0
SELECT current_user	0	2	1	2	0
DROP VIEW IF EXISTS public.document_nfe_view	0	1	3	3	0
-- ============================ -- SPED ICMS / IPI -- ============================ UPDATE configuracao_consolidacao SET origem_icms_ipi = true WHERE tipo_consolidacao IN ( 'ANALISE_VENDA_PRODUTO',--OK 'ANALISE_VENDA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_VENDA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI 'ANALISE_COMPRA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_COMPRA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI 'ANALISE_REPRESENTATIVIDADE',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'EXCLUSAO_ICMS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'CONTRATACAO_FRETE_OPERACAO_ACUMULO_CREDITO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS',--OK DEPENDE DE SPED_EFD_ICMS_IPI E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_PIS_COFINS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES: -- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR, -- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS, -- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL, -- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS, -- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST, -- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL, -- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO, -- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO, -- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS, -- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS, -- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS, -- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR, -- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS, -- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS, -- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL, -- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS, -- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL, -- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO, -- 19.EXCLUSAO_ICMS_BC_IPI, -- 20.EXCLUSAO_PIS_COFINS_BC_IPI 'OPORTUNIDADE_TESE_JURIDICA_CNPJ' -- DEPENDE DE XML, DEPENDE DE SPED_EFD_ICMS_IPI E DEPENDE DE ANALISES: -- 1.CREDITOS_POSSIVEIS_ICMS )	0	1	3	3	0
DROP VIEW IF EXISTS public.document_nfe_canhoto_view	0	1	3	3	0
CREATE OR REPLACE VIEW public.document_obrigacoes_view AS SELECT document.key, document.protocol, document.cnpj_issuer, document.nsu, document.type, document.cnpj, document.imported_at, document.name_file, (CAST((document.data -> 'header'::text) ->> 'startsDate'::text as date)) AS starts_date, (CAST((document.data -> 'header'::text) ->> 'endsDate'::text as date)) AS ends_date, (document.data -> 'header'::text) ->> 'finalType'::text AS final_type, (CAST(((document.data -> 'header'::text) ->> 'deliveryDate'::text) as timestamp)) AS delivery_date, document.data ->> 'originalFileName'::text AS original_file_name, document.data_emissao, document.inscricao_estadual, cast(coalesce(document.data -> 'header' ->> 'parcial', 'false') as boolean) as parcial FROM document	0	1	3	3	0
-- ============================ -- SPED CONTRIBUIÇÕES -- ============================ UPDATE configuracao_consolidacao SET origem_contribuicoes = true WHERE tipo_consolidacao IN ( 'CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO',--OK 'EXCLUSAO_ICMSST_BASE_PIS_COFINS',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS',--OK DEPENDE DE SPED_EFD_ICMS_IPI E SPED_EF_CONTRIBUIÇÕES 'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES: -- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR, -- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS, -- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL, -- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS, -- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST, -- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL, -- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO, -- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO, -- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS, -- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS, -- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS, -- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR, -- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS, -- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS, -- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL, -- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS, -- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL, -- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO, -- 19.EXCLUSAO_ICMS_BC_IPI, -- 20.EXCLUSAO_PIS_COFINS_BC_IPI 'OPORTUNIDADE_TESE_JURIDICA_CNPJ' -- DEPENDE DE XML, DEPENDE DE SPED_EFD_ICMS_IPI E DEPENDE DE ANALISES: -- 1.CREDITOS_POSSIVEIS_ICMS )	0	1	3	3	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS versao_consolidacao integer default 1 not null	0	1	3	3	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS origem_ecd boolean default false not null	0	1	2	2	0
-- ============================ -- eSocial -- ============================ UPDATE configuracao_consolidacao SET origem_esocial = true WHERE tipo_consolidacao IN ( 'SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS',--OK DEPENDE DE XML E ESOCIAL 'OPORTUNIDADE_DOCUMENT_CNPJ'--OK DEPENDE DE CONSOLIDACOES: -- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR, -- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS, -- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL, -- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS, -- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST, -- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL, -- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO, -- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO, -- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS, -- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS, -- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS, -- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR, -- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS, -- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS, -- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL, -- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS, -- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL, -- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO, -- 19.EXCLUSAO_ICMS_BC_IPI, -- 20.EXCLUSAO_PIS_COFINS_BC_IPI )	0	1	2	2	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS origem_esocial boolean default false not null	0	1	2	2	0
comment on column public.configuracao_consolidacao.origem_contribuicoes is 'Identificar se dados consolidados são oriundos do SPED Contribuições.'	0	1	2	2	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS origem_xml boolean default false not null	0	1	2	2	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS origem_ecf boolean default false not null	0	1	2	2	0
comment on column public.configuracao_consolidacao.origem_esocial is 'Identificar se dados consolidados são oriundos do eSocial.'	0	1	2	2	0
-- ============================ -- XML -- ============================ UPDATE configuracao_consolidacao SET origem_xml = true WHERE tipo_consolidacao IN ( -- 'ANALISE_ICMS_BASE_PIS_COFINS',--DESATIVADO 'ANALISE_VENDA_PRODUTO',--OK 'ANALISE_VENDA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_VENDA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI 'ANALISE_COMPRA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_COMPRA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI\| 'ANALISE_PIS_COFINS_RESTITUIR_ICMS_ST',--OK -- 'ANALISE_PIS_COFINS_RESTITUIR_ISS',--DESATIVADO 'ANALISE_REPRESENTATIVIDADE',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL',--OK 'ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR',--OK 'ANALISE_SERVICO_PRESTADO_NFSE',--OK 'ANALISE_CLIENTE_NFSE',--OK 'ANALISE_SERVICOS_TOMADOS_NFSE',--OK 'ANALISE_FORNECEDORES_NFSE',--OK 'OPORTUNIDADE_RESSARCIMENTO_CIGARROS',--OK 'EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST',--OK 'INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL',--OK 'CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO',--OK 'ANALISE_PM_PF',--OK DEPENDE DE XML E CONFAZ 'CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'CHECAGEM_ALIQUOTA_ICMS',--OK 'VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS', --OK 'CONTRATACAO_FRETE_OPERACAO_ACUMULO_CREDITO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'RECALCULO_EXCLUSAO_GROSSUP_ICMS',--OK 'EXCLUSAO_ICMSST_BASE_PIS_COFINS',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS',--OK DEPENDE XML 'EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL',--OK DEPENDE XML 'SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS',--OK DEPENDE DE XML E ESOCIAL 'ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL',--OK DEPENDE XML 'SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO',--OK DEPENDE XML 'EXCLUSAO_ICMS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'EXCLUSAO_PIS_COFINS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES: -- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR, -- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS, -- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL, -- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS, -- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST, -- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL, -- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO, -- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO, -- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS, -- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS, -- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS, -- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR, -- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS, -- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS, -- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL, -- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS, -- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL, -- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO, -- 19.EXCLUSAO Details -- ============================ -- XML -- ============================ UPDATE configuracao_consolidacao SET origem_xml = true WHERE tipo_consolidacao IN ( -- 'ANALISE_ICMS_BASE_PIS_COFINS',--DESATIVADO 'ANALISE_VENDA_PRODUTO',--OK 'ANALISE_VENDA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_VENDA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI 'ANALISE_COMPRA_ESTADO_REGIAO',--OK XML - DEPENDE DE CONSOLIDAÇÃO ANALISE_COMPRA_ESTADO_REGIAO --> SPED_EFD_ICMS_IPI\| 'ANALISE_PIS_COFINS_RESTITUIR_ICMS_ST',--OK -- 'ANALISE_PIS_COFINS_RESTITUIR_ISS',--DESATIVADO 'ANALISE_REPRESENTATIVIDADE',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL',--OK 'ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR',--OK 'ANALISE_SERVICO_PRESTADO_NFSE',--OK 'ANALISE_CLIENTE_NFSE',--OK 'ANALISE_SERVICOS_TOMADOS_NFSE',--OK 'ANALISE_FORNECEDORES_NFSE',--OK 'OPORTUNIDADE_RESSARCIMENTO_CIGARROS',--OK 'EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST',--OK 'INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL',--OK 'CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO',--OK 'ANALISE_PM_PF',--OK DEPENDE DE XML E CONFAZ 'CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'CHECAGEM_ALIQUOTA_ICMS',--OK 'VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS', --OK 'CONTRATACAO_FRETE_OPERACAO_ACUMULO_CREDITO',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'RECALCULO_EXCLUSAO_GROSSUP_ICMS',--OK 'EXCLUSAO_ICMSST_BASE_PIS_COFINS',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR',--OK DEPENDE DE XML E SPED_EF_CONTRIBUIÇÕES 'EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS',--OK DEPENDE XML 'EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL',--OK DEPENDE XML 'SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS',--OK DEPENDE DE XML E ESOCIAL 'ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL',--OK DEPENDE XML 'SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO',--OK DEPENDE XML 'EXCLUSAO_ICMS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'EXCLUSAO_PIS_COFINS_BC_IPI',--OK DEPENDE DE XML E SPED_EFD_ICMS_IPI 'OPORTUNIDADE_DOCUMENT_CNPJ',--OK DEPENDE DE CONSOLIDACOES: -- 1.ANALISE_EXCLUSAO_ICMS_BC_PIS_COFINS_RESTITUIR, -- 2.ANALISE_PIS_COFINS_RESTITUIR_ISS, -- 3.ANALISE_NAO_INCIDENCIA_SOBRE_CONTRATOS_EMPREITADA_GLOBAL, -- 4.OPORTUNIDADE_RESSARCIMENTO_CIGARROS, -- 5.EXCLUSAO_IPI_BASE_CALCULO_PIS_COFINS_ST, -- 6.INCONSTITUCIONALIDADE_DIFAL_SIMPLES_NACIONAL, -- 7.CREDITO_PIS_COFINS_AQUISICAO_INSUMOS_MATERIAL_RECICLADO, -- 8.CREDITO_ICMS_OPERACAO_ST_SUBSTITUIDO, -- 9.VALIDACAO_TRIBUTACAO_SAIDA_PRODUTOS_MONOFASICOS, -- 10.RECALCULO_EXCLUSAO_GROSSUP_ICMS, -- 11.EXCLUSAO_ICMSST_BASE_PIS_COFINS, -- 12.EXCLUSAO_PIS_COFINS_BC_ICMS_RESTITUIR, -- 13.EXCLUSAO_DIFERENCIAL_ALIQUOTAS_ICMS_CALCULO_PIS_COFINS, -- 14.EXCLUSAO_ADICIONAL_ICMS_PIS_COFINS, -- 15.EXCLUSAO_BASE_CALCULO_BENEFICIO_FISCAL, -- 16.SIMPLES_NACIONAL_VENDAS_BRUTAS_X_COMPRAS_BRUTAS, -- 17.ICMS_ST_SIMPLES_NACIONAL_CONSUMIDOR_FINAL, -- 18.SIMPLES_NACIONAL_CREDITO_PIS_COFINS_MONOFASICO, -- 19.EXCLUSAO_ICMS_BC_IPI, -- 20.EXCLUSAO_PIS_COFINS_BC_IPI 'OPORTUNIDADE_TESE_JURIDICA_CNPJ' -- DEPENDE DE XML, DEPENDE DE SPED_EFD_ICMS_IPI E DEPENDE DE ANALISES: -- 1.CREDITOS_POSSIVEIS_ICMS )	0	1	2	2	0
CREATE TABLE IF NOT EXISTS public.resumo_nfe ( id int8 NOT NULL GENERATED BY DEFAULT AS IDENTITY, cnpj varchar(14) NULL, key varchar(44) NULL, name_file varchar(255) NULL, status varchar(255) NULL, prioridade int8 NULL, create_at timestamptz NULL, update_at timestamptz NULL, CONSTRAINT resumo_nfe_pkey PRIMARY KEY (id) )	0	1	2	2	0
CREATE UNIQUE INDEX IF NOT EXISTS resumo_nfe_c_k_idx ON public.resumo_nfe USING btree (cnpj, key)	0	1	2	2	0
SELECT CURRENT_USER	0	1	2	2	0
comment on column public.configuracao_consolidacao.origem_icms_ipi is 'Identificar se dados consolidados são oriundos do SPED ICMS IPI.'	0	1	2	2	0
comment on column public.configuracao_consolidacao.origem_ecd is 'Identificar se dados consolidados são oriundos do SPED ECD.'	0	1	2	2	0
alter table public.configuracao_consolidacao ADD COLUMN IF NOT EXISTS origem_icms_ipi boolean default false not null	0	1	2	2	0
comment on column public.configuracao_consolidacao.versao_consolidacao is 'Identificar a versao em que a consolidação se encontra.'	0	1	2	2	0
comment on column public.configuracao_consolidacao.origem_xml is 'Identificar se dados consolidados são oriundos de XML.'	0	1	2	2	0
CREATE TABLE IF NOT EXISTS public.resumo_nfe_prioridade ( cnpj varchar(14) NOT NULL, prioridade int8 NULL, CONSTRAINT resumo_nfe_prioridade_pkey PRIMARY KEY (cnpj) )	0	1	2	2	0
CREATE INDEX IF NOT EXISTS resumo_nfe_c_s_idx ON public.resumo_nfe USING btree (cnpj, status)	0	1	2	2	0
comment on column public.cnpj_consolidation.versao_consolidacao is 'Identificar versão da consolidação em que os dados foram consolidados.'	0	1	1	1	0
comment on column public.configuracao_consolidacao.origem_ecf is 'Identificar se dados consolidados são oriundos do SPED ECF.'	0	1	1	1	0

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	Mean hits sql	Mean time sql (ms)
spring global	100	13	5,856	9,752	4,601	100	51	12,756	1	5,799
spring warning	0	0	-1	0	-1	0	-1	-1	-1	-1
spring severe	0	0	-1	0	-1	0	-1	-1	-1	-1

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	Mean hits sql	Mean time sql (ms)
CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	49	4	9,343	9,752	408	32	54	16,779	1	9,286
CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	49	4	9,342	9,752	409	31	52	16,578	1	9,286
DocumentController.getDocumentsNFECanhoto	0	1	533	533	0	16	108	15,027	2	415
DocumentNfeCanhotoViewQueryService.findDocumentsWithData	0	1	517	517	0	14	96	10,695	2	415
DocumentController.getDocumentsNFEV2	0	1	173	173	0	2	19	2,685	2	138
DocumentNfeViewQueryService.findDocumentsWithData	0	1	166	166	0	2	18	2,672	2	138
BasicErrorController.error	0	1	3	3	0	0	3	1,328	0	0

Error	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb
Error404	100	1	7	7	0	100	6	801

Error	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb
Error404	100	1	7	7	0	100	6	801

Date	Request	Error
9/29/25, 6:09:36 PM	/robots.txt GET	Error404

Thread	User	Request	Elapsed time (ms)	Mean time (ms)	Cpu time (ms)	Mean cpu time (ms)	Hits sql	Mean hits sql	Time sql (ms)	Mean time sql (ms)	Executed method	Kill
XNIO-1 task-3 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source) app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113) app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441) app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057) app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422) app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142) app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300) app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source) app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) app//org.hibernate.loader.Loader.doQuery(Loader.java:948) app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) app//org.hibernate.loader.Loader.doList(Loader.java:2850) app//org.hibernate.loader.Loader.doList(Loader.java:2832) app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) app//org.hibernate.loader.Loader.list(Loader.java:2659) app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338) app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141) app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163) app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173) app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533) app//org.hibernate.query.Query.getResultList(Query.java:165) app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156) app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205) com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517) app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584) app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132) app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119) app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269) app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130) app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99) app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370) app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836) app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) java.base@11.0.23/java.lang.Thread.run(Unknown Source) XNIO-1 task-3	UsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}	/api/nfe/credito-tese-artigo-426a/71605265010205/period?dataInicio=2022-09-01T00:00&dataFim=2022-09-30T23:59:59.999999999&page=14&size=1000 POST CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm SELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ?	7,605 7,602 7,602 7,601	9,377 9,343 9,342 9,286	4 2 2	87 54 52	0 0 0	1 1 1	0 0 0	9,286 9,286 9,286	java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)
XNIO-1 task-2 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source) app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113) app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441) app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057) app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422) app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142) app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300) app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source) app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) app//org.hibernate.loader.Loader.doQuery(Loader.java:948) app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) app//org.hibernate.loader.Loader.doList(Loader.java:2850) app//org.hibernate.loader.Loader.doList(Loader.java:2832) app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) app//org.hibernate.loader.Loader.list(Loader.java:2659) app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338) app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141) app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163) app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173) app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533) app//org.hibernate.query.Query.getResultList(Query.java:165) app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156) app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205) com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517) app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584) app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132) app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119) app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269) app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130) app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99) app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370) app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836) app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) java.base@11.0.23/java.lang.Thread.run(Unknown Source) XNIO-1 task-2	UsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}	/api/nfe/credito-tese-artigo-426a/71605265010205/period?dataInicio=2022-09-01T00:00&dataFim=2022-09-30T23:59:59.999999999&page=31&size=1000 POST CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm SELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? offset ?	1,985 1,982 1,982 1,977	9,377 9,343 9,342 9,286	5 2 2	87 54 52	0 0 0	1 1 1	0 0 0	9,286 9,286 9,286	java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)

Thread	Daemon ?	Priority	State	Executed method	Cpu time (ms)	User time (ms)
Common-Cleaner java.base@11.0.23/java.lang.Object.wait(Native Method) java.base@11.0.23/java.lang.ref.ReferenceQueue.remove(Unknown Source) java.base@11.0.23/jdk.internal.ref.CleanerImpl.run(Unknown Source) java.base@11.0.23/java.lang.Thread.run(Unknown Source) java.base@11.0.23/jdk.internal.misc.InnocuousThread.run(Unknown Source) Common-Cleaner	yes	8	TIMED_WAITING	java.base@11.0.23/java.lang.Object.wait(Native Method)	3	0
DestroyJavaVM	no	5	RUNNABLE		414	380
Finalizer java.base@11.0.23/java.lang.Object.wait(Native Method) java.base@11.0.23/java.lang.ref.ReferenceQueue.remove(Unknown Source) java.base@11.0.23/java.lang.ref.ReferenceQueue.remove(Unknown Source) java.base@11.0.23/java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source) Finalizer	yes	8	WAITING	java.base@11.0.23/java.lang.Object.wait(Native Method)	2	0
Hikari housekeeper java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) java.base@11.0.23/java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source) java.base@11.0.23/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source) java.base@11.0.23/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source) java.base@11.0.23/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source) java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source) java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base@11.0.23/java.lang.Thread.run(Unknown Source) Hikari housekeeper	yes	5	TIMED_WAITING	java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)	2	0
HttpClient-1-SelectorManager java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) platform/java.net.http@11.0.23/jdk.internal.net.http.HttpClientImpl$SelectorManager.run(Unknown Source) HttpClient-1-SelectorManager	yes	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	2	0
idle-connection-reaper java.base@11.0.23/java.lang.Thread.sleep(Native Method) app//software.amazon.awssdk.http.apache.internal.conn.IdleConnectionReaper$ReaperTask.run(IdleConnectionReaper.java:150) java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base@11.0.23/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base@11.0.23/java.lang.Thread.run(Unknown Source) idle-connection-reaper	yes	5	TIMED_WAITING	java.base@11.0.23/java.lang.Thread.sleep(Native Method)	0	0
java-sdk-http-connection-reaper java.base@11.0.23/java.lang.Thread.sleep(Native Method) app//com.amazonaws.http.IdleConnectionReaper.run(IdleConnectionReaper.java:188) java-sdk-http-connection-reaper	yes	5	TIMED_WAITING	java.base@11.0.23/java.lang.Thread.sleep(Native Method)	0	0
javamelody java.base@11.0.23/java.lang.Object.wait(Native Method) java.base@11.0.23/java.util.TimerThread.mainLoop(Unknown Source) java.base@11.0.23/java.util.TimerThread.run(Unknown Source) javamelody	yes	5	TIMED_WAITING	java.base@11.0.23/java.lang.Object.wait(Native Method)	4	0
PostgreSQL-JDBC-SharedTimer-1 java.base@11.0.23/java.lang.Object.wait(Native Method) java.base@11.0.23/java.util.TimerThread.mainLoop(Unknown Source) java.base@11.0.23/java.util.TimerThread.run(Unknown Source) PostgreSQL-JDBC-SharedTimer-1	yes	5	TIMED_WAITING	java.base@11.0.23/java.lang.Object.wait(Native Method)	0	0
reactor-http-epoll-1 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-1	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	171	150
reactor-http-epoll-10 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-10	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-11 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-11	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-12 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-12	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-13 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-13	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-14 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-14	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-15 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-15	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-16 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-16	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-2 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-2	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-3 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-3	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-4 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-4	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-5 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-5	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-6 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-6	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-7 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-7	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-8 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-8	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
reactor-http-epoll-9 app//io.netty.channel.epoll.Native.epollWait(Native Method) app//io.netty.channel.epoll.Native.epollWait(Native.java:148) app//io.netty.channel.epoll.Native.epollWait(Native.java:141) app//io.netty.channel.epoll.EpollEventLoop.epollWaitNoTimerChange(EpollEventLoop.java:290) app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:347) app//io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) app//io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) app//io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) java.base@11.0.23/java.lang.Thread.run(Unknown Source) reactor-http-epoll-9	yes	5	RUNNABLE	app//io.netty.channel.epoll.Native.epollWait(Native Method)	0	0
Reference Handler java.base@11.0.23/java.lang.ref.Reference.waitForReferencePendingList(Native Method) java.base@11.0.23/java.lang.ref.Reference.processPendingReferences(Unknown Source) java.base@11.0.23/java.lang.ref.Reference$ReferenceHandler.run(Unknown Source) Reference Handler	yes	10	RUNNABLE	java.base@11.0.23/java.lang.ref.Reference.waitForReferencePendingList(Native Method)	4	0
Signal Dispatcher	yes	9	RUNNABLE		0	0
XNIO-1 Accept java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 Accept	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	11	10
XNIO-1 I/O-1 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-1	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	27	20
XNIO-1 I/O-10 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-10	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	1	0
XNIO-1 I/O-11 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-11	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	8	0
XNIO-1 I/O-12 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-12	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-13 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-13	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-14 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-14	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	13	10
XNIO-1 I/O-15 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-15	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-16 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-16	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-2 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-2	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-3 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-3	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-4 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-4	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	17	10
XNIO-1 I/O-5 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-5	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-6 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:551) XNIO-1 I/O-6	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	3	0
XNIO-1 I/O-7 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-7	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 I/O-8 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-8	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	1	0
XNIO-1 I/O-9 java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) java.base@11.0.23/sun.nio.ch.EPollSelectorImpl.doSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.lockAndDoSelect(Unknown Source) java.base@11.0.23/sun.nio.ch.SelectorImpl.select(Unknown Source) app//org.xnio.nio.WorkerThread.run(WorkerThread.java:532) XNIO-1 I/O-9	no	5	RUNNABLE	java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method)	0	0
XNIO-1 task-1 java.base@11.0.23/java.lang.Thread.dumpThreads(Native Method) java.base@11.0.23/java.lang.Thread.getAllStackTraces(Unknown Source) app//net.bull.javamelody.internal.model.JavaInformations.buildThreadInformationsList(JavaInformations.java:327) app//net.bull.javamelody.internal.model.JavaInformations.<init>(JavaInformations.java:202) app//net.bull.javamelody.internal.web.MonitoringController.doActionIfNeededAndReport(MonitoringController.java:158) app//net.bull.javamelody.MonitoringFilter.doMonitoring(MonitoringFilter.java:408) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:206) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132) app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119) app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269) app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130) app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99) app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370) app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836) app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) java.base@11.0.23/java.lang.Thread.run(Unknown Source) XNIO-1 task-1	no	5	RUNNABLE	java.base@11.0.23/java.lang.Thread.dumpThreads(Native Method)	782	760
XNIO-1 task-2 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source) app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113) app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441) app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057) app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422) app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142) app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300) app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source) app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) app//org.hibernate.loader.Loader.doQuery(Loader.java:948) app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) app//org.hibernate.loader.Loader.doList(Loader.java:2850) app//org.hibernate.loader.Loader.doList(Loader.java:2832) app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) app//org.hibernate.loader.Loader.list(Loader.java:2659) app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338) app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141) app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163) app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173) app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533) app//org.hibernate.query.Query.getResultList(Query.java:165) app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156) app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205) com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517) app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584) app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132) app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119) app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269) app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130) app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99) app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370) app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836) app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) java.base@11.0.23/java.lang.Thread.run(Unknown Source) XNIO-1 task-2	no	5	RUNNABLE	java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)	973	860
XNIO-1 task-3 java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method) java.base@11.0.23/java.net.SocketInputStream.socketRead(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/java.net.SocketInputStream.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source) java.base@11.0.23/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source) app//org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128) app//org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113) app//org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) app//org.postgresql.core.PGStream.receiveChar(PGStream.java:441) app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057) app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422) app//net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142) app//net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300) app//com.sun.proxy.$Proxy131.executeQuery(Unknown Source) app//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) app//org.hibernate.loader.Loader.getResultSet(Loader.java:2304) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) app//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) app//org.hibernate.loader.Loader.doQuery(Loader.java:948) app//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) app//org.hibernate.loader.Loader.doList(Loader.java:2850) app//org.hibernate.loader.Loader.doList(Loader.java:2832) app//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) app//org.hibernate.loader.Loader.list(Loader.java:2659) app//org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338) app//org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141) app//org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163) app//org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173) app//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533) app//org.hibernate.query.Query.getResultList(Query.java:165) app//org.springframework.data.jpa.repository.query.JpaQueryExecution$SlicedExecution.doExecute(JpaQueryExecution.java:156) app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154) app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor$QueryMethodInvoker.invoke(QueryExecutorMethodInterceptor.java:195) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:152) app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) com.sun.proxy.$Proxy408.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205) com.sun.proxy.$Proxy208.findAllCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(Unknown Source) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AServiceImpl.java:28) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$FastClassBySpringCGLIB$$91ed21a6.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1687/0x0000000840f68040.proceedWithInvocation(Unknown Source) app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.service.impl.CreditoTeseArtigo426AServiceImpl$$EnhancerBySpringCGLIB$$5861cb4e.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(CreditoTeseArtigo426AController.java:37) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$FastClassBySpringCGLIB$$3455e92e.invoke(<generated>) app//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:76) app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) app//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) br.com.revizia.documentapi.v2.creditoteseartigo426a.controller.CreditoTeseArtigo426AController$$EnhancerBySpringCGLIB$$204b93d5.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm(<generated>) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) java.base@11.0.23/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.base@11.0.23/java.lang.reflect.Method.invoke(Unknown Source) app//org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) app//org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) app//org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) app//org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) app//org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) app//org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) app//org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) app//org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) app//org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:517) app//org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) app//javax.servlet.http.HttpServlet.service(HttpServlet.java:584) app//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:113) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239) app//net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) app//org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:118) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:158) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) br.com.revizia.documentapi.config.security.jwt.JwtTokenFilter.doFilterInternal(JwtTokenFilter.java:86) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) app//org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) app//org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) app//org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) app//org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) app//org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) app//org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) app//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) app//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) app//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) app//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) app//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) app//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) app//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) app//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132) app//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) app//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) app//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) app//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) app//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) app//io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119) app//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269) app//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133) app//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130) app//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) app//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) app//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) app//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) app//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99) app//io.undertow.server.Connectors.executeRootHandler(Connectors.java:370) app//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836) app//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) app//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) java.base@11.0.23/java.lang.Thread.run(Unknown Source) XNIO-1 task-3	no	5	RUNNABLE	java.base@11.0.23/java.net.SocketInputStream.socketRead0(Native Method)	143	130
XNIO-1 task-4 java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) java.base@11.0.23/java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source) app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2234) app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1493) java.base@11.0.23/java.lang.Thread.run(Unknown Source) XNIO-1 task-4	no	5	TIMED_WAITING	java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)	26	20

The cpu times and user times of these threads are measured from the start of the server

Dump threads as text

View in a new page

Host:	ip-10-0-6-204.ec2.internal@10.0.6.204
Java memory used:	176 Mb / 25,600 Mb
Nb of http sessions:	0
Nb of active threads (current http requests):	2
Nb of active jdbc connections:	2
Nb of used jdbc connections (opened if no datasource):	2
System load	0.76
% System CPU	1.31

OS:	Linux, 5.10.240-238.966.amzn2.x86_64 , amd64/64 (16 cores)
Java:	OpenJDK Runtime Environment, 11.0.23+9
JVM:	OpenJDK 64-Bit Server VM, 11.0.23+9, mixed mode, sharing
PID of process:	7
Nb of opened files	428 / 65,535
Server:	Undertow - 2.1.4.Final
Webapp context:
Start:	9/29/25, 6:08 PM
JVM arguments:	-Xms1024m -Xmx25600m -XX:+HeapDumpOnOutOfMemoryError -Xverify:none -XX:+AlwaysPreTouch -Djava.security.egd=file:/dev/./urandom
Mean age of http sessions (min):	-1
Memory:	Non heap memory = 200 Mb (Perm Gen, Code Cache), Buffered memory = 17 Mb, Loaded classes = 22,920, Garbage collection time = 1,004 ms, Process cpu time = 105,750 ms, Committed virtual memory = 33,632 Mb, Free physical memory = 29,563 Mb, Total physical memory = 32,768 Mb
Free disk space:	19,830 Mb
Usable disk space:	18,278 Mb
DataBase:	dataSource: jdbc:postgresql://bd-rvz-prod-proxy.proxy-cjipvy4ifgsj.us-east-1.rds.amazonaws.com/documents?ApplicationName=document-api&reWriteBatchedInserts=true&rewriteBatchedStatements=true&assumeMinServerVersion=9.0 PostgreSQL, 15.13 Driver JDBC: PostgreSQL JDBC Driver, 42.2.18
Dependencies:	Dependencies

Statistics of JavaMelody monitoring taken at 9/29/25, 6:10 PM from 9/29/25, 6:08 PM on _ip-10-0-6-204.ec2.internal (application)

Statistics http - all

Statistics sql - all

Statistics spring - all

Statistics http system errors - all

Statistics system errors logs - all

Current requests

System information

Threads