HeapDeck: Postgres® Monitor — ASO

By Vladimir Chemeris on AppTrack Ninja.

PostgreSQL locks, vacuum, lag

The on-call deck for PostgreSQL on iPhone and iPad: see what's burning in your Postgres and put it out. You get paged and your laptop is at home. On Health, the first screen HeapDeck opens, you see whether the server is in trouble, and where. Tap once more to reach the session that is blocking everyone else. HEALTH • One verdict and ten tiles: sessions against max_connections, blocked sessions, the longest query, TPS, cache hit, autovacuum, wraparound, replication, database size and slow queries. • Refreshes every 10 seconds while it is open. LOCKS • The blocking tree from pg_blocking_pids(),…

Categories: Developer Tools, Utilities

Keyword visibility, ranked search terms and daily position movement for HeapDeck: Postgres® Monitor.