Disk usage warnings

[pgiraud]

[Krysztophe]

Ideas of I/O intensive operations, as just discussed:

• temp files due to sorting ( https://explain.dalibo.com/plan/pES ) or hash joins ( https://explain.dalibo.com/plan/f0S )

• temporary tables ( "local" buffers, see https://explain.dalibo.com/plan/3yw or https://explain.dalibo.com/plan/jK0 )

• read and written blocks (see https://explain.dalibo.com/plan/Zje)

In the above examples, the Buffers read/written/temp indicate the amount of I/O.

For the duration:

• If  track_io_timnig = on, the ''I/O Timing'' entry can indicate which node takes the most I/O time (see all above examples).