On Mar 20, 2009, at 5:26 AM, ml(at)bortal(dot)de wrote:
> Hello List,
> is there a way to find out, how many transactions my currenc
> productive database is doing?
> I know know how much i an offer with my new database and hardware,
> but i would also like to know what i actually _need_ on my current
> productive system.
> Is there a way to find this out?
Are you looking to see how many transactions per second or more how
many transactions concurrently at a given time?
For the former you can use pgspy (its on pgfoundry) to get an idea of
queries per second coming in.
For the latter, just select * from pg_stat_activity where
current_query <> '<IDLE>';
Jeff Trout <jeff(at)jefftrout(dot)com>
In response to
pgsql-performance by date
|Next:||From: Anne Rosset||Date: 2009-03-20 17:16:02|
|Subject: Re: Need help with one query|
|Previous:||From: Tom Lane||Date: 2009-03-20 15:55:45|
|Subject: Re: Proposal of tunable fix for scalability of 8.4 |