Skip site navigation (1) Skip section navigation (2)

getting postgresql-7.4.1 statistics

From: Victor Sudakov <sudakov(at)sibptus(dot)tomsk(dot)ru>
To: "pgsql-admin(at)postgresql(dot)org(dot)pgsql-novice"(at)postgresql(dot)org
Subject: getting postgresql-7.4.1 statistics
Date: 2004-02-11 04:55:40
Message-ID: c0cckc$1c9p$1@mpeks.tomsk.su (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novice
Colleagues,

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.

-- 
Victor Sudakov,  VAS4-RIPE, VAS47-RIPN
2:5005/149(at)fidonet http://vas.tomsk.ru/

pgsql-novice by date

Next:From: Vijay RaoDate: 2004-02-12 03:26:54
Subject: createdb: undefined symbol: get_progname
Previous:From: Nabil SayeghDate: 2004-02-10 21:32:13
Subject: Re: psql scroll horizontal

pgsql-admin by date

Next:From: Tom LaneDate: 2004-02-11 06:03:50
Subject: Re: Log query results?
Previous:From: Robert CreagerDate: 2004-02-11 02:49:04
Subject: Log query results?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group