Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

A visual stat tool for CrateDB clusters

Project Description

cstat

A visual stat tool for CrateDB clusters.

cstat is ispired by the awesome interactive process monitoring tool htop. cstat should be a similar tool to iostat, but for monitoring CrateDB clusters.

Installation

Right now, stat is only available from Github. Therefore you need to checkout the repository and run pip install on the local directory.

git clone https://github.com/chaudum/crate-top.git cstat
cd cstat
python3.4 -m venv env
source ./env/bin/activate
pip install -e .

cstat requires Python 3.6 or greater and can connect to CrateDB 2.x.

Usage

After installation you can monitor CrateDB running on localhost with default configuration by invoking the following command:

>>> cstat --user crate

A full list of command line arguments are listed when invoking cstat with the --help argument:

>>> cstat --help
usage: cstat [-h] [--host HOST] [--port PORT] [--interval INTERVAL]
             [--user USER] [--version]

A visual stat tool for CrateDB clusters

optional arguments:
  -h, --help            show this help message and exit
  --host HOST, --crate-host HOST
                        CrateDB host to connect to
  --port PORT, --psql-port PORT
                        PSQL port of CrateDB host
  --interval INTERVAL, --refresh-interval INTERVAL
                        amount of time in seconds between each update
  --user USER, --db-user USER
                        database user
  --version             show program's version number and exit

By default cstat connects to localhost on port 5432 if not otherwise specified.

Keyboard Shortcuts

  • 0 … toggle cluster info
  • 1 … show utilization for CPU, process, memory, heap and disk
  • 2 … show I/O statistics for network and disk
  • 3 … show aggregated query duration based on jobs_log
  • x … toggle nodes/aggregation view
  • f3 … enable/disable job logging (this also sets the stats.jobs_log cluster setting)

Known Issues

  • Small terminal sizes will raise CanvasErrors because of content overflow.

Todo

  • [x] display disk usage
  • [x] display disk i/o
  • [x] display network i/o
  • [x] display node names in detail views
  • [x] use asyncio to perform http requests
  • [x] coloring of i/o stats
  • [ ] responsive i/o widget

Changelog for cstat

Unreleased

0.2.0

Released on 2017/11/14 with the following changes:

  • Implemented asynchronous database access using aiopg which uses the Postgres Wire Protocol instead of the official CrateDB Python client which uses the HTTP protocol.
  • Added median, percentile 95, and percentile 99 to query stats table view.
  • Added --user/--db-user command line argument to support user authentication for clusters which run CrateDB 2.0 or greater.
  • Changed the toggle key for enabling/disabling query stats from F1 to F3, because in the Terminator terminal the F1 key is reserved for “help”.
  • Pre-calculate used and idle CPU in SQL statement to avoid rounding issues that can cause an display overflow in CPU widget.

0.1.0

Initial release on 2017/03/30:

Release History

Release History

This version
History Node

0.2.0

History Node

0.1.0

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
cstat-0.2.0-py3-none-any.whl (18.7 kB) Copy SHA256 Checksum SHA256 py3 Wheel Nov 14, 2017
cstat-0.2.0.tar.gz (60.8 kB) Copy SHA256 Checksum SHA256 Source Nov 14, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting