Datasentinel Docs
Visit our websiteBlogRelease Notes
  • 👋Welcome
  • 🆓Free Trial
  • 📣Release Notes
  • Getting started
    • Architecture
    • Installation
      • 🌐Platform
      • 🕶️Agent
    • PostgreSQL clusters
      • 🔌Extensions
        • 🔌pg_stat_statements
        • 🔌pg_store_plans
        • 🔌system_stats
        • 🔌pg_buffercache
      • 🕶️Monitoring User
      • ➕Adding Connection
    • FAQs
      • ❓Platform FAQ
      • ❓Agent FAQ
  • Features
    • Key Features
      • 📊Session History
      • 📊Top Queries
      • 📂Top Tables
      • 🔓Lock Explorer
      • 📈Cluster & System Metrics
      • ⌚Live360
      • 📰Reporting
      • 🔔Alerting
        • Settings
        • Templates
        • Silences
        • Manager
    • Other Features
      • 📡Agentless Monitoring
      • 🛡️Role Based Access
      • 🔂Changed Parameters
    • Tips & Hints
      • 🖥️User Interface
      • 🏷️Tags
      • 🔀Metric Correlation
      • 👁️‍🗨️Consolidated View
      • ❗Graphical Annotations
      • ☁️Predefined Providers
      • ❓Wait Event Description
      • ®️Read Replicas
      • 👁️‍🗨️Agentless & System Metrics
      • ☑️Simplified pg_instance Display
  • implementation
    • Platform Usage
      • ⚙️Configuration
        • 🔑License
        • 📓LDAP
        • ✉️SMTP
        • 📋Audit
        • 👨‍🏭Users & Roles
      • 🧩API
        • 🔗Access Token
        • 🧩Connection API
        • 🧩Role API
        • 🧩User API
        • 🧩Reporting API
        • 🧩Workload API
        • 🧩Alerting API
      • 🛠️Tooling
    • Agent Usage
      • 📣Release Notes
      • ⌨️CLI
      • 🧩API
      • 🗃️Collection Level
      • 🔬Internals
    • Upgrade
      • 🔄Platform
      • 🔄Agent
    • Troubleshooting
      • 🩺Error message: “502 Bad Gateway”
      • 🩺The UI is not displaying any metrics for my new instance.
      • 🩺UI dashboard is encountering loading errors
      • 🩺InfluxDB
  • Support
    • How to Contact Us
  • GitHub Toolkit
Powered by GitBook
On this page
  • Refer to Blog Post
  • How it Operates
  • Visualization
  • Interactive Demo
  1. Features
  2. Key Features

Lock Explorer

Lock explorer makes it easy to identify blocking sessions during blocked session issues, along with the associated queries and locks.

PreviousTop TablesNextCluster & System Metrics

Last updated 1 year ago

By continuously monitoring lock activity, Datasentinel offers insights into your database’s state and assists you in addressing issues by generating blocking scenarios that give comprehensive information about lock activity during blocked session incidents.

Refer to Blog Post

How it Operates

Lock explorer is enabled by default and requires a minimum agent version of v3.2.

Datasentinel performs a check every minute to determine if there are any blocked sessions. If a blocked session duration exceeds the specified delay (default is 30s), a blocking scenario is generated and sent to the platform.

A blocking scenario includes the identification of the blocking session, the locks held, the current query at the time of check, and the properties of the blocked sessions.

The blocking scenario is then updated every minute until it is resolved.

Visualization

When a blocking scenario occurs, a graphical annotation is added to the main dashboards to highlight the problem. This annotation displays information about the blocking session and the number of blocked sessions. By clicking on the dashboard link, you can access more detailed information.

The Blocking Scenarios dashboard presents an overview of current session activity in the main graph.

The bottom portion of the dashboard is split into two sections.

On the left, you will see a list of all blocking scenarios that occurred during the selected time frame. Simply click on a scenario to access its detailed information.

The information displayed for each scenario includes:

  • Details of the blocking session, including its current query and the locks held at the time of the scan made by Datasentinel.

  • The number of blocked sessions and details about each, including the waiting lock and current waiting query.

Interactive Demo

Lock monitoring can be enabled or disabled and the delay can be adjusted through the agent or .

🔓
Agent CLI
Agent API
PostgreSQL Locks
Logo