System Views
A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
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: