File: TODO

package info (click to toggle)
ptop 3.6.2-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 1,356 kB
  • ctags: 2,292
  • sloc: ansic: 18,216; sh: 3,493; makefile: 122; awk: 44
file content (54 lines) | stat: -rw-r--r-- 1,860 bytes parent folder | download | duplicates (3)
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
52
53
54
* Test on more platforms.  Development has primarily been on Linux and some
  attempts have been made on FreeBSD and Solaris.

* Use a stored procedure to get system statistics so that pg_top can be run
  remotely, as opposed to running pg_top locally in order to access the
  operating systems process table.

* 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 queries per second, average query cpu time,
  average query elapsed time, etc.

* Display i/o statistics per process.

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