53.1. Overview #

   Table 53.1 lists the system views. More detailed documentation of each
   catalog follows below. Except where noted, all the views described here
   are read-only.

   Table 53.1. System Views
   View Name Purpose
   pg_aios In-use asynchronous IO handles
   pg_available_extensions available extensions
   pg_available_extension_versions available versions of extensions
   pg_backend_memory_contexts backend memory contexts
   pg_config compile-time configuration parameters
   pg_cursors open cursors
   pg_file_settings summary of configuration file contents
   pg_group groups of database users
   pg_hba_file_rules summary of client authentication configuration file
   contents
   pg_ident_file_mappings summary of client user name mapping
   configuration file contents
   pg_indexes indexes
   pg_locks locks currently held or awaited
   pg_matviews materialized views
   pg_policies policies
   pg_prepared_statements prepared statements
   pg_prepared_xacts prepared transactions
   pg_publication_tables publications and information of their associated
   tables
   pg_replication_origin_status information about replication origins,
   including replication progress
   pg_replication_slots replication slot information
   pg_roles database roles
   pg_rules rules
   pg_seclabels security labels
   pg_sequences sequences
   pg_settings parameter settings
   pg_shadow database users
   pg_shmem_allocations shared memory allocations
   pg_shmem_allocations_numa NUMA node mappings for shared memory
   allocations
   pg_stats planner statistics
   pg_stats_ext extended planner statistics
   pg_stats_ext_exprs extended planner statistics for expressions
   pg_tables tables
   pg_timezone_abbrevs time zone abbreviations
   pg_timezone_names time zone names
   pg_user database users
   pg_user_mappings user mappings
   pg_views views
   pg_wait_events wait events