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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-novice

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

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-2017 The PostgreSQL Global Development Group