Search skmtc
⌘K
Docs
Sign in
Docs
History
Schema
Generate
Filter operations
Account
36
AIGateway
7
Application_Users
8
Authentication_Methods
3
Billing
6
BillingGroup
18
Cloud_platforms
4
Custom_Cloud
7
Domains
5
Groups
7
Kafka_Connect_Custom_Plugins
18
OAuth2
1
Organization_Vpc
12
OrganizationBillingGroup
10
OrganizationEmissions
1
OrganizationPaymentMethod
9
Organizations
36
Payment
4
Permissions
3
Project
35
Project_Billing
4
Project_Key_Management
1
Secrets
8
Service
56
Service_Integrations
12
Service:_Application
1
Service:_ClickHouse
13
Service:_Flink
32
Service:_Kafka
50
Service:_Kafka_MirrorMaker
5
Service:_Managed_Agents
11
Service:_MySQL
5
Service:_OpenSearch
24
Service:_PostgreSQL
10
post
/account/{account_id}/pg/query/optimize
Get query optimization recommendations for a query
get
/project/{project}/service/{service_name}/pg/available-extensions
List PostgreSQL extensions that can be loaded with CREATE EXTENSION in this service
get
/pg/database-metadata-query
Get the query used to retrieve schema metadata
post
/pg/query/metadata-validate
Validate schema metadata structure and statistics
post
/project/{project}/service/{service_name}/pg/query/stats
Fetch PostgreSQL service query statistics
post
/project/{project}/service/{service_name}/query/stats
Fetch PostgreSQL service query statistics (DEPRECATED: Use /project/$project/service/$service/pg/query/stats instead)
post
/pg/query/validate
Validate SQL query syntax
post
/project/{project}/service/{service_name}/connection_pool
Create a new connection pool for service
put
/project/{project}/service/{service_name}/connection_pool/{pool_name}
Update a connection pool
delete
/project/{project}/service/{service_name}/connection_pool/{pool_name}
Delete a connection pool
Service:_Thanos
1
StaticIP
7
Upgrade_pipeline
6
Users
36
Service:_PostgreSQL
Copy
Copy Markdown
Copy Markdown
Copying…
Copied
Copy failed
Changes to Get query optimization recommendations for a query
post
/account/{account_id}/pg/query/optimize
Mar 16, 2026
402066a999a1
Revision changes
info
the
do_not_store
request property default value
false
was added