data-peek
Features

Health Monitor

Monitor database health with active queries, table sizes, cache ratios, and locks

Health Monitor

The Health Monitor gives you a live view of your database’s operational health without leaving data-peek.

Opening the Monitor

Click Health Monitor in the sidebar to open it as a dedicated tab.

Panels

Active Queries

See all currently running queries with:

  • Query text
  • Duration
  • State (active, idle, waiting)
  • Terminate or Kill buttons to cancel long-running queries

Table Sizes

A sortable table showing:

  • Table name
  • Total size (data + indexes)
  • Data size
  • Index size
  • Row count (estimated)

Sort by any column to find your largest tables or most indexed tables.

Cache Hit Ratios

Displays the cache hit ratio for your database, indicating how effectively PostgreSQL is using shared buffers.

Locks

Shows current lock activity and any blocking queries, helping you identify and resolve contention.

Auto-Refresh

Configure automatic polling:

IntervalUse Case
2sActive debugging
5sGeneral monitoring
10sBackground monitoring
30sLow-frequency checks
OffManual refresh only

Share as Image

Each panel has a Share button that exports the data as a styled PNG image with your choice of background theme, perfect for sharing in Slack or documentation.

The Health Monitor currently supports PostgreSQL. MySQL and MSSQL support is planned.

On this page