System Views

HAWQ provides the following system views not available in PostgreSQL.

• 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_resqueue_status
• pg_stats

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

• System Views
• Statistics Collector Views
• The Information Schema