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

Re: current transaction in productive database

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: ml(at)bortal(dot)de
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: current transaction in productive database
Date: 2009-03-20 17:01:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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 RossetDate: 2009-03-20 17:16:02
Subject: Re: Need help with one query
Previous:From: Tom LaneDate: 2009-03-20 15:55:45
Subject: Re: Proposal of tunable fix for scalability of 8.4

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