iostat and nicstat

Now pgCenter can displays input/output statistics for disk devices and partitions and network traffic statistics. Statistics interface is identical withandutilities. Input/output statistics for disk devices includes information about IOPS, bandwidth, queue, latency and utilization. Network traffic stat displays information about bandwidth (bytes/packets), errors and interfaces utilization. By default these statistics not displayed and can be enabled (or disabled) with hostkeys.for iostat,for nicstat. Details and additional info about field’s descriptions can be obtained from

pg_stat_statements improvements

The pg_stat_statements statistics now has all information which available from pg_stat_statements view.

Resource utilization – now we can determine how cpu or input/output resources were consumed by particular type of queries.

Buffers input/output – allows to determine how many pages were read, written or dirtied in shared buffers per query (values shown in kylobytes, not in pages).

Temporary input/output – all queries which use temp files can be found and optimized (values shown in kylobytes, not in pages).

General query info – for all types of queries we can see the number of calls and returned rows.

In additional, if you interested in details of specific query, you can get detailed report about this query using his queryid (G hotkey).



