Technologies/PostgreSQL/active_queries
PostgreSQLPostgreSQLMetric

active_queries

Active queries
Dimensions:None
Available on:DatadogDatadog (1)
Interface Metrics (1)
DatadogDatadog
Enabled with `collect_activity_metrics`. The number of active queries in this database. This metric (by default) is tagged with db, app, user.
Dimensions:None
Sources
postgresql.active_queriesgithub.com

Technical Annotations (8)

Configuration Parameters (1)
hikaricp.cache_prepared_statementsrecommended: consider enabling
HikariCP does not support caching prepared statements, may contribute to bind phase overhead
Technical References (7)
pg_stat_activitycomponentplanidcomponentqueryidcomponentHikariCPcomponentAurora PostgrescomponentBIND phaseconceptprepared statementsconcept
Related Insights (2)
Brief CPU spike in active sessions during bind phase prevents query plan generationwarning
▸
Sessions missing queryid despite actively executing queries indicates parse/bind bottleneckwarning
▸