top of page
logo-cerebrosql

STANDBY STATUS node for PostgreSQL

The state of the processes of translation of operations to backup servers

[CerebroSQL] Tree object for PostgreSQL - standby standby
List of Sessions Replication Operations

SELECT pid,
      usesysid,
      usename,
      application_name,
      client_addr::text,
      client_hostname::text,
      client_port,
      backend_start,
      backend_xmin,
      state,
      sent_lsn::text,
      write_lsn::text,
      flush_lsn::text,
      replay_lsn::text,
      write_lag::text,
      flush_lag::text,
      replay_lag::text,
      sync_priority,
      sync_state,
      reply_time,
      pg_current_wal_lsn()::text "current_wal_lsn"
 FROM pg_stat_replication

bottom of page