blob: 4bade5b9fdf3aeb5d22812a1c3855157150b7348 [file] [log] [blame]
Usage: pt-config [option...] [command] [param [value]]
Commands:
get [PARAM] Get a current value of a parameter.
set [PARAM] [VALUE] Set a new value for a parameter.
disable [PARAM] Comment a parameter out.
Options:
-D, --pgdata=PGDATA Specify a PostgreSQL database cluster.
--apply Apply change(s).
--help Print this help.
Usage: pt-index-usage [option...]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
-o, --owner=STRING Owner name
-n, --schema=STRING Schema name
-t, --table=STRING Table name
-i, --index=STRING Index name
--help Print this help.
Usage: pt-kill [option...] [command] [pid]
Commands:
cancel Cancel a running query.
terminate Terminate a backend with canceling query.
Options:
--help Print this help.
Usage: pt-proc-stat [option...] [delay [count]]
Options:
-D, --pgdata=DATADIR Location of the database storage area
-P, --pid=PID Process ID of the postmaster
--help Print this help.
Usage: pt-replication-stat [option...] [delay [count]]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
--help Print this help.
Usage: pt-session-profiler [option...]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-i STRING Interface name to listen
-T, --threshold=NUMBER Threashold of query elapsed time (in millisecond)
--help Print this help.
Usage: pt-set-tablespace [option...] [tablespace]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
-o, --owner=STRING Owner name
-n, --schema=STRING Schema name
-t, --table=STRING Table name
-l, --list List table spaces
--apply Apply change(s)
--help Print this help.
Usage: pt-snap-statements [option...] [interval]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
-t, --top=NUMBER Number of queries to be listed
-R, --reset Reset statistics
--help Print this help.
Usage: pt-stat-snapshot [option...] install
pt-stat-snapshot [option...] create [level]
pt-stat-snapshot [option...] list
pt-stat-snapshot [option...] delete [sid]
pt-stat-snapshot [option...] export [file]
pt-stat-snapshot [option...] import [file]
pt-stat-snapshot [option...] uninstall
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
--help Print this help.
Usage: pt-table-usage [option...]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
-o, --owner=STRING Owner name
-n, --schema=STRING Schema name
-t, --table=STRING Table name
--help Print this help.
Usage: pt-tablespace-usage [option...]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
--help Print this help.
Usage: pt-verify-checksum [option...] [file]
pt-verify-checksum [option...] [directory]
Options:
-r, --recursive Find files recursively.
-v, --verbose Enable verbose output.
--help Print this help.
Usage: pt-xact-stat [option...] [delay [count]]
Options:
-h, --host=HOSTNAME Host name of the postgres server
-p, --port=PORT Port number of the postgres server
-H, --host-list=HOSTLIST List of pairs of hostname and port number
(c.f. host1:port1,host2:port2)
-U, --username=USERNAME User name to connect
-d, --dbname=DBNAME Database name to connect
--help Print this help.