---
title: "3 Ways to Detect Slow Queries in Postgres"
publication: "Postgres Weekly"
issue: 270
published_at: "2018-08-22"
canonical_url: "https://postgresweekly.com/issues/270"
---

The latest Postgres news, articles, tools, and projects.       

#270 — August 22, 2018 

[Read on the Web](https://postgresweekly.com/issues/270)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/wp66tdk7wd99p4wqrsgu.jpg)](https://www.cybertec-postgresql.com/en/3-ways-to-detect-slow-queries-in-postgresql/)  

[3 Ways to Detect Slow Queries in Postgres](https://www.cybertec-postgresql.com/en/3-ways-to-detect-slow-queries-in-postgresql/) — 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](https://rob.conery.io/2018/08/13/transactional-data-operations-in-postgresql-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   [![\](https://copm.s3.amazonaws.com/3619f4c3.jpg)](https://www.enterprisedb.com/cloud) 

[Ease Your Cloud Migration - Gain Agility & Maintain Control](https://www.enterprisedb.com/cloud) — Running Postgres databases in the cloud is not one-size-fits-all. 

EnterpriseDB sponsor   

[How Citus's Real-Time Executor Parallelizes Postgres Queries](https://www.citusdata.com/blog/2018/08/17/breaking-down-citus-real-time-executor/) — 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](https://severalnines.com/blog/overview-amazon-rds-aurora-offerings-postgresql) — An overview plus tips and tricks for running Postgres on Amazon RDS or Aurora. 

Viorel Tabara   

[How to Benchmark Postgres Performance with Sysbench](https://severalnines.com/blog/how-benchmark-postgresql-performance-using-sysbench) — [Sysbench](https://github.com/akopytov/sysbench) is a scriptable database and system performance benchmarking tool built on LuaJIT. 

Ashraf Sharif   

[GraphQL with Postgres Views and Materialized Views](https://blog.hasura.io/postgres-views-and-materialized-views-with-graphql-fd75680888b8?source=rss------postgres-5&gi=83dba784ce0e) 

Hasura   

[Using search_path and Views to Hide Columns for Reporting with Postgres](https://www.citusdata.com/blog/2018/07/03/masking-columns-in-postgresql/) — Tips on using schemas and views to provide access to data while keeping Personally Identifiable Information (PII) hidden. 

citusdata   

[Simplifying Recursive SQL Queries](https://haughtcodeworks.com/blog/software-development/recursive-sql-queries-using-ctes/) — 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](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyB) 

Datadog sponsor   

[pgSentinel: An Extension to Record Active Session History](https://github.com/pgsentinel/pgsentinel) — For Postgres 10 and up. 

Bertrand Drouvot   

[PostGIS 2.5.0 Release Candidate 1 Released](http://postgis.net/2018/08/19/postgis-2.5.0rc1/) 

PostGIS Developers  

Events  

[PostgresOpen SV 2018](https://2018.postgresopen.org/) — **September 5-7 (San Francisco, CA)** Two days packed with tutorials and presentations about PostgreSQL.    

[PostgresConf Silicon Valley](https://blog.pgconf.us/2018/08/postgresconf-silicon-valley-early-bird.html) — **October 15-16 (San Jose, CA)** Early bird tickets now available.    

[PostgreSQL Conference Europe 2018](https://2018.pgconf.eu/) — **October 23-26 (Lisbon, Portugal)**          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom