Age | Commit message (Collapse) | Author |
|
|
|
Configure PostgreSQL using --with-openssl flag to build libpq library
such that pg_top can use SSL connections from the AppImage.
|
|
Follow up to f3a30cd1b356b37e44f8b2c5bb1a564a906a3dfd.
|
|
Some Linux distros may need _GNU_SOURCE explicitly defined in order to
use reallocarray() in. Ubuntu 18.01 is one of them.
|
|
|
|
|
|
|
|
* Updated on OpenBSD 6.7
* add replication view
* update activity view
* Username column now reflects the Postgres role.
* State column now reflects Postgres backend state.
* Transaction (XTIME) and query (QTIME) execution time has been added.
* Added LOCKS column showing number of locks acquired per process.
* Removed column relating to priority and nice.
|
|
|
|
|
|
Set of various machines as we go since displaying i/o stats per process
is going to be operating system dependent.
|
|
|
|
|
|
|
|
|
|
Removed column relating threads, priority and nice. These tends not
necessarily be of interest to Postgres as a processed base application
that is generally not niced or prioritized.
Username column now reflects the Postgres role.
State column now reflects Postgres backend state.
Transaction (XTIME) and query (QTIME) execution time has been added.
Added LOCKS column showing number of locks acquired per process.
|
|
The changes that were previously restricted for Linux should be applied
to all machines. There shouldn't be any reason that the updates can't
be applied to some degree on all platform.
|
|
|
|
This will hopefully make updating various machine files easier.
|
|
This will hopefully make updating various machine files easier.
|
|
|
|
|
|
Previously hid anything that was 0, which would display anything that
was negative. I think it's useful to see values that are 0 and then to
use negative values to indicate that a statistic isn't available.
|
|
Redid the bulk of that changes in
7b98b287f95fed34719e0bd30a1e77a34ecd2d26 to conform with the
infrastructure already in place.
|
|
|
|
|
|
Add a column for the schema name and index name.
| database | schema | table | index | type | granted
--+----------+--------+-------+--------+-----------------+--------
1 | mark | public | | a_pkey | AccessShareLock | t
2 | mark | public | a | | AccessShareLock | t
Previously the schema was not being shown and tables and indexes were
being shown in the same column.
|
|
|
|
|
|
The update and initialization functions were not coloring the same parts
of the text.
|
|
|
|
With minor updates in usage() output to match the command line text
with the options test.
|
|
The usage() function was missing -R and -X.
|
|
I don't think it make sense to show the raw cumulative numbers from the
operative system, except for debugging. It should be more meaningful
to see the rate of change.
|
|
I think people primarily want to see i/o operations and throughput that
is actually going to storage. Also fixed the calculations to display
rates per second as opposed to just the difference between snapshots of
data.
|
|
Currently only working with Linux.
|
|
|
|
|
|
|
|
Sorting was incorrectly comparing absolute values instead of the change
of values.
|
|
|
|
|
|
|
|
Display only locks against relations/tables.
|
|
This sets the isolation level just for pg_top.
|
|
|
|
|
|
|
|
|
|
If no PGHOST is in the environment, set it to search multiple unixsock
directories.
|