PostgreSQL Extract Is Having Huge Checkpoint Lag But There Is No DML Operation At Source PostgreSQL Database (Doc ID 2795865.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

PostgreSQL Extract is having huge/strange checkpoint lag but there is no DML operation at source PostgreSQL Database:

GGSCI (ogg-hub.xxxxx.xx as <ogguser>@test) 31> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      STOPPED
PMSRVR      STOPPED
EXTRACT     RUNNING     <EXT_NAME>    26:29:32      00:00:00
EXTRACT     RUNNING     <EXT1_NAME>    451394:31:31  00:00:03
EXTRACT     RUNNING     <EXT2_NAME>    451394:31:33  00:00:02
EXTRACT     RUNNING     <EXT3_NAME>    26:29:31      00:00:01

Extract status will show at EOF/end of file:

GGSCI (ogg-hub.xxxxx.xx as <ogguser>@test) 6> send extract <EXT_NAME>, status

Sending STATUS request to EXTRACT <EXT_NAME> ...
EXTRACT <EXT_NAME> (PID <XXXX>)
  Current status: Recovery complete: At EOF

  Current read position:
  LSN: <XXXX/XX00X722>
  Timestamp: 2021-05-12 02:11:46.195582

  Current write position:
  Sequence #: 4
  RBA: 44222
  Timestamp: 2021-05-12 09:11:51.350446
  Extract Trail: ./dirdat/r1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.