Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.

Read Original

The article details a new feature in PostgreSQL 18 that adds the measurement of time spent sleeping due to cost-based vacuum delays to the pg_stat_progress_vacuum and pg_stat_progress_analyze system views. It explains the new 'track_cost_delay_timing' configuration parameter and includes a practical demonstration with modified settings to show how the delay_time column works in monitoring vacuum operations.

Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week