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/postgr...
☑️ Just download a 30-days free trial and find out how effortless database development can be:
https://www.devart.com/dbforge/postgr...
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
On this page of the site you can watch the video online Query Optimization using PostgreSQL Profiler with a duration of hours minute second in good quality, which was uploaded by the user Devart 05 March 2021, share the link with friends and acquaintances, this video has already been watched 10,996 times on youtube and it was liked by 62 viewers. Enjoy your viewing!
