/usr/share/doc/pgtop/TODO is in pgtop 3.7.0-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | * Test on more platforms. Development has primarily been on Linux and some
attempts have been made on FreeBSD, OpenBSD, and OS X.
* Display status in the executor using pstack/dtract/gstack.
* Display elapsed time of currently running query.
* Display SQL statement type currently executing, i.e. SELECT, UPDATE,
VACUUM, etc.
* Display summary statistics for average query cpu time, average query elapsed
time, etc.
* Renamed number of processs to be number of connections since that is more
accurate:
5 processes: 1 running, 4 sleeping
to
5 connections: 1 running, 4 sleeping
* Display summary statistics for connections such as total number of idles
connections, etc.
* Display summary statistics for locks such as total number of granted locks,
total number of ungranted locks, etc.
* Display summary statistics for listener information such as total number of
entries in pg_listener, distinct number of entries in pg_listener, etc.
* Display screen database statistics:
SELECT datname,
SUM(numbackends) AS numbackends,
SUM(blks_read) AS reads,
SUM(tup_fetched) AS fetches,
SUM(tup_inserte + tup_update + tup_deleted) AS alterations
FROM pg_stat_database
GROUP BY datname HAVING SUM(numbackends) > 0
ORDER BY (SUM(blks_read) + SUM(tup_fetched) +
SUM(tup_inserted + tup_updated + tup_deleted)) DESC LIMIT 5;
datname | numbackends | reads | fetches | alterations
-------------+-------------+-------+---------+-------------
pgbenchtest | 1 | 3085 | 321558 | 485894
* Display the size of each database.
* Make new TPS and i/o activity and disk space usage work on remote
connections.
|