Statistics of JavaMelody monitoring taken at 9/27/25, 6:37 PM on _ip-10-0-5-13.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 day since midnight

6,325 hits/min on 11 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/cte/credito-pis-cofins-frete-insumo-aliquota-zero/{cnpj}/period GET	97	11,610	14	596	23	94	1	258	0.00	0	1	10
/api/consumo-documentos-conta/ GET	0	1	1,336	1,336	0	0	125	13,716	0.00	0	1	1,205
/api/comercial/total-oportunidade/{cnpj} POST	0	1	1,061	1,061	0	2	360	43,179	0.00	8	18	646
/api/consumo-documentos-conta GET	0	1	640	640	0	0	60	3,287	0.00	0	1	551
/api/document/keys POST	0	3	70	108	33	0	21	4,415	0.00	0	1	38
/api/etiqueta/listar POST	0	1	192	192	0	0	93	18,032	0.00	1	1	3
/api/regularize/divida-ativa/{cnpj}/total POST	0	5	36	66	17	0	6	856	0.00	0	1	17
/actuator/health GET	0	9	7	33	9	0	4	454	0.00	0	0	0
/api/feature-flag/todas GET	0	1	23	23	0	0	16	2,396	0.00	0	1	2
Error404	0	1	4	4	0	0	4	599	100.00	0	0	0
/api/server/publico/version GET	0	1	3	3	0	0	3	623	0.00	0	0	0

Statistics sql - 1 day since midnight

6,328 hits/min on 12 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of system error
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 ?	97	11,610	10	372	19	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 ?	1	2	878	1,205	462	0.00
select cnpjconsol0_.id as id1_2_, cnpjconsol0_.cnpj as cnpj2_2_, cnpjconsol0_.data as data3_2_, cnpjconsol0_.data_processamento as data_pro4_2_, cnpjconsol0_.duracao_ultimo_processamento as duracao_5_2_, cnpjconsol0_.inscricao_estadual as inscrica6_2_, cnpjconsol0_.periodo as periodo7_2_, cnpjconsol0_.tipo_consolidacao as tipo_con8_2_ from public.cnpj_consolidation cnpjconsol0_ where cnpjconsol0_.cnpj=? and (cnpjconsol0_.tipo_consolidacao in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (cnpjconsol0_.periodo in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	0	1	555	555	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	5	17	22	4	0.00
select cnpjconsol0_.id as id1_2_, cnpjconsol0_.cnpj as cnpj2_2_, cnpjconsol0_.data as data3_2_, cnpjconsol0_.data_processamento as data_pro4_2_, cnpjconsol0_.duracao_ultimo_processamento as duracao_5_2_, cnpjconsol0_.inscricao_estadual as inscrica6_2_, cnpjconsol0_.periodo as periodo7_2_, cnpjconsol0_.tipo_consolidacao as tipo_con8_2_ from public.cnpj_consolidation cnpjconsol0_ where cnpjconsol0_.cnpj=? and (cnpjconsol0_.tipo_consolidacao in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (cnpjconsol0_.periodo is null)	0	1	53	53	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	45	45	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	38	38	0	0.00
select ofertaopor0_.id as col_0_0_, ofertaopor0_.status_indicador_oferta as col_1_0_ from oferta_oportunidade_tese ofertaopor0_ where ofertaopor0_.cnpj_cliente_oferta=? and ofertaopor0_.tipo_consolidacao_oferta=?	0	15	2	8	1	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	33	33	0	0.00
select etiqueta0_.id as id1_48_, etiqueta0_.cnpj_empresa as cnpj_emp2_48_, etiqueta0_.cor_etiqueta as cor_etiq3_48_, etiqueta0_.etiqueta_padrao as etiqueta4_48_, etiqueta0_.id_conta as id_conta5_48_, etiqueta0_.nome_etiqueta as nome_eti6_48_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=1548 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	1	3	3	0	0.00
select featurefla0_.code as code1_62_, featurefla0_.value as value2_62_ from feature_flag featurefla0_	0	1	2	2	0	0.00
select configurac0_.id as id1_35_, configurac0_.ativa as ativa2_35_, configurac0_.descricao as descrica3_35_, configurac0_.grupo as grupo4_35_, configurac0_.habilitar_taxa_selic as habilita5_35_, configurac0_.nome_atributo_consolidacao as nome_atr6_35_, configurac0_.nome_fila as nome_fil7_35_, configurac0_.tipo_consolidacao as tipo_con8_35_, configurac0_.tipo_imposto as tipo_imp9_35_, configurac0_.tipo_tese as tipo_te10_35_, configurac0_.vigencia_final as vigenci11_35_, configurac0_.vigencia_inicial as vigenci12_35_ from configuracao_consolidacao configurac0_	0	1	2	2	0	0.00

Statistics spring - 1 day since midnight

12,642 hits/min on 19 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)
CreditoPisCofinsFreteInsumosAliquotaZeroController.consultar	48	11,610	13	382	20	28	0	48	0.00	1	10
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar	48	11,610	13	382	20	24	0	46	0.00	1	10
ConsumoDocumentosContaEmpresaController.cosumoDocumentosPorConta	0	2	974	1,322	491	5	82	7,676	0.00	1	878
ConsumoDocumentosContaEmpresaServiceImp.consultarQuantidadeDocumentosUtilizadosNoMesConta	0	2	970	1,314	485	4	79	6,920	0.00	1	878
ComercialController.consultarTotalOportunidadeCnpj	0	1	1,045	1,045	0	10	344	41,343	0.00	18	646
DocumentService.consultarTotalOportunidadeCnpj	0	1	1,043	1,043	0	10	342	40,741	0.00	18	646
CnpjConsolidationServiceImpl.findOportunidadeTeseJuridicaCnpj	0	1	286	286	0	7	238	28,130	0.00	15	36
DocumentController.listDocumentsByKeys	0	3	66	99	29	1	17	4,198	0.00	1	38
DocumentService.listDocumentsByKeys	0	3	58	81	20	1	13	2,776	0.00	1	38
EtiquetaController.listarEtiquetas	0	1	164	164	0	2	75	16,754	0.00	1	3
EtiquetaServiceImpl.consultarEtiquetas	0	1	162	162	0	2	73	15,895	0.00	1	3
DividaAtivaRegularizeController.findDividaAtivaByCnpj	0	5	31	63	17	0	2	335	0.00	1	17
DividaAtivaRegularizeServiceImpl.findDividaAtivaByCnpj	0	5	30	62	17	0	1	197	0.00	1	17
CoreApiServiceImpl.consultaContasPorIds	0	1	89	89	0	0	10	2,185	0.00	0	0
EtiquetaQueryService.listarEtiquetas	0	1	24	24	0	0	14	2,534	0.00	1	3
FeatureFlagController.listarTodas	0	1	21	21	0	0	13	2,181	0.00	1	2
FeatureFlagService.listarTodas	0	1	10	10	0	0	5	774	0.00	1	2
BasicErrorController.error	0	1	3	3	0	0	3	1,324	0.00	0	0
ServerController.version	0	1	1	1	0	0	1	573	0.00	0	0

Statistics http system errors - 1 day since midnight

0 hits/min on 1 errors       Details       Last errors      

Statistics system errors logs - 1 day since midnight

22 hits/min on 41 errors       Details       Last errors