Simon Willison’s Weblog

Subscribe

Wednesday, 3rd February 2021

Cleaning Up Your Postgres Database (via) Craig Kerstiens provides some invaluable tips on running an initial check of the health of a PostgreSQL database, by using queries against the pg_statio_user_indexes table to find the memory cache hit ratio and the pg_stat_user_tables table to see what percentage of queries to your tables are using an index.

# 7:32 am / databases, performance, postgresql, craig-kerstiens

2021 » February

MTWTFSS
1234567
891011121314
15161718192021
22232425262728