DIsk I/O from pg_stat_activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: DIsk I/O from pg_stat_activity
From: Artem Tomyuk <admin@xxxxxxxxxxxxxx>
Date: Sun, 13 Mar 2016 19:39:38 +0200

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.

Follow-Ups:
- Re: DIsk I/O from pg_stat_activity
  - From: Vladimir Borodin

Prev by Date: Re: Clarification on using pg_upgrade
Next by Date: Re: DIsk I/O from pg_stat_activity
Previous by thread: using stale statistics instead of current ones because stats collector is not responding
Next by thread: Re: DIsk I/O from pg_stat_activity
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux