pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jelena <gjelena@hot.ee>
To: pgsql-admin@postgresql.org
Subject: PostgreSQL statement latency
Date: Sat, 05 Nov 2011 17:43:51 +0200
Message-ID: <20111105155340.9469D1590675@mail.postgresql.org> (raw)

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

Message-ID: <20111105155340.9469D1590675@mail.postgresql.org>
Permalink:  ../20111105155340.9469D1590675@mail.postgresql.org/
Also on:    postgresql.org/message-id/20111105155340.9469D1590675@mail.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gjelena@hot.ee
  Subject: Re: PostgreSQL statement latency
  In-Reply-To: <20111105155340.9469D1590675@mail.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox