HeapDeck: Postgres® Monitor

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(), root blocker on top: pid, user and app, how long it has held the lock and what it is running. • Terminate root shows how many sessions it will unblock before you confirm. HeapDeck reads the chain again before it sends anything. • To terminate a lock root, you type its pid. VACUUM AND WRAPAROUND • Distance to transaction ID wraparound, the oldest tables and the three things that hold autovacuum back: a long open transaction, an inactive replication slot and a worker stuck on a lock. • Dead tuples per table and unused indexes with the space they hold. Run VACUUM (ANALYZE) or ANALYZE on a table. ACTIVITY, REPLICATION, STORAGE, SLOW QUERIES • Every session from pg_stat_activity, waiting ones first. Swipe to cancel or terminate. • Replay lag per standby and the WAL each replication slot holds. • The biggest tables and indexes, and the heaviest statements from pg_stat_statements. DATA AND SQL • Browse tables, filter on the server, follow foreign keys, export a page as CSV or JSON, and insert, edit or delete rows. • The SQL console classifies each statement as you type. Before a destructive one runs, you type to confirm. Mark a connection Production and it gets a PROD badge and stricter checks. AI ASSISTANT • Explains an incident or a lock chain and drafts the fix with your own API key or your own Ollama. It works from a redacted snapshot, shows you what it will send, and runs nothing itself. SAFE TO POINT AT PRODUCTION • Connect to your server, or tunnel through your bastion over SSH. No HeapDeck server sits in between, and you need no account. • HeapDeck pins the TLS certificate fingerprint and, on first connect, the SSH host key. • Passwords and keys stay in the device's Keychain. Face ID or Touch ID locks the app. • Without superuser, each screen shows what your role can't see and the GRANT pg_monitor that fixes it. FREE AND PRO Free, forever: one saved connection, every monitoring screen, TLS and SSH tunnels, the data browser and read-only SQL. HeapDeck Pro, one purchase: unlimited saved connections, cancel and terminate sessions, VACUUM and ANALYZE, writes and DDL, row edits and the AI assistant. No subscription. PRIVACY Crash reports go to Sentry and usage counts to our own analytics server. Switch either off on first launch or in Settings. Neither contains your SQL, database, table or column names, hostnames, values or credentials. Works with PostgreSQL 13–19, self-hosted or managed, including Neon, Supabase and Amazon RDS. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission. HeapDeck is an independent client and is not affiliated with, endorsed by, or sponsored by the PostgreSQL Community Association of Canada, PostgreSQL Global Development Group, PostgreSQL Project, PostgreSQL Core Team, or PostgreSQL Community. Neon, Supabase and Amazon RDS are trademarks of their respective owners. HeapDeck is not affiliated with them.