Search PostgreSQL documentation

pg_shdependCatalogs & ViewsReferencepg_shdepend System catalogs 10 The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to …System Catalogs · System catalogs pg_shdescriptionCatalogs & ViewsReferencepg_shdescription System catalogs 10 The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command…System Catalogs · System catalogs pg_shmem_allocationsCatalogs & ViewsReferencepg_shmem_allocations System views 13 The pg_shmem_allocations view shows allocations made from the server's main shared memory segment. This includes both memory allocated by postgres itself…System Catalogs · System views pg_shmem_allocations_numaCatalogs & ViewsReferencepg_shmem_allocations_numa System views 18 The pg_shmem_allocations_numa shows how shared memory allocations in the server's main shared memory segment are distributed across NUMA nodes. This…System Catalogs · System views pg_shseclabelCatalogs & ViewsReferencepg_shseclabel System catalogs 10 The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easie…System Catalogs · System catalogs pg_stat_all_indexesCatalogs & ViewsReferencepg_stat_all_indexes Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in T…System Catalogs · Statistics views pg_stat_all_tablesCatalogs & ViewsReferencepg_stat_all_tables Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in Ta…System Catalogs · Statistics views pg_stat_archiverCatalogs & ViewsReferencepg_stat_archiver Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in Tabl…System Catalogs · Statistics views pg_stat_autovacuum_scoresCatalogs & ViewsReferencepg_stat_autovacuum_scores Statistics views 19 The pg_stat_autovacuum_scores view will contain one row for each table in the current database (including TOAST tables), showing the current aut…System Catalogs · Statistics views pg_stat_bgwriterCatalogs & ViewsReferencepg_stat_bgwriter Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in Tabl…System Catalogs · Statistics views pg_stat_checkpointerCatalogs & ViewsReferencepg_stat_checkpointer Statistics views 17 The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster. num_timed Number of sched…System Catalogs · Statistics views pg_stat_databaseCatalogs & ViewsReferencepg_stat_database Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in Tabl…System Catalogs · Statistics views pg_stat_database_conflictsCatalogs & ViewsReferencepg_stat_database_conflicts Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, list…System Catalogs · Statistics views pg_stat_gssapiCatalogs & ViewsReferencepg_stat_gssapi Statistics views 12 Several predefined views, listed in Table 27.1, are available to show the current state of the system. There are also several other views, listed in Table …System Catalogs · Statistics views pg_stat_ioCatalogs & ViewsReferencepg_stat_io Statistics views 16 The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combina…System Catalogs · Statistics views pg_stat_kind_infoCatalogs & ViewsReferencepg_stat_kind_info Statistics views 20 The pg_stat_kind_info view contains one row for each registered statistics kind, including both built-in and custom kinds. id Numeric identifier of the …System Catalogs · Statistics views pg_stat_lockCatalogs & ViewsReferencepg_stat_lock Statistics views 19 The pg_stat_lock view will contain one row for each lock type, showing cluster-wide locks statistics. locktype Type of the lockable object. See pg_locks for …System Catalogs · Statistics views pg_stat_progress_analyzeCatalogs & ViewsReferencepg_stat_progress_analyze Progress reporting 13 Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command. The …System Catalogs · Progress reporting pg_stat_progress_basebackupCatalogs & ViewsReferencepg_stat_progress_basebackup Progress reporting 13 Whenever an application like pg_basebackup is taking a base backup, the pg_stat_progress_basebackup view will contain a row for each WAL sen…System Catalogs · Progress reporting pg_stat_progress_clusterCatalogs & ViewsReferencepg_stat_progress_cluster Progress reporting 12 Whenever CLUSTER or VACUUM FULL is running, the pg_stat_progress_cluster view will contain a row for each backend that is currently running eit…System Catalogs · Progress reporting pg_stat_progress_copyCatalogs & ViewsReferencepg_stat_progress_copy Progress reporting 14 Whenever COPY is running, the pg_stat_progress_copy view will contain one row for each backend that is currently running a COPY command. The table…System Catalogs · Progress reporting pg_stat_progress_create_indexCatalogs & ViewsReferencepg_stat_progress_create_index Progress reporting 12 Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currentl…System Catalogs · Progress reporting pg_stat_progress_data_checksumsCatalogs & ViewsReferencepg_stat_progress_data_checksums Progress reporting 19 When data checksums are being enabled or disabled on a running cluster, the pg_stat_progress_data_checksums view will contain a row for …System Catalogs · Progress reporting pg_stat_progress_repackCatalogs & ViewsReferencepg_stat_progress_repack Progress reporting 19 Whenever REPACK is running, the pg_stat_progress_repack view will contain a row for each backend that is currently running the command. The tabl…System Catalogs · Progress reporting pg_stat_progress_vacuumCatalogs & ViewsReferencepg_stat_progress_vacuum Progress reporting 10 Whenever VACUUM is running, the pg_stat_progress_vacuum view will contain one row for each backend (including autovacuum worker processes) that …System Catalogs · Progress reporting pg_stat_recoveryCatalogs & ViewsReferencepg_stat_recovery Statistics views 19 The pg_stat_recovery view will contain at most one row, showing statistics about the recovery state of the startup process. This view returns no rows whe…System Catalogs · Statistics views pg_stat_recovery_prefetchCatalogs & ViewsReferencepg_stat_recovery_prefetch Statistics views 15 The pg_stat_recovery_prefetch view will contain only one row. The columns wal_distance, block_distance and io_depth show current values, and the…System Catalogs · Statistics views pg_stat_replicationCatalogs & ViewsReferencepg_stat_replication Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in T…System Catalogs · Statistics views pg_stat_replication_slotsCatalogs & ViewsReferencepg_stat_replication_slots Statistics views 14 The pg_stat_replication_slots view will contain one row per logical replication slot, showing statistics about its usage. slot_name A unique, cl…System Catalogs · Statistics views pg_stat_slruCatalogs & ViewsReferencepg_stat_slru Statistics views 13 PostgreSQL accesses certain on-disk information via SLRU (simple least-recently-used) caches. The pg_stat_slru view will contain one row for each tracked SLR…System Catalogs · Statistics views pg_stat_sslCatalogs & ViewsReferencepg_stat_ssl Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in Table 28.…System Catalogs · Statistics views pg_stat_subscriptionCatalogs & ViewsReferencepg_stat_subscription Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in …System Catalogs · Statistics views pg_stat_subscription_statsCatalogs & ViewsReferencepg_stat_subscription_stats Statistics views 15 The pg_stat_subscription_stats view will contain one row per subscription. subid OID of the subscription subname Name of the subscription apply…System Catalogs · Statistics views pg_stat_sys_indexesCatalogs & ViewsReferencepg_stat_sys_indexes Statistics views 10 The pg_stat_all_indexes view will contain one row for each index in the current database, showing statistics about accesses to that specific index. Th…System Catalogs · Statistics views pg_stat_sys_tablesCatalogs & ViewsReferencepg_stat_sys_tables Statistics views 10 The pg_stat_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about accesses to …System Catalogs · Statistics views pg_stat_user_functionsCatalogs & ViewsReferencepg_stat_user_functions Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed i…System Catalogs · Statistics views pg_stat_user_indexesCatalogs & ViewsReferencepg_stat_user_indexes Statistics views 10 The pg_stat_all_indexes view will contain one row for each index in the current database, showing statistics about accesses to that specific index. T…System Catalogs · Statistics views pg_stat_user_tablesCatalogs & ViewsReferencepg_stat_user_tables Statistics views 10 The pg_stat_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about accesses to…System Catalogs · Statistics views pg_stat_walCatalogs & ViewsReferencepg_stat_wal Statistics views 14 The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster. wal_records Total number of WAL records generated wal_f…System Catalogs · Statistics views pg_stat_wal_receiverCatalogs & ViewsReferencepg_stat_wal_receiver Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in …System Catalogs · Statistics views