Hi,
I am reindexing my 7.1.4 postgres database. The postmaster seems to
create processes for each reindex request. Is there any way to find
out more about the processes.
ps -aef | grep postgres
yields the following, but does not tell me which table is being
reindexed or anything meaningful
about the process.
postgres 605 604 0 Feb 18 ? 0:00 /usr/local/pgsql/
bin/postmaster
postgres 5599 579 0 Feb 21 ? 39:12 /usr/local/pgsql/
bin/postmaster
postgres 20101 579 0 10:56:52 ? 0:58 /usr/local/pgsql/
bin/postmaster
postgres 579 1 0 Feb 18 ? 0:02 /usr/local/pgsql/
bin/postmaster
postgres 604 579 0 Feb 18 ? 0:00 /usr/local/pgsql/
bin/postmaster
dspace 21563 21391 0 13:27:00 pts/3 0:00 grep postgres
postgres 5645 579 0 Feb 21 ? 35:29 /usr/local/pgsql/
bin/postmaster
postgres 19695 579 0 10:13:22 ? 2:51 /usr/local/pgsql/
bin/postmaster
postgres 19713 579 0 10:15:02 ? 2:43 /usr/local/pgsql/
bin/postmaster
postgres 7441 579 0 Feb 21 ? 33:49 /usr/local/pgsql/
bin/postmaster
postgres 19963 579 0 10:42:25 ? 1:43 /usr/local/pgsql/
bin/postmaster
postgres 19658 579 0 10:09:56 ? 2:52 /usr/local/pgsql/
bin/postmaster
postgres 19981 579 0 10:44:43 ? 2:20 /usr/local/pgsql/
bin/postmaster
postgres 6276 579 0 Feb 21 ? 39:12 /usr/local/pgsql/
bin/postmaster
postgres 19667 579 0 10:10:56 ? 2:25 /usr/local/pgsql/
bin/postmaster
postgres 5654 579 0 Feb 21 ? 36:36 /usr/local/pgsql/
bin/postmaster
postgres 5657 579 20 Feb 21 ? 33:06 /usr/local/pgsql/
bin/postmaster
postgres 5656 579 0 Feb 21 ? 39:17 /usr/local/pgsql/
bin/postmaster
postgres 6216 579 0 Feb 21 ? 31:02 /usr/local/pgsql/
bin/postmaster
postgres 7508 579 0 Feb 21 ? 29:03 /usr/local/pgsql/
bin/postmaster
postgres 20159 579 0 11:03:25 ? 2:22 /usr/local/pgsql/
bin/postmaster
postgres 6275 579 0 Feb 21 ? 35:12 /usr/local/pgsql/
bin/postmaster
postgres 7474 579 0 Feb 21 ? 32:07 /usr/local/pgsql/
bin/postmaster
postgres 19884 579 0 10:33:52 ? 1:38 /usr/local/pgsql/
bin/postmaster
postgres 5655 579 0 Feb 21 ? 35:42 /usr/local/pgsql/
bin/postmaster
postgres 20100 579 0 10:56:43 ? 2:04 /usr/local/pgsql/
bin/postmaster
postgres 5598 579 0 Feb 21 ? 40:22 /usr/local/pgsql/
bin/postmaster
postgres 20259 579 0 11:15:33 ? 2:04 /usr/local/pgsql/
bin/postmaster
postgres 19696 579 19 10:13:57 ? 2:07 /usr/local/pgsql/
bin/postmaster
postgres 7509 579 0 Feb 21 ? 34:43 /usr/local/pgsql/
bin/postmaster
postgres 19946 579 0 10:40:11 ? 1:12 /usr/local/pgsql/
bin/postmaster
postgres 20006 579 0 10:47:06 ? 2:17 /usr/local/pgsql/
bin/postmaster
postgres 6258 579 0 Feb 21 ? 40:08 /usr/local/pgsql/
bin/postmaster
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
