show-clockskew v5

Shows the status of clock skew between each BDR node pair.

Synopsis

Shows the status of clock skew between each BDR node pair in the cluster.

Please note that the current implementation of clock skew may return an inaccurate skew value if the cluster is under high load while running this command or has large number of nodes in it.

Symbol      Meaning
-------     --------
*           ok
~           warning (skew > 2 seconds)
!           critical (skew > 5 seconds)
x           down / unreachable
?           unknown
-           n/a
pgd show-clockskew [flags]

Examples

  Example 1 (3 node cluster, bdr-a1 and bdr-c1 are up, bdr-b1 is down)

  $ pgd show-clockskew

  Node   bdr-a1 bdr-b1 bdr-c1 Current Time
  ----   ------ ------ ------ ------------
  bdr-a1 *      ?      *      2022-03-30 07:02:21.334472
  bdr-b1 x      *      x      x
  bdr-c1 *      ?      *      2022-03-30 07:02:21.186809


  Example 2 (3 node cluster, all nodes are up)

  $ pgd show-clockskew

  Node   bdr-a1 bdr-b1 bdr-c1 Current Time
  ----   ------ ------ ------ ------------
  bdr-a1 *      *      *      2022-03-30 07:04:54.147017
  bdr-b1 *      *      *      2022-03-30 07:04:54.340543
  bdr-c1 *      *      *      2022-03-30 07:04:53.90451

Options

  -h, --help   help for show-clockskew

Options inherited from parent commands

  -f, --config-file string   config file; ignored if 
                             --dsn flag is present (default "/etc/edb/pgd-cli/pgd-cli-config.yml")
      --dsn string           database connection string
                             e.g."host=bdr-a1 port=5432 dbname=bdrdb user=postgres "
  -L, --log-level string     logging level: debug, info, warn, error (default "error")
  -o, --output string        output format: json, yaml