subject:"\[PERFORM\] DIsk I\/O from pg_stat_activity"

Re: [PERFORM] DIsk I/O from pg_stat_activity

2016-03-13 Thread Vladimir Borodin

> 13 марта 2016 г., в 20:39, Artem Tomyuk написал(а): > > 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

[PERFORM] DIsk I/O from pg_stat_activity

2016-03-13 Thread Artem Tomyuk

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.