gistfile1.txt

> select time, first(value) from "xxx_requests.duration"
name: xxx_requests.duration
-----------------------------
time                       
2015-10-08T06:18:02.998308967Z  0.00542

> select * from  "xxx_requests.duration"
name: xxx_requests.duration
-----------------------------
time               
1444285082998308967
1444285082999406775
1444285083116193455
1444285083404847866
1444285108834115844

> select * from  "xxx_requests.duration"
name: xxx_requests.duration
-----------------------------
time               
1444285082998308967
1444285082999406775
1444285083116193455
1444285083404847866
1444285108834115844
1444285183259387523
1444285183259512963
1444285183289076534
1444285183506420752
1444285183569677543
1444285183600289371
1444285193669770884
1444285203244609547
1444285203343716266
1444285203359004153

> select * from  "xxx_requests.duration"
name: xxx_requests.duration
-----------------------------
time               
1444285183259387523
1444285183259512963
1444285183289076534
1444285183506420752
1444285183569677543
1444285183600289371
1444285193669770884
1444285203244609547
1444285203343716266
1444285203359004153
1444285226692767249
1444285232714664724
1444285238416806186
1444285241211755102
1444285241273149576
1444285241284528535
1444285246325943114
1444285246746019678
1444285253080584646
1444285253185286442
1444285255048743537
1444285257257721154

> select time, first(value) from "xxx_requests.duration"
name: xxx_requests.duration
-----------------------------
time                       
2015-10-08T06:19:43.259387523Z  0.007084

> exit
[root@rac-perfdb-p01 ~]# date
Thu Oct  8 08:21:21 CEST 2015
[root@rac-perfdb-p01 ~]#

--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------

> show stats
name: cq
--------
points_written  query_ok
4               7295


name: hh
tags: path=/var/opt/influxdb/hh
process_req
-----------
2471


name: httpd
tags: bind=:8086
auth_fail       ping_req        query_req       query_resp_bytes        req
---------       --------        ---------       ----------------        ---
2               3               3027            51487533                3052


name: shard
tags: engine=tsm1, id=1, path=/var/opt/influxdb/data/_internal/monitor/1
fields_create   series_create   write_points_ok write_req
-------------   -------------   --------------- ---------
9               10              2465            247


name: shard
tags: engine=tsm1, id=3, path=/var/opt/influxdb/data/xxx_nonprod/default/3
fields_create   series_create   write_points_ok write_req
-------------   -------------   --------------- ---------
33              1049            4535            154


name: shard
tags: engine=tsm1, id=2, path=/var/opt/influxdb/data/xxx_prod/default/2
fields_create   series_create   write_points_ok write_req
-------------   -------------   --------------- ---------
480             859             157108          492


name: udp
tags: bind=10.100.20.40:4444
batches_tx      bytes_rx        points_rx       points_tx
----------      --------        ---------       ---------
488             16030150        157297          157104


name: udp
tags: bind=10.100.20.40:4445
batches_tx      bytes_rx        points_rx       points_tx
----------      --------        ---------       ---------
154             482634          4565            4535


name: write
-----------
point_req       point_req_local req     write_ok
164108          164108          893     893


name: runtime
-------------
Alloc           Frees           HeapAlloc       HeapIdle        HeapInUse       HeapObjects     HeapReleased    HeapSys         Lookups Mallocs         NumGC   NumGoroutine    PauseTotalNs    Sys             TotalAlloc
24205024        54190028        24205024        22478848        25821184        269365          0               48300032        355     54459393        1017    54              472288023       54737144        11314965920