Home > mailing lists

DIsk I/O from pg_stat_activity - Mailing list pgsql-performance

From	Artem Tomyuk
Subject	DIsk I/O from pg_stat_activity
Date	March 13, 2016 20:40:07
Msg-id	CANYYVqLuWU0HSd=2EGJ=V51U1bomUgScCUtDhzZ4XinJvuTYqw@mail.gmail.com Whole thread Raw
Responses	Re: DIsk I/O from pg_stat_activity (Vladimir Borodin <root@simply.name>)
List	pgsql-performance

Tree view

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.

pgsql-performance by date:

From: Jim Nasby
Date: 11 March 2016, 19:47:02
Subject: Re: Clarification on using pg_upgrade

From: Vladimir Borodin
Date: 13 March 2016, 20:50:50
Subject: Re: DIsk I/O from pg_stat_activity

DIsk I/O from pg_stat_activity - Mailing list pgsql-performance

Previous

Next