In this blog post, weβll see What is an SQL Execution Plan? Postgres documentation says: The execution plan shows how the table(s) referenced by the statement will…
View More Postgres Execution Plans
Tag: execution plan
PostgreSQL EXPLAIN Explained
When a SQL statement is sent to a PostgreSQL server for execution, Postgres will decipher various parts of the query and define an execution plan…
View More PostgreSQL EXPLAIN Explained
How do I display and read the execution plans for a SQL statement
This post covers how you can use the PL/SQL package DBMS_XPLAN to display execution plan information. If you want to learn more about DBMS_XPLAN options,…
View More How do I display and read the execution plans for a SQL statement
Flush Bad SQL Plan from Shared Pool
Sometimes it is required to flush the BAD SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID 1)…
View More Flush Bad SQL Plan from Shared Pool
Query Performance in Postgres
What is Explain? EXPLAIN is a keyword that gets prepended to a query to show a user how the query planner plans to execute the…
View More Query Performance in Postgres