top of page
![Волнистый абстрактный фон](https://static.wixstatic.com/media/11062b_db8f5ddb085b41fda169efb854f9b69e~mv2.jpg/v1/fill/w_41,h_23,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/11062b_db8f5ddb085b41fda169efb854f9b69e~mv2.jpg)
![](https://static.wixstatic.com/media/513478_a3290e79ef484986811c6db9c839ddcc~mv2.jpg/v1/fill/w_93,h_93,al_c,q_80,usm_0.66_1.00_0.01,enc_auto/logo-cerebrosql.jpg)
Query Editor: Query Execution Plan
Menu
oracle
SQL query plan for Oracle DBMS
![get query plan - oracle](https://static.wixstatic.com/media/513478_133497d86a3942e58a47bf3a7b50c5c2~mv2.jpg/v1/fill/w_796,h_497,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/get%20query%20plan%20-%20oracle.jpg)
EXPLAIN PLAN FOR <QUERY TEXT>
select * from TABLE(DBMS_XPLAN.display(NULL,NULL,'all'))
PostgreSQL
SQL query plan for PostgreSQL DBMS
![get query plan - postgresql](https://static.wixstatic.com/media/513478_847b6570d8fa4a1cbeed88dafa342d5c~mv2.jpg/v1/fill/w_142,h_67,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/get%20query%20plan%20-%20postgresql.jpg)
EXPLAIN VERBOSE <QUERY TEXT>
MSSQL
SQL query plan for MS SQL Server DBMS
![get query plan - mssql](https://static.wixstatic.com/media/513478_537398cd26eb4708843bf53dff8de032~mv2.jpg/v1/fill/w_143,h_67,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/get%20query%20plan%20-%20mssql.jpg)
SET SHOWPLAN_ALL ON
<RUN SQL TEXT>
SET SHOWPLAN_ALL OFF
MySQL
SQL query plan for MySQL DBMS
![get query plan - mysql](https://static.wixstatic.com/media/513478_30d1ef6c83fc413aa7238027e8f01e63~mv2.jpg/v1/fill/w_143,h_78,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/get%20query%20plan%20-%20mysql.jpg)
EXPLAIN <QUERY TEXT>
SQLite
SQL query plan for SQLite databases
![get query plan - sqlite](https://static.wixstatic.com/media/513478_6e3a99efcea44cc8a7fd733649e2a4be~mv2.jpg/v1/fill/w_143,h_85,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/get%20query%20plan%20-%20sqlite.jpg)
EXPLAIN QUERY PLAN <QUERY TEXT>
bottom of page