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 10/3/25, 2:36 AM on _ip-10-0-10-150.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 - 1 day since midnight

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 272,942 12 3,024 19 100 0 411 0.00 0 1 8
http warning 0 219 39 680 51 0 2 541 0.00 2 1 30
http severe 9 3,162 101 3,024 134 28 16 15,133 0.00 11 2 77
2,110 hits/min on 23 requests       Details      
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/cte/credito-pis-cofins-frete-insumo-aliquota-zero/{cnpj}/period GET 90 268,520 11 1,615 7 70 0 238 0.00 0 1 8
graph/api/reports/nfe/{key} GET 8 2,947 96 1,998 70 28 17 16,142 0.00 11 3 73
graph/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST 0 90 124 3,024 500 0 1 599 0.00 0 1 119
graph/api/regularize/divida-ativa/{cnpj}/total POST 0 78 135 1,718 336 0 1 303 0.00 0 1 130
graph/api/download/nfse/pdf-zip-online POST 0 6 696 2,228 791 0 31 6,041 0.00 15 2 371
graph/actuator/health GET 0 777 5 60 4 0 0 67 0.00 0 0 0
graph/api/document/{cnpj}/nfse/period GET 0 180 16 125 18 0 1 254 0.00 0 1 10
graph/api/reports/cte/{key} GET 0 11 272 876 302 0 22 10,201 0.00 10 2 241
graph/api/document/keys POST 0 74 39 281 42 0 1 252 0.00 0 1 30
graph/api/download/cte/xml/{key} GET 0 65 38 58 5 0 3 356 0.00 4 2 29
graph/api/document/{cnpj}/v2/cte/ POST 0 10 199 1,047 311 0 16 2,236 0.00 29 2 177
graph/api/document/buscar-cte-por-chave/{key} GET 0 65 29 47 4 0 2 280 0.00 1 1 24
graph/api/document/{cnpj}/cruzamento-efd-nfse POST 0 1 1,819 1,819 0 0 9 1,897 0.00 0 0 0
graph/api/reports/nfse/{key} GET 0 3 589 708 120 0 19 5,055 0.00 23 2 252
graph/api/document/{cnpj}/analise-venda-devolucao POST 0 40 43 680 106 0 5 1,530 0.00 0 1 32
graph/api/document/{cnpj}/v2/nfe/ POST 0 11 75 336 88 0 6 1,178 0.00 15 2 64
graph/api/download/nfe/xml/{key} GET 0 20 40 43 1 0 2 384 0.00 4 2 32
graph/api/document/buscar-nfe-por-chave/{key} GET 0 20 34 38 2 0 2 390 0.00 8 1 27
graph/api/document/{cnpj}/products-nfe GET 0 5 79 119 34 0 2 289 0.00 0 1 69
graph/api/document/{key}/sped-document GET 0 12 14 28 6 0 2 362 0.00 0 1 7
graph/api/document/{cnpj}/find-nota-emitida-periodo POST 0 4 28 42 12 0 2 530 0.00 0 1 18
graphError404 0 2 3 4 0 0 2 401 100.00 0 0 0
graph/api/server/publico/version GET 0 1 2 2 0 0 2 619 0.00 0 0 0

sql Statistics sql - 1 day since midnight

Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of system error
sql global 100 278,182 8 3,019 15 0.00
sql warning 0 237 26 662 43 0.00
sql severe 8 3,110 69 3,019 122 0.00
2,150 hits/min on 78 requests       Details      
Request% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of system error
graphSELECT CAST(cte.data -> 'cte' -> 'infCte' -> 'ide' ->> 'nct' AS int8) AS numeroCte, cte.key AS chaveCte, nfe_info.numeroNfe, item.produto ->> 'chave' AS chaveNfe, CAST(cte.data -> 'cte' -> 'infCte' -> 'vprest' ->> 'vtPrest' AS numeric) AS valorPrestacao FROM document cte, jsonb_array_elements(cte.data -> 'cte' -> 'infCteNorm' -> 'infDoc' -> 'infNFe') WITH ORDINALITY item(produto), LATERAL ( SELECT DISTINCT CAST(nfe.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS int8) AS numeroNfe FROM document nfe, jsonb_array_elements(nfe.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item_nfe(produto_nfe) WHERE nfe.key = item.produto ->> 'chave' AND nfe.data_emissao BETWEEN ? AND ? AND nfe.type IN ('NFE_4_0', 'NFE_3_1', 'NFE_2_0') AND produto_nfe -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '06' AND produto_nfe -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '06' ) AS nfe_info WHERE cte.type = 'CTE' AND cte.cnpj_addressee = ? AND cte.data_emissao BETWEEN ? AND ? AND EXISTS ( SELECT 1 FROM document nfe, jsonb_array_elements(nfe.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item_nfe(produto_nfe) WHERE nfe.key = item.produto ->> 'chave' AND nfe.data_emissao BETWEEN ? AND ? AND nfe.type IN ('NFE_4_0', 'NFE_3_1', 'NFE_2_0') AND produto_nfe -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '06' AND produto_nfe -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '06' ) limit ? 89 268,520 8 1,611 6 0.00
graphselect documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.cnpj as cnpj12_15_, documentnf0_.cnpj_addressee as cnpj_ad13_15_, documentnf0_.cnpj_carrier as cnpj_ca14_15_, documentnf0_.cte_key as cte_key15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ?)) 7 2,947 63 1,687 53 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 2,967 6 302 8 0.00
graph SELECT SUM(dar.valor_consolidado) AS dividaAtiva FROM divida_ativa_regularize dar WHERE dar.cnpj = ? AND dar.valor_consolidado IS NOT NULL 0 78 130 1,700 335 0.00
graphselect canhotonot0_.id as id1_28_, canhotonot0_.canhoto_importacao_id as canhoto_6_28_, canhotonot0_.created_at as created_2_28_, canhotonot0_.documento_chave as document3_28_, canhotonot0_.empresa_cnpj as empresa_4_28_, canhotonot0_.numero_nota as numero_n5_28_ from canhoto_nota canhotonot0_ left outer join canhoto_importacao canhotoimp1_ on canhotonot0_.canhoto_importacao_id=canhotoimp1_.id where canhotonot0_.documento_chave=? and (canhotoimp1_.status in (? , ?)) 0 2,947 3 274 8 0.00
graphselect documentct0_.cnpj_issuer as cnpj_iss1_9_, documentct0_.type as type2_9_, documentct0_.key as key3_9_, documentct0_.nsu as nsu4_9_, documentct0_.protocol as protocol5_9_, documentct0_.addressee_cnpj_cpf as addresse6_9_, documentct0_.addressee_inscricao_estadual as addresse7_9_, documentct0_.addressee_name as addresse8_9_, documentct0_.available_at as availabl9_9_, documentct0_.canceled_at as cancele10_9_, documentct0_.chaves_nfe_associadas_sistema as chaves_11_9_, documentct0_.chaves_nfe_documento as chaves_12_9_, documentct0_.cnpj_carrier as cnpj_ca13_9_, documentct0_.cnpj_cpf_remetente as cnpj_cp14_9_, documentct0_.cst as cst15_9_, documentct0_.data_emissao as data_em16_9_, documentct0_.expedidor_cnpj as expedid17_9_, documentct0_.expedidor_inscricao_estadual as expedid18_9_, documentct0_.expedidor_nome as expedid19_9_, documentct0_.issuer_inscricao_estadual as issuer_20_9_, documentct0_.issuer_name as issuer_21_9_, documentct0_.manifestation as manifes22_9_, documentct0_.name_file as name_fi23_9_, documentct0_.numero_cte as numero_24_9_, documentct0_.picms as picms25_9_, documentct0_.recebedor_cnpj_cpf as recebed26_9_, documentct0_.recebedor_inscricao_estadual as recebed27_9_, documentct0_.recebedor_nome as recebed28_9_, documentct0_.remetente_cnpj_cpf as remeten29_9_, documentct0_.remetente_inscricao_estadual as remeten30_9_, documentct0_.remetente_nome as remeten31_9_, documentct0_.schema as schema32_9_, documentct0_.serial as serial33_9_, documentct0_.status as status34_9_, documentct0_.tipo_cte as tipo_ct35_9_, documentct0_.tipo_tomador_servico as tipo_to36_9_, documentct0_.tomador4_cnpj as tomador37_9_, documentct0_.tomador4_inscricao_estadual as tomador38_9_, documentct0_.tomador4_nome as tomador39_9_, documentct0_.value as value40_9_, documentct0_.vbc as vbc41_9_, documentct0_.vicms as vicms42_9_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?)) and (documentct0_.data_emissao between ? and ?) 0 130 24 36 3 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 4 758 2,947 1,459 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 2 1,515 3,019 2,126 0.00
graphselect documentct0_.cnpj_issuer as cnpj_iss1_9_, documentct0_.type as type2_9_, documentct0_.key as key3_9_, documentct0_.nsu as nsu4_9_, documentct0_.protocol as protocol5_9_, documentct0_.addressee_cnpj_cpf as addresse6_9_, documentct0_.addressee_inscricao_estadual as addresse7_9_, documentct0_.addressee_name as addresse8_9_, documentct0_.available_at as availabl9_9_, documentct0_.canceled_at as cancele10_9_, documentct0_.chaves_nfe_associadas_sistema as chaves_11_9_, documentct0_.chaves_nfe_documento as chaves_12_9_, documentct0_.cnpj_carrier as cnpj_ca13_9_, documentct0_.cnpj_cpf_remetente as cnpj_cp14_9_, documentct0_.cst as cst15_9_, documentct0_.data_emissao as data_em16_9_, documentct0_.expedidor_cnpj as expedid17_9_, documentct0_.expedidor_inscricao_estadual as expedid18_9_, documentct0_.expedidor_nome as expedid19_9_, documentct0_.issuer_inscricao_estadual as issuer_20_9_, documentct0_.issuer_name as issuer_21_9_, documentct0_.manifestation as manifes22_9_, documentct0_.name_file as name_fi23_9_, documentct0_.numero_cte as numero_24_9_, documentct0_.picms as picms25_9_, documentct0_.recebedor_cnpj_cpf as recebed26_9_, documentct0_.recebedor_inscricao_estadual as recebed27_9_, documentct0_.recebedor_nome as recebed28_9_, documentct0_.remetente_cnpj_cpf as remeten29_9_, documentct0_.remetente_inscricao_estadual as remeten30_9_, documentct0_.remetente_nome as remeten31_9_, documentct0_.schema as schema32_9_, documentct0_.serial as serial33_9_, documentct0_.status as status34_9_, documentct0_.tipo_cte as tipo_ct35_9_, documentct0_.tipo_tomador_servico as tipo_to36_9_, documentct0_.tomador4_cnpj as tomador37_9_, documentct0_.tomador4_inscricao_estadual as tomador38_9_, documentct0_.tomador4_nome as tomador39_9_, documentct0_.value as value40_9_, documentct0_.vbc as vbc41_9_, documentct0_.vicms as vicms42_9_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?)) 0 11 235 841 302 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 6 414 2,265 907 0.00
graphselect documentnf0_.key as key1_16_, documentnf0_.addressee_cpfcnpj as addresse2_16_, documentnf0_.addressee_name as addresse3_16_, documentnf0_.city_name as city_nam4_16_, documentnf0_.competency_date as competen5_16_, documentnf0_.data_emissao as data_emi6_16_, documentnf0_.type as type7_16_, documentnf0_.group_type as group_ty8_16_, documentnf0_.ibge_city_code as ibge_cit9_16_, documentnf0_.imported_at as importe10_16_, documentnf0_.iss_value as iss_val11_16_, documentnf0_.issuer_cpfcnpj as issuer_12_16_, documentnf0_.issuer_name as issuer_13_16_, documentnf0_.name_file as name_fi14_16_, documentnf0_.number as number15_16_, documentnf0_.opcao_simples as opcao_s16_16_, documentnf0_.opting_simple as opting_17_16_, documentnf0_.rps_number as rps_num18_16_, documentnf0_.rps_serie as rps_ser19_16_, documentnf0_.service_code as service20_16_, documentnf0_.service_description as service21_16_, documentnf0_.status as status22_16_, documentnf0_.uf_initial as uf_init23_16_, documentnf0_.value as value24_16_, documentnf0_.verification_code as verific25_16_ 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 (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) 0 6 360 1,213 458 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 ? 0 180 10 122 17 0.00
graph SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d.cnpj_issuer in (?) OR d.cnpj_addressee in (?)) 0 1 1,763 1,763 0 0.00
graphselect documentct0_.cnpj_issuer as cnpj_iss1_9_, documentct0_.type as type2_9_, documentct0_.key as key3_9_, documentct0_.nsu as nsu4_9_, documentct0_.protocol as protocol5_9_, documentct0_.addressee_cnpj_cpf as addresse6_9_, documentct0_.addressee_inscricao_estadual as addresse7_9_, documentct0_.addressee_name as addresse8_9_, documentct0_.available_at as availabl9_9_, documentct0_.canceled_at as cancele10_9_, documentct0_.chaves_nfe_associadas_sistema as chaves_11_9_, documentct0_.chaves_nfe_documento as chaves_12_9_, documentct0_.cnpj_carrier as cnpj_ca13_9_, documentct0_.cnpj_cpf_remetente as cnpj_cp14_9_, documentct0_.cst as cst15_9_, documentct0_.data_emissao as data_em16_9_, documentct0_.expedidor_cnpj as expedid17_9_, documentct0_.expedidor_inscricao_estadual as expedid18_9_, documentct0_.expedidor_nome as expedid19_9_, documentct0_.issuer_inscricao_estadual as issuer_20_9_, documentct0_.issuer_name as issuer_21_9_, documentct0_.manifestation as manifes22_9_, documentct0_.name_file as name_fi23_9_, documentct0_.numero_cte as numero_24_9_, documentct0_.picms as picms25_9_, documentct0_.recebedor_cnpj_cpf as recebed26_9_, documentct0_.recebedor_inscricao_estadual as recebed27_9_, documentct0_.recebedor_nome as recebed28_9_, documentct0_.remetente_cnpj_cpf as remeten29_9_, documentct0_.remetente_inscricao_estadual as remeten30_9_, documentct0_.remetente_nome as remeten31_9_, documentct0_.schema as schema32_9_, documentct0_.serial as serial33_9_, documentct0_.status as status34_9_, documentct0_.tipo_cte as tipo_ct35_9_, documentct0_.tipo_tomador_servico as tipo_to36_9_, documentct0_.tomador4_cnpj as tomador37_9_, documentct0_.tomador4_inscricao_estadual as tomador38_9_, documentct0_.tomador4_nome as tomador39_9_, documentct0_.value as value40_9_, documentct0_.vbc as vbc41_9_, documentct0_.vicms as vicms42_9_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and substring(documentct0_.tomador4_cnpj, 1, 8)=? limit ? 0 10 170 992 298 0.00
graphWITH operacoes AS ( SELECT CASE WHEN item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN CASE WHEN ds.status = '3' THEN 'VENDA|CANCELADA' ELSE 'VENDA' END WHEN item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN CASE WHEN ds.status = '3' THEN 'DEVOLUCAO|CANCELADA' ELSE 'DEVOLUCAO' END WHEN ds.status = '3' THEN 'CANCELADA' END AS tipoOperacao, TO_CHAR(d.data_emissao, 'YYYY-MM') AS periodo, SUM(CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC)) AS valor FROM document d 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 JOIN jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') item(produto) ON TRUE WHERE d.cnpj_issuer = ? AND d.type IN ('NFE_4_0', 'NFE_3_1') AND ((null) is NULL OR d.key IN (null)) AND d.data_emissao BETWEEN ? AND ? AND (? = 'nao_filtrar_ie' OR d.data -> 'nfe' -> 'infNFe' -> 'emit' ->> 'ie' =?) AND ( item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR ds.status = '3' ) GROUP BY item.produto -> 'prod' ->> 'cfop', ds.status, TO_CHAR(d.data_emissao, 'YYYY-MM') ) SELECT tipoOperacao, periodo, SUM(valor) AS valor FROM operacoes GROUP BY tipoOperacao, periodo ORDER BY periodo 0 40 32 662 104 0.00
graphselect documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.cnpj as cnpj12_15_, documentnf0_.cnpj_addressee as cnpj_ad13_15_, documentnf0_.cnpj_carrier as cnpj_ca14_15_, documentnf0_.cte_key as cte_key15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ? , ?)) and (documentnf0_.data_emissao between ? and ?) 0 40 26 33 1 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 4 192 731 359 0.00
graphselect documentnf0_.key as key1_16_, documentnf0_.addressee_cpfcnpj as addresse2_16_, documentnf0_.addressee_name as addresse3_16_, documentnf0_.city_name as city_nam4_16_, documentnf0_.competency_date as competen5_16_, documentnf0_.data_emissao as data_emi6_16_, documentnf0_.type as type7_16_, documentnf0_.group_type as group_ty8_16_, documentnf0_.ibge_city_code as ibge_cit9_16_, documentnf0_.imported_at as importe10_16_, documentnf0_.iss_value as iss_val11_16_, documentnf0_.issuer_cpfcnpj as issuer_12_16_, documentnf0_.issuer_name as issuer_13_16_, documentnf0_.name_file as name_fi14_16_, documentnf0_.number as number15_16_, documentnf0_.opcao_simples as opcao_s16_16_, documentnf0_.opting_simple as opting_17_16_, documentnf0_.rps_number as rps_num18_16_, documentnf0_.rps_serie as rps_ser19_16_, documentnf0_.service_code as service20_16_, documentnf0_.service_description as service21_16_, documentnf0_.status as status22_16_, documentnf0_.uf_initial as uf_init23_16_, documentnf0_.value as value24_16_, documentnf0_.verification_code as verific25_16_ from public.document_nfse_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) 0 3 246 328 129 0.00
graphselect documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.cnpj as cnpj12_15_, documentnf0_.cnpj_addressee as cnpj_ad13_15_, documentnf0_.cnpj_carrier as cnpj_ca14_15_, documentnf0_.cte_key as cte_key15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.key asc limit ? 0 11 58 315 86 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?)ORDER BY d.key limit ? 0 32 17 117 24 0.00
graphselect documentwi0_.key as key3_4_, documentwi0_.data_emissao as data_em11_4_, documentwi0_.type as type2_4_, documentwi0_.gzip as gzip13_4_ from public.document documentwi0_ where documentwi0_.key=? and documentwi0_.type=? and (documentwi0_.data_emissao between ? and ?) 0 85 5 23 2 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 17 24 120 31 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 5 69 109 34 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 169 275 149 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?)ORDER BY d.key limit ? 0 14 19 74 18 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 4 48 173 83 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 2 75 145 98 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 132 132 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 127 127 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 40 81 35 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 93 93 0 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 2 45 86 57 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, cast(coalesce(data -> 'header' ->> 'parcial','false') as boolean) as parcial from document where key = ? and group_type = 'SPED' and data_emissao between ? and ? 0 12 7 21 5 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 41 60 26 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 40 44 4 0.00
graph SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE SUBSTRING(d.cnpj_addressee, 1, 8) = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? 0 11 6 10 1 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 4 18 30 11 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 5 14 28 10 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 4 17 48 20 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 33 57 33 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?)ORDER BY d.key limit ? 0 4 14 33 12 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 29 53 33 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 53 53 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 22 32 13 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 41 41 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 20 36 21 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 13 24 9 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 36 36 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 4 8 18 6 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 32 32 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 10 11 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 31 31 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 14 22 11 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 26 26 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 25 25 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 24 24 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 22 22 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 20 20 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 18 18 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 18 18 0 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 4 4 6 1 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 5 3 6 1 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 2 8 10 2 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?)ORDER BY d.key limit ? 0 2 7 11 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 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 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 13 13 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 6 8 2 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 2 5 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 11 11 0 0.00
graphSELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ? 0 2 5 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 11 11 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 9 9 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 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 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

spring Statistics spring - 1 day since midnight

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 544,438 12 3,023 19 100 0 217 0.00 1 8
spring warning 0 419 36 674 52 0 1 284 0.00 1 30
spring severe 9 6,340 97 3,023 137 91 16 14,988 0.00 2 77
4,209 hits/min on 47 requests       Summary by class       Dependencies       Details      
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)
graphCreditoPisCofinsFreteInsumosAliquotaZeroController.consultar 45 268,520 11 1,614 7 4 0 44 0.00 1 8
graphCreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar 45 268,520 11 1,614 7 3 0 43 0.00 1 8
graphReportController.generateNfeReport 4 2,947 91 1,994 69 45 17 16,051 0.00 3 73
graphGeradorPdfNfeServiceImpl.generatePdfByKey 4 2,947 91 1,994 69 45 17 16,049 0.00 3 73
graphCreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm 0 90 123 3,023 500 0 0 75 0.00 1 119
graphCreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm 0 90 123 3,023 500 0 0 66 0.00 1 119
graphDividaAtivaRegularizeController.findDividaAtivaByCnpj 0 78 134 1,711 336 0 0 56 0.00 1 130
graphDividaAtivaRegularizeServiceImpl.findDividaAtivaByCnpj 0 78 134 1,709 336 0 0 46 0.00 1 130
graphDownloadController.downloadNfsePdfZipOnline 0 6 689 2,222 790 0 30 5,998 0.00 2 371
graphDownloadService.downloadNfsePdfZip 0 6 689 2,222 790 0 30 5,996 0.00 2 371
graphGeradorPdfNfseServiceImpl.generatePdfByNfseDTO 0 6 687 2,220 790 0 29 5,947 0.00 2 371
graphDocumentCteViewQueryService.findByKey 0 130 26 39 3 0 1 67 0.00 1 24
graphDownloadService.getFileXmlInS3ByTypeAndKey 0 85 35 51 4 0 2 229 0.00 2 29
graphDocumentController.listNfseByCnpjAndPeriod 0 180 16 125 18 0 0 65 0.00 1 10
graphReportController.generateCteReport 0 11 267 872 302 0 21 10,112 0.00 2 241
graphGeradorPdfCteServiceImpl.generatePdfByKey 0 11 267 872 302 0 21 10,110 0.00 2 241
graphDocumentController.listDocumentsByKeys 0 74 38 280 42 0 0 139 0.00 1 30
graphDocumentService.listDocumentsByKeys 0 74 35 278 42 0 0 132 0.00 1 30
graphDocumentService.listNfseByCnpjAndPeriod 0 180 13 122 18 0 0 58 0.00 1 10
graphDownloadController.retornaBytesXmlZipadoPelaChaveCte 0 65 34 52 4 0 2 245 0.00 2 29
graphDocumentController.getDocumentsCte 0 10 193 1,042 311 0 10 1,329 0.00 2 177
graphDocumentCteViewQueryService.findDocumentsWithData 0 10 189 1,037 310 0 9 1,281 0.00 2 177
graphDocumentController.getCteByKey 0 65 28 41 3 0 1 75 0.00 1 24
graphDocumentController.cruzamentoEfdNfse 0 1 1,817 1,817 0 0 6 1,400 0.00 0 0
graphDocumentService.cruzamentoEfdNfse 0 1 1,814 1,814 0 0 5 1,374 0.00 0 0
graphFiscalntelligenceCoreService.buscarServicos 0 9 201 558 153 0 0 274 0.00 0 0
graphGeradorPdfNfseServiceImpl.generatePdfByKey 0 3 584 702 118 0 18 4,958 0.00 2 252
graphReportController.generateReport 0 3 584 702 118 0 18 4,964 0.00 2 252
graphDocumentController.analiseVendaDevolucao 0 40 40 674 105 0 2 732 0.00 1 32
graphDocumentService.findComparativeSaleReturnByCnpjKeyPeriodCfop 0 40 36 671 105 0 1 603 0.00 1 32
graphDocumentNfeViewQueryService.findByKey 0 40 29 33 1 0 0 162 0.00 1 26
graphDocumentController.getDocumentsNFEV2 0 11 72 334 88 0 2 537 0.00 2 64
graphDownloadController.retornaBytesXmlZipadoPelaChaveNfe 0 20 37 40 1 0 1 275 0.00 2 32
graphDocumentNfeViewQueryService.findDocumentsWithData 0 11 68 329 87 0 2 528 0.00 2 64
graphDocumentController.getNfeByKey 0 20 32 37 2 0 1 180 0.00 1 27
graphNextGenService.obterTodasCidades 0 1 470 470 0 0 6 1,379 0.00 0 0
graphDocumentController.getProductsNfe 0 5 78 118 34 0 1 92 0.00 1 69
graphDocumentService.findProductDescriptionByCnpjAndCfop 0 5 73 112 33 0 1 85 0.00 1 69
graphNextGenService.findAtividadeEconomica 0 9 31 67 14 0 0 17 0.00 0 0
graphDocumentController.findSpedByKey 0 12 12 27 6 0 1 142 0.00 1 7
graphDocumentService.findSpedByKey 0 12 10 25 6 0 1 136 0.00 1 7
graphDocumentController.findNotaEmitidaNfeCfeCteByCnpjPeriod 0 4 26 38 10 0 1 66 0.00 1 18
graphDocumentService.findNotaEmitidaNfeCfeCteByCnpjPeriod 0 4 22 34 11 0 0 59 0.00 1 18
graphNextGenService.obterCnpjMatrizEFiliais 0 1 37 37 0 0 3 1,170 0.00 0 0
graphBasicErrorController.errorHtml 0 1 8 8 0 0 7 3,246 0.00 0 0
graphBasicErrorController.error 0 1 1 1 0 0 0 3 0.00 0 0
graphServerController.version 0 1 1 1 0 0 1 573 0.00 0 0

error Statistics http system errors - 1 day since midnight

Error% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb
Error404 100 2 3 4 0 100 2 401
0 hits/min on 1 errors       Details       Last errors      
Error% of cumulative timeHitsMean time (ms)Max time (ms)Standard deviation% of cumulative cpu timeMean cpu time (ms)Mean allocated Kb
Error404 100 2 3 4 0 100 2 401
DateRequestError
10/3/25, 1:55:36 AM/robots.txt GETError404
10/3/25, 2:35:49 AM/robots.txt GETError404

log Statistics system errors logs - 1 day since midnight

ErrorHits
WARN com.zaxxer.hikari.pool.PoolBase - Hikari - Failed to validate connection org.postgresql.jdbc.PgConnection@6b070f13 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
 1
0 hits/min on 2 errors       Details       Last errors      
ErrorHits
WARN com.zaxxer.hikari.pool.PoolBase - Hikari - Failed to validate connection org.postgresql.jdbc.PgConnection@6b070f13 (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
10/3/25, 12:29:55 AM/api/reports/nfe/31250816701716002957550000206090761923001664 GETUsuarioAutenticadoParaServicos{id=3, email='revizia-cron-job@revizia.com.br'}WARN  n.s.j.engine.export.PdfGlyphRenderer - Unpatched iText found, cannot use glyph rendering
10/3/25, 12:34:15 AM  WARN  com.zaxxer.hikari.pool.PoolBase - Hikari - Failed to validate connection org.postgresql.jdbc.PgConnection@6b070f13 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.

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-10-150.ec2.internal@10.0.10.150
Java memory used: graph713 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.05
% System CPUgraph1.05    ++++++++++++








      Details


OS: OS Linux, 5.10.240-238.966.amzn2.x86_64 , amd64/64 (16 cores)
Java: OpenJDK Runtime Environment, 11.0.23+9
JVM: OpenJDK 64-Bit Server VM, 11.0.23+9, mixed mode, sharing
PID of process: 8
Nb of opened filesgraph481 / 65,535    ++++++++++++
Server: Undertow - 2.1.4.Final
Webapp context:
Start: 10/3/25, 12:27 AM
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 = 272 Mb (Perm Gen, Code Cache),
Buffered memory = 259 Mb,
Loaded classes = 26,890,
Garbage collection time = 1,341 ms,
Process cpu time = 771,670 ms,
Committed virtual memory = 36,762 Mb,
Free physical memory = 25,644 Mb,
Total physical memory = 32,768 Mb
Free disk space: 19,824 Mb
Usable disk space: 18,272 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-10-150.ec2.internal@10.0.10.150: Number = 73, Maximum = 200, Total started = 3,288       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) 13 10 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   268 250 Send a thread interrupt signal to DestroyJavaVM. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread DestroyJavaVM
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) 1,290 890 Send a thread interrupt signal to Hikari housekeeper. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread Hikari housekeeper
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) 6 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) 8 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) 3 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) 864 640 Send a thread interrupt signal to javamelody. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread javamelody
PostgreSQL-JDBC-SharedTimer-3
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-3
 yes 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/java.lang.Object.wait(Native Method) 20 20 Send a thread interrupt signal to PostgreSQL-JDBC-SharedTimer-3. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread PostgreSQL-JDBC-SharedTimer-3
reactor-http-epoll-112
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-112
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 5,521 4,570 Send a thread interrupt signal to reactor-http-epoll-112. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-112
reactor-http-epoll-117
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-117
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 4,949 4,170 Send a thread interrupt signal to reactor-http-epoll-117. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-117
reactor-http-epoll-131
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-131
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 4,775 3,970 Send a thread interrupt signal to reactor-http-epoll-131. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-131
reactor-http-epoll-135
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-135
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 3,602 2,920 Send a thread interrupt signal to reactor-http-epoll-135. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-135
reactor-http-epoll-139
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-139
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 4,039 3,430 Send a thread interrupt signal to reactor-http-epoll-139. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-139
reactor-http-epoll-17
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-17
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 6,455 5,440 Send a thread interrupt signal to reactor-http-epoll-17. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-17
reactor-http-epoll-23
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-23
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 8,089 6,690 Send a thread interrupt signal to reactor-http-epoll-23. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-23
reactor-http-epoll-36
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-36
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 8,104 6,790 Send a thread interrupt signal to reactor-http-epoll-36. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-36
reactor-http-epoll-42
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-42
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 8,246 6,950 Send a thread interrupt signal to reactor-http-epoll-42. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-42
reactor-http-epoll-56
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-56
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 8,234 6,970 Send a thread interrupt signal to reactor-http-epoll-56. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-56
reactor-http-epoll-60
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-60
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 7,509 6,270 Send a thread interrupt signal to reactor-http-epoll-60. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-60
reactor-http-epoll-74
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-74
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 7,384 6,040 Send a thread interrupt signal to reactor-http-epoll-74. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-74
reactor-http-epoll-79
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-79
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 8,363 7,020 Send a thread interrupt signal to reactor-http-epoll-79. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-79
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) 6,648 5,670 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-94
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-94
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 7,020 5,910 Send a thread interrupt signal to reactor-http-epoll-94. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-94
reactor-http-epoll-98
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-98
 yes 5 RUNNABLERUNNABLE app//io.netty.channel.epoll.Native.epollWait(Native Method) 5,810 4,700 Send a thread interrupt signal to reactor-http-epoll-98. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread reactor-http-epoll-98
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) 18 10 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) 286 180 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) 2,320 1,600 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) 1,127 800 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) 1,974 1,360 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:551)
 XNIO-1 I/O-12
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 1,307 1,000 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) 2,649 1,770 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) 715 470 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) 243 170 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) 1,608 1,080 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) 4,329 2,930 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) 1,295 880 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:551)
 XNIO-1 I/O-4
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 1,801 1,190 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:551)
 XNIO-1 I/O-5
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 3,164 2,250 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:551)
 XNIO-1 I/O-6
 no 5 RUNNABLERUNNABLE java.base@11.0.23/sun.nio.ch.EPoll.wait(Native Method) 1,686 1,260 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) 1,110 740 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) 1,884 1,280 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) 2,965 2,060 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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-1
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 28,353 25,900 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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-10
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 14,962 14,020 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-11
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-11
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 14,892 13,620 Send a thread interrupt signal to XNIO-1 task-11. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-11
XNIO-1 task-12
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-12
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 26,805 24,440 Send a thread interrupt signal to XNIO-1 task-12. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-12
XNIO-1 task-13
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-13
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 11,122 10,180 Send a thread interrupt signal to XNIO-1 task-13. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-13
XNIO-1 task-14
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-14
 no 5 RUNNABLERUNNABLE java.base@11.0.23/java.lang.Thread.dumpThreads(Native Method) 32,084 29,470 Send a thread interrupt signal to XNIO-1 task-14. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-14
XNIO-1 task-15
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-15
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 11,145 10,140 Send a thread interrupt signal to XNIO-1 task-15. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-15
XNIO-1 task-16
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-16
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 5,517 5,040 Send a thread interrupt signal to XNIO-1 task-16. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-16
XNIO-1 task-17
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-17
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 11,703 10,740 Send a thread interrupt signal to XNIO-1 task-17. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-17
XNIO-1 task-18
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-18
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 19,150 17,440 Send a thread interrupt signal to XNIO-1 task-18. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-18
XNIO-1 task-19
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-19
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 10,818 9,850 Send a thread interrupt signal to XNIO-1 task-19. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-19
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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-2
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 13,315 12,250 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-20
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-20
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 4,500 4,090 Send a thread interrupt signal to XNIO-1 task-20. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-20
XNIO-1 task-21
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-21
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 10,170 9,290 Send a thread interrupt signal to XNIO-1 task-21. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-21
XNIO-1 task-22
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-22
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 6,032 5,530 Send a thread interrupt signal to XNIO-1 task-22. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-22
XNIO-1 task-23
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-23
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 7,332 6,750 Send a thread interrupt signal to XNIO-1 task-23. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-23
XNIO-1 task-24
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-24
 no 5 TIMED_WAITINGTIMED_WAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 12,638 11,380 Send a thread interrupt signal to XNIO-1 task-24. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-24
XNIO-1 task-25
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-25
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 285 250 Send a thread interrupt signal to XNIO-1 task-25. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-25
XNIO-1 task-26
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-26
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 11,536 10,530 Send a thread interrupt signal to XNIO-1 task-26. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-26
XNIO-1 task-27
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-27
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 21,063 19,560 Send a thread interrupt signal to XNIO-1 task-27. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-27
XNIO-1 task-29
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-29
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 13,672 12,600 Send a thread interrupt signal to XNIO-1 task-29. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-29
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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-3
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 24,740 22,750 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-30
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-30
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 10,309 9,350 Send a thread interrupt signal to XNIO-1 task-30. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-30
XNIO-1 task-31
java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-31
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 3,492 3,180 Send a thread interrupt signal to XNIO-1 task-31. The thread can test Thread.currentThread().isInterrupted() to stop itself. Kill the thread XNIO-1 task-31
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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-4
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 14,575 13,350 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/jdk.internal.misc.Unsafe.park(Native Method)
java.base@11.0.23/java.util.concurrent.locks.LockSupport.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-5
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 13,721 12,570 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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-6
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 20,989 19,170 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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-7
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 30,097 27,750 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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-8
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 4,029 3,600 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.park(Unknown Source)
app//org.jboss.threads.EnhancedQueueExecutor$PoolThreadNode.park(EnhancedQueueExecutor.java:2194)
app//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1481)
java.base@11.0.23/java.lang.Thread.run(Unknown Source)
 XNIO-1 task-9
 no 5 WAITINGWAITING java.base@11.0.23/jdk.internal.misc.Unsafe.park(Native Method) 8,498 7,760 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: 7 ms
Memory overhead estimate: < 1 Mb
Disk usage: 2 Mb     Purge the obsolete files

JavaMelody 1.90.0
Debugging logs

Only the last 50 messages are displayed
Fri Oct 03 00:27:36 BRT 2025     DEBUG     JavaMelody listener init done in 5 ms
Fri Oct 03 00:27:37 BRT 2025     DEBUG     rest template interceptor initialized
Fri Oct 03 00:27:38 BRT 2025     DEBUG     JavaMelody filter init started
Fri Oct 03 00:27:38 BRT 2025     DEBUG     OS: Linux unknown, amd64/64
Fri Oct 03 00:27:38 BRT 2025     DEBUG     Java: OpenJDK Runtime Environment, 11.0.23+9
Fri Oct 03 00:27:38 BRT 2025     DEBUG     Server: Undertow - 2.1.4.Final
Fri Oct 03 00:27:38 BRT 2025     DEBUG     Webapp context:
Fri Oct 03 00:27:38 BRT 2025     DEBUG     JavaMelody version: 1.90.0
Fri Oct 03 00:27:38 BRT 2025     DEBUG     JavaMelody classes loaded from: file:/app/libs/javamelody-core-1.90.0.jar
Fri Oct 03 00:27:38 BRT 2025     DEBUG     Application type: Spring Boot
Fri Oct 03 00:27:38 BRT 2025     DEBUG     Application version: null
Fri Oct 03 00:27:38 BRT 2025     DEBUG     Host: ip-10-0-10-150.ec2.internal@10.0.10.150
Fri Oct 03 00:27:38 BRT 2025     DEBUG     log listeners initialized
Fri Oct 03 00:27:38 BRT 2025     DEBUG     datasources found in JNDI: []
Fri Oct 03 00:27:38 BRT 2025     DEBUG     JPA persistence provider resolver initialized
Fri Oct 03 00:27:38 BRT 2025     DEBUG     counters initialized
Fri Oct 03 00:27:38 BRT 2025     DEBUG     counters data read from files in /tmp/javamelody/_ip-10-0-10-150.ec2.internal
Fri Oct 03 00:27:38 BRT 2025     DEBUG     collect task scheduled every 60s
Fri Oct 03 00:27:38 BRT 2025     DEBUG     first collect of data done
Fri Oct 03 00:27:38 BRT 2025     DEBUG     JavaMelody filter init done in 161 ms
Fri Oct 03 02:35:49 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:35:50 BRT 2025     DEBUG     Action 'KILL_THREAD' executed. Result: Thread Finalizer killed
Fri Oct 03 02:35:50 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:35:51 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:35:51 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:35:52 BRT 2025     DEBUG     Action 'KILL_THREAD' executed. Result: Thread reactor-http-epoll-42 killed
Fri Oct 03 02:35:52 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:35:52 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:35:53 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread not found
Fri Oct 03 02:35:53 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:57 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:57 BRT 2025     DEBUG     Action 'KILL_THREAD' executed. Result: Thread XNIO-1 task-28 killed
Fri Oct 03 02:36:57 BRT 2025     DEBUG     Action 'KILL_THREAD' executed. Result: Thread reactor-http-epoll-79 killed
Fri Oct 03 02:36:57 BRT 2025     DEBUG     Action 'KILL_THREAD' executed. Result: Thread reactor-http-epoll-135 killed
Fri Oct 03 02:36:57 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: I will not interrupt myself
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:58 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:59 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:59 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:59 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:59 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent
Fri Oct 03 02:36:59 BRT 2025     DEBUG     Action 'SEND_THREAD_INTERRUPT' executed. Result: Thread interrupt signal sent