All Projects → sanpii → Explain

sanpii / Explain

Licence: mit
Transform postgresql explain to a graph

Programming Languages

rust
11053 projects

Projects that are alternatives of or similar to Explain

Pgtools
Gui application to monitor postgres database events in real time
Stars: ✭ 42 (-16%)
Mutual labels:  postgresql
Ensembl Hive
EnsEMBL Hive - a system for creating and running pipelines on a distributed compute resource
Stars: ✭ 44 (-12%)
Mutual labels:  postgresql
Authentication Server
A simple authentication service to deliver JWT with Hasura claims, based on users with multiples roles stored in a Postgres database.
Stars: ✭ 48 (-4%)
Mutual labels:  postgresql
Tinder Clone
Fullstack Tinder app clone made with React/Ts/Nest
Stars: ✭ 43 (-14%)
Mutual labels:  postgresql
Pg party
Automatic partitioning on date-timestamp columns for PostgreSQL v9.1+
Stars: ✭ 44 (-12%)
Mutual labels:  postgresql
Pghoard
PostgreSQL backup and restore service
Stars: ✭ 1,027 (+1954%)
Mutual labels:  postgresql
Pg cron
Run periodic jobs in PostgreSQL
Stars: ✭ 1,002 (+1904%)
Mutual labels:  postgresql
Barman
Barman - Backup and Recovery Manager for PostgreSQL
Stars: ✭ 1,044 (+1988%)
Mutual labels:  postgresql
Pg variables
Session wide variables for PostgreSQL
Stars: ✭ 44 (-12%)
Mutual labels:  postgresql
Admin
AutoQuery + Admin UI for ServiceStack Projects
Stars: ✭ 47 (-6%)
Mutual labels:  postgresql
Phalcon Vm
Vagrant configuration for PHP7, Phalcon 3.x and Zephir development.
Stars: ✭ 43 (-14%)
Mutual labels:  postgresql
K2
Koa2 API template with passport, GraphQL, flowtype, knex and more.
Stars: ✭ 44 (-12%)
Mutual labels:  postgresql
P3
A lean and mean PostgreSQL client for Pharo
Stars: ✭ 47 (-6%)
Mutual labels:  postgresql
Postgraphile Nest
GraphQL (PostGraphile) module for Nest framework (node.js)
Stars: ✭ 43 (-14%)
Mutual labels:  postgresql
Perfect Postgresql
A stand-alone Swift wrapper around the libpq client library, enabling access to PostgreSQL servers.
Stars: ✭ 48 (-4%)
Mutual labels:  postgresql
Ar Uuid
Override migration methods to support UUID columns without having to be explicit about it.
Stars: ✭ 41 (-18%)
Mutual labels:  postgresql
Sales Cashregister
Cash Register Version 2.0 with barcode logon and to 8 buttongroups with each 23 programmable product buttons and equipped with inventory management system
Stars: ✭ 45 (-10%)
Mutual labels:  postgresql
Scala Db Codegen
Scala code/boilerplate generator from a db schema
Stars: ✭ 49 (-2%)
Mutual labels:  postgresql
Pop
A Tasty Treat For All Your Database Needs
Stars: ✭ 1,045 (+1990%)
Mutual labels:  postgresql
Kiba Plus
Kiba enhancement for Ruby ETL.
Stars: ✭ 47 (-6%)
Mutual labels:  postgresql

Explain

Github actions Build Status

Transform postgresql explain to a graph.

Install

If you use Arch Linux, explain is available in AUR.

Manually

git clone https://github.com/sanpii/explain
cd explain
make
sudo make install

Launch

Launch this program like psql and use dot to generate image:

$ explain --command 'select 1' database | dot -Tpng > explain.png
$ explain --help
explain 1.0.0

USAGE:
    explain [FLAGS] [OPTIONS] [dbname]

FLAGS:
        --analyse     this option executes explain analyse /!\ Be carful, that executes the query!
    -n, --dry-run     Don’t execute the query, the input is already an explain plan in JSON
        --help        Prints help information
    -W, --password    Prompt for a password before connecting to a database
    -V, --version     Prints version information

OPTIONS:
    -c, --command <command>    Specifies the command to execute
    -f, --file <file>          Read commands from the file, rather than standard input
    -h, --host <host>          Specifies the host name of the machine on which the server is running
    -o, --output <output>      Put output into file
    -p, --port <port>          Specifies the TCP port on which the server is listening for connections
    -U, --user <user>          Connect to the database as the user

ARGS:
    <dbname>    Specifies the name of the database to connect to
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].