Padding Tutorials
Databases
Install, configure, back up and tune relational and non-relational databases.
Filter
1 tutorial
All in this category
How to Find and Fix Slow PostgreSQL Queries with EXPLAIN ANALYZE
You will read a PostgreSQL 18 query plan, add an index that turns a 40 ms table scan into a 0.2 ms lookup, and use pg_stat_statements to find which queries deserve that effort.
Advanced · 16 min · Databases