-
Notifications
You must be signed in to change notification settings - Fork 13
InfluxDB Measurement Count Performance
Charlie Martin edited this page Oct 8, 2018
·
2 revisions
On the sugartechllc site:
- Dashboard refresh
- Google Cloud Platform
- 15M measurements
- Release: development (c0f5ca3) (2018-09-27 23:48:22 UTC)
InfluxDB times for select count(value) from "tsdata", and total page render time.
| N CPU | Memory | Count Time | Page Render |
|---|---|---|---|
| 1 | 1.7G | 10107ms | 18714ms |
| 2 | 2.0G | 3451ms | 5055ms |
| 2 | 4.0G | 3261ms | 4926ms |
| 4 | 4.0G | 1841ms | 2862ms |
I, [2018-10-08T17:12:53.421890 #8516] INFO -- : Started GET "/dashboard" for 128.117.153.159 at 2018-10-08 17:12:53 +0000
I, [2018-10-08T17:12:53.424840 #8516] INFO -- : Processing by DashboardController#index as HTML
D, [2018-10-08T17:12:53.427408 #8516] DEBUG -- : Profile Load (0.6ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` ASC LIMIT 1
D, [2018-10-08T17:12:53.428716 #8516] DEBUG -- : Site Load (0.3ms) SELECT `sites`.* FROM `sites` ORDER BY `sites`.`id` ASC LIMIT 1
D, [2018-10-08T17:12:53.429753 #8516] DEBUG -- : Instrument Load (0.3ms) SELECT `instruments`.* FROM `instruments` ORDER BY `instruments`.`id` ASC LIMIT 1
D, [2018-10-08T17:12:53.450650 #8516] DEBUG -- : CACHE (0.0ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` ASC LIMIT 1
D, [2018-10-08T17:13:03.559747 #8516] DEBUG -- : InfluxDB SQL (10107.2ms) select count(value) from "tsdata"
D, [2018-10-08T17:13:03.925987 #8516] DEBUG -- : InfluxDB SQL (365.5ms) select sum(diskBytes) / 1024 /1024 from _internal."monitor"."shard" where time > now() - 20s
D, [2018-10-08T17:13:03.988304 #8516] DEBUG -- : InfluxDB SQL (61.4ms) show retention policies
D, [2018-10-08T17:13:04.409607 #8516] DEBUG -- : (419.0ms) SELECT COUNT(*) FROM `sites` WHERE (1=1)
D, [2018-10-08T17:13:04.413328 #8516] DEBUG -- : Instrument Load (2.4ms) SELECT `instruments`.* FROM `instruments` WHERE (1=1)
D, [2018-10-08T17:13:04.415340 #8516] DEBUG -- : Instrument Load (0.5ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:13:05.892532 #8516] DEBUG -- : InfluxDB SQL (1476.2ms) select * from "tsdata" where (inst = '1') order by desc limit 1
D, [2018-10-08T17:13:06.034360 #8516] DEBUG -- : InfluxDB SQL (141.0ms) select * from "tsdata" where (inst = '2') order by desc limit 1
D, [2018-10-08T17:13:07.544060 #8516] DEBUG -- : InfluxDB SQL (1508.9ms) select * from "tsdata" where (inst = '3') order by desc limit 1
D, [2018-10-08T17:13:07.676364 #8516] DEBUG -- : InfluxDB SQL (131.4ms) select * from "tsdata" where (inst = '4') order by desc limit 1
D, [2018-10-08T17:13:07.829894 #8516] DEBUG -- : InfluxDB SQL (152.7ms) select * from "tsdata" where (inst = '5') order by desc limit 1
D, [2018-10-08T17:13:07.850629 #8516] DEBUG -- : Instrument Load (19.7ms) SELECT `instruments`.* FROM `instruments` WHERE `instruments`.`id` = 3 LIMIT 1
D, [2018-10-08T17:13:07.854559 #8516] DEBUG -- : Profile Load (2.0ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` DESC LIMIT 1
D, [2018-10-08T17:13:07.903597 #8516] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:13:08.160326 #8516] DEBUG -- : InfluxDB SQL (255.4ms) select count(value) from "tsdata" where (time > 1539011587903005696 and time <= 1539018787903005696) group by time(1m), inst
D, [2018-10-08T17:13:08.220948 #8516] DEBUG -- : CACHE (0.1ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:13:08.482789 #8516] DEBUG -- : InfluxDB SQL (260.7ms) select count(value) from "tsdata" where (time > 1538413987903005696 and time <= 1539018787903005696) group by time(1h), inst
D, [2018-10-08T17:13:08.667863 #8516] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:13:11.401718 #8516] DEBUG -- : InfluxDB SQL (2732.5ms) select count(value) from "tsdata" where (time > 1533834787903005696 and time <= 1539018787903005696) group by time(1d), inst
D, [2018-10-08T17:13:11.943179 #8516] DEBUG -- : InfluxDB SQL (6.1ms) select count(value) from "tsdata" where (inst = '1') and (time > now() - 65s)
D, [2018-10-08T17:13:11.952091 #8516] DEBUG -- : InfluxDB SQL (4.7ms) select count(value) from "tsdata" where (inst = '2') and (time > now() - 65s)
D, [2018-10-08T17:13:11.960200 #8516] DEBUG -- : InfluxDB SQL (7.0ms) select count(value) from "tsdata" where (inst = '3') and (time > now() - 65s)
D, [2018-10-08T17:13:11.968569 #8516] DEBUG -- : InfluxDB SQL (6.9ms) select count(value) from "tsdata" where (inst = '4') and (time > now() - 65s)
D, [2018-10-08T17:13:11.976232 #8516] DEBUG -- : InfluxDB SQL (6.2ms) select count(value) from "tsdata" where (inst = '5') and (time > now() - 65s)
I, [2018-10-08T17:13:12.013045 #8516] INFO -- : Rendered dashboard/_samples_per_minute.html.haml (8.4ms)
I, [2018-10-08T17:13:12.023913 #8516] INFO -- : Rendered dashboard/_samples_per_hour.html.haml (8.5ms)
I, [2018-10-08T17:13:12.032677 #8516] INFO -- : Rendered dashboard/_samples_per_day.html.haml (6.1ms)
I, [2018-10-08T17:13:12.033387 #8516] INFO -- : Rendered dashboard/index.html.haml within layouts/application (213.1ms)
I, [2018-10-08T17:13:12.134958 #8516] INFO -- : Rendered layouts/_bannerbar.html.haml (1.1ms)
I, [2018-10-08T17:13:12.137476 #8516] INFO -- : Rendered layouts/_topnav.html.haml (1.8ms)
I, [2018-10-08T17:13:12.138251 #8516] INFO -- : Rendered layouts/_messages.html.haml (0.1ms)
I, [2018-10-08T17:13:12.138763 #8516] INFO -- : Rendered layouts/_footer.html.haml (0.1ms)
I, [2018-10-08T17:13:12.139551 #8516] INFO -- : Completed 200 OK in 18714ms (Views: 725.1ms | ActiveRecord: 445.0ms)
I, [2018-10-08T17:48:57.008363 #101] INFO -- : Started GET "/dashboard" for 128.117.153.159 at 2018-10-08 17:48:57 +0000
I, [2018-10-08T17:48:57.009919 #101] INFO -- : Processing by DashboardController#index as HTML
D, [2018-10-08T17:48:57.011518 #101] DEBUG -- : Profile Load (0.6ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` ASC LIMIT 1
D, [2018-10-08T17:48:57.012556 #101] DEBUG -- : Site Load (0.3ms) SELECT `sites`.* FROM `sites` ORDER BY `sites`.`id` ASC LIMIT 1
D, [2018-10-08T17:48:57.013481 #101] DEBUG -- : Instrument Load (0.3ms) SELECT `instruments`.* FROM `instruments` ORDER BY `instruments`.`id` ASC LIMIT 1
D, [2018-10-08T17:48:57.015704 #101] DEBUG -- : CACHE (0.0ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` ASC LIMIT 1
D, [2018-10-08T17:49:00.467871 #101] DEBUG -- : InfluxDB SQL (3451.0ms) select count(value) from "tsdata"
D, [2018-10-08T17:49:00.473992 #101] DEBUG -- : InfluxDB SQL (5.9ms) select sum(diskBytes) / 1024 /1024 from _internal."monitor"."shard" where time > now() - 20s
D, [2018-10-08T17:49:00.476246 #101] DEBUG -- : InfluxDB SQL (2.1ms) show retention policies
D, [2018-10-08T17:49:00.478079 #101] DEBUG -- : (0.5ms) SELECT COUNT(*) FROM `sites` WHERE (1=1)
D, [2018-10-08T17:49:00.478895 #101] DEBUG -- : Instrument Load (0.3ms) SELECT `instruments`.* FROM `instruments` WHERE (1=1)
D, [2018-10-08T17:49:00.480094 #101] DEBUG -- : Instrument Load (0.3ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:49:00.495860 #101] DEBUG -- : InfluxDB SQL (15.1ms) select * from "tsdata" where (inst = '1') order by desc limit 1
D, [2018-10-08T17:49:00.512831 #101] DEBUG -- : InfluxDB SQL (16.6ms) select * from "tsdata" where (inst = '2') order by desc limit 1
D, [2018-10-08T17:49:00.529274 #101] DEBUG -- : InfluxDB SQL (16.1ms) select * from "tsdata" where (inst = '3') order by desc limit 1
D, [2018-10-08T17:49:00.542820 #101] DEBUG -- : InfluxDB SQL (13.2ms) select * from "tsdata" where (inst = '4') order by desc limit 1
D, [2018-10-08T17:49:00.555807 #101] DEBUG -- : InfluxDB SQL (12.6ms) select * from "tsdata" where (inst = '5') order by desc limit 1
D, [2018-10-08T17:49:00.557174 #101] DEBUG -- : Instrument Load (0.7ms) SELECT `instruments`.* FROM `instruments` WHERE `instruments`.`id` = 3 LIMIT 1
D, [2018-10-08T17:49:00.558739 #101] DEBUG -- : Profile Load (0.4ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` DESC LIMIT 1
D, [2018-10-08T17:49:00.560053 #101] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:49:00.626243 #101] DEBUG -- : InfluxDB SQL (65.4ms) select count(value) from "tsdata" where (time > 1539013740559718912 and time <= 1539020940559718912) group by time(1m), inst
D, [2018-10-08T17:49:00.641438 #101] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:49:00.823152 #101] DEBUG -- : InfluxDB SQL (181.0ms) select count(value) from "tsdata" where (time > 1538416140559718912 and time <= 1539020940559718912) group by time(1h), inst
D, [2018-10-08T17:49:00.845209 #101] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:49:02.016479 #101] DEBUG -- : InfluxDB SQL (1170.4ms) select count(value) from "tsdata" where (time > 1533836940559718912 and time <= 1539020940559718912) group by time(1d), inst
D, [2018-10-08T17:49:02.030659 #101] DEBUG -- : InfluxDB SQL (3.8ms) select count(value) from "tsdata" where (inst = '1') and (time > now() - 65s)
D, [2018-10-08T17:49:02.035969 #101] DEBUG -- : InfluxDB SQL (3.5ms) select count(value) from "tsdata" where (inst = '2') and (time > now() - 65s)
D, [2018-10-08T17:49:02.040544 #101] DEBUG -- : InfluxDB SQL (3.7ms) select count(value) from "tsdata" where (inst = '3') and (time > now() - 65s)
D, [2018-10-08T17:49:02.044959 #101] DEBUG -- : InfluxDB SQL (3.7ms) select count(value) from "tsdata" where (inst = '4') and (time > now() - 65s)
D, [2018-10-08T17:49:02.049124 #101] DEBUG -- : InfluxDB SQL (3.4ms) select count(value) from "tsdata" where (inst = '5') and (time > now() - 65s)
I, [2018-10-08T17:49:02.053013 #101] INFO -- : Rendered dashboard/_samples_per_minute.html.haml (2.6ms)
I, [2018-10-08T17:49:02.057868 #101] INFO -- : Rendered dashboard/_samples_per_hour.html.haml (4.5ms)
I, [2018-10-08T17:49:02.059556 #101] INFO -- : Rendered dashboard/_samples_per_day.html.haml (1.4ms)
I, [2018-10-08T17:49:02.059671 #101] INFO -- : Rendered dashboard/index.html.haml within layouts/application (33.7ms)
I, [2018-10-08T17:49:02.061785 #101] INFO -- : Rendered layouts/_bannerbar.html.haml (0.8ms)
I, [2018-10-08T17:49:02.063866 #101] INFO -- : Rendered layouts/_topnav.html.haml (1.9ms)
I, [2018-10-08T17:49:02.064154 #101] INFO -- : Rendered layouts/_messages.html.haml (0.1ms)
I, [2018-10-08T17:49:02.064504 #101] INFO -- : Rendered layouts/_footer.html.haml (0.1ms)
I, [2018-10-08T17:49:02.065014 #101] INFO -- : Completed 200 OK in 5055ms (Views: 39.4ms | ActiveRecord: 3.6ms)
I, [2018-10-08T17:59:32.144969 #95] INFO -- : Started GET "/dashboard" for 128.117.153.159 at 2018-10-08 17:59:32 +0000
I, [2018-10-08T17:59:32.147888 #95] INFO -- : Processing by DashboardController#index as HTML
D, [2018-10-08T17:59:32.149538 #95] DEBUG -- : Profile Load (0.7ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` ASC LIMIT 1
D, [2018-10-08T17:59:32.150664 #95] DEBUG -- : Site Load (0.3ms) SELECT `sites`.* FROM `sites` ORDER BY `sites`.`id` ASC LIMIT 1
D, [2018-10-08T17:59:32.151605 #95] DEBUG -- : Instrument Load (0.3ms) SELECT `instruments`.* FROM `instruments` ORDER BY `instruments`.`id` ASC LIMIT 1
D, [2018-10-08T17:59:32.153784 #95] DEBUG -- : CACHE (0.0ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` ASC LIMIT 1
D, [2018-10-08T17:59:35.418544 #95] DEBUG -- : InfluxDB SQL (3261.3ms) select count(value) from "tsdata"
D, [2018-10-08T17:59:35.436650 #95] DEBUG -- : InfluxDB SQL (17.2ms) select sum(diskBytes) / 1024 /1024 from _internal."monitor"."shard" where time > now() - 20s
D, [2018-10-08T17:59:35.444787 #95] DEBUG -- : InfluxDB SQL (7.8ms) show retention policies
D, [2018-10-08T17:59:35.448542 #95] DEBUG -- : (0.6ms) SELECT COUNT(*) FROM `sites` WHERE (1=1)
D, [2018-10-08T17:59:35.449430 #95] DEBUG -- : Instrument Load (0.5ms) SELECT `instruments`.* FROM `instruments` WHERE (1=1)
D, [2018-10-08T17:59:35.450641 #95] DEBUG -- : Instrument Load (0.3ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:59:35.467032 #95] DEBUG -- : InfluxDB SQL (15.6ms) select * from "tsdata" where (inst = '1') order by desc limit 1
D, [2018-10-08T17:59:35.484153 #95] DEBUG -- : InfluxDB SQL (16.5ms) select * from "tsdata" where (inst = '2') order by desc limit 1
D, [2018-10-08T17:59:35.500928 #95] DEBUG -- : InfluxDB SQL (16.1ms) select * from "tsdata" where (inst = '3') order by desc limit 1
D, [2018-10-08T17:59:35.513929 #95] DEBUG -- : InfluxDB SQL (12.4ms) select * from "tsdata" where (inst = '4') order by desc limit 1
D, [2018-10-08T17:59:35.544492 #95] DEBUG -- : InfluxDB SQL (30.0ms) select * from "tsdata" where (inst = '5') order by desc limit 1
D, [2018-10-08T17:59:35.545922 #95] DEBUG -- : Instrument Load (0.7ms) SELECT `instruments`.* FROM `instruments` WHERE `instruments`.`id` = 3 LIMIT 1
D, [2018-10-08T17:59:35.547743 #95] DEBUG -- : Profile Load (0.6ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` DESC LIMIT 1
D, [2018-10-08T17:59:35.553363 #95] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:59:35.578635 #95] DEBUG -- : InfluxDB SQL (24.6ms) select count(value) from "tsdata" where (time > 1539014375552869888 and time <= 1539021575552869888) group by time(1m), inst
D, [2018-10-08T17:59:35.594040 #95] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:59:35.774124 #95] DEBUG -- : InfluxDB SQL (179.5ms) select count(value) from "tsdata" where (time > 1538416775552869888 and time <= 1539021575552869888) group by time(1h), inst
D, [2018-10-08T17:59:35.806680 #95] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:59:36.951834 #95] DEBUG -- : InfluxDB SQL (1144.3ms) select count(value) from "tsdata" where (time > 1533837575552869888 and time <= 1539021575552869888) group by time(1d), inst
D, [2018-10-08T17:59:36.999059 #95] DEBUG -- : InfluxDB SQL (3.4ms) select count(value) from "tsdata" where (inst = '1') and (time > now() - 65s)
D, [2018-10-08T17:59:37.004862 #95] DEBUG -- : InfluxDB SQL (3.6ms) select count(value) from "tsdata" where (inst = '2') and (time > now() - 65s)
D, [2018-10-08T17:59:37.009272 #95] DEBUG -- : InfluxDB SQL (3.3ms) select count(value) from "tsdata" where (inst = '3') and (time > now() - 65s)
D, [2018-10-08T17:59:37.013347 #95] DEBUG -- : InfluxDB SQL (3.1ms) select count(value) from "tsdata" where (inst = '4') and (time > now() - 65s)
D, [2018-10-08T17:59:37.018622 #95] DEBUG -- : InfluxDB SQL (4.5ms) select count(value) from "tsdata" where (inst = '5') and (time > now() - 65s)
I, [2018-10-08T17:59:37.026688 #95] INFO -- : Rendered dashboard/_samples_per_minute.html.haml (6.7ms)
I, [2018-10-08T17:59:37.035551 #95] INFO -- : Rendered dashboard/_samples_per_hour.html.haml (7.9ms)
I, [2018-10-08T17:59:37.048603 #95] INFO -- : Rendered dashboard/_samples_per_day.html.haml (12.1ms)
I, [2018-10-08T17:59:37.048775 #95] INFO -- : Rendered dashboard/index.html.haml within layouts/application (72.0ms)
I, [2018-10-08T17:59:37.060080 #95] INFO -- : Rendered layouts/_bannerbar.html.haml (3.9ms)
I, [2018-10-08T17:59:37.068186 #95] INFO -- : Rendered layouts/_topnav.html.haml (7.3ms)
I, [2018-10-08T17:59:37.070772 #95] INFO -- : Rendered layouts/_messages.html.haml (1.8ms)
I, [2018-10-08T17:59:37.073289 #95] INFO -- : Rendered layouts/_footer.html.haml (1.7ms)
I, [2018-10-08T17:59:37.073896 #95] INFO -- : Completed 200 OK in 4926ms (Views: 107.2ms | ActiveRecord: 4.0ms)
D, [2018-10-08T17:38:27.633273 #105] DEBUG -- : InfluxDB SQL (1841.6ms) select count(value) from "tsdata"
D, [2018-10-08T17:38:27.639418 #105] DEBUG -- : InfluxDB SQL (5.9ms) select sum(diskBytes) / 1024 /1024 from _internal."monitor"."shard" where time > now() - 20s
D, [2018-10-08T17:38:27.642071 #105] DEBUG -- : InfluxDB SQL (2.4ms) show retention policies
D, [2018-10-08T17:38:27.644218 #105] DEBUG -- : (0.6ms) SELECT COUNT(*) FROM `sites` WHERE (1=1)
D, [2018-10-08T17:38:27.645312 #105] DEBUG -- : Instrument Load (0.6ms) SELECT `instruments`.* FROM `instruments` WHERE (1=1)
D, [2018-10-08T17:38:27.646554 #105] DEBUG -- : Instrument Load (0.4ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:38:27.663736 #105] DEBUG -- : InfluxDB SQL (16.4ms) select * from "tsdata" where (inst = '1') order by desc limit 1
D, [2018-10-08T17:38:27.686737 #105] DEBUG -- : InfluxDB SQL (22.6ms) select * from "tsdata" where (inst = '2') order by desc limit 1
D, [2018-10-08T17:38:27.703615 #105] DEBUG -- : InfluxDB SQL (16.5ms) select * from "tsdata" where (inst = '3') order by desc limit 1
D, [2018-10-08T17:38:27.717511 #105] DEBUG -- : InfluxDB SQL (13.6ms) select * from "tsdata" where (inst = '4') order by desc limit 1
D, [2018-10-08T17:38:27.730015 #105] DEBUG -- : InfluxDB SQL (12.0ms) select * from "tsdata" where (inst = '5') order by desc limit 1
D, [2018-10-08T17:38:27.731307 #105] DEBUG -- : Instrument Load (0.7ms) SELECT `instruments`.* FROM `instruments` WHERE `instruments`.`id` = 5 LIMIT 1
D, [2018-10-08T17:38:27.733102 #105] DEBUG -- : Profile Load (0.6ms) SELECT `profiles`.* FROM `profiles` ORDER BY `profiles`.`id` DESC LIMIT 1
D, [2018-10-08T17:38:27.734893 #105] DEBUG -- : CACHE (0.1ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:38:27.771507 #105] DEBUG -- : InfluxDB SQL (35.9ms) select count(value) from "tsdata" where (time > 1539013107734275840 and time <= 1539020307734275840) group by time(1m), inst
D, [2018-10-08T17:38:27.786283 #105] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:38:27.900945 #105] DEBUG -- : InfluxDB SQL (114.1ms) select count(value) from "tsdata" where (time > 1538415507734275840 and time <= 1539020307734275840) group by time(1h), inst
D, [2018-10-08T17:38:27.921016 #105] DEBUG -- : CACHE (0.0ms) SELECT `instruments`.* FROM `instruments`
D, [2018-10-08T17:38:28.593379 #105] DEBUG -- : InfluxDB SQL (671.7ms) select count(value) from "tsdata" where (time > 1533836307734275840 and time <= 1539020307734275840) group by time(1d), inst
D, [2018-10-08T17:38:28.606423 #105] DEBUG -- : InfluxDB SQL (3.4ms) select count(value) from "tsdata" where (inst = '1') and (time > now() - 65s)
D, [2018-10-08T17:38:28.611883 #105] DEBUG -- : InfluxDB SQL (4.2ms) select count(value) from "tsdata" where (inst = '2') and (time > now() - 65s)
D, [2018-10-08T17:38:28.616132 #105] DEBUG -- : InfluxDB SQL (3.4ms) select count(value) from "tsdata" where (inst = '3') and (time > now() - 65s)
D, [2018-10-08T17:38:28.620518 #105] DEBUG -- : InfluxDB SQL (3.6ms) select count(value) from "tsdata" where (inst = '4') and (time > now() - 65s)
D, [2018-10-08T17:38:28.624580 #105] DEBUG -- : InfluxDB SQL (3.3ms) select count(value) from "tsdata" where (inst = '5') and (time > now() - 65s)
I, [2018-10-08T17:38:28.627920 #105] INFO -- : Rendered dashboard/_samples_per_minute.html.haml (2.5ms)
I, [2018-10-08T17:38:28.631959 #105] INFO -- : Rendered dashboard/_samples_per_hour.html.haml (3.7ms)
I, [2018-10-08T17:38:28.633747 #105] INFO -- : Rendered dashboard/_samples_per_day.html.haml (1.5ms)
I, [2018-10-08T17:38:28.633866 #105] INFO -- : Rendered dashboard/index.html.haml within layouts/application (31.8ms)
I, [2018-10-08T17:38:28.635888 #105] INFO -- : Rendered layouts/_bannerbar.html.haml (0.7ms)
I, [2018-10-08T17:38:28.645493 #105] INFO -- : Rendered layouts/_topnav.html.haml (9.4ms)
I, [2018-10-08T17:38:28.645858 #105] INFO -- : Rendered layouts/_messages.html.haml (0.1ms)
I, [2018-10-08T17:38:28.646187 #105] INFO -- : Rendered layouts/_footer.html.haml (0.1ms)
I, [2018-10-08T17:38:28.646568 #105] INFO -- : Completed 200 OK in 2862ms (Views: 45.0ms | ActiveRecord: 4.1ms)
Project Management
- Stakeholders
- Communication
- Use Cases
- Requirements
- Deliverables
- Milestones Associated with a Release
- "Sandbox" Milestones
- Github Workflow
AWS
- AWS Portal Migrations
- Amazon Appliance Workflow
- Overview
- Bringing up a new CHORDS Portal
- Cloud Formation
- EC2 Costing and Memory Constraints
Docker
- Running CHORDS
- Docker on AWS
- Duplicating Docker/Influxdb portals
- Docker on Raspberry Pi
- Docker Details and Tips
- Running CHORDS on Windows 10
Influxdb
Data Formats
Google Maps
Ingest Utilities
Miscellaneous
- Recovery from a full disk
- Github/Dockerhub release scheme
- CHORDS gh-pages and jeykll
- Bootstrap
- CHORDS Portal Web Site
- Dashboard Helper Refactor
- Development Notes
- Heroku
- Meteobridge
- Migrating from mysql to mysql/influxdb portals
- NCAR Wx Stations into CHORDS
- PAWS to CHORDS
- Post Get Query Syntax
- Postgres Testing
- Rails Tips
- Ruby and Rails Resources
- CUAHSI Archive
Historical Archive