Monthly expert-led Postgres database health assessments with AI assistance. Get comprehensive reports, expert calls, and proactive monitoring to prevent performance issues and scale confidently.|
A toolkit for PostgreSQL professionals to input and analyze custom queries and execution plans using visualization tools, AI insights, and easy sharing capabilities.|
A monitoring solution built specifically for PostgreSQL experts who need rapid root cause analysis and deep performance insights. Combines real-time monitoring with deep analysis capabilities for human experts and AI systems.|
Recently, I have read a nice post titled "Query Progress Bar", by Brian Davis. It describes an interesting approach to observing the progress of slow query execution. At some point, the author mentions: > Don't use this in prod. And I agree. The article discusses long-running queries such as SELECTs, UPDATEs, DELETEs, and quite "invasive" methods of progress monitoring. In an OLTP production scenario, in most cases, we should try to limit the duration of such queries, setting statement_timeou...|