spec/dummy/db/structure.sql in landable-1.9.2 vs spec/dummy/db/structure.sql in landable-1.10.0.rc1
- old
+ new
@@ -1369,11 +1369,11 @@
agg1."average response time (ms)"
FROM ( SELECT p.path_id,
p.path,
round(avg(pv.response_time), 3) AS "average response time (ms)"
FROM (page_views pv
- JOIN paths p ON ((p.path_id = pv.path_id)))
- GROUP BY p.path_id, p.path) agg1
+ JOIN paths p ON ((p.path_id = pv.path_id)))
+ GROUP BY p.path_id, p.path) agg1
ORDER BY agg1."average response time (ms)" DESC;
--
-- Name: VIEW path_response_time__by_time; Type: COMMENT; Schema: dummy_landable_traffic; Owner: -