| |
| pt-proc-stat |
| ============ |
| |
| Summary |
| ------- |
| |
| Displays statistics I/O for each process. |
| |
| Usage |
| ----- |
| |
| .. code-block:: none |
| |
| pt-proc-stat [option...] [delay [count]] |
| |
| |
| ``pt-proc-stat`` Referring to proc file system. Make sure you run by running PostgreSQL user or root user. |
| |
| Options |
| ------- |
| |
| .. code-block:: none |
| |
| -D, --pgdata=DATADIR |
| -P, --pid=PID |
| --help |
| |
| ``-D``, ``--pgdata`` |
| Specifies the directory of the database cluster. |
| |
| ``-P``, ``--pid`` |
| Specifies the process ID of the postmaster process. |
| |
| When both ``-D`` (or ``--pgdata``) and ``-P`` (or ``--pid``) are not specified, ``pt-proc-stat`` searches postmaster process(es) from all the running processes, and uses it to monitor. |
| |
| If two or more postmaster processes are found, one of them will be picked at random to be monitored. |
| |
| Output Items |
| ------------ |
| |
| .. csv-table:: |
| |
| ``PROCESS NAME``, Process name |
| ``PID``, Process ID |
| ``STAT``, Status of the process |
| ``USR``, User CPU time (Difference) |
| ``SYS``, System CPU time (Difference) |
| ``VSZ``, Virtual memory size (MB) |
| ``RSS``, Usage of a physical memory (MB) |
| ``READ``, Reading I/O volume is displayed differently between both of the data(kB). |
| ``WRITE``, Writing I/O volume is displayed differently between both of the data(kB). |
| ``READ2``, Load I/O except the ``READ`` (KB / Difference) |
| ``WRITE2``, Load I/O except the ``WRITE`` (KB / Difference) |
| |
| Examples |
| -------- |
| |
| It looks for the postmaster process automatically. Statistics I/O of the postmaster and the child process is displayed every five seconds twice. |
| |
| .. code-block:: none |
| |
| $ sudo ./pt-proc-stat 5 2 |
| Fri May 1 22:23:39 JST 2015 |
| PROCESS NAME[ PID] STAT USR SYS VSZ RSS READ WRITE READ2 WRITE2 |
| postmaster[24026] S 4 13 100 9 23752 1290092 1090800 155357 |
| logger[24028] S 0 1 85 1 4 76 30 -45 |
| checkpointer[24030] S 4 117 100 8 176 56768 -176 -46965 |
| writer[24031] S 104 66 100 9 0 291080 0 130560 |
| wal writer[24032] S 8 19 100 1 0 2928 0 0 |
| autovacuum launcher[24033] S 3 3 101 2 8 8 288 0 |
| stats collector[24034] S 13 32 85 1 0 2140 34 -649 |
| snaga postgres 127.0[25473] R 32 9 101 7 296 1472 1264 0 |
| snaga postgres 127.0[25474] R 33 9 101 7 424 1384 1120 0 |
| snaga postgres 127.0[25475] R 33 9 101 7 424 1448 1016 0 |
| snaga postgres 127.0[25476] S 32 9 101 7 580 1400 780 0 |
| snaga postgres 127.0[25477] R 32 9 101 7 908 1368 492 0 |
| |
| Fri May 1 22:23:44 JST 2015 |
| PROCESS NAME[ PID] STAT USR SYS VSZ RSS READ WRITE READ2 WRITE2 |
| postmaster[24026] S 0 0 100 9 0 0 0 0 |
| logger[24028] S 0 0 85 1 0 0 0 0 |
| checkpointer[24030] S 0 0 100 8 0 0 0 0 |
| writer[24031] S 4 1 100 9 0 11928 0 392 |
| wal writer[24032] S 0 0 100 1 0 0 0 0 |
| autovacuum launcher[24033] S 0 0 101 2 0 0 0 0 |
| stats collector[24034] S 0 0 85 1 0 0 0 0 |
| snaga postgres 127.0[25473] R 72 18 101 10 1772 3608 1740 0 |
| snaga postgres 127.0[25474] R 68 20 101 10 1436 3920 2020 0 |
| snaga postgres 127.0[25475] D 70 18 101 10 1304 4216 2368 0 |
| snaga postgres 127.0[25476] R 70 20 101 10 1252 3384 2212 0 |
| snaga postgres 127.0[25477] R 73 16 101 10 1464 3224 2080 0 |
| |
| $ |