58.2. Snapshots #
58.2.1. Taking a Snapshot #
Before performing this instruction:
To take a snapshot:
Go to snapshots in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Snapshots.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Snapshots.
In the top-right corner of the page, click Take snapshot.
Specify parameters of the new snapshot (parameters marked with an asterisk are required):
Database: The database for which the snapshot will be taken.
Server: The profiler server whose directory will be used to store the snapshot.
skip_sizes: Specifies whether to skip the collection of relation sizes when taking the snapshot.
Possible values:
true: The collection of relation sizes will be skipped when taking the snapshot.
false: The collection of relation sizes will not be skipped when taking the snapshot.
Click Save.
58.2.2. Viewing Snaphots #
Go to snapshots in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Snapshots.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Snapshots.
From Database, select the database.
From Server, select the profiler server.
Click Select.
The table of snapshots with the following columns will be displayed:
ID: The unique identifier (ordinal number) of the snapshot.
Time: The date and time when the snapshot was created.
Sizes were collected: Specifies whether relation sizes were collected when taking the snapshot.
Possible values:
yes
no
Database stat reset: Specifies whether database statistics were reset when taking the snapshot.
Possible values:
yes
no
Bgwriter stat reset: Specifies whether
bgwriterstatistics were reset.Possible values:
yes
no
Archiver stat reset: Specifies whether archiver statistics were reset.
Possible values:
yes
no