Tracking table and index partition usage in a database
View Patent ↗Apparatus, methods and computer-readable medium for displaying information related to performance of a given database statement which accesses a plurality of multi-partition objects during a time interval. In some embodiments, the method comprises: a) determining, for a given database statement that accesses a plurality of index or table partitions during the time interval, for each accessed partition of a plurality of partitions, a respective aggregate wait time associated with said accessed partition; b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval.
1. A method for displaying information related to performance of a given database statement which accesses a plurality of multi-partition objects during a time interval, the method comprising:
a) determining, by a processor, for a given database statement that accesses a plurality of index or table partitions during the time interval, for each accessed partition of a plurality of partitions, a respective aggregate wait time associated with said accessed partition;
b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval, that includes, for each accessed partition, an indication of a ratio between:
i) said respective aggregate wait time associated with said accessed partition; and
ii) a total wait time associated with executing the given database statement during the time interval.
2. The method of claim 1 wherein step (a) is carried out for a plurality different database statements, each database statement being associated with a different plurality of partition aggregate wait times.
3. The method of claim 1 where presenting of the description of the database performance includes presenting indications of the plurality of the determined aggregate wait times.
4. The method of claim 1 the presented indications are ranked in accordance with relative magnitudes of the ratios.
5. A method for displaying information related to performance of a database during a time interval, the method comprising:
a) determining, by a processor, for a given multi-partition table or multi-partition index that is accessed by a plurality of database statements during the time interval, a respective aggregate wait time, for the time interval, for each partition of the multi-partition table or index; and
b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval, that includes for each accessed partition, an indication of a ratio between:
i) said respective aggregate wait time associated with said accessed partition; and
ii) an aggregate wait time for the multi-partition index or table for the time interval.
6. The method of claim 5 wherein step (a) is carried out for a plurality different database indexes, each database index being associated with a different plurality of partition aggregate wait times.
7. The method of claim 6 wherein step (a) is carried out for a plurality different database tables, each database table being associated with a different plurality of partition aggregate wait times.
8. The method of claim 5 the presented indications are ranked in accordance with relative magnitudes of the ratios.
9. A method for displaying information related to performance of a database during a time interval, the method comprising:
a) determining, by a processor, for a given partition that is part of a multi-partition table or index, the given partition being that is accessed by a plurality of database statements during the time interval, a respective aggregate wait time for the time interval for each accessing database statement of the given partition; and
b) in accordance with the determined wait times for the given partition, presenting, to a user, a description of performance of the database during the time interval, that includes for each accessing database statement, an indication of a ratio between:
i) said respective aggregate wait time associated with access of the accessing database statement to the given partition; and
ii) a total wait time associated with the given partition during the time interval.
10. The method of claim 9 wherein step (a) is carried out for a plurality of different partitions, each partition being associated with a different plurality of partition aggregate wait times.
11. The method of claim 9 where presenting of the description of the database performance includes presenting indications of the plurality of the determined aggregate wait times.
12. The method of claim 9 , the presented indications are ranked in accordance with relative magnitudes of the ratios.