Statistics of JavaMelody monitoring taken at 9/28/25, 8:45 AM on _ip-10-0-9-82.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

1,034 hits/min on 7 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	90	4,061	21	2,832	138	85	1	293	0.00	0	1	10
/api/comercial/total-oportunidade/{cnpj} POST	6	5	1,316	2,464	746	10	148	32,615	0.00	8	17	1,154
/api/regularize/divida-ativa/{cnpj}/total POST	2	8	283	2,044	711	1	13	2,091	0.00	0	1	18
/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST	0	2	241	474	329	0	6	1,334	0.00	0	1	231
/api/etiqueta/listar POST	0	1	258	258	0	1	85	18,301	0.00	1	1	84
/actuator/health GET	0	24	7	31	6	0	2	206	0.00	0	0	0
/api/feature-flag/todas GET	0	2	31	53	30	0	19	3,018	0.00	0	1	7

Statistics sql - 1 day since midnight

1,049 hits/min on 9 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 ?	86	4,061	10	954	44	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 (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	10	5	1,005	2,081	667	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)	1	5	106	205	57	0.00
SELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ORDER BY d.key limit ?	0	2	231	458	321	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	73	2	5	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	8	18	21	1	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	84	84	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	5	3	5	0	0.00
select featurefla0_.code as code1_62_, featurefla0_.value as value2_62_ from feature_flag featurefla0_	0	2	7	12	6	0.00

Statistics spring - 1 day since midnight

2,059 hits/min on 15 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	44	4,061	14	997	46	22	0	52	0.00	1	10
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar	43	4,061	14	996	46	20	0	50	0.00	1	10
ComercialController.consultarTotalOportunidadeCnpj	4	5	1,311	2,462	745	18	142	31,780	0.00	17	1,154
DocumentService.consultarTotalOportunidadeCnpj	4	5	1,310	2,462	745	18	141	31,659	0.00	17	1,154
CnpjConsolidationServiceImpl.findOportunidadeTeseJuridicaCnpj	0	5	129	246	65	12	91	22,648	0.00	14	39
CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	0	2	238	469	326	0	3	735	0.00	1	231
CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	0	2	237	468	325	0	2	420	0.00	1	231
DividaAtivaRegularizeController.findDividaAtivaByCnpj	0	8	50	193	59	0	4	446	0.00	1	18
DividaAtivaRegularizeServiceImpl.findDividaAtivaByCnpj	0	8	49	189	58	0	4	360	0.00	1	18
EtiquetaController.listarEtiquetas	0	1	239	239	0	1	69	16,909	0.00	1	84
EtiquetaServiceImpl.consultarEtiquetas	0	1	237	237	0	1	67	16,045	0.00	1	84
EtiquetaQueryService.listarEtiquetas	0	1	100	100	0	0	14	2,654	0.00	1	84
CoreApiServiceImpl.consultaContasPorIds	0	1	92	92	0	0	9	2,193	0.00	0	0
FeatureFlagController.listarTodas	0	2	28	47	26	0	15	2,683	0.00	1	7
FeatureFlagService.listarTodas	0	2	21	37	22	0	11	1,915	0.00	1	7

Statistics http system errors - 1 day since midnight

Statistics system errors logs - 1 day since midnight

9 hits/min on 39 errors       Details       Last errors