Postgres Pro
Downloads
Home   >   mailing lists

Increased I/O / Writes - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Increased I/O / Writes
Date
Msg-id CAE_gQfUZSg-c_vw0gwuUvK2MpH_jRBAzyed9GWwSVUZr0vhSBQ@mail.gmail.com
Whole thread Raw
Responses Re: Increased I/O / Writes  (Igor Neyman <ineyman@perceptron.com>)
Re: Increased I/O / Writes  (Edson Richter <edsonrichter@hotmail.com>)
Re: Increased I/O / Writes  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view
Hi all,

I've recently an increase IO for writes on my DB. I'm currently using PostgreSQL 9.2.
Inline images 1

I know that much improvements can be done (as I'm using SATA disks), but my question is:

Is there a way to detect the queries that are causing that?

I can use pg_stat_statements to get the most usage queries, but I was wondering how can I find the queries that are causing that much IO?

Please, if anyone can share anything.. Thanks a lot!
Lucas
Attachment

pgsql-general by date:

Previous
From: Jasim Mohd
Date:
Subject: Postgres RFC3339 datetime formatting
Next
From: Roman Khalupa
Date:
Subject: Build postgresql