kbcli bench pgbench run

Run pgbench against a PostgreSQL cluster

kbcli bench pgbench run [flags]

Examples

  # pgbench run on a cluster
  kbcli bench pgbench run pgcluster --database postgres --user xxx --password xxx
  
  # pgbench run on a cluster with different threads and different client
  kbcli bench sysbench run  pgcluster --user xxx --password xxx --database xxx --clients 5 --threads 5
  
  # pgbench run on a cluster with specified transactions
  kbcli bench pgbench run pgcluster --database postgres --user xxx --password xxx --transactions 1000
  
  # pgbench run on a cluster with specified times
  kbcli bench pgbench run pgcluster --database postgres --user xxx --password xxx --times 1000
  
  # pgbench run on a cluster with select only
  kbcli bench pgbench run pgcluster --database postgres --user xxx --password xxx --select

Options

      --clients int        The number of clients to use for pgbench (default 1)
  -h, --help               help for run
      --select             Run pgbench with select only
      --threads int        The number of threads to use for pgbench (default 1)
      --time int           The duration to run pgbench for
      --transactions int   The number of transactions to run for pgbench

Options inherited from parent commands

      --as string                      Username to impersonate for the operation. User could be a regular user or a service account in a namespace.
      --as-group stringArray           Group to impersonate for the operation, this flag can be repeated to specify multiple groups.
      --as-uid string                  UID to impersonate for the operation.
      --cache-dir string               Default cache directory (default "$HOME/.kube/cache")
      --certificate-authority string   Path to a cert file for the certificate authority
      --client-certificate string      Path to a client certificate file for TLS
      --client-key string              Path to a client key file for TLS
      --cluster string                 The name of the kubeconfig cluster to use
      --context string                 The name of the kubeconfig context to use
      --database string                database name
      --disable-compression            If true, opt-out of response compression for all requests to the server
      --host string                    the host of database
      --insecure-skip-tls-verify       If true, the server's certificate will not be checked for validity. This will make your HTTPS connections insecure
      --kubeconfig string              Path to the kubeconfig file to use for CLI requests.
      --match-server-version           Require server version to match client version
  -n, --namespace string               If present, the namespace scope for this CLI request
      --password string                the password of database
      --port int                       the port of database
      --request-timeout string         The length of time to wait before giving up on a single server request. Non-zero values should contain a corresponding time unit (e.g. 1s, 2m, 3h). A value of zero means don't timeout requests. (default "0")
  -s, --server string                  The address and port of the Kubernetes API server
      --tls-server-name string         Server name to use for server certificate validation. If it is not provided, the hostname used to contact the server is used
      --token string                   Bearer token for authentication to the API server
      --user string                    the user of database

SEE ALSO

• kbcli bench pgbench - Run pgbench against a PostgreSQL cluster

Go Back to CLI Overview Homepage.