On Sun, Oct 7, 2012 at 7:43 AM, Ants Aasma wrote:
> On Wed, Sep 26, 2012 at 11:11 PM, Jeff Janes wrote:
>> On Wed, Sep 12, 2012 at 11:40 PM, Ants Aasma 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
On Wed, Sep 26, 2012 at 11:11 PM, Jeff Janes wrote:
> On Wed, Sep 12, 2012 at 11:40 PM, Ants Aasma 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 o
On Wed, Sep 12, 2012 at 11:40 PM, Ants Aasma wrote:
> On Wed, Sep 12, 2012 at 7:00 PM, Jeff Janes wrote:
>> Regarding the wiki page on reporting slow queries:
>> We currently recommend EXPLAIN ANALYZE over just EXPLAIN. Should we
>> recommend EXPLAIN (ANALYZE, BUFFERS) instead? I know I very of
On Wed, Sep 12, 2012 at 7:00 PM, Jeff Janes wrote:
> Regarding the wiki page on reporting slow queries:
> We currently recommend EXPLAIN ANALYZE over just EXPLAIN. Should we
> recommend EXPLAIN (ANALYZE, BUFFERS) instead? I know I very often
> wish I could see that data. I don't think turning b
Regarding the wiki page on reporting slow queries:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
We currently recommend EXPLAIN ANALYZE over just EXPLAIN. Should we
recommend EXPLAIN (ANALYZE, BUFFERS) instead? I know I very often
wish I could see that data. I don't think turning buff
