Child pages
  • Duke Disk Space Usage

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

grouper_audit_entry (user audit) - 21,612,122

Table disk space usage

...

This is the disk space used by each of the Grouper tables excluding indexes.


TableDisk space (GB)
GROUPER_ATTRIBUTE_ASSIGN

...

.021484375
GROUPER_ATTRIBUTE_ASSIGN_VALUE

...

.0078125
GROUPER_ATTRIBUTE_DEF

...

.000061035
GROUPER_ATTRIBUTE_DEF_NAME

...

.00390625
GROUPER_ATTRIBUTE_DEF_NAME_SET

...

.001953125
GROUPER_ATTRIBUTE_DEF_SCOPE

...

.000061035
GROUPER_ATTR_ASSIGN_ACTION

...

.000061035
GROUPER_ATTR_ASSIGN_ACTION_SET

...

.000061035
GROUPER_AUDIT_ENTRY

...

13.7304688
GROUPER_AUDIT_TYPE

...

.000061035
GROUPER_CHANGE_LOG_CONSUMER

...

.000061035
GROUPER_CHANGE_LOG_ENTRY

...

1.44805908
GROUPER_CHANGE_LOG_ENTRY_TEMP

...

.0859375
GROUPER_CHANGE_LOG_TYPE

...

.000061035
GROUPER_COMPOSITES

...

.001953125
GROUPER_DDL

...

.000061035
GROUPER_FIELDS

...

.000061035
GROUPER_GROUPS

...

.3671875
GROUPER_GROUP_SET

...

4.15332031
GROUPER_LOADER_LOG

...

.036132813
GROUPER_MEMBERS

...

.59375
GROUPER_MEMBERSHIPS

...

4.4453125
GROUPER_PIT_ATTRIBUTE_ASSIGN

...

.044921875
GROUPER_PIT_ATTRIBUTE_DEF

...

.000061035
GROUPER_PIT_ATTR_ASSN_ACTN

...

.000061035
GROUPER_PIT_ATTR_ASSN_ACTN_SET

...

.000061035
GROUPER_PIT_ATTR_ASSN_VALUE

...

.02734375
GROUPER_PIT_ATTR_DEF_NAME

...

.002929688
GROUPER_PIT_ATTR_DEF_NAME_SET

...

.002929688
GROUPER_PIT_FIELDS

...

.000061035
GROUPER_PIT_GROUPS

...

.247070313
GROUPER_PIT_GROUP_SET

...

4.87597656
GROUPER_PIT_MEMBERS

...

.33203125
GROUPER_PIT_MEMBERSHIPS

...

5.88476563
GROUPER_PIT_ROLE_SET

...

.000976563
GROUPER_PIT_STEMS

...

.140625
GROUPER_QZ_CRON_TRIGGERS

...

.000061035
GROUPER_QZ_FIRED_TRIGGERS

...

.000061035
GROUPER_QZ_JOB_DETAILS

...

.000061035
GROUPER_QZ_LOCKS

...

.000061035
GROUPER_QZ_SCHEDULER_STATE

...

.000061035
GROUPER_QZ_SIMPROP_TRIGGERS

...

.000061035
GROUPER_QZ_TRIGGERS

...

.000061035
GROUPER_ROLE_SET

...

.000427246
GROUPER_STEMS

...

.1875
GROUPER_STEM_SET

...

.4140625
GROUPER_TABLE_INDEX

...

.000061035
SUBJECT

...

.000061035
SUBJECTATTRIBUTE

...

.000061035




Index disk space usage

...

This is the total disk space used by indexes on each of the Grouper tables.

TableDisk space (GB)
GROUPER_ATTRIBUTE_ASSIGN

...

0.0673828130
GROUPER_ATTRIBUTE_ASSIGN_VALUE

...

0.0095214860
GROUPER_ATTRIBUTE_DEF

...

0.0002441400
GROUPER_ATTRIBUTE_DEF_NAME

...

0.0017700190
GROUPER_ATTRIBUTE_DEF_NAME_SET

...

0.0053100590
GROUPER_ATTRIBUTE_DEF_SCOPE

...

0.0001220700
GROUPER_ATTR_ASSIGN_ACTION

...

0.0001220700
GROUPER_ATTR_ASSIGN_ACTION_SET

...

0.0002441400
GROUPER_AUDIT_ENTRY

...

18.9204101580
GROUPER_AUDIT_TYPE

...

0.0001220700
GROUPER_CHANGE_LOG_CONSUMER

...

0.0001220700
GROUPER_CHANGE_LOG_ENTRY

...

3.2520141610
GROUPER_CHANGE_LOG_ENTRY_TEMP

...

0.1224365250
GROUPER_CHANGE_LOG_TYPE

...

0.0001220700
GROUPER_COMPOSITES

...

0.0028686520
GROUPER_DDL

...

0.0001220700
GROUPER_FIELDS

...

0.0002441400
GROUPER_GROUPS

...

0.6962890630
GROUPER_GROUP_SET

...

11.5604858360
GROUPER_LOADER_LOG

...

0.0254516600
GROUPER_MEMBERS

...

0.8634033210
GROUPER_MEMBERSHIPS

...

24.0016479350
GROUPER_PIT_ATTRIBUTE_ASSIGN

...

0.1552734410
GROUPER_PIT_ATTRIBUTE_DEF

...

0.0004882800
GROUPER_PIT_ATTR_ASSN_ACTN

...

0.0003051750
GROUPER_PIT_ATTR_ASSN_ACTN_SET

...

0.0004272450
GROUPER_PIT_ATTR_ASSN_VALUE

...

0.0469970710
GROUPER_PIT_ATTR_DEF_NAME

...

0.0038452140
GROUPER_PIT_ATTR_DEF_NAME_SET

...

0.0046997070
GROUPER_PIT_FIELDS

...

0.0003662100
GROUPER_PIT_GROUPS

...

0.4638671890
GROUPER_PIT_GROUP_SET

...

14.7217407250
GROUPER_PIT_MEMBERS

...

0.5703735350
GROUPER_PIT_MEMBERSHIPS

...

15.8040161330
GROUPER_PIT_ROLE_SET

...

0.0021972660
GROUPER_PIT_STEMS

...

0.2714843770
GROUPER_QZ_CRON_TRIGGERS

...

0.0000610350
GROUPER_QZ_FIRED_TRIGGERS

...

0.0004272450
GROUPER_QZ_JOB_DETAILS

...

0.0001831050
GROUPER_QZ_LOCKS

...

0.0000610350
GROUPER_QZ_SCHEDULER_STATE

...

0.0000610350
GROUPER_QZ_SIMPROP_TRIGGERS

...

0.0000610350
GROUPER_QZ_TRIGGERS

...

0.0007934550
GROUPER_ROLE_SET

...

0.0010986330
GROUPER_STEMS

...

0.3280029290
GROUPER_STEM_SET

...

0.8203125000
GROUPER_TABLE_INDEX

...

0.0001220700
SUBJECT

...

0.0000610350
SUBJECTATTRIBUTE

...

0.0002441400