# psq - postgres monitor utility — quick pg performance monitor

> Real-time PostgreSQL database performance monitoring utility for iOS devices. (iPhone/iPad app by BENJAMIN SANBORN CURRIE.)

- Source: https://appshunter.io/ios/app/psq-postgres-monitor-utility/id6757760191 (this page in markdown: same URL + `.md`)
- Developer: [BENJAMIN SANBORN CURRIE](https://appshunter.io/developer/1868745384)
- Category: Developer Tools, Utilities
- Price: Free
- Rating: 5.00/5 from 1 App Store ratings
- Age rating: 4+
- Requires: iOS 26.0 · 11 MB
- Languages: American English
- Released: 2026-01-16
- Data updated: 2026-06-01
- Monetization: free
- User reviews in markdown: https://appshunter.io/ios/app/psq-postgres-monitor-utility/id6757760191/reviews.md

## What is psq?

# psq4ios - PostgreSQL Monitor

Monitor your PostgreSQL databases in real-time, directly from your iPhone or iPad.

## Overview

psq4ios brings professional PostgreSQL monitoring to iOS. Connect securely to your databases and get instant visibility into server performance, active queries, connection states, and transaction throughput.

## Key Features

### Real-Time Monitoring
- Live dashboard refreshing every 2 seconds
- Active query tracking with execution time
- Connection state breakdown (active, idle, idle in transaction)
- Transaction throughput (TPS) with 5-minute sparkline visualization
- Replication stream health monitoring

### Query Management
- View full query text with syntax highlighting
- Cancel or terminate long-running queries
- Copy queries to clipboard for analysis
- Color-coded query states and execution times
- Sort by duration to identify bottlenecks

### Server Management
- Manage multiple PostgreSQL servers
- Custom colors and icons for easy identification
- Secure password storage in iOS Keychain
- Drag to reorder servers
- Last connected timestamp tracking

### Import & Export
- Import servers from pg_service.conf files
- Bulk import multiple database connections
- Quick setup from existing configurations

### Security
- Direct TLS-encrypted connections to PostgreSQL
- No third-party services or data collection
- Passwords stored securely in iOS Keychain
- All monitoring happens on-device

### Native iOS Experience
- Built with SwiftUI for smooth, native performance
- Dark mode support
- SF Symbols throughout
- Optimized for iPhone and iPad

## Perfect For

- **Database Administrators**: Monitor production databases from anywhere
- **DevOps Engineers**: Quick troubleshooting on the go
- **Backend Developers**: Check query performance during development
- **Site Reliability Engineers**: Respond to incidents from mobile

## Technical Details

- Connects directly to PostgreSQL 9.4+
- Uses PostgresNIO for robust connectivity
- TLS 1.2+ encryption required
- Supports standard PostgreSQL authentication
- Queries pg_stat_activity, pg_stat_database, and pg_stat_replication

## Requirements

- iOS 26.0 or later
- Network access to your PostgreSQL servers
- PostgreSQL server with TLS enabled
- Valid database credentials with appropriate permissions

## Privacy

PSQ respects your privacy:
- No analytics or tracking
- No data sent to third parties
- All connections are direct from your device to your servers
- Passwords stored only in iOS Keychain

## Support

Need help? Contact us at support@psq.lol or visit our website for documentation and guides.

## Key features

- Real-time database monitoring
- Active query tracking
- Query cancellation
- Multiple server management
- Secure password storage
- Import server configurations
- TLS-encrypted connections


## Frequently asked questions about psq

### What is psq?

psq is a PostgreSQL monitor utility designed for iOS devices. It allows users to monitor their PostgreSQL databases in real-time, track active queries, manage server connections, and more, directly from their iPhone or iPad.

### What PostgreSQL versions does psq support?

psq connects directly to PostgreSQL 9.4 and later versions. It requires TLS 1.2+ encryption to be enabled on the PostgreSQL server.

### How does psq ensure security?

psq uses direct TLS-encrypted connections to your PostgreSQL servers. Passwords are stored securely in the iOS Keychain, and all monitoring happens on-device with no third-party services or data collection.

### Can I manage multiple PostgreSQL servers with psq?

Yes, psq allows you to manage multiple PostgreSQL servers. You can assign custom colors and icons for easy identification and reorder them by dragging.

### Does psq have ads?

No, psq does not contain advertisements. The app is free to use and does not display any ads.

### How often is psq updated?

The latest version of psq is 1.1, and it was last updated on January 16, 2026. Specific update frequency is not detailed, but it is actively maintained.

### What are the system requirements for psq?

psq requires iOS 26.0 or later and network access to your PostgreSQL servers. The PostgreSQL server must have TLS enabled and valid database credentials with appropriate permissions.

### Can I cancel long-running queries using psq?

Yes, psq provides query management features, including the ability to view full query text and cancel or terminate long-running queries directly from the app.

## Version history (last 1 release)

### 1.1 — 2026-01-16

No release notes.

## More apps by BENJAMIN SANBORN CURRIE

- [Album Browser](https://appshunter.io/ios/app/album-browser/id6760136913)
- [Super Word: A Crossword Game](https://appshunter.io/ios/app/super-word-a-crossword-game/id6762553283)

All apps by BENJAMIN SANBORN CURRIE: https://appshunter.io/developer/1868745384

---

*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-06-01.*