YugabyteDB 2.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 11.2-YB-2.8.12.0-b0 on x86_64-pc-linux-gnu, compiled by gcc (Homebrew gcc 5.5.0_4) 5.5.0, 64-bit

SELECT 1

-- yb_hash_code() exposes which hash bucket a key lands in (new in 2.8)
create table item (k int primary key, name text);
insert into item values (1,'alpha'),(2,'beta'),(3,'gamma');

CREATE TABLE

INSERT 0 3

select k, name, yb_hash_code(k) as hash_bucket from item order by k;

k
name
hash_bucket

1
alpha
4624

2
beta
49348

3
gamma
64672

SELECT 3