From: Kamen Stanev <hambai@gmail.com>
To: pgsql-performance@postgresql.org
Subject: query io stats and finding a slow query
Date: Fri, 21 Sep 2007 00:36:59 +0300
Message-ID: <de5063670709201436y5cbff0d0k70ade289a4c68199@mail.gmail.com> (raw)
Hi everybody,
Is there a way to find which query is doing large io operations and/or which
is using cached data and which is reading from disk. I need to see this on a
production server to localize a slow and resource eating query. The
pg_statio* tables are very handy, but don't help me at all in finding the
most disk intensive** query, just the most used table which I already knew.
And besides that, please share your experience on how do you decide which
queries to optimize and how to reorganize your database? Is there any tools
that you use to profile your database.
Regards,
Kamen Stanev
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-performance@postgresql.org
Cc: hambai@gmail.com
Subject: Re: query io stats and finding a slow query
In-Reply-To: <de5063670709201436y5cbff0d0k70ade289a4c68199@mail.gmail.com>
* 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