alert A new version of JavaMelody is available (1.91.0 instead of 1.90.0, see Release Notes)

Stats Statistics of JavaMelody monitoring taken at 8/25/25, 7:04 PM from 8/25/25, 6:51 PM on _ip-10-0-15-189.ec2.internal (application)

Update Update     PDF PDF     Online help Online help     Monitoring with a Rich Desktop Application Desktop     Choice of period :  Day Day  Week Week  Month Month  Year Year  All All  Customized Customized


           (m/d/yy)     


Used memory % CPU Http sessions
Active threads Active jdbc connections Used jdbc connections
Http hits per minute Http mean times (ms) % of http errors
Sql hits per minute Sql mean times (ms) % of sql errors
Spring hits per minute Spring mean times (ms) % of spring errors
Other charts
% Garbage Collector time Threads count Loaded classes count
Used buffered memory Used non heap memory Used physical memory
Used swap space System load % System CPU
Nb of opened files Mean age of http sessions (min) Transactions per minute
Free disk space Usable disk space

http Statistics http - all

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean size (Kb)Mean hits sqlMean time sql (ms)
http global 100 885 60 2,330 110 100 6 767 0.11 2 7 45
http warning 0 0 -1 0 -1 0 -1 -1 0.00 0 -1 -1
http severe 5 3 1,040 2,330 1,118 15 277 32,483 0.00 15 2 185
69 hits/min on 11 requests       Details       Clear
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean size (Kb)Mean hits sqlMean time sql (ms)
graph/api/regularize/divida-ativa/{cnpj} POST 75 353 113 1,270 94 44 6 625 0.00 0 17 100
graph/api/document/keys POST 10 214 27 284 23 18 4 977 0.00 9 1 16
graph/api/download/nfse/pdf-zip-online POST 5 3 1,040 2,330 1,118 15 277 32,483 0.00 15 2 185
graph/api/document/{cnpj}/nfse/period GET 4 153 16 99 14 14 5 781 0.00 0 1 5
graph/actuator/health GET 2 150 8 98 17 6 2 132 0.00 0 0 0
graph/api/document/{cnpj}/v2/cte POST 0 1 119 119 0 1 68 7,257 0.00 4 2 33
graph/api/document/{cnpj}/products-nfe GET 0 1 98 98 0 0 6 436 0.00 0 1 88
graph/api/document/{key}/sped-document GET 0 4 17 28 7 0 6 653 0.00 0 1 5
graph/api/document/{cnpj}/find-nota-emitida-periodo POST 0 1 24 24 0 0 11 1,103 0.00 0 1 6
graph/api/server/publico/version GET 0 4 1 4 1 0 0 186 0.00 0 0 0
graphError404 0 1 4 4 0 0 3 637 100.00 0 0 0

sql Statistics sql - all

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of system error
sql global 100 6,770 6 350 7 0.00
sql warning 7 190 16 200 14 0.00
sql severe 2 12 79 288 75 0.00
527 hits/min on 55 requests       Details       Clear
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of system error
graphinsert into divida_ativa_regularize (cnpj, cnpj_cpf_devedor, created_at, data_consolidacao, devedor, emissao_doc_pagamento, grupo, numero_inscricao, numero_processo, situacao, tipo, valor_consolidado) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 71 5,584 5 350 5 0.00
graphselect dividaativ0_.id as id1_39_, dividaativ0_.cnpj as cnpj2_39_, dividaativ0_.cnpj_cpf_devedor as cnpj_cpf3_39_, dividaativ0_.created_at as created_4_39_, dividaativ0_.data_consolidacao as data_con5_39_, dividaativ0_.devedor as devedor6_39_, dividaativ0_.emissao_doc_pagamento as emissao_7_39_, dividaativ0_.grupo as grupo8_39_, dividaativ0_.numero_inscricao as numero_i9_39_, dividaativ0_.numero_processo as numero_10_39_, dividaativ0_.situacao as situaca11_39_, dividaativ0_.tipo as tipo12_39_, dividaativ0_.updated_at as updated13_39_, dividaativ0_.valor_consolidado as valor_c14_39_ from divida_ativa_regularize dividaativ0_ where dividaativ0_.cnpj=? 11 353 12 66 3 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 7 185 16 200 15 0.00
graph/* BATCH */ delete from divida_ativa_regularize where id=? 3 353 4 110 6 0.00
graph SELECT d.key, d.cnpj_issuer as cnpjIssuer, d.cnpj_addressee as cnpjAddressee, d.type, d.data, d.info, d.imported_at as importedAt, d.name_file as nameFile, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d WHERE d.data_emissao BETWEEN (?) AND (?) AND d.cnpj_issuer = ? AND d.group_type = 'NFSE' AND d.info ->> 'status' = 'NORMAL' order by d.key desc limit ? 1 153 5 30 2 0.00
graphselect documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where documentnf0_.issuer_cpfcnpj=? and documentnf0_.addressee_cpfcnpj=? and documentnf0_.rps_number=? and documentnf0_.rps_serie=? and (documentnf0_.type in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) 1 3 173 288 100 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 3 49 74 37 0.00
graph SELECT d.data_emissao AS dataNfe, d.key AS chaveNfe, (items.prod ->> 'cprod') AS codigoProduto, (items.prod ->> 'xprod') AS nomeProduto, CAST((items.prod ->> 'vprod') AS NUMERIC) AS valorProduto, (items.prod ->> 'qcom') AS quantidadeProduto, (items.prod ->> 'cfop') AS cfop FROM document d, jsonb_to_recordset(d.data -> 'nfe' -> 'infNFe' -> 'det') AS items(prod jsonb) WHERE (items.prod ->> 'cfop') IN (?, ?) AND d.cnpj_issuer = ? AND d.type IN (?, ?, ?, ?, ?, ?, ?, ?) AND (d.data_emissao BETWEEN CAST(? as date) AND CAST(? as date)) 0 1 88 88 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 84 84 0 0.00
graphSET ROLE 'postgres' 0 25 2 4 0 0.00
graphselect documentwi0_.key as key3_4_, documentwi0_.data as data10_4_, documentwi0_.data_emissao as data_em11_4_, documentwi0_.type as type2_4_ from public.document documentwi0_ where documentwi0_.key=? and documentwi0_.type=? and (documentwi0_.data_emissao between ? and ?) 0 3 11 19 7 0.00
graph/*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 10 3 15 4 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 31 31 0 0.00
graphcreate 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)
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'::text)::double precision AS value,
doc.info ->> 'issuerName'::text AS issuer_name,
doc.info ->> 'addresseeName'::text AS addressee_name,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'ide'::text) ->>
'nnf'::text AS nfe_number,
COALESCE((SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN (item.historico ->> 'eventCode'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN (item.historico ->> 'eventCode'::text)::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text)::character varying
ELSE NULL::character varying
END AS case_result
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE ((item.historico ->> 'eventType'::text) = ANY
(ARRAY ['NFE_EVENT_MANIFESTATION'::text, 'NFE_EVENT'::text]))
AND (
CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN (item.historico ->> 'eventCode'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN (item.historico ->> 'eventCode'::text)::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text)::character varying
ELSE NULL::character varying
END::text = ANY
(ARRAY ['210200'::character varying::text, '210210'::character varying::text, '210220'::character varying::text, '210240'::character varying::text]))
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.manifestation) AS manifestation,
ds.cce_events,
ds.available_at,
COALESCE((SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text THEN (
((item.historico ->> 'eventAt'::text)::timestamp without time zone) AT TIME ZONE
'UTC'::text)
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text THEN (
((item.historico ->> 'eventAt'::text)::timestamp without time zone) AT TIME ZONE
'UTC'::text)
ELSE NULL::timestamp with time zone
END AS case_result
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE (item.historico ->> 'eventCode'::text) = '110111'::text
OR regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text, 'gi'::text) =
'110111'::text
ORDER BY (item.historico ->> 'eventAt'::text)
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)
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'::text)::double precision AS value,
doc.info ->> 'issuerName'::text AS issuer_name,
doc.info ->> 'addresseeName'::text AS addressee_name,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'ide'::text) ->>
'nnf'::text AS nfe_number,
COALESCE((SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN (item.historico ->> 'eventCode'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN (item.historico ->> 'eventCode'::text)::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text)::character varying
ELSE NULL::character varying
END AS case_result
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE ((item.historico ->> 'eventType'::text) = ANY
(ARRAY ['NFE_EVENT_MANIFESTATION'::text, 'NFE_EVENT'::text]))
AND (
CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN (item.historico ->> 'eventCode'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN (item.historico ->> 'eventCode'::text)::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text)::character varying
ELSE NULL::character varying
END::text = ANY
(ARRAY ['210200'::character varying::text, '210210'::character varying::text, '210220'::character varying::text, '210240'::character varying::text]))
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.manifestation) AS manifestation,
ds.cce_events,
ds.available_at,
COALESCE((SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text THEN (
((item.historico ->> 'eventAt'::text)::timestamp without time zone) AT TIME ZONE
'UTC'::text)
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text THEN (
((item.historico ->> 'eventAt'::text)::timestamp without time zone) AT TIME ZONE
'UTC'::text)
ELSE NULL::timestamp with time zone
END AS case_result
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE (item.historico ->> 'eventCode'::text) = '110111'::text
OR regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text, 'gi'::text) =
'110111'::text
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.canceled_at) AS canceled_at,
COALESCE((SELECT CASE
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text THEN '3'::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text THEN '3'::character varying
WHEN ds.status IS NOT NULL THEN ds.status
ELSE '1'::character varying
END AS case_result
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY (
CASE
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text
THEN '3'::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text THEN '3'::character varying
WHEN ds.status IS NOT NULL THEN ds.status
ELSE '1'::character varying
END) DESC
LIMIT 1), ds.status) AS status,
doc.name_file,
(SELECT json_agg(consulta.*) AS json_agg
FROM (SELECT (((d.data -> 'procEventoNFe'::text) -> 'evento'::text) -> 'infEvento'::text) ->>
'dhEvento'::text AS data_evento,
((((d.data -> 'procEventoNFe'::text) -> 'evento'::text) -> 'infEvento'::text) ->
'detEvento'::text) ->> 'xCorrecao'::text AS correcao_evento
FROM document d
WHERE doc.key::text = d.key::text
AND doc.cnpj_issuer::text = d.cnpj_issuer::text
AND ((((d.data -> 'procEventoNFe'::text) -> 'retEvento'::text) -> 'infEvento'::text) ->>
'tpEvento'::text) = '110110'::text
AND d.data_emissao = doc.data_emissao) consulta) AS carta_correcao,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'cobr'::text) ->
'dup'::text AS duplicatas,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'cobr'::text) -> 'fat'::text AS fatura,
doc.data,
(SELECT string_agg(DISTINCT (item.value -> 'prod'::text) ->> 'cfop'::text, ','::text) AS string_agg
FROM jsonb_array_elements(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'det'::text) item(value)) AS cfops,
(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)) AS jsonb_agg
FROM etiqueta_documento ed
JOIN etiqueta e ON e.id = ed.id_etiqueta_atual
WHERE ed.chave_nfe::text = doc.key::text) AS etiquetas,
(SELECT string_agg(DISTINCT nota.referencia ->> 'refNFe'::text, ', '::text) AS string_agg
FROM jsonb_array_elements((((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'ide'::text) ->
'nfref'::text) WITH ORDINALITY nota(referencia, ordinality)) AS notas_referencia
FROM document doc
JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text
WHERE doc.group_type::text = 'NFE'::text
 0 1 29 29 0 0.00
graphSELECT version() 0 11 2 7 1 0.00
graphcreate or replace view document_product_nfe_view
(info_adicionais_produto, numero_item, codigo_produto, cod_ean, nome_produto, codigo_ncm, ext_ipi,
cfop_produto, descricao_unidade_medida, quantidade_produto, valor_comercializacao_produto, valor_produto,
cean_tributavel, unidade_tributavel_produto, quantidade_tributavel_produto,
valor_unitario_tributavel_produto, valor_frete_produto, valor_seguro_produto, valor_desconto_produto,
valor_outras_despesas_produto, indicador_total, cest_produto, valor_total_tributacao,
origem_mercadoria_icms_00, cst_icms_00, modalidade_bc_icms_00, valor_bc_icms_00, aliquota_icms_00,
valor_icms_00, percentual_fcp_icms_00, valor_fcp_icms_00, origem_mercadoria_icms_10, cst_icms_10,
modalidade_bc_icms_10, valor_bc_icms_10, aliquota_icms_10, valor_icms_10, valor_bc_fcp_icms_10,
percentual_fcp_icms_10, valor_fcp_icms_10, modalidade_bc_icms_st_10, percentual_margem_icms_st_10,
percentual_reducao_bc_icms_st_10, valor_bc_icms_st_10, aliquota_icms_st_10, valor_icms_st_10,
valor_bc_fcp_icms_st_10, percentual_fcp_icms_st_10, valor_fcp_icms_st_10, origem_mercadoria_icms_20,
cst_icms_20, modalidade_bc_icms_20, percentual_reducao_bc_icms_20, valor_bc_icms_20, aliquota_icms_20,
valor_icms_20, valor_bc_fcp_icms_20, percentual_fcp_icms_20, valor_fcp_icms_20, valor_desonerado_icms_20,
motivo_desonerado_icms_20, origem_mercadoria_icms_30, cst_icms_30, modalidade_bc_icms_st_30,
percentual_margem_valor_icms_st_30, percentual_reducao_bc_icms_st_30, valor_bc_icms_st_30,
aliquota_icms_st_30, valor_icms_st_30, valor_bc_fcp_icms_st_30, percentual_fcp_icms_st_30,
valor_fcp_icms_st_30, valor_desonerado_icms_30, motivo_desonerado_icms_30, origem_mercadoria_icms_40,
cst_icms_40, valor_desonerado_icms_40, motivo_desonerado_icms_40, origem_mercadoria_icms_51, cst_icms_51,
modalidade_bc_icms_51, valor_bc_icms_51, aliquota_icms_51, valor_icms_51, percentual_fcp_icms_51,
valor_fcp_icms_51, percentual_reducao_bc_icms_51, valor_operacao_icms_51, percentual_diferimento_icms_51,
valor_diferido_icms_51, valor_bc_fcp_icms_51, origem_mercadoria_icms_60, cst_icms_60,
valor_bc_icms_st_retido_60, aliquota_suportada_icms_60, valor_icms_substituto_60, valor_icms_st_retido_60,
valor_bc_fcp_retido_st_60, percentual_fcp_retido_st_60, valor_fcp_retido_st_60,
percentual_reducao_bc_efetiva_60, valor_bc_efetiva_60, aliquota_icms_efetiva_60, valor_icms_efetiva_60,
origem_mercadoria_icms_70, cst_icms_70, modalidade_bc_icms_70, valor_bc_icms_70, aliquota_icms_70,
valor_icms_70, valor_bc_fcp_icms_70, percentual_fcp_icms_70, valor_fcp_icms_70, modalidade_bc_icms_st_70,
percentual_margem_icms_st_70, percentual_reducao_bc_icms_st_70, valor_bc_icms_st_70, aliquota_icms_st_70,
valor_icms_st_70, valor_bc_fcp_icms_st_70, percentual_fcp_icms_st_70, valor_fcp_icms_st_70,
percentual_reducao_bc_icms_70, valor_desonerado_icms_70, motivo_desonerado_icms_70,
origem_mercadoria_icms_90, cst_icms_90, modalidade_bc_icms_90, valor_bc_icms_90, aliquota_icms_90,
valor_icms_90, valor_bc_fcp_icms_90, percentual_fcp_icms_90, valor_fcp_icms_90, modalidade_bc_icms_st_90,
percentual_margem_icms_st_90, percentual_reducao_bc_icms_st_90, valor_bc_icms_st_90, aliquota_icms_st_90,
valor_icms_st_90, valor_bc_fcp_icms_st_90, percentual_fcp_icms_st_90, valor_fcp_icms_st_90,
percentual_reducao_bc_icms_90, valor_desonerado_icms_90, motivo_desonerado_icms_90,
origem_mercadoria_icms_grupo_de_partilha, cst_icms_grupo_de_partilha, modalidade_bc_icms_grupo_de_partilha,
valor_bc_icms_grupo_de_partilha, aliquota_icms_grupo_de_partilha, valor_icms_grupo_de_partilha,
percentual_reducao_bc_grupo_de_partilha, modalidade_bc_icms_st_grupo_de_partilha,
percentual_margem_icms_st_grupo_de_partilha, percentual_reducao_bc_icms_st_grupo_de_partilha,
valor_bc_icms_st_grupo_de_partilha, aliquota_icms_st_grupo_de_partilha, valor_icms_st_grupo_de_partilha,
percentual_bc_op_grupo_de_partilha, uf_icms_st_grupo_de_partilha, origem_mercadoria_icms_st, cst_icms_st,
valor_bc_icms_st_retido_st, aliquota_suportada_icms_st, valor_icms_substituto_st, valor_icms_st_retido_st,
valor_bc_fcp_retido_st, percentual_fcp_retido_st, valor_fcp_retido_st, valor_bc_fcp_destino_st,
valor_icms_st_destino_st, percentual_reducao_bc_efetiva_st, valor_bc_efetiva_st, aliquota_icmsefet_st,
valor_icms_efetiva_st, origem_mercadoria_icms_simples_nacional_101, cs_osn_simples_nacional_101,
aliquota_credito_simples_nacional_101, valor_credito_icms_simples_naci
Details

create or replace view document_product_nfe_view
(info_adicionais_produto, numero_item, codigo_produto, cod_ean, nome_produto, codigo_ncm, ext_ipi,
cfop_produto, descricao_unidade_medida, quantidade_produto, valor_comercializacao_produto, valor_produto,
cean_tributavel, unidade_tributavel_produto, quantidade_tributavel_produto,
valor_unitario_tributavel_produto, valor_frete_produto, valor_seguro_produto, valor_desconto_produto,
valor_outras_despesas_produto, indicador_total, cest_produto, valor_total_tributacao,
origem_mercadoria_icms_00, cst_icms_00, modalidade_bc_icms_00, valor_bc_icms_00, aliquota_icms_00,
valor_icms_00, percentual_fcp_icms_00, valor_fcp_icms_00, origem_mercadoria_icms_10, cst_icms_10,
modalidade_bc_icms_10, valor_bc_icms_10, aliquota_icms_10, valor_icms_10, valor_bc_fcp_icms_10,
percentual_fcp_icms_10, valor_fcp_icms_10, modalidade_bc_icms_st_10, percentual_margem_icms_st_10,
percentual_reducao_bc_icms_st_10, valor_bc_icms_st_10, aliquota_icms_st_10, valor_icms_st_10,
valor_bc_fcp_icms_st_10, percentual_fcp_icms_st_10, valor_fcp_icms_st_10, origem_mercadoria_icms_20,
cst_icms_20, modalidade_bc_icms_20, percentual_reducao_bc_icms_20, valor_bc_icms_20, aliquota_icms_20,
valor_icms_20, valor_bc_fcp_icms_20, percentual_fcp_icms_20, valor_fcp_icms_20, valor_desonerado_icms_20,
motivo_desonerado_icms_20, origem_mercadoria_icms_30, cst_icms_30, modalidade_bc_icms_st_30,
percentual_margem_valor_icms_st_30, percentual_reducao_bc_icms_st_30, valor_bc_icms_st_30,
aliquota_icms_st_30, valor_icms_st_30, valor_bc_fcp_icms_st_30, percentual_fcp_icms_st_30,
valor_fcp_icms_st_30, valor_desonerado_icms_30, motivo_desonerado_icms_30, origem_mercadoria_icms_40,
cst_icms_40, valor_desonerado_icms_40, motivo_desonerado_icms_40, origem_mercadoria_icms_51, cst_icms_51,
modalidade_bc_icms_51, valor_bc_icms_51, aliquota_icms_51, valor_icms_51, percentual_fcp_icms_51,
valor_fcp_icms_51, percentual_reducao_bc_icms_51, valor_operacao_icms_51, percentual_diferimento_icms_51,
valor_diferido_icms_51, valor_bc_fcp_icms_51, origem_mercadoria_icms_60, cst_icms_60,
valor_bc_icms_st_retido_60, aliquota_suportada_icms_60, valor_icms_substituto_60, valor_icms_st_retido_60,
valor_bc_fcp_retido_st_60, percentual_fcp_retido_st_60, valor_fcp_retido_st_60,
percentual_reducao_bc_efetiva_60, valor_bc_efetiva_60, aliquota_icms_efetiva_60, valor_icms_efetiva_60,
origem_mercadoria_icms_70, cst_icms_70, modalidade_bc_icms_70, valor_bc_icms_70, aliquota_icms_70,
valor_icms_70, valor_bc_fcp_icms_70, percentual_fcp_icms_70, valor_fcp_icms_70, modalidade_bc_icms_st_70,
percentual_margem_icms_st_70, percentual_reducao_bc_icms_st_70, valor_bc_icms_st_70, aliquota_icms_st_70,
valor_icms_st_70, valor_bc_fcp_icms_st_70, percentual_fcp_icms_st_70, valor_fcp_icms_st_70,
percentual_reducao_bc_icms_70, valor_desonerado_icms_70, motivo_desonerado_icms_70,
origem_mercadoria_icms_90, cst_icms_90, modalidade_bc_icms_90, valor_bc_icms_90, aliquota_icms_90,
valor_icms_90, valor_bc_fcp_icms_90, percentual_fcp_icms_90, valor_fcp_icms_90, modalidade_bc_icms_st_90,
percentual_margem_icms_st_90, percentual_reducao_bc_icms_st_90, valor_bc_icms_st_90, aliquota_icms_st_90,
valor_icms_st_90, valor_bc_fcp_icms_st_90, percentual_fcp_icms_st_90, valor_fcp_icms_st_90,
percentual_reducao_bc_icms_90, valor_desonerado_icms_90, motivo_desonerado_icms_90,
origem_mercadoria_icms_grupo_de_partilha, cst_icms_grupo_de_partilha, modalidade_bc_icms_grupo_de_partilha,
valor_bc_icms_grupo_de_partilha, aliquota_icms_grupo_de_partilha, valor_icms_grupo_de_partilha,
percentual_reducao_bc_grupo_de_partilha, modalidade_bc_icms_st_grupo_de_partilha,
percentual_margem_icms_st_grupo_de_partilha, percentual_reducao_bc_icms_st_grupo_de_partilha,
valor_bc_icms_st_grupo_de_partilha, aliquota_icms_st_grupo_de_partilha, valor_icms_st_grupo_de_partilha,
percentual_bc_op_grupo_de_partilha, uf_icms_st_grupo_de_partilha, origem_mercadoria_icms_st, cst_icms_st,
valor_bc_icms_st_retido_st, aliquota_suportada_icms_st, valor_icms_substituto_st, valor_icms_st_retido_st,
valor_bc_fcp_retido_st, percentual_fcp_retido_st, valor_fcp_retido_st, valor_bc_fcp_destino_st,
valor_icms_st_destino_st, percentual_reducao_bc_efetiva_st, valor_bc_efetiva_st, aliquota_icmsefet_st,
valor_icms_efetiva_st, origem_mercadoria_icms_simples_nacional_101, cs_osn_simples_nacional_101,
aliquota_credito_simples_nacional_101, valor_credito_icms_simples_nacional_101,
origem_mercadoria_icms_simples_nacional_102, cs_osn_simples_nacional_102, cs_osn_simples_nacional_103,
origem_mercadoria_icms_simples_nacional_201, cs_osn_simples_nacional_201,
aliquota_credito_simples_nacional_201, valor_credito_icms_simples_nacional_201,
modalidade_bc_icms_st_simples_nacional_201, percentual_margem_icms_st_simples_nacional_201,
percentual_reducao_bc_icms_st_simples_nacional_201, valor_bc_icms_st_simples_nacional_201,
aliquota_icms_st_simples_nacional_201, valor_icms_st_simples_nacional_201,
valor_bc_fcp_icms_st_simples_nacional_201, percentual_fcp_icms_st_simples_nacional_201,
valor_fcp_icms_st_simples_nacional_201, origem_mercadoria_icms_simples_nacional_202,
cs_osn_simples_nacional_202, modalidade_bc_icms_st_simples_nacional_202,
percentual_margem_icms_st_simples_nacional_202, percentual_reducao_bc_icms_st_simples_nacional_202,
valor_bc_icms_st_simples_nacional_202, aliquota_icms_st_simples_nacional_202,
valor_icms_st_simples_nacional_202, valor_bc_fcp_icms_st_simples_nacional_202,
percentual_fcp_icms_st_simples_nacional_202, valor_fcp_icms_st_simples_nacional_202,
cs_osn_simples_nacional_203, cs_osn_simples_nacional_300, cs_osn_simples_nacional_400,
origem_mercadoria_icms_simples_nacional_500, cs_osn_simples_nacional_500,
valor_bc_icms_st_retido_simples_nacional_500, aliquota_suportada_icms_simples_nacional_500,
valor_icms_substituto_simples_nacional_500, valor_icms_st_retido_simples_nacional_500,
valor_bc_fcp_retido_st_simples_nacional_500, percentual_fcp_retido_st_simples_nacional_500,
valor_fcp_retido_st_simples_nacional_500, percentual_reducao_bc_efetiva_simples_nacional_500,
valor_bc_efetiva_simples_nacional_500, aliquota_icms_efetiva_simples_nacional_500,
valor_icms_efetiva_simples_nacional_500, origem_mercadoria_icms_simples_nacional_900,
cs_osn_simples_nacional_900, modalidade_bc_icms_st_simples_nacional_900,
percentual_margem_icms_st_simples_nacional_900, percentual_reducao_bc_icms_st_simples_nacional_900,
valor_bc_icms_st_simples_nacional_900, aliquota_icms_st_simples_nacional_900,
valor_icms_st_simples_nacional_900, valor_bc_fcp_icms_st_simples_nacional_900,
percentual_fcp_icms_st_simples_nacional_900, valor_fcp_icms_st_simples_nacional_900,
modalidade_bc_icms_simples_nacional_900, valor_bc_icms_simples_nacional_900,
aliquota_icms_simples_nacional_900, valor_icms_simples_nacional_900,
percentual_reducao_bc_simples_nacional_900, aliquota_credito_simples_nacional_900,
valor_credito_icms_simples_nacional_900, cnpj_produtor_ipi, codigo_selo_ipi, quantidade_selo_ipi,
codigo_enquadramento_ipi, cst_ipi_tributado, valor_bc_ipi_trib, aliquota_ipi_trib,
quantidade_total_ipi_trib, valor_unidade_tributavel_ipi_trib, valor_ipi, cst_ipi_int, cst_pis_aliquota,
valor_bc_pis_aliquota, aliquota_pis_aliquota, valor_pis_aliquota, cst_pis_tributado_por_quantidade,
quantidade_vendida_pis_tributado_por_quantidade, aliquota_pis_tributado_por_quantidade,
valor_pis_tributado_por_quantidade, cst_pis_nao_ttributado, cst_pis_outras_operacoes,
valor_bc_pis_outras_operacoes, aliquota_pis_outras_operacoes, cst_cofins_aliquota,
valor_bc_cofins_aliquota, aliquota_cofins_aliquota, valor_cofins_aliquota,
cst_cofins_tributado_por_quantidade, quantidade_vendida_cofins_tributado_por_quantidade,
aliquota_cofins_tributado_por_quantidade, valor_cofins_tributado_por_quantidade, cst_cofins_nao_ttributado,
cst_cofins_outras_operacoes, valor_bc_cofins_outras_operacoes, aliquota_cofins_outras_operacoes,
quantidade_vendida_cofins_outras_operacoes, valor_aliquota_cofins_outras_operacoes,
valor_cofins_outras_operacoes, valor_bc_icms_uf_destinatario, valor_bc_fcp_icms_uf_destinatario,
aliquota_icms_fcp_uf_destinatario, aliquota_icms_uf_destinatario,
aliquota_interestadual_icms_uf_destinatario, aliquota_provisoria_interestadual_part_icms_uf_destinatario,
valor_icms_fcp_uf_destinatario, valor_icms_interestadual_uf_dest, valor_icms_interestadual_uf_remetente,
valor_bc_imposto_importacao, valor_despesas_aduaneiras_imposto_importacao, valor_imposto_importacao,
valor_iof_imposto_importacao, percentual_mercadoria_devolvida, v_ipi_devolvido, chave, versao_nota, cnpj,
cnpj_emissor, cnpj_destinatario, cnpj_transportador, data_emissao, nsu, protocolo, valor, nome_emissor,
nome_destinatario, numero_nfe, manifestacao, cce, disponivel_em, cancelado_em, status, nome_arquivo,
canhoto_id, uf_emitente, uf_destinatario)
as
SELECT produtos.produto ->> 'infAdProd'::text AS info_adicionais_produto,
COALESCE(produtos.produto ->> 'nitem'::text, produtos.produto ->>
'nItem'::text)::integer AS numero_item,
(produtos.produto -> 'prod'::text) ->> 'cprod'::text AS codigo_produto,
(produtos.produto -> 'prod'::text) ->> 'cean'::text AS cod_ean,
(produtos.produto -> 'prod'::text) ->> 'xprod'::text AS nome_produto,
((produtos.produto -> 'prod'::text) ->> 'ncm'::text)::integer AS codigo_ncm,
(produtos.produto -> 'prod'::text) ->> 'extipi'::text AS ext_ipi,
((produtos.produto -> 'prod'::text) ->> 'cfop'::text)::integer AS cfop_produto,
(produtos.produto -> 'prod'::text) ->> 'ucom'::text AS descricao_unidade_medida,
((produtos.produto -> 'prod'::text) ->> 'qcom'::text)::double precision AS quantidade_produto,
((produtos.produto -> 'prod'::text) ->> 'vunCom'::text)::double precision AS valor_comercializacao_produto,
((produtos.produto -> 'prod'::text) ->> 'vprod'::text)::double precision AS valor_produto,
(produtos.produto -> 'prod'::text) ->> 'ceanTrib'::text AS cean_tributavel,
(produtos.produto -> 'prod'::text) ->> 'utrib'::text AS unidade_tributavel_produto,
((produtos.produto -> 'prod'::text) ->> 'qtrib'::text)::double precision AS quantidade_tributavel_produto,
((produtos.produto -> 'prod'::text) ->> 'vunTrib'::text)::double precision AS valor_unitario_tributavel_produto,
((produtos.produto -> 'prod'::text) ->> 'vfrete'::text)::double precision AS valor_frete_produto,
((produtos.produto -> 'prod'::text) ->> 'vSeg'::text)::double precision AS valor_seguro_produto,
((produtos.produto -> 'prod'::text) ->> 'vdesc'::text)::double precision AS valor_desconto_produto,
((produtos.produto -> 'prod'::text) ->> 'vOutro'::text)::double precision AS valor_outras_despesas_produto,
((produtos.produto -> 'prod'::text) ->> 'indTot'::text)::integer AS indicador_total,
((produtos.produto -> 'prod'::text) ->> 'cest'::text)::integer AS cest_produto,
((produtos.produto -> 'imposto'::text) ->> 'vTotTrib'::text)::double precision AS valor_total_tributacao,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'orig'::text AS origem_mercadoria_icms_00,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'cst'::text AS cst_icms_00,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_00,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_00,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'picms'::text)::double precision AS aliquota_icms_00,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'vicms'::text)::double precision AS valor_icms_00,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'pfcp'::text)::double precision AS percentual_fcp_icms_00,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms00'::text) ->>
'vfcp'::text)::double precision AS valor_fcp_icms_00,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'orig'::text AS origem_mercadoria_icms_10,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'cst'::text AS cst_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'picms'::text)::double precision AS aliquota_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vicms'::text)::double precision AS valor_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vbcfcp'::text)::double precision AS valor_bc_fcp_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'pfcp'::text)::double precision AS percentual_fcp_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vfcp'::text)::double precision AS valor_fcp_icms_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'modBCST'::text)::smallint AS modalidade_bc_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_10,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms10'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_10,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'orig'::text AS origem_mercadoria_icms_20,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'cst'::text AS cst_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'pRedBC'::text)::double precision AS percentual_reducao_bc_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'picms'::text)::double precision AS aliquota_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'vicms'::text)::double precision AS valor_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'vbcfcp'::text)::double precision AS valor_bc_fcp_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'pfcp'::text)::double precision AS percentual_fcp_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'vfcp'::text)::double precision AS valor_fcp_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'vicmsDeson'::text)::double precision AS valor_desonerado_icms_20,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms20'::text) ->>
'motDesICMS'::text)::integer AS motivo_desonerado_icms_20,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'orig'::text AS origem_mercadoria_icms_30,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'cst'::text AS cst_icms_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'modBCST'::text)::smallint AS modalidade_bc_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_valor_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'vbcST'::text)::double precision AS valor_bc_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'vicmsDeson'::text)::double precision AS valor_desonerado_icms_30,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms30'::text) ->>
'motDesICMS'::text)::integer AS motivo_desonerado_icms_30,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms40'::text) ->>
'orig'::text AS origem_mercadoria_icms_40,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms40'::text) ->>
'cst'::text AS cst_icms_40,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms40'::text) ->>
'vicmsDeson'::text)::double precision AS valor_desonerado_icms_40,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms40'::text) ->>
'motDesICMS'::text)::integer AS motivo_desonerado_icms_40,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'orig'::text AS origem_mercadoria_icms_51,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'cst'::text AS cst_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'picms'::text)::double precision AS aliquota_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'vicms'::text)::double precision AS valor_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'pfcp'::text)::double precision AS percentual_fcp_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'vfcp'::text)::double precision AS valor_fcp_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'pRedBC'::text)::double precision AS percentual_reducao_bc_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'vicmsOp'::text)::double precision AS valor_operacao_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'pDif'::text)::double precision AS percentual_diferimento_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'vicmsDif'::text)::double precision AS valor_diferido_icms_51,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms51'::text) ->>
'vbcfcp'::text)::double precision AS valor_bc_fcp_icms_51,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'orig'::text AS origem_mercadoria_icms_60,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'cst'::text AS cst_icms_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vBCSTRet'::text)::smallint AS valor_bc_icms_st_retido_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'pst'::text)::double precision AS aliquota_suportada_icms_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vicmsSubstituto'::text)::double precision AS valor_icms_substituto_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vicmsstRet'::text)::double precision AS valor_icms_st_retido_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vbcfcpstRet'::text)::double precision AS valor_bc_fcp_retido_st_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'pfcpstRet'::text)::double precision AS percentual_fcp_retido_st_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vfcpstRet'::text)::double precision AS valor_fcp_retido_st_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'pRedBCEfet'::text)::double precision AS percentual_reducao_bc_efetiva_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vbcEfet'::text)::double precision AS valor_bc_efetiva_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'picmsEfet'::text)::double precision AS aliquota_icms_efetiva_60,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms60'::text) ->>
'vicmsEfet'::text)::double precision AS valor_icms_efetiva_60,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'orig'::text AS origem_mercadoria_icms_70,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'cst'::text AS cst_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'picms'::text)::double precision AS aliquota_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vicms'::text)::double precision AS valor_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vbcfcp'::text)::double precision AS valor_bc_fcp_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'pfcp'::text)::double precision AS percentual_fcp_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vfcp'::text)::double precision AS valor_fcp_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'modBCST'::text)::smallint AS modalidade_bc_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'pRedBC'::text)::double precision AS percentual_reducao_bc_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'vicmsDeson'::text)::double precision AS valor_desonerado_icms_70,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms70'::text) ->>
'motDesICMS'::text)::integer AS motivo_desonerado_icms_70,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'orig'::text AS origem_mercadoria_icms_90,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'cst'::text AS cst_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'picms'::text)::double precision AS aliquota_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vicms'::text)::double precision AS valor_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vbcfcp'::text)::double precision AS valor_bc_fcp_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'pfcp'::text)::double precision AS percentual_fcp_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vfcp'::text)::double precision AS valor_fcp_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'modBCST'::text)::smallint AS modalidade_bc_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'pRedBC'::text)::double precision AS percentual_reducao_bc_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'vicmsDeson'::text)::double precision AS valor_desonerado_icms_90,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icms90'::text) ->>
'motDesICMS'::text)::integer AS motivo_desonerado_icms_90,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'orig'::text AS origem_mercadoria_icms_grupo_de_partilha,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'cst'::text AS cst_icms_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'modBC'::text)::smallint AS modalidade_bc_icms_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'picms'::text)::double precision AS aliquota_icms_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'vicms'::text)::double precision AS valor_icms_grupo_de_partilha,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'pRedBC'::text AS percentual_reducao_bc_grupo_de_partilha,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'modBCST'::text AS modalidade_bc_icms_st_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_grupo_de_partilha,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'pbcOp'::text)::double precision AS percentual_bc_op_grupo_de_partilha,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsPart'::text) ->>
'ufst'::text AS uf_icms_st_grupo_de_partilha,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'orig'::text AS origem_mercadoria_icms_st,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'cst'::text AS cst_icms_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vbcstRet'::text)::double precision AS valor_bc_icms_st_retido_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'pst'::text)::double precision AS aliquota_suportada_icms_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vicmsSubstituto'::text)::double precision AS valor_icms_substituto_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vicmsstRet'::text)::double precision AS valor_icms_st_retido_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vbcfcpstRet'::text)::double precision AS valor_bc_fcp_retido_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'pfcpstRet'::text)::double precision AS percentual_fcp_retido_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vfcpstRet'::text)::double precision AS valor_fcp_retido_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vbcstDest'::text)::double precision AS valor_bc_fcp_destino_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vicmsstDest'::text)::double precision AS valor_icms_st_destino_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'pRedBCEfet'::text)::double precision AS percentual_reducao_bc_efetiva_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vbcEfet'::text)::double precision AS valor_bc_efetiva_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'picmsEfet'::text)::double precision AS aliquota_icmsefet_st,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmsst'::text) ->>
'vicmsEfet'::text)::double precision AS valor_icms_efetiva_st,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn101'::text) ->>
'orig'::text AS origem_mercadoria_icms_simples_nacional_101,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn101'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_101,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn101'::text) ->>
'pCredSN'::text)::double precision AS aliquota_credito_simples_nacional_101,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn101'::text) ->>
'vCredICMSSN'::text)::double precision AS valor_credito_icms_simples_nacional_101,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn102'::text) ->>
'orig'::text AS origem_mercadoria_icms_simples_nacional_102,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn102'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_102,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn103'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_103,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'orig'::text AS origem_mercadoria_icms_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'pCredSN'::text)::double precision AS aliquota_credito_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'vCredICMSSN'::text)::double precision AS valor_credito_icms_simples_nacional_201,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'modBCST'::text AS modalidade_bc_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_simples_nacional_201,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn201'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_simples_nacional_201,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'orig'::text AS origem_mercadoria_icms_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_202,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'modBCST'::text AS modalidade_bc_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn202'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_simples_nacional_202,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn203'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_203,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn300'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_300,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn400'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_400,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'orig'::text AS origem_mercadoria_icms_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vbcstRet'::text)::double precision AS valor_bc_icms_st_retido_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'pst'::text)::double precision AS aliquota_suportada_icms_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vicmsSubstituto'::text)::double precision AS valor_icms_substituto_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vicmsstRet'::text)::double precision AS valor_icms_st_retido_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vbcfcpstRet'::text)::double precision AS valor_bc_fcp_retido_st_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'pfcpstRet'::text)::double precision AS percentual_fcp_retido_st_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vfcpstRet'::text)::double precision AS valor_fcp_retido_st_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'pRedBCEfet'::text)::double precision AS percentual_reducao_bc_efetiva_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vbcEfet'::text)::double precision AS valor_bc_efetiva_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'picmsEfet'::text)::double precision AS aliquota_icms_efetiva_simples_nacional_500,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn500'::text) ->>
'vicmsEfet'::text)::double precision AS valor_icms_efetiva_simples_nacional_500,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'orig'::text AS origem_mercadoria_icms_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'csosn'::text)::integer AS cs_osn_simples_nacional_900,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'modBCST'::text AS modalidade_bc_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'pmvast'::text)::double precision AS percentual_margem_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'pRedBCST'::text)::double precision AS percentual_reducao_bc_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vbcst'::text)::double precision AS valor_bc_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'picmsst'::text)::double precision AS aliquota_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vicmsst'::text)::double precision AS valor_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vbcfcpst'::text)::double precision AS valor_bc_fcp_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'pfcpst'::text)::double precision AS percentual_fcp_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vfcpst'::text)::double precision AS valor_fcp_icms_st_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'modBC'::text)::integer AS modalidade_bc_icms_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vbc'::text)::double precision AS valor_bc_icms_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'picms'::text)::double precision AS aliquota_icms_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vicms'::text)::double precision AS valor_icms_simples_nacional_900,
(((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'pRedBC'::text AS percentual_reducao_bc_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'pCredSN'::text)::double precision AS aliquota_credito_simples_nacional_900,
((((produtos.produto -> 'imposto'::text) -> 'icms'::text) -> 'icmssn900'::text) ->>
'vCredICMSSN'::text)::double precision AS valor_credito_icms_simples_nacional_900,
((produtos.produto -> 'imposto'::text) -> 'ipi'::text) ->>
'cnpjProd'::text AS cnpj_produtor_ipi,
((produtos.produto -> 'imposto'::text) -> 'ipi'::text) ->>
'cSelo'::text AS codigo_selo_ipi,
((produtos.produto -> 'imposto'::text) -> 'ipi'::text) ->>
'qSelo'::text AS quantidade_selo_ipi,
((produtos.produto -> 'imposto'::text) -> 'ipi'::text) ->>
'cEnq'::text AS codigo_enquadramento_ipi,
(((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipiTrib'::text) ->>
'cst'::text AS cst_ipi_tributado,
((((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipiTrib'::text) ->>
'vbc'::text)::double precision AS valor_bc_ipi_trib,
((((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipiTrib'::text) ->>
'pipi'::text)::double precision AS aliquota_ipi_trib,
((((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipiTrib'::text) ->>
'qUnid'::text)::double precision AS quantidade_total_ipi_trib,
((((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipiTrib'::text) ->>
'vUnid'::text)::double precision AS valor_unidade_tributavel_ipi_trib,
((((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipiTrib'::text) ->>
'vipi'::text)::double precision AS valor_ipi,
(((produtos.produto -> 'imposto'::text) -> 'ipi'::text) -> 'ipint'::text) ->>
'cst'::text AS cst_ipi_int,
(((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisAliq'::text) ->>
'cst'::text AS cst_pis_aliquota,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisAliq'::text) ->>
'vbc'::text)::double precision AS valor_bc_pis_aliquota,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisAliq'::text) ->>
'ppis'::text)::double precision AS aliquota_pis_aliquota,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisAliq'::text) ->>
'vpis'::text)::double precision AS valor_pis_aliquota,
(((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisQtde'::text) ->>
'cst'::text AS cst_pis_tributado_por_quantidade,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisQtde'::text) ->>
'qbcProd'::text)::double precision AS quantidade_vendida_pis_tributado_por_quantidade,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisQtde'::text) ->>
'vAliqProd'::text)::double precision AS aliquota_pis_tributado_por_quantidade,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisQtde'::text) ->>
'vpis'::text)::double precision AS valor_pis_tributado_por_quantidade,
(((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisnt'::text) ->>
'cst'::text AS cst_pis_nao_ttributado,
(((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisOutr'::text) ->>
'cst'::text AS cst_pis_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisOutr'::text) ->>
'vbc'::text)::double precision AS valor_bc_pis_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'pis'::text) -> 'pisOutr'::text) ->>
'ppis'::text)::double precision AS aliquota_pis_outras_operacoes,
(((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsAliq'::text) ->>
'cst'::text AS cst_cofins_aliquota,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsAliq'::text) ->>
'vbc'::text)::double precision AS valor_bc_cofins_aliquota,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsAliq'::text) ->>
'pcofins'::text)::double precision AS aliquota_cofins_aliquota,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsAliq'::text) ->>
'vcofins'::text)::double precision AS valor_cofins_aliquota,
(((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsQtde'::text) ->>
'cst'::text AS cst_cofins_tributado_por_quantidade,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsQtde'::text) ->>
'qbcProd'::text)::double precision AS quantidade_vendida_cofins_tributado_por_quantidade,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsQtde'::text) ->>
'vAliqProd'::text)::double precision AS aliquota_cofins_tributado_por_quantidade,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsQtde'::text) ->>
'vcofins'::text)::double precision AS valor_cofins_tributado_por_quantidade,
(((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsnt'::text) ->>
'cst'::text AS cst_cofins_nao_ttributado,
(((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsOutr'::text) ->>
'cst'::text AS cst_cofins_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsOutr'::text) ->>
'vbc'::text)::double precision AS valor_bc_cofins_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsOutr'::text) ->>
'pcofins'::text)::double precision AS aliquota_cofins_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsOutr'::text) ->>
'qbcProd'::text)::double precision AS quantidade_vendida_cofins_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsOutr'::text) ->>
'vAliqProd'::text)::double precision AS valor_aliquota_cofins_outras_operacoes,
((((produtos.produto -> 'imposto'::text) -> 'cofins'::text) -> 'cofinsOutr'::text) ->>
'vcofins'::text)::double precision AS valor_cofins_outras_operacoes,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'vbcufDest'::text)::double precision AS valor_bc_icms_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'vbcfcpufDest'::text)::double precision AS valor_bc_fcp_icms_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'pfcpufDest'::text)::double precision AS aliquota_icms_fcp_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'picmsufDest'::text)::double precision AS aliquota_icms_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'picmsInter'::text)::double precision AS aliquota_interestadual_icms_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'picmsInterPart'::text)::double precision AS aliquota_provisoria_interestadual_part_icms_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'vfcpufDest'::text)::double precision AS valor_icms_fcp_uf_destinatario,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'vicmsufDest'::text)::double precision AS valor_icms_interestadual_uf_dest,
(((produtos.produto -> 'imposto'::text) -> 'icmsUfDest'::text) ->>
'vicmsufRemet'::text)::double precision AS valor_icms_interestadual_uf_remetente,
(((produtos.produto -> 'imposto'::text) -> 'ii'::text) ->> 'vbc'::text)::double precision AS valor_bc_imposto_importacao,
(((produtos.produto -> 'imposto'::text) -> 'ii'::text) ->>
'vDespAdu'::text)::double precision AS valor_despesas_aduaneiras_imposto_importacao,
(((produtos.produto -> 'imposto'::text) -> 'ii'::text) ->> 'vii'::text)::double precision AS valor_imposto_importacao,
(((produtos.produto -> 'imposto'::text) -> 'ii'::text) ->>
'viof'::text)::double precision AS valor_iof_imposto_importacao,
((produtos.produto -> 'impostoDevol'::text) ->> 'pDevol'::text)::double precision AS percentual_mercadoria_devolvida,
(((produtos.produto -> 'impostoDevol'::text) -> 'ipi'::text) ->>
'vIPIDevol'::text)::double precision AS v_ipi_devolvido,
doc.key AS chave,
doc.type AS versao_nota,
doc.cnpj,
doc.cnpj_issuer AS cnpj_emissor,
doc.cnpj_addressee AS cnpj_destinatario,
doc.cnpj_carrier AS cnpj_transportador,
doc.data_emissao,
doc.nsu,
doc.protocol AS protocolo,
(doc.info ->> 'value'::text)::double precision AS valor,
doc.info ->> 'issuerName'::text AS nome_emissor,
doc.info ->> 'addresseeName'::text AS nome_destinatario,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'ide'::text) ->>
'nnf'::text AS numero_nfe,
ds.manifestation AS manifestacao,
ds.cce_events AS cce,
ds.available_at AS disponivel_em,
ds.canceled_at AS cancelado_em,
ds.status,
doc.name_file AS nome_arquivo,
cn.canhoto_importacao_id AS canhoto_id,
((((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'emit'::text) -> 'enderEmit'::text) ->>
'uf'::text AS uf_emitente,
((((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'dest'::text) -> 'enderDest'::text) ->>
'uf'::text AS uf_destinatario
FROM document doc
LEFT JOIN canhoto_nota cn
ON doc.key::text = cn.documento_chave::text AND doc.cnpj_issuer::text = cn.empresa_cnpj::text
JOIN document_status ds ON doc.key::text = ds.key::text AND doc.cnpj_issuer::text = ds.cnpj_issuer::text,
LATERAL jsonb_array_elements(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'det'::text) WITH ORDINALITY produtos(produto, ordinality)
WHERE doc.type::text = ANY
(ARRAY ['NFE_2_0'::character varying::text, 'NFE_4_0'::character varying::text, 'NFE_3_1'::character varying::text])
 0 1 26 26 0 0.00
graphSELECT 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 11 2 3 0 0.00
graphselect documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.key in (?)) and (documentct0_.type in (? , ?)) and documentct0_.addressee_cnpj_cpf=? limit ? 0 1 23 23 0 0.00
graphselect key, type, cast(data->'header'->>'version' as text) as version, cast(data->'header'->>'endsDate' as date) as periodo, cast(data->'header'->>'endsDate' as date) as periodoFinal, cast(data->'header'->>'startsDate' as date) as periodoInicial, cast(data->'header'->>'ecdType' as text) as ecdType, cast(data->'header'->>'finalType' as text) as purpose, name_file as nameFile, cnpj, cast(data->'header'->>'deliveryDate' as timestamp) as deliveryDate, info->>'originalFileName' as fileNameOriginal, inscricao_estadual as inscricaoEstadual from document where key = ? and type like 'SPED%' and data_emissao between ? and ? 0 4 5 8 2 0.00
graphDROP VIEW IF EXISTS public.document_nfe_view 0 1 19 19 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 2 9 13 4 0.00
graphDROP view IF EXISTS public.document_product_nfe_view 0 1 19 19 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 3 6 7 1 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 15 15 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 14 14 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 14 14 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 13 13 0 0.00
graphSELECT pg_try_advisory_lock(77433833903597) 0 5 2 3 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 2 5 6 0 0.00
graphSELECT pg_advisory_unlock(77433833903597) 0 5 2 3 0 0.00
graphSELECT set_config('search_path', ?, false) 0 5 2 2 0 0.00
graphselect documentwi0_.key as key3_4_, documentwi0_.data as data10_4_, documentwi0_.data_emissao as data_em11_4_, documentwi0_.type as type2_4_ from public.document documentwi0_ where (documentwi0_.key in (?)) and (documentwi0_.type in (? , ?)) and (documentwi0_.data_emissao between ? and ?) 0 1 10 10 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 10 10 0 0.00
graphSELECT COUNT(*) FROM pg_namespace WHERE nspname=? 0 5 2 3 0 0.00
graphINSERT INTO "public"."flyway_schema_history" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 0 4 2 3 0 0.00
graphSHOW search_path 0 4 2 3 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 2 4 5 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 8 8 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 8 8 0 0.00
graphSELECT current_schema 0 3 2 3 0 0.00
graphCREATE 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
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 0.00
graphWITH consultaNfeCfe AS ( SELECT 'NFE_CFE_EMITIDA' AS notaEmitida FROM document d WHERE d.type IN ('NFE_3_1', 'NFE_4_0', 'CFE_0_6', 'CFE_00_6', 'CFE_0_7', 'CFE_00_7', 'CFE_0_8') AND d.cnpj_issuer = ? AND d.data_emissao BETWEEN ? AND ? LIMIT 1 ), consultaCte AS ( SELECT 'CTE_EMITIDA' AS notaEmitida FROM document d WHERE d.type = 'CTE' AND d.cnpj_issuer = ? AND d.data_emissao BETWEEN ? AND ? LIMIT 1 ) SELECT notaEmitida FROM consultaNfeCfe UNION ALL SELECT notaEmitida FROM consultaCte 0 1 6 6 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 5 5 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 5 5 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 5 5 0 0.00
graphcreate 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)
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'::text)::double precision AS value,
doc.info ->> 'issuerName'::text AS issuer_name,
doc.info ->> 'addresseeName'::text AS addressee_name,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'ide'::text) ->>
'nnf'::text AS nfe_number,
COALESCE((SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN (item.historico ->> 'eventCode'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN (item.historico ->> 'eventCode'::text)::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text)::character varying
ELSE NULL::character varying
END AS "case"
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE (item.historico ->> 'eventType'::text) = ANY
(ARRAY ['NFE_EVENT_MANIFESTATION'::text, 'NFE_EVENT'::text])
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.manifestation) AS manifestation,
ds.cce_events,
ds.available_at,
COALESCE((SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text
THEN ((item.historico ->> 'eventAt'::text)::timestamp without time zone)::timestamp with time zone
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text
THEN ((item.historico ->> 'eventAt'::text)::timestamp without time zone)::timestamp with time zone
ELSE NULL::timestamp with time zone
END AS "case"
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE (item.historico ->> 'eventCode'::text) = '110111'::text
OR regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text, 'gi'::text) =
'110111'::text
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.canceled_at) AS canceled_at,
COALESCE((SELECT CASE
WHEN ds.status IS NOT NULL THEN ds.status
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text THEN '3'::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text THEN '3'::character varying
ELSE '1'::character varying
END AS "case"
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1), ds.status) AS status,
doc.name_file,
(SELECT json_agg(consulta.*) AS json_agg
FROM (SELECT (((d.data -> 'procEventoNFe'::text) -> 'evento'::text) -> '
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)
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'::text)::double precision AS value,
doc.info ->> 'issuerName'::text AS issuer_name,
doc.info ->> 'addresseeName'::text AS addressee_name,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'ide'::text) ->>
'nnf'::text AS nfe_number,
COALESCE((SELECT CASE
WHEN ds.manifestation IS NOT NULL THEN ds.manifestation
WHEN (item.historico ->> 'eventCode'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN (item.historico ->> 'eventCode'::text)::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = ANY
(ARRAY ['210200'::text, '210210'::text, '210220'::text, '210240'::text])
THEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text)::character varying
ELSE NULL::character varying
END AS "case"
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE (item.historico ->> 'eventType'::text) = ANY
(ARRAY ['NFE_EVENT_MANIFESTATION'::text, 'NFE_EVENT'::text])
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.manifestation) AS manifestation,
ds.cce_events,
ds.available_at,
COALESCE((SELECT CASE
WHEN ds.canceled_at IS NOT NULL THEN ds.canceled_at
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text
THEN ((item.historico ->> 'eventAt'::text)::timestamp without time zone)::timestamp with time zone
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text
THEN ((item.historico ->> 'eventAt'::text)::timestamp without time zone)::timestamp with time zone
ELSE NULL::timestamp with time zone
END AS "case"
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
WHERE (item.historico ->> 'eventCode'::text) = '110111'::text
OR regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text, 'gi'::text) =
'110111'::text
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1),
ds.canceled_at) AS canceled_at,
COALESCE((SELECT CASE
WHEN ds.status IS NOT NULL THEN ds.status
WHEN (item.historico ->> 'eventCode'::text) = '110111'::text THEN '3'::character varying
WHEN regexp_replace(item.historico ->> 'description'::text, '[^0-9]'::text, ''::text,
'gi'::text) = '110111'::text THEN '3'::character varying
ELSE '1'::character varying
END AS "case"
FROM jsonb_array_elements(ds.history) WITH ORDINALITY item(historico, ordinality)
ORDER BY (item.historico ->> 'eventAt'::text) DESC
LIMIT 1), ds.status) AS status,
doc.name_file,
(SELECT json_agg(consulta.*) AS json_agg
FROM (SELECT (((d.data -> 'procEventoNFe'::text) -> 'evento'::text) -> 'infEvento'::text) ->>
'dhEvento'::text AS data_evento,
((((d.data -> 'procEventoNFe'::text) -> 'evento'::text) -> 'infEvento'::text) ->
'detEvento'::text) ->> 'xCorrecao'::text AS correcao_evento
FROM document d
WHERE doc.key::text = d.key::text
AND doc.cnpj_issuer::text = d.cnpj_issuer::text
AND ((((d.data -> 'procEventoNFe'::text) -> 'retEvento'::text) -> 'infEvento'::text) ->>
'tpEvento'::text) =
'110110'::text) consulta) AS carta_correcao,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'cobr'::text) ->
'dup'::text AS duplicatas,
(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'cobr'::text) -> 'fat'::text 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::timestamp with time zone, CURRENT_TIMESTAMP)::date -
doc.data_emissao::date AS canhoto_diferenca_dias_associacao,
doc.data,
(SELECT string_agg(DISTINCT (item.value -> 'prod'::text) ->> 'cfop'::text, ','::text) AS string_agg
FROM jsonb_array_elements(((doc.data -> 'nfe'::text) -> 'infNFe'::text) -> 'det'::text) item(value)) AS cfops,
(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)) AS jsonb_agg
FROM etiqueta_documento ed
JOIN etiqueta e ON e.id = ed.id_etiqueta_atual
WHERE ed.chave_nfe::text = doc.key::text) AS etiquetas
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 canhoto_nota cn
ON doc.key::text = cn.documento_chave::text AND doc.cnpj_issuer::text = cn.empresa_cnpj::text
WHERE doc.group_type::text = 'NFE'::text
 0 1 5 5 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 5 5 0 0.00
graphSELECT current_user 0 2 2 2 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 4 4 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 4 4 0 0.00
graphDROP view IF EXISTS public.document_cte_view 0 1 4 4 0 0.00
graphSELECT CURRENT_USER 0 1 4 4 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 4 4 0 0.00
graphSELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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 d.key IN (?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ? 0 1 4 4 0 0.00
graphDROP view IF EXISTS public.document_nfe_canhoto_view 0 1 3 3 0 0.00

spring Statistics spring - all

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean hits sqlMean time sql (ms)
spring global 100 1,476 70 2,321 133 100 5 720 0.00 9 55
spring warning 0 0 -1 0 -1 0 -1 -1 0.00 -1 -1
spring severe 10 13 829 2,321 865 29 190 22,425 0.00 1 128
114 hits/min on 22 requests       Summary by class       Dependencies       Details       Clear
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb% of system errorMean hits sqlMean time sql (ms)
graphDividaAtivaRegularizeController.salvar 37 353 111 1,266 94 21 5 342 0.00 17 100
graphDividaAtivaRegularizeServiceImpl.salvar 37 353 111 1,266 94 21 4 338 0.00 17 100
graphDocumentController.listDocumentsByKeys 5 214 25 246 20 8 3 813 0.00 1 16
graphDocumentService.listDocumentsByKeys 4 214 22 243 20 7 2 807 0.00 1 16
graphDownloadController.downloadNfsePdfZipOnline 2 3 1,026 2,321 1,122 9 276 32,423 0.00 2 185
graphDownloadService.downloadNfsePdfZip 2 3 1,025 2,318 1,120 9 275 31,816 0.00 2 185
graphGeradorPdfNfseServiceImpl.generatePdfByNfseDTO 2 3 1,021 2,310 1,117 9 271 31,361 0.00 2 185
graphDocumentController.listNfseByCnpjAndPeriod 2 153 14 95 12 5 3 576 0.00 1 5
graphDocumentService.listNfseByCnpjAndPeriod 1 153 11 89 11 4 2 540 0.00 1 5
graphFiscalntelligenceCoreService.buscarServicos 1 3 397 882 420 0 1 771 0.00 0 0
graphNextGenService.obterTodasCidades 0 1 376 376 0 0 10 2,414 0.00 0 0
graphNextGenService.findAtividadeEconomica 0 3 32 34 1 0 0 20 0.00 0 0
graphDocumentController.getProductsNfe 0 1 95 95 0 0 2 150 0.00 1 88
graphDocumentService.findProductDescriptionByCnpjAndCfop 0 1 91 91 0 0 2 139 0.00 1 88
graphDocumentController.getDocumentsCte 0 1 84 84 0 0 41 4,595 0.00 2 33
graphDocumentCteViewQueryService.findDocumentsWithData 0 1 78 78 0 0 37 4,303 0.00 2 33
graphDocumentController.findSpedByKey 0 4 13 18 4 0 2 307 0.00 1 5
graphDocumentService.findSpedByKey 0 4 10 15 3 0 2 300 0.00 1 5
graphDocumentController.findNotaEmitidaNfeCfeCteByCnpjPeriod 0 1 17 17 0 0 5 238 0.00 1 6
graphDocumentService.findNotaEmitidaNfeCfeCteByCnpjPeriod 0 1 14 14 0 0 4 227 0.00 1 6
graphBasicErrorController.error 0 2 2 4 2 0 2 693 0.00 0 0
graphServerController.version 0 4 0 2 1 0 0 144 0.00 0 0

error Statistics http system errors - all

Error% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb
Error404 100 1 4 4 0 100 3 637
0 hits/min on 1 errors       Details       Last errors       Clear
Error% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb
Error404 100 1 4 4 0 100 3 637
DateRequestError
8/25/25, 7:03:58 PM/robots.txt GETError404

log Statistics system errors logs - all

ErrorHits
WARN com.zaxxer.hikari.pool.PoolBase - Hikari - Failed to validate connection org.postgresql.jdbc.PgConnection@72c1936d (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
 1
0 hits/min on 2 errors       Details       Last errors       Clear
ErrorHits
WARN com.zaxxer.hikari.pool.PoolBase - Hikari - Failed to validate connection org.postgresql.jdbc.PgConnection@72c1936d (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
 1
WARN n.s.j.engine.export.PdfGlyphRenderer - Unpatched iText found, cannot use glyph rendering
 1
DateRequestUserError
8/25/25, 6:56:36 PM/api/document/keys POSTUsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}WARN  com.zaxxer.hikari.pool.PoolBase - Hikari - Failed to validate connection org.postgresql.jdbc.PgConnection@72c1936d (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
8/25/25, 7:00:04 PM/api/download/nfse/pdf-zip-online POSTUsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}WARN  n.s.j.engine.export.PdfGlyphRenderer - Unpatched iText found, cannot use glyph rendering
Clear all statistics

Current requests Current requests

None

System information System information

Execute the garbage collector Execute the garbage collector     Generate a heap dump Generate a heap dump     View memory histogram View memory histogram     Invalidate http sessions Invalidate http sessions     View http sessions View http sessions
     MBeans MBeans     View OS processes View OS processes     JNDI tree JNDI tree     Spring beans Spring beans     Opened jdbc connections Opened jdbc connections     Database Database
Host: ip-10-0-15-189.ec2.internal@10.0.15.189
Java memory used: graph1,464 Mb / 25,600 Mb    ++++++++++++
Nb of http sessions: graph0
Nb of active threads
(current http requests): 		graph0
Nb of active jdbc connections: graph0
Nb of used jdbc connections
(opened if no datasource): 		graph0
System loadgraph0.09
% System CPUgraph1.28    ++++++++++++








      Details


OS: OS Linux, 5.10.238-234.956.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 filesgraph470 / 65,535    ++++++++++++
Server: Undertow - 2.1.4.Final
Webapp context:
Start: 8/25/25, 6:51 PM
JVM arguments: -Xms1024m
-Xmx25600m
-XX:+HeapDumpOnOutOfMemoryError
-Xverify:none
-XX:+AlwaysPreTouch
-Djava.security.egd=file:/dev/./urandom
Mean age of http sessions (min): graph-1
Memory: Non heap memory = 243 Mb (Perm Gen, Code Cache),
Buffered memory = 177 Mb,
Loaded classes = 25,567,
Garbage collection time = 967 ms,
Process cpu time = 164,470 ms,
Committed virtual memory = 34,271 Mb,
Free physical memory = 29,179 Mb,
Total physical memory = 32,768 Mb
Free disk space: 19,828 Mb
Usable disk space: 18,276 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 Dependencies

Threads Threads

Threads on ip-10-0-15-189.ec2.internal@10.0.15.189: Number = 55, Maximum = 56, Total started = 212       Details

ThreadDaemon ?PriorityStateExecuted methodCpu time (ms)User time (ms)Interrupt Kill
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_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 3 0 Send a thread interrupt signal to Common-Cleaner. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Common-Cleaner
DestroyJavaVM no 5 RUNNABLERUNNABLE   412 370 Send a thread interrupt signal to DestroyJavaVM. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread DestroyJavaVM
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 WAITINGWAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 2 0 Send a thread interrupt signal to Finalizer. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Finalizer
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_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 17 10 Send a thread interrupt signal to Hikari housekeeper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Hikari housekeeper
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 12 0 Send a thread interrupt signal to HttpClient-1-SelectorManager. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread HttpClient-1-SelectorManager
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_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Thread.sleep(Native Method) 0 0 Send a thread interrupt signal to idle-connection-reaper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread idle-connection-reaper
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_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Thread.sleep(Native Method) 1 0 Send a thread interrupt signal to java-sdk-http-connection-reaper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread java-sdk-http-connection-reaper
Java2D Disposer
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.desktop@11.0.23/sun.java2d.Disposer.run(Unknown Source)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 Java2D Disposer
 yes 10 WAITINGWAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 0 0 Send a thread interrupt signal to Java2D Disposer. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Java2D Disposer
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_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 222 150 Send a thread interrupt signal to javamelody. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread javamelody
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_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 10 10 Send a thread interrupt signal to PostgreSQL-JDBC-SharedTimer-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread PostgreSQL-JDBC-SharedTimer-1
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 273 260 Send a thread interrupt signal to reactor-http-epoll-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-1
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 99 80 Send a thread interrupt signal to reactor-http-epoll-10. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-10
reactor-http-epoll-11
app//io.netty.channel.epoll.Native.epollWait0(Native Method)
app//io.netty.channel.epoll.Native.epollWait(Native.java:132)
app//io.netty.channel.epoll.EpollEventLoop.epollWait(EpollEventLoop.java:281)
app//io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:351)
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait0(Native Method) 34 20 Send a thread interrupt signal to reactor-http-epoll-11. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-11
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-12. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-12
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-13. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-13
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-14. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-14
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-15. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-15
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 0 0 Send a thread interrupt signal to reactor-http-epoll-16. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-16
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 137 120 Send a thread interrupt signal to reactor-http-epoll-2. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-2
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 138 120 Send a thread interrupt signal to reactor-http-epoll-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-3
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 139 120 Send a thread interrupt signal to reactor-http-epoll-4. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-4
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 126 110 Send a thread interrupt signal to reactor-http-epoll-5. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-5
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 131 120 Send a thread interrupt signal to reactor-http-epoll-6. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-6
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 116 90 Send a thread interrupt signal to reactor-http-epoll-7. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-7
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 101 80 Send a thread interrupt signal to reactor-http-epoll-8. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-8
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 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 99 90 Send a thread interrupt signal to reactor-http-epoll-9. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-9
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 RUNNABLERUNNABLE java.base@11.0.23/java.lang.ref.Reference.waitForReferencePendingList(Native Method) 4 0 Send a thread interrupt signal to Reference Handler. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Reference Handler
Signal Dispatcher yes 9 RUNNABLERUNNABLE   0 0 Send a thread interrupt signal to Signal Dispatcher. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Signal Dispatcher
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 32 20 Send a thread interrupt signal to XNIO-1 Accept. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 Accept
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 44 40 Send a thread interrupt signal to XNIO-1 I/O-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-1
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:532)
 XNIO-1 I/O-10
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 2 0 Send a thread interrupt signal to XNIO-1 I/O-10. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-10
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 9 0 Send a thread interrupt signal to XNIO-1 I/O-11. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-11
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:532)
 XNIO-1 I/O-12
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 10 10 Send a thread interrupt signal to XNIO-1 I/O-12. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-12
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:551)
 XNIO-1 I/O-13
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 9 0 Send a thread interrupt signal to XNIO-1 I/O-13. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-13
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 6 0 Send a thread interrupt signal to XNIO-1 I/O-14. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-14
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:551)
 XNIO-1 I/O-15
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 15 10 Send a thread interrupt signal to XNIO-1 I/O-15. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-15
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:551)
 XNIO-1 I/O-16
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 92 80 Send a thread interrupt signal to XNIO-1 I/O-16. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-16
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 64 60 Send a thread interrupt signal to XNIO-1 I/O-2. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-2
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 42 30 Send a thread interrupt signal to XNIO-1 I/O-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-3
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 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 2 0 Send a thread interrupt signal to XNIO-1 I/O-4. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-4
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:532)
 XNIO-1 I/O-5
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 1 0 Send a thread interrupt signal to XNIO-1 I/O-5. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-5
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:532)
 XNIO-1 I/O-6
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 4 0 Send a thread interrupt signal to XNIO-1 I/O-6. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-6
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:551)
 XNIO-1 I/O-7
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 14 10 Send a thread interrupt signal to XNIO-1 I/O-7. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-7
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:551)
 XNIO-1 I/O-8
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 51 40 Send a thread interrupt signal to XNIO-1 I/O-8. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-8
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:551)
 XNIO-1 I/O-9
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 8 0 Send a thread interrupt signal to XNIO-1 I/O-9. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 I/O-9
XNIO-1 task-1
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-1
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 836 800 Send a thread interrupt signal to XNIO-1 task-1. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-1
XNIO-1 task-10
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-10
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 905 850 Send a thread interrupt signal to XNIO-1 task-10. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-10
XNIO-1 task-2
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-2
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 486 440 Send a thread interrupt signal to XNIO-1 task-2. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-2
XNIO-1 task-3
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-3
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 378 350 Send a thread interrupt signal to XNIO-1 task-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-3
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_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 1,304 1,240 Send a thread interrupt signal to XNIO-1 task-4. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-4
XNIO-1 task-5
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-5
 no 5 RUNNABLERUNNABLE java.base@11.0.23/java.lang.Thread.dumpThreads(Native Method) 934 830 Send a thread interrupt signal to XNIO-1 task-5. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-5
XNIO-1 task-6
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-6
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 1,085 1,020 Send a thread interrupt signal to XNIO-1 task-6. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-6
XNIO-1 task-7
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-7
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 1,317 1,270 Send a thread interrupt signal to XNIO-1 task-7. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-7
XNIO-1 task-8
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-8
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 392 370 Send a thread interrupt signal to XNIO-1 task-8. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-8
XNIO-1 task-9
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-9
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 248 220 Send a thread interrupt signal to XNIO-1 task-9. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-9
The cpu times and user times of these threads are measured from the start of the server

Dump threads as text Dump threads as text       Threads View in a new page


Last collect time: 3 ms
Display time: 17 ms
Memory overhead estimate: < 1 Mb
Disk usage: 2 Mb     Purge the obsolete files

JavaMelody 1.90.0
Debugging logs

Mon Aug 25 18:51:14 BRT 2025     DEBUG     spring interceptor initialized
Mon Aug 25 18:51:14 BRT 2025     DEBUG     spring interceptor initialized
Mon Aug 25 18:51:14 BRT 2025     DEBUG     spring interceptor initialized
Mon Aug 25 18:51:14 BRT 2025     DEBUG     spring interceptor initialized
Mon Aug 25 18:51:14 BRT 2025     DEBUG     spring interceptor initialized
Mon Aug 25 18:51:14 BRT 2025     DEBUG     spring interceptor initialized
Mon Aug 25 18:51:15 BRT 2025     DEBUG     Spring datasource wrapped: dataSource
Mon Aug 25 18:51:20 BRT 2025     DEBUG     JavaMelody listener init started
Mon Aug 25 18:51:20 BRT 2025     DEBUG     datasources found in JNDI: []
Mon Aug 25 18:51:20 BRT 2025     DEBUG     JavaMelody listener init done in 7 ms
Mon Aug 25 18:51:22 BRT 2025     DEBUG     rest template interceptor initialized
Mon Aug 25 18:51:24 BRT 2025     DEBUG     JavaMelody filter init started
Mon Aug 25 18:51:24 BRT 2025     DEBUG     OS: Linux unknown, amd64/64
Mon Aug 25 18:51:24 BRT 2025     DEBUG     Java: OpenJDK Runtime Environment, 11.0.23+9
Mon Aug 25 18:51:24 BRT 2025     DEBUG     Server: Undertow - 2.1.4.Final
Mon Aug 25 18:51:24 BRT 2025     DEBUG     Webapp context:
Mon Aug 25 18:51:24 BRT 2025     DEBUG     JavaMelody version: 1.90.0
Mon Aug 25 18:51:24 BRT 2025     DEBUG     JavaMelody classes loaded from: file:/app/libs/javamelody-core-1.90.0.jar
Mon Aug 25 18:51:24 BRT 2025     DEBUG     Application type: Spring Boot
Mon Aug 25 18:51:24 BRT 2025     DEBUG     Application version: null
Mon Aug 25 18:51:24 BRT 2025     DEBUG     Host: ip-10-0-15-189.ec2.internal@10.0.15.189
Mon Aug 25 18:51:24 BRT 2025     DEBUG     log listeners initialized
Mon Aug 25 18:51:24 BRT 2025     DEBUG     datasources found in JNDI: []
Mon Aug 25 18:51:24 BRT 2025     DEBUG     JPA persistence provider resolver initialized
Mon Aug 25 18:51:24 BRT 2025     DEBUG     counters initialized
Mon Aug 25 18:51:24 BRT 2025     DEBUG     counters data read from files in /tmp/javamelody/_ip-10-0-15-189.ec2.internal
Mon Aug 25 18:51:24 BRT 2025     DEBUG     collect task scheduled every 60s
Mon Aug 25 18:51:25 BRT 2025     DEBUG     first collect of data done
Mon Aug 25 18:51:25 BRT 2025     DEBUG     JavaMelody filter init done in 162 ms