System Views
System Views
In addition to the system catalogs, Tacnode provides a number of built-in views. Some system views provide convenient access to some commonly used queries on the system catalogs. Other views provide access to internal server state.
Table 12.40 lists the system views described here. More detailed documentation of each view follows below. There are some additional views that provide access to the results of the statistics collector; they are described in "monitoring-stats-views-table".
Except where noted, all the views described here are read-only.
Table System Views
| View Name | Purpose |
|---|---|
| pg_available_extensions | available extensions |
| pg_indexes | indexes |
| pg_locks | locks currently held or awaited |
| pg_matviews | materialized views |
| pg_prepared_statements | prepared statements |
| pg_prepared_xacts | prepared transactions |
| pg_roles | database roles |
| pg_seclabels | security labels |
| pg_settings | parameter settings |
| pg_shadow | database users |
| pg_tables | tables |
| pg_user | database users |
| pg_views | views |