System Views
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_resgroup_status_per_host
- gp_resgroup_status_per_segment
- gp_resqueue_status
- gp_transaction_log
- gpexpand.expansion_progress
- pg_matviews
- 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_replication
- pg_stat_resqueues
- session_level_memory_consumption (See "Viewing Session Memory Usage Information" in the Greenplum Database Administrator Guide.)
For more information about the standard system views supported in PostgreSQL and Greenplum Database, see the following sections of the PostgreSQL documentation: