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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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

2. (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!

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-2017 The PostgreSQL Global Development Group