select TOP 1 TO_TIMESTAMP(TO_VARCHAR("TIME", 'YYYY-MM-DD HH24:MI')) "TIME", HOST, PORT, MAX(CPU) "CPU_PCT_INDEXSERVER", MAX(SYSTEM_CPU) "SYSTEM_CPU_PCT_INDEXSERVER", ROUND(MAX(MEMORY_USED)/1024/1024/1024, 1) "MEMORY_USED_GB", ROUND(MAX(MEMORY_ALLOCATION_LIMIT)/1024/1024/1024, 1) "MEMORY_ALLOCATION_LIMIT_GB", MAX(CS_UNLOAD_COUNT) "CS_UNLOAD_COUNT", MAX(SWAP_IN) "SWAP_IN_BYTE", MAX(PING_TIME) "PING_TIME_MS", MAX(PENDING_SESSION_COUNT) "PENDING_SESSION_COUNT", MAX(MVCC_VERSION_COUNT) "MVCC_VERSION_COUNT", MAX(WAITING_THREAD_COUNT) "WAITING_THREAD_COUNT", MAX(BLOCKED_TRANSACTION_COUNT) "BLOCKED_TRANSACTION_COUNT" from "M_LOAD_HISTORY_SERVICE" WHERE PORT LIKE '%03' group by TO_TIMESTAMP(TO_VARCHAR("TIME", 'YYYY-MM-DD HH24:MI')), HOST, PORT order by TIME desc