Search PostgreSQL documentation

pg_shdependManual ChaptersPG1852.48. pg_shdepend The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to ensure that …pg_shdepend pg_shdescriptionManual ChaptersPG1852.49. pg_shdescription The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed …pg_shdescription pg_shmem_allocationsManual ChaptersPG1853.27. pg_shmem_allocations The pg_shmem_allocations view shows allocations made from the server's main shared memory segment. This includes both memory allocated by PostgreSQL itself and me…pg_shmem_allocations pg_shmem_allocations_numaManual ChaptersPG1853.28. pg_shmem_allocations_numa The pg_shmem_allocations_numa shows how shared memory allocations in the server's main shared memory segment are distributed across NUMA nodes. This includes…pg_shmem_allocations_numa pg_shseclabelManual ChaptersPG1852.50. pg_shseclabel The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to vie…pg_shseclabel pg_stat_activityManual ChaptersPG1827.2.3. pg_stat_activity The pg_stat_activity view will have one row per server process, showing information related to the current activity of that process. Table 27.3. pg_stat_activity Vie…pg_stat_activity pg_stat_all_indexesManual ChaptersPG1827.2.20. pg_stat_all_indexes 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. The pg_stat_u…pg_stat_all_indexes pg_stat_all_tablesManual ChaptersPG1827.2.19. pg_stat_all_tables 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 that specif…pg_stat_all_tables pg_stat_archiverManual ChaptersPG1827.2.12. pg_stat_archiver The pg_stat_archiver view will always have a single row, containing data about the archiver process of the cluster. Table 27.22. pg_stat_archiver View Column Type D…pg_stat_archiver pg_stat_bgwriterManual ChaptersPG1827.2.14. pg_stat_bgwriter The pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster. Table 27.24. pg_stat_bgwriter View Column Type …pg_stat_bgwriter pg_stat_checkpointerManual ChaptersPG1827.2.15. pg_stat_checkpointer The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster. Table 27.25. pg_stat_checkpointer Vi…pg_stat_checkpointer pg_stat_databaseManual ChaptersPG1827.2.17. pg_stat_database The pg_stat_database view will contain one row for each database in the cluster, plus one for shared objects, showing database-wide statistics. Table 27.27. pg_stat…pg_stat_database pg_stat_database_conflictsManual ChaptersPG1827.2.18. pg_stat_database_conflicts The pg_stat_database_conflicts view will contain one row per database, showing database-wide statistics about query cancels occurring due to conflicts wit…pg_stat_database_conflicts pg_stat_gssapiManual ChaptersPG1827.2.11. pg_stat_gssapi The pg_stat_gssapi view will contain one row per backend, showing information about GSSAPI usage on this connection. It can be joined to pg_stat_activity or pg_stat_r…pg_stat_gssapi pg_stat_ioManual ChaptersPG1827.2.13. pg_stat_io 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. Combinations which…pg_stat_io pg_stat_recovery_prefetchManual ChaptersPG1827.2.7. pg_stat_recovery_prefetch 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 other colum…pg_stat_recovery_prefetch pg_stat_replicationManual ChaptersPG1827.2.4. pg_stat_replication The pg_stat_replication view will contain one row per WAL sender process, showing statistics about replication to that sender's connected standby server. Only dir…pg_stat_replication pg_stat_replication_slotsManual ChaptersPG1827.2.5. pg_stat_replication_slots The pg_stat_replication_slots view will contain one row per logical replication slot, showing statistics about its usage. Table 27.15. pg_stat_replication_s…pg_stat_replication_slots pg_stat_slruManual ChaptersPG1827.2.25. pg_stat_slru 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 SLRU cache, sh…pg_stat_slru pg_stat_sslManual ChaptersPG1827.2.10. pg_stat_ssl The pg_stat_ssl view will contain one row per backend or WAL sender process, showing statistics about SSL usage on this connection. It can be joined to pg_stat_activity …pg_stat_ssl pg_stat_statementsManual ChaptersPG18E.6.3.9.1. pg_stat_statements Allow the queries of CREATE TABLE AS and DECLARE to be tracked by pg_stat_statements (Anthonin Bonnefoy) § They are also now assigned query ids. Allow the param…pg_stat_statements pg_stat_statements — track statistics of SQL planning and executionManual ChaptersPG18F.32. pg_stat_statements — track statistics of SQL planning and execution The pg_stat_statements module provides a means for tracking planning and execution statistics of all SQL statements …pg_stat_statements — track statistics of SQL planning and execution pg_stat_subscriptionManual ChaptersPG1827.2.8. pg_stat_subscription Table 27.18. pg_stat_subscription View Column Type Description subid oid OID of the subscription subname name Name of the subscription worker_type text Type of t…pg_stat_subscription pg_stat_subscription_statsManual ChaptersPG1827.2.9. pg_stat_subscription_stats The pg_stat_subscription_stats view will contain one row per subscription. Table 27.19. pg_stat_subscription_stats View Column Type Description subid oid O…pg_stat_subscription_stats pg_stat_user_functionsManual ChaptersPG1827.2.24. pg_stat_user_functions The pg_stat_user_functions view will contain one row for each tracked function, showing statistics about executions of that function. The track_functions para…pg_stat_user_functions pg_stat_walManual ChaptersPG1827.2.16. pg_stat_wal The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster. Table 27.26. pg_stat_wal View Column Type Description wal_records …pg_stat_wal pg_stat_wal_receiverManual ChaptersPG1827.2.6. pg_stat_wal_receiver The pg_stat_wal_receiver view will contain only one row, showing statistics about the WAL receiver from that receiver's connected server. Table 27.16. pg_stat_wa…pg_stat_wal_receiver pg_statio_all_indexesManual ChaptersPG1827.2.22. pg_statio_all_indexes The pg_statio_all_indexes view will contain one row for each index in the current database, showing statistics about I/O on that specific index. The pg_statio_…pg_statio_all_indexes pg_statio_all_sequencesManual ChaptersPG1827.2.23. pg_statio_all_sequences The pg_statio_all_sequences view will contain one row for each sequence in the current database, showing statistics about I/O on that specific sequence. Tabl…pg_statio_all_sequences pg_statio_all_tablesManual ChaptersPG1827.2.21. pg_statio_all_tables The pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specifi…pg_statio_all_tables pg_statisticManual ChaptersPG1852.51. pg_statistic The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the query planner. Note that …pg_statistic pg_statistic_extManual ChaptersPG1852.52. pg_statistic_ext The catalog pg_statistic_ext holds definitions of extended planner statistics. Each row in this catalog corresponds to a statistics object created with CREATE STATIST…pg_statistic_ext pg_statistic_ext_dataManual ChaptersPG1852.53. pg_statistic_ext_data The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a statistics ob…pg_statistic_ext_data pg_statsManual ChaptersPG1853.29. pg_stats The view pg_stats provides access to the information stored in the pg_statistic catalog. This view allows access only to rows of pg_statistic that correspond to tables the us…pg_stats pg_stats_extManual ChaptersPG1853.30. pg_stats_ext The view pg_stats_ext provides access to information about each extended statistics object in the database, combining information stored in the pg_statistic_ext and pg_st…pg_stats_ext pg_stats_ext_exprsManual ChaptersPG1853.31. pg_stats_ext_exprs The view pg_stats_ext_exprs provides access to information about all expressions included in extended statistics objects, combining information stored in the pg_sta…pg_stats_ext_exprs pg_subscriptionManual ChaptersPG1852.54. pg_subscription The catalog pg_subscription contains all existing logical replication subscriptions. For more information about logical replication see Chapter 29. Unlike most system …pg_subscription pg_subscription_relManual ChaptersPG1852.55. pg_subscription_rel The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping. This catalog only contains ta…pg_subscription_rel pg_surgery — perform low-level surgery on relation dataManual ChaptersPG18F.34. pg_surgery — perform low-level surgery on relation data The pg_surgery module provides various functions to perform surgery on a damaged relation. These functions are unsafe by design …pg_surgery — perform low-level surgery on relation data pg_tablesManual ChaptersPG1853.32. pg_tables The view pg_tables provides access to useful information about each table in the database. Table 53.32. pg_tables Columns Column Type Description schemaname name (references…pg_tables