System Views
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 (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: