Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.
Read OriginalThe 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.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser