Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 183E5B5DC0A
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 20 Jun 2011 04:57:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 41255-08
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 20 Jun 2011 07:57:16 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from nm7.bullet.mail.sg1.yahoo.com (nm7.bullet.mail.sg1.yahoo.com
	[115.178.12.209])
	by mail.postgresql.org (Postfix) with SMTP id 20F54B5DBD1
	for <pgsql-performance@postgresql.org>;
	Mon, 20 Jun 2011 04:57:14 -0300 (ADT)
Received: from [115.178.12.221] by nm7.bullet.mail.sg1.yahoo.com with NNFMP;
	20 Jun 2011 07:57:13 -0000
Received: from [115.178.12.217] by tm2.bullet.mail.sg1.yahoo.com with NNFMP;
	20 Jun 2011 07:57:13 -0000
Received: from [127.0.0.1] by omp1002.mail.sg1.yahoo.com with NNFMP;
	20 Jun 2011 07:57:13 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 43935.331.bm@omp1002.mail.sg1.yahoo.com
Received: (qmail 43197 invoked by uid 60001); 20 Jun 2011 07:57:12 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1308556632; bh=g2FrctiBTi2opN7Cr8SpC3eriCcTw6MkAqdDqkxQklU=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=QAWSSyzsIJVUAdMffe4YoGPAKLs82e+XT1hK5sqFJAtdkWySVX+nYsUNS1JCnhmM2P9RMlIiibQJHhryIm6a6EJ/K7EDnDhizE+8IKW30QrKJubpPrt2O7a+HJFgysYXcSNm5vlZWzR6158BCm94vxBBDlsfY5GJFD/mKF58k0A=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=zL5dyp2yOyYqllNGyb3XrT4FoaGG11AF+2SbLtdkRArO9851mGHVqxrWBGcsUEC18PDaI4JEe+6JVvv6b2wPkIamAQWg2yJiAOypJ39vHtSeUpcYQ+2+DoN1kS0AVJ6h/LlU4OInUxpKUvMkdZ/iF4ncm9SgkjOQ1PMAVSExtbM=;
Message-ID: <821517.42508.qm@web77309.mail.sg1.yahoo.com>
X-YMail-OSG: PTS3lewVM1mr48xKEwvnSDq_Av6JwgGjim8hQaOn76kbKsU
	ZuCMSJalSs2vircK7iBkFR5HT63_FLNmb94sO4Tl7l1f6whU875eDinD43aT
	8cYPegAzpLyuKNI_KWs1kXDDFblqJX8boZMwPPpxgKW6mlWInhFbFUtE39qy
	H0o0HcUeTSKiRgjANh9qXn6bu0H2.IcYLfkoAxr8LH26kC0L.px5cpT96iq3
	Wviu1KWAS5qAYDIikcmXAGWBCZ5hCBUeZU6C3ATPJSreKvIiy6pQlCzZO3RF
	cYeEAKp9LLQfyGqSZKe..8g--
Received: from [202.169.34.218] by web77309.mail.sg1.yahoo.com via HTTP;
	Mon, 20 Jun 2011 15:57:12 SGT
X-Mailer: YahooMailRC/570 YahooMailWebService/0.8.111.304355
Date: Mon, 20 Jun 2011 15:57:12 +0800 (SGT)
From: Didik Prasetyo <prasetyodidik62@yahoo.com>
Subject: how to know slowly query in lock postgre
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1763793090-1308556632=:42508"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.003 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001,
	HTML_MESSAGE=0.001,
	RCVD_IN_BL_SPAMCOP_NET=1.347, RCVD_IN_DNSWL_NONE=-0.0001,
	RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: *
X-Archive-Number: 201106/174
X-Sequence-Number: 44107

--0-1763793090-1308556632=:42508
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

hai friend i have problem with performance database in postgre, how to know=
 =0Aslowly query in postgre,=0Ai want kill or stop query to make postgre sl=
owly, on the server status on the =0Aadmin pg, sometimes the query and how =
long the query runs do not appear=0A=0AThanks for solution=0A
--0-1763793090-1308556632=:42508
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman,new york,times,serif;fon=
t-size:12pt"><div>hai friend i have problem with performance database in po=
stgre, how to know slowly query in postgre,<br>i want kill or stop query to=
 make postgre slowly, <span id=3D"result_box" class=3D"" lang=3D"en"><span =
title=3D"Klik untuk terjemahan alternatif" class=3D"hps">on the server</spa=
n> <span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">status</s=
pan> <span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">on</spa=
n> <span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">the admin=
</span> <span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">pg</=
span><span class=3D"" title=3D"Klik untuk terjemahan alternatif">,</span> <=
span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">sometimes</sp=
an> <span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">the quer=
y</span> <span title=3D"Klik untuk
 terjemahan alternatif" class=3D"hps">and</span> <span title=3D"Klik untuk =
terjemahan alternatif" class=3D"hps">how long</span> <span title=3D"Klik un=
tuk terjemahan alternatif" class=3D"hps">the query</span> <span title=3D"Kl=
ik untuk terjemahan alternatif" class=3D"hps">runs</span> <span title=3D"Kl=
ik untuk terjemahan alternatif" class=3D"hps">do not appear<br><br>Thanks f=
or solution<br></span></span></div>=0A=0A=0A</div></body></html>
--0-1763793090-1308556632=:42508--