System Views
Greenplum Database provides the following system views not available in
PostgreSQL.
- gp_distributed_log
- gp_distributed_xacts
- gp_pgdatabase
- gp_resqueue_status
- gp_transaction_log
- gpexpand.expansion_progress
- pg_max_external_files (shows number of external table files allowed per segment host when using the file protocol)
- pg_partition_columns
- pg_partition_templates
- pg_partitions
- pg_stat_activity
- pg_stat_replication
- pg_resqueue_attributes
- pg_resqueue_status (Deprecated. Use gp_toolkit.gp_resqueue_status.)
- pg_stat_resqueues
- pg_user_mappings (not supported)
- session_level_memory_consumption 4.3.4.0
For more information about the standard system views supported in PostgreSQL and Greenplum Database, see the following sections of the PostgreSQL documentation: