PostgreSQL CPU and I/O tracking
We've added 4 new columns to Insights for PostgreSQL databases to track per-query pattern CPU and I/O utilization. The new columns are:
- CPU Time - the cumulative CPU time
- I/O Time - the cumulative I/O time
- % CPU time - the percent of all CPU time consumed (query pattern CPU time / cumulative CPU time of all queries)
- % I/O time - the percent of all I/O time consumed (query pattern I/O time / cumulative I/O time of all queries)
Note: To see the I/O columns, you'll need to first enable the track_io_timing
parameter in your database's cluster configuration.