#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Sign up
The home for great developer writing.
We surface the best developer writing from thousands of independent blogs, updated daily.
Join Diff.blog
TOPICS
How to Tell Whether Your Slow Query Is a Planning or an Execution Problem
·
Timescale
·
Aug. 21, 2026, 4:02 p.m.
PostgreSQL Tips
PostgreSQL Performance
Postgres
Database performance
Query Optimization
EXPLAIN ANALYZE
Summary
The blog post explains how to diagnose slow Postgres queries by analyzing the Planning Time and Execution Time provided by the EXPLAIN ANALYZE command, helping developers identify whether the issue lies in the query planning or execution phase.
Read full post on www.tigerdata.com →
MORE POSTS LIKE THIS
How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries
Timescale ·
Jun 29, 2026
postgresql
PostgreSQL Performance
The insert benchmark on a small server, IO-bound workload : Postgres 19 beta1
Smalldatum Blogspot ·
Jun 17, 2026
Postgres
mysql
pg_stat_statements: everything it can't
Radim Marek ·
Jun 3, 2026
postgresql
Database performance
pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF
Jan Nidzwetzki ·
Mar 4, 2026
performance
postgresql
How to Elevate Your Database Game: Supercharging Query Performance with Postgres FDW
freeCodeCamp.org ·
Feb 19, 2026
performance
postgresql
Autoscaling Lakebase Postgres
Mooncake ·
Aug 31, 2026
engineering
data engineering
Discover more posts →
AUTHOR
Sponsored
Zulip
Organized team chat for people who take work seriously. Topic-based threading keeps conversations focused.
Try Zulip
Become a sponsor →
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub
Continue with Google