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

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 (view raw or flat)
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

pgsql-admin by date

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

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