AI Already Did It › Developer Tools › Database Tools

PostgreSQL Profiler (package/command: pgprofiler)

Name: PostgreSQL Profiler (package/command: pgprofiler)
Author: Administrator

A SQL Server Profiler style desktop trace tool for PostgreSQL on Linux: live event grid, templates, filters, grouped views, trace files, SQL extraction and replay.

License	MIT
Generated by	Anthropic Claude Fable 5.1 —
Platforms	linux
Rating	0/100 (0 ratings) · worked for 0, didn't for 0
Downloads	0
Latest version	1.0.0 (2026-09-09)
Uploader	Administrator
Estimated generation cost	12,000,000 tokens (≈ $180.00) — saved so far: 0 tokens

Screenshots

PostgreSQL Profiler (package/command: pgprofiler) screenshot

Description

PostgreSQL Profiler

PostgreSQL Profiler brings the Microsoft SQL Server Profiler workflow to PostgreSQL on Linux. Connect to a server, pick a trace template, and watch events stream into a live grid: statements with exact durations, prepared-statement phases with bind parameters, logins and logouts, errors, lock waits, deadlocks, execution plans, checkpoints and autovacuum runs.

PostgreSQL has no trace API, so the profiler combines three sources into one Profiler-style event stream: the server log (read through SQL, a local file, or a command such as docker logs -f), pg_stat_activity sampling (zero configuration) and pg_stat_statements deltas. It can enable the required logging settings with ALTER SYSTEM and restores them when the trace stops.

Highlights

Profiler-style Trace Properties: event classes grouped by category, per-column check boxes, Column Filters with Like / Not like / Equals / Greater or equal / Less or equal, Organize Columns.
52 event classes in 12 categories and the familiar data columns (TextData, Duration, SPID, Reads, Writes, RowCounts, Error, StartTime...).
12 templates: Standard, SQL, SQL_Duration, SQL_Grouped, SQL_Locks, SQL_Replay, SQL_SPs, Tuning, Errors_and_Warnings, Activity_Sampler, Server_Health, Blank, plus user templates.
Trace window: run / pause / stop with a colour state indicator, auto scroll, colour-coded rows, syntax-highlighted statement pane, event properties, find, bookmarks, sorting, grouped and aggregated views, "filter by this value".
Persistence: save to .pgtrace files (with rollover) or to a PostgreSQL table, open them later, export CSV / JSON / SQL script.
Replay the captured workload against any server with per-session connections, original timing, single step, run to cursor and breakpoints.
Server Configuration tool for logging parameters and extensions, a workload generator, and a Debian package for one-command installation.

Built with Python 3, PySide6 (Qt 6) and psycopg 3. Tested against PostgreSQL 18. MIT licensed.

Downloads

pgprofiler_1.0.0_amd64.deb — Linux, 31 MB
postgres_profiler.tar.gz — Source, 1.2 MB

Original prompt(s)

Prompt 1

PostgreSQL Profiller

- Look at Micrososft Sql server Profiler and create a Linux profiler application like Micrososft one for PostgreSQL
- Research Micrososft Sql server Profiler before implementing any code
- Also check those links:
    * https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver17
    * https://marketplace.visualstudio.com/items?itemName=coopdigity-inc.vscode-mssql-profiler
- It should be desktop application of course

Follow-up prompts in the same session: detailed QA and bug fixing (event selection, visible run/pause state), git commit, remove .idea, MIT license, .deb package, and dependency fixes for Ubuntu 24.04.

Tags: database-monitoring, desktop-app, devtools, postgres, postgresql, profiler, query-performance, sql-trace

Open in AI Already Did It