Start_lsn | end_lsn | prev_lsn | xid | resource_manager | record_type | record_length | main_data_length | fpi_length | ![]() Test =# select start_lsn, end_lsn, prev_lsn, xid, resource_manager, record_type, record_length, main_data_length, fpi_length, description from pg_get_wal_records_info( '0/1A3E258', '0/1A58910') Select start_lsn, end_lsn, prev_lsn, xid, resource_manager, record_type, record_length, main_data_length, fpi_length, description from pg_get_wal_records_info_till_end_of_wal( '0/1A58910') +- 2022 -07 -17 10: 55: 08.627989 + 00 | 0 / 1A58910Īnalyze the workload using "pg_walinspect" extension select start_lsn, end_lsn, prev_lsn, xid, resource_manager, record_type, record_length, main_data_length, fpi_length, description from pg_get_wal_records_info( '0/1A3E258', '0/1A58910') Insert into account values( 4, 'name4', '') Ĭapture Log Sequence Number (lsn) after workload test =# select now(),pg_current_wal_lsn() Insert into account values( 3, 'name3', '') Insert into account values( 2, 'name2', '') Insert into account values( 1, 'name1', '') ![]() ![]() Test =# select now(),pg_current_wal_lsn() Create Extension create extension pg_walinspect Ĭapture Log Sequence Number (lsn) before workload select now(),pg_current_wal_lsn()
0 Comments
Leave a Reply. |