get_database_conflicts_stats
Retrieve query conflict statistics by type on standby or replica databases to diagnose replication lag and performance issues.
Instructions
[Tool Purpose]: Analyze query conflicts in standby/replica database environments
[Exact Functionality]:
Show conflict statistics for standby servers (only relevant on replicas)
Display conflicts by type (tablespace, lock, snapshot, bufferpin, deadlock)
Help diagnose replication-related performance issues
Provide conflict resolution statistics
[Required Use Cases]:
When user requests "replication conflicts", "standby conflicts", etc.
When analyzing replica server performance issues
When troubleshooting replication lag or conflicts
When monitoring standby server health
[Strictly Prohibited Use Cases]:
Requests for conflict resolution actions
Requests for replication configuration changes
Requests for statistics reset
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_database_conflicts_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | Database name to analyze (uses default database if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |