API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 15th, 2019
75
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.64 KB | None | 0 0
raw download clone embed print report
  1. root@ns3017798:/usr/lib/postgresql/9.6# sudo /usr/lib/postgresql/9.6/bin/pg_xlogdump -b /var/lib/postgresql/ 9.6/main/pg_xlog/000000010000000000000002 | less
  2. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2779, lsn: 0/02000420, prev 0/01FFEAE8, desc: COMMIT 2019-12-10 18:50:44.361969 UTC
  3. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/02000448, prev 0/02000420, desc: CHECKPOINT_ONLINE redo 0/2000448; tli 1; prev tli 1; fpw true; xid 0:2780; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  4. rmgr: Heap len (rec/tot): 65/ 6573, tx: 2780, lsn: 0/020004B8, prev 0/02000448, desc: HOT_UPDATE off 26 xmax 2780 ; new off 18 xmax 0
  5. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 1684
  6.  
  7. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2780, lsn: 0/02001E68, prev 0/020004B8, desc: COMMIT 2019-12-10 18:59:34.456841 UTC
  8. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/02001E90, prev 0/02001E68, desc: CHECKPOINT_ONLINE redo 0/2001E90; tli 1; prev tli 1; fpw true; xid 0:2781; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  9. rmgr: Heap len (rec/tot): 65/ 3341, tx: 2781, lsn: 0/02001F00, prev 0/02001E90, desc: HOT_UPDATE off 5 xmax 2781 ; new off 9 xmax 0
  10. blkref #0: rel 1663/16385/16394 fork main blk 2 (FPW); hole: offset: 372, length: 4916
  11.  
  12. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2781, lsn: 0/02002C28, prev 0/02001F00, desc: COMMIT 2019-12-10 19:03:12.390211 UTC
  13. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/02002C50, prev 0/02002C28, desc: CHECKPOINT_ONLINE redo 0/2002C50; tli 1; prev tli 1; fpw true; xid 0:2782; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  14. rmgr: Heap len (rec/tot): 65/ 3533, tx: 2782, lsn: 0/02002CC0, prev 0/02002C50, desc: HOT_UPDATE off 9 xmax 2782 ; new off 10 xmax 0
  15. blkref #0: rel 1663/16385/16394 fork main blk 2 (FPW); hole: offset: 372, length: 4724
  16.  
  17. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2782, lsn: 0/02003A90, prev 0/02002CC0, desc: COMMIT 2019-12-10 19:10:20.048146 UTC
  18. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/02003AB8, prev 0/02003A90, desc: CHECKPOINT_ONLINE redo 0/2003AB8; tli 1; prev tli 1; fpw true; xid 0:2783; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  19. rmgr: Heap len (rec/tot): 65/ 6765, tx: 2783, lsn: 0/02003B28, prev 0/02003AB8, desc: HOT_UPDATE off 18 xmax 2783 ; new off 21 xmax 0
  20. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 1492
  21.  
  22. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2783, lsn: 0/020055B0, prev 0/02003B28, desc: COMMIT 2019-12-10 19:23:53.438718 UTC
  23. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/020055D8, prev 0/020055B0, desc: CHECKPOINT_ONLINE redo 0/20055D8; tli 1; prev tli 1; fpw true; xid 0:2784; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  24. rmgr: Heap len (rec/tot): 65/ 6973, tx: 2784, lsn: 0/02005648, prev 0/020055D8, desc: HOT_UPDATE off 17 xmax 2784 ; new off 22 xmax 0
  25. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 1284
  26.  
  27. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2784, lsn: 0/020071A0, prev 0/02005648, desc: COMMIT 2019-12-10 19:38:04.962594 UTC
  28. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/020071C8, prev 0/020071A0, desc: CHECKPOINT_ONLINE redo 0/20071C8; tli 1; prev tli 1; fpw true; xid 0:2785; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  29. rmgr: Heap len (rec/tot): 65/ 7173, tx: 2785, lsn: 0/02007238, prev 0/020071C8, desc: HOT_UPDATE off 25 xmax 2785 ; new off 24 xmax 0
  30. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 1084
  31.  
  32. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2785, lsn: 0/02008E58, prev 0/02007238, desc: COMMIT 2019-12-10 19:54:41.788520 UTC
  33. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/02008E80, prev 0/02008E58, desc: CHECKPOINT_ONLINE redo 0/2008E80; tli 1; prev tli 1; fpw true; xid 0:2786; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  34. rmgr: Heap len (rec/tot): 65/ 7333, tx: 2786, lsn: 0/02008EF0, prev 0/02008E80, desc: HOT_UPDATE off 16 xmax 2786 ; new off 30 xmax 0
  35. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 924
  36.  
  37. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2786, lsn: 0/0200ABB0, prev 0/02008EF0, desc: COMMIT 2019-12-10 20:05:01.550878 UTC
  38. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/0200ABD8, prev 0/0200ABB0, desc: CHECKPOINT_ONLINE redo 0/200ABD8; tli 1; prev tli 1; fpw true; xid 0:2787; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  39. rmgr: Heap len (rec/tot): 65/ 7525, tx: 2787, lsn: 0/0200AC48, prev 0/0200ABD8, desc: HOT_UPDATE off 30 xmax 2787 ; new off 31 xmax 0
  40. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 732
  41.  
  42. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2787, lsn: 0/0200C9C8, prev 0/0200AC48, desc: COMMIT 2019-12-10 20:12:21.561569 UTC
  43. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/0200C9F0, prev 0/0200C9C8, desc: CHECKPOINT_ONLINE redo 0/200C9F0; tli 1; prev tli 1; fpw true; xid 0:2788; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  44. rmgr: Heap2 len (rec/tot): 59/ 4983, tx: 0, lsn: 0/0200CA60, prev 0/0200C9F0, desc: CLEAN remxid 2787
  45. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 3268
  46.  
  47. rmgr: Heap len (rec/tot): 112/ 112, tx: 2788, lsn: 0/0200DDD8, prev 0/0200CA60, desc: HOT_UPDATE off 31 xmax 2788 ; new off 1 xmax 0
  48. blkref #0: rel 1663/16385/16394 fork main blk 3
  49. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2788, lsn: 0/0200DE48, prev 0/0200DDD8, desc: COMMIT 2019-12-10 20:45:25.098897 UTC
  50. rmgr: XLOG len (rec/tot): 106/ 106, tx: 0, lsn: 0/0200DE70, prev 0/0200DE48, desc: CHECKPOINT_ONLINE redo 0/200DE70; tli 1; prev tli 1; fpw true; xid 0:2789; oid 24577; multi 1; offset 0; oldest xid 543 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 0; online
  51. rmgr: Heap len (rec/tot): 65/ 5373, tx: 2789, lsn: 0/0200DEE0, prev 0/0200DE70, desc: HOT_UPDATE off 1 xmax 2789 ; new off 2 xmax 0
  52. blkref #0: rel 1663/16385/16394 fork main blk 3 (FPW); hole: offset: 300, length: 2884
  53.  
  54. rmgr: Transaction len (rec/tot): 34/ 34, tx: 2789, lsn: 0/0200F3F8, prev 0/0200DEE0, desc: COMMIT 2019-12-10 21:22:24.959237 UTC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!