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 Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) % of system error
sql  SELECT c.cnpj_empresa as cnpj, TO_CHAR(data_consumo, 'YYYY-MM') as periodo, SUM(total_documentos_consumidos) as quantidadeDocumentosConsumidos FROM consumo_documentos_conta_empresa c WHERE c.data_consumo BETWEEN ? AND ? AND c.cnpj_empresa in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY TO_CHAR(data_consumo, 'YYYY-MM'), c.cnpj_empresa ORDER BY TO_CHAR(data_consumo, 'YYYY-MM') 637 637 0   0.00
Find usages Find usages