X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D003DD1D5B0 for ; Fri, 13 Feb 2004 04:16:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 33686-01 for ; Fri, 13 Feb 2004 00:16:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 28FC4D1D27C for ; Fri, 13 Feb 2004 00:16:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i1D4GZ1Y068746 for ; Fri, 13 Feb 2004 04:16:35 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i1D409l2066060 for pgsql-admin@postgresql.org; Fri, 13 Feb 2004 04:00:09 GMT From: Victor Sudakov X-Newsgroups: comp.databases.postgresql.admin Subject: Re: getting postgresql-7.4.1 statistics Date: Fri, 13 Feb 2004 03:54:38 +0000 (UTC) Organization: AO "Svyaztransneft", SibPTUS Lines: 31 Message-ID: References: <5.1.0.14.2.20040212165313.033dee28@imap.eldocomp.com> X-Complaints-To: noc@sibptus.tomsk.ru X-Comment-To: nwalker@eldocomp.com (Naomi Walker) X-PGP-Key: http://vas.tomsk.ru/vas.asc User-Agent: tin/1.5.16-20030125 ("Bubbles") (UNIX) (FreeBSD/4.7-RELEASE-p24 (i386)) To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/216 X-Sequence-Number: 12390 Naomi Walker wrote: > >> >How do I get the postgresql statistics? I would like to know queries >> >per second etc. >> > >> >The stats_start_collector variable is on, and I can see the >> >stats collector process running. But how do I query it? >> > >> >Thanks a lot for any input. >> >>Check out www.postgresql.org/docs/7.3/static/monitoring-stats.html. >> >>There are several views and functions available for querying stats, like >>pg_stat_activity, pg_stat_database. In pgsql, try "select * from >>pg_stat_activity;", etc. I still cannot find the average number of queries per second. Could you please be more specific. >> >---------------------------(end of broadcast)--------------------------- >> >TIP 3: if posting/reading through Usenet, please send an appropriate >> > subscribe-nomail command to majordomo@postgresql.org so that your >> > message can get through to the mailing list cleanly By the way this advice does not work. Majordomo says: The command mode "nomail" is invalid. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/149@fidonet http://vas.tomsk.ru/