System Views

Greenplum Database provides the following system views not available in PostgreSQL.

• gp_distributed_log
• gp_distributed_xacts
• gp_pgdatabase
• gp_resgroup_config
• gp_resgroup_status
• gp_resqueue_status
• gp_transaction_log
• gpexpand.expansion_progress
• pg_max_external_files
• pg_partition_columns
• pg_partition_templates
• pg_partitions
• pg_resqueue_attributes
• pg_resqueue_status (Deprecated. Use gp_toolkit.gp_resqueue_status.)
• pg_stat_activity
• pg_stat_all_indexes
• pg_stat_all_tables
• pg_stat_replication
• pg_stat_resqueues
• session_level_memory_consumption (See Viewing Session Memory Usage Information.)

For more information about the standard system views supported in PostgreSQL and Greenplum Database, see the following sections of the PostgreSQL documentation:

• System Views
• Statistics Collector Views
• The Information Schema

Parent topic: System Catalog Reference