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

Statistics of JavaMelody monitoring taken at 10/4/25, 11:17 PM on _ip-10-0-7-166.ec2.internal (application)

Update     PDF     Online help     Desktop     Choice of period :  Day  Week  Month  Year  All  Customized

From     to      (m/d/yy)     

Other charts

Statistics http - 1 week since midnight

0 hits/min on 14 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean size (Kb)	Mean hits sql	Mean time sql (ms)
/api/document/{cnpj}/products-nfe GET	41	4	13,470,986	13,534,915	55,322	0	6	1,314	100.00	0	1	13,470,978
/api/document/{cnpj}/v2/nfe POST	34	4	11,198,142	14,058,219	1,919,448	1	24	3,318	100.00	0	1	11,198,107
/api/etiqueta/listar POST	15	3	6,819,454	7,074,818	285,122	2	47	6,202	100.00	0	1	6,819,279
/api/document/{cnpj}/analise-servico-tomado POST	8	54	199,626	5,382,988	1,026,085	3	3	519	0.00	0	1	199,619
/api/cte/credito-pis-cofins-frete-insumo-aliquota-zero/{cnpj}/period GET	0	590	84	2,135	360	39	3	405	0.00	0	1	73
/api/consumo-documentos-conta/ GET	0	2	10,705	20,080	13,258	2	82	12,342	0.00	0	1	10,616
/api/consumo-documentos-conta GET	0	2	10,310	19,958	13,643	0	11	581	0.00	0	1	10,277
/actuator/health GET	0	3,210	5	108	5	44	0	60	0.00	0	0	0
/api/document/keys POST	0	3	2,364	4,788	2,117	2	48	4,959	0.00	251	1	2,220
/api/regularize/divida-ativa/{cnpj}/total POST	0	1	1,815	1,815	0	0	14	2,203	0.00	0	1	1,577
/api/document/{cnpj}/analise-servico-prestado POST	0	7	41	129	40	1	9	2,224	0.00	0	1	27
/api/feature-flag/todas GET	0	2	38	67	41	0	13	1,944	0.00	0	1	19
Error404	0	4	3	5	1	0	2	477	100.00	0	0	0
/api/server/publico/version GET	0	4	1	4	1	0	1	218	0.00	0	0	0

Statistics sql - 1 week since midnight

0 hits/min on 13 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of system error
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))	41	4	13,470,978	13,534,904	55,321	100.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.cnpj as cnpj12_15_, documentnf0_.cnpj_addressee as cnpj_ad13_15_, documentnf0_.cnpj_carrier as cnpj_ca14_15_, documentnf0_.cte_key as cte_key15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.key in (?)) and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	23	3	10,244,757	10,487,134	270,314	100.00
select etiqueta0_.id as id1_49_, etiqueta0_.cnpj_empresa as cnpj_emp2_49_, etiqueta0_.cor_etiqueta as cor_etiq3_49_, etiqueta0_.etiqueta_padrao as etiqueta4_49_, etiqueta0_.id_conta as id_conta5_49_, etiqueta0_.nome_etiqueta as nome_eti6_49_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=1548 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	15	3	6,819,279	7,074,635	285,117	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.cnpj as cnpj12_15_, documentnf0_.cnpj_addressee as cnpj_ad13_15_, documentnf0_.cnpj_carrier as cnpj_ca14_15_, documentnf0_.cte_key as cte_key15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	10	1	14,058,159	14,058,159	0	100.00
SELECT 'TOMADO' AS tipoServico, DATE_TRUNC('month', d.data_emissao) AS periodo, SUM(CAST(d.info ->> 'value' AS NUMERIC)) AS valor FROM document d WHERE d.group_type = 'NFSE' AND d.cnpj_addressee = ? AND (d.info ->> 'status' = 'NORMAL' OR d.info ->> 'status' = 'N') AND (? = 'nao_filtrar_ie' OR d.data -> 'nfe' -> 'infNFe' -> 'emit' ->> 'ie' =?) AND d.data_emissao between ? and ? GROUP BY DATE_TRUNC('month', d.data_emissao) ORDER BY DATE_TRUNC('month', d.data_emissao)	8	54	199,619	5,382,980	1,026,084	0.00
SELECT 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 ?	0	590	73	2,123	351	0.00
WITH empresasConta AS (SELECT cnpj FROM revizia_vw_resumo_conta_empresa WHERE conta_id = ?) SELECT c.* FROM consumo_documentos_conta_empresa c INNER JOIN empresasConta ec ON c.cnpj_empresa = ec.cnpj WHERE c.data_consumo BETWEEN ? AND ?	0	4	10,447	19,944	10,955	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT JOIN document_status ds ON d.key = ds.key AND d.cnpj_issuer = ds.cnpj_issuer AND d.protocol = ds.protocol AND d.nsu = ds.nsu AND d.type = ds.type WHERE d.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	4,655	4,655	0	0.00
SELECT SUM(dar.valor_consolidado) AS dividaAtiva FROM divida_ativa_regularize dar WHERE dar.cnpj = ? AND dar.valor_consolidado IS NOT NULL	0	1	1,577	1,577	0	0.00
SELECT 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	1,383	1,383	0	0.00
SELECT 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	623	623	0	0.00
SELECT 'PRESTADO' AS tipoServico, DATE_TRUNC('month', d.data_emissao) AS periodo, SUM(CAST(d.info ->> 'value' AS NUMERIC)) AS valor FROM document d WHERE d.group_type = 'NFSE' AND d.cnpj_issuer = ? AND (d.info ->> 'status' = 'NORMAL' OR d.info ->> 'status' = 'N') AND d.data_emissao between ? and ? GROUP BY DATE_TRUNC('month', d.data_emissao) ORDER BY DATE_TRUNC('month', d.data_emissao)	0	7	27	80	25	0.00
select featurefla0_.code as code1_63_, featurefla0_.value as value2_63_ from feature_flag featurefla0_	0	2	19	36	24	0.00

Statistics spring - 1 week since midnight

0 hits/min on 24 requests       Summary by class       Dependencies       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean hits sql	Mean time sql (ms)
DocumentController.getProductsNfe	19	4	13,470,984	13,534,913	55,322	0	5	1,174	0.00	1	13,470,978
DocumentService.findProductDescriptionByCnpjAndCfop	19	4	13,470,983	13,534,911	55,322	0	4	665	0.00	1	13,470,978
DocumentController.getDocumentsNFEV2	15	4	11,198,138	14,058,207	1,919,443	2	19	2,626	0.00	1	11,198,107
DocumentNfeViewQueryService.findDocumentsWithData	15	4	11,198,134	14,058,203	1,919,442	2	16	2,041	0.00	1	11,198,107
EtiquetaController.listarEtiquetas	7	3	6,819,451	7,074,813	285,121	5	44	6,060	0.00	1	6,819,279
EtiquetaServiceImpl.consultarEtiquetas	7	3	6,819,450	7,074,810	285,120	5	43	5,769	0.00	1	6,819,279
EtiquetaQueryService.listarEtiquetas	7	3	6,819,290	7,074,651	285,120	0	6	799	0.00	1	6,819,279
DocumentController.analiseServicoTomado	3	54	199,624	5,382,985	1,026,085	2	1	59	0.00	1	199,619
DocumentService.findAnaliseServicoTomado	3	54	199,621	5,382,981	1,026,084	2	1	52	0.00	1	199,619
CreditoPisCofinsFreteInsumosAliquotaZeroController.consultar	0	590	81	2,135	359	27	1	65	0.00	1	73
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar	0	590	80	2,134	359	25	1	61	0.00	1	73
ConsumoDocumentosContaEmpresaController.cosumoDocumentosPorConta	0	4	10,499	20,066	10,982	6	42	6,118	0.00	1	10,447
ConsumoDocumentosContaEmpresaServiceImp.consultarQuantidadeDocumentosUtilizadosNoMesConta	0	4	10,498	20,059	10,980	6	40	5,738	0.00	1	10,447
DocumentController.listDocumentsByKeys	0	3	2,343	4,738	2,092	3	26	3,666	0.00	1	2,220
DocumentService.listDocumentsByKeys	0	3	2,338	4,735	2,093	3	26	3,658	0.00	1	2,220
DividaAtivaRegularizeController.findDividaAtivaByCnpj	0	1	1,807	1,807	0	0	8	1,444	0.00	1	1,577
DividaAtivaRegularizeServiceImpl.findDividaAtivaByCnpj	0	1	1,805	1,805	0	0	6	761	0.00	1	1,577
CoreApiServiceImpl.consultaContasPorIds	0	3	105	106	0	0	8	1,137	0.00	0	0
DocumentController.analiseServicoPrestado	0	7	36	114	35	1	5	1,562	0.00	1	27
DocumentService.findAnaliseServicoPrestado	0	7	32	102	32	0	3	942	0.00	1	27
FeatureFlagController.listarTodas	0	2	36	64	39	0	12	1,789	0.00	1	19
FeatureFlagService.listarTodas	0	2	29	53	33	0	7	1,033	0.00	1	19
BasicErrorController.error	0	15	1	6	2	0	1	249	0.00	0	0
ServerController.version	0	4	0	2	1	0	0	143	0.00	0	0

Statistics http system errors - 1 week since midnight

0 hits/min on 3 errors       Details       Last errors      

Statistics system errors logs - 1 week since midnight

0 hits/min on 35 errors       Details       Last errors