#
DIFF.BLOG
New
Following
Discover
Jobs
More
Top Writers
Suggest a blog
Upvotes plugin
Report bug
Contact
About
Privacy
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 Performance
PostgreSQL Tips
Postgres
Query Optimization
Database performance
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
Lakebase Postgres branch-based restores for fast recovery at scale
Mooncake ·
Oct 1, 2026
engineering
data engineering
The insert benchmark on a small server, IO-bound workload : Postgres 19 beta1
Smalldatum Blogspot ·
Jun 17, 2026
庖丁解InnoDB
insert benchmark
pg_stat_statements: everything it can't
Radim Marek ·
Jun 3, 2026
postgresql
Query Optimization
pg_plan_alternatives: Tracing PostgreSQL’s Query Plan Alternatives using eBPF
Jan Nidzwetzki ·
Mar 4, 2026
postgresql
performance
How to Elevate Your Database Game: Supercharging Query Performance with Postgres FDW
freeCodeCamp.org ·
Feb 19, 2026
performance
postgresql
Discover more posts →
AUTHOR
Advertise
Sponsor diff.blog
Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.
Become a sponsor →
RECENT POSTS FROM THE AUTHOR
Choose how you want to continue.
Continue with GitHub
Continue with Google
By continuing, you agree to our
Privacy Policy
.