PostgreSQL statement latency

From: Jelena <gjelena(at)hot(dot)ee>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL statement latency
Date: 2011-11-05 15:43:51
Message-ID: 20111105155340.9469D1590675@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

What is the right way to measure PostgreSQL statements
latencies in pgbench? I found several solutions:

1. in PostgreSQL
9.1 (for example, with an option -r) -> pgbench  -S -c 8  -t 2000 -r
pgbench

2.
http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm (is this
solution only for version 8.2.3)?

I would like to build the graph
- Latency (ms) versus Time during test. I am running PostgreSQL on
Windows 7 - How could I do it?

----------------------------
Vaata, mida põnevat telest tuleb!
minuTV.ee
www.minutv.ee

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Lai 2011-11-07 16:13:05 Re: streaming replication
Previous Message Tom Lane 2011-11-04 14:08:06 Re: Fwd: My Query to insert and retrieve takes time