HeapDeck: Postgres® Monitor

PostgreSQL locks, vacuum, lag

Free · In‑App Purchases · Designed for iPad. Not verified for macOS.

Your Postgres pages you and the laptop is at home. See who's blocking, how close wraparound is and which replica lags, then stop the root blocker from your iPhone. 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.

  • This app hasn’t received enough ratings or reviews to display an overview.

HeapDeck has a new icon. Works with PostgreSQL 19. The SQL console asks you to type the table name before CLUSTER or the new REPACK command runs. Both rewrite the table and block reads and writes on it until they finish. REPACK (CONCURRENTLY) blocks for a moment at the end. After it commits, a transaction with an older snapshot sees the table as empty.

The developer, Vladimir Chemeris, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Linked to You

    The following data may be collected but it is not linked to your identity:

    • Usage Data
    • Diagnostics

Privacy practices may vary, for example, based on the features you use or your age. Learn More

The developer has not yet indicated which accessibility features this app supports. Learn More

Seller
Vladimir Chemeris
Size
37.1 MB
Category
Developer Tools
Compatibility
Requires iOS 17.0 or later.
  • iPhone
    Requires iOS 17.0 or later.
  • iPad
    Requires iPadOS 17.0 or later.
  • Mac
    Requires macOS 14.0 or later and a Mac with Apple M1 chip or later.
Languages
English and 10 more
  • English, French, German, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese, Spanish, Traditional Chinese
Age Rating
4+
In-App Purchases
Yes
Copyright
© 2026 Vladimir Chemeris