All Documentation
GaussDB
GaussDB
What's New
Function Overview
Product Bulletin
Vulnerability Fixing Policies
Service Overview
GaussDB Infographics
What Is GaussDB?
Scenarios
Basic Concepts
Advantages
DB Instance Description
Instance Statuses
Instance Specifications
Instance Storage Types
Instance Versions
Security
Shared Responsibilities
Identity Authentication and Access Control
Data Protection
Audit and Logs
Risk Monitoring
Fault Recovery
Certificates
Permissions Management
Constraints
Billing
Related Services
Getting Started
Operation Guide
Logging In to the Console
Buying a DB Instance
Connecting to a DB Instance Using a Database Client
Connecting to a DB Instance
Connecting to an Instance Through DAS
Connecting to an Instance over a Private Network
Connecting to a DB Instance over a Public Network
Connecting to a DB Instance Using a Driver
Development Guidelines
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
Example: Using DAS to Connect to an Instance and Execute SQL Statements
Kernel Release Notes
Kernel Version Description
User Guide
Logging In to the Console
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
Instance Management
Changing an Instance Name
Rebooting a DB Instance
Deleting a Pay-per-Use DB Instance
Resetting the Administrator Password
Binding and Unbinding an EIP
Adding Nodes
Deleting CNs
Scaling up Storage Space
Viewing and Modifying Instance Parameters
Changing CPU and Memory Specifications
Exporting Instance Information
Changing Failover Priority
Configuring Security Group Rules
Changing Replicas
Updating the DB Engine and OS of a DB Instance
Parameter Template Management
Creating a Parameter Template
Modifying Parameters in a Parameter Template
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
Data Backup
Working with Backups
Configuring an Automated Backup Policy for Instances
Creating a Manual Backup for Instances
Exporting Backup Information
Deleting a Manual Backup
Data Restoration
Restoring a Backup File to a DB Instance
Restoring a DB Instance to a Specific Point in Time
Monitoring and Alarming
Introducing Metrics
Supported Events
Creating Alarm Rules
Viewing Monitoring Metrics
Interconnection with CTS
Key Operations Supported by CTS
Viewing Traces
Uploading Audit Logs to LTS
Quota Management
Task Center
Viewing a Task
Deleting a Task Record
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
Tags
Rebuilding a Deleted Instance
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
Developer Guide
Developer Guide (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
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)
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 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
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
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: Refactoring 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 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
OID Types
Pseudo-Types
Data Types Supported by Column-store Tables
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
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/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
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
NewNode13
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
Table Search
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 LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER NODE
ALTER NODE GROUP
ALTER RESOURCE LABEL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
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 MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE NODE
CREATE NODE GROUP
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE SCHEMA
CREATE SEQUENCE
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 MASKING POLICY
DROP MATERIALIZED VIEW
DROP NODE
DROP NODE GROUP
DROP OWNED
DROP PROCEDURE
DROP RESOURCE LABEL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP SCHEMA
DROP SEQUENCE
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 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
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
NewNode12
DBE_APPLICATION_INFO
Retry Management
Commissioning
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_POLICY_LABEL
GS_RECYCLEBIN
NewNode11
GS_TXN_SNAPSHOT
GS_UID
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_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_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_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_HIST_SQLSTAT_FUNC
ADM_HIST_SQLSTAT_IDLAG_FUNC
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
NewNode9
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
NewNode10
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_WLM_CGROUP_INFO
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_WRITE_TERM_LOG
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_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_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_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
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_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_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
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
NewNode5
NewNode6
Wait Classes by Total Wait Time
NewNode7
IO Profile
Memory Statistics
Time Model
NewNode8
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
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
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 Event
Query
System Performance Snapshot
Security Configuration
HyperLogLog
Scheduled Task
Thread Pool
Full Text Search
Backup and Restoration
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()
Developer Guide (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 Store Method
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 Client Reference
Overview
Usage Guidelines
Obtaining 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
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)
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
ANALYZE Table
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
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
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
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
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
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
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
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
Table Search
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 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 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 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 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
Advanced Packages
Basic Interfaces
PKG_SERVICE
PKG_UTIL
Secondary Encapsulation Interfaces (Recommended)
DBE_LOB
DBE_RANDOM
DBE_OUTPUT
DBE_RAW
DBE_TASK
DBE_SCHEDULER
DBE_SQL
DBE_FILE
DBE_UTILITY
DEB_SESSION
DBE_MATCH
DBE_APPLICATION_INFO
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_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_HIST_SQLSTAT_FUNC
ADM_HIST_SQLSTAT_IDLAG_FUNC
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_AUDITING
GS_AUDITING_ACCESS
GS_AUDITING_PRIVILEGE
GS_COMM_PROXY_THREAD_STATUS
GS_DB_PRIVILEGES
GS_FILE_STAT
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_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_WRITE_TERM_LOG
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_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
PLAN_TABLE
SYS_DUMMY
Schemas
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
GS_SHARED_MEMORY_DETAIL
GLOBAL_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_USER_COMPLEX_HISTORY
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_GET_BGWRITER_STATUS
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
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