# 图传



'輔大','關渡','小南門','大直','西湖','萬芳醫院','港墘','紅樹林','木柵','大安',


'永寧','府中','忠孝新生','小碧潭','動物園','龍山寺','新店','anomaly_rate','圓山','板橋'



WITH AVG_TABLE AS(
WITH const AS (SELECT extract(EPOCH from {interval}::interval) gap)
SELECT to_timestamp(floor((extract(EPOCH from date) / const.gap)) * const.gap)
AT TIME ZONE 'UTC' as interval_alias,
{grouped_columns} {mask}
FROM {schema}.{tbl}, const
{date_cond}
GROUP BY interval_alias
ORDER BY {sort})
SELECT {columns} FROM AVG_TABLE










Discover events of interest from a global view