Skip to content

Instantly share code, notes, and snippets.

@sim51
Created June 1, 2018 14:43
Show Gist options
  • Select an option

  • Save sim51/de002724b41c5bdcb1a6dee84edc9120 to your computer and use it in GitHub Desktop.

Select an option

Save sim51/de002724b41c5bdcb1a6dee84edc9120 to your computer and use it in GitHub Desktop.
+-------------------------------+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Name | Type | Query |
+-------------------------------+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Thread Jetty | Line Graph | SELECT mean("threads.jetty.all") AS "mean_threads.jetty.all", mean("threads.jetty.idle") AS "mean_threads.jetty.idle" FROM "telegraf"."autogen"."neo4j.server" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(null) |
| JVM memory | Stacked Graph | SELECT pool.g1_survivor_space/1000000, pool.metaspace/1000000, pool.g1_eden_space/1000000, pool.g1_old_gen/1000000 FROM "telegraf"."autogen"."vm.memory"WHERE time > :dashboardTime: |
| JVM GC Time | Line Graph | SELECT DIFFERENCE("time.g1_young_generation") AS "mean_time.g1_young_generation", DIFFERENCE("time.g1_old_generation") AS "mean_time.g1_old_generation" FROM "telegraf"."autogen"."vm.gc" WHERE time > :dashboardTime: |
| Transactions | Line Graph | SELECT DIFFERENCE(last("started")) AS "mean_started" FROM "telegraf"."autogen"."neo4j.transaction" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(linear) |
| Page cache | Line Graph | SELECT mean("hits") AS "mean_hits", mean("page_faults") AS "mean_page_faults", mean("flushes") AS "mean_flushes",mean("evictions") AS "mean_evictions", mean("eviction_exceptions") AS "mean_eviction_exceptions" FROM "telegraf"."autogen"."neo4j.page_cache" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(null) |
| JVM Threads | Line Graph | SELECT mean("total") AS "mean_total"FROM "telegraf"."autogen"."vm.thread" WHERE time > :dashboardTime:GROUP BY time(:interval:) FILL(null) |
| Number of Nodes | Line Graph + Single stat | SELECT max("node") AS "max_node" FROM "telegraf"."autogen"."neo4j.ids_in_use" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(none) |
| Number of relationships | Line Graph + Single stat | SELECT last("relationship") AS "last_relationship" FROM "telegraf"."autogen"."neo4j.ids_in_use" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(none) |
| Number of Properties | Line Graph + Single stat | SELECT last("property") AS "last_property" FROM "telegraf"."autogen"."neo4j.ids_in_use" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(none) |
| Number of Relationship Types | Line Graph + Single stat | SELECT last("relationship_type") AS "last_relationship_type" FROM "telegraf"."autogen"."neo4j.ids_in_use" WHERE time > :dashboardTime: GROUP BY time(:interval:) FILL(none) |
| Opened Transactions | Line Graph + Single stat | SELECT started - committed - rollbacks FROM "telegraf"."autogen"."neo4j.transaction" WHERE time > :dashboardTime: |
+-------------------------------+----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment