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
In questa pagina del sito puoi guardare il video online Query Optimization using PostgreSQL Profiler della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Devart 05 marzo 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 10,996 volte e gli è piaciuto 62 spettatori. Buona visione!
