Hallo,
i became the following db timeout when i open an resource:
ERROR: canceling statement due to statement timeout
STATEMENT: SELECT template_id, COUNT(id) FROM EAM_MEASUREMENT WHERE EXISTS (SELECT 1 FROM (SELECT * FROM HQ_METRIC_DATA_8D_0S WHERE timestamp between 1237762800000 and 1237794060000 AND measurement_id in (24445,24446,24448,24449,24450,24451,24452,24453,24454,24455,24456,24457,24458,24459,24460) UNION ALL SELECT * FROM HQ_METRIC_DATA_7D_1S WHERE timestamp between 1237719600000 and 1237762799999 AND measurement_id in (24445,24446,24448,24449,24450,24451,24452,24453,24454,24455,24456,24457,24458,24459,24460) UNION ALL SELECT * FROM HQ_METRIC_DATA_7D_0S WHERE timestamp between 1237676400000 and 1237719599999 AND measurement_id in (24445,24446,24448,24449,24450,24451,24452,24453,24454,24455,24456,24457,24458,24459,24460) UNION ALL SELECT * FROM HQ_METRIC_DATA_6D_1S WHERE timestamp between 1237633200000 and 1237676399999 AND measurement_id in (24445,24446,24448,24449,24450,24451,24452,24453,24454,24455,24456,24457,24458,24459,24460) UNION ALL SELECT * FROM HQ_METRIC_DATA_6D_0S WHERE timestamp between 1237621260000 and 1237633199999 AND measurement_id in (24445,24446,24448,24449,24450,24451,24452,24453,24454,24455,24456,24457,24458,24459,24460)) EAM_MEASUREMENT_DATA WHERE timestamp BETWEEN 1237621260000 AND 1237794060000 AND measurement_id = id) GROUP BY template_id
has anyone an idea?
thanks thoas
