| |
| 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. |
| |