Skip to content

Instantly share code, notes, and snippets.

@chaintng

chaintng/dist_shard.sql

Last active December 17, 2017 15:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chaintng/e54e620e17c8950c3a121d3f285f87d7 to your computer and use it in GitHub Desktop.
Save chaintng/e54e620e17c8950c3a121d3f285f87d7 to your computer and use it in GitHub Desktop.
Download ZIP
dist_shard.sql
Raw
dist_shard.sql
SELECT * from pg_dist_shard;
logicalrelid | shardid | shardstorage | shardminvalue | shardmaxvalue
---------------+---------+--------------+---------------+---------------
github_events | 102026 | t | 268435456 | 402653183
github_events | 102027 | t | 402653184 | 536870911
github_events | 102028 | t | 536870912 | 671088639
github_events | 102029 | t | 671088640 | 805306367
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment