geunho · May 23, 2022 01:43
diff --git a/citus_shard_to_node_map.sql b/citus_shard_to_node_map.sql
 SELECT s.shardid id, shardminvalue min, shardmaxvalue MAX, p.nodename 
 FROM pg_dist_shard s 
 LEFT JOIN pg_dist_shard_placement p 
  ON s.shardid = p.shardid 
 WHERE logicalrelid = $TABLE_NAME::regclass;
	SELECT s.shardid id, shardminvalue min, shardmaxvalue MAX, p.nodename
	FROM pg_dist_shard s
	LEFT JOIN pg_dist_shard_placement p
	ON s.shardid = p.shardid
	WHERE logicalrelid = $TABLE_NAME::regclass;