Thread: How many updates and inserts

How many updates and inserts

From
"Campbell, Lance"
Date:

PostgreSQL: 8.2

How can I identify how many inserts and updates are being done in a given time frame for a database?

 

Thanks,

 

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

My e-mail address has changed to lance@illinois.edu

 

Re: How many updates and inserts

From
Ben
Date:
Have a look at the pg_stat_user_tables table.

On Fri, 11 Jul 2008, Campbell, Lance wrote:

> PostgreSQL: 8.2
>
> How can I identify how many inserts and updates are being done in a
> given time frame for a database?
>
>
>
> Thanks,
>
>
>
>
>
> Lance Campbell
>
> Project Manager/Software Architect
>
> Web Services at Public Affairs
>
> University of Illinois
>
> 217.333.0382
>
> http://webservices.uiuc.edu
>
> My e-mail address has changed to lance@illinois.edu
>
>
>
>