Homepage on Valerie Parham-Thompson: Database architecture for teams ready to launch and scale · Jun 4, 2026
Analyzing Postgres Tables
0Sign in to vote or save
This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.
In my previous blog post, I used analyze after defining extended statistics . But why do we run this statement? When you run analyze on a postgres table, the pg_statistic table (and therefore the pg_stats view) gets updated. Those statistics give insight into the size and shape of the data in the tables so the query planner can choose an optimal lookup path. It is executed in the background during…
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.