/usr/share/doc/pgtop/FAQ is in pgtop 3.7.0-2build2.
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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 | pg_top
Version 3.7.0
Frequently Asked Questions and their Answers
GENERAL
1. What is pg_top?
pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to top,
pg_top allows you to monitor PostgreSQL processes. It also allows you to:
* View currently running SQL statement of a process.
* View query plan of a currently running SELECT statement.
* View locks held by a process.
* View user table statistics.
* View user index statistics.
2. Where do I get the latest version of pg_top?
If you have git, you can checkout the latest at:
git clone git://git.postgresql.org/git/pg_top.git
3. Is there a web page for pg_top?
http://ptop.projects.postgresql.org/
4. Is there a mailing list or on-line bulletin board for pg_top?
Subscribe or browse the archives of ptop-hackers at:
http://lists.pgfoundry.org/mailman/listinfo/ptop-hackers
5. What about Y2K/Year 2038 compliance?
A full statement concerning top and the year 2000 can be found in the file
"Y2K" included with the distribution.
6. Will there be another major release of pg_top? Will there be a pg_top
version 4?
We hope so! Depends on how much fun we have. :)
7. We just upgraded our operating system to a new version and pg_top broke.
What should we do?
Recompile it. pg_top is very sensitive to changes in internal kernel
data structures. It is not uncommon for a new version of the
operating system to include changes to kernel data structures.
RUNNING
8. I just finished compiling top and it works fine for root, but when I
try to run it as a regular user it either complains about files it
can't open or it doesn't display all the information it should. Did I
do something wrong?
Well, you're just not done. On many operating systems today, access
to many of the kernel memory devices and other system files is
restricted to either root or a particular group. The configure script
figures this out (usually) and makes sure that the "install" rule in
the Makefile will install top so that anyone can run it successfully.
However, you have to *install* it first. Do this with the command
"make install".
9. pg_top is (not) displaying idle processes and I don't (do) want it to.
This default has only changed about a dozen times, and I finally got
tired of people whining about it. Go read the manual page for the
current version and pay special attention to the description of the
"PG_TOP" environment variable.
10. The cpu state percentages are all wrong, indicating that my machine
is using 95% system time when it is clearly idle. What's wrong?
This can happen if you compiled with gcc using the wrong include
files. See the previous question.
STILL STUCK
11. I'm still stuck. To whom do I report problems with top?
If after reading all of this file and checking everything you can you
are still stuck, then please refer to the mailing to ask further
questions:
http://lists.pgfoundry.org/mailman/listinfo/ptop-hackers
|