54.1. Overview

Table 54.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 54.1. System Views

View NamePurpose

available extensions

available versions of extensions

backend memory contexts

compile-time configuration parameters

open cursors

summary of configuration file contents

groups of database users

summary of client authentication configuration file contents

summary of client user name mapping configuration file contents


locks currently held or awaited

materialized views


prepared statements

prepared transactions

publications and information of their associated tables

information about replication origins, including replication progress

replication slot information

database roles


security labels


parameter settings

database users

shared memory allocations

planner statistics

extended planner statistics

extended planner statistics for expressions


time zone abbreviations

time zone names

database users

user mappings