1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
$ fq -d pg_control -o flavour=postgres13 dv pg_control
|00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d 0e 0f|0123456789abcdef|.{}: pg_control (pg_control) 0x0-0x2000 (8192)
0x0000|02 a4 3e eb fc 7f d5 62 |..>....b | system_identifier: 7121739110011544578 0x0-0x8 (8)
0x0000| 14 05 00 00 | .... | pg_control_version: 1300 0x8-0xc (4)
0x0000| a1 62 0a 0c| .b..| catalog_version_no: 202007201 0xc-0x10 (4)
0x0010|06 00 00 00 |.... | state: "DB_IN_PRODUCTION" (6) 0x10-0x14 (4)
0x0010| 00 00 00 00 | .... | hole0: 0 0x14-0x18 (4)
0x0010| 3f c4 eb 62 00 00 00 00| ?..b....| time: "Thu, 04 Aug 2022 13:06:07 UTC" (1659618367) 0x18-0x20 (8)
0x0020|58 7c 77 02 00 00 00 00 |X|w..... | check_point: "0/2777C58" (41385048) 0x20-0x28 (8)
| | | check_point_copy{}: 0x28-0x80 (88)
0x0020| 20 7c 77 02 00 00 00 00| |w.....| redo: "0/2777C20" (41384992) 0x28-0x30 (8)
0x0030|01 00 00 00 |.... | this_time_line_id: 1 0x30-0x34 (4)
0x0030| 01 00 00 00 | .... | prev_time_line_id: 1 0x34-0x38 (4)
0x0030| 01 | . | full_page_writes: 1 0x38-0x39 (1)
0x0030| 00 00 00 00 00 00 00| .......| hole1: 0 0x39-0x40 (7)
0x0040|db 30 00 00 00 00 00 00 |.0...... | next_full_xid: 12507 0x40-0x48 (8)
0x0040| 00 60 00 00 | .`.. | next_oid: 24576 0x48-0x4c (4)
0x0040| 01 00 00 00| ....| next_multi: 1 0x4c-0x50 (4)
0x0050|00 00 00 00 |.... | next_multi_offset: 0 0x50-0x54 (4)
0x0050| de 01 00 00 | .... | oldest_xid: 478 0x54-0x58 (4)
0x0050| 01 00 00 00 | .... | oldest_xid_db: 1 0x58-0x5c (4)
0x0050| 01 00 00 00| ....| oldest_multi: 1 0x5c-0x60 (4)
0x0060|01 00 00 00 |.... | oldest_multi_db: 1 0x60-0x64 (4)
0x0060| 00 00 00 00 | .... | hole2: 0 0x64-0x68 (4)
0x0060| 3f c4 eb 62 00 00 00 00| ?..b....| time: "Thu, 04 Aug 2022 13:06:07 UTC" (1659618367) 0x68-0x70 (8)
0x0070|00 00 00 00 |.... | oldest_commit_ts_xid: 0 0x70-0x74 (4)
0x0070| 00 00 00 00 | .... | newest_commit_ts_xid: 0 0x74-0x78 (4)
0x0070| db 30 00 00 | .0.. | oldest_active_xid: 12507 0x78-0x7c (4)
0x0070| 00 00 00 00| ....| padding0: 0 0x7c-0x80 (4)
0x0080|e8 03 00 00 00 00 00 00 |........ | unlogged_lsn: "0/3E8" (1000) 0x80-0x88 (8)
0x0080| 00 00 00 00 00 00 00 00| ........| min_recovery_point: "0/0" (0) 0x88-0x90 (8)
0x0090|00 00 00 00 |.... | min_recovery_point_tli: 0 0x90-0x94 (4)
0x0090| 00 00 00 00 | .... | hole3: 0 0x94-0x98 (4)
0x0090| 00 00 00 00 00 00 00 00| ........| backup_start_point: "0/0" (0) 0x98-0xa0 (8)
0x00a0|00 00 00 00 00 00 00 00 |........ | backup_end_point: "0/0" (0) 0xa0-0xa8 (8)
0x00a0| 00 | . | backup_end_required: 0 0xa8-0xa9 (1)
0x00a0| 00 00 00 | ... | hole4: 0 0xa9-0xac (3)
0x00a0| 01 00 00 00| ....| wal_level: "WAL_LEVEL_REPLICA" (1) 0xac-0xb0 (4)
0x00b0|00 |. | wal_log_hints: 0 0xb0-0xb1 (1)
0x00b0| 00 00 00 | ... | hole5: 0 0xb1-0xb4 (3)
0x00b0| e8 03 00 00 | .... | max_connections: 1000 0xb4-0xb8 (4)
0x00b0| 08 00 00 00 | .... | max_worker_processes: 8 0xb8-0xbc (4)
0x00b0| 0a 00 00 00| ....| max_wal_senders: 10 0xbc-0xc0 (4)
0x00c0|00 00 00 00 |.... | max_prepared_xacts: 0 0xc0-0xc4 (4)
0x00c0| 40 00 00 00 | @... | max_locks_per_xact: 64 0xc4-0xc8 (4)
0x00c0| 00 | . | track_commit_timestamp: 0 0xc8-0xc9 (1)
0x00c0| 00 00 00 | ... | hole6: 0 0xc9-0xcc (3)
0x00c0| 08 00 00 00| ....| max_align: 8 0xcc-0xd0 (4)
0x00d0|00 00 00 00 87 d6 32 41 |......2A | float_format: 1.234567e+06 0xd0-0xd8 (8)
0x00d0| 00 20 00 00 | . .. | blcksz: 8192 0xd8-0xdc (4)
0x00d0| 00 00 02 00| ....| relseg_size: 131072 0xdc-0xe0 (4)
0x00e0|00 20 00 00 |. .. | xlog_blcksz: 8192 0xe0-0xe4 (4)
0x00e0| 00 00 00 01 | .... | xlog_seg_size: 16777216 0xe4-0xe8 (4)
0x00e0| 40 00 00 00 | @... | name_data_len: 64 0xe8-0xec (4)
0x00e0| 20 00 00 00| ...| index_max_keys: 32 0xec-0xf0 (4)
0x00f0|cc 07 00 00 |.... | toast_max_chunk_size: 1996 0xf0-0xf4 (4)
0x00f0| 00 08 00 00 | .... | loblksize: 2048 0xf4-0xf8 (4)
0x00f0| 01 | . | float8_by_val: 1 0xf8-0xf9 (1)
0x00f0| 00 00 00 | ... | hole7: 0 0xf9-0xfc (3)
0x00f0| 00 00 00 00| ....| data_checksum_version: 0 0xfc-0x100 (4)
0x0100|40 30 6a 6b 3a 01 12 b3 9c 0d aa 29 b2 39 3b e3|@0jk:......).9;.| mock_authentication_nonce: "40306a6b3a0112b39c0daa29b2393be3a10e6a9823b4df2..." (raw bits) 0x100-0x120 (32)
0x0110|a1 0e 6a 98 23 b4 df 24 8c 37 a9 12 8c 5a 12 cb|..j.#..$.7...Z..|
0x0120|47 ec c5 c2 |G... | crc: 3267750983 0x120-0x124 (4)
0x0120| 00 00 00 00 | .... | padding1: 0 0x124-0x128 (4)
0x0120| 00 00 00 00 00 00 00 00| ........| unused: raw bits 0x128-0x2000 (7896)
0x0130|00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00|................|
* |until 0x1fff.7 (end) (7896) | |
|
