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

Statistics of JavaMelody monitoring taken at 8/25/25, 5:42 AM on _ip-10-0-13-7.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

16 hits/min on 17 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)
/actuator/health GET	27	4,786	4	11	3	19	0	57	0.00	0	0	0
/api/document/keys POST	22	486	36	655	61	25	4	1,779	0.00	65	1	25
/api/download/nfse/pdf-zip-online POST	15	18	681	1,994	567	11	58	8,938	0.00	15	2	191
/api/reports/nfe/{key} GET	13	79	135	715	130	23	26	12,472	22.78	9	2	101
/api/reports/cte/{key} GET	7	49	117	507	110	8	14	3,240	73.47	2	1	94
/api/document/{cnpj}/nfse/period GET	6	176	26	170	31	5	2	698	0.00	0	1	18
/api/reports/nfse/{key} GET	2	3	774	867	98	1	31	5,242	0.00	45	2	214
/api/documento-ausente-download-lote/{tipo}/{cnpj}/importar-chaves-acesso POST	1	6	132	345	104	2	42	4,863	0.00	0	6	31
/api/document/{cnpj}/products-nfe GET	0	3	194	366	148	0	4	322	0.00	0	1	182
/api/document/{cnpj}/v2/nfe/ POST	0	11	52	188	45	0	5	963	0.00	1	2	42
/api/document/{cnpj}/v2/cte/ POST	0	11	27	90	21	0	7	1,111	0.00	1	2	15
/api/document/{key}/sped-document GET	0	11	16	33	8	0	2	287	0.00	0	1	7
/api/download/cte/xml/{key} GET	0	2	29	38	12	0	11	1,065	0.00	4	2	9
/api/document/{cnpj}/find-nota-emitida-periodo POST	0	2	22	29	9	0	5	625	0.00	0	1	10
/api/document/buscar-cte-por-chave/{key} GET	0	2	18	25	9	0	8	739	0.00	0	1	7
Error404	0	6	2	3	0	0	1	401	100.00	0	0	0
/api/server/publico/version GET	0	1	0	0	0	0	0	38	0.00	0	0	0

Statistics sql - 1 day since midnight

3 hits/min on 41 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of system error
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 ?	33	458	24	542	47	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_14_, documentnf0_.type as type2_14_, documentnf0_.key as key3_14_, documentnf0_.nsu as nsu4_14_, documentnf0_.protocol as protocol5_14_, documentnf0_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ?))	21	79	94	648	120	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?))	13	49	92	437	88	0.00
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 ?	9	176	18	143	29	0.00
select documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where documentnf0_.issuer_cpfcnpj=? and documentnf0_.addressee_cpfcnpj=? and documentnf0_.rps_number=? and documentnf0_.rps_serie=? and (documentnf0_.type in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	9	18	180	777	189	0.00
select 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 ?)	1	95	6	40	5	0.00
select documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	1	3	207	350	127	0.00
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))	1	3	182	356	150	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_14_, documentnf0_.type as type2_14_, documentnf0_.key as key3_14_, documentnf0_.nsu as nsu4_14_, documentnf0_.protocol as protocol5_14_, documentnf0_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ 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 ?	1	11	34	137	34	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	2	147	172	35	0.00
select canhotonot0_.id as id1_26_, canhotonot0_.canhoto_importacao_id as canhoto_6_26_, canhotonot0_.created_at as created_2_26_, canhotonot0_.documento_chave as document3_26_, canhotonot0_.empresa_cnpj as empresa_4_26_, canhotonot0_.numero_nota as numero_n5_26_ 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	61	4	31	5	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	2	118	144	36	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	2	104	122	25	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	2	65	124	83	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and substring(documentct0_.tomador4_cnpj, 1, 8)=? limit ?	0	11	9	29	6	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	2	49	92	60	0.00
insert into documento_ausente_download (chave_acesso, documento_ausente_download_lote_id, quantidade_tentativas, status, ultima_tentativa) values (?, ?, ?, ?, ?)	0	18	5	11	1	0.00
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	7	17	4	0.00
select key, type, cast(data->'header'->>'version' as text) as version, cast(data->'header'->>'endsDate' as date) as periodo, cast(data->'header'->>'endsDate' as date) as periodoFinal, cast(data->'header'->>'startsDate' as date) as periodoInicial, cast(data->'header'->>'ecdType' as text) as ecdType, cast(data->'header'->>'finalType' as text) as purpose, name_file as nameFile, cnpj, cast(data->'header'->>'deliveryDate' as timestamp) as deliveryDate, info->>'originalFileName' as fileNameOriginal, inscricao_estadual as inscricaoEstadual from document where key = ? and type like 'SPED%' and data_emissao between ? and ?	0	11	7	19	5	0.00
select 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	11	5	7	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	2	28	29	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	2	28	36	11	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	2	18	27	12	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	3	10	13	3	0.00
insert into documento_ausente_download_lote (data_atualizacao, data_criacao, checksum, cnpj, nome, planilha, quantidade_documentos, status, tipo_documento) values (?, ?, ?, ?, ?, ?, ?, ?, ?)	0	6	5	11	2	0.00
/* BATCH */ update documento_ausente_download_lote set data_atualizacao=?, data_criacao=?, checksum=?, cnpj=?, nome=?, planilha=?, quantidade_documentos=?, status=?, tipo_documento=? where id=?	0	6	4	5	0	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?)) and (documentct0_.data_emissao between ? and ?)	0	4	6	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	2	11	13	2	0.00
WITH 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	2	10	15	6	0.00
select documentoa0_.chave_acesso as col_0_0_ from documento_ausente_download documentoa0_ where documentoa0_.chave_acesso in (? , ? , ? , ?)	0	1	13	13	0	0.00
select documentoa0_.chave_acesso as col_0_0_ from documento_ausente_download documentoa0_ where documentoa0_.chave_acesso in (?)	0	2	5	6	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	11	11	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	10	10	0	0.00
select 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	2	4	5	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	8	8	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	2	3	4	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	7	7	0	0.00
select documentoa0_.chave_acesso as col_0_0_ from documento_ausente_download documentoa0_ where documentoa0_.chave_acesso in (? , ? , ? , ? , ? , ?)	0	1	6	6	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	5	5	0	0.00
select documentoa0_.chave_acesso as col_0_0_ from documento_ausente_download documentoa0_ where documentoa0_.chave_acesso in (? , ? , ?)	0	1	4	4	0	0.00
select documentoa0_.chave_acesso as col_0_0_ from documento_ausente_download documentoa0_ where documentoa0_.chave_acesso in (? , ? , ? , ? , ?)	0	1	4	4	0	0.00

Statistics spring - 1 day since midnight

5 hits/min on 38 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.listDocumentsByKeys	13	486	34	605	56	10	2	1,435	0.00	1	25
DocumentService.listDocumentsByKeys	11	486	31	603	56	10	2	1,429	0.00	1	25
DownloadController.downloadNfsePdfZipOnline	9	18	671	1,979	563	8	57	8,882	0.00	2	191
DownloadService.downloadNfsePdfZip	9	18	671	1,979	563	8	57	8,780	0.00	2	191
GeradorPdfNfseServiceImpl.generatePdfByNfseDTO	9	18	669	1,977	562	7	55	8,668	0.00	2	191
ReportController.generateNfeReport	8	79	130	710	129	16	25	12,317	0.00	2	101
GeradorPdfNfeServiceImpl.generatePdfByKey	8	79	130	710	129	16	25	12,315	0.00	2	101
FiscalntelligenceCoreService.buscarServicos	5	21	345	923	254	0	0	124	0.00	0	0
ReportController.generateCteReport	4	49	111	502	109	5	13	2,956	0.00	1	94
GeradorPdfCteServiceImpl.generatePdfByKey	4	49	111	502	109	5	13	2,953	0.00	1	94
DocumentController.listNfseByCnpjAndPeriod	3	176	25	170	31	2	1	502	0.00	1	18
DocumentService.listNfseByCnpjAndPeriod	3	176	22	167	31	1	1	495	0.00	1	18
GeradorPdfNfseServiceImpl.generatePdfByKey	1	3	768	863	101	0	30	5,140	0.00	2	214
ReportController.generateReport	1	3	768	863	101	0	30	5,147	0.00	2	214
NextGenService.findAtividadeEconomica	0	21	58	218	49	0	0	17	0.00	0	0
DocumentoAusenteDownloadLoteController.importarAPartirChavesAcesso	0	6	128	334	101	1	38	4,246	0.00	6	31
DocumentoAusenteDownloadLoteService.salvarLoteComChavesDeAcesso	0	6	128	332	100	1	37	4,099	0.00	6	31
DocumentController.getProductsNfe	0	3	192	363	148	0	2	107	0.00	1	182
DocumentService.findProductDescriptionByCnpjAndCfop	0	3	187	360	149	0	1	99	0.00	1	182
DocumentController.getDocumentsNFEV2	0	11	50	177	42	0	3	398	0.00	2	42
DocumentNfeViewQueryService.findDocumentsWithData	0	11	45	171	41	0	2	390	0.00	2	42
NextGenService.obterTodasCidades	0	1	399	399	0	0	8	2,416	0.00	0	0
DocumentController.getDocumentsCte	0	11	23	64	13	0	3	369	0.00	2	15
DocumentCteViewQueryService.findDocumentsWithData	0	11	19	59	13	0	3	351	0.00	2	15
SalvaChavesAcessoDocumentoAusenteDownloadService.salvar	0	6	33	65	17	0	5	385	0.00	4	22
DocumentController.findSpedByKey	0	11	16	32	8	0	1	91	0.00	1	7
DocumentService.findSpedByKey	0	11	13	30	8	0	1	84	0.00	1	7
SalvaDocumentoAusenteDownloadLoteService.salvar	0	6	23	74	24	0	10	1,830	0.00	1	5
SalvaDocumentoAusenteDownloadLoteService.concluirImportacaoChaves	0	6	10	20	4	0	2	275	0.00	1	4
DownloadController.retornaBytesXmlZipadoPelaChaveCte	0	2	25	34	12	0	10	934	0.00	2	9
DownloadService.getFileXmlInS3ByTypeAndKey	0	2	24	33	12	0	10	925	0.00	2	9
DocumentCteViewQueryService.findByKey	0	4	11	14	3	0	3	236	0.00	1	6
DocumentController.findNotaEmitidaNfeCfeCteByCnpjPeriod	0	2	19	26	9	0	2	138	0.00	1	10
DocumentService.findNotaEmitidaNfeCfeCteByCnpjPeriod	0	2	16	22	8	0	2	130	0.00	1	10
DocumentController.getCteByKey	0	2	14	18	4	0	3	247	0.00	1	7
BasicErrorController.error	0	62	0	0	0	0	0	140	0.00	0	0
AuditorAwareImpl.getCurrentAuditor	0	12	0	1	0	0	0	46	0.00	0	0
ServerController.version	0	1	0	0	0	0	0	0	0.00	0	0

Statistics http system errors - 1 day since midnight

0 hits/min on 8 errors       Details       Last errors