Using the SHOW DIAGNOSTICS statement to monitoring InfluxDB

Diagnostic information includes mostly information about your InfluxDB server that is not necessarily numerical in format. This diagnostic information is not stored in the _internal database.

To see InfluxDB server or node diagnostic information, you can use the SHOW DIAGNOSTICS statement. This statement returns InfluxDB instance information, including build details, uptime, hostname, server configuration, memory usage, and Go runtime diagnostics. This information is particularly useful to InfluxData Support, so be sure to include the output of this query anytime you file a support ticket or GitHub issue.

SHOW DIAGNOSTICS measurement details

The SHOW DIAGNOSTICS statement returns the following information.

build

  • Branch
  • Build Time
  • Commit

config

  • bind-address
  • reporting-disabled

config-coordinator

  • log-queries-after
  • max-concurrent-queries
  • max-select-buckets
  • max-select-point
  • max-select-series
  • query-timeout
  • write-timeout

config-cqs

  • enabled
  • query-stats-enabled
  • run-interval

config-data

  • cache-max-memory-size
  • cache-snapshot-memory-size
  • cache-snapshot-write-cold-duration
  • compact-full-write-cold-duration
  • dir
  • max-concurrent-compactions
  • max-series-per-database
  • max-values-per-tag
  • wal-dir
  • wal-fsync-delay

config-httpd

  • access-log-path
  • bind-address
  • enabled
  • https-enabled
  • max-connection-limit
  • max-row-limit

config-meta

  • dir

config-monitor

  • store-database
  • store-enabled
  • store-interval

config-precreator

  • advance-period
  • check-interval
  • enabled

config-retention

  • check-interval
  • enabled

config-subscriber

  • enabled
  • http-timeout
  • write-buffer-size
  • write-concurrency

network

  • hostname

runtime

  • GOARCH
  • GOMAXPROCS
  • GOOS
  • version

system

  • PID currentTime
  • started
  • uptime

Example of SHOW DIAGNOSTICS output

Here is an example of the output returned when running the SHOW DIAGNOSTICS statement on an InfluxDB OSS server.

> show diagnostics
name: build
Branch Build Time Commit                                   Version
------ ---------- ------                                   -------
master            389de31c961831de0a9f4172173337d4a6193909 v1.6.3

name: config
bind-address   reporting-disabled
------------   ------------------
127.0.0.1:8088 false

name: config-coordinator
log-queries-after max-concurrent-queries max-select-buckets max-select-point max-select-series query-timeout write-timeout
----------------- ---------------------- ------------------ ---------------- ----------------- ------------- -------------
0s                0                      0                  0                0                 0s            10s

name: config-cqs
enabled query-stats-enabled run-interval
------- ------------------- ------------
true    false               1s

name: config-data
cache-max-memory-size cache-snapshot-memory-size cache-snapshot-write-cold-duration compact-full-write-cold-duration dir                          max-concurrent-compactions max-series-per-database max-values-per-tag wal-dir                     wal-fsync-delay
--------------------- -------------------------- ---------------------------------- -------------------------------- ---                          -------------------------- ----------------------- ------------------ -------                     ---------------
1073741824            26214400                   10m0s                              4h0m0s                           /usr/local/var/influxdb/data 0                          1000000                 100000             /usr/local/var/influxdb/wal 0s

name: config-httpd
access-log-path bind-address enabled https-enabled max-connection-limit max-row-limit
--------------- ------------ ------- ------------- -------------------- -------------
                :8086        true    false         0                    0

name: config-meta
dir
---
/usr/local/var/influxdb/meta

name: config-monitor
store-database store-enabled store-interval
-------------- ------------- --------------
_internal      true          10s

name: config-precreator
advance-period check-interval enabled
-------------- -------------- -------
30m0s          10m0s          true

name: config-retention
check-interval enabled
-------------- -------
30m0s          true

name: config-subscriber
enabled http-timeout write-buffer-size write-concurrency
------- ------------ ----------------- -----------------
true    30s          1000              40

name: network
hostname
--------
influxdb-1.local

name: runtime
GOARCH GOMAXPROCS GOOS   version
------ ---------- ----   -------
amd64  8          darwin go1.11

name: system
PID currentTime                 started                     uptime
--- -----------                 -------                     ------
940 2018-10-15T15:07:47.435739Z 2018-10-15T06:03:34.002126Z 9h4m13.433613s

This documentation is open source. See a typo? Please, open an issue.

Need help getting up and running? Get Support