.show materialized-view extents

Article
09/10/2024

Applies to: ✅ Azure Data Explorer

Returns the extents in the materialized part of the materialized view. For a definition of the materialized part, see how materialized views work.

If hot is specified, only shows the extents that are expected to be in the hot cache.

This command provides the same details as the show table extents command.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.

Syntax

.show materialized-view MaterializedViewName extents [hot]

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
MaterializedViewName	`string`	✔️	Name of the materialized view.

Returns

Name	Type	Description
ExtentId	`guid`	Globally unique identifier associated to the extent.
DatabaseName	`string`	Database that the extent belongs to.
TableName	`string`	Name of the table or the materialized part of the materialized view that the extent belongs to.
MaxCreatedOn	`datetime`	Date and time when the extent was created. For a merged extent, the maximum of creation times among source extents.
OriginalSize	double	Original size in bytes of the extent data.
ExtentSize	double	Size of the extent in memory (compressed + index).
CompressedSize	double	Compressed size of the extent data in memory.
IndexSize	double	Index size of the extent data.
Blocks	`long`	Number of data blocks in the extent.
Segments	`long`	Number of data segments in the extent.
ReservedSlot1	`string`	For internal use only.
ReservedSlot2	`string`	For internal use only.
ExtentContainerId	`string`	Identifier of the container the extent is stored in.
RowCount	`long`	Number of rows in the extent.
MinCreatedOn	`datetime`	Date and time when the extent was created. For a merged extent, the minimum of creation times among the source extents.
Tags	`string`	Tags, if any, defined for the extent.
Kind	`string`	Kind of the storage engine that created the extent
ReservedSlot3	`string`	For internal use only.
DeletedRowCount	`long`	Number of deleted rows in the extent.

Examples

Show extents from materialized part of one materialized view

The following command shows the extents holding the data in the materialized part of materialized view ViewName, regardless of whether those extents are in hot cache or not:

.show materialized-view ViewName extents

Output

ExtentId	DatabaseName	TableName	MaxCreatedOn	OriginalSize	ExtentSize	CompressedSize	IndexSize	Blocks	Segments	ReservedSlot1	ReservedSlot2	ExtentContainerId	RowCount	MinCreatedOn	Tags	Kind	ReservedSlot3	DeletedRowCount
17a05fa6-9ec4-45f6-991f-28075a09c9f9	MyDatabase	ViewName	2023-03-01T09:37:05.4447625Z	116458	1080900	388865	153527						2876	2023-03-01T09:36:05.4536225Z		StorageV3		0
65ac5fa6-c434-56a6-65bf-07b575d09ff9	MyDatabase	ViewName	2023-03-01T09:48:05.5547625Z	127458	1200900	407865	183539						3000	2023-03-01T09:48:05.5547625Z		StorageV3		0

Show extents in hot cache from materialized part of one materialized view

The following command shows the extents holding the data in the materialized part of materialized view ViewName, but only those which are expected to be in hot cache:

.show materialized-view ViewName extents hot