pgcenter provides convenient interface to this statistics and allow viewing statistics changes in time interval, eg. per second. The pgcenter provides fast access for database management task, such as editing configuration files, reloading services, viewing log files and canceling or terminating database backends (by pid or using state mask). However if need execute some specific operations, pgcenter can start psql session for this purposes.

pgsqlstat: report top-level postgres stats
pgsqlslower: print details about queries taking longer than N milliseconds
pgsqlslowest: print details about N slowest queries
pgsqllat: print details about query latency distribution
pgsqltxslower: print details about transactions taking longer than N milliseconds
pglockwaits: print counts of events where Postgres blocked waiting for a lock

Howto stuff


Behind the scenes

A graphical overview of Postgres ecosystem; via - Data Egret: Deep dive into postgres stats: pg_stat_database

Performace tuning

High availability





This is a recollection of the UC Berkeley Postgres project, which was led by Mike Stonebraker from the mid-1980’s to the mid-1990’s. The article was solicited for Stonebraker’s Turing Award book, as one of many personal/historical recollections. As a result it focuses on Stonebraker’s design ideas and leadership. But Stonebraker was never a coder, and he stayed out of the way of his development team. The Postgres codebase was the work of a team of brilliant students and the occasional university “staff programmers” who had little more experience (and only slightly more compensation) than the students. I was lucky to join that team as a student during the latter years of the project....

Articles / discussions

See also: Indy big data meetup notes on PostgreSQL

Missing citation