DIsk I/O from pg_stat_activity

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: DIsk I/O from pg_stat_activity
Date: 2016-03-13 17:39:38
Message-ID: CANYYVqLuWU0HSd=2EGJ=V51U1bomUgScCUtDhzZ4XinJvuTYqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all.

Is there any way of how to retrieve information from pg_stat_activity (its
not very comfort to get it from iotop, because its not showing full text of
query) which query generates or consumes the most IO load or time.

Thanks for any advice.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vladimir Borodin 2016-03-13 17:50:42 Re: DIsk I/O from pg_stat_activity
Previous Message Jim Nasby 2016-03-11 16:46:42 Re: Clarification on using pg_upgrade