• Stars
    star
    782
  • Rank 58,164 (Top 2 %)
  • Language
    Go
  • License
    MIT License
  • Created over 8 years ago
  • Updated over 1 year ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

A command-line GO Postgres query visualizer, heavily inspired by pev (https://github.com/AlexTatiyants/pev)

gocmdpev

A command-line GO Postgres query visualizer, heavily inspired by the excellent (web-based) pev

image

Usage

go get -u github.com/simon-engledew/gocmdpev

or via Homebrew:

brew tap simon-engledew/gocmdpev
brew install gocmdpev

Generate a query plan with all the trimmings by prefixing your query with:

EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON)

Then pipe the resulting query plan into gocmdpev.

On MacOS you can just grab a query on your clipboard and run this one-liner:

pbpaste | sed '1s/^/EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON) /' | psql -qXAt <DATABASE> | gocmdpev

Python 3 Bindings

Check out the repository and run make python3 to build and test the bindings.

Using with Ruby on Rails

Try the pg-eyeballs gem

More Repositories

1

dockerweb

Connect a browser to a docker container
JavaScript
53
star
2

sshim

Scriptable SSH server for testing clients and automation - think expect for SSH
Python
25
star
3

mock-ssh-server

Use Starlark scripts to create test SSH servers.
Go
4
star
4

python-radius

A python radius implementation which supports Status-Server and Message-Authenticators
Python
4
star
5

ruby-process-lock

Use process lock to see if a process is already running or designate a master process when running concurrent applications.
Ruby
4
star
6

python-er

Python micro library that generates data matching a given regular expression.
Python
3
star
7

relaxedjson.py

A relaxed JSON parser for Python
Python
3
star
8

csharp-netstrings

A netstrings implementation in C# for .NET
C#
2
star
9

bean-loader

A database loader that automagically injects the results of prepared statements into Java beans (without any configuration), returning them in a variety of useful & exciting ways.
Java
2
star
10

python-chunks

Python http chunked encoding and decoding library
Python
2
star
11

count-by-month

Adds an ActiveRecord class method to count records by the month they were created.
Ruby
2
star
12

ijsongenerators

A wrapper for ijson
Python
1
star
13

restmate

A bundle for Textmate which allows you to display and edit RESTful resources as YAML.
1
star
14

grouped-select-helper

Adds a grouped_select helper to Rails 2.3
1
star
15

screenslaver

Wireless E-ink display
C++
1
star
16

postgresql-rpc

Simple synchronous postgres RPC mechanism
C
1
star
17

twirpmock

Create mock twirp services powered by Starlark scripts
Go
1
star
18

square-battle

two squares battle in XNA using the Farseer physics library to adjudicate!
C#
1
star
19

postcss-scoped

At an @scope rule to css which will qualify nested rules
JavaScript
1
star
20

seed

Go
1
star
21

pg-go-rpc

dblink based postgres <-> golang sketch
Go
1
star
22

memetic-routes

Plugin to remember Rails route parameters automatically, especially useful for multiple views onto the same action.
Ruby
1
star
23

dot_handler

Rails 2 TemplateHandler for outputting graphviz dotfiles
Ruby
1
star
24

truncate-active-record

Adds a truncate class method to ActiveRecord which deletes all records and resets the autoincrement ID
Ruby
1
star