All Documentation
GaussDB
GaussDB
All results for "
" in this service
All results for "
" in this service
What's New
Function Overview
Product Bulletin
Product Bulletin
GaussDB(for openGauss) Is Now Called GaussDB
URLs of GaussDB Documents Will Be Changed in Huawei Cloud Help Center
GaussDB Billing Items Will Be Split from GaussDB(for MySQL)
Product Release Notes
Vulnerability Fixing Policies
Version Support Bulletin
GaussDB Version Policies
Kernel Release History
3.x Versions
2.x Versions
1.x Versions
Service Overview
GaussDB Infographics
What Is GaussDB?
Scenarios
Basic Concepts
Advantages
DB Instance Description
Instance Statuses
Instance Specifications
Instance Storage Types
Instance Versions
DB Instance Types
DB Instance Parameters
System Accounts for DB Instances
Compatibility with Oracle
Distributed Instances
Oracle Compatibility Overview
Basic SQL Elements
Pseudocolumns
Operators
Expressions
Conditions
Common SQL DDL Clauses
SQL Queries and Subqueries
PL/SQL Language
System Functions
System Views
Advanced Packages
Primary/Standby Instances
Oracle Compatibility Overview
Basic SQL Elements
Pseudocolumns
Operators
Expressions
Conditions
Common SQL DDL Clauses
SQL Queries and Subqueries
PL/SQL Language
System Functions
System Views
Advanced Packages
Security
Shared Responsibilities
Identity Authentication and Access Control
Service Access Control
Data Protection
Audit and Logs
Risk Monitoring
Fault Recovery
Certificates
Permissions Management
GaussDB Constraints
Billing
Related Services
Billing
Billing Overview
Billed Items
Billing Modes
Overview
Yearly/Monthly Billing
Pay-per-Use Billing
Billing Examples
Billing Mode Changes
Overview
Pay-per-Use to Yearly/Monthly
Yearly/Monthly to Pay-per-Use
Subscription Renewal
Overview
Manually Renewing a GaussDB Instance
Auto-renewing a GaussDB Instance
Bills
Arrears
Billing Termination
Cost Management
Getting Started
Operation Guide
Buying a DB Instance
Connecting to a DB Instance Using a Database Client
Connecting to a DB Instance
Connecting to an Instance Through DAS(Recommended)
Using gsql to Connect to an Instance from a Linux Server
Using DBeaver to Connect to an Instance from a Windows Server
Using Navicat to Connect to an Instance from a Windows Server
Connecting to a DB Instance Using a Driver
Distributed Instances
Development Specifications
Using JDBC to Connect to a Database
Using ODBC to Connect to a Database
Using libpq to Connect to a Database
Using Psycopg to Connect to a Database
Using Hibernate to Connect to a Database
Using MyBatis to Connect to a Database
Using JayDeBeApi to Connect to a Database
Primary/Standby Instances
Development Specifications
Using JDBC to Connect to a Database
Using ODBC to Connect to a Database
Using libpq to Connect to a Database
Using Psycopg to Connect to a Database
Using Hibernate to Connect to a Database
Using MyBatis to Connect to a Database
Using JayDeBeApi to Connect to a Database
Example: Using DAS to Connect to an Instance and Execute SQL Statements
Kernel Versions
3.x Versions
2.x Versions
1.x Versions
User Guide
Viewing Instance Overview Data
Usage Guidelines and Suggestions
Purpose
Database Design Guidelines
General Guidelines
Deployment Guidelines
Database Object Naming Guidelines
Database Design Guidelines
Permission Design Guidelines
Table Design Guidelines
Column Design Guidelines
Index Design Guidelines
Function/Stored Procedure Design Guidelines
Database Programming Guidelines
GUC Parameter Programming Guidelines
Object Access Programming Guidelines
WHERE
SELECT
INSERT
UPDATE
DELETE
Associated Query
Subqueries
Transactions
Client Programming Guidelines
JDBC
Parameter Configuration Guidelines
GaussDB Parameter Configuration Standards
Performance Tuning
Performance Tuning Process
Performance Tuning Scope
Querying the Most Time-Consuming SQL Statements
Checking Blocked Statements
Tuning Parameters
SQL Tuning Guide
Query Execution Process
Introduction to the SQL Execution Plan
Overview
Description
Tuning Process
Updating Statistics
Reviewing and Modifying a Table Definition
Reviewing and Modifying a Table Definition
Selecting a Storage Type
Selecting a Distribution Table
Selecting a Distribution Key
Using Partial Cluster Key
Using Partitioned Tables
Selecting a Data Type
Typical SQL Tuning Advantages
SQL Self-Diagnosis
Tuning Statement Pushdown
Tuning Subqueries
Tuning Statistics
Tuning Operators
Tuning Data Skew
Experience in Rewriting SQL Statements
Resetting Key Parameters During SQL Tuning
Hint-based Tuning
Plan Hint Tuning
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Operation Hints
Sublink Name Hints
Skew Hints
Hint Errors, Conflicts, and Other Warnings
Plan Hint Cases
Checking the Implicit Conversion Performance
Optimization Cases
Case: Selecting an Appropriate Distribution Key
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Pushing Down Sort Operations to DNs
Case: Setting cost_param and Optimizing Query Performance
Case: Adjusting Distribution Keys
Case: Reconstructing Partitioned Tables
Permissions Management
Creating a User and Granting Permissions
Creating a Custom Policy
Billing Management
Renewing a DB Instance
Changing Pay-per-Use Instances to Yearly/Monthly
Changing Yearly/Monthly Instances to Pay-per-Use
Unsubscribing a Yearly/Monthly DB Instance
Enabling Auto-Renewal for Yearly/Monthly Instances
Modifying Auto-Renewal Settings for Yearly/Monthly Instances
Database Migration
Migration Solution Overview
Migrating Data to GaussDB Using the Export and Import Functions of DAS
Instance Lifecycle
Rebooting a DB Instance
Deleting a Pay-per-Use DB Instance
Exporting Instance Information
Rebuilding a Deleted Instance
Instance Modifications
Changing an Instance Name
Binding and Unbinding an EIP
Adding Nodes
Deleting CNs
Deleting Shards
Scaling Up Storage Space
Enabling Storage Autoscaling
Modifying Instance Parameters
Changing CPU and Memory Specifications
Changing Failover Priority
Configuring Security Group Rules
Changing the Deployment Model of a Single-Replica Instance
Performing a Primary/Standby DN Switchover
Updating the DB Engine and OS of a DB Instance
Node Management
Rebooting a Node
Data Backup
Working with Backups
Configuring an Automated Backup Policy for Instances
Creating a Manual Backup for Instances
Exporting Backup Information
Stopping a Backup
Deleting a Manual Backup
Data Restoration
Restoring a Backup File to a DB Instance
Restoring a DB Instance to a Specific Point in Time
Account and Network Security
Resetting the Administrator Password
Enterprise Project Quota Management
Parameter Template Management
Creating a Parameter Template
Modifying GaussDB Instance Parameters
Exporting Parameters
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Modifying a Parameter Template Description
Deleting a Parameter Template
Monitoring and Alarming
Monitoring Metrics
Supported Events
Creating Alarm Rules
Viewing Monitoring Metrics
Creating an Alarm Rule to Monitor an Event
Introduction to Event Monitoring
Monitoring and Inspection
Monitoring Dashboards
Interconnection with CTS
Key Operations Supported by CTS
Viewing Traces
Log Management
Analyzing Logs
Uploading Audit Logs to LTS
Task Center
Viewing a Task
Deleting a Task Record
Tags
Quotas
Developer Guide
Distributed_3.x
Database System Overview
Database Logical Architecture
Query Request Handling Process
Managing Transactions
Concepts
Database Security
Users and Permissions
Default Permission Mechanism
Administrator
Separation of Duties
Users
Roles
Schemas
Setting User Permissions
Row-Level Security Policy
Database Audit
Database Quick Start
Connecting to a Database
Using gsql to Connect to a Database
APIs
Operating a Database
Creating a Database Account
Creating and Managing Databases
Planning a Storage Model
Creating and Managing Tablespaces
Creating and Managing Tables
Creating a Table
Inserting Data to a Table
Updating Data in a Table
Viewing Data
Deleting Data from a Table
Querying a System Catalog
Other Operations
Creating and Managing Schemas
Creating and Managing Partitioned Tables
Creating and Managing Indexes
Creating and Managing Views
Creating and Managing Sequences
Creating and Managing Scheduled Jobs
Development and Design Proposal
Overview
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Column Design
Constraint Design
View and Joined Table Design
Tool Interconnection
JDBC Configuration
SQL Compilation
Application Development Guide
Development Specifications
Obtaining the Driver Package
Development Based on JDBC
JDBC Package, Driver Class, and Environment Class
Development Process
Loading a Driver
Connecting to a Database
Connecting to the Database (Using SSL)
Connecting to a Database (Using UDS)
Running SQL Statements
Processing Data in a Result Set
Closing a Connection
Log Management
Examples: Common Operations
Example: Retrying SQL Queries for Applications
Example: Logic Replication Code
Example: Parameters for Connecting to the Database in Different Scenarios
JDBC Interface Reference
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
PGReplicationConnection
PGReplicationStream
ChainedStreamBuilder
ChainedCommonStreamBuilder
Common JDBC Parameters
FAQs
Incorrect batchMode Settings
Mapping for JDBC Data Types
Development Based on ODBC
ODBC Packages, Dependent Libraries, and Header Files
Development Process
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
Example: Common Functions and Batch Binding
Typical Application Scenarios and Configurations
ODBC Interface Reference
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
Development Based on libpq
libpq Package, Dependent Library, and Header File
Development Process
Example
libpq Interface Reference
Database Connection Control Functions
PQconnectdbParams
PQconnectdb
PQbackendPID
PQsetdbLogin
PQfinish
PQreset
PQstatus
Database Statement Execution Functions
PQexec
PQprepare
PQresultStatus
PQclear
Functions for Asynchronous Command Processing
PQsendQuery
PQsendQueryParams
PQsendPrepare
PQsendQueryPrepared
PQflush
Functions for Canceling Queries in Progress
PQgetCancel
PQfreeCancel
PQcancel
Connection Parameters
Psycopg-based Development
Development Process
Development Procedure
Example: Common Operations
Psycopg API Reference
psycopg2.connect()
connection.cursor()
cursor.execute(query,vars_list)
curosr.executemany(query,vars_list)
connection.commit()
connection.rollback()
cursor.fetchone()
cursor.fetchall()
cursor.close()
connection.close()
ECPG-based Development
Development Process
ECPG Components
ECPG Preprocessing and Compiling
Managing Database Connections
Connecting to a Database
Managing Connections
Running SQL Commands
Running SQL Statements
Using Cursors
Transaction
Prepared Statements
Embedded SQL Commands
ALLOCATE DESCRIPTOR
CONNECT
DEALLOCATE DESCRIPTOR
DECLARE
DESCRIBE
DISCONECT
EXECUTE IMMEDIATE
GET DESCRIPTOR
OPEN
PREPARE
SET AUTOCOMMIT
SET CONNECTION
SET DESCRIPTOR
TYPE
VAR
WHENEVER
Querying the Result Set
Closing a Database Connection
Host Variables
Overview
DECLARE Section
Retrieving Query Results
Type Mapping
Handling Character Strings
Host Variables with Non-Primitive Types
Accessing Special Data Types
Handling Non-Primitive SQL Data Types
Executing Dynamic SQL Statements
Executing Statements Without a Result Set
Executing a Statement with Input Parameters
Executing a Statement with a Result Set
Error Handling
Setting Callbacks
sqlca
SQLSTATE and SQLCODE
Preprocessor Directives
Including Files
Directives ifdef, ifndef, else, elif, and endif
Directives define and undef
Using Library Functions
SQL Descriptor Area
Named SQLDA
SQLDA
Examples
ECPG API Reference
Interval Type
Numeric data types
Date Type
Timestamp Type
Development Based on the Go Driver
Go Driver Package, Environment Class, and Driver Class
Development Process
Connecting to a Database
Connecting to the Database (Using SSL)
Go APIs
sql.Open
type DB
type Stmt
type Tx
type Rows
type Row
type ColumnType
type Result
Commissioning
SQL Optimization
Query Execution Process
Introduction to the SQL Execution Plan
Overview
Description
Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Overview
Selecting a Storage Model
Selecting a Distribution Mode
Selecting Distribution Keys
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Typical SQL Optimization Methods
Optimizing SQL Self-Diagnosis
Optimizing Statement Pushdown
Optimizing Subqueries
Optimizing Statistics
Optimizing Operators
Optimizing Data Skew
Experience in Rewriting SQL Statements
Configuring Key Parameters for SQL Tuning
Hint-based Tuning
Plan Hint Optimization
Hint Specifying the Query Block Where the Hint Is Located
Hint Specifying the Query Block and Schema of a Table
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Hints
Sublink Name Hints
Skew Hints
Parameterized Path Hint
Hint Errors, Conflicts, and Other Warnings
Plan Hint Cases
GUC Parameter Hints
Hints for Selecting the Custom Plan or Generic Plan
Hints Specifying Not to Expand Subqueries
Hints Specifying Not to Use Global Plan Cache
Hint of Parameterized Paths at the Same Level
Hint for Setting Slow SQL Control Rules
Bitmap Scan Hints
Hint for Inner Table Materialization During Join
AGG Hint
Checking the Implicit Conversion Performance
Using the Vectorized Executor for Tuning
Tuning with SQL PATCH
Optimization Cases
Case: Selecting an Appropriate Distribution Key
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Pushing Down Sort Operations to DNs
Case: Setting cost_param and Optimizing Query Performance
Case: Adjusting Distribution Keys
Case: Adjusting Partial Clustering Keys
Case: Adjusting the Table Storage Model in a Medium Table
Case: Adjusting Partial Clustering Keys
Case: Modifying a Partitioned Table
Case: Adjusting the GUC Parameter best_agg_plan
Case: Rewriting SQL and Deleting Subqueries (1)
Case: Rewriting SQL and Deleting Subqueries (2)
Case: Rewriting SQL Statements to Eliminate Pruning Interference
Case: Rewriting SQL Statements and Deleting in-clause
Case: Setting Partial Cluster Keys
Case: Modifying the GUC Parameter rewrite_rule
Using DN Gather to Reduce Stream Nodes in the Plan
SQL Reference
GaussDB SQL
Keywords
Data Type
Numeric Types
Monetary Types
Boolean Types
Character Types
Binary Types
Date/Time Types
Geometric Types
Network Address Types
Bit String Types
Text Search Types
UUID Type
JSON/JSONB Types
HLL
Range
Object Identifier Types
Pseudo-Types
Data Types Supported by Column-Store Tables
XML Type
XMLType
ACLItem
Data Types Used by a Ledger Database (Lab Feature)
Constant and Macro
Functions and Operators
Logical Operators
Comparison Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Pattern Matching Operators
Arithmetic Functions and Operators
Date and Time Processing Functions and Operators
Type Conversion Functions
Geometric Functions and Operators
Network Address Functions and Operators
Text Search Functions and Operators
JSON/JSONB Functions and Operators
HLL Functions and Operators
SEQUENCE Functions
Array Functions and Operators
Range Functions and Operators
Aggregate Functions
Window Functions
Security Functions
Encrypted Functions and Operators
Set Returning Functions
Conditional Expression Functions
System Information Functions
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signal Functions
Backup and Restoration Control Functions
Dual-Cluster DR Control Functions
Dual-Cluster DR Query Functions
Snapshot Synchronization Functions
Database Object Functions
Advisory Lock Functions
Logical Replication Functions
Undo System Functions
Other Functions
Segment-Page Storage Functions (Lab Feature)
Statistics Information Functions
Trigger Functions
Hash Function
Prompt Message Function
Fault Injection System Function
Redistribution Parameters
Distribution Key Recommendation Functions
Other System Functions
Internal Functions
AI Feature Functions
Dynamic Data Masking Functions
Hotkey Feature Functions
Global SysCache Functions
Data Damage Detection and Repair Functions
Functions of the XML Type
Functions of the XMLType Type
Functions Used by a Ledger Database (Lab Feature)
Obsolete Functions
Expressions
Simple Expressions
Condition Expressions
Subquery Expressions
Array Expressions
Row Expressions
Pseudocolumn
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Full Text Search
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Tables and Indexes
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Manipulating Queries
Rewriting Queries
Gathering Document Statistics
Parser
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Configuration Examples
Testing and Debugging Text Search
Testing a Configuration
Testing an Age Parser
Testing a Dictionary
Limitations
System Operation
Controlling Transactions
DDL Syntax Overview
DML Syntax Overview
DCL Syntax Overview
SQL Syntax
SQL Syntax
ABORT
ALTER APP WORKLOAD GROUP MAPPING
ALTER AUDIT POLICY
ALTER COLUMN ENCRYPTION KEY
ALTER COORDINATOR
ALTER DATABASE
ALTER DATABASE LINK
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER FOREIGN TABLE (for Import and Export)
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER NODE
ALTER NODE GROUP
ALTER PACKAGE
ALTER RESOURCE LABEL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ALTER WORKLOAD GROUP
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE APP WORKLOAD GROUP MAPPING
CREATE AUDIT POLICY
CREATE BARRIER
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATABASE LINK
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE FOREIGN TABLE (for Import and Export)
CREATE FUNCTION
CREATE GLOBAL INDEX
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE NODE
CREATE NODE GROUP
CREATE PACKAGE
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE WORKLOAD GROUP
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP APP WORKLOAD GROUP MAPPING
DROP AUDIT POLICY
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATABASE LINK
DROP DATA SOURCE
DROP DIRECTORY
DROP FOREIGN TABLE
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP NODE
DROP NODE GROUP
DROP OWNED
DROP PACKAGE
DROP PROCEDURE
DROP RESOURCE LABEL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
DROP WORKLOAD GROUP
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXECUTE DIRECT
EXPDP DATABASE
EXPDP TABLE
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
IMPDP DATABASE CREATE
IMPDP RECOVER
INSERT
IMPDP TABLE
IMPDP TABLE PREPARE
LOCK
MOVE
MERGE INTO
PREDICT BY
PREPARE
PREPARE TRANSACTION
PURGE
REASSIGN OWNED
REINDEX
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
SHUTDOWN
START TRANSACTION
TIMECAPSULE TABLE
TRUNCATE
UPDATE
VACUUM
VALUES
ALTER RESOURCE POOL (Lab Feature)
CREATE RESOURCE POOL (Lab Feature)
DROP RESOURCE POOL (Lab Feature)
Appendix
GIN Indexes
Introduction
Scalability
Implementation
GIN Tips and Tricks
Extended Functions
Dollar-Quoted String Constants
DATABASE LINK
Best Practices
Best Practices of Table Design
Selecting a Storage Model
Selecting a Distribution Mode
Selecting Distribution Keys
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Checking a Node Where a Table Resides
Best Practices of SQL Queries
Best Practices for Data Skew Query
Quickly Locating Tables That Cause Data Skew
User-defined Functions
PL/SQL Functions
C Language Functions (Lab Feature)
Stored Procedures
Overview
Data Types
Data Type Conversion
Arrays, Collections, and Records
Arrays
Collections
Use of Collection Types
Collection Functions
Records
DECLARE Syntax
Basic Structure
Anonymous Blocks
Subprograms
Basic Statements
Variable Definition Statements
Assignment Statements
Call Statements
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-Query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Transaction Statements
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Advanced Packages
Basic Interfaces
PKG_SERVICE
PKG_UTIL
DBE_XML
Secondary Encapsulation Interfaces (Recommended)
DBE_LOB
DBE_RANDOM
DBE_OUTPUT
DBE_RAW
DBE_TASK
DBE_UTILITY
DBE_SQL
DBE_FILE
DBE_SESSION
DBE_MATCH
DBE_SCHEDULER
DBE_APPLICATION_INFO
DBE_XMLDOM
DBE_XMLPARSER
Retry Management
PACKAGE
Debugging
Autonomous Transaction
Stored Procedure Supporting Autonomous Transaction
Anonymous Block Supporting Autonomous Transaction
Function Supporting Autonomous Transaction
Package Supporting Autonomous Transaction
Restrictions
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_AUDITING_POLICY
GS_AUDITING_POLICY_ACCESS
GS_AUDITING_POLICY_FILTERS
GS_AUDITING_POLICY_PRIVILEGES
GS_ASP
GS_CLIENT_GLOBAL_KEYS
GS_CLIENT_GLOBAL_KEYS_ARGS
GS_COLUMN_KEYS
GS_COLUMN_KEYS_ARGS
GS_DATABASE_LINK
GS_DB_PRIVILEGE
GS_DEPENDENCIES
GS_DEPENDENCIES_OBJ
GS_ENCRYPTED_COLUMNS
GS_ENCRYPTED_PROC
GS_GLOBAL_CHAIN
GS_GLOBAL_CONFIG
GS_JOB_ATTRIBUTE
GS_JOB_ARGUMENT
GS_MASKING_POLICY
GS_MASKING_POLICY_ACTIONS
GS_MASKING_POLICY_FILTERS
GS_MATVIEW
GS_MATVIEW_DEPENDENCY
GS_MODEL_WAREHOUSE
GS_OPT_MODEL
GS_PACKAGE
GS_PLAN_TRACE
GS_POLICY_LABEL
GS_RECYCLEBIN
GS_SQL_PATCH
GS_TXN_SNAPSHOT
GS_UID
GS_WLM_EC_OPERATOR_INFO
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_SESSION_QUERY_INFO_ALL
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_APP_WORKLOADGROUP_MAPPING
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_DIRECTORY
PG_ENUM
PG_EXTENSION
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_HASHBUCKET
PG_INDEX
PG_INHERITS
PG_JOB
PG_JOB_PROC
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_PUBLICATION
PG_PUBLICATION_REL
PG_RANGE
PG_REPLICATION_ORIGIN
PG_RESOURCE_POOL
PG_REWRITE
PG_RLSPOLICY
PG_SECLABEL
PG_SET
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_STATISTIC
PG_STATISTIC_EXT
PG_SUBSCRIPTION
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_GROUP
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PGXC_REDISTB
PGXC_SLICE
PLAN_TABLE_DATA
STATEMENT_HISTORY
STREAMING_STREAM
STREAMING_CONT_QUERY
System Views
ADM_ARGUMENTS
ADM_AUDIT_OBJECT
ADM_AUDIT_SESSION
ADM_AUDIT_STATEMENT
ADM_AUDIT_TRAIL
ADM_COL_COMMENTS
ADM_CONS_COLUMNS
ADM_CONSTRAINTS
ADM_COLL_TYPES
ADM_COL_PRIVS
ADM_DATA_FILES
ADM_DEPENDENCIES
ADM_DIRECTORIES
ADM_HIST_SNAPSHOT
ADM_HIST_SQL_PLAN
ADM_HIST_SQLSTAT
ADM_HIST_SQLTEXT
ADM_INDEXES
ADM_IND_COLUMNS
ADM_IND_EXPRESSIONS
ADM_IND_PARTITIONS
ADM_IND_SUBPARTITIONS
ADM_OBJECTS
ADM_PART_COL_STATISTICS
ADM_PART_INDEXES
ADM_PART_TABLES
ADM_PROCEDURES
ADM_ROLE_PRIVS
ADM_ROLES
ADM_SCHEDULER_JOBS
ADM_SCHEDULER_JOB_ARGS
ADM_SCHEDULER_PROGRAMS
ADM_SCHEDULER_PROGRAM_ARGS
ADM_SCHEDULER_RUNNING_JOBS
ADM_SEGMENTS
ADM_SEQUENCES
ADM_SOURCE
ADM_SUBPART_KEY_COLUMNS
ADM_SYS_PRIVS
ADM_SYNONYMS
ADM_TAB_COLS
ADM_TABLES
ADM_TABLESPACES
ADM_TAB_COL_STATISTICS
ADM_TAB_COLUMNS
ADM_TAB_COMMENTS
ADM_TAB_HISTOGRAMS
ADM_TAB_PARTITIONS
ADM_TAB_PRIVS
ADM_TAB_STATS_HISTORY
ADM_TAB_STATISTICS
ADM_TRIGGERS
ADM_TYPES
ADM_TYPE_ATTRS
ADM_USERS
ADM_VIEWS
COMM_CLIENT_INFO
DB_ARGUMENTS
DB_ALL_TABLES
DB_COL_COMMENTS
DB_COL_PRIVS
DB_COLL_TYPES
DB_CONSTRAINTS
DB_CONS_COLUMNS
DB_DEPENDENCIES
DB_IND_COLUMNS
DB_IND_EXPRESSIONS
DB_IND_PARTITIONS
DB_IND_SUBPARTITIONS
DB_INDEXES
DB_OBJECTS
DB_PART_COL_STATISTICS
DB_PART_KEY_COLUMNS
DB_PART_TABLES
DB_PROCEDURES
DB_SCHEDULER_JOB_ARGS
DB_SCHEDULER_PROGRAM_ARGS
DB_SEQUENCES
DB_SOURCE
DB_SUBPART_KEY_COLUMNS
DB_SYNONYMS
DB_TAB_COLUMNS
DB_TAB_COMMENTS
DB_TAB_COL_STATISTICS
DB_TAB_HISTOGRAMS
DB_TAB_PARTITIONS
DB_TAB_STATS_HISTORY
DB_TAB_SUBPARTITIONS
DB_TABLES
DB_TRIGGERS
DB_TYPES
DB_USERS
DB_VIEWS
DICT
DICTIONARY
DV_SESSIONS
DV_SESSION_LONGOPS
GET_GLOBAL_PREPARED_XACTS
GLOBAL_BAD_BLOCK_INFO
GLOBAL_CLEAR_BAD_BLOCK_INFO
GLOBAL_COMM_CLIENT_INFO
GLOBAL_SQL_PATCH
GLOBAL_STAT_HOTKEYS_INFO
GLOBAL_WAL_SENDER_STATUS
GS_ALL_CONTROL_GROUP_INFO
GS_ALL_PREPARED_STATEMENTS
GS_AUDITING
GS_AUDITING_ACCESS
GS_AUDITING_PRIVILEGE
GS_CLUSTER_RESOURCE_INFO
GS_COMM_LISTEN_ADDRESS_EXT_INFO
GS_DB_LINKS
GS_DB_PRIVILEGES
GS_GET_CONTROL_GROUP_INFO
GS_GSC_MEMORY_DETAIL
GS_LABELS
GS_GET_LISTEN_ADDRESS_EXT_INFO
GS_LSC_MEMORY_DETAIL
GS_MASKING
GS_MATVIEWS
GS_MY_PLAN_TRACE
GS_SESSION_ALL_SETTINGS
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY_STATISTICS
GS_SQL_COUNT
GS_STAT_DB_CU
GS_STAT_SESSION_CU
GS_TOTAL_NODEGROUP_MEMORY_DETAIL
GS_WLM_CGROUP_INFO
GS_WLM_EC_OPERATOR_STATISTICS
GS_WLM_EC_OPERATOR_HISTORY
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_REBUILD_USER_RESOURCE_POOL
GS_WLM_RESOURCE_POOL
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_INFO
GS_WLM_SESSION_INFO_ALL
GS_WLM_USER_INFO
GS_WLM_USER_SESSION_INFO
GS_WLM_SESSION_STATISTICS
GS_WLM_WORKLOAD_RECORDS
GV_INSTANCE
GV_SESSION
MPP_TABLES
MY_COL_COMMENTS
MY_COL_PRIVS
MY_COLL_TYPES
MY_CONS_COLUMNS
MY_CONSTRAINTS
MY_DEPENDENCIES
MY_INDEXES
MY_IND_COLUMNS
MY_IND_EXPRESSIONS
MY_IND_PARTITIONS
MY_IND_SUBPARTITIONS
MY_JOBS
MY_OBJECTS
MY_PART_COL_STATISTICS
MY_PART_INDEXES
MY_PART_KEY_COLUMNS
MY_PART_TABLES
MY_PROCEDURES
MY_ROLE_PRIVS
MY_SCHEDULER_JOB_ARGS
MY_SCHEDULER_PROGRAM_ARGS
MY_SEQUENCES
MY_SOURCE
MY_SUBPART_KEY_COLUMNS
MY_SYNONYMS
MY_SYS_PRIVS
MY_TAB_COLUMNS
MY_TAB_COL_STATISTICS
MY_TAB_COMMENTS
MY_TAB_HISTOGRAMS
MY_TAB_PARTITIONS
MY_TAB_STATS_HISTORY
MY_TAB_STATISTICS
MY_TABLES
MY_TABLESPACES
MY_TRIGGERS
MY_TYPE_ATTRS
MY_TYPES
MY_VIEWS
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
PG_AVAILABLE_EXTENSIONS
PG_AVAILABLE_EXTENSION_VERSIONS
PG_COMM_DELAY
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_STATUS
PG_CONTROL_GROUP_CONFIG
PG_CURSORS
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_INDEXES
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_POOLER_STATUS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_PUBLICATION_TABLES
PG_REPLICATION_SLOTS
PG_RLSPOLICIES
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SESSION_IOSTAT
PG_SESSION_WLMSTAT
PG_SETTINGS
PG_SHADOW
PG_SHARED_MEMORY_DETAIL
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ACTIVITY_NG
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_REPLICATION
PG_STAT_SUBSCRIPTION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_THREAD_WAIT_STATUS
PG_TABLES
PG_TDE_INFO
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_USER_RESOURCE_INFO
PG_TOTAL_USER_RESOURCE_INFO_OID
PG_USER
PG_USER_MAPPINGS
PG_VARIABLE_INFO
PG_VIEWS
PG_WLM_STATISTICS
PGXC_COMM_DELAY
PGXC_COMM_RECV_STREAM
PGXC_COMM_SEND_STREAM
PGXC_COMM_STATUS
PGXC_GET_STAT_ALL_TABLES
PGXC_GET_TABLE_SKEWNESS
PGXC_NODE_ENV
PGXC_OS_THREADS
PGXC_PREPARED_XACTS
PGXC_RUNNING_XACTS
PGXC_STAT_ACTIVITY
PGXC_STAT_BAD_BLOCK
PGXC_SQL_COUNT
PGXC_THREAD_WAIT_STATUS
PGXC_TOTAL_MEMORY_DETAIL
PGXC_VARIABLE_INFO
PGXC_WLM_EC_OPERATOR_HISTORY
PGXC_WLM_EC_OPERATOR_INFO
PGXC_WLM_EC_OPERATOR_STATISTICS
PGXC_WLM_OPERATOR_HISTORY
PGXC_WLM_OPERATOR_INFO
PGXC_WLM_OPERATOR_STATISTICS
PGXC_WLM_REBUILD_USER_RESPOOL
PGXC_WLM_SESSION_HISTORY
PGXC_WLM_SESSION_INFO
PGXC_WLM_SESSION_STATISTICS
PGXC_WLM_WORKLOAD_RECORDS
PLAN_TABLE
PV_FILE_STAT
PV_INSTANCE_TIME
PV_OS_RUN_INFO
PV_REDO_STAT
PV_SESSION_MEMORY
PV_SESSION_MEMORY_CONTEXT
PV_SESSION_MEMORY_DETAIL
PV_SESSION_STAT
PV_SESSION_TIME
PV_THREAD_MEMORY_CONTEXT
PV_TOTAL_MEMORY_DETAIL
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SYS_DUMMY
V_INSTANCE
V_MYSTAT
V_SESSION
V$NLS_PARAMETERS
V$SESSION_WAIT
V$SYSSTAT
V$SYSTEM_EVENT
V$VERSION
GS_STATIO_ALL_PARTITIONS
GS_STAT_XACT_ALL_PARTITIONS
GS_STAT_ALL_PARTITIONS
Discarded
System Catalogs
GS_OBSSCANINFO
PG_EXTENSION_DATA_SOURCE
PG_OBSSCANINFO
STREAMING_REAPER_STATUS
Schemas
Information Schema
_PG_FOREIGN_DATA_WRAPPERS
_PG_FOREIGN_SERVERS
_PG_FOREIGN_TABLE_COLUMNS
_PG_FOREIGN_TABLES
_PG_USER_MAPPINGS
INFORMATION_SCHEMA_CATALOG_NAME
DBE_PERF Schema
OS
OS_RUNTIME
GLOBAL_OS_RUNTIME
OS_THREADS
GLOBAL_OS_THREADS
Instance
INSTANCE_TIME
GLOBAL_INSTANCE_TIME
Memory
MEMORY_NODE_DETAIL
GLOBAL_MEMORY_NODE_DETAIL
MEMORY_NODE_NG_DETAIL
SHARED_MEMORY_DETAIL
GLOBAL_SHARED_MEMORY_DETAIL
TRACK_MEMORY_CONTEXT_DETAIL
File
FILE_IOSTAT
SUMMARY_FILE_IOSTAT
GLOBAL_FILE_IOSTAT
FILE_REDO_IOSTAT
SUMMARY_FILE_REDO_IOSTAT
GLOBAL_FILE_REDO_IOSTAT
LOCAL_REL_IOSTAT
GLOBAL_REL_IOSTAT
SUMMARY_REL_IOSTAT
Object
STAT_USER_TABLES
SUMMARY_STAT_USER_TABLES
GLOBAL_STAT_USER_TABLES
STAT_USER_INDEXES
SUMMARY_STAT_USER_INDEXES
GLOBAL_STAT_USER_INDEXES
STAT_SYS_TABLES
SUMMARY_STAT_SYS_TABLES
GLOBAL_STAT_SYS_TABLES
STAT_SYS_INDEXES
SUMMARY_STAT_SYS_INDEXES
GLOBAL_STAT_SYS_INDEXES
STAT_ALL_TABLES
SUMMARY_STAT_ALL_TABLES
GLOBAL_STAT_ALL_TABLES
STAT_ALL_INDEXES
SUMMARY_STAT_ALL_INDEXES
GLOBAL_STAT_ALL_INDEXES
STAT_DATABASE
SUMMARY_STAT_DATABASE
GLOBAL_STAT_DATABASE
STAT_DATABASE_CONFLICTS
SUMMARY_STAT_DATABASE_CONFLICTS
GLOBAL_STAT_DATABASE_CONFLICTS
STAT_XACT_ALL_TABLES
SUMMARY_STAT_XACT_ALL_TABLES
GLOBAL_STAT_XACT_ALL_TABLES
STAT_XACT_SYS_TABLES
SUMMARY_STAT_XACT_SYS_TABLES
GLOBAL_STAT_XACT_SYS_TABLES
STAT_XACT_USER_TABLES
SUMMARY_STAT_XACT_USER_TABLES
GLOBAL_STAT_XACT_USER_TABLES
STAT_XACT_USER_FUNCTIONS
SUMMARY_STAT_XACT_USER_FUNCTIONS
GLOBAL_STAT_XACT_USER_FUNCTIONS
STAT_BAD_BLOCK
SUMMARY_STAT_BAD_BLOCK
GLOBAL_STAT_BAD_BLOCK
STAT_USER_FUNCTIONS
SUMMARY_STAT_USER_FUNCTIONS
GLOBAL_STAT_USER_FUNCTIONS
Workload
WORKLOAD_SQL_COUNT
SUMMARY_WORKLOAD_SQL_COUNT
WORKLOAD_TRANSACTION
SUMMARY_WORKLOAD_TRANSACTION
GLOBAL_WORKLOAD_TRANSACTION
WORKLOAD_SQL_ELAPSE_TIME
SUMMARY_WORKLOAD_SQL_ELAPSE_TIME
USER_TRANSACTION
GLOBAL_USER_TRANSACTION
Session and Thread
SESSION_STAT
GLOBAL_SESSION_STAT
SESSION_TIME
GLOBAL_SESSION_TIME
SESSION_MEMORY
GLOBAL_SESSION_MEMORY
SESSION_MEMORY_DETAIL
GLOBAL_SESSION_MEMORY_DETAIL
SESSION_STAT_ACTIVITY
GLOBAL_SESSION_STAT_ACTIVITY
THREAD_WAIT_STATUS
GLOBAL_THREAD_WAIT_STATUS
LOCAL_THREADPOOL_STATUS
GLOBAL_THREADPOOL_STATUS
SESSION_CPU_RUNTIME
SESSION_MEMORY_RUNTIME
STATEMENT_IOSTAT_COMPLEX_RUNTIME
LOCAL_ACTIVE_SESSION
GLOBAL_ACTIVE_SESSION
Transaction
TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS
GLOBAL_TRANSACTIONS_RUNNING_XACTS
TRANSACTIONS_PREPARED_XACTS
SUMMARY_TRANSACTIONS_PREPARED_XACTS
GLOBAL_TRANSACTIONS_PREPARED_XACTS
Query
STATEMENT
SUMMARY_STATEMENT
STATEMENT_COUNT
GLOBAL_STATEMENT_COUNT
SUMMARY_STATEMENT_COUNT
GLOBAL_STATEMENT_COMPLEX_HISTORY
GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
GLOBAL_STATEMENT_COMPLEX_RUNTIME
STATEMENT_RESPONSETIME_PERCENTILE
STATEMENT_COMPLEX_RUNTIME
STATEMENT_COMPLEX_HISTORY_TABLE
STATEMENT_COMPLEX_HISTORY
STATEMENT_WLMSTAT_COMPLEX_RUNTIME
STATEMENT_HISTORY
Cache and I/O
STATIO_USER_TABLES
SUMMARY_STATIO_USER_TABLES
GLOBAL_STATIO_USER_TABLES
STATIO_USER_INDEXES
SUMMARY_STATIO_USER_INDEXES
GLOBAL_STATIO_USER_INDEXES
STATIO_USER_SEQUENCES
SUMMARY_STATIO_USER_SEQUENCES
GLOBAL_STATIO_USER_SEQUENCES
STATIO_SYS_TABLES
SUMMARY_STATIO_SYS_TABLES
GLOBAL_STATIO_SYS_TABLES
STATIO_SYS_INDEXES
SUMMARY_STATIO_SYS_INDEXES
GLOBAL_STATIO_SYS_INDEXES
STATIO_SYS_SEQUENCES
SUMMARY_STATIO_SYS_SEQUENCES
GLOBAL_STATIO_SYS_SEQUENCES
STATIO_ALL_TABLES
SUMMARY_STATIO_ALL_TABLES
GLOBAL_STATIO_ALL_TABLES
STATIO_ALL_INDEXES
SUMMARY_STATIO_ALL_INDEXES
GLOBAL_STATIO_ALL_INDEXES
STATIO_ALL_SEQUENCES
SUMMARY_STATIO_ALL_SEQUENCES
GLOBAL_STATIO_ALL_SEQUENCES
GLOBAL_STAT_DB_CU
GLOBAL_STAT_SESSION_CU
Communication Library
COMM_DELAY
GLOBAL_COMM_DELAY
COMM_RECV_STREAM
GLOBAL_COMM_RECV_STREAM
COMM_SEND_STREAM
GLOBAL_COMM_SEND_STREAM
COMM_STATUS
GLOBAL_COMM_STATUS
Utility
REPLICATION_STAT
GLOBAL_REPLICATION_STAT
REPLICATION_SLOTS
GLOBAL_REPLICATION_SLOTS
PARALLEL_DECODE_STATUS
GLOBAL_PARALLEL_DECODE_STATUS
PARALLEL_DECODE_THREAD_INFO
GLOBAL_PARALLEL_DECODE_THREAD_INFO
BGWRITER_STAT
GLOBAL_BGWRITER_STAT
POOLER_STATUS
GLOBAL_COMM_CHECK_CONNECTION_STATUS
GLOBAL_CKPT_STATUS
GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_PAGEWRITER_STATUS
GLOBAL_POOLER_STATUS
GLOBAL_RECORD_RESET_TIME
GLOBAL_REDO_STATUS
GLOBAL_RECOVERY_STATUS
CLASS_VITAL_INFO
USER_LOGIN
SUMMARY_USER_LOGIN
GLOBAL_GET_BGWRITER_STATUS
GLOBAL_SINGLE_FLUSH_DW_STATUS
GLOBAL_CANDIDATE_STATUS
Lock
LOCKS
GLOBAL_LOCKS
Wait Event
WAIT_EVENTS
GLOBAL_WAIT_EVENTS
WAIT_EVENT_INFO
Configuration
CONFIG_SETTINGS
GLOBAL_CONFIG_SETTINGS
Operator
OPERATOR_HISTORY_TABLE
OPERATOR_HISTORY
OPERATOR_RUNTIME
GLOBAL_OPERATOR_EC_HISTORY
GLOBAL_OPERATOR_EC_HISTORY_TABLE
GLOBAL_OPERATOR_EC_RUNTIME
GLOBAL_OPERATOR_HISTORY
GLOBAL_OPERATOR_HISTORY_TABLE
GLOBAL_OPERATOR_RUNTIME
Workload Manager
WLM_CGROUP_CONFIG
WLM_CLUSTER_RESOURCE_RUNTIME
WLM_CONTROLGROUP_CONFIG
WLM_CONTROLGROUP_NG_CONFIG
WLM_RESOURCEPOOL_RUNTIME
WLM_USER_RESOURCE_CONFIG
WLM_USER_RESOURCE_RUNTIME
WLM_WORKLOAD_HISTORY_INFO
WLM_WORKLOAD_RUNTIME
GLOBAL_WLM_WORKLOAD_RUNTIME
LOCAL_IO_WAIT_INFO
GLOBAL_IO_WAIT_INFO
Global Plan Cache
LOCAL_PLANCACHE_STATUS
GLOBAL_PLANCACHE_STATUS
RTO & RPO
global_rto_status
global_streaming_hadr_rto_and_rpo_stat
AI Watchdog
ai_watchdog_monitor_status
ai_watchdog_detection_warnings
ai_watchdog_parameters
Discarded
Query
GS_SLOW_QUERY_INFO
GS_SLOW_QUERY_HISTORY
GLOBAL_SLOW_QUERY_HISTORY
GLOBAL_SLOW_QUERY_INFO
Operator
OPERATOR_EC_HISTORY
OPERATOR_EC_HISTORY_TABLE
OPERATOR_EC_RUNTIME
Global Plancache
LOCAL_PREPARE_STATEMENT_STATUS
GLOBAL_PREPARE_STATEMENT_STATUS
WDR Snapshot Schema
Original Information of WDR Snapshots
SNAPSHOT.SNAPSHOT
SNAPSHOT.TABLES_SNAP_TIMESTAMP
SNAP_SEQ
WDR Snapshot Data Table
WDR Information
Database Stat
Load Profile
Instance Efficiency Percentages
Top 10 Events by Total Wait Time
Wait Classes by Total Wait Time
Host CPU
IO Profile
Memory Statistics
Time Model
SQL Statistics
Wait Events
Cache IO Stats
Utility status
Object stats
Configuration settings
SQL Detail
DBE_SQL_UTIL Schema
DBE_SQL_UTIL.create_hint_sql_patch
DBE_SQL_UTIL.create_abort_sql_patch
DBE_SQL_UTIL.drop_sql_patch
DBE_SQL_UTIL.enable_sql_patch
DBE_SQL_UTIL.disable_sql_patch
DBE_SQL_UTIL.show_sql_patch
DBE_SQL_UTIL.create_hint_sql_patch
DBE_SQL_UTIL.create_abort_sql_patch
DBE_SQL_UTIL.create_remote_hint_sql_patch
DBE_SQL_UTIL.create_remote_abort_sql_patch
DBE_SQL_UTIL.drop_remote_sql_patch
DBE_SQL_UTIL.enable_remote_sql_patch
DBE_SQL_UTIL.disable_remote_sql_patch
Configuring Running Parameters
Viewing Parameters
Setting Parameters
GUC Parameters
GUC Parameter Usage
File Location
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Disk Space
Kernel Resource Usage
Cost-based Vacuum Delay
Background Writer
Asynchronous I/O
Parallel Data Import
Write Ahead Log
Settings
Checkpoints
Log Replay
Archiving
HA Replication
Sending Server
Primary Server
Standby Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Destination
Logging Time
Logging Content
Using CSV Log Output
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Hotspot Key Statistics
Workload Management
Automatic Vacuuming
Default Settings of Client Connection
Statement Behavior
Locale and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Cluster Transaction Parameters
Dual-Cluster Replication Parameters
Developer Options
Auditing
Audit Switch
User and Permission Audit
Operation Auditing
Transaction Monitoring
CM Parameters
CM Agent Parameters
CM Server Parameters
GTM Parameters
Upgrade Parameters
Miscellaneous Parameters
Wait Event
Query
System Performance Snapshot
Multi-Mode Engine
Time Series Engine
Streaming Engine
Security Configuration
HyperLogLog
User-defined Functions
Collaborative Analysis
Acceleration Cluster
Scheduled Task
Thread Pool
Full Text Search
Backup and Restoration
AI Features
Global SysCache Parameters
Reserved Parameters
Read Parameters of the Standby Node in a Distributed System
Restoring Data on the Standby Node
Undo
Rollback Parameters
DCF Parameters Settings
Flashback
Centralized_3.x
Database System Overview
Database Logical Architecture
Query Request Handling Process
Managing Transactions
Concepts
Database Security
Users and Permissions
Default Permission Mechanism
Administrator
Separation of Duties
Users
Roles
Schemas
Setting User Permissions
Row-Level Security Policy
Database Audit
Database Quick Start
Connecting to a Database
Using gsql to Connect to a Database
APIs
Operating a Database
Creating a Database Account
Creating and Managing Databases
Planning a Storage Model
Creating and Managing Tablespaces
Creating and Managing Tables
Creating Tables
Inserting Data to Tables
Updating Data in a Table
Viewing Data
Deleting Data from a Table
Querying System Catalogs
Other Operations
Creating and Managing Schemas
Creating and Managing Partitioned Tables
Creating and Managing Indexes
Creating and Managing Views
Creating and Managing Sequences
Development and Design Proposal
Development and Design Proposal
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Field Design
Constraint Design
View and Joined Table Design
Tool Interconnection
JDBC Configuration
SQL Compilation
Application Development Guide
Development Specifications
Obtaining the Driver Package
Development Based on JDBC
JDBC Packages, Driver Classes, and Environment Classes
Development Process
Loading the Driver
Connecting to a Database
Connecting to the Database (Using SSL)
Connecting to a Database (Using UDS)
Running SQL Statements
Processing Data in a Result Set
Closing a Connection
Log Management
Examples: Common Operations
Example: Retrying SQL Queries for Applications
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MY
Example: Logic Replication Code
Example: Parameters for Connecting to the Database in Different Scenarios
JDBC API Reference
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
PGReplicationConnection
PGReplicationStream
ChainedStreamBuilder
ChainedCommonStreamBuilder
PGobject
Common JDBC Parameters
Troubleshooting
Incorrect batchMode Settings
Mapping for JDBC Data Types
Development Based on ODBC
ODBC Packages, Dependent Libraries, and Header Files
Development Process
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
Example: Common Functions and Batch Binding
Typical Application Scenarios and Configurations
ODBC Interface Reference
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
Development Based on libpq
libpq Package, Dependent Library, and Header File
Development Process
Example
libpq API Reference
Database Connection Control Functions
PQconnectdbParams
PQconnectdb
PQconninfoParse
PQconnectStart
PQerrorMessage
PQsetdbLogin
PQfinish
PQreset
PQstatus
Database Statement Execution Functions
PQclear
PQexec
PQexecParams
PQexecParamsBatch
PQexecPrepared
PQexecPreparedBatch
PQfname
PQgetvalue
PQnfields
PQntuples
PQprepare
PQresultStatus
Functions for Asynchronous Command Processing
PQsendQuery
PQsendQueryParams
PQsendPrepare
PQsendQueryPrepared
PQflush
Functions for Canceling Queries in Progress
PQgetCancel
PQfreeCancel
PQcancel
Connection Parameters
Psycopg-based Development
Development Process
Development Procedure
Examples: Common Operations
Psycopg API Reference
psycopg2.connect()
connection.cursor()
cursor.execute(query,vars_list)
curosr.executemany(query,vars_list)
connection.commit()
connection.rollback()
cursor.fetchone()
cursor.fetchall()
cursor.close()
connection.close()
Development Based on the Go Driver
Go Driver Package, Environment Class, and Driver Class
Development Process
Connecting to the Database
Connecting to the Database (Using SSL)
Go APIs
sql.Open
type DB
type Stmt
type Tx
type Rows
type Row
type ColumnType
type Result
ECPG-based Development
Development Process
ECPG Components
ECPG Preprocessing and Compiling
Managing Database Connections
Connecting to a Database
Managing Connections
Running SQL Commands
Executing SQL Statements
Using Cursors
Managing Transactions
Prepared Statements
Embedded SQL Commands
ALLOCATE DESCRIPTOR
CONNECT
DEALLOCATE DESCRIPTOR
DECLARE
DESCRIBE
DISCONECT
EXECUTE IMMEDIATE
GET DESCRIPTOR
OPEN
PREPARE
SET AUTOCOMMIT
SET CONNECTION
SET DESCRIPTOR
TYPE
VAR
WHENEVER
Querying the Result Set
Closing a Database Connection
Host Variables
Overview
DECLARE Section
Retrieving Query Results
Type Mapping
Handling Character Strings
Host Variables with Non-Primitive Types
Accessing Special Data Types
Handling Non-Primitive SQL Data Types
Executing Dynamic SQL Statements
Executing Statements Without a Result Set
Executing a Statement with Input Parameters
Executing a Statement with a Result Set
Error Handling
Setting Callbacks
sqlca
SQLSTATE and SQLCODE
Preprocessor Directives
Including Files
Directives ifdef, ifndef, else, elif, and endif
Directives define and undef
Using Library Functions
SQL Descriptor Area
Named SQLDA
C-Structure SQLDA
Examples
ECPG API Reference
Interval Type
Numeric Type
Date Type
Timestamp Type
Commissioning
SQL Optimization
Query Execution Process
Introduction to the SQL Execution Plan
Overview
Description
Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Overview
Selecting a Storage Model
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Typical SQL Optimization Methods
Optimizing SQL Self-Diagnosis
Optimizing Subqueries
Optimizing Statistics
Optimizing Operators
Experience in Rewriting SQL Statements
Configuring Key Parameters for SQL Tuning
Hint-based Tuning
Plan Hint Optimization
Hint Specifying the Query Block Where the Hint Is Located
Hint Specifying the Query Block and Schema of a Table
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Operation Hints
Sublink Name Hints
Hint Errors, Conflicts, and Other Warnings
Optimizer GUC Parameter Hints
Hint for Selecting the Custom Plan or Generic Plan
Hints Specifying Not to Expand Subqueries
Hint Specifying Not to Use Global Plan Cache
Hint of Parameterized Paths at the Same Level
Hint for Setting Slow SQL Control Rules
Hint for Adaptive Plan Selection
Hint for Materializing a Sub-plan Result
Bitmap Scan Hints
Hint for Inner Table Materialization During Join
AGG Hint
Using the Vectorized Executor for Tuning
Introduction to Plan Trace
Tuning with SQL PATCH
Optimization Cases
Case: Modifying the GUC Parameter rewrite_rule
Case: Creating an Appropriate Index
Case: Adding NOT NULL for the JOIN Column
Case: Modifying a Partitioned Table
Case: Rewriting SQL and Deleting Subqueries (1)
Case: Rewriting SQL and Deleting Subqueries (2)
Case: Rewriting SQL Statements and Deleting in-clause
SQL Reference
SQL
Keywords
Data Types
Numeric Types
Monetary Types
Boolean Types
Character Types
Binary Types
Date/Time Types
Geometric
Network Address Types
Bit String Types
Text Search Types
UUID
JSON/JSONB Types
HLL
Range
Object Identifier Types
Pseudo-Types
Data Types Supported by Column-Store Tables
XML Type
XMLType
SET Type
ACLItem
Data Types Used by the Ledger Database
Constant and Macro
Functions and Operators
Logical Operators
Comparison Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Pattern Matching Operators
Arithmetic Functions and Operators
Date and Time Processing Functions and Operators
Type Conversion Functions
Geometric Functions and Operators
Network Address Functions and Operators
Text Search Functions and Operators
JSON/JSONB Functions and Operators
HLL Functions and Operators
SEQUENCE Functions
Array Functions and Operators
Range Functions and Operators
Aggregate Functions
Window Functions
Security Functions
Encrypted Functions and Operators
Set Returning Functions
Conditional Expression Functions
System Information Functions
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signal Functions
Backup and Restoration Control Functions
DR Control Functions for Dual-Database Instances
DR Query Functions for Dual-Database Instances
Snapshot Synchronization Functions
Database Object Functions
Advisory Lock Functions
Logical Replication Functions
Other Functions
Undo System Functions
Row-Store Compression System Functions
Segment-Page Storage Functions (Lab Feature)
Statistics Information Functions
Trigger Functions
Hash Function
Prompt Message Function
Global Temporary Table Functions
Fault Injection System Function
AI Feature Functions
Dynamic Data Masking Functions
Hierarchical Recursion Query Functions
Other System Functions
Internal Functions
Global SysCache Functions
Data Damage Detection and Repair Functions
Functions of the XML Type
Functions of the XMLType Type
Global PL/SQL Cache Functions
Ledger Database Functions
Obsolete Functions
Expressions
Simple Expressions
Condition Expressions
Subquery Expressions
Array Expressions
Row Expressions
Pseudocolumn
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Tables and Indexes
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Manipulating Queries
Rewriting Queries
Gathering Document Statistics
Parser
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Configuration Examples
Testing and Debugging Text Search
Testing a Configuration
Testing a Parser
Testing a Dictionary
Limitations
System Operation
Controlling Transactions
DDL Syntax Overview
DML Syntax Overview
DCL Syntax Overview
SQL Syntax
SQL Syntax
ABORT
ALTER AGGREGATE
ALTER AUDIT POLICY
ALTER COLUMN ENCRYPTION KEY
ALTER EVENT
ALTER DATABASE
ALTER DATABASE LINK
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER PUBLICATION
ALTER PACKAGE
ALTER PROCEDURE
ALTER RESOURCE LABEL
ALTER RESOURCE POOL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SUBSCRIPTION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLE SUBPARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY (Lab Feature)
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE AGGREGATE
CREATE AUDIT POLICY
CREATE CAST
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATABASE LINK
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE EVENT
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE PACKAGE
CREATE PROCEDURE
CREATE PUBLICATION
CREATE RESOURCE LABEL
CREATE RESOURCE POOL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SUBSCRIPTION
CREATE SYNONYM
CREATE TABLE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TABLESPACE
CREATE TABLE SUBPARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP AGGREGATE
DROP AUDIT POLICY
DROP CAST
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATABASE LINK
DROP DATA SOURCE
DROP DIRECTORY
DROP EVENT
DROP FOREIGN TABLE
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP OPERATOR
DROP OWNED
DROP PACKAGE
DROP PROCEDURE
DROP RESOURCE LABEL
DROP RESOURCE POOL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP RULE
DROP PUBLICATION
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SUBSCRIPTION
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY (Lab Feature)
DROP TRIGGER
DROP TYPE
DROP USER
DROP USER MAPPING
DROP VIEW
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXPDP DATABASE
EXPDP TABLE
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
IMPDP DATABASE CREATE
IMPDP RECOVER
IMPDP TABLE
IMPDP TABLE PREPARE
INSERT
LOCK
MERGE INTO
MOVE
PREDICT BY
PREPARE
PREPARE TRANSACTION
PURGE
REASSIGN OWNED
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
REINDEX
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
SHOW EVENTS
SHRINK
SHUTDOWN
SNAPSHOT
START TRANSACTION
TIMECAPSULE TABLE
TRUNCATE
UPDATE
VACUUM
VALUES
ALTER EXTENSION (Lab Feature)
CREATE EXTENSION (Lab Feature)
DROP EXTENSION (Lab Feature)
Appendix
GIN Index
Introduction
Scalability
Implementation
GIN Tips and Tricks
Extended Functions
Extended Syntax
Dollar-Quoted String Constants
DATABASE LINK
Best Practices
Best Practices of Table Design
Selecting a Storage Model
Using Partial Cluster Keys (PCKs)
Using Partitioned Tables
Selecting a Data type
Best Practices of SQL Queries
User-defined Functions
PL/SQL Functions
C Language Functions (Lab Feature)
Stored Procedure
Stored Procedure
Data Types
Data Type Conversion
Arrays, Collections, and Records
Arrays
Use of Array Types
Functions Supported by Arrays
Collections
Use of Collection Types
Collection Functions
Records
DECLARE Syntax
Basic Structure
Anonymous Blocks
Subprogram
Basic Statements
Variable Definition Statements
Assignment Statements
Call Statements
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-Query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Transaction Management
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Retry Management
Debugging
Package
Autonomous Transaction
Stored Procedure Supporting Autonomous Transaction
Anonymous Block Supporting Autonomous Transaction
Function Supporting Autonomous Transaction
Package Supporting Autonomous Transaction
Restrictions
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_ASP
GS_AUDITING_POLICY
GS_AUDITING_POLICY_ACCESS
GS_AUDITING_POLICY_FILTERS
GS_AUDITING_POLICY_PRIVILEGES
GS_CLIENT_GLOBAL_KEYS
GS_CLIENT_GLOBAL_KEYS_ARGS
GS_COLUMN_KEYS
GS_COLUMN_KEYS_ARGS
GS_DATABASE_LINK
GS_DB_PRIVILEGE
GS_DEPENDENCIES
GS_DEPENDENCIES_OBJ
GS_ENCRYPTED_COLUMNS
GS_ENCRYPTED_PROC
GS_GLOBAL_CHAIN
GS_GLOBAL_CONFIG
GS_JOB_ARGUMENT
GS_JOB_ATTRIBUTE
GS_MASKING_POLICY
GS_MASKING_POLICY_ACTIONS
GS_MASKING_POLICY_FILTERS
GS_MATVIEW
GS_MATVIEW_DEPENDENCY
GS_MODEL_WAREHOUSE
GS_OPT_MODEL
GS_PACKAGE
GS_PLAN_TRACE
GS_POLICY_LABEL
GS_RECYCLEBIN
GS_SQL_PATCH
GS_TXN_SNAPSHOT
GS_UID
GS_WLM_EC_OPERATOR_INFO
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_PLAN_ENCODING_TABLE
GS_WLM_PLAN_OPERATOR_INFO
GS_WLM_SESSION_QUERY_INFO_ALL
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_APP_WORKLOADGROUP_MAPPING
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_DIRECTORY
PG_ENUM
PG_EXTENSION
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_HASHBUCKET
PG_INDEX
PG_INHERITS
PG_JOB
PG_JOB_PROC
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OBSSCANINFO
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_PUBLICATION
PG_PUBLICATION_REL
PG_RANGE
PG_REPLICATION_ORIGIN
PG_RESOURCE_POOL
PG_REWRITE
PG_RLSPOLICY
PG_SECLABEL
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_SET
PG_STATISTIC
PG_STATISTIC_EXT
PG_SUBSCRIPTION
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_GROUP
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PGXC_SLICE
PLAN_TABLE_DATA
STATEMENT_HISTORY
STREAMING_STREAM
STREAMING_CONT_QUERY
System Views
ADM_ARGUMENTS
ADM_AUDIT_OBJECT
ADM_AUDIT_SESSION
ADM_AUDIT_STATEMENT
ADM_AUDIT_TRAIL
ADM_COL_COMMENTS
ADM_COL_PRIVS
ADM_COLL_TYPES
ADM_CONSTRAINTS
ADM_CONS_COLUMNS
ADM_DATA_FILES
ADM_DEPENDENCIES
ADM_DIRECTORIES
ADM_HIST_SNAPSHOT
ADM_HIST_SQL_PLAN
ADM_HIST_SQLSTAT
ADM_HIST_SQLTEXT
ADM_INDEXES
ADM_IND_COLUMNS
ADM_IND_EXPRESSIONS
ADM_IND_PARTITIONS
ADM_IND_SUBPARTITIONS
ADM_PART_COL_STATISTICS
ADM_PART_INDEXES
ADM_OBJECTS
ADM_PART_TABLES
ADM_PROCEDURES
ADM_RECYCLEBIN
ADM_ROLE_PRIVS
ADM_ROLES
ADM_SCHEDULER_JOB_ARGS
ADM_SCHEDULER_JOBS
ADM_SCHEDULER_PROGRAM_ARGS
ADM_SCHEDULER_PROGRAMS
ADM_SCHEDULER_RUNNING_JOBS
ADM_SEGMENTS
ADM_SEQUENCES
ADM_SOURCE
ADM_SUBPART_COL_STATISTICS
ADM_SUBPART_KEY_COLUMNS
ADM_SYNONYMS
ADM_SYS_PRIVS
ADM_TAB_COL_STATISTICS
ADM_TAB_COLS
ADM_TAB_HISTOGRAMS
ADM_TAB_PRIVS
ADM_TAB_STATISTICS
ADM_TAB_STATS_HISTORY
ADM_TAB_SUBPARTITIONS
ADM_TABLES
ADM_TABLESPACES
ADM_TAB_COLUMNS
ADM_TAB_COMMENTS
ADM_TAB_PARTITIONS
ADM_TRIGGERS
ADM_TYPE_ATTRS
ADM_TYPES
ADM_USERS
ADM_VIEWS
DB_ARGUMENTS
DB_ALL_TABLES
DB_COL_COMMENTS
DB_COL_PRIVS
DB_COLL_TYPES
DB_CONSTRAINTS
DB_CONS_COLUMNS
DB_DEPENDENCIES
DB_ERRORS
DB_IND_COLUMNS
DB_IND_EXPRESSIONS
DB_IND_PARTITIONS
DB_IND_SUBPARTITIONS
DB_INDEXES
DB_OBJECTS
DB_PROCEDURES
DB_PART_COL_STATISTICS
DB_PART_INDEXES
DB_PART_KEY_COLUMNS
DB_PART_TABLES
DB_SCHEDULER_JOB_ARGS
DB_SCHEDULER_PROGRAM_ARGS
DB_SEQUENCES
DB_SOURCE
DB_SUBPART_COL_STATISTICS
DB_SUBPART_KEY_COLUMNS
DB_SYNONYMS
DB_TAB_COL_STATISTICS
DB_TAB_COLUMNS
DB_TAB_COMMENTS
DB_TAB_HISTOGRAMS
DB_TAB_PARTITIONS
DB_TAB_STATS_HISTORY
DB_TAB_SUBPARTITIONS
DB_TABLES
DB_TRIGGERS
DB_TYPES
DB_USERS
DB_VIEWS
DICT
DICTIONARY
DV_SESSIONS
DV_SESSION_LONGOPS
GS_ALL_CONTROL_GROUP_INFO
GS_ALL_PREPARED_STATEMENTS
GS_AUDITING
GS_AUDITING_ACCESS
GS_AUDITING_PRIVILEGE
GS_CLUSTER_RESOURCE_INFO
GS_COMM_LISTEN_ADDRESS_EXT_INFO
GS_COMM_PROXY_THREAD_STATUS
GS_DB_LINKS
GS_DB_PRIVILEGES
GS_FILE_STAT
GS_GET_CONTROL_GROUP_INFO
GS_GET_LISTEN_ADDRESS_EXT_INFO
GS_GLC_MEMORY_DETAIL
GS_GSC_MEMORY_DETAIL
GS_INSTANCE_TIME
GS_LABELS
GS_LSC_MEMORY_DETAIL
GS_MASKING
GS_MATVIEWS
GS_MY_PLAN_TRACE
GS_OS_RUN_INFO
GS_REDO_STAT
GS_SESSION_ALL_SETTINGS
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY
GS_SESSION_MEMORY_CONTEXT
GS_SESSION_MEMORY_DETAIL
GS_SESSION_MEMORY_STATISTICS
GS_SESSION_STAT
GS_SESSION_TIME
GS_SQL_COUNT
GS_STAT_SESSION_CU
GS_THREAD_MEMORY_CONTEXT
GS_TOTAL_MEMORY_DETAIL
GS_TOTAL_NODEGROUP_MEMORY_DETAIL
GS_WLM_CGROUP_INFO
GS_WLM_EC_OPERATOR_STATISTICS
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_PLAN_OPERATOR_HISTORY
GS_WLM_REBUILD_USER_RESOURCE_POOL
GS_WLM_RESOURCE_POOL
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_INFO
GS_WLM_SESSION_INFO_ALL
GS_WLM_SESSION_STATISTICS
GS_WLM_USER_INFO
GS_WLM_WORKLOAD_RECORDS
GV_INSTANCE
GV_SESSION
MPP_TABLES
MY_COL_COMMENTS
MY_COL_PRIVS
MY_COLL_TYPES
MY_CONSTRAINTS
MY_CONS_COLUMNS
MY_DEPENDENCIES
MY_ERRORS
MY_INDEXES
MY_IND_COLUMNS
MY_IND_EXPRESSIONS
MY_IND_PARTITIONS
MY_IND_SUBPARTITIONS
MY_JOBS
MY_OBJECTS
MY_PART_COL_STATISTICS
MY_PART_INDEXES
MY_PART_KEY_COLUMNS
MY_PART_TABLES
MY_PROCEDURES
MY_RECYCLEBIN
MY_ROLE_PRIVS
MY_SCHEDULER_JOB_ARGS
MY_SCHEDULER_PROGRAM_ARGS
MY_SEQUENCES
MY_SOURCE
MY_SUBPART_COL_STATISTICS
MY_SUBPART_KEY_COLUMNS
MY_SYNONYMS
MY_SYS_PRIVS
MY_TAB_COL_STATISTICS
MY_TAB_COLUMNS
MY_TAB_COMMENTS
MY_TAB_HISTOGRAMS
MY_TAB_PARTITIONS
MY_TAB_STATS_HISTORY
MY_TAB_STATISTICS
MY_TAB_SUBPARTITIONS
MY_TABLES
MY_TABLESPACES
MY_TRIGGERS
MY_TYPE_ATTRS
MY_TYPES
MY_VIEWS
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSIONS
PG_CURSORS
PG_COMM_DELAY
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_STATUS
PG_CONTROL_GROUP_CONFIG
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_GTT_RELSTATS
PG_GTT_STATS
PG_GTT_ATTACHED_PIDS
PG_INDEXES
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_PUBLICATION_TABLES
PG_REPLICATION_ORIGIN_STATUS
PG_REPLICATION_SLOTS
PG_RLSPOLICIES
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SESSION_IOSTAT
PG_SESSION_WLMSTAT
PG_SETTINGS
PG_SHADOW
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ACTIVITY_NG
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_REPLICATION
PG_STAT_SUBSCRIPTION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_TABLES
PG_TDE_INFO
PG_THREAD_WAIT_STATUS
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_USER_RESOURCE_INFO
PG_TOTAL_USER_RESOURCE_INFO_OID
PG_USER
PG_USER_MAPPINGS
PG_VIEWS
PG_VARIABLE_INFO
PG_WLM_STATISTICS
PGXC_PREPARED_XACTS
PGXC_THREAD_WAIT_STATUS
PLAN_TABLE
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SYS_DUMMY
V_INSTANCE
V_MYSTAT
V_SESSION
V$SYSSTAT
V$NLS_PARAMETERS
V$SESSION_WAIT
V$SYSTEM_EVENT
V$VERSION
V$GLOBAL_TRANSACTION
GS_STATIO_ALL_PARTITIONS
GS_STAT_XACT_ALL_PARTITIONS
GS_STAT_ALL_PARTITIONS
Discarded
System Catalogs
PG_EXTENSION_DATA_SOURCE
STREAMING_REAPER_STATUS
System Views
GET_GLOBAL_PREPARED_XACTS
Schemas
Information Schema
_PG_FOREIGN_DATA_WRAPPERS
_PG_FOREIGN_SERVERS
_PG_FOREIGN_TABLE_COLUMNS
_PG_FOREIGN_TABLES
_PG_USER_MAPPINGS
INFORMATION_SCHEMA_CATALOG_NAME
DBE_PERF Schema
OS
OS_RUNTIME
GLOBAL_OS_RUNTIME
OS_THREADS
GLOBAL_OS_THREADS
NODE_NAME
Instance
INSTANCE_TIME
GLOBAL_INSTANCE_TIME
Memory
GS_SHARED_MEMORY_DETAIL
GLOBAL_MEMORY_NODE_DETAIL
GLOBAL_SHARED_MEMORY_DETAIL
MEMORY_NODE_DETAIL
SHARED_MEMORY_DETAIL
File
FILE_IOSTAT
SUMMARY_FILE_IOSTAT
GLOBAL_FILE_IOSTAT
FILE_REDO_IOSTAT
SUMMARY_FILE_REDO_IOSTAT
GLOBAL_FILE_REDO_IOSTAT
LOCAL_REL_IOSTAT
GLOBAL_REL_IOSTAT
SUMMARY_REL_IOSTAT
Object
STAT_USER_TABLES
SUMMARY_STAT_USER_TABLES
GLOBAL_STAT_USER_TABLES
STAT_USER_INDEXES
SUMMARY_STAT_USER_INDEXES
GLOBAL_STAT_USER_INDEXES
STAT_SYS_TABLES
SUMMARY_STAT_SYS_TABLES
GLOBAL_STAT_SYS_TABLES
STAT_SYS_INDEXES
SUMMARY_STAT_SYS_INDEXES
GLOBAL_STAT_SYS_INDEXES
STAT_ALL_TABLES
SUMMARY_STAT_ALL_TABLES
GLOBAL_STAT_ALL_TABLES
STAT_ALL_INDEXES
SUMMARY_STAT_ALL_INDEXES
GLOBAL_STAT_ALL_INDEXES
STAT_DATABASE
SUMMARY_STAT_DATABASE
GLOBAL_STAT_DATABASE
STAT_DATABASE_CONFLICTS
SUMMARY_STAT_DATABASE_CONFLICTS
GLOBAL_STAT_DATABASE_CONFLICTS
STAT_XACT_ALL_TABLES
SUMMARY_STAT_XACT_ALL_TABLES
GLOBAL_STAT_XACT_ALL_TABLES
STAT_XACT_SYS_TABLES
SUMMARY_STAT_XACT_SYS_TABLES
GLOBAL_STAT_XACT_SYS_TABLES
STAT_XACT_USER_TABLES
SUMMARY_STAT_XACT_USER_TABLES
GLOBAL_STAT_XACT_USER_TABLES
STAT_XACT_USER_FUNCTIONS
SUMMARY_STAT_XACT_USER_FUNCTIONS
GLOBAL_STAT_XACT_USER_FUNCTIONS
STAT_BAD_BLOCK
SUMMARY_STAT_BAD_BLOCK
GLOBAL_STAT_BAD_BLOCK
STAT_USER_FUNCTIONS
SUMMARY_STAT_USER_FUNCTIONS
GLOBAL_STAT_USER_FUNCTIONS
Workload
WORKLOAD_SQL_COUNT
SUMMARY_WORKLOAD_SQL_COUNT
WORKLOAD_TRANSACTION
SUMMARY_WORKLOAD_TRANSACTION
GLOBAL_WORKLOAD_TRANSACTION
WORKLOAD_SQL_ELAPSE_TIME
SUMMARY_WORKLOAD_SQL_ELAPSE_TIME
USER_TRANSACTION
GLOBAL_USER_TRANSACTION
Session/Thread
SESSION_STAT
GLOBAL_SESSION_STAT
SESSION_TIME
GLOBAL_SESSION_TIME
SESSION_MEMORY
GLOBAL_SESSION_MEMORY
SESSION_MEMORY_DETAIL
GLOBAL_SESSION_MEMORY_DETAIL
SESSION_STAT_ACTIVITY
GLOBAL_SESSION_STAT_ACTIVITY
THREAD_WAIT_STATUS
GLOBAL_THREAD_WAIT_STATUS
LOCAL_THREADPOOL_STATUS
GLOBAL_THREADPOOL_STATUS
SESSION_CPU_RUNTIME
SESSION_MEMORY_RUNTIME
STATEMENT_IOSTAT_COMPLEX_RUNTIME
LOCAL_ACTIVE_SESSION
Transaction
TRANSACTIONS_PREPARED_XACTS
SUMMARY_TRANSACTIONS_PREPARED_XACTS
GLOBAL_TRANSACTIONS_PREPARED_XACTS
TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS
GLOBAL_TRANSACTIONS_RUNNING_XACTS
Query
STATEMENT
SUMMARY_STATEMENT
STATEMENT_COUNT
GLOBAL_STATEMENT_COUNT
SUMMARY_STATEMENT_COUNT
GLOBAL_STATEMENT_COMPLEX_HISTORY
GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
GLOBAL_STATEMENT_COMPLEX_RUNTIME
STATEMENT_RESPONSETIME_PERCENTILE
STATEMENT_COMPLEX_RUNTIME
STATEMENT_COMPLEX_HISTORY_TABLE
STATEMENT_COMPLEX_HISTORY
STATEMENT_WLMSTAT_COMPLEX_RUNTIME
STATEMENT_HISTORY
Cache/IO
STATIO_USER_TABLES
SUMMARY_STATIO_USER_TABLES
GLOBAL_STATIO_USER_TABLES
STATIO_USER_INDEXES
SUMMARY_STATIO_USER_INDEXES
GLOBAL_STATIO_USER_INDEXES
STATIO_USER_SEQUENCES
SUMMARY_STATIO_USER_SEQUENCES
GLOBAL_STATIO_USER_SEQUENCES
STATIO_SYS_TABLES
SUMMARY_STATIO_SYS_TABLES
GLOBAL_STATIO_SYS_TABLES
STATIO_SYS_INDEXES
SUMMARY_STATIO_SYS_INDEXES
GLOBAL_STATIO_SYS_INDEXES
STATIO_SYS_SEQUENCES
SUMMARY_STATIO_SYS_SEQUENCES
GLOBAL_STATIO_SYS_SEQUENCES
STATIO_ALL_TABLES
SUMMARY_STATIO_ALL_TABLES
GLOBAL_STATIO_ALL_TABLES
STATIO_ALL_INDEXES
SUMMARY_STATIO_ALL_INDEXES
GLOBAL_STATIO_ALL_INDEXES
STATIO_ALL_SEQUENCES
SUMMARY_STATIO_ALL_SEQUENCES
GLOBAL_STATIO_ALL_SEQUENCES
GLOBAL_STAT_DB_CU
GLOBAL_STAT_SESSION_CU
Utility
REPLICATION_STAT
GLOBAL_REPLICATION_STAT
REPLICATION_SLOTS
GLOBAL_REPLICATION_SLOTS
BGWRITER_STAT
GLOBAL_BGWRITER_STAT
GLOBAL_CKPT_STATUS
GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_PAGEWRITER_STATUS
GLOBAL_RECORD_RESET_TIME
GLOBAL_REDO_STATUS
GLOBAL_RECOVERY_STATUS
CLASS_VITAL_INFO
USER_LOGIN
SUMMARY_USER_LOGIN
GLOBAL_SINGLE_FLUSH_DW_STATUS
GLOBAL_CANDIDATE_STATUS
PARALLEL_DECODE_STATUS
GLOBAL_PARALLEL_DECODE_STATUS
PARALLEL_DECODE_THREAD_INFO
GLOBAL_PARALLEL_DECODE_THREAD_INFO
Lock
LOCKS
GLOBAL_LOCKS
Wait Events
WAIT_EVENTS
GLOBAL_WAIT_EVENTS
Configuration
CONFIG_SETTINGS
GLOBAL_CONFIG_SETTINGS
Operator
OPERATOR_HISTORY_TABLE
OPERATOR_HISTORY
OPERATOR_RUNTIME
GLOBAL_OPERATOR_HISTORY
GLOBAL_OPERATOR_HISTORY_TABLE
GLOBAL_OPERATOR_RUNTIME
Workload Manager
WLM_USER_RESOURCE_CONFIG
WLM_USER_RESOURCE_RUNTIME
Global Plancache
GLOBAL_PLANCACHE_STATUS
GLOBAL_PLANCACHE_CLEAN
RTO & RPO
global_rto_status
global_streaming_hadr_rto_and_rpo_stat
AI Watchdog
ai_watchdog_monitor_status
ai_watchdog_detection_warnings
ai_watchdog_parameters
Discarded
Query
GS_SLOW_QUERY_INFO
GS_SLOW_QUERY_HISTORY
GLOBAL_SLOW_QUERY_HISTORY
GLOBAL_SLOW_QUERY_INFO
WDR Snapshot Schema
Original Information of WDR Snapshots
SNAPSHOT.SNAPSHOT
SNAPSHOT.TABLES_SNAP_TIMESTAMP
SNAP_SEQ
WDR Snapshot Data Table
WDR Information
Database Stat
Load Profile
Instance Efficiency Percentages
Top 10 Events by Total Wait Time
Wait Classes by Total Wait Time
Host CPU
IO Profile
Memory Statistics
Time Model
SQL Statistics
Wait Events
Cache IO Stats
Utility status
Object stats
Configuration settings
SQL Detail
DBE_PLDEBUGGER Schema
DBE_PLDEBUGGER.turn_on
DBE_PLDEBUGGER.turn_off
DBE_PLDEBUGGER.local_debug_server_info
DBE_PLDEBUGGER.attach
DBE_PLDEBUGGER.info_locals
DBE_PLDEBUGGER.next
DBE_PLDEBUGGER.continue
DBE_PLDEBUGGER.abort
DBE_PLDEBUGGER.print_var
DBE_PLDEBUGGER.info_code
DBE_PLDEBUGGER.step
DBE_PLDEBUGGER.add_breakpoint
DBE_PLDEBUGGER.delete_breakpoint
DBE_PLDEBUGGER.info_breakpoints
DBE_PLDEBUGGER.backtrace
DBE_PLDEBUGGER.enable_breakpoint
DBE_PLDEBUGGER.disable_breakpoint
DBE_PLDEBUGGER.finish
DBE_PLDEBUGGER.set_var
DB4AI Schema
DB4AI.SNAPSHOT
DB4AI.CREATE_SNAPSHOT
DB4AI.CREATE_SNAPSHOT_INTERNAL
DB4AI.PREPARE_SNAPSHOT
DB4AI.PREPARE_SNAPSHOT_INTERNAL
DB4AI.ARCHIVE_SNAPSHOT
DB4AI.PUBLISH_SNAPSHOT
DB4AI.MANAGE_SNAPSHOT_INTERNAL
DB4AI.SAMPLE_SNAPSHOT
DB4AI.PURGE_SNAPSHOT
DB4AI.PURGE_SNAPSHOT_INTERNAL
DBE_PLDEVELOPER
DBE_PLDEVELOPER.gs_source
DBE_PLDEVELOPER.gs_errors
DBE_SQL_UTIL Schema
DBE_SQL_UTIL.create_hint_sql_patch
DBE_SQL_UTIL.create_abort_sql_patch
DBE_SQL_UTIL.drop_sql_patch
DBE_SQL_UTIL.enable_sql_patch
DBE_SQL_UTIL.disable_sql_patch
DBE_SQL_UTIL.show_sql_patch
DBE_SQL_UTIL.create_hint_sql_patch
DBE_SQL_UTIL.create_abort_sql_patch
Configuring Running Parameters
Viewing Parameters
Setting Parameters
GUC Parameters
GUC Parameter Usage
File Location
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Disk Space
Kernel Resource Usage
Cost-based Vacuum Delay
Background Writer
Asynchronous I/O
Write Ahead Log
Settings
Checkpoints
Log Replay
Archiving
HA Replication
Sending Server
Primary Server
Standby Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Destination
Logging Time
Logging Content
Using CSV Log Output
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Workload Management
Automatic Vacuuming
Default Settings of Client Connection
Statement Behavior
Locale and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Transaction
Replication Parameters of Two Database Instances
Developer Options
Auditing
Audit Switch
User and Permission Audit
Operation Audit
CM Parameters
Parameters Related to cm_agent
Parameters Related to cm_server
Upgrade Parameters
Miscellaneous Parameters
Wait Events
Query
System Performance Snapshot
Security Configuration
Global Temporary Table
HyperLogLog
User-defined Functions
Scheduled Task
Thread Pool
Backup and Restoration
Undo
DCF Parameters Settings
Flashback
Rollback Parameters
Reserved Parameters
AI Features
Global SysCache Parameters
Parameters Related to the Efficient Data Compression Algorithm
Restoring Data on the Standby Node
Delimiter
Global PL/SQL Cache Parameters
Distributed_2.x
Overview
Database Logical Architecture
Query Request Handling Process
Managing Transactions
Concepts
Working with Databases
Connecting to a Database
APIs
Before You Start
Creating and Managing Databases
Planning a Storage Model
Creating and Managing Tablespaces
Creating and Managing Tables
Creating a Table
Inserting Data to a Table
Updating Data in a Table
Viewing Data
Deleting Data from a Table
Querying a System Catalog
Other Operations
Creating and Managing Schemas
Creating and Managing Partitioned Tables
Creating and Managing Indexes
Creating and Managing Views
Creating and Managing Sequences
Creating and Managing Scheduled Jobs
gsql Client Reference
Overview
How to Use gsql
Obtaining Help Information
Command Reference
Meta-Command Reference
Troubleshooting
Development and Design Proposal
Overview
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Column Design
Constraint Design
View and Joined Table Design
Tool Interconnection
JDBC Configuration
SQL Compilation
Best Practices
Best Practices of Table Design
Selecting a Storage Model
Selecting a Distribution Mode
Selecting Distribution Keys
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Checking a Node Where a Table Resides
Best Practices of Data Import
Best Practices of SQL Queries
Best Practices for Data Skew Query
Detecting Storage Skew in Real Time During Data Import
Quickly Locating Tables That Cause Data Skew
Tutorial: Using GDS to Import Data from a Remote Server
Overview
Prerequisites
Step 1: Preparing Source Data
Step 2: Installing, Configuring, and Starting GDS on a Data Server
Step 3: Creating a Foreign Table in GaussDB
Step 4: Importing Data to GaussDB
Step 5: Analyzing and Handling Import Errors
Step 6: Improving Query Efficiency After Data Import
Step 7: Stopping GDS
Step 8: Cleaning Up Resources
Application Development Guide
Development Specifications
Obtaining the Driver Package
Development Based on JDBC
JDBC Package, Driver Class, and Environment Class
Development Process
Loading a Driver
Connecting to a Database
Connecting to the Database (Using SSL)
Connecting to a Database (Using UDS)
Running SQL Statements
Processing Data in a Result Set
Closing a Connection
Log Management
Example: Common Operations
Example: Retrying SQL Queries for Applications
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MySQL
Example: Logic Replication Code
Example: Parameters for Connecting to the Database in Different Scenarios
JDBC Interface Reference
Development Based on ODBC
ODBC Packages, Dependent Libraries, and Header Files
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
Development Process
Example: Common Functions and Batch Binding
Typical Application Scenarios and Configurations
ODBC Interface Reference
Development Based on libpq
Dependent Header Files of libpq
Development Process
Example
libpq Interface Reference
Link Parameters
Psycopg-based Development
Psycopg Package
Development Process
Loading a Driver
Connecting a Database
Executing SQL Statements
Processing the Result Set
Closing the Connection
Connecting the Database (Using SSL)
Example: Common Operations
Psycopg API Reference
Database Security Management
Checking the Number of Database Connections
Managing Users and Their Permissions
Default Permission Mechanism
Administrator
Separation of Duties
Users
Roles
Schemas
Setting User Permissions
Row-Level Access Control
Setting Security Policies
Setting Account Security Policies
Setting the Validity Period of an Account
Setting Password Security Policies
Configuring Database Audit
Overview
Querying Audit Results
Maintaining Audit Logs
Importing Data
Importing Data in Parallel Using Foreign Tables
Parallel Data Import
Tutorial and Best Practice
Preparing Source Data
Installing, Configuring, and Starting GDS
Creating a GDS Foreign Table
Importing Data
Handling Import Errors
Stopping GDS
Examples
Example 1: Importing Data in Normal Mode
Example 2: Importing Data in Shared Mode
Example 3: Importing Data in Private Mode
Running the INSERT Statement to Insert Data
Running the COPY FROM STDIN Statement to Import Data
Data Import Using COPY FROM STDIN
Introduction to the CopyManager Class
Example 1: Importing and Exporting Data Through Local Files
Example 2: Migrating Data from a MySQL Database
Using a gsql Meta-Command to Import Data
Updating Data in a Table
Updating a Table by Using DML Statements
Updating and Inserting Data by Using the MERGE INTO Statement
Deep Copy
Performing a Deep Copy by Using the CREATE TABLE Statement
Performing a Deep Copy by Using the CREATE TABLE LIKE Statement
Performing a Deep Copy by Creating a Temporary Table and Truncating the Original Table
Checking for Data Skew
Analyzing Tables
Doing VACUUM to a Table
Managing Concurrent Write Operations
Transaction Isolation
Write and Read/Write Operations
Potential Deadlocks During Concurrent Write
Concurrent Write Examples
Concurrent INSERT and DELETE in the Same Table
Concurrent INSERT in the Same table
Concurrent UPDATE in the Same Table
Concurrent Data Import and Queries
Exporting Data
Exporting Data in Parallel Using a Foreign Table
Exporting Data In Parallel
Planning Data Export
Installing, Configuring, and Starting GDS
Creating a GDS Foreign Table
Exporting Data
Stopping GDS
Examples
Performance Tuning
Overview
Determining the Scope of Performance Tuning
Querying SQL Statements That Affect Performance Most
Checking Blocked Statements
SQL Optimization
Query Execution Process
Introduction to the SQL Execution Plan
Overview
Description
Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Overview
Selecting a Storage Model
Selecting a Distribution Mode
Selecting Distribution Keys
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Typical SQL Optimization Methods
Optimizing SQL Self-Diagnosis
Optimizing Statement Pushdown
Optimizing Subqueries
Optimizing Statistics
Optimizing Operators
Optimizing Data Skew
Experience in Rewriting SQL Statements
Configuring Key Parameters for SQL Tuning
Hint-based Tuning
Plan Hint Optimization
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Operation Hints
Sublink Name Hints
Skew Hints
Parameterized Path Hint
Hint Errors, Conflicts, and Other Warnings
Plan Hint Cases
Optimizer GUC Parameter Hints
Hints for Selecting the Custom Plan or Generic Plan
Hints Specifying Not to Expand Subqueries
Hints Specifying Not to Use Global Plan Cache
Hint of Parameterized Paths at the Same Level
Checking the Implicit Conversion Performance
Using the Vectorized Executor for Tuning
Optimization Cases
Case: Selecting an Appropriate Distribution Key
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Pushing Down Sort Operations to DNs
Case: Setting cost_param and Optimizing Query Performance
Case: Adjusting Distribution Keys
Case: Adjusting Partial Clustering Keys
Case: Adjusting the Table Storage Model in a Medium Table
Case: Adjusting Partial Clustering Keys
Case: Modifying a Partitioned Table
Case: Adjusting the GUC Parameter best_agg_plan
Case: Rewriting SQL and Deleting Subqueries (1)
Case: Rewriting SQL and Deleting Subqueries (2)
Case: Rewriting SQL Statements to Eliminate Pruning Interference
Case: Rewriting SQL Statements and Deleting in-clause
Case: Setting Partial Cluster Keys
Case: Modifying the GUC Parameter rewrite_rule
Case: Using DN Gather to Reduce Stream Nodes in the Plan
Case: Adjusting I/O Parameters to Reduce the Log Bloat Rate
Configuring Running Parameters
Viewing Parameter Values
Resetting Parameters
SQL Reference
GaussDB SQL
Keywords
Data Type
Numeric Types
Monetary Types
Boolean Types
Character Types
Binary Types
Date/Time Types
Geometric Types
Network Address Types
Bit String Types
Text Search Types
UUID Type
JSON/JSONB Types
HLL
Range
Object Identifier Types
Pseudo-Types
Data Types Supported by Column-store Tables
Data Types Used by the Ledger Database
ACLItem
Constant and Macro
Functions and Operators
Logical Operators
Comparison Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Pattern Matching Operators
Arithmetic Functions and Operators
Date and Time Processing Functions and Operators
Type Conversion Functions
Geometric Functions and Operators
Network Address Functions and Operators
Text Search Functions and Operators
JSON/JSONB Functions and Operators
HLL Functions and Operators
SEQUENCE Functions
Array Functions and Operators
Range Functions and Operators
Aggregate Functions
Window Functions
Security Functions
Ledger Database Functions
Encrypted Equality Functions
Set Returning Functions
Conditional Expression Functions
System Information Functions
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signal Functions
Backup and Restoration Control Functions
Dual-Cluster DR Control Functions
Dual-Cluster DR Query Functions
Snapshot Synchronization Functions
Database Object Functions
Advisory Lock Functions
Logical Replication Functions
Segment-Page Storage Functions
Other Functions
Statistics Information Functions
Trigger Functions
Hash Function
Prompt Message Function
Fault Injection System Function
Redistribution Parameters
Distribution Column Recommendation Functions
Other System Functions
Internal Functions
AI Feature Functions
Dynamic Data Masking Functions
Hotkey Feature Functions
Global SysCache Functions
Data Damage Detection and Repair Functions
Obsolete Functions
Expressions
Simple Expressions
Condition Expressions
Subquery Expressions
Array Expressions
Row Expressions
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Full Text Search
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Tables and Indexes
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Manipulating Queries
Rewriting Queries
Gathering Document Statistics
Parser
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Configuration Examples
Testing and Debugging Text Search
Testing a Configuration
Testing an Age Parser
Testing a Dictionary
Limitations
System Operation
Controlling Transactions
DDL Syntax Overview
DML Syntax Overview
DCL Syntax Overview
SQL Syntax
ABORT
ALTER APP WORKLOAD GROUP MAPPING
ALTER AUDIT POLICY
ALTER COORDINATOR
ALTER DATABASE
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER FOREIGN TABLE (for Import and Export)
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER NODE
ALTER NODE GROUP
ALTER RESOURCE LABEL
ALTER RESOURCE POOL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ALTER WORKLOAD GROUP
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE APP WORKLOAD GROUP MAPPING
CREATE AUDIT POLICY
CREATE BARRIER
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE FOREIGN TABLE (for Import and Export)
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE NODE
CREATE NODE GROUP
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE RESOURCE POOL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE WORKLOAD GROUP
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP APP WORKLOAD GROUP MAPPING
DROP AUDIT POLICY
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATA SOURCE
DROP DIRECTORY
DROP FOREIGN TABLE
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP NODE
DROP NODE GROUP
DROP OWNED
DROP PROCEDURE
DROP RESOURCE LABEL
DROP RESOURCE POOL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
DROP WORKLOAD GROUP
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXECUTE DIRECT
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
INSERT
LOCK
MOVE
MERGE INTO
PREDICT BY
PREPARE
PREPARE TRANSACTION
REASSIGN OWNED
REINDEX
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
SHUTDOWN
START TRANSACTION
TRUNCATE
UPDATE
VACUUM
VALUES
Appendix
GIN Indexes
Introduction
Scalability
Implementation
GIN Tips and Tricks
Extended Functions
Stored Procedures
Overview
Data Types
Data Type Conversion
Arrays and Records
Arrays
Records
DECLARE Syntax
Basic Structure
Anonymous Blocks
Subprograms
Basic Statements
Variable Definition Statements
Assignment Statements
Call Statements
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-Query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Transaction Statements
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Advanced Packages
Basic Interfaces
PKG_SERVICE
PKG_UTIL
Secondary Encapsulation Interfaces (Recommended)
DBE_LOB
DBE_RANDOM
DBE_OUTPUT
DBE_RAW
DBE_TASK
DBE_UTILITY
DBE_SQL
DBE_FILE
DBE_SESSION
DBE_MATCH
DBE_SCHEDULER
DBE_APPLICATION_INFO
Retry Management
Debugging
Autonomous Transaction
Stored Procedure Supporting Autonomous Transaction
Anonymous Block Supporting Autonomous Transaction
Function Supporting Autonomous Transaction
Restrictions
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_AUDITING_POLICY
GS_AUDITING_POLICY_ACCESS
GS_AUDITING_POLICY_FILTERS
GS_AUDITING_POLICY_PRIVILEGES
GS_ASP
GS_CLIENT_GLOBAL_KEYS
GS_CLIENT_GLOBAL_KEYS_ARGS
GS_COLUMN_KEYS
GS_COLUMN_KEYS_ARGS
GS_DB_PRIVILEGE
GS_ENCRYPTED_COLUMNS
GS_ENCRYPTED_PROC
GS_GLOBAL_CHAIN
GS_GLOBAL_CONFIG
GS_JOB_ATTRIBUTE
GS_JOB_ARGUMENT
GS_MASKING_POLICY
GS_MASKING_POLICY_ACTIONS
GS_MASKING_POLICY_FILTERS
GS_MATVIEW
GS_MATVIEW_DEPENDENCY
GS_MODEL_WAREHOUSE
GS_OBSSCANINFO
GS_OPT_MODEL
GS_POLICY_LABEL
GS_RECYCLEBIN
GS_SQL_PATCH
GS_TXN_SNAPSHOT
GS_UID
GS_WLM_EC_OPERATOR_INFO
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_SESSION_QUERY_INFO_ALL
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_APP_WORKLOADGROUP_MAPPING
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_DIRECTORY
PG_ENUM
PG_EXTENSION
PG_EXTENSION_DATA_SOURCE
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_HASHBUCKET
PG_INDEX
PG_INHERITS
PG_JOB
PG_JOB_PROC
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OBSSCANINFO
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_PUBLICATION
PG_PUBLICATION_REL
PG_RANGE
PG_REPLICATION_ORIGIN
PG_RESOURCE_POOL
PG_REWRITE
PG_RLSPOLICY
PG_SECLABEL
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_STATISTIC
PG_STATISTIC_EXT
PG_SUBSCRIPTION
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_GROUP
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PGXC_REDISTB
PGXC_SLICE
PLAN_TABLE_DATA
STATEMENT_HISTORY
STREAMING_STREAM
STREAMING_CONT_QUERY
STREAMING_REAPER_STATUS
System Views
ADM_COL_COMMENTS
ADM_CONS_COLUMNS
ADM_CONSTRAINTS
ADM_DATA_FILES
ADM_HIST_SNAPSHOT
ADM_HIST_SQL_PLAN
ADM_HIST_SQLSTAT
ADM_INDEXES
ADM_IND_COLUMNS
ADM_IND_EXPRESSIONS
ADM_IND_PARTITIONS
ADM_OBJECTS
ADM_PART_INDEXES
ADM_PART_TABLES
ADM_PROCEDURES
ADM_SEQUENCES
ADM_SCHEDULER_JOBS
ADM_SOURCE
ADM_SYNONYMS
ADM_TABLES
ADM_TABLESPACES
ADM_TAB_COLUMNS
ADM_TAB_COMMENTS
ADM_TAB_PARTITIONS
ADM_TRIGGERS
ADM_TYPE_ATTRS
ADM_USERS
ADM_VIEWS
COMM_CLIENT_INFO
DB_ALL_TABLES
DB_CONSTRAINTS
DB_CONS_COLUMNS
DB_DEPENDENCIES
DB_IND_COLUMNS
DB_IND_EXPRESSIONS
DB_INDEXES
DB_OBJECTS
DB_PROCEDURES
DB_SEQUENCES
DB_SOURCE
DB_SYNONYMS
DB_TAB_COLUMNS
DB_TAB_COMMENTS
DB_COL_COMMENTS
DB_TABLES
DB_TRIGGERS
DB_USERS
DB_VIEWS
DV_SESSIONS
DV_SESSION_LONGOPS
GET_GLOBAL_PREPARED_XACTS
GLOBAL_BAD_BLOCK_INFO
GLOBAL_CLEAR_BAD_BLOCK_INFO
GLOBAL_COMM_CLIENT_INFO
GLOBAL_STAT_HOTKEYS_INFO
GLOBAL_WAL_SENDER_STATUS
GS_ALL_CONTROL_GROUP_INFO
GS_AUDITING
GS_AUDITING_ACCESS
GS_AUDITING_PRIVILEGE
GS_CLUSTER_RESOURCE_INFO
GS_DB_PRIVILEGES
GS_GET_CONTROL_GROUP_INFO
GS_GSC_MEMORY_DETAIL
GS_LABELS
GS_LSC_MEMORY_DETAIL
GS_MASKING
GS_MATVIEWS
GS_MATVIEWS
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY_STATISTICS
GS_SQL_COUNT
GS_STAT_DB_CU
GS_STAT_SESSION_CU
GS_TOTAL_NODEGROUP_MEMORY_DETAIL
GS_WLM_CGROUP_INFO
GS_WLM_EC_OPERATOR_STATISTICS
GS_WLM_EC_OPERATOR_HISTORY
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_REBUILD_USER_RESOURCE_POOL
GS_WLM_RESOURCE_POOL
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_INFO
GS_WLM_SESSION_INFO_ALL
GS_WLM_USER_INFO
GS_WLM_USER_SESSION_INFO
GS_WLM_SESSION_STATISTICS
GS_WLM_WORKLOAD_RECORDS
GV_SESSION
MPP_TABLES
MY_COL_COMMENTS
MY_CONS_COLUMNS
MY_CONSTRAINTS
MY_INDEXES
MY_IND_COLUMNS
MY_IND_EXPRESSIONS
MY_IND_PARTITIONS
MY_JOBS
MY_OBJECTS
MY_PART_INDEXES
MY_PART_TABLES
MY_PROCEDURES
MY_SEQUENCES
MY_SOURCE
MY_SYNONYMS
MY_TAB_COLUMNS
MY_TAB_COMMENTS
MY_TAB_PARTITIONS
MY_TABLES
MY_TRIGGERS
MY_VIEWS
PG_AVAILABLE_EXTENSIONS
PG_AVAILABLE_EXTENSION_VERSIONS
PG_COMM_DELAY
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_STATUS
PG_CONTROL_GROUP_CONFIG
PG_CURSORS
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_INDEXES
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_POOLER_STATUS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_PUBLICATION_TABLES
PG_REPLICATION_ORIGIN_STATUS
PG_REPLICATION_SLOTS
PG_RLSPOLICIES
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SESSION_IOSTAT
PG_SESSION_WLMSTAT
PG_SETTINGS
PG_SHADOW
PG_SHARED_MEMORY_DETAIL
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ACTIVITY_NG
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_REPLICATION
PG_STAT_SUBSCRIPTION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_THREAD_WAIT_STATUS
PG_TABLES
PG_TDE_INFO
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_USER_RESOURCE_INFO
PG_TOTAL_USER_RESOURCE_INFO_OID
PG_USER
PG_USER_MAPPINGS
PG_VARIABLE_INFO
PG_VIEWS
PG_WLM_STATISTICS
PGXC_COMM_DELAY
PGXC_COMM_RECV_STREAM
PGXC_COMM_SEND_STREAM
PGXC_COMM_STATUS
PGXC_GET_STAT_ALL_TABLES
PGXC_GET_TABLE_SKEWNESS
PGXC_NODE_ENV
PGXC_OS_THREADS
PGXC_PREPARED_XACTS
PGXC_RUNNING_XACTS
PGXC_STAT_ACTIVITY
PGXC_STAT_BAD_BLOCK
PGXC_SQL_COUNT
PGXC_THREAD_WAIT_STATUS
PGXC_TOTAL_MEMORY_DETAIL
PGXC_VARIABLE_INFO
PGXC_WLM_EC_OPERATOR_HISTORY
PGXC_WLM_EC_OPERATOR_INFO
PGXC_WLM_EC_OPERATOR_STATISTICS
PGXC_WLM_OPERATOR_HISTORY
PGXC_WLM_OPERATOR_INFO
PGXC_WLM_OPERATOR_STATISTICS
PGXC_WLM_REBUILD_USER_RESPOOL
PGXC_WLM_SESSION_HISTORY
PGXC_WLM_SESSION_INFO
PGXC_WLM_SESSION_STATISTICS
PGXC_WLM_WORKLOAD_RECORDS
PLAN_TABLE
PV_FILE_STAT
PV_INSTANCE_TIME
PV_OS_RUN_INFO
PV_REDO_STAT
PV_SESSION_MEMORY
PV_SESSION_MEMORY_CONTEXT
PV_SESSION_MEMORY_DETAIL
PV_SESSION_STAT
PV_SESSION_TIME
PV_THREAD_MEMORY_CONTEXT
PV_TOTAL_MEMORY_DETAIL
SYS_DUMMY
Schemas
Information Schema
_PG_FOREIGN_DATA_WRAPPERS
_PG_FOREIGN_SERVERS
_PG_FOREIGN_TABLE_COLUMNS
_PG_FOREIGN_TABLES
_PG_USER_MAPPINGS
INFORMATION_SCHEMA_CATALOG_NAME
DBE_PERF Schema
OS
OS_RUNTIME
GLOBAL_OS_RUNTIME
OS_THREADS
GLOBAL_OS_THREADS
Instance
INSTANCE_TIME
GLOBAL_INSTANCE_TIME
Memory
MEMORY_NODE_DETAIL
GLOBAL_MEMORY_NODE_DETAIL
MEMORY_NODE_NG_DETAIL
SHARED_MEMORY_DETAIL
GLOBAL_SHARED_MEMORY_DETAIL
TRACK_MEMORY_CONTEXT_DETAIL
File
FILE_IOSTAT
SUMMARY_FILE_IOSTAT
GLOBAL_FILE_IOSTAT
FILE_REDO_IOSTAT
SUMMARY_FILE_REDO_IOSTAT
GLOBAL_FILE_REDO_IOSTAT
LOCAL_REL_IOSTAT
GLOBAL_REL_IOSTAT
SUMMARY_REL_IOSTAT
Object
STAT_USER_TABLES
SUMMARY_STAT_USER_TABLES
GLOBAL_STAT_USER_TABLES
STAT_USER_INDEXES
SUMMARY_STAT_USER_INDEXES
GLOBAL_STAT_USER_INDEXES
STAT_SYS_TABLES
SUMMARY_STAT_SYS_TABLES
GLOBAL_STAT_SYS_TABLES
STAT_SYS_INDEXES
SUMMARY_STAT_SYS_INDEXES
GLOBAL_STAT_SYS_INDEXES
STAT_ALL_TABLES
SUMMARY_STAT_ALL_TABLES
GLOBAL_STAT_ALL_TABLES
STAT_ALL_INDEXES
SUMMARY_STAT_ALL_INDEXES
GLOBAL_STAT_ALL_INDEXES
STAT_DATABASE
SUMMARY_STAT_DATABASE
GLOBAL_STAT_DATABASE
STAT_DATABASE_CONFLICTS
SUMMARY_STAT_DATABASE_CONFLICTS
GLOBAL_STAT_DATABASE_CONFLICTS
STAT_XACT_ALL_TABLES
SUMMARY_STAT_XACT_ALL_TABLES
GLOBAL_STAT_XACT_ALL_TABLES
STAT_XACT_SYS_TABLES
SUMMARY_STAT_XACT_SYS_TABLES
GLOBAL_STAT_XACT_SYS_TABLES
STAT_XACT_USER_TABLES
SUMMARY_STAT_XACT_USER_TABLES
GLOBAL_STAT_XACT_USER_TABLES
STAT_XACT_USER_FUNCTIONS
SUMMARY_STAT_XACT_USER_FUNCTIONS
GLOBAL_STAT_XACT_USER_FUNCTIONS
STAT_BAD_BLOCK
SUMMARY_STAT_BAD_BLOCK
GLOBAL_STAT_BAD_BLOCK
STAT_USER_FUNCTIONS
SUMMARY_STAT_USER_FUNCTIONS
GLOBAL_STAT_USER_FUNCTIONS
Workload
WORKLOAD_SQL_COUNT
SUMMARY_WORKLOAD_SQL_COUNT
WORKLOAD_TRANSACTION
SUMMARY_WORKLOAD_TRANSACTION
GLOBAL_WORKLOAD_TRANSACTION
WORKLOAD_SQL_ELAPSE_TIME
SUMMARY_WORKLOAD_SQL_ELAPSE_TIME
USER_TRANSACTION
GLOBAL_USER_TRANSACTION
Session and Thread
SESSION_STAT
GLOBAL_SESSION_STAT
SESSION_TIME
GLOBAL_SESSION_TIME
SESSION_MEMORY
GLOBAL_SESSION_MEMORY
SESSION_MEMORY_DETAIL
GLOBAL_SESSION_MEMORY_DETAIL
SESSION_STAT_ACTIVITY
GLOBAL_SESSION_STAT_ACTIVITY
THREAD_WAIT_STATUS
GLOBAL_THREAD_WAIT_STATUS
LOCAL_THREADPOOL_STATUS
GLOBAL_THREADPOOL_STATUS
SESSION_CPU_RUNTIME
SESSION_MEMORY_RUNTIME
STATEMENT_IOSTAT_COMPLEX_RUNTIME
LOCAL_ACTIVE_SESSION
GLOBAL_ACTIVE_SESSION
Transaction
TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS
GLOBAL_TRANSACTIONS_RUNNING_XACTS
TRANSACTIONS_PREPARED_XACTS
SUMMARY_TRANSACTIONS_PREPARED_XACTS
GLOBAL_TRANSACTIONS_PREPARED_XACTS
Query
STATEMENT
SUMMARY_STATEMENT
STATEMENT_COUNT
GLOBAL_STATEMENT_COUNT
SUMMARY_STATEMENT_COUNT
GLOBAL_STATEMENT_COMPLEX_HISTORY
GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
GLOBAL_STATEMENT_COMPLEX_RUNTIME
STATEMENT_RESPONSETIME_PERCENTILE
STATEMENT_COMPLEX_RUNTIME
STATEMENT_COMPLEX_HISTORY_TABLE
STATEMENT_COMPLEX_HISTORY
STATEMENT_WLMSTAT_COMPLEX_RUNTIME
GS_SLOW_QUERY_INFO (Discarded)
GS_SLOW_QUERY_HISTORY (Discarded)
GLOBAL_SLOW_QUERY_HISTORY (Discarded)
GLOBAL_SLOW_QUERY_INFO (Discarded)
STATEMENT_HISTORY
Cache and I/O
STATIO_USER_TABLES
SUMMARY_STATIO_USER_TABLES
GLOBAL_STATIO_USER_TABLES
STATIO_USER_INDEXES
SUMMARY_STATIO_USER_INDEXES
GLOBAL_STATIO_USER_INDEXES
STATIO_USER_SEQUENCES
SUMMARY_STATIO_USER_SEQUENCES
GLOBAL_STATIO_USER_SEQUENCES
STATIO_SYS_TABLES
SUMMARY_STATIO_SYS_TABLES
GLOBAL_STATIO_SYS_TABLES
STATIO_SYS_INDEXES
SUMMARY_STATIO_SYS_INDEXES
GLOBAL_STATIO_SYS_INDEXES
STATIO_SYS_SEQUENCES
SUMMARY_STATIO_SYS_SEQUENCES
GLOBAL_STATIO_SYS_SEQUENCES
STATIO_ALL_TABLES
SUMMARY_STATIO_ALL_TABLES
GLOBAL_STATIO_ALL_TABLES
STATIO_ALL_INDEXES
SUMMARY_STATIO_ALL_INDEXES
GLOBAL_STATIO_ALL_INDEXES
STATIO_ALL_SEQUENCES
SUMMARY_STATIO_ALL_SEQUENCES
GLOBAL_STATIO_ALL_SEQUENCES
GLOBAL_STAT_DB_CU
GLOBAL_STAT_SESSION_CU
Communication Library
COMM_DELAY
GLOBAL_COMM_DELAY
COMM_RECV_STREAM
GLOBAL_COMM_RECV_STREAM
COMM_SEND_STREAM
GLOBAL_COMM_SEND_STREAM
COMM_STATUS
GLOBAL_COMM_STATUS
Utility
REPLICATION_STAT
GLOBAL_REPLICATION_STAT
REPLICATION_SLOTS
GLOBAL_REPLICATION_SLOTS
BGWRITER_STAT
GLOBAL_BGWRITER_STAT
POOLER_STATUS
GLOBAL_COMM_CHECK_CONNECTION_STATUS
GLOBAL_CKPT_STATUS
GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_PAGEWRITER_STATUS
GLOBAL_POOLER_STATUS
GLOBAL_RECORD_RESET_TIME
GLOBAL_REDO_STATUS
GLOBAL_RECOVERY_STATUS
CLASS_VITAL_INFO
USER_LOGIN
SUMMARY_USER_LOGIN
GLOBAL_GET_BGWRITER_STATUS
GLOBAL_SINGLE_FLUSH_DW_STATUS
GLOBAL_CANDIDATE_STATUS
Lock
LOCKS
GLOBAL_LOCKS
Wait Event
WAIT_EVENTS
GLOBAL_WAIT_EVENTS
WAIT_EVENT_INFO
Configuration
CONFIG_SETTINGS
GLOBAL_CONFIG_SETTINGS
Operator
OPERATOR_EC_HISTORY
OPERATOR_EC_HISTORY_TABLE
OPERATOR_EC_RUNTIME
OPERATOR_HISTORY_TABLE
OPERATOR_HISTORY
OPERATOR_RUNTIME
GLOBAL_OPERATOR_EC_HISTORY
GLOBAL_OPERATOR_EC_HISTORY_TABLE
GLOBAL_OPERATOR_EC_RUNTIME
GLOBAL_OPERATOR_HISTORY
GLOBAL_OPERATOR_HISTORY_TABLE
GLOBAL_OPERATOR_RUNTIME
Workload Manager
WLM_CGROUP_CONFIG
WLM_CLUSTER_RESOURCE_RUNTIME
WLM_CONTROLGROUP_CONFIG
WLM_CONTROLGROUP_NG_CONFIG
WLM_RESOURCEPOOL_RUNTIME
WLM_USER_RESOURCE_CONFIG
WLM_USER_RESOURCE_RUNTIME
WLM_WORKLOAD_HISTORY_INFO
WLM_WORKLOAD_RUNTIME
GLOBAL_WLM_WORKLOAD_RUNTIME
LOCAL_IO_WAIT_INFO
GLOBAL_IO_WAIT_INFO
Global Plan Cache
LOCAL_PLANCACHE_STATUS
GLOBAL_PLANCACHE_STATUS
LOCAL_PREPARE_STATEMENT_STATUS (Discarded)
GLOBAL_PREPARE_STATEMENT_STATUS (Discarded)
RTO & RPO
global_rto_status
global_streaming_hadr_rto_and_rpo_stat
WDR Snapshot Schema
Original Information of WDR Snapshots
SNAPSHOT.SNAPSHOT
SNAPSHOT.TABLES_SNAP_TIMESTAMP
SNAP_SEQ
WDR Snapshot Data Table
Performance Report Generated Based on WDR Snapshots
WDRs
Database Stat
Load Profile
Instance Efficiency Percentages
Top 10 Events by Total Wait Time
Wait Classes by Total Wait Time
Host CPU
IO Profile
Memory Statistics
Time Model
SQL Statistics
Wait Events
Cache IO Stats
Utility status
Object stats
Configuration settings
SQL Detail
GTM Mode
Materialized View
Full Materialized View
Overview
Usage
Support and Constraints
Incremental Materialized View
Overview
Usage
Support and Constraints
GUC Parameters
GUC Parameter Usage
File Location
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Disk Space
Kernel Resource Usage
Cost-based Vacuum Delay
Background Writer
Asynchronous I/O Operations
Parallel Data Import
Write Ahead Log
Settings
Checkpoints
Log Replay
Archiving
HA Replication
Sending Server
Primary Server
Standby Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Destination
Logging Time
Logging Content
Using CSV Log Output
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Hotspot Key Statistics
Workload Management
Automatic Vacuuming
Default Settings of Client Connection
Statement Behavior
Locale and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Cluster Transaction Parameters
Dual-Cluster Replication Parameters
Developer Options
Auditing
Audit Switch
User and Permission Audit
Operation Auditing
Transaction Monitoring
CM Parameters
CM Agent Parameters
CM Server Parameters
GTM Parameters
Upgrade Parameters
Miscellaneous Parameters
Wait Event
Query
System Performance Snapshot
Security Configuration
HyperLogLog
User-defined Functions
Collaborative Analysis
Acceleration Cluster
Scheduled Task
Thread Pool
Full Text Search
Backup and Restoration
AI Features
Global SysCache Parameters
Reserved Parameters
Error Log Reference
Kernel Error Information
CM Error Information
API Reference
JDBC Interface Reference
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
PGReplicationConnection
PGReplicationStream
ChainedStreamBuilder
ChainedCommonStreamBuilder
ODBC Interface Reference
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
libpq Interface Reference
Database Connection Control Functions
PQconnectdbParams
PQconnectdb
PQbackendPID
PQsetdbLogin
PQfinish
PQreset
PQstatus
Database Statement Execution Functions
PQexec
PQprepare
PQresultStatus
PQclear
Functions for Asynchronous Command Processing
PQsendQuery
PQsendQueryParams
PQsendPrepare
PQsendQueryPrepared
PQflush
Functions for Canceling Queries in Progress
PQgetCancel
PQfreeCancel
PQcancel
Psycopg API Reference
psycopg2.connect()
connection.cursor()
cursor.execute(query,vars_list)
curosr.executemany(query,vars_list)
connection.commit()
connection.rollback()
cursor.fetchone()
cursor.fetchall()
cursor.close()
connection.close()
Centralized_2.x
Overview
Database Logical Architecture
Query Request Handling Process
Managing Transactions
Concepts
Working with Databases
Connecting to a Database
APIs
Before You Start
Creating and Managing Databases
Planning a Storage Model
Creating and Managing Tablespaces
Creating and Managing Tables
Creating Tables
Inserting Data to Tables
Updating Data in a Table
Viewing Data
Deleting Data from a Table
Querying a System Catalog
Other Operations
Creating and Managing Schemas
Creating and Managing Partitioned Tables
Creating and Managing Indexes
Creating and Managing Views
Creating and Managing Sequences
gsql
gsql Overview
Usage Guidelines
Help Information
Command Reference
Meta-Command Reference
Troubleshooting
Development and Design Proposal
Development and Design Proposal
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Field Design
Constraint Design
View and Joined Table Design
Tool Interconnection
JDBC Configuration
SQL Compilation
Best Practices
Best Practices of Table Design
Selecting a Storage Model
Using Partial Cluster Keys (PCKs)
Using Partitioned Tables
Selecting a Data type
Best Practices of Data Import
Best Practices of SQL Queries
Application Development Guide
Development Specifications
Obtaining the Driver Package
Development Based on JDBC
JDBC Package, Driver Class, and Environment Class
Development Process
Loading the Driver
Connecting to a Database
Connecting to the Database (Using SSL)
Connecting to a Database (Using UDS)
Running SQL Statements
Processing Data in a Result Set
Closing a Connection
Log Management
Examples: Common Operations
Example: Retrying SQL Queries for Applications
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MY
Example: Logic Replication Code
Example: Parameters for Connecting to the Database in Different Scenarios
JDBC API Reference
Development Based on ODBC
ODBC Packages, Dependent Libraries, and Header Files
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
Development Process
Example: Common Functions and Batch Binding
Typical Application Scenarios and Configurations
ODBC Interface Reference
Development Based on libpq
Dependent Header Files of libpq
Development Process
Example
libpq API Reference
Link Parameters
Psycopg-based Development
Psycopg Package
Development Process
Loading a Driver
Connecting to the Database
Executing SQL Statements
Processing the Result Set
Closing the Connection
Connecting to the Database (Using SSL)
Example: Common Operations
Psycopg API Reference
Development Based on the Go Driver
Go Driver Package and Driver Class
Go Code Project Structure
Development Process
Connecting to the Database
Connecting to the Database (Using SSL)
Go APIs
Database Security Management
Checking the Number of Database Connections
Managing Users and Their Permissions
Default Permission Mechanism
Administrator
Separation of Duties
Users
Roles
Schemas
Setting User Permissions
Row-Level Security Policy
Setting Security Policies
Setting Account Security Policies
Setting the Validity Period of an Account
Setting Password Security Policies
Configuring Database Audit
Overview
Querying Audit Results
Maintaining Audit Logs
API Reference
JDBC
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
PGReplicationConnection
PGReplicationStream
ChainedStreamBuilder
ChainedCommonStreamBuilder
ODBC
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
Examples
libpq
Database Connection Control Functions
PQconnectdbParams
PQconnectdb
PQconninfoParse
PQconnectStart
PQerrorMessage
PQsetdbLogin
PQfinish
PQreset
PQstatus
Database Statement Execution Functions
PQclear
PQexec
PQexecParams
PQexecParamsBatch
PQexecPrepared
PQexecPreparedBatch
PQfname
PQgetvalue
PQnfields
PQntuples
PQprepare
PQresultStatus
Functions for Asynchronous Command Processing
PQsendQuery
PQsendQueryParams
PQsendPrepare
PQsendQueryPrepared
PQflush
Functions for Canceling Queries in Progress
PQgetCancel
PQfreeCancel
PQcancel
Psycopg
psycopg2.connect()
connection.cursor()
cursor.execute(query,vars_list)
curosr.executemany(query,vars_list)
connection.commit()
connection.rollback()
cursor.fetchone()
cursor.fetchall()
cursor.close()
connection.close()
Go
sql.Open
type DB
type Stmt
type Tx
type Rows
type Row
type ColumnType
type Result
Importing Data
Running the INSERT Statement to Insert Data
Running the COPY FROM STDIN Statement to Import Data
Data Import Using COPY FROM STDIN
Introduction to the CopyManager Class
Handling Import Errors
Example 1: Importing and Exporting Data Through Local Files
Example 2: Migrating Data from MY
Using a gsql Meta-Command to Import Data
Updating Data in a Table
Updating a Table by Using DML Statements
Updating and Inserting Data by Using the MERGE INTO Statement
Deep Copy
Performing a Deep Copy by Using the CREATE TABLE Statement
Performing a Deep Copy by Using the CREATE TABLE LIKE Statement
Performing a Deep Copy by Creating a Temporary Table and Truncating the Original Table
Analyzing Tables
Doing VACUUM to a Table
Managing Concurrent Write Operations
Transaction Isolation
Write and Read/Write Operations
Potential Deadlocks During Concurrent Write
Concurrent Write Examples
Concurrent INSERT and DELETE in the Same Table
Concurrent INSERT in the Same table
Concurrent UPDATE in the Same Table
Concurrent Data Import and Queries
Performance Tuning
Performance Tuning Process
Determining the Scope of Performance Tuning
Querying SQL Statements That Affect Performance Most
Checking Blocked Statements
SQL Optimization
Query Execution Process
Introduction to the SQL Execution Plan
Overview
Description
Tuning Process
Updating Statistics
Reviewing and Modifying a Table Definition
Overview
Selecting a Storage Model
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Typical SQL Optimization Methods
Optimizing SQL Self-Diagnosis
Optimizing Subqueries
Optimizing Statistics
Optimizing Operators
Experience in Rewriting SQL Statements
Resetting Key Parameters During SQL Tuning
Hint-based Tuning
Plan Hint Optimization
Join Order Hints
Join Operation Hints
Rows Hints
Scan Operation Hints
Sublink Name Hints
Hint Errors, Conflicts, and Other Warnings
Optimizer GUC Parameter Hints
Hint for Selecting the Custom Plan or Generic Plan
Hint Specifying Not to Expand Subqueries
Hint Specifying Not to Use Global Plan Cache
Hint of Parameterized Paths at the Same Level
Hint for Materializing a Sub-plan Result
Using the Vectorized Executor for Tuning
Optimization Cases
Case: Modifying the GUC Parameter rewrite_rule
Case: Adjusting I/O Parameters to Reduce the Log Bloat Rate
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Modifying a Partitioned Table
Case: Rewriting SQL and Deleting Subqueries (1)
Case: Rewriting SQL and Deleting Subqueries (2)
Case: Rewriting SQL Statements and Deleting in-clause
Configuring Running Parameters
Viewing Parameter Values
Resetting Parameters
SQL Reference
SQL
Keywords
Data Types
Numeric Types
Monetary Types
Boolean Types
Character Types
Binary Types
Date/Time Types
Geometric
Network Address Types
Bit String Types
Text Search Types
UUID
JSON/JSONB Types
HLL
Range
OID Types
Pseudo-Types
Data Types Supported by Column-store Tables
Data Type Used by the Ledger Database
ACLItem
Constant and Macro
Functions and Operators
Logical Operators
Comparison Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Mode Matching Operators
Mathematical Functions and Operators
Date and Time Processing Functions and Operators
Type Conversion Functions
Geometric Functions and Operators
Network Address Functions and Operators
Text Search Functions and Operators
JSON/JSONB Functions and Operators
HLL Functions and Operators
SEQUENCE Functions
Array Functions and Operators
Range Functions and Operators
Aggregate Functions
Window Functions
Security Functions
Ledger Database Functions
Encrypted Equality Functions
Set Returning Functions
Conditional Expression Functions
System Information Functions
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signal Functions
Backup and Restoration Control Functions
DR Control Functions for Dual Database Instances
DR Query Functions for Dual-Database Instances
Snapshot Synchronization Functions
Database Object Functions
Advisory Lock Functions
Logical Replication Functions
Segment-Page Storage Functions
Other Functions
Undo System Functions
Statistics Information Functions
Trigger Functions
Hash Function
Prompt Message Function
Global Temporary Table Functions
Fault Injection System Function
Dynamic Data Masking Functions
Hierarchical Recursion Query Functions
Other System Functions
Internal Functions
Global SysCache Feature Functions
Data Damage Detection and Repair Functions
Obsolete Functions
Expressions
Simple Expressions
Condition Expressions
Subquery Expressions
Array Expressions
Row Expressions
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Full Text Search
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Tables and Indexes
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Manipulating Queries
Rewriting Queries
Gathering Document Statistics
Parser
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Configuration Examples
Testing and Debugging Text Search
Testing a Configuration
Testing a Parser
Testing a Dictionary
Limitations
System Operation
Controlling Transactions
DDL Syntax Overview
DML Syntax Overview
DCL Syntax Overview
SQL Syntax
ABORT
ALTER AGGREGATE
ALTER AUDIT POLICY
ALTER DATABASE
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER EXTENSION
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER PUBLICATION
ALTER PACKAGE
ALTER PROCEDURE
ALTER RESOURCE LABEL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SUBSCRIPTION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLE SUBPARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE AGGREGATE
CREATE AUDIT POLICY
CREATE CAST
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE EXTENSION
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE OPERATOR
CREATE PACKAGE
CREATE PROCEDURE
CREATE PUBLICATION
CREATE RESOURCE LABEL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SUBSCRIPTION
CREATE SYNONYM
CREATE TABLE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TABLESPACE
CREATE TABLE SUBPARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP AGGREGATE
DROP AUDIT POLICY
DROP CAST
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATA SOURCE
DROP DIRECTORY
DROP EXTENSION
DROP FOREIGN TABLE
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP OPERATOR
DROP OWNED
DROP PACKAGE
DROP PROCEDURE
DROP RESOURCE LABEL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP RULE
DROP PUBLICATION
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SUBSCRIPTION
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP USER MAPPING
DROP VIEW
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
INSERT
LOCK
MERGE INTO
MOVE
PREDICT BY
PREPARE
PREPARE TRANSACTION
PURGE
REASSIGN OWNED
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
REINDEX
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
SHUTDOWN
SNAPSHOT
START TRANSACTION
TIMECAPSULE TABLE
TRUNCATE
UPDATE
VACUUM
VALUES
Appendix
GIN Indexes
Introduction
Scalability
Implementation
GIN Tips and Tricks
Extended Functions
Extended Syntax
Stored Procedure
Stored Procedure
Data Types
Data Type Conversion
Arrays, Sets, and Records
Arrays
Sets
record
DECLARE Syntax
Basic Structure
Anonymous Blocks
Subprogram
Basic Statements
Variable Definition Statements
Assignment Statements
Call Statements
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Transaction Management
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Retry Management
Debugging
Package
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_ASP
GS_AUDITING_POLICY
GS_AUDITING_POLICY_ACCESS
GS_AUDITING_POLICY_FILTERS
GS_AUDITING_POLICY_PRIVILEGES
GS_CLIENT_GLOBAL_KEYS
GS_CLIENT_GLOBAL_KEYS_ARGS
GS_COLUMN_KEYS
GS_COLUMN_KEYS_ARGS
GS_DB_PRIVILEGE
GS_ENCRYPTED_COLUMNS
GS_ENCRYPTED_PROC
GS_GLOBAL_CHAIN
GS_GLOBAL_CONFIG
GS_JOB_ARGUMENT
GS_JOB_ATTRIBUTE
GS_MASKING_POLICY
GS_MASKING_POLICY_ACTIONS
GS_MASKING_POLICY_FILTERS
GS_MATVIEW
GS_MATVIEW_DEPENDENCY
GS_MODEL_WAREHOUSE
GS_OPT_MODEL
GS_PACKAGE
GS_POLICY_LABEL
GS_RECYCLEBIN
GS_SQL_PATCH
GS_TXN_SNAPSHOT
GS_UID
GS_WLM_EC_OPERATOR_INFO
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_PLAN_ENCODING_TABLE
GS_WLM_PLAN_OPERATOR_INFO
GS_WLM_SESSION_QUERY_INFO_ALL
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_APP_WORKLOADGROUP_MAPPING
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_DIRECTORY
PG_ENUM
PG_EXTENSION
PG_EXTENSION_DATA_SOURCE
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_HASHBUCKET
PG_INDEX
PG_INHERITS
PG_JOB
PG_JOB_PROC
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OBSSCANINFO
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_PUBLICATION
PG_PUBLICATION_REL
PG_RANGE
PG_REPLICATION_ORIGIN
PG_RESOURCE_POOL
PG_REWRITE
PG_RLSPOLICY
PG_SECLABEL
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_STATISTIC
PG_STATISTIC_EXT
PG_SUBSCRIPTION
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_GROUP
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PGXC_SLICE
PLAN_TABLE_DATA
STATEMENT_HISTORY
STREAMING_STREAM
STREAMING_CONT_QUERY
STREAMING_REAPER_STATUS
System Views
ADM_COL_COMMENTS
ADM_CONSTRAINTS
ADM_CONS_COLUMNS
ADM_DATA_FILES
ADM_HIST_SNAPSHOT
ADM_HIST_SQL_PLAN
ADM_HIST_SQLSTAT
ADM_INDEXES
ADM_IND_COLUMNS
ADM_IND_EXPRESSIONS
ADM_IND_PARTITIONS
ADM_IND_SUBPARTITIONS
ADM_PART_INDEXES
ADM_OBJECTS
ADM_PART_TABLES
ADM_PROCEDURES
ADM_SCHEDULER_JOBS
ADM_SEQUENCES
ADM_SOURCE
ADM_SYNONYMS
ADM_TAB_SUBPARTITIONS
ADM_TABLES
ADM_TABLESPACES
ADM_TAB_COLUMNS
ADM_TAB_COMMENTS
ADM_TAB_PARTITIONS
ADM_TRIGGERS
ADM_TYPE_ATTRS
ADM_USERS
ADM_VIEWS
DB_ALL_TABLES
DB_COL_COMMENTS
DB_CONSTRAINTS
DB_CONS_COLUMNS
DB_DEPENDENCIES
DB_IND_COLUMNS
DB_IND_EXPRESSIONS
DB_IND_PARTITIONS
DB_IND_SUBPARTITIONS
DB_INDEXES
DB_OBJECTS
DB_PROCEDURES
DB_PART_INDEXES
DB_PART_TABLES
DB_SEQUENCES
DB_SOURCE
DB_SYNONYMS
DB_TAB_PARTITIONS
DB_TAB_SUBPARTITIONS
DB_TAB_COLUMNS
DB_TAB_COMMENTS
DB_TABLES
DB_TRIGGERS
DB_USERS
DB_VIEWS
DV_SESSIONS
DV_SESSION_LONGOPS
GET_GLOBAL_PREPARED_XACTS (Discarded)
GS_ALL_CONTROL_GROUP_INFO
GS_AUDITING
GS_AUDITING_ACCESS
GS_AUDITING_PRIVILEGE
GS_CLUSTER_RESOURCE_INFO
GS_COMM_PROXY_THREAD_STATUS
GS_DB_PRIVILEGES
GS_FILE_STAT
GS_GET_CONTROL_GROUP_INFO
GS_GSC_MEMORY_DETAIL
GS_INSTANCE_TIME
GS_LABELS
GS_LSC_MEMORY_DETAIL
GS_MASKING
GS_MATVIEWS
GS_OS_RUN_INFO
GS_REDO_STAT
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY
GS_SESSION_MEMORY_CONTEXT
GS_SESSION_MEMORY_DETAIL
GS_SESSION_MEMORY_STATISTICS
GS_SESSION_STAT
GS_SESSION_TIME
GS_SQL_COUNT
GS_STAT_SESSION_CU
GS_THREAD_MEMORY_CONTEXT
GS_TOTAL_MEMORY_DETAIL
GS_TOTAL_NODEGROUP_MEMORY_DETAIL
GS_WLM_CGROUP_INFO
GS_WLM_EC_OPERATOR_STATISTICS
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_PLAN_OPERATOR_HISTORY
GS_WLM_REBUILD_USER_RESOURCE_POOL
GS_WLM_RESOURCE_POOL
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_INFO
GS_WLM_SESSION_INFO_ALL
GS_WLM_SESSION_STATISTICS
GS_WLM_USER_INFO
GS_WLM_WORKLOAD_RECORDS
GV_SESSION
MPP_TABLES
MY_COL_COMMENTS
MY_CONSTRAINTS
MY_CONS_COLUMNS
MY_INDEXES
MY_IND_COLUMNS
MY_IND_EXPRESSIONS
MY_IND_PARTITIONS
MY_IND_SUBPARTITIONS
MY_JOBS
MY_OBJECTS
MY_PART_INDEXES
MY_PART_TABLES
MY_PROCEDURES
MY_SEQUENCES
MY_SOURCE
MY_SYNONYMS
MY_TAB_COLUMNS
MY_TAB_COMMENTS
MY_TAB_PARTITIONS
MY_TAB_SUBPARTITIONS
MY_TABLES
MY_TRIGGERS
MY_VIEWS
PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSIONS
PG_CURSORS
PG_COMM_DELAY
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_STATUS
PG_CONTROL_GROUP_CONFIG
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_GTT_RELSTATS
PG_GTT_STATS
PG_GTT_ATTACHED_PIDS
PG_INDEXES
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_PUBLICATION_TABLES
PG_REPLICATION_ORIGIN_STATUS
PG_REPLICATION_SLOTS
PG_RLSPOLICIES
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SESSION_IOSTAT
PG_SESSION_WLMSTAT
PG_SETTINGS
PG_SHADOW
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ACTIVITY_NG
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_REPLICATION
PG_STAT_SUBSCRIPTION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_TABLES
PG_TDE_INFO
PG_THREAD_WAIT_STATUS
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_USER_RESOURCE_INFO
PG_TOTAL_USER_RESOURCE_INFO_OID
PG_USER
PG_USER_MAPPINGS
PG_VIEWS
PG_VARIABLE_INFO
PG_WLM_STATISTICS
PGXC_PREPARED_XACTS
PGXC_THREAD_WAIT_STATUS
PLAN_TABLE
SYS_DUMMY
Schemas
DBE_PERF Schema
OS
OS_RUNTIME
GLOBAL_OS_RUNTIME
OS_THREADS
GLOBAL_OS_THREADS
NODE_NAME
Instance
INSTANCE_TIME
GLOBAL_INSTANCE_TIME
Memory
GS_SHARED_MEMORY_DETAIL
GLOBAL_MEMORY_NODE_DETAIL
GLOBAL_SHARED_MEMORY_DETAIL
MEMORY_NODE_DETAIL
SHARED_MEMORY_DETAIL
File
FILE_IOSTAT
SUMMARY_FILE_IOSTAT
GLOBAL_FILE_IOSTAT
FILE_REDO_IOSTAT
SUMMARY_FILE_REDO_IOSTAT
GLOBAL_FILE_REDO_IOSTAT
LOCAL_REL_IOSTAT
GLOBAL_REL_IOSTAT
SUMMARY_REL_IOSTAT
Object
STAT_USER_TABLES
SUMMARY_STAT_USER_TABLES
GLOBAL_STAT_USER_TABLES
STAT_USER_INDEXES
SUMMARY_STAT_USER_INDEXES
GLOBAL_STAT_USER_INDEXES
STAT_SYS_TABLES
SUMMARY_STAT_SYS_TABLES
GLOBAL_STAT_SYS_TABLES
STAT_SYS_INDEXES
SUMMARY_STAT_SYS_INDEXES
GLOBAL_STAT_SYS_INDEXES
STAT_ALL_TABLES
SUMMARY_STAT_ALL_TABLES
GLOBAL_STAT_ALL_TABLES
STAT_ALL_INDEXES
SUMMARY_STAT_ALL_INDEXES
GLOBAL_STAT_ALL_INDEXES
STAT_DATABASE
SUMMARY_STAT_DATABASE
GLOBAL_STAT_DATABASE
STAT_DATABASE_CONFLICTS
SUMMARY_STAT_DATABASE_CONFLICTS
GLOBAL_STAT_DATABASE_CONFLICTS
STAT_XACT_ALL_TABLES
SUMMARY_STAT_XACT_ALL_TABLES
GLOBAL_STAT_XACT_ALL_TABLES
STAT_XACT_SYS_TABLES
SUMMARY_STAT_XACT_SYS_TABLES
GLOBAL_STAT_XACT_SYS_TABLES
STAT_XACT_USER_TABLES
SUMMARY_STAT_XACT_USER_TABLES
GLOBAL_STAT_XACT_USER_TABLES
STAT_XACT_USER_FUNCTIONS
SUMMARY_STAT_XACT_USER_FUNCTIONS
GLOBAL_STAT_XACT_USER_FUNCTIONS
STAT_BAD_BLOCK
SUMMARY_STAT_BAD_BLOCK
GLOBAL_STAT_BAD_BLOCK
STAT_USER_FUNCTIONS
SUMMARY_STAT_USER_FUNCTIONS
GLOBAL_STAT_USER_FUNCTIONS
Workload
WORKLOAD_SQL_COUNT
SUMMARY_WORKLOAD_SQL_COUNT
WORKLOAD_TRANSACTION
SUMMARY_WORKLOAD_TRANSACTION
GLOBAL_WORKLOAD_TRANSACTION
WORKLOAD_SQL_ELAPSE_TIME
SUMMARY_WORKLOAD_SQL_ELAPSE_TIME
USER_TRANSACTION
GLOBAL_USER_TRANSACTION
Session/Thread
SESSION_STAT
GLOBAL_SESSION_STAT
SESSION_TIME
GLOBAL_SESSION_TIME
SESSION_MEMORY
GLOBAL_SESSION_MEMORY
SESSION_MEMORY_DETAIL
GLOBAL_SESSION_MEMORY_DETAIL
SESSION_STAT_ACTIVITY
GLOBAL_SESSION_STAT_ACTIVITY
THREAD_WAIT_STATUS
GLOBAL_THREAD_WAIT_STATUS
LOCAL_THREADPOOL_STATUS
GLOBAL_THREADPOOL_STATUS
SESSION_CPU_RUNTIME
SESSION_MEMORY_RUNTIME
STATEMENT_IOSTAT_COMPLEX_RUNTIME
LOCAL_ACTIVE_SESSION
Transaction
TRANSACTIONS_PREPARED_XACTS
SUMMARY_TRANSACTIONS_PREPARED_XACTS
GLOBAL_TRANSACTIONS_PREPARED_XACTS
TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS
GLOBAL_TRANSACTIONS_RUNNING_XACTS
Query
STATEMENT
SUMMARY_STATEMENT
STATEMENT_COUNT
GLOBAL_STATEMENT_COUNT
SUMMARY_STATEMENT_COUNT
GLOBAL_STATEMENT_COMPLEX_HISTORY
GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
GLOBAL_STATEMENT_COMPLEX_RUNTIME
STATEMENT_RESPONSETIME_PERCENTILE
STATEMENT_COMPLEX_RUNTIME
STATEMENT_COMPLEX_HISTORY_TABLE
STATEMENT_COMPLEX_HISTORY
STATEMENT_WLMSTAT_COMPLEX_RUNTIME
STATEMENT_HISTORY
GS_SLOW_QUERY_INFO (Discarded)
GS_SLOW_QUERY_HISTORY (Discarded)
GLOBAL_SLOW_QUERY_HISTORY (Discarded)
GLOBAL_SLOW_QUERY_INFO (Discarded)
Cache/IO
STATIO_USER_TABLES
SUMMARY_STATIO_USER_TABLES
GLOBAL_STATIO_USER_TABLES
STATIO_USER_INDEXES
SUMMARY_STATIO_USER_INDEXES
GLOBAL_STATIO_USER_INDEXES
STATIO_USER_SEQUENCES
SUMMARY_STATIO_USER_SEQUENCES
GLOBAL_STATIO_USER_SEQUENCES
STATIO_SYS_TABLES
SUMMARY_STATIO_SYS_TABLES
GLOBAL_STATIO_SYS_TABLES
STATIO_SYS_INDEXES
SUMMARY_STATIO_SYS_INDEXES
GLOBAL_STATIO_SYS_INDEXES
STATIO_SYS_SEQUENCES
SUMMARY_STATIO_SYS_SEQUENCES
GLOBAL_STATIO_SYS_SEQUENCES
STATIO_ALL_TABLES
SUMMARY_STATIO_ALL_TABLES
GLOBAL_STATIO_ALL_TABLES
STATIO_ALL_INDEXES
SUMMARY_STATIO_ALL_INDEXES
GLOBAL_STATIO_ALL_INDEXES
STATIO_ALL_SEQUENCES
SUMMARY_STATIO_ALL_SEQUENCES
GLOBAL_STATIO_ALL_SEQUENCES
GLOBAL_STAT_DB_CU
GLOBAL_STAT_SESSION_CU
Utility
REPLICATION_STAT
GLOBAL_REPLICATION_STAT
REPLICATION_SLOTS
GLOBAL_REPLICATION_SLOTS
BGWRITER_STAT
GLOBAL_BGWRITER_STAT
GLOBAL_CKPT_STATUS
GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_PAGEWRITER_STATUS
GLOBAL_RECORD_RESET_TIME
GLOBAL_REDO_STATUS
GLOBAL_RECOVERY_STATUS
CLASS_VITAL_INFO
USER_LOGIN
SUMMARY_USER_LOGIN
GLOBAL_SINGLE_FLUSH_DW_STATUS
GLOBAL_CANDIDATE_STATUS
Lock
LOCKS
GLOBAL_LOCKS
Wait Events
WAIT_EVENTS
GLOBAL_WAIT_EVENTS
Configuration
CONFIG_SETTINGS
GLOBAL_CONFIG_SETTINGS
Operator
OPERATOR_HISTORY_TABLE
OPERATOR_HISTORY
OPERATOR_RUNTIME
GLOBAL_OPERATOR_HISTORY
GLOBAL_OPERATOR_HISTORY_TABLE
GLOBAL_OPERATOR_RUNTIME
Workload Manager
WLM_USER_RESOURCE_CONFIG
WLM_USER_RESOURCE_RUNTIME
Global Plancache
GLOBAL_PLANCACHE_STATUS
GLOBAL_PLANCACHE_CLEAN
RTO & RPO
global_rto_status
global_streaming_hadr_rto_and_rpo_stat
WDR Snapshot Schema
Original Information of WDR Snapshots
SNAPSHOT.SNAPSHOT
SNAPSHOT.TABLES_SNAP_TIMESTAMP
SNAP_SEQ
WDR Snapshot Data Table
Performance Report Generated Based on WDR Snapshots
WDRs
Database Stat
Load Profile
Instance Efficiency Percentages
Top 10 Events by Total Wait Time
Wait Classes by Total Wait Time
Host CPU
IO Profile
Memory Statistics
Time Model
SQL Statistics
Wait Events
Cache IO Stats
Utility status
Object stats
Configuration settings
SQL Detail
DBE_PLDEBUGGER Schema
DBE_PLDEBUGGER.turn_on
DBE_PLDEBUGGER.turn_off
DBE_PLDEBUGGER.local_debug_server_info
DBE_PLDEBUGGER.attach
DBE_PLDEBUGGER.info_locals
DBE_PLDEBUGGER.next
DBE_PLDEBUGGER.continue
DBE_PLDEBUGGER.abort
DBE_PLDEBUGGER.print_var
DBE_PLDEBUGGER.info_code
DBE_PLDEBUGGER.step
DBE_PLDEBUGGER.add_breakpoint
DBE_PLDEBUGGER.delete_breakpoint
DBE_PLDEBUGGER.info_breakpoints
DBE_PLDEBUGGER.backtrace
DBE_PLDEBUGGER.enable_breakpoint
DBE_PLDEBUGGER.disable_breakpoint
DBE_PLDEBUGGER.finish
DBE_PLDEBUGGER.set_var
DBE_SQL_UTIL Schema
DBE_SQL_UTIL.create_hint_sql_patch
DBE_SQL_UTIL.create_abort_sql_patch
DBE_SQL_UTIL.drop_sql_patch
DBE_SQL_UTIL.enable_sql_patch
DBE_SQL_UTIL.disable_sql_patch
DBE_SQL_UTIL.show_sql_patch
Logical Replication
Logical Decoding
Overview
Logical Decoding by SQL Function Interfaces
Replicating Data Using the Logical Replication Tool
Publication-Subscription
Publications
Subscriptions
Conflicts
Restrictions
Architecture
Monitoring
Security
Configuration Settings
Quick Setup
Materialized View
Complete-refresh Materialized View
Overview
Usage
Support and Constraints
Fast-refresh Materialized View
Overview
Usage
Support and Constraints
GUC Parameters
GUC Parameter Usage
File Location
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Disk Space
Kernel Resource Usage
Cost-based Vacuum Delay
Background Writer
Asynchronous I/O Operations
Write Ahead Log
Settings
Checkpoints
Log Replay
Archiving
HA Replication
Sending Server
Primary Server
Standby Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Destination
Logging Time
Logging Content
Using CSV Log Output
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Workload Management
Automatic Vacuuming
Default Settings of Client Connection
Statement Behavior
Locale and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Transaction
Replication Parameters of Two Database Instances
Developer Options
Auditing
Audit Switch
User and Permission Audit
Operation Audit
CM Parameters
Parameters Related to cm_agent
Parameters Related to cm_server
Upgrade Parameters
Miscellaneous Parameters
Wait Events
Query
System Performance Snapshot
Security Configuration
Global Temporary Table
HyperLogLog
User-defined Functions
Scheduled Task
Thread Pool
Backup and Restoration
Undo
DCF Parameters Settings
Flashback
Rollback Parameters
Reserved Parameters
Global SysCache Parameters
Error Log Reference
Kernel Error Information
CM Error Information
1.x
Overview
Database Logical Architecture
Query Request Handling Process
Managing Transactions
Concepts
Working with Databases
Connecting to a Database
APIs
Before You Start
Creating and Managing Databases
Planning a Storage Model
Creating and Managing Tablespaces
Creating and Managing Tables
Creating a Table
Inserting Data to a Table
Updating Data in a Table
Viewing Data
Deleting Data from a Table
Querying a System Catalog
Other Operations
Creating and Managing Schemas
Creating and Managing Partitioned Tables
Creating and Managing Indexes
Creating and Managing Views
Creating and Managing Sequences
Creating and Managing Scheduled Jobs
gsql Client Reference
gsql Overview
Operation Guide
Help Information
Command Reference
Meta-Command Reference
Troubleshooting
Development and Design Proposal
Overview
Database Object Naming Conventions
Database Object Design
Database and Schema Design
Table Design
Column Design
Constraint Design
View and Joined Table Design
Tool Interconnection
JDBC Configuration
SQL Compilation
Best Practices
Best Practices of Table Design
Selecting a Storage Model
Selecting a Distribution Mode
Selecting Distribution Keys
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Checking a Node Where a Table Resides
Best Practices of Data Import
Best Practices of SQL Queries
Best Practices for Data Skew Query
Detecting Storage Skew in Real Time During Data Import
Quickly Locating Tables That Cause Data Skew
Tutorial: Using GDS to Import Data from a Remote Server
Overview
Prerequisites
Step 1: Preparing Source Data
Step 2: Installing, Configuring, and Starting GDS on a Data Server
Step 3: Creating a Foreign Table in GaussDB
Step 4: Importing Data to GaussDB
Step 5: Analyzing and Handling Import Errors
Step 6: Improving Query Efficiency After Data Import
Step 7: Stopping GDS
Step 8: Cleaning Up Resources
Application Development Guide
Development Based on JDBC
JDBC Package, Driver Class, and Environment Class
Development Process
Loading the Driver
Connecting to a Database
Running SQL Statements
Processing Data in a Result Set
Closing a Connection
Log Management
Example: Common Operations
Example: Retrying SQL Queries for Applications
Example: Importing and Exporting Data Through Local Files
Example: Migrating Data from MySQL to GaussDB
Example: Logic Replication Code
Example: Parameters for Connecting to the Database in Different Scenarios
JDBC Interface Reference
Development Based on ODBC
ODBC Packages, Dependent Libraries, and Header Files
Configuring a Data Source in the Linux OS
Configuring a Data Source in the Windows OS
Development Process
Example: Common Functions and Batch Binding
Typical Application Scenarios and Configurations
ODBC Interface Reference
Development Based on libpq
Dependent Header Files of libpq
Development Process
Example
libpq Interface Reference
Link Parameters
Psycopg-Based Development
Psycopg Package
Development Process
Loading a Driver
Connecting a Database
Executing SQL Statements
Processing the Result Set
Closing the Connection
Connecting the Database (Using SSL)
Example: Common Operations
Psycopg API Reference
Commissioning
Database Security Management
Checking the Number of Database Connections
Managing Users and Their Permissions
Default Permission Mechanism
Administrator
Separation of Duties
Users
Roles
Schemas
Setting User Permissions
Row-Level Access Control
Setting Security Policies
Setting Account Security Policies
Setting the Validity Period of an Account
Configuring Database Audit
Overview
Querying Audit Results
Maintaining Audit Logs
Configuring File Permission Security Policies
Unified Audit Policy
Importing Data
Importing Data in Parallel Using Foreign Tables
Parallel Data Import
Tutorial and Best Practice
Preparing Source Data
Installing, Configuring, and Starting GDS
Creating a GDS Foreign Table
Importing Data
Handling Import Errors
Stopping GDS
Examples
Example 1: Importing Data in Normal Mode
Example 2: Importing Data in Shared Mode
Example 3: Importing Data in Private Mode
Running the INSERT Statement to Insert Data
Running the COPY FROM STDIN Statement to Import Data
Data Import Using COPY FROM STDIN
Introduction to the CopyManager Class
Example 1: Importing and Exporting Data Through Local Files
Example 2: Migrating Data from a MySQL Database to GaussDB
Using a gsql Meta-Command to Import Data
Updating Data in a Table
Updating a Table by Using DML Statements
Updating and Inserting Data by Using the MERGE INTO Statement
Deep Copy
Performing a Deep Copy by Using the CREATE TABLE Statement
Performing a Deep Copy by Using the CREATE TABLE LIKE Statement
Performing a Deep Copy by Creating a Temporary Table and Truncating the Original Table
Checking for Data Skew
Analyzing Tables
Doing VACUUM to a Table
Managing Concurrent Write Operations
Transaction Isolation
Write and Read/Write Operations
Potential Deadlocks During Concurrent Write
Concurrent Write Examples
Concurrent INSERT and DELETE in the Same Table
Concurrent INSERT in the Same table
Concurrent UPDATE in the Same Table
Concurrent Data Import and Queries
Exporting Data
Exporting Data in Parallel Using a Foreign Table
Exporting Data In Parallel
Planning Data Export
Installing, Configuring, and Starting GDS
Creating a GDS Foreign Table
Exporting Data
Stopping GDS
Examples
Performance Tuning
Overview
Determining the Scope of Performance Tuning
Querying SQL Statements That Affect Performance Most
Checking Blocked Statements
SQL Optimization
Query Execution Process
Introduction to the SQL Execution Plan
Overview
Description
Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Overview
Selecting a Storage Model
Selecting a Distribution Mode
Selecting Distribution Keys
Using PCKs
Using Partitioned Tables
Selecting a Data Type
Typical SQL Optimization Methods
Optimizing SQL Self-Diagnosis
Optimizing Statement Pushdown
Optimizing Subqueries
Optimizing Statistics
Optimizing Operators
Optimizing Data Skew
Experience in Rewriting SQL Statements
Resetting Key Parameters During SQL Tuning
Hint-based Tuning
Plan Hint Optimization
Join Order Hints
Join Operation Hints
Rows Hints
Stream Operation Hints
Scan Operation Hints
Sublink Name Hints
Skew Hints
Parameterized Path Hint
Hint Errors, Conflicts, and Other Warnings
Plan Hint Cases
Checking the Implicit Conversion Performance
Optimization Cases
Case: Selecting an Appropriate Distribution Key
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Pushing Down Sort Operations to DNs
Case: Setting cost_param and Optimizing Query Performance
Case: Adjusting Distribution Keys
Case: Adjusting Partial Clustering Keys
Case: Adjusting the Table Storage Model in a Medium Table
Case: Adjusting Partial Clustering Keys
Case: Reconstructing Partitioned Tables
Case: Adjusting the GUC Parameter best_agg_plan
Case: Rewriting SQL and Deleting Subqueries (1)
Case: Rewriting SQL and Deleting Subqueries (2)
Case: Rewriting SQL Statements to Eliminate Pruning Interference
Case: Rewriting SQL Statements and Deleting in-clause
Case: Setting Partial Cluster Keys
Case: Modifying the GUC Parameter rewrite_rule
Using DN Gather to Reduce Stream Nodes in the Plan
Case: Adjusting I/O Parameters to Reduce the Log Bloat Rate
Configuring Running Parameters
Viewing Parameter Values
Resetting Parameters
SQL Reference
GaussDB SQL
Keywords
Data Type
Numeric Data Types
Monetary
Boolean
Character String
Binary
Date/Time
Geometric
Network Address
Bit String
Text Search Types
UUID Type
JSON Types
HLL Data Types
Range
Object Identifier Types
Pseudo-Types
Data Types Supported by Column-store Tables
Constant and Macro
Functions and Operators
Logical Operators
Comparison Operators
Character Processing Functions and Operators
Binary String Functions and Operators
Bit String Functions and Operators
Mode Matching Operators
Arithmetic Functions and Operators
Date and Time Processing Functions and Operators
Type Conversion Functions
Geometric Functions and Operators
Network Address Functions and Operators
Text Search Functions and Operators
JSON Functions
HLL Functions and Operators
SEQUENCE Functions
Array Functions and Operators
Range Functions and Operators
Aggregate Functions
Window Functions
Security Functions
Encrypted Equality Functions
Set Returning Functions
Conditional Expression Functions
System Information Functions
System Administration Functions
Configuration Settings Functions
Universal File Access Functions
Server Signal Functions
Backup and Restoration Control Functions
Dual-Cluster DR Control Function
Dual-Instance DR Query Function
Snapshot Synchronization Functions
Database Object Functions
Advisory Lock Functions
Logical Replication Functions
Other Functions
Statistics Information Functions
Trigger Functions
Hash Function
Prompt Message Function
Fault Injection System Function
Redistribution Parameters
Other System Functions
Internal Functions
Obsolete Functions
Expressions
Simple Expressions
Condition Expressions
Subquery Expressions
Array Expressions
Row Expressions
Type Conversion
Overview
Operators
Functions
Value Storage
UNION, CASE, and Related Constructs
Full Text Search
Introduction
Full-Text Retrieval
What Is a Document?
Basic Text Matching
Configurations
Tables and Indexes
Searching a Table
Creating an Index
Constraints on Index Use
Controlling Text Search
Parsing Documents
Parsing Queries
Ranking Search Results
Highlighting Results
Additional Features
Manipulating tsvector
Manipulating Queries
Rewriting Queries
Gathering Document Statistics
Parser
Dictionaries
Overview
Stop Words
Simple Dictionary
Synonym Dictionary
Thesaurus Dictionary
Ispell Dictionary
Snowball Dictionary
Configuration Examples
Testing and Debugging Text Search
Testing a Configuration
Testing a Parser
Testing a Dictionary
Limitations
System Operation
Controlling Transactions
DDL Syntax Overview
DML Syntax Overview
DCL Syntax Overview
SQL Syntax
ALTER COORDINATOR
ALTER DATABASE
ABORT
ALTER APP WORKLOAD GROUP MAPPING
ALTER AUDIT POLICY
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER FOREIGN TABLE (for Import and Export)
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER NODE
ALTER NODE GROUP
ALTER RESOURCE LABEL
ALTER RESOURCE POOL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ALTER WORKLOAD GROUP
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE APP WORKLOAD GROUP MAPPING
CREATE AUDIT POLICY
CREATE BARRIER
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE DATABASE
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE FOREIGN TABLE (for Import and Export)
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE NODE
CREATE NODE GROUP
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE RESOURCE POOL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE WORKLOAD GROUP
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP APP WORKLOAD GROUP MAPPING
DROP AUDIT POLICY
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATA SOURCE
DROP DIRECTORY
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP NODE
DROP NODE GROUP
DROP OWNED
DROP PROCEDURE
DROP RESOURCE LABEL
DROP RESOURCE POOL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
DROP WORKLOAD GROUP
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXECUTE DIRECT
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
INSERT
LOCK
MOVE
MERGE INTO
PREPARE
PREPARE TRANSACTION
REASSIGN OWNED
REINDEX
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH METADATA
REFRESH MATERIALIZED VIEW
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
START TRANSACTION
TRUNCATE
VACUUM
VALUES
UPDATE
Appendix
GIN Indexes
Introduction
Scalability
Implementation
GIN Tips and Tricks
Extended Functions
Stored Procedures
Overview
Data Types
Data Type Conversion
Arrays and Records
Arrays
Records
DECLARE Syntax
Basic Structure
Anonymous Blocks
Subprograms
Basic Statements
Variable Definition Statements
Assignment Statements
Call Statements
Dynamic Statements
Executing Dynamic Query Statements
Executing Dynamic Non-Query Statements
Dynamically Calling Stored Procedures
Dynamically Calling Anonymous Blocks
Control Statements
RETURN Statements
RETURN
RETURN NEXT and RETURN QUERY
Conditional Statements
Loop Statements
Branch Statements
NULL Statements
Error Trapping Statements
GOTO Statements
Transaction Statements
Other Statements
Lock Operations
Cursor Operations
Cursors
Overview
Explicit Cursor
Implicit Cursor
Cursor Loop
Advanced Packages
Basic Interfaces
PKG_SERVICE
PKG_UTIL
PG_CATALOG
Secondary Encapsulation Interfaces (Recommended)
DBE_LOB
DBE_RANDOM
DBE_OUTPUT
DBE_RAW
DBE_TASK
DBE_SQL
DBE_FILE
Retry Management
Debugging
System Catalogs and System Views
Overview of System Catalogs and System Views
System Catalogs
GS_AUDITING_POLICY
GS_AUDITING_POLICY_ACCESS
GS_AUDITING_POLICY_FILTERS
GS_AUDITING_POLICY_PRIVILEGES
GS_CLIENT_GLOBAL_KEYS
GS_CLIENT_GLOBAL_KEYS_ARGS
GS_COLUMN_KEYS
GS_COLUMN_KEYS_ARGS
GS_ENCRYPTED_COLUMNS
GS_GLOBAL_CONFIG
GS_MASKING_POLICY
GS_MASKING_POLICY_ACTIONS
GS_MASKING_POLICY_FILTERS
GS_MATVIEW
GS_MATVIEW_DEPENDENCY
GS_OBSSCANINFO
GS_POLICY_LABEL
GS_WLM_EC_OPERATOR_INFO
GS_WLM_INSTANCE_HISTORY
GS_WLM_OPERATOR_INFO
GS_WLM_SESSION_QUERY_INFO_ALL
GS_WLM_USER_RESOURCE_HISTORY
PG_AGGREGATE
PG_AM
PG_AMOP
PG_AMPROC
PG_APP_WORKLOADGROUP_MAPPING
GS_ASP
PG_ATTRDEF
PG_ATTRIBUTE
PG_AUTHID
PG_AUTH_HISTORY
PG_AUTH_MEMBERS
PG_CAST
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_CONVERSION
PG_DATABASE
PG_DB_ROLE_SETTING
PG_DEFAULT_ACL
PG_DEPEND
PG_DESCRIPTION
PG_DIRECTORY
PG_ENUM
PG_EXTENSION
PG_EXTENSION_DATA_SOURCE
PG_FOREIGN_DATA_WRAPPER
PG_FOREIGN_SERVER
PG_FOREIGN_TABLE
PG_HASHBUCKET
PG_INDEX
PG_INHERITS
PG_JOB
PG_JOB_PROC
PG_LANGUAGE
PG_LARGEOBJECT
PG_LARGEOBJECT_METADATA
PG_NAMESPACE
PG_OBJECT
PG_OBSSCANINFO
PG_OPCLASS
PG_OPERATOR
PG_OPFAMILY
PG_PARTITION
PG_PLTEMPLATE
PG_PROC
PG_RANGE
PG_RESOURCE_POOL
PG_REWRITE
PG_RLSPOLICY
PG_SECLABEL
PG_SHDEPEND
PG_SHDESCRIPTION
PG_SHSECLABEL
PG_STATISTIC
PG_STATISTIC_EXT
PG_SYNONYM
PG_TABLESPACE
PG_TRIGGER
PG_TS_CONFIG
PG_TS_CONFIG_MAP
PG_TS_DICT
PG_TS_PARSER
PG_TS_TEMPLATE
PG_TYPE
PG_USER_MAPPING
PG_USER_STATUS
PG_WORKLOAD_GROUP
PGXC_CLASS
PGXC_GROUP
PGXC_NODE
PLAN_TABLE_DATA
GS_MATVIEW
GS_MATVIEW_DEPENDENCY
PGXC_REDISTB
PGXC_SLICE
STATEMENT_HISTORY
STREAMING_STREAM
STREAMING_CONT_QUERY
STREAMING_REAPER_STATUS
QUERY_PATCHES
System Views
DB_ALL_TABLES
DB_CONSTRAINTS
DB_CONS_COLUMNS
DB_DEPENDENCIES
DB_IND_COLUMNS
DB_IND_EXPRESSIONS
DB_INDEXES
DB_OBJECTS
DB_PROCEDURES
DB_SEQUENCES
DB_SOURCE
DB_SYNONYMS
DB_TAB_COLUMNS
DB_TAB_COMMENTS
DB_COL_COMMENTS
DB_TABLES
DB_USERS
DB_VIEWS
COMM_CLIENT_INFO
ADM_COL_COMMENTS
ADM_CONSTRAINTS
ADM_CONS_COLUMNS
ADM_DATA_FILES
ADM_INDEXES
ADM_IND_COLUMNS
ADM_IND_EXPRESSIONS
ADM_IND_PARTITIONS
ADM_OBJECTS
ADM_PART_INDEXES
ADM_PART_TABLES
ADM_PROCEDURES
ADM_SEQUENCES
ADM_SOURCE
ADM_SYNONYMS
ADM_TABLES
ADM_TABLESPACES
ADM_TAB_COLUMNS
ADM_TAB_COMMENTS
ADM_TAB_PARTITIONS
ADM_TRIGGERS
ADM_USERS
ADM_VIEWS
GET_GLOBAL_PREPARED_XACTS
GLOBAL_WAL_SENDER_STATUS
GS_ALL_CONTROL_GROUP_INFO
GS_AUDITING
GS_AUDITING_ACCESS
GS_AUDITING_PRIVILEGE
GS_CLUSTER_RESOURCE_INFO
GS_GET_CONTROL_GROUP_INFO
GS_LABELS
GS_MASKING
GS_MATVIEWS
GS_SESSION_CPU_STATISTICS
GS_SESSION_MEMORY_STATISTICS
GS_SQL_COUNT
GS_WLM_CGROUP_INFO
GS_WLM_EC_OPERATOR_STATISTICS
GS_WLM_EC_OPERATOR_HISTORY
GS_WLM_OPERATOR_HISTORY
GS_WLM_OPERATOR_STATISTICS
GS_WLM_REBUILD_USER_RESOURCE_POOL
GS_WLM_RESOURCE_POOL
GS_WLM_SESSION_HISTORY
GS_WLM_SESSION_INFO
GS_WLM_SESSION_INFO_ALL
GS_WLM_USER_INFO
GS_WLM_USER_SESSION_INFO
GS_WLM_SESSION_STATISTICS
GS_WLM_WORKLOAD_RECORDS
GS_STAT_DB_CU
GS_STAT_SESSION_CU
MPP_TABLES
PG_AVAILABLE_EXTENSIONS
PG_AVAILABLE_EXTENSION_VERSIONS
PG_COMM_DELAY
PG_COMM_RECV_STREAM
PG_COMM_SEND_STREAM
PG_COMM_STATUS
PG_CONTROL_GROUP_CONFIG
PG_CURSORS
PG_EXT_STATS
PG_GET_INVALID_BACKENDS
PG_GET_SENDERS_CATCHUP_TIME
PG_GROUP
PG_INDEXES
PG_LOCKS
PG_NODE_ENV
PG_OS_THREADS
PG_POOLER_STATUS
PG_PREPARED_STATEMENTS
PG_PREPARED_XACTS
PG_REPLICATION_SLOTS
PG_RLSPOLICIES
PG_ROLES
PG_RULES
PG_RUNNING_XACTS
PG_SECLABELS
PG_SESSION_IOSTAT
PG_SESSION_WLMSTAT
PG_SETTINGS
PG_SHADOW
PG_SHARED_MEMORY_DETAIL
PG_STATS
PG_STAT_ACTIVITY
PG_STAT_ACTIVITY_NG
PG_STAT_ALL_INDEXES
PG_STAT_ALL_TABLES
PG_STAT_BAD_BLOCK
PG_STAT_BGWRITER
PG_STAT_GET_POOLER_STATUS
PG_STAT_DATABASE
PG_STAT_DATABASE_CONFLICTS
PG_STAT_REPLICATION
PG_STAT_SYS_INDEXES
PG_STAT_SYS_TABLES
PG_STAT_USER_FUNCTIONS
PG_STAT_USER_INDEXES
PG_STAT_USER_TABLES
PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_USER_FUNCTIONS
PG_STAT_XACT_USER_TABLES
PG_STATIO_ALL_INDEXES
PG_STATIO_ALL_SEQUENCES
PG_STATIO_ALL_TABLES
PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_SEQUENCES
PG_STATIO_SYS_TABLES
PG_STATIO_USER_INDEXES
PG_STATIO_USER_SEQUENCES
PG_STATIO_USER_TABLES
PG_THREAD_WAIT_STATUS
PG_TABLES
PG_TDE_INFO
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TOTAL_MEMORY_DETAIL
PG_TOTAL_USER_RESOURCE_INFO
PG_TOTAL_USER_RESOURCE_INFO_OID
PG_USER
PG_USER_MAPPINGS
PG_VARIABLE_INFO
PG_VIEWS
PG_WLM_STATISTICS
PGXC_COMM_DELAY
PGXC_COMM_RECV_STREAM
PGXC_COMM_SEND_STREAM
PGXC_COMM_STATUS
PGXC_GET_SENDERS_CATCHUP_TIME
PGXC_GET_STAT_ALL_TABLES
PGXC_GET_TABLE_SKEWNESS
PGXC_NODE_ENV
PGXC_OS_THREADS
PGXC_PREPARED_XACTS
PGXC_RUNNING_XACTS
PGXC_STAT_ACTIVITY
PGXC_STAT_BAD_BLOCK
PGXC_SQL_COUNT
PGXC_THREAD_WAIT_STATUS
PGXC_TOTAL_MEMORY_DETAIL
PGXC_VARIABLE_INFO
PGXC_WLM_EC_OPERATOR_HISTORY
PGXC_WLM_EC_OPERATOR_INFO
PGXC_WLM_EC_OPERATOR_STATISTICS
PGXC_WLM_OPERATOR_HISTORY
PGXC_WLM_OPERATOR_INFO
PGXC_WLM_OPERATOR_STATISTICS
PGXC_WLM_REBUILD_USER_RESPOOL
PGXC_WLM_SESSION_HISTORY
PGXC_WLM_SESSION_INFO
PGXC_WLM_SESSION_STATISTICS
PGXC_WLM_WORKLOAD_RECORDS
PLAN_TABLE
PV_FILE_STAT
PV_INSTANCE_TIME
PV_OS_RUN_INFO
PV_REDO_STAT
PV_SESSION_MEMORY
PV_SESSION_MEMORY_CONTEXT
PV_SESSION_MEMORY_DETAIL
PV_SESSION_STAT
PV_SESSION_TIME
PV_THREAD_MEMORY_CONTEXT
PV_TOTAL_MEMORY_DETAIL
MY_COL_COMMENTS
MY_CONSTRAINTS
MY_CONS_COLUMNS
MY_INDEXES
MY_IND_COLUMNS
MY_IND_EXPRESSIONS
MY_IND_PARTITIONS
MY_JOBS
MY_OBJECTS
MY_PART_INDEXES
MY_PART_TABLES
MY_PROCEDURES
MY_SEQUENCES
MY_SOURCE
MY_SYNONYMS
MY_TAB_COLUMNS
MY_TAB_COMMENTS
MY_TAB_PARTITIONS
MY_TABLES
MY_TRIGGERS
MY_VIEWS
DV_SESSIONS
DV_SESSION_LONGOPS
SYS_DUMMY
GS_MATVIEWS
GLOBAL_STAT_HOTKEYS_INFO
GLOBAL_COMM_CLIENT_INFO
DBE_PERF Schema
OS
OS_RUNTIME
GLOBAL_OS_RUNTIME
OS_THREADS
GLOBAL_OS_THREADS
Instance
INSTANCE_TIME
GLOBAL_INSTANCE_TIME
Memory
MEMORY_NODE_DETAIL
GLOBAL_MEMORY_NODE_DETAIL
MEMORY_NODE_NG_DETAIL
SHARED_MEMORY_DETAIL
GLOBAL_SHARED_MEMORY_DETAIL
TRACK_MEMORY_CONTEXT_DETAIL
File
FILE_IOSTAT
SUMMARY_FILE_IOSTAT
GLOBAL_FILE_IOSTAT
FILE_REDO_IOSTAT
SUMMARY_FILE_REDO_IOSTAT
GLOBAL_FILE_REDO_IOSTAT
LOCAL_REL_IOSTAT
GLOBAL_REL_IOSTAT
SUMMARY_REL_IOSTAT
Object
STAT_USER_TABLES
SUMMARY_STAT_USER_TABLES
GLOBAL_STAT_USER_TABLES
STAT_USER_INDEXES
SUMMARY_STAT_USER_INDEXES
GLOBAL_STAT_USER_INDEXES
STAT_SYS_TABLES
SUMMARY_STAT_SYS_TABLES
GLOBAL_STAT_SYS_TABLES
STAT_SYS_INDEXES
SUMMARY_STAT_SYS_INDEXES
GLOBAL_STAT_SYS_INDEXES
STAT_ALL_TABLES
SUMMARY_STAT_ALL_TABLES
GLOBAL_STAT_ALL_TABLES
STAT_ALL_INDEXES
SUMMARY_STAT_ALL_INDEXES
GLOBAL_STAT_ALL_INDEXES
STAT_DATABASE
SUMMARY_STAT_DATABASE
GLOBAL_STAT_DATABASE
STAT_DATABASE_CONFLICTS
SUMMARY_STAT_DATABASE_CONFLICTS
GLOBAL_STAT_DATABASE_CONFLICTS
STAT_XACT_ALL_TABLES
SUMMARY_STAT_XACT_ALL_TABLES
GLOBAL_STAT_XACT_ALL_TABLES
STAT_XACT_SYS_TABLES
SUMMARY_STAT_XACT_SYS_TABLES
GLOBAL_STAT_XACT_SYS_TABLES
STAT_XACT_USER_TABLES
SUMMARY_STAT_XACT_USER_TABLES
GLOBAL_STAT_XACT_USER_TABLES
STAT_XACT_USER_FUNCTIONS
SUMMARY_STAT_XACT_USER_FUNCTIONS
GLOBAL_STAT_XACT_USER_FUNCTIONS
STAT_BAD_BLOCK
SUMMARY_STAT_BAD_BLOCK
GLOBAL_STAT_BAD_BLOCK
STAT_USER_FUNCTIONS
SUMMARY_STAT_USER_FUNCTIONS
GLOBAL_STAT_USER_FUNCTIONS
Workload
WORKLOAD_SQL_COUNT
SUMMARY_WORKLOAD_SQL_COUNT
WORKLOAD_TRANSACTION
SUMMARY_WORKLOAD_TRANSACTION
GLOBAL_WORKLOAD_TRANSACTION
WORKLOAD_SQL_ELAPSE_TIME
SUMMARY_WORKLOAD_SQL_ELAPSE_TIME
USER_TRANSACTION
GLOBAL_USER_TRANSACTION
Session and Thread
SESSION_STAT
GLOBAL_SESSION_STAT
SESSION_TIME
GLOBAL_SESSION_TIME
SESSION_MEMORY
GLOBAL_SESSION_MEMORY
SESSION_MEMORY_DETAIL
GLOBAL_SESSION_MEMORY_DETAIL
SESSION_STAT_ACTIVITY
GLOBAL_SESSION_STAT_ACTIVITY
THREAD_WAIT_STATUS
GLOBAL_THREAD_WAIT_STATUS
LOCAL_THREADPOOL_STATUS
GLOBAL_THREADPOOL_STATUS
SESSION_CPU_RUNTIME
SESSION_MEMORY_RUNTIME
STATEMENT_IOSTAT_COMPLEX_RUNTIME
LOCAL_ACTIVE_SESSION
GLOBAL_ACTIVE_SESSION
Transaction
TRANSACTIONS_RUNNING_XACTS
SUMMARY_TRANSACTIONS_RUNNING_XACTS
GLOBAL_TRANSACTIONS_RUNNING_XACTS
TRANSACTIONS_PREPARED_XACTS
SUMMARY_TRANSACTIONS_PREPARED_XACTS
GLOBAL_TRANSACTIONS_PREPARED_XACTS
Query
STATEMENT
SUMMARY_STATEMENT
STATEMENT_COUNT
GLOBAL_STATEMENT_COUNT
SUMMARY_STATEMENT_COUNT
GLOBAL_STATEMENT_COMPLEX_HISTORY
GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
GLOBAL_STATEMENT_COMPLEX_RUNTIME
STATEMENT_RESPONSETIME_PERCENTILE
STATEMENT_USER_COMPLEX_HISTORY
STATEMENT_COMPLEX_RUNTIME
STATEMENT_COMPLEX_HISTORY_TABLE
STATEMENT_COMPLEX_HISTORY
STATEMENT_WLMSTAT_COMPLEX_RUNTIME
GS_SLOW_QUERY_INFO (Discarded)
GS_SLOW_QUERY_HISTORY (Discarded)
GLOBAL_SLOW_QUERY_HISTORY (Discarded)
GLOBAL_SLOW_QUERY_INFO (Discarded)
STATEMENT_HISTORY
Cache and I/O
STATIO_USER_TABLES
SUMMARY_STATIO_USER_TABLES
GLOBAL_STATIO_USER_TABLES
STATIO_USER_INDEXES
SUMMARY_STATIO_USER_INDEXES
GLOBAL_STATIO_USER_INDEXES
STATIO_USER_SEQUENCES
SUMMARY_STATIO_USER_SEQUENCES
GLOBAL_STATIO_USER_SEQUENCES
STATIO_SYS_TABLES
SUMMARY_STATIO_SYS_TABLES
GLOBAL_STATIO_SYS_TABLES
STATIO_SYS_INDEXES
SUMMARY_STATIO_SYS_INDEXES
GLOBAL_STATIO_SYS_INDEXES
STATIO_SYS_SEQUENCES
SUMMARY_STATIO_SYS_SEQUENCES
GLOBAL_STATIO_SYS_SEQUENCES
STATIO_ALL_TABLES
SUMMARY_STATIO_ALL_TABLES
GLOBAL_STATIO_ALL_TABLES
STATIO_ALL_INDEXES
SUMMARY_STATIO_ALL_INDEXES
GLOBAL_STATIO_ALL_INDEXES
STATIO_ALL_SEQUENCES
SUMMARY_STATIO_ALL_SEQUENCES
GLOBAL_STATIO_ALL_SEQUENCES
GLOBAL_STAT_DB_CU
GLOBAL_STAT_SESSION_CU
Communication Library
COMM_DELAY
GLOBAL_COMM_DELAY
COMM_RECV_STREAM
GLOBAL_COMM_RECV_STREAM
COMM_SEND_STREAM
GLOBAL_COMM_SEND_STREAM
COMM_STATUS
GLOBAL_COMM_STATUS
Utility
REPLICATION_STAT
GLOBAL_REPLICATION_STAT
REPLICATION_SLOTS
GLOBAL_REPLICATION_SLOTS
BGWRITER_STAT
GLOBAL_BGWRITER_STAT
POOLER_STATUS
GLOBAL_CKPT_STATUS
GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_PAGEWRITER_STATUS
GLOBAL_POOLER_STATUS
GLOBAL_RECORD_RESET_TIME
GLOBAL_REDO_STATUS
GLOBAL_RECOVERY_STATUS
CLASS_VITAL_INFO
USER_LOGIN
SUMMARY_USER_LOGIN
GLOBAL_GET_BGWRITER_STATUS
GLOBAL_SINGLE_FLUSH_DW_STATUS
Lock
LOCKS
GLOBAL_LOCKS
Wait Event
WAIT_EVENTS
GLOBAL_WAIT_EVENTS
WAIT_EVENT_INFO
Configuration
CONFIG_SETTINGS
GLOBAL_CONFIG_SETTINGS
Operator
OPERATOR_EC_HISTORY
OPERATOR_EC_HISTORY_TABLE
OPERATOR_EC_RUNTIME
OPERATOR_HISTORY_TABLE
OPERATOR_HISTORY
OPERATOR_RUNTIME
GLOBAL_OPERATOR_EC_HISTORY
GLOBAL_OPERATOR_EC_HISTORY_TABLE
GLOBAL_OPERATOR_EC_RUNTIME
GLOBAL_OPERATOR_HISTORY
GLOBAL_OPERATOR_HISTORY_TABLE
GLOBAL_OPERATOR_RUNTIME
Workload Manager
WLM_CGROUP_CONFIG
WLM_CLUSTER_RESOURCE_RUNTIME
WLM_CONTROLGROUP_CONFIG
WLM_CONTROLGROUP_NG_CONFIG
WLM_RESOURCEPOOL_RUNTIME
WLM_USER_RESOURCE_CONFIG
WLM_USER_RESOURCE_RUNTIME
WLM_WORKLOAD_HISTORY_INFO
WLM_WORKLOAD_RUNTIME
GLOBAL_WLM_WORKLOAD_RUNTIME
LOCAL_IO_WAIT_INFO
GLOBAL_IO_WAIT_INFO
Global Plan Cache
LOCAL_PLANCACHE_STATUS
GLOBAL_PLANCACHE_STATUS
LOCAL_PREPARE_STATEMENT_STATUS (Discarded)
GLOBAL_PREPARE_STATEMENT_STATUS (Discarded)
WDR Snapshot Schema
Original Information Table of WDR Snapshots
SNAPSHOT.SNAPSHOT
SNAPSHOT.TABLES_SNAP_TIMESTAMP
WDR Snapshot Data Table
Performance Report Generated Based on WDR Snapshots
GTM Mode
Materialized View
Full Materialized View
Overview
Usage
Support and Constraints
Incremental Materialized View
Overview
Usage
Support and Constraints
GUC Parameters
GUC Parameter Usage
File Location
Connection and Authentication
Connection Settings
Security and Authentication (postgresql.conf)
Communication Library Parameters
Resource Consumption
Memory
Disk Space
Kernel Resource Usage
Cost-based Vacuum Delay
Background Writer
Asynchronous I/O Operations
Parallel Data Import
Write Ahead Log
Settings
Checkpoints
Log Replay
Archiving
HA Replication
Sending Server
Primary Server
Standby Server
Query Planning
Optimizer Method Configuration
Optimizer Cost Constants
Genetic Query Optimizer
Other Optimizer Options
Error Reporting and Logging
Logging Destination
Logging Time
Logging Content
Using CSV Log Output
Alarm Detection
Statistics During the Database Running
Query and Index Statistics Collector
Performance Statistics
Hotspot Key Statistics
Workload Management
Automatic Vacuuming
Default Settings of Client Connection
Statement Behavior
Locale and Formatting
Other Default Parameters
Lock Management
Version and Platform Compatibility
Compatibility with Earlier Versions
Platform and Client Compatibility
Fault Tolerance
Connection Pool Parameters
Cluster Transaction Parameters
Dual-Cluster Replication Parameters
Developer Options
Auditing
Audit Switch
User and Permission Audit
Operation Auditing
Transaction Monitoring
CM Parameters
Parameters Related to cm_agent
Parameters Related to cm_server
GTM Parameters
Upgrade Parameters
Miscellaneous Parameters
Wait Events
Query
System Performance Snapshot
Security Policy Configuration
HyperLogLog
Collaborative Analysis
Acceleration Instance
Scheduled Task
Thread Pool
Full Text Search
Backup and Restoration
Reserved Parameters
API Reference
JDBC Interface Reference
java.sql.Connection
java.sql.CallableStatement
java.sql.DatabaseMetaData
java.sql.Driver
java.sql.PreparedStatement
java.sql.ResultSet
java.sql.ResultSetMetaData
java.sql.Statement
javax.sql.ConnectionPoolDataSource
javax.sql.DataSource
javax.sql.PooledConnection
javax.naming.Context
javax.naming.spi.InitialContextFactory
CopyManager
PGReplicationConnection
ODBC Interface Reference
SQLAllocEnv
SQLAllocConnect
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLConnect
SQLDisconnect
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeStmt
SQLFreeConnect
SQLFreeHandle
SQLFreeEnv
SQLPrepare
SQLGetData
SQLGetDiagRec
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
libpq Interface Reference
Database Connection Control Functions
PQconnectdbParams
PQconnectdb
PQsetdbLogin
PQfinish
PQreset
PQstatus
Database Statement Execution Functions
PQexec
PQprepare
PQresultStatus
PQclear
Functions for Asynchronous Command Processing
PQsendQuery
PQsendQueryParams
PQsendPrepare
PQsendQueryPrepared
PQflush
Functions for Canceling Queries in Progress
PQgetCancel
PQfreeCancel
PQcancel
Psycopg API Reference
psycopg2.connect()
connection.cursor()
cursor.execute(query,vars_list)
curosr.executemany(query,vars_list)
connection.commit()
connection.rollback()
cursor.fetchone()
cursor.fetchall()
cursor.close()
connection.close()
Tool Guide
Distributed
Client Tool
gsql
Overview
How to Use gsql
Obtaining Help Information
Command Reference
Meta-Command Reference
Troubleshooting
gs_ktool
Centralized
Client Tool
gsql
Overview
Usage Guidelines
Obtaining Help Information
Command Reference
Meta-Command Reference
Troubleshooting
gs_ktool
gs_loader
Feature Guide
Distributed
Materialized View
Full Materialized View
Overview
Usage
Support and Constraints
Incremental Materialized View
Overview
Usage
Support and Constraints
Setting Encrypted Equality Queries
Overview
Using gsql to Operate an Encrypted Database
Using JDBC to Operate an Encrypted Database
Enhancing Security in the Configuration Phase
Encrypted Functions and Stored Procedures
Sorting Encrypted Data on Clients (Lab Feature)
Partitioned Table
Large-Capacity Database
Background
Table Partitioning
Data Partition Query Optimization
Data Partition O&M Management
Introduction to Partitioned Tables
Basic Concepts
Partitioned Table
Partition
Partition Key
Partitioning Policy
Range Partitioning
Hash Partitioning
List Partitioning
Impact of Partitioned Tables on Import Performance
Basic Usage of Partitions
Creating Partitioned Tables
DML Statements for Querying Partitioned Tables
Partitioned Table Query Optimization
Partition Pruning
Static Partition Pruning
Dynamic Partition Pruning
Dynamic PBE Pruning
Dynamic Parameterized Path Pruning
Partitioned Indexes
Partitioned Table O&M Management
ADD PARTITION
Adding a Partition to a Range Partitioned Table
Adding a Partition to a List Partitioned Table
DROP PARTITION
EXCHANGE PARTITION
TRUNCATE PARTITION
SPLIT PARTITION
Splitting a Partition for a Range Partitioned Table
Splitting a Partition for a List Partitioned Table
MERGE PARTITION
MOVE PARTITION
RENAME PARTITION
Renaming a Partition in a Partitioned Table
Renaming an Index Partition for a Local Index
ALTER TABLE ENABLE/DISABLE ROW MOVEMENT
Invalidating/Rebuilding Indexes of a Partition
Invalidating/Rebuilding Indexes
Invalidating/Rebuilding Local Indexes of a Partition
System Views & DFX Related to Partitioned Tables
System Views Related to Partitioned Tables
Built-in Tool Functions Related to Partitioned Tables
Storage Engine
Storage Engine Architecture
Overview
Static Compilation Architecture
Database Service Layer
Setting Up a Storage Engine
Astore Storage Engine
Overview
Ustore Storage Engine
Overview
Ustore Features and Specifications
Feature Constraints
Storage Specifications
Example
Best Practices of Ustore
How Can I Configure init_td
How Can I Configure fillfactor
Collecting Statistics
Online Verification
How Can I Configure the Size of Rollback Segments
Storage Format
Relation
Page-based Row Consistency Read (PbRCR) Heap Multi-Version Management
PbPCR Heap Visibility Mechanism
Heap Space Management
Index
Row Consistency Read (RCR) UB-tree Multi-Version Management
RCR UB-tree Visibility Mechanism
Inserting, Deleting, Updating, and Scanning UB-tree
UB-tree Space Management
Undo
Rollback Segment Management
File Structure
Undo Space Management
Ustore Transaction Model
Transaction Commit
Transaction Rollback
Common View Tools
Common Problems and Troubleshooting Methods
Snapshot Too Old
Undo Space Recycling Blocked by Long Transactions
Slow Undo Space Recycling Caused by Many Rollback Transactions
Storage Test Error
An Error "UBTreeSearch::read_page has conflict with recovery, please try again later" Is Reported when a Service Uses a Standby Node to Read Data
Centralized
Materialized View
Complete-refresh Materialized View
Overview
Usage
Support and Constraints
Fast-refresh Materialized View
Overview
Usage
Support and Constraints
Setting Encrypted Equality Query
Overview
Using gsql to Operate an Encrypted Database
Using JDBC to Operate an Encrypted Database
Using Go Driver to Operate an Encrypted Database
Enhancing Security in the Configuration Phase
Encrypted Functions and Stored Procedures
Sorting Encrypted Data on Clients (Lab Feature)
Partitioned Table
Large-Capacity Database
Background
Table Partitioning
Data Partition Query Optimization
Data Partition O&M Management
Introduction to Partitioned Tables
Basic Concepts
Partitioned Table
Partition
Partition Key
Partitioning Policy
Range Partitioning
Interval Partitioning
Hash Partitioning
List Partitioning
Subpartitioning
Impact of Partitioned Tables on Import Performance
Basic Usage of Partitions
Creating Partitioned Tables
DML Statements for Querying Partitioned Tables
Partitioned Table Query Optimization
Partition Pruning
Static Partition Pruning
Dynamic Partition Pruning
Dynamic PBE Pruning
Dynamic Parameterized Path Pruning
Optimizing Partition Operator Execution
PI Elimination
Merge Append
Max/Min
Optimizing Performance of Importing Data to Partitions
Partitioned Indexes
Partitioned Table O&M Management
ADD PARTITION
Adding a Partition to a Range Partitioned Table
Adding a Partition to an Interval Partitioned Table
Adding a Partition to a List Partitioned Table
Adding a Partition to a Level-2 Partitioned Table
Adding a Level-2 Partition to a Level-2 Partitioned Table
DROP PARTITION
Deleting a Partition from a Partitioned Table
Deleting a Partition from a Level-2 Partitioned Table
Deleting a Level-2 Partition from a Level-2 Partitioned Table
EXCHANGE PARTITION
Exchanging Partitions for a Partitioned Table
Exchanging Level-2 Partitions for a Level-2 Partitioned Table
TRUNCATE PARTITION
Clearing Partitions from a Partitioned Table
Clearing Partitions from a Level-2 Partitioned Table
Clearing Level-2 Partitions from a Level-2 Partitioned Table
SPLIT PARTITION
Splitting a Partition for a Range Partitioned Table
Splitting a Partition for an Interval Partitioned Table
Splitting a Partition for a List Partitioned Table
Splitting a Level-2 Partition for a Level-2 *-Range Partitioned Table
Splitting a Level-2 Partition for a Level-2 *-List Partitioned Table
MERGE PARTITION
Merging Partitions for a Partitioned Table
Merging Level-2 Partitions for a Level-2 Partitioned Table
MOVE PARTITION
Moving Partitions for a Partitioned Table
Moving Level-2 Partitions for a Level-2 Partitioned Table
RENAME PARTITION
Renaming a Partition in a Partitioned Table
Renaming a Partition in a Level-2 Partitioned Table
Renaming a Level-2 Partition in a Level-2 Partitioned Table
Renaming an Index Partition for a Local Index
ALTER TABLE ENABLE/DISABLE ROW MOVEMENT
Invalidating/Rebuilding Indexes of a Partition
Invalidating/Rebuilding Indexes
Invalidating/Rebuilding Local Indexes of a Partition
Partition Concurrency Control
Common Lock Design
DQL/DML-DQL/DML Concurrency
DQL/DML-DDL Concurrency
DDL-DDL Concurrency
System Views & DFX Related to Partitioned Tables
System Views Related to Partitioned Tables
Built-in Tool Functions Related to Partitioned Tables
Storage Engine
Storage Engine Architecture
Overview
Static Compilation Architecture
Database Service Layer
Setting Up a Storage Engine
Astore Storage Engine
Overview
Ustore Storage Engine
Overview
Ustore Features and Specifications
Feature Constraints
Storage Specifications
Example
Best Practices of Ustore
How Can I Configure init_td
How Can I Configure fillfactor
Collecting Statistics
Online Verification
How Can I Configure the Size of Rollback Segments
Storage Format
Relation
Page-based Row Consistency Read (PbRCR) Heap Multi-Version Management
PbPCR Heap Visibility Mechanism
Heap Space Management
Index
Row Consistency Read (RCR) UB-tree Multi-Version Management
RCR UB-tree Visibility Mechanism
Inserting, Deleting, Updating, and Scanning UB-tree
UB-tree Space Management
Undo
Rollback Segment Management
File Structure
Undo Space Management
Ustore Transaction Model
Transaction Commit
Transaction Rollback
Common View Tools
Common Problems and Troubleshooting Methods
Snapshot Too Old
Undo Space Recycling Blocked by Long Transactions
Slow Undo Space Recycling Caused by Many Rollback Transactions
Storage Test Error
An Error "UBTreeSearch::read_page has conflict with recovery, please try again later" Is Reported when a Service Uses a Standby Node to Read Data
Best Practices
Overview
Best Practices of Migrating Data from Oracle to GaussDB
Purpose
Resource Planning
Operation Flowchart
Creating a VPC and Security Group
Creating a GaussDB Instance
Constructing Data Before Migration
Migrating the Database
Verifying Data After Migration
GaussDB Security Best Practices
Overview
Security
Maximum Number of Connections
Security Authentication
User Password Security
Permissions Management
Database Audit
WAL Archiving
Backup Management
Performance White Paper
Test Method
Test Data
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Response
APIs (Recommended)
Instance Management
Creating a DB Instance
Adding CNs, Adding Shards, or Scaling up Storage
Deleting a DB Instance
Querying DB Instances
Resetting a Database Password
Changing a DB Instance Name
Rebooting a DB Instance
Switching Roles of the Primary and Standby DNs in Shards
Querying the Components of a DB Instance
Changing vCPUs and Memory of a DB Instance
Checking Whether Host Load Is Unbalanced Due to a Primary/Standby Switchover
Querying Solution Template Settings
Querying EIPs Bound to a DB Instance
Validating Password Strength
Binding or Unbinding an EIP
Querying the SSL Certificate Download Address of a DB Instance
Querying the Instance Quotas of a Tenant
Parameter Configuration
Obtaining Parameter Templates
Obtaining the Parameters of a Specified DB Instance
Modifying Parameters of a Specified DB Instance
Creating a Parameter Template
Deleting a Parameter Template
Querying Details About a Parameter Template
Replicating a Parameter Template
Resetting a Parameter Template
Obtaining the Differences of Two Parameter Templates
Querying Instances That a Parameter Template Can Be Applied To
Checking Whether the Parameter Template Name Exists
Applying a Parameter Template
Querying Application Records of a Parameter Template
Querying Change History of a Parameter Template
Backup Management
Configuring an Automated Backup Policy
Querying an Automated Backup Policy
Querying Backups
Creating a Manual Backup
Deleting a Manual Backup
Restoring Data to a New DB Instance
Querying Instances that Can Be Used for Backups and Restorations
Querying Information About the Original Instance Based on a Specific Point of Time or a Backup File
Stopping a Backup
DB Engine Versions and Specifications
Querying DB Engine Versions
Querying Instance Specifications
Querying DB Engines
Querying Specifications that a DB Instance Can Be Changed To
Querying Database Disk Type
Database and Account Management
Creating a Database
Creating a Database Account
Creating a Database Schema
Configuring Permissions of Database Accounts
Resetting a Password for a Database Account
Querying Databases
Querying Database Users
Querying Database Schemas
Deleting a Database
Tag Management
Querying Tags of a Specific Instance
Querying Tags of a Project
Querying Predefined Tags
Adding Tags for a DB Instance
Storage Management
Querying the Storage Usage of a DB Instance
Quota Management
Modifying Enterprise Project Quotas
Querying Enterprise Project Quotas
Task Management
Obtaining Task Information
Querying Tasks
Deleting a Task Record
Recycle Bin
Modifying the Recycling Policy
Querying the Recycling Policy
Querying All DB Engine Instances In the Recycle Bin
Historical APIs
DB Instance Management
Creating a DB Instance
Creating a DB Instance
Querying DB Instances
Scaling up Storage Space of a DB Instance
Deleting a DB Instance
Querying DB Instances
Adding CNs
Adding Shards
Resetting a Database Password
Changing a DB Instance Name
Parameter Configuration
Modifying Parameters of a Specified DB Instance
Obtaining Parameter Templates
Obtaining the Parameters of a Specified DB Instance
Backup Management
Configuring an Automated Backup Policy
Querying Backups
DB Engine Versions and Specifications
Querying Instance Specifications
Permissions Policies and Supported Actions
Introduction
GaussDB Actions
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID and Name
Replication Mode Table
DB Instance Specifications
Change History
SDK Reference
SDK Overview
FAQs
About GaussDB
What Should I Pay Attention to When Using GaussDB?
What Is the Availability of GaussDB Instances?
Will My GaussDB Instances Be Affected by Other Users' Instances?
What Can I Do About Slow Responses of Websites When They Use GaussDB?
Can Multiple ECSs Connect to the Same GaussDB Instance?
Can I Encrypt the Disk After Purchasing a GaussDB Instance?
Will Backups Be Encrypted After Disk Encryption Is Enabled for My GaussDB Instance?
Will Different GaussDB Instances Share CPU and Memory Resources?
How Many Databases Can Run on a GaussDB Instance?
What Is the Relationship Between GaussDB and PostgreSQL?
Resource Freezing, Unfreezing, Release, Deletion, and Unsubscription
Resource and Disk Management
Can I Scale Down the Storage Space of My GaussDB Instances?
Which Items Occupy the Storage Space of My GaussDB Instances?
How Much Storage Space Is Required for DDL Operations?
Database Connections
Can I Connect to GaussDB over SSL?
What Should I Do If I Can't Connect to My GaussDB Instance?
Can an External Server Access GaussDB Instances?
How Can I Create and Connect to an ECS?
What Should I Do If an ECS Cannot Connect to a GaussDB Instance Through a Private Network?
What Should I Do If a Database Client Problem Causes a Connection Failure?
What Should I Do If a GaussDB Database Problem Causes a Connection Failure?
How Do My Applications Access a GaussDB Instance in a VPC?
Do Applications Need to Support Reconnecting to the GaussDB Instance Automatically?
Why Can't I Ping My EIP After It Is Bound to an Instance?
Can I Access a GaussDB Instance Over an Intranet Connection Across Regions?
Will My Access Be Restricted by Bandwidth When I Connect to My GaussDB Instance from an ECS over a Private Network?
Why Did the New Password Not Take Effect After I Reset the Administrator Password?
What Should I Do If the ECS and GaussDB Instance Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
Database Permissions
Can Multiple Users Log In to DAS at the Same Time? Will the Accounts Be Locked If I Enter Wrong Passwords Several Times in a Row?
Database Storage
What Types of Storage Does GaussDB Use?
What Should I Do If My Data Exceeds the Available Storage of a GaussDB Instance?
How Do I View the Storage Usage of My GaussDB Instance?
Database Usage
How Do I Use DAS to Query SQL Statements?
What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
What Should I Do If My root Account Was Deleted by Mistake?
What Do I Do If a DB Instance Is Locked?
What Do I Do If Replay Speed of Standby Nodes Cannot Catch Up with Write Speed of Primary Nodes?
Backup and Restoration
Does GaussDB Support Both Cold Backup and Hot Backup?
How Long Does GaussDB Store Backup Data?
How Do I Clear GaussDB Backup Space?
Can My Instance Still Be Used in the Backup Window?
How Is GaussDB Backup Data Billed?
How Do I View My Backup Storage Usage?
How Can I Back Up a GaussDB Database to an ECS?
Will Backups Be Retained After My GaussDB Instance Is Deleted?
How Can I Retrieve the Databases and Tables Deleted by Mistake?
Why Does Automated Backup Fail?
Why Is a Table or Data Missing from My Database?
How Do I Restore a Local Database Backup to GaussDB?
Does GaussDB Support Table PITR?
Can I Dump Backup Files to My OBS Buckets?
Does GaussDB Support Table-Level Backup to a Specified OBS Bucket?
Can I Delete the GaussDB Backup Policy?
Database Monitoring
Which DB Instance Monitoring Metrics Do I Need to Pay Attention To?
How Can I Calculate the Memory Usage of a GaussDB Instance?
Scaling and Specification Change
Are My GaussDB Instances Still Available During Storage Scale-up and Instance Specification Change?
Can I Change the VPC to Which My GaussDB Instance Belongs?
Database Parameter Modification
How Can I Change the Time Zone?
How Can I Configure a Password Expiration Policy?
Log Management
How Do I View All SQL Logs Executed by GaussDB?
How Do I View Deadlock Logs of GaussDB?
Network Security
What Security Protection Policies Does GaussDB Have?
How Can I Prevent Untrusted Source IP Addresses from Accessing GaussDB Instances?
How Do I Configure a Security Group to Enable Access to GaussDB Instances?
How Can I Import the Root Certificate to a Windows or Linux Server?
How Do I Manage and Ensure GaussDB Security?
Videos
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions