- Notifications
You must be signed in to change notification settings - Fork26
Add progress bar during query execution to track progress.#63
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
Uh oh!
There was an error while loading.Please reload this page.
Conversation
Progress bar is run-time SQL-query progress indicator.Function pg_progress_bar(pid) extracts the current query state from backend with specified 'pid'. Then gets thenumerical values of the actual rows and total rows and count progress for the whole query tree. Function returnsnumeric value from 0 to 1 describing the measure of query fulfillment. This function can be used to be embeddedin the PostgreSQL GUI.To intuitively track progress without using a graphical client, you can use the additionally implemented functionpg_progress_bar_visual(pid, delay). It prints state every period specified by 'delay' (in seconds).Increase version to 1.2 due to init.sql change.
Codecov ReportAttention: Patch coverage is
Additional details and impacted files@@ Coverage Diff @@## master #63 +/- ##==========================================- Coverage 77.03% 75.74% -1.30%========================================== Files 10 10 Lines 736 878 +142 ==========================================+ Hits 567 665 +98- Misses 169 213 +44 ☔ View full report in Codecov by Sentry. 🚀 New features to boost your workflow:
|
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
everything all right
c927d0c intomasterUh oh!
There was an error while loading.Please reload this page.
Progress bar is run-time SQL-query progress indicator.
Function pg_progress_bar(pid) extracts the current query state from backend with specified 'pid'. Then gets the
numerical values of the actual rows and total rows and count progress for the whole query tree. Function returns
numeric value from 0 to 1 describing the measure of query fulfillment. This function can be used to be embedded
in the PostgreSQL GUI.
To intuitively track progress without using a graphical client, you can use the additionally implemented function
pg_progress_bar_visual(pid, delay). It prints state every period specified by 'delay' (in seconds).
Increase version to 1.2 due to init.sql change.