PostgreSQL statement latency - Mailing list pgsql-admin

From Jelena
Subject PostgreSQL statement latency
Date
Msg-id 20111105155340.9469D1590675@mail.postgresql.org
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: My Query to insert and retrieve takes time
Next
From: Alex Lai
Date:
Subject: Re: streaming replication