drh_time_range_stacked_metrics (view) Content

drh_time_range_stacked_metrics (view) Schema


DCLP1-001-001	1.1539629517157608	304	25 hours, 20 minutes	0.17081688430003036	45	03 hours, 45 minutes	88.69571819010021	23366	1947 hours, 10 minutes	1.0628606134224112	280	23 hours, 20 minutes	8.916641360461584	2349	195 hours, 45 minutes
DCLP1-001-002	3.8139989015683162	625	52 hours, 05 minutes	1.1411484713492404	187	15 hours, 35 minutes	58.424360773784095	9574	797 hours, 50 minutes	9.538048453042046	1563	130 hours, 15 minutes	27.082443400256302	4438	369 hours, 50 minutes
DCLP1-001-003	1.4482616745525612	352	29 hours, 20 minutes	0.38675169718164987	94	07 hours, 50 minutes	63.71528492079819	15486	1290 hours, 30 minutes	7.842007817321539	1906	158 hours, 50 minutes	26.60769389014606	6467	538 hours, 55 minutes
DCLP1-001-004	1.887385970430953	480	40 hours, 00 minutes	1.1874803397294746	302	25 hours, 10 minutes	71.14265492293174	18093	1507 hours, 45 minutes	5.386914123938346	1370	114 hours, 10 minutes	20.395564642969486	5187	432 hours, 15 minutes
DCLP1-001-005	3.357138840465613	597	49 hours, 45 minutes	1.445200472361244	257	21 hours, 25 minutes	50.857560591576224	9044	753 hours, 40 minutes	17.404262497891246	3095	257 hours, 55 minutes	26.935837597705675	4790	399 hours, 10 minutes
DCLP1-001-006	0.4555357496533967	115	09 hours, 35 minutes	0.09506833036244801	24	02 hours, 00 minutes	51.55872449990097	13016	1084 hours, 40 minutes	12.576747870865518	3175	264 hours, 35 minutes	35.31392354921767	8915	742 hours, 55 minutes
DCLP1-001-007	1.9487139272271017	497	41 hours, 25 minutes	0.5959849435382685	152	12 hours, 40 minutes	63.58218318695106	16216	1351 hours, 20 minutes	6.959692597239648	1775	147 hours, 55 minutes	26.913425345043915	6864	572 hours, 00 minutes
DCLP1-001-008	0.8649667951135526	211	17 hours, 35 minutes	0.16807411658604574	41	03 hours, 25 minutes	57.173895220136096	13947	1162 hours, 15 minutes	12.261211773386899	2991	249 hours, 15 minutes	29.531852094777403	7204	600 hours, 20 minutes
DCLP1-001-009	1.2503895294484264	321	26 hours, 45 minutes	0.39342474291056406	101	08 hours, 25 minutes	68.09364287940168	17481	1456 hours, 45 minutes	8.187909005920847	2102	175 hours, 10 minutes	22.07463384231848	5667	472 hours, 15 minutes
DCLP1-001-011	3.023177695666779	90	07 hours, 30 minutes	1.5451797111185757	46	03 hours, 50 minutes	64.93113873026537	1933	161 hours, 05 minutes	10.077258985555929	300	25 hours, 00 minutes	20.423244877393348	608	50 hours, 40 minutes
DCLP1-001-012	1.102108381251089	253	21 hours, 05 minutes	0.5140268339431957	118	09 hours, 50 minutes	49.3030144624499	11318	943 hours, 10 minutes	20.966196201428822	4813	401 hours, 05 minutes	28.11465412092699	6454	537 hours, 50 minutes
DCLP1-001-013	0.5031005031005031	129	10 hours, 45 minutes	0.156000156000156	40	03 hours, 20 minutes	55.82075582075582	14313	1192 hours, 45 minutes	13.412113412113412	3439	286 hours, 35 minutes	30.108030108030107	7720	643 hours, 20 minutes
DCLP1-001-014	0.7629975749689478	129	10 hours, 45 minutes	0.08280593836872302	14	01 hours, 10 minutes	54.592772224522385	9230	769 hours, 10 minutes	16.76228780978293	2834	236 hours, 10 minutes	27.79913645235701	4700	391 hours, 40 minutes
DCLP1-001-015	0.4729623206684534	120	10 hours, 00 minutes	0.059120290083556674	15	01 hours, 15 minutes	42.5232539807662	10789	899 hours, 05 minutes	30.584896736559987	7760	646 hours, 40 minutes	26.359766671921804	6688	557 hours, 20 minutes
DCLP1-001-016	1.6194729351720076	330	27 hours, 30 minutes	0.5987142366393483	122	10 hours, 10 minutes	63.12509201550768	12863	1071 hours, 55 minutes	13.166805712322716	2683	223 hours, 35 minutes	21.489915100358246	4379	364 hours, 55 minutes
DCLP1-001-017	1.7037080705063963	289	24 hours, 05 minutes	0.36550138536815424	62	05 hours, 10 minutes	48.23439250132642	8182	681 hours, 50 minutes	16.91328184872959	2869	239 hours, 05 minutes	32.78311619406944	5561	463 hours, 25 minutes
DCLP1-001-018	2.797174733124649	697	58 hours, 05 minutes	2.155068625090296	537	44 hours, 45 minutes	49.20539369130749	12261	1021 hours, 45 minutes	16.851272172726542	4199	349 hours, 55 minutes	28.991090777751023	7224	602 hours, 00 minutes
DCLP1-001-019	1.280448372494072	297	24 hours, 45 minutes	0.24574261694330674	57	04 hours, 45 minutes	44.20349213192498	10253	854 hours, 25 minutes	23.431774089243373	5435	452 hours, 55 minutes	30.838542789394268	7153	596 hours, 05 minutes
DCLP1-001-020	0.7221362536206007	182	15 hours, 10 minutes	0.1944212990517002	49	04 hours, 05 minutes	41.677578066103244	10504	875 hours, 20 minutes	27.62369559179463	6962	580 hours, 10 minutes	29.78216878942983	7506	625 hours, 30 minutes
DCLP1-002-001	1.6334960570784829	348	29 hours, 00 minutes	0.15490048817123545	33	02 hours, 45 minutes	63.41532106646639	13510	1125 hours, 50 minutes	7.730942546000751	1647	137 hours, 15 minutes	27.06533984228314	5766	480 hours, 30 minutes
DCLP1-002-002	1.557553501329619	369	30 hours, 45 minutes	0.3207969271031193	76	06 hours, 20 minutes	82.15356042378963	19463	1621 hours, 55 minutes	2.0471909163817483	485	40 hours, 25 minutes	13.920898231395888	3298	274 hours, 50 minutes
DCLP1-002-003	4.201460236960608	961	80 hours, 05 minutes	2.596948367070345	594	49 hours, 30 minutes	60.65229746863114	13873	1156 hours, 05 minutes	10.326585931010362	2362	196 hours, 50 minutes	22.222707996327546	5083	423 hours, 35 minutes
DCLP1-002-004	0.764519535374868	181	15 hours, 05 minutes	0.08025343189017951	19	01 hours, 35 minutes	74.91869060190074	17737	1478 hours, 05 minutes	3.151003167898627	746	62 hours, 10 minutes	21.085533262935588	4992	416 hours, 00 minutes
DCLP1-002-005	1.7882232724485885	280	23 hours, 20 minutes	0.8430195427257632	132	11 hours, 00 minutes	69.90675692936519	10946	912 hours, 10 minutes	4.623834461617065	724	60 hours, 20 minutes	22.8381657938434	3576	298 hours, 00 minutes
DCLP1-002-006	1.0566684345803925	259	21 hours, 35 minutes	0.616049936763086	151	12 hours, 35 minutes	55.685202562114966	13649	1137 hours, 25 minutes	14.238505160948145	3490	290 hours, 50 minutes	28.403573905593408	6962	580 hours, 10 minutes
DCLP1-002-007	0.5332859301395432	120	10 hours, 00 minutes	0.2177584214736468	49	04 hours, 05 minutes	41.37854412941072	9311	775 hours, 55 minutes	21.39809794684917	4815	401 hours, 15 minutes	36.47231357212692	8207	683 hours, 55 minutes
DCLP1-002-008	2.4654991526107657	611	50 hours, 55 minutes	0.8675651682672908	215	17 hours, 55 minutes	61.46396578161569	15232	1269 hours, 20 minutes	10.479380195303042	2597	216 hours, 25 minutes	24.723589702203213	6127	510 hours, 35 minutes
DCLP1-002-009	3.2312851108304663	742	61 hours, 50 minutes	1.2672560205548056	291	24 hours, 15 minutes	38.056874101815964	8739	728 hours, 15 minutes	31.620432870269564	7261	605 hours, 05 minutes	25.824151896529198	5930	494 hours, 10 minutes
DCLP1-002-010	2.8605747842334726	643	53 hours, 35 minutes	1.1033010054275292	248	20 hours, 40 minutes	59.83628436693656	13450	1120 hours, 50 minutes	7.807634131150458	1755	146 hours, 15 minutes	28.39220571225198	6382	531 hours, 50 minutes
DCLP1-002-011	2.855188921183108	668	55 hours, 40 minutes	0.7180714652077278	168	14 hours, 00 minutes	62.459394768336466	14613	1217 hours, 45 minutes	9.189605060694136	2150	179 hours, 10 minutes	24.77773978457856	5797	483 hours, 05 minutes
DCLP1-002-012	4.754487464767839	641	53 hours, 25 minutes	1.6985610443554369	229	19 hours, 05 minutes	49.75522919448153	6708	559 hours, 00 minutes	22.66726005043762	3056	254 hours, 40 minutes	21.124462245957574	2848	237 hours, 20 minutes
DCLP1-002-013	4.295466748485081	1120	93 hours, 20 minutes	2.44688195136918	638	53 hours, 10 minutes	60.470200199432384	15767	1313 hours, 55 minutes	8.763519214543223	2285	190 hours, 25 minutes	24.023931886170132	6264	522 hours, 00 minutes
DCLP1-002-014	2.5927487352445193	615	51 hours, 15 minutes	0.8558178752107926	203	16 hours, 55 minutes	54.09359190556492	12831	1069 hours, 15 minutes	13.718381112984822	3254	271 hours, 10 minutes	28.73946037099494	6817	568 hours, 05 minutes
DCLP1-002-015	2.3701371711266024	527	43 hours, 55 minutes	1.2907578142568024	287	23 hours, 55 minutes	57.46795592534293	12778	1064 hours, 50 minutes	14.076905779176974	3130	260 hours, 50 minutes	24.794243310096693	5513	459 hours, 25 minutes
DCLP1-002-016	1.9054042660821178	452	37 hours, 40 minutes	0.5522299974707023	131	10 hours, 55 minutes	51.951774723885	12324	1027 hours, 00 minutes	20.773965095691764	4928	410 hours, 40 minutes	24.816625916870414	5887	490 hours, 35 minutes
DCLP1-002-017	2.6810761094504483	583	48 hours, 35 minutes	1.1083007587951252	241	20 hours, 05 minutes	63.03977925959991	13708	1142 hours, 20 minutes	13.078868705449528	2844	237 hours, 00 minutes	20.09197516670499	4369	364 hours, 05 minutes
DCLP1-002-018	2.7340370306281363	474	39 hours, 30 minutes	1.0959220164965104	190	15 hours, 50 minutes	59.318221145526906	10284	857 hours, 00 minutes	16.784910884236027	2910	242 hours, 30 minutes	20.06690892311242	3479	289 hours, 55 minutes
DCLP1-003-001	3.1643882563497203	831	69 hours, 15 minutes	0.6130764251170938	161	13 hours, 25 minutes	90.17554548570124	23681	1973 hours, 25 minutes	0.43410380412017824	114	09 hours, 30 minutes	5.612886028711778	1474	122 hours, 50 minutes
DCLP1-003-002	0.782577763724754	198	16 hours, 30 minutes	0.33595510058890954	85	07 hours, 05 minutes	56.270503142168295	14237	1186 hours, 25 minutes	9.999604758705189	2530	210 hours, 50 minutes	32.61135923481285	8251	687 hours, 35 minutes
DCLP1-003-003	1.0127459663444878	263	21 hours, 55 minutes	0.011552235357541685	3	00 hours, 15 minutes	76.66063383264661	19908	1659 hours, 00 minutes	4.066386845854673	1056	88 hours, 00 minutes	18.248681119796682	4739	394 hours, 55 minutes
DCLP1-003-004	3.6117775354416577	828	69 hours, 00 minutes	0.920392584514722	211	17 hours, 35 minutes	53.53980370774264	12274	1022 hours, 50 minutes	14.625954198473282	3353	279 hours, 25 minutes	27.302071973827697	6259	521 hours, 35 minutes
DCLP1-003-005	5.239452915168795	1268	105 hours, 40 minutes	1.611503656873683	390	32 hours, 30 minutes	77.78604189909508	18825	1568 hours, 45 minutes	1.9668608735176232	476	39 hours, 40 minutes	13.396140655344821	3242	270 hours, 10 minutes
DCLP1-003-006	3.8676607642124883	996	83 hours, 00 minutes	1.1960236098167132	308	25 hours, 40 minutes	73.87775706741223	19025	1585 hours, 25 minutes	4.267629698664181	1099	91 hours, 35 minutes	16.79092885989438	4324	360 hours, 20 minutes
DCLP1-003-007	0.036733194563487205	9	00 hours, 45 minutes	0.0	0	00 hours, 00 minutes	59.72817436023019	14634	1219 hours, 30 minutes	4.293702297865393	1052	87 hours, 40 minutes	35.941390147340925	8806	733 hours, 50 minutes
DCLP1-003-008	4.22982302991826	1066	88 hours, 50 minutes	0.694389334179827	175	14 hours, 35 minutes	74.74009999206412	18836	1569 hours, 40 minutes	2.83707642250615	715	59 hours, 35 minutes	17.49861122133164	4410	367 hours, 30 minutes
DCLP1-003-009	1.5235124760076775	381	31 hours, 45 minutes	0.19593730006397952	49	04 hours, 05 minutes	69.43378119001919	17364	1447 hours, 00 minutes	6.014075495841331	1504	125 hours, 20 minutes	22.83269353806782	5710	475 hours, 50 minutes
DCLP1-003-010	2.033606204222318	472	39 hours, 20 minutes	1.3313227057302888	309	25 hours, 45 minutes	74.56268849633778	17306	1442 hours, 10 minutes	4.377423524342956	1016	84 hours, 40 minutes	17.694959069366654	4107	342 hours, 15 minutes
DCLP1-003-011	2.3974181650530197	624	52 hours, 00 minutes	0.7184570462578761	187	15 hours, 35 minutes	72.57952973720609	18891	1574 hours, 15 minutes	4.683417857691716	1219	101 hours, 35 minutes	19.6211771937913	5107	425 hours, 35 minutes
DCLP1-003-012	0.046354825115887066	11	00 hours, 55 minutes	0.046354825115887066	11	00 hours, 55 minutes	31.11251580278129	7383	615 hours, 15 minutes	30.442477876106196	7224	602 hours, 00 minutes	38.35229667088074	9101	758 hours, 25 minutes
DCLP1-003-013	1.970048512971947	467	38 hours, 55 minutes	0.39232229487449904	93	07 hours, 45 minutes	68.67749419953596	16280	1356 hours, 40 minutes	5.243619489559165	1243	103 hours, 35 minutes	23.716515503058428	5622	468 hours, 30 minutes

Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

Error in query number 6:

Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:

            SELECT 'text' AS component,
                (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
                                                                                                                                                   ⬆️
                '(Page ' || $current_page || ' of ' || $total_pages || ') ' ||

Backtrace

sql parser error: Expected: END, found: ' ||
                ' at Line: 42, Column: 149

"console/content/view/drh_time_range_stacked_metrics.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.

You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.