# HeapDeck: Postgres® Monitor — PostgreSQL locks, vacuum, lag

> PostgreSQL locks, vacuum, lag (iPhone/iPad app by Vladimir Chemeris.)

- Source: https://appshunter.io/ios/app/heapdeck-postgres-monitor/id6818842593 (this page in markdown: same URL + `.md`)
- Developer: [Vladimir Chemeris](https://appshunter.io/developer/1854526571)
- Category: Developer Tools, Utilities
- Price: Free with in-app purchases
- Age rating: 4+
- Requires: iOS 17.0 · 35 MB
- Languages: Russian, American English, European Spanish, Italian, Korean, German (Germany), Brazilian Portuguese, Chinese (Traditional, Taiwan), Chinese (Simplified, China), French (France) and 1 more
- Released: 2026-10-29
- Data updated: 2026-11-08

## What is HeapDeck?

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.

## Pricing and in-app purchases

Base price: Free.

**One-time purchases**

| Purchase | Price | Type |
| --- | --- | --- |
| HeapDeck Pro | $19.99 | one-time |


## Is HeapDeck safe?

Not enough ratings yet to assess HeapDeck.

## Is HeapDeck legit?

HeapDeck: Postgres® Monitor appears legitimate, with a few gaps. The AppsHunter Legitimacy Score for HeapDeck is 65 out of 100 points across 7 verification signals from App Store and developer data.


## Version history (last 5 releases)

### 1.3.0 — 2026-11-06

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.

### 1.2.9 — 2026-11-03

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.

### 1.2.8 — 2026-11-02

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.

### 1.2.7 — 2026-10-29

HeapDeck runs full screen on iPad, with a sidebar in place of the tab bar. Locks shows the lock tree and the session side by side, with the AI assistant (Pro) on the right. Schema & Data sits next to its catalog, and the SQL console takes the full width. Forms and confirmations open as centered sheets.
Health names the tiles behind a Critical or Warning verdict and grades Autovacuum against each table's own threshold. “Explain this incident” reads the verdict and all ten tiles.
HeapDeck sends the server name in the TLS handshake, so Neon connects and verify-full accepts certificates issued for a host name. If a Supabase direct host has only an IPv6 address and your network has no IPv6, HeapDeck shows the way to the Session pooler in place of “Server unreachable”.
Paste a postgres:// URI or a key=value string into New connection, and HeapDeck fills in the form. Over SSH you can sign in with an RSA, ECDSA or Ed25519 key and its passphrase or with a Secure Enclave key, answer two-factor prompts and route through up to three hosts.
In Slow queries, a statement's detail shows the role and database behind it, its timings and I/O, and the sessions running it now. Vacuum & Bloat opens a table card with live and dead rows and the last VACUUM, autovacuum and ANALYZE.
Pull to refresh Vacuum & Bloat, Replication, Storage and Slow queries. If you leave a sheet open, the Face ID lock covers it.

### 1.0.2 — 2026-10-29

No release notes.

## More apps by Vladimir Chemeris

- [iPerf3 Client & Server](https://appshunter.io/ios/app/iperf3-client-and-server/id6755545337)
- [Open Links in Apps](https://appshunter.io/ios/app/open-links-in-apps/id6757597623)
- [Offline AI Translator & Chat](https://appshunter.io/ios/app/offline-ai-translator-and-chat/id6765833139)
- [Modbus TCP FieldKit](https://appshunter.io/ios/app/modbus-tcp-fieldkit/id6768897913)
- [MQTT Commander](https://appshunter.io/ios/app/mqtt-commander/id6779048421)
- [CacheDeck: Redis® Client](https://appshunter.io/ios/app/cachedeck-redis-client/id6783852434)

All apps by Vladimir Chemeris: https://appshunter.io/developer/1854526571

---

*Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2026-11-08.*