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 our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Add support for reporting relation/table summary/total Index Page usage statistics [CORE3906] #4242
Comments
Modified by: Sean Leyne (seanleyne)summary: Add support for reporting Relation Index Page usage statistics => Add support for reporting relation/table Index Page usage statistics |
Commented by: @dyemanov What do you mean here? Index pages are reported by GSTAT. Or did you mean pointer pages instead? |
Commented by: Sean Leyne (seanleyne) I am saying that GSTAT should report all details on all structures (even system structures), so that a complete picture is available. |
Commented by: Sean Leyne (seanleyne) Here is the current GSTAT output:
All I see is the number of "Data Pages". "Data pages" means pages used to store primary data. Where are the number of index pages? |
Commented by: Sean Leyne (seanleyne) Although you get extract the index page usage details:
Unlike the data page output there is no summary (as the Data pages have), ie: I also think that a simple summary at the relation/table level would be appropriate, ie: To save from having to add up all the fill distributions for all of the relation/table indexes. |
Modified by: Sean Leyne (seanleyne)summary: Add support for reporting relation/table Index Page usage statistics => Add support for reporting relation/table summary/total Index Page usage statistics |
Commented by: @ibaseru Sean, I'm against this because yes, you can extract index root pages for table at once, but total index pages you can determine only visiting that pages. Really, all these numbers can be parsed and computed, giving additional info line size in megabytes, etc, by any other program that analyzes gstat output. I wrote my own (and I think you know it's name), not to dig into numbers, especially for the large databases. Also "count of indices" is not necessary, because indices are numbered from 1 to N for table, and gstat output places this info between current and next table. |
Commented by: Sean Leyne (seanleyne) While the current output includes a index number for a table, the output in not in index number order:
So, it is not obvious how many indexes exist. |
Commented by: Sean Leyne (seanleyne) kdv, It should not require a third-party tool in order for a user to gather details about a database, this is something which is engine should provide. |
Modified by: @dyemanovassignee: Vlad Khorsun [ hvlad ] |
Submitted by: Sean Leyne (seanleyne)
The current statistics do not include details regarding the page usage related to index structures linked to data rows of the relation/table.
Details concerning Index page usage are important when trying to determine the storage 'profile' of a database.
The text was updated successfully, but these errors were encountered: