Explore @pganalyze Open Source projects

@pganalyze

pganalyze

Stars
3,364
Global Org. Rank 6,372 (Top 3 %)
Registered almost 12 years ago
Most used languages

Ruby
30.4 %

C
17.4 %

Python
13.0 %

Rust
13.0 %

TypeScript
8.7 %

MDX 4.3 %

Go
4.3 %

C++
4.3 %

PLpgSQL 4.3 %
Location 🇺🇸 United States
Country Total Rank 3,680
Country Ranking

MDX 116

C
135

PLpgSQL 273

Rust
801

Go
1,146

Ruby
2,095

C++
2,990

TypeScript
7,409

libpg_query

C library for accessing the PostgreSQL parser outside of the server environment

pg_query

Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser

pg_query_go

Go library to parse and normalize SQL queries using the PostgreSQL query parser

collector

pganalyze statistics collector for gathering PostgreSQL metrics and log data

pg_query.rs

Rust library to parse, deparse and normalize SQL queries using the PostgreSQL query parser

pg-query-emscripten

Emscripten Port of pg_query to easily play with it in the browser

activerecord-copy

Supports binary COPY into PostgreSQL with activerecord

queryparser

DEPRECATED - use libpg_query instead! https://github.com/lfittl/libpg_query

lint

Check for missing indexes during development using constraint programming

materialized-views-demo

Example for using Materialized Views in Rails

sidekiq_server.rs

A Sidekiq server implemented in Rust

pg_simulator

PostgreSQL Schema Simulator - Load schema and statistics information into a database and run EXPLAIN on queries

react-svg-example

Example of how to build UI components with React and SVG

subqueries-rails-example

pgcon2023

Simple index selection model using constraint programming presented at PGCon 2023

pganalyze-docs

Documentation for pganalyze - PostgreSQL Performance Monitoring

graphql-batch-example

Code example for "Efficient GraphQL queries in Ruby on Rails & Postgres" blog post

cp-sat-python-example

postgis_mock

Simplified version of the PostGIS extension functions, types and operators, to be used for parsing/planning queries that depend on PostGIS APIs, but without calling actual PostGIS code.

pgday-chicago-2024

full-text-search-rails

Example for article "Full Text Search in Milliseconds with Rails and PostgreSQL"

collector-snapshot

Protocol Buffers definition for the pganalyze collector

heroku-plugin-psql

Like heroku pg:psql but for any Postgres database

postgres-local-sync

Heroku helper app to synchronize your staging database to local development, via S3

index-advisor-feedback