ctrl+shift+p filters: :st2 :st3 :win :osx :linux
Browse

Explain Postgre​SQL

by MGorkov ST3

Explain PostgreSQL plugin for Sublime Text

Details

Installs

  • Total 238
  • Win 115
  • Mac 71
  • Linux 52
May 12 May 11 May 10 May 9 May 8 May 7 May 6 May 5 May 4 May 3 May 2 May 1 Apr 30 Apr 29 Apr 28 Apr 27 Apr 26 Apr 25 Apr 24 Apr 23 Apr 22 Apr 21 Apr 20 Apr 19 Apr 18 Apr 17 Apr 16 Apr 15 Apr 14 Apr 13 Apr 12 Apr 11 Apr 10 Apr 9 Apr 8 Apr 7 Apr 6 Apr 5 Apr 4 Apr 3 Apr 2 Apr 1 Mar 31 Mar 30 Mar 29 Mar 28
Windows 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 1 1 1 2 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1
Mac 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
Linux 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
01234May 12May 9May 6May 3Apr 30Apr 27Apr 24Apr 21Apr 18Apr 15Apr 12Apr 9Apr 6Apr 3Mar 31Mar 28May 12 Linux: 0 Mac: 0 Windows: 0May 11 Linux: 0 Mac: 0 Windows: 0May 10 Linux: 0 Mac: 0 Windows: 0May 9 Linux: 0 Mac: 0 Windows: 0May 8 Linux: 0 Mac: 0 Windows: 0May 7 Linux: 0 Mac: 0 Windows: 0May 6 Linux: 0 Mac: 0 Windows: 0May 5 Linux: 0 Mac: 0 Windows: 0May 4 Linux: 0 Mac: 0 Windows: 0May 3 Linux: 0 Mac: 0 Windows: 0May 2 Linux: 1 Mac: 0 Windows: 1May 1 Linux: 0 Mac: 1 Windows: 0Apr 30 Linux: 0 Mac: 0 Windows: 1Apr 29 Linux: 0 Mac: 0 Windows: 1Apr 28 Linux: 0 Mac: 0 Windows: 0Apr 27 Linux: 0 Mac: 0 Windows: 0Apr 26 Linux: 0 Mac: 0 Windows: 0Apr 25 Linux: 0 Mac: 0 Windows: 1Apr 24 Linux: 0 Mac: 1 Windows: 1Apr 23 Linux: 0 Mac: 0 Windows: 1Apr 22 Linux: 0 Mac: 0 Windows: 2Apr 21 Linux: 0 Mac: 0 Windows: 0Apr 20 Linux: 0 Mac: 0 Windows: 0Apr 19 Linux: 1 Mac: 0 Windows: 0Apr 18 Linux: 0 Mac: 0 Windows: 2Apr 17 Linux: 0 Mac: 0 Windows: 2Apr 16 Linux: 0 Mac: 0 Windows: 0Apr 15 Linux: 0 Mac: 0 Windows: 0Apr 14 Linux: 0 Mac: 1 Windows: 0Apr 13 Linux: 0 Mac: 0 Windows: 0Apr 12 Linux: 0 Mac: 0 Windows: 0Apr 11 Linux: 0 Mac: 0 Windows: 0Apr 10 Linux: 0 Mac: 0 Windows: 0Apr 9 Linux: 0 Mac: 0 Windows: 0Apr 8 Linux: 0 Mac: 0 Windows: 0Apr 7 Linux: 0 Mac: 0 Windows: 0Apr 6 Linux: 0 Mac: 0 Windows: 0Apr 5 Linux: 0 Mac: 0 Windows: 0Apr 4 Linux: 0 Mac: 1 Windows: 0Apr 3 Linux: 0 Mac: 0 Windows: 1Apr 2 Linux: 0 Mac: 0 Windows: 0Apr 1 Linux: 0 Mac: 0 Windows: 0Mar 31 Linux: 0 Mac: 0 Windows: 1Mar 30 Linux: 0 Mac: 0 Windows: 0Mar 29 Linux: 0 Mac: 0 Windows: 0Mar 28 Linux: 0 Mac: 0 Windows: 1May 12 Linux: 0 Mac: 0 Windows: 0May 11 Linux: 0 Mac: 0 Windows: 0May 10 Linux: 0 Mac: 0 Windows: 0May 9 Linux: 0 Mac: 0 Windows: 0May 8 Linux: 0 Mac: 0 Windows: 0May 7 Linux: 0 Mac: 0 Windows: 0May 6 Linux: 0 Mac: 0 Windows: 0May 5 Linux: 0 Mac: 0 Windows: 0May 4 Linux: 0 Mac: 0 Windows: 0May 3 Linux: 0 Mac: 0 Windows: 0May 2 Linux: 1 Mac: 0 Windows: 1May 1 Linux: 0 Mac: 1 Windows: 0Apr 30 Linux: 0 Mac: 0 Windows: 1Apr 29 Linux: 0 Mac: 0 Windows: 1Apr 28 Linux: 0 Mac: 0 Windows: 0Apr 27 Linux: 0 Mac: 0 Windows: 0Apr 26 Linux: 0 Mac: 0 Windows: 0Apr 25 Linux: 0 Mac: 0 Windows: 1Apr 24 Linux: 0 Mac: 1 Windows: 1Apr 23 Linux: 0 Mac: 0 Windows: 1Apr 22 Linux: 0 Mac: 0 Windows: 2Apr 21 Linux: 0 Mac: 0 Windows: 0Apr 20 Linux: 0 Mac: 0 Windows: 0Apr 19 Linux: 1 Mac: 0 Windows: 0Apr 18 Linux: 0 Mac: 0 Windows: 2Apr 17 Linux: 0 Mac: 0 Windows: 2Apr 16 Linux: 0 Mac: 0 Windows: 0Apr 15 Linux: 0 Mac: 0 Windows: 0Apr 14 Linux: 0 Mac: 1 Windows: 0Apr 13 Linux: 0 Mac: 0 Windows: 0Apr 12 Linux: 0 Mac: 0 Windows: 0Apr 11 Linux: 0 Mac: 0 Windows: 0Apr 10 Linux: 0 Mac: 0 Windows: 0Apr 9 Linux: 0 Mac: 0 Windows: 0Apr 8 Linux: 0 Mac: 0 Windows: 0Apr 7 Linux: 0 Mac: 0 Windows: 0Apr 6 Linux: 0 Mac: 0 Windows: 0Apr 5 Linux: 0 Mac: 0 Windows: 0Apr 4 Linux: 0 Mac: 1 Windows: 0Apr 3 Linux: 0 Mac: 0 Windows: 1Apr 2 Linux: 0 Mac: 0 Windows: 0Apr 1 Linux: 0 Mac: 0 Windows: 0Mar 31 Linux: 0 Mac: 0 Windows: 1Mar 30 Linux: 0 Mac: 0 Windows: 0Mar 29 Linux: 0 Mac: 0 Windows: 0Mar 28 Linux: 0 Mac: 0 Windows: 1May 12 Linux: 0 Mac: 0 Windows: 0May 11 Linux: 0 Mac: 0 Windows: 0May 10 Linux: 0 Mac: 0 Windows: 0May 9 Linux: 0 Mac: 0 Windows: 0May 8 Linux: 0 Mac: 0 Windows: 0May 7 Linux: 0 Mac: 0 Windows: 0May 6 Linux: 0 Mac: 0 Windows: 0May 5 Linux: 0 Mac: 0 Windows: 0May 4 Linux: 0 Mac: 0 Windows: 0May 3 Linux: 0 Mac: 0 Windows: 0May 2 Linux: 1 Mac: 0 Windows: 1May 1 Linux: 0 Mac: 1 Windows: 0Apr 30 Linux: 0 Mac: 0 Windows: 1Apr 29 Linux: 0 Mac: 0 Windows: 1Apr 28 Linux: 0 Mac: 0 Windows: 0Apr 27 Linux: 0 Mac: 0 Windows: 0Apr 26 Linux: 0 Mac: 0 Windows: 0Apr 25 Linux: 0 Mac: 0 Windows: 1Apr 24 Linux: 0 Mac: 1 Windows: 1Apr 23 Linux: 0 Mac: 0 Windows: 1Apr 22 Linux: 0 Mac: 0 Windows: 2Apr 21 Linux: 0 Mac: 0 Windows: 0Apr 20 Linux: 0 Mac: 0 Windows: 0Apr 19 Linux: 1 Mac: 0 Windows: 0Apr 18 Linux: 0 Mac: 0 Windows: 2Apr 17 Linux: 0 Mac: 0 Windows: 2Apr 16 Linux: 0 Mac: 0 Windows: 0Apr 15 Linux: 0 Mac: 0 Windows: 0Apr 14 Linux: 0 Mac: 1 Windows: 0Apr 13 Linux: 0 Mac: 0 Windows: 0Apr 12 Linux: 0 Mac: 0 Windows: 0Apr 11 Linux: 0 Mac: 0 Windows: 0Apr 10 Linux: 0 Mac: 0 Windows: 0Apr 9 Linux: 0 Mac: 0 Windows: 0Apr 8 Linux: 0 Mac: 0 Windows: 0Apr 7 Linux: 0 Mac: 0 Windows: 0Apr 6 Linux: 0 Mac: 0 Windows: 0Apr 5 Linux: 0 Mac: 0 Windows: 0Apr 4 Linux: 0 Mac: 1 Windows: 0Apr 3 Linux: 0 Mac: 0 Windows: 1Apr 2 Linux: 0 Mac: 0 Windows: 0Apr 1 Linux: 0 Mac: 0 Windows: 0Mar 31 Linux: 0 Mac: 0 Windows: 1Mar 30 Linux: 0 Mac: 0 Windows: 0Mar 29 Linux: 0 Mac: 0 Windows: 0Mar 28 Linux: 0 Mac: 0 Windows: 1

Readme

Source
raw.​githubusercontent.​com

Explain PostgreSQL

Analyzes EXPLAIN plan from PostgreSQL and related (Greenplum, Citus, TimescaleDB and Amazon RedShift).

Shows plan and node details and visualizations with piechart, flowchart and tilemap, also gives smart recommendations to improve query.

Uses the external service with public access to format and analyze the query, so be carefull to upload proprietary code!

Uses public api from the explain.tensor.ru , the site can be changed in settings (e.g. to mirror https://explain-postgresql.com)

Learn more

Features

  • Beautifier and formatter for SQL CTRL+SHIFT+g
  • Explain Analyze for query plan CTRL+SHIFT+e

Settings

Installing

Using Sublime Package Control

Click the Package Control: Install Package menu item and choose Explain PostgreSQL

  1. Press CTRL+SHIFT+p
  2. Type Install Package
  3. Install Explain PostgreSQL

Please install and configure the SQLTools plugin first.

Download Manually

  1. Download the latest released zip file here
  2. Unzip the files to Explain PostgreSQL
  3. Find your Packages directory using the menu item Preferences -> Browse Packages...
  4. Copy the folder into your Sublime Text Packages directory