title

text

Ekaterina Sokolova
Ekaterina Sokolova PostgresPro
12:35 26 October
22 min

PG_QUERY_STATE: Everything about the inner life of your queries

When working with PostgreSQL, we regularly encounter queries that take suspiciously long to be executed. What if it's too late to enable statistics or auto explain, and cancellation of the query doesn't look sensible, but you still need to find out what caused the issue or see at what stage execution the query is? pg_query_state is an open source PostgreSQL extension, which can give you access to the query execution plan in real time. It also makes available statistics for each node, including the number of processed rows.

Slides

Video

Other talks