duckservability

KO | EN

gitlite — search

#ai #typescript #llm #go #android #machine-learning #docker #macos #nodejs #java #awesome #kubernetes #vue #pytorch

duckservability

(★ 31)

Inspect Your Servers with DuckDB

duckservability 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Duckservability: Query Your Linux Systems
Duckservability is a DuckDB database schema for querying standard Linux systems via the `/proc` virtual file system which exposes real time kernel and process statistics. Traditionally files exposing these statistics have been aggregated via unix commandline tools. This project wraps these files in database tables that can be queried, joined, etc via SQL.

# Goals
Duckservability is primarily meant as a proof of concept. The overarching goal is to illustrate a class of things that can be done when the traditionally coupled storage and compute components of a database system are decoupled.

# Getting Started
Note that Duckservability presently only works on Linux and other Linux like systems.

1. Install [DuckDB](https://duckdb.org/docs/installation/)
1. Download the [latest release](https://github.com/MarkRoddy/duckservability/releases/download/latest/duckservability.duckdb) of the DuckDB file containing the Duckservibility schema.
1. Start DuckDB by running `duckdb duckservability.duckdb`
1. Start querying! To do so, run the `show tables;` command, or run one of the [example queries](https://github.com/MarkRoddy/duckservability/releases/download/latest/duckservability-example-queries.zip).

# Example Queries
Below are a few examples of questions you can ask with Ducservability. Additionally, see the [example-queries](tree/main/example-queries) directory for more examples.

## Processes with Most IO
Query processes that have performed the most IO operation in megabytes:
<br>
![most io](https://raw.githubusercontent.com/MarkRoddy/duckservability/main/images/process-most-io.png)

## Longest Running Proccesses by CPU Time
![most cpu time](https://raw.githubusercontent.com/MarkRoddy/duckservability/main/images/processes-most-cpu-time.png)

# Production Usage
Duckservability is presently in a proof of concept state. If you're looking for a more mature SQL system for querying OS data, take a look at the [osquery](https://github.com/osquery/osquery) project.

duckservability

duckservability 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

duckservability

duckservability 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README