All Products
Search
Document Center

AnalyticDB for PostgreSQL:List of operations by function

Last Updated:May 09, 2024
This product(gpdb/2016-05-03) OpenAPI adopts RPC Signature style. See signature details in Description of the signature mechanism. We have packaged SDKs for common programming languages for developers. Developers can directly call the OpenAPI of this product by downloading the SDK without paying attention to the technical details. If the existing SDK cannot meet the usage requirements, you can connect through the signature mechanism. It will take about 5 working days. Therefore, it is recommended to join our DingTalk service group (11370001915) and sign under the guidance of experts.
Before using the API, you need to prepare your identity account and access key (AccessKey) to effectively access the API through client tools (SDK, CLI, etc.). For details see getAccessKey.

APITitleDescription
InitVectorDatabaseInitVectorDatabaseInitializes vector databases.
CreateNamespaceCreateNamespaceCreates a vector namespace.
DescribeNamespaceDescribeNamespaceQueries the information about a namespace.
DeleteNamespaceDeleteNamespaceDeletes a namespace.
ListNamespacesListNamespacesQueries a list of namespaces.

Query data

APITitleDescription
DescribeCollectionDescribeCollectionQueries the information about a vector collection.
DeleteCollectionDeleteCollectionDeletes a vector collection.
GrantCollectionGrantCollectionGrants vector collection permissions to a namespace.
ListCollectionsListCollectionsQueries a list of vector collections.
DeleteVectorIndexDeleteVectorIndexDeletes a vector index.
UpsertCollectionDataUpsertCollectionDataUploads vector data to a vector collection.
DeleteCollectionDataDeleteCollectionDataDeletes vector data.

Create instance

APITitleDescription
CreateDBInstanceCreateDBInstanceCreates an AnalyticDB for PostgreSQL instance.

Instance management

APITitleDescription
DeleteDBInstanceDeleteDBInstanceReleases a pay-as-you-go AnalyticDB for PostgreSQL instance.
ModifyDBInstanceDescriptionModifyDBInstanceDescriptionChanges the description of an AnalyticDB for PostgreSQL instance.
ModifyDBInstanceMaintainTimeModifyDBInstanceMaintainTimeModifies the maintenance window of an AnalyticDB for PostgreSQL instance.
ModifyDBInstanceResourceGroupModifyDBInstanceResourceGroupMoves an AnalyticDB for PostgreSQL instance to a resource group.
ModifyVectorConfigurationModifyVectorConfigurationModifies the vector engine optimization configuration of an AnalyticDB for PostgreSQL instance.
PauseInstancePauseInstancePauses an AnalyticDB for PostgreSQL instance.
RebalanceDBInstanceRebalanceDBInstanceRebalances an AnalyticDB for PostgreSQL instance.
RestartDBInstanceRestartDBInstanceRestarts an AnalyticDB for PostgreSQL instance.
ResumeInstanceResumeInstanceResumes an AnalyticDB for PostgreSQL instance.
UpgradeDBVersionUpgradeDBVersionUpgrades the minor version of an AnalyticDB for PostgreSQL instance.

Instance configuration change

APITitleDescription
DescribeDataReDistributeInfoDescribeDataReDistributeInfoQueries the data redistribution information about an AnalyticDB for PostgreSQL V6.0 instance in elastic storage mode.
ModifyDBInstanceConfigModifyDBInstanceConfigChanges the threshold of computing resources and the wait period of idle resources for an AnalyticDB for PostgreSQL instance in Serverless automatic scheduling mode.
UpgradeDBInstanceUpgradeDBInstanceChanges the configurations of an AnalyticDB for PostgreSQL instance.

Instance information query

APITitleDescription
DescribeDBClusterNodeDescribeDBClusterNodeQueries a list of nodes in an AnalyticDB for PostgreSQL instance.
DescribeDBInstanceAttributeDescribeDBInstanceAttributeQueries the information about an AnalyticDB for PostgreSQL instance.
DescribeDBInstancesDescribeDBInstancesQueries a list of AnalyticDB for PostgreSQL instances.
DescribeDBVersionInfosDescribeDBVersionInfosQueries the information about minor versions of AnalyticDB for PostgreSQL instances.
DescribeSupportFeaturesDescribeSupportFeaturesQueries the features that are supported by an AnalyticDB for PostgreSQL instance.

Parameter management

APITitleDescription
DescribeModifyParameterLogDescribeModifyParameterLogQueries the parameter modification logs of an AnalyticDB for PostgreSQL instance.
DescribeParametersDescribeParametersQueries the information about configuration parameters for an AnalyticDB for PostgreSQL instance.
ModifyParametersModifyParametersModifies the configuration parameters of an AnalyticDB for PostgreSQL instance.

Backup and restoration

APITitleDescription
DescribeBackupPolicyDescribeBackupPolicyQueries the backup policy of an AnalyticDB for PostgreSQL instance.
DescribeDataBackupsDescribeDataBackupsQueries a list of backup sets of full backup or point-in-time backup for an AnalyticDB for PostgreSQL instance.
DescribeLogBackupsDescribeLogBackupsQueries a list of log backups.
ModifyBackupPolicyModifyBackupPolicyConfigures the backup policy of an AnalyticDB for PostgreSQL instance.

Account management

APITitleDescription
CreateAccountCreateAccountCreates a privileged account for an AnalyticDB for PostgreSQL instance.
DescribeAccountsDescribeAccountsQueries the information about database accounts for an AnalyticDB for PostgreSQL instance.
DescribeDiagnosisDimensionsDescribeDiagnosisDimensionsQueries all databases and database accounts for an AnalyticDB for PostgreSQL instance.
ModifyAccountDescriptionModifyAccountDescriptionModifies the description of a database account for an AnalyticDB for PostgreSQL instance.
ResetAccountPasswordResetAccountPasswordResets the password of a database account for an AnalyticDB for PostgreSQL instance.

Data sharing

APITitleDescription
DescribeDataShareInstancesDescribeDataShareInstancesQueries the state of data sharing for AnalyticDB for PostgreSQL instances.
DescribeDataSharePerformanceDescribeDataSharePerformanceQueries the information about data sharing performance metrics.
SetDataShareInstanceSetDataShareInstanceEnables or disables data sharing for an AnalyticDB for PostgreSQL instance.

Diagnostics and optimization

APITitleDescription
DescribeDBClusterPerformanceDescribeDBClusterPerformanceQueries the information about performance metrics of an AnalyticDB for PostgreSQL instance within a time range.
DescribeDBInstanceDataBloatDescribeDBInstanceDataBloatQueries the information about data bloat for an AnalyticDB for PostgreSQL instance.
DescribeDBInstanceDataSkewDescribeDBInstanceDataSkewQueries the information about data skew for an AnalyticDB for PostgreSQL instance.
DescribeDBInstanceDiagnosisSummaryDescribeDBInstanceDiagnosisSummaryQueries the information about nodes in an AnalyticDB for PostgreSQL instance.
DescribeDBInstanceIndexUsageDescribeDBInstanceIndexUsageQueries the index usage of an AnalyticDB for PostgreSQL instance.
DescribeDBInstancePerformanceDescribeDBInstancePerformanceQueries the information about performance metrics of an AnalyticDB for PostgreSQL instance within a time range.
DescribeDiagnosisMonitorPerformanceDescribeDiagnosisMonitorPerformanceQueries the details of query execution on an AnalyticDB for PostgreSQL instance.
DescribeDiagnosisRecordsDescribeDiagnosisRecordsQueries the information about SQL queries for an AnalyticDB for PostgreSQL instance.
DescribeDiagnosisSQLInfoDescribeDiagnosisSQLInfoQueries the information about a query for an AnalyticDB for PostgreSQL instance.
DescribeDownloadRecordsDescribeDownloadRecordsQueries the download records of query diagnostic information for an AnalyticDB for PostgreSQL instance.
DescribeDownloadSQLLogsDescribeDownloadSQLLogsQueries the last five download records of slow query logs for an AnalyticDB for PostgreSQL instance.
DescribeHealthStatusDescribeHealthStatusQueries the health status of an AnalyticDB for PostgreSQL instance and its nodes.
DescribeWaitingSQLInfoDescribeWaitingSQLInfoQueries the information about a lock-waiting query for an AnalyticDB for PostgreSQL instance.
DescribeWaitingSQLRecordsDescribeWaitingSQLRecordsQueries the lock diagnostic records of an AnalyticDB for PostgreSQL instance.
DownloadDiagnosisRecordsDownloadDiagnosisRecordsDownloads the information about query diagnostics of an AnalyticDB for PostgreSQL instance.
DownloadSQLLogsRecordsDownloadSQLLogsRecordsDownload the slow query logs of an AnalyticDB for PostgreSQL instance.

Plan management

APITitleDescription
CreateDBInstancePlanCreateDBInstancePlanCreates a plan for an AnalyticDB for PostgreSQL instance.
DeleteDBInstancePlanDeleteDBInstancePlanDeletes a plan from an AnalyticDB for PostgreSQL instance.
DescribeDBInstancePlansDescribeDBInstancePlansQueries the information about plans for an AnalyticDB for PostgreSQL instance.
SetDBInstancePlanStatusSetDBInstancePlanStatusEnables or disables a plan for an AnalyticDB for PostgreSQL instance.
UpdateDBInstancePlanUpdateDBInstancePlanModifies a plan for an AnalyticDB for PostgreSQL instance.

Tag management

APITitleDescription
DescribeTagsDescribeTagsQueries a list of tags for AnalyticDB for PostgreSQL instances.
ListTagResourcesListTagResourcesQueries a list of tags that are added to AnalyticDB for PostgreSQL instances.
TagResourcesTagResourcesCreates and adds tags to AnalyticDB for PostgreSQL instances.
UntagResourcesUntagResourcesRemoves tags from AnalyticDB for PostgreSQL instances. If the tags that you remove are not added to other instances, the tags are automatically deleted.

Security management

APITitleDescription
CheckServiceLinkedRoleCheckServiceLinkedRoleQueries whether a service-linked role is created.
CreateServiceLinkedRoleCreateServiceLinkedRoleCreates a service-linked role.
DescribeDBInstanceIPArrayListDescribeDBInstanceIPArrayListQueries the whitelists of IP addresses that are allowed to access an AnalyticDB for PostgreSQL instance.
DescribeDBInstanceSSLDescribeDBInstanceSSLQueries the SSL information about an AnalyticDB for PostgreSQL instance.
DescribeUserEncryptionKeyListDescribeUserEncryptionKeyListQueries a list of Key Management Service (KMS) keys.
ModifyDBInstanceSSLModifyDBInstanceSSLEnables, disables, or updates SSL encryption for an AnalyticDB for PostgreSQL instance.
ModifySecurityIpsModifySecurityIpsModifies the IP address whitelist of an AnalyticDB for PostgreSQL instance.

Log management

APITitleDescription
DescribeDBInstanceErrorLogDescribeDBInstanceErrorLogQueries the error logs of an AnalyticDB for PostgreSQL instance.
DescribeSQLLogCountDescribeSQLLogCountQueries the number of audit logs for an AnalyticDB for PostgreSQL instance.
DescribeSQLLogsV2DescribeSQLLogsV2Queries SQL logs within a specific time range.
ModifySQLCollectorPolicyModifySQLCollectorPolicyEnables or disables the SQL collection feature for an AnalyticDB for PostgreSQL instance.

Network management

APITitleDescription
AllocateInstancePublicConnectionAllocateInstancePublicConnectionAllocates a public endpoint for an AnalyticDB for PostgreSQL instance.
DescribeDBInstanceNetInfoDescribeDBInstanceNetInfoQueries the connection information of an instance.
DescribeRdsVpcsDescribeRdsVpcsQueries a list of VPCs.
DescribeRdsVSwitchsDescribeRdsVSwitchsQueries a list of vSwitches.
ModifyDBInstanceConnectionStringModifyDBInstanceConnectionStringChanges the endpoint of an AnalyticDB for PostgreSQL instance.
ReleaseInstancePublicConnectionReleaseInstancePublicConnectionReleases the public endpoint of an AnalyticDB for PostgreSQL instance.
SwitchDBInstanceNetTypeSwitchDBInstanceNetTypeSwitches between the internal and public endpoints of an AnalyticDB for PostgreSQL instance.

Resource management

APITitleDescription
DescribeAvailableResourcesDescribeAvailableResourcesQueries the information about available resources of AnalyticDB for PostgreSQL.
DescribeRegionsDescribeRegionsQueries a list of regions and zones where AnalyticDB for PostgreSQL is available.

Sample dataset

APITitleDescription
CreateSampleDataCreateSampleDataCreates a sample dataset for an AnalyticDB for PostgreSQL instance.
DescribeSampleDataDescribeSampleDataQueries whether a sample dataset is loaded to an AnalyticDB for PostgreSQL instance.
UnloadSampleDataUnloadSampleDataReleases a sample dataset from an AnalyticDB for PostgreSQL instance.

Other

APITitleDescription
DescribeSQLLogsDescribeSQLLogsQueries the SQL execution logs of an AnalyticDB for PostgreSQL instance.