Return Return     Main page Main page      Update Update     PDF PDF     Online help Online help     Monitoring with a Rich Desktop Application Desktop     Choice of period :  Day Day  Week Week  Month Month  Year Year  All All  Customized Customized


           (m/d/yy)     



Request Hits by parent request Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) Mean allocated Kb % of system error Mean hits sql Mean time sql (ms)
spring  AnalisadorValidacaoTributacaoSaidaProdutosMonofasicosServiceImpl.analisar  56 128 10 0 128 0.00 1 10
spring  graphNextGenService.getRvzByCnpj
 1.00 23 83 9 0 32 0.00    
spring  graphFiscalntelligenceCoreService.obter
 1.00 24 101 7 0 17 0.00    
sql  graphselect cast(d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'cnf' as int4) numeroNota, d.key as chave, d.data_emissao as dataEmissao, items.prod ->> 'cprod' as codigoProduto, items.prod ->> 'xprod' as descricaoProduto, items.prod ->> 'ncm' as ncm, items.prod ->> 'cfop' as cfop, items.imposto -> 'pis' -> 'pisAliq' ->> 'cst' as cstPisProduto, cast(items.imposto -> 'pis' -> 'pisAliq' ->> 'ppis' as numeric) as aliquotaPisProduto, cast(items.imposto -> 'pis' -> 'pisAliq' ->> 'vpis' as numeric) as valorPisProduto, items.imposto -> 'cofins' -> 'cofinsAliq' ->> 'cst' as cstCofinsProduto, cast(items.imposto -> 'cofins' -> 'cofinsAliq' ->> 'pcofins' as numeric) as aliquotaCofinsProduto, cast(items.imposto -> 'cofins' -> 'cofinsAliq' ->> 'vcofins' as numeric) as valorCofinsProduto from document d, jsonb_to_recordset(d.data -> 'nfe' -> 'infNFe' -> 'det') as items(prod jsonb, imposto jsonb) where d.type in ('NFE_2_0','NFE_3_1','NFE_4_0') and d.cnpj_issuer = ? and (items.prod ->> 'ncm' in ('27101159','27101921','27101910','27101911', '38249029','38260000','22089000','70109021', '39233000','73102110','76129019','22011000', '21069010','22021000','22029000','22030000', '27101259') or starts_with(items.prod ->> 'ncm', '220710') or starts_with(items.prod ->> 'ncm', '2207201') ) and items.imposto -> 'pis' -> 'pisAliq' ->> 'cst' <> '04' and items.imposto -> 'cofins' -> 'cofinsAliq' ->> 'cst' <> '04' and d.data_emissao between ? and ? limit ?
 1.00 10 17 1     0.00    
Find usages Find usages