That works for the `pointsWritten` value, but not the `writeFailures` value:
> select sum(writeFailures) from subscriber where "database" != '' and time > > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' name: subscriber ---------------- time sum 1475727840000000001 0 > select sum(writeFailures) from subscriber where "database" = '' and time > > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' name: subscriber ---------------- time sum 1475727840000000001 5135757 > select difference(writeFailures) from subscriber where time > > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' group by > "database","destination" name: subscriber tags: database=, destination= time difference ---- ---------- 1475727860000000000 0 1475727870000000000 44 1475727880000000000 30 1475727890000000000 0 name: subscriber tags: database=_internal, destination=http://localhost:9092 time difference ---- ---------- 1475727860000000000 0 1475727870000000000 0 1475727880000000000 0 1475727890000000000 0 name: subscriber tags: database=commerce, destination=http://localhost:9092 time difference ---- ---------- 1475727860000000000 0 1475727870000000000 0 1475727880000000000 0 1475727890000000000 0 name: subscriber tags: database=telegraf, destination=http://localhost:9092 time difference ---- ---------- 1475727860000000000 0 1475727870000000000 0 1475727880000000000 0 1475727890000000000 0 -Patrick On Wednesday, October 5, 2016 at 7:42:32 PM UTC-4, Sean Beckett wrote: > The "subscriber" metrics with no associated database are the totals across > all databases. To put it into InfluxQL: > > > > select sum(pointsWritten) from "subscriber" where time > now() - 10s and > "database" != ''; > select sum(pointsWritten) from "subscriber" where time > now() - 10s and > "database" = '' > > > Those will return the same values. > > > > On Wed, Oct 5, 2016 at 3:29 PM, Sean Beckett <[email protected]> wrote: > > Good question, Patrick. I assume it's measuring some internal metrics > gathering, but I'll ask the devs. We're in the process of fully documenting > all _internal values, but I still don't know all of them. > > > > > On Wed, Oct 5, 2016 at 2:46 PM, <[email protected]> wrote: > I was looking at the _internal..subscriber measurement to generate a report > when there are write errors when I ran across this which has me confused: > > > > > select * from _internal..subscriber where "database"='' and time > now() - > > 1m > > name: subscriber > > ---------------- > > time database destination hostname mode > name pointsWritten retention_policy writeFailures > > 1475700180000000000 iad1aixd01 > 192434264 991194 > > 1475700190000000000 iad1aixd01 > 192435540 991194 > > 1475700200000000000 iad1aixd01 > 192436834 991194 > > 1475700210000000000 iad1aixd01 > 192438705 991194 > > 1475700220000000000 iad1aixd01 > 192440276 991194 > > 1475700230000000000 iad1aixd01 > 192442036 991194 > > > > > > What is this? There's no database, destination, name, etc. > > > > show subscriptions has the following: > > > > > show subscriptions > > name: telegraf > > -------------- > > retention_policy name mode > destinations > > autogen kapacitor-0411293e-3763-4774-92f8-e4df678f27f4 ANY > [http://localhost:9092] > > > > > > name: _internal > > --------------- > > retention_policy name mode > destinations > > monitor kapacitor-0411293e-3763-4774-92f8-e4df678f27f4 ANY > [http://localhost:9092] > > > > > > name: commerce > > -------------- > > retention_policy name mode > destinations > > autogen kapacitor-0411293e-3763-4774-92f8-e4df678f27f4 ANY > [http://localhost:9092] > > > > > > > > Thanks > > > > -Patrick > > > > -- > > Remember to include the InfluxDB version number with all issue reports > > --- > > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To post to this group, send email to [email protected]. > > Visit this group at https://groups.google.com/group/influxdb. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/998a8025-a9fa-4458-9230-2a3a01e29deb%40googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/16e060b2-3be2-450c-9ab6-cace7faa0b81%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
