Visualize Explain Results from PostgreSQL in PGCLI

Visualize Explain Results from PostgreSQL in PGCLI

Table of Contents

Recently I wrote a visualizer for explain query responses from PostgreSQL. I also integrated it into pgcli and it got merged few days ago. You can install it currently with:

pip install git+https://github.com/dbcli/pgcli@main

or wait for 3.4.2 release and update. To switch between normal mode and explain mode you can press F5

PGCLI Explain Visualizer

comments powered by Disqus

Related Posts

Porting Files Generated by Phoenix to Surface

Porting Files Generated by Phoenix to Surface

This post is intended to get you started with surface provided components. I provided the original code and surface versions so you can compare the differences yourself without installing anything.

Read More
Reverse Engineer Unknown Data Format Using Elixir

Reverse Engineer Unknown Data Format Using Elixir

I recently worked on porting the csv file converter for AdventureWorks database from ruby to elixir. This ended successful and I have all the data in my local postgresql to play with. By browsing the tables I found spatial_location column in person.address table and I wanted to decode it.

Read More
Enhancements to dbg in Elixir 1.18

Enhancements to dbg in Elixir 1.18

Elixir 1.18 added some interesting features, but one that went under the radar was extended support for dbg. In 1.17 when you had this code:

Read More