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

Statistics of JavaMelody monitoring taken at 9/8/25, 6:02 PM on _ip-10-0-4-62.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

291 hits/min on 102 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	17	88,918	10	568	7	5	0	242	0.00	0	1	7
/api/document/{cnpj}/v2/nfe POST	17	1,083	885	67,223	4,365	5	14	5,962	0.00	69	2	861
/api/reports/nfe/{key} GET	7	3,918	106	1,288	39	37	28	16,813	0.46	11	2	72
/api/consumo-documentos-conta/ GET	7	334	1,211	2,643	205	9	82	29,405	0.30	0	0	1,134
/api/document/keys POST	7	2,667	145	1,239	141	21	24	8,591	0.00	414	1	117
/api/processamento-carregamento-documentos/processamentos POST	6	10	34,471	80,009	23,449	0	1	285	0.00	5	0	0
/api/document/{cnpj}/v2/cte POST	4	267	991	56,900	5,294	0	4	1,456	0.00	23	2	979
/api/processamento-carregamento-documentos/carregamentos POST	3	11	15,388	50,514	14,453	0	10	1,155	0.00	0	5	1,379
/api/nfe-manifestacao/{cnpj}/confirmar-operacao-nfe POST	2	29	5,641	68,619	16,948	0	50	6,240	0.00	0	7	95
/api/uploads3/publico/documents/trigger/success-upload/presigned/{fileName}/{idRequest} POST	2	9,007	14	597	14	4	1	567	0.00	0	2	7
/api/consumo-documentos-conta GET	2	332	383	1,917	230	0	4	1,337	0.00	0	1	373
/api/document/{cnpj}/analise-servico-prestado POST	2	1,549	71	1,714	200	0	1	493	0.00	0	1	67
/api/reports/nfse/{key} GET	1	133	760	2,263	225	1	26	5,667	1.50	21	2	69
/api/document/{cnpj}/documentos/quantidade POST	1	888	108	3,380	364	0	1	545	0.00	0	1	99
/api/document/codigos-servicos-nfse POST	1	165	575	45,954	3,800	0	2	370	0.00	0	2	566
/api/document/{cnpj}/v2/nfe-canhoto POST	1	116	698	25,890	2,666	0	14	6,224	0.00	69	2	670
/api/document/{cnpj}/nfse/period GET	1	3,650	19	1,219	39	2	2	685	0.00	0	1	12
/consolidacao/oportunidade-document GET	1	1	57,811	57,811	0	0	116	37,778	0.00	2,183	1	57,698
/api/document/{cnpj}/analise-representatividade-consolidada POST	1	79	700	4,166	936	0	6	2,254	7.59	8	1	13
/api/document/{cnpj}/v2/nfse POST	0	183	261	21,699	1,712	0	6	1,230	0.00	12	1	232
/api/uploads/{cnpj} GET	0	20	2,019	7,998	2,400	0	4	792	0.00	3	3	2,007
/api/document/{cnpj}/v2/cfe POST	0	7	5,708	35,933	13,354	0	11	2,985	0.00	43	2	5,691
Error404	0	75	491	36,422	4,205	0	1	307	100.00	0	0	488
/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST	0	110	284	1,395	369	0	1	591	0.00	0	1	280
/api/uploads3/documents/generate/multiple/presigned POST	0	23	1,350	11,365	3,343	0	62	8,882	0.00	264	414	1,165
/api/document/{cnpj}/obrigacoes POST	0	62	359	1,666	446	0	2	649	0.00	4	1	344
/api/document/{cnpj}/oportunidade-tese-juridica-consolidada-resumida POST	0	89	232	690	124	2	73	56,552	0.00	0	17	126
/actuator/health GET	0	2,484	8	447	17	0	0	60	0.00	0	0	0
/api/reports/cte/{key} GET	0	192	93	310	36	1	30	10,125	0.00	10	2	56
/api/importacao-canhoto/canhotos/{canhotoId}/confirmar-upload POST	0	216	71	379	52	0	9	1,085	0.00	0	3	10
/api/document/{cnpj}/analise-servico-tomado POST	0	872	15	420	19	0	1	496	0.00	0	1	11
/api/download/nfse/pdf-zip-online POST	0	21	647	2,258	536	0	17	3,819	0.00	15	2	133
/api/download/{cnpj}/solicitacoes GET	0	165	81	1,410	215	0	4	1,529	0.00	7	1	69
/api/document/bookKeepingCanBeProcessed GET	0	763	17	682	50	0	0	144	0.00	0	1	13
/api/nfe-manifestacao/{cnpj}/operacao-nao-realizada-nfe POST	0	1	13,158	13,158	0	0	270	28,843	0.00	0	3	140
/api/document/{cnpj}/analise-venda-devolucao POST	0	64	172	9,483	1,183	0	1	783	0.00	0	1	165
/api/cfe-periodo-importacao/paginado/{cnpj} POST	0	39	268	872	159	0	4	786	0.00	7	16	243
/api/etiqueta/listar POST	0	173	52	463	44	0	4	728	0.00	1	1	3
/api/analise-gerencial-servicos/{cnpj}/tomado/codigo-servico POST	0	2	2,950	5,732	3,934	0	8	1,209	0.00	2	1	83
/api/importacao-canhoto/{cnpj}/lotes/{loteId}/canhotos GET	0	135	41	225	32	0	2	342	0.00	0	8	33
/api/reports/nfse/{key}/SAO_PAULO GET	0	29	175	329	47	0	2	387	0.00	0	2	165
/api/download/nfe/xml/{key} GET	0	85	46	156	18	0	3	530	0.00	5	2	33
/api/document/{cnpj}/products-nfe GET	0	70	50	128	23	0	1	255	0.00	0	1	42
/api/document/{key}/sped-document GET	0	318	10	56	3	0	1	261	0.00	0	1	6
/api/importacao-canhoto/{cnpj}/lotes POST	0	97	35	94	9	0	4	879	0.00	2	1	7
/api/email/{cnpj}/NFE/{batchType}/{tipoEmailDocumento} POST	0	5	676	840	188	0	44	6,337	0.00	0	9	65
/api/feature-flag/todas GET	0	323	9	36	4	0	1	144	0.00	0	1	3
/api/cte-manifestacao/{cnpj}/desacordo-cte POST	0	4	752	843	118	0	37	3,932	0.00	0	3	32
/api/document/{cnpj}/cruzamento-efd-nfse POST	0	17	161	620	137	0	2	516	0.00	0	0	0
/api/solicitacao-documento-batch/{id}/{total} PUT	0	145	17	76	6	0	3	435	0.00	1	2	6
/api/document/{cnpj}/arquivo-entregue POST	0	1	2,407	2,407	0	0	13	4,121	0.00	14	1	2,390
/api/importacao-canhoto/lotes/{loteId}/presigned-urls POST	0	48	34	268	46	0	6	1,670	0.00	2	5	22
/api/etiqueta/associar POST	0	29	54	112	20	0	4	722	0.00	0	5	42
/api/importacao-canhoto/{cnpj}/canhotos/download/{canhotoId} GET	0	18	86	153	38	0	8	2,782	0.00	281	1	3
/api/download/cte/xml/{key} GET	0	49	30	461	63	0	2	285	0.00	4	2	14
/api/document/{cnpj}/documentos/grupo/quantidade POST	0	2	682	1,228	771	0	4	747	0.00	0	1	671
/api/regularize/divida-ativa/{cnpj}/total POST	0	17	80	242	88	0	1	414	0.00	0	1	74
/api/cfe-periodo-importacao/importar-planilha/{cnpj} POST	0	1	1,333	1,333	0	0	733	181,652	0.00	0	6	385
/api/document/{cnpj}/analise-compra-devolucao POST	0	28	45	508	98	0	1	802	0.00	0	1	40
/api/simples-nacional/reforma-tributaria POST	0	6	198	389	198	0	4	707	0.00	0	1	7
/api/regularize/divida-ativa/{cnpj} POST	0	7	156	309	106	0	6	762	0.00	0	21	144
/api/download-nfe-canhoto/{cnpj}/excel POST	0	1	1,097	1,097	0	0	72	12,066	0.00	0	15	301
/api/document/{year}/{cnpj}/speds GET	0	1	945	945	0	0	21	6,047	0.00	61	1	917
/api/consumo-documentos-conta/{cnpj} GET	0	2	349	351	2	0	3	630	0.00	0	1	335
/api/registrato-bcb/relatorio/{cnpj} GET	0	38	17	60	10	0	2	851	0.00	0	1	9
/api/comercial/total-oportunidade POST	0	3	200	337	173	0	29	8,076	0.00	0	42	170
/api/importacao-canhoto/lotes POST	0	48	11	37	4	0	1	153	0.00	0	1	4
/api/document/{cnpj}/v2/nfe/ POST	0	11	47	140	30	0	3	899	0.00	6	2	39
/api/document/{cnpj}/nfse/resumo POST	0	1	462	462	0	0	5	992	0.00	0	2	453
/api/document/{cnpj}/find-nota-emitida-periodo POST	0	38	11	19	2	0	1	506	0.00	0	1	5
/api/analise-venda-devolucao/nfe-canceladas/{cnpj} POST	0	1	451	451	0	0	13	3,706	0.00	0	2	430
/api/documento-ausente-download-lote/{tipo}/{cnpj} GET	0	6	52	108	38	0	7	968	0.00	2	7	40
/api/document/buscar-nfe-por-chave/{key} GET	0	8	34	38	2	0	2	510	0.00	7	1	27
/api/document/{cnpj}/solicitar-download-documentos-cancelados POST	0	3	87	125	33	0	21	2,543	0.00	0	7	29
/api/server/publico/version GET	0	467	0	47	2	0	0	47	0.00	0	0	0
/api/analise-gerencial-servicos/{cnpj}/tomado/cnpj-emitente POST	0	2	119	142	32	0	6	1,662	0.00	1	1	67
/api/solicitacao-documento-batch POST	0	18	12	30	5	0	2	404	0.00	1	1	4
/api/analise-gerencial-servicos/{cnpj}/tomado/municipios POST	0	2	110	140	42	0	4	852	0.00	0	1	68
/api/comercial/total-oportunidade/{cnpj} POST	0	1	212	212	0	0	32	23,729	0.00	7	16	176
/api/document/{cnpj}/v2/cte/ POST	0	11	16	24	3	0	2	586	0.00	1	2	11
/api/documento-ausente-download/chave-acesso/modelo POST	0	8	21	46	14	0	0	303	0.00	0	0	0
/api/analise-gerencial-servicos/{cnpj}/tomado/aliquota-iss POST	0	2	79	138	83	0	4	879	0.00	0	1	52
/api/document/{cnpj}/oportunidade-tese-juridica-consolidada POST	0	1	143	143	0	0	76	61,642	0.00	8	17	47
/api/document/{cnpj}/analise-vendas-estado-regiao-consolidada POST	0	4	30	35	4	0	12	5,963	0.00	2	1	12
/api/simples-nacional/compras-brutas-vendas-brutas/painel/{cnpj} POST	0	4	30	90	40	0	3	720	0.00	0	1	3
/api/solicitacao-documento-batch/{id} PUT	0	5	23	28	3	0	3	513	0.00	7	2	12
/api/esociais/{cnpj} POST	0	2	54	73	26	0	7	1,748	0.00	2	1	44
/api/document/{cnpj}/v2/nfe-ouro POST	0	5	16	33	10	0	3	969	0.00	0	1	5
/api/simples-nacional/compras-brutas-vendas-brutas POST	0	4	19	34	10	0	5	970	0.00	2	1	6
/api/document/{cnpj}/analise-compras-estado-regiao-consolidada POST	0	3	25	47	18	0	6	1,885	0.00	1	1	5
/consolidacao/{cnpj}/dados-ultima-consolidacao/{tipoConsolidacao} GET	0	6	11	19	4	0	2	463	0.00	0	1	5
/api/icms-st-simples-nacional-consumidor-final/sintetizado POST	0	4	13	26	8	0	6	2,783	0.00	0	1	3
/api/simples-nacional/credito-pis-cofins/sintetizado POST	0	2	22	31	12	0	11	3,753	0.00	0	1	8
/api/importacao-canhoto/{idCanhoto}/{idLote} DELETE	0	1	38	38	0	0	6	701	0.00	0	2	21
/api/document/{cnpj}/v2/nfce POST	0	1	38	38	0	0	13	2,937	0.00	0	2	11
/api/document/{cnpj}/cte/resumo POST	0	1	35	35	0	0	4	784	0.00	0	3	28
/api/ressarcimento-cigarros/{cnpj}/pis-cofins-restituir POST	0	1	29	29	0	0	15	3,080	0.00	0	1	4
/api/nfe-manifestacao/{cnpj}/{key} GET	0	2	11	12	0	0	2	311	0.00	0	1	3
/api/document/buscar-cte-por-chave/{key} GET	0	2	11	13	2	0	3	637	0.00	1	1	5
/api/document/{cnpj}/nfe/resumo POST	0	1	21	21	0	0	5	908	0.00	0	4	14
/api/download-nfe/{cnpj}/excel POST	0	9	2	6	1	0	1	438	0.00	0	0	0
/api/simples-nacional/credito-pis-cofins/detalhamento POST	0	1	18	18	0	0	9	2,442	0.00	0	1	6

Statistics sql - 1 day since midnight

366 hits/min on 686 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 ?	16	88,918	7	495	6	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 ?	12	665	755	2,454	430	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_.nfe_number=? and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	10	458	948	42,775	3,416	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_.nfe_number=? and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	7	25	11,841	66,277	20,406	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 ?	7	1,857	158	1,207	134	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 (? , ? , ?))	6	3,918	63	336	24	0.00
SELECT EXISTS ( SELECT 1 FROM document d WHERE (cnpj_issuer =? OR cnpj_addressee =?) AND group_type =? LIMIT 1 )	2	22	5,431	20,058	8,075	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_.tipo_cte in (? , ?)) and documentct0_.numero_cte=? and documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (?)) and documentct0_.tomador4_cnpj=? limit ?	2	3	37,784	56,855	31,836	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)	2	1,549	67	1,708	200	0.00
SELECT nfse.service_code FROM document_nfse_view nfse WHERE nfse.addressee_cpfcnpj = ? AND nfse.data_emissao BETWEEN ? AND ? UNION SELECT nfse.service_code FROM document_nfse_view nfse WHERE nfse.issuer_cpfcnpj = ? AND nfse.data_emissao BETWEEN ? AND ?	2	165	559	45,931	3,799	0.00
select count(1) as col_0_0_, document0_.type as col_1_0_ from public.document document0_ where (document0_.cnpj_issuer=? or document0_.cnpj_addressee=?) and (document0_.data_emissao between ? and ?) and (document0_.type not in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) group by document0_.type	2	888	99	3,297	362	0.00