Query insights

PgDog Enterprise provides visibility into all queries that it serves, which allows it to analyze and report how those queries perform, in real-time.

Telemetry

PgDog Enterprise collects the following telemetry:

Telemetry	Frequency	Description
Active queries	real time	Queries actively executing through the proxy.
Query plans	sample / threshold	Query plans (EXPLAIN output) are collected for slow queries and sampled queries automatically.
Query statistics	real time	Query duration, number of rows returned, idle-in-transaction time, errors, and more.
Errors	real time	View into recently encountered query errors, like syntax errors or lock timeouts.

This data is transmitted to the control plane in real-time, which makes it available via its web dashboard and HTTP API.