Re: Guide to Posting Slow Query Questions

From: Ants Aasma <ants(at)cybertec(dot)at>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Guide to Posting Slow Query Questions
Date: 2012-10-07 14:43:45
Message-ID: CA+CSw_upkCLVD-+h3+XWZuLdzpwQucDrANBV-uRJ3LBs11iVQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Sep 26, 2012 at 11:11 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Wed, Sep 12, 2012 at 11:40 PM, Ants Aasma <ants(at)cybertec(dot)at> wrote:
>> I don't have any links for OS level monitoring, but with version 9.2
>> track_io_timing would do the job.
>
> I don't know how to advice people on how to use this to obtain
> information on a specific query. Would someone else like to take a
> stab at explaining that?

I added a line suggesting that 9.2 users turn it on via SET
track_io_timing TO on;

Ants Aasma
--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Korisk 2012-10-07 17:33:19 hash aggregation speedup
Previous Message Ants Aasma 2012-10-07 14:27:02 Re: Same query doing slow then quick