dlt

dlt / pg_glimpse

Public

🐘 Terminal-based PostgreSQL dashboard for monitoring queries, locks, replication, and performance

cli monitoring observability postgresql ratatui
71
1
100% credibility
Found Feb 09, 2026 at 17 stars 4x -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Rust
AI Summary

A terminal-based real-time monitoring dashboard for PostgreSQL databases that displays active queries, performance graphs, locks, replication status, and more.

How It Works

1
🔍 Discover pg_glimpse

You hear about a handy terminal tool that lets you watch your database's health in real-time, like a dashboard right in your command line.

2
📥 Get it ready

You quickly download and set up the tool on your computer so it's ready to use.

3
🔌 Connect your database

You tell the tool where your PostgreSQL database lives, using simple details like host and name, and it connects securely.

4
📊 See live insights

Beautiful graphs and lists pop up showing active queries, connection counts, slow spots, and cache performance updating every few seconds.

5
🔄 Explore different views

Switch between panels to check locks, replication delays, cleanup progress, or table bloat with easy keyboard shortcuts.

6
📹 Record for later

The tool automatically saves sessions so you can replay them to review past issues or share with your team.

✅ Database stays healthy

You spot slow queries, fix blocks early, and keep everything running smoothly without fancy setups.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 17 to 71 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is pg_glimpse?

pg_glimpse is a terminal-based PostgreSQL dashboard built in Rust, delivering real-time monitoring of queries, locks, replication lag, and performance metrics like cache hit ratios and TPS directly in your shell. It replaces clunky web-based tools with a fast TUI featuring panels for active queries, blocking chains, vacuum progress, WAL I/O, and sparklines for trends in connections and query latency. Developers get instant insights without leaving the terminal or spinning up a browser.

Why is it gaining traction?

Its Rust-powered speed and ratatui interface make it snappier than browser dashboards, with fuzzy filtering, SQL yanking to clipboard, and inspect overlays for query details. Unique hooks include automatic session recordings for incident replay—step through outages at variable speeds—and batch cancel/kill from the UI. Themes, configurable refresh rates, and Homebrew/Cargo installs lower the barrier for quick spins.

Who should use this?

Postgres DBAs on-call debugging slow queries or lock storms, SREs chasing replication lag during outages, and backend devs tuning performance without pgAdmin overhead. Ideal for ops-heavy teams preferring terminal workflows over Grafana setups.

Verdict

Grab it if you live in the terminal—early promise in replay and kill features outweighs the 19 stars and 1.0% credibility score. Actively developed but expect bugs; solid CI/coverage, watch for stability.

(187 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.