Query Optimization using PostgreSQL Profiler

In this video, we will see how the PostgreSQL Query Profiler works. It’s a functionality built into dbForge Studio for PostgreSQL that helps DBAs and developers troubleshoot slow-running queries to optimize performance.

The Query Profiler has a graphical interface that shows each step of a Postgres query’s execution plan.

The Query Profiling information includes:
🔹 The date and time of the query
🔹 The total execution time and planning time
🔹 A plan tree
🔹 A graphical plan diagram
🔹 The top operations within the query plan, and
🔹 An XML version of the query plan

As we will see, the plan diagram has an extensive set of information that helps you identify potential bottlenecks.

☑️ To learn more about the Query Profiler and other great features of dbForge Studio for PostgreSQL visit:
https://www.devart.com/dbforge/postgresql/studio/query-profiler.html

☑️ Just download a 30-days free trial and find out how effortless database development can be:
https://www.devart.com/dbforge/postgresql/studio/download.html

0:00 Introduction
0:21 Execution plan diagram information
1:25 Example of tuning Postgres queries
1:55 Start the Query Profiler
2:34 The navigation pane
2:57 The node with execution time and the planning time
3:22 The Plan Tree
5:56 “Top Operations” node
4:11 “Plan XML node”
4:31 Postgres graphical query plan
5:38 The costs
6:22 Compare the Plan Rows and the Actual Rows
7:59 Run the ANALYZE command

#PostgreSQL #QueryProfiler #QueryOptimization #PostgreSQLDatabase #dbForge #Devart