Search PostgreSQL documentation

pg_partition_ancestorsFunctionsReferencepg_partition_ancestors System Administration Functions 12 List the ancestor relations of the given partition, including the partition itself. pg_partition_ancestors ( regclass ) → setof regc…Functions · System Administration Functions pg_partition_rootFunctionsReferencepg_partition_root System Administration Functions 12 Return the top-most parent of a partition tree to which the given relation belongs. pg_partition_root ( regclass ) → regclass Return the …Functions · System Administration Functions pg_partition_treeFunctionsReferencepg_partition_tree System Administration Functions 12 List information about tables or indexes in a partition tree for a given partitioned table or partitioned index, with one row for each pa…Functions · System Administration Functions pg_postmaster_start_timeFunctionsReferencepg_postmaster_start_time System Information Functions And Operators 10 server start time pg_postmaster_start_time ( ) → timestamp with time zone server start time 11 12 13 Returns the time w…Functions · System Information Functions And Operators pg_promoteFunctionsReferencepg_promote System Administration Functions 12 Promotes a physical standby server. With wait set to true (the default), the function waits until promotion is completed or wait_seconds seconds…Functions · System Administration Functions pg_read_binary_fileFunctionsReferencepg_read_binary_file System Administration Functions 10 Return the contents of a file. pg_read_binary_file ( filename text [, offset bigint, length bigint [, missing_ok boolean] ] ) → bytea R…Functions · System Administration Functions pg_read_fileFunctionsReferencepg_read_file System Administration Functions 10 Return the contents of a text file. pg_read_file ( filename text [, offset bigint, length bigint [, missing_ok boolean] ] ) → text Return the …Functions · System Administration Functions pg_relation_filenodeFunctionsReferencepg_relation_filenode System Administration Functions 10 Filenode number of the specified relation pg_relation_filenode ( relation regclass ) → oid Filenode number of the specified relation 1…Functions · System Administration Functions pg_relation_filepathFunctionsReferencepg_relation_filepath System Administration Functions 10 File path name of the specified relation pg_relation_filepath ( relation regclass ) → text File path name of the specified relation 11…Functions · System Administration Functions pg_relation_sizeFunctionsReferencepg_relation_size System Administration Functions 10 Disk space used by the specified fork ('main', 'fsm', 'vm', or 'init') of the specified table or index pg_relation_size ( relation regclas…Functions · System Administration Functions pg_reload_confFunctionsReferencepg_reload_conf System Administration Functions 10 Cause server processes to reload their configuration files pg_reload_conf ( ) → boolean Cause server processes to reload their configuration…Functions · System Administration Functions pg_replication_origin_advanceFunctionsReferencepg_replication_origin_advance System Administration Functions 10 Set replication progress for the given node to the given location. This primarily is useful for setting up the initial locati…Functions · System Administration Functions pg_replication_origin_createFunctionsReferencepg_replication_origin_create System Administration Functions 10 Create a replication origin with the given external name, and return the internal id assigned to it. pg_replication_origin_cre…Functions · System Administration Functions pg_replication_origin_dropFunctionsReferencepg_replication_origin_drop System Administration Functions 10 Delete a previously created replication origin, including any associated replay progress. pg_replication_origin_drop ( node_name…Functions · System Administration Functions pg_replication_origin_oidFunctionsReferencepg_replication_origin_oid System Administration Functions 10 Lookup a replication origin by name and return the internal ID. If no such replication origin is found, NULL is returned. pg_repl…Functions · System Administration Functions pg_replication_origin_progressFunctionsReferencepg_replication_origin_progress System Administration Functions 10 Return the replay location for the given replication origin. The parameter flush determines whether the corresponding local …Functions · System Administration Functions pg_replication_origin_session_is_setupFunctionsReferencepg_replication_origin_session_is_setup System Administration Functions 10 Has a replication origin been configured in the current session? pg_replication_origin_session_is_setup ( ) → bool H…Functions · System Administration Functions pg_replication_origin_session_progressFunctionsReferencepg_replication_origin_session_progress System Administration Functions 10 Return the replay location for the replication origin configured in the current session. The parameter flush determi…Functions · System Administration Functions pg_replication_origin_session_resetFunctionsReferencepg_replication_origin_session_reset System Administration Functions 10 Cancel the effects of pg_replication_origin_session_setup(). pg_replication_origin_session_reset ( ) → void Cancel the …Functions · System Administration Functions pg_replication_origin_session_setupFunctionsReferencepg_replication_origin_session_setup System Administration Functions 10 Mark the current session as replaying from the given origin, allowing replay progress to be tracked. Use pg_replication…Functions · System Administration Functions pg_replication_origin_xact_resetFunctionsReferencepg_replication_origin_xact_reset System Administration Functions 10 Cancel the effects of pg_replication_origin_xact_setup(). pg_replication_origin_xact_reset ( ) → void Cancel the effects o…Functions · System Administration Functions pg_replication_origin_xact_setupFunctionsReferencepg_replication_origin_xact_setup System Administration Functions 10 Mark the current transaction as replaying a transaction that has committed at the given LSN and timestamp. Can only be cal…Functions · System Administration Functions pg_replication_slot_advanceFunctionsReferencepg_replication_slot_advance System Administration Functions 11 Advances the current confirmed position of a replication slot named slot_name. The slot will not be moved backwards, and it wil…Functions · System Administration Functions pg_restore_attribute_statsFunctionsReferencepg_restore_attribute_stats System Administration Functions 18 Creates or updates column-level statistics. Ordinarily, these statistics are collected automatically or updated as a part of VAC…Functions · System Administration Functions pg_restore_extended_statsFunctionsReferencepg_restore_extended_stats System Administration Functions 19 Creates or updates statistics for statistics objects. Ordinarily, these statistics are collected automatically or updated as a pa…Functions · System Administration Functions pg_restore_relation_statsFunctionsReferencepg_restore_relation_stats System Administration Functions 18 Updates table-level statistics. Ordinarily, these statistics are collected automatically or updated as a part of VACUUM or ANALYZ…Functions · System Administration Functions pg_rotate_logfileFunctionsReferencepg_rotate_logfile System Administration Functions 10 Rotate server's log file pg_rotate_logfile ( ) → boolean Rotate server's log file 11 12 13 Signals the log-file manager to switch to a ne…Functions · System Administration Functions pg_safe_snapshot_blocking_pidsFunctionsReferencepg_safe_snapshot_blocking_pids System Information Functions And Operators 10 Process ID(s) that are blocking specified server process ID from acquiring a safe snapshot pg_safe_snapshot_block…Functions · System Information Functions And Operators pg_settings_get_flagsFunctionsReferencepg_settings_get_flags System Information Functions And Operators 15 Returns an array of the flags associated with the given GUC, or NULL if it does not exist. The result is an empty array if…Functions · System Information Functions And Operators pg_size_bytesFunctionsReferencepg_size_bytes System Administration Functions 10 Converts a size in human-readable format with size units into bytes pg_size_bytes ( text ) → bigint Converts a size in human-readable format …Functions · System Administration Functions pg_size_prettyFunctionsReferencepg_size_pretty System Administration Functions 10 Converts a size in bytes expressed as a 64-bit integer into a human-readable format with size units pg_size_pretty ( bigint ) → text Convert…Functions · System Administration Functions pg_sleepFunctionsReferencepg_sleep Date/Time Functions And Operators 10 pg_sleep makes the current session's process sleep until seconds seconds have elapsed. seconds is a value of type double precision, so fractiona…Functions · Date/Time Functions And Operators pg_sleep_forFunctionsReferencepg_sleep_for Date/Time Functions And Operators 10 pg_sleep makes the current session's process sleep until seconds seconds have elapsed. seconds is a value of type double precision, so fract…Functions · Date/Time Functions And Operators pg_sleep_untilFunctionsReferencepg_sleep_until Date/Time Functions And Operators 10 pg_sleep makes the current session's process sleep until seconds seconds have elapsed. seconds is a value of type double precision, so fra…Functions · Date/Time Functions And Operators pg_snapshot_xipFunctionsReferencepg_snapshot_xip System Information Functions And Operators 13 Returns the set of in-progress transaction IDs contained in a snapshot. pg_snapshot_xip ( pg_snapshot ) → setof xid8 Returns the…Functions · System Information Functions And Operators pg_snapshot_xmaxFunctionsReferencepg_snapshot_xmax System Information Functions And Operators 13 Returns the xmax of a snapshot. pg_snapshot_xmax ( pg_snapshot ) → xid8 Returns the xmax of a snapshot. 14 15 16 17 18 19 20Functions · System Information Functions And Operators pg_snapshot_xminFunctionsReferencepg_snapshot_xmin System Information Functions And Operators 13 Returns the xmin of a snapshot. pg_snapshot_xmin ( pg_snapshot ) → xid8 Returns the xmin of a snapshot. 14 15 16 17 18 19 20Functions · System Information Functions And Operators pg_split_walfile_nameFunctionsReferencepg_split_walfile_name System Administration Functions 16 Extracts the sequence number and timeline ID from a WAL file name. pg_split_walfile_name ( file_name text ) → record ( segment_number…Functions · System Administration Functions pg_start_backupFunctionsReferencepg_start_backup System Administration Functions 10 Prepare for performing on-line backup (restricted to superusers by default, but other users can be granted EXECUTE to run the function) pg_…Functions · System Administration Functions pg_stat_clear_snapshotFunctionsPG18pg_stat_clear_snapshot () → void Discards the current statistics snapshot or cached information.The Cumulative Statistics System › Statistics Functions