-- The following table is only created for illustration. You can remove it on a productive site.

-- Table: diagram_dummy_logs
CREATE TABLE diagram_dummy_logs
(
  x1 timestamptz,
  y1 int4,
  x2 timestamptz,
  y2 int4,
  x3 timestamptz,
  y3 int4
);


-- Some dummy data
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:11.868964+01',2,'2005-11-21 23:06:11.868964+01',1.0,'2005-11-21 23:06:10.868964+01',2);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:12.913197+01',2,'2005-11-21 23:06:12.913197+01',0,'2005-11-21 23:06:13.913197+01',3);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:13.207786+01',3,'2005-11-21 23:06:13.207786+01',2,'2005-11-21 23:06:16.207786+01',8);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:14.358372+01',2,'2005-11-21 23:06:14.358372+01',3,'2005-11-21 23:06:19.358372+01',8);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:15.489034+01',3,'2005-11-21 23:06:15.489034+01',7,'2005-11-21 23:06:21.489034+01',6);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:16.614377+01',3,'2005-11-21 23:06:16.614377+01',3,'2005-11-21 23:06:23.614377+01',0);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:17.735309+01',4,'2005-11-21 23:06:17.735309+01',6,'2005-11-21 23:06:26.735309+01',8);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:18.453809+01',4,'2005-11-21 23:06:18.453809+01',1,'2005-11-21 23:06:29.453809+01',8);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:19.186141+01',4,'2005-11-21 23:06:20.186141+01',6,'2005-11-21 23:06:31.186141+01',3);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:20.077621+01',5,'2005-11-21 23:06:22.077621+01',8,'2005-11-21 23:06:33.077621+01',6);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:21.362135+01',5,'2005-11-21 23:06:23.362135+01',5,'2005-11-21 23:06:36.362135+01',7);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:22.700218+01',5,'2005-11-21 23:06:25.700218+01',0,'2005-11-21 23:06:39.700218+01',0);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:23.850676+01',4,'2005-11-21 23:06:26.850676+01',6,'2005-11-21 23:06:41.850676+01',4);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:24.041068+01',5,'2005-11-21 23:06:27.041068+01',7,'2005-11-21 23:06:43.041068+01',6);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:25.171647+01',5,'2005-11-21 23:06:28.171647+01',0,'2005-11-21 23:06:46.171647+01',6);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:26.317253+01',6,'2005-11-21 23:06:29.317253+01',4,'2005-11-21 23:06:49.317253+01',9);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:27.423928+01',6,'2005-11-21 23:06:30.423928+01',3,'2005-11-21 23:06:51.423928+01',5);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:28.528976+01',7,'2005-11-21 23:06:31.528976+01',2,'2005-11-21 23:06:53.528976+01',6);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:29.557702+01',7,'2005-11-21 23:06:32.557702+01',7,'2005-11-21 23:06:56.557702+01',2);
INSERT INTO diagram_dummy_logs VALUES ('2005-11-21 23:06:30.708037+01',5,'2005-11-21 23:06:33.708037+01',5.5,'2005-11-21 23:06:59.708037+01',9);