Skip to main content
Version: release-0.9

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

Go Back to CLI Overview Homepage.