cURL
curl --request GET \
--url 'https://app.teable.ai/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE' \
--header 'Authorization: Bearer REPLACE_BEARER_TOKEN'const url = 'https://app.teable.ai/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE';
const options = {method: 'GET', headers: {Authorization: 'Bearer REPLACE_BEARER_TOKEN'}};
try {
const response = await fetch(url, options);
const data = await response.json();
console.log(data);
} catch (error) {
console.error(error);
}const http = require('https');
const options = {
method: 'GET',
hostname: 'app.teable.ai',
port: null,
path: '/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE',
headers: {
Authorization: 'Bearer REPLACE_BEARER_TOKEN'
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on('data', function (chunk) {
chunks.push(chunk);
});
res.on('end', function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.end();import http.client
conn = http.client.HTTPSConnection("app.teable.ai")
headers = { 'Authorization': "Bearer REPLACE_BEARER_TOKEN" }
conn.request("GET", "/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE", headers=headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://app.teable.ai/api/admin/observability/table-query-ops",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://app.teable.ai/api/admin/observability/table-query-ops"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://app.teable.ai/api/admin/observability/table-query-ops")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://app.teable.ai/api/admin/observability/table-query-ops")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"summary": {
"enabled": true,
"observationWindowCount": 123,
"requestCount": 123,
"slowCount": 123,
"timeoutCount": 123,
"dbErrorCount": 123,
"openRecommendationCount": 123,
"acceptedRecommendationCount": 123,
"runningTaskCount": 123,
"failedTaskCount": 123,
"searchAccessPathReadyCount": 123,
"searchAccessPathDegradedCount": 123,
"searchAccessPathRuntimeEnabled": true,
"oldestQueuedTaskAgeMs": 123
},
"trackA": {
"sources": [
{
"source": "slow_query_observation",
"label": "<string>",
"status": "active",
"signalCount": 123,
"recommendationCount": 123,
"taskCount": 123,
"note": "<string>"
}
],
"accessPaths": [
{
"kind": "pg_btree_index",
"label": "<string>",
"track": "A",
"status": "active",
"recommendationCount": 123,
"taskCount": 123,
"note": "<string>"
}
],
"indexInventory": {
"observedTableCount": 123,
"inspectedTableCount": 123,
"usefulIndexCount": 123,
"missingIndexCandidateCount": 123,
"abnormalIndexCount": 123,
"externalIndexCount": 123,
"lastObservationTime": "<string>"
}
},
"hotTables": [
{
"spaceId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"requestCount": 123,
"slowCount": 123,
"timeoutCount": 123,
"dbErrorCount": 123,
"maxDurationMs": 123,
"spaceName": "<string>",
"baseName": "<string>",
"tableName": "<string>",
"latestWindowStart": "<string>"
}
],
"searchAccessPaths": [
{
"spaceId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"provider": "pg_bigm",
"status": "ready",
"coveredSearchableFieldCount": 1,
"currentEligibleFieldCount": 1,
"uncoveredFieldCount": 1,
"spaceName": "<string>",
"baseName": "<string>",
"tableName": "<string>"
}
],
"recommendations": {
"data": [
{
"id": "<string>",
"spaceId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"executionTarget": {
"storage": "default",
"displayHost": "<string>",
"displayDatabase": "<string>",
"internalSchema": "<string>"
},
"shapeHash": "<string>",
"policyVersion": "<string>",
"status": "open",
"riskLevel": "none",
"riskScore": 123,
"reasonCodes": [
"<string>"
],
"remediationKinds": [
"<string>"
],
"sqlDiagnostics": [
{
"source": "<string>",
"statementKind": "<string>",
"fingerprint": "<string>",
"parameterCount": 123,
"sampled": true,
"normalizedSql": "<string>"
}
],
"priorityScore": 123,
"spaceName": "<string>",
"baseName": "<string>",
"tableName": "<string>",
"remediationCandidates": [
{
"kind": "<string>",
"reason": "<string>",
"executableInPhase1": true,
"fieldId": "<string>",
"fieldDbName": "<string>",
"indexKind": "<string>",
"accessPath": "<string>",
"fields": [
{
"fieldId": "<string>",
"fieldDbName": "<string>",
"direction": "asc",
"role": "<string>"
}
]
}
],
"trigger": {
"sourceKind": "saved_view_config",
"observedWorkload": true,
"sourceId": "<string>",
"viewId": "<string>",
"fingerprint": "<string>"
},
"shapeSummary": {
"filterFields": [
{
"fieldId": "<string>",
"operatorFamily": "<string>",
"sourceKind": "<string>"
}
],
"sortFields": [
{
"direction": "asc",
"source": "<string>",
"fieldId": "<string>",
"systemColumn": "<string>"
}
],
"search": {
"fieldCount": 123,
"allFields": true,
"valueLengthBucket": "<string>"
}
},
"queryKind": "<string>",
"planValidation": {
"status": "validated",
"candidateCount": 123,
"method": "explain",
"reason": "<string>",
"startupCostBefore": 123,
"startupCostAfter": 123,
"totalCostBefore": 123,
"totalCostAfter": 123,
"planNodeBefore": "<string>",
"planNodeAfter": "<string>",
"usesCandidateIndex": true,
"indexStatements": [
"<string>"
],
"errors": [
"<string>"
]
},
"createdTime": "<string>",
"lastModifiedTime": "<string>",
"heat": {
"requestCount": 123,
"slowCount": 123,
"timeoutCount": 123,
"totalDurationMs": 123,
"maxDurationMs": 123,
"estimatedRows": 123,
"seqScanCount": 123,
"indexScanCount": 123
},
"decision": {
"action": "auto_accept",
"actor": "system_policy",
"outcome": "pending",
"wouldAutoAccept": true,
"reasonCodes": [
"<string>"
],
"cooldownUntil": "<string>",
"decidedAt": "<string>"
}
}
],
"total": 123
},
"tasks": {
"data": [
{
"id": "<string>",
"recommendationId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"kind": "<string>",
"status": "queued",
"attempts": 123,
"maxAttempts": 123,
"baseName": "<string>",
"tableName": "<string>",
"lockedBy": "<string>",
"lockedAt": "<string>",
"lastError": "<string>",
"result": null,
"createdTime": "<string>",
"lastModifiedTime": "<string>"
}
],
"total": 123
}
}admin
Get adminobservabilitytable query ops
Get Table Query Ops observation, recommendation, and task overview
Required token scopes: instance|read
GET
/
admin
/
observability
/
table-query-ops
cURL
curl --request GET \
--url 'https://app.teable.ai/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE' \
--header 'Authorization: Bearer REPLACE_BEARER_TOKEN'const url = 'https://app.teable.ai/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE';
const options = {method: 'GET', headers: {Authorization: 'Bearer REPLACE_BEARER_TOKEN'}};
try {
const response = await fetch(url, options);
const data = await response.json();
console.log(data);
} catch (error) {
console.error(error);
}const http = require('https');
const options = {
method: 'GET',
hostname: 'app.teable.ai',
port: null,
path: '/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE',
headers: {
Authorization: 'Bearer REPLACE_BEARER_TOKEN'
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on('data', function (chunk) {
chunks.push(chunk);
});
res.on('end', function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.end();import http.client
conn = http.client.HTTPSConnection("app.teable.ai")
headers = { 'Authorization': "Bearer REPLACE_BEARER_TOKEN" }
conn.request("GET", "/api/admin/observability/table-query-ops?organizationId=SOME_STRING_VALUE&spaceId=SOME_STRING_VALUE&baseId=SOME_STRING_VALUE&tableId=SOME_STRING_VALUE&recommendationStatus=SOME_STRING_VALUE&riskLevel=SOME_STRING_VALUE&taskStatus=SOME_STRING_VALUE&recommendationSkip=SOME_INTEGER_VALUE&recommendationTake=SOME_INTEGER_VALUE&taskSkip=SOME_INTEGER_VALUE&taskTake=SOME_INTEGER_VALUE&includeSearchAccessPaths=SOME_BOOLEAN_VALUE&skip=SOME_INTEGER_VALUE&take=SOME_INTEGER_VALUE", headers=headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://app.teable.ai/api/admin/observability/table-query-ops",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://app.teable.ai/api/admin/observability/table-query-ops"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://app.teable.ai/api/admin/observability/table-query-ops")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://app.teable.ai/api/admin/observability/table-query-ops")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"summary": {
"enabled": true,
"observationWindowCount": 123,
"requestCount": 123,
"slowCount": 123,
"timeoutCount": 123,
"dbErrorCount": 123,
"openRecommendationCount": 123,
"acceptedRecommendationCount": 123,
"runningTaskCount": 123,
"failedTaskCount": 123,
"searchAccessPathReadyCount": 123,
"searchAccessPathDegradedCount": 123,
"searchAccessPathRuntimeEnabled": true,
"oldestQueuedTaskAgeMs": 123
},
"trackA": {
"sources": [
{
"source": "slow_query_observation",
"label": "<string>",
"status": "active",
"signalCount": 123,
"recommendationCount": 123,
"taskCount": 123,
"note": "<string>"
}
],
"accessPaths": [
{
"kind": "pg_btree_index",
"label": "<string>",
"track": "A",
"status": "active",
"recommendationCount": 123,
"taskCount": 123,
"note": "<string>"
}
],
"indexInventory": {
"observedTableCount": 123,
"inspectedTableCount": 123,
"usefulIndexCount": 123,
"missingIndexCandidateCount": 123,
"abnormalIndexCount": 123,
"externalIndexCount": 123,
"lastObservationTime": "<string>"
}
},
"hotTables": [
{
"spaceId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"requestCount": 123,
"slowCount": 123,
"timeoutCount": 123,
"dbErrorCount": 123,
"maxDurationMs": 123,
"spaceName": "<string>",
"baseName": "<string>",
"tableName": "<string>",
"latestWindowStart": "<string>"
}
],
"searchAccessPaths": [
{
"spaceId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"provider": "pg_bigm",
"status": "ready",
"coveredSearchableFieldCount": 1,
"currentEligibleFieldCount": 1,
"uncoveredFieldCount": 1,
"spaceName": "<string>",
"baseName": "<string>",
"tableName": "<string>"
}
],
"recommendations": {
"data": [
{
"id": "<string>",
"spaceId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"executionTarget": {
"storage": "default",
"displayHost": "<string>",
"displayDatabase": "<string>",
"internalSchema": "<string>"
},
"shapeHash": "<string>",
"policyVersion": "<string>",
"status": "open",
"riskLevel": "none",
"riskScore": 123,
"reasonCodes": [
"<string>"
],
"remediationKinds": [
"<string>"
],
"sqlDiagnostics": [
{
"source": "<string>",
"statementKind": "<string>",
"fingerprint": "<string>",
"parameterCount": 123,
"sampled": true,
"normalizedSql": "<string>"
}
],
"priorityScore": 123,
"spaceName": "<string>",
"baseName": "<string>",
"tableName": "<string>",
"remediationCandidates": [
{
"kind": "<string>",
"reason": "<string>",
"executableInPhase1": true,
"fieldId": "<string>",
"fieldDbName": "<string>",
"indexKind": "<string>",
"accessPath": "<string>",
"fields": [
{
"fieldId": "<string>",
"fieldDbName": "<string>",
"direction": "asc",
"role": "<string>"
}
]
}
],
"trigger": {
"sourceKind": "saved_view_config",
"observedWorkload": true,
"sourceId": "<string>",
"viewId": "<string>",
"fingerprint": "<string>"
},
"shapeSummary": {
"filterFields": [
{
"fieldId": "<string>",
"operatorFamily": "<string>",
"sourceKind": "<string>"
}
],
"sortFields": [
{
"direction": "asc",
"source": "<string>",
"fieldId": "<string>",
"systemColumn": "<string>"
}
],
"search": {
"fieldCount": 123,
"allFields": true,
"valueLengthBucket": "<string>"
}
},
"queryKind": "<string>",
"planValidation": {
"status": "validated",
"candidateCount": 123,
"method": "explain",
"reason": "<string>",
"startupCostBefore": 123,
"startupCostAfter": 123,
"totalCostBefore": 123,
"totalCostAfter": 123,
"planNodeBefore": "<string>",
"planNodeAfter": "<string>",
"usesCandidateIndex": true,
"indexStatements": [
"<string>"
],
"errors": [
"<string>"
]
},
"createdTime": "<string>",
"lastModifiedTime": "<string>",
"heat": {
"requestCount": 123,
"slowCount": 123,
"timeoutCount": 123,
"totalDurationMs": 123,
"maxDurationMs": 123,
"estimatedRows": 123,
"seqScanCount": 123,
"indexScanCount": 123
},
"decision": {
"action": "auto_accept",
"actor": "system_policy",
"outcome": "pending",
"wouldAutoAccept": true,
"reasonCodes": [
"<string>"
],
"cooldownUntil": "<string>",
"decidedAt": "<string>"
}
}
],
"total": 123
},
"tasks": {
"data": [
{
"id": "<string>",
"recommendationId": "<string>",
"baseId": "<string>",
"tableId": "<string>",
"kind": "<string>",
"status": "queued",
"attempts": 123,
"maxAttempts": 123,
"baseName": "<string>",
"tableName": "<string>",
"lockedBy": "<string>",
"lockedAt": "<string>",
"lastError": "<string>",
"result": null,
"createdTime": "<string>",
"lastModifiedTime": "<string>"
}
],
"total": 123
}
}Autorisations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Paramètres de requête
Minimum string length:
1Minimum string length:
1Minimum string length:
1Minimum string length:
1Options disponibles:
open, accepted, dismissed, superseded Options disponibles:
none, low, medium, high, critical Options disponibles:
queued, running, succeeded, failed, cancelled Plage requise:
x >= 0Plage requise:
1 <= x <= 100Plage requise:
x >= 0Plage requise:
1 <= x <= 100Plage requise:
x >= 0Plage requise:
1 <= x <= 100Réponse
200 - application/json
Successful response
Dernière modification le 15 septembre 2026
Cette page vous a-t-elle été utile ?

