Shows the top queries running on your server using pg_stat_statements

pg_query_optimizer is a gem that improving the performance of complex queries specifically desingned for postgress database. This query significantly improves query execution times for large datasets.

Some experimentations with LISTEN/NOTIFY for background jobs

Web interface for pgq gem. Inspect pgq and londiste queues

Rails goodies.

Easily use randomized keys instead of sequential values for your record surrogate ids.

Console utility for gracefully rebuild indexes/pkeys for PostgreSQL, with minimal locking in semi-auto mode.

Postgres replication protocol

REST API for remote PostgreSQL database migrations.

Simple schema migrations for PostgreSQL, which runs pure SQL.

serializes rails models from postgres (9.5+)

pg_shrink makes it simple to shrink and sanitize a PosrgreSQL database

Construct composable, structured, PostgreSQL queries in plain Ruby.

A collection of Postgres data definition SQL builders

pg_space_cadet is a simple hack for postgreSQL and ActiveRecord which provides a uuids table of distributable identities of space cadets -- ActiveRecord::Base instances which use the SpaceCadetWrapper. Each space cadet has a default ActiveRecord id unique in the set of all local space cadets; a s...

Helper class for setting up and easily tearing down PostgreSQL database objects within a testing environment

Production-grade PostgreSQL trigger management for Rails with lifecycle management, safe deploys, versioning, drift detection, and a mountable UI.

Stream data from postgres or Redshift

A gem that makes working with tags stored in a Postgresql column easy. Support for array of string, integer and jsonb values.

PostgreSQL Tasks and Functions for Ruby on Rails