AS
select if(isnull("PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST"),'background',"PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST") AS "HOST",sum("STMT"."TOTAL") AS "STATEMENTS","SYS"."FORMAT_TIME"(sum("STMT"."TOTAL_LATENCY")) AS "STATEMENT_LATENCY","SYS"."FORMAT_TIME"(ifnull((sum("STMT"."TOTAL_LATENCY") / nullif(sum("STMT"."TOTAL"),0)),0)) AS "STATEMENT_AVG_LATENCY",sum("STMT"."FULL_SCANS") AS "TABLE_SCANS",sum("IO"."IOS") AS "FILE_IOS","SYS"."FORMAT_TIME"(sum("IO"."IO_LATENCY")) AS "FILE_IO_LATENCY",sum("PERFORMANCE_SCHEMA"."ACCOUNTS"."CURRENT_CONNECTIONS") AS "CURRENT_CONNECTIONS",sum("PERFORMANCE_SCHEMA"."ACCOUNTS"."TOTAL_CONNECTIONS") AS "TOTAL_CONNECTIONS",count(distinct "PERFORMANCE_SCHEMA"."ACCOUNTS"."USER") AS "UNIQUE_USERS","SYS"."FORMAT_BYTES"(sum("MEM"."CURRENT_ALLOCATED")) AS "CURRENT_MEMORY","SYS"."FORMAT_BYTES"(sum("MEM"."TOTAL_ALLOCATED")) AS "TOTAL_MEMORY_ALLOCATED" from ((("PERFORMANCE_SCHEMA"."ACCOUNTS" join "SYS"."X$HOST_SUMMARY_BY_STATEMENT_LATENCY" "STMT" on(("PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST" = "STMT"."HOST"))) join "SYS"."X$HOST_SUMMARY_BY_FILE_IO" "IO" on(("PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST" = "IO"."HOST"))) join "SYS"."X$MEMORY_BY_HOST_BY_CURRENT_BYTES" "MEM" on(("PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST" = "MEM"."HOST"))) group by if(isnull("PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST"),'background',"PERFORMANCE_SCHEMA"."ACCOUNTS"."HOST")