Explorers

Explore any database from one set of data.

Start from a database, a session, a query or a schema object. Every explorer works on the same data the agent already sends, so the views always agree.

Database Explorer

Every database, at a glance.

Status, CPU, memory and open alerts for every database you monitor. Open one to see its health score from 0 to 100, traced back to the alerts that lowered it.

The Databases page in the Logstag app: every monitored database with its instance, engine, status, CPU and memory use, and open alerts by severity.
  • Everything you monitor

    Databases across every engine and instance in one list, filtered by the instances and time range you choose.

  • Health you can trace

    Each database scores from 0 to 100 across five dimensions, and each dimension opens the alerts that lowered it.

  • Against the period before

    CPU and memory use are shown against the previous period, so changes stand out.

Activity Explorer

Who is waiting, and on what.

Sessions, wait events and locks for each database, with blocking chains that start at the root blocker.

Activity for one PostgreSQL database in the Logstag app: wait events, locks and blocked processes, the wait events of the past week by type, and the sessions waiting now.
  • Blocking chains from the root

    Chains start at the root blocker, with each blocked session under the one holding it.

  • Wait events by type

    See what sessions are waiting on, now and across the week: locks, I/O, client and more.

  • Back to any moment

    Pick a past moment to see sessions, locks and blocking as they were.

Query Explorer

Every query, against its own history.

One list across all your databases, sortable by time, calls, rows and alerts. Open a query for its full text and how its calls, execution time, rows and cache hits moved over time.

One query in the Logstag app: its calls, mean execution time, rows and cache hit rate over the past week, with the full query text.
  • One list, every database

    Sort by execution time, calls, rows and alerts, and filter by text, engine, database and instance.

  • Against the period before

    Execution time is compared with the previous period of the same length, so a slower query stands out without a threshold.

  • The whole story of a query

    Full text, charts of calls, mean time, rows and cache hit, detailed statistics and its alerts.

Schema Explorer

What changed in the schema, and who can touch what.

Objects with their sizes, a history of what was added, removed or modified, and a permissions view with grant and revoke history.

One schema in the Logstag app: how many objects were added, modified and removed, and the change history with when each change was detected.
  • Every change, recorded

    Objects added, removed or modified, each with the time it was detected.

  • Who can touch what

    A permissions view with grant and revoke history.

  • Objects and sizes

    Tables, indexes, views and more for each schema, with their sizes.

Explore your own databases for a month.

Connect one database or twenty. The explorers fill in as the agent's first snapshots arrive.