Self-managed PostgreSQL

pocketPG works with any PostgreSQL 12+ instance. No agent, extension installation, or schema changes are required.

Setup

1. Paste your PostgreSQL connection URL or configure an SSH tunnel.
2. Connect and start using all tabs immediately.

Recommended extensions

• pg_stat_statements — required for the Queries tab, tail latency insights, extension recommendations, and several tuning signals (work_mem spill, prepared statements detection). Highly recommended.

Full feature availability

All pocketPG features work on self-managed PostgreSQL:

• ALTER SYSTEM SET for applying tuning recommendations
• VACUUM / ANALYZE / REINDEX maintenance actions
• Full pg_settings access for the ALL SETTINGS tab
• pg_stat_wal (PG14+) for WAL rate metrics
• pg_stat_progress_vacuum for autovacuum worker monitoring

Version-specific features

Feature	Minimum version
Core monitoring	PostgreSQL 12
mean_plan_time in pg_stat_statements	PostgreSQL 13
hash_mem_multiplier	PostgreSQL 13
pg_stat_wal, query_id in pg_stat_activity	PostgreSQL 14
autovacuum_worker_slots	PostgreSQL 17