Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SLICE_NUM Function

Returns an integer corresponding to the slice number in the cluster where the data for a row is located. SLICE_NUM takes no parameters.

Syntax

Copy
SLICE_NUM()

Return Type

The SLICE_NUM function returns an integer.

Examples

The following example shows which slices contain data for the first ten EVENT rows in the EVENTS table:

Copy
select distinct eventid, slice_num() from event order by eventid limit 10; eventid | slice_num ---------+----------- 1 | 1 2 | 2 3 | 3 4 | 0 5 | 1 6 | 2 7 | 3 8 | 0 9 | 1 10 | 2 (10 rows)

The following example returns a code (10000) to show that a query without a FROM statement executes on the leader node:

Copy
select slice_num(); slice_num ----------- 10000 (1 row)

On this page: