Search PostgreSQL documentation

pg_indexes_sizeFunctionsReferencepg_indexes_size System Administration Functions 10 Total disk space used by indexes attached to the specified table pg_indexes_size ( regclass ) → bigint Total disk space used by indexes att…Functions · System Administration Functions pg_input_error_infoFunctionsReferencepg_input_error_info System Information Functions And Operators 16 Tests whether the given string is valid input for the specified data type; if not, return the details of the error that woul…Functions · System Information Functions And Operators pg_input_is_validFunctionsReferencepg_input_is_valid System Information Functions And Operators 16 Tests whether the given string is valid input for the specified data type, returning true or false. pg_input_is_valid ( string…Functions · System Information Functions And Operators pg_is_in_backupFunctionsReferencepg_is_in_backup System Administration Functions 10 True if an on-line exclusive backup is still in progress. pg_is_in_backup ( ) → bool True if an on-line exclusive backup is still in progre…Functions · System Administration Functions pg_is_in_recoveryFunctionsReferencepg_is_in_recovery System Administration Functions 10 True if recovery is still in progress. pg_is_in_recovery ( ) → bool True if recovery is still in progress. 11 12 13 Returns true if recov…Functions · System Administration Functions pg_is_other_temp_schemaFunctionsReferencepg_is_other_temp_schema System Information Functions And Operators 10 is schema another session's temporary schema? pg_is_other_temp_schema ( oid ) → boolean is schema another session's temp…Functions · System Information Functions And Operators pg_is_wal_replay_pausedFunctionsReferencepg_is_wal_replay_paused System Administration Functions 10 True if recovery is paused. pg_is_wal_replay_paused ( ) → bool True if recovery is paused. 11 12 13 Returns true if recovery is pau…Functions · System Administration Functions pg_is_xlog_replay_pausedFunctionsReferencepg_is_xlog_replay_paused System Administration Functions 9.1 True if recovery is paused. pg_is_xlog_replay_paused ( ) → bool True if recovery is paused. 9.2 9.3 9.4 9.5 9.6Functions · System Administration Functions pg_jit_availableFunctionsReferencepg_jit_available System Information Functions And Operators 11 is a JIT compiler extension available (see Chapter 32) and the jit configuration parameter set to on. pg_jit_available ( ) → bo…Functions · System Information Functions And Operators pg_last_committed_xactFunctionsReferencepg_last_committed_xact System Information Functions And Operators 10 get transaction ID and commit timestamp of latest committed transaction pg_last_committed_xact ( ) → xid xid, timestamp t…Functions · System Information Functions And Operators pg_last_wal_receive_lsnFunctionsReferencepg_last_wal_receive_lsn System Administration Functions 10 Get last write-ahead log location received and synced to disk by streaming replication. While streaming replication is in progress …Functions · System Administration Functions pg_last_wal_replay_lsnFunctionsReferencepg_last_wal_replay_lsn System Administration Functions 10 Get last write-ahead log location replayed during recovery. If recovery is still in progress this will increase monotonically. If re…Functions · System Administration Functions pg_last_xact_replay_timestampFunctionsReferencepg_last_xact_replay_timestamp System Administration Functions 10 Get time stamp of last transaction replayed during recovery. This is the time at which the commit or abort WAL record for tha…Functions · System Administration Functions pg_last_xlog_receive_locationFunctionsReferencepg_last_xlog_receive_location System Administration Functions 9.0 Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in pr…Functions · System Administration Functions pg_last_xlog_replay_locationFunctionsReferencepg_last_xlog_replay_location System Administration Functions 9.0 Get last transaction log location replayed during recovery. If recovery is still in progress this will increase monotonically…Functions · System Administration Functions pg_listening_channelsFunctionsReferencepg_listening_channels System Information Functions And Operators 10 channel names that the session is currently listening on pg_listening_channels ( ) → setof text channel names that the ses…Functions · System Information Functions And Operators pg_log_backend_memory_contextsFunctionsReferencepg_log_backend_memory_contexts System Administration Functions 14 Requests to log the memory contexts of the backend with the specified process ID. These memory contexts will be logged at LO…Functions · System Administration Functions pg_log_standby_snapshotFunctionsReferencepg_log_standby_snapshot System Administration Functions 16 Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This i…Functions · System Administration Functions pg_logical_emit_messageFunctionsReferencepg_logical_emit_message System Administration Functions 10 Emit text logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The paramete…Functions · System Administration Functions pg_logical_slot_get_binary_changesFunctionsReferencepg_logical_slot_get_binary_changes System Administration Functions 10 Behaves just like the pg_logical_slot_get_changes() function, except that changes are returned as bytea. pg_logical_slot…Functions · System Administration Functions pg_logical_slot_get_changesFunctionsReferencepg_logical_slot_get_changes System Administration Functions 10 Returns changes in the slot slot_name, starting from the point at which since changes have been consumed last. If upto_lsn and …Functions · System Administration Functions pg_logical_slot_peek_binary_changesFunctionsReferencepg_logical_slot_peek_binary_changes System Administration Functions 10 Behaves just like the pg_logical_slot_get_changes() function, except that changes are returned as bytea and that change…Functions · System Administration Functions pg_logical_slot_peek_changesFunctionsReferencepg_logical_slot_peek_changes System Administration Functions 10 Behaves just like the pg_logical_slot_get_changes() function, except that changes are not consumed; that is, they will be retu…Functions · System Administration Functions pg_ls_archive_statusdirFunctionsReferencepg_ls_archive_statusdir System Administration Functions 12 List the name, size, and last modification time of files in the WAL archive status directory. Access is granted to members of the p…Functions · System Administration Functions pg_ls_dirFunctionsReferencepg_ls_dir System Administration Functions 10 List the contents of a directory. pg_ls_dir ( dirname text [, missing_ok boolean, include_dot_dirs boolean] ) → setof text List the contents of a…Functions · System Administration Functions pg_ls_logdirFunctionsReferencepg_ls_logdir System Administration Functions 10 List the name, size, and last modification time of files in the log directory. Access is granted to members of the pg_monitor role and may be …Functions · System Administration Functions pg_ls_logicalmapdirFunctionsReferencepg_ls_logicalmapdir System Administration Functions 15 Returns the name, size, and last modification time (mtime) of each ordinary file in the server's pg_logical/mappings directory. Filenam…Functions · System Administration Functions pg_ls_logicalsnapdirFunctionsReferencepg_ls_logicalsnapdir System Administration Functions 15 Returns the name, size, and last modification time (mtime) of each ordinary file in the server's pg_logical/snapshots directory. Filen…Functions · System Administration Functions pg_ls_replslotdirFunctionsReferencepg_ls_replslotdir System Administration Functions 15 Returns the name, size, and last modification time (mtime) of each ordinary file in the server's pg_replslot/slot_name directory, where s…Functions · System Administration Functions pg_ls_summariesdirFunctionsReferencepg_ls_summariesdir System Administration Functions 18 Returns the name, size, and last modification time (mtime) of each ordinary file in the server's WAL summaries directory (pg_wal/summari…Functions · System Administration Functions pg_ls_tmpdirFunctionsReferencepg_ls_tmpdir System Administration Functions 12 List the name, size, and last modification time of files in the temporary directory for tablespace. If tablespace is not provided, the pg_defa…Functions · System Administration Functions pg_ls_waldirFunctionsReferencepg_ls_waldir System Administration Functions 10 List the name, size, and last modification time of files in the WAL directory. Access is granted to members of the pg_monitor role and may be …Functions · System Administration Functions pg_mcv_list_itemsFunctionsReferencepg_mcv_list_items Statistics Information Functions 12 pg_mcv_list_items returns a list of all items stored in a multi-column MCV list, and returns the following columns: 13 pg_mcv_list_items…Functions · Statistics Information Functions pg_my_temp_schemaFunctionsReferencepg_my_temp_schema System Information Functions And Operators 10 OID of session's temporary schema, or 0 if none pg_my_temp_schema ( ) → oid OID of session's temporary schema, or 0 if none 11…Functions · System Information Functions And Operators pg_notification_queue_usageFunctionsReferencepg_notification_queue_usage System Information Functions And Operators 10 fraction of the asynchronous notification queue currently occupied (0-1) pg_notification_queue_usage ( ) → double fr…Functions · System Information Functions And Operators pg_numa_availableFunctionsReferencepg_numa_available System Information Functions And Operators 18 Returns true if the server has been compiled with NUMA support. pg_numa_available () → boolean Returns true if the server has …Functions · System Information Functions And Operators pg_opclass_is_visibleFunctionsReferencepg_opclass_is_visible System Information Functions And Operators 10 is operator class visible in search path pg_opclass_is_visible ( opclass_oid ) → boolean is operator class visible in sear…Functions · System Information Functions And Operators pg_operator_is_visibleFunctionsReferencepg_operator_is_visible System Information Functions And Operators 10 is operator visible in search path pg_operator_is_visible ( operator_oid ) → boolean is operator visible in search path 1…Functions · System Information Functions And Operators pg_opfamily_is_visibleFunctionsReferencepg_opfamily_is_visible System Information Functions And Operators 10 is operator family visible in search path pg_opfamily_is_visible ( opclass_oid ) → boolean is operator family visible in …Functions · System Information Functions And Operators pg_options_to_tableFunctionsReferencepg_options_to_table System Information Functions And Operators 10 get the set of storage option name/value pairs pg_options_to_table ( reloptions ) → setof record get the set of storage opti…Functions · System Information Functions And Operators