Web Design: 3 Ways to Detect Slow Queries in Postgres

Wednesday, August 22, 2018

3 Ways to Detect Slow Queries in Postgres

#270 — August 22, 2018

3 Ways to Detect Slow Queries in Postgres — Make use of the slow query log, check execution plans with auto_explain, and rely on aggregate information in pg_stat_statements.

Hans-Jürgen Schönig

Transactional Data Operations in Postgres Using Common Table Expressions — Working with Common Table Expressions in Postgres is easy and straightforward. You can insert, update and delete data easily, all in one operation, within a single transaction.

Rob Conery

Ease Your Cloud Migration - Gain Agility & Maintain Control — Running Postgres databases in the cloud is not one-size-fits-all.

EnterpriseDB sponsor

How Citus's Real-Time Executor Parallelizes Postgres Queries — Citus, a Postgres extension for transparent horizontal scaling of Postgres, has to do some extra work to make distributed SQL work.

Craig Kerstiens

An Overview of AWS's RDS and Aurora Offerings for Postgres — An overview plus tips and tricks for running Postgres on Amazon RDS or Aurora.

Viorel Tabara

How to Benchmark Postgres Performance with Sysbench — Sysbench is a scriptable database and system performance benchmarking tool built on LuaJIT.

Ashraf Sharif

GraphQL with Postgres Views and Materialized Views

Hasura

Using search_path and Views to Hide Columns for Reporting with Postgres — Tips on using schemas and views to provide access to data while keeping Personally Identifiable Information (PII) hidden.

citusdata

Simplifying Recursive SQL Queries — Recursive CTEs are a great tool to simplify complex application logic. Here we see how you can use them effectively to find categories and sub categories.

Andy Kappen

Real-Time Postgres Performance Monitoring. Try Datadog Free

Datadog sponsor

pgSentinel: An Extension to Record Active Session History — For Postgres 10 and up.

Bertrand Drouvot

PostGIS 2.5.0 Release Candidate 1 Released

PostGIS Developers

Events

PostgresOpen SV 2018 — September 5-7 (San Francisco, CA) Two days packed with tutorials and presentations about PostgreSQL.

PostgresConf Silicon Valley — October 15-16 (San Jose, CA) Early bird tickets now available.

PostgreSQL Conference Europe 2018 — October 23-26 (Lisbon, Portugal)