~/talk

Debugging active queries...

on YouTube 47m
Talkat PostgreSQL Conference Europe 2024 · 2024-10-22..10-25· [databases]

speaker

name:Rafael Thofehrn Castro
links:none on file

resources

video:https://youtu.be/6ahTb-7C05c
slides:none on file

summary

A patch logs instrumented EXPLAIN ANALYZE plans mid-flight to a catalog view (pg_explain_activity) at a configurable interval (default track_explain_interval = 10ms), cloning instrumentation state in a temporary memory context to avoid corrupting running queries. Demo prints the plan 2,231 times with ~9ms total logging overhead, and a local single‑page app visualizes per‑node rows and timing in real time. Works only for instrumented executions and requires enabling the track flag; proposed as experimental, not yet upstream.

AI-written summary · about

chapters (6)

  1. 0:00Introduction
  2. 3:01Query analysis challenges
  3. 11:01Existing troubleshooting features
  4. 16:59Analyzing running queries
  5. 26:40Experimental patch demo
  6. 43:44Patch limitations and Q&A

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.