Backlog for ctk info

Iteration +1

• Display differences to the standard configuration

• tail -f for sys.jobs_log and friends See discussion and suggestions.

• Check if the patch includes relevant details from here. https://community.cratedb.com/t/monitoring-an-on-premises-cratedb-cluster-with-prometheus-and-grafana/1236

• Inform about table sizes, like Admin UI is doing it.

• Inform about shard imbalances.

Iteration +2

• Make ctk info logs also optionally consider sys. tables.

• Make ctk info ... explore table|shard|partition|node

• High-level analysis, evaluating a set of threshold rules

• High-level summary reports with heuristics support

• Network diagnostics?

• Provide a GUI? https://github.com/davep/pispy

Iteration +3

• Make it work with CrateDB Cloud.

  ctk cluster info
  ctk cluster health
  ctk cluster logs --slow-queries
  

Iteration +4

• Expose collected data via Glances-like UI

• Experimental UI using Grafana Scenes

Done

• Make it work

• Proper marshalling of timestamp values (ISO 8601)

• Expose collected data via HTTP API

  ctk info serve
  

• Provide scrub option also via HTTP

• Complete collected queries and code snippets

• Harvest queries from Admin UI, crash, crate-admin-alt

• Harvest queries from experts

  • https://tools.cr8.net/grafana/d/RkpNJx84z/cratedb-jobs-log?orgId=1&refresh=5m&var-datasource=crate-production

  • https://tools.cr8.net/grafana/d/RkpNJx84z/cratedb-jobs-log?orgId=1&refresh=5m&var-datasource=crate-production&viewPanel=44

• Add description and unit fields to each InfoElement definition