Document Center

    AnalyticDB for PostgreSQL

    • Release Notes
      • AnalyticDB for PostgreSQL V6.0 available for commercial use
      • Release notes
    • Notices
      • [Notice] Diagnostics and optimization feature released
      • [Notice] AnalyticDB for PostgreSQL Basic Edition Released
    • Product Introduction
      • Overview
      • Scenarios
      • Terms
      • Features and limits
      • Features of AnalyticDB for PostgreSQL V6.0
      • Basic Edition
      • Precautions
      • TPC-H
    • Specifications and Pricing
      • Instance specifications
      • Pricing
      • Expiration and overdue policy
      • Change the billing method from pay-as-you-go to subscription
    • Quick Start
      • Get started with AnalyticDB for PostgreSQL
      • Create an instance
      • Configure an IP address whitelist
      • Create a database account
      • Use client tools to connect to an instance
    • Data Migration and Synchronization
      • Overview
      • Migrate data to AnalyticDB for PostgreSQL
        • Write data
          • Use the Client SDK
        • Migrate table data
          • Use Data Integration to migrate and batch synchronize data
          • Use a Realtime Compute for Apache Flink cluster to write data to an AnalyticDB for PostgreSQL instance
          • Use Alibaba Cloud Realtime Compute for Apache Flink to read data from AnalyticDB for PostgreSQL
          • Use the \copy command to import data from your computer to AnalyticDB for PostgreSQL
          • Migrate data by using an OSS external table
          • Use an external table to read and write HDFS data
        • Migrate warehouse data
          • Migrate data from a self-managed Greenplum cluster to an AnalyticDB for PostgreSQL instance
          • Migrate data from a Teradata database to an AnalyticDB for PostgreSQL instance
          • Migrate data from an Amazon Redshift instance to an AnalyticDB for PostgreSQL instance
          • Migrate data from an Oracle database to an AnalyticDB for PostgreSQL instance
          • Migrate data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance
      • Synchronize data from cloud databases
        • Use DTS to synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from an ApsaraDB RDS for SQL Server instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from an ApsaraDB RDS for PostgreSQL instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for PostgreSQL instance
      • Synchronize data from self-managed databases
        • Use DTS to synchronize data from an ECS-based user-created MySQL database to an AnalyticDB for PostgreSQL instance
        • Use DTS to synchronize data from a user-created MySQL database connected by a leased line, VPN Gateway, or Smart Access Gateway to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed SQL Server database hosted on ECS to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed PostgreSQL database to an AnalyticDB for PostgreSQL instance
        • Use rds_dbsync to migrate or synchronize data from a MySQL database to an AnalyticDB for PostgreSQL database
        • Use rds_dbsync to migrate or synchronize data from a PostgreSQL database to an AnalyticDB for PostgreSQL database
    • Instances
      • Node configuration change
        • Upgrade instance specifications
      • Create a Basic Edition instance
      • Enable SQL audit
      • Instance locking
        • Instance locking caused by disk usage
      • Restart an AnalyticDB for PostgreSQL instance
      • Configure disk encryption for an AnalyticDB for PostgreSQL instance
      • Network Connection
        • Manage public endpoints
        • Release an Internet IP address
        • Endpoints of an instance and its primary coordinator node
      • Version Management
        • Upgrade the engine version
        • Query the minor engine version
        • Compatibility comparisons between AnalyticDB for PostgreSQL V4.3 and V6.0
        • Check for incompatibility between AnalyticDB for PostgreSQL V4.3 and V6.0
      • Backup and restoration
        • Overview
        • Back up data
        • Restore data
      • Tags
        • Add tags to instances
        • Unbind a tag from an AnalyticDB for PostgreSQL instance
        • Filter AnalyticDB for PostgreSQL instances by tag
      • Diagnostics and optimization
        • View slow SQL queries
        • View SQL distribution statistics
      • Release an instance
      • Configure parameters
      • CloudMonitor
        • Configure an alert rule
    • Data
      • Manage databases
      • Manage schemas
      • Create and manage tables
      • Define table distribution
      • Define table partitioning
      • Define storage models for tables
      • Manage indexes
      • Manage views
      • Manage materialized views
      • Real-time materialized views (beta)
      • Storage reclaim
    • Beginner Developer Guide
      • Data types
      • SQL statements
      • Manage users and permissions
      • Insert, update, and delete data
      • Use INSERT ON CONFLICT to overwrite data
      • Use COPY ON CONFLICT to overwrite data
      • Use MaxCompute foreign tables to access MaxCompute data
      • Use OSS foreign tables to access OSS data
      • Use the COPY or UNLOAD statement to import or export data between OSS foreign tables and local tables
      • Use external tables for federated analytics of Hadoop data sources
      • Use external tables for federated analytics of external SQL databases
      • Transaction management
      • Manage JSON and JSON-B data
      • Use sort keys and rough set indexes to accelerate queries in column-oriented tables
      • Use the ANALYZE statement to collect statistics on AnalyticDB for PostgreSQL
      • Use the EXPLAIN statement to read a query plan
      • Use resource queues for load management
      • Use MetaScan to accelerate queries for column-oriented tables
      • Configure sorting acceleration
      • Auto-merge
      • Configure parallel query
    • Advanced Developer Guide
      • Use advanced extensions
        • Manage extensions
        • Use the Laser computing engine
        • Use HyperLogLog
        • Use PostGIS
        • Use compressed bitmap index
        • Use the uuid-ossp extension
        • Use zhparser to perform Chinese word segmentation
      • Use PL/Java
        • Create and use PL/Java UDFs
        • Use the CREATE LIBRARY statement
      • Use PL/Python
      • AnalyticDB for PostgreSQL error codes
    • Data Warehouse Development
      • Use DataWorks to schedule ETL tasks of AnalyticDB for PostgreSQL
    • BI Analysis and Visualization
      • BI tools compatible with AnalyticDB for PostgreSQL
      • Connect Alibaba Cloud Quick BI to AnalyticDB for PostgreSQL
      • Use Tableau to connect to AnalyticDB for PostgreSQL
    • GANOS
      • Overview
      • Model
        • Geometry model
        • Raster model
        • Trajectory model
      • Raster SQL Reference
        • Terms
        • Raster creation
          • ST_CreateRast
        • Import and export
          • ST_ImportFrom
          • ST_ExportTo
        • Pyramid operations
          • ST_BuildPyramid
          • ST_DeletePyramid
          • ST_BestPyramidLevel
        • Coordinate system conversion
          • ST_Rast2WorldCoord
          • ST_World2RastCoord
        • Pixel value operations
          • S​T_ClipDimension
          • ST_Clip
          • ST_ClipToRast
          • ST_AddZ
          • ST_MosaicFrom
        • DEM operations
          • ST_Slope
        • Attribute query and update
          • ST_Name
          • ST_SetName
          • ST_MetaData
          • ST_Width
          • ST_Height
          • ST_NumBands
          • ST_Value
          • ST_RasterID
          • ST_CellDepth
          • ST_CellType
          • ST_InterleavingType
          • ST_TopPyramidLevel
          • ST_Extent
          • ST_ConvexHull
          • ST_Envelope
          • ST_Srid
          • ST_SetSrid
          • ST_ScaleX
          • ST_ScaleY
          • ST_SetScale
          • ST_SkewX
          • ST_SkewY
          • ST_SetSkew
          • ST_UpperLeftX
          • ST_UpperLeftY
          • ST_SetUpperLeft
          • ST_PixelWidth
          • ST_PixelHeight
          • ST_Georeference
          • ST_IsGeoreferenced
          • ST_UnGeoreference
          • ST_SetGeoreference
          • ST_NoData
          • ST_SetNoData
          • ST_ColorTable
          • ST_SetColorTable
          • ST_Statistics
          • ST_SetStatistics
          • ST_SummaryStats
          • ST_ColorInterp
          • ST_SetColorInterp
          • ST_Histogram
          • ST_SetHistogram
          • ST_BuildHistogram
          • ST_StatsQuantile
          • ST_Quantile
          • ST_MD5Sum
          • ST_SetMD5Sum
          • ST_XMin
          • ST_YMin
          • ST_XMax
          • ST_YMax
          • ST_ChunkHeight
          • ST_ChunkWidth
          • ST_ChunkBands
          • ST_MetaItems
          • ST_SetMetaData
          • ST_BeginDateTime
          • ST_EndDateTime
          • ST_SetBeginDateTime
          • ST_SetEndDateTime
          • ST_DateTime
          • ST_SetDateTime
        • Operators
          • Equal to operator (=)
          • Greater than operator (>)
          • Less than operator (<)
          • Greater than or equal to operator (>=)
          • Less than or equal to operator (<=)
        • Functions for Identifying Spatial Relationships
          • ST_Intersects
          • ST_Contains
          • ST_ContainsProperly
          • ST_Covers
          • ST_CoveredBy
          • ST_Disjoint
          • ST_overlaps
          • ST_Touches
          • ST_Within
        • Auxiliary functions
          • ST_CheckGPU
          • ST_AKId
          • ST_SetAccessKey
          • ST_SetAKId
          • ST_SetAKSecret
        • Variables
          • ganos.raster.calculate_md5
          • ganos.raster.md5sum_chunk_size
          • ganos.raster.mosaic_must_same_nodata
      • SpatialRef SQL reference
        • ST_SrEqual
        • ST_SrReg
        • ST_SrFromEsriWkt
      • Trajectory SQL reference
        • Basic concepts
        • Constructors
          • Overview
          • ST_makeTrajectory
          • ST_append
        • Edit and process functions
          • ST_Compress
          • ST_CompressSED
          • ST_attrDeduplicate
          • ST_sort
          • ST_deviation
        • Attribute metadata
          • ST_attrDefinition
          • ST_attrSize
          • ST_attrName
          • ST_attrType
          • ST_attrLength
          • ST_attrNullable
        • Event functions
          • ST_addEvent
          • ST_eventTimes
          • ST_eventTime
          • ST_eventTypes
          • ST_eventType
        • Attribute functions
          • ST_startTime
          • ST_endTime
          • ST_trajectorySpatial
          • ST_trajectoryTemporal
          • ST_trajAttrs
          • ST_attrIntMax
          • ST_attrIntMin
          • ST_attrIntAverage
          • ST_attrFloatMax
          • ST_attrFloatMin
          • ST_attrFloatAverage
          • ST_leafType
          • ST_leafCount
          • ST_duration
          • ST_timeAtPoint
          • ST_pointAtTime
          • ST_velocityAtTime
          • ST_accelerationAtTime
          • ST_timeToDistance
          • ST_timeAtDistance
          • ST_cumulativeDistanceAtTime
          • ST_timeAtCumulativeDistance
          • ST_subTrajectory
          • ST_subTrajectorySpatial
          • ST_samplingInterval
          • ST_trajAttrsAsText
          • ST_trajAttrsAsInteger
          • ST_trajAttrsAsDouble
          • ST_trajAttrsAsBool
          • ST_trajAttrsAsTimestamp
          • ST_attrIntFilter
          • ST_attrFloatFilter
          • ST_attrTimestampFilter
          • ST_attrNullFilter
          • ST_attrNotNullFilter
          • ST_trajAttrsMeanMax
        • Functions to process bounding boxes
          • ST_MakeBox
          • ST_MakeBox{Z|T|2D|2DT|3D|3DT}
          • ST_BoxndfToGeom
          • ST_Has{xy|z|t}
          • ST_{X|Y|Z|T}Min
          • ST_{X|Y|Z|T}Max
          • ST_ExpandSpatial
        • Operators to process bounding boxes
          • Basic concepts
          • INTERSECT operators
          • INCLUDE operators
          • INCLUDED operators
        • Spatial relationship judgment
          • ST_intersects
          • ST_equals
          • ST_distanceWithin
        • Spatial processing
          • ST_intersection
          • ST_difference
        • Spatial statistics
          • ST_nearestApproachPoint
          • ST_nearestApproachDistance
        • Spatio-temporal relationship judgment
          • ST_intersects
          • ST_equals
          • ST_distanceWithin
          • ST_durationWithin
          • ST_{Z|T|2D|2DT|3D|3DT}Intersects
          • ST_{2D|2DT|3D|3DT}Intersects_IndexLeft
          • ST_{2D|2DT|3D|3DT}DWithin
          • ST_{2D|2DT|3D|3DT}DWithin_IndexLeft
          • ST_{T|2D|2DT|3D|3DT}Contains
          • ST_{T|2D|2DT|3D|3DT}Within
        • Spatio-temporal processing
          • ST_intersection
        • Spatio-temporal statistics
          • ST_nearestApproachPoint
          • S​T_nearestApproachDistance
        • Distance measurement
          • ST_length
          • ST_euclideanDistance
          • ST_mdistance
        • Similarity analysis
          • ST_lcsSimilarity
          • ST_lcsDistance
          • ST_lcsSubDistance
        • Indexing
          • GiST indexing
          • TrajGiST indexing
        • Variables
          • ganos.trajectory.attr_string_length
      • FAQ
        • Load raster data
        • Load vector data
        • Trajectory FAQ
      • Best practice
        • Trajectory best practices
    • Best Practices
      • Use pg_stat_activity to analyze and diagnose active PostgreSQL queries
      • Bulk update
      • Optimize query performance
      • Configure scheduled maintenance tasks to clear junk data
      • Pre-process special characters within files to be imported
      • Use HyperLogLog for high-performance multi-dimensional data view
      • How do I diagnose and handle locks?
      • Check for data skew
      • Use a connection pool
      • Use the pg_cron plug-in to configure scheduled tasks
    • Optimization Guide
      • Instance specification selection and planning
      • Database object optimization
        • Logical structure of database objects
        • Data distribution options
        • Distribution key choices
        • Partitioned tables and partition pruning
        • Storage models
        • Compressed storage
      • Performance optimization
        • Slow query identification
          • pg_stat_activity view
          • Enable SQL audit
        • Statistics collection
        • Execution plans
        • Execution plan optimization
        • Index optimization
        • Sorting optimization
        • Data skew elimination
        • Data redistribution elimination
        • Disk spill prevention
        • Lock wait prevention
        • Storage reclaim
        • General SQL optimization methods
        • Performance parameter optimization
    • Technical White Paper
      • AnalyticDB for PostgreSQL overview
      • Scenarios
      • Benefits
        • Multi-coordinator introduction
          • Multi-coordinator architecture
          • Multi-coordinator technologies
          • Multi-coordinator performance evaluation
        • Performance
          • Execution engine
          • Storage engine
          • Optimizers
          • TPC-H
        • Cost-effectiveness
        • Security
        • Scalability
        • Availability and reliability
        • Advanced features
          • Stored procedures
          • Semi-structured data analysis
          • Machine learning
          • Spatio-temporal data analysis
      • Ecosystem integration
      • Planning
    • FAQ
      • What do I do if I cannot connect to an instance?
      • How to view the data size of a table or a database?
      • How do I obtain technical details about AnalyticDB for PostgreSQL?
      • How do I choose an AnalyticDB for PostgreSQL instance type?
      • How do I switch the network type?
      • How do I clear data on a locked disk?
      • How do I reconfigure parameters?
      • How to enable column-store and compression in AnalyticDB for PostgreSQL?
      • What do I do if an AnalyticDB for PostgreSQL instance fails to be created or remains in the creating state for a long time?
      • Do I need to execute COPY statements as the superuser user?
      • Why am I unable to view the bills for my pay-as-you-go instance? And when can I receive my invoice?
      • How do I terminate the abnormal execution of an SQL statement?
      • How do I view the distribution key and partitions of a table?
      • How do I join the AnalyticDB for PostgreSQL technical support group on DingTalk?
      • Mappings between compute node types and compute group types
    • API Reference
      • List of operations by function
      • Request structure
      • Common parameters
      • Responses
      • Sign signatures
      • Service linked role
      • Use RAM for resource authorization
        • Use RAM for resource authorization
        • Resource types supported by RAM
        • Actions of authorized resources
        • Authentication rules for APIs
      • Instance management
        • CreateDBInstance
        • CreateECSDBInstance
        • DeleteDBInstance
        • DescribeDBInstanceAttribute
        • DescribeDBClusterPerformance
        • DescribeDBInstances
        • DescribeRegions
        • DescribeResourceUsage
        • ModifyDBInstanceConnectionMode
        • ModifyDBInstanceDescription
        • ModifyDBInstanceMaintainTime
        • RestartDBInstance
        • UpgradeDBInstance
        • UpgradeDBVersion
        • DescribeDBInstancePerformance
        • DescribeDBInstanceOnECSAttribute
        • DescribeModifyParameterLog
        • DescribeAvailableResources
        • DescribeParameters
        • DescribeSpecification
        • ModifyParameters
        • DescribeDBInstanceForDms
        • DescribeDBInstancesForDms
        • ModifyBackupPolicy
        • DescribeDataBackups
        • DescribeBackupPolicy
        • DescribeLogBackups
      • Database management
        • DeleteDatabase
      • Account management
        • CreateAccount
        • DescribeAccounts
        • ModifyAccountDescription
        • ResetAccountPassword
      • Tag management
        • TagResources
        • ListTagResources
        • UntagResources
        • DescribeTags
      • Security management
        • DescribeDBInstanceIPArrayList
        • ModifySecurityIps
        • CheckServiceLinkedRole
        • CreateServiceLinkedRole
        • DescribeDBInstanceSSL
        • ModifyDBInstanceSSL
        • ModifyDBInstanceSecurityIps
        • DescribeDBInstanceSecurityIps
        • DescribeUserEncryptionKeyList
      • Log management
        • DescribeDBInstanceSQLPatterns
        • DescribeSlowLogRecords
        • DescribeSlowSQLLogs
        • DescribeSQLCollectorPolicy
        • DescribeSQLLogByQueryId
        • DescribeSQLLogCount
        • DescribeSQLLogFiles
        • DescribeSQLLogRecords
        • DescribeSQLLogs
        • DescribeSQLLogsOnSlice
        • ModifySQLCollectorPolicy
      • Network management
        • AllocateInstancePublicConnection
        • DescribeDBInstanceNetInfo
        • ModifyDBInstanceConnectionString
        • ModifyDBInstanceNetworkType
        • ReleaseInstancePublicConnection
        • SwitchDBInstanceNetType
        • DescribeRdsVSwitchs
        • DescribeRdsVpcs
      • Appendix
        • Error codes
          • Client error codes
          • Server error codes
        • Ensure idempotence
        • Instance types
        • Performance parameters
        • Instance statuses
 
All Products
Search
  • Document Center
  • AnalyticDB for PostgreSQL
  • Specifications and Pricing
  • Pricing

This Product

  • This Product
  • All Products

    Pricing

    Document Center

    Pricing

    Last Updated: Mar 08, 2021

    For more information about pricing, see AnalyticDB for PostgreSQL Pricing.

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.