Support
Downloads
Contact Us
Sign In
Pivotal Greenplum
v5.29
v6.x
v5.29
v5.28
v5.27
v5.26
v5.25
v5.24
Earlier
All docs
Downloads
Support
Contact Us
Sign In
Doc Index
Pivotal Greenplum® 5.29 Documentation
Reference Guide
SQL Command Reference
SQL Syntax Summary
ABORT
ALTER AGGREGATE
ALTER CONVERSION
ALTER DATABASE
ALTER DOMAIN
ALTER EXTENSION
ALTER EXTERNAL TABLE
ALTER FILESPACE
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER OPERATOR
ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY
ALTER PROTOCOL
ALTER RESOURCE GROUP
ALTER RESOURCE QUEUE
ALTER ROLE
ALTER SCHEMA
ALTER SEQUENCE
ALTER TABLE
ALTER TABLESPACE
ALTER TYPE
ALTER USER
ALTER VIEW
ANALYZE
BEGIN
CHECKPOINT
CLOSE
CLUSTER
COMMENT
COMMIT
COPY
CREATE AGGREGATE
CREATE CAST
CREATE CONVERSION
CREATE DATABASE
CREATE DOMAIN
CREATE EXTENSION
CREATE EXTERNAL TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY
CREATE PROTOCOL
CREATE RESOURCE GROUP
CREATE RESOURCE QUEUE
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TYPE
CREATE USER
CREATE VIEW
DEALLOCATE
DECLARE
DELETE
DISCARD
DO
DROP AGGREGATE
DROP CAST
DROP CONVERSION
DROP DATABASE
DROP DOMAIN
DROP EXTENSION
DROP EXTERNAL TABLE
DROP FILESPACE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP OPERATOR
DROP OPERATOR CLASS
DROP OPERATOR FAMILY
DROP OWNED
DROP PROTOCOL
DROP RESOURCE GROUP
DROP RESOURCE QUEUE
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP TABLE
DROP TABLESPACE
DROP TYPE
DROP USER
DROP VIEW
END
EXECUTE
EXPLAIN
FETCH
GRANT
INSERT
LOAD
LOCK
MOVE
PREPARE
REASSIGN OWNED
REINDEX
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
START TRANSACTION
TRUNCATE
UPDATE
VACUUM
VALUES
SQL 2008 Optional Feature Compliance
Greenplum Environment Variables
System Catalog Reference
System Tables
System Views
System Catalogs Definitions
gp_configuration_history
gp_distributed_log
gp_distributed_xacts
gp_distribution_policy
gpexpand.expansion_progress
gpexpand.status
gpexpand.status_detail
gp_fastsequence
gp_fault_strategy
gp_global_sequence
gp_id
gp_persistent_database_node
gp_persistent_filespace_node
gp_persistent_relation_node
gp_persistent_tablespace_node
gp_pgdatabase
gp_relation_node
gp_resgroup_config
gp_resgroup_status
gp_resqueue_status
gp_segment_configuration
gp_transaction_log
gp_version_at_initdb
pg_aggregate
pg_am
pg_amop
pg_amproc
pg_appendonly
pg_attrdef
pg_attribute
pg_attribute_encoding
pg_auth_members
pg_authid
pg_available_extension_versions
pg_available_extensions
pg_cast
pg_class
pg_compression
pg_constraint
pg_conversion
pg_database
pg_depend
pg_description
pg_enum
pg_extension
pg_exttable
pg_filespace
pg_filespace_entry
pg_index
pg_inherits
pg_language
pg_largeobject
pg_listener
pg_locks
pg_max_external_files
pg_namespace
pg_opclass
pg_operator
pg_partition
pg_partition_columns
pg_partition_encoding
pg_partition_rule
pg_partition_templates
pg_partitions
pg_pltemplate
pg_proc
pg_resgroup
pg_resgroupcapability
pg_resourcetype
pg_resqueue
pg_resqueue_attributes
pg_resqueuecapability
pg_rewrite
pg_roles
pg_shdepend
pg_shdescription
pg_stat_activity
pg_stat_all_indexes
pg_stat_all_tables
pg_stat_last_operation
pg_stat_last_shoperation
pg_stat_operations
pg_stat_partition_operations
pg_stat_replication
pg_statistic
pg_stat_resqueues
pg_tablespace
pg_trigger
pg_type
pg_type_encoding
pg_user_mapping
pg_window
The gp_toolkit Administrative Schema
Checking for Tables that Need Routine Maintenance
Checking for Locks
Checking Append-Optimized Tables
Viewing Greenplum Database Server Log Files
Checking Server Configuration Files
Checking for Failed Segments
Checking Resource Group Activity and Status
Checking Resource Queue Activity and Status
Checking Query Disk Spill Space Usage
Viewing Users and Groups (Roles)
Checking Database Object Sizes and Disk Space
Checking for Uneven Data Distribution
The gpperfmon Database
database_*
diskspace_*
interface_stats_*
log_alert_*
queries_*
segment_*
socket_stats_*
system_*
dynamic_memory_info
memory_info
Greenplum Database Data Types
Character Set Support
Server Configuration Parameters
Parameter Types and Values
Setting Parameters
Parameter Categories
Configuration Parameters
add_missing_from
application_name
array_nulls
authentication_timeout
backslash_quote
block_size
bonjour_name
check_function_bodies
client_encoding
client_min_messages
cpu_index_tuple_cost
cpu_operator_cost
cpu_tuple_cost
cursor_tuple_fraction
custom_variable_classes
data_checksums
DateStyle
db_user_namespace
deadlock_timeout
debug_assertions
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_prelim_plan
debug_print_rewritten
debug_print_slice_table
default_statistics_target
default_tablespace
default_transaction_isolation
default_transaction_read_only
dtx_phase2_retry_count
dynamic_library_path
effective_cache_size
enable_bitmapscan
enable_groupagg
enable_hashagg
enable_hashjoin
enable_indexscan
enable_mergejoin
enable_nestloop
enable_seqscan
enable_sort
enable_tidscan
escape_string_warning
explain_pretty_print
extra_float_digits
filerep_mirrorvalidation_during_resync
from_collapse_limit
gp_adjust_selectivity_for_outerjoins
gp_analyze_relative_error
gp_appendonly_compaction
gp_appendonly_compaction_threshold
gp_autostats_mode
gp_autostats_mode_in_functions
gp_autostats_on_change_threshold
gp_backup_directIO
gp_backup_directIO_read_chunk_mb
gp_cached_segworkers_threshold
gp_command_count
gp_connection_send_timeout
gp_connections_per_thread
gp_content
gp_create_table_random_default_distribution
gp_dbid
gp_debug_linger
gp_default_storage_options
gp_dynamic_partition_pruning
gp_email_from
gp_email_smtp_password
gp_email_smtp_server
gp_email_smtp_userid
gp_email_to
gp_enable_agg_distinct
gp_enable_agg_distinct_pruning
gp_enable_direct_dispatch
gp_enable_exchange_default_partition
gp_enable_fallback_plan
gp_enable_fast_sri
gp_enable_gpperfmon
gp_enable_groupext_distinct_gather
gp_enable_groupext_distinct_pruning
gp_enable_multiphase_agg
gp_enable_predicate_propagation
gp_enable_preunique
gp_enable_relsize_collection
gp_enable_segment_copy_checking
gp_enable_sequential_window_plans (Beta)
gp_enable_sort_distinct
gp_enable_sort_limit
gp_external_enable_exec
gp_external_max_segs
gp_external_enable_filter_pushdown
gp_filerep_tcp_keepalives_count
gp_filerep_tcp_keepalives_idle
gp_filerep_tcp_keepalives_interval
gp_fts_probe_interval
gp_fts_probe_retries
gp_fts_probe_threadcount
gp_fts_probe_timeout
gp_gpperfmon_send_interval
gpperfmon_log_alert_level
gp_hadoop_home
gp_hadoop_target_version
gp_hashjoin_tuples_per_bucket
gp_idf_deduplicate
gp_ignore_error_table
gp_initial_bad_row_limit
gp_interconnect_debug_retry_interval
gp_interconnect_fc_method
gp_interconnect_hash_multiplier
gp_interconnect_queue_depth
gp_interconnect_setup_timeout
gp_interconnect_snd_queue_depth
gp_interconnect_transmit_timeout
gp_interconnect_type
gp_log_format
gp_log_fts
gp_log_gang
gp_log_interconnect
gp_max_csv_line_length
gp_max_databases
gp_max_filespaces
gp_max_local_distributed_cache
gp_max_packet_size
gp_max_plan_size
gp_max_slices
gp_max_tablespaces
gp_motion_cost_per_row
gp_num_contents_in_cluster
gp_recursive_cte_prototype
gp_reject_percent_threshold
gp_reraise_signal
gp_resgroup_memory_policy
gp_resource_group_bypass
gp_resource_group_cpu_limit
gp_resource_group_memory_limit
gp_resource_manager
gp_resqueue_memory_policy
gp_resqueue_priority
gp_resqueue_priority_cpucores_per_segment
gp_resqueue_priority_sweeper_interval
gp_role
gp_safefswritesize
gp_segment_connect_timeout
gp_segments_for_planner
gp_server_version
gp_server_version_num
gp_session_id
gp_set_proc_affinity
gp_set_read_only
gp_snmp_community
gp_snmp_monitor_address
gp_snmp_use_inform_or_trap
gp_statistics_pullup_from_child_partition
gp_statistics_use_fkeys
gp_vmem_idle_resource_timeout
gp_vmem_protect_limit
gp_vmem_protect_segworker_cache_limit
gp_workfile_checksumming
gp_workfile_compress_algorithm
gp_workfile_limit_files_per_query
gp_workfile_limit_per_query
gp_workfile_limit_per_segment
gpperfmon_port
ignore_checksum_failure
integer_datetimes
IntervalStyle
join_collapse_limit
keep_wal_segments
krb_caseins_users
krb_server_keyfile
lc_collate
lc_ctype
lc_messages
lc_monetary
lc_numeric
lc_time
listen_addresses
local_preload_libraries
log_autostats
log_connections
log_disconnections
log_dispatch_stats
log_duration
log_error_verbosity
log_executor_stats
log_hostname
log_min_duration_statement
log_min_error_statement
log_min_messages
log_parser_stats
log_planner_stats
log_rotation_age
log_rotation_size
log_statement
log_statement_stats
log_temp_files
log_timezone
log_truncate_on_rotation
max_appendonly_tables
max_connections
max_files_per_process
max_fsm_pages
max_fsm_relations
max_function_args
max_identifier_length
max_index_keys
max_locks_per_transaction
max_prepared_transactions
max_resource_portals_per_transaction
max_resource_queues
max_stack_depth
max_statement_mem
memory_spill_ratio
optimizer
optimizer_array_expansion_threshold
optimizer_analyze_root_partition
optimizer_control
optimizer_cost_model
optimizer_cte_inlining_bound
optimizer_dpe_stats
optimizer_enable_associativity
optimizer_enable_dml
optimizer_enable_master_only_queries
optimizer_force_agg_skew_avoidance
optimizer_force_multistage_agg
optimizer_force_three_stage_scalar_dqa
optimizer_join_arity_for_associativity_commutativity
optimizer_join_order
optimizer_join_order_threshold
optimizer_mdcache_size
optimizer_metadata_caching
optimizer_minidump
optimizer_nestloop_factor
optimizer_parallel_union
optimizer_penalize_skew
optimizer_print_missing_stats
optimizer_print_optimization_stats
optimizer_sort_factor
optimizer_use_gpdb_allocators
optimizer_xform_bind_threshold
password_encryption
password_hash_algorithm
pgcrypto.fips
pgstat_track_activity_query_size
pljava_classpath
pljava_classpath_insecure
pljava_statement_cache_size
pljava_release_lingering_savepoints
pljava_vmoptions
port
random_page_cost
readable_external_table_timeout
repl_catchup_within_range
replication_timeout
regex_flavor
resource_cleanup_gangs_on_wait
resource_select_only
runaway_detector_activation_percent
search_path
seq_page_cost
server_encoding
server_version
server_version_num
shared_buffers
shared_preload_libraries
ssl
ssl_ciphers
standard_conforming_strings
statement_mem
statement_timeout
stats_queue_level
superuser_reserved_connections
tcp_keepalives_count
tcp_keepalives_idle
tcp_keepalives_interval
temp_buffers
TimeZone
timezone_abbreviations
track_activities
track_activity_query_size
track_counts
transaction_isolation
transaction_read_only
transform_null_equals
unix_socket_directory
unix_socket_group
unix_socket_permissions
update_process_title
vacuum_cost_delay
vacuum_cost_limit
vacuum_cost_page_dirty
vacuum_cost_page_hit
vacuum_cost_page_miss
vacuum_freeze_min_age
validate_previous_free_tid
verify_gpfdists_cert
vmem_process_interrupt
wal_receiver_status_interval
writable_external_table_bufsize
xid_stop_limit
xid_warn_limit
Summary of Built-in Functions
Greenplum MapReduce Specification
Greenplum PL/pgSQL Procedural Language
Greenplum PostGIS Extension
Greenplum PL/R Language Extension
Greenplum PL/Python Language Extension
PL/Container Language
Greenplum PL/Java Language Extension
Greenplum PL/Perl Language Extension
Greenplum MADlib Extension for Analytics
Greenplum Partner Connector API
Greenplum Fuzzy String Match Extension
Summary of Greenplum Features
System Catalogs Definitions
System Catalogs Definitions
System catalog table and view definitions in alphabetical order.
gp_configuration_history
gp_distributed_log
gp_distributed_xacts
gp_distribution_policy
gpexpand.expansion_progress
gpexpand.status
gpexpand.status_detail
gp_fastsequence
gp_fault_strategy
gp_global_sequence
gp_id
gp_persistent_database_node
gp_persistent_filespace_node
gp_persistent_relation_node
gp_persistent_tablespace_node
gp_pgdatabase
gp_relation_node
gp_resgroup_config
gp_resgroup_status
gp_resqueue_status
gp_segment_configuration
gp_transaction_log
gp_version_at_initdb
pg_aggregate
pg_am
pg_amop
pg_amproc
pg_appendonly
pg_attrdef
pg_attribute
pg_attribute_encoding
pg_auth_members
pg_authid
pg_available_extension_versions
pg_available_extensions
pg_cast
pg_class
pg_compression
pg_constraint
pg_conversion
pg_database
pg_depend
pg_description
pg_enum
pg_extension
pg_exttable
pg_filespace
pg_filespace_entry
pg_index
pg_inherits
pg_language
pg_largeobject
pg_listener
pg_locks
pg_max_external_files
pg_namespace
pg_opclass
pg_operator
pg_partition
pg_partition_columns
pg_partition_encoding
pg_partition_rule
pg_partition_templates
pg_partitions
pg_pltemplate
pg_proc
pg_resgroup
pg_resgroupcapability
pg_resourcetype
pg_resqueue
pg_resqueue_attributes
pg_resqueuecapability
pg_rewrite
pg_roles
pg_shdepend
pg_shdescription
pg_stat_activity
pg_stat_all_indexes
pg_stat_all_tables
pg_stat_last_operation
pg_stat_last_shoperation
pg_stat_operations
pg_stat_partition_operations
pg_stat_replication
pg_statistic
pg_stat_resqueues
pg_tablespace
pg_trigger
pg_type
pg_type_encoding
pg_user_mapping
pg_window
Parent topic:
System Catalog Reference
Download
Ask for Help
Knowledge Base
PDF