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 249
  • Win 119
  • Mac 76
  • Linux 54
Jun 5 Jun 4 Jun 3 Jun 2 Jun 1 May 31 May 30 May 29 May 28 May 27 May 26 May 25 May 24 May 23 May 22 May 21 May 20 May 19 May 18 May 17 May 16 May 15 May 14 May 13 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
Windows 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 1 1 1 2
Mac 0 1 0 0 0 0 0 0 1 0 0 0 1 0 1 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 1 0 0
Linux 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0
01234Jun 5Jun 2May 30May 27May 24May 21May 18May 15May 12May 9May 6May 3Apr 30Apr 27Apr 24Jun 5 Linux: 0 Mac: 0 Windows: 0Jun 4 Linux: 0 Mac: 1 Windows: 0Jun 3 Linux: 0 Mac: 0 Windows: 0Jun 2 Linux: 0 Mac: 0 Windows: 0Jun 1 Linux: 0 Mac: 0 Windows: 0May 31 Linux: 0 Mac: 0 Windows: 0May 30 Linux: 0 Mac: 0 Windows: 1May 29 Linux: 0 Mac: 0 Windows: 1May 28 Linux: 0 Mac: 1 Windows: 1May 27 Linux: 1 Mac: 0 Windows: 0May 26 Linux: 0 Mac: 0 Windows: 0May 25 Linux: 1 Mac: 0 Windows: 0May 24 Linux: 0 Mac: 1 Windows: 0May 23 Linux: 0 Mac: 0 Windows: 0May 22 Linux: 0 Mac: 1 Windows: 0May 21 Linux: 0 Mac: 0 Windows: 0May 20 Linux: 0 Mac: 0 Windows: 0May 19 Linux: 0 Mac: 0 Windows: 0May 18 Linux: 0 Mac: 0 Windows: 0May 17 Linux: 0 Mac: 0 Windows: 0May 16 Linux: 0 Mac: 0 Windows: 0May 15 Linux: 0 Mac: 0 Windows: 0May 14 Linux: 0 Mac: 1 Windows: 1May 13 Linux: 0 Mac: 0 Windows: 0May 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: 2Jun 5 Linux: 0 Mac: 0 Windows: 0Jun 4 Linux: 0 Mac: 1 Windows: 0Jun 3 Linux: 0 Mac: 0 Windows: 0Jun 2 Linux: 0 Mac: 0 Windows: 0Jun 1 Linux: 0 Mac: 0 Windows: 0May 31 Linux: 0 Mac: 0 Windows: 0May 30 Linux: 0 Mac: 0 Windows: 1May 29 Linux: 0 Mac: 0 Windows: 1May 28 Linux: 0 Mac: 1 Windows: 1May 27 Linux: 1 Mac: 0 Windows: 0May 26 Linux: 0 Mac: 0 Windows: 0May 25 Linux: 1 Mac: 0 Windows: 0May 24 Linux: 0 Mac: 1 Windows: 0May 23 Linux: 0 Mac: 0 Windows: 0May 22 Linux: 0 Mac: 1 Windows: 0May 21 Linux: 0 Mac: 0 Windows: 0May 20 Linux: 0 Mac: 0 Windows: 0May 19 Linux: 0 Mac: 0 Windows: 0May 18 Linux: 0 Mac: 0 Windows: 0May 17 Linux: 0 Mac: 0 Windows: 0May 16 Linux: 0 Mac: 0 Windows: 0May 15 Linux: 0 Mac: 0 Windows: 0May 14 Linux: 0 Mac: 1 Windows: 1May 13 Linux: 0 Mac: 0 Windows: 0May 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: 2Jun 5 Linux: 0 Mac: 0 Windows: 0Jun 4 Linux: 0 Mac: 1 Windows: 0Jun 3 Linux: 0 Mac: 0 Windows: 0Jun 2 Linux: 0 Mac: 0 Windows: 0Jun 1 Linux: 0 Mac: 0 Windows: 0May 31 Linux: 0 Mac: 0 Windows: 0May 30 Linux: 0 Mac: 0 Windows: 1May 29 Linux: 0 Mac: 0 Windows: 1May 28 Linux: 0 Mac: 1 Windows: 1May 27 Linux: 1 Mac: 0 Windows: 0May 26 Linux: 0 Mac: 0 Windows: 0May 25 Linux: 1 Mac: 0 Windows: 0May 24 Linux: 0 Mac: 1 Windows: 0May 23 Linux: 0 Mac: 0 Windows: 0May 22 Linux: 0 Mac: 1 Windows: 0May 21 Linux: 0 Mac: 0 Windows: 0May 20 Linux: 0 Mac: 0 Windows: 0May 19 Linux: 0 Mac: 0 Windows: 0May 18 Linux: 0 Mac: 0 Windows: 0May 17 Linux: 0 Mac: 0 Windows: 0May 16 Linux: 0 Mac: 0 Windows: 0May 15 Linux: 0 Mac: 0 Windows: 0May 14 Linux: 0 Mac: 1 Windows: 1May 13 Linux: 0 Mac: 0 Windows: 0May 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: 2

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