9.26. System Information Functions and Operators

--- doc/src/sgml/html/functions-info.html | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'doc/src/sgml/html/functions-info.html') diff --git a/doc/src/sgml/html/functions-info.html b/doc/src/sgml/html/functions-info.html index 6f16acd..5a2052c 100644 --- a/doc/src/sgml/html/functions-info.html +++ b/doc/src/sgml/html/functions-info.html @@ -1,5 +1,5 @@ -9.26. System Information Functions and Operators

9.26. System Information Functions and Operators
Prev	Up	Chapter 9. Functions and Operators	Home	Next

9.26. System Information Functions and Operators

+9.26. System Information Functions and Operators

9.26. System Information Functions and Operators
Prev	Up	Chapter 9. Functions and Operators	Home	Next

9.26. System Information Functions and Operators

Table 9.66 shows several functions that extract session and system information.

@@ -1771,4 +1771,4 @@ SELECT collation for ('foo' COLLATE "de_DE");

Returns information about recovery state, as shown in Table 9.86. -

Table 9.83. pg_control_checkpoint Output Columns

Column Name	Data Type
`checkpoint_lsn`	`pg_lsn`
`redo_lsn`	`pg_lsn`
`redo_wal_file`	`text`
`timeline_id`	`integer`
`prev_timeline_id`	`integer`
`full_page_writes`	`boolean`
`next_xid`	`text`
`next_oid`	`oid`
`next_multixact_id`	`xid`
`next_multi_offset`	`xid`
`oldest_xid`	`xid`
`oldest_xid_dbid`	`oid`
`oldest_active_xid`	`xid`
`oldest_multi_xid`	`xid`
`oldest_multi_dbid`	`oid`
`oldest_commit_ts_xid`	`xid`
`newest_commit_ts_xid`	`xid`
`checkpoint_time`	`timestamp with time zone`

Table 9.84. pg_control_system Output Columns

Column Name	Data Type
`pg_control_version`	`integer`
`catalog_version_no`	`integer`
`system_identifier`	`bigint`
`pg_control_last_modified`	`timestamp with time zone`

Table 9.85. pg_control_init Output Columns

Column Name	Data Type
`max_data_alignment`	`integer`
`database_block_size`	`integer`
`blocks_per_segment`	`integer`
`wal_block_size`	`integer`
`bytes_per_wal_segment`	`integer`
`max_identifier_length`	`integer`
`max_index_columns`	`integer`
`max_toast_chunk_size`	`integer`
`large_object_chunk_size`	`integer`
`float8_pass_by_value`	`boolean`
`data_page_checksum_version`	`integer`

Table 9.86. pg_control_recovery Output Columns

Column Name	Data Type
`min_recovery_end_lsn`	`pg_lsn`
`min_recovery_end_timeline`	`integer`
`backup_start_lsn`	`pg_lsn`
`backup_end_lsn`	`pg_lsn`
`end_of_backup_record_required`	`boolean`

Prev	Up	Next
9.25. Set Returning Functions	Home	9.27. System Administration Functions

\ No newline at end of file +

Table 9.83. pg_control_checkpoint Output Columns

Column Name	Data Type
`checkpoint_lsn`	`pg_lsn`
`redo_lsn`	`pg_lsn`
`redo_wal_file`	`text`
`timeline_id`	`integer`
`prev_timeline_id`	`integer`
`full_page_writes`	`boolean`
`next_xid`	`text`
`next_oid`	`oid`
`next_multixact_id`	`xid`
`next_multi_offset`	`xid`
`oldest_xid`	`xid`
`oldest_xid_dbid`	`oid`
`oldest_active_xid`	`xid`
`oldest_multi_xid`	`xid`
`oldest_multi_dbid`	`oid`
`oldest_commit_ts_xid`	`xid`
`newest_commit_ts_xid`	`xid`
`checkpoint_time`	`timestamp with time zone`

Table 9.84. pg_control_system Output Columns

Column Name	Data Type
`pg_control_version`	`integer`
`catalog_version_no`	`integer`
`system_identifier`	`bigint`
`pg_control_last_modified`	`timestamp with time zone`

Table 9.85. pg_control_init Output Columns

Column Name	Data Type
`max_data_alignment`	`integer`
`database_block_size`	`integer`
`blocks_per_segment`	`integer`
`wal_block_size`	`integer`
`bytes_per_wal_segment`	`integer`
`max_identifier_length`	`integer`
`max_index_columns`	`integer`
`max_toast_chunk_size`	`integer`
`large_object_chunk_size`	`integer`
`float8_pass_by_value`	`boolean`
`data_page_checksum_version`	`integer`

Table 9.86. pg_control_recovery Output Columns

Column Name	Data Type
`min_recovery_end_lsn`	`pg_lsn`
`min_recovery_end_timeline`	`integer`
`backup_start_lsn`	`pg_lsn`
`backup_end_lsn`	`pg_lsn`
`end_of_backup_record_required`	`boolean`

Prev	Up	Next
9.25. Set Returning Functions	Home	9.27. System Administration Functions

\ No newline at end of file -- cgit v1.2.3