SQL Query Optimizer-based Query Progress Indicator
Urmila Mane · 2013
Nowadays, widely used Business Intelligence(BI) and Data Warehousing(DW) technologies are mostly based on long- running and complex queries. So for this purpose it is important for users to have information about progress of query execution. Recently interest in the development of percent-done progress indicators has been increased. In this paper, we propose a method that constructs model of a percent-done progress indicators based on optimizer-based approach. Percent-done progress indicators basically used as a technique that graphically shows query execution time that means total and remaining or degree of completion. Also the proposed technique is based on postgerSQL database engine. PostgreSQL is a powerful, open source object-relational database system. Currently Postgres doesn't have SQL query progress indicator for long-running queries. With the help of user-system interaction (interface) the progress indicator show the progress of SQL queries through various phases like parsing, analyzing, rewrite, execution. The graphical user interface show all the queries running on system and their estimated time completion. The execution phase of query is critical phase and also the cost of query varies depending disk read time, type of join used, distribution or broadcast of table, order in which tables are joined, statistics information available.