PostgresSQL Range Annotation Provides Wrong Region

When I use a query to try and get a region annotation from PostgresSQL it makes the region the start of the chart through the start of the region. The correct start and end points are the red lines on the chart below.

SELECT
extract(epoch from start_time) as time,
extract(epoch from end_time) as timeend,
anomaly_name as text,
anomaly_name as tags
FROM
rad_anomalies
where
$__timeFilter(start_time)
and anomaly_guid = ‘9316f58a-8f9e-4358-0000-000000551643’

This topic was automatically closed after 365 days. New replies are no longer allowed.