![]() ![]() Rows are defined as the number of rows which was defined in the query.The actual time is defined as how much time is required to execute the query and retrieve its output.Cost is defined as two number first number contains the startup cost, and the second contains the incurred process cost. Cost is defined as how much work will be required to execute the query.Node in explain plan consist of the logical unit of work.Nodes are defined as the block of code that was executing at the time of query execution in PostgreSQL.We have also used explain analysis with the query it will show the additional information related to the query’s execution time.The below example shows that find explains and explains analyze the plan of query in PostgreSQL.Įxplain analyze select * from performance_table.Using the above parameter, we are tuning the query to increase the performance of the database.After finding a slow query, we need to create the explain plan of that query explain plan will show the below information related to the slow query.In the above example state that is using the exact start time, we can find the long-running query. ![]() The below example shows that find the long-running or slow query in PostgreSQL. ![]() We can find a long-running query by using the pg_stat_activity catalog table.To tune the database performance, we need to find a log running a query that was running on the database server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |