https://www.p99conf.io/session/measuring-query-latency-the-hard-way-an-adventure-in-impractical-postgres-monitoring/
Measuring Query Latency the Hard Way: An Adventure in Impractical Postgres Monitoring - P99 CONF
Sampling pg_stat_activity reveals insights into Postgres workloads but pitfalls in measuring latency.
query latencyhard way
https://www.p99conf.io/session/java-heap-memory-optimization-improve-p99-query-latency-linkedin-scale/
Java Heap Memory Optimization to Improve P99 Query Latency at Linkedin Scale - P99 CONF
java heapmemory optimization
https://link.springer.com/article/10.1007/s00778-022-00741-5?error=cookies_not_supported&code=7de8a487-dd0e-44ea-9317-a9ed8be85592
Low-latency query compilation | The VLDB Journal
May 10, 2022 - Query compilation is a processing technique that achieves very high processing speeds but has the disadvantage of introducing additional compilation latenc
low latencyquerycompilation