TOOL SIGNAL / ACTIVE

pgbench

PostgreSQL Global Development Group

Database Benchmarking Open Source Self-hosted

NOT YET REVIEWED · CATALOG DATA

Official site ↗ Source repo ↗
Pricing model
Free; PostgreSQL License.
First released
Not verified
Last verified
Answer

pgbench initializes a standard TPC-B-like schema or executes custom SQL scripts across concurrent PostgreSQL sessions. It reports transaction rate and latency for repeatable database capacity measurements.

What it is

pgbench initializes a standard TPC-B-like schema or executes custom SQL scripts across concurrent PostgreSQL sessions. It reports transaction rate and latency for repeatable database capacity measurements.

Best for

  • Database throughput, transaction latency, and capacity benchmarks
  • Teams that prefer open-source licensing and self-hosting options
  • Groups comfortable scripting in SQL

Not the best fit when

  • Teams unwilling to operate generators, results storage, and scaling

Architecture and concurrency

pgbench is operated as a database benchmark with SQL. Workload definitions and database sessions determine concurrency, while results focus on throughput and latency rather than browser journeys.

Fact sheet

Specs

Scripting
SQL
Protocols
PostgreSQLSQL
Operating systems
WindowsmacOSLinux
Tags
databasepostgresqlsqlcli
Repo health
★ 21970 · last push 2026-09-01

CATALOG LAST VERIFIED · 2026-08-12 · CURATED BY NAVEENKUMAR NAMACHIVAYAM

Frequently asked

ANSWER-SHAPED
Who is pgbench for?

pgbench is best for engineers measuring database throughput, transaction latency, and capacity. It is open source, so teams can self-host and extend it. Vendor: PostgreSQL Global Development Group. Deployment model: self-hosted. Free; PostgreSQL License. Confirm details against the official site and a short proof-of-concept in your environment.

How does pgbench differ from BenchBase?

Compared with BenchBase, scripting centers on SQL rather than Java, XML. pgbench lists protocols PostgreSQL, SQL; BenchBase lists JDBC, SQL. Status is active versus active. Use the Test Rig to compare full specs side by side before a proof-of-concept. Confirm details against the official site and a short proof-of-concept in your environment.

What scripting language and concurrency model does pgbench use?

pgbench uses SQL for scripting or scenario definition. Runtime model: protocol-oriented virtual users configured through the product workflow. OS support: Windows, macOS, Linux. Protocols: PostgreSQL, SQL. Match these to how your team already authors tests and which systems you must drive under load.

What is the cloud or enterprise path for pgbench?

pgbench is a focused benchmark harness rather than a browser or enterprise load controller. Use its measured workload and reporting model to isolate database or code performance before broader system testing. As open source, commercial support or hosted siblings may exist separately. Check the official site. Pricing note: Free; PostgreSQL License.

What are known limitations of pgbench?

pgbench limitations to weigh: self-hosted tools require you to provision, scale, and observe load generators yourself. Status: active. Always validate against your target protocols and scale with a proof-of-concept. Confirm details against the official site and a short proof-of-concept in your environment.