gistfile1.sql

SELECT
*
FROM
(
   SELECT
   DISTINCT X.*
   FROM TSD_TSMETA X,
   TSD_METRIC M,
   TSD_FQN_TAGPAIR T,
   TSD_TAGPAIR P,
   TSD_TAGK K,
   TSD_TAGV V
   WHERE M.XUID = X.METRIC_UID
   AND X.FQNID = T.FQNID
   AND T.XUID = P.XUID
   AND P.TAGK = K.XUID
   AND (M.NAME = 'sys.cpu')
   AND P.TAGV = V.XUID
   AND (K.NAME = 'cpu')
   AND (V.NAME LIKE '%') INTERSECT
   SELECT
   DISTINCT X.*
   FROM TSD_TSMETA X,
   TSD_METRIC M,
   TSD_FQN_TAGPAIR T,
   TSD_TAGPAIR P,
   TSD_TAGK K,
   TSD_TAGV V
   WHERE M.XUID = X.METRIC_UID
   AND X.FQNID = T.FQNID
   AND T.XUID = P.XUID
   AND P.TAGK = K.XUID
   AND (M.NAME = 'sys.cpu')
   AND P.TAGV = V.XUID
   AND (K.NAME = 'host')
   AND (V.NAME LIKE 'WebServer%') INTERSECT
   SELECT
   DISTINCT X.*
   FROM TSD_TSMETA X,
   TSD_METRIC M,
   TSD_FQN_TAGPAIR T,
   TSD_TAGPAIR P,
   TSD_TAGK K,
   TSD_TAGV V
   WHERE M.XUID = X.METRIC_UID
   AND X.FQNID = T.FQNID
   AND T.XUID = P.XUID
   AND P.TAGK = K.XUID
   AND (M.NAME = 'sys.cpu')
   AND P.TAGV = V.XUID
   AND (K.NAME = 'type')
   AND (V.NAME = 'combined')
)
X
WHERE X.TSUID <= 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
ORDER BY X.TSUID DESC LIMIT 101